Mercurial > hg > fapweb

changeset 354:1dd598221874

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Simplify code by reusing functions from site module.
author Matti Hamalainen <ccr@tnsp.org>
date Mon, 02 Dec 2013 11:23:08 +0200
parents d805f6f2a83d
children 4ced04d29858
files msite.inc.php
diffstat 1 files changed, 4 insertions(+), 20 deletions(-) [+]
line wrap: on
line diff
--- a/msite.inc.php	Mon Dec 02 07:20:21 2013 +0200
+++ b/msite.inc.php	Mon Dec 02 11:23:08 2013 +0200
@@ -66,16 +66,7 @@
   if (($res = stExecSQL("SELECT * FROM displayVars")) !== FALSE)
   {
     foreach ($res as $row)
-    {
-      switch ($row["vtype"])
-      {
-        case VT_INT:  $val = intval($row["vint"]); break;
-        case VT_BOOL: $val = intval($row["vint"]) ? true : false; break;
-        case VT_STR:  $val = $row["vstr"]; break;
-        case VT_TEXT: $val = $row["vtext"]; break;
-      }
-      $displayVars[$row["key"]] = $val;
-    }
+      $displayVars[$row["key"]] = stGetSQLSettingData($row);
   }
 }
 
@@ -88,16 +79,9 @@
   if (isset($displayVarsChanged[$item["key"]]))
   {
     $val = $displayVars[$item["key"]];
-    switch ($item["vtype"])
-    {
-      case VT_INT:  $vsql = stPrepareSQL("vint=%d", $val); break;
-      case VT_BOOL: $vsql = stPrepareSQL("vint=%d", $val ? 1 : 0); break;
-      case VT_STR:  $vsql = stPrepareSQL("vstr=%s", $val); break;
-      case VT_TEXT: $vsql = stPrepareSQL("vtext=%s", $val); break;
-    }
-
-    $sql = "UPDATE displayVars SET ".$vsql." WHERE key=".$db->quote($item["key"]);
-    stExecSQL($sql);
+    stExecSQL(
+      "UPDATE displayVars SET ".stGetSettingSQL($item, $val).
+      " WHERE key=".$db->quote($item["key"]));
   }
 }