phpBB.de

Code: Alles auswählen

SELECT u.user_id, u.username
FROM phpbb_auth_access aa
INNER JOIN phpbb_user_group ug ON aa.group_id = ug.group_id
INNER JOIN phpbb_users u ON ug.user_id = u.user_id
WHERE aa.auth_mod AND aa.forum_id = x

Code: Alles auswählen

$sql = "SELECT * 
FROM phpbb_auth_access aa, phpbb_forums f
INNER JOIN phpbb_user_group ug ON aa.group_id = ug.group_id 
INNER JOIN phpbb_users u ON ug.user_id = u.user_id 
WHERE aa.auth_mod AND aa.user_id = $user_id";

$result = mysql_query($sql);

$ForumData = array();

while ($row = $db->sql_fetchrow($result)) 
{ 
$ForumData['forum_id'] = $row['forum_id']; 
}

Code: Alles auswählen

<!-- BEGIN forumdata -->
{forumdata.FORUMID}
<!-- END forumdata -->

Code: Alles auswählen

$sql = "SELECT * 
	FROM phpbb_auth_access aa, phpbb_forums f
	INNER JOIN phpbb_user_group ug ON aa.group_id = ug.group_id 
	INNER JOIN phpbb_users u ON ug.user_id = u.user_id 
	WHERE aa.auth_mod AND aa.user_id = $user_id";
mysql_query($sql);

echo $row['forum_id'];

Code: Alles auswählen

	//
	// Check if User is an Admin or a normal Moderator 
	//

	$forumids = array();

	$sql = "SELECT user_level
		FROM phpbb_users
		WHERE user_id = $user_id";
	$result = mysql_query($sql);

	while( $row = $db->sql_fetchrow($result) )
	{
		$userlevel = $row['user_level'];
	}

	$mod_status = '';

	if ( $userlevel == 1 )
	{

		//
		// User is Admin so his MOD Status is true...
		//
		
		$mod_status = "You are ADMIN!";

		$forumids['id'] = "All Forums";

	}
	else if ( $userlevel == 2 )
	{
		//
		// User is a MOD so lets see in which forums this User is a MOD
		//

		$mod_status = "User is Mod...";

		$sql = "SELECT forum_id
			  FROM phpbb_auth_access
			  WHERE group_id = $user_id";
		$result = mysql_query($sql);

		while( $row = $db->sql_fetchrow($result) )
		{
			$forumids['id'] = $row['forum_id'];
		}
	}
	else if ( $userlevel == 0 )
	{
		$mod_status = "YOU aren't a MOD but a User!";	
	}	

Code: Alles auswählen

WHERE group_id = $user_id";