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
/**
 * Microsoft SQL Server ADO driver.
 *
 * Requires ADO and MSSQL client. Works only on MS Windows.
 *
 * 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();

if (!defined('_ADODB_ADO_LAYER')) {
	include_once(ADODB_DIR . "/drivers/adodb-ado5.inc.php");
}

class  ADODB_ado_mssql extends ADODB_ado {
	var $databaseType = 'ado_mssql';
	var $hasTop = 'top';
	var $hasInsertID = true;
	var $sysDate = 'convert(datetime,convert(char,GetDate(),102),102)';
	var $sysTimeStamp = 'GetDate()';
	var $leftOuter = '*=';
	var $rightOuter = '=*';
	var $ansiOuter = true; // for mssql7 or later
	var $substr = "substring";
	var $length = 'len';
	var $_dropSeqSQL = "drop table %s";

//var $_inTransaction = 1; // always open recordsets, so no transaction problems.

protected function _insertID($table = '', $column = '')
	{
			return $this->GetOne('select SCOPE_IDENTITY()');
	}

function _affectedrows()
	{
			return $this->GetOne('select @@rowcount');
	}

function SetTransactionMode( $transaction_mode )
	{
		$this->_transmode  = $transaction_mode;
		if (empty($transaction_mode)) {
			$this->Execute('SET TRANSACTION ISOLATION LEVEL READ COMMITTED');
			return;
		}
		if (!stristr($transaction_mode,'isolation')) $transaction_mode = 'ISOLATION LEVEL '.$transaction_mode;
		$this->Execute("SET TRANSACTION ".$transaction_mode);
	}

function qStr($s, $magic_quotes=false)
	{
		$s = ADOConnection::qStr($s);
		return str_replace("\0", "\\\\000", $s);
	}

function MetaColumns($table, $normalize=true)
	{
		$table = strtoupper($table);
		$arr= array();
		$dbc = $this->_connectionID;

$osoptions = array();
		$osoptions[0] = null;
		$osoptions[1] = null;
		$osoptions[2] = $table;
		$osoptions[3] = null;

$adors=@$dbc->OpenSchema(4, $osoptions);//tables

if ($adors){
			while (!$adors->EOF){
				$fld = new ADOFieldObject();
				$c = $adors->Fields(3);
				$fld->name = $c->Value;
				$fld->type = 'CHAR'; // cannot discover type in ADO!
				$fld->max_length = -1;
				$arr[strtoupper($fld->name)]=$fld;

$adors->MoveNext();
			}
			$adors->Close();
		}
		$false = false;
		return empty($arr) ? $false : $arr;
	}

function CreateSequence($seq='adodbseq',$start=1)
	{

$this->Execute('BEGIN TRANSACTION adodbseq');
		$start -= 1;
		$this->Execute("create table $seq (id float(53))");
		$ok = $this->Execute("insert into $seq with (tablock,holdlock) values($start)");
		if (!$ok) {
				$this->Execute('ROLLBACK TRANSACTION adodbseq');
				return false;
		}
		$this->Execute('COMMIT TRANSACTION adodbseq');
		return true;
	}

function GenID($seq='adodbseq',$start=1)
	{
		//$this->debug=1;
		$this->Execute('BEGIN TRANSACTION adodbseq');
		$ok = $this->Execute("update $seq with (tablock,holdlock) set id = id + 1");
		if (!$ok) {
			$this->Execute("create table $seq (id float(53))");
			$ok = $this->Execute("insert into $seq with (tablock,holdlock) values($start)");
			if (!$ok) {
				$this->Execute('ROLLBACK TRANSACTION adodbseq');
				return false;
			}
			$this->Execute('COMMIT TRANSACTION adodbseq');
			return $start;
		}
		$num = $this->GetOne("select id from $seq");
		$this->Execute('COMMIT TRANSACTION adodbseq');
		return $num;

// in old implementation, pre 1.90, we returned GUID...
		//return $this->GetOne("SELECT CONVERT(varchar(255), NEWID()) AS 'Char'");
	}

} // end class

class ADORecordSet_ado_mssql extends ADORecordSet_ado {

var $databaseType = 'ado_mssql';

}