/**
* Метод, предназначенный для получения и вывода списка Запросов
*
* @param boolean $pagination признак формирования постраничного списка
*/
function _requestListGet($pagination = true)
{
global $AVE_DB, $AVE_Template;
$limit = '';
// Если используется постраничная навигация
if ($pagination) {
// Определяем лимит записей на страницу и начало диапазона выборки
$limit = $this->_limit;
$start = get_current_page() * $limit - $limit;
// Получаем общее количество запросов
$num = $AVE_DB->Query("SELECT COUNT(*) FROM " . PREFIX . "_request")->GetCell();
// Если количество больше, чем установленный лимит, тогда формируем постраничную навигацию
if ($num > $limit) {
$page_nav = " <a class=\"pnav\" href=\"index.php?do=request&page={s}&cp=" . SESSION . "\">{t}</a> ";
$page_nav = get_pagination(ceil($num / $limit), 'page', $page_nav);
$AVE_Template->assign('page_nav', $page_nav);
}
$limit = $pagination ? "LIMIT " . $start . "," . $limit : '';
}
// Выполняем запрос к БД на получение списка запросов с учетом лимита вывода на страницу (если необходимо)
$items = array();
$sql = $AVE_DB->Query("\r\n\t\t\tSELECT *\r\n\t\t\tFROM " . PREFIX . "_request\r\n\t\t\tORDER BY Id ASC\r\n\t\t\t" . $limit . "\r\n\t\t");
// Формируем массив из полученных данных
while ($row = $sql->FetchRow()) {
$row->request_author = get_username_by_id($row->request_author_id);
array_push($items, $row);
}
// Возвращаем массив
return $items;
}
public function get_priest_preach_by_id()
{
$id = $this->input->get('id');
$limit = $this->get('limit');
$page = $this->get('page');
$limit = $limit ? $limit : self::DEFAULT_LIMIT;
if ($limit > self::MAX_LIMIT) {
$limit = self::DEFAULT_LIMIT;
}
$page = $page ? $page : 1;
if ($page == 0) {
$page = 1;
}
$count = $this->priest_preach_model->count_priest_preach_by_id($id);
$total = $count->count;
if ($total <= 0 || !$count) {
$this->response(array('status_code' => '400'));
return;
}
$this->load->helper('util_helper');
$pagination = get_pagination($total, $limit, $page);
$results = $this->priest_preach_model->get_priest_preach_by_id($id, $pagination['limit'], $pagination['offset']);
if (!$results) {
$this->response(array('status_code' => 400));
return;
}
$this->response(array('status_code' => 200, 'total' => $total, 'results' => $results));
}
function get_user_followers($userid, $page, $username)
{
$text = "SELECT id, following_user_id AS username FROM follow WHERE follower_user_id='{$userid}' AND deleted_time=''";
$return['query'] = build_query($text, $page);
$return['pagination'] = get_pagination($text, $page);
return $return;
}
public function index()
{
$this->load->model('admin/soggetti_model');
$this->load->model('admin/luoghi_model');
// Setto il titolo della pagina
$data['titolo'] = "DiconArt - Gestione soggetti";
$data["cerca"] = isset($_GET["cerca"]) ? $_GET["cerca"] : "";
// Gestione della paginazione
$data["total_rows"] = $config["total_rows"] = $this->soggetti_model->count_soggetti($data["cerca"]);
$base_url = base_url() . "admin/soggetti/index/";
$pagination = get_pagination($base_url);
$this->pagination->initialize($config);
// Prende i dati dei soggetti
$data['lista_soggetti'] = $this->soggetti_model->lista_soggetti($data["cerca"], $pagination["per_page"], $pagination["offset"]);
foreach ($data['lista_soggetti'] as $k => $soggetto) {
$data['lista_soggetti'][$k]->luogo_nascita = $this->luoghi_model->dati_luogo($soggetto->id_luogo_nascita);
$data['lista_soggetti'][$k]->luogo_morte = $this->luoghi_model->dati_luogo($soggetto->id_luogo_morte);
}
$data["pagination"] = $this->pagination->create_links();
$data['javascript_files'] = array('plugins/jquery.tablesorter.min.js', 'admin/functions.js');
// Stampo la pagina di lista dei soggetti
$data["page"] = "lista_soggetti";
$content = array('admin/pages/soggetti/lista', 'admin/modals/cancella');
$this->render($content, $data);
}
public function onlineBibile()
{
$search_keyword = $_REQUEST['search_keyword'];
$limit = $this->get('limit');
$page = $this->get('page');
$limit = $limit ? $limit : self::DEFAULT_LIMIT;
if ($limit > self::MAX_LIMIT) {
$limit = self::DEFAULT_LIMIT;
}
$page = $page ? $page : 1;
if ($page == 0) {
$page = 1;
}
if (!($total = $this->bibile_model->count_all($search_keyword))) {
$this->response(array('message' => '没有找到！你想要<b>【' . $search_keyword . '】</b>相关的经文！'));
return;
}
$this->load->helper('util_helper');
$pagination = get_pagination($total, $limit, $page);
if (!($bibile_seciton = $this->bibile_model->onlineBibile($search_keyword, $pagination['limit'], $pagination['offset']))) {
$this->response(array('message' => '没有找到，你想要相关的经文！'));
return;
}
$this->response(array('total' => $total, 'results' => $bibile_seciton));
}
function get_tag($tag, $page)
{
$term = make_it_safe($tag);
$text = "SELECT DISTINCT id, time FROM quiz JOIN (SELECT quiz_id FROM tag WHERE tag='{$term}') AS hellyeah ON quiz.id=quiz_id";
$return['query'] = build_query($text, $page);
$return['pagination'] = get_pagination($text, $page);
return $return;
}
function get_prints(&$dbh, $user, $args, $page)
{
list($count, $offset, $perpage, $page) = get_pagination($page);
$where_clauses = array('composed');
if ($user['id']) {
$where_clauses[] = sprintf('(private = 0 OR (private = 1 AND user_id = %s))', $dbh->quoteSmart($user['id']));
} else {
$where_clauses[] = 'private = 0';
}
if (isset($args['date']) && ($time = strtotime($args['date']))) {
$start = date('Y-m-d 00:00:00', $time);
$end = date('Y-m-d 23:59:59', $time);
$where_clauses[] = sprintf('(created BETWEEN "%s" AND "%s")', $start, $end);
}
if (isset($args['month']) && ($time = strtotime("{$args['month']}-01"))) {
$start = date('Y-m-d 00:00:00', $time);
$end = date('Y-m-d 23:59:59', $time + 86400 * intval(date('t', $time)));
$where_clauses[] = sprintf('(created BETWEEN "%s" AND "%s")', $start, $end);
}
if (isset($args['place'])) {
$woeid_clauses = array(sprintf('place_woeid = %d', $args['place']), sprintf('region_woeid = %d', $args['place']), sprintf('country_woeid = %d', $args['place']));
$where_clauses[] = '(' . join(' OR ', $woeid_clauses) . ')';
}
if (isset($args['user'])) {
$where_clauses[] = sprintf('(user_id = %s)', $dbh->quoteSmart($args['user']));
}
$q = sprintf("SELECT paper_size, orientation, provider, private,\n pdf_url, preview_url, geotiff_url,\n id, title, north, south, east, west, zoom,\n (north + south) / 2 AS latitude,\n (east + west) / 2 AS longitude,\n UNIX_TIMESTAMP(created) AS created,\n UNIX_TIMESTAMP(composed) AS composed,\n UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(created) AS age,\n country_name, country_woeid, region_name, region_woeid, place_name, place_woeid,\n user_id, progress\n FROM prints\n WHERE %s\n ORDER BY created DESC\n LIMIT %d OFFSET %d", join(' AND ', $where_clauses), $count, $offset);
$res = $dbh->query($q);
if (PEAR::isError($res)) {
die_with_code(500, "{$res->message}\n{$q}\n");
}
$rows = array();
while ($row = $res->fetchRow(DB_FETCHMODE_ASSOC)) {
// TODO: ditch special-case for provider
if (empty($row['provider'])) {
$row['provider'] = reset(reset(get_map_providers()));
}
// decode/compose.py writes the filename for pdf's
// I suppose this special case handles a time before the url's were being written to the DB
// TODO: ditch special-case for pdf_url
if (empty($row['pdf_url']) && S3_BUCKET_ID) {
$row['pdf_url'] = sprintf('http://%s.s3.amazonaws.com/prints/%s/walking-paper-%s.pdf', S3_BUCKET_ID, $row['id'], $row['id']);
}
// TODO: ditch special-case for preview_url
if (empty($row['preview_url']) && S3_BUCKET_ID) {
$row['preview_url'] = sprintf('http://%s.s3.amazonaws.com/prints/%s/preview.png', S3_BUCKET_ID, $row['id']);
}
$rows[] = $row;
}
$pagination_props = array('count' => $count, 'offset' => $offset, 'perpage' => $perpage, 'page' => $page);
return array($rows, $pagination_props, $where_clauses);
}
function get_forms(&$dbh, $user_id, $page)
{
list($count, $offset, $perpage, $page) = get_pagination($page);
$where_user_clause = empty($user_id) ? '1' : sprintf('(user_id = %s)', $dbh->quoteSmart($user_id));
$q = sprintf("SELECT id, form_url, title, http_method, action_url,\n UNIX_TIMESTAMP(created) AS created,\n UNIX_TIMESTAMP(parsed) AS parsed,\n UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(created) AS age,\n user_id\n FROM forms\n WHERE parsed\n AND {$where_user_clause}\n ORDER BY created DESC\n LIMIT %d OFFSET %d", $count, $offset);
$res = $dbh->query($q);
if (PEAR::isError($res)) {
die_with_code(500, "{$res->message}\n{$q}\n");
}
$rows = array();
while ($row = $res->fetchRow(DB_FETCHMODE_ASSOC)) {
$rows[] = $row;
}
return $rows;
}
/**
* Постраничная навигация документа
*
* @param string $text текст многострочной части документа
* @return string
*/
function document_pagination($text)
{
global $AVE_Core;
// IE8 <div style="page-break-after: always"><span style="display: none"> </span></div>
// Chrome <div style="page-break-after: always; "><span style="DISPLAY:none"> </span></div>
// FF <div style="page-break-after: always;"><span style="display: none;"> </span></div>
$pages = preg_split('#<div style="page-break-after:[; ]*always[; ]*"><span style="display:[ ]*none[;]*"> </span></div>#i', $text);
$total_page = @sizeof($pages);
if ($total_page > 1) {
$text = @$pages[get_current_page('artpage') - 1];
$page_nav = ' <a class="pnav" href="index.php?id=' . $AVE_Core->curentdoc->Id . '&doc=' . (empty($AVE_Core->curentdoc->document_alias) ? prepare_url($AVE_Core->curentdoc->document_title) : $AVE_Core->curentdoc->document_alias) . '&artpage={s}' . '">{t}</a> ';
$page_nav = get_pagination($total_page, 'artpage', $page_nav, get_settings('navi_box'));
$text .= rewrite_link($page_nav);
}
return $text;
}
/**
* Вывод списка рубрик
*
*/
function rubricList()
{
global $AVE_DB, $AVE_Template;
$rubrics = array();
$num = $AVE_DB->Query("SELECT COUNT(*) FROM " . PREFIX . "_rubrics")->GetCell();
$page_limit = $this->_limit;
$seiten = ceil($num / $page_limit);
$set_start = get_current_page() * $page_limit - $page_limit;
if ($num > $page_limit) {
$page_nav = " <a class=\"pnav\" href=\"index.php?do=rubs&page={s}&cp=" . SESSION . "\">{t}</a> ";
$page_nav = get_pagination($seiten, 'page', $page_nav);
$AVE_Template->assign('page_nav', $page_nav);
}
$sql = $AVE_DB->Query("\r\n\t\t\tSELECT\r\n\t\t\t\trub.*,\r\n\t\t\t\tCOUNT(doc.Id) AS doc_count\r\n\t\t\tFROM\r\n\t\t\t\t" . PREFIX . "_rubrics AS rub\r\n\t\t\tLEFT JOIN\r\n\t\t\t\t" . PREFIX . "_documents AS doc\r\n\t\t\t\t\tON rubric_id = rub.Id\r\n\t\t\tGROUP BY rub.Id\r\n\t\t\tLIMIT " . $set_start . "," . $page_limit);
while ($row = $sql->FetchRow()) {
array_push($rubrics, $row);
}
$AVE_Template->assign('rubrics', $rubrics);
}
public function index()
{
$this->load->model('admin/tecniche_model');
// Setto il titolo della pagina
$data['titolo'] = "DiconArt - Gestione tecniche";
$data["cerca"] = isset($_GET["cerca"]) ? $_GET["cerca"] : "";
// Gestione della paginazione
$data["total_rows"] = $config["total_rows"] = $this->tecniche_model->count_tecniche($data["cerca"]);
$base_url = base_url() . "admin/tecniche/index/";
$pagination = get_pagination($base_url);
$this->pagination->initialize($config);
// Prende i dati delle tecniche
$data['lista_tecniche'] = $this->tecniche_model->lista_tecniche($data["cerca"], $pagination["per_page"], $pagination["offset"]);
$data["pagination"] = $this->pagination->create_links();
$data['javascript_files'] = array('plugins/jquery.tablesorter.min.js', 'admin/functions.js');
// Stampo la pagina di lista delle tecniche
$data["page"] = "lista_tecniche";
$content = array('admin/pages/tecniche/lista', 'admin/modals/cancella');
$this->render($content, $data);
}
/**
* Вывод списка рассылок
*
* @param string $tpl_dir путь к директории с шаблонами модуля
*/
function newsletterList($tpl_dir)
{
global $AVE_DB, $AVE_Template;
$db_extra = '';
$nav_string = '';
if (!empty($_REQUEST['q'])) {
$query = preg_replace('/[^ +_A-Za-zА-Яа-яЁёЇЄІїєі0-9-]/s', '', $_REQUEST['q']);
$db_extra = " WHERE newsletter_title LIKE '%{$query}%' OR newsletter_message LIKE '%{$query}%' ";
$nav_string = "&q={$query}";
}
$num = $AVE_DB->Query("\r\n\t\t\tSELECT COUNT(*)\r\n\t\t\tFROM " . PREFIX . "_modul_newsletter\r\n\t\t\t" . $db_extra . "\r\n\t\t\tORDER BY id DESC\r\n\t\t")->GetCell();
$limit = 20;
@($pages = @ceil($num / $limit));
$start = get_current_page() * $limit - $limit;
$items = array();
$sql = $AVE_DB->Query("\r\n\t\t\tSELECT *\r\n\t\t\tFROM " . PREFIX . "_modul_newsletter\r\n\t\t\t" . $db_extra . "\r\n\t\t\tORDER BY Id DESC\r\n\t\t\tLIMIT " . $start . "," . $limit);
while ($row = $sql->FetchRow()) {
$s = $AVE_DB->Query("\r\n\t\t\t\tSELECT user_group_name\r\n\t\t\t\tFROM " . PREFIX . "_user_groups\r\n\t\t\t\tWHERE user_group = " . implode(' OR user_group = ', explode(';', $row->newsletter_groups)));
$e = array();
while ($r = $s->FetchRow()) {
array_push($e, $r);
}
$row->newsletter_attach = explode(';', $row->newsletter_attach);
$row->newsletter_groups = $e;
array_push($items, $row);
}
if ($num > $limit) {
$page_nav = " <a class=\"pnav\" href=\"index.php?do=modules&action=modedit&mod=newsletter&moduleaction=1" . $nav_string . "&page={s}&cp=" . SESSION . "\">{t}</a> ";
$page_nav = get_pagination($pages, 'page', $page_nav);
$AVE_Template->assign('page_nav', $page_nav);
}
$AVE_Template->assign('items', $items);
$AVE_Template->assign('content', $AVE_Template->fetch($tpl_dir . 'start.tpl'));
}
$post->group_ids = @explode(",", $post->GRUPPEN_IDS);
if (array_intersect($post->group_ids, $my_group_id)) {
// soll bbcode verwendet werden
if ($post->use_bbcode == 1) {
$post->message = $this->kcodes($post->message);
} else {
$post->message = nl2br($post->message);
}
} else {
$post->message = $mod['config_vars']['FORUMS_DENIED_TEXT'];
$post->flink = 'no';
}
$post->message = @$this->badwordreplace($post->message);
$post->message = $this->high($post->message);
$post->message = SMILIES == 1 && $post->use_smilies == 1 ? $this->replaceWithSmileys($post->message) : $post->message;
$matches[] = $post;
}
if ($num > $limit) {
$id = !is_numeric($_REQUEST['id']) ? 1 : $_REQUEST['id'];
$page_nav = " <a class=\"page_navigation\" href=\"index.php?module=forums&show=userpostings&user_id=" . $_GET['user_id'] . "&page={s}&pp=" . $limit . "\">{t}</a> ";
$page_nav = get_pagination($seiten, 'page', $page_nav);
$AVE_Template->assign('pages', $page_nav);
}
$AVE_Template->assign("matches", $matches);
$AVE_Template->assign("post_count", $num);
define("MODULE_CONTENT", $AVE_Template->fetch($mod['tpl_dir'] . 'showpost.tpl'));
define("MODULE_SITE", $mod['config_vars']['FORUMS_USER_POSTINGS']);
} else {
header("Location:index.php?module=forums");
exit;
}
<div class="post-row">
<div class="row-fluid">
<?php
// Use specific post-format template: aside, image, gallery, etc...
get_template_part('templates/post', get_post_format());
?>
</div>
</div><!-- .row-fluid -->
</article><!-- #post -->
<?php
}
// Pagination
$paging = isset($custom_query->query['paging']) && $custom_query->query['paging'] == 'false' ? false : true;
if ($paging) {
get_pagination($the_query);
}
// clean up
unset($the_query);
if (isset($custom_query)) {
unset($custom_query);
}
} else {
// No Posts Found
// ------------------------------------------------------------------
?>
<article id="post-0" class="post no-results not-found">
<header class="entry-header">
<h1 class="entry-title"><?php
_e('Sorry, no blog posts were found.', 'framework');
?>
/**
* Метод, предназначенный для просмотра сообщений отправленных пользователями.
* Данный метод работает в двух режимах:
* 1) Просмотр входящих или исходящих сообщений списком
* 2) Полный просмотр любого сообщения
*
* @param string $tpl_dir путь к папке с шаблонами
* @param int $contact_form_id идентификатор формы
* @param string $newold сообщение без ответа new
*/
function contactMessageShow($tpl_dir, $contact_form_id, $newold = '')
{
global $AVE_DB, $AVE_Template;
// Определяем, пришел ли запрос на полный просмотр сообщения
switch ($_REQUEST['sub']) {
// Если нет, тогда
case '':
// Определяем условия просмотра (прочитанные или новые)
$n_o = $newold == 'new' ? 'AND contact_form_out_date < 1' : 'AND contact_form_out_date > 1';
$new_old = $newold == 'new' ? 'showmessages_new' : 'showmessages_old';
// Выполняем запрос к БД на получение списка сообщений согласно условиям
$num = $AVE_DB->Query("\r\n\t\t\t\t\tSELECT COUNT(*)\r\n\t\t\t\t\tFROM " . PREFIX . "_modul_contact_info\r\n\t\t\t\t\tWHERE contact_form_id = '" . $contact_form_id . "'\r\n\t\t\t\t\t" . $n_o . "\r\n\t\t\t\t")->GetCell();
// Формируем условия для выборки опредленного диапазона сообщений, в зависимости от
// номера страницы при постраницной навигации
$limit = $this->_adminlimit;
$seiten = ceil($num / $limit);
$start = get_current_page() * $limit - $limit;
// Выполняем запрос к БД на получение сообщений с учетом всех условий выборки
$items = array();
$sql = $AVE_DB->Query("\r\n\t\t\t\t\tSELECT *\r\n\t\t\t\t\tFROM " . PREFIX . "_modul_contact_info\r\n\t\t\t\t\tWHERE contact_form_id = '" . $contact_form_id . "'\r\n\t\t\t\t\t" . $n_o . "\r\n\t\t\t\t\tORDER BY contact_form_in_date DESC\r\n\t\t\t\t\tLIMIT " . $start . "," . $limit);
while ($row = $sql->FetchRow()) {
array_push($items, $row);
}
$sql->Close();
// Если количество сообщений превышает максимально-допустимый лимит на странице, тогла
// формируем постраничную навигацию.
if ($num > $limit) {
$page_nav = " <a class=\"pnav\" href=\"index.php?do=modules&action=modedit&mod=contact&moduleaction=" . $new_old . "&cp=" . SESSION . "&page={s}&id=" . intval($_REQUEST['id']) . "\">{t}</a> ";
$page_nav = get_pagination($seiten, 'page', $page_nav);
$AVE_Template->assign('page_nav', $page_nav);
}
// Передаем данные в шаблон и выводим
$AVE_Template->assign('items', $items);
$AVE_Template->assign('content', $AVE_Template->fetch($tpl_dir . 'admin_messages.tpl'));
break;
// Если да
// Если да
case 'view':
// Выполняем запрос к БД и получаем полную информацию о просматриваемом сообщении
$row = $AVE_DB->Query("\r\n\t\t\t\t\tSELECT *\r\n\t\t\t\t\tFROM " . PREFIX . "_modul_contact_info\r\n\t\t\t\t\tWHERE Id = '" . $_REQUEST['id'] . "'\r\n\t\t\t\t")->FetchRow();
$attachments = '';
// Если сообщение имеет прикрепленные файлы, тогда получаем названия файлов
if ($row->contact_form_in_attachment != '') {
$attachments = array();
$attachments_arr = explode(';', $row->contact_form_in_attachment);
foreach ($attachments_arr as $attachment) {
$row_a->name = $attachment;
$row_a->size = round(filesize(BASE_DIR . '/attachments/' . $attachment) / 1024, 2);
array_push($attachments, $row_a);
$row_a = '';
}
}
// Приводим текст сообщения к правильному формату и передаем в шаблон полученные данные
$row->nl2brText = nl2br(stripslashes($row->contact_form_in_message));
$row->replytext = $row->contact_form_in_message;
$AVE_Template->assign('attachments', $attachments);
$AVE_Template->assign('row', $row);
// Отображаем данные
$AVE_Template->assign('content', $AVE_Template->fetch($tpl_dir . 'admin_messageform.tpl'));
break;
}
}
/**
* Метод отображения списка стран
*
*/
function settingsCountriesList()
{
global $AVE_DB, $AVE_Template;
$sql = $AVE_DB->Query("\r\n\t\t\tSELECT SQL_CALC_FOUND_ROWS *\r\n\t\t\tFROM " . PREFIX . "_countries\r\n\t\t\tORDER BY country_status ASC, country_name ASC\r\n\t\t\tLIMIT " . (get_current_page() * $this->_limit - $this->_limit) . "," . $this->_limit);
$laender = array();
while ($row = $sql->FetchAssocArray()) {
array_push($laender, $row);
}
$num = $AVE_DB->Query("SELECT FOUND_ROWS()")->GetCell();
if ($num > $this->_limit) {
$page_nav = " <a class=\"pnav\" href=\"index.php?do=settings&sub=countries&page={s}&cp=" . SESSION . "\">{t}</a> ";
$page_nav = get_pagination(ceil($num / $this->_limit), 'page', $page_nav);
$AVE_Template->assign('page_nav', $page_nav);
}
$AVE_Template->assign('laender', $laender);
$AVE_Template->assign('content', $AVE_Template->fetch('settings/settings_countries.tpl'));
}
/**
* Формирование спискка учетных записей пользователей
*
* @param int $user_group_id идентификатор Группы пользователей
*/
function userListFetch($user_group_id = '')
{
global $AVE_DB, $AVE_Template;
$search_by_group = '';
$search_by_id_or_name = '';
$user_group_navi = '';
$query_navi = '';
$status_search = '';
$status_navi = '';
if (isset($_REQUEST['user_group']) && $_REQUEST['user_group'] != '0') {
$user_group_id = $user_group_id != '' ? $user_group_id : $_REQUEST['user_group'];
$user_group_navi = '&user_group=' . $user_group_id;
$search_by_group = " AND user_group = '" . $user_group_id . "' ";
}
if (!empty($_REQUEST['query'])) {
$q = urldecode($_REQUEST['query']);
$search_by_id_or_name = "\r\n\t\t\t\tAND (email LIKE '%" . $q . "%'\r\n\t\t\t\tOR email = '" . $q . "'\r\n\t\t\t\tOR Id = '" . $q . "'\r\n\t\t\t\tOR firstname LIKE '" . $q . "%'\r\n\t\t\t\tOR lastname LIKE '" . $q . "%')\r\n\t\t\t";
$query_navi = '&query=' . urlencode($_REQUEST['query']);
}
if (isset($_REQUEST['status']) && $_REQUEST['status'] != 'all') {
$status_search = " AND status = '" . $_REQUEST['status'] . "' ";
$status_navi = '&status=' . $_REQUEST['status'];
}
$num = $AVE_DB->Query("\r\n\t\t\tSELECT COUNT(*)\r\n\t\t\tFROM " . PREFIX . "_users\r\n\t\t\tWHERE 1" . $search_by_group . $search_by_id_or_name . $status_search)->GetCell();
$sql = $AVE_DB->Query("\r\n\t\t\tSELECT *\r\n\t\t\tFROM " . PREFIX . "_users\r\n\t\t\tWHERE 1" . $search_by_group . $search_by_id_or_name . $status_search . " LIMIT " . (get_current_page() * $this->_limit - $this->_limit) . "," . $this->_limit);
$isShop = $AVE_DB->Query("SHOW TABLES LIKE '" . PREFIX . "_modul_shop_bestellungen'")->GetCell();
$users = array();
while ($row = $sql->FetchRow()) {
// для комментариев
$sqla = $AVE_DB->Query("SELECT * FROM " . PREFIX . "_modul_comment_info WHERE comment_author_id = '" . (int) $row->Id . "'");
$row->comments = $sqla->numrows();
array_push($users, $row);
}
if ($num > $this->_limit) {
$page_nav = ' <a class="pnav" href="index.php?do=user' . $status_navi . '&page={s}&cp=' . SESSION . $user_group_navi . $query_navi . '">{t}</a> ';
$page_nav = get_pagination(ceil($num / $this->_limit), 'page', $page_nav);
$AVE_Template->assign('page_nav', $page_nav);
}
$AVE_Template->assign('ugroups', $this->userGroupListGet());
$AVE_Template->assign('users', $users);
}
echo $priceinfoObj->ID;
?>
" style="display:none;">
<td colspan="6">
<?php
deal_list_perauthor($priceinfoObj->ID);
?>
</td>
</tr>
<?php
}
}
?>
<tr><td colspan="6" align="center">
<?php
if ($total_pages > $recordsperpage) {
echo get_pagination($targetpage, $total_pages, $recordsperpage, $pagination, '#option_saller_report');
}
?>
</td></tr>
</thead>
</table>
<?php
} else {
?>
<strong><?php
_e('No Transaction Available');
?>
</strong>
<?php
}
* @filesource
*/
if (!defined("USERPOP")) {
exit;
}
global $AVE_DB, $AVE_Template, $mod;
$limit = 20;
$Phrase = isset($_REQUEST['Phrase']) && $_REQUEST['Phrase'] != '' && $_REQUEST['Phrase'] > 0 && is_numeric($_REQUEST['Phrase']) && $_REQUEST['Phrase'] == 1 ? " = " : " LIKE ";
$searchUser = isset($_REQUEST['uname']) && !empty($_REQUEST['uname']) ? " a.uname {$Phrase} '" . addslashes($_REQUEST['uname']) . "%%' AND " : "";
$query = "SELECT\r\n\t\ta.pn_receipt,\r\n\t\ta.uname,\r\n\t\ta.uid,\r\n\t\tb.Id,\r\n\t\tb.status\r\n\tFROM\r\n\t\t" . PREFIX . "_modul_forum_userprofile as a,\r\n\t\t" . PREFIX . "_users as b\r\n\tWHERE\r\n\t\ta.uid = b.Id AND\r\n\t\ta.pn_receipt = '1' AND\r\n\t\t" . $searchUser . "\r\n\t\tb.status = '1'\r\n\tORDER BY\r\n\t\ta.uname ASC\r\n";
$r_poster = $AVE_DB->Query($query);
$num = $r_poster->NumRows();
$num_pages = ceil($num / $limit);
$a = get_current_page() * $limit - $limit;
$r_poster = $AVE_DB->Query($query . "LIMIT {$a},{$limit}");
$poster = array();
while ($post = $r_poster->FetchRow()) {
$poster[] = $post;
}
$AVE_Template->assign("poster", $poster);
//=======================================================
// Navigation erzeugen
//=======================================================
if ($num > $limit) {
$nav = " <a class=\"page_navigation\" href=\"index.php?module=forums&show=userpop&pop=1&theme_folder=" . $_GET['theme_folder'] . "&uname=" . @$_REQUEST['uname'] . "&Phrase=" . @$_REQUEST['Phrase'] . "&page={s}\">{t}</a> ";
$nav = get_pagination($num_pages, 'page', $nav);
$AVE_Template->assign("nav", $nav);
}
$tpl_out = $AVE_Template->fetch($mod['tpl_dir'] . "users.tpl");
define("MODULE_CONTENT", $tpl_out);
define("MODULE_SITE", $mod['config_vars']['FORUMS_USERPOP_NAME']);
/**
* Метод вывода списка опросов
*
* @param string $tpl_dir путь к папке с шаблонами модуля
* @param string $lang_file путь к языковому файлу модуля
*/
function pollList($tpl_dir, $lang_file)
{
global $AVE_DB, $AVE_Template;
$AVE_Template->config_load($lang_file, 'showpolls');
$num = $AVE_DB->Query("SELECT COUNT(*) FROM " . PREFIX . "_modul_poll")->GetCell();
$limit = $this->_adminlimit;
$pages = ceil($num / $limit);
$start = get_current_page() * $limit - $limit;
$items = array();
$sql = $AVE_DB->Query("\r\n\t\t\tSELECT *\r\n\t\t\tFROM " . PREFIX . "_modul_poll\r\n\t\t\tLIMIT " . $start . "," . $limit);
while ($row = $sql->FetchRow()) {
$row_hits = $AVE_DB->Query("\r\n\t\t\t\tSELECT SUM(poll_item_hits)\r\n\t\t\t\tFROM " . PREFIX . "_modul_poll_items\r\n\t\t\t\tWHERE poll_id = '" . $row->id . "'\r\n\t\t\t\tGROUP BY poll_id\r\n\t\t\t")->GetCell();
$row->sum_hits = floor($row_hits);
$row->comments = $AVE_DB->Query("\r\n\t\t\t\tSELECT COUNT(*)\r\n\t\t\t\tFROM " . PREFIX . "_modul_poll_comments\r\n\t\t\t\tWHERE poll_id = '" . $row->id . "'\r\n\t\t\t")->GetCell();
array_push($items, $row);
}
if ($num > $limit) {
$page_nav = " <a class=\"pnav\" href=\"index.php?do=modules&action=modedit&mod=poll&moduleaction=1&cp=" . SESSION . "&page={s}\">{t}</a> ";
$page_nav = get_pagination($pages, 'page', $page_nav);
$AVE_Template->assign('page_nav', $page_nav);
}
$AVE_Template->assign('items', $items);
$AVE_Template->assign('content', $AVE_Template->fetch($tpl_dir . 'admin_forms.tpl'));
}
public function ricerca()
{
$this->load->model('admin/opere_model');
$this->load->model('admin/soggetti_model');
$this->load->model('admin/autori_model');
$this->load->model('admin/soggetti_model');
$this->load->model('admin/luoghi_model');
$this->load->model('admin/tecniche_model');
$this->load->model('admin/correnti_model');
// Setto il titolo della pagina
$data['titolo'] = "DiconArt - Ricerca opere";
// Gestione della paginazione
$base_url = base_url() . "admin/opere/ricerca/";
$pagination = get_pagination($base_url);
// Recupero il parametro di ricerca e i filtri
$cerca = $data["cerca"] = isset($_GET["cerca"]) ? $_GET["cerca"] : "";
// Filtro autore
$data["id_autore"] = isset($_GET["id_autore"]) ? $_GET["id_autore"] : "";
$data["autore"] = isset($_GET["autore"]) ? $_GET["autore"] : "";
if ($data["autore"] === "") {
$data["id_autore"] = "";
}
// Filtro luogo
$data["id_luogo"] = isset($_GET["id_luogo"]) ? $_GET["id_luogo"] : "";
$data["luogo"] = isset($_GET["luogo"]) ? $_GET["luogo"] : "";
if ($data["luogo"] === "") {
$data["id_luogo"] = "";
}
// Filtro soggetto
$data["soggetti"] = $soggetti_selezionati = isset($_GET["soggetti_selezionati"]) ? $_GET["soggetti_selezionati"] : "";
if (strpos($soggetti_selezionati, ",") !== FALSE) {
$soggetti = explode(",", trim($soggetti_selezionati));
} else {
$soggetti = explode(" ", trim($soggetti_selezionati));
}
if ($soggetti_selezionati != "") {
$data["dati_soggetti"] = array();
foreach ($soggetti as $soggetto) {
array_push($data["dati_soggetti"], array("id_soggetto" => $soggetto, "nome_soggetto" => $this->soggetti_model->dati_soggetto($soggetto)[0]->nome));
}
}
// Filtro tecnica
$data["id_tecnica"] = isset($_GET["id_tecnica"]) ? $_GET["id_tecnica"] : "";
$data["tecnica"] = isset($_GET["tecnica"]) ? $_GET["tecnica"] : "";
if ($data["tecnica"] === "") {
$data["id_tecnica"] = "";
}
// Filtro corrente
$data["id_corrente"] = isset($_GET["id_corrente"]) ? $_GET["id_corrente"] : "";
$data["corrente"] = isset($_GET["corrente"]) ? $_GET["corrente"] : "";
if ($data["corrente"] === "") {
$data["id_corrente"] = "";
}
// Filtro anno
$from_filter = $data["from_filter"] = isset($_GET["from-filter"]) ? $_GET["from-filter"] : "dc";
$from_year = $data["from_year"] = isset($_GET["from-year"]) ? $_GET["from-year"] : "";
$to_filter = $data["to_filter"] = isset($_GET["to-filter"]) ? $_GET["to-filter"] : "dc";
$to_year = $data["to_year"] = isset($_GET["to-year"]) ? $_GET["to-year"] : "";
// Se cerco con la ricerca avanzata tiene aperto il box
if ($data["autore"] !== "" || $data["luogo"] !== "" || $data["soggetti"] !== "" || $data["tecnica"] !== "" || $data["corrente"] !== "" || $data["from_year"] !== "" || $data["to_year"] !== "") {
$data["ricerca_avanzata"] = "visible";
$data["filter_class"] = "active";
} else {
$data["ricerca_avanzata"] = "";
$data["filter_class"] = "";
}
// Numero totale di risultati
$data["total_rows"] = $this->opere_model->count_opere($cerca, $data["id_autore"], $data["id_luogo"], $data["soggetti"], $data["id_tecnica"], $data["id_corrente"], $from_year, $from_filter, $to_year, $to_filter);
// Risultati
$data["lista_opere"] = $this->opere_model->lista_opere($cerca, $pagination["per_page"], $pagination["offset"], $data["id_autore"], $data["id_luogo"], $data["soggetti"], $data["id_tecnica"], $data["id_corrente"], $from_year, $from_filter, $to_year, $to_filter);
foreach ($data['lista_opere'] as $k => $opera) {
$data['lista_opere'][$k]->soggetti = $this->soggetti_model->dati_soggetti($opera->id);
}
// Inizializzo e creo i link della paginazione
$config["total_rows"] = $data["total_rows"];
$this->pagination->initialize($config);
$data["pagination"] = $this->pagination->create_links();
$data['javascript_files'] = array('http://maps.googleapis.com/maps/api/js?sensor=false&libraries=places', 'plugins/gmaps.js', 'plugins/jquery.geocomplete.js', "plugins/jquery.tablesorter.min.js", 'plugins/typeahead.bundle.js', 'plugins/select2/select2.min.js', "admin/opere/ricerca.js", "admin/functions.js");
// Stampo la pagina di lista delle opere
$data["page"] = "ricerca";
$content = array("admin/pages/opere/ricerca", "admin/pages/opere/lista", "admin/modals/cancella");
$this->render($content, $data);
}
/**
* builds pagination information from a result set and slices the result set to return the current_page of results
*
* @param string $results
* @param string $current_page
* @param string $per_page
* @return array
* @author Craig Ulliott
*/
function paginate($results, $current_page = 1, $per_page = 5)
{
$record_count = count($results);
$pagination = get_pagination($record_count, $current_page, $per_page);
// slice the results array
$result_subset = array_slice($results, ($current_page - 1) * $per_page, $per_page, true);
return array($pagination, $result_subset);
}
/**
* Обработка тега запроса.
* Возвращает список документов удовлетворяющих параметрам запроса
* оформленный с использованием шаблона
*
* @param int $id идентификатор запроса
* @return string
*/
function request_parse($id)
{
global $AVE_Core, $AVE_DB, $request_documents;
$return = '';
if (is_array($id)) {
$id = $id[1];
}
$row_ab = $AVE_DB->Query("\r\n\t\tSELECT *\r\n\t\tFROM " . PREFIX . "_request\r\n\t\tWHERE Id = '" . $id . "'\r\n\t")->FetchRow();
if (is_object($row_ab)) {
$ttl = (int) $row_ab->request_cache_lifetime;
$limit = $row_ab->request_items_per_page < 1 ? 1 : $row_ab->request_items_per_page;
$main_template = $row_ab->request_template_main;
$item_template = $row_ab->request_template_item;
$request_order_by = $row_ab->request_order_by;
$request_asc_desc = $row_ab->request_asc_desc;
$request_order = $request_order_by . " " . $request_asc_desc;
$request_order_fields = '';
$request_order_tables = '';
if ($row_ab->request_order_by_nat) {
$request_order_tables = "LEFT JOIN " . PREFIX . "_document_fields AS s" . $row_ab->request_order_by_nat . "\r\n\t\t\t ON (s" . $row_ab->request_order_by_nat . ".document_id = a.Id and s" . $row_ab->request_order_by_nat . ".rubric_field_id=" . $row_ab->request_order_by_nat . ")";
$request_order_fields = "s" . $row_ab->request_order_by_nat . ".field_value, ";
$request_order = "s" . $row_ab->request_order_by_nat . ".field_value " . $row_ab->request_asc_desc;
}
$doctime = get_settings('use_doctime') ? "AND a.document_published <= UNIX_TIMESTAMP() AND\r\n \t\t \t(a.document_expire = 0 OR a.document_expire >=UNIX_TIMESTAMP())" : '';
$where_cond = empty($_POST['req_' . $id]) && empty($_SESSION['doc_' . $AVE_Core->curentdoc->Id]['req_' . $id]) ? unserialize($row_ab->request_where_cond) : unserialize(request_get_condition_sql_string($row_ab->Id));
$where_cond['from'] = str_replace('%%PREFIX%%', PREFIX, $where_cond['from']);
$where_cond['where'] = str_replace('%%PREFIX%%', PREFIX, $where_cond['where']);
if ($row_ab->request_show_pagination == 1) {
if (!empty($AVE_Core->install_modules['comment']->Status)) {
$num = $AVE_DB->Query(eval2var(" ?> \r\n\t\t\t\t\tSELECT COUNT(*)\r\n\t\t\t\t\tFROM \r\n\t\t\t\t\t" . ($where_cond['from'] ? $where_cond['from'] : '') . "\r\n\t\t\t\t\t" . PREFIX . "_documents AS a\r\n\t\t\t\t\tWHERE\r\n\t\t\t\t\t\ta.Id != '1'\r\n\t\t\t\t\tAND a.Id != '" . PAGE_NOT_FOUND_ID . "'\r\n\t\t\t\t\tAND a.Id != '" . get_current_document_id() . "'\r\n\t\t\t\t\tAND a.rubric_id = '" . $row_ab->rubric_id . "'\r\n\t\t\t\t\tAND a.document_deleted != '1'\r\n\t\t\t\t\tAND a.document_status != '0'\r\n\t\t\t\t\t" . $where_cond['where'] . "\r\n\t\t\t\t\t" . $doctime . "\r\n\t\t\t\t<?php "), $ttl, 'rub_' . $row_ab->rubric_id)->GetCell();
} else {
$num = $AVE_DB->Query(eval2var(" ?>\r\n\t\t\t\t\tSELECT COUNT(*)\r\n\t\t\t\t\tFROM \r\n\t\t\t\t\t" . ($where_cond['from'] ? $where_cond['from'] : '') . "\r\n\t\t\t\t\t" . PREFIX . "_documents AS a\r\n\t\t\t\t\tWHERE\r\n\t\t\t\t\t\ta.Id != '1'\r\n\t\t\t\t\tAND a.Id != '" . PAGE_NOT_FOUND_ID . "'\r\n\t\t\t\t\tAND a.Id != '" . get_current_document_id() . "'\r\n\t\t\t\t\tAND a.rubric_id = '" . $row_ab->rubric_id . "'\r\n\t\t\t\t\tAND a.document_deleted != '1'\r\n\t\t\t\t\tAND a.document_status != '0'\r\n\t\t\t\t\t" . $where_cond['where'] . "\r\n\t\t\t\t\t" . $doctime . "\r\n\t\t\t\t<?php "), $ttl, 'rub_' . $row_ab->rubric_id)->GetCell();
}
$seiten = ceil($num / $limit);
if (isset($_REQUEST['apage']) && is_numeric($_REQUEST['apage']) && $_REQUEST['apage'] > $seiten) {
$redirect_link = rewrite_link('index.php?id=' . $AVE_Core->curentdoc->Id . '&doc=' . (empty($AVE_Core->curentdoc->document_alias) ? prepare_url($AVE_Core->curentdoc->document_title) : $AVE_Core->curentdoc->document_alias) . (isset($_REQUEST['artpage']) && is_numeric($_REQUEST['artpage']) ? '&artpage=' . $_REQUEST['artpage'] : '') . (isset($_REQUEST['page']) && is_numeric($_REQUEST['page']) ? '&page=' . $_REQUEST['page'] : ''));
header('Location:' . $redirect_link);
exit;
}
$start = get_current_page('apage') * $limit - $limit;
} else {
$start = 0;
}
if ($row_ab->request_items_per_page != 0) {
$filter_limit = "LIMIT " . $start . "," . $limit;
}
if (!empty($AVE_Core->install_modules['comment']->Status)) {
$q = " ?>\r\n\t\t\t\tSELECT\r\n\t\t\t\t\t" . $request_order_fields . "\r\n\t\t\t\t\ta.Id,\r\n\t\t\t\t\ta.document_title,\r\n\t\t\t\t\ta.document_alias,\r\n\t\t\t\t\ta.document_author_id,\r\n\t\t\t\t\ta.document_count_view,\r\n\t\t\t\t\ta.document_published,\r\n\t\t\t\t\tCOUNT(b.document_id) AS nums\r\n\t\t\t\tFROM\r\n\t\t\t\t\t" . ($where_cond['from'] ? $where_cond['from'] : '') . "\r\n\t\t\t\t\t" . PREFIX . "_documents AS a\r\n\t\t\t\tLEFT JOIN\r\n\t\t\t\t\t" . PREFIX . "_modul_comment_info AS b\r\n\t\t\t\t\t\tON b.document_id = a.Id\r\n\t\t\t\t " . ($request_order_tables > '' ? $request_order_tables : '') . "\t\r\n\t\t\t\tWHERE\r\n\t\t\t\t\ta.Id != '1'\r\n\t\t\t\tAND a.Id != '" . PAGE_NOT_FOUND_ID . "'\r\n\t\t\t\tAND a.Id != '" . get_current_document_id() . "'\r\n\t\t\t\tAND a.rubric_id = '" . $row_ab->rubric_id . "'\r\n\t\t\t\tAND a.document_deleted != '1'\r\n\t\t\t\tAND a.document_status != '0'\r\n\t\t\t\t" . $where_cond['where'] . "\r\n\t\t\t\t" . $doctime . "\r\n\t\t\t\tGROUP BY a.Id\r\n\t\t\t\tORDER BY " . $request_order . "\r\n\t\t\t\t" . $filter_limit . " <?php ";
} else {
$q = " ?>\r\n\t\t\t\tSELECT\r\n\t\t\t\t\t" . $request_order_fields . "\r\n\t\t\t\t\ta.Id,\r\n\t\t\t\t\ta.document_title,\r\n\t\t\t\t\ta.document_alias,\r\n\t\t\t\t\ta.document_author_id,\r\n\t\t\t\t\ta.document_count_view,\r\n\t\t\t\t\ta.document_published\r\n\t\t\t\tFROM\r\n\t\t\t\t\t" . ($where_cond['from'] ? $where_cond['from'] : '') . "\r\n\t\t\t\t\t\r\n\t\t\t\t\t" . PREFIX . "_documents AS a\r\n\t\t\t\t\t" . ($request_order_tables > '' ? $request_order_tables : "") . "\r\n\t\t\t\tWHERE\r\n\t\t\t\t\ta.Id != '1'\r\n\t\t\t\tAND a.Id != '" . PAGE_NOT_FOUND_ID . "'\r\n\t\t\t\tAND a.Id != '" . get_current_document_id() . "'\r\n\t\t\t\tAND a.rubric_id = '" . $row_ab->rubric_id . "'\r\n\t\t\t\tAND a.document_deleted != '1'\r\n\t\t\t\tAND a.document_status != '0'\r\n\t\t\t\t" . $where_cond['where'] . "\r\n\t\t\t\t" . $doctime . "\r\n\t\t\t\tORDER BY " . $request_order . "\r\n\t\t\t\t" . $filter_limit . " <?php ";
}
$q = eval2var($q);
$q = $AVE_DB->Query($q, $ttl, 'rub_' . $row_ab->rubric_id);
if ($q->NumRows() > 0) {
$main_template = preg_replace('/\\[tag:if_empty](.*?)\\[\\/tag:if_empty]/si', '', $main_template);
$main_template = str_replace(array('[tag:if_notempty]', '[/tag:if_notempty]'), '', $main_template);
} else {
$main_template = preg_replace('/\\[tag:if_notempty](.*?)\\[\\/tag:if_notempty]/si', '', $main_template);
$main_template = str_replace(array('[tag:if_empty]', '[/tag:if_empty]'), '', $main_template);
}
$page_nav = '';
if ($row_ab->request_show_pagination == 1 && $seiten > 1 && $row_ab->request_items_per_page != 0) {
$page_nav = ' <a class="pnav" href="index.php?id=' . $AVE_Core->curentdoc->Id . '&doc=' . (empty($AVE_Core->curentdoc->document_alias) ? prepare_url($AVE_Core->curentdoc->document_title) : $AVE_Core->curentdoc->document_alias) . (isset($_REQUEST['artpage']) && is_numeric($_REQUEST['artpage']) ? '&artpage=' . $_REQUEST['artpage'] : '') . '&apage={s}' . (isset($_REQUEST['page']) && is_numeric($_REQUEST['page']) ? '&page=' . $_REQUEST['page'] : '') . '">{t}</a> ';
$page_nav = get_pagination($seiten, 'apage', $page_nav, get_settings('navi_box'));
$page_nav = rewrite_link($page_nav);
}
$rows = array();
$request_documents = array();
while ($row = $q->FetchRow()) {
array_push($request_documents, $row->Id);
array_push($rows, $row);
}
$items = '';
foreach ($rows as $row) {
$cachefile_docid = BASE_DIR . '/cache/sql/doc_' . $row->Id . '/request-' . $id . '.cache';
if (!file_exists($cachefile_docid)) {
$item = preg_replace('/\\[tag:rfld:(\\d+)]\\[(more|esc|[0-9-]+)]/e', "request_get_document_field(\"\$1\", {$row->Id}, \"\$2\")", $item_template);
//if(!file_exists(dirname($cachefile_docid)))mkdir(dirname($cachefile_docid),0777,true);
//file_put_contents($cachefile_docid,$item);
} else {
$item = file_get_contents($cachefile_docid);
}
$link = rewrite_link('index.php?id=' . $row->Id . '&doc=' . (empty($row->document_alias) ? prepare_url($row->document_title) : $row->document_alias));
$item = str_replace('[tag:link]', $link, $item);
$item = str_replace('[tag:docid]', $row->Id, $item);
$item = str_replace('[tag:doctitle]', $row->document_title, $item);
$item = str_replace('[tag:docparent]', $row->document_parent, $item);
$item = str_replace('[tag:docdate]', pretty_date(strftime(DATE_FORMAT, $row->document_published)), $item);
$item = str_replace('[tag:doctime]', pretty_date(strftime(TIME_FORMAT, $row->document_published)), $item);
$item = str_replace('[tag:docauthor]', get_username_by_id($row->document_author_id), $item);
$item = str_replace('[tag:docviews]', $row->document_count_view, $item);
$item = str_replace('[tag:doccomments]', isset($row->nums) ? $row->nums : '', $item);
$items .= $item;
}
$main_template = str_replace('[tag:pages]', $page_nav, $main_template);
$main_template = str_replace('[tag:doctotal]', $seiten * $q->NumRows(), $main_template);
$main_template = str_replace('[tag:pagetitle]', $AVE_DB->Query("SELECT document_title FROM " . PREFIX . "_documents WHERE Id = '" . $AVE_Core->curentdoc->Id . "' ")->GetCell(), $main_template);
$main_template = str_replace('[tag:docid]', $AVE_Core->curentdoc->Id, $main_template);
$main_template = str_replace('[tag:docdate]', pretty_date(strftime(DATE_FORMAT, $AVE_Core->curentdoc->document_published)), $main_template);
$main_template = str_replace('[tag:doctime]', pretty_date(strftime(TIME_FORMAT, $AVE_Core->curentdoc->document_published)), $main_template);
$main_template = str_replace('[tag:docauthor]', get_username_by_id($AVE_Core->curentdoc->document_author_id), $main_template);
$main_template = preg_replace('/\\[tag:dropdown:([,0-9]+)\\]/e', "request_get_dropdown(\"\$1\", " . $row_ab->rubric_id . ", " . $row_ab->Id . ");", $main_template);
$return = str_replace('[tag:content]', $items, $main_template);
$return = str_replace('[tag:path]', ABS_PATH, $return);
$return = str_replace('[tag:mediapath]', ABS_PATH . 'templates/' . THEME_FOLDER . '/', $return);
$return = $AVE_Core->coreModuleTagParse($return);
}
return $return;
}
function rt_woocommerce_pagination()
{
echo '
<!-- paging-->
<div class="paging_wrapper clearfix">
<ul class="paging">
';
get_pagination();
echo '
</ul>
</div>
';
}
<p class="crumb">Back to: <?php
echo oo_get_gallery_crumb();
?>
</p>
<?php
while (have_posts()) {
the_post();
include 'block-event-thumb125.php';
}
?>
<p> </p>
<div class="pagination clearme"><?php
get_pagination();
?>
</div>
/**
* Вывод списка галерей
*
* @param string $tpl_dir - путь к папке с шаблонами модуля
*/
function galleryListShow($tpl_dir)
{
global $AVE_DB, $AVE_Template;
if (!empty($_POST['create'])) {
foreach ($_POST['create'] as $gallery_id) {
$this->_galleryImageMove((int) $gallery_id);
}
}
$limit = $this->_limit_galleries;
$start = get_current_page() * $limit - $limit;
$galleries = array();
$sql = $AVE_DB->Query("\r\n\t\t\tSELECT SQL_CALC_FOUND_ROWS\r\n\t\t\t\tgal.*,\r\n\t\t\t\tCOUNT(img.id) AS image_count\r\n\t\t\tFROM\r\n\t\t\t\t" . PREFIX . "_modul_gallery AS gal\r\n\t\t\tLEFT JOIN\r\n\t\t\t\t" . PREFIX . "_modul_gallery_images AS img\r\n\t\t\t\t\tON img.gallery_id = gal.id\r\n\t\t\tGROUP BY gal.id\r\n\t\t\tORDER BY gal.gallery_created DESC\r\n\t\t\tLIMIT " . $start . "," . $limit . "\r\n\t\t");
$num = $AVE_DB->Query("SELECT FOUND_ROWS()")->GetCell();
while ($row = $sql->FetchAssocArray()) {
$row['username'] = get_username_by_id($row['gallery_author_id']);
array_push($galleries, $row);
}
if ($num > $limit) {
$page_nav = ' <a class="pnav" href="index.php?do=modules&action=modedit&mod=gallery&moduleaction=1&cp=' . SESSION . '&page={s}">{t}</a> ';
$page_nav = get_pagination(ceil($num / $limit), 'page', $page_nav);
$AVE_Template->assign('page_nav', $page_nav);
}
if (!empty($_REQUEST['alert'])) {
$AVE_Template->assign('alert', htmlspecialchars(stripslashes($_REQUEST['alert'])));
}
$AVE_Template->assign('galleries', $galleries);
$AVE_Template->assign('formaction', 'index.php?do=modules&action=modedit&mod=gallery&moduleaction=new&sub=save&cp=' . SESSION);
$AVE_Template->assign('content', $AVE_Template->fetch($tpl_dir . 'admin_gallery_list.tpl'));
}
public function get_today_user_photos()
{
$limit = $this->get('limit');
$limit = $limit ? $limit : self::DEFAULT_LIMIT;
if ($limit > self::MAX_LIMIT) {
$limit = self::DEFAULT_LIMIT;
}
$temp_page = $this->get('page');
$page = $temp_page ? $temp_page : 1;
if ($page == 0) {
$page = 1;
}
$total = $this->fellowship_life_model->count_user_photos();
// var_dump($total);exit;
if ($total <= 0 || !$total) {
$this->response(array('status_code' => 400));
return;
}
if ($total < $limit && $page >= 2) {
$this->response(array('status_code' => 400));
return;
}
$this->load->helper('util_helper');
$pagination = get_pagination($total, $limit, $page);
if ($page > $pagination['page']) {
$this->response(array('status_code' => 400));
return;
}
$user_photos_results = $this->fellowship_life_model->get_all_user_photos($pagination['limit'], $pagination['offset']);
if (!isset($user_photos_results) || empty($user_photos_results)) {
$this->response(array('status_code' => 401));
return;
}
$this->response(array('status_code' => 200, 'total' => $total, 'results' => $user_photos_results));
}
function showAttachments($tpl_dir)
{
global $AVE_DB, $AVE_Template;
if (isset($_REQUEST['save']) && $_REQUEST['save'] == 1) {
if (isset($_POST['del']) && $_POST['del'] >= 1) {
foreach ($_POST['del'] as $filename => $del) {
if ($del != "") {
$result = $AVE_DB->Query("DELETE FROM " . PREFIX . "_modul_forum_attachment WHERE filename = '" . $filename . "'");
@unlink(BASE_DIR . "/modules/forums/attachments/{$filename}");
}
}
}
}
if (isset($_REQUEST['dl']) && $_REQUEST['dl'] == 1) {
$query = "SELECT filename, orig_name FROM " . PREFIX . "_modul_forum_attachment WHERE id = '" . $_GET['id'] . "'";
$result = $AVE_DB->Query($query);
$file = $result->FetchRow();
header("Cache-control: private");
header("Content-type: application/octet-stream");
header("Content-disposition:attachment; filename=" . $file->orig_name);
header("Content-Length: " . @filesize(BASE_DIR . "/modules/forums/attachments/" . $file->filename));
readfile(BASE_DIR . "/modules/forums/attachments/" . $file->filename);
exit;
}
$limit = !isset($_REQUEST['pp']) ? 10 : $_REQUEST['pp'];
$attachments = array();
$_REQUEST['sort'] = !isset($_REQUEST['sort']) ? '' : $_REQUEST['sort'];
$_REQUEST['q'] = !isset($_REQUEST['q']) ? '' : $_REQUEST['q'];
switch ($_REQUEST['sort']) {
case "name":
$ord = " ORDER BY orig_name ASC";
break;
case "hits":
$ord = "ORDER BY hits DESC";
break;
case "":
$ord = "ORDER BY hits DESC";
break;
}
$extra_ext = '';
if (!empty($_REQUEST['ext'])) {
$extra_ext = " AND ( (RIGHT(orig_name,3) = '" . $_REQUEST['ext'] . "') OR (RIGHT(orig_name,4) = '" . $_REQUEST['ext'] . "') OR (RIGHT(orig_name,5) = '" . $_REQUEST['ext'] . "') ) ";
}
$extra = "WHERE orig_name like '%" . $_REQUEST['q'] . "%' {$extra_ext} ";
$query = "SELECT id FROM " . PREFIX . "_modul_forum_attachment {$extra} {$ord}";
$result = $AVE_DB->Query($query);
$num = $result->NumRows();
$num_pages = ceil($num / $limit);
$a = get_current_page() * $limit - $limit;
$query = "SELECT * FROM " . PREFIX . "_modul_forum_attachment {$extra} {$ord} limit {$a},{$limit}";
$result = $AVE_DB->Query($query);
while ($row = $result->FetchRow()) {
$row->sizes = $this->file_size(@filesize(BASE_DIR . "/modules/forums/attachments/" . $row->filename) / 1024);
array_push($attachments, $row);
}
if ($num > $limit) {
$page_nav = " <a class=\"pnav\" href=\"index.php?do=modules&action=modedit&mod=forums&moduleaction=show_attachments&cp=" . SESSION . "&q=" . @$_REQUEST['q'] . "&sort=" . @$_REQUEST['sort'] . "&page={s}\">{t}</a> ";
$page_nav = get_pagination($num_pages, 'page', $page_nav);
$AVE_Template->assign('nav', $page_nav);
}
$AVE_Template->assign('attachments', $attachments);
$AVE_Template->assign('content', $AVE_Template->fetch($tpl_dir . 'forum_attachments.tpl'));
}
function bannerList($tpl_dir)
{
global $AVE_DB, $AVE_Template;
$limit = $this->_limit;
$num = $AVE_DB->Query("SELECT COUNT(*) FROM " . PREFIX . "_modul_banners")->GetCell();
$seiten = ceil($num / $limit);
$start = get_current_page() * $limit - $limit;
$banners = array();
$sql = $AVE_DB->Query("\r\n\t\t\tSELECT *\r\n\t\t\tFROM " . PREFIX . "_modul_banners\r\n\t\t\tLIMIT " . $start . "," . $limit);
while ($row = $sql->FetchRow()) {
array_push($banners, $row);
}
if ($num > $limit) {
$page_nav = ' <a class="pnav" href="index.php?do=modules&action=modedit&mod=' . BANNER_DIR . '&moduleaction=1&cp=' . SESSION . '&page={s}">{t}</a> ';
$page_nav = get_pagination($seiten, 'page', $page_nav);
$AVE_Template->assign('page_nav', $page_nav);
}
$AVE_Template->assign('banners', $banners);
$AVE_Template->assign('mod_path', BANNER_DIR);
$AVE_Template->assign('categories', $this->_bannerCategoryGet());
$AVE_Template->assign('content', $AVE_Template->fetch($tpl_dir . 'banners.tpl'));
}
" class="readmore_link">
<?php
_e(get_option('ptthemes_content_excerpt_readmore'));
?>
</a> </div>
</div>
</div>
<?php
$page_layout = templ_get_page_layout();
if ($page_layout == 'full_width') {
if ($pcount == 3) {
$pcount = 0;
?>
<div class="hr clearfix"></div>
<?php
}
} else {
if ($pcount == 2) {
$pcount = 0;
?>
<div class="hr clear"></div>
<?php
}
}
}
if ($all_total_pages > $recordsperpage) {
echo '<div style="text-align:right" >' . get_pagination($deal_targetpage, $all_total_pages, $recordsperpage, $all_pagination) . '</div>';
}
} else {
echo '<h3>Geen verlopen deals gevonden</h3>';
}
