}
if ($req_dt)
{
$date = strtotime($req_dt);
$sql .= " AND TO_DAYS(dtadded) = TO_DAYS(FROM_UNIXTIME('{$date}'))";
$paging->AddURLFilter("dt", $req_dt);
$display["dt"] = $req_dt;
}
else
$display["dt"] = date("m/d/Y");
//Paging
$paging->SetSQLQuery($sql);
$paging->AdditionalSQL = "ORDER BY dtadded DESC";
$paging->ApplyFilter($_POST["filter_q"], array("object"));
$paging->ApplySQLPaging();
$paging->ParseHTML();
$display["filter"] = $paging->GetFilterHTML("admin/inc/table_filter.tpl");
$display["paging"] = $paging->GetPagerHTML("admin/inc/paging.tpl");
// Rows
$rows = $db->Execute($paging->SQL);
$added = array();
while ($row = $rows->FetchRow())
{
$row["type"] = ucfirst(strtolower($row["type"]));
$row["operation"] = ucfirst(strtolower($row["operation"]));
$display["rows"][] = $row;
break;
}
$sql .= " AND ({$date_sql})";
$display["dfilter"] = true;
}
//
//Paging
//
$paging->SetSQLQuery($sql);
$paging->AdditionalSQL = "ORDER BY UNIX_TIMESTAMP(dtcreated) DESC";
$paging->ApplyFilter($_POST["filter_q"], array("description"));
$paging->ApplySQLPaging();
$paging->ParseHTML();
$display["filter"] = $paging->GetFilterHTML("client/inc/table_filter.tpl");
$display["paging"] = $paging->GetPagerHTML("client/inc/paging.tpl");
//
// Rows
//
foreach ((array)$db->GetAll($paging->SQL) as $k=>$row)
{
$display["rows"][$k] = $row;
$display["rows"][$k]["userinfo"] = $db->GetRow("SELECT * FROM users WHERE id='{$row['userid']}'");
$display["rows"][$k]["gatename"] = ucfirst($row["gate"]);
}
break;
}
}
}
$sql = "SELECT * FROM `extensions` WHERE 1 > 0";
if ($get_id)
{
$id = (int)$get_id;
$sql .= " AND id = '{$id}'";
}
//Paging
$paging = new SQLPaging($sql);
$paging->ApplyFilter($_POST["filter_q"], array("name"));
//$paging->ApplySQLPaging();
$paging->ParseHTML();
$display["filter"] = $paging->GetFilterHTML("admin/inc/table_filter.tpl");
$display["paging"] = $paging->GetPagerHTML("admin/inc/paging.tpl");
// Rows
$rows = $db->SelectLimit($paging->SQL, $paging->ItemsOnPage, $paging->GetOffset());
while ($row = $rows->FetchRow())
{
$row["licensed"] = License::IsExtensionLicensed($row['license_flag']);
$display["rows"][] = $row;
}
require_once('src/append.inc.php');
$sql = "
SELECT clid
FROM contacts
WHERE
userid='{$_SESSION['userid']}' AND
(TLD = '{$get_TLD}' OR (
module_name='{$Registry->GetModuleName()}' AND
section_name='{$section_name}' AND
target_index='{$target_index}'
)) AND
groupname='{$get_groupname}'
";
$paging = new SQLPaging($sql, isset($req_pn) ? $req_pn : 1, 10);
$paging->ApplyFilter(
$req_filter_q,
array(),
"(clid IN (SELECT DISTINCT contactid FROM contacts_data WHERE value LIKE '%[FILTER]%')) or clid LIKE '%[FILTER]%'"
);
$paging->SetURLFormat("javascript:ContactList_ShowPage('{$req_type}', %d)");
$paging->TrainLength = 5;
$sql = $paging->ApplySQLPaging();
$paging->ParseHTML();
$clids = $db->GetAll($sql);
$rows = array();
foreach ($clids as $clid)
{
try
{
$c = DBContact::GetInstance()->LoadByCLID($clid['clid']);
$contact_fields = $c->GetFieldList();
if ($req_modulename)
{
$sql .= " AND modulename='{$req_modulename}'";
$paging->AddURLFilter('modulename', $req_modulename);
}
//
//Paging
//
if ($req_pf && !$post_filter_q)
$_SESSION["filter"] = null;
$paging->SetSQLQuery($sql);
$paging->AdditionalSQL = " ORDER BY modulename ASC, TLD ASC";
$paging->ApplyFilter($post_filter_q ? $post_filter_q : $req_pf, array("TLD", "modulename"));
$paging->ApplySQLPaging();
$paging->ParseHTML();
$display["filter"] = $paging->GetFilterHTML("admin/inc/table_filter.tpl");
$display["paging"] = $paging->GetPagerHTML("admin/inc/paging.tpl");
//
// Rows
//
foreach ((array)$db->GetAll($paging->SQL) as $k=>$row)
{
if ($_POST && $post_actionsubmit)
{
if (isset($post_isactive[$row["TLD"]]) && $row['isactive'] == 0)
{
require_once('src/prepend.inc.php');
// Delete
$paging = new SQLPaging(null, $req_pn, CONFIG::$PAGING_ITEMS);
$sql = "SELECT * from countries WHERE id!=''";
//
//Paging
//
if ($req_pf && !$post_filter_q)
$_SESSION["filter"] = null;
$paging->SetSQLQuery($sql);
$paging->AdditionalSQL = " ORDER BY name ASC";
$paging->ApplyFilter($post_filter_q ? $post_filter_q : $req_pf, array("name", "code"));
$paging->ApplySQLPaging();
$paging->ParseHTML();
$display["filter"] = $paging->GetFilterHTML("admin/inc/table_filter.tpl");
$display["paging"] = $paging->GetPagerHTML("admin/inc/paging.tpl");
//
// Rows
//
foreach ((array)$db->GetAll($paging->SQL) as $k=>$row)
{
if ($_POST && $post_actionsubmit)
{
if (isset($post_enabled[$row["id"]]) && $row['enabled'] == 0)
{
