}
else
{
$_SESSION["dt"] = $post_dt;
$_SESSION["dt2"] = $post_dt2;
$_SESSION["date_type"] = $post_date_type;
$_SESSION["quick_date"] = $post_quick_date;
$_SESSION["purpose"] = $post_purpose;
$_SESSION["dfilter"] = true;
}
}
}
if (!$template_name)
{
$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);
<?
require("src/prepend.inc.php");
if (!$template_name)
{
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;
}
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;
}
}
$Contact->SetFieldList($fields);
$Contact->SetDiscloseList($PendingOperation->ObjectBefore->GetDiscloseList());
DBContact::GetInstance()->Save($Contact);
} else {
if ($PendingOperation->Type == Registry::OP_CREATE_APPROVE) {
DBContact::GetInstance()->Delete($Contact);
}
}
}
}
}
}
}
$sql = "SELECT * FROM pending_operations \n\t\tWHERE operation = '" . Registry::OP_CREATE_APPROVE . "' \n\t\t\tOR operation = '" . Registry::OP_UPDATE_APPROVE . "' \n\t\tORDER BY dtbegin DESC";
$paging = new SQLPaging();
$paging->SetSQLQuery($sql);
$paging->ApplySQLPaging();
$paging->ParseHTML();
$display["paging"] = $paging->GetPagerHTML("admin/inc/paging.tpl");
$Factory = RegistryModuleFactory::GetInstance();
$rows = $db->GetAll($paging->SQL);
foreach ($rows as &$row) {
$Contact = unserialize($row["object_after"]);
$ContactBefore = unserialize($row["object_before"]);
unset($row["object_after"], $row["object_before"]);
$row["clid"] = $Contact->CLID;
$row["contactid"] = $Contact->ID;
$Registry = $Contact->TLD ? $Factory->GetRegistryByExtension($Contact->TLD) : $Factory->GetRegistryByName($Contact->ModuleName);
$fields = $Registry->GetManifest()->GetContactFormSchema(null, $Contact->GroupName);
if ($row["operation"] == Registry::OP_UPDATE_APPROVE) {
<?php
require_once 'src/prepend.inc.php';
if (!$req_userid) {
throw new ApplicationException("Parameter 'userid' must be specified");
}
$DBBalance = DBBalance::GetInstance();
$Balance = $DBBalance->LoadClientBalance($req_userid);
$paging = new SQLPaging();
$paging->URLFormat = "?userid=" . (int) $req_userid . "&pn=%d&pt=%d";
$paging->SetSQLQuery("SELECT * FROM balance_history WHERE balanceid = '{$Balance->ID}' ORDER BY operation_date DESC");
$paging->ApplySQLPaging();
$paging->ParseHTML();
//$display["filter"] = $paging->GetFilterHTML("admin/inc/table_filter.tpl");
$display["paging"] = $paging->GetPagerHTML("admin/inc/paging.tpl");
$display["users"] = (array) $db->GetAll("SELECT * FROM users");
$display["attr"] = array_merge($_GET, $_POST);
$display["rows"] = $DBBalance->LoadBalanceHistory($paging->SQL);
foreach ($display["rows"] as &$row) {
if ($row->InvoiceID) {
$row->InvoiceDescription = $db->GetOne("SELECT description from invoices WHERE id = ?", array($row->InvoiceID));
}
}
$display["title"] = _("Balance » History");
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
<?
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);
<?
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
<?
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)
