Navigacija

Vartotojų tinkle

Prisijungusių svečių: 249
Prisijungusių narių: 0
Prisijungusių narių nėra

Registruoti nariai: 25,955
Naujausias narys: lanis

Naujausi straipsniai

Paskutiniai nariai

TOMIJUS 4 dienos
ozzWANTED 5 dienos
Reikalas 9 savaitės
Jaunelis15 savaitės
lanis16 savaitės
And2s16 savaitės
Memento Mori21 savaitės
Quwqkibor24 savaitės
asirija28 savaitės
tomeem30 savaitės
weberiz33 savaitės
mRokass35 savaitės
kartoonas36 savaitės
grunskiz39 savaitės
Bruksnys40 savaitės
illusion40 savaitės
ordo41 savaitės
Jurgaila41 savaitės
originalcs1641 savaitės
Rytis42 savaitės

Informacija:


OS: Unknown
Naršyklė: Nežinoma
IP: 3.147.72.188
Naujienų: 529
Straipsnių: 235
Temų: 52,588
Postų: 522,537
Postų pask. parą: 0
Shout'ų pask. parą: 0
P.S.C. pask. parą: 0
Nuorodų kataloge: 13

Lankomumo Statistika

Peržiūrų šiandien: 22

Iš viso peržiūrų: 22948724

Prisijungti

REGISTRUOTIS
Nario vardas

Slaptažodis



Pamiršai slaptažodį?
Paprašyk naujo

Aktyvuoti save

Šaukykla

Jei norite rašyti žinutes, turite prisijungti.

Jaunelis
2024 Lie. 25 11:07:43
Oho vis dar veikia svetainė akinanti šypsen Šimtas metų, matau Šaukykloje nuostalgija. Smagu panaršyt po forumą ir pažiūrėt senas temas šypsosi

And2s
2024 Lie. 17 19:07:04
2008 pirmą kart čia patekau, man buvo 10m ir čia pramokau programavimo.. smagu skaityti senas žinutes, tokia nostalgija akinanti šypsen ačiū Ozz kad saugoji šitą kultūrinį reliktą šypsosi

ozzWANTED
2024 Sau. 17 01:01:00
Desperatiškus komentarus šaukykloje su accountu po mėnesio prasibuvimo, ištryniau. Pasaulis ir taip juodas. Įjungiam šviesą, prašviesės. šypsosi

Majakas
2023 Gru. 10 19:12:39
Negaliu patikėti jog žinutės/pranešimai visi yra nuo 2008 m akinanti šypsen

Žmogus
2023 Rugs. 7 21:09:14
O gal BloodKiller pasijungs?

Šaukyklos archyvas

Apklausa

Ar esate patenkinti lietuviško vertimo kokybe?

Taip!

Taip, bet yra ką taisyti (parašysiu komentaruose)

Ne

Norėdamas balsuoti turite prisijungti.
Archyvas
Reklama 400x60
update_profile_include.php
Forumas | PHP-Fusion, WordPress, Shopify, PHP ir MySQL (PROGRAMAVIMAS) | Expert PHP, MySQL klausimai

Autorius: lexys Peržiūrų: 2361      Spausdinti temą
2008 Lie. 20 21:07:30          1 žinutė iš 11
Spausdinti pranešimą
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ą?

2008 Lie. 20 21:07:24          2 žinutė iš 11
Spausdinti pranešimą
Locale. akinanti šypsenDD Nu tai į čia surašyk kur reikia.
2008 Lie. 20 22:07:51          3 žinutė iš 11
Spausdinti pranešimą
cia tavo update_profile_include.php ??? o kur visos uzklausos kad i db irasytu? garantuoju ten neivedes savo klano statistikos
2008 Lie. 20 23:07:00          4 žinutė iš 11
Spausdinti pranešimą
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.

2008 Lie. 20 23:07:51          5 žinutė iš 11
Spausdinti pranešimą
vat ir pratryniai akinanti šypsen
duok cia originalu upadate profile include ir pateik cia savo edit_profile

2008 Lie. 20 23:07:05          6 žinutė iš 11
Spausdinti pranešimą
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.

2008 Lie. 21 09:07:34          7 žinutė iš 11
Spausdinti pranešimą
Padėkit giakinanti šypsen
2008 Lie. 21 09:07:23          8 žinutė iš 11
Spausdinti pranešimą
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



2008 Lie. 22 01:07:07          9 žinutė iš 11
Spausdinti pranešimą
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("@","&#64;",$data['user_email'])."' title='".str_replace("@","&#64;",$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";
?>




2008 Lie. 22 09:07:37          10 žinutė iš 11
Spausdinti pranešimą
uzeik i mysql ir pasirink user lentele, tada export ir visa lentele cia papostink
2008 Lie. 22 20:07:30          11 žinutė iš 11
Spausdinti pranešimą
Chipas, ir tai ką tu man daviai, tai dabar profilio neatnaujina net standartinių laukų akinanti šypsen

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 ;



Peršokti į forumą: