added LOCK/UNLOCK to mainps queries (reported by Erik Hjortsberg)

tvvcox · tvvcox · commit dc60b4d4661a · 2001-07-11T11:03:27.000Z
diff --git a/pear/DB.php b/pear/DB.php
@@ -297,7 +297,9 @@ function isError($value)
      */
     function isManip($query)
     {
-        if (preg_match('/^\s*"?(INSERT|UPDATE|DELETE|REPLACE|CREATE|DROP|ALTER|GRANT|REVOKE)\s+/i', $query)) {
+        $manips = 'INSERT|UPDATE|DELETE|'.'REPLACE|CREATE|DROP|'.
+                  'ALTER|GRANT|REVOKE|'.'LOCK|UNLOCK';
+        if (preg_match('/^\s*"?('.$manips.')\s+/i', $query)) {
             return true;
         }
         return false;

Original file line number	Diff line number	Diff line change
`@@ -297,7 +297,9 @@ function isError($value)`
`297`	`297`	`*/`
`298`	`298`	`function isManip($query)`
`299`	`299`	`{`
`300`		`- if (preg_match('/^\s*"?(INSERT\|UPDATE\|DELETE\|REPLACE\|CREATE\|DROP\|ALTER\|GRANT\|REVOKE)\s+/i', $query)) {`
	`300`	`+ $manips = 'INSERT\|UPDATE\|DELETE\|'.'REPLACE\|CREATE\|DROP\|'.`
	`301`	`+ 'ALTER\|GRANT\|REVOKE\|'.'LOCK\|UNLOCK';`
	`302`	`+ if (preg_match('/^\s*"?('.$manips.')\s+/i', $query)) {`
`301`	`303`	`return true;`
`302`	`304`	`}`
`303`	`305`	`return false;`