function execute(&$request) { if ($request['user']->isMember() && $request['user']->get('perms') >= SUPERADMIN) { global $_DATASTORE; k4_bread_crumbs($request['template'], $request['dba'], 'L_EMAILUSERS'); $request['template']->setVar('misc_on', '_on'); $request['template']->setFile('sidebar_menu', 'menus/misc.html'); if (isset($_DATASTORE['massmail'])) { $action = new K4InformationAction(new K4LanguageElement('L_EMAILINPROGRESS'), 'content', FALSE); return $action->execute($request); } global $_URL; $verify_url = new FAUrl($_URL->__toString()); $verify_url->args = array(); $verify_url->file = FALSE; $verify_url->anchor = FALSE; $verify_url->scheme = FALSE; $verify_url->path = FALSE; $verify_url->host = preg_replace('~www\\.~i', '', $verify_url->host); $request['template']->setFile('content', 'email_users.html'); $request['template']->setVar('email_from', substr($verify_url->__toString(), 0, -1)); } else { no_perms_error($request); } return TRUE; }
function execute(&$request) { /* Create the ancestors bar */ k4_bread_crumbs($request['template'], $request['dba'], 'L_RESENDVALIDATIONEMAIL'); /* Check if the user is logged in or not */ if ($request['user']->isMember()) { no_perms_error($request); return TRUE; } if (!$this->runPostFilter('email', new FARequiredFilter())) { $action = new K4InformationAction(new K4LanguageElement('L_SUPPLYEMAIL'), 'content', TRUE); return $action->execute($request); } if (!$this->runPostFilter('email', new FARegexFilter('~^([0-9a-zA-Z]+[-._+&])*[0-9a-zA-Z]+@([-0-9a-zA-Z]+[.])+[a-zA-Z]{2,6}$~'))) { $action = new K4InformationAction(new K4LanguageElement('L_NEEDVALIDEMAIL'), 'content', TRUE); return $action->execute($request); } $user = $request['dba']->getRow("SELECT * FROM " . K4USERS . " WHERE email = '" . $request['dba']->quote($_REQUEST['email']) . "'"); if (!is_array($user) || empty($user)) { $action = new K4InformationAction(new K4LanguageElement('L_INVALIDEMAILRVE', $_REQUEST['email']), 'content', TRUE); return $action->execute($request); } if ($user['reg_key'] == '') { $action = new K4InformationAction(new K4LanguageElement('L_USERREGGEDRVE'), 'content', TRUE); return $action->execute($request); } // .'/member.php?act=activate_accnt&key='. $user['reg_key'] $url = new FAUrl(K4_URL); $url->file = 'member.php'; $url->args = array('act' => 'activate_accnt', 'key' => $user['reg_key']); $email = sprintf($request['template']->getVar('L_REGISTEREMAILRMSG'), $user['name'], $request['template']->getVar('bbtitle'), str_replace('&', '&', $url->__toString()), $request['template']->getVar('bbtitle')); email_user($user['email'], $request['template']->getVar('bbtitle') . ' - ' . $request['template']->getVar('L_RESENDVALIDATIONEMAIL'), $email); $action = new K4InformationAction(new K4LanguageElement('L_RESENTREGEMAIL', $_REQUEST['email']), 'content', TRUE); return $action->execute($request); }
function execute(&$request) { global $_QUERYPARAMS, $_USERGROUPS, $_URL; /* set the breadcrumbs bit */ k4_bread_crumbs($request['template'], $request['dba'], 'L_INFORMATION'); if (isset($_REQUEST['f']) && intval($_REQUEST['f']) != 0 || isset($_REQUEST['c']) && intval($_REQUEST['c']) != 0) { $thing = isset($_REQUEST['f']) ? 'f' : 'c'; $forum = $request['dba']->getRow("SELECT * FROM " . K4FORUMS . " WHERE forum_id = " . intval($_REQUEST[$thing])); } else { $action = new K4InformationAction(new K4LanguageElement('L_FORUMDOESNTEXIST'), 'content', TRUE); return $action->execute($request); } if (!$forum || !is_array($forum) || empty($forum)) { $action = new K4InformationAction(new K4LanguageElement('L_FORUMDOESNTEXIST'), 'content', FALSE); return $action->execute($request); } if ($forum['row_type'] & FORUM && $forum['is_link'] == 1) { if ($forum['link_show_redirects'] == 1) { $action = new K4InformationAction(new K4LanguageElement('L_REDIRECTING'), 'content', FALSE, 'redirect.php?id=' . $forum['forum_id'], 3); } else { $action = new K4InformationAction(new K4LanguageElement('L_REDIRECTING'), 'content', FALSE, $forum['link_href'], 3); } return $action->execute($request); } /* Set the extra SQL query fields to check */ $extra = " AND location_file = '" . $request['dba']->Quote($_URL->file) . "' AND location_id = " . ($forum['row_type'] & CATEGORY ? intval($forum['category_id']) : intval($forum['forum_id'])); $user_extra = $request['user']->isMember() ? ' OR (seen > 0 AND user_id = ' . intval($request['user']->get('id')) . ')' : ''; $forum_can_view = $forum['row_type'] & CATEGORY ? get_map('', 'can_view', array('category_id' => $forum['category_id'])) : get_map('', 'can_view', array('forum_id' => $forum['forum_id'])); $expired = time() - ini_get('session.gc_maxlifetime'); $num_online_total = $request['dba']->getValue("SELECT COUNT(id) FROM " . K4SESSIONS . " WHERE ((seen >= {$expired} {$extra}) {$user_extra})"); $num_online_total = !$request['user']->isMember() ? $num_online_total + 1 : $num_online_total; /* If there are more than 0 people browsing the forum, display the stats */ if ($num_online_total > 0 && $forum_can_view <= $request['user']->get('perms')) { $query = "SELECT * FROM " . K4SESSIONS . " WHERE ((seen >= {$expired} {$extra}) {$user_extra}) AND ((user_id > 0) OR (user_id = 0 AND name <> '')) GROUP BY name ORDER BY seen DESC"; $users_browsing =& new K4OnlineUsersIterator($request['dba'], '', $request['dba']->executeQuery($query)); /* Set the users browsing list */ $request['template']->setList('users_browsing', $users_browsing); $stats = array('num_online_members' => Globals::getGlobal('num_online_members'), 'num_invisible' => Globals::getGlobal('num_online_invisible'), 'num_online_total' => $num_online_total); $stats['num_guests'] = $stats['num_online_total'] - $stats['num_online_members'] - $stats['num_invisible']; $element = $forum['row_type'] & CATEGORY ? 'L_USERSBROWSINGCAT' : 'L_USERSBROWSINGFORUM'; $request['template']->setVar('num_online_members', $stats['num_online_members']); $request['template']->setVar('users_browsing', $request['template']->getVar($element)); $request['template']->setVar('online_stats', sprintf($request['template']->getVar('L_USERSBROWSINGSTATS'), $stats['num_online_total'], $stats['num_online_members'], $stats['num_guests'], $stats['num_invisible'])); /* Set the User's Browsing file */ $request['template']->setFile('users_browsing', 'users_browsing.html'); $groups = array(); /* Set the usergroups legend list */ foreach ($_USERGROUPS as $group) { if ($group['display_legend'] == 1) { $groups[] = $group; } } $groups =& new FAArrayIterator($groups); $request['template']->setList('usergroups_legend', $groups); } if ($forum_can_view > $request['user']->get('perms')) { $action = new K4InformationAction(new K4LanguageElement('L_PERMCANTVIEW'), 'content', FALSE); return $action->execute($request); } /** * Breadcrumbs */ /* Set the breadcrumbs bit */ k4_bread_crumbs($request['template'], $request['dba'], NULL, $forum); /* Set if this breadcrumb should be 'new' or not */ $icon = NULL; $new = $forum['row_type'] & FORUM ? forum_icon($forum, $icon) : FALSE; $request['template']->setVar('breadcrumb_new', $new == TRUE ? 'new' : ''); /** * Forum/cateogry checking */ /* Set all of the category/forum info to the template */ $request['template']->setVarArray($forum); /** * * CATEGORY * */ if ($forum['row_type'] & CATEGORY) { if (get_map('categories', 'can_view', array()) > $request['user']->get('perms')) { $action = new K4InformationAction(new K4LanguageElement('L_PERMCANTVIEW'), 'content', FALSE); return $action->execute($request); } /* Set the Categories list */ $categories =& new K4ForumsIterator($request['dba'], "SELECT * FROM " . K4FORUMS . " WHERE forum_id = " . $forum['forum_id'] . " ORDER BY row_order ASC"); $request['template']->setList('tlforums', $categories); /* Hide the welcome message at the top of the forums.html template */ $request['template']->setVisibility('welcome_msg', FALSE); /* Show the forum status icons */ $request['template']->setVisibility('forum_status_icons', TRUE); /* Show the 'Mark these forums Read' link */ $request['template']->setVisibility('mark_these_forums', TRUE); /* Set the forums template to content variable */ $request['template']->setFile('content', 'forums.html'); /** * * FORUM / META FORUM * */ } else { if ($forum['row_type'] & FORUM || $forum['row_type'] & METAFORUM || $forum['row_type'] & ARCHIVEFORUM) { /* Add the forum info to the template */ foreach ($forum as $key => $val) { $request['template']->setVar('forum_' . $key, $val); } /* If this forum has sub-forums */ if (isset_forum_cache_item('subforums', $forum['forum_id']) && $forum['subforums'] >= 1) { /* Cache this forum as having subforums */ set_forum_cache_item('subforums', 1, $forum['forum_id']); /* Show the table that holds the subforums */ $request['template']->setVisibility('subforums', TRUE); /* Set the sub-forums list */ $it =& new K4ForumsIterator($request['dba'], "SELECT * FROM " . K4FORUMS . " WHERE parent_id = " . $forum['forum_id'] . " ORDER BY row_order ASC"); $request['template']->setList('forums', $it); } if (get_map('topics', 'can_view', array('forum_id' => $forum['forum_id'])) > $request['user']->get('perms')) { $action = new K4InformationAction(new K4LanguageElement('L_CANTVIEWFORUMTOPICS'), 'content_extra', FALSE); return $action->execute($request); } /** * Forum settings */ /* Set the topics template to the content variable */ $request['template']->setFile('content', 'viewforum.html'); /* Set what this user can/cannot do in this forum */ $request['template']->setVar('forum_user_topic_options', sprintf($request['template']->getVar('L_FORUMUSERTOPICPERMS'), get_map('topics', 'can_add', array('forum_id' => $forum['forum_id'])) > $request['user']->get('perms') ? $request['template']->getVar('L_CANNOT') : $request['template']->getVar('L_CAN'), get_map('topics', 'can_edit', array('forum_id' => $forum['forum_id'])) > $request['user']->get('perms') ? $request['template']->getVar('L_CANNOT') : $request['template']->getVar('L_CAN'), get_map('topics', 'can_del', array('forum_id' => $forum['forum_id'])) > $request['user']->get('perms') ? $request['template']->getVar('L_CANNOT') : $request['template']->getVar('L_CAN'), get_map('attachments', 'can_add', array('forum_id' => $forum['forum_id'])) > $request['user']->get('perms') ? $request['template']->getVar('L_CANNOT') : $request['template']->getVar('L_CAN'))); $request['template']->setVar('forum_user_reply_options', sprintf($request['template']->getVar('L_FORUMUSERREPLYPERMS'), get_map('replies', 'can_add', array('forum_id' => $forum['forum_id'])) > $request['user']->get('perms') ? $request['template']->getVar('L_CANNOT') : $request['template']->getVar('L_CAN'), get_map('replies', 'can_edit', array('forum_id' => $forum['forum_id'])) > $request['user']->get('perms') ? $request['template']->getVar('L_CANNOT') : $request['template']->getVar('L_CAN'), get_map('replies', 'can_del', array('forum_id' => $forum['forum_id'])) > $request['user']->get('perms') ? $request['template']->getVar('L_CANNOT') : $request['template']->getVar('L_CAN'))); /* Create an array with all of the possible sort orders we can have */ $sort_orders = array('name', 'lastpost_created', 'num_replies', 'views', 'lastpost_uname', 'rating', 'poster_name'); //$extra_topics = intval(@$_ALLFORUMS[GLBL_ANNOUNCEMENTS]['topics']); $extra_topics = 0; // TODO: need only Announcements from global announcements /** * Pagination */ /* Create the Pagination */ $resultsperpage = $request['user']->get('topicsperpage') <= 0 ? $forum['topicsperpage'] : $request['user']->get('topicsperpage'); $num_results = $forum['topics'] + $extra_topics; $perpage = isset($_REQUEST['limit']) && ctype_digit($_REQUEST['limit']) && intval($_REQUEST['limit']) > 0 ? intval($_REQUEST['limit']) : $resultsperpage; $perpage = $perpage > 100 ? 100 : $perpage; $num_pages = intval(@ceil($num_results / $perpage)); $page = isset($_REQUEST['page']) && ctype_digit($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1; $pager =& new FAPaginator($_URL, $num_results, $page, $perpage); if ($num_results > $perpage) { $request['template']->setPager('topics_pager', $pager); /* Create a friendly url for our pager jump */ $page_jumper = new FAUrl($_URL->__toString()); $page_jumper->args['limit'] = $perpage; $page_jumper->args['page'] = FALSE; $page_jumper->anchor = FALSE; $request['template']->setVar('pagejumper_url', preg_replace('~&~i', '&', $page_jumper->__toString())); } /* Get the topics for this forum */ $daysprune = $_daysprune = isset($_REQUEST['daysprune']) && ctype_digit($_REQUEST['daysprune']) ? $_REQUEST['daysprune'] == 0 ? 0 : intval($_REQUEST['daysprune']) : 365; $daysprune = $daysprune > 0 ? time() - @($daysprune * 86400) : 0; $sortorder = isset($_REQUEST['order']) && ($_REQUEST['order'] == 'ASC' || $_REQUEST['order'] == 'DESC') ? $_REQUEST['order'] : 'DESC'; $sortedby = isset($_REQUEST['sort']) && in_array($_REQUEST['sort'], $sort_orders) ? $_REQUEST['sort'] : 'lastpost_created'; $start = ($page - 1) * $perpage; /* Apply the directional arrow to the sorting of topics */ $request['template']->setVar('order', $sortorder == 'DESC' ? 'ASC' : 'DESC'); $image = '<img src="Images/' . $request['template']->getVar('IMG_DIR') . '/Icons/arrow_' . ($sortorder == 'DESC' ? 'down' : 'up') . '.gif" alt="" border="0" />'; $request['template']->setVar($sortedby . '_sort', $image); /* If there are no topics, set the right message to display */ if ($forum['topics'] <= 0) { $request['template']->setVisibility('no_topics', TRUE); $request['template']->setVar('topics_message', $daysprune == 0 ? $request['template']->getVar('L_NOPOSTSINFORUM') : sprintf($request['template']->getVar('L_FORUMNOPOSTSSINCE'), $_daysprune)); } if ($forum['topics'] + $extra_topics > 0 || $forum['row_type'] > GALLERY) { /** * Moderator Functions */ $extra = 'AND queue = 0'; $request['template']->setVar('modpanel', 0); /* is this user a moderator */ if (is_moderator($request['user']->getInfoArray(), $forum) && $forum['row_type'] <= GALLERY) { $request['template']->setVar('modpanel', 1); if (isset($_REQUEST['queued']) || isset($_REQUEST['locked'])) { if (isset($_REQUEST['queued'])) { $extra = 'AND queue = 1'; } elseif (isset($_REQUEST['locked'])) { $extra = ' AND queue = 0 AND post_locked = 1'; } } } /** * Topic Setting */ /* Make our query */ $query = "SELECT * FROM " . K4POSTS . " WHERE created>={$daysprune} AND is_draft=0 AND display=1 AND row_type=" . TOPIC . " AND forum_id=" . intval($forum['forum_id']) . " AND (post_type <> " . TOPIC_ANNOUNCE . " AND post_type <> " . TOPIC_STICKY . " AND is_feature = 0) {$extra} ORDER BY {$sortedby} {$sortorder} LIMIT {$start},{$perpage}"; if ($forum['row_type'] & METAFORUM) { global $_FILTERS, $_FORUMFILTERS; $query = "SELECT * FROM " . K4POSTS . " WHERE row_type=" . TOPIC . " AND forum_id<>" . GARBAGE_BIN . " "; // loop through the filters being applied to this forum $forum_filters = array(); if (isset($_FORUMFILTERS[$forum['forum_id']])) { foreach ($_FORUMFILTERS[$forum['forum_id']] as $forum_filter) { if (isset($_FILTERS[$forum_filter['filter_id']])) { $forum_filters[] = array('name' => $_FILTERS[$forum_filter['filter_id']]['filter_name']); $query .= " AND " . sprintf($_FILTERS[$forum_filter['filter_id']]['filter_query'], $request['dba']->quote($forum_filter['insert1']), $request['dba']->quote($forum_filter['insert2']), $request['dba']->quote($forum_filter['insert3'])) . " "; } } } $request['template']->setList('forum_filters', new FAArrayIterator($forum_filters)); $query .= " {$extra} ORDER BY {$sortedby} {$sortorder} LIMIT {$start},{$perpage}"; $query = str_replace('**', '%', $query); } /* get the topics */ $result = $request['dba']->executeQuery($query); /* Apply the topics iterator */ $it =& new TopicsIterator($request['dba'], $request['user'], $result, $request['template']->getVar('IMG_DIR'), $forum); $request['template']->setList('topics', $it); // let's just make sure.. if ($result->hasNext()) { $request['template']->setVisibility('no_topics', FALSE); } if ($forum['row_type'] <= GALLERY) { /** * Get announcement/global topics */ if ($page == 1) { $announcements = $request['dba']->executeQuery("SELECT * FROM " . K4POSTS . " WHERE (is_draft=0 AND display=1) AND row_type=" . TOPIC . " AND post_type = " . TOPIC_ANNOUNCE . " AND (forum_id = " . intval($forum['forum_id']) . " OR forum_id = " . GLBL_ANNOUNCEMENTS . ") {$extra} ORDER BY lastpost_created DESC"); if ($announcements->hasNext()) { $a_it =& new TopicsIterator($request['dba'], $request['user'], $announcements, $request['template']->getVar('IMG_DIR'), $forum); $request['template']->setList('announcements', $a_it); } } /** * Get sticky/feature topics */ $importants = $request['dba']->executeQuery("SELECT * FROM " . K4POSTS . " WHERE is_draft=0 AND row_type=" . TOPIC . " AND display = 1 AND forum_id = " . intval($forum['forum_id']) . " AND (post_type <> " . TOPIC_ANNOUNCE . ") AND (post_type = " . TOPIC_STICKY . " OR is_feature = 1) {$extra} ORDER BY lastpost_created DESC"); if ($importants->hasNext()) { $i_it =& new TopicsIterator($request['dba'], $request['user'], $importants, $request['template']->getVar('IMG_DIR'), $forum); $request['template']->setList('importants', $i_it); } } /* Outside valid page range, redirect */ if (!$pager->hasPage($page) && $num_pages > 0) { $action = new K4InformationAction(new K4LanguageElement('L_PASTPAGELIMIT'), 'content', FALSE, 'viewforum.php?f=' . $forum['forum_id'] . '&limit=' . $perpage . '&page=' . $num_pages, 3); return $action->execute($request); } } /** * Forum Subscriptions */ if ($request['user']->isMember() && $forum['topics'] > 0) { $subscribed = $request['dba']->executeQuery("SELECT * FROM " . K4SUBSCRIPTIONS . " WHERE forum_id = " . intval($forum['forum_id']) . " AND post_id = 0 AND user_id = " . $request['user']->get('id')); $request['template']->setVar('is_subscribed', $subscribed->numRows() > 0 ? 1 : 0); } /** * * GALLERY * */ } else { if ($forum['row_type'] & GALLERY) { $request['template']->setFile('content', 'viewgallery.html'); /** * * ERROR * */ } else { $action = new K4InformationAction(new K4LanguageElement('L_FORUMDOESNTEXIST'), 'content', FALSE); return $action->execute($request); } } } /** * Can we post in here? */ $can_post_in_forum = 1; if ($forum['forum_id'] == GARBAGE_BIN || $forum['row_type'] > GALLERY) { $can_post_in_forum = 0; } $request['template']->setVar('can_post_in_forum', $can_post_in_forum); // urls $request['template']->setVar('U_FORUMRSSURL', K4Url::getGenUrl('rss', 'f=' . $forum['forum_id'])); /* Add the cookies for this forum's topics */ bb_execute_topiccache(); // show the midsection of the forum $request['template']->setVisibility('forum_midsection', TRUE); return TRUE; }
function execute(&$request) { global $_QUERYPARAMS, $_ALLFORUMS, $_URL; k4_bread_crumbs($request['template'], $request['dba'], 'L_SEARCHRESULTS'); if (get_map('advsearch', 'can_add', array()) > $request['user']->get('perms')) { // something here? } /* Do we force it to rewrite the session? */ if (isset($_REQUEST['rewrite_session']) && intval($_REQUEST['rewrite_session']) == 1 && isset($_SESSION['search']['search_queries'])) { unset($_SESSION['search']['search_queries']); } /** * Sort out author information */ $user_ids = ''; if (isset($_REQUEST['author']) && $_REQUEST['author'] != '') { $author = k4_htmlentities(trim($_REQUEST['author']), ENT_QUOTES); if (!isset($_REQUEST['exact']) || !$_REQUEST['exact']) { $author = str_replace('%', '*', $author); $author = intval($request['template']->getVar('allowwildcards')) == 1 ? str_replace('*', '%', $author) : str_replace('*', ' ', $author); // wildcard/partial match $user_search = "LOWER(name) LIKE LOWER('%" . $request['dba']->quote($author) . "%')"; } else { // exact match $user_search = "name = '" . $request['dba']->quote($author) . "'"; } if (strlen($author) < $request['template']->getVar('minsearchlength') || strlen($author) > $request['template']->getVar('maxsearchlength')) { $action = new K4InformationAction(new K4LanguageElement('L_INVALIDSEARCHKEYWORDS', $request['template']->getVar('minsearchlength'), $request['template']->getVar('maxsearchlength')), 'content', TRUE, 'search.php', 5); return !USE_XMLHTTP ? $action->execute($request) : xmlhttp_message(sprintf($request['template']->getVar('L_INVALIDSEARCHKEYWORDS'), $request['template']->getVar('minsearchlength'), $request['template']->getVar('maxsearchlength'))); } $users = $request['dba']->executeQuery("SELECT * FROM " . K4USERS . " WHERE {$user_search}"); if ($users->numrows() > 0) { $user_ids = ' AND ('; while ($users->next()) { $user = $users->current(); $user_ids .= $users->key() == 0 ? ' poster_id = ' . intval($user['id']) : ' OR poster_id = ' . intval($user['id']); } $user_ids .= ') '; } else { $action = new K4InformationAction(new K4LanguageElement('L_NOAUTHORSBYNAME'), 'content', FALSE, 'search.php', 5); return !USE_XMLHTTP ? $action->execute($request) : xmlhttp_message('L_NOAUTHORSBYNAME'); } } /** * Sort out forum information */ $forum_ids = ''; $category_ids = ''; $searchable_forums = ''; /* This will handle different types of forum data */ if (isset($_REQUEST['forums']) && is_array($_REQUEST['forums']) && !empty($_REQUEST['forums'])) { $forums = $_REQUEST['forums']; } elseif (isset($_REQUEST['forums']) && count(explode("|", $_REQUEST['forums'])) > 0) { $forums = explode("|", $_REQUEST['forums']); } else { $forums = array(); } /* Now start looking thouroughly at the data */ if (is_array($forums) && !empty($forums)) { $subforums = isset($_REQUEST['searchsubforums']) && intval($_REQUEST['searchsubforums']) == 1 ? TRUE : FALSE; $allforums = intval(@$forums[0]) == -1 ? TRUE : FALSE; $searchable_forums = $allforums ? '-1' : ''; // do not include the first option for ($i = 1; $i < count($forums); $i++) { $id = intval($forums[$i]); // forums if (isset($_ALLFORUMS[$id])) { if (get_map('', 'can_view', array('forum_id' => $id)) <= $request['user']->get('perms')) { $forum_ids .= !$subforums && $_ALLFORUMS[$id]['row_level'] > 2 ? '' : ' OR forum_id = ' . intval($id); $searchable_forums .= '|' . $id; } } } $category_ids = $category_ids != '' ? ' AND (' . substr($category_ids, 4) . ') ' : ''; $forum_ids = $forum_ids != '' ? ' AND (' . substr($forum_ids, 4) . ') ' : ''; // if(($allforums && !$subforums) || (!$allforums && !$subforums) ) { // $forum_ids = $forum_ids != '' ? ' AND ('. substr($forum_ids, 4) .') ' : ''; // } else { // $category_ids = ''; // $forum_ids = ''; // $searchable_forums = '-1'; // } } /* Set which forums we're looking through to the display options field */ $request['template']->setVar('search_forums', trim($searchable_forums, '|')); /** * Sort out keywords */ $keyword_query = ''; if (isset($_REQUEST['keywords']) && $_REQUEST['keywords'] != '' && !isset($_REQUEST['newposts'])) { // deal with wildcrds $keywords = str_replace('%', '*', $_REQUEST['keywords']); $keywords = intval($request['template']->getVar('allowwildcards')) == 1 ? str_replace('*', '%', $keywords) : str_replace('*', ' ', $keywords); // are the keywords too short or too long? if (strlen($keywords) < $request['template']->getVar('minsearchlength') || strlen($keywords) > $request['template']->getVar('maxsearchlength')) { $action = new K4InformationAction(new K4LanguageElement('L_INVALIDSEARCHKEYWORDS', $request['template']->getVar('minsearchlength'), $request['template']->getVar('maxsearchlength')), 'content', TRUE, 'search.php', 5); return !USE_XMLHTTP ? $action->execute($request) : xmlhttp_message(sprintf($request['template']->getVar('L_INVALIDSEARCHKEYWORDS'), $request['template']->getVar('minsearchlength'), $request['template']->getVar('maxsearchlength'))); } // has the person specified where to search? if (isset($_REQUEST['searchwhere']) && $_REQUEST['searchwhere'] != '' && $_REQUEST['searchwhere'] != 'subjectmessage') { if ($_REQUEST['searchwhere'] == 'subject') { $keyword_query = " AND LOWER(name) LIKE LOWER('%" . $request['dba']->quote($keywords) . "%')"; } else { if ($_REQUEST['searchwhere'] == 'message') { $keyword_query = " AND LOWER(body_text) LIKE LOWER('%" . $request['dba']->quote($keywords) . "%')"; } } } else { $keyword_query = " AND (LOWER(name) LIKE LOWER('%" . $request['dba']->quote($keywords) . "%') OR LOWER(body_text) LIKE LOWER('%" . $request['dba']->quote($keywords) . "%')) "; } } // set where we are searching to the template $request['template']->setVar('search_where', !isset($_REQUEST['searchwhere']) ? 'subjectmessage' : $_REQUEST['searchwhere']); // are there no keywords, user ids, etc? if ($keyword_query == '' && $user_ids == '' && !isset($_SESSION['search']['search_queries']) && !isset($_REQUEST['newposts'])) { $action = new K4InformationAction(new K4LanguageElement('L_SEARCHINVALID'), 'content', TRUE, 'search.php', 3); return !USE_XMLHTTP ? $action->execute($request) : xmlhttp_message('L_SEARCHINVALID'); } /** * Viewing preferences */ $sort_orders = array('created', 'poster_name', 'name', 'forum_id'); $viewas = isset($_SESSION['search']['search_queries']['viewas']) && $_SESSION['search']['search_queries']['viewas'] == 'topics' ? 'topics' : (isset($_REQUEST['viewas']) && $_REQUEST['viewas'] == 'topics' ? 'topics' : 'posts'); $resultsperpage = $viewas == 'topics' ? intval($request['template']->getVar('searchtopicsperpage')) : intval($request['template']->getVar('searchpostsperpage')); $resultsperpage = isset($_REQUEST['limit']) && ctype_digit($_REQUEST['limit']) && intval($_REQUEST['limit']) > 0 ? intval($_REQUEST['limit']) : $resultsperpage; $page = isset($_REQUEST['page']) && ctype_digit($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1; $daysprune = isset($_REQUEST['daysprune']) && ctype_digit($_REQUEST['daysprune']) ? $_REQUEST['daysprune'] == -1 ? 0 : intval($_REQUEST['daysprune']) : 0; $daysprune = $daysprune > 0 ? time() - @($daysprune * 86400) : 0; $sortorder = isset($_SESSION['search']['search_queries']['order']) && $_SESSION['search']['search_queries']['order'] == 'ASC' ? 'ASC' : (isset($_REQUEST['order']) && $_REQUEST['order'] == 'ASC' ? 'ASC' : 'DESC'); $sortedby = isset($_SESSION['search']['search_queries']['sort']) && $_SESSION['search']['search_queries']['sort'] != 'DESC' ? $_SESSION['search']['search_queries']['sort'] : (isset($_REQUEST['sort']) && $_REQUEST['sort'] != '' ? $_REQUEST['sort'] : 'created'); $start = ceil(@($page - 1) * $resultsperpage); /** * Execute the search */ /* Create an array of the queries that we will use to weed out posts and pass through the session */ $select = "num_replies, forum_id, post_id, post_id, body_text, name, posticon, is_poll, poster_name, poster_id, views, lastpost_uname, lastpost_uid, created, row_type"; $general_condition = "is_draft=0 AND queue=0 AND display=1 AND moved_new_post_id=0 AND post_id>0"; //$selectr = "num_replies, forum_id, post_id, post_id, body_text, name, posticon, is_poll, poster_name, poster_id, poster_ip as views, poster_ip, category_id, created, row_type"; $queries = array('posts' => "SELECT **SELECT** FROM " . K4POSTS . " WHERE {$general_condition} {$user_ids} {$forum_ids} {$category_ids} {$keyword_query} AND created >= {$daysprune} ORDER BY {$sortedby} {$sortorder}", 'topics_only' => "SELECT **SELECT** FROM " . K4POSTS . " WHERE row_type=" . TOPIC . " AND {$general_condition} {$user_ids} {$forum_ids} {$keyword_query} ORDER BY {$sortedby} {$sortorder}", 'viewas' => $viewas, 'limit' => $resultsperpage, 'sort' => $sortedby, 'order' => $sortorder, 'author' => @$_REQUEST['author'], 'keywords' => @$_REQUEST['keywords'], 'subforums' => intval(@$_REQUEST['searchsubforums'])); //print_r($queries); // set these queries to the session if (isset($_SESSION['search']['search_queries']) && is_array($_SESSION['search']['search_queries']) && !empty($_SESSION['search']['search_queries'])) { $queries = $_SESSION['search']['search_queries']; } else { $_SESSION['search']['search_queries'] = $queries; } /* Get topics and replies */ if ($queries['viewas'] == 'posts') { if (!isset($queries['num_results'])) { $num_results = $request['dba']->getValue(str_replace('**SELECT**', 'COUNT(post_id)', $queries['posts'])); $_SESSION['search']['search_queries']['num_results'] = $num_results; } else { $num_results = $queries['num_results']; } /* Set the iterator */ $result = $request['dba']->executeQuery(str_replace('**SELECT**', $select, $queries['posts']) . " LIMIT {$start}," . intval($queries['limit'])); $it =& new SearchResultsIterator($request['dba'], $result); /* Get topics only */ } else { if (!isset($queries['num_results'])) { $num_results = $request['dba']->getValue(str_replace('**SELECT**', 'COUNT(post_id)', $queries['topics_only'])); $_SESSION['search']['search_queries']['num_results'] = $num_results; } else { $num_results = $queries['num_results']; } /* get the topics */ $topics = $request['dba']->executeQuery(str_replace('**SELECT**', '*', $queries['topics_only']) . " LIMIT {$start}," . $queries['limit']); /* Apply the topics iterator */ $it =& new TopicsIterator($request['dba'], $request['user'], $topics, $request['template']->getVar('IMG_DIR'), array('postsperpage' => $queries['limit'])); } /** * Pagination */ /* Create the Pagination */ $url = new FAUrl($_URL->__toString()); $url->args['limit'] = $queries['limit']; $url->args['viewas'] = $queries['viewas']; $url->args['sort'] = $queries['sort']; $url->args['order'] = $queries['order']; $url->args['page'] = FALSE; $url->anchor = FALSE; $num_pages = ceil(@($num_results / $queries['limit'])); $pager =& new FAPaginator($url, $num_results, $page, $queries['limit']); $base_url = new FAUrl($_URL->__toString()); if ($num_results > $resultsperpage) { $request['template']->setPager('searchresults_pager', $pager); /* Create a friendly url for our pager jump */ $request['template']->setVar('pagejumper_url', preg_replace('~&~i', '&', $base_url->__toString())); } /* Outside valid page range, redirect */ if (!$pager->hasPage($page) && $num_pages > 0) { $base_url->args['page'] = $num_pages; $action = new K4InformationAction(new K4LanguageElement('L_PASTPAGELIMIT'), 'content', FALSE, $base_url->__toString(), 3); return !USE_XMLHTTP ? $action->execute($request) : xmlhttp_message('L_PASTPAGELIMIT'); } // finish stuff off $request['template']->setVar('mod_panel', 0); $request['template']->setVar('search_panel', 1); $request['template']->setList('search_results', $it); /* Search data gathered */ $request['template']->setVar('search_viewas', $queries['viewas']); $request['template']->setVar('search_viewas_int', $queries['viewas'] == 'posts' ? 1 : 2); // for the if statements $request['template']->setVar('search_num_results', $num_results); $request['template']->setVar('search_author', $queries['author']); $request['template']->setVar('search_keywords', $queries['keywords']); $request['template']->setVar('search_sort', $queries['sort']); $request['template']->setVar('search_limit', $queries['limit']); $request['template']->setVar('search_order', $queries['order']); $request['template']->setVar('search_subforums', $queries['subforums']); $request['template']->setVar('search_daysprune', isset($_REQUEST['daysprune']) ? intval($_REQUEST['daysprune']) : 0); $request['template']->setVar('post_length', isset($_REQUEST['post_length']) && intval($_REQUEST['post_length']) > 0 ? intval($_REQUEST['post_length']) : intval($request['template']->getVar('searchpostlength'))); $request['template']->setFile('content', 'search_results.html'); //$request['template']->setFile('content_extra', 'search_sort_menu.html'); $request['template']->setVisibility('forum_midsection', FALSE); /* Memory Saving */ unset($result); if (USE_XMLHTTP) { $html = $request['template']->run(BB_BASE_DIR . '/templates/' . $request['user']->get('templateset') . '/search_results_simple.html'); xmlhttp_header(); echo $html; xmlhttp_footer(); } return TRUE; }
/** * Function to make pagination */ function paginate($count, $first, $prev, $separator, $next, $last, $limit, $id) { global $_URL, $_LANG; $page = isset($_REQUEST['page']) && ctype_digit($_REQUEST['page']) ? intval($_REQUEST['page']) : 1; $limit = isset($_REQUEST['limit']) && ctype_digit($_REQUEST['limit']) ? intval($_REQUEST['limit']) : $limit; $limit = $limit <= 0 ? 10 : $limit; $url = new FAUrl($_URL->__toString()); $url->anchor = FALSE; $url->host = FALSE; $url->user = FALSE; $url->scheme = FALSE; $url->path = FALSE; $url->file = 'viewtopic.php'; $url->args['id'] = intval($id); $before = 3; $after = 3; $num_pages = @ceil($count / $limit); $page_start = $page - $before < 1 ? 1 : $page - $before; $page_end = $page + $after > $num_pages ? $num_pages : $page + $after; $url->args['page'] = $page; $url->args['limit'] = $limit; if ($count > $limit) { $str = '<div style="float: right;"><table celpadding="0" cellspacing="' . K4_TABLE_CELLSPACING . '" border="0" class="pagination"><tr>'; if ($page > 1) { $str .= '<td class="alt2" style="padding:2px;"><a href="' . $url->__toString() . '" class="minitext">' . $first . '</a></td>'; $url->args['page'] = $page - 1 <= 0 ? 1 : $page - 1; $str .= '<td class="alt2" style="padding:2px;"><a href="' . $url->__toString() . '" class="minitext">' . $prev . '</a></td>'; } //$str .= '('; for ($i = $page_start; $i <= $page_end; $i++) { $url->args['page'] = $i; $str .= '<td class="alt1" style="padding:2px;"><a href="' . $url->__toString() . '" class="minitext">' . $i . '</a></td>'; if ($i != $page_end) { $str .= $separator; } } //$str .= ')'; if ($page != $num_pages) { if ($page != $num_pages && $page > 1) { $url->args['page'] = $page + 1 < $num_pages ? $page + 1 : $num_pages; $str .= '<td class="alt2" style="padding:2px;"><a href="' . $url->__toString() . '" class="minitext">' . $next . '</a></td>'; } $url->args['page'] = $num_pages; $str .= '<td class="alt2" style="padding:2px;"><a href="' . $url->__toString() . '" class="minitext">' . $last . '</a></td>'; } $str .= '</tr></table></div>'; return $str; } }
/** * Email a user with the proper noreply email address */ function email_user($to, $subject, $message, $from = 'noreply', $headers = "") { global $_URL, $_SETTINGS; $verify_url = new FAUrl($_URL->__toString()); $verify_url->args = array(); $verify_url->file = FALSE; $verify_url->anchor = FALSE; $verify_url->scheme = FALSE; $verify_url->path = FALSE; $verify_url->host = preg_replace('~www\\.~i', '', $verify_url->host); return @mail($to, $subject, $message, "From: \"" . $_SETTINGS['bbtitle'] . " Forums\" <" . $from . "@" . substr($verify_url->__toString(), 0, -1) . ">" . $headers); }
function execute(&$request) { global $_URL; if ($request['user']->get('perms') < get_map('banuser', 'can_add', array()) && $request['user']->get('perms') < get_map('warnuser', 'can_add', array()) && $request['user']->get('perms') < get_map('flaguser', 'can_add', array())) { no_perms_error($request); return TRUE; } // include the wildcards in the valid username match if (!isset($_REQUEST['username']) || $_REQUEST['username'] == '' || !preg_match('~^[a-zA-Z]([a-zA-Z0-9]*[-_ \\*\\%]?)*[a-zA-Z0-9]*$~', $_REQUEST['username'])) { $action = new K4InformationAction(new K4LanguageElement('L_BADUSERS'), 'content', TRUE); return $action->execute($request); } $url = new FAUrl($_URL->__toString()); $username = str_replace('*', '%', $request['dba']->quote($_REQUEST['username'])); $num_users = $request['dba']->getValue("SELECT COUNT(*) FROM " . K4USERS . " WHERE lower(name) LIKE lower('%{$username}%') ORDER BY name DESC"); $request['template']->setVar('search_num_results', $num_users); $perpage = isset($_REQUEST['limit']) && ctype_digit($_REQUEST['limit']) && intval($_REQUEST['limit']) > 0 ? intval($_REQUEST['limit']) : 25; $num_pages = @ceil($num_users / $perpage); $page = isset($_REQUEST['page']) && ctype_digit($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1; $url->args['username'] = $username; $pager =& new FAPaginator($url, $num_users, $page, $perpage); if ($num_users > $perpage) { $request['template']->setPager('users_pager', $pager); /* Create a friendly url for our pager jump */ $page_jumper = new FAUrl($_URL->__toString()); $page_jumper->args['limit'] = $perpage; $page_jumper->args['page'] = FALSE; $page_jumper->anchor = FALSE; $request['template']->setVar('pagejumper_url', preg_replace('~&~i', '&', $page_jumper->__toString())); } k4_bread_crumbs($request['template'], $request['dba'], 'L_FINDUSERS'); /* Outside valid page range, redirect */ if (!$pager->hasPage($page) && $num_pages > 0) { $action = new K4InformationAction(new K4LanguageElement('L_PASTPAGELIMIT'), 'content', FALSE, 'mod.php?act=findusers&username='******'&limit=' . $perpage . '&page=' . $num_pages, 3); return $action->execute($request); } $result = $request['dba']->executeQuery("SELECT * FROM " . K4USERS . " WHERE lower(name) LIKE lower('%{$username}%') ORDER BY name DESC"); $it =& new UsersIterator($result); $request['template']->setList('users', $it); $request['template']->setFile('content', 'foundusers.html'); }
function execute(&$request) { global $_QUERYPARAMS, $_URL; /** * Error checking */ /* set the breadcrumbs bit */ k4_bread_crumbs($request['template'], $request['dba'], 'L_INFORMATION'); if (!isset($_REQUEST['id']) || !$_REQUEST['id'] || intval($_REQUEST['id']) == 0) { $action = new K4InformationAction(new K4LanguageElement('L_TOPICDOESNTEXIST'), 'content', FALSE); return $action->execute($request); } /* Get our topic */ $topic = $request['dba']->getRow("SELECT * FROM " . K4POSTS . " WHERE post_id = " . intval($_REQUEST['id'])); if (!$topic || !is_array($topic) || empty($topic)) { $action = new K4InformationAction(new K4LanguageElement('L_TOPICDOESNTEXIST'), 'content', FALSE); return $action->execute($request); } // set the topic id to the template $request['template']->setVar('topic_id', $topic['post_id']); // get the forum $forum = $request['dba']->getRow("SELECT * FROM " . K4FORUMS . " WHERE forum_id = " . intval($topic['forum_id'])); /* Check the forum data given */ if (!$forum || !is_array($forum) || empty($forum)) { $action = new K4InformationAction(new K4LanguageElement('L_FORUMDOESNTEXIST'), 'content', FALSE); return $action->execute($request); } /* Make sure the we are trying to post to a forum */ if (!($forum['row_type'] & FORUM) || $forum['forum_id'] == GARBAGE_BIN) { no_perms_error($request); return TRUE; } /* Do we have permission to post to this topic in this forum? */ if ($request['user']->get('perms') < get_map('replies', 'can_add', array('forum_id' => $forum['forum_id']))) { no_perms_error($request); return TRUE; } if (isset($_REQUEST['r']) && intval($_REQUEST['r']) != 0) { $reply = $request['dba']->getRow("SELECT * FROM " . K4POSTS . " WHERE post_id = " . intval($_REQUEST['r'])); if (!$reply || !is_array($reply) || empty($reply)) { $action = new K4InformationAction(new K4LanguageElement('L_REPLYDOESNTEXIST'), 'content', FALSE); return $action->execute($request); } else { $request['template']->setVisibility('parent_id', TRUE); $request['template']->setVar('parent_id', $reply['post_id']); } } /* Prevent post flooding */ $last_topic = $request['dba']->getRow("SELECT * FROM " . K4POSTS . " WHERE poster_ip = '" . USER_IP . "' ORDER BY created DESC LIMIT 1"); $last_reply = $request['dba']->getRow("SELECT * FROM " . K4POSTS . " WHERE poster_ip = '" . USER_IP . "' ORDER BY created DESC LIMIT 1"); if (is_array($last_topic) && !empty($last_topic)) { if (intval($last_topic['created']) + POST_IMPULSE_LIMIT > time() && $request['user']->get('perms') < MODERATOR) { $action = new K4InformationAction(new K4LanguageElement('L_MUSTWAITSECSTOPOST'), 'content', TRUE); return $action->execute($request); } } if (is_array($last_reply) && !empty($last_reply)) { if (intval($last_reply['created']) + POST_IMPULSE_LIMIT > time() && $request['user']->get('perms') < MODERATOR) { $action = new K4InformationAction(new K4LanguageElement('L_MUSTWAITSECSTOPOST'), 'content', TRUE); return $action->execute($request); } } $parent = isset($reply) && is_array($reply) ? $reply : $topic; /** * Start setting useful template information */ /* Get and set the emoticons and post icons to the template */ $emoticons = $request['dba']->executeQuery("SELECT * FROM " . K4EMOTICONS . " WHERE clickable = 1"); $posticons = $request['dba']->executeQuery("SELECT * FROM " . K4POSTICONS); $request['template']->setList('emoticons', $emoticons); $request['template']->setList('posticons', $posticons); $request['template']->setVar('emoticons_per_row', $request['template']->getVar('smcolumns')); $request['template']->setVar('emoticons_per_row_remainder', $request['template']->getVar('smcolumns') - 1); /* Set to the template what posting perms this user has */ topic_post_options($request['template'], $request['user'], $forum); /** * Deal with reply attachments */ $num_attachments = 0; /** * Deal with file attachments */ if ($request['template']->getVar('attach_inputs') == '') { if ($request['user']->get('perms') >= get_map('attachments', 'can_add', array('forum_id' => $forum['forum_id']))) { $num_attachments = $request['template']->getVar('nummaxattaches') - $num_attachments; $attach_inputs = ''; for ($i = 1; $i <= $num_attachments; $i++) { $attach_inputs .= '<br /><input type="file" class="inputbox" name="attach' . $i . '" id="attach' . $i . '" value="" size="55" />'; } $request['template']->setVar('attach_inputs', $attach_inputs); } } /* Set the forum and topic info to the template */ foreach ($forum as $key => $val) { $request['template']->setVar('forum_' . $key, $val); } /* We set topic information to be reply information */ foreach ($topic as $key => $val) { /* Omit the body text variable */ if ($key != 'body_text') { $request['template']->setVar('post_' . $key, $val); } } $body_text = ''; /* If this is a quote, put quote tags around the message */ if (isset($_REQUEST['quote']) && intval($_REQUEST['quote']) == 1) { // are we quoting a poll? if ($parent['is_poll'] == 1) { // does this reply have a/some poll(s) ? preg_match_all('~\\[poll=([0-9]+?)\\]~i', $parent['body_text'], $poll_matches, PREG_SET_ORDER); if (count($poll_matches) > 0) { $url = new FAUrl($_URL->__toString()); $url->args = array(); $url->anchor = FALSE; $url->file = 'viewpoll.php'; foreach ($poll_matches as $poll) { $parent['body_text'] = str_replace('[poll=' . $poll[1] . ']', $request['template']->getVar('L_POLL') . ': [b][url=' . $url->__toString() . '?id=' . $poll[1] . ']' . $request['dba']->getValue("SELECT question FROM " . K4POLLQUESTIONS . " WHERE id = " . intval($poll[1])) . '[/url][/b]', $parent['body_text']); } } } // revert the text with the bbcode parser $parser =& new BBParser(); $body_text = '[quote=' . ($parent['poster_name'] == '' ? $request['template']->getVar('L_GUEST') : $parent['poster_name']) . ']' . $parser->revert($parent['body_text']) . '[/quote]'; } /* Set the title variable */ $request['template']->setVar('post_name', $request['template']->getVar('L_RE') . ': ' . (isset($reply) ? $reply['name'] : $topic['name'])); $request['template']->setVar('L_TITLETOOSHORT', sprintf($request['template']->getVar('L_TITLETOOSHORT'), $request['template']->getVar('topicminchars'), $request['template']->getVar('topicmaxchars'))); /* set the breadcrumbs bit */ k4_bread_crumbs($request['template'], $request['dba'], 'L_POSTREPLY', $parent, $forum); foreach ($parent as $key => $val) { $request['template']->setVar('parent_' . $key, $val); } $query = "SELECT * FROM " . K4POSTS . " WHERE post_id = " . intval($topic['post_id']) . " ORDER BY created DESC LIMIT 10"; $replies = $request['dba']->executeQuery($query); /* Set the form actiob */ $request['template']->setVar('newreply_act', 'newreply.php?act=postreply'); $it =& new TopicReviewIterator($request['dba'], $topic, $replies, $request['user']->getInfoArray()); $request['template']->setList('topic_review', $it); /* Set the post topic form */ $request['template']->setFile('content', 'newreply.html'); /* Create our editor */ create_editor($request, $body_text, 'post', $forum); /* Clear up some memory */ unset($it, $body_text, $forum, $replies, $bbcode, $last_topic, $last_reply, $topic); return TRUE; }
function execute(&$request) { global $_USERGROUPS, $_QUERYPARAMS, $_URL; /** * Are we looking at the list of user groups? */ if (!isset($_REQUEST['id']) || intval($_REQUEST['id']) == 0) { $result = explode('|', $request['user']->get('usergroups')); $groups = $request['user']->get('usergroups') && $request['user']->get('usergroups') != '' ? iif(!$result, force_usergroups($request['user']->getInfoArray()), $result) : array(); $query = "SELECT * FROM " . K4USERGROUPS . " WHERE display_legend = 1"; if ($request['user']->get('perms') < ADMIN) { foreach ($groups as $id) { if (isset($_USERGROUPS[$id])) { $query .= ' OR id = ' . intval($id); } } } else { $query = "SELECT * FROM " . K4USERGROUPS; } $groups = $request['dba']->executeQuery($query); $request['template']->setList('usergroups', $groups); k4_bread_crumbs($request['template'], $request['dba'], 'L_USERGROUPS'); $request['template']->setFile('content', 'usergroups.html'); /** * Are we looking at a specific user group? */ } else { /* Is this user group set? */ if (!isset($_USERGROUPS[intval($_REQUEST['id'])])) { k4_bread_crumbs($request['template'], $request['dba'], 'L_INFORMATION'); $action = new K4InformationAction(new K4LanguageElement('L_GROUPDOESNTEXIST'), 'content', FALSE); return $action->execute($request); } $group = $_USERGROUPS[intval($_REQUEST['id'])]; /** * If the group admin has yet to be set, set it to our administrator */ if ($group['mod_name'] == '' || $group['mod_id'] == 0) { /* Get our administrator */ $admin = $request['dba']->getRow("SELECT * FROM " . K4USERS . " WHERE perms >= " . intval(ADMIN) . " ORDER BY perms,id ASC LIMIT 1"); $request['dba']->executeUpdate("UPDATE " . K4USERGROUPS . " SET mod_name = '" . $request['dba']->quote($admin['name']) . "', mod_id = " . intval($admin['id']) . " WHERE id = " . intval($group['id'])); reset_cache('usergroups'); /* Add this info to the group array so that we can access it later */ $group['mod_name'] = $admin['name']; $group['mod_id'] = $admin['id']; } /* Get our admins max user group.. it _should_ be the administrators group */ $g = get_user_max_group($request['dba']->getRow("SELECT " . $_QUERYPARAMS['user'] . $_QUERYPARAMS['userinfo'] . " FROM " . K4USERS . " u LEFT JOIN " . K4USERINFO . " ui ON u.id=ui.user_id WHERE u.id = " . intval($group['mod_id'])), $_USERGROUPS); /* Set his group's color */ $group['mod_color'] = !isset($g['color']) || $g['color'] == '' ? '000000' : $g['color']; /* Add this group's info to the database */ foreach ($group as $key => $val) { $request['template']->setVar('group_' . $key, $val); } /* Create the Pagination */ $resultsperpage = 10; $num_results = $request['dba']->getValue("SELECT COUNT(*) FROM " . K4USERS . " WHERE usergroups LIKE '%|" . intval($group['id']) . "|%' AND id <> " . intval($group['mod_id'])); $perpage = isset($_REQUEST['limit']) && ctype_digit($_REQUEST['limit']) && intval($_REQUEST['limit']) > 0 ? intval($_REQUEST['limit']) : $resultsperpage; $num_pages = ceil($num_results / $perpage); $page = isset($_REQUEST['page']) && ctype_digit($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1; $pager =& new FAPaginator($_URL, $num_results, $page, $perpage); if ($num_results > $perpage) { $request['template']->setPager('users_pager', $pager); /* Create a friendly url for our pager jump */ $page_jumper = new FAUrl($_URL->__toString()); $page_jumper->args['limit'] = $perpage; $page_jumper->args['page'] = FALSE; $page_jumper->anchor = FALSE; $request['template']->setVar('pagejumper_url', preg_replace('~&~i', '&', $page_jumper->__toString())); } /* Outside valid page range, redirect */ if (!$pager->hasPage($page) && $num_pages > 0) { $action = new K4InformationAction(new K4LanguageElement('L_PASTPAGELIMIT'), 'content', FALSE, 'usergroups.php?id=' . $group['id'] . '&limit=' . $perpage . '&page=' . $num_pages, 3); return $action->execute($request); } /* Get the members for this usergroup */ $start = ($page - 1) * $perpage; /* Get the members of this usergroup */ if ($num_results > 0) { $result = $request['dba']->executeQuery("SELECT " . $_QUERYPARAMS['user'] . $_QUERYPARAMS['userinfo'] . " FROM " . K4USERS . " u LEFT JOIN " . K4USERINFO . " ui ON u.id=ui.user_id WHERE u.usergroups LIKE '%|" . intval($group['id']) . "|%' AND u.id <> " . intval($group['mod_id']) . " LIMIT " . intval($start) . ", " . intval($perpage)); $users =& new UsersIterator($result); $request['template']->setList('users_in_usergroup', $users); } $request['template']->setVar('num_group_members', $num_results); if ($request['user']->get('id') == $group['mod_id']) { $request['template']->setVisibility('add_user', TRUE); $request['template']->setVar('is_mod', 1); } k4_bread_crumbs($request['template'], $request['dba'], $group['name']); $request['template']->setFile('content', 'lookup_usergroup.html'); } return TRUE; }
function execute(&$request) { global $_URL; /* set the breadcrumbs bit */ k4_bread_crumbs($request['template'], $request['dba'], 'L_INFORMATION'); if (!isset($_REQUEST['id']) || !$_REQUEST['id'] || intval($_REQUEST['id']) == 0) { $action = new K4InformationAction(new K4LanguageElement('L_FORUMDOESNTEXIST'), 'content', FALSE); return $action->execute($request); } $forum = $request['dba']->getRow("SELECT * FROM " . K4FORUMS . " WHERE forum_id = " . intval($_REQUEST['id'])); /* Check the forum data given */ if (!$forum || !is_array($forum) || empty($forum)) { $action = new K4InformationAction(new K4LanguageElement('L_FORUMDOESNTEXIST'), 'content', FALSE); return $action->execute($request); } /* Make sure the we are trying to post into a forum */ if (!($forum['row_type'] & FORUM)) { $action = new K4InformationAction(new K4LanguageElement('L_CANTMODACATEGORY'), 'content', FALSE); return $action->execute($request); } foreach ($forum as $key => $val) { $request['template']->setVar('forum_' . $key, $val); } /** * Moderator Functions */ $extra = 'AND queue = 0'; $request['template']->setVar('modpanel', 0); /* is this user a moderator */ if (is_moderator($request['user']->getInfoArray(), $forum)) { $mod_url = new FAUrl($_URL->__toString()); $mod_url->file = 'viewforum.php'; $mod_url->args = array('f' => $forum['forum_id']); $request['template']->setVar('mod_url', $mod_url->__toString()); $request['template']->setVar('modpanel', 1); } else { no_perms_error($request); return TRUE; } k4_bread_crumbs($request['template'], $request['dba'], 'L_BADPOSTREPORTS', $forum); $num_results = $request['dba']->getValue("SELECT COUNT(*) FROM " . K4BADPOSTREPORTS . " WHERE forum_id = " . intval($forum['forum_id'])); /** * Pagination */ /* Create the Pagination */ $perpage = isset($_REQUEST['limit']) && ctype_digit($_REQUEST['limit']) && intval($_REQUEST['limit']) > 0 ? intval($_REQUEST['limit']) : 10; $num_pages = ceil($num_results / $perpage); $page = isset($_REQUEST['page']) && ctype_digit($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1; $pager =& new FAPaginator($_URL, $num_results, $page, $perpage); if ($num_results > $perpage) { $request['template']->setPager('topics_pager', $pager); /* Create a friendly url for our pager jump */ $page_jumper = new FAUrl($_URL->__toString()); $page_jumper->args['limit'] = $perpage; $page_jumper->args['page'] = FALSE; $page_jumper->anchor = FALSE; $request['template']->setVar('pagejumper_url', preg_replace('~&~i', '&', $page_jumper->__toString())); } /* Outside valid page range, redirect */ if (!$pager->hasPage($page) && $num_pages > 0) { $action = new K4InformationAction(new K4LanguageElement('L_PASTPAGELIMIT'), 'content', FALSE, 'mod.php?id=' . $forum['forum_id'] . '&limit=' . $perpage . '&page=' . $num_pages, 3); return $action->execute($request); } /* Get the bad post reports for this forum */ $start = ($page - 1) * $perpage; $reports = $request['dba']->executeQuery("SELECT * FROM " . K4BADPOSTREPORTS . " WHERE forum_id = " . intval($forum['forum_id'] . " ORDER BY created ASC LIMIT {$start},{$perpage}")); $it = new BadPostReportIterator($request['dba'], $reports); $request['template']->setList('badpost_reports', $it); $request['template']->setFile('content', 'badpost_reports.html'); }