Przedszkolak
Postów: 24
Ostrzeżeń: 4
Data rejestracji: 21.06.2009 12:16
|
Mogliście podać, co w jakiej linijce i po czym dodać, bo ja jestem początkujący, a bardzo chciałbym mieć tą opcję na swojej stronie. Jeśli mogę to podaję swoje panele i prosiłbym o uzupełnienie nich :
update_profile_include.php
<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| 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
+----------------------------------------------------*/
if (!defined("IN_FUSION")) { header("Location: ../index.php"); exit; }
if (!iMEMBER || !isset($_POST['user_hash']) || $_POST['user_hash'] != $userdata['user_password']) fallback("index.php");
$error = ""; $set_avatar = "";
//$username = trim(eregi_replace(" +", " ", $_POST['user_name']));
if ($_POST['user_email'] == "") {
$error .= $locale['480']."<br>\n";
} else {
//if (!preg_match("/^[-0-9A-Z_@\s]+$/i", $username)) $error .= $locale['481']."<br>\n";
/* if ($username != $userdata['user_name']) {
$result = dbquery("SELECT user_name FROM ".$db_prefix."users WHERE user_name='$username'");
if (dbrows($result) != 0) $error = $locale['482']."<br>\n";
}*/
if (!preg_match("/^[-0-9A-Z_\.]{1,50}@([-0-9A-Z_\.]+\.){1,50}([0-9A-Z]){2,4}$/i", $_POST['user_email'])) $error .= $locale['483']."<br>\n";
if ($_POST['user_email'] != $userdata['user_email']) {
$result = dbquery("SELECT user_email FROM ".$db_prefix."users WHERE user_email='".$_POST['user_email']."'");
if (dbrows($result) != 0) $error = $locale['484']."<br>\n";
}
}
if ($_POST['user_newpassword'] != "" && $_POST['user_newpassword2'] != "") {
if ($_POST['user_newpassword2'] != $_POST['user_newpassword']) {
$error .= $locale['485']."<br>";
} else {
if ($_POST['user_hash'] == $userdata['user_password']) {
if (!preg_match("/^[0-9A-Z@]{6,20}$/i", $_POST['user_newpassword'])) {
$error .= $locale['486']."<br>\n";
}
} else {
$error .= $locale['487']."<br>\n";
}
}
}
$user_hide_email = isNum($_POST['user_hide_email']) ? $_POST['user_hide_email'] : "1";
$user_location = isset($_POST['user_location']) ? stripinput(trim($_POST['user_location'])) : "";
if ($_POST['user_month'] != "--" && $_POST['user_day'] != "--" && $_POST['user_year'] != "----") {
$user_birthdate = (isNum($_POST['user_year']) ? $_POST['user_year'] : "0000")
."-".(isNum($_POST['user_month']) ? $_POST['user_month'] : "00")
."-".(isNum($_POST['user_day']) ? $_POST['user_day'] : "00");
} else {
$user_birthdate = "0000-00-00";
}
$user_aim = isset($_POST['user_aim']) ? stripinput(trim($_POST['user_aim'])) : "";
$user_icq = isset($_POST['user_icq']) ? stripinput(trim($_POST['user_icq'])) : "";
$user_msn = isset($_POST['user_msn']) ? stripinput(trim($_POST['user_msn'])) : "";
$user_yahoo = isset($_POST['user_yahoo']) ? stripinput(trim($_POST['user_yahoo'])) : "";
$user_web = isset($_POST['user_web']) ? stripinput(trim($_POST['user_web'])) : "";
$user_theme = stripinput($_POST['user_theme']);
$user_offset = is_numeric($_POST['user_offset']) ? $_POST['user_offset'] : "0";
$user_sig = isset($_POST['user_sig']) ? stripinput(trim($_POST['user_sig'])) : "";
if ($error == "") {
$newavatar = $_FILES['user_avatar'];
if ($userdata['user_avatar'] == "" && !empty($newavatar['name']) && is_uploaded_file($newavatar['tmp_name'])) {
$avatarext = strrchr($newavatar['name'],".");
$avatarname = substr($newavatar['name'], 0, strrpos($newavatar['name'], "."));
if (preg_match("/^[-0-9A-Z_\[\]]+$/i", $avatarname) && preg_match("/(\.gif|\.GIF|\.jpg|\.JPG|\.png|\.PNG)$/", $avatarext) && $newavatar['size'] <= 30720) {
$avatarname = $avatarname."[".$userdata['user_id']."]".$avatarext;
$set_avatar = "user_avatar='$avatarname', ";
move_uploaded_file($newavatar['tmp_name'], IMAGES."avatars/".$avatarname);
chmod(IMAGES."avatars/".$avatarname,0644);
if ($size = @getimagesize(IMAGES."avatars/".$avatarname)) {
if ($size['0'] > 100 || $size['1'] > 100) {
unlink(IMAGES."avatars/".$avatarname);
$set_avatar = "";
} elseif (!verify_image(IMAGES."avatars/".$avatarname)) {
unlink(IMAGES."avatars/".$avatarname);
$set_avatar = "";
}
} else {
unlink(IMAGES."avatars/".$avatarname);
$set_avatar = "";
}
}
}
if (isset($_POST['del_avatar'])) {
$set_avatar = "user_avatar='', ";
unlink(IMAGES."avatars/".$userdata['user_avatar']);
}
if (isset($_POST['user_adds']) && isNum($user_adds)) $user_adds = $_POST['user_adds']; else $user_adds=0;
if ($user_adds!=0)
{
$d = dbarray(dbquery("SELECT group_prefix, group_color from ".$db_prefix."user_groups WHERE group_id='".$user_adds."'"));
$user_prefix = $d['group_prefix'];
$user_color = $d['group_color'];
} else {
$d = dbarray(dbquery("SELECT user_prefix, user_color from ".$db_prefix."colors WHERE user_level='".$userdata['user_level']."'"));
$user_prefix = $d['user_prefix'];
$user_color = $d['user_color'];
}
if ($_POST['user_newpassword'] != "" && $_POST['user_newpassword2'] != "") { $newpass = " user_password=md5('$user_newpassword'), "; } else { $newpass = " "; }
$result = dbquery("UPDATE ".$db_prefix."users SET ".$newpass."user_email='".$_POST['user_email']."', user_hide_email='$user_hide_email', user_location='$user_location', user_birthdate='$user_birthdate', user_aim='$user_aim', user_icq='$user_icq', user_msn='$user_msn', user_yahoo='$user_yahoo', user_web='$user_web', user_theme='$user_theme', user_offset='$user_offset', ".$set_avatar."user_sig='$user_sig', user_color='".$user_color."', user_prefix='".$user_prefix."', user_adds='".$user_adds."' WHERE user_id='".$userdata['user_id']."'");
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id='".$userdata['user_id']."'");
if (dbrows($result) != 0) {
$userdata = dbarray($result);
redirect("edit_profile.php?update_profile=ok");
}
}
?>
edit_profile.php:
<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright ê 2002 - 2005 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| 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";
include LOCALE.LOCALESET."user_fields.php";
if (isset($_POST['update_profile'])) require_once INCLUDES."update_profile_include.php";
opentable($locale['440']);
if (iMEMBER) {
if ($userdata['user_birthdate']!="0000-00-00") {
$user_birthdate = explode("-", $userdata['user_birthdate']);
$user_month = number_format($user_birthdate['1']);
$user_day = number_format($user_birthdate['2']);
$user_year = $user_birthdate['0'];
} else {
$user_month = 0; $user_day = 0; $user_year = 0;
}
$theme_files = makefilelist(THEMES, ".|..", true, "folders");
array_unshift($theme_files, "Default");
$offset_list = "";
for ($i=-13;$i<17;$i++) {
if ($i > 0) { $offset="+".$i; } else { $offset=$i; }
$offset_list .= "<option".($offset == $userdata['user_offset'] ? " selected" : "").">$offset</option>\n";
}
echo "<form name='inputform' method='post' action='".FUSION_SELF."' enctype='multipart/form-data'>\n";
echo "<table align='center' cellpadding='0' cellspacing='0'>\n";
if (isset($update_profile)) {
echo "<tr>\n<td colspan='2' class='tbl'>".$locale['441']."<br><br>\n</td>\n</tr>\n";
}
echo "<tr>
<td class='tbl'>".$locale['u001']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'>".$userdata['user_name']."</td>
</tr>
<tr>
<td class='tbl'>".$locale['u003']."</td>
<td class='tbl'><input type='password' name='user_newpassword' maxlength='20' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u004']."</td>
<td class='tbl'><input type='password' name='user_newpassword2' maxlength='20' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u005']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='user_email' value='".$userdata['user_email']."' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u006']."</td>
<td class='tbl'><input type='radio' name='user_hide_email' value='1'".($userdata['user_hide_email'] == "1" ? " checked" : "").">".$locale['u007']."
<input type='radio' name='user_hide_email' value='0'".($userdata['user_hide_email'] == "0" ? " checked" : "").">".$locale['u008']."</td>
</tr>
<tr>
<td class='tbl'>".$locale['u009']."</td>
<td class='tbl'><input type='text' name='user_location' value='".$userdata['user_location']."' maxlength='50' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u010']." <span class='small2'>(mm/dd/yyyy)</span></td>
<td class='tbl'><select name='user_month' class='textbox'>\n<option>--</option>\n";
for ($i=1;$i<=12;$i++) echo "<option".($user_month == $i ? " selected" : "").">$i</option>\n";
echo "</select>
<select name='user_day' class='textbox'>\n<option>--</option>\n";
for ($i=1;$i<=31;$i++) echo "<option".($user_day == $i ? " selected" : "").">$i</option>\n";
echo "</select>
<select name='user_year' class='textbox'>\n<option>----</option>\n";
for ($i=1900;$i<=2004;$i++) echo "<option".($user_year == $i ? " selected" : "").">$i</option>\n";
echo "</select>
</td>
</tr>
<tr>
<td class='tbl'>".$locale['u021']."</td>
<td class='tbl'><input type='text' name='user_aim' value='".$userdata['user_aim']."' maxlength='25' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u011']."</td>
<td class='tbl'><input type='text' name='user_icq' value='".$userdata['user_icq']."' maxlength='15' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u012']."</td>
<td class='tbl'><input type='text' name='user_msn' value='".$userdata['user_msn']."' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u013']."</td>
<td class='tbl'><input type='text' name='user_yahoo' value='".$userdata['user_yahoo']."' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u014']."</td>
<td class='tbl'><input type='text' name='user_web' value='".$userdata['user_web']."' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>Kolorowanie:</td>
<td class='tbl'>
<select name='user_adds' class='textbox' style='width:200px;'>";
$d = dbarray(dbquery("SELECT * from ".$db_prefix."colors WHERE user_level='".$userdata['user_level']."'"));
echo"
<option style='color:#".$d['user_color'].";' value='0'>".$d['user_prefix'].$userdata['user_name']." ".$locale['ep_def']."</option>";
if ($userdata['user_groups']!="")
{
$tmp = explode(".", $userdata['user_groups']);
$count = count($tmp);
for ($x=0; $x<=$count; $x++)
{
$r = dbquery("SELECT group_prefix, group_color from ".$db_prefix."user_groups WHERE group_id='".$tmp[$x]."'");
if ($g = dbarray($r)) echo "<option style='color:#".$g['group_color'].";' value='".$tmp[$x]."' ".($userdata['user_color']==$g['group_color'] && $userdata['user_prefix']==$g['group_prefix'] ? "selected=\"selected\"" : "").">".$g['group_prefix'].$userdata['user_name']."</option>";
}
}
echo "</select>
</td>
</tr>
<tr>
<td class='tbl'>".$locale['u015']."</td>
<td class='tbl'><select name='user_theme' class='textbox' style='width:100px;'>
".makefileopts($theme_files, $userdata['user_theme'])."
</select></td>
</tr>
<tr>
<td class='tbl'>".$locale['u016']."</td>
<td class='tbl'><select name='user_offset' class='textbox' style='width:100px;'>
$offset_list</select></td>
</tr>\n";
if (!$userdata['user_avatar']) {
echo "<tr>
<td class='tbl'>".$locale['u017']."</td>
<td class='tbl'>
<input type='file' name='user_avatar' class='textbox' style='width:200px;'><br>
<span class='small2'>".$locale['u018']."</span><br>
<span class='small2'>".sprintf($locale['u022'], parsebytesize(30720), 100, 100)."</span>
</td>
</tr>\n";
}
echo "<tr>
<td valign='top' class='tbl'>".$locale['u020']."</td>
<td class='tbl'>
<textarea name='user_sig' rows='5' class='textbox' style='width:295px'>".$userdata['user_sig']."</textarea><br>
<input type='button' value='b' class='button' style='font-weight:bold;width:25px;' onClick=\"addText('user_sig', '[b]', '[/b]');\">
<input type='button' value='i' class='button' style='font-style:italic;width:25px;' onClick=\"addText('user_sig', '[i]', '[/i]');\">
<input type='button' value='u' class='button' style='text-decoration:underline;width:25px;' onClick=\"addText('user_sig', '[u]', '[/u]');\">
<input type='button' value='url' class='button' style='width:30px;' onClick=\"addText('user_sig', '[url]', '[/url]');\">
<input type='button' value='mail' class='button' style='width:35px;' onClick=\"addText('user_sig', '[mail]', '[/mail]');\">
<input type='button' value='img' class='button' style='width:30px;' onClick=\"addText('user_sig', '[img]', '[/img]');\">
<input type='button' value='center' class='button' style='width:45px;' onClick=\"addText('user_sig', '[center]', '[/center]');\">
<input type='button' value='small' class='button' style='width:40px;' onClick=\"addText('user_sig', '[small]', '[/small]');\">";
if ($userdata['user_sig']) {
$sygnatura = nl2br(parseubb(parsesmileys($userdata['user_sig'])));
echo "</td></tr><tr><td>\n</td><td align='center'>";
echo "<table cellspacing='0' cellpadding='0' border='0' width='100%'><tr>\n";
echo "<td align='left'>";
echo "<FIELDSET><LEGEND><font size='1'>".$locale['u020']."</font></LEGEND>";
echo "$sygnatura</td>";
echo "</tr></table>";
} else {
echo " ";
}
echo "</td>
</tr>
<tr>
<td align='center' colspan='2' class='tbl'>\n";
if ($userdata['user_avatar']) {
echo "<table cellspacing='0' cellpadding='0' border='0'><tr>\n";
echo "<td><img src='".IMAGES."avatar_mod/gora_lewa.png' height='12' width='12'></td>\n";
echo "<td><img src='".IMAGES."avatar_mod/gora_srodek.png' height='12' width='100%'></td>\n";
echo "<td><img src='".IMAGES."avatar_mod/gora_prawa.png' height='12' width='12'></td></tr>\n";
echo "<td align='left'><img src='".IMAGES."avatar_mod/srodek_lewa.png' width='12' height='100%'></td>\n";
echo "<td align='center' height='1%'>";
echo "<img src='".IMAGES."avatars/".$userdata['user_avatar']."' alt='".$locale['u017']."'></td>";
echo "<td align='right'><img src='".IMAGES."avatar_mod/srodek_prawa.png' height='100%' width='12'></td></tr><tr>\n";
echo "<td><img src='".IMAGES."avatar_mod/dol_lewa.png' height='12' width='12'></td>\n";
echo "<td><img src='".IMAGES."avatar_mod/dol_srodek.png' height='12' width='100%'></td>\n";
echo "<td><img src='".IMAGES."avatar_mod/dol_prawa.png' height='12' width='12'></td></tr>\n";
echo "</tr></table>
<input type='checkbox' name='del_avatar' value='y'> ".$locale['u019']."
<input type='hidden' name='user_avatar' value='".$userdata['user_avatar']."'><br>\n";
} else {
echo "<table cellspacing='0' cellpadding='0' border='0'><tr>\n";
echo "<td><img src='".IMAGES."avatar_mod/gora_lewa.png' height='12' width='12'></td>\n";
echo "<td><img src='".IMAGES."avatar_mod/gora_srodek.png' height='12' width='100%'></td>\n";
echo "<td><img src='".IMAGES."avatar_mod/gora_prawa.png' height='12' width='12'></td></tr>\n";
echo "<td align='left'><img src='".IMAGES."avatar_mod/srodek_lewa.png' width='12' height='100%'></td>\n";
echo "<td align='center' height='1%'>";
echo "<img src='".FORUM."images/brak.gif' alt='".$locale['u017']."'></td>";
echo "<td align='right'><img src='".IMAGES."avatar_mod/srodek_prawa.png' height='100%' width='12'></td></tr><tr>\n";
echo "<td><img src='".IMAGES."avatar_mod/dol_lewa.png' height='12' width='12'></td>\n";
echo "<td><img src='".IMAGES."avatar_mod/dol_srodek.png' height='12' width='100%'></td>\n";
echo "<td><img src='".IMAGES."avatar_mod/dol_prawa.png' height='12' width='12'></td></tr>\n";
echo "</tr></table>\n";
}
echo "<input type='hidden' name='user_hash' value='".$userdata['user_password']."'>
<center><input type='submit' name='update_profile' value='".$locale['460']."' class='button'>
</center></td>
</tr>
</table>
</form>\n";
closetable();
} else {
echo "<center><br>\n".$locale['03']."<br>\n<br></center>\n";
closetable();
}
require_once "side_right.php";
require_once "footer.php";
?>
profile.php:
<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| 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";
include LOCALE.LOCALESET."user_fields.php";
if (!isset($group_id)) {
if (!isset($lookup) || !isNum($lookup)) fallback("index.php");
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id='$lookup'");
if (dbrows($result)) { $data = dbarray($result); } else { redirect("index.php"); }
opentable($locale['420']);
echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>
<tr>
<td colspan='3'>
<table align='center' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td class='tbl2'><b>".$data['user_name']."</b></td>
<td align='right' class='tbl2'>".getuserlevel($data['user_level'])."</td>
</tr>
</table>
</td>
<tr>
<td align='center' width='150' rowspan='5' class='tbl2'>\n";
echo genshadow($data['user_avatar'])."</td>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u009']."</b></td>
<td class='tbl1'>".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u010']."</b></td>
<td class='tbl2'>";
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>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u021']."</b></td>
<td class='tbl1'>".($data['user_aim'] ? $data['user_aim'] : $locale['u048'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u011']."</b></td>
<td class='tbl2'>";
if ($data['user_icq']) {
echo "<img border=0 src='http://web.icq.com/whitepages/online?icq=".$data['user_icq']."&img=5' height='14'>";
echo $data['user_icq'];
} else {
echo $locale['u048'];
}
echo "</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u012']."</b></td>
<td class='tbl1'>";
if ($data['user_msn']) {
echo "<img src='http://www.gadu-gadu.pl/users/status.asp?id=".$data['user_msn']."&styl=1' height='14'>";
echo "<a href='gg:".$data['user_msn']."' target='_blank'>".$data['user_msn']."</a>\n";
} else {
echo $locale['u048']."\n";
}
echo "</td>
</tr>
<tr>
<td align='center' class='tbl1'>\n";
if ($data['user_hide_email'] != "1" || iADMIN) {
echo "[<a href='mailto:".str_replace("@","@",$data['user_email'])."' title='".str_replace("@","@",$data['user_email'])."'>".$locale['u051']."</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'>".$locale['u052']."</a>]\n";
}
if (!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id']) {
echo "[<a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>".$locale['u053']."</a>]\n";
}
echo "</td>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u013']."</b></td>
<td class='tbl2'>";
if ($data['user_yahoo']) {
echo "<img src='http://status.tlen.pl/?u=".$data['user_yahoo']."&t=1' height='14'>";
echo "<a href='http://ludzie.tlen.pl/".$data['user_yahoo']."'>".$data['user_yahoo']."</a>\n";
} else {
echo $locale['u048']."\n";
}
echo "</td>
</tr>
</table>\n";
tablebreak();
echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>
<tr>
<td class='tbl2' colspan='2'><b>".$locale['422']."</b></td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u040']."</b></td>
<td class='tbl1'>".showdate("longdate", $data['user_joined'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u044']."</b></td>
<td class='tbl2'>".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u041']."</b></td>
<td class='tbl1'>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u042']."</b></td>
<td class='tbl2'>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u043']."</b></td>
<td class='tbl1'>".number_format($data['user_posts'])."</td>
</tr>".(iADMIN ? "<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['EP_IP']."</b></td>
<td class='tbl2'>".$data['user_ip']."</td>
</tr>" : "");
if (EPS) echo "<tr><td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['560']."</b></td> <td class='tbl1'>".check_rang($lookup)."</td></tr>
<tr><td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['561']."</b></td> <td class='tbl2'>".show_points($lookup)."</td></tr>
</table>\n";
if ($data['user_groups']) {
tablebreak();
echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>\n";
echo "<tr>\n<td class='tbl2'><b>".$locale['423']."</b></td>\n\n</tr>\n<tr>\n<td class='tbl1'>\n";
$user_groups = (strpos($data['user_groups'], ".") == 0 ? explode(".", substr($data['user_groups'], 1)) : explode(".", $data['user_groups']));
for ($i = 0;$i < count($user_groups);$i++) {
echo "<a href='".FUSION_SELF."?group_id=".$user_groups[$i]."'>".getgroupname($user_groups[$i])."</a>";
if ($i != (count($user_groups)-1)) { echo ",\n"; } else { echo "\n"; }
}
echo "</td>\n</tr>\n</table>\n";
}
} else {
if (!isNum($group_id)) fallback("index.php");
$result = dbquery("SELECT * FROM ".$db_prefix."user_groups WHERE group_id='$group_id'");
if (dbrows($result)) {
$data = dbarray($result);
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_groups REGEXP('^\\\.{$group_id}$|\\\.{$group_id}\\\.|\\\.{$group_id}$') ORDER BY user_level DESC, user_name");
opentable($locale['410']);
echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>
<tr>
<td align='center' colspan='2' class='tbl1'><b>".$data['group_name']."</b> (".sprintf((dbrows($result)==1?$locale['411']:$locale['412']), dbrows($result)).")</td>
</tr>
<tr>
<td class='tbl2'><b>".$locale['401']."</b></td>
<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['402']."</b></td>
</tr>\n";
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
echo "<tr>\n<td class='$cell_color'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>\n";
echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>\n</tr>";
}
echo "</table>\n";
} else {
fallback(BASEDIR."index.php");
}
}
closetable();
if (isset($lookup) && isNum($lookup))
{
if (file_exists(INFUSIONS."cautions/locale/".$settings['locale'].".php")) {
include INFUSIONS."cautions/locale/".$settings['locale'].".php";
} else {
include INFUSIONS."cautions/locale/Polish.php";
}
tablebreak();
opentable($locale['C_000']);
$caution_r = dbquery("SELECT * from ".$db_prefix."cautions WHERE user_id=".$_GET['lookup']);
$c_count = mysql_numrows($caution_r);
echo "<table cellpadding='0' cellspacing='0' width='100%'>";
echo "<tr>\n<td class='tbl' width='50%' align='right'>".$locale['C_014']."</td>\n<td class='tbl' colspan='2'><font style='font-size:13; color:red'><b>\n";
echo $c_count."</b></font></td>\n</tr>\n";
while ($caution = dbarray($caution_r))
{
$author = dbarray(dbquery("SELECT user_name,user_color,user_prefix from ".$db_prefix."users WHERE user_id=".$caution['who']));
echo "<tr>\n<td class='tbl' valign='top' align='right'><font style='font-size:9'>".$locale['C_021']."</font> <span style='color:#".$author['user_color'].";'>".$author['user_prefix'].$author['user_name'];
if ((checkgroup($cautions_conf['group_id']) && $cautions_conf['group_id']!=0) || iSUPERADMIN)
{
echo" <br>[ <a href='".INFUSIONS."cautions/cautions.php?action=del&userid=".$caution['user_id']."&id=".$caution['id' ]."'>
<font style='font-size:9; color:red'>".$locale['C_015']."</font></a> <font style='font-size:9'> | </font><a href='".INFUSIONS."cautions/cautions.php?action=edit&userid=".$caution['user_id']."&id=".$caution['id']."&username=".$data[ 'user_name']."'>
<font style='font-size:9; color:red'>".$locale['C_016']."</font></a> <font style='font-size:9'></font> ]
"; }
echo"</td>\n<td class='tbl' colspan='2'>\n";
echo "<font style='font-size:9'> | ".$caution['why']."</font></td>\n</tr>\n";
}
echo "</table>";
closetable();
tablebreak();
// -------------------------------------------------------------------------
require_once INFUSIONS."fusion_forum_view/fusion_forum_view.php";
}
require_once "side_right.php";
require_once "footer.php";
?>
Gdzie mam dodać tą tabelę do bazy danych ?
|
v7.02.04
Rozwiń Kod źródłowy PHP
Pokaż jak zmieniłeś zapytanie do bazy, które aktualizuje profil.
, a co do extreme-fusion szukałem i może jestem trochę ślepy bo nie znalazłem. A tak na marginesie to tam można prosić o pomoć milion razy, a i tak nikt CI nie pomoże.