function buildChatVouchers($typecond = "") { global $RESPONSE, $INTERNAL, $GROUPS, $CONFIG; if (empty($_POST["p_ct_r"])) { return; } if ($_POST["p_ct_r"] == XML_CLIP_NULL) { $_POST["p_ct_r"] = 0; } $RESPONSE->ChatVouchers = ""; if (!empty($CONFIG["db"]["cct"])) { $types = array(); foreach ($INTERNAL[CALLER_SYSTEM_ID]->Groups as $gid) { if (isset($GROUPS[$gid]) && is_array($GROUPS[$gid]->ChatVouchersRequired)) { foreach ($GROUPS[$gid]->ChatVouchersRequired as $vid) { if (!isset($types[$vid])) { $types[$vid] = $vid; if (!empty($typecond)) { $typecond .= " OR "; } $typecond .= "`t1`.`tid`='" . $vid . "'"; } } } } if (!empty($typecond) && is_numeric($_POST["p_ct_r"])) { if ($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`.`edited` > " . $_POST["p_ct_r"] . " AND (" . $typecond . ") ORDER BY `t1`.`edited` ASC LIMIT " . DATA_ITEM_LOADS . ";")) { while ($row = DBManager::FetchArray($result)) { $voucher = new CommercialChatVoucher($row); $RESPONSE->ChatVouchers .= $voucher->GetXML(); } } } } }
function buildChatVouchers($typecond = "") { if (empty($_POST["p_ct_r"])) { return; } if ($_POST["p_ct_r"] == XML_CLIP_NULL) { $_POST["p_ct_r"] = 0; } Server::$Response->ChatVouchers = ""; if (!empty(Server::$Configuration->Database["cct"])) { $types = array(); foreach (Server::$Operators[CALLER_SYSTEM_ID]->Groups as $gid) { if (isset(Server::$Groups[$gid]) && is_array(Server::$Groups[$gid]->ChatVouchersRequired)) { foreach (Server::$Groups[$gid]->ChatVouchersRequired as $vid) { if (!isset($types[$vid])) { $types[$vid] = $vid; if (!empty($typecond)) { $typecond .= " OR "; } $typecond .= "`t1`.`tid`='" . $vid . "'"; } } } } if (!empty($typecond) && is_numeric($_POST["p_ct_r"])) { if ($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`.`edited` > " . $_POST["p_ct_r"] . " AND (" . $typecond . ") ORDER BY `t1`.`edited` ASC LIMIT " . DATA_ITEM_LOADS . ";")) { while ($row = DBManager::FetchArray($result)) { $voucher = new CommercialChatVoucher($row); Server::$Response->ChatVouchers .= $voucher->GetXML(); } } } } }