Verfasst: 08.12.2007 21:33
gibt er das aus was der user eingegeben hat oder nicht? darum geht es mir!!!
phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Code: Alles auswählen
$raid_memberlist = group_memberships(7);
$user_id_ary = $user_data_ary = $group_users = array();
if (sizeof($raid_memberlist)
{
foreach ($raid_memberlist as $row)
{
$user_id_ary[] = $row['user_id'];
}
if (sizeof($user_id_ary))
{
$sql = 'SELECT pf_wowclass
FROM ' . PROFILE_FIELDS_DATA_TABLE . '
WHERE ' . $db->sql_in_set('user_id', $user_id_ary);
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$user_data_ary[$row['user_id']] = $row;
}
$db->sql_freeresult($result);
foreach ($raid_memberlist as $row)
{
if ($row['group_leader'] == 1)
{
$group_users[] = '<a href="http://eu.wowarmory.com/character-sheet.xml?r=Khaz\'goroth&n=' . $user_data_ary[$row['user_id']]['pf_wowchar'] . '"><b>' . $row['username'] . '</b></a>, ';
}
else
{
$group_users[] = '<a href="http://eu.wowarmory.com/character-sheet.xml?r=Khaz\'goroth&n=' . $user_data_ary[$row['user_id']]['pf_wowchar'] . '">' . $row['username'] . '</a>, ';
}
}
$group_users = implode(' ,', $group_users);
unset($user_data_ary, $user_id_ary);
}
}
Code: Alles auswählen
$raid_memberlist = group_memberships(7);
$user_id_ary = $user_data_ary = array();
$group_users = '';
if (sizeof($raid_memberlist))
{
foreach ($raid_memberlist as $row)
{
$user_id_ary[] = $row['user_id'];
}
if (sizeof($user_id_ary))
{
$sql = 'SELECT *
FROM ' . PROFILE_FIELDS_DATA_TABLE;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$user_data_ary[$row['user_id']] = $row;
}
$db->sql_freeresult($result);
foreach ($raid_memberlist as $row)
{
if ($row['group_leader'] == 1)
{
// $user_data_ary[$row['user_id']]['pf_wowclass']
$group_users .= '<a href="http://eu.wowarmory.com/character-sheet.xml?r=Khaz\'goroth&n=' . $user_data_ary[$row['user_id']]['pf_wowchar'] . '" target="_blank"><b>' . $row['username'] . '</b></a>, ';
}
else
{
$group_users .= '<a href="http://eu.wowarmory.com/character-sheet.xml?r=Khaz\'goroth&n=' . $user_data_ary[$row['user_id']]['pf_wowchar'] . '" target="_blank">' . $row['username'] . '</a>, ';
}
}
$group_users = substr($group_users,0,-2);
unset($user_data_ary, $user_id_ary);
}
}