@@ -294,7 +294,7 @@ discard block |
||
294 | 294 | |
295 | 295 | if (mysqli_num_rows($rs)) { |
296 | 296 | $installDataLevel['templates'][$moduleTemplate[0]]['type'] = 'update'; |
297 | - $query = "UPDATE $dbase.`" . $table_prefix . "site_templates` SET content='$template', description='$desc', category=$category_id, locked='$locked' WHERE templatename='$name' LIMIT 1;"; |
|
297 | + $query = "update $dbase.`" . $table_prefix . "site_templates` SET content='$template', description='$desc', category=$category_id, locked='$locked' WHERE templatename='$name' LIMIT 1;"; |
|
298 | 298 | if (!mysqli_query($sqlParser->conn, $query)) { |
299 | 299 | $errors += 1; |
300 | 300 | $installDataLevel['templates'][$moduleTemplate[0]]['error'] = array( |
@@ -385,7 +385,7 @@ discard block |
||
385 | 385 | if (mysqli_num_rows($rs)) { |
386 | 386 | $installDataLevel['tvs'][$moduleTV[0]]['type'] = 'update'; |
387 | 387 | while ($row = mysqli_fetch_assoc($rs)) { |
388 | - $query = "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']};"; |
|
388 | + $query = "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']};"; |
|
389 | 389 | if (!mysqli_query($sqlParser->conn, $query)) { |
390 | 390 | $installDataLevel['tvs'][$moduleTV[0]]['error'] = array( |
391 | 391 | 'type' => 'sql', |
@@ -496,7 +496,7 @@ discard block |
||
496 | 496 | if ($update) { |
497 | 497 | $installDataLevel['chunks'][$moduleChunk[0]]['type'] = 'update'; |
498 | 498 | if (!mysqli_query($sqlParser->conn, |
499 | - "UPDATE $dbase.`" . $table_prefix . "site_htmlsnippets` SET snippet='$chunk', description='$desc', category=$category_id WHERE name='$name';")) { |
|
499 | + "update $dbase.`" . $table_prefix . "site_htmlsnippets` SET snippet='$chunk', description='$desc', category=$category_id WHERE name='$name';")) { |
|
500 | 500 | $errors += 1; |
501 | 501 | $installDataLevel['chunks'][$moduleChunk[0]]['error'] = array( |
502 | 502 | 'type' => 'sql', |
@@ -581,7 +581,7 @@ discard block |
||
581 | 581 | $row = mysqli_fetch_assoc($rs); |
582 | 582 | $props = mysqli_real_escape_string($conn, propUpdate($properties, $row['properties'])); |
583 | 583 | if (!mysqli_query($sqlParser->conn, |
584 | - "UPDATE $dbase.`" . $table_prefix . "site_modules` SET modulecode='$module', description='$desc', properties='$props', enable_sharedparams='$shared' WHERE name='$name';")) { |
|
584 | + "update $dbase.`" . $table_prefix . "site_modules` SET modulecode='$module', description='$desc', properties='$props', enable_sharedparams='$shared' WHERE name='$name';")) { |
|
585 | 585 | $installDataLevel['modules'][$moduleModule[0]]['error'] = array( |
586 | 586 | 'type' => 'sql', |
587 | 587 | 'content' => mysqli_error($sqlParser->conn) |
@@ -660,7 +660,7 @@ discard block |
||
660 | 660 | |
661 | 661 | // disable legacy versions based on legacy_names provided |
662 | 662 | if (!empty($leg_names)) { |
663 | - $update_query = "UPDATE $dbase.`" . $table_prefix . "site_plugins` SET disabled='1' WHERE name IN ($leg_names);"; |
|
663 | + $update_query = "update $dbase.`" . $table_prefix . "site_plugins` SET disabled='1' WHERE name IN ($leg_names);"; |
|
664 | 664 | $rs = mysqli_query($sqlParser->conn, $update_query); |
665 | 665 | } |
666 | 666 | |
@@ -678,7 +678,7 @@ discard block |
||
678 | 678 | while ($row = mysqli_fetch_assoc($rs)) { |
679 | 679 | $props = mysqli_real_escape_string($conn, propUpdate($properties, $row['properties'])); |
680 | 680 | if ($row['description'] == $desc) { |
681 | - $query = "UPDATE $dbase.`" . $table_prefix . "site_plugins` SET plugincode='$plugin', description='$desc', properties='$props' WHERE id={$row['id']};"; |
|
681 | + $query = "update $dbase.`" . $table_prefix . "site_plugins` SET plugincode='$plugin', description='$desc', properties='$props' WHERE id={$row['id']};"; |
|
682 | 682 | if (!mysqli_query($sqlParser->conn, $query)) { |
683 | 683 | $installDataLevel['plugins'][$modulePlugin[0]]['error'] = array( |
684 | 684 | 'type' => 'sql', |
@@ -689,7 +689,7 @@ discard block |
||
689 | 689 | } |
690 | 690 | $insert = false; |
691 | 691 | } else { |
692 | - $query = "UPDATE $dbase.`" . $table_prefix . "site_plugins` SET disabled='1' WHERE id={$row['id']};"; |
|
692 | + $query = "update $dbase.`" . $table_prefix . "site_plugins` SET disabled='1' WHERE id={$row['id']};"; |
|
693 | 693 | if (!mysqli_query($sqlParser->conn, $query)) { |
694 | 694 | $installDataLevel['plugins'][$modulePlugin[0]]['error'] = array( |
695 | 695 | 'type' => 'sql', |
@@ -792,7 +792,7 @@ discard block |
||
792 | 792 | $row = mysqli_fetch_assoc($rs); |
793 | 793 | $props = mysqli_real_escape_string($conn, propUpdate($properties, $row['properties'])); |
794 | 794 | if (!mysqli_query($sqlParser->conn, |
795 | - "UPDATE $dbase.`" . $table_prefix . "site_snippets` SET snippet='$snippet', description='$desc', properties='$props' WHERE name='$name';")) { |
|
795 | + "update $dbase.`" . $table_prefix . "site_snippets` SET snippet='$snippet', description='$desc', properties='$props' WHERE name='$name';")) { |
|
796 | 796 | $installDataLevel['snippets'][$moduleSnippet[0]]['error'] = array( |
797 | 797 | 'type' => 'sql', |
798 | 798 | 'content' => mysqli_error($sqlParser->conn) |