lexys
Narys
Margas
Pranešimai: 72
Įstojęs: 2006 Kov. 16 20:03:23
|
Sveiki,
<?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 ($username == "" || $_POST['user_email'] == "") {
$error .= $locale['480']."<br>\n";
} else {
if (preg_match("/^[-0-9A-Z_@\s]+$/i", $username)) {
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";
}
} else {
$error .= $locale['481']."<br>\n";
}
if (preg_match("/^[-0-9A-Z_\.]{1,50}@([-0-9A-Z_\.]+\.){1,50}([0-9A-Z]){2,4}$/i", $_POST['user_email'])) {
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";
}
} else {
$error .= $locale['483']."<br>\n";
}
}
if ($_POST['user_newpassword'] != "") {
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_msn = isset($_POST['user_msn']) ? stripinput(trim($_POST['user_msn'])) : "";
$user_offset = is_numeric($_POST['user_offset']) ? $_POST['user_offset'] : "0";
$user_sig = isset($_POST['user_sig']) ? stripinput(trim($_POST['user_sig'])) : "";
$user_klanopavadinimas = isset($_POST['user_klanopavadinimas']) ? stripinput(trim($_POST['user_klanopavadinimas'])) : "";
$user_wincm = isset($_POST['user_wincm']) ? stripinput(trim($_POST['user_wincm'])) : "";
$user_lostcm = isset($_POST['user_lostcm']) ? stripinput(trim($_POST['user_lostcm'])) : "";
$user_clanweb = isset($_POST['user_clanweb']) ? stripinput(trim($_POST['user_clanweb'])) : "";
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 ($user_newpassword != "") { $newpass = " user_password='".md5(md5($user_newpassword))."', "; } else { $newpass = " "; }
$result = dbquery("UPDATE ".$db_prefix."users SET user_name='$username',".$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_klanopavadinimas='$user_klanopavadinimas', user_wincm='$user_wincm', user_lostcm='$user_lostcm', user_clanweb='$user_clanweb' user_msn='$user_msn', user_offset='$user_offset', ".$set_avatar."user_sig='$user_sig' WHERE user_id='".$userdata['user_id']."'");
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id='".$userdata['user_id']."'");
if (dbrows($result) != 0) {
cuserdata = dbarray($result);
redirect("edit_profile.php?update_profile=ok");
}
}
?>
Darausi savo tinklalapyje Klanų statistiką, kad kiekvioenas žmogus galėtų užregistruoti kllaną, tačiau susidūriau su bėda.
Kai Apžiūrinėji Profilį, viskas čiki piki, kai spaudi redaguoti viskas čiki piki, tačiau kai suvedi info ir bandai atnaujinti visą informaciją atnaujina o klano info neatnaujina. Kiek supratau edit_profile.php naudoja šitą include kurio kodą daviau, msql'e lentelės sukurtos kokių reikia, tačiau vistiek neveikia man, įvesti įrašai neįsirašo.
Gal kas padės nustatyti poblemą?
|
Dandžu
Narys
Ekspertas
Pranešimai: 3265
Įstojęs: 2007 Lie. 23 13:07:47
|
Locale. DD Nu tai į čia surašyk kur reikia.
|
bruzgis
Narys
Ekspertas
Pranešimai: 3368
Įstojęs: 2006 Geg. 9 18:05:02
|
cia tavo update_profile_include.php ??? o kur visos uzklausos kad i db irasytu? garantuoju ten neivedes savo klano statistikos
|
lexys
Narys
Margas
Pranešimai: 72
Įstojęs: 2006 Kov. 16 20:03:23
|
jo, toksai yra mano update_profile_include.php esu iš jo pratrynes, nereikalingus man laukelius otkius kaip theme sarasai, ICQ ID, yahoo ir pan. Kintamuosius pridėjau user_clanweb ir pan, na matot jūs, paskui ten kur ir funkcija POST yra, ir ten juos esu surašęs, ir MSQL'e esu laukelius reikiamus sukūręs, tačiau vistiek kažkas blogai.
PAsigedau čia tik vieno dalyko, įrašymo į MSQL, bet čia fušionas todėl nežinau.
msql insert into, gal tai reikėtų vartoti nežinau.
P.S Aš nesu PHP meistras ar dar kas nors, tai mano pirmieji bandymai daryti savita ant PHP.
|
bruzgis
Narys
Ekspertas
Pranešimai: 3368
Įstojęs: 2006 Geg. 9 18:05:02
|
vat ir pratryniai
duok cia originalu upadate profile include ir pateik cia savo edit_profile
|
lexys
Narys
Margas
Pranešimai: 72
Įstojęs: 2006 Kov. 16 20:03:23
|
Mano Edit profile.php Failas
<?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($_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'><input type='text' name='user_name' value='".$userdata['user_name']."' maxlength='30' class='textbox' style='width:200px;'></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='16' 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>\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' cols='53' class='textbox'>".$userdata['user_sig']."</textarea><br>
<input type='button' value='b' class='button' style='font-weight:bold;width:25px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='i' class='button' style='font-style:italic;width:25px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='u' class='button' style='text-decoration:underline;width:25px;' onClick=\"addText('user_sig', '', '');\">
<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', '', '');\">
<input type='button' value='small' class='button' style='width:40px;' onClick=\"addText('user_sig', '', '');\">
</td>
</tr>";
// Prasdeda
echo"
<tr>
<td class='tb1' width='400px' colspan='2'>
<b>".$locale['u061']."</b></td>
</tr>
<br>
<tr>
<td class='tb1' width='150px'>".$locale['u062']."</td>
<td class='tb1' width='250px'><input type='text' name='user_klanopavadinimas' value='".$userdata['user_klanopavadinimas']."' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tb1' width='150px'>".$locale['u063']."</td>
<td class='tb1' width='250px'><input type='text' name='user_wincm' value='".$userdata['user_wincm']."' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tb1' width='150px'>".$locale['u064']."</td>
<td class='tb1' width='250px'><input type='text' name='user_lostcm' value='".$userdata['user_lostcm']."' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tb1' width='150px'>".$locale['u065']."</td>
<td class='tb1' width='250px'><input type='text' name='user_clanweb' value='".$userdata['user_clanweb']."' maxlength='100' class='textbox' style='width:200px;'</td>
</tr>";
// Pasbaige
echo"
<tr>
<td align='center' colspan='2' class='tbl'><br>\n";
if ($userdata['user_avatar']) {
echo $locale['u017']."<br>\n<img src='".IMAGES."avatars/".$userdata['user_avatar']."' alt='".$locale['u017']."'><br>
<input type='checkbox' name='del_avatar' value='y'> ".$locale['u019']."
<input type='hidden' name='user_avatar' value='".$userdata['user_avatar']."'><br><br>\n";
}
echo "<input type='hidden' name='user_hash' value='".$userdata['user_password']."'>
<input type='submit' name='update_profile' value='".$locale['460']."' class='button'></td>
</tr>
</table>
</form>\n";
closetable();
} else {
echo "<center><br>\n".$locale['003']."<br>\n<br></center>\n";
closetable();
}
require_once "side_right.php";
require_once "footer.php";
?>
Klano Informacijos laukeliai atskirti // Prasdeda //pasbaigia
Tad greitai rasi.
update_profile_include.php failiukas, nepratrintas, tik dadėtas tvarkingai.
<?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 ($username == "" || $_POST['user_email'] == "") {
$error .= $locale['480']."<br>\n";
} else {
if (preg_match("/^[-0-9A-Z_@\s]+$/i", $username)) {
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";
}
} else {
$error .= $locale['481']."<br>\n";
}
if (preg_match("/^[-0-9A-Z_\.]{1,50}@([-0-9A-Z_\.]+\.){1,50}([0-9A-Z]){2,4}$/i", $_POST['user_email'])) {
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";
}
} else {
$error .= $locale['483']."<br>\n";
}
}
if ($_POST['user_newpassword'] != "") {
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_klanopavadinimas = isset($_POST['user_klanopavadinimas']) ? stripinput(trim($_POST['user_klanopavadinimas'])) : "";
$user_wincm = isset($_POST['user_wincm']) ? stripinput(trim($_POST['user_wincm'])) : "";
$user_lostcm = isset($_POST['user_lostcm']) ? stripinput(trim($_POST['user_lostcm'])) : "";
$user_clanweb = isset($_POST['user_clanweb']) ? stripinput(trim($_POST['user_clanweb'])) : "";
$user_icq = isset($_POST['user_icq']) ? stripinput(trim($_POST['user_icq'])) : "";
$user_msn = isset($_POST['user_msn']) ? stripinput(trim($_POST['user_msn'])) : "";
$user_aim = isset($_POST['user_aim']) ? stripinput(trim($_POST['user_aim'])) : "";
$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 ($user_newpassword != "") { $newpass = " user_password='".md5(md5($user_newpassword))."', "; } else { $newpass = " "; }
$result = dbquery("UPDATE ".$db_prefix."users SET user_name='$username',".$newpass."user_email='".$_POST['user_email']."', user_hide_email='$user_hide_email', user_location='$user_location', user_birthdate='$user_birthdate',user_klanopavadinimas='$user_klanopavadinimas', user_wincm='$user_wincm', user_lostcm='$user_lostcm''user_clanweb='$user_clanweb, 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' 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");
}
}
?>
MSQL'e toki laukai yra uskurti:
user_klanopavadinimas
user_wincm
user_lostcm
user_clanweb
Nustatymai jiems uždėti toki kaip ir user_aim laukui, tačiau padidintas varchar iki 100 ar 200 kur lost win cm tai 20 nustatęs esu.
|
lexys
Narys
Margas
Pranešimai: 72
Įstojęs: 2006 Kov. 16 20:03:23
|
Padėkit gi
|
bruzgis
Narys
Ekspertas
Pranešimai: 3368
Įstojęs: 2006 Geg. 9 18:05:02
|
sql uzklausa:
ALTER TABLE `f1fanas_users` ADD `user_klanopavadinimas` VARCHAR( 255 ) NOT NULL ,
ADD `user_wincm` VARCHAR( 255 ) NOT NULL ,
ADD `user_lostcm` VARCHAR( 255 ) NOT NULL ,
ADD `user_clanweb` VARCHAR( 255 ) NOT NULL ;
edit_profile.php failas:
<?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($_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'><input type='text' name='user_name' value='".$userdata['user_name']."' maxlength='30' class='textbox' style='width:200px;'></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='16' 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='tb1' width='400px' colspan='2'>
<b>".$locale['u061']."</b></td>
</tr>
<br>
<tr>
<td class='tb1' width='150px'>".$locale['u062']."</td>
<td class='tb1' width='250px'><input type='text' name='user_klanopavadinimas' value='".$userdata['user_klanopavadinimas']."' maxlength='255' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tb1' width='150px'>".$locale['u063']."</td>
<td class='tb1' width='250px'><input type='text' name='user_wincm' value='".$userdata['user_wincm']."' maxlength='255' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tb1' width='150px'>".$locale['u064']."</td>
<td class='tb1' width='250px'><input type='text' name='user_lostcm' value='".$userdata['user_lostcm']."' maxlength='255' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tb1' width='150px'>".$locale['u065']."</td>
<td class='tb1' width='250px'><input type='text' name='user_clanweb' value='".$userdata['user_clanweb']."' maxlength='255' class='textbox' style='width:200px;'</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' cols='53' class='textbox'>".$userdata['user_sig']."</textarea><br>
<input type='button' value='b' class='button' style='font-weight:bold;width:25px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='i' class='button' style='font-style:italic;width:25px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='u' class='button' style='text-decoration:underline;width:25px;' onClick=\"addText('user_sig', '', '');\">
<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', '', '');\">
<input type='button' value='small' class='button' style='width:40px;' onClick=\"addText('user_sig', '', '');\">
</td>
</tr>
<tr>
<td align='center' colspan='2' class='tbl'><br>\n";
if ($userdata['user_avatar']) {
echo $locale['u017']."<br>\n<img src='".IMAGES."avatars/".$userdata['user_avatar']."' alt='".$locale['u017']."'><br>
<input type='checkbox' name='del_avatar' value='y'> ".$locale['u019']."
<input type='hidden' name='user_avatar' value='".$userdata['user_avatar']."'><br><br>\n";
}
echo "<input type='hidden' name='user_hash' value='".$userdata['user_password']."'>
<input type='submit' name='update_profile' value='".$locale['460']."' class='button'></td>
</tr>
</table>
</form>\n";
closetable();
} else {
echo "<center><br>\n".$locale['003']."<br>\n<br></center>\n";
closetable();
}
require_once "side_right.php";
require_once "footer.php";
?>
upadate_profile_include.php failas:
<?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 ($username == "" || $_POST['user_email'] == "") {
$error .= $locale['480']."<br>\n";
} else {
if (preg_match("/^[-0-9A-Z_@\s]+$/i", $username)) {
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";
}
} else {
$error .= $locale['481']."<br>\n";
}
if (preg_match("/^[-0-9A-Z_\.]{1,50}@([-0-9A-Z_\.]+\.){1,50}([0-9A-Z]){2,4}$/i", $_POST['user_email'])) {
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";
}
} else {
$error .= $locale['483']."<br>\n";
}
}
if ($_POST['user_newpassword'] != "") {
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_icq = isset($_POST['user_icq']) ? stripinput(trim($_POST['user_icq'])) : "";
$user_msn = isset($_POST['user_msn']) ? stripinput(trim($_POST['user_msn'])) : "";
$user_aim = isset($_POST['user_aim']) ? stripinput(trim($_POST['user_aim'])) : "";
$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'])) : "";
$user_klanopavadinimas = isset($_POST['user_klanopavadinimas']) ? stripinput(trim($_POST['user_klanopavadinimas'])) : "";
$user_wincm = isset($_POST['user_wincm']) ? stripinput(trim($_POST['user_wincm'])) : "";
$user_lostcm = isset($_POST['user_lostcm']) ? stripinput(trim($_POST['user_lostcm'])) : "";
$user_clanweb = isset($_POST['user_clanweb']) ? stripinput(trim($_POST['user_clanweb'])) : "";
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 ($user_newpassword != "") { $newpass = " user_password='".md5(md5($user_newpassword))."', "; } else { $newpass = " "; }
$result = dbquery("UPDATE ".$db_prefix."users SET user_name='$username',".$newpass." user_email='".$_POST['user_email']."', user_hide_email='$user_hide_email', user_location='$user_location', user_birthdate='$user_birthdate', 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_klanopavadinimas='$user_klanopavadinimas', user_wincm='$user_wincm', user_lostcm='$user_lostcm' user_clanweb='$user_clanweb' 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");
}
}
?>
Nu žioplas esi :) tokias klaidas daryt .. :)
'$user_birthdate',user_klanopavadinimas='$user_klanopavadinimas', user_wincm='$user_wincm', user_lostcm='$user_lostcm''user_clanweb='$user_clanweb, user_icq='$user_icq
|
lexys
Narys
Margas
Pranešimai: 72
Įstojęs: 2006 Kov. 16 20:03:23
|
Blemba nu neveikia...
MSQL Lenteles sukūriau fushion_user lentelėje.
Sudėjau tuos tavo failus ir vistiek MSQL'e įrašų neatsiranda.
Profile kodas:
<?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>
";
If ($data['strike1'] == "1") {
echo "<img src='".BASEDIR."infusions/warning_system/s1.gif'>";
}
else{
echo "<img src='".BASEDIR."infusions/warning_system/s.gif'>";
}
If ($data['strike2'] == "1") {
echo "<img src='".BASEDIR."infusions/warning_system/s1.gif'>";
}
else{
echo "<img src='".BASEDIR."infusions/warning_system/s.gif'>";
}
If ($data['strike3'] == "1") {
echo "<img src='".BASEDIR."infusions/warning_system/s1.gif'>";
}
else{
echo "<img src='".BASEDIR."infusions/warning_system/s.gif'>";
}
echo"
</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 ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</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='tbl1' style='white-space:nowrap'><b>".$locale['u012']."</b></td>
<td class='tbl1'>".($data['user_msn'] ? $data['user_msn'] : $locale['u048'])."</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_clanweb']) {
$urlprefix = !strstr($data['user_clanweb'], "http://") ? "http://" : "";
echo "[<a href='".$urlprefix.$data['user_clanweb']."' title='".$urlprefix.$data['user_clanweb']."' target='_blank'>".$locale['u065']."</a>]\n";
}
echo "</td>
<td width='1%' class='tbl2' style='white-space:nowrap'>";
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>
</tr>
</table>\n";
tablebreak();
echo"<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>
<tr>
<td class='tbl2' width='398' colspan='2'>
<b>".$locale['u061']."</b></td>
</tr>
<tr>
<td class='tbl1' width='147'><b>".$locale['u062']."</b></td>
<td class='tbl2' width='250'>".($data['user_klanopavadinimas'] ? $data['user_klanopavadinimas'] : $locale['u048'])."</td>
</tr>
<tr>
<td class='tbl2' width='147'><b>".$locale['u063']."</b></td>
<td class='tbl1' width='250'>".($data['user_wincm'] ? $data['user_wincm'] : $locale['u048'])."</td>
</tr>
<tr>
<td class='tbl1' width='147'><b>".$locale['u064']."</b></td>
<td class='tbl2' width='250'>".($data['user_lostcm'] ? $data['user_lostcm'] : $locale['u048'])."</td>
</tr>
<tr>
<td class='tbl2' width='147'><b>".$locale['u065']."</b></td>
<td class='tbl1' width='250'>".($data['user_clanweb'] ? $data['user_clanweb'] : $locale['u048'])."</td>
</tr>
<tr>
<td class='tbl1' width='147'><b>".$locale['u066']."</b></td>
<td class='tbl2' width='250'>Pasiulyk</td>
</tr>
</table>";
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>
</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();
include INCLUDES."comments_include.php";
showcomments("U","users","user_id",$_GET['lookup'],FUSION_SELF."?lookup=".$_GET['lookup']);
require_once "side_right.php";
require_once "footer.php";
?>
Update profili include failas
<?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 ($username == "" || $_POST['user_email'] == "") {
$error .= $locale['480']."<br>\n";
} else {
if (preg_match("/^[-0-9A-Z_@\s]+$/i", $username)) {
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";
}
} else {
$error .= $locale['481']."<br>\n";
}
if (preg_match("/^[-0-9A-Z_\.]{1,50}@([-0-9A-Z_\.]+\.){1,50}([0-9A-Z]){2,4}$/i", $_POST['user_email'])) {
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";
}
} else {
$error .= $locale['483']."<br>\n";
}
}
if ($_POST['user_newpassword'] != "") {
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_icq = isset($_POST['user_icq']) ? stripinput(trim($_POST['user_icq'])) : "";
$user_msn = isset($_POST['user_msn']) ? stripinput(trim($_POST['user_msn'])) : "";
$user_aim = isset($_POST['user_aim']) ? stripinput(trim($_POST['user_aim'])) : "";
$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'])) : "";
$user_klanopavadinimas = isset($_POST['user_klanopavadinimas']) ? stripinput(trim($_POST['user_klanopavadinimas'])) : "";
$user_wincm = isset($_POST['user_wincm']) ? stripinput(trim($_POST['user_wincm'])) : "";
$user_lostcm = isset($_POST['user_lostcm']) ? stripinput(trim($_POST['user_lostcm'])) : "";
$user_clanweb = isset($_POST['user_clanweb']) ? stripinput(trim($_POST['user_clanweb'])) : "";
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 ($user_newpassword != "") { $newpass = " user_password='".md5(md5($user_newpassword))."', "; } else { $newpass = " "; }
$result = dbquery("UPDATE ".$db_prefix."users SET user_name='$username',".$newpass." user_email='".$_POST['user_email']."', user_hide_email='$user_hide_email', user_location='$user_location', user_birthdate='$user_birthdate', 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_klanopavadinimas='$user_klanopavadinimas', user_wincm='$user_wincm', user_lostcm='$user_lostcm' user_clanweb='$user_clanweb' 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 failas
<?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($_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'><input type='text' name='user_name' value='".$userdata['user_name']."' maxlength='30' class='textbox' style='width:200px;'></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='16' 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='tb1' width='400px' colspan='2'>
<b>".$locale['u061']."</b></td>
</tr>
<br>
<tr>
<td class='tb1' width='150px'>".$locale['u062']."</td>
<td class='tb1' width='250px'><input type='text' name='user_klanopavadinimas' value='".$userdata['user_klanopavadinimas']."' maxlength='255' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tb1' width='150px'>".$locale['u063']."</td>
<td class='tb1' width='250px'><input type='text' name='user_wincm' value='".$userdata['user_wincm']."' maxlength='255' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tb1' width='150px'>".$locale['u064']."</td>
<td class='tb1' width='250px'><input type='text' name='user_lostcm' value='".$userdata['user_lostcm']."' maxlength='255' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tb1' width='150px'>".$locale['u065']."</td>
<td class='tb1' width='250px'><input type='text' name='user_clanweb' value='".$userdata['user_clanweb']."' maxlength='255' class='textbox' style='width:200px;'</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' cols='53' class='textbox'>".$userdata['user_sig']."</textarea><br>
<input type='button' value='b' class='button' style='font-weight:bold;width:25px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='i' class='button' style='font-style:italic;width:25px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='u' class='button' style='text-decoration:underline;width:25px;' onClick=\"addText('user_sig', '', '');\">
<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', '
', '
');\">
<input type='button' value='small' class='button' style='width:40px;' onClick=\"addText('user_sig', '', '');\">
</td>
</tr>
<tr>
<td align='center' colspan='2' class='tbl'><br>\n";
if ($userdata['user_avatar']) {
echo $locale['u017']."<br>\n<img src='".IMAGES."avatars/".$userdata['user_avatar']."' alt='".$locale['u017']."'><br>
<input type='checkbox' name='del_avatar' value='y'> ".$locale['u019']."
<input type='hidden' name='user_avatar' value='".$userdata['user_avatar']."'><br><br>\n";
}
echo "<input type='hidden' name='user_hash' value='".$userdata['user_password']."'>
<input type='submit' name='update_profile' value='".$locale['460']."' class='button'></td>
</tr>
</table>
</form>\n";
closetable();
} else {
echo "<center><br>\n".$locale['003']."<br>\n<br></center>\n";
closetable();
}
require_once "side_right.php";
require_once "footer.php";
?>
|
bruzgis
Narys
Ekspertas
Pranešimai: 3368
Įstojęs: 2006 Geg. 9 18:05:02
|
uzeik i mysql ir pasirink user lentele, tada export ir visa lentele cia papostink
|
lexys
Narys
Margas
Pranešimai: 72
Įstojęs: 2006 Kov. 16 20:03:23
|
Chipas, ir tai ką tu man daviai, tai dabar profilio neatnaujina net standartinių laukų
Kur vartotojų info hash ir pan, tai to neduodu ;D
CREATE TABLE `fusion_users` (
`user_id` smallint(5) unsigned NOT NULL auto_increment,
`user_name` varchar(30) NOT NULL default '',
`user_password` varchar(32) NOT NULL default '',
`user_email` varchar(100) NOT NULL default '',
`user_hide_email` tinyint(1) unsigned NOT NULL default '1',
`user_location` varchar(50) NOT NULL default '',
`user_birthdate` date NOT NULL default '0000-00-00',
`user_aim` varchar(16) NOT NULL default '',
`user_icq` varchar(15) character set utf8 collate utf8_lithuanian_ci NOT NULL default '',
`user_yahoo` varchar(100) character set utf8 collate utf8_lithuanian_ci NOT NULL default '',
`user_web` varchar(200) character set utf8 collate utf8_lithuanian_ci NOT NULL default '',
`user_theme` varchar(100) character set utf8 collate utf8_lithuanian_ci NOT NULL default 'Default',
`user_msn` varchar(100) NOT NULL default '',
`user_offset` char(3) NOT NULL default '0',
`user_avatar` varchar(100) NOT NULL default '',
`user_sig` text NOT NULL,
`user_posts` smallint(5) unsigned NOT NULL default '0',
`user_joined` int(10) unsigned NOT NULL default '0',
`user_lastvisit` int(10) unsigned NOT NULL default '0',
`user_ip` varchar(20) NOT NULL default '0.0.0.0',
`user_rights` text NOT NULL,
`user_groups` text NOT NULL,
`user_level` tinyint(3) unsigned NOT NULL default '101',
`user_status` tinyint(1) unsigned NOT NULL default '0',
`strike1` tinyint(4) NOT NULL default '0',
`strike2` tinyint(4) NOT NULL default '0',
`strike3` tinyint(4) NOT NULL default '0',
`user_klanopavadinimas` varchar(255) NOT NULL default '',
`user_wincm` varchar(255) NOT NULL default '',
`user_lostcm` varchar(255) NOT NULL default '',
`user_clanweb` varchar(255) NOT NULL default '',
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1099 ;
|