From 18aa21f2aadf1d5bfbf1d28bd5f32643ab3fbab1 Mon Sep 17 00:00:00 2001 From: Antonio Gallo Date: Tue, 17 Apr 2012 21:02:56 +0000 Subject: added usb.ids --- scripts/vendorid/insert_vendors.php | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'scripts/vendorid/insert_vendors.php') diff --git a/scripts/vendorid/insert_vendors.php b/scripts/vendorid/insert_vendors.php index 14f2235..27b8307 100644 --- a/scripts/vendorid/insert_vendors.php +++ b/scripts/vendorid/insert_vendors.php @@ -7,6 +7,7 @@ include("connect.php"); include("functions.php"); +//insert the PCI vendors $ids_fp = fopen('pci.ids', 'r'); while (($line = fgets($ids_fp)) !== false) { @@ -21,4 +22,21 @@ while (($line = fgets($ids_fp)) !== false) { } } +fclose($ids_fp); + +//insert the USB vendors +$ids_fp = fopen('usb.ids', 'r'); + +while (($line = fgets($ids_fp)) !== false) { + if (preg_match('/^([0-9a-f]{4})\s+(.*)\s*$/', + $line, $matches) == 1) { + $vendorid = $matches[1]; + $full_name = sanitizeDb(decode_soft($matches[2])); + $clean_name = sanitizeDb(decode($matches[2])); +// echo "$vendorid $full_name $clean_name".PHP_EOL; + $query = "INSERT INTO vendors (bus,vendorid,clean_name,full_name) VALUES ('usb','$vendorid','$clean_name','$full_name');"; + DB::$instance->query($query); + } +} + fclose($ids_fp); \ No newline at end of file -- cgit v1.2.3