Diese Website verwendet Cookies, um sicherzustellen, dass Sie die bestmögliche Erfahrung auf unserer Website erhalten. Mehr erfahren
Kein Signal
All Tutorials
Dreamweaver
Autor: EliteBär Level:
 
Title: Neu Instalation oder Template wechsel!
Autor: EliteBär
Level: Normal
Programm: Dreamweaver
Comments: 4 Hits: (67297)
26.01.2013 - 12:18
Dreamweaver
Autor: EliteBär Level:
 
Title: Datenbank Externes Zugreifen z.B gameserver
Autor: EliteBär
Level: Very Easy
Programm: Dreamweaver
Comments: 2 Hits: (20925)
16.01.2013 - 06:25
DZCP
Autor: EliteBär Level:
 
Title: TS3 Auf der DZCP Homepage sichtbar machen!
Autor: EliteBär
Level: Very Easy
Programm: DZCP
Comments: 5 Hits: (29255)
08.01.2013 - 02:59
Dreamweaver
Autor: Bulletproof Level:
 
Title: Social Networks animieren mit JQuery
Autor: Bulletproof
Level: Easy
Programm: Dreamweaver
Comments: 4 Hits: (31181)
12.03.2011 - 12:58
Dreamweaver
Autor: F4n Level:
 
Title: CSS Teil 1 Einführung
Autor: F4n
Level: Very Easy
Programm: Dreamweaver
Comments: 2 Hits: (25062)
24.06.2010 - 11:09
All Downloads
DZCP 1.5.4
Downloads: 14760 Size: 2.34 MB
DZCP 1.5.4 Template #08
Downloads: 8811 Size: 7.24 MB
webSPELL Template #01
Downloads: 8038 Size: 1.88 MB
Logo #12
Downloads: 7694 Size: 4.3 MB
DZCP 1.5.4 Template #05
Downloads: 6821 Size: 7.75 MB
All Votings
no active poll

show polls
All Partners





 
Messageboard » webSPELL » Fragen zum webSPELL » Fehler!

Sort:     printview
  Author:   Message:
xnat0rx  offline
Forumrang: Plappermaul
registered: 01.11.2009
10 Posts
26.06.2010, 20:22, U
quote 
Hallo, wenn man sein Profil editiert und dies dann speichert, kommt dieser Query Failed:


# Query failed: errorno=1064
# error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'plz='' WHERE userID='1'' at line 34
# query=UPDATE `ws_aSF_user` SET nickname='LordHelmchen', username='lukas', email_hide='1', firstname='Lukas', lastname='', sex='m', country='de', town='Nürnberg', birthday='1994-01-05', icq='357063181', usertext='', clantag='=GCE=', clanname='GermanCombatElite', clanhp='www.germancombatelite.de', clanirc='', clanhistory='', cpu='', mainboard='', ram='', monitor='', graphiccard='', soundcard='', verbindung='', keyboard='', mouse='', mousepad='', mailonpm='0', newsletter='1', homepage='www.germancombatelite.de', about='', language='de' plz='' WHERE userID='1'

Bin über jede Antwort dankbar!

F4n  offline
Forumrang: GT Süchtig
registered: 24.04.2010
144 Posts
26.06.2010, 20:29, U
quote 
evlt falsche webspell version !

du hast 4.2.2

das temp. ist für 4.2.1 und 4.1.2 wink

xnat0rx  offline
Forumrang: Plappermaul
registered: 01.11.2009
10 Posts
26.06.2010, 20:41, U
quote 
Ne tut mir leid!

Es ging ja noch. Bis kurz vor ner halben stunde ;D

myfarynet.eu  offline
Forumrang: GT Süchtig
registered: 22.01.2009
252 Posts
26.06.2010, 20:49, U homepage
quote 
Poste mal deine myprofile.php.

