Witam.
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.

  1. <?php
  2.  
  3. require_once "maincore.php";
  4. require_once THEMES."templates/header.php";
  5.  
  6. function MakeTeamTable($tablename, $where="", $group="")
  7. {
  8. global $locale, $userdata;
  9.  
  10. if(!$group)
  11. $result = dbquery("SELECT * FROM ".DB_USERS." WHERE ".$where." ORDER BY user_name ASC");
  12. else
  13. $result = dbquery("SELECT * FROM ".DB_USERS." WHERE user_groups REGEXP('^\\\.{$group}$|\\\.{$group}\\\.|\\\.{$group}$') ".($where ? $where : "")." ORDER BY user_name ASC");
  14.  
  15. if (dbrows($result)) {
  16. $i = 0;
  17. echo "\n<!-- ".$tablename." -->\n";
  18. echo "<center><b>".$tablename."</b></center>\n<br>\n";
  19. while ($data = dbarray($result)) {
  20. $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
  21. echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
  22. echo "<tr>\n<td width='50%' align='center' class='tbl2'><a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>\n";
  23. echo "<td align='center' rowspan='5' class='tbl2'>";
  24. echo ($data['user_avatar'] ? "<div id='imgb'><img src='".IMAGES."avatars/".$data['user_avatar']."' alt=''>" : "<img src='".IMAGES."avatars/noavatar.png' />")."</div></td>\n";
  25. //echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt=''>" : "Brak avatara")."</td>\n";
  26. echo "<td align='center' width='50%' class='tbl2' style='white-space:nowrap'>Dołączył: ".showdate("longdate", $data['user_joined'])."</td>\n";
  27. echo "</tr>\n<tr>\n";
  28. echo "<td align='center' class='tbl1'>Lokalizacja: ".($data['user_location'] ? $data['user_location'] : "")."</td>\n";
  29. 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";
  30. echo "</tr>\n<tr>\n";
  31. echo "<td align='center' class='tbl2'>Data urodzenia: ";
  32. if ($data['user_birthdate'] != "0000-00-00") {
  33. $months = explode("|", $locale['months']);
  34. $user_birthdate = explode("-", $data['user_birthdate']);
  35. echo number_format($user_birthdate['2'])." ".$months[number_format($user_birthdate['1'])]." ".$user_birthdate['0'];
  36. } else {
  37.  
  38. }
  39. echo "</td>\n";
  40. echo "<td align='center' class='tbl2'>Komentarzy: <b>".number_format(dbcount("(comment_id)", DB_COMMENTS, "comment_name='".$data['user_id']."'"))."</b></td>\n";
  41. echo "</tr>\n<tr>\n";
  42. echo "<td align='center' class='tbl1'>Ostatnia wizyta: ".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : "")."</td>\n";
  43. echo "<td align='center' class='tbl1'>Postów na forum: <b>".number_format($data['user_posts'])."</b></td>\n";
  44. echo "</tr>\n</table>\n";
  45. echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
  46. if (iMEMBER) {
  47. echo "<tr>\n<td align='center' class='tbl2'>";
  48. if ($data['user_hide_email'] != "1" || iADMIN)
  49. echo "| <a href='mailto:".str_replace("@","@",$data['user_email'])."' title='".str_replace("@","@",$data['user_email'])."'>".$data['user_email']."</a> ";
  50.  
  51. if ($data['user_web']) {
  52. $urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
  53. echo "| <a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$data['user_web']."</a> ";
  54. }
  55. if (iMEMBER && $data['user_id'] != $userdata['user_id'])
  56. echo "| <a href='messages.php?msg_send=".$data['user_id']."' >Prywatna Wiadomość</a> ";
  57.  
  58. echo "|<br>\n";
  59. echo (isset($data['user_aim']) && $data['user_aim']) ? "<a href='gg:".$data['user_aim']."'><img src='http://gadu-gadu.pl/users/status.asp?id=".$data['user_aim']."&amp;styl=0' alt='GG' style='vertical-align:middle;border:0;'></a> " : "";
  60. echo (isset($data['user_msn']) && $data['user_msn']) ? "<a href='tlen://chat|".$data['user_msn']."|/'><img src='http://status.tlen.pl/?u=".$data['user_msn']."&amp;t=1' alt='Tlen' style='vertical-align:middle;border:0;'></a> " : "";
  61. echo (isset($data['user_icq']) && $data['user_icq']) ? "<a target='_blank' href='http://web.icq.com/wwp?Uin=".$data['user_icq']."'><img border='0' src='http://web.icq.com/whitepages/online?icq=".$data['user_icq']."&amp;img=5' alt='ICQ' style='vertical-align:middle;border:0;'></a> " : "";
  62. echo (isset($data['user_yahoo']) && $data['user_yahoo']) ? "<a href='callto://".$data['user_yahoo']."/'><img src='http://mystatus.skype.com/smallicon/".$data['user_yahoo']."' alt='Skype' style='vertical-align:middle;border:0;'></a> " : "";
  63. echo (isset($data['user_gizmo']) && $data['user_gizmo']) ? "<a href='sip://call?id=".$data['user_gizmo']."'><img src='".IMAGES."gizmo_18x18.gif' alt='Gizmo' style='vertical-align:middle;border:0;'></a> " : "";
  64. echo "</td>\n</tr>\n";
  65. }else{
  66. echo "<tr><td align='center' class='tbl2'>";
  67. echo "<center>Kontakt: Tylko dla użytkowników</center></td></tr>\n";
  68. }
  69. echo "</table>\n<br>\n";
  70. }
  71. }
  72. }//end MakeTeamTable()
  73.  
  74. //tworzenie listy moderatorow
  75. $moderators = array(); $quer = "";
  76. $result = dbquery("SELECT forum_moderators from ".DB_FORUMS."");
  77. if (dbrows($result) > 0){
  78. while ($data = dbarray($result)){
  79. if ($data['forum_moderators'] != ""){
  80. if (strpos($data['forum_moderators'], ".") !== FALSE){
  81. $modd = explode(".", $data['forum_moderators']);
  82. for ($i=0;$i<count($modd);$i++)
  83. if($modd[$i]!="")
  84. $moderators[] = trim($modd[$i]);
  85. } else
  86. $moderators[] = trim($data['forum_moderators']);
  87. }
  88. }
  89. }
  90. foreach (array_unique($moderators) as $groupid)
  91. $quer .= (!$quer ? "" : " OR ")."user_groups REGEXP('^\\\.{$groupid}$|\\\.{$groupid}\\\.|\\\.{$groupid}$')";
  92.  
  93. opentable("Administracja");
  94. MakeTeamTable('Super Administratorzy', "user_level = 103");
  95. MakeTeamTable('Administratorzy', "user_level = 102");
  96. if($quer != "") MakeTeamTable('Moderatorzy', "(".$quer.") AND user_level = 101");
  97. closetable();
  98.  
  99. require_once THEMES."templates/footer.php";
  100. ?>
.

Proszę o pomoc.