} 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) {