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"; |