Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: update_profile_include.php
Parašė lexys· 2008 Lie. 20 21:07:30
#1
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ą?
Redagavo lexys· 2008 Lie. 20 23:07:22
Parašė Dandžu· 2008 Lie. 20 21:07:24
#2
Locale. :DDD Nu tai į čia surašyk kur reikia.
Parašė bruzgis· 2008 Lie. 20 22:07:51
#3
cia tavo update_profile_include.php ??? o kur visos uzklausos kad i db irasytu? garantuoju ten neivedes savo klano statistikos
Parašė lexys· 2008 Lie. 20 23:07:00
#4
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.
Redagavo lexys· 2008 Lie. 20 23:07:40
Parašė bruzgis· 2008 Lie. 20 23:07:51
#5
vat ir pratryniai :D
duok cia originalu upadate profile include ir pateik cia savo edit_profile
Parašė lexys· 2008 Lie. 20 23:07:05
#6
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.
Redagavo lexys· 2008 Lie. 21 09:07:57
Parašė lexys· 2008 Lie. 21 09:07:34
#7
Padėkit gi:D
Parašė bruzgis· 2008 Lie. 21 09:07:23
#8
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
Parašė lexys· 2008 Lie. 22 01:07:07
#9
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";
?>
Parašė bruzgis· 2008 Lie. 22 09:07:37
#10
uzeik i
mysql ir pasirink user lentele, tada export ir visa lentele cia papostink
Parašė lexys· 2008 Lie. 22 20:07:30
#11
Chipas, ir tai ką tu man daviai, tai dabar profilio neatnaujina net standartinių laukų :D
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 ;