| Server IP : 182.53.201.61 / Your IP : 216.73.217.175 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/doc/smolt-1.4/ |
Upload File : |
# Converts mysql hex fileds for vendorid to device and vendor ints:
# echo "select id, device_id from device" | mysql -u root smolt | sed 's/\:/ /g' | sed 's/0x//g' | awk -f vendorhexint.awk | sed 's/\=0/=""/g' > mysql
{
printf "update device set vendor_id=%i, device_id=%i where id=%i;\n", $3, $2, $1
}