1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
#! /usr/bin/php
<?php
//created by Antonio Gallo (tonicucoz@yahoo.com) and P. J. McDermott
//Additional changes by Ian Gilfillan
// this script is in the Public Domain
//Accepts on argument, either -v or -s
//-v for verbose, which shows all the inserts/updates that are being made
//-s for safe, which shows all the inserts/updates to be made without actually making them
if (isset($argv[1])) {
if ($argv[1]=='-v') {
$verbose=1;
$change=1;
}
elseif ($argv[1]=='-s'){
$change=0;
$verbose=1;
}
}
else {
$verbose=0;
$change=1;
}
include("connect.php");
include("functions.php");
//insert the PCI vendors
$ids_fp = fopen('pci.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]));
// Check if record exists, insert if not
$query = "SELECT vendorid, clean_name FROM vendors WHERE vendorid='$vendorid' AND bus='PCI'";
if ($result = DB::$instance->query($query)) {
$found = $result->num_rows;
}
if ($found == 0) {
//insert
$query = "INSERT INTO vendors (bus,vendorid,clean_name,full_name) VALUES ('PCI','$vendorid','$clean_name','$full_name');";
if ($verbose) {
echo "\n Adding record: PCI $vendorid $clean_name $full_name";
}
if ($change) {
DB::$instance->query($query);
}
}
// Check if record has changed, update if so
$query = "SELECT vendorid, clean_name, full_name FROM vendors WHERE vendorid='$vendorid' AND (BINARY clean_name!='$clean_name' OR BINARY full_name!='$full_name') AND bus='PCI'";
if ($result = DB::$instance->query($query)) {
$found = $result->num_rows;
}
if ($found > 0) {
$row = $result->fetch_assoc();
//update
$query = "UPDATE vendors SET clean_name='$clean_name', full_name='$full_name' WHERE vendorid='$vendorid' AND bus='PCI';";
if ($verbose) {
echo "\n Updating record - old value: PCI " . $row['clean_name'] . " " . $row['full_name'];
echo "\n Updating record - new value: PCI $clean_name $full_name";
}
if ($change) {
DB::$instance->query($query);
}
}
}
}
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]));
$query = "SELECT vendorid FROM vendors WHERE vendorid='$vendorid' AND bus='USB'";
if ($result = DB::$instance->query($query)) {
$found = $result->num_rows;
}
if ($found == 0) {
//insert
$query = "INSERT INTO vendors (bus,vendorid,clean_name,full_name) VALUES ('USB','$vendorid','$clean_name','$full_name');";
if ($verbose) {
echo "\n Adding record: USB $vendorid $clean_name $full_name";
}
if ($change) {
DB::$instance->query($query);
}
}
// Check if record has changed, update if so
$query = "SELECT vendorid, clean_name, full_name FROM vendors WHERE vendorid='$vendorid' AND (BINARY clean_name!='$clean_name' OR BINARY full_name!='$full_name') AND bus='USB'";
if ($result = DB::$instance->query($query)) {
$found = $result->num_rows;
}
if ($found >0) {
$row = $result->fetch_assoc();
$query = "UPDATE vendors SET clean_name='$clean_name', full_name='$full_name' WHERE vendorid='$vendorid' AND bus='USB';";
if ($verbose) {
echo "\n Updating record - old value: USB " . $row['clean_name'] . " " . $row['full_name'];
echo "\n Updating record - new value: USB $clean_name $full_name";
}
if ($change) {
DB::$instance->query($query);
}
}
}
}
fclose($ids_fp);
|
