function sp_do_sp_ForumDropdownTag($args = '')
{
#check if forum displayed
if (sp_abort_display_forum()) {
return;
}
$defs = array('tagId' => 'spForumDropdownTag', 'tagClass' => 'spLinkTag', 'selectClass' => 'spSelectTag', 'forumList' => 0, 'label' => __("Select forum", 'sp-ttags'), 'length' => 30, 'echo' => 1);
$a = wp_parse_args($args, $defs);
$a = apply_filters('sph_ForumDropdownTag_args', $a);
extract($a, EXTR_SKIP);
# sanitize before use
$tagId = esc_attr($tagId);
$tagClass = esc_attr($tagClass);
$selectClass = esc_attr($selectClass);
$forumList = esc_attr($forumList);
$label = sp_filter_title_display($label);
$length = (int) $length;
$echo = (int) $echo;
global $spThisUser;
sp_forum_api_support();
$forum_ids = array();
if ($forumList == 0) {
$forum_ids = sp_get_forum_memberships($spThisUser->ID);
} else {
$allforums = explode(',', $forumList);
foreach ($allforums as $thisforum) {
if (sp_can_view($thisforum, 'forum-title')) {
$forum_ids[] = $thisforum;
}
}
}
if (empty($forum_ids)) {
return;
}
# create where clause based on forums that current user can view
$where = "forum_id IN (" . implode(",", $forum_ids) . ")";
$spdb = new spdbComplex();
$spdb->table = SFFORUMS;
$spdb->fields = 'forum_slug, forum_name';
$spdb->join = array(SFGROUPS . ' ON ' . SFFORUMS . '.group_id = ' . SFGROUPS . '.group_id');
$spdb->where = $where;
$spdb->orderby = 'group_seq, forum_seq';
$forums = $spdb->select();
$out = "<div id='{$tagId}' class='{$tagClass}'>";
$out .= '<select name="forumselect" class="' . $selectClass . '" onChange="javascript:spjChangeForumURL(this)">' . "\n";
$out .= '<option>' . $label . '</option>' . "\n";
foreach ($forums as $forum) {
$out .= '<option value="' . sp_build_url($forum->forum_slug, '', 0, 0) . '"> ' . sp_create_name_extract(sp_filter_title_display($forum->forum_name), $length) . '</option>' . "\n";
}
$out .= '</select>' . "\n";
$out .= '</div>';
$out .= '<script type="text/javascript">';
$out .= 'function spjChangeForumURL(menuObj) {';
$out .= 'var i = menuObj.selectedIndex;';
$out .= 'if(i > 0) {';
$out .= 'if(menuObj.options[i].value != "#") {';
$out .= 'window.location = menuObj.options[i].value;';
$out .= '}}}';
$out .= '</script>';
$out = apply_filters('sph_ForumDropdownTag', $out);
if ($echo) {
echo $out;
} else {
return $out;
}
}
function sp_do_sp_AuthorPostsTag($args = '')
{
#check if forum displayed
if (sp_abort_display_forum()) {
return;
}
$defs = array('tagId' => 'spAuthorPostsTag', 'tagClass' => 'spLinkTag', 'authorId' => '', 'showForum' => 1, 'showDate' => 1, 'limit' => 5, 'listTags' => 0, 'echo' => 1);
$a = wp_parse_args($args, $defs);
$a = apply_filters('sph_AuthorPostsTag_args', $a);
extract($a, EXTR_SKIP);
# sanitize before use
$tagId = esc_attr($tagId);
$tagClass = esc_attr($tagClass);
$authorId = (int) $authorId;
$showForum = (int) $showForum;
$showDate = (int) $showDate;
$limit = (int) $limit;
$listTags = (int) $listTags;
$echo = (int) $echo;
if (empty($authorId)) {
return;
}
sp_forum_api_support();
if ($limit == 0) {
$limit = '';
}
# limit to viewable forums based on permissions
$where = SFPOSTS . '.user_id = ' . $authorId . ' AND ' . SFPOSTS . '.post_status=0 ';
$forum_ids = sp_get_forum_memberships();
# create where clause based on forums that current user can view
if ($forum_ids != '') {
$where .= "AND " . SFPOSTS . ".forum_id IN (" . implode(",", $forum_ids) . ")";
} else {
return '';
}
$spdb = new spdbComplex();
$spdb->table = SFPOSTS;
$spdb->distinct = true;
$spdb->fields = SFPOSTS . '.post_id, ' . SFPOSTS . '.forum_id, ' . SFPOSTS . '.topic_id, ' . spdb_zone_datetime('post_date') . ',
post_index, forum_slug, forum_name, topic_slug, topic_name';
$spdb->join = array(SFTOPICS . ' ON ' . SFPOSTS . '.topic_id = ' . SFTOPICS . '.topic_id', SFFORUMS . ' ON ' . SFPOSTS . '.forum_id = ' . SFFORUMS . '.forum_id');
$spdb->where = $where;
$spdb->orderby = 'post_date DESC';
$spdb->limits = $limit;
$sfposts = $spdb->select();
if (!$listTags) {
$out = "<div id='{$tagId}' class='{$tagClass}'>";
$open = '<div>';
$close = '</div>';
} else {
$out = "<ul id='{$tagId}' class='{$tagClass}'>";
$open = '<li>';
$close = '</li>';
}
if ($sfposts) {
foreach ($sfposts as $sfpost) {
$out .= $open;
if ($showForum) {
$out .= sp_filter_title_display($sfpost->forum_name) . '<br />';
}
$out .= '<a href="' . sp_build_url($sfpost->forum_slug, $sfpost->topic_slug, 0, $sfpost->post_id, $sfpost->post_index) . '">' . sp_filter_title_display($sfpost->topic_name) . '</a><br />' . "\n";
if ($showDate) {
$out .= sp_date('d', $sfpost->post_date) . '<br />';
}
$out .= $close;
}
} else {
$out .= $open . __('No posts by this author', 'sp-ttags') . $close;
}
if (!$listTags) {
$out .= '</div>';
} else {
$out .= '</ul>';
}
$out = apply_filters('sph_AuthorPostsTag', $out);
if ($echo) {
echo $out;
} else {
return $out;
}
}
function sp_memberslist_query($groupBy, $orderBy, $sortBy, $number, $limitUG, $ugids)
{
global $spThisUser, $spVars, $wpdb;
# check for page
$page = isset($_GET['page']) ? sp_esc_int($_GET['page']) : $spVars['page'];
# check for member search
$search = !empty($_POST['msearch']) && !isset($_POST['allmembers']) ? sp_esc_str($_POST['msearch']) : '';
$search = !empty($_GET['msearch']) ? sp_esc_str($_GET['msearch']) : $search;
# check for usergroup selection query arg
$ug_select = !empty($_POST['ug']) && !isset($_POST['allmembers']) ? sp_esc_int($_POST['ug']) : '';
$ug_select = !empty($_GET['ug']) ? sp_esc_int($_GET['ug']) : $ug_select;
# check for constructor limiting usergroups
if ($groupBy == 'usergroup' && !empty($ugids)) {
$ugids = explode(',', sp_esc_str($ugids));
}
$data = new stdClass();
$data->records = new stdClass();
$data->count = 0;
if ($spThisUser->admin || sp_get_auth('view_members_list')) {
# default to 'no data'
$this->membersListStatus = 'no data';
# are we limiting member lists to user group memberships?
$where = 'posts > -2';
if ($groupBy == 'usergroup' && !$spThisUser->admin) {
# if limiting to memberships, get usergroups current user has membership in
if ($limitUG) {
$ugs = sp_get_user_memberships($spThisUser->ID);
if (empty($ugs)) {
$value = sp_get_sfmeta('default usergroup', 'sfguests');
$sql = 'SELECT * FROM ' . SFUSERGROUPS . " WHERE usergroup_id={$value[0]['meta_value']}";
$ugs = spdb_select('set', $sql, ARRAY_A);
}
# Now add any moderator user groups who can moderate the current users forums
$forums = sp_get_forum_memberships($spThisUser->ID);
$forums = implode(',', $forums);
$sql = 'SELECT DISTINCT ' . SFMEMBERSHIPS . '.usergroup_id, usergroup_name, usergroup_desc, usergroup_join, usergroup_badge FROM ' . SFMEMBERSHIPS . '
JOIN ' . SFUSERGROUPS . ' ON ' . SFUSERGROUPS . '.usergroup_id = ' . SFMEMBERSHIPS . '.usergroup_id
JOIN ' . SFPERMISSIONS . ' ON ' . SFPERMISSIONS . ".forum_id IN ({$forums})\n\t\t\t\t\tWHERE usergroup_is_moderator=1 ORDER BY " . SFMEMBERSHIPS . '.usergroup_id';
$mugs = spdb_select('set', $sql, ARRAY_A);
if ($mugs) {
$ugs = array_merge($mugs, $ugs);
}
} else {
$ugs = spdb_table(SFUSERGROUPS, '', '', '', '', ARRAY_A);
}
if (empty($ugs)) {
return $data;
}
# now build the where clause
$ug_ids = array();
foreach ($ugs as $index => $ug) {
if (empty($ugids) || in_array($ug['usergroup_id'], $ugids)) {
$ug_ids[] = $ug['usergroup_id'];
} else {
unset($ugs[$index]);
}
}
if (empty($ug_ids)) {
return $data;
}
$this->userGroups = array_values($ugs);
# create where clause based on user memberships
if (!$limitUG && empty($ugids) && empty($ug_select)) {
# not limiting by usergroup or specific ids so grab all users
$where .= ' AND (' . SFMEMBERSHIPS . '.usergroup_id IN (' . implode(',', $ug_ids) . ') OR ' . SFMEMBERSHIPS . '.usergroup_id IS NULL)';
} else {
if (empty($ug_select)) {
# limiting by usergroup or specific ids, so only grab those users plus admins (skips users with no memmberships)
$where .= ' AND (' . SFMEMBERSHIPS . '.usergroup_id IN (' . implode(',', $ug_ids) . ') OR admin=1)';
} else {
$where .= ' AND (' . SFMEMBERSHIPS . ".usergroup_id = {$ug_select} AND " . SFMEMBERSHIPS . '.usergroup_id IN (' . implode(',', $ug_ids) . '))';
}
}
} else {
if (!empty($ug_select)) {
$where .= ' AND ' . SFMEMBERSHIPS . ".usergroup_id = {$ug_select}";
}
$this->userGroups = spdb_table(SFUSERGROUPS, '', '', '', '', ARRAY_A);
}
if ($search != '') {
$where .= ' AND ' . SFMEMBERS . '.display_name LIKE "' . esc_sql($wpdb->esc_like($search)) . '%"';
}
# how many members per page?
$startlimit = 0;
if ($page != 1) {
$startlimit = ($page - 1) * $number;
}
$limit = $startlimit . ', ' . $number;
$order = '';
if ($groupBy == 'usergroup' && $orderBy == 'id') {
$order .= "usergroup_id {$sortBy}, " . SFMEMBERS . ".display_name {$sortBy}";
}
if ($groupBy == 'usergroup' && $orderBy == 'alpha') {
$order .= "usergroup_name {$sortBy}, " . SFMEMBERS . ".display_name {$sortBy}";
}
if ($groupBy == 'user' && $orderBy == 'id') {
$order .= SFMEMBERS . ".user_id {$sortBy}";
}
if ($groupBy == 'user' && $orderBy == 'alpha') {
$order .= SFMEMBERS . ".display_name {$sortBy}";
}
$join = SFUSERS . ' ON ' . SFMEMBERS . '.user_id=' . SFUSERS . '.ID ';
if ($groupBy == 'usergroup') {
$q = 'if (' . SFMEMBERS . '.admin=1, 0, IFNULL(' . SFMEMBERSHIPS . '.usergroup_id, 99999999)) AS usergroup_id,
if (' . SFMEMBERS . '.admin=1, "' . sp_text('Admins') . '", IFNULL(' . SFUSERGROUPS . '.usergroup_name, "' . sp_text('No Memberships') . '")) as usergroup_name,
if (' . SFMEMBERS . '.admin=1, "' . sp_text('Forum Administrators') . '", IFNULL(' . SFUSERGROUPS . '.usergroup_desc, "' . sp_text('Members without any usergroup memberships') . '")) as usergroup_desc,
' . SFMEMBERS . '.user_id, ' . SFMEMBERS . '.display_name, admin, avatar, posts, lastvisit, user_registered, user_url, user_options';
$join .= 'LEFT JOIN ' . SFMEMBERSHIPS . ' ON ' . SFMEMBERSHIPS . '.user_id=' . SFMEMBERS . '.user_id
LEFT JOIN ' . SFUSERGROUPS . ' ON ' . SFUSERGROUPS . '.usergroup_id=' . SFMEMBERSHIPS . '.usergroup_id';
} else {
$q = SFMEMBERS . '.user_id, ' . SFMEMBERS . '.display_name, admin, avatar, posts, lastvisit, user_registered, user_url, user_options';
}
# retrieve members list records
$spdb = new spdbComplex();
$spdb->table = SFMEMBERS;
$spdb->fields = $q;
$spdb->found_rows = true;
$spdb->distinct = true;
$spdb->left_join = $join;
$spdb->where = $where;
$spdb->orderby = $order;
$spdb->limits = $limit;
$spdb = apply_filters('sph_members_list_query', $spdb, $this);
$records = $spdb->select();
if ($records) {
$m = array();
$ugidx = -1;
$midx = 0;
$data->count = spdb_select('var', 'SELECT FOUND_ROWS()');
foreach ($records as $r) {
# for user list only, set up dummy usergroup
if ($groupBy != 'usergroup') {
$ugidx = 0;
}
# we have data
$this->membersListStatus = 'data';
# set up the usergroup outer data and member inner data
if ($groupBy == 'usergroup' && ($ugidx == -1 || $m[$ugidx]->usergroup_id != $r->usergroup_id)) {
$ugidx++;
$midx = 0;
$m[$ugidx] = new stdClass();
$m[$ugidx]->usergroup_id = $r->usergroup_id;
$name = !empty($r->usergroup_name) ? sp_filter_title_display($r->usergroup_name) : sp_text('No Memberships');
$desc = !empty($r->usergroup_desc) ? sp_filter_title_display($r->usergroup_desc) : sp_text('Members without any usergroup memberships');
$m[$ugidx]->usergroup_name = $name;
$m[$ugidx]->usergroup_desc = $desc;
$m[$ugidx] = apply_filters('sph_members_list_records', $m[$ugidx], $r);
}
if (isset($r->user_id)) {
$m[$ugidx]->members[$midx] = new stdClass();
$m[$ugidx]->members[$midx]->user_id = $r->user_id;
$m[$ugidx]->members[$midx]->display_name = sp_filter_title_display($r->display_name);
$m[$ugidx]->members[$midx]->posts = $r->posts;
$m[$ugidx]->members[$midx]->user_url = $r->user_url;
$m[$ugidx]->members[$midx]->admin = $r->admin;
$m[$ugidx]->members[$midx]->avatar = unserialize($r->avatar);
$m[$ugidx]->members[$midx]->user_options = unserialize($r->user_options);
$m[$ugidx]->members[$midx]->lastvisit = sp_apply_timezone(sp_member_lastvisit_to_server_tz($r->lastvisit, $m[$ugidx]->members[$midx]->user_options), 'mysql');
$m[$ugidx]->members[$midx]->user_registered = sp_member_registration_to_server_tz($r->user_registered);
$m[$ugidx]->members[$midx] = apply_filters('sph_members_list_records', $m[$ugidx]->members[$midx], $r);
$midx++;
}
}
$data->records = $m;
}
} else {
$this->membersListStatus = 'no access';
}
return $data;
}
function sp_do_sp_HotTopicsTag($args = '')
{
#check if forum displayed
if (sp_abort_display_forum()) {
return;
}
global $spThisUser;
$defs = array('tagId' => 'spHotTopicsTag', 'tagClass' => 'spHotTopicsTag', 'listClass' => 'spListItemTag', 'textClass' => 'spHotTopicTextTag', 'listTags' => 1, 'forumIds' => 0, 'limit' => 5, 'days' => 30, 'showForum' => 1, 'textForum' => __('posted in', 'sp-ttags'), 'showCount' => 1, 'textCount' => __('recent posts', 'sp-ttags'), 'showHotness' => 1, 'textHotness' => __('hotness', 'sp-ttags'), 'echo' => 1);
$a = wp_parse_args($args, $defs);
$a = apply_filters('sph_HotTopicsTag_args', $a);
extract($a, EXTR_SKIP);
# sanitize before use
$tagId = esc_attr($tagId);
$tagClass = esc_attr($tagClass);
$listClass = esc_attr($listClass);
$textClass = esc_attr($textClass);
$listTags = (int) $listTags;
$forumIds = sp_filter_title_display($forumIds);
$limit = (int) $limit;
$days = (int) $days;
$showForum = (int) $showForum;
$textForum = sp_filter_title_display($textForum);
$showCount = (int) $showCount;
$textCount = sp_filter_title_display($textCount);
$showHotness = (int) $showHotness;
$textHotness = sp_filter_title_display($textHotness);
$echo = (int) $echo;
sp_forum_api_support();
$forumList = '';
if (!empty($forumIds)) {
# are we passing forum ID's?
$flist = explode(',', $forumIds);
foreach ($flist as $id) {
if (sp_can_view($id, 'topic-title')) {
$forumList[] = $id;
}
}
} else {
global $spThisUser;
$allForums = sp_get_forum_memberships($spThisUser->ID);
if ($allForums) {
foreach ($allForums as $id) {
if (sp_can_view($id, 'topic-title')) {
$forumList[] = $id;
}
}
}
}
if (!empty($forumList)) {
$where = ' AND ' . SFPOSTS . '.forum_id IN (' . implode(',', $forumList) . ')';
} else {
return '';
}
# get any posts that meeet date criteria
$spdb = new spdbComplex();
$spdb->table = SFPOSTS;
$spdb->fields = SFPOSTS . '.topic_id, DATEDIFF(CURDATE(), post_date) AS delta, ' . SFPOSTS . '.forum_id, forum_name, forum_slug, forum_slug, topic_name, topic_slug';
$spdb->join = array(SFTOPICS . ' ON ' . SFTOPICS . '.topic_id = ' . SFPOSTS . '.topic_id', SFFORUMS . ' ON ' . SFFORUMS . '.forum_id = ' . SFPOSTS . '.forum_id');
$spdb->where = 'DATE_SUB(CURDATE(),INTERVAL ' . $days . ' DAY) <= post_date' . $where;
$spdb = apply_filters('sph_HotTopicsTagQuery', $spdb);
$posts = $spdb->select();
$out = '';
$out = $listTags ? "<ul id='{$tagId}' class='{$tagClass}'>" : "<div id='{$tagId}' class='{$tagClass}'>";
if ($posts) {
# give each topic with posts a score - currently ln(cur date - post date) for each post
$score = $count = $forum_name = $forum_slug = $topic_slug = $topic_name = array();
foreach ($posts as $post) {
if ($post->delta != $days) {
$value = apply_filters('sph_HotTopicTagScore', log($days - $post->delta), $post, $a);
# let plugins modify the hotness algorithm
$score[$post->topic_id] = isset($score[$post->topic_id]) ? $score[$post->topic_id] + $value : $value;
$count[$post->topic_id] = isset($count[$post->topic_id]) ? $count[$post->topic_id] + 1 : 1;
$forum_name[$post->topic_id] = sp_filter_title_display($post->forum_name);
$forum_slug[$post->topic_id] = $post->forum_slug;
$topic_slug[$post->topic_id] = $post->topic_slug;
$topic_name[$post->topic_id] = sp_filter_title_display($post->topic_name);
}
}
# reverse sort the posts and limit to number to display
arsort($score);
$topics = array_slice($score, 0, $limit, true);
# now output the popular topics
foreach ($topics as $id => $topic) {
$out .= $listTags ? "<li class='{$listClass}'>" : "<div class='{$textClass}'>";
$out .= sp_get_topic_url($forum_slug[$id], $topic_slug[$id], $topic_name[$id]);
if ($showForum) {
$out .= " {$textForum} {$forum_name[$id]}";
}
if ($showCount) {
$out .= ' (' . $count[$id] . " {$textCount})";
}
if ($showHotness) {
$out .= ' (' . round($score[$id], 2) . " {$textHotness})";
}
$out .= $listTags ? '</li>' : '</div>';
}
} else {
$out .= "<div class='{$textClass}'>" . __('No current hot topics to display', 'sp-ttags') . '</div>';
}
$out .= $listTags ? '</ul>' : '</div>';
$out = apply_filters('sph_HotTopicsTag', $out);
if ($echo) {
echo $out;
} else {
return $out;
}
}
