<?php

/*======================================================================*\

|| #################################################################### ||

|| # vBulletin 4.2.2 Alpha 1 - Licence Number VBFSA2W3VC

|| # ---------------------------------------------------------------- # ||

|| # Copyright ©2000-2013 vBulletin Solutions Inc. All Rights Reserved. ||

|| # This file may not be redistributed in whole or significant part. # ||

|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||

|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||

|| #################################################################### ||

\*======================================================================*/

// ####################### SET PHP ENVIRONMENT ###########################

error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################

define('THIS_SCRIPT', 'showgroups');

define('CSRF_PROTECTION', true);

// ################### PRE-CACHE TEMPLATES AND DATA ######################

// get special phrase groups

$phrasegroups = array();

// get special data templates from the datastore

$specialtemplates = array();

// pre-cache templates used by all actions

$globaltemplates = array(

'SHOWGROUPS',

'showgroups_usergroup',

'showgroups_usergroupbit',

'postbit_onlinestatus'

);

// pre-cache templates used by specific actions

$actiontemplates = array();

// ######################### REQUIRE BACK-END ############################

require_once('./global.php');

require_once(DIR . '/includes/functions_bigthree.php');

require_once(DIR . '/includes/functions_user.php');

// #######################################################################

// ######################## START MAIN SCRIPT ############################

// #######################################################################

if (!$vbulletin->options['forumleaders'])

{

print_no_permission();

}

// 2 is the default location field and the one we always use in the template

$show['locationfield'] = $db->query_first("

SELECT profilefieldid

FROM " . TABLE_PREFIX . "profilefield

WHERE profilefieldid = 2

");

$show['contactinfo'] = (bool)$vbulletin->userinfo['userid'];

function process_showgroups_userinfo($user)

}

if (!($permissions & $vbulletin->bf_ugp_forumpermissions['canview']))

{

print_no_permission();

}

$hook_query_fields = $hook_query_joins = $hook_query_where = '';

($hook = vBulletinHook::fetch_hook('showgroups_start')) ? eval($hook) : false;

// get usergroups who should be displayed on showgroups

// Scans too many rows. Usergroup Rows * User Rows

// VBIV-6689 Caching.

$groupcache = array();

if ($vbulletin->options['flcache'])

{

$groupcache = vB_Cache::instance()->read('showgroups.groupcache');

}

if (empty($groupcache))

{

$users = $db->query_read_slave("

SELECT user.*,

usergroup.title,

user.options, usertextfield.buddylist,

" . ($show['locationfield'] ? 'userfield.field2,' : '') . "

IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid

" . ($vbulletin->options['avatarenabled'] ? ",avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,

customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb,

filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom" : "") . "

$hook_query_fields

FROM " . TABLE_PREFIX . "user AS user

LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids))

LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=user.userid)

" . ($vbulletin->options['avatarenabled'] ? "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid)

LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)" : "") . "

$hook_query_joins

WHERE (usergroup.genericoptions & " . $vbulletin->bf_ugp_genericoptions['showgroup'] . ")

$hook_query_where

");

while ($user = $db->fetch_array($users))

{

$t = strtoupper($user['title']);

$u = strtoupper($user['username']);

$groupcache["$t"]["$u"] = $user;

}

if ($vbulletin->options['flcache'])

{

vB_Cache::instance()->write('showgroups.groupcache', $groupcache, $vbulletin->options['flcache']);

}

}

$usergroups = '';

if (sizeof($groupcache) >= 1)

{

ksort($groupcache); // alphabetically sort usergroups

foreach ($groupcache AS $users)

{

ksort($users); // alphabetically sort users

$usergroupbits = '';

foreach ($users AS $user)

{

exec_switch_bg();

$user = process_showgroups_userinfo($user);

if ($vbulletin->options['enablepms'] AND $vbulletin->userinfo['permissions']['pmquota'] AND ($vbulletin->userinfo['permissions']['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel']

OR ($user['receivepm'] AND $user['permissions']['pmquota']

AND (!$user['receivepmbuddies'] OR can_moderate() OR strpos(" $user[buddylist] ", ' ' . $vbulletin->userinfo['userid'] . ' ') !== false))

))

{

$show['pmlink'] = true;

}

else

{

$show['pmlink'] = false;

}

if ($user['showemail'] AND $vbulletin->options['displayemails'] AND (!$vbulletin->options['secureemail'] OR ($vbulletin->options['secureemail'] AND $vbulletin->options['enableemail'])) AND $vbulletin->userinfo['permissions']['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canemailmember'] AND $vbulletin->userinfo['userid'])

{

$show['emaillink'] = true;

}

else

{

$show['emaillink'] = false;

}

($hook = vBulletinHook::fetch_hook('showgroups_user')) ? eval($hook) : false;

$templater = vB_Template::create('showgroups_usergroupbit');

$templater->register('bgclass', $bgclass);

$templater->register('showforums', $showforums);

$templater->register('user', $user);

$templater->register('xhtml_id', ++$xhtmlid2);

$usergroupbits .= $templater->render();

}

($hook = vBulletinHook::fetch_hook('showgroups_usergroup')) ? eval($hook) : false;

$templater = vB_Template::create('showgroups_usergroup');

$templater->register('user', $user);

$templater->register('usergroupbits', $usergroupbits);

$templater->register('xhtml_id', ++$xhtmlid);

$usergroups .= $templater->render();

}

}

unset($groupcache);

$hook_query_fields = $hook_query_joins = $hook_query_where = '';

($hook = vBulletinHook::fetch_hook('showgroups_forumleaders')) ? eval($hook) : false;

if ($vbulletin->options['forumleaders'] == 1)

{

// get moderators **********************************************************

$moderators = $db->query_read_slave("

SELECT user.*,

moderator.forumid,

usertextfield.buddylist,

" . ($show['locationfield'] ? 'userfield.field2,' : '') . "

IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid

" . ($vbulletin->options['avatarenabled'] ? ",avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom" : "") . "

$hook_query_fields

FROM " . TABLE_PREFIX . "moderator AS moderator

INNER JOIN " . TABLE_PREFIX . "user AS user USING(userid)

INNER JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)

INNER JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=user.userid)

" . ($vbulletin->options['avatarenabled'] ? "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)" : "") . "

$hook_query_joins

WHERE moderator.forumid <> -1

$hook_query_where

");

$modcache = array();

while ($moderator = $db->fetch_array($moderators))

{

if (!isset($modcache["$moderator[username]"]))

{

$modcache["$moderator[username]"] = $moderator;

}

$modcache["$moderator[username]"]['forums'][] = $moderator['forumid'];

}

unset($moderator);

$db->free_result($moderators);

if (is_array($modcache))

{

$showforums = true;

uksort($modcache, 'strnatcasecmp'); // alphabetically sort moderator usernames

foreach ($modcache AS $moderator)

{

$premodforums = array();

foreach ($moderator['forums'] AS $forumid)

{

if ($vbulletin->forumcache["$forumid"]['options'] & $vbulletin->bf_misc_forumoptions['active'] AND (($vbulletin->forumcache["$forumid"]['showprivate'] > 1 OR (!$vbulletin->forumcache["$forumid"]['showprivate'] AND $vbulletin->options['showprivateforums'])) OR ($vbulletin->userinfo['forumpermissions']["$forumid"] & $vbulletin->bf_ugp_forumpermissions['canview'])))

{

$forumtitle = $vbulletin->forumcache["$forumid"]['title'];

$premodforums["$forumid"] = $forumtitle;

}

}

if (empty($premodforums))

{

continue;

}

$clc = 0;

$modforums = array();

uasort($premodforums, 'strnatcasecmp'); // alphabetically sort moderator usernames

foreach($premodforums AS $forumid => $forumtitle)

{

$foruminfo = array(

'forumid' => $forumid,

'title' => $forumtitle,

);

($hook = vBulletinHook::fetch_hook('showgroups_forum')) ? eval($hook) : false;

$clc++;

$foruminfo['comma'] = $vbphrase['comma_space'];

$modforums[$clc] = $foruminfo;

}

// Last element

if ($clc)

{

$modforums[$clc]['comma'] = '';

}

$moderator = process_showgroups_userinfo($moderator);

if ($vbulletin->options['enablepms'] AND $vbulletin->userinfo['permissions']['pmquota'] AND ($vbulletin->userinfo['permissions']['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel']

OR ($moderator['receivepm'] AND $moderator['permissions']['pmquota']

AND (!$moderator['receivepmbuddies'] OR can_moderate() OR strpos(" $moderator[buddylist] ", ' ' . $vbulletin->userinfo['userid'] . ' ') !== false))

))

{

$show['pmlink'] = true;

}

else

{

$show['pmlink'] = false;

}

if ($moderator['showemail'] AND $vbulletin->options['displayemails'] AND (!$vbulletin->options['secureemail'] OR ($vbulletin->options['secureemail'] AND $vbulletin->options['enableemail'])) AND $vbulletin->userinfo['permissions']['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canemailmember'] AND $vbulletin->userinfo['userid'])

{

$show['emaillink'] = true;

}

else

{

$show['emaillink'] = false;

}

($hook = vBulletinHook::fetch_hook('showgroups_usergroup')) ? eval($hook) : false;

$templater = vB_Template::create('showgroups_usergroupbit');

$templater->register('modforums', $modforums);

$templater->register('showforums', $showforums);

$templater->register('user', $moderator); // Needs to be 'user' because we are using the same template as above.

$templater->register('xhtml_id', ++$xhtmlid2);

$moderatorbits .= $templater->render();

}

}

}

// *******************************************************

$navpopup = array(

'id' => 'showgroups_navpopup',

'title' => $vbphrase['show_groups'],

'link' => 'showgroups.php' . $vbulletin->session->vars['sessionurl_q'],

);

construct_quick_nav($navpopup);

$navbits = construct_navbits(array('' => $vbphrase['show_groups']));

$navbar = render_navbar_template($navbits);

($hook = vBulletinHook::fetch_hook('showgroups_complete')) ? eval($hook) : false;

$templater = vB_Template::create('SHOWGROUPS');

$templater->register_page_templates();

$templater->register('forumjump', $forumjump);

$templater->register('moderatorbits', $moderatorbits);

$templater->register('navbar', $navbar);

$templater->register('usergroups', $usergroups);

print_output($templater->render());

/*======================================================================*\

|| ####################################################################

|| # Downloaded: 03:13, Sat Sep 7th 2013

|| # CVS: $RCSfile$ - $Revision: 62098 $

|| ####################################################################

\*======================================================================*/

?>