# HG changeset patch
# User Matti Hamalainen <ccr@tnsp.org>
# Date 1382011280 -10800
# Node ID 63a6caf59e5c7a7e09f0815c339070b8219c200d
# Parent  d74fb8cf006273767702fd10f185e534346bd08e
Fix creation of boolean settings, and add '%b' formatter into stPrepareSQL().

diff -r d74fb8cf0062 -r 63a6caf59e5c createdb.php
--- a/createdb.php	Fri Oct 11 09:33:16 2013 +0300
+++ b/createdb.php	Thu Oct 17 15:01:20 2013 +0300
@@ -215,7 +215,7 @@
     {
       case VT_TEXT: $type = "%s"; $var = "vtext"; break;
       case VT_STR:  $type = "%s"; $var = "vstr"; break;
-      case VT_BOOL: $type = "%B"; $var = "vint"; break;
+      case VT_BOOL: $type = "%b"; $var = "vint"; break;
       case VT_INT:  $type = "%d"; $var = "vint"; break;
     }
 
diff -r d74fb8cf0062 -r 63a6caf59e5c msite.inc.php
--- a/msite.inc.php	Fri Oct 11 09:33:16 2013 +0300
+++ b/msite.inc.php	Thu Oct 17 15:01:20 2013 +0300
@@ -268,6 +268,9 @@
     case "s":
       return $db->quote($value);
 
+    case "b":
+      return intval($value) ? 1 : 0;
+
     case "D":
       return intval(stGetRequestItem($value));