Problem mit Wettermod

[frank1606]

Hallo

ich habe den o.g. Mod eingebaut.
Bei mir funktioniert er einwandfrei.
Nur meine Mitglieder sagen mir das sie diese Fehlermeldung bekommen.

Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' user_plz = 'Reptilien, Frettchen, PC und Internet', '64289', user_birthday = '-' at line 2
...
...

Line : 531
File : /www/htdocs/xxx/phpbb2/includes/usercp_register.php
Was hab ich falsch gemacht.?
Das db_update_wetter_addon.php habe ich Erfolgreich ausgefürt

[Andy120]

hi...

poste doch mal die Zeile 530 - 540 von der usercp_register.php....

[frank1606]

hier die zeilen

{
$user_active = 1;
$user_actkey = '';
}

$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, user_plz = '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $plz) . "', user_plz = '", 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_blending = $blending
, 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)) )
{
message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
}

if ( !$user_active )
{
//
// The users account has been deactivated, send them an email with a new activation key
//
include($phpbb_root_path . 'includes/emailer.'.$phpEx);
$emailer = new emailer($board_config['smtp_delivery']);

[Andy120]

Suche:

Code: Alles auswählen

, '" . str_replace("\'", "''", $plz) . "', user_plz = '",

Ersetze:

Code: Alles auswählen

, user_plz = '" . str_replace("\'", "''", $plz) . "',

So wies aussieht hast du etwas verwechselt

[frank1606]

Es geht immer noch nicht.

$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) . "' . str_replace("\'", "''", $interests) . "', user_plz = '" . str_replace("\'", "''", $plz) . "', 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_blending = $blending
, 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)) )

Bekomme nun diese meldung
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /www/htdocs/xxx/phpbb2/includes/usercp_register.php on line 526

[Andy120]

Verlinke doch bitte mal deine ganze Datei als Text - Datei...

[frank1606]

Hier der ganze Text

http://www.mitglied.lycos.de/collaris/u ... gister.txt

[Andy120]

Versuche es mal mit dieser:

www.habbofanclub.com/downloads/usercp_register.zip

[frank1606]

Immer noch dieser Fehler
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /www/htdocs/xxx/phpbb2/includes/usercp_register.php on line 526

[Markus67]

Hi ...

damit sollte es passen ...

Code: Alles auswählen

				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_plz = '" . str_replace("\'", "''", $plz) . "', 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_blending = $blending, 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";

Markus