=========================================================== .___ __ __ _________________ __ __ __| _/|__|/ |_ / ___\_` __ \__ \ | | \/ __ | | \\_ __\ / /_/ > | \// __ \| | / /_/ | | || | \___ /|__| (____ /____/\____ | |__||__| /_____/ \/ \/ grep rough audit - static analysis tool v2.8 written by @Wireghoul =================================[justanotherhacker.com]=== php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql/Schema.php-68- { php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql/Schema.php:69: return '`' . str_replace('`', '``', $name) . '`'; php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql/Schema.php-70- } ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql/Schema.php-421- { php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql/Schema.php:422: return $this->execute("CREATE DATABASE `$name`"); php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql/Schema.php-423- } ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql/Schema.php-431- { php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql/Schema.php:432: return $this->execute("DROP DATABASE IF EXISTS `$name`"); php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql/Schema.php-433- } ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Pdo/Base.php-363- if (is_array($where)) { php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Pdo/Base.php:364: $where = $this->_replaceParameters($where[0], $where[1]); php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Pdo/Base.php-365- } ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Pdo/Pgsql.php-90- $this->_lastQuery = $sql = "SET datestyle TO 'iso'"; php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Pdo/Pgsql.php:91: $retval = $this->_connection->exec($sql); php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Pdo/Pgsql.php-92- if ($retval === false) { ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Pdo/Sqlite.php-102- $this->_lastQuery = $sql = 'PRAGMA full_column_names=0'; php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Pdo/Sqlite.php:103: $retval = $this->_connection->exec($sql); php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Pdo/Sqlite.php-104- if ($retval === false) { ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Pdo/Sqlite.php-109- $this->_lastQuery = $sql = 'PRAGMA short_column_names=1'; php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Pdo/Sqlite.php:110: $retval = $this->_connection->exec($sql); php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Pdo/Sqlite.php-111- if ($retval === false) { ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-389- LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php:390: WHERE a.attrelid = ' . $this->quote($tableName) . '::regclass php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-391- AND a.attnum > 0 AND NOT a.attisdropped ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-1124- ON t.constraint_name = c.constraint_name php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php:1125: WHERE t.table_name = '$table' AND t.constraint_type = 'PRIMARY KEY';"; php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-1126- $result = $this->selectOne($sql, 'PK and custom sequence'); ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Base.php-632- if (is_array($where)) { php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Base.php:633: $where = $this->_replaceParameters($where[0], $where[1]); php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Base.php-634- } ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql.php-256- $this->_lastQuery = $query; php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql.php:257: $stmt = mysql_query($query, $this->_connection); php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql.php-258- if (!$stmt) { ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql.php-294- $this->_lastQuery = 'SET AUTOCOMMIT=0; BEGIN'; php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql.php:295: @mysql_query('SET AUTOCOMMIT=0', $this->_connection) && @mysql_query('BEGIN', $this->_connection); php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql.php-296- } ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql.php-305- $this->_lastQuery = 'COMMIT; SET AUTOCOMMIT=1'; php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql.php:306: @mysql_query('COMMIT', $this->_connection) && @mysql_query('SET AUTOCOMMIT=1', $this->_connection); php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql.php-307- } ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql.php-320- $this->_lastQuery = 'ROLLBACK; SET AUTOCOMMIT=1'; php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql.php:321: @mysql_query('ROLLBACK', $this->_connection) && @mysql_query('SET AUTOCOMMIT=1', $this->_connection); php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Mysql.php-322- $this->_transactionStarted = 0; ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Oci8.php-426- if (is_array($where)) { php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Oci8.php:427: $where = $this->_replaceParameters($where[0], $where[1]); php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Oci8.php-428- } ############################################## php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Oci8.php-533- if ($limit) { php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Oci8.php:534: $sql = "SELECT a.*, ROWNUM rnum FROM ($sql) a WHERE ROWNUM <= $limit"; php-horde-db-2.4.0/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Oci8.php-535- if ($offset) { ############################################## php-horde-db-2.4.0/debian/patches/psql-drop-pg-attrdef-adsrc.patch-20-- ON a.attrelid = d.adrelid AND a.attnum = d.adnum php-horde-db-2.4.0/debian/patches/psql-drop-pg-attrdef-adsrc.patch:21:- WHERE a.attrelid = ' . $this->quote($tableName) . '::regclass php-horde-db-2.4.0/debian/patches/psql-drop-pg-attrdef-adsrc.patch-22-- AND a.attnum > 0 AND NOT a.attisdropped ############################################## php-horde-db-2.4.0/debian/patches/psql-drop-pg-attrdef-adsrc.patch-27-+ LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum php-horde-db-2.4.0/debian/patches/psql-drop-pg-attrdef-adsrc.patch:28:+ WHERE a.attrelid = ' . $this->quote($tableName) . '::regclass php-horde-db-2.4.0/debian/patches/psql-drop-pg-attrdef-adsrc.patch-29-+ AND a.attnum > 0 AND NOT a.attisdropped ############################################## php-horde-db-2.4.0/debian/patches/psql-drop-pg-attrdef-adsrc.patch-52-- JOIN pg_constraint cons ON (conrelid = adrelid AND adnum = conkey[1]) php-horde-db-2.4.0/debian/patches/psql-drop-pg-attrdef-adsrc.patch:53:- WHERE t.oid = '$table'::regclass php-horde-db-2.4.0/debian/patches/psql-drop-pg-attrdef-adsrc.patch-54-- AND cons.contype = 'p' ############################################## php-horde-db-2.4.0/debian/patches/psql-drop-pg-attrdef-adsrc.patch-61-+ ON t.constraint_name = c.constraint_name php-horde-db-2.4.0/debian/patches/psql-drop-pg-attrdef-adsrc.patch:62:+ WHERE t.table_name = '$table' AND t.constraint_type = 'PRIMARY KEY';"; php-horde-db-2.4.0/debian/patches/psql-drop-pg-attrdef-adsrc.patch-63- $result = $this->selectOne($sql, 'PK and custom sequence'); ############################################## php-horde-db-2.4.0/.pc/psql-use-show-server-version-num.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-388- ON a.attrelid = d.adrelid AND a.attnum = d.adnum php-horde-db-2.4.0/.pc/psql-use-show-server-version-num.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php:389: WHERE a.attrelid = ' . $this->quote($tableName) . '::regclass php-horde-db-2.4.0/.pc/psql-use-show-server-version-num.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-390- AND a.attnum > 0 AND NOT a.attisdropped ############################################## php-horde-db-2.4.0/.pc/psql-use-show-server-version-num.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-1120- JOIN pg_constraint cons ON (conrelid = adrelid AND adnum = conkey[1]) php-horde-db-2.4.0/.pc/psql-use-show-server-version-num.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php:1121: WHERE t.oid = '$table'::regclass php-horde-db-2.4.0/.pc/psql-use-show-server-version-num.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-1122- AND cons.contype = 'p' ############################################## php-horde-db-2.4.0/.pc/psql-use-pg_sequences.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-388- ON a.attrelid = d.adrelid AND a.attnum = d.adnum php-horde-db-2.4.0/.pc/psql-use-pg_sequences.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php:389: WHERE a.attrelid = ' . $this->quote($tableName) . '::regclass php-horde-db-2.4.0/.pc/psql-use-pg_sequences.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-390- AND a.attnum > 0 AND NOT a.attisdropped ############################################## php-horde-db-2.4.0/.pc/psql-use-pg_sequences.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-1120- JOIN pg_constraint cons ON (conrelid = adrelid AND adnum = conkey[1]) php-horde-db-2.4.0/.pc/psql-use-pg_sequences.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php:1121: WHERE t.oid = '$table'::regclass php-horde-db-2.4.0/.pc/psql-use-pg_sequences.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-1122- AND cons.contype = 'p' ############################################## php-horde-db-2.4.0/.pc/psql-drop-pg-attrdef-adsrc.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-388- ON a.attrelid = d.adrelid AND a.attnum = d.adnum php-horde-db-2.4.0/.pc/psql-drop-pg-attrdef-adsrc.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php:389: WHERE a.attrelid = ' . $this->quote($tableName) . '::regclass php-horde-db-2.4.0/.pc/psql-drop-pg-attrdef-adsrc.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-390- AND a.attnum > 0 AND NOT a.attisdropped ############################################## php-horde-db-2.4.0/.pc/psql-drop-pg-attrdef-adsrc.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-1132- JOIN pg_constraint cons ON (conrelid = adrelid AND adnum = conkey[1]) php-horde-db-2.4.0/.pc/psql-drop-pg-attrdef-adsrc.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php:1133: WHERE t.oid = '$table'::regclass php-horde-db-2.4.0/.pc/psql-drop-pg-attrdef-adsrc.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-1134- AND cons.contype = 'p' ############################################## php-horde-db-2.4.0/.pc/1011_psql-avoid-access-array-offset-on-val-of-type-bool.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-389- LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum php-horde-db-2.4.0/.pc/1011_psql-avoid-access-array-offset-on-val-of-type-bool.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php:390: WHERE a.attrelid = ' . $this->quote($tableName) . '::regclass php-horde-db-2.4.0/.pc/1011_psql-avoid-access-array-offset-on-val-of-type-bool.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-391- AND a.attnum > 0 AND NOT a.attisdropped ############################################## php-horde-db-2.4.0/.pc/1011_psql-avoid-access-array-offset-on-val-of-type-bool.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-1124- ON t.constraint_name = c.constraint_name php-horde-db-2.4.0/.pc/1011_psql-avoid-access-array-offset-on-val-of-type-bool.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php:1125: WHERE t.table_name = '$table' AND t.constraint_type = 'PRIMARY KEY';"; php-horde-db-2.4.0/.pc/1011_psql-avoid-access-array-offset-on-val-of-type-bool.patch/Horde_Db-2.4.0/lib/Horde/Db/Adapter/Postgresql/Schema.php-1126- $result = $this->selectOne($sql, 'PK and custom sequence');