From 8047e0d9c9545b89de29978e45ffc5fd595f18fa Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Sun, 8 Jul 2001 15:56:58 +0000 Subject: Number of queries executed ... for testing only git-svn-id: file:///svn/phpbb/trunk@603 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/db/mssql.php | 3 +++ phpBB/db/mysql.php | 3 +++ phpBB/db/odbc.php | 3 +++ phpBB/db/oracle.php | 4 +++- phpBB/db/postgres7.php | 3 +++ 5 files changed, 15 insertions(+), 1 deletion(-) (limited to 'phpBB/db') diff --git a/phpBB/db/mssql.php b/phpBB/db/mssql.php index 032e00587a..2f79ae042b 100644 --- a/phpBB/db/mssql.php +++ b/phpBB/db/mssql.php @@ -36,6 +36,7 @@ class sql_db var $query_limit_success; var $next_id; var $row; + var $num_queries = 0; // // Constructor @@ -100,8 +101,10 @@ class sql_db // unset($this->query_result); unset($this->row); + if($query != "") { + $this->num_queries++; if($transaction == BEGIN_TRANSACTION) { $result = mssql_query("BEGIN TRANSACTION", $this->db_connect_id); diff --git a/phpBB/db/mysql.php b/phpBB/db/mysql.php index 9afe8acbe8..0e123a8244 100644 --- a/phpBB/db/mysql.php +++ b/phpBB/db/mysql.php @@ -30,6 +30,7 @@ class sql_db var $db_connect_id; var $query_result; var $row; + var $num_queries = 0; // // Constructor @@ -100,6 +101,8 @@ class sql_db unset($this->query_result); if($query != "") { + $this->num_queries++; + $this->query_result = @mysql_query($query, $this->db_connect_id); } if($this->query_result) diff --git a/phpBB/db/odbc.php b/phpBB/db/odbc.php index 6b21346603..6ac3d376d7 100644 --- a/phpBB/db/odbc.php +++ b/phpBB/db/odbc.php @@ -34,6 +34,7 @@ class sql_db var $next_id; var $row; var $row_index; + var $num_queries = 0; // // Constructor @@ -126,6 +127,8 @@ class sql_db unset($this->row); if($query != "") { + $this->num_queries++; + if($this->db_type == "msaccess") { $query = str_replace("LOWER(", "LCASE(", $query); diff --git a/phpBB/db/oracle.php b/phpBB/db/oracle.php index 42664ca45d..a7dc09eb33 100644 --- a/phpBB/db/oracle.php +++ b/phpBB/db/oracle.php @@ -30,7 +30,7 @@ class sql_db var $db_connect_id; var $query_result; var $row; - + var $num_queries = 0; // // Constructor @@ -90,6 +90,8 @@ class sql_db unset($this->query_result); if($query != "") { + $this->num_queries++; + if(eregi("LIMIT", $query)) { preg_match("/^(.*)LIMIT ([0-9]+)[, ]*([0-9]+)*/s", $query, $limits); diff --git a/phpBB/db/postgres7.php b/phpBB/db/postgres7.php index 981439cc10..df5d8edc4c 100644 --- a/phpBB/db/postgres7.php +++ b/phpBB/db/postgres7.php @@ -32,6 +32,7 @@ class sql_db var $in_transaction = 0; var $row; var $rownum = array(); + var $num_queries = 0; // // Constructor @@ -122,6 +123,8 @@ class sql_db unset($this->query_result); if($query != "") { + $this->num_queries++; + $query = preg_replace("/LIMIT ([0-9]+),([ 0-9]+)/", "LIMIT \\2, \\1", $query); if($transaction == BEGIN_TRANSACTION) -- cgit v1.2.1