phpBB.de

Code: Alles auswählen

Couldn't obtain user group information.

DEBUG MODE

SQL Error : 1146 Table 'meinedomain_de.PHPBB_GROUPS' doesn't exist

SELECT * FROM PHPBB_GROUPS

Line : 361
File : /is/htdocs/49513/www.meinedomain.de/includes/usercp_avatar.php

Code: Alles auswählen

## Mod Title: Avatar gallery hack
## Mod Version: 1.0.0
## phpBB Version: 2.0.2
## Author: dzidzius - dzidzius@dione.ids.pl (you can find me also at forum www.ForumBest.150.pl, there send all questions)
## Description:
## Avatar from gallery after chosing it by user automatically disappear from gallery. Thanks
## to this hack two users cannot have the same avatar. If user resign from that avatar it will 
## be shown again in gallery.
## Installation Level: easy
## Installation Time: 2
## Files To Edit: 
##
##   includes\usercp_avatar.php 

Code: Alles auswählen

while( list($key) = each($avatar_images) )
	{
		$selected = ( $key == $category ) ? ' selected="selected"' : '';
		if( count($avatar_images[$key]) )
		{
			$s_categories .= '<option value="' . $key . '"' . $selected . '>' . ucfirst($key) . '</option>';
		}
	}
	$s_categories .= '</select>';

Code: Alles auswählen

global $userdata; 

//Usergruppe des Users Finden
$is_in_Group = array(); 
$zz=-1;

//hole Gruppen ID des Users
		$sql = "SELECT * FROM ".USER_GROUP_TABLE." WHERE user_id = ".$userdata['user_id'];
		if(!$result = $db->sql_query($sql))
		{
			message_die(GENERAL_ERROR, "Couldn't obtain user group information.", "", __LINE__, __FILE__, $sql);
		}
		while( $row = $db->sql_fetchrow($result))
		{
			$zz++;
			$is_in_Group[$zz] =$row['group_id'];  //merke GruppenID vom User
		}
		
//wandele GruppenID in Gruppennamen um
		if($zz>-1)
		{
			$sql = "SELECT * FROM ".GROUPS_TABLE; 		
                                                if(!$result = $db->sql_query($sql))
			{
				message_die(GENERAL_ERROR, "Couldn't obtain user group information.", "", __LINE__, __FILE__, $sql);
			}
		
			while( $row = $db->sql_fetchrow($result))
			{
			for ($i=0;$i<($zz+1);$i++)
				{
					if ($is_in_Group[$i]==$row['group_id'])
						{
						$is_in_Group[$i]=strtolower ($row['group_name']);
						}
				}
			}		
		}

//Aufbau der dropdownbox
	while( list($key) = each($avatar_images) )
	{
		$selected = ( $key == $category ) ? ' selected="selected"' : '';
		if( count($avatar_images[$key]) )
		{
			$AvatarOrdner=strtolower ($key);		  //ordnername 
			$AvatarOrdnerT= substr($AvatarOrdner, 2); //ohne die ersten beiden Zeichen
			$test=substr($AvatarOrdner, 0, 2);        //die ersten beiden Zeichen
		
			//Wenn Ordner mit "x_" anfängt gucken ob User zugriff darauf haben soll (=in Gruppe ist)
			if ($test=="x_")
				{
				for ($i=0;$i<($zz+1);$i++)
					{
					if ($is_in_Group[$i]==$AvatarOrdnerT)
							{
							$s_categories .= '<option value="' . $key . '"' . $selected . '>'. ucfirst($AvatarOrdnerT) . '</option>';
							}
					}
				}
			else
				{
				$s_categories .= '<option value="' . $key . '"' . $selected . '>'. ucfirst($key) . '</option>';
				}
		}
	}
	$s_categories .= '</select>';