20 $sql = "INSERT INTO `profile_styles` SET "; |
20 $sql = "INSERT INTO `profile_styles` SET "; |
21 } |
21 } |
22 if (isset($_POST['update'])) { |
22 if (isset($_POST['update'])) { |
23 $sql = "UPDATE `profile_styles` SET "; |
23 $sql = "UPDATE `profile_styles` SET "; |
24 } |
24 } |
25 |
25 if (isset($_POST['uuid']) && (strlen($_POST['uuid']) == 36)) { |
26 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); |
26 $sql .= "uuid='" . $_POST['uuid']; |
|
27 } else { |
|
28 $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); |
|
29 $sql .= "uuid='" . $uuid; |
|
30 } |
|
31 $sql .= "', name='" . mysqli_real_escape_string($connect, $_POST['name']); |
27 $sql .= "', category='" . mysqli_real_escape_string($connect, $_POST['category']); |
32 $sql .= "', category='" . mysqli_real_escape_string($connect, $_POST['category']); |
28 $sql .= "', category_number='" . $_POST['category_number']; |
33 $sql .= "', category_number='" . $_POST['category_number']; |
29 $sql .= "', style_letter='" . mysqli_real_escape_string($connect, $_POST['style_letter']); |
34 $sql .= "', style_letter='" . mysqli_real_escape_string($connect, $_POST['style_letter']); |
30 $sql .= "', style_guide='" . mysqli_real_escape_string($connect, $_POST['style_guide']); |
35 $sql .= "', style_guide='" . mysqli_real_escape_string($connect, $_POST['style_guide']); |
31 $sql .= "', type='" . $_POST['type']; |
36 $sql .= "', type='" . $_POST['type']; |
75 $query = "SELECT * FROM profile_styles ORDER BY style_guide,style_letter,name"; |
80 $query = "SELECT * FROM profile_styles ORDER BY style_guide,style_letter,name"; |
76 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
81 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
77 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
82 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
78 $styles[] = array( |
83 $styles[] = array( |
79 'record' => $row['record'], |
84 'record' => $row['record'], |
|
85 'uuid' => $row['uuid'], |
80 'name' => $row['name'], |
86 'name' => $row['name'], |
81 'category' => $row['category'], |
87 'category' => $row['category'], |
82 'category_number' => $row['category_number'], |
88 'category_number' => $row['category_number'], |
83 'style_letter' => $row['style_letter'], |
89 'style_letter' => $row['style_letter'], |
84 'style_guide' => $row['style_guide'], |
90 'style_guide' => $row['style_guide'], |