{
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
