Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
adodb-access.inc.php	2.15 KB	-rw-r--r--	2023-01-22 09:53
adodb-ado.inc.php	16.24 KB	-rw-r--r--	2023-01-22 09:53
adodb-ado5.inc.php	17.33 KB	-rw-r--r--	2023-01-22 09:53
adodb-ado_access.inc.php	1.48 KB	-rw-r--r--	2023-01-22 09:53
adodb-ado_mssql.inc.php	4.02 KB	-rw-r--r--	2023-01-22 09:53
adodb-ads.inc.php	19.39 KB	-rw-r--r--	2023-01-22 09:53
adodb-borland_ibase.inc.php	2.43 KB	-rw-r--r--	2023-01-22 09:53
adodb-csv.inc.php	5.09 KB	-rw-r--r--	2023-01-22 09:53
adodb-db2.inc.php	44.36 KB	-rw-r--r--	2023-01-22 09:53
adodb-db2oci.inc.php	4.31 KB	-rw-r--r--	2023-01-22 09:53
adodb-db2ora.inc.php	2.23 KB	-rw-r--r--	2023-01-22 09:53
adodb-fbsql.inc.php	6.84 KB	-rw-r--r--	2023-01-22 09:53
adodb-firebird.inc.php	33.07 KB	-rw-r--r--	2023-01-22 09:53
adodb-ibase.inc.php	22.51 KB	-rw-r--r--	2023-01-22 09:53
adodb-informix.inc.php	1.21 KB	-rw-r--r--	2023-01-22 09:53
adodb-informix72.inc.php	14.9 KB	-rw-r--r--	2023-01-22 09:53
adodb-ldap.inc.php	10.93 KB	-rw-r--r--	2023-01-22 09:53
adodb-mssql.inc.php	30.66 KB	-rw-r--r--	2023-01-22 09:53
adodb-mssql_n.inc.php	7.75 KB	-rw-r--r--	2023-01-22 09:53
adodb-mssqlnative.inc.php	34.74 KB	-rw-r--r--	2023-01-22 09:53
adodb-mssqlpo.inc.php	1.41 KB	-rw-r--r--	2023-01-22 09:53
adodb-mysqli.inc.php	50.3 KB	-rw-r--r--	2023-01-22 09:53
adodb-netezza.inc.php	5.12 KB	-rw-r--r--	2023-01-22 09:53
adodb-oci8.inc.php	47.83 KB	-rw-r--r--	2023-01-22 09:53
adodb-oci805.inc.php	1.79 KB	-rw-r--r--	2023-01-22 09:53
adodb-oci8po.inc.php	7.12 KB	-rw-r--r--	2023-01-22 09:53
adodb-oci8quercus.inc.php	2.3 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc.inc.php	18.56 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc_db2.inc.php	6.87 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc_mssql.inc.php	12.34 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc_mssql2012.inc.php	1.08 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc_oracle.inc.php	3.34 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbtp.inc.php	23.2 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbtp_unicode.inc.php	1.42 KB	-rw-r--r--	2023-01-22 09:53
adodb-oracle.inc.php	9.39 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo.inc.php	20.79 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_dblib.inc.php	5.8 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_firebird.inc.php	10.76 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_mssql.inc.php	1.84 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_mysql.inc.php	9.84 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_oci.inc.php	3.41 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_pgsql.inc.php	10.2 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_sqlite.inc.php	6.33 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_sqlsrv.inc.php	4.5 KB	-rw-r--r--	2023-01-22 09:53
adodb-postgres.inc.php	1008 B	-rw-r--r--	2023-01-22 09:53
adodb-postgres64.inc.php	32.3 KB	-rw-r--r--	2023-01-22 09:53
adodb-postgres7.inc.php	9.27 KB	-rw-r--r--	2023-01-22 09:53
adodb-postgres8.inc.php	2.1 KB	-rw-r--r--	2023-01-22 09:53
adodb-postgres9.inc.php	1.13 KB	-rw-r--r--	2023-01-22 09:53
adodb-proxy.inc.php	1.12 KB	-rw-r--r--	2023-01-22 09:53
adodb-sapdb.inc.php	5 KB	-rw-r--r--	2023-01-22 09:53
adodb-sqlanywhere.inc.php	3.43 KB	-rw-r--r--	2023-01-22 09:53
adodb-sqlite.inc.php	11.83 KB	-rw-r--r--	2023-01-22 09:53
adodb-sqlite3.inc.php	18.66 KB	-rw-r--r--	2023-01-22 09:53
adodb-sqlitepo.inc.php	2.05 KB	-rw-r--r--	2023-01-22 09:53
adodb-sybase.inc.php	12.27 KB	-rw-r--r--	2023-01-22 09:53
adodb-sybase_ase.inc.php	3.5 KB	-rw-r--r--	2023-01-22 09:53
adodb-text.inc.php	8.14 KB	-rw-r--r--	2023-01-22 09:53
adodb-vfp.inc.php	2.6 KB	-rw-r--r--	2023-01-22 09:53

