Mercurial > hg > fapweb
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"])); } }