public static function GetRelatedChatVouchers($_groupId, $_ticket) { global $CONFIG, $GROUPS; $vouchers = array(); $result = queryDB(true, $d = "SELECT *,`t1`.`id` AS `voucherid` FROM `" . DB_PREFIX . DATABASE_COMMERCIAL_CHAT_VOUCHERS . "` AS `t1` INNER JOIN `" . DB_PREFIX . DATABASE_COMMERCIAL_CHAT_TYPES . "` AS `t2` ON `t1`.`tid`=`t2`.`id` WHERE `t1`.`id`='" . DBManager::RealEscape($_ticket->Id) . "' OR (`t1`.`paid`=1 AND `voided`=0 AND (`t1`.`id`='" . DBManager::RealEscape($_ticket->Id) . "' OR `t1`.`extends`='" . DBManager::RealEscape($_ticket->Id) . "' OR `t1`.`id`='" . DBManager::RealEscape($_ticket->Extends) . "' OR (`t1`.`extends`!='' AND `t1`.`extends`='" . DBManager::RealEscape($_ticket->Extends) . "'))) ORDER BY `created` DESC;"); while ($row = @DBManager::FetchArray($result)) { if (!empty($CONFIG["db"]["cct"][$row["tid"]])) { $ticket = new CommercialChatVoucher($row); $ticket->CheckForVoid(); if ($_ticket->Id == $ticket->Id || !$ticket->Voided && in_array($row["tid"], $GROUPS[$_groupId]->ChatVouchersRequired)) { $vouchers[] = $ticket; } } } return $vouchers; }
static function GetRelatedChatVouchers($_groupId, $_ticket) { $vouchers = array(); Server::InitDataBlock(array("DBCONFIG")); $result = DBManager::Execute(true, $d = "SELECT *,`t1`.`id` AS `voucherid` FROM `" . DB_PREFIX . DATABASE_COMMERCIAL_CHAT_VOUCHERS . "` AS `t1` INNER JOIN `" . DB_PREFIX . DATABASE_COMMERCIAL_CHAT_TYPES . "` AS `t2` ON `t1`.`tid`=`t2`.`id` WHERE `t1`.`id`='" . DBManager::RealEscape($_ticket->Id) . "' OR (`t1`.`paid`=1 AND `voided`=0 AND (`t1`.`id`='" . DBManager::RealEscape($_ticket->Id) . "' OR `t1`.`extends`='" . DBManager::RealEscape($_ticket->Id) . "' OR `t1`.`id`='" . DBManager::RealEscape($_ticket->Extends) . "' OR (`t1`.`extends`!='' AND `t1`.`extends`='" . DBManager::RealEscape($_ticket->Extends) . "'))) ORDER BY `created` DESC;"); while ($row = @DBManager::FetchArray($result)) { if (!empty(Server::$Configuration->Database["cct"][$row["tid"]])) { $ticket = new CommercialChatVoucher($row); $ticket->CheckForVoid(); if ($_ticket->Id == $ticket->Id || !$ticket->Voided && in_array($row["tid"], Server::$Groups[$_groupId]->ChatVouchersRequired)) { $vouchers[] = $ticket; } } } return $vouchers; }