Rename

<?php
/**
 * ADOdb PDO dblib driver.
 *
 * This file is part of ADOdb, a Database Abstraction Layer library for PHP.
 *
 * @package ADOdb
 * @link https://adodb.org Project's web site and documentation
 * @link https://github.com/ADOdb/ADOdb Source code and issue tracker
 *
 * The ADOdb Library is dual-licensed, released under both the BSD 3-Clause
 * and the GNU Lesser General Public Licence (LGPL) v2.1 or, at your option,
 * any later version. This means you can use it in proprietary products.
 * See the LICENSE.md file distributed with this source code for details.
 * @license BSD-3-Clause
 * @license LGPL-2.1-or-later
 *
 * @copyright 2000-2013 John Lim
 * @copyright 2019 Damien Regad, Mark Newnham and the ADOdb community
 */

class ADODB_pdo_dblib extends ADODB_pdo
{
	var $hasTop = 'top';
	var $sysDate = 'convert(datetime,convert(char,GetDate(),102),102)';
	var $sysTimeStamp = 'GetDate()';
	var $metaDatabasesSQL = "select name from sysdatabases where name <> 'master'";
	var $metaTablesSQL="select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties'))";

var $metaColumnsSQL = "SELECT c.NAME, OBJECT_NAME(c.id) as tbl_name, c.length, c.isnullable, c.status, ( CASE WHEN c.xusertype=61 THEN 0 ELSE c.xprec END), ( CASE WHEN c.xusertype=61 THEN 0 ELSE c.xscale END), ISNULL(i.is_primary_key, 0) as primary_key FROM   syscolumns c INNER JOIN systypes t ON t.xusertype=c.xusertype INNER JOIN sysobjects o ON o.id=c.id LEFT JOIN sys.index_columns ic ON ic.object_id = c.id AND c.colid = ic.column_id LEFT JOIN sys.indexes i ON i.object_id = ic.object_id AND i.index_id = ic.index_id WHERE c.id = OBJECT_ID('%s') ORDER by c.colid";

function _init(ADODB_pdo $parentDriver)
	{
		$parentDriver->hasTransactions = true;
		$parentDriver->_bindInputArray = true;
		$parentDriver->hasInsertID = true;
		$parentDriver->fmtTimeStamp = "'Y-m-d H:i:s'";
		$parentDriver->fmtDate = "'Y-m-d'";
	}

function BeginTrans()
	{
		$returnval = parent::BeginTrans();
		return $returnval;
	}

function MetaColumns($table, $normalize=true)
	{
		$this->_findschema($table,$schema);
		if ($schema) {
			$dbName = $this->database;
			$this->SelectDB($schema);
		}
		global $ADODB_FETCH_MODE;
		$save = $ADODB_FETCH_MODE;
		$ADODB_FETCH_MODE = ADODB_FETCH_NUM;

if ($this->fetchMode !== false) $savem = $this->SetFetchMode(false);
		$rs = $this->Execute(sprintf($this->metaColumnsSQL,$table));

if ($schema) {
			$this->SelectDB($dbName);
		}

if (isset($savem)) $this->SetFetchMode($savem);
		$ADODB_FETCH_MODE = $save;
		if (!is_object($rs)) {
			$false = false;
			return $false;
		}

$retarr = array();
		while (!$rs->EOF) {
			$fld = new ADOFieldObject();
			$fld->name = $rs->fields[0];
			$fld->type = $rs->fields[1];
			$fld->primary_key = $rs->fields[7];

$fld->not_null = (!$rs->fields[3]);
			$fld->auto_increment = ($rs->fields[4] == 128);		// sys.syscolumns status field. 0x80 = 128 ref: http://msdn.microsoft.com/en-us/library/ms186816.aspx

if (isset($rs->fields[5]) && $rs->fields[5]) {
				if ($rs->fields[5]>0) $fld->max_length = $rs->fields[5];
				$fld->scale = $rs->fields[6];
				if ($fld->scale>0) $fld->max_length += 1;
			} else
				$fld->max_length = $rs->fields[2];

if ($save == ADODB_FETCH_NUM) {
				$retarr[] = $fld;
			} else {
				$retarr[strtoupper($fld->name)] = $fld;
			}
			$rs->MoveNext();
		}

$rs->Close();
		return $retarr;
	}

function MetaTables($ttype=false,$showSchema=false,$mask=false)
	{
		if ($mask) {
			$save = $this->metaTablesSQL;
			$mask = $this->qstr(($mask));
			$this->metaTablesSQL .= " AND name like $mask";
		}
		$ret = ADOConnection::MetaTables($ttype,$showSchema);

if ($mask) {
			$this->metaTablesSQL = $save;
		}
		return $ret;
	}

function SelectLimit($sql,$nrows=-1,$offset=-1, $inputarr=false,$secs2cache=0)
	{
		if ($nrows > 0 && $offset <= 0) {
			$sql = preg_replace(
				'/(^\s*select\s+(distinctrow|distinct)?)/i','\\1 '.$this->hasTop." $nrows ",$sql);

if ($secs2cache)
				$rs = $this->CacheExecute($secs2cache, $sql, $inputarr);
			else
				$rs = $this->Execute($sql,$inputarr);
		} else
			$rs = ADOConnection::SelectLimit($sql,$nrows,$offset,$inputarr,$secs2cache);

return $rs;
	}

function _query($sql,$inputarr=false)
	{
		$this->_connectionID->setAttribute(\PDO::ATTR_EMULATE_PREPARES , true);
		if (is_array($sql)) {
			$stmt = $sql[1];
		} else {
			$stmt = $this->_connectionID->prepare($sql);
		}

if ($stmt) {
			$this->_driver->debug = $this->debug;
			if ($inputarr) {
				foreach ($inputarr as $key => $value) {
					if(gettype($key) == 'integer') {
						$key += 1;
					}
					$stmt->bindValue($key, $value, $this->GetPDODataType($value));
				}
			}
		}

$ok = $stmt->execute();

$this->_errormsg = false;
		$this->_errorno = false;

if ($ok) {
			$this->_stmt = $stmt;
			return $stmt;
		}

if ($stmt) {

$arr = $stmt->errorinfo();
			if ((integer)$arr[1]) {
				$this->_errormsg = $arr[2];
				$this->_errorno = $arr[1];
			}

} else {
			$this->_errormsg = false;
			$this->_errorno = false;
		}
		return false;
	}

private function GetPDODataType($var)
	{
		if(gettype($var) == 'integer') {
			return PDO::PARAM_INT ;
		}
		return PDO::PARAM_STR;
	}

function ServerInfo()
	{
		return ADOConnection::ServerInfo();
	}
}