diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-07-08 15:56:58 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-07-08 15:56:58 +0000 |
| commit | 8047e0d9c9545b89de29978e45ffc5fd595f18fa (patch) | |
| tree | c935d253ef0a388b3b3ebe94ac1dc33accb25ad8 /phpBB/db | |
| parent | 3497f2adab9fb2e05afb584c1eb3904cb3dba17f (diff) | |
| download | forums-8047e0d9c9545b89de29978e45ffc5fd595f18fa.tar forums-8047e0d9c9545b89de29978e45ffc5fd595f18fa.tar.gz forums-8047e0d9c9545b89de29978e45ffc5fd595f18fa.tar.bz2 forums-8047e0d9c9545b89de29978e45ffc5fd595f18fa.tar.xz forums-8047e0d9c9545b89de29978e45ffc5fd595f18fa.zip | |
Number of queries executed ... for testing only
git-svn-id: file:///svn/phpbb/trunk@603 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mssql.php | 3 | ||||
| -rw-r--r-- | phpBB/db/mysql.php | 3 | ||||
| -rw-r--r-- | phpBB/db/odbc.php | 3 | ||||
| -rw-r--r-- | phpBB/db/oracle.php | 4 | ||||
| -rw-r--r-- | phpBB/db/postgres7.php | 3 |
5 files changed, 15 insertions, 1 deletions
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) |