|
Proszę mniej więcej strukturę nie wiem czy na 100% będzie chodzić, oto kod:
<?php
$gr1 = "17";
$gr2 = "18";
$gr3 = "19";
opentable("Lista osób w klanie");
// grupa pierwsza
$result = dbquery("SELECT group_id, group_name FROM ".DB_USER_GROUPS." WHERE group_id='".$gr1."'");
if (dbrows($result)) {
$data = dbarray($result);
$result = dbquery("SELECT user_id, user_name, user_level, user_status FROM ".DB_USERS." WHERE user_groups='.".$gr1."' ORDER BY user_level DESC, user_name");
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
echo "<td align='left' colspan='2' class='tbl1'><strong>".$data['group_name'].":</strong></td>\n";
echo "</tr>\n<tr>\n";
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
echo "<tr>\n<td class='$cell_color'>\n".profile_link($data['user_id'], $data['user_name'], $data['user_status'])."</td>\n";
echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>\n</tr>";
}
echo "</table><br><br>\n";
} else {
echo "Brak użytkowników w grupie<br><br>";
}
// grupa druga
$result = dbquery("SELECT group_id, group_name FROM ".DB_USER_GROUPS." WHERE group_id='".$gr2."'");
if (dbrows($result)) {
$data = dbarray($result);
$result = dbquery("SELECT user_id, user_name, user_level, user_status FROM ".DB_USERS." WHERE user_groups='.".$gr2."' ORDER BY user_level DESC, user_name");
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
echo "<td align='left' colspan='2' class='tbl1'><strong>".$data['group_name'].":</strong></td>\n";
echo "</tr>\n<tr>\n";
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
echo "<tr>\n<td class='$cell_color'>\n".profile_link($data['user_id'], $data['user_name'], $data['user_status'])."</td>\n";
echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>\n</tr>";
}
echo "</table><br><br>\n";
} else {
echo "Brak użytkowników w grupie<br><br>";
}
// grupa trzecia
$result = dbquery("SELECT group_id, group_name FROM ".DB_USER_GROUPS." WHERE group_id='".$gr3."'");
if (dbrows($result)) {
$data = dbarray($result);
$result = dbquery("SELECT user_id, user_name, user_level, user_status FROM ".DB_USERS." WHERE user_groups='.".$gr3."' ORDER BY user_level DESC, user_name");
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
echo "<td align='left' colspan='2' class='tbl1'><strong>".$data['group_name'].":</strong></td>\n";
echo "</tr>\n<tr>\n";
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
echo "<tr>\n<td class='$cell_color'>\n".profile_link($data['user_id'], $data['user_name'], $data['user_status'])."</td>\n";
echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>\n</tr>";
}
echo "</table><br><br>\n";
} else {
echo "Brak użytkowników w grupie<br><br>";
}
closetable();
?>
|