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
/**
 * IBM DB2 / Oracle compatibility driver.
 *
 * This driver re-maps ibm :0 bind variables to oracle compatible ? variables.
 *
 * @deprecated
 *
 * 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 2014 Damien Regad, Mark Newnham and the ADOdb community
 */

// security - hide paths
if (!defined('ADODB_DIR')) die();
include_once(ADODB_DIR."/drivers/adodb-db2.inc.php");

if (!defined('ADODB_DB2OCI')){
define('ADODB_DB2OCI',1);

/**
 * Smart remapping of :0, :1 bind vars to ? ?
 * Handles colons in comments -- and / * * / and in quoted strings.
 * @param string $sql SQL statement
 * @param array  $arr parameters
 * @return array
 */
function _colonparser($sql,$arr)
{
	$lensql = strlen($sql);
	$arrsize = sizeof($arr);
	$state = 'NORM';
	$at = 1;
	$ch = $sql[0];
	$ch2 = @$sql[1];
	$sql2 = '';
	$arr2 = array();
	$nprev = 0;

while (strlen($ch)) {

switch($ch) {
		case '/':
			if ($state == 'NORM' && $ch2 == '*') {
				$state = 'COMMENT';

$at += 1;
				$ch = $ch2;
				$ch2 = $at < $lensql ? $sql[$at] : '';
			}
			break;

case '*':
			if ($state == 'COMMENT' && $ch2 == '/') {
				$state = 'NORM';

$at += 1;
				$ch = $ch2;
				$ch2 = $at < $lensql ? $sql[$at] : '';
			}
			break;

case "\n":
		case "\r":
			if ($state == 'COMMENT2') $state = 'NORM';
			break;

case "'":
			do {
				$at += 1;
				$ch = $ch2;
				$ch2 = $at < $lensql ? $sql[$at] : '';
			} while ($ch !== "'");
			break;

case ':':
			if ($state == 'COMMENT' || $state == 'COMMENT2') break;

//echo "$at=$ch $ch2, ";
			if ('0' <= $ch2 && $ch2 <= '9') {
				$n = '';
				$nat = $at;
				do {
					$at += 1;
					$ch = $ch2;
					$n .= $ch;
					$ch2 = $at < $lensql ? $sql[$at] : '';
				} while ('0' <= $ch && $ch <= '9');
				#echo "$n $arrsize ] ";
				$n = (integer) $n;
				if ($n < $arrsize) {
					$sql2 .= substr($sql,$nprev,$nat-$nprev-1).'?';
					$nprev = $at-1;
					$arr2[] = $arr[$n];
				}
			}
			break;

case '-':
			if ($state == 'NORM') {
				if ($ch2 == '-') $state = 'COMMENT2';
				$at += 1;
				$ch = $ch2;
				$ch2 = $at < $lensql ? $sql[$at] : '';
			}
			break;
		}

$at += 1;
		$ch = $ch2;
		$ch2 = $at < $lensql ? $sql[$at] : '';
	}

if ($nprev == 0) {
		$sql2 = $sql;
	} else {
		$sql2 .= substr($sql,$nprev);
	}

return array($sql2,$arr2);
}

class ADODB_db2oci extends ADODB_db2 {
	var $databaseType = "db2oci";
	var $sysTimeStamp = 'sysdate';
	var $sysDate = 'trunc(sysdate)';
	var $_bindInputArray = true;

function Param($name,$type='C')
	{
		return ':'.$name;
	}

function MetaTables($ttype = false, $schema = false, $mask = false)
	{
	global $ADODB_FETCH_MODE;

$savem = $ADODB_FETCH_MODE;
		$ADODB_FETCH_MODE = ADODB_FETCH_NUM;
		$qid = db2_tables($this->_connectionID);

$rs = new ADORecordSet_db2($qid);

$ADODB_FETCH_MODE = $savem;
		if (!$rs) {
			$false = false;
			return $false;
		}

$arr = $rs->GetArray();
		$rs->Close();
		$arr2 = array();
	//	adodb_pr($arr);
		if ($ttype) {
			$isview = strncmp($ttype,'V',1) === 0;
		}
		for ($i=0; $i < sizeof($arr); $i++) {
			if (!$arr[$i][2]) continue;
			$type = $arr[$i][3];
			$schemaval = ($schema) ? $arr[$i][1].'.' : '';
			$name = $schemaval.$arr[$i][2];
			$owner = $arr[$i][1];
			if (substr($name,0,8) == 'EXPLAIN_') continue;
			if ($ttype) {
				if ($isview) {
					if (strncmp($type,'V',1) === 0) $arr2[] = $name;
				} else if (strncmp($type,'T',1) === 0 && strncmp($owner,'SYS',3) !== 0) $arr2[] = $name;
			} else if (strncmp($type,'T',1) === 0 && strncmp($owner,'SYS',3) !== 0) $arr2[] = $name;
		}
		return $arr2;
	}

function _Execute($sql, $inputarr=false	)
	{
		if ($inputarr) list($sql,$inputarr) = _colonparser($sql, $inputarr);
		return parent::_Execute($sql, $inputarr);
	}
};

class  ADORecordSet_db2oci extends ADORecordSet_db2 {

var $databaseType = "db2oci";

}

} //define