// Avatars in Moderating Team List - Hack by: Hal10000
//
// This hack will show the Avatar of an Admin/Moderator in the Moderating Team List
// and sort this lists by the name.
//
// Supplied and supported by Hal10000 (hack@hal10000.de)


=======================================================================//
Step 1 - Download and Backup > Skin/s1/skin_stats.php                             
                             > sources/misc/stats.php
                             > sources/functions.php
=======================================================================//

---------------------------------------------------------------------
Open Skin/s*/skin_stats.php AND FIND THE FOLLOWING (around line 90)
---------------------------------------------------------------------

	 <td width='30%' align='left'   class='pformstrip' valign='middle'>{$ibforums->lang['leader_name']}</td>

--------------------------------------------------------------------
ADD THE FOLLOWING LINE RIGHT "ABOVE" THAT
--------------------------------------------------------------------

	 <td nowrap='nowrap' class='pformstrip'></td>

---------------------------------------------------------------------
FIND THE FOLLOWING (around line 105)
---------------------------------------------------------------------

	 <td align='left'   class='row1' valign='middle'><a href='{$ibforums->base_url}showuser={$info['id']}'>{$info['name']}</a></td>

--------------------------------------------------------------------
ADD THE FOLLOWING LINE RIGHT "ABOVE" THAT
--------------------------------------------------------------------

	 <td align='center' class='row1' valign='middle'>{$info['avatar']}</td>

=======================================================================//
Step 2 : Save And Close Skin/s*/skin_stats.php
=======================================================================//

