evolution-cms /
evolution
| @@ 1100-1106 (lines=7) @@ | ||
| 1097 | $rs = mysqli_query($sqlParser->conn, "SELECT * FROM $dbase.`" . $table_prefix . "site_tmplvars` WHERE name='$name'"); |
|
| 1098 | if (mysqli_num_rows($rs)) { |
|
| 1099 | $insert = true; |
|
| 1100 | while($row = mysqli_fetch_assoc($rs)) { |
|
| 1101 | if (!mysqli_query($sqlParser->conn, "UPDATE $dbase.`" . $table_prefix . "site_tmplvars` SET type='$input_type', caption='$caption', description='$desc', category=$category, locked=$locked, elements='$input_options', display='$output_widget', display_params='$output_widget_params', default_text='$input_default' WHERE id={$row['id']};")) { |
|
| 1102 | echo mysqli_error($sqlParser->conn) . PHP_EOL; |
|
| 1103 | return; |
|
| 1104 | } |
|
| 1105 | $insert = false; |
|
| 1106 | } |
|
| 1107 | echo " $name: " . $_lang['upgraded'] . PHP_EOL; |
|
| 1108 | } else { |
|
| 1109 | $q = "INSERT INTO $dbase.`" . $table_prefix . "site_tmplvars` (type,name,caption,description,category,locked,elements,display,display_params,default_text) VALUES('$input_type','$name','$caption','$desc',$category,$locked,'$input_options','$output_widget','$output_widget_params','$input_default');"; |
|
| @@ 390-396 (lines=7) @@ | ||
| 387 | $rs = mysqli_query($sqlParser->conn, "SELECT * FROM $dbase.`" . $table_prefix . "site_tmplvars` WHERE name='$name'"); |
|
| 388 | if (mysqli_num_rows($rs)) { |
|
| 389 | $insert = true; |
|
| 390 | while($row = mysqli_fetch_assoc($rs)) { |
|
| 391 | if (!mysqli_query($sqlParser->conn, "UPDATE $dbase.`" . $table_prefix . "site_tmplvars` SET type='$input_type', caption='$caption', description='$desc', category=$category, locked=$locked, elements='$input_options', display='$output_widget', display_params='$output_widget_params', default_text='$input_default' WHERE id={$row['id']};")) { |
|
| 392 | echo "<p>" . mysqli_error($sqlParser->conn) . "</p>"; |
|
| 393 | return; |
|
| 394 | } |
|
| 395 | $insert = false; |
|
| 396 | } |
|
| 397 | echo "<p> $name: <span class=\"ok\">" . $_lang['upgraded'] . "</span></p>"; |
|
| 398 | } else { |
|
| 399 | //$q = "INSERT INTO $dbase.`" . $table_prefix . "site_tmplvars` (type,name,caption,description,category,locked,elements,display,display_params,default_text) VALUES('$input_type','$name','$caption','$desc',(SELECT (CASE COUNT(*) WHEN 0 THEN 0 ELSE `id` END) `id` FROM $dbase.`" . $table_prefix . "categories` WHERE `category` = '$category'),$locked,'$input_options','$output_widget','$output_widget_params','$input_default');"; |
|
