Teampage

[Isyan]

Hallo,

ich hab mir diesen MOD installiert und folgende änderung nicht durchgenommen, weil durch diese änderung eine Fehlermeldung immer erscheint:

Code: Alles auswählen

#-----[ FIND ]------------------------------------------ 
#
			$sql = "UPDATE " . USERS_TABLE . "
				SET " . $username_sql . $passwd_sql

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
#
str_replace("\'", "''", $user_actkey) . "'

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
, user_realname = '" . str_replace("\'", "''", $realname) . "', user_adress = '" . str_replace("\'", "''", $adress) . "', user_birth = '$birth', user_photo = '" . str_replace("\'", "''", $photo) . "', user_slogan = '" . str_replace("\'", "''", $slogan) . "', user_topt_title = '" . str_replace("\'", "''", $opt_title) . "', user_topt_text = '" . str_replace("\'", "''", $opt_text) . "', user_teamdesc_title = '$team_desc', user_teamtext = '$team_text', team_website = '$team_website', team_email = '$team_email', team_pm = '$team_pm'

hier ist meine usercp_register.php

Gruß

[Markus67]

Hi ...

wie lautet denn die Fehlermeldung?

Markus

[Isyan]

Zeile 678 ist die Stelle, in der ich dannach die Code einfügen soll

davor:

Code: Alles auswählen

                                $user_actkey = gen_rand_string(true);
                                $key_len = 54 - (strlen($server_url));
                                $key_len = ( $key_len > 6 ) ? $key_len : 6;
                                $user_actkey = substr($user_actkey, 0, $key_len);
                                $sql .= "0, '" . str_replace("\'", "''", $user_actkey) . "')";
                        }
                        else
                        {

danach:

Code: Alles auswählen

                                $user_actkey = gen_rand_string(true);
                                $key_len = 54 - (strlen($server_url));
                                $key_len = ( $key_len > 6 ) ? $key_len : 6;
                                $user_actkey = substr($user_actkey, 0, $key_len);
                                $sql .= "0, '" . str_replace("\'", "''", $user_actkey) . "', user_realname = '" . str_replace("\'", "''", $realname) . "', user_adress = '" . str_replace("\'", "''", $adress) . "', user_birth = '$birth', user_photo = '" . str_replace("\'", "''", $photo) . "', user_slogan = '" . str_replace("\'", "''", $slogan) . "', user_topt_title = '" . str_replace("\'", "''", $opt_title) . "', user_topt_text = '" . str_replace("\'", "''", $opt_text) . "', user_teamdesc_title = '$team_desc', user_teamtext = '$team_text', team_website = '$team_website', team_email = '$team_email', team_pm = '$team_pm')";
                        }
                        else
                        {

Sobald ich diese änderung durchnehme erscheint diese Fehlermeldung:

Warning: include(./includes/usercp_register.php) [function.include]: failed to open stream: No such file or directory in /usr/export/www/hosting/atowndesigns/forum/profile.php on line 93

Warning: include() [function.include]: Failed opening './includes/usercp_register.php' for inclusion (include_path='.:') in /usr/export/www/hosting/atowndesigns/forum/profile.php on line 93

Zeile 93 von profile.php

Code: Alles auswählen

        {
                if ( !$userdata['session_logged_in'] && $mode == 'editprofile' )
                {
                        redirect(append_sid("login.$phpEx?redirect=profile.$phpEx&mode=editprofile", true));
                }

                include($phpbb_root_path . 'includes/usercp_register.'.$phpEx);
                exit;
        }

include($phpbb_....

[Markus67]

Hi ...

da stimmt was nicht ganz in der usercp_register.php

suche:

Code: Alles auswählen

                        $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 = '$user_actkey'" . $avatar_sql . "

ersetze mit:

Code: Alles auswählen

	 		                  $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_realname = '" . str_replace("\'", "''", $realname) . "', user_adress = '" . str_replace("\'", "''", $adress) . "', user_birth = '$birth', user_photo = '" . str_replace("\'", "''", $photo) . "', user_slogan = '" . str_replace("\'", "''", $slogan) . "', user_topt_title = '" . str_replace("\'", "''", $opt_title) . "', user_topt_text = '" . str_replace("\'", "''", $opt_text) . "', user_teamdesc_title = '$team_desc', user_teamtext = '$team_text', team_website = '$team_website', team_email = '$team_email', team_pm = '$team_pm'" . $avatar_sql . "

Jetzt sollte es passen

Markus

[Isyan]

Hallo Markus,

danke jetzt funktionierts... kannst du mir sagen woran es lag?

Gruß

[Markus67]

Hallo Markus,

danke jetzt funktionierts... kannst du mir sagen woran es lag?

Gruß

Ziemlich am Ende der Zeile war was faul. Kopiere doch einfach meine geänderte Zeile unter deine alte .... dann siehst du den Fehler.

Durch den Fehler hast du auch nicht die richtige Zeile gefunden ... daher dann die Fehlermeldung

Markus