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