===========================================================
.___ __ __
_________________ __ __ __| _/|__|/ |_
/ ___\_` __ \__ \ | | \/ __ | | \\_ __\
/ /_/ > | \// __ \| | / /_/ | | || |
\___ /|__| (____ /____/\____ | |__||__|
/_____/ \/ \/
grep rough audit - static analysis tool
v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
php-horde-whups-3.0.12/whups-3.0.12/bin/whups-convert-datatree-shares-to-sql-31-try {
php-horde-whups-3.0.12/whups-3.0.12/bin/whups-convert-datatree-shares-to-sql:32: $shares_result = $db->selectAssoc('SELECT datatree_id, datatree_name FROM horde_datatree WHERE group_uid = ' . $db->quoteString('horde.shares.whups'));
php-horde-whups-3.0.12/whups-3.0.12/bin/whups-convert-datatree-shares-to-sql-33-} catch (Horde_Db_Exception $e) {
##############################################
php-horde-whups-3.0.12/whups-3.0.12/bin/whups-convert-datatree-shares-to-sql-125- try {
php-horde-whups-3.0.12/whups-3.0.12/bin/whups-convert-datatree-shares-to-sql:126: $db->delete('DELETE FROM horde_datatree_attributes WHERE datatree_id = ?', array($share_id));
php-horde-whups-3.0.12/whups-3.0.12/bin/whups-convert-datatree-shares-to-sql:127: $db->delete('DELETE FROM horde_datatree WHERE datatree_id = ?', array($share_id));
php-horde-whups-3.0.12/whups-3.0.12/bin/whups-convert-datatree-shares-to-sql-128- } catch (Horde_Db_Exception $e) {
##############################################
php-horde-whups-3.0.12/whups-3.0.12/docs/INSTALL-196- if any, is used. Finally, if none has been provided, the user specified in
php-horde-whups-3.0.12/whups-3.0.12/docs/INSTALL:197: Whups' configuration (``$conf[mail][username]``) will be used. If there
php-horde-whups-3.0.12/whups-3.0.12/docs/INSTALL-198- still hasn't been a user determined at this point, the ticket will be
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-95- if (strlen($slug) &&
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:96: $this->_db->selectValue('SELECT 1 FROM whups_queues WHERE queue_slug = ?', array($slug))) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-97- throw new Whups_Exception(
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-595-
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:596: $where = $query->reduce(array($this, 'clauseFromQuery'), $vars);
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-597- if (!$where) {
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-879- // Search conditions.
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:880: $where = $this->_generateWhere(
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-881- 'whups_tickets',
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-888- if (empty($where)) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:889: $where = $where2;
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-890- } elseif (!empty($where2)) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:891: $where .= ' AND ' . $where2;
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-892- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-895- if (!empty($info['summary'])) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:896: $where = $this->_addWhere(
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-897- $where, 1,
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-903- if (!empty($info['ticket_timestamp'])) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:904: $where = $this->_addDateWhere($where, $info['ticket_timestamp'], 'ticket_timestamp');
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-905- }
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-906- if (!empty($info['date_updated'])) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:907: $where = $this->_addDateWhere($where, $info['date_updated'], 'date_updated');
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-908- }
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-909- if (!empty($info['date_assigned'])) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:910: $where = $this->_addDateWhere($where, $info['date_assigned'], 'date_assigned');
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-911- }
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-912- if (!empty($info['date_resolved'])) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:913: $where = $this->_addDateWhere($where, $info['date_resolved'], 'date_resolved');
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-914- }
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-915- if (!empty($info['ticket_due'])) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:916: $where = $this->_addDateWhere($where, $info['ticket_due'], 'ticket_due');
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-917- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-999- $uc || $res || $new || $ass || $cat) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:1000: $where = $this->_addWhere($where, 1, "(whups_tickets.type_id = whups_states.type_id AND whups_tickets.state_id = whups_states.state_id$nouc$nores$nonew$noass$uc$res$new$ass$cat)");
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1001- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1027- }
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:1028: $where = $this->_addWhere($where, 1,
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1029- 'whups_ticket_owners.ticket_id IS NULL');
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1221- {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:1222: $where = 'whups_logs.ticket_id = ' . (int)$ticket_id;
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1223- $join = 'LEFT JOIN whups_comments
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1529- if (!empty($slug)) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:1530: if ($this->_db->selectValue('SELECT 1 FROM whups_queues WHERE queue_slug = ? AND queue_id <> ?', array($slug, $queueId))) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1531- throw new Whups_Exception(
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1952- } else {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:1953: $where = 'type_id = ' . $type;
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1954- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1956- if (!is_array($category)) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:1957: $where = $this->_addWhere($where, $category, 'state_category = ' . $this->_db->quoteString($category));
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1958- } else {
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1963- if (count($clauses))
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:1964: $where = $this->_addWhere($where, $cat, implode(' OR ', $clauses));
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1965- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1967- if (!is_array($notcategory)) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:1968: $where = $this->_addWhere($where, $notcategory, 'state_category <> ' . $this->_db->quoteString($notcategory));
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1969- } else {
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1974- if (count($clauses)) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:1975: $where = $this->_addWhere($where, $notcat, implode(' OR ', $clauses));
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1976- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1978- if (!empty($where)) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:1979: $where = ' WHERE ' . $where;
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-1980- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-2284- } else {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:2285: $where = ' WHERE type_id = ' . $type;
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-2286- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-2897- } else {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:2898: $where = ' WHERE type_id = ' . (int)$type;
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-2899- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3314- if (count($clauses)) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:3315: $where = $this->_addWhere($where, true, implode(' OR ', $clauses));
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3316- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3318- $success = @settype($prop, $type);
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:3319: $where = $this->_addWhere($where, !is_null($prop) && $success, "$table.$field = " . $this->_db->quoteString($prop));
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3320- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3329- $success = @settype($prop, $type);
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:3330: $where = $this->_addWhere($where, $prop && $success, "$table.$field <> " . $this->_db->quoteString($prop));
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3331- } else {
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3335- $success = @settype($prop, $type);
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:3336: $where = $this->_addWhere($where, $prop && $success, "$table.$field <> " . $this->_db->quoteString($prop));
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3337- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3367- if (!empty($where)) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:3368: $where .= " $conjunction ";
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3369- }
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3370-
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:3371: $where .= "($clause)";
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3372- }
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3380- if (!empty($data['from'])) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:3381: $where = $this->_addWhere($where, true,
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3382- $type . ' >= ' . (int)$data['from']);
##############################################
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3384- if (!empty($data['to'])) {
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php:3385: $where = $this->_addWhere($where, true,
php-horde-whups-3.0.12/whups-3.0.12/lib/Driver/Sql.php-3386- $type . ' <= ' . (int)$data['to']);
##############################################
php-horde-whups-3.0.12/whups-3.0.12/migration/6_whups_upgrade_transactions.php-58- // constraint violations.
php-horde-whups-3.0.12/whups-3.0.12/migration/6_whups_upgrade_transactions.php:59: if ($this->selectValue('SELECT count(*) FROM whups_transactions WHERE transaction_id = ?', array($row['transaction_id'])) > 0) {
php-horde-whups-3.0.12/whups-3.0.12/migration/6_whups_upgrade_transactions.php-60- continue;