Gender Mod

[Whyti]

Beste mensen,

Ik heb ook een probleempje in mijn gender mod.

Ik heb alles gedaan wat er stond. Wanneer ik dan naar m'n eigen profiel ga krijg ik deze fout.

Code: Selecteer alles

Parse error: parse error, unexpected ',' in /home/virtual/site313/fst/var/www/html/forum/includes/usercp_register.php on line 456

Dit is het stukje uit regel 456 waar het om draait.

Code: Selecteer alles

 "'" . $avatar_sql , user_gender=$gender"

Het moet iets zijn met die punten en komma's want die instructie vond ik nogal onduidelijk.

Misschien dat iemand me zou kunnen helpen.
Bij voorbaat dank!

[Luuk]

PLaats die hele regel eens.

[Whyti]

Ik heb ondertussen nog wat zitten prutsen, dus hij is al stukje anders. Maar krijg dezelfde fout.

Je moet maar even kijken.. Misschien dat iemand gewoon de hele zin kan geven hoe die moet.

Code: Selecteer alles

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_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) . "'" , user_gender=$gender . $avatar_sql  . "

Das een aardig lang zinnetje
Wat ik er bij heb moeten zetten staat helemaal achteraan!

[Luuk]

Probeer eens:

Code: Selecteer alles

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_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) . "', user_gender = $gender, " . $avatar_sql . "

[Whyti]

Je bent geweldig!

Er komt nu wel een andere fout als ik mn geslacht invul, in dat zelfde bestand, maar dat moet ik nog even uitzoeken..

Misschien dat ik die morgen wel post dan

Bedankt

[Whyti]

Op de een of andere vreemde manier, kom ik echt overal fouten tegen.

Ik snap hier de fout niet van hoor:

Code: Selecteer alles

Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'WHERE user_id = 2' at line 3

En dan t hele profiel wat die wil updaten. Het probleem zit m in regel 460 van het bestand van gister.

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_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) . "', user_gender = $gender, " . $avatar_sql . "
				WHERE user_id = $user_id";
			if ( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
			}

			if ( !$user_active )
			{

Ik vind t raaaar!

Misschien iemand die zo goed hier in is, dat die in dit zootje zelfs de fout kan ontdekken..

[Luuk]

Vervang in dat stuk

Code: Selecteer alles

user_gender = $gender, " . $avatar_sql . " 

Met

Code: Selecteer alles

user_gender = $gender" . $avatar_sql . "