{ Core::Load("Data/Formater"); $display["title"] = _("Objects history"); //$display["help"] = _("1"); $display["load_calendar"] = 1; $paging = new SQLPaging(); $sql = "SELECT * FROM objects_history WHERE 1=1"; if ($req_search && $req_search != '') { $search = mysql_escape_string($req_search); $sql .= " AND object LIKE '%{$search}%'"; $paging->AddURLFilter("search", $req_search); $display["search"] = $req_search; } if ($req_obj_filter && $req_obj_filter !="") { $obj = mysql_escape_string($req_obj_filter); $sql .= " AND type = '{$obj}'"; $paging->AddURLFilter("obj_filter", $req_obj_filter); $display["obj_filter"] = $req_obj_filter; } if ($req_op_filter && $req_op_filter !="") { $op = mysql_escape_string($req_op_filter); $sql .= " AND operation = '{$op}'";
<? require_once('src/prepend.inc.php'); $sql = "SELECT * from domains WHERE userid='{$_SESSION['userid']}'"; $paging = new SQLPaging(); switch($req_op) { case INCOMPLETE_OPERATION::DOMAIN_CREATE: $sql .= " AND incomplete_operation='".INCOMPLETE_OPERATION::DOMAIN_CREATE."' AND status = '".DOMAIN_STATUS::PENDING."'"; $paging->AddURLFilter("op", INCOMPLETE_OPERATION::DOMAIN_CREATE); break; case INCOMPLETE_OPERATION::DOMAIN_TRADE: $sql .= " AND incomplete_operation='".INCOMPLETE_OPERATION::DOMAIN_TRADE."' AND status = '".DOMAIN_STATUS::DELEGATED."'"; $paging->AddURLFilter("op", INCOMPLETE_OPERATION::DOMAIN_TRADE); break; case INCOMPLETE_OPERATION::DOMAIN_TRANSFER: $sql .= " AND incomplete_operation='".INCOMPLETE_OPERATION::DOMAIN_TRANSFER."' AND status = '".DOMAIN_STATUS::PENDING."'"; $paging->AddURLFilter("op", INCOMPLETE_OPERATION::DOMAIN_TRANSFER); break; case INCOMPLETE_OPERATION::DOMAIN_OUTGOING_TRANSFER: $sql .= " AND outgoing_transfer_status='".OUTGOING_TRANSFER_STATUS::REQUESTED."' AND status = '".DOMAIN_STATUS::DELEGATED."'"; $paging->AddURLFilter("op", INCOMPLETE_OPERATION::DOMAIN_OUTGOING_TRANSFER);
$paging = new SQLPaging(); // // Start compile SQL query // $sql = "SELECT * from invoices WHERE id!='' AND userid='{$_SESSION['userid']}' AND hidden=0"; // // Show invoices with specified status // if (isset($req_status)) { $get_status = (int)$get_status; $sql .= " AND status='{$req_status}'"; $paging->AddURLFilter("status", $req_status); } // // Show invoices for specified domain name // if (isset($get_domainid)) { $domainid = (int)$get_domainid; $purposes = implode(',', array($db->qstr(INVOICE_PURPOSE::DOMAIN_CREATE), $db->qstr(INVOICE_PURPOSE::DOMAIN_RENEW), $db->qstr(INVOICE_PURPOSE::DOMAIN_TRANSFER), $db->qstr(INVOICE_PURPOSE::DOMAIN_TRADE) ));
<? require_once('src/prepend.inc.php'); // Delete $paging = new SQLPaging(null, $req_pn, CONFIG::$PAGING_ITEMS); $sql = "SELECT * from tlds WHERE id!=''"; 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