www/upl_miscs.php

changeset 785
aa79acfdf8a9
parent 311
f6fafccd8a6d
equal deleted inserted replaced
784:d51b05838ac4 785:aa79acfdf8a9
49 $imported = 0; 49 $imported = 0;
50 $miscs = simplexml_load_file($target_file); 50 $miscs = simplexml_load_file($target_file);
51 51
52 foreach ($miscs->MISC as $misc) { 52 foreach ($miscs->MISC as $misc) {
53 53
54 $sql = "INSERT INTO inventory_miscs SET name='" . mysqli_real_escape_string($db, $misc->NAME); 54 $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid'));
55 $sql = "INSERT INTO inventory_miscs SET uuid='" . $uuid;
56 $sql .= "', name='" . mysqli_real_escape_string($db, $misc->NAME);
55 if ($misc->NOTES) 57 if ($misc->NOTES)
56 $sql .= "', notes='" . mysqli_real_escape_string($db, $misc->NOTES); 58 $sql .= "', notes='" . mysqli_real_escape_string($db, $misc->NOTES);
57 59
58 if ($misc->TYPE == 'Spice') 60 if ($misc->TYPE == 'Spice')
59 $sql .= "', type='0"; 61 $sql .= "', type='0";

mercurial