brauch mal hilfe
wenn ich das mache
suche nach:
---
signature='".addslashes($signature)."',
---
füge DANACH ein:
---
diebgameblock='".intval($diebgameblock)."'
kommt das hier
wenn ich ein use bearbeite und im ACP speicher
Database error in WoltLab Burning Board (2.3.2): Invalid SQL: UPDATE bb1_users SET username='blocParty',email='gh_phoenix@gmx.de',groupcombinationid='4',ranki
d='4',title='',usertext='',lebenslauf='testghlljjjjjj',diebgameblock='1' signature='',disablesignature='0',icq='0',aim='',yim='',msn='',homepage='',
birthday='0000-00-00',gender='0',showemail='1',admincanemail='1',usercanema
il='1',invisible='0',usecookies='1',styleid='0',daysprune='0',timezoneoffse
t='1',startweek='1',dateformat='d.m.Y',timeformat='H:i',emailnotify='0',not
ificationperpm='0',receivepm='1',emailonpm='1',pmpopup='1',emailonapplicati
on='0',umaxposts='0',showsignatures='1',showavatars='1',showimages='1', blocked='0', avatarid = '0', threadview='0', rankgroupid='4', useronlinegroupid='4', allowsigsmilies='0', allowsightml='0', allowsigbbcode='0', allowsigimages='0', langid='0', usewysiwyg = '0' WHERE userid='2171'
mysql 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 'signature='',disablesignature='0',icq='0',aim='',yim='',msn='',
wie muss da ausehen
code: |
1:
2:
3:
4:
|
// update user
$db->unbuffered_query("UPDATE bb".$n."_users SET username='".addslashes($username)."',email='".addslashes($email)."',groupcombinationid='".$groupcombinationid."',rankid='".$rankid['rankid']."',title='".addslashes($title)."',usertext='".addslashes($usertext)."',lebenslauf='".addslashes($lebenslauf)."',diebgameblock='".intval($diebgameblock)."'
signature='".addslashes($signature)."',disablesignature='".intval($disablesignature)."',icq='".intval($icq)."',aim='".addslashes($aim)."',yim='".addslashes($yim)."',msn='".addslashes($msn)."',homepage='".addslashes($homepage)."',birthday='".addslashes($birthday)."',gender='".intval($gender)."',showemail='".intval($showemail)."',admincanemail='".intval($admincanemail)."',usercanemail='".intval($usercanemail)."',invisible='".intval($invisible)."',usecookies='".intval($usecookies)."',styleid='".intval($styleid)."',daysprune='".intval($daysprune)."',timezoneoffset='".addslashes($timezoneoffset)."',startweek='".intval($startweek)."',dateformat='".addslashes($udateformat)."',timeformat='".addslashes($utimeformat)."',emailnotify='".intval($emailnotify)."',notificationperpm='".intval($notificationperpm)."',receivepm='".intval($receivepm)."',emailonpm='".intval($emailonpm)."',pmpopup='".intval($pmpopup)."',emailonapplication='".intval($emailonapplication)."',umaxposts='".intval($umaxposts)."',showsignatures='".intval($showsignatures)."',showavatars='".intval($showavatars)."',showimages='".intval($showimages)."', blocked='".intval($blocked)."', avatarid = '".intval($avatarid)."', threadview='".intval($threadview)."', rankgroupid='".intval($rankgroupid)."', useronlinegroupid='".intval($useronlinegroupid)."', allowsigsmilies='".$allowsmilies."', allowsightml='".$allowhtml."', allowsigbbcode='".$allowbbcode."', allowsigimages='".$allowimages."', langid='".intval($langid)."', usewysiwyg = '".$usewysiwyg."' WHERE userid='$userid'", 1);
if ($fieldvalues) $db->unbuffered_query("UPDATE bb".$n."_userfields SET $fieldvalues WHERE userid='$userid'", 1); |
|
wenn ich das weg lasse gehts