Za mało znam jeszcze php, mam do was prośbę pomóżcie proszę przerobić tego scrypta zęby pokazywał użytkowników danej grupy za pomocą user_group a nie za pomocą user_level.
.
<?php require_once "maincore.php"; require_once THEMES."templates/header.php"; function MakeTeamTable($tablename, $where="", $group="") { if(!$group) $result = dbquery("SELECT * FROM ".DB_USERS." WHERE ".$where." ORDER BY user_name ASC"); else $result = dbquery("SELECT * FROM ".DB_USERS." WHERE user_groups REGEXP('^\\\.{$group}$|\\\.{$group}\\\.|\\\.{$group}$') ".($where ? $where : "")." ORDER BY user_name ASC"); if (dbrows($result)) { $i = 0; while ($data = dbarray($result)) { $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++; echo "<tr>\n<td width='50%' align='center' class='tbl2'><a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>\n"; echo ($data['user_avatar'] ? "<div id='imgb'><img src='".IMAGES."avatars/".$data['user_avatar']."' alt=''>" : "<img src='".IMAGES."avatars/noavatar.png' />")."</div></td>\n"; //echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt=''>" : "Brak avatara")."</td>\n"; echo "<td align='center' width='50%' class='tbl2' style='white-space:nowrap'>Dołączył: ".showdate("longdate", $data['user_joined'])."</td>\n"; echo "<td align='center' class='tbl1'>Lokalizacja: ".($data['user_location'] ? $data['user_location'] : "")."</td>\n"; echo "<td align='center' class='tbl1'>Postów w Shoutbox: <b>".number_format(dbcount("(shout_id)", DB_SHOUTBOX, "shout_name='".$data['user_id']."'"))."</b></td>\n"; if ($data['user_birthdate'] != "0000-00-00") { echo number_format($user_birthdate['2'])." ".$months[number_format($user_birthdate['1'])]." ".$user_birthdate['0']; } else { } echo "<td align='center' class='tbl2'>Komentarzy: <b>".number_format(dbcount("(comment_id)", DB_COMMENTS, "comment_name='".$data['user_id']."'"))."</b></td>\n"; echo "<td align='center' class='tbl1'>Ostatnia wizyta: ".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : "")."</td>\n"; echo "<td align='center' class='tbl1'>Postów na forum: <b>".number_format($data['user_posts'])."</b></td>\n"; if (iMEMBER) { if ($data['user_hide_email'] != "1" || iADMIN) echo "| <a href='mailto:".str_replace("@","@",$data['user_email'])."' title='".str_replace("@","@",$data['user_email'])."'>".$data['user_email']."</a> "; if ($data['user_web']) { echo "| <a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$data['user_web']."</a> "; } if (iMEMBER && $data['user_id'] != $userdata['user_id']) }else{ } } } }//end MakeTeamTable() //tworzenie listy moderatorow $result = dbquery("SELECT forum_moderators from ".DB_FORUMS.""); if (dbrows($result) > 0){ while ($data = dbarray($result)){ if ($data['forum_moderators'] != ""){ for ($i=0;$i<count($modd);$i++) if($modd[$i]!="") } else } } } $quer .= (!$quer ? "" : " OR ")."user_groups REGEXP('^\\\.{$groupid}$|\\\.{$groupid}\\\.|\\\.{$groupid}$')"; opentable("Administracja"); MakeTeamTable('Super Administratorzy', "user_level = 103"); MakeTeamTable('Administratorzy', "user_level = 102"); if($quer != "") MakeTeamTable('Moderatorzy', "(".$quer.") AND user_level = 101"); closetable(); require_once THEMES."templates/footer.php"; ?>
Proszę o pomoc.