/** * Метод, предназначенный для получения и вывода списка Запросов * * @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>'; }