Pagina 1 van 1
Birthdayhack, waar zit de fout?
Geplaatst: 02 mar 2005, 14:32
door Eefjuh
Code: Selecteer alles
[color=red]$sql = "UPDATE " . USERS_TABLE . "SET . [/color]$username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) ."', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests), user_birthday = '$birthday', user_next_birthday_greeting = '$next_birthday_greeting' . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popup_pm, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql. ", user_gender = '$gender'
WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )
{
Bij het rode word d fout angegeven maar wat is er fout gegaan?
Geplaatst: 02 mar 2005, 14:33
door Bee
Mogen we de foutmelding? En heb je al in het topic hieronder gekeken, wat bijna over hetzelfde gaat
Geplaatst: 02 mar 2005, 14:39
door Eefjuh
foutmelding?
Parse error: parse error, unexpected ',' in /home/eefjuh/public_html/forum/includes/usercp_register.php on line 586
Geplaatst: 02 mar 2005, 14:44
door Eefjuh
*foute zinnetje opsporen*
Geplaatst: 02 mar 2005, 14:47
door Bee
Er ontbreekt een stuk van je code. Kan je deze in een tekstbestand plaatsen, of beter nog, alleen 5 regels ervoor tot 5 regels na de regel posten.
Geplaatst: 02 mar 2005, 15:41
door Eefjuh
jah me code? welke code? het staat er nu zoals het er eerst stond.
Code: Selecteer alles
#-----[ FIND ]------------------------------------------------
#
$sql = "UPDATE " . USERS_TABLE . "
SET
#
#-----[ IN-LINE FIND ]----------------------------------------
#
str_replace("\'", "''", $interests) . "'
#
#-----[ IN-LINE AFTER, ADD ]----------------------------------
#
, user_birthday='$birthday', user_next_birthday_greeting=$next_birthday_greeting
En zo staat het nu:
Code: Selecteer alles
//
// Update entry in DB
//
if( !$error )
{
$sql = "UPDATE " . USERS_TABLE . "
SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) . "', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests), user_birthday='$birthday', user_next_birthday_greeting=$next_birthday_greeting . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active = $user_status, user_rank = $user_rank, user_gender = '$gender'" . $avatar_sql . "
WHERE user_id = $user_id";
if( $result = $db->sql_query($sql) )
{
if( isset($rename_user) )
{
Ik snpa het niet een fout zit er niet maar in kladblok geeft ie als het ware 2 overelkaargeschreven zinen aan in dit stukje:
USERS_TABLE . "
SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) . "',
Geplaatst: 02 mar 2005, 15:47
door Eefjuh
Oja daarbij is ook nog me wie is online *beep*:
http://www.birdplanet.nl/forum/index.php
Ziet dr niet meer uit hoe verander ik dit weer terug?!?!?!?!
Geplaatst: 02 mar 2005, 15:47
door Stef
Code: Selecteer alles
'" . str_replace("\'", "''", $interests), user_birthday='$birthday', user_next_birthday_greeting=$next_birthday_greeting . "', user_sig = '" .
Dit klopt overigens ook niet, maak daar eens dit van:
Code: Selecteer alles
'" . str_replace("\'", "''", $interests) . "', user_birthday='$birthday', user_next_birthday_greeting=$next_birthday_greeting, user_sig = '" .
Geplaatst: 02 mar 2005, 15:56
door Eefjuh
Gedaan maar me probleem ligt nu nog in:
Parse error: parse error, unexpected ',' in /home/eefjuh/public_html/forum/admin/admin_users.php on line 712
Die staat waar me adminpaneel hoort:
Code: Selecteer alles
$sql = "UPDATE " . USERS_TABLE . "
SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) . "', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests), user_birthday='$birthday', user_next_birthday_greeting=$next_birthday_greeting . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active = $user_status, user_rank = $user_rank, user_gender = '$gender'" . $avatar_sql . "
WHERE user_id = $user_id";
Daar gaat iets mis..
Geplaatst: 02 mar 2005, 15:57
door Stef
Zelfde fout, als hierboven.
Geplaatst: 02 mar 2005, 15:59
door Eefjuh
Jah zag k dus ook nu
Dat klopt nu weer helemaal maar hoe kjomt me wie is online nou weer goed?!
Geplaatst: 02 mar 2005, 16:00
door Paul
Je moet de rowspan eentje omhoog doen daar
Geplaatst: 02 mar 2005, 16:02
door Eefjuh
waar is daar?
Geplaatst: 02 mar 2005, 16:05
door Bee
index_body.tpl
Geplaatst: 02 mar 2005, 19:06
door Eefjuh
Er is nog veel meer aan de hand, in m'n profiel stond ie weer op jungle, wil het terugzetten naar Bird Planet krijg ik dit: SQL Error : 1064 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 ' user_sig = '[url=
http://www.knavivo.nl][img:782f7e8796]http://
UPDATE phpbb_users SET user_email = '
webmaster@knavivo.nl
*beep* problemen blijven!
Daarbij wil die SQL nog STEEDS niet lukken
Geplaatst: 02 mar 2005, 19:29
door Bee
Vraag hem om de volledige foutmelding, deze is niet volledig.