Advertisement
Guest User

Untitled

a guest
Sep 15th, 2017
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.28 KB | None | 0 0
  1. <?php
  2.     // Data for mysql connection
  3.     $mysql_host = "";  // Host
  4.     $mysql_user = "";        // User Name
  5.     $mysql_pass = ""; // Password
  6.     $mysql_db   = "";  // DB Name
  7.  
  8.     $ip = getenv("REMOTE_ADDR");
  9.     $date = date("d.m.Y H:i:s");
  10.  
  11.     $filename = "./reports/".md5($ip.$date).".ini";
  12.  
  13.     copy($_FILES['data']['tmp_name'], $filename);
  14.  
  15.     $mysql = mysql_connect($mysql_host, $mysql_user, $mysql_pass);
  16.     mysql_select_db($mysql_db, $mysql);
  17.    
  18.     $file = fopen($filename, "r");
  19.  
  20.     while (!feof($file))
  21.     {
  22.         $buffer = fgets($file, 1024);
  23.  
  24.         $buffer = str_replace(array("'",'"','<','>','`','*'), "", $buffer);
  25.  
  26.         list($type, $devid, $name) = explode(":", $buffer);
  27.        
  28.         $devid = strtolower($devid);
  29.  
  30.         if (strcmp($type, "MON") == 0)
  31.             $table = "mon_devices_db";
  32.         else if (strcmp($type, "USB") == 0)
  33.             $table = "usb_devices_db";
  34.         else if (strcmp($type, "PCI") == 0)
  35.             $table = "pci_devices_db";
  36.         else continue;
  37.  
  38.         $query = "SELECT * FROM ".$table." WHERE devid='".$devid."'";
  39.         $result = mysql_query($query, $mysql);
  40.         $count = mysql_num_rows($result, $mysql);
  41.         if ($count > 0) continue;
  42.  
  43.         $query = "INSERT INTO ".$table." (devid, name) VALUES('".$devid."', '".$name."')";
  44.         mysql_query($query, $mysql);
  45.     }
  46.  
  47.     fclose($file);
  48.     mysql_close($mysql);
  49.  
  50.     //unlink($filename);
  51. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement