KONTOLODON

/var/www/ojs-3.3.0-13/lib/pkp/lib/vendor/adodb/adodb-php/drivers/

<?php
/*
@version   v5.20.18  28-Jun-2020
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014      Damien Regad, Mark Newnham and the ADOdb community
  Released under both BSD license and Lesser GPL library license.
  Whenever there is any discrepancy between the two licenses,
  the BSD license will take precedence.

Latest version is available at http://adodb.org/

SQLite info: http://www.hwaci.com/sw/sqlite/

Install Instructions:
  ====================
  1. Place this in adodb/drivers
  2. Rename the file, remove the .txt prefix.
*/

// security - hide paths
if (!defined('ADODB_DIR')) die();

class ADODB_sqlite extends ADOConnection {
	var $databaseType = "sqlite";
	var $replaceQuote = "''"; // string to use to replace quotes
	var $concat_operator='||';
	var $_errorNo = 0;
	var $hasLimit = true;
	var $hasInsertID = true; 		/// supports autoincrement ID?
	var $hasAffectedRows = true; 	/// supports affected rows for update/delete?
	var $metaTablesSQL = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name";
	var $sysDate = "adodb_date('Y-m-d')";
	var $sysTimeStamp = "adodb_date('Y-m-d H:i:s')";
	var $fmtTimeStamp = "'Y-m-d H:i:s'";

function __construct()
	{
	}

function ServerInfo()
	{
		$arr['version'] = sqlite_libversion();
		$arr['description'] = 'SQLite ';
		$arr['encoding'] = sqlite_libencoding();
		return $arr;
	}

function BeginTrans()
	{
		if ($this->transOff) {
			return true;
		}
		$ret = $this->Execute("BEGIN TRANSACTION");
		$this->transCnt += 1;
		return true;
	}

function RollbackTrans()
	{
		if ($this->transOff) {
			return true;
		}
		$ret = $this->Execute("ROLLBACK");
		if ($this->transCnt > 0) {
			$this->transCnt -= 1;
		}
		return !empty($ret);
	}

// mark newnham
	function MetaColumns($table, $normalize=true)
	{
		global $ADODB_FETCH_MODE;
		$false = false;
		$save = $ADODB_FETCH_MODE;
		$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
		if ($this->fetchMode !== false) {
			$savem = $this->SetFetchMode(false);
		}
		$rs = $this->Execute("PRAGMA table_info('$table')");
		if (isset($savem)) {
			$this->SetFetchMode($savem);
		}
		if (!$rs) {
			$ADODB_FETCH_MODE = $save;
			return $false;
		}
		$arr = array();
		while ($r = $rs->FetchRow()) {
			$type = explode('(',$r['type']);
			$size = '';
			if (sizeof($type)==2) {
				$size = trim($type[1],')');
			}
			$fn = strtoupper($r['name']);
			$fld = new ADOFieldObject;
			$fld->name = $r['name'];
			$fld->type = $type[0];
			$fld->max_length = $size;
			$fld->not_null = $r['notnull'];
			$fld->default_value = $r['dflt_value'];
			$fld->scale = 0;
			if (isset($r['pk']) && $r['pk']) {
				$fld->primary_key=1;
			}
			if ($save == ADODB_FETCH_NUM) {
				$arr[] = $fld;
			} else {
				$arr[strtoupper($fld->name)] = $fld;
			}
		}
		$rs->Close();
		$ADODB_FETCH_MODE = $save;
		return $arr;
	}

function _init($parentDriver)
	{
		$parentDriver->hasTransactions = false;
		$parentDriver->hasInsertID = true;
	}

function _insertid()
	{
		return sqlite_last_insert_rowid($this->_connectionID);
	}

function _affectedrows()
	{
		return sqlite_changes($this->_connectionID);
	}

function ErrorMsg()
 	{
		if ($this->_logsql) {
			return $this->_errorMsg;
		}
		return ($this->_errorNo) ? sqlite_error_string($this->_errorNo) : '';
	}

function ErrorNo()
	{
		return $this->_errorNo;
	}

function SQLDate($fmt, $col=false)
	{
		$fmt = $this->qstr($fmt);
		return ($col) ? "adodb_date2($fmt,$col)" : "adodb_date($fmt)";
	}

function _createFunctions()
	{
		@sqlite_create_function($this->_connectionID, 'adodb_date', 'adodb_date', 1);
		@sqlite_create_function($this->_connectionID, 'adodb_date2', 'adodb_date2', 2);
	}

// returns true or false
	function _connect($argHostname, $argUsername, $argPassword, $argDatabasename)
	{
		if (!function_exists('sqlite_open')) {
			return null;
		}
		if (empty($argHostname) && $argDatabasename) {
			$argHostname = $argDatabasename;
		}

$this->_connectionID = sqlite_open($argHostname);
		if ($this->_connectionID === false) {
			return false;
		}
		$this->_createFunctions();
		return true;
	}

// returns true or false
	function _pconnect($argHostname, $argUsername, $argPassword, $argDatabasename)
	{
		if (!function_exists('sqlite_open')) {
			return null;
		}
		if (empty($argHostname) && $argDatabasename) {
			$argHostname = $argDatabasename;
		}

$this->_connectionID = sqlite_popen($argHostname);
		if ($this->_connectionID === false) {
			return false;
		}
		$this->_createFunctions();
		return true;
	}

// returns query ID if successful, otherwise false
	function _query($sql,$inputarr=false)
	{
		$rez = sqlite_query($sql,$this->_connectionID);
		if (!$rez) {
			$this->_errorNo = sqlite_last_error($this->_connectionID);
		}
		// If no data was returned, we don't need to create a real recordset
		// Note: this code is untested, as I don't have a sqlite2 setup available
		elseif (sqlite_num_fields($rez) == 0) {
			$rez = true;
		}

return $rez;
	}

function SelectLimit($sql,$nrows=-1,$offset=-1,$inputarr=false,$secs2cache=0)
	{
		$nrows = (int) $nrows;
		$offset = (int) $offset;
		$offsetStr = ($offset >= 0) ? " OFFSET $offset" : '';
		$limitStr  = ($nrows >= 0)  ? " LIMIT $nrows" : ($offset >= 0 ? ' LIMIT 999999999' : '');
		if ($secs2cache) {
			$rs = $this->CacheExecute($secs2cache,$sql."$limitStr$offsetStr",$inputarr);
		} else {
			$rs = $this->Execute($sql."$limitStr$offsetStr",$inputarr);
		}

return $rs;
	}

/*
		This algorithm is not very efficient, but works even if table locking
		is not available.

Will return false if unable to generate an ID after $MAXLOOPS attempts.
	*/
	var $_genSeqSQL = "create table %s (id integer)";

function GenID($seq='adodbseq',$start=1)
	{
		// if you have to modify the parameter below, your database is overloaded,
		// or you need to implement generation of id's yourself!
		$MAXLOOPS = 100;
		//$this->debug=1;
		while (--$MAXLOOPS>=0) {
			@($num = $this->GetOne("select id from $seq"));
			if ($num === false) {
				$this->Execute(sprintf($this->_genSeqSQL ,$seq));
				$start -= 1;
				$num = '0';
				$ok = $this->Execute("insert into $seq values($start)");
				if (!$ok) {
					return false;
				}
			}
			$this->Execute("update $seq set id=id+1 where id=$num");

if ($this->affected_rows() > 0) {
				$num += 1;
				$this->genID = $num;
				return $num;
			}
		}
		if ($fn = $this->raiseErrorFn) {
			$fn($this->databaseType,'GENID',-32000,"Unable to generate unique id after $MAXLOOPS attempts",$seq,$num);
		}
		return false;
	}

var $_dropSeqSQL = 'drop table %s';
	function DropSequence($seqname = 'adodbseq')
	{
		if (empty($this->_dropSeqSQL)) {
			return false;
		}
		return $this->Execute(sprintf($this->_dropSeqSQL,$seqname));
	}

// returns true or false
	function _close()
	{
		return @sqlite_close($this->_connectionID);
	}

$indexes = array ();
		while ($row = $rs->FetchRow()) {
			if ($primary && preg_match("/primary/i",$row[1]) == 0) {
				continue;
			}
			if (!isset($indexes[$row[0]])) {
				$indexes[$row[0]] = array(
					'unique' => preg_match("/unique/i",$row[1]),
					'columns' => array()
				);
			}
			/**
			 * There must be a more elegant way of doing this,
			 * the index elements appear in the SQL statement
			 * in cols[1] between parentheses
			 * e.g CREATE UNIQUE INDEX ware_0 ON warehouse (org,warehouse)
			 */
			$cols = explode("(",$row[1]);
			$cols = explode(")",$cols[1]);
			array_pop($cols);
			$indexes[$row[0]]['columns'] = $cols;
		}
		if (isset($savem)) {
			$this->SetFetchMode($savem);
			$ADODB_FETCH_MODE = $save;
		}
		return $indexes;
	}

}

/*--------------------------------------------------------------------------------------
		Class Name: Recordset
--------------------------------------------------------------------------------------*/

class ADORecordset_sqlite extends ADORecordSet {

var $databaseType = "sqlite";
	var $bind = false;

function __construct($queryID,$mode=false)
	{

if ($mode === false) {
			global $ADODB_FETCH_MODE;
			$mode = $ADODB_FETCH_MODE;
		}
		switch($mode) {
			case ADODB_FETCH_NUM:
				$this->fetchMode = SQLITE_NUM;
				break;
			case ADODB_FETCH_ASSOC:
				$this->fetchMode = SQLITE_ASSOC;
				break;
			default:
				$this->fetchMode = SQLITE_BOTH;
				break;
		}
		$this->adodbFetchMode = $mode;

$this->_queryID = $queryID;

$this->_inited = true;
		$this->fields = array();
		if ($queryID) {
			$this->_currentRow = 0;
			$this->EOF = !$this->_fetch();
			@$this->_initrs();
		} else {
			$this->_numOfRows = 0;
			$this->_numOfFields = 0;
			$this->EOF = true;
		}

return $this->_queryID;
	}

function FetchField($fieldOffset = -1)
	{
		$fld = new ADOFieldObject;
		$fld->name = sqlite_field_name($this->_queryID, $fieldOffset);
		$fld->type = 'VARCHAR';
		$fld->max_length = -1;
		return $fld;
	}

function _initrs()
	{
		$this->_numOfRows = @sqlite_num_rows($this->_queryID);
		$this->_numOfFields = @sqlite_num_fields($this->_queryID);
	}

return $this->fields[$this->bind[strtoupper($colname)]];
	}

function _seek($row)
	{
		return sqlite_seek($this->_queryID, $row);
	}

function _fetch($ignore_fields=false)
	{
		$this->fields = @sqlite_fetch_array($this->_queryID,$this->fetchMode);
		return !empty($this->fields);
	}

function _close()
	{
	}

}

Nama File / Folder	Size	Action
adodb-access.inc.php	2.174KB	Hapus Edit Rename
adodb-ado.inc.php	15.918KB	Hapus Edit Rename
adodb-ado5.inc.php	16.979KB	Hapus Edit Rename
adodb-ado_access.inc.php	1.385KB	Hapus Edit Rename
adodb-ado_mssql.inc.php	4.284KB	Hapus Edit Rename
adodb-ads.inc.php	23.069KB	Hapus Edit Rename
adodb-borland_ibase.inc.php	2.217KB	Hapus Edit Rename
adodb-csv.inc.php	4.876KB	Hapus Edit Rename
adodb-db2.inc.php	21.322KB	Hapus Edit Rename
adodb-db2oci.inc.php	4.559KB	Hapus Edit Rename
adodb-db2ora.inc.php	1.929KB	Hapus Edit Rename
adodb-fbsql.inc.php	6.362KB	Hapus Edit Rename
adodb-firebird.inc.php	1.871KB	Hapus Edit Rename
adodb-ibase.inc.php	23.988KB	Hapus Edit Rename
adodb-informix.inc.php	1.023KB	Hapus Edit Rename
adodb-informix72.inc.php	14.561KB	Hapus Edit Rename
adodb-ldap.inc.php	10.86KB	Hapus Edit Rename
adodb-mssql.inc.php	33.798KB	Hapus Edit Rename
adodb-mssql_n.inc.php	9.859KB	Hapus Edit Rename
adodb-mssqlnative.inc.php	35.364KB	Hapus Edit Rename
adodb-mssqlpo.inc.php	1.516KB	Hapus Edit Rename
adodb-mysqli.inc.php	32.434KB	Hapus Edit Rename
adodb-mysqlpo.inc.php	3.098KB	Hapus Edit Rename
adodb-mysqlt.inc.php	3.47KB	Hapus Edit Rename
adodb-oci8.inc.php	46.1KB	Hapus Edit Rename
adodb-oci805.inc.php	1.547KB	Hapus Edit Rename
adodb-oci8po.inc.php	7.157KB	Hapus Edit Rename
adodb-oci8quercus.inc.php	2.383KB	Hapus Edit Rename
adodb-odbc.inc.php	18.832KB	Hapus Edit Rename
adodb-odbc_db2.inc.php	9.151KB	Hapus Edit Rename
adodb-odbc_mssql.inc.php	10.532KB	Hapus Edit Rename
adodb-odbc_oracle.inc.php	3.195KB	Hapus Edit Rename
adodb-odbtp.inc.php	23.293KB	Hapus Edit Rename
adodb-odbtp_unicode.inc.php	1.13KB	Hapus Edit Rename
adodb-oracle.inc.php	9.252KB	Hapus Edit Rename
adodb-pdo.inc.php	16.82KB	Hapus Edit Rename
adodb-pdo_mssql.inc.php	1.496KB	Hapus Edit Rename
adodb-pdo_mysql.inc.php	7.012KB	Hapus Edit Rename
adodb-pdo_oci.inc.php	2.867KB	Hapus Edit Rename
adodb-pdo_pgsql.inc.php	8.331KB	Hapus Edit Rename
adodb-pdo_sqlite.inc.php	5.875KB	Hapus Edit Rename
adodb-pdo_sqlsrv.inc.php	0.989KB	Hapus Edit Rename
adodb-proxy.inc.php	0.864KB	Hapus Edit Rename
adodb-sapdb.inc.php	5.094KB	Hapus Edit Rename
adodb-sqlanywhere.inc.php	4.124KB	Hapus Edit Rename
adodb-sqlite.inc.php	10.445KB	Hapus Edit Rename
adodb-sqlite3.inc.php	10.11KB	Hapus Edit Rename
adodb-sybase.inc.php	12.114KB	Hapus Edit Rename
adodb-sybase_ase.inc.php	3.239KB	Hapus Edit Rename
adodb-text.inc.php	9.783KB	Hapus Edit Rename
adodb-vfp.inc.php	2.436KB	Hapus Edit Rename