private function templateSongs()
{
// $user = GWF_Session::getUser();
// $uid = $user->getID();
$table = GDO::table('Slay_Song');
$joins = NULL;
$headers = array();
$headers[] = array($this->module->lang('th_artist'), 'ss_artist');
$headers[] = array($this->module->lang('th_title'), 'ss_title');
$headers[] = array($this->module->lang('th_duration'), 'ss_duration');
$headers[] = array($this->module->lang('th_bpm'), 'ss_bpm');
$headers[] = array($this->module->lang('th_key'), 'ss_key');
$headers[] = array($this->module->lang('D'));
$headers[] = array($this->module->lang('L'));
$headers[] = array($this->module->lang('T'));
$headers[] = array($this->module->lang('th_tags'));
$where = "";
$nItems = $table->selectVar('COUNT(ss_id)', $where, '', $joins);
$nPages = GWF_PageMenu::getPagecount(self::IPP, $nItems);
$page = Common::clamp(Common::getGetInt('page'), 1, $nPages);
$by = Common::getGetString('by', self::BY);
$dir = Common::getGetString('dir', self::DIR);
$orderby = $table->getMultiOrderby($by, $dir, false);
$songs = $table->selectAll('*', $where, $orderby, $joins, self::IPP, GWF_PageMenu::getFrom($page, self::IPP), GDO::ARRAY_O);
$tVars = array('is_dj' => GWF_User::isInGroupS('dj'), 'sort_url' => GWF_WEB_ROOT . 'index.php?mo=Slaytags&me=Songs&by=%BY%&dir=%DIR%&page=1', 'pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . sprintf('index.php?mo=Slaytags&me=Songs&by=%s&dir=%s&page=%%PAGE%%', urlencode($by), urlencode($dir))), 'songs' => $songs, 'headers' => $headers);
return $this->module->template('songs.tpl', $tVars);
}
public function execute()
{
if (false === ($user = GWF_User::getByName(Common::getGetString('username')))) {
return GWF_HTML::err('ERR_UNKNOWN_USER');
}
if (false !== ($error = $this->module->isExcludedFromAPI($user, false))) {
return $error;
}
$this->module->includeClass('WC_RegAt');
$format = Common::getGetString('format', self::FORMAT);
$bg = Common::getGetString('bg', self::BGCOLOR);
$fg = Common::getGetString('fg', self::FGCOLOR);
$size = Common::clamp(Common::getGetInt('s', self::SIZE), 6, 30);
$spacingx = Common::clamp(Common::getGetInt('sx', 1), 0, 30);
$spacingy = Common::clamp(Common::getGetInt('sy', 1), 0, 30);
$marginx = Common::clamp(Common::getGetInt('mx', 1), 0, 30);
$marginy = Common::clamp(Common::getGetInt('my', 1), 0, 30);
$divider = Common::getGetString('div', ' ');
$font = Common::getGetString('font', self::FONT);
$_GET['font'] = $font;
if (!preg_match('/^[a-z_0-9]+$/iD', $font) || !Common::isFile(GWF_EXTRA_PATH . 'font/' . $font . '.ttf')) {
return "Font not found. Available fonts: " . $this->listFonts();
}
die($this->displayBanner($user, $format, $bg, $fg, $size, $spacingx, $spacingy, $marginx, $marginy, $divider));
}
public function execute()
{
GWF_Website::plaintext();
GWF3::setConfig('store_last_url', false);
$lat = $this->module->lat();
$lon = $this->module->lon();
$descr = trim(Common::getGetString('pp_descr'));
$descr = $descr === '' ? null : $descr;
$id = Common::getGetInt('pp_id', 0);
$user = GWF_User::getStaticOrGuest();
$uid = $user->getID();
if (!GWF_ProfilePOI::changeAllowed($id, $uid)) {
$this->module->ajaxError('Permission error!');
}
$count = $id === 0 ? GWF_ProfilePOI::getPOICount($uid) : 0;
$max_pois = $this->module->cfgAllowedPOIs();
if ($count >= $max_pois) {
$this->module->ajaxErr('err_poi_exceed');
}
$poi = new GWF_ProfilePOI(array('pp_id' => $id, 'pp_uid' => $uid, 'pp_lat' => $lat, 'pp_lon' => $lon, 'pp_descr' => $descr));
$poi->replace();
$data = $poi->getGDOData();
$data['user_name'] = $user->getVar('user_name');
die(json_encode($data));
}
public function execute()
{
if (false !== ($bid = Common::getGetInt('subscribe', false))) {
return $this->onSubscribe($bid);
} elseif (false !== ($bid = Common::getGetInt('unsubscribe', false))) {
return $this->onUnSubscribe($bid);
} else {
return GWF_HTML::err('ERR_GENERAL', array(__FILE__, __LINE__));
}
}
private function sanitize()
{
if (false === ($this->site = WC_Site::getByID(Common::getGetInt('siteid', 0)))) {
return array($this->module->lang('err_site'));
}
require_once GWF_CORE_PATH . 'module/WeChall/WC_SiteAdmin.php';
if (!WC_SiteAdmin::isSiteAdmin(GWF_Session::getUserID(), $this->site->getID()) && !GWF_User::isAdminS()) {
return array(GWF_HTML::lang('ERR_NO_PERMISSION'));
}
return false;
}
public function templateShow($href = NULL)
{
$nItems = $this->comments->getVar('cmts_count');
$nPages = GWF_PageMenu::getPagecount($this->module->cfgIPP(), $nItems);
$page = Common::clamp(Common::getGetInt('cpage', 1), 1, $nPages);
$cid = $this->comments->getID();
$visible = GWF_Comment::VISIBLE;
$comments = GDO::table('GWF_Comment')->selectObjects('*', "cmt_cid={$cid} AND cmt_options&{$visible}", 'cmt_date ASC');
$tVars = array('pagemenu' => GWF_PageMenu::display($page, $nPages, $href), 'comments' => $this->comments->displayComments($comments, $href));
return $this->module->template('show.tpl', $tVars);
}
public function execute()
{
if (false === ($id = Common::getGetInt('id', false))) {
return GWF_HTML::err('ERR_PARAMETER', array(__FILE__, __LINE__, 'id'));
}
if (false === ($log = GWF_AuditLog::getByID($id))) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
GWF_Website::plaintext();
die($log->getVar('al_data'));
}
public function execute()
{
GWF_Website::plaintext();
GWF3::setConfig('store_last_url', false);
$id = Common::getGetInt('pp_id');
if (!GWF_ProfilePOI::changeAllowed($id, GWF_Session::getUserID())) {
$this->module->ajaxError('Permission error!');
}
GDO::table('GWF_ProfilePOI')->deleteWhere("pp_id = {$id}");
die("{$id}");
}
private function onReply(Module_Comments $mod_c, GWF_News $news, GWF_Comments $comments)
{
$ipp = 10;
$nItems = $comments->getVar('cmts_count');
$nPages = GWF_PageMenu::getPagecount($ipp, $nItems);
$page = Common::clamp(Common::getGetInt('cpage'), 1, $nPages);
$href = GWF_WEB_ROOT . 'news-comments-' . $news->getID() . '-' . $news->displayTitle() . '-page-' . $page . '.html';
$me = $mod_c->getMethod('Reply');
$me instanceof Comments_Reply;
return $me->onReply($href);
}
private function onAddTag()
{
$form = $this->formAddTag();
if (false !== ($error = $form->validate($this->module))) {
return $error . $this->templateAddTag();
}
$user = GWF_Session::getUser();
$uid = $user->isStaff() ? '0' : $user->getID();
GDO::table('Slay_Tag')->insertAssoc(array('st_id' => 0, 'st_uid' => $uid, 'st_name' => $form->getVar('tag')), false);
$href = $this->module->getMethodURL('Tag', '&stid=' . Common::getGetInt('stid', '0'));
return $this->module->message('msg_tag_added', array($href));
}
private function templateHistory()
{
$table = GDO::table('Slay_PlayHistory');
$ipp = Slay_PlayHistory::IPP;
$where = '';
$nItems = $table->countRows($where);
$nPages = GWF_PageMenu::getPagecount($ipp, $nItems);
$page = Common::clamp(Common::getGetInt('page'), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, $ipp);
$tVars = array('is_admin' => GWF_User::isStaffS(), 'page' => $page, 'pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . 'index.php?mo=Slaytags&me=History&page=%PAGE%'), 'history' => $table->selectAll('*', $where, 'sph_date ASC', array('songs'), $ipp, $from, 'Slay_Song'));
return $this->module->template('history.tpl', $tVars);
}
public function execute()
{
$nid = Common::getGetInt('nid');
$id = Common::getGetInt('id');
$back = '';
if (isset($_POST['editnavi'])) {
$back = $this->onEdit($this->module, $nid, $id);
}
$this->navigation = GWF_Navigation::getNavigation($nid);
$this->navigations = GWF_Navigations::getByID($nid);
return $back . $this->templateEdit();
}
private function sanitize()
{
$this->user = GWF_Session::getUser();
$this->table = GDO::table('GWF_AccountAccess');
$where = "accacc_uid={$this->user->getID()}";
$this->nItems = $this->table->countRows($where);
$this->nPages = GWF_PageMenu::getPagecount($this->perpage, $this->nItems);
$this->page = Common::clamp(Common::getGetInt('page'), 1, $this->nPages);
$this->from = GWF_PageMenu::getFrom($this->page, $this->perpage);
$this->by = $this->table->getWhitelistedBy(Common::getGetString('by', self::DEFAULT_BY), self::DEFAULT_BY);
$this->dir = $this->table->getWhitelistedBy(Common::getGetString('dir', self::DEFAULT_DIR), self::DEFAULT_DIR);
$this->result = $this->table->select('*', $where, "{$this->by} {$this->dir}", null, $this->perpage, $this->from);
}
public function execute()
{
$_GET['ajax'] = 1;
header('Content-Type: text/plain');
if (false === ($date = Common::getGetString('datestamp', false))) {
return 'Missing parameter: datestamp.';
}
if (!GWF_Time::isValidDate($date, false, GWF_Date::LEN_SECOND)) {
return 'Error in parameter: datestamp.';
}
$amt = Common::clamp(Common::getGetInt('amt', 5), 1, self::MAX_OUT);
return $this->templateOutput($date, $amt);
}
private function templateTermine()
{
$termine = GDO::table('Konzert_Termin');
$where = '';
$by = Common::getGetString('by', self::DEFAULT_BY);
$dir = Common::getGetString('dir', self::DEFAULT_DIR);
$orderby = $termine->getMultiOrderby($by, $dir);
$nItems = $termine->countRows($where);
$nPages = GWF_PageMenu::getPagecount(self::IPP, $nItems);
$page = Common::clamp(Common::getGetInt('page'), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, self::IPP);
$tVars = array('add_button' => GWF_Button::add($this->module->lang('btn_add'), $this->module->getMethodURL('AddTermin')), 'termine' => $termine->selectObjects('*', $where, $orderby, self::IPP, $from), 'pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . 'index.php?mo=Konzert&me=AdminTermine&by=' . urlencode($by) . '&dir=' . urlencode($dir) . '&page=%PAGE%'), 'sort_url' => GWF_WEB_ROOT . 'index.php?mo=Konzert&me=AdminTermine&by=%BY%&dir=%DIR%&page=1');
return $this->module->template('a_termine.tpl', $tVars);
}
private function templateTickets()
{
$limit = 25;
$uid = GWF_Session::getUserID();
$tickets = GDO::table('GWF_HelpdeskTicket');
$where = "hdt_uid={$uid}";
$by = Common::getGetString('by', 'hdt_date');
$dir = Common::getGetString('dir', 'DESC');
$orderby = $tickets->getMultiOrderby($by, $dir);
$nItems = $tickets->countRows($where);
$nPages = GWF_PageMenu::getPagecount($limit, $nItems);
$page = Common::clamp(Common::getGetInt('page'), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, $limit);
$tVars = array('tickets' => $tickets->selectAll('*, worker.user_name worker_name', $where, $orderby, array('worker'), $limit, $from, GDO::ARRAY_O), 'pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . 'index.php?mo=Helpdesk&me=ShowTickets&by=' . urlencode($by) . '&dir=' . urlencode($dir) . '&page=%PAGE%'), 'sort_url' => GWF_WEB_ROOT . 'index.php?mo=Helpdesk&me=ShowTickets&by=%BY%&dir=%DIR%');
return $this->module->template('user.tpl', $tVars);
}
private function templateTermine()
{
$l = new GWF_LangTrans($this->module->getModuleFilePath('lang/termine'));
GWF_Website::setPageTitle($l->lang('page_title'));
$termine = GDO::table('Konzert_Termin');
$where = 'kt_options&1';
$by = Common::getGetString('by', self::DEFAULT_BY);
$dir = Common::getGetString('dir', self::DEFAULT_DIR);
$orderby = $termine->getMultiOrderby($by, $dir);
$nItems = $termine->countRows($where);
$nPages = GWF_PageMenu::getPagecount(self::IPP, $nItems);
$page = Common::clamp(Common::getGetInt('page'), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, self::IPP);
$tVars = array('l' => $l, 'href_admin' => $this->module->getMethodURL('AdminTermine'), 'user' => GWF_User::getStaticOrGuest(), 'termine' => $termine->selectObjects('*', $where, $orderby, self::IPP, $from), 'pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . 'index.php?mo=Konzert&me=Termine&by=' . urlencode($by) . '&dir=' . urlencode($dir) . '&page=%PAGE%'), 'sort_url' => GWF_WEB_ROOT . 'index.php?mo=Konzert&me=Termine&by=%BY%&dir=%DIR%&page=1');
return $this->module->template('termine.tpl', $tVars);
}
private function templateLogs()
{
$ipp = self::IPP;
$where = "al_type='script'";
$whitelist = array('size');
$table = GDO::table('GWF_AuditLog');
$nRows = $table->countRows($where);
$nPages = GWF_PageMenu::getPagecount($ipp, $nRows);
$page = Common::clamp(Common::getGetInt('page', 1), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, $ipp);
$by = Common::getGetString('by', self::DEFAULT_BY);
$dir = Common::getGetString('dir', self::DEFAULT_DIR);
$orderby = $table->getMultiOrderby($by, $dir, true, $whitelist);
$tVars = array('logs' => $table->selectAll('al_id,al_eusername,al_username,al_time_start,al_time_end,al_rand,LENGTH(al_data) size, al_id, al_id+1', $where, $orderby, NULL, $ipp, $from, GDO::ARRAY_N), 'pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . 'index.php?mo=Audit&me=Logs&by=' . urlencode($by) . '&dir=' . urlencode($dir) . '&page=%PAGE%'), 'sort_url' => GWF_WEB_ROOT . 'index.php?mo=Audit&me=Logs&by=%BY%&dir=%DIR%&page=1');
return $this->module->template('logs.tpl', $tVars);
}
private function templateStaff()
{
$tickets = GDO::table('GWF_HelpdeskTicket');
$limit = 25;
$by = Common::getGetString('by', 'hdt_priority');
$dir = Common::getGetString('dir', 'DESC');
$orderby = $tickets->getMultiOrderby($by, $dir);
$where = $this->getConditions();
$mode = $this->getMode();
$nItems = $tickets->countRows($where);
$nPages = GWF_PageMenu::getPagecount($limit, $nItems);
$page = Common::clamp(Common::getGetInt('page', 1), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, $limit);
$tVars = array('pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . 'index.php?mo=Heldpdesk&me=Staff&by=' . urlencode($by) . '&dir=' . urlencode($dir) . '&page=%PAGE%&mode=' . $mode), 'tickets' => $tickets->selectAll('t.*, creator.user_name creator_name, worker.user_name worker_name', $where, $orderby, array('worker', 'creator'), $limit, $from, GDO::ARRAY_O), 'sort_url' => GWF_WEB_ROOT . 'index.php?mo=Helpdesk&me=Staff&by=%BY%&dir=%DIR%&mode=' . $mode, 'href_all' => $this->getMethodHREF('&mode=all'), 'href_own' => $this->getMethodHREF('&mode=own'), 'href_open' => $this->getMethodHREF('&mode=open'), 'href_work' => $this->getMethodHREF('&mode=work'), 'href_closed' => $this->getMethodHREF('&mode=closed'), 'href_unsolved' => $this->getMethodHREF('&mode=unsolved'));
return $this->module->template('staff.tpl', $tVars);
}
private function templateStaff()
{
$table = GDO::table('GWF_Comments');
$where = $this->getWhere();
$ipp = 25;
$nItems = $table->countRows($where);
$nPages = GWF_PageMenu::getPagecount($ipp, $nItems);
$page = Common::clamp(Common::getGetInt('page'), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, $ipp);
$by = Common::getGetString('by', self::DEFAULT_BY);
$dir = Common::getGetString('dir', self::DEFAULT_DIR);
$orderby = $table->getMultiOrderby($by, $dir);
$hrefp = GWF_WEB_ROOT . sprintf('index.php?mo=Comments&me=Staff&by=%s&dir=%s&mode=%s&page=%%PAGE%%', urlencode($by), urlencode($dir), urlencode(Common::getGetString('mode')));
$tVars = array('pagemenu' => GWF_PageMenu::display($page, $nPages, $hrefp), 'comments' => $table->selectObjects('*', $where, $orderby, $ipp, $from));
return $this->module->template('staff.tpl', $tVars);
}
private function templateHistory(WC_Site $site)
{
require_once GWF_CORE_PATH . 'module/WeChall/WC_HistoryUser2.php';
$table = GDO::table('WC_HistoryUser2');
$orderby = 'userhist_date ASC';
$siteid = $site->getVar('site_id');
$conditions = "userhist_sid={$siteid}";
$ipp = 50;
$nItems = $table->countRows($conditions);
$nPages = GWF_PageMenu::getPagecount($ipp, $nItems);
$page = Common::clamp(Common::getGetInt('page', $nPages), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, $ipp);
$rows = $table->select('*', $conditions, $orderby, array('userhist_uid', 'userhist_sid'), 50, $from);
$href_pagemenu = GWF_WEB_ROOT . 'site/history/' . $site->urlencode2('site_name') . '/page/%PAGE%';
$tVars = array('pagemenu' => GWF_PageMenu::display($page, $nPages, $href_pagemenu), 'result' => $rows, 'site_quickjump' => $this->module->templateSiteQuickjumpHistory());
return $this->module->templatePHP('site_history.php', $tVars);
}
private function templateMyTags()
{
$user = GWF_Session::getUser();
$uid = $user->getID();
$table = GDO::table('Slay_Song');
$joins = array('tagvotes');
$where = "stv_uid={$uid}";
$nItems = $table->selectVar('COUNT(DISTINCT(ss_id))', $where, '', $joins);
$nPages = GWF_PageMenu::getPagecount(self::IPP, $nItems);
$page = Common::clamp(Common::getGetInt('page'), 1, $nPages);
$by = Common::getGetString('by', self::BY);
$dir = Common::getGetString('dir', self::DIR);
$orderby = $table->getMultiOrderby($by, $dir, false);
$songs = $table->selectAll('DISTINCT(ss_id), t.*', $where, $orderby, $joins, self::IPP, GWF_PageMenu::getFrom($page, self::IPP), GDO::ARRAY_O);
$tVars = array('sort_url' => GWF_WEB_ROOT . 'index.php?mo=Slaytags&me=MyTags&by=%BY%&dir=%DIR%&page=1', 'pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . sprintf('index.php?mo=Slaytags&me=MyTags&by=%s&dir=%s&page=%%PAGE%%', urlencode($by), urlencode($dir))), 'songs' => $songs);
return $this->module->template('mytags.tpl', $tVars);
}
private function templatePlayers()
{
$bid = $this->box->getID();
$_GET['sid'] = $this->box->getSiteID();
$_GET['bid'] = $bid;
$table = GDO::table('WC_Warflags');
$where = "wf_wbid={$bid} AND wf_solved_at IS NOT NULL";
$orderby = 'score DESC, solvedate ASC';
$joins = array('flag', 'flagbox', 'solvers');
$ipp = 50;
$nItems = $table->countRows($where, $joins, 'user_name');
$nPages = GWF_PageMenu::getPagecount($ipp, $nItems);
$page = Common::clamp(Common::getGetInt('page', 1), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, $ipp);
$tVars = array('site_quickjump' => $this->module->templateSiteQuickjump('boxranking'), 'data' => $table->selectAll("user_name, user_countryid country, COUNT(*) solved, SUM(wf_score) score, SUM(wf_score)/{$this->box->getVar('wb_totalscore')}*100 percent, MAX(wf_solved_at) solvedate", $where, $orderby, $joins, $ipp, $from, GDO::ARRAY_A, 'user_name'), 'box' => $this->box, 'playercount' => $nItems, 'rank' => $from + 1, 'pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . 'index.php?mo=WeChall&me=WarboxPlayers&boxid=' . $bid . '&page=%PAGE%'));
return $this->module->templatePHP('warbox_players.php', $tVars);
}
private function templateSolvers()
{
$box = $this->flag->getWarbox();
$_GET['sid'] = $box->getSiteID();
$_GET['bid'] = $box->getID();
$fid = $this->flag->getID();
$table = GDO::table('WC_Warflags');
$where = "wf_id={$fid} AND wf_solved_at IS NOT NULL";
$orderby = 'wf_solved_at ASC';
$joins = array('flag', 'solvers', 'flagbox', 'flagsite');
$ipp = 50;
$nItems = $table->countRows($where, $joins);
$nPages = GWF_PageMenu::getPagecount($ipp, $nItems);
$page = Common::clamp(Common::getGetInt('page'), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, $ipp);
$tVars = array('site_quickjump' => $this->module->templateSiteQuickjump('boxdetail'), 'solvers' => $table->selectAll('*', $where, $orderby, $joins, $ipp, $from, GDO::ARRAY_A), 'flag' => $this->flag, 'rank' => $from + 1, 'sort_url' => NULL, 'solvercount' => $nItems, 'pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . "index.php?mo=WeChall&me=WarflagSolvers&flag={$fid}&page=%PAGE%"));
return $this->module->templatePHP('warflag_solvers.php', $tVars);
}
public function execute()
{
require_once GWF_CORE_PATH . 'module/Slaytags/slay_secrets.php';
if (0 === ($site = Common::getGetInt('site'))) {
return GWF_HTML::err('ERR_PARAMETER', array(__FILE__, __LINE__, 'site'));
}
if (0 >= ($userid = Common::getGetInt('uid'))) {
return GWF_HTML::err('ERR_PARAMETER', array(__FILE__, __LINE__, 'uid'));
}
if ('' === ($token = Common::getGetString('token'))) {
return GWF_HTML::err('ERR_PARAMETER', array(__FILE__, __LINE__, 'uid'));
}
if ($site === 1) {
return $this->onCrossLoginSlayradio($userid, $token);
} else {
return GWF_HTML::err('ERR_PARAMETER', array(__FILE__, __LINE__, 'site'));
}
}
private function templateUsers(GWF_Group $group)
{
$users = GDO::table('GWF_User');
$gid = $group->getVar('group_id');
$gn = $group->urlencode('group_name');
$by = Common::getGet('by', '');
$dir = Common::getGet('dir', '');
$orderby = $users->getMultiOrderby($by, $dir);
$ipp = 50;
$nItems = $group->getVar('group_memberc');
$nPages = GWF_PageMenu::getPagecount($ipp, $nItems);
$page = Common::clamp(Common::getGetInt('page', 1), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, $ipp);
$ug = GWF_TABLE_PREFIX . 'usergroup';
$hidden = GWF_UserGroup::HIDDEN;
$conditions = "(SELECT 1 FROM {$ug} WHERE ug_userid=user_id AND ug_groupid={$gid} AND ug_options&{$hidden}=0)";
$tVars = array('sort_url' => GWF_WEB_ROOT . 'users_in_group/' . $gid . '/' . $gn . '/by/%BY%/%DIR%/page-1', 'pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . sprintf('users_in_group/%s/%s/by/%s/%s/page-%%PAGE%%', $gid, $gn, urlencode($by), urlencode($dir))), 'users' => $users->selectObjects('*', $conditions, $orderby, $ipp, $from));
return $this->module->templatePHP('users.php', $tVars);
}
/**
* @todo try to get Navi-Name
* @todo rethink
*/
public function execute()
{
$nid = Common::getGetInt('nid');
$name = Common::getGetString('nname', 'unknown');
$back = '';
# Delete a Navigation?
if ('delete' === ($action = Common::getGet('action'))) {
if ($nid <= 0 || false === $this->onDelete($nid)) {
# couldnt delete the navi! does it exists?
$back = $this->module->error('err_delete', $name);
} else {
$back = $this->module->message('succ_delete', $name);
}
} elseif ('copy' === $action) {
$back = $this->onCopy();
} elseif (false !== ($delete = Common::getPostArray('delete'))) {
$back .= $this->onEdit($delete);
}
return $back . $this->templateAdmin();
}
private function templateWhitelist()
{
$ipp = 20;
$page = Common::getGetInt('page', 1);
$userid = GWF_Session::getUserID();
$where = "pw_uida={$userid}";
$table = GDO::table('GWF_ProfilePOIWhitelist');
$numItems = $table->countRows($where);
$nPages = GWF_PageMenu::getPagecount($ipp, $numItems);
$page = Common::clamp($page, 1, $nPages);
$from = GWF_PageMenu::getFrom($page, $ipp);
$by = Common::getGetString('by', 'pw_date');
$dir = Common::getGetString('dir', 'ASC');
$by = $table->getWhitelistedBy($by);
$dir = $table->getWhitelistedDirS($dir);
$pagehref = GWF_WEB_ROOT . "index.php?mo=Profile&me=POISWhitelist&by={$by}&dir={$dir}&page=%PAGE%";
$tVars = array('form_add' => $this->formAdd(), 'form_clear' => $this->formClear(), 'form_settings' => $this->formSettings(), 'table' => $table, 'where' => $where, 'by' => $by, 'dir' => $dir, 'ipp' => $ipp, 'from' => $from, 'form_action' => GWF_WEB_ROOT . 'index.php?mo=Profile&me=POISWhitelist', 'sort_url' => GWF_WEB_ROOT . "index.php?mo=Profile&me=POISWhitelist&by=%BY%&dir=%DIR%&page=1", 'page_menu' => GWF_PageMenu::display($page, $nPages, $pagehref));
$back = $this->module->templatePHP('whitelist.php', $tVars);
return $back;
}
private function sanitize()
{
if (false === ($this->thread = GWF_ForumThread::getByID(Common::getGetString('tid')))) {
return $this->module->error('err_thread');
}
$this->ppt = $this->module->getPostsPerThread();
$this->nPosts = $this->thread->getPostCount();
$this->nPages = GWF_PageMenu::getPagecount($this->ppt, $this->nPosts);
$default_page = isset($_GET['last_page']) ? $this->nPages : 1;
$this->page = Common::clamp(Common::getGetInt('page'), $default_page, $this->nPages);
if (!$this->thread->getBoard()) {
return $this->module->error('err_thread_perm');
}
if (!$this->thread->hasPermission(GWF_Session::getUser())) {
return $this->module->error('err_thread_perm');
}
if ($this->thread->isInModeration()) {
return $this->module->error('err_in_mod');
}
return false;
}
private function onSearch()
{
$form = $this->formSearch();
if (false !== ($error = $form->validate($this->module))) {
return $error . $this->templateSearch();
}
$ipp = self::IPP;
$term = $form->getVar('searchterm');
$tagname = NULL;
$table = GDO::table('Slay_Song');
$whitelist = array('(ss_lyrics>0)', '(ss_options&1)', '(ss_sid_path!=NULL)');
$joins = array('lyrics');
if (false === ($where = GWF_QuickSearch::getQuickSearchConditions($table, array('ss_artist', 'ss_title', 'ss_composer'), $term))) {
return GWF_HTML::err('ERR_SEARCH_TERM') . $this->templateSearch();
}
$term2 = GDO::escape($term);
// $term2 = str_replace(array('%', '_'), array('\\%', '\\_'), $term);
$term3 = '1';
if ('0' !== ($tag = $form->getVar('searchtag'))) {
$tagname = Slay_Tag::getNameByID($tag);
$term3 = 'sst_count>0';
$joins[] = 'searchtag';
}
$where = "(({$where}) OR (ssl_lyrics LIKE '%{$term2}%')) AND ({$term3})";
$nItems = $table->countRows($where, $joins);
$nPages = GWF_PageMenu::getPagecount($ipp, $nItems);
$page = Common::clamp(Common::getGetInt('page'), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, $ipp);
$by = Common::getGetString('by', self::BY);
$dir = Common::getGetString('dir', self::DIR);
$orderby = $table->getMultiOrderby($by, $dir, false, $whitelist);
$matches = $table->selectAll('*', $where, $orderby, $joins, $ipp, $from, GDO::ARRAY_O);
$headers = array(array(), array($this->module->lang('L'), '(ss_lyrics>0)'), array($this->module->lang('T'), 'ss_taggers'), array($this->module->lang('D'), '(ss_options&1)'), array($this->module->lang('th_artist'), 'ss_artist'), array($this->module->lang('th_title'), 'ss_title'), array($this->module->lang('th_duration'), 'ss_duration'), array($this->l('th_bpm'), 'ss_bpm'), array($this->l('th_key'), 'ss_key'));
if ($tag > 0) {
$headers[] = array($this->module->lang(Slay_Tag::getNameByID($tag)), 'sst_count');
}
$headers[] = array($this->module->lang('th_tags'));
$tVars = array('form' => $form->templateX($this->module->lang('ft_search'), GWF_WEB_ROOT . 'index.php'), 'pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . sprintf('index.php?mo=Slaytags&me=Search&searchterm=%s&searchtag=%s&by=%s&dir=%s&page=%%PAGE%%', urlencode($term), $tag, urlencode($by), urlencode($dir))), 'matches' => $matches, 'sort_url' => GWF_WEB_ROOT . sprintf('index.php?mo=Slaytags&me=Search&searchterm=%s&searchtag=%s&by=%%BY%%&dir=%%DIR%%&page=1', urlencode($term), $tag), 'is_admin' => GWF_User::isStaffS(), 'headers' => $headers, 'singletag' => $tagname, 'no_match' => count($matches) === 0);
return $this->module->template('search.tpl', $tVars);
}