xnat0rx  offline
Forumrang: Plappermaul
registered: 01.11.2009
10 Posts
26.06.2010, 21:30, U
quote 
Code:
1.
<?php /* ########################################################################## #                                                                        # #           Version 4       /                        /   /               # #          -----------__---/__---__------__----__---/---/-               # #           | /| /  /___) /   ) (_ `   /   ) /___) /   /                 # #          _|/_|/__(___ _(___/_(__)___/___/_(___ _/___/___               # #                       Free Content / Management System                 # #                                   /                                    # #                                                                        # #                                                                        # #   Copyright 2005-2010 by webspell.org                                  # #                                                                        # #   visit webSPELL.org, webspell.info to get webSPELL for free           # #   - Script runs under the GNU GENERAL PUBLIC LICENSE                   # #   - It's NOT allowed to remove this copyright-tag                      # #   -- http://www.fsf.org/licensing/licenses/gpl.html                    # #                                                                        # #   Code based on WebSPELL Clanpackage (Michael Gruber - webspell.at),   # #   Far Development by Development Team - webspell.org                   # #                                                                        # #   visit webspell.org                                                   # #                                                                        # ########################################################################## */  $_language->read_module('myprofile');  if(!$userID) echo $_language->module['not_logged_in'];  else {       $showerror = '';      eval ("\$title_myprofile = \"".gettemplate("title_myprofile")."\";");      echo $title_myprofile;       if(isset($_POST['submit'])) {           $nickname = htmlspecialchars(mb_substr(trim($_POST['nickname']), 0, 30));           if(isset($_POST['mail'])) $mail = $_POST['mail'];          else $mail="";           if(isset($_POST['mail_hide'])) $mail_hide = true;           else $mail_hide = false;           $usernamenew = mb_substr(trim($_POST['usernamenew']), 0, 30);           $usertext = $_POST['usertext'];           $firstname = $_POST['firstname'];           $lastname = $_POST['lastname'];           $b_day = $_POST['b_day'];           $b_month = $_POST['b_month'];           $b_year = $_POST['b_year'];           $sex = $_POST['sex'];           $flag = $_POST['flag'];           $town = $_POST['town'];           $icq = $_POST['icq'];           $icq = str_replace('-','',$icq); // Replace -            $about = $_POST['messageabout'];           $clantag = $_POST['clantag'];           $clanname = $_POST['clanname'];           $clanhp = $_POST['clanhp'];           $clanirc = $_POST['clanirc'];           $clanhistory = $_POST['clanhistory'];           $cpu = $_POST['cpu'];           $mainboard = $_POST['mainboard'];           $monitor = $_POST['monitor'];           $ram = $_POST['ram'];           $graphiccard = $_POST['graphiccard'];           $soundcard = $_POST['soundcard'];           $connection = $_POST['connection'];           $keyboard = $_POST['keyboard'];           $mouse = $_POST['mouse'];           $mousepad = $_POST['mousepad'];           $newsletter = $_POST['newsletter'];           $homepage = str_replace('http://', '', $_POST['homepage']);           $pm_mail = $_POST['pm_mail'];           $avatar = $_FILES['avatar'];           $userpic = $_FILES['userpic'];           $language = $_POST['language'];           $plz = $_POST['plz'];           $id = $userID;                      $error_array = array();                      if(isset($_POST['userID']) or isset($_GET['userID']) or $userID=="") die($_language->module['not_logged_in']);            if(isset($_POST['delavatar'])) {                $filepath = "./images/avatars/";                if(file_exists($filepath.$id.'.gif')) @unlink($filepath.$id.'.gif');                if(file_exists($filepath.$id.'.jpg')) @unlink($filepath.$id.'.jpg');                if(file_exists($filepath.$id.'.png')) @unlink($filepath.$id.'.png');                safe_query("UPDATE ".PREFIX."user SET avatar='' WHERE userID='".$id."'");           }           if(isset($_POST['deluserpic'])) {                $filepath = "./images/userpics/";                if(file_exists($filepath.$id.'.gif')) @unlink($filepath.$id.'.gif');                if(file_exists($filepath.$id.'.jpg')) @unlink($filepath.$id.'.jpg');                if(file_exists($filepath.$id.'.png')) @unlink($filepath.$id.'.png');                safe_query("UPDATE ".PREFIX."user SET userpic='' WHERE userID='".$id."'");           }            //avatar           $filepath = "./images/avatars/";           if($avatar['name'] != "" or ($_POST['avatar_url'] != "" and $_POST['avatar_url'] != "http://")) {                if($avatar['name'] != "") {                     move_uploaded_file($avatar['tmp_name'], $filepath.$avatar['name'].".tmp");                }                else {                     $avatar['name'] = strrchr($_POST['avatar_url'],"/");                     if(!copy($_POST['avatar_url'],$filepath.$avatar['name'].".tmp")) {                          $error_array['can_not_copy'] = $_language->module['can_not_copy'];                     }                }                if(!array_key_exists('can_not_copy', $error_array))                {                     @chmod($filepath.$avatar['name'].".tmp", $new_chmod);                     $info = getimagesize($filepath.$avatar['name'].".tmp");                     if($info[0] < 91 && $info[1] < 91) {                          $pic = '';                          if($info[2] == 1) $pic=$id.'.gif';                          elseif($info[2] == 2) $pic=$id.'.jpg';                          elseif($info[2] == 3) $pic=$id.'.png';                          if($pic != "") {                               if(file_exists($filepath.$id.'.gif')) @unlink($filepath.$id.'.gif');                               if(file_exists($filepath.$id.'.jpg')) @unlink($filepath.$id.'.jpg');                               if(file_exists($filepath.$id.'.png')) @unlink($filepath.$id.'.png');                               rename($filepath.$avatar['name'].'.tmp', $filepath.$pic);                               safe_query("UPDATE ".PREFIX."user SET avatar='".$pic."' WHERE userID='".$id."'");                          }                          else {                               if(unlink($filepath.$avatar['name'].".tmp")) {                                    $error_array[] = $_language->module['invalid_picture-format'];                               }                               else {                                    $error_array[] = $_language->module['upload_failed'];                               }                          }                     }                     else {                          @unlink($filepath.$avatar['name'].".tmp");                          $error_array[] = $_language->module['picture_too_big_avatar'];                     }                }           }            //userpic           $filepath = "./images/userpics/";           if($userpic['name'] != "" or ($_POST['userpic_url'] != "" and $_POST['userpic_url'] != "http://")) {                if($userpic['name'] != "") {                     move_uploaded_file($userpic['tmp_name'], $filepath.$userpic['name'].".tmp");                } else {                     $userpic['name'] = strrchr($_POST['userpic_url'],"/");                     if(!copy($_POST['userpic_url'],$filepath.$userpic['name'].".tmp")) {                          $error_array['can_not_copy'] = $_language->module['can_not_copy'];                     }                }                if(!array_key_exists('can_not_copy', $error_array))                {                     @chmod($filepath.$userpic['name'].".tmp", $new_chmod);                     $info = getimagesize($filepath.$userpic['name'].".tmp");                     if($info[0] < 231 && $info[1] < 211) {                          $pic = '';                          if($info[2] == 1) $pic=$id.'.gif';                          elseif($info[2] == 2) $pic=$id.'.jpg';                          elseif($info[2] == 3) $pic=$id.'.png';                          if($pic != "") {                               if(file_exists($filepath.$id.'.gif')) @unlink($filepath.$id.'.gif');                               if(file_exists($filepath.$id.'.jpg')) @unlink($filepath.$id.'.jpg');                               if(file_exists($filepath.$id.'.png')) @unlink($filepath.$id.'.png');                               rename($filepath.$userpic['name'].".tmp", $filepath.$pic);                               safe_query("UPDATE ".PREFIX."user SET userpic='".$pic."' WHERE userID='".$id."'");                          }                          else {                               if(unlink($filepath.$userpic['name'].".tmp")) {                                    $error_array[] = $_language->module['invalid_picture-format'];                               }                               else {                                    $error_array[] = $_language->module['upload_failed'];                               }                          }                     }                     else {                          @unlink($filepath.$userpic['name'].".tmp");                          $error_array[] = $_language->module['picture_too_big_userpic'];                     }                }           }            $birthday = $b_year.'-'.$b_month.'-'.$b_day;            $qry = "SELECT userID FROM ".PREFIX."user WHERE username = '".$usernamenew."' AND userID != ".$userID." LIMIT 0,1";           if(mysql_num_rows(safe_query($qry))) {                $error_array[] = $_language->module['username_aleady_in_use'];           }                      $qry = "SELECT userID FROM ".PREFIX."user WHERE nickname = '".$nickname."' AND userID!=".$userID." LIMIT 0,1";           if(mysql_num_rows(safe_query($qry))) {                     $error_array[] = $_language->module['nickname_already_in_use'];           }            if(count($error_array))            {                $fehler=implode('<br />&#8226; ', $error_array);                $showerror = '<div class="errorbox">                  <b>'.$_language->module['errors_there'].':</b><br /><br />                  &#8226; '.$fehler.'                </div>';           }           else           {                safe_query("UPDATE `".PREFIX."user`                               SET                                     nickname='".$nickname."',                                    username='".$usernamenew."',                                    email_hide='".$mail_hide."',                                    firstname='".$firstname."',                                    lastname='".$lastname."',                                    sex='".$sex."',                                    country='".$flag."',                                    town='".$town."',                                    birthday='".$birthday."',                                    icq='".$icq."',                                    usertext='".$usertext."',                                    clantag='".$clantag."',                                    clanname='".$clanname."',                                    clanhp='".$clanhp."',                                    clanirc='".$clanirc."',                                    clanhistory='".$clanhistory."',                                    cpu='".$cpu."',                                    mainboard='".$mainboard."',                                    ram='".$ram."',                                    monitor='".$monitor."',                                    graphiccard='".$graphiccard."',                                    soundcard='".$soundcard."',                                    verbindung='".$connection."',                                    keyboard='".$keyboard."',                                    mouse='".$mouse."',                                    mousepad='".$mousepad."',                                    mailonpm='".$pm_mail."',                                    newsletter='".$newsletter."',                                    homepage='".$homepage."',                                    about='".$about."',                                    language='".$language."'                                    plz='".$plz."'                               WHERE                                     userID='".$id."'");                      redirect("index.php?site=profile&amp;id=$id", $_language->module['profile_updated'],3);           }   }       if(isset($_GET['action']) AND $_GET['action']=="editpwd") {                 $bg1 = BG_1;           $bg2 = BG_2;             $bg3 = BG_3;           $bg4 = BG_4;           $border = BORDER;                 eval("\$myprofile_editpwd = \"".gettemplate("myprofile_editpwd")."\";");           echo $myprofile_editpwd;       }                 elseif(isset($_POST['savepwd'])) {            $oldpwd = $_POST['oldpwd'];           $pwd1 = $_POST['pwd1'];           $pwd2 = $_POST['pwd2'];           $id = $userID;            $ergebnis = safe_query("SELECT password FROM ".PREFIX."user WHERE userID='".$id."'");           $ds = mysql_fetch_array($ergebnis);            if(!(mb_strlen(trim($oldpwd)))) {                $error = $_language->module['forgot_old_pw'];                die('<b>ERROR: '.$error.'</b><br /><br /><input type="button" onclick="javascript:history.back()" value="'.$_language->module['back'].'" />');           }           $oldmd5pwd = md5($oldpwd);           if($oldmd5pwd != $ds['password']) {                $error = $_language->module['old_pw_not_valid'];                die('<b>ERROR: '.$error.'</b><br /><br /><input type="button" onclick="javascript:history.back()" value="'.$_language->module['back'].'" />');           }           if($pwd1 == $pwd2) {                if(!(mb_strlen(trim($pwd1)))) {                     $error = $_language->module['forgot_new_pw'];                     die('<b>ERROR: '.$error.'</b><br /><br /><input type="button" onclick="javascript:history.back()" value="'.$_language->module['back'].'" />');                }           }           else {                $error = $_language->module['repeated_pw_not_valid'];                die('<b>ERROR: '.$error.'</b><br /><br /><input type="button" onclick="javascript:history.back()" value="'.$_language->module['back'].'" />');           }           $newmd5pwd = md5(stripslashes($pwd1));           safe_query("UPDATE ".PREFIX."user SET password='".$newmd5pwd."' WHERE userID='".$userID."'");            //logout           unset($_SESSION['ws_auth']);           unset($_SESSION['ws_lastlogin']);           session_destroy();      redirect('index.php?site=login', $_language->module['pw_changed'],3);       }                 elseif(isset($_GET['action']) AND $_GET['action']=="editmail") {            $bg1 = BG_1;           $bg2 = BG_2;     $bg3 = BG_3;           $bg4 = BG_4;           $border = BORDER;            eval("\$myprofile_editmail = \"".gettemplate("myprofile_editmail")."\";");           echo $myprofile_editmail;       }                 elseif(isset($_POST['savemail'])){            $activationkey = createkey(20);           $activationlink = 'http://'.$hp_url.'/index.php?site=register&mailkey='.$activationkey;           $pwd = $_POST['oldpwd'];           $mail1 = $_POST['mail1'];           $mail2 = $_POST['mail2'];            $ergebnis = safe_query("SELECT password, username FROM ".PREFIX."user WHERE userID='".$userID."'");           $ds = mysql_fetch_array($ergebnis);           $username = $ds['username'];           if(!(mb_strlen(trim($pwd)))) {                $error = $_language->module['forgot_old_pw'];                die('<b>ERROR: '.$error.'</b><br /><br /><input type="button" onclick="javascript:history.back()" value="'.$_language->module['back'].'" />');           }           $md5pwd = md5(stripslashes($pwd));           if($md5pwd != $ds['password']) {                die('<b>ERROR: '.$error.'</b><br /><br /><input type="button" onclick="javascript:history.back()" value="'.$_language->module['back'].'" />');           }           if($mail1 == $mail2) {                if(!(mb_strlen(trim($mail1)))) {                     $error = $_language->module['mail_not_valid'];                     die('<b>ERROR: '.$error.'</b><br /><br /><input type="button" onclick="javascript:history.back()" value="'.$_language->module['back'].'" />');                }           }           else {                $error = $_language->module['repeated_pw_not_valid'];                die('<b>ERROR: '.$error.'</b><br /><br /><input type="button" onclick="javascript:history.back()" value="'.$_language->module['back'].'" />');           }            // check e-mail                      if(!validate_email($mail1)){                 $error=$_language->module['invalid_mail'];                die('<b>ERROR: '.$error.'</b><br /><br /><input type="button" onclick="javascript:history.back()" value="'.$_language->module['back'].'" />');           }                      safe_query("UPDATE ".PREFIX."user SET email_change = '".$mail1."', email_activate = '".$activationkey."' WHERE userID='".$userID."'");            $ToEmail = $mail1;           $ToName = $username;           $header =  str_replace(Array('%homepage_url%'), Array($hp_url), $_language->module['mail_subject']);           $Message = str_replace(Array('%username%', '%activationlink%', '%pagetitle%', '%homepage_url%'), Array($username, $activationlink, $hp_title, $hp_url), $_language->module['mail_text']);            if(mail($ToEmail,$header, $Message, "From:".$admin_email."\nContent-type: text/plain; charset=utf-8\n")) echo $_language->module['mail_changed'];           else echo $_language->module['mail_failed'];       }                 else {           $ergebnis = safe_query("SELECT * FROM ".PREFIX."user WHERE userID='".$userID."'");           $anz = mysql_num_rows($ergebnis);           if($anz) {                $ds = mysql_fetch_array($ergebnis);                $flag = ''.$ds['country'].'';                $country = flags($flag);                $country = str_replace("<img","<img id='county'",$country);                $sex = '<option value="m">'.$_language->module['male'].'</option><option value="f">'.$_language->module['female'].'</option><option value="u">'.$_language->module['unknown'].'</option>';                $sex = str_replace('value="'.$ds['sex'].'"','value="'.$ds['sex'].'" selected="selected"',$sex);                if($ds['newsletter'] == "1") $newsletter = '<option value="1" selected="selected">'.$_language->module['yes'].'</option><option value="0">'.$_language->module['no'].'</option>';                else $newsletter = '<option value="1">'.$_language->module['yes'].'</option><option value="0" selected="selected">'.$_language->module['no'].'</option>';                if($ds['mailonpm'] == "1") $pm_mail = '<option value="1" selected="selected">'.$_language->module['yes'].'</option><option value="0">'.$_language->module['no'].'</option>';                else $pm_mail = '<option value="1">'.$_language->module['yes'].'</option><option value="0" selected="selected">'.$_language->module['no'].'</option>';                if($ds['email_hide']) $email_hide = ' checked="checked"';                else $email_hide = '';                $b_day = mb_substr($ds['birthday'],8,2);                $b_month = mb_substr($ds['birthday'],5,2);                $b_year = mb_substr($ds['birthday'],0,4);                $countries = str_replace(" selected=\"selected\"", "", $countries);                $countries = str_replace('value="'.$ds['country'].'"', 'value="'.$ds['country'].'" selected="selected"', $countries);                if($ds['avatar']) $viewavatar = '&#8226; <a href="javascript:MM_openBrWindow(\'images/avatars/'.$ds['avatar'].'\',\'avatar\',\'width=120,height=120\')">'.$_language->module['avatar'].'</a>';                else $viewavatar = $_language->module['avatar'];                if($ds['userpic']) $viewpic = '&#8226; <a href="javascript:MM_openBrWindow(\'images/userpics/'.$ds['userpic'].'\',\'userpic\',\'width=250,height=230\')">'.$_language->module['userpic'].'</a>';                else $viewpic = $_language->module['userpic'];                 $usertext = getinput($ds['usertext']);                $clanhistory = clearfromtags($ds['clanhistory']);                $clanname = clearfromtags($ds['clanname']);                $clantag = clearfromtags($ds['clantag']);                $clanirc = clearfromtags($ds['clanirc']);                $firstname = clearfromtags($ds['firstname']);                $lastname = clearfromtags($ds['lastname']);                $town = clearfromtags($ds['town']);                $cpu = clearfromtags($ds['cpu']);                $mainboard = clearfromtags($ds['mainboard']);                $ram = clearfromtags($ds['ram']);                $monitor = clearfromtags($ds['monitor']);                $graphiccard = clearfromtags($ds['graphiccard']);                $soundcard = clearfromtags($ds['soundcard']);                $connection = clearfromtags($ds['verbindung']);                $keyboard = clearfromtags($ds['keyboard']);                $mouse = clearfromtags($ds['mouse']);                $mousepad = clearfromtags($ds['mousepad']);                $clanhp = getinput($ds['clanhp']);                $about = getinput($ds['about']);                $nickname = $ds['nickname'];                $username = getinput($ds['username']);                $email = getinput($ds['email']);                $icq = getinput($ds['icq']);                $homepage = getinput($ds['homepage']);                $plz = getinput($ds['plz']);                $langdirs = '';                $filepath = "languages/";                                // Select all possible languages                $mysql_langs = array();                $query = safe_query("SELECT lang, language FROM ".PREFIX."news_languages");                while($dx = mysql_fetch_assoc($query)){                     $mysql_langs[$dx['lang']] = $dx['language'];                }                if($dh = opendir($filepath)) {                     while($file = mb_substr(readdir($dh), 0, 2)) {                          if($file != "." and $file!=".." and is_dir($filepath.$file)) {                               if(isset($mysql_langs[$file])){                                    $name = $mysql_langs[$file];                                    $name = ucfirst($name);                                    $langdirs .= '<option value="'.$file.'">'.$name.'</option>';                               }                               else {                                    $langdirs .= '<option value="'.$file.'">'.$file.'</option>';                               }                          }                     }                     closedir($dh);                }                                if($ds['language']) $langdirs = str_replace('"'.$ds['language'].'"', '"'.$ds['language'].'" selected="selected"', $langdirs);                else $langdirs = str_replace('"'.$_language->language.'"', '"'.$_language->language.'" selected="selected"', $langdirs);                                $bg1 = BG_1;                $bg2 = BG_2;                $bg3 = BG_3;                $bg4 = BG_4;                 eval("\$myprofile = \"".gettemplate("myprofile")."\";");                echo $myprofile;            }           else echo $_language->module['not_logged_in'];      } } ?>

myfarynet.eu  offline
Forumrang: GT Süchtig
registered: 22.01.2009
252 Posts
26.06.2010, 21:44, U homepage
quote 
Suche nach:

Code:
1.
safe_query("UPDATE `".PREFIX."user` SET nickname='".$nickname."',   username='".$usernamenew."',   email_hide='".$mail_hide."',   firstname='".$firstname."', lastname='".$lastname."', sex='".$sex."', country='".$flag."', town='".$town."', birthday='".$birthday."', icq='".$icq."', usertext='".$usertext."', clantag='".$clantag."', clanname='".$clanname."', clanhp='".$clanhp."', clanirc='".$clanirc."', clanhistory='".$clanhistory."', cpu='".$cpu."', mainboard='".$mainboard."', ram='".$ram."', monitor='".$monitor."', graphiccard='".$graphiccard."', soundcard='".$soundcard."', verbindung='".$connection."', keyboard='".$keyboard."', mouse='".$mouse."', mousepad='".$mousepad."', mailonpm='".$pm_mail."', newsletter='".$newsletter."', homepage='".$homepage."', about='".$about."', language='".$language."', plz='".$plz."' WHERE userID='".$id."'");


ersetz das mit:

Code:
1.
safe_query("UPDATE `".PREFIX."user` SET nickname='".$nickname."',   username='".$usernamenew."',   email_hide='".$mail_hide."',   firstname='".$firstname."', lastname='".$lastname."', sex='".$sex."', country='".$flag."', town='".$town."', birthday='".$birthday."', icq='".$icq."', usertext='".$usertext."', clantag='".$clantag."', clanname='".$clanname."', clanhp='".$clanhp."', clanirc='".$clanirc."', clanhistory='".$clanhistory."', cpu='".$cpu."', mainboard='".$mainboard."', ram='".$ram."', monitor='".$monitor."', graphiccard='".$graphiccard."', soundcard='".$soundcard."', verbindung='".$connection."', keyboard='".$keyboard."', mouse='".$mouse."', mousepad='".$mousepad."', mailonpm='".$pm_mail."', newsletter='".$newsletter."', homepage='".$homepage."', about='".$about."', language='".$language."' plz='".$plz."' WHERE userID='".$id."'");

xnat0rx  offline
Forumrang: Plappermaul
registered: 01.11.2009
10 Posts
26.06.2010, 21:51, U
quote 
Das ist doch genau das gleiche? amused

Habe es hinbekommen. Webspell einfach neu hochgeladen!Danke!

myfarynet.eu  offline
Forumrang: GT Süchtig
registered: 22.01.2009
252 Posts
26.06.2010, 22:46, U homepage
quote 
Nein ist nicht das gleiche smiling

dort fehlt ein , im UPDATE Query smiling

Sort:     printview


To start or to reply to a topic you have to be registered and logged in!

register now
login
All Showrooms

n/a
by: n/a
Views: n/a
 
Posts: n/a
 
Last post by: n/a
 
 
 
All Topics
DZCP Installation schläg... | 6
Fragen zum DZCP
DZCP Installation schlägt dauernt fehl
Author: astk15
Last post: Lanacs
Board: Fragen zum DZCP
Catagorie: DZCP - Alles zu dem CMS DZCP
11.04.2018 - 18:28
Besucherzähler zählt jed... | 3
Fragen
Besucherzähler zählt jeden Homepage klick nicht jeden besucher
Author: astk15
Last post: Daeem
Board: Fragen
Catagorie: Allgemein - Alles Allgemein
05.04.2018 - 19:11
DZCP 1.6 Template | 29
DZCP Template Support
DZCP 1.6 Template
Author: exxs
Last post: Daeem
Board: DZCP Template Support
Catagorie: DZCP - Alles zu dem CMS DZCP
30.03.2018 - 13:06
DZCP und GT_DZCP_v1.5.5.... | 4
DZCP Template Support
DZCP und GT_DZCP_v1.5.5.2_10
Author: astk15
Last post: Daeem
Board: DZCP Template Support
Catagorie: DZCP - Alles zu dem CMS DZCP
16.03.2018 - 19:37
möcht mich mal vorstelle... | 2
Spambereich
möcht mich mal vorstellen
Author: Gyzmou
Last post: Gyzmou
Board: Spambereich
Catagorie: Allgemein - Alles Allgemein
20.12.2017 - 07:51
Fehler in der Mysql Date... | 1
DZCP Template Support
Fehler in der Mysql Datenbank?
Author: faine1312
Last post: Daeem
Board: DZCP Template Support
Catagorie: DZCP - Alles zu dem CMS DZCP
13.10.2017 - 18:11
Latest registered users | 0
DZCP Template Support
Latest registered users
Author: demiro86
Last post: demiro86
Board: DZCP Template Support
Catagorie: DZCP - Alles zu dem CMS DZCP
25.06.2017 - 19:32
All News
Wahnsinns kostenloses Clan...
Date: 29.07.2013     Comments: 5
Ein neues DZCP Free Templa...
Date: 26.01.2013     Comments: 7
Fröhliche Weihnachten und ...
Date: 24.12.2012     Comments: 5
Ein neues DZCP Free Templa...
Date: 15.10.2012     Comments: 4
Gewinne ein Headset im wer...
Date: 11.10.2012     Comments: 2
 
 
 
 
FORUM
IMAGEHOSTER
SUPPORT
LIZENZEN
 
 
 
 
777
1291
3217193
34407
0
39
8
248601