/modules/forums/internals/userlist.php
PHP | 138 lines | 103 code | 20 blank | 15 comment | 21 complexity | 8b5e96af59556f8233868174a8f2d610 MD5 | raw file
Possible License(s): GPL-3.0, BSD-3-Clause, BSD-2-Clause, Apache-2.0, LGPL-2.1
- <?php
-
- if (!defined('USERLIST')) exit;
-
- global $AVE_DB, $AVE_Template;
-
- //// Beitragszaehler aktualisieren
- //$sql_first = $AVE_DB->Query("SELECT Id FROM " . PREFIX . "_modul_forum_userprofile");
- //while ($row_first = $sql_first->FetchRow())
- //{
- // $sql = $AVE_DB->Query("SELECT COUNT(id) AS counts FROM " . PREFIX . "_modul_forum_post WHERE uid = {$row_first->Id}");
- // while ($row = $sql->FetchRow())
- // {
- // $AVE_DB->Query("UPDATE " . PREFIX . "_modul_forum_userprofile SET Beitraege={$row->counts} WHERE BenutzerId={$row_first->Id}");
- // }
- //}
-
- // Benutzerabfrage
- $user = array();
-
- if (!empty($_REQUEST['orderby']))
- {
- $nav_link = '';
- switch ($_REQUEST['orderby'])
- {
- case 'posts_asc':
- $orderby = ' ORDER BY Beitraege ASC';
- $nav_link = '&orderby=posts_asc';
- $img_post = '<img hspace="5" border="0" src="templates/'. THEME_FOLDER.'/modules/forums/sortasc.gif" alt="" />';
- $AVE_Template->assign("img_post", $img_post);
- break;
-
- case 'posts_desc':
- $orderby = ' ORDER BY Beitraege DESC';
- $nav_link = '&orderby=posts_desc';
- $img_post = '<img hspace="5" border="0" src="templates/'. THEME_FOLDER.'/modules/forums/sortdesc.gif" alt="" />';
- $AVE_Template->assign("img_post", $img_post);
- break;
-
- case 'reg_asc':
- $orderby = ' ORDER BY reg_time ASC';
- $nav_link = '&orderby=reg_asc';
- $img_reg = '<img hspace="5" border="0" src="templates/'. THEME_FOLDER.'/modules/forums/sortasc.gif" alt="" />';
- $AVE_Template->assign("img_reg", $img_reg);
- break;
-
- case 'reg_desc':
- $orderby = ' ORDER BY reg_time DESC';
- $nav_link = '&orderby=reg_desc';
- $img_reg = '<img hspace="5" border="0" src="templates/'. THEME_FOLDER.'/modules/forums/sortdesc.gif" alt="" />';
- $AVE_Template->assign("img_reg", $img_reg);
- break;
-
- case 'name_asc':
- $orderby = ' ORDER BY BenutzerName ASC';
- $nav_link = '&orderby=name_asc';
- $img_name = '<img hspace="5" border="0" src="templates/'. THEME_FOLDER.'/modules/forums/sortasc.gif" alt="" />';
- $AVE_Template->assign("img_name", $img_name);
- break;
-
- case 'name_desc':
- $orderby = ' ORDER BY BenutzerName DESC';
- $nav_link = '&orderby=name_desc';
- $img_name = '<img hspace="5" border="0" src="templates/'. THEME_FOLDER.'/modules/forums/sortdesc.gif" alt="" />';
- $AVE_Template->assign("img_name", $img_name);
- break;
- }
- }
- else
- {
- $orderby = ' ORDER BY Beitraege DESC';
- }
-
- // Aktuelle Seite f?Œr Links
- $f_page = (!empty($_REQUEST['page']) && is_numeric($_REQUEST['page']) && $_REQUEST['page']>0)
- ? "&page=". $_REQUEST['page']
- : "";
-
- // Sortierungs-Links
- $Link_PostSort = (isset($_REQUEST['orderby']) && $_REQUEST['orderby'] == 'posts_asc')
- ? "index.php?module=forums&show=userlist&orderby=posts_desc{$f_page}"
- : "index.php?module=forums&show=userlist&orderby=posts_asc{$f_page}";
- $Link_RegSort = (isset($_REQUEST['orderby']) && $_REQUEST['orderby'] == 'reg_asc')
- ? "index.php?module=forums&show=userlist&orderby=reg_desc{$f_page}"
- : "index.php?module=forums&show=userlist&orderby=reg_asc{$f_page}";
- $Link_NameSort = (isset($_REQUEST['orderby']) && $_REQUEST['orderby'] == 'name_asc')
- ? "index.php?module=forums&show=userlist&orderby=name_desc{$f_page}"
- : "index.php?module=forums&show=userlist&orderby=name_asc{$f_page}";
-
- $limit = (isset($_REQUEST['pp']) && is_numeric($_REQUEST['pp']) && $_REQUEST['pp'] > 0 ) ? $_REQUEST['pp'] : 25;
- $limit = (isset($_REQUEST['print']) && $_REQUEST['print']==1) ? 10000 : $limit;
-
- $a = get_current_page() * $limit - $limit;
- $a = (isset($_REQUEST['print']) && $_REQUEST['print']==1) ? 0 : $a;
-
- $sql = $AVE_DB->Query("
- SELECT SQL_CALC_FOUND_ROWS *
- FROM " . PREFIX . "_modul_forum_userprofile
- " . $orderby . "
- LIMIT " . $a . "," . $limit . "
- ");
- while ($row = $sql->FetchRow())
- {
- $row->UserWeb = ($row->Webseite != '' && $row->Webseite_show==1)
- ? 'http://' . str_replace('http://', '', $row->Webseite)
- : '';
- $row->UserPN = ($row->Pnempfang==1)
- ? 'index.php?module=forums&show=pn&action=new&to=' . base64_encode($row->BenutzerName)
- : '';
- $row->UserLink = ($row->ZeigeProfil==1)
- ? "<a class=\"forum_links\" href=\"index.php?module=forums&show=userprofile&user_id={$row->BenutzerId}\">{$row->BenutzerName}</a>"
- : "$row->BenutzerName";
- $row->Posts = $this->num_format($row->Beitraege);
- if ($row->reg_time != '') array_push($user, $row);
- }
-
- $num = $AVE_DB->Query("SELECT FOUND_ROWS()")->GetCell();
- //if (!isset($page)) $page = 1;
- $seiten = $this->getPageNum($num, $limit);
-
- // Navigation
- if ($num > $limit)
- {
- $nav_link = (empty($nav_link)) ? '' : $nav_link;
- $page_nav = " <a class=\"page_navigation\" href=\"index.php?module=forums&show=userlist{$nav_link}&pp={$limit}&page={s}\">{t}</a> ";
- $page_nav = get_pagination($seiten, 'page', $page_nav);
- $AVE_Template->assign('pages', $page_nav);
- }
-
- $AVE_Template->assign("user", $user);
- $AVE_Template->assign("Link_PostSort", $Link_PostSort);
- $AVE_Template->assign("Link_RegSort", $Link_RegSort);
- $AVE_Template->assign("Link_NameSort", $Link_NameSort);
-
- define("MODULE_CONTENT", $AVE_Template->fetch($GLOBALS['mod']['tpl_dir'] . 'userlist.tpl'));
- define("MODULE_SITE", $GLOBALS['mod']['config_vars']['PageNameUserProfile']);
-
- ?>