--------------------------------------------------------------------
Open sources/misc/stats.php AND FIND THE FOLLOWING (around line 208)
--------------------------------------------------------------------

    	$DB->query("SELECT m.id, m.name, m.email, m.hide_email, m.location, m.aim_name, m.icq_number, g.g_access_cp
    			    FROM ibf_members m, ibf_groups g
    			    WHERE g.g_access_cp=1 AND m.mgroup=g.g_id ORDER BY m.name");

--------------------------------------------------------------------
REPLACE WITH THE FOLLOWING LINE
--------------------------------------------------------------------

    	$DB->query("SELECT m.id, m.name, m.email, m.hide_email, m.location, m.avatar, m.avatar_size, m.aim_name, m.icq_number, g.g_access_cp
    			    FROM ibf_members m, ibf_groups g
    			    WHERE g.g_access_cp=1 AND m.mgroup=g.g_id ORDER BY m.name");

--------------------------------------------------------------------
FIND THE FOLLOWING (around line 232)
--------------------------------------------------------------------

				$DB->query("SELECT id, name, email, hide_email, location, aim_name, icq_number from ibf_members WHERE mgroup IN (".implode( ',', $sup_ids ).") and id NOT IN(".implode(',', $admin_ids).") ORDER BY name");

--------------------------------------------------------------------
REPLACE WITH THE FOLLOWING LINE
--------------------------------------------------------------------

    		$DB->query("SELECT id, name, email, hide_email, location, avatar, avatar_size, aim_name, icq_number from ibf_members WHERE mgroup IN (".implode( ',', $sup_ids ).") and id NOT IN(".implode(',', $admin_ids).") ORDER BY name");

--------------------------------------------------------------------
FIND THE FOLLOWING (around line 252)
--------------------------------------------------------------------

    	$DB->query("SELECT m2.id, m2.name, m2.email, m2.hide_email, m2.location, m2.aim_name, m2.icq_number,
    	                   f.id as forum_id, f.read_perms, f.name as forum_name, c.state
    	            FROM ibf_moderators mod
    	              LEFT JOIN ibf_forums f ON(f.id=mod.forum_id)
    	              LEFT JOIN ibf_categories c ON(c.id=f.category AND c.state != 0)
    	              LEFT JOIN ibf_members m2 ON (mod.member_id=m2.id)
    	            ");

--------------------------------------------------------------------
REPLACE WITH THE FOLLOWING LINES
--------------------------------------------------------------------   	            
    	            
    	$DB->query("SELECT m2.id, m2.name, m2.email, m2.hide_email, m2.location, m2.avatar, m2.avatar_size, m2.aim_name, m2.icq_number,
    	                   f.id as forum_id, f.read_perms, f.name as forum_name, c.state
    	            FROM ibf_moderators mod
    	              LEFT JOIN ibf_forums f ON(f.id=mod.forum_id)
    	              LEFT JOIN ibf_categories c ON(c.id=f.category AND c.state != 0)
    	              LEFT JOIN ibf_members m2 ON (mod.member_id=m2.id)
    	            ORDER BY m2.name");

--------------------------------------------------------------------
FIND THE FOLLOWING (around line 280)
--------------------------------------------------------------------

    	$DB->query("SELECT m.id, m.name, m.email, m.hide_email, m.location, m.aim_name, m.icq_number,
    	                   f.id as forum_id, f.read_perms, f.name as forum_name, c.state
    	            FROM ibf_moderators mod
    	              LEFT JOIN ibf_forums f ON(f.id=mod.forum_id)
    	              LEFT JOIN ibf_categories c ON(c.id=f.category AND c.state != 0)
    	              LEFT JOIN ibf_members m ON ((mod.is_group=1 and mod.group_id=m.mgroup))
    	            ");
    	            
--------------------------------------------------------------------
REPLACE WITH THE FOLLOWING LINES
--------------------------------------------------------------------

    	$DB->query("SELECT m.id, m.name, m.email, m.hide_email, m.location, m.avatar, m.avatar_size, m.aim_name, m.icq_number,
    	                   f.id as forum_id, f.read_perms, f.name as forum_name, c.state
    	            FROM ibf_moderators mod
    	              LEFT JOIN ibf_forums f ON(f.id=mod.forum_id)
    	              LEFT JOIN ibf_categories c ON(c.id=f.category AND c.state != 0)
    	              LEFT JOIN ibf_members m ON ((mod.is_group=1 and mod.group_id=m.mgroup))
    	            ORDER BY m.name");

--------------------------------------------------------------------
FIND THE FOLLOWING (around line 286)
--------------------------------------------------------------------

	'location'   => $i['location'],

--------------------------------------------------------------------
ADD THE FOLLOWING LINE RIGHT "BELOW" THAT
--------------------------------------------------------------------
	
	'avatar'     => $i['avatar'],
	'avatar_size' => $i['avatar_size'],    	              

--------------------------------------------------------------------
FIND THE FOLLOWING (around line 453)
--------------------------------------------------------------------

		$member['msg_icon'] = "<a href='{$this->base_url}&act=Msg&CODE=04&MID={$member['id']}'><{P_MSG}></a>";
		
--------------------------------------------------------------------
ADD THE FOLLOWING LINE RIGHT "ABOVE" THAT
--------------------------------------------------------------------

		$member['avatar'] = $std->get_avatar( $member['avatar'] , 2, $member['avatar_size'] );
		
--------------------------------------------------------------------
OR IF YOU WANT THE PICTURE TO BE IN ORGINAL SIZE YOU HAVE TO ADD (you can also skip Step 4)
--------------------------------------------------------------------
		
		$member['avatar'] = $std->get_avatar( $member['avatar'] , 1, $member['avatar_size'] );

=======================================================================//
Step 3 - Save and Close sources/misc/stats.php
=======================================================================//

--------------------------------------------------------------------
Open sources/functions.php AND FIND THE FOLLOWING (around line 1558)
--------------------------------------------------------------------

			if ( (preg_match ( "/\.swf/", $member_avatar)) and ($ibforums->vars['allow_flash'] != 1) )
			{
				return "";
			}
		
--------------------------------------------------------------------
ADD THE FOLLOWING LINES RIGHT "BELOW" THAT
--------------------------------------------------------------------

			if ($member_view_avatars == 2)
    	{
    		if ( preg_match( "/^http:\/\//", $member_avatar ) )
				{
			// Ok, it's a URL..
			
					if (preg_match ( "/\.swf/", $member_avatar))
					{
						return "<object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" width='32'>
							<param name='movie' value='{$member_avatar}'><param name='play' value='true'>
							<param name='loop' value='true'><param name='quality' value='high'>
							<embed src='{$member_avatar}' width='32' play='true' loop='true' quality='high'></embed>
							</object>";
					}
					else
					{
						return "<img src='{$member_avatar}' border='0' width='32' alt='' />";
					}
			
			//---------------------------------------
			// Not a URL? Is it an uploaded avatar?
			//---------------------------------------
					}
						else if ( ($ibforums->vars['avup_size_max'] > 1) and ( preg_match( "/^upload:av-(?:\d+)\.(?:\S+)/", $member_avatar ) ) )
					{
					$member_avatar = preg_replace( "/^upload:/", "", $member_avatar );
			
					if ( preg_match ( "/\.swf/", $member_avatar) )
					{
						return "<object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" width='32'>
							<param name='movie' value='{$ibforums->vars['upload_url']}/$member_avatar'><param name='play' value='true'>
							<param name='loop' value='true'><param name='quality' value='high'>
							<embed src='{$ibforums->vars['upload_url']}/$member_avatar\' width='32' play='true' loop='true' quality='high'></embed>
							</object>";
					}
					else
					{
						return "<img src='{$ibforums->vars['upload_url']}/$member_avatar' border='0' width='32' alt='' />";
					}
				}
		
		//---------------------------------------
		// No, it's not a URL or an upload, must
		// be a normal avatar then
		//---------------------------------------
		
				else if ($member_avatar != "")
				{
			//---------------------------------------
			// Do we have an avatar still ?
		  //---------------------------------------
		   	
					return "<img src='{$ibforums->vars['AVATARS_URL']}/{$member_avatar}' border='0' width='32' alt='' />";
				}
				else
				{
			//---------------------------------------
			// No, ok - return blank
			//---------------------------------------
			
					return "";
				}
			}

=======================================================================//
Step 4 - Save and Close sources/functions.php
=======================================================================//

--------------------------------------------------------------------
Now Upload all three files that you edited back to their proper locations
--------------------------------------------------------------------

                  > Skin/s1/skin_stats.php                             
                  > sources/misc/stats.php
                  > sources/functions.php

=====================================================================
               Your Finished, use and enjoy :)
=====================================================================