comparison: www/includes/db_inventory_miscs.php
www/includes/db_inventory_miscs.php
- changeset 785
- aa79acfdf8a9
- parent 767
- 08c0343b622b
equal
deleted
inserted
replaced
| 784:d51b05838ac4 | 785:aa79acfdf8a9 |
|---|---|
| 22 } | 22 } |
| 23 if (isset($_POST['update'])) { | 23 if (isset($_POST['update'])) { |
| 24 $sql = "UPDATE `inventory_miscs` SET "; | 24 $sql = "UPDATE `inventory_miscs` SET "; |
| 25 } | 25 } |
| 26 | 26 |
| 27 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); | 27 if (isset($_POST['uuid']) && (strlen($_POST['uuid']) == 36)) { |
| 28 $sql .= "uuid='" . $_POST['uuid']; | |
| 29 } else { | |
| 30 $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); | |
| 31 $sql .= "uuid='" . $uuid; | |
| 32 } | |
| 33 $sql .= "', name='" . mysqli_real_escape_string($connect, $_POST['name']); | |
| 28 $sql .= "', type='" . array_search($_POST['type'], $misctype); | 34 $sql .= "', type='" . array_search($_POST['type'], $misctype); |
| 29 $sql .= "', use_use='" . array_search($_POST['use_use'], $miscuse); | 35 $sql .= "', use_use='" . array_search($_POST['use_use'], $miscuse); |
| 30 $sql .= "', time='" . $_POST['time']; | 36 $sql .= "', time='" . $_POST['time']; |
| 31 ($_POST['amount_is_weight'] == 'true') ? $sql .= "', amount_is_weight='1" : $sql .= "', amount_is_weight='0"; | 37 ($_POST['amount_is_weight'] == 'true') ? $sql .= "', amount_is_weight='1" : $sql .= "', amount_is_weight='0"; |
| 32 $sql .= "', use_for='" . mysqli_real_escape_string($connect, $_POST['use_for']); | 38 $sql .= "', use_for='" . mysqli_real_escape_string($connect, $_POST['use_for']); |
| 74 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | 80 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
| 75 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | 81 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 76 $miscs[] = array( | 82 $miscs[] = array( |
| 77 'record' => $row['record'], | 83 'record' => $row['record'], |
| 78 'name' => $row['name'], | 84 'name' => $row['name'], |
| 85 'uuid' => $row['uuid'], | |
| 79 'type' => $misctype[$row['type']], | 86 'type' => $misctype[$row['type']], |
| 80 'use_use' => $miscuse[$row['use_use']], | 87 'use_use' => $miscuse[$row['use_use']], |
| 81 'time' => $row['time'], | 88 'time' => $row['time'], |
| 82 'amount_is_weight' => $row['amount_is_weight'], | 89 'amount_is_weight' => $row['amount_is_weight'], |
| 83 'use_for' => $row['use_for'], | 90 'use_for' => $row['use_for'], |
