// php

// Files:
// NSRLFile
// NSRLMfg
// NSRLOS
// NSRLProd

// File DB Parameters:
$db = "database";
$dbhost = "localhost";
$dbuser = "username";
$dbpass = "password";

// Functions
function add_slashes ($oldarray) { 
  foreach ($oldarray as $key => $value) { 
    $newarray[$key] = addslashes($oldarray[$key]); 
  } 
  return $newarray;
}

// Setup DB Connection
$dblink = mysql_connect($dbhost,  $dbuser,  $dbpass) or die(mysql_error());;
mysql_select_db($db, $dblink) or die(mysql_error());

// read version file
mysql_query("DELETE FROM version") or die(mysql_error());
$handle = fopen("version.txt", "r");
fgetcsv($handle, 1000, ","); 
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    $data = add_slashes($data);
    mysql_query("INSERT INTO version (SHA1, RDSVersion) VALUES ('$data[0]', '$data[1]')") or die(mysql_error());
}
fclose($handle);

// read NSRLFile file
//mysql_query("DELETE FROM NSRLFile") or die(mysql_error());
$handle = fopen("NSRLFile.txt", "r");
fgetcsv($handle, 1000, ",");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    $data = add_slashes($data);
    mysql_query("INSERT INTO NSRLFile (SHA1, MD5, CRC32, FileName, FileSize, ProductCode, OpSystemCode, SpecialCode) VALUES ('$data[0]', '$data[1]', '$data[2]', '$data[3]', '$data[4]', '$data[5]', '$data[6]', '$data[7]')") or die(mysql_error());

}
fclose($handle);

// read NSRLMfg file
mysql_query("DELETE FROM NSRLMfg") or die(mysql_error());
$handle = fopen("NSRLMfg.txt", "r");
fgetcsv($handle, 1000, ",");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    $data = add_slashes($data);
    mysql_query("INSERT INTO NSRLMfg (MfgCode, MfgName) VALUES ('$data[0]', '$data[1]')") or die(mysql_error());
}
fclose($handle);

// read NSRLProd file
mysql_query("DELETE FROM NSRLProd") or die(mysql_error());
$handle = fopen("NSRLProd.txt", "r");
fgetcsv($handle, 1000, ",");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    $data = add_slashes($data);
    mysql_query("INSERT INTO NSRLProd (ProductCode, ProductName, ProductVersion, OpSystemCode, MfgCode, Language, ApplicationType) VALUES ('$data[0]', '$data[1]', '$data[2]', '$data[3]', '$data[4]', '$data[5]', '$data[6]')") or die(mysql_error());
}
fclose($handle);

// read NSRLOS file
mysql_query("DELETE FROM NSRLOS") or die(mysql_error());
$handle = fopen("NSRLOS.txt", "r");
fgetcsv($handle, 1000, ",");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
   $data = add_slashes($data);
    mysql_query("INSERT INTO NSRLOS (OpSystemCode, OpSystemName, OpSystemVersion, MfgCode) VALUES ('$data[0]', '$data[1]', '$data[2]', '$data[3]')") or die(mysql_error());
}
fclose($handle);

?>