From 22bbfe0e2e0ddb0ccaafe888446f2f59a9ab4e2f Mon Sep 17 00:00:00 2001
From: Yuchen Pei <hi@ypei.me>
Date: Thu, 14 Oct 2021 14:54:03 +1100
Subject: Removing scripts subdir

---
 scripts/vendorid/insert_vendors.php | 124 ------------------------------------
 1 file changed, 124 deletions(-)
 delete mode 100644 scripts/vendorid/insert_vendors.php

(limited to 'scripts/vendorid/insert_vendors.php')

diff --git a/scripts/vendorid/insert_vendors.php b/scripts/vendorid/insert_vendors.php
deleted file mode 100644
index 630a88d..0000000
--- a/scripts/vendorid/insert_vendors.php
+++ /dev/null
@@ -1,124 +0,0 @@
-#! /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);
-- 
cgit v1.2.3