===========================================================
.___ __ __
_________________ __ __ __| _/|__|/ |_
/ ___\_` __ \__ \ | | \/ __ | | \\_ __\
/ /_/ > | \// __ \| | / /_/ | | || |
\___ /|__| (____ /____/\____ | |__||__|
/_____/ \/ \/
grep rough audit - static analysis tool
v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
libphp-adodb-5.20.18/adodb-active-record.inc.php-639- $table = $this->TableInfo();
libphp-adodb-5.20.18/adodb-active-record.inc.php:640: $where = $this->GenWhere($db, $table);
libphp-adodb-5.20.18/adodb-active-record.inc.php-641- return($this->Load($where));
##############################################
libphp-adodb-5.20.18/adodb-active-record.inc.php-782- }
libphp-adodb-5.20.18/adodb-active-record.inc.php:783: $this->_where = $where;
libphp-adodb-5.20.18/adodb-active-record.inc.php-784-
##############################################
libphp-adodb-5.20.18/adodb-active-record.inc.php-908-
libphp-adodb-5.20.18/adodb-active-record.inc.php:909: $where = $this->GenWhere($db,$table);
libphp-adodb-5.20.18/adodb-active-record.inc.php-910- $sql = 'DELETE FROM '.$this->_table.' WHERE '.$where;
##############################################
libphp-adodb-5.20.18/adodb-active-record.inc.php-1012-
libphp-adodb-5.20.18/adodb-active-record.inc.php:1013: $where = $this->GenWhere($db, $table);
libphp-adodb-5.20.18/adodb-active-record.inc.php-1014-
##############################################
libphp-adodb-5.20.18/adodb-active-recordx.inc.php-669- $table =& $this->TableInfo();
libphp-adodb-5.20.18/adodb-active-recordx.inc.php:670: $where = $this->GenWhere($db, $table);
libphp-adodb-5.20.18/adodb-active-recordx.inc.php-671- return($this->Load($where));
##############################################
libphp-adodb-5.20.18/adodb-active-recordx.inc.php-818- }
libphp-adodb-5.20.18/adodb-active-recordx.inc.php:819: $this->_where = $where;
libphp-adodb-5.20.18/adodb-active-recordx.inc.php-820-
##############################################
libphp-adodb-5.20.18/adodb-active-recordx.inc.php-1023-
libphp-adodb-5.20.18/adodb-active-recordx.inc.php:1024: $where = $this->GenWhere($db,$table);
libphp-adodb-5.20.18/adodb-active-recordx.inc.php-1025- $sql = 'DELETE FROM '.$this->_table.' WHERE '.$where;
##############################################
libphp-adodb-5.20.18/adodb-active-recordx.inc.php-1141-
libphp-adodb-5.20.18/adodb-active-recordx.inc.php:1142: $where = $this->GenWhere($db, $table);
libphp-adodb-5.20.18/adodb-active-recordx.inc.php-1143-
##############################################
libphp-adodb-5.20.18/adodb-datadict.inc.php-121- $tokarr = array();
libphp-adodb-5.20.18/adodb-datadict.inc.php:122: if ($ch == '`') $tokarr[] = '`';
libphp-adodb-5.20.18/adodb-datadict.inc.php-123- }
##############################################
libphp-adodb-5.20.18/adodb-error.inc.php-57- else {
libphp-adodb-5.20.18/adodb-error.inc.php:58: include_once(ADODB_DIR."/lang/adodb-$ADODB_LANG.inc.php");
libphp-adodb-5.20.18/adodb-error.inc.php-59- }
##############################################
libphp-adodb-5.20.18/adodb-lib.inc.php-164- if (isset($fieldArray[$v])) {
libphp-adodb-5.20.18/adodb-lib.inc.php:165: if ($where) $where .= ' and '.$v.'='.$fieldArray[$v];
libphp-adodb-5.20.18/adodb-lib.inc.php:166: else $where = $v.'='.$fieldArray[$v];
libphp-adodb-5.20.18/adodb-lib.inc.php-167- }
##############################################
libphp-adodb-5.20.18/adodb-pear.inc.php-111- {
libphp-adodb-5.20.18/adodb-pear.inc.php:112: include_once(ADODB_DIR."/drivers/adodb-$type.inc.php");
libphp-adodb-5.20.18/adodb-pear.inc.php-113- $obj = NewADOConnection($type);
##############################################
libphp-adodb-5.20.18/adodb-pear.inc.php-152- // expose php errors with sufficient debug level
libphp-adodb-5.20.18/adodb-pear.inc.php:153: @include_once("adodb-$type.inc.php");
libphp-adodb-5.20.18/adodb-pear.inc.php-154- } else {
libphp-adodb-5.20.18/adodb-pear.inc.php:155: @include_once("adodb-$type.inc.php");
libphp-adodb-5.20.18/adodb-pear.inc.php-156- }
##############################################
libphp-adodb-5.20.18/adodb-perf.inc.php-41-
libphp-adodb-5.20.18/adodb-perf.inc.php:42: exec('tasklist /FI "PID eq ' . $pid. '" /FO LIST', $output);
libphp-adodb-5.20.18/adodb-perf.inc.php-43- return substr($output[5], strpos($output[5], ':') + 1);
##############################################
libphp-adodb-5.20.18/adodb-perf.inc.php-46- /* Hopefully UNIX */
libphp-adodb-5.20.18/adodb-perf.inc.php:47: exec("ps --pid $pid --no-headers -o%mem,size", $output);
libphp-adodb-5.20.18/adodb-perf.inc.php-48- if (sizeof($output) == 0) return 0;
##############################################
libphp-adodb-5.20.18/adodb-perf.inc.php-400-"select count(*),tracer
libphp-adodb-5.20.18/adodb-perf.inc.php:401: from $perf_table where sql1=$sqlq
libphp-adodb-5.20.18/adodb-perf.inc.php-402- group by tracer
##############################################
libphp-adodb-5.20.18/adodb-perf.inc.php-459- $partial = !empty($_GET['part']);
libphp-adodb-5.20.18/adodb-perf.inc.php:460: echo "<a name=explain></a>".$this->Explain($_GET['sql'],$partial)."\n";
libphp-adodb-5.20.18/adodb-perf.inc.php-461- }
##############################################
libphp-adodb-5.20.18/adodb-perf.inc.php-538- $partial = !empty($_GET['part']);
libphp-adodb-5.20.18/adodb-perf.inc.php:539: echo "<a name=explain></a>".$this->Explain($_GET['sql'],$partial)."\n";
libphp-adodb-5.20.18/adodb-perf.inc.php-540- }
##############################################
libphp-adodb-5.20.18/adodb-xmlschema.inc.php-506- if( !isset( $this->fields[$field_id] ) ) {
libphp-adodb-5.20.18/adodb-xmlschema.inc.php:507: $sql[] = $xmls->dict->DropColumnSQL( $this->name, '`'.$field->name.'`' );
libphp-adodb-5.20.18/adodb-xmlschema.inc.php-508- }
##############################################
libphp-adodb-5.20.18/adodb-xmlschema03.inc.php-1026- if( $where ) $where .= ' AND ';
libphp-adodb-5.20.18/adodb-xmlschema03.inc.php:1027: $where .= $key . ' = ' . $xmls->db->qstr( $mfields[$key] );
libphp-adodb-5.20.18/adodb-xmlschema03.inc.php-1028- }
##############################################
libphp-adodb-5.20.18/adodb.inc.php-2145- */
libphp-adodb-5.20.18/adodb.inc.php:2146: function AutoExecute($table, $fields_values, $mode = 'INSERT', $where = false, $forceUpdate = true, $magicq = false) {
libphp-adodb-5.20.18/adodb.inc.php:2147: if ($where === false && ($mode == 'UPDATE' || $mode == 2 /* DB_AUTOQUERY_UPDATE */) ) {
libphp-adodb-5.20.18/adodb.inc.php-2148- $this->outp_throw('AutoExecute: Illegal mode=UPDATE with empty WHERE clause', 'AutoExecute');
##############################################
libphp-adodb-5.20.18/adodb.inc.php-4748- $file = "drivers/adodb-$db.inc.php";
libphp-adodb-5.20.18/adodb.inc.php:4749: @include_once(ADODB_DIR . '/' . $file);
libphp-adodb-5.20.18/adodb.inc.php-4750- $ADODB_LASTDB = $class;
##############################################
libphp-adodb-5.20.18/adodb.inc.php-5027- include_once(ADODB_DIR.'/adodb-perf.inc.php');
libphp-adodb-5.20.18/adodb.inc.php:5028: @include_once(ADODB_DIR."/perf/perf-$drivername.inc.php");
libphp-adodb-5.20.18/adodb.inc.php-5029- $class = "Perf_$drivername";
##############################################
libphp-adodb-5.20.18/adodb.inc.php-5050- }
libphp-adodb-5.20.18/adodb.inc.php:5051: include_once($path);
libphp-adodb-5.20.18/adodb.inc.php-5052- $class = "ADODB2_$drivername";
##############################################
libphp-adodb-5.20.18/datadict/datadict-mssqlnative.inc.php-153- "SELECT name FROM sys.default_constraints
libphp-adodb-5.20.18/datadict/datadict-mssqlnative.inc.php:154: WHERE object_name(parent_object_id) = '$tabname'
libphp-adodb-5.20.18/datadict/datadict-mssqlnative.inc.php-155- AND col_name(parent_object_id, parent_column_id) = '$colname'"
##############################################
libphp-adodb-5.20.18/datadict/datadict-oci8.inc.php-291- $col = $this->connection->qstr($col);
libphp-adodb-5.20.18/datadict/datadict-oci8.inc.php:292: return "select comments from USER_COL_COMMENTS where TABLE_NAME=$table and COLUMN_NAME=$col";
libphp-adodb-5.20.18/datadict/datadict-oci8.inc.php-293- }
##############################################
libphp-adodb-5.20.18/datadict/datadict-postgres.inc.php-389- // check if a tables depends on the sequenz and it therefor cant and dont need to be droped separatly
libphp-adodb-5.20.18/datadict/datadict-postgres.inc.php:390: if (!$seq || $this->connection->GetOne("SELECT relname FROM pg_class JOIN pg_depend ON pg_class.relfilenode=pg_depend.objid WHERE relname='$seq' AND relkind='S' AND deptype='i'")) {
libphp-adodb-5.20.18/datadict/datadict-postgres.inc.php-391- return False;
##############################################
libphp-adodb-5.20.18/docs/changelog.md-249-- sqlite3: Modified to support php 5.4. Thx Günter Weber [built.development#googlemail.com]
libphp-adodb-5.20.18/docs/changelog.md:250:- adodb: When fetch mode is ADODB_FETCH_ASSOC, and we execute `$db->GetAssoc("select 'a','0'");` we get an error. Fixed. See http://phplens.com/lens/lensforum/msgs.php?id=19190
libphp-adodb-5.20.18/docs/changelog.md-251-- adodb: Caching directory permissions now configurable using global variable $ADODB_CACHE_PERMS. Default value is 0771.
##############################################
libphp-adodb-5.20.18/docs/changelog.md-427-- The rs2html() function in tohtml.inc.php did not handle dates with ':' in it properly. Fixed. (also in 4.991)
libphp-adodb-5.20.18/docs/changelog.md:428:- Added support for connecting to oci8 using `$DB->Connect($ip, $user, $pwd, "SID=$sid");` (also in 4.991)
libphp-adodb-5.20.18/docs/changelog.md-429-- Added mysql type 'VAR_STRING' to MetaType(). (also in 4.991)
##############################################
libphp-adodb-5.20.18/docs/changelog.md-456-- Fixed sybase driver SQLDate to use str_replace(). Also for adodb5, changed sybase driver UnixDate and UnixTimeStamp calls to static.
libphp-adodb-5.20.18/docs/changelog.md:457:- Changed oci8 lob handler to use & reference `$this->_refLOBs[$numlob]['VAR'] = &$var`.
libphp-adodb-5.20.18/docs/changelog.md-458-- We now strtolower the get_class() function in PEAR::isError() for php5 compat.
##############################################
libphp-adodb-5.20.18/docs/changelog.md-550-- CacheFlush no longer deletes all files/directories. Only *.cache files deleted.
libphp-adodb-5.20.18/docs/changelog.md:551:- DB2 timestamp format changed to `var $fmtTimeStamp = "'Y-m-d-H:i:s'";`
libphp-adodb-5.20.18/docs/changelog.md-552-- Added some code sanitization to AutoExecute in adodb-lib.inc.php.
##############################################
libphp-adodb-5.20.18/docs/changelog_v4.x.md-213-- Thanks to Halmai Csongor for suggestion.
libphp-adodb-5.20.18/docs/changelog_v4.x.md:214:- Removed `$off = $fieldOffset - 1` line in db2 driver, FetchField(). Tx Larry Menard.
libphp-adodb-5.20.18/docs/changelog_v4.x.md-215-- Added support for PHP5 objects as Execute() bind parameters using `__toString` (eg. Simple-XML). Thx Carl-Christian Salvesen.
##############################################
libphp-adodb-5.20.18/docs/changelog_v4.x.md-237-- Added activerecord support.
libphp-adodb-5.20.18/docs/changelog_v4.x.md:238:- Added mysql `$conn->compat323 = true` if you want MySQL 3.23 compat enabled. Fixes GetOne() Select-Limit problems.
libphp-adodb-5.20.18/docs/changelog_v4.x.md-239-- Added adodb-xmlschema03.inc.php to support XML Schema version 3 and updated adodb-datadict.htm docs.
##############################################
libphp-adodb-5.20.18/docs/changelog_v4.x.md-270-- Fixed http://phplens.com/lens/lensforum/msgs.php?id=14254 in adodb-perf.inc.php, `_DBParameter()` settings of fetchmode was wrong.
libphp-adodb-5.20.18/docs/changelog_v4.x.md:271:- Fixed security issues in server.php and tmssql.php discussed by Andreas Sandblad in a Secunia security advisory. Added `$ACCEPTIP = 127.0.0.1` and changed suggested root password to something more secure.
libphp-adodb-5.20.18/docs/changelog_v4.x.md-272-- Changed pager to close recordset after RenderLayout().
##############################################
libphp-adodb-5.20.18/docs/changelog_v4.x.md-420-- RSFilter now accepts methods of the form $array($obj, 'methodname'). Thx to blake#near-time.com.
libphp-adodb-5.20.18/docs/changelog_v4.x.md:421:- Changed CacheFlush to `$cmd = 'rm -rf '.$ADODB_CACHE_DIR.'/[0-9a-f][0-9a-f]/';`
libphp-adodb-5.20.18/docs/changelog_v4.x.md-422-- For better cursor concurrency, added code to free ref cursors in oci8 when $rs->Close() is called. Note that CLose() is called internally by the Get* functions too.
##############################################
libphp-adodb-5.20.18/drivers/adodb-ads.inc.php-294- {
libphp-adodb-5.20.18/drivers/adodb-ads.inc.php:295: $recordSet = $this->Execute("select table_primary_key from system.tables where name='$table'");
libphp-adodb-5.20.18/drivers/adodb-ads.inc.php-296- if(!$recordSet){
##############################################
libphp-adodb-5.20.18/drivers/adodb-ads.inc.php-486- {
libphp-adodb-5.20.18/drivers/adodb-ads.inc.php:487: $recordSet = $this->Execute("select name from system.columns where parent='$table'");
libphp-adodb-5.20.18/drivers/adodb-ads.inc.php-488- if(!$recordSet){
##############################################
libphp-adodb-5.20.18/drivers/adodb-ads.inc.php-554-
libphp-adodb-5.20.18/drivers/adodb-ads.inc.php:555: $stmtid = ads_exec($this->_connectionID,$sql);
libphp-adodb-5.20.18/drivers/adodb-ads.inc.php-556-
##############################################
libphp-adodb-5.20.18/drivers/adodb-db2.inc.php-656- } else
libphp-adodb-5.20.18/drivers/adodb-db2.inc.php:657: $stmtid = @db2_exec($this->_connectionID,$sql);
libphp-adodb-5.20.18/drivers/adodb-db2.inc.php-658-
##############################################
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php-43- //OPN STUFF start
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php:44: var $metaColumnsSQL = "select a.rdb\$field_name, a.rdb\$null_flag, a.rdb\$default_source, b.rdb\$field_length, b.rdb\$field_scale, b.rdb\$field_sub_type, b.rdb\$field_precision, b.rdb\$field_type from rdb\$relation_fields a, rdb\$fields b where a.rdb\$field_source = b.rdb\$field_name and a.rdb\$relation_name = '%s' order by a.rdb\$field_position asc";
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php-45- //OPN STUFF end
##############################################
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php-121- FROM RDB$INDICES I JOIN RDB$INDEX_SEGMENTS S ON I.RDB$INDEX_NAME=S.RDB$INDEX_NAME
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php:122: WHERE I.RDB$RELATION_NAME=\''.$table.'\' and I.RDB$INDEX_NAME like \'RDB$PRIMARY%\'
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php-123- ORDER BY I.RDB$INDEX_NAME,S.RDB$FIELD_POSITION';
##############################################
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php-216- $table = strtoupper($table);
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php:217: $sql = "SELECT * FROM RDB\$INDICES WHERE RDB\$RELATION_NAME = '".$table."'";
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php-218- if (!$primary) {
##############################################
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php-245- }
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php:246: $sql = "SELECT * FROM RDB\$INDEX_SEGMENTS WHERE RDB\$INDEX_NAME = '".$index."' ORDER BY RDB\$FIELD_POSITION ASC";
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php-247- $rs1 = $this->Execute($sql);
##############################################
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php-282- $seqname = strtoupper($seqname);
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php:283: $this->Execute("delete from RDB\$GENERATORS where RDB\$GENERATOR_NAME='$seqname'");
libphp-adodb-5.20.18/drivers/adodb-ibase.inc.php-284- }
##############################################
libphp-adodb-5.20.18/drivers/adodb-informix72.inc.php-261- sysreferences r,systables tr,sysconstraints s2,sysindexes i2
libphp-adodb-5.20.18/drivers/adodb-informix72.inc.php:262: where t.tabname='$table'
libphp-adodb-5.20.18/drivers/adodb-informix72.inc.php-263- and s.tabid=t.tabid and s.constrtype='R' and r.constrid=s.constrid
##############################################
libphp-adodb-5.20.18/drivers/adodb-mssql.inc.php-448- INNER JOIN dbo.syscolumns c ON K.id = C.id AND K.colid = C.Colid
libphp-adodb-5.20.18/drivers/adodb-mssql.inc.php:449: WHERE LEFT(i.name, 8) <> '_WA_Sys_' AND o.status >= 0 AND O.Name LIKE $table
libphp-adodb-5.20.18/drivers/adodb-mssql.inc.php-450- ORDER BY O.name, I.Name, K.keyno";
##############################################
libphp-adodb-5.20.18/drivers/adodb-mssql.inc.php-492-from sysforeignkeys
libphp-adodb-5.20.18/drivers/adodb-mssql.inc.php:493:where upper(object_name(fkeyid)) = $table
libphp-adodb-5.20.18/drivers/adodb-mssql.inc.php-494-order by constraint_name, referenced_table_name, keyno";
##############################################
libphp-adodb-5.20.18/drivers/adodb-mssqlnative.inc.php-625- INNER JOIN dbo.syscolumns c ON K.id = C.id AND K.colid = C.Colid
libphp-adodb-5.20.18/drivers/adodb-mssqlnative.inc.php:626: WHERE LEFT(i.name, 8) <> '_WA_Sys_' AND o.status >= 0 AND O.Name LIKE $table
libphp-adodb-5.20.18/drivers/adodb-mssqlnative.inc.php-627- ORDER BY O.name, I.Name, K.keyno";
##############################################
libphp-adodb-5.20.18/drivers/adodb-mssqlnative.inc.php-669- from sysforeignkeys
libphp-adodb-5.20.18/drivers/adodb-mssqlnative.inc.php:670: where upper(object_name(fkeyid)) = $table
libphp-adodb-5.20.18/drivers/adodb-mssqlnative.inc.php-671- order by constraint_name, referenced_table_name, keyno";
##############################################
libphp-adodb-5.20.18/drivers/adodb-mysql.inc.php-604-
libphp-adodb-5.20.18/drivers/adodb-mysql.inc.php:605: return mysql_query($sql,$this->_connectionID);
libphp-adodb-5.20.18/drivers/adodb-mysql.inc.php-606- /*
##############################################
libphp-adodb-5.20.18/drivers/adodb-mysql.inc.php-608- if($ADODB_COUNTRECS)
libphp-adodb-5.20.18/drivers/adodb-mysql.inc.php:609: return mysql_query($sql,$this->_connectionID);
libphp-adodb-5.20.18/drivers/adodb-mysql.inc.php-610- else
##############################################
libphp-adodb-5.20.18/drivers/adodb-mysqli.inc.php-217- if ($this->transCnt==0) $this->BeginTrans();
libphp-adodb-5.20.18/drivers/adodb-mysqli.inc.php:218: if ($where) $where = ' where '.$where;
libphp-adodb-5.20.18/drivers/adodb-mysqli.inc.php-219- $rs = $this->Execute("select $col from $tables $where for update");
##############################################
libphp-adodb-5.20.18/drivers/adodb-mysqlpo.inc.php-71- if ($this->transCnt==0) $this->BeginTrans();
libphp-adodb-5.20.18/drivers/adodb-mysqlpo.inc.php:72: if ($where) $where = ' where '.$where;
libphp-adodb-5.20.18/drivers/adodb-mysqlpo.inc.php-73- $rs = $this->Execute("select $col from $tables $where for update");
##############################################
libphp-adodb-5.20.18/drivers/adodb-mysqlt.inc.php-85- if ($this->transCnt==0) $this->BeginTrans();
libphp-adodb-5.20.18/drivers/adodb-mysqlt.inc.php:86: if ($where) $where = ' where '.$where;
libphp-adodb-5.20.18/drivers/adodb-mysqlt.inc.php-87- $rs = $this->Execute("select $col from $tables $where for update");
##############################################
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php-430-
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php:431: $rs = $this->Execute(sprintf("SELECT * FROM ALL_CONSTRAINTS WHERE UPPER(TABLE_NAME)='%s' AND CONSTRAINT_TYPE='P'",$table));
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php-432- if (!is_object($rs)) {
##############################################
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php-451-
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php:452: $rs = $this->Execute(sprintf("SELECT ALL_INDEXES.INDEX_NAME, ALL_INDEXES.UNIQUENESS, ALL_IND_COLUMNS.COLUMN_POSITION, ALL_IND_COLUMNS.COLUMN_NAME FROM ALL_INDEXES,ALL_IND_COLUMNS WHERE UPPER(ALL_INDEXES.TABLE_NAME)='%s' AND ALL_IND_COLUMNS.INDEX_NAME=ALL_INDEXES.INDEX_NAME",$table));
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php-453-
##############################################
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php-852-
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php:853: //if (strlen($val) < 4000) return $this->Execute("UPDATE $table SET $column=:blob WHERE $where",array('blob'=>$val)) != false;
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php-854-
##############################################
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php-1421- , {$ptab}CONS_COLUMNS b
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php:1422: WHERE ( UPPER(b.table_name) = ('$table'))
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php-1423- AND (UPPER(a.table_name) = ('$table') and a.constraint_type = 'P')
##############################################
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php-1466- from {$tabp}constraints
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php:1467: where constraint_type = 'R' and table_name = $table $owner";
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php-1468-
##############################################
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php-1474- $rcons = $this->qstr($constr[2]);
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php:1475: $cols = $this->GetArray("select column_name from {$tabp}cons_columns where constraint_name=$cons $owner order by position");
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php:1476: $tabcol = $this->GetArray("select table_name,column_name from {$tabp}cons_columns where owner=$rowner and constraint_name=$rcons order by position");
libphp-adodb-5.20.18/drivers/adodb-oci8.inc.php-1477-
##############################################
libphp-adodb-5.20.18/drivers/adodb-oci805.inc.php-39- if ($offset > 0) $nrows += $offset;
libphp-adodb-5.20.18/drivers/adodb-oci805.inc.php:40: $sql = "select * from ($sql) where rownum <= $nrows";
libphp-adodb-5.20.18/drivers/adodb-oci805.inc.php-41- $nrows = -1;
##############################################
libphp-adodb-5.20.18/drivers/adodb-odbc.inc.php-159- }
libphp-adodb-5.20.18/drivers/adodb-odbc.inc.php:160: $this->Execute("update $seq set id=id+1 where id=$num");
libphp-adodb-5.20.18/drivers/adodb-odbc.inc.php-161-
##############################################
libphp-adodb-5.20.18/drivers/adodb-odbc.inc.php-536- } else
libphp-adodb-5.20.18/drivers/adodb-odbc.inc.php:537: $stmtid = odbc_exec($this->_connectionID,$sql);
libphp-adodb-5.20.18/drivers/adodb-odbc.inc.php-538-
##############################################
libphp-adodb-5.20.18/drivers/adodb-odbc_db2.inc.php-200- $table = strtoupper($table);
libphp-adodb-5.20.18/drivers/adodb-odbc_db2.inc.php:201: $SQL="SELECT NAME, UNIQUERULE, COLNAMES FROM SYSIBM.SYSINDEXES WHERE TBNAME='$table'";
libphp-adodb-5.20.18/drivers/adodb-odbc_db2.inc.php-202- if ($primary)
##############################################
libphp-adodb-5.20.18/drivers/adodb-odbc_mssql.inc.php-99-from sysforeignkeys
libphp-adodb-5.20.18/drivers/adodb-odbc_mssql.inc.php:100:where upper(object_name(fkeyid)) = $table
libphp-adodb-5.20.18/drivers/adodb-odbc_mssql.inc.php-101-order by constraint_name, referenced_table_name, keyno";
##############################################
libphp-adodb-5.20.18/drivers/adodb-odbc_mssql.inc.php-207- INNER JOIN dbo.syscolumns c ON K.id = C.id AND K.colid = C.Colid
libphp-adodb-5.20.18/drivers/adodb-odbc_mssql.inc.php:208: WHERE LEFT(i.name, 8) <> '_WA_Sys_' AND o.status >= 0 AND O.Name LIKE $table
libphp-adodb-5.20.18/drivers/adodb-odbc_mssql.inc.php-209- ORDER BY O.name, I.Name, K.keyno";
##############################################
libphp-adodb-5.20.18/drivers/adodb-odbtp.inc.php-116- }
libphp-adodb-5.20.18/drivers/adodb-odbtp.inc.php:117: $num = $this->GetOne("select seq_value from adodb_seq where seq_name='$seqname'");
libphp-adodb-5.20.18/drivers/adodb-odbtp.inc.php-118- if ($num) {
##############################################
libphp-adodb-5.20.18/drivers/adodb-odbtp.inc.php-142- while (--$MAXLOOPS>=0) {
libphp-adodb-5.20.18/drivers/adodb-odbtp.inc.php:143: $num = $this->GetOne("select seq_value from adodb_seq where seq_name='$seq'");
libphp-adodb-5.20.18/drivers/adodb-odbtp.inc.php-144- if ($num === false) {
##############################################
libphp-adodb-5.20.18/drivers/adodb-odbtp.inc.php-155- }
libphp-adodb-5.20.18/drivers/adodb-odbtp.inc.php:156: $ok = $this->Execute("update adodb_seq set seq_value=seq_value+1 where seq_name='$seq'");
libphp-adodb-5.20.18/drivers/adodb-odbtp.inc.php-157- if($ok) {
##############################################
libphp-adodb-5.20.18/drivers/adodb-odbtp.inc.php-568- INNER JOIN dbo.syscolumns c ON K.id = C.id AND K.colid = C.Colid
libphp-adodb-5.20.18/drivers/adodb-odbtp.inc.php:569: WHERE LEFT(i.name, 8) <> '_WA_Sys_' AND o.status >= 0 AND lower(O.Name) = $table
libphp-adodb-5.20.18/drivers/adodb-odbtp.inc.php-570- ORDER BY O.name, I.Name, K.keyno";
##############################################
libphp-adodb-5.20.18/drivers/adodb-oracle.inc.php-192- if (!ora_parse($curs,$sql)) return false;
libphp-adodb-5.20.18/drivers/adodb-oracle.inc.php:193: if (ora_exec($curs)) return $curs;
libphp-adodb-5.20.18/drivers/adodb-oracle.inc.php-194- // <G. Giunta 2004/03/03> before we close the cursor, we have to store the error message
##############################################
libphp-adodb-5.20.18/drivers/adodb-pdo.inc.php-186- case 'sqlsrv':
libphp-adodb-5.20.18/drivers/adodb-pdo.inc.php:187: include_once(ADODB_DIR.'/drivers/adodb-pdo_'.$this->dsnType.'.inc.php');
libphp-adodb-5.20.18/drivers/adodb-pdo.inc.php-188- break;
##############################################
libphp-adodb-5.20.18/drivers/adodb-postgres64.inc.php-169- // to really return the id, we need the table and column-name, else we can only return the oid != id
libphp-adodb-5.20.18/drivers/adodb-postgres64.inc.php:170: return empty($table) || empty($column) ? $oid : $this->GetOne("SELECT $column FROM $table WHERE oid=".(int)$oid);
libphp-adodb-5.20.18/drivers/adodb-postgres64.inc.php-171- }
##############################################
libphp-adodb-5.20.18/drivers/adodb-postgres64.inc.php-1000- if ($blob === NULL) return NULL;
libphp-adodb-5.20.18/drivers/adodb-postgres64.inc.php:1001:// eval('$realblob="'.adodb_str_replace(array('"','$'),array('\"','\$'),$blob).'";');
libphp-adodb-5.20.18/drivers/adodb-postgres64.inc.php-1002- return pg_unescape_bytea($blob);
##############################################
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php-54-
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php:55: return $this->GetCol("SELECT columnname FROM COLUMNS WHERE tablename=$table AND mode='KEY' ORDER BY pos");
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php-56- }
##############################################
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php-62- $sql = "SELECT INDEXNAME,TYPE,COLUMNNAME FROM INDEXCOLUMNS ".
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php:63: " WHERE TABLENAME=$table".
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php-64- " ORDER BY INDEXNAME,COLUMNNO";
##############################################
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php-90- 'unique' => True, // by definition
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php:91: 'columns' => $this->GetCol("SELECT columnname FROM COLUMNS WHERE tablename=$table AND mode='KEY' ORDER BY pos"),
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php-92- );
##############################################
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php-107- $retarr = array();
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php:108: foreach($this->GetAll("SELECT COLUMNNAME,DATATYPE,LEN,DEC,NULLABLE,MODE,\"DEFAULT\",CASE WHEN \"DEFAULT\" IS NULL THEN 0 ELSE 1 END AS HAS_DEFAULT FROM COLUMNS WHERE tablename=$table ORDER BY pos") as $column)
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php-109- {
##############################################
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php-148-
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php:149: return $this->GetCol("SELECT columnname FROM COLUMNS WHERE tablename=$table ORDER BY pos");
libphp-adodb-5.20.18/drivers/adodb-sapdb.inc.php-150- }
##############################################
libphp-adodb-5.20.18/drivers/adodb-sqlite.inc.php-202-
libphp-adodb-5.20.18/drivers/adodb-sqlite.inc.php:203: $this->_connectionID = sqlite_popen($argHostname);
libphp-adodb-5.20.18/drivers/adodb-sqlite.inc.php-204- if ($this->_connectionID === false) {
##############################################
libphp-adodb-5.20.18/drivers/adodb-sqlite.inc.php-266- }
libphp-adodb-5.20.18/drivers/adodb-sqlite.inc.php:267: $this->Execute("update $seq set id=id+1 where id=$num");
libphp-adodb-5.20.18/drivers/adodb-sqlite.inc.php-268-
##############################################
libphp-adodb-5.20.18/drivers/adodb-sqlite.inc.php-318- }
libphp-adodb-5.20.18/drivers/adodb-sqlite.inc.php:319: $SQL=sprintf("SELECT name,sql FROM sqlite_master WHERE type='index' AND tbl_name='%s'", strtolower($table));
libphp-adodb-5.20.18/drivers/adodb-sqlite.inc.php-320- $rs = $this->Execute($SQL);
##############################################
libphp-adodb-5.20.18/drivers/adodb-sqlite3.inc.php-249- }
libphp-adodb-5.20.18/drivers/adodb-sqlite3.inc.php:250: $this->Execute("update $seq set id=id+1 where id=$num");
libphp-adodb-5.20.18/drivers/adodb-sqlite3.inc.php-251-
##############################################
libphp-adodb-5.20.18/drivers/adodb-sqlite3.inc.php-301- }
libphp-adodb-5.20.18/drivers/adodb-sqlite3.inc.php:302: $SQL=sprintf("SELECT name,sql FROM sqlite_master WHERE type='index' AND tbl_name='%s'", strtolower($table));
libphp-adodb-5.20.18/drivers/adodb-sqlite3.inc.php-303- $rs = $this->Execute($SQL);
##############################################
libphp-adodb-5.20.18/drivers/adodb-sybase.inc.php-288- "FROM syscolumn c, systable t " .
libphp-adodb-5.20.18/drivers/adodb-sybase.inc.php:289: "WHERE t.table_name='$table' AND c.table_id=t.table_id " .
libphp-adodb-5.20.18/drivers/adodb-sybase.inc.php-290- "AND t.table_type='BASE' " .
##############################################
libphp-adodb-5.20.18/drivers/adodb-text.inc.php-216- else {
libphp-adodb-5.20.18/drivers/adodb-text.inc.php:217: eval($eval);
libphp-adodb-5.20.18/drivers/adodb-text.inc.php-218- //print " $i: result=$rez arr[0]={$arr[0]} arr[1]={$arr[1]} <BR>\n ";
##############################################
libphp-adodb-5.20.18/pear/Auth/Container/ADOdb.php-241- " FROM ".$this->options['table'].
libphp-adodb-5.20.18/pear/Auth/Container/ADOdb.php:242: " WHERE ".$this->options['usernamecol']." = " . $this->db->Quote($username);
libphp-adodb-5.20.18/pear/Auth/Container/ADOdb.php-243-
##############################################
libphp-adodb-5.20.18/pear/auth_adodb_example.php-6-?>
libphp-adodb-5.20.18/pear/auth_adodb_example.php:7: <form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>">
libphp-adodb-5.20.18/pear/auth_adodb_example.php-8- <input type="text" name="username">
##############################################
libphp-adodb-5.20.18/perf/perf-db2.inc.php-83- else {
libphp-adodb-5.20.18/perf/perf-db2.inc.php:84: $rs = $this->conn->Execute("select * from explain_statement where queryno=$qno");
libphp-adodb-5.20.18/perf/perf-db2.inc.php-85- if ($rs) rs2html($rs);
##############################################
libphp-adodb-5.20.18/perf/perf-oci8.inc.php-571- $partial = empty($_GET['part']);
libphp-adodb-5.20.18/perf/perf-oci8.inc.php:572: echo "<a name=explain></a>".$this->Explain($_GET['sql'],$partial)."\n";
libphp-adodb-5.20.18/perf/perf-oci8.inc.php-573- }
##############################################
libphp-adodb-5.20.18/perf/perf-oci8.inc.php-645- $partial = empty($_GET['part']);
libphp-adodb-5.20.18/perf/perf-oci8.inc.php:646: echo "<a name=explain></a>".$this->Explain($_GET['sql'],$partial)."\n";
libphp-adodb-5.20.18/perf/perf-oci8.inc.php-647- }
##############################################
libphp-adodb-5.20.18/perf/perf-postgres.inc.php-46- 'data cache hit ratio' => array('RATIO',
libphp-adodb-5.20.18/perf/perf-postgres.inc.php:47: "select case when blks_hit=0 then 0 else round( ((1-blks_read::float/blks_hit)*100)::numeric, 2) end from pg_stat_database where datname='\$DATABASE'",
libphp-adodb-5.20.18/perf/perf-postgres.inc.php-48- '=WarnCacheRatio'),
##############################################
libphp-adodb-5.20.18/pivottable.inc.php-43-
libphp-adodb-5.20.18/pivottable.inc.php:44: if ($where) $where = "\nWHERE $where";
libphp-adodb-5.20.18/pivottable.inc.php-45- if (!is_array($colfield)) $colarr = $db->GetCol("select distinct $colfield from $tables $where order by 1");
##############################################
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-199- else $s = $srcdb->qstr($ds);
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php:200: $where = "WHERE $lastUpdateFld = $s and $where";
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-201- } else
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php:202: $where = "WHERE $where";
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-203- $fn = $this->updateSrcFn;
##############################################
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-374-
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php:375: $where = where clause for SELECT from $table $where. Include the WHERE reserved word in beginning.
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-376- You can put ORDER BY at the end also
##############################################
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-532-
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php:533: function ReplicateData($table, $desttable = '', $uniqflds = array(), $where = '',$ignore_flds = array(),
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-534- $dstCopyDateFld='', $extraflds = array(), $lastUpdateFld = '')
##############################################
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-622- if ($name2 && $name2[0] == '"' && $name2[strlen($name2)-1] == '"') $name22 = substr($name2,1,strlen($name2)-2);
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php:623: elseif ($name2 && $name2[0] == '`' && $name2[strlen($name2)-1] == '`') $name22 = substr($name2,1,strlen($name2)-2);
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-624- else $name22 = $name2;
##############################################
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-765- if ($deleteFirst && $this->deleteFirst) {
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php:766: $where = preg_replace('/[ \n\r\t]+order[ \n\r\t]+by.*$/i', '', $where);
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-767- $sql = "DELETE FROM $desttable $wheredest\n";
##############################################
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-1021- JOIN Deleted as D ON I.$pk = D.$pk
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php:1022: WHERE I.$srcCopyFlagFld = D.$srcCopyFlagFld or I.$srcCopyFlagFld = $arrv2
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-1023- or I.$srcCopyFlagFld = $arrv3 or I.$srcCopyFlagFld is null
##############################################
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-1115- if (empty($whereClauses)) $whereClauses = '1=1';
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php:1116: $where = " WHERE ($whereClauses) and ($srcCopyFlagFld = ".$src->qstr($flagvals[1]).')';
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php:1117: if ($orderBy) $where .= ' '.$orderBy;
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php:1118: else $where .= ' ORDER BY '.$srcUpdateDateFld;
libphp-adodb-5.20.18/replicate/adodb-replicate.inc.php-1119-
##############################################
libphp-adodb-5.20.18/replicate/replicate-steps.php-31- $QTY_BA = " and qu_bacode='$BA'";
libphp-adodb-5.20.18/replicate/replicate-steps.php:32: if (1) $STP_BA = " and s_stagecat in (select stg_stagecat from kbstage where stg_bacode='$BA')"; # OLDER KBSTEP
libphp-adodb-5.20.18/replicate/replicate-steps.php-33- else $STP_BA = " and s_bacode='$BA'"; # LATEST KBSTEP format
##############################################
libphp-adodb-5.20.18/replicate/replicate-steps.php-86-delete from kbqtype where qu_mode in ('STAGE','STEP') $QTY_BA $QTY_STG;
libphp-adodb-5.20.18/replicate/replicate-steps.php:87:delete from kbstep where (1=1) $STP_BA$STP_STG;
libphp-adodb-5.20.18/replicate/replicate-steps.php:88:delete from kbstage where (1=1)$STG_BA$STG_STG;
libphp-adodb-5.20.18/replicate/replicate-steps.php-89-
##############################################
libphp-adodb-5.20.18/replicate/replicate-steps.php-104- // src table name, dst table name, primary key, where condition
libphp-adodb-5.20.18/replicate/replicate-steps.php:105:$rep->ReplicateData('KBSTAGE', 'KBSTAGE', array(), " where (1=1)$STG_BA$STG_STG");
libphp-adodb-5.20.18/replicate/replicate-steps.php:106:$rep->ReplicateData('KBSTEP', 'KBSTEP', array(), " where (1=1)$STP_BA$STP_STG");
libphp-adodb-5.20.18/replicate/replicate-steps.php-107-$rep->ReplicateData('KBQTYPE','KBQTYPE',array()," where qu_mode in ('STAGE','STEP')$QTY_BA$QTY_STG");
##############################################
libphp-adodb-5.20.18/session/adodb-sess.txt-81-* In ADODB_Session::destroy(), since "SELECT expireref, sesskey FROM $table
libphp-adodb-5.20.18/session/adodb-sess.txt:82:WHERE sesskey = $qkey" will only return a single value, we don't loop on the
libphp-adodb-5.20.18/session/adodb-sess.txt-83-result, we simply process the row, if any.
##############################################
libphp-adodb-5.20.18/session/adodb-session.php-76- $new_id = session_id();
libphp-adodb-5.20.18/session/adodb-session.php:77: $ok = $conn->Execute('UPDATE '. ADODB_Session::table(). ' SET sesskey='. $conn->qstr($new_id). ' WHERE sesskey='.$conn->qstr($old_id));
libphp-adodb-5.20.18/session/adodb-session.php-78-
##############################################
libphp-adodb-5.20.18/session/adodb-session.php-599-
libphp-adodb-5.20.18/session/adodb-session.php:600: $sql = "SELECT $data FROM $table WHERE sesskey = $binary $qkey AND expiry >= " . time();
libphp-adodb-5.20.18/session/adodb-session.php-601- /* Lock code does not work as it needs to hold transaction within whole page, and we don't know if
##############################################
libphp-adodb-5.20.18/session/adodb-session.php-682-
libphp-adodb-5.20.18/session/adodb-session.php:683: $sql = "UPDATE $table SET expiry = ".$conn->Param('0').",expireref=".$conn->Param('1')." WHERE $binary sesskey = ".$conn->Param('2')." AND expiry >= ".$conn->Param('3');
libphp-adodb-5.20.18/session/adodb-session.php-684- $rs = $conn->Execute($sql,array($expiry,$expirevar,$key,time()));
##############################################
libphp-adodb-5.20.18/session/adodb-session.php-726- // do we insert or update? => as for sesskey
libphp-adodb-5.20.18/session/adodb-session.php:727: $rs = $conn->Execute("SELECT COUNT(*) AS cnt FROM $table WHERE $binary sesskey = $qkey");
libphp-adodb-5.20.18/session/adodb-session.php-728- if ($rs && reset($rs->fields) > 0) {
libphp-adodb-5.20.18/session/adodb-session.php:729: $sql = "UPDATE $table SET expiry = $expiry, $data = $lob_value, expireref=$expiryref WHERE sesskey = $qkey";
libphp-adodb-5.20.18/session/adodb-session.php-730- } else {
##############################################
libphp-adodb-5.20.18/session/adodb-session.php-753- if ($conn->databaseType == 'access') {
libphp-adodb-5.20.18/session/adodb-session.php:754: $sql = "SELECT sesskey FROM $table WHERE $binary sesskey = $qkey";
libphp-adodb-5.20.18/session/adodb-session.php-755- $rs = $conn->Execute($sql);
##############################################
libphp-adodb-5.20.18/session/adodb-session.php-787- $savem = $conn->SetFetchMode(ADODB_FETCH_NUM);
libphp-adodb-5.20.18/session/adodb-session.php:788: $sql = "SELECT expireref, sesskey FROM $table WHERE $binary sesskey = $qkey";
libphp-adodb-5.20.18/session/adodb-session.php-789- $rs = $conn->Execute($sql);
##############################################
libphp-adodb-5.20.18/session/adodb-session.php-804-
libphp-adodb-5.20.18/session/adodb-session.php:805: $sql = "DELETE FROM $table WHERE $binary sesskey = $qkey";
libphp-adodb-5.20.18/session/adodb-session.php-806- $rs = $conn->Execute($sql);
##############################################
libphp-adodb-5.20.18/session/adodb-session.php-845- $fn($ref, $key);
libphp-adodb-5.20.18/session/adodb-session.php:846: $del = $conn->Execute("DELETE FROM $table WHERE sesskey=".$conn->Param('0'),array($key));
libphp-adodb-5.20.18/session/adodb-session.php-847- $rs->MoveNext();
##############################################
libphp-adodb-5.20.18/session/adodb-session.php-858- foreach ($arr as $row) {
libphp-adodb-5.20.18/session/adodb-session.php:859: $sql2 = "DELETE FROM $table WHERE sesskey=".$conn->Param('0');
libphp-adodb-5.20.18/session/adodb-session.php-860- $conn->Execute($sql2,array(reset($row)));
##############################################
libphp-adodb-5.20.18/session/adodb-session2.php-106- $new_id = session_id();
libphp-adodb-5.20.18/session/adodb-session2.php:107: $ok = $conn->Execute('UPDATE '. ADODB_Session::table(). ' SET sesskey='. $conn->qstr($new_id). ' WHERE sesskey='.$conn->qstr($old_id));
libphp-adodb-5.20.18/session/adodb-session2.php-108-
##############################################
libphp-adodb-5.20.18/session/adodb-session2.php-627- if (!isset($ADODB_SESSION_SELECT_FIELDS)) $ADODB_SESSION_SELECT_FIELDS = 'sessdata';
libphp-adodb-5.20.18/session/adodb-session2.php:628: $sql = "SELECT $ADODB_SESSION_SELECT_FIELDS FROM $table WHERE sesskey = $binary ".$conn->Param(0)." AND expiry >= " . $conn->sysTimeStamp;
libphp-adodb-5.20.18/session/adodb-session2.php-629-
##############################################
libphp-adodb-5.20.18/session/adodb-session2.php-710-
libphp-adodb-5.20.18/session/adodb-session2.php:711: $sql = "UPDATE $table SET expiry = $expiry ,expireref=".$conn->Param('0').", modified = $sysTimeStamp WHERE $binary sesskey = ".$conn->Param('1')." AND expiry >= $sysTimeStamp";
libphp-adodb-5.20.18/session/adodb-session2.php-712- $rs = $conn->Execute($sql,array($expirevar,$key));
##############################################
libphp-adodb-5.20.18/session/adodb-session2.php-731- if (!$clob) { // no lobs, simply use replace()
libphp-adodb-5.20.18/session/adodb-session2.php:732: $rs = $conn->Execute("SELECT COUNT(*) AS cnt FROM $table WHERE $binary sesskey = ".$conn->Param(0),array($key));
libphp-adodb-5.20.18/session/adodb-session2.php-733- if ($rs) $rs->Close();
##############################################
libphp-adodb-5.20.18/session/adodb-session2.php-735- if ($rs && reset($rs->fields) > 0) {
libphp-adodb-5.20.18/session/adodb-session2.php:736: $sql = "UPDATE $table SET expiry=$expiry, sessdata=".$conn->Param(0).", expireref= ".$conn->Param(1).",modified=$sysTimeStamp WHERE sesskey = ".$conn->Param(2);
libphp-adodb-5.20.18/session/adodb-session2.php-737-
##############################################
libphp-adodb-5.20.18/session/adodb-session2.php-752-
libphp-adodb-5.20.18/session/adodb-session2.php:753: $rs = $conn->Execute("SELECT COUNT(*) AS cnt FROM $table WHERE $binary sesskey = ".$conn->Param(0),array($key));
libphp-adodb-5.20.18/session/adodb-session2.php-754-
libphp-adodb-5.20.18/session/adodb-session2.php-755- if ($rs && reset($rs->fields) > 0) {
libphp-adodb-5.20.18/session/adodb-session2.php:756: $sql = "UPDATE $table SET expiry=$expiry, sessdata=$lob_value, expireref= ".$conn->Param(0).",modified=$sysTimeStamp WHERE sesskey = ".$conn->Param('1');
libphp-adodb-5.20.18/session/adodb-session2.php-757-
##############################################
libphp-adodb-5.20.18/session/adodb-session2.php-779- if ($conn->databaseType == 'access') {
libphp-adodb-5.20.18/session/adodb-session2.php:780: $sql = "SELECT sesskey FROM $table WHERE $binary sesskey = $qkey";
libphp-adodb-5.20.18/session/adodb-session2.php-781- $rs = $conn->Execute($sql);
##############################################
libphp-adodb-5.20.18/session/adodb-session2.php-814- $savem = $conn->SetFetchMode(ADODB_FETCH_NUM);
libphp-adodb-5.20.18/session/adodb-session2.php:815: $sql = "SELECT expireref, sesskey FROM $table WHERE $binary sesskey = $qkey";
libphp-adodb-5.20.18/session/adodb-session2.php-816- $rs = $conn->Execute($sql);
##############################################
libphp-adodb-5.20.18/session/adodb-session2.php-831-
libphp-adodb-5.20.18/session/adodb-session2.php:832: $sql = "DELETE FROM $table WHERE $binary sesskey = $qkey";
libphp-adodb-5.20.18/session/adodb-session2.php-833- $rs = $conn->Execute($sql);
##############################################
libphp-adodb-5.20.18/session/adodb-session2.php-889- if ($fn) $fn($ref, $key);
libphp-adodb-5.20.18/session/adodb-session2.php:890: $del = $conn->Execute("DELETE FROM $table WHERE sesskey=".$conn->Param('0'),array($key));
libphp-adodb-5.20.18/session/adodb-session2.php-891- $rs->MoveNext();
##############################################
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php-158-global $ADODB_SESS_CONN,$ADODB_SESS_INSERT,$ADODB_SESSION_TBL;
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php:159: $rs = $ADODB_SESS_CONN->Execute("SELECT data FROM $ADODB_SESSION_TBL WHERE sesskey = '$key' AND expiry >= " . time());
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php-160- if ($rs) {
##############################################
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php-202-
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php:203: if ($ADODB_SESS_CONN->databaseType == 'access') $rs = $ADODB_SESS_CONN->Execute("select sesskey from $ADODB_SESSION_TBL WHERE sesskey='$key'");
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php-204- }
##############################################
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php-215- $savem = $ADODB_SESS_CONN->SetFetchMode(ADODB_FETCH_NUM);
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php:216: $rs = $ADODB_SESS_CONN->Execute("SELECT expireref,sesskey FROM $ADODB_SESSION_TBL WHERE sesskey='$key'");
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php-217- $ADODB_SESS_CONN->SetFetchMode($savem);
##############################################
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php-223- $fn($ref,$key);
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php:224: $del = $ADODB_SESS_CONN->Execute("DELETE FROM $ADODB_SESSION_TBL WHERE sesskey='$key'");
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php-225- $rs->MoveNext();
##############################################
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php-229- } else {
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php:230: $qry = "DELETE FROM $ADODB_SESSION_TBL WHERE sesskey = '$key'";
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php-231- $rs = $ADODB_SESS_CONN->Execute($qry);
##############################################
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php-252- $fn($ref,$key);
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php:253: //$del = $ADODB_SESS_CONN->Execute("DELETE FROM $ADODB_SESSION_TBL WHERE sesskey='$key'");
libphp-adodb-5.20.18/session/old/adodb-cryptsession.php-254- $rs->MoveNext();
##############################################
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-217-
libphp-adodb-5.20.18/session/old/adodb-session-clob.php:218: $rs = $ADODB_SESS_CONN->Execute("SELECT data FROM $ADODB_SESSION_TBL WHERE sesskey = '$key' AND expiry >= " . time());
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-219- if ($rs) {
##############################################
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-259--- Session: Only updating date - crc32 not changed</p>";
libphp-adodb-5.20.18/session/old/adodb-session-clob.php:260: $qry = "UPDATE $ADODB_SESSION_TBL SET expiry=$expiry WHERE sesskey='$key' AND expiry >= " . time();
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-261- $rs = $ADODB_SESS_CONN->Execute($qry);
##############################################
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-296- // do we insert or update? => as for sesskey
libphp-adodb-5.20.18/session/old/adodb-session-clob.php:297: $res = $ADODB_SESS_CONN->Execute("select count(*) as cnt from $ADODB_SESSION_TBL where sesskey = '$key'");
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-298- if ($res && reset($res->fields) > 0) {
libphp-adodb-5.20.18/session/old/adodb-session-clob.php:299: $qry = sprintf("update %s set expiry = %d, data = %s where sesskey = '%s'", $ADODB_SESSION_TBL, $expiry, $lob_value, $key);
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-300- } else {
##############################################
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-323- if ($ADODB_SESS_CONN->databaseType == 'access')
libphp-adodb-5.20.18/session/old/adodb-session-clob.php:324: $rs = $ADODB_SESS_CONN->Execute("select sesskey from $ADODB_SESSION_TBL WHERE sesskey='$key'");
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-325- }
##############################################
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-336- $savem = $ADODB_SESS_CONN->SetFetchMode(ADODB_FETCH_NUM);
libphp-adodb-5.20.18/session/old/adodb-session-clob.php:337: $rs = $ADODB_SESS_CONN->Execute("SELECT expireref,sesskey FROM $ADODB_SESSION_TBL WHERE sesskey='$key'");
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-338- $ADODB_SESS_CONN->SetFetchMode($savem);
##############################################
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-344- $fn($ref,$key);
libphp-adodb-5.20.18/session/old/adodb-session-clob.php:345: $del = $ADODB_SESS_CONN->Execute("DELETE FROM $ADODB_SESSION_TBL WHERE sesskey='$key'");
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-346- $rs->MoveNext();
##############################################
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-350- } else {
libphp-adodb-5.20.18/session/old/adodb-session-clob.php:351: $qry = "DELETE FROM $ADODB_SESSION_TBL WHERE sesskey = '$key'";
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-352- $rs = $ADODB_SESS_CONN->Execute($qry);
##############################################
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-373- $fn($ref,$key);
libphp-adodb-5.20.18/session/old/adodb-session-clob.php:374: $del = $ADODB_SESS_CONN->Execute("DELETE FROM $ADODB_SESSION_TBL WHERE sesskey='$key'");
libphp-adodb-5.20.18/session/old/adodb-session-clob.php-375- $rs->MoveNext();
##############################################
libphp-adodb-5.20.18/session/old/adodb-session.php-129- $new_id = session_id();
libphp-adodb-5.20.18/session/old/adodb-session.php:130: $ok = $conn->Execute('UPDATE '. ADODB_Session::table(). ' SET sesskey='. $conn->qstr($new_id). ' WHERE sesskey='.$conn->qstr($old_id));
libphp-adodb-5.20.18/session/old/adodb-session.php-131-
##############################################
libphp-adodb-5.20.18/session/old/adodb-session.php-250-
libphp-adodb-5.20.18/session/old/adodb-session.php:251: $rs = $ADODB_SESS_CONN->Execute("SELECT data FROM $ADODB_SESSION_TBL WHERE sesskey = '$key' AND expiry >= " . time());
libphp-adodb-5.20.18/session/old/adodb-session.php-252- if ($rs) {
##############################################
libphp-adodb-5.20.18/session/old/adodb-session.php-290--- Session: Only updating date - crc32 not changed</p>";
libphp-adodb-5.20.18/session/old/adodb-session.php:291: $qry = "UPDATE $ADODB_SESSION_TBL SET expiry=$expiry WHERE sesskey='$key' AND expiry >= " . time();
libphp-adodb-5.20.18/session/old/adodb-session.php-292- $rs = $ADODB_SESS_CONN->Execute($qry);
##############################################
libphp-adodb-5.20.18/session/old/adodb-session.php-312- if ($ADODB_SESS_CONN->databaseType == 'access')
libphp-adodb-5.20.18/session/old/adodb-session.php:313: $rs = $ADODB_SESS_CONN->Execute("select sesskey from $ADODB_SESSION_TBL WHERE sesskey='$key'");
libphp-adodb-5.20.18/session/old/adodb-session.php-314- }
##############################################
libphp-adodb-5.20.18/session/old/adodb-session.php-325- $savem = $ADODB_SESS_CONN->SetFetchMode(ADODB_FETCH_NUM);
libphp-adodb-5.20.18/session/old/adodb-session.php:326: $rs = $ADODB_SESS_CONN->Execute("SELECT expireref,sesskey FROM $ADODB_SESSION_TBL WHERE sesskey='$key'");
libphp-adodb-5.20.18/session/old/adodb-session.php-327- $ADODB_SESS_CONN->SetFetchMode($savem);
##############################################
libphp-adodb-5.20.18/session/old/adodb-session.php-333- $fn($ref,$key);
libphp-adodb-5.20.18/session/old/adodb-session.php:334: $del = $ADODB_SESS_CONN->Execute("DELETE FROM $ADODB_SESSION_TBL WHERE sesskey='$key'");
libphp-adodb-5.20.18/session/old/adodb-session.php-335- $rs->MoveNext();
##############################################
libphp-adodb-5.20.18/session/old/adodb-session.php-339- } else {
libphp-adodb-5.20.18/session/old/adodb-session.php:340: $qry = "DELETE FROM $ADODB_SESSION_TBL WHERE sesskey = '$key'";
libphp-adodb-5.20.18/session/old/adodb-session.php-341- $rs = $ADODB_SESS_CONN->Execute($qry);
##############################################
libphp-adodb-5.20.18/session/old/adodb-session.php-362- $fn($ref,$key);
libphp-adodb-5.20.18/session/old/adodb-session.php:363: $del = $ADODB_SESS_CONN->Execute("DELETE FROM $ADODB_SESSION_TBL WHERE sesskey='$key'");
libphp-adodb-5.20.18/session/old/adodb-session.php-364- $rs->MoveNext();
##############################################
libphp-adodb-5.20.18/tests/test-php5.php-16-
libphp-adodb-5.20.18/tests/test-php5.php:17:include("$path/../adodb-exceptions.inc.php");
libphp-adodb-5.20.18/tests/test-php5.php:18:include("$path/../adodb.inc.php");
libphp-adodb-5.20.18/tests/test-php5.php-19-
##############################################
libphp-adodb-5.20.18/tests/test.php-766- $id = $db->GetOne("select id from ADOXYZ
libphp-adodb-5.20.18/tests/test.php:767: where id=".$db->Param('zid')." and created>=".$db->Param('ZDATE')."",
libphp-adodb-5.20.18/tests/test.php-768- $array);
##############################################
libphp-adodb-5.20.18/tests/test.php-773- $id = $db->GetOne("select id from ADOXYZ
libphp-adodb-5.20.18/tests/test.php:774: where id=".$db->Param('0')." and created>=".$db->Param('1')."",
libphp-adodb-5.20.18/tests/test.php-775- $array);
##############################################
libphp-adodb-5.20.18/tests/test.php-1503-
libphp-adodb-5.20.18/tests/test.php:1504: $rs = $db->limitQuery('select * from ADOXYZ where id>0 order by id',$i=3,$top=3);
libphp-adodb-5.20.18/tests/test.php-1505- $i2 = $i;
##############################################
libphp-adodb-5.20.18/tests/test3.php-16-
libphp-adodb-5.20.18/tests/test3.php:17:include("$path/../adodb-exceptions.inc.php");
libphp-adodb-5.20.18/tests/test3.php:18:include("$path/../adodb.inc.php");
libphp-adodb-5.20.18/tests/test3.php-19-
##############################################
libphp-adodb-5.20.18/tests/test4.php-95-SELECT *
libphp-adodb-5.20.18/tests/test4.php:96:FROM ADOXYZ WHERE lastname=".$conn->Param('var'). " ORDER BY 1";
libphp-adodb-5.20.18/tests/test4.php-97-// Select a record to update
##############################################
libphp-adodb-5.20.18/tests/testdatabases.inc.php-43-<input type=checkbox name="nolog" value=1 <?php echo !empty($nolog) ? 'checked' : '' ?>> No SQL Logging<br>
libphp-adodb-5.20.18/tests/testdatabases.inc.php:44:<input type=checkbox name="time" value=1 <?php echo !empty($_GET['time']) ? 'checked' : '' ?>> ADOdb time test
libphp-adodb-5.20.18/tests/testdatabases.inc.php-45-</table>
##############################################
libphp-adodb-5.20.18/tohtml.inc.php-124- function mime_content_type ($file) {
libphp-adodb-5.20.18/tohtml.inc.php:125: return exec("file -bi ".escapeshellarg($file));
libphp-adodb-5.20.18/tohtml.inc.php-126- }