diff msite.inc.php @ 542:8c1a53532be0

Rename various database tables and column names for better SQL compatibility.
author Matti Hamalainen <ccr@tnsp.org>
date Sun, 15 Dec 2013 23:48:14 +0200
parents 88c048f3b9e1
children 2de6e0ecb3fa
line wrap: on
line diff
--- a/msite.inc.php	Sun Dec 15 23:46:41 2013 +0200
+++ b/msite.inc.php	Sun Dec 15 23:48:14 2013 +0200
@@ -106,7 +106,7 @@
   $displayVars = array();
   $displayVarsChanged = array();
 
-  if (($res = stExecSQL("SELECT * FROM displayVars")) !== FALSE)
+  if (($res = stExecSQL("SELECT * FROM display_vars")) !== FALSE)
   {
     foreach ($res as $row)
       $displayVars[$row["key"]] = stGetSQLSettingData($row);
@@ -118,12 +118,12 @@
 {
   global $db, $displayVars, $displayVarsChanged;
 
-  foreach (stExecSQL("SELECT * FROM displayVars") as $item)
+  foreach (stExecSQL("SELECT * FROM display_vars") as $item)
   if (isset($displayVarsChanged[$item["key"]]))
   {
     $val = $displayVars[$item["key"]];
     stExecSQL(
-      "UPDATE displayVars SET ".stGetSettingSQL($item, $val).
+      "UPDATE display_vars SET ".stGetSettingSQL($item, $val).
       " WHERE key=".$db->quote($item["key"]));
   }
 }