aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/db/postgres.php
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2003-03-17 11:48:27 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2003-03-17 11:48:27 +0000
commit28ed4efed1bfc2319c6b4db4d357ea10bb1c3d0a (patch)
treed910feb218d8f4085850ed527a60f3f1bf5e6d92 /phpBB/db/postgres.php
parent18b4bf0d05c49cd6b211fc177f568fc2329e2089 (diff)
downloadforums-28ed4efed1bfc2319c6b4db4d357ea10bb1c3d0a.tar
forums-28ed4efed1bfc2319c6b4db4d357ea10bb1c3d0a.tar.gz
forums-28ed4efed1bfc2319c6b4db4d357ea10bb1c3d0a.tar.bz2
forums-28ed4efed1bfc2319c6b4db4d357ea10bb1c3d0a.tar.xz
forums-28ed4efed1bfc2319c6b4db4d357ea10bb1c3d0a.zip
Moved to includes/
git-svn-id: file:///svn/phpbb/trunk@3658 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/postgres.php')
-rw-r--r--phpBB/db/postgres.php397
1 files changed, 0 insertions, 397 deletions
diff --git a/phpBB/db/postgres.php b/phpBB/db/postgres.php
deleted file mode 100644
index 96a90fbb1a..0000000000
--- a/phpBB/db/postgres.php
+++ /dev/null
@@ -1,397 +0,0 @@
-<?php
- /***************************************************************************
- * postgres7.php
- * -------------------
- * begin : Saturday, Feb 13, 2001
- * copyright : (C) 2001 The phpBB Group
- * email : supportphpbb.com
- *
- * $Id$
- *
- ***************************************************************************/
-
-/***************************************************************************
- *
- * This program is free software; you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation; either version 2 of the License, or
- * (at your option) any later version.
- *
- ***************************************************************************/
-
-if(!defined("SQL_LAYER"))
-{
-
-define("SQL_LAYER","postgresql");
-
-class sql_db
-{
-
- var $db_connect_id;
- var $query_result;
- var $in_transaction = 0;
- var $row = array();
- var $rowset = array();
- var $rownum = array();
- var $num_queries = 0;
-
- //
- // Constructor
- //
- function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)
- {
- $this->connect_string = "";
-
- if( $sqluser )
- {
- $this->connect_string .= "user=$sqluser ";
- }
-
- if( $sqlpassword )
- {
- $this->connect_string .= "password=$sqlpassword ";
- }
-
- if( $sqlserver )
- {
- if( ereg(":", $sqlserver) )
- {
- list($sqlserver, $sqlport) = split(":", $sqlserver);
- $this->connect_string .= "host=$sqlserver port=$sqlport ";
- }
- else
- {
- if( $sqlserver != "localhost" )
- {
- $this->connect_string .= "host=$sqlserver ";
- }
- }
- }
-
- if( $database )
- {
- $this->dbname = $database;
- $this->connect_string .= "dbname=$database";
- }
-
- $this->persistency = $persistency;
-
- $this->db_connect_id = ( $this->persistency ) ? pg_pconnect($this->connect_string) : pg_connect($this->connect_string);
-
- return ( $this->db_connect_id ) ? $this->db_connect_id : false;
- }
-
- //
- // Other base methods
- //
- function sql_close()
- {
- if( $this->db_connect_id )
- {
- //
- // Commit any remaining transactions
- //
- if( $this->in_transaction )
- {
- @pg_exec($this->db_connect_id, "COMMIT");
- }
-
- if( $this->query_result )
- {
- @pg_freeresult($this->query_result);
- }
-
- return @pg_close($this->db_connect_id);
- }
- else
- {
- return false;
- }
- }
-
- //
- // Query method
- //
- function sql_query($query = "", $transaction = false)
- {
- //
- // Remove any pre-existing queries
- //
- unset($this->query_result);
- if( $query != "" )
- {
- $this->num_queries++;
-
- $query = preg_replace("/LIMIT ([0-9]+),([ 0-9]+)/", "LIMIT \\2 OFFSET \\1", $query);
-
- if( $transaction == BEGIN_TRANSACTION && !$this->in_transaction )
- {
- $this->in_transaction = TRUE;
-
- if( !@pg_exec($this->db_connect_id, "BEGIN") )
- {
- return false;
- }
- }
-
- $this->query_result = @pg_exec($this->db_connect_id, $query);
- if( $this->query_result )
- {
- if( $transaction == END_TRANSACTION )
- {
- $this->in_transaction = FALSE;
-
- if( !@pg_exec($this->db_connect_id, "COMMIT") )
- {
- @pg_exec($this->db_connect_id, "ROLLBACK");
- return false;
- }
- }
-
- $this->last_query_text[$this->query_result] = $query;
- $this->rownum[$this->query_result] = 0;
-
- unset($this->row[$this->query_result]);
- unset($this->rowset[$this->query_result]);
-
- return $this->query_result;
- }
- else
- {
- if( $this->in_transaction )
- {
- @pg_exec($this->db_connect_id, "ROLLBACK");
- }
- $this->in_transaction = FALSE;
-
- return false;
- }
- }
- else
- {
- if( $transaction == END_TRANSACTION && $this->in_transaction )
- {
- $this->in_transaction = FALSE;
-
- if( !@pg_exec($this->db_connect_id, "COMMIT") )
- {
- @pg_exec($this->db_connect_id, "ROLLBACK");
- return false;
- }
- }
-
- return true;
- }
- }
-
- //
- // Other query methods
- //
- function sql_numrows($query_id = 0)
- {
- if( !$query_id )
- {
- $query_id = $this->query_result;
- }
-
- return ( $query_id ) ? @pg_numrows($query_id) : false;
- }
-
- function sql_numfields($query_id = 0)
- {
- if( !$query_id )
- {
- $query_id = $this->query_result;
- }
-
- return ( $query_id ) ? @pg_numfields($query_id) : false;
- }
-
- function sql_fieldname($offset, $query_id = 0)
- {
- if( !$query_id )
- {
- $query_id = $this->query_result;
- }
-
- return ( $query_id ) ? @pg_fieldname($query_id, $offset) : false;
- }
-
- function sql_fieldtype($offset, $query_id = 0)
- {
- if( !$query_id )
- {
- $query_id = $this->query_result;
- }
-
- return ( $query_id ) ? @pg_fieldtype($query_id, $offset) : false;
- }
-
- function sql_fetchrow($query_id = 0)
- {
- if( !$query_id )
- {
- $query_id = $this->query_result;
- }
-
- if($query_id)
- {
- $this->row = @pg_fetch_array($query_id, $this->rownum[$query_id]);
-
- if( $this->row )
- {
- $this->rownum[$query_id]++;
- return $this->row;
- }
- }
-
- return false;
- }
-
- function sql_fetchrowset($query_id = 0)
- {
- if( !$query_id )
- {
- $query_id = $this->query_result;
- }
-
- if( $query_id )
- {
- unset($this->rowset[$query_id]);
- unset($this->row[$query_id]);
- $this->rownum[$query_id] = 0;
-
- while( $this->rowset = @pg_fetch_array($query_id, $this->rownum[$query_id], PGSQL_ASSOC) )
- {
- $result[] = $this->rowset;
- $this->rownum[$query_id]++;
- }
-
- return $result;
- }
-
- return false;
- }
-
- function sql_fetchfield($field, $row_offset=-1, $query_id = 0)
- {
- if( !$query_id )
- {
- $query_id = $this->query_result;
- }
-
- if( $query_id )
- {
- if( $row_offset != -1 )
- {
- $this->row = @pg_fetch_array($query_id, $row_offset, PGSQL_ASSOC);
- }
- else
- {
- if( $this->rownum[$query_id] )
- {
- $this->row = @pg_fetch_array($query_id, $this->rownum[$query_id]-1, PGSQL_ASSOC);
- }
- else
- {
- $this->row = @pg_fetch_array($query_id, $this->rownum[$query_id], PGSQL_ASSOC);
-
- if( $this->row )
- {
- $this->rownum[$query_id]++;
- }
- }
- }
-
- return $this->row[$field];
- }
-
- return false;
- }
-
- function sql_rowseek($offset, $query_id = 0)
- {
-
- if(!$query_id)
- {
- $query_id = $this->query_result;
- }
-
- if( $query_id )
- {
- if( $offset > -1 )
- {
- $this->rownum[$query_id] = $offset;
- return true;
- }
- else
- {
- return false;
- }
- }
-
- return false;
- }
-
- function sql_nextid()
- {
- $query_id = $this->query_result;
-
- if($query_id && $this->last_query_text[$query_id] != "")
- {
- if( preg_match("/^INSERT[\t\n ]+INTO[\t\n ]+([a-z0-9\_\-]+)/is", $this->last_query_text[$query_id], $tablename) )
- {
- $query = "SELECT currval('" . $tablename[1] . "_id_seq') AS last_value";
- $temp_q_id = @pg_exec($this->db_connect_id, $query);
- if( !$temp_q_id )
- {
- return false;
- }
-
- $temp_result = @pg_fetch_array($temp_q_id, 0, PGSQL_ASSOC);
-
- return ( $temp_result ) ? $temp_result['last_value'] : false;
- }
- }
-
- return false;
- }
-
- function sql_affectedrows($query_id = 0)
- {
- if( !$query_id )
- {
- $query_id = $this->query_result;
- }
-
- return ( $query_id ) ? @pg_cmdtuples($query_id) : false;
- }
-
- function sql_freeresult($query_id = 0)
- {
- if( !$query_id )
- {
- $query_id = $this->query_result;
- }
-
- return ( $query_id ) ? @pg_freeresult($query_id) : false;
- }
-
- function sql_error($query_id = 0)
- {
- if( !$query_id )
- {
- $query_id = $this->query_result;
- }
-
- $result['message'] = @pg_errormessage($this->db_connect_id);
- $result['code'] = -1;
-
- return $result;
- }
-
-} // class ... db_sql
-
-} // if ... defined
-
-?> \ No newline at end of file
generated by cgit v1.2.1 (git 2.21.0) at 2025-03-23 09:21:42 +0000