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;
}
