# HG changeset patch
# User Matti Hamalainen <ccr@tnsp.org>
# Date 1557999828 -10800
# Node ID b3c1c5969a0b73cd07a2c0da41bbf021396c049b
# Parent  0b0094db56da467e83e5c3784dfd4c2dbb20d07f
Add new helper function stDBPrepareSQL_V().

diff -r 0b0094db56da -r b3c1c5969a0b msitegen.inc.php
--- a/msitegen.inc.php	Thu May 16 12:42:24 2019 +0300
+++ b/msitegen.inc.php	Thu May 16 12:43:48 2019 +0300
@@ -593,6 +593,34 @@
 }
 
 
+function stDBPrepareSQL_V($dbh, $fmt, $argv)
+{
+  $len = strlen($fmt);
+  $sql = "";
+  $argn = 0;
+  $argc = count($argv);
+
+  for ($pos = 0; $pos < $len; $pos++)
+  {
+    if ($fmt[$pos] == "%")
+    {
+      if ($argn < $argc)
+        $sql .= stDBGetSQLParam($dbh, $fmt[++$pos], $argv[$argn++]);
+      else
+      {
+        stLogError("Invalid SQL statement format string '".$fmt.
+          "', not enough parameters specified (".$argn." of ".$argc.")");
+        return FALSE;
+      }
+    }
+    else
+      $sql .= $fmt[$pos];
+  }
+
+  return $sql;
+}
+
+
 function stDBPrepareSQL($dbh)
 {
   $argc = func_num_args();