|
@@ -294,7 +294,7 @@ discard block |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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) |