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 ?
