phpBB.de

Code: Alles auswählen

$allowed_ugs = array('2','6','7');

$sql = 	"SELECT group_id 
		FROM " . USER_GROUP_TABLE . " 
		WHERE ( group_id = " . $allowed_ugs[0] . " OR group_id = " . $allowed_ugs[1] . " OR group_id = " . $allowed_ugs[2] . " ) AND user_id = " . $postrow[$i]['user_id']; 

if ( !($result = $db->sql_query($sql)) ) 
{ 
	message_die(GENERAL_ERROR, 'Could not get user group.', '', __LINE__, __FILE__, $sql); 
} 

$seimontemp = $db->sql_fetchrow($result);

$seimon_vip = ''; 

if ( $seimontemp['group_id'] == 6)
{ 
		$seimon_vip = '<br /><a href="viewtopic.php?t=5988" target="_blank"><img src="templates/subSilver/images/logo_vip.gif" alt="V.I.P." title="V.I.P." border="0" /></a>';
} 

if ( $seimontemp['group_id'] == 7)
{ 
		$seimon_vip = '<br /><a href="viewtopic.php?t=5988" target="_blank"><img src="templates/subSilver/images/logo_mod.gif" alt="Moderator" title="Moderator" border="0" /></a>';
} 

if ( $seimontemp['group_id'] == 2)
{ 
		$seimon_vip = '<br /><a href="viewtopic.php?t=5988" target="_blank"><img src="templates/subSilver/images/logo_admin.gif" alt="Administrator" title="Administrator" border="0" /></a>';
}

Code: Alles auswählen

		WHERE ( group_id = " . $allowed_ugs[0] . " OR group_id = " . $allowed_ugs[1] . " OR group_id = " . $allowed_ugs[2] . " ) AND user_id = " . $postrow[$i]['user_id']; 

Code: Alles auswählen

      WHERE  inArray(group_id, $allowed_ugs) AND user_id = " . $postrow[$i]['user_id']; 

Code: Alles auswählen

WHERE group_id IN (" . implode(',', $allowed_ugs) . ") AND ...