Leaders & Team Block

[Foxy]

Your Portal Version: 1.0.6
Your phpBB Type: Standard phpBB3
MODs installed: Yes
Your knowledge: Basic Knowledge
Boardlink: http://www.border-forums.com

What have you done before the problem was there?


What have you already tryed to solve the problem?


Description and Message
Hi,

How do I get the Leaders/Team Block to display:

Administrators as Administraors only and not also in the Global Moderators.

Regards, Foxy

[Marc]

Open portal/block/leaders.php
Find:

Code: Select all

	'WHERE'		=> 'u.group_id = g.group_id AND ' . $db->sql_in_set('g.group_name', array('ADMINISTRATORS', 'GLOBAL_MODERATORS')),

Replace with:

Code: Select all

	'WHERE'		=> 'u.group_id = g.group_id AND ' . $db->sql_in_set('g.group_name', array('ADMINISTRATORS')),

[Foxy]

Here is my leaders.php
I don't think it has the code you have given for changes.

Code: Select all

<?php

/**
*
* @package - Board3portal
* @version $Id: leaders.php 523 2009-08-27 21:41:08Z christian_n $
* @copyright (c) kevin / saint ( www.board3.de/ ), (c) Ice, (c) nickvergessen ( www.flying-bits.org/ ), (c) redbull254 ( www.digitalfotografie-foren.de ), (c) Christian_N ( www.phpbb-projekt.de )
* @based on: phpBB3 Portal by Sevdin Filiz, www.phpbb3portal.com
* @license http://opensource.org/licenses/gpl-license.php GNU Public License 
*
*/

if (!defined('IN_PHPBB') || !defined('IN_PORTAL'))
{
   exit;
}

// Display a listing of board admins, moderators
$user->add_lang('groups');

$user_ary = $auth->acl_get_list(false, array('a_', 'm_'), false);

$admin_id_ary = $mod_id_ary = $forum_id_ary = array();
foreach ($user_ary as $forum_id => $forum_ary)
{
	foreach ($forum_ary as $auth_option => $id_ary)
	{
		if (!$forum_id && $auth_option == 'a_')
		{
			$admin_id_ary = array_merge($admin_id_ary, $id_ary);
			continue;
		}
		else
		{
			$mod_id_ary = array_merge($mod_id_ary, $id_ary);
		}

		if ($forum_id)
		{
			foreach ($id_ary as $id)
			{
				$forum_id_ary[$id][] = $forum_id;
			}
		}
	}
}

$admin_id_ary = array_unique($admin_id_ary);
$mod_id_ary = array_unique($mod_id_ary);

// Admin group id...
$sql = 'SELECT group_id
	FROM ' . GROUPS_TABLE . "
	WHERE group_name = 'ADMINISTRATORS'";
$result = $db->sql_query($sql);
$admin_group_id = (int) $db->sql_fetchfield('group_id');
$db->sql_freeresult($result);

$sql = 'SELECT forum_id, forum_name 
	FROM ' . FORUMS_TABLE . '
	WHERE forum_type = ' . FORUM_POST;
$result = $db->sql_query($sql);

$forums = array();
while ($row = $db->sql_fetchrow($result))
{
	$forums[$row['forum_id']] = $row['forum_name'];
}
$db->sql_freeresult($result);

$sql = $db->sql_build_query('SELECT', array(
	'SELECT'	=> 'u.user_id, u.group_id as default_group, u.username, u.user_colour, u.user_allow_pm, g.group_id, g.group_name, g.group_colour, g.group_type, ug.user_id as ug_user_id',
	'FROM'		=> array(
		USERS_TABLE		=> 'u',
		GROUPS_TABLE	=> 'g'
	),
	'LEFT_JOIN'	=> array(
		array(
			'FROM'	=> array(USER_GROUP_TABLE => 'ug'),
			'ON'	=> 'ug.group_id = g.group_id AND ug.user_pending = 0 AND ug.user_id = ' . $user->data['user_id']
		)),
	'WHERE'		=> $db->sql_in_set('u.user_id', array_unique(array_merge($admin_id_ary, $mod_id_ary))) . '
		AND u.group_id = g.group_id',
	'ORDER_BY'	=> 'g.group_name ASC, u.username_clean ASC'
));

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))
{
	$which_row = (in_array($row['user_id'], $admin_id_ary)) ? 'admin' : 'mod';

	// We sort out admins not having the admin group as default
	// The drawback is that only those admins are displayed which are within
	// the special group 'Administrators' and also having it assigned as their default group.
	// - might change
	if ($which_row == 'admin' && $row['default_group'] != $admin_group_id)
	{
		// Remove from admin_id_ary, because the user may be a mod instead
		unset($admin_id_ary[array_search($row['user_id'], $admin_id_ary)]);

		if (!in_array($row['user_id'], $mod_id_ary))
		{
			continue;
		}
		else
		{
			$which_row = 'mod';
		}
	}

	if ($row['group_type'] == GROUP_HIDDEN && !$auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel') && $row['ug_user_id'] != $user->data['user_id'])
	{
		$group_name = $user->lang['GROUP_UNDISCLOSED'];
		$u_group = '';
	}
	else
	{
		$group_name = ($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name'];
		$u_group = append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&g=' . $row['group_id']);
	}

	$template->assign_block_vars($which_row, array(
		'USER_ID'			=> $row['user_id'],
		'GROUP_NAME'		=> $group_name,
		'GROUP_COLOR'		=> $row['group_colour'],

		'U_GROUP'			=> $u_group,

		'USERNAME_FULL'		=> get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
		'USERNAME'			=> get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),
		'USER_COLOR'		=> get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']),
		'U_VIEW_PROFILE'	=> get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']),
	));
}
$db->sql_freeresult($result);


$template->assign_var('S_DISPLAY_LEADERS', true);

?>

[Marc]

Sorry, that was the development file.

Anyhow, find:

Code: Select all

$user_ary = $auth->acl_get_list(false, array('a_', 'm_'), false);

Replace with:

Code: Select all

$user_ary = $auth->acl_get_list(false, array('a_'), false);

[Foxy]

Ok, I have made the changes and uploaded new file to the site. I have refreshed all caches but Admins still showing under Global Mods. Do I need to make any changes to Group settings now?

[Marc]

Oh sorry, I misunderstood you there. Undo the edits. You can do that activating the normal leaders block. I guess you have the extended leaders block enabled.

[Foxy]

Hi Marc,

Ok, I undid the edits, refreshed the caches and tried both Team Block & Extended settings in the Portal. Neither gave the result I am after.

My site has 2 Administrators, 1 Global Moderator and 3 Regular Moderators.

I would like them displayed as:

Administrators
xxxxxx
xxxxxx

Global Moderators
xxxxx

Moderators
xxxxx
xxxxx
xxxxx
With Normal Leader/team block switched on and the Extended off, my Global Moderator is being diplayed in the correct colour for their default group, but not under their default heading of Global Moderator.

If I switch the Extended on, along with the Leader/team block, then the Administrators are displayed as Administrators and as Global Moderators.

This problem started when I noticed that the 2 Administrators could not edit any posts but the Global Mods could. The guys at phpBB.com said that I should make sure that the 2 Administrators were in the Global Moderators Group. I did this and the problem of editing posts was resolved. However, this then created the problem of the Administrators showing in 2 Groups on the Team Block.

I'm sure the solution is simple enough but I'm not sure what more I can try.

I have left my board for you to view with both the Leader and Extended Leader switched on.
http://www.border-forums.com

Regards, Foxy

[Foxy]

Marc,

I have tried every possible setting and configuration and none of them seem to work. The simplest solution would be to just switch this block off. However, that does not solve the problem.

I am all out of ideas!!!