www/includes/db_recipes.php

changeset 168
ce92dc75cb09
parent 166
635033a29c48
child 220
14e349ff2a10
equal deleted inserted replaced
167:dabcd35f8f92 168:ce92dc75cb09
30 $sql .= "uuid='" . $_POST['uuid']; 30 $sql .= "uuid='" . $_POST['uuid'];
31 } else { 31 } else {
32 $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); 32 $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid'));
33 $sql .= "uuid='" . $uuid; 33 $sql .= "uuid='" . $uuid;
34 } 34 }
35 ($_POST['locked'] == 'true') ? $sql .= "', locked='1" : $sql .= "', locked='0";
35 $sql .= "', st_name='" . mysqli_real_escape_string($connect, $_POST['st_name']); 36 $sql .= "', st_name='" . mysqli_real_escape_string($connect, $_POST['st_name']);
36 $sql .= "', st_letter='" . mysqli_real_escape_string($connect, $_POST['st_letter']); 37 $sql .= "', st_letter='" . mysqli_real_escape_string($connect, $_POST['st_letter']);
37 $sql .= "', st_guide='" . mysqli_real_escape_string($connect, $_POST['st_guide']); 38 $sql .= "', st_guide='" . mysqli_real_escape_string($connect, $_POST['st_guide']);
38 $sql .= "', st_type='" . mysqli_real_escape_string($connect, $_POST['st_type']); 39 $sql .= "', st_type='" . mysqli_real_escape_string($connect, $_POST['st_type']);
39 $sql .= "', st_category='" . mysqli_real_escape_string($connect, $_POST['st_category']); 40 $sql .= "', st_category='" . mysqli_real_escape_string($connect, $_POST['st_category']);
204 if ($comma) { 205 if ($comma) {
205 $recipes .= ','; 206 $recipes .= ',';
206 } 207 }
207 $comma = TRUE; 208 $comma = TRUE;
208 $recipes .= '{"record":' . $row['record']; 209 $recipes .= '{"record":' . $row['record'];
210 $recipes .= ',"uuid":"' . $row['uuid'];
211 $recipes .= '","locked":' . $row['locked'];
209 $recipes .= ',"st_guide":"' . str_replace($escapers, $replacements, $row['st_guide']); 212 $recipes .= ',"st_guide":"' . str_replace($escapers, $replacements, $row['st_guide']);
210 $recipes .= '","st_letter":"' . str_replace($escapers, $replacements, $row['st_letter']); 213 $recipes .= '","st_letter":"' . str_replace($escapers, $replacements, $row['st_letter']);
211 $recipes .= '","st_name":"' . str_replace($escapers, $replacements, $row['st_name']); 214 $recipes .= '","st_name":"' . str_replace($escapers, $replacements, $row['st_name']);
212 $recipes .= '","st_type":"' . str_replace($escapers, $replacements, $row['st_type']); 215 $recipes .= '","st_type":"' . str_replace($escapers, $replacements, $row['st_type']);
213 $recipes .= '","st_category":"' . str_replace($escapers, $replacements, $row['st_category']); 216 $recipes .= '","st_category":"' . str_replace($escapers, $replacements, $row['st_category']);

mercurial