Początkujący
Postów: 113
Pomógł: 2
Ostrzeżeń: 2
 v7.01.04
Data rejestracji: 12.10.2006 11:29
|
U mnie działa. Trzeba sobie tylko pozmieniać numery grup które mają być wyświetlane oraz ewentualny opis tych grup.
Dodatkowo u siebie wykasowałem linijkę z informacją o ilości postów w shoutboxie.
<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2005 Nick Jones
| http://www.php-fusion.co.uk/
| Team - Mod v2 by Daniel (Divine JazOOn) Rynduch
| http://power.portal.4cms.pl
| http://jazoon.themes.of.pl
|
| and Wooya
| http://mfusion.2loud.net.pl
|
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include LOCALE.LOCALESET."members-profile.php";
opentable("Administracja");
echo "<center><br><b>Redaktor glówny</b></center><br>";
if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all";
$orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'");
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby."");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$i = 0;
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." WHERE user_groups = .6 ORDER BY `fusion_users`.`user_groups` ASC LIMIT 0 , 30");
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
echo "<tr>\n<td width='50%' align='center' class='tbl2'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>";
echo "<td align='center' rowspan='5' class='tbl2'>\n";
echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n";
echo "<td align='center' width='50%' class='tbl2' style='white-space:nowrap'>Doł±czył: ".showdate("longdate", $data['user_joined'])."</td>\n</tr>
<tr>
<td align='center' class='tbl1'>Lokalizacja: ".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td>
<td align='center' class='tbl1'><!--Postów w Shoutbox: <b>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</b>--></td>
</tr>
<tr>
<td align='center' class='tbl2'>Data urodzenia: ";
if ($data['user_birthdate'] != "0000-00-00") {
$months = explode("|", $locale['months']);
$user_birthdate = explode("-", $data['user_birthdate']);
echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0'];
} else {
echo $locale['u048'];
}
echo "</td>
<td align='center' class='tbl2'>Komentarzy: <b>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</b></td>
</tr>
<tr>
<td align='center' class='tbl1'>Ostatnia wizyta: ".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
<td align='center' class='tbl1'>Postów na forum: <b>".number_format(dbcount("(post_id)", "posts", "post_author='".$data['user_id']."'"))."</b></td>
</tr></table>";
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>";
if (iMEMBER) {
echo "<tr><td align='center' class='tbl2'>\n";
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> | \n";
}
if ($data['user_web']) {
$urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
echo "<a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$data['user_web']."</a> | ";
}
if (!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id']) {
echo "| <a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>Prywatna Wiadomo¶ć</a> |";
}
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
echo "</td>\n</tr>";
}else{ // End IF
echo "<tr><td align='center' class='tbl2'>\n";
echo "<center>Kontakt: dostępny w profilu</center></td></tr>\n";
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
}
echo "</table>\n";
} // End while
} else {
echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n";
} // End If
echo "<center><br><b>Redaktorzy</b></center><br>";
if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all";
$orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'");
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby."");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$i = 0;
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." WHERE user_groups = .8 ORDER BY `fusion_users`.`user_groups` ASC LIMIT 0 , 30");
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
echo "<tr>\n<td width='50%' align='center' class='tbl2'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>";
echo "<td align='center' rowspan='5' class='tbl2'>\n";
echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n";
echo "<td align='center' width='50%' class='tbl2' style='white-space:nowrap'>Doł±czył: ".showdate("longdate", $data['user_joined'])."</td>\n</tr>
<tr>
<td align='center' class='tbl1'>Lokalizacja: ".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td>
<td align='center' class='tbl1'><!--Postów w Shoutbox: <b>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</b>--></td>
</tr>
<tr>
<td align='center' class='tbl2'>Data urodzenia: ";
if ($data['user_birthdate'] != "0000-00-00") {
$months = explode("|", $locale['months']);
$user_birthdate = explode("-", $data['user_birthdate']);
echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0'];
} else {
echo $locale['u048'];
}
echo "</td>
<td align='center' class='tbl2'>Komentarzy: <b>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</b></td>
</tr>
<tr>
<td align='center' class='tbl1'>Ostatnia wizyta: ".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
<td align='center' class='tbl1'>Postów na forum: <b>".number_format(dbcount("(post_id)", "posts", "post_author='".$data['user_id']."'"))."</b></td>
</tr></table>";
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>";
if (iMEMBER) {
echo "<tr><td align='center' class='tbl2'>\n";
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> | \n";
}
if ($data['user_web']) {
$urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
echo "<a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$data['user_web']."</a> | ";
}
if (!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id']) {
echo "| <a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>Prywatna Wiadomo¶ć</a> |";
}
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
echo "</td>\n</tr>";
}else{ // End IF
echo "<tr><td align='center' class='tbl2'>\n";
echo "<center>Kontakt: dostępny w profilu</center></td></tr>\n";
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
}
echo "</table>\n";
} // End while
} else {
echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n";
} // End If
/*
echo "<center><br><b>Przyjaciele serwisu: relacje live, fotorelacje itp.</b></center><br>";
if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all";
$orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'");
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby."");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$i = 0;
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." WHERE user_groups = .5 ORDER BY `fusion_users`.`user_groups` ASC LIMIT 0 , 30");
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
echo "<tr>\n<td width='50%' align='center' class='tbl2'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>";
echo "<td align='center' rowspan='5' class='tbl2'>\n";
echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n";
echo "<td align='center' width='50%' class='tbl2' style='white-space:nowrap'>Doł±czył: ".showdate("longdate", $data['user_joined'])."</td>\n</tr>
<tr>
<td align='center' class='tbl1'>Lokalizacja: ".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td>
<td align='center' class='tbl1'>Postów w Shoutbox: <b>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</b></td>
</tr>
<tr>
<td align='center' class='tbl2'>Data urodzenia: ";
if ($data['user_birthdate'] != "0000-00-00") {
$months = explode("|", $locale['months']);
$user_birthdate = explode("-", $data['user_birthdate']);
echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0'];
} else {
echo $locale['u048'];
}
echo "</td>
<td align='center' class='tbl2'>Komentarzy: <b>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</b></td>
</tr>
<tr>
<td align='center' class='tbl1'>Ostatnia wizyta: ".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
<td align='center' class='tbl1'>Postów na forum: <b>".number_format(dbcount("(post_id)", "posts", "post_author='".$data['user_id']."'"))."</b></td>
</tr></table>";
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>";
if (iMEMBER) {
echo "<tr><td align='center' class='tbl2'>\n";
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> | \n";
}
if ($data['user_web']) {
$urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
echo "<a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$data['user_web']."</a> | ";
}
if (!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id']) {
echo "| <a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>Prywatna Wiadomo¶ć</a> |";
}
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
echo "</td>\n</tr>";
}else{ // End IF
echo "<tr><td align='center' class='tbl2'>\n";
echo "<center>Kontakt: Tylko dla użytkowników</center></td></tr>\n";
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
}
echo "</table>\n";
} // End while
} else {
echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n";
} // End If
*/
echo "<center><br><b>Fotoreporter</b></center><br>";
if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all";
$orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'");
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby."");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$i = 0;
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." WHERE user_groups = .14 ORDER BY `fusion_users`.`user_groups` ASC LIMIT 0 , 30");
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
echo "<tr>\n<td width='50%' align='center' class='tbl2'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>";
echo "<td align='center' rowspan='5' class='tbl2'>\n";
echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n";
echo "<td align='center' width='50%' class='tbl2' style='white-space:nowrap'>Doł±czył: ".showdate("longdate", $data['user_joined'])."</td>\n</tr>
<tr>
<td align='center' class='tbl1'>Lokalizacja: ".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td>
<td align='center' class='tbl1'><!--Postów w Shoutbox: <b>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</b>--></td>
</tr>
<tr>
<td align='center' class='tbl2'>Data urodzenia: ";
if ($data['user_birthdate'] != "0000-00-00") {
$months = explode("|", $locale['months']);
$user_birthdate = explode("-", $data['user_birthdate']);
echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0'];
} else {
echo $locale['u048'];
}
echo "</td>
<td align='center' class='tbl2'>Komentarzy: <b>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</b></td>
</tr>
<tr>
<td align='center' class='tbl1'>Ostatnia wizyta: ".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
<td align='center' class='tbl1'>Postów na forum: <b>".number_format(dbcount("(post_id)", "posts", "post_author='".$data['user_id']."'"))."</b></td>
</tr></table>";
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>";
if (iMEMBER) {
echo "<tr><td align='center' class='tbl2'>\n";
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> | \n";
}
if ($data['user_web']) {
$urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
echo "<a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$data['user_web']."</a> | ";
}
if (!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id']) {
echo "| <a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>Prywatna Wiadomo¶ć</a> |";
}
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
echo "</td>\n</tr>";
}else{ // End IF
echo "<tr><td align='center' class='tbl2'>\n";
echo "<center>Kontakt: dostępny w profilu</center></td></tr>\n";
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
}
echo "</table>\n";
} // End while
} else {
echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n";
} // End If
echo "<center><br><b>Wsparcie techniczne</b></center><br>";
if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all";
$orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'");
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby."");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$i = 0;
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." WHERE user_groups = .7 ORDER BY `fusion_users`.`user_groups` ASC LIMIT 0 , 30");
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
echo "<tr>\n<td width='50%' align='center' class='tbl2'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>";
echo "<td align='center' rowspan='5' class='tbl2'>\n";
echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n";
echo "<td align='center' width='50%' class='tbl2' style='white-space:nowrap'>Doł±czył: ".showdate("longdate", $data['user_joined'])."</td>\n</tr>
<tr>
<td align='center' class='tbl1'>Lokalizacja: ".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td>
<td align='center' class='tbl1'><!--Postów w Shoutbox: <b>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</b>--></td>
</tr>
<tr>
<td align='center' class='tbl2'>Data urodzenia: ";
if ($data['user_birthdate'] != "0000-00-00") {
$months = explode("|", $locale['months']);
$user_birthdate = explode("-", $data['user_birthdate']);
echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0'];
} else {
echo $locale['u048'];
}
echo "</td>
<td align='center' class='tbl2'>Komentarzy: <b>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</b></td>
</tr>
<tr>
<td align='center' class='tbl1'>Ostatnia wizyta: ".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
<td align='center' class='tbl1'>Postów na forum: <b>".number_format(dbcount("(post_id)", "posts", "post_author='".$data['user_id']."'"))."</b></td>
</tr></table>";
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>";
if (iMEMBER) {
echo "<tr><td align='center' class='tbl2'>\n";
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> | \n";
}
if ($data['user_web']) {
$urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
echo "<a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$data['user_web']."</a> | ";
}
if (!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id']) {
echo "| <a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>Prywatna Wiadomo¶ć</a> |";
}
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
echo "</td>\n</tr>";
}else{ // End IF
echo "<tr><td align='center' class='tbl2'>\n";
echo "<center>Kontakt: dostępny w profilu</center></td></tr>\n";
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
}
echo "</table>\n";
} // End while
} else {
echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n";
} // End If
echo "<center><br><b>Redaktorzy - stażysci</b></center><br>";
if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all";
$orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'");
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby."");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$i = 0;
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." WHERE user_groups = .15 ORDER BY `fusion_users`.`user_groups` ASC LIMIT 0 , 30");
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
echo "<tr>\n<td width='50%' align='center' class='tbl2'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>";
echo "<td align='center' rowspan='5' class='tbl2'>\n";
echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n";
echo "<td align='center' width='50%' class='tbl2' style='white-space:nowrap'>Doł±czył: ".showdate("longdate", $data['user_joined'])."</td>\n</tr>
<tr>
<td align='center' class='tbl1'>Lokalizacja: ".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td>
<td align='center' class='tbl1'><!--Postów w Shoutbox: <b>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</b>--></td>
</tr>
<tr>
<td align='center' class='tbl2'>Data urodzenia: ";
if ($data['user_birthdate'] != "0000-00-00") {
$months = explode("|", $locale['months']);
$user_birthdate = explode("-", $data['user_birthdate']);
echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0'];
} else {
echo $locale['u048'];
}
echo "</td>
<td align='center' class='tbl2'>Komentarzy: <b>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</b></td>
</tr>
<tr>
<td align='center' class='tbl1'>Ostatnia wizyta: ".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
<td align='center' class='tbl1'>Postów na forum: <b>".number_format(dbcount("(post_id)", "posts", "post_author='".$data['user_id']."'"))."</b></td>
</tr></table>";
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>";
if (iMEMBER) {
echo "<tr><td align='center' class='tbl2'>\n";
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> | \n";
}
if ($data['user_web']) {
$urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
echo "<a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$data['user_web']."</a> | ";
}
if (!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id']) {
echo "| <a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>Prywatna Wiadomo¶ć</a> |";
}
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
echo "</td>\n</tr>";
}else{ // End IF
echo "<tr><td align='center' class='tbl2'>\n";
echo "<center>Kontakt: dostępny w profilu</center></td></tr>\n";
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
}
echo "</table>\n";
} // End while
} else {
echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n";
} // End If
closetable();
require_once "footer.php";
?>
Edytowane przez Pieka dnia 15.11.2007 01:04:30
pozdr
eldzi
|
Przedszkolak
Postów: 10
Data rejestracji: 18.07.2007 22:26
|
@eldzi najprawdopodobniej to jest to czego potrzebowałem jeżeli to:
echo "<center><br><b>Wsparcie techniczne</b></center><br>";
if (!isset($sortby) || !preg_match("/^[A-Z]$/", $sortby)) $sortby = "all";
$orderby = ($sortby == "all" ? "" : " WHERE user_name LIKE '".stripinput($sortby)."%'");
$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby."");
$rows = dbrows($result);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$i = 0;
[b]$result = dbquery("SELECT * FROM ".$db_prefix."users".$orderby." WHERE [color=red]user_groups = .7[/color] ORDER BY `fusion_users`.`user_groups` [color=blue]ASC LIMIT 0 , 30[/color]");[/b]
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
echo "<tr>\n<td width='50%' align='center' class='tbl2'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>";
echo "<td align='center' rowspan='5' class='tbl2'>\n";
echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>\n";
echo "<td align='center' width='50%' class='tbl2' style='white-space:nowrap'>Doł±czył: ".showdate("longdate", $data['user_joined'])."</td>\n</tr>
<tr>
<td align='center' class='tbl1'>Lokalizacja: ".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td>
<td align='center' class='tbl1'><!--Postów w Shoutbox: <b>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</b>--></td>
</tr>
<tr>
<td align='center' class='tbl2'>Data urodzenia: ";
if ($data['user_birthdate'] != "0000-00-00") {
$months = explode("|", $locale['months']);
$user_birthdate = explode("-", $data['user_birthdate']);
echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0'];
} else {
echo $locale['u048'];
}
echo "</td>
<td align='center' class='tbl2'>Komentarzy: <b>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</b></td>
</tr>
<tr>
<td align='center' class='tbl1'>Ostatnia wizyta: ".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
<td align='center' class='tbl1'>Postów na forum: <b>".number_format(dbcount("(post_id)", "posts", "post_author='".$data['user_id']."'"))."</b></td>
</tr></table>";
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>";
if (iMEMBER) {
echo "<tr><td align='center' class='tbl2'>\n";
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> | \n";
}
if ($data['user_web']) {
$urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
echo "<a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$data['user_web']."</a> | ";
}
if (!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id']) {
echo "| <a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>Prywatna Wiadomoć</a> |";
}
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
echo "</td>\n</tr>";
}else{ // End IF
echo "<tr><td align='center' class='tbl2'>\n";
echo "<center>Kontakt: dostępny w profilu</center></td></tr>\n";
echo"<tr><td align='center' class='tbl1'><br></td></tr>";
}
echo "</table>\n";
} // End while
} else {
echo "<center><br>\n".$locale['403']."$sortby<br><br>\n</center>\n";
} // End If
odpowiada za wyświetlenie na liście użytkowników dowolnej grupy.
Niestety jest małe ale :)
Jak się domyślam za wybór grupy której użytkownicy mają być "wyświetleni" odpowiada to co jest wyboldowane. To co jest czerwone to nr tej wybranej grupy?? Jeżeli tak to jak znaleść ją na phpMyAdminie? Gdzie tego szukać bo przypuszczam że tam trzeba "grzebać". Mam tabele (tak to chyba się zwie) fushion_user_grup (w phpMyAdmin) i tam mam group_id czy to (zaznaczone na czerwono) ten numer (poprzedzony kropką).
I co to jest to zaznaczone na niebiesko :) Czy to ma jakieś znaczenie??
Wydaje mi się że nie ale jako noob z php i sql-a itp to wole zapytać niż potem odzyskiwać cała bazę. A może w w/w kodzie są jeszcze jakieś "zmienne" "dane" które są uzależnione od osoby stosującej ten kod??
Edytowane przez Pieka dnia 15.11.2007 01:05:41
|
jezeli wpisze numer grupy radaktora glownego to aktualnie na pozycji 3 pojawia sie prawidlowo a niestety zadna inna grupa w tamtym nie chodzi. Wie ktos moze o co tu chodzi ?
