Sida 2 av 3

Postat: 2005-06-16 11:01
av Holger
Om du laddade upp filerna som du backade upp innan hacket så borde detta inte finnas i usercp_register.php

/Holger

Postat: 2005-06-16 11:03
av Tumbo
Holger skrev:Om du laddade upp filerna som du backade upp innan hacket så borde detta inte finnas i usercp_register.php

/Holger
Jo det tyckte jag var konstigt också. Slalvigt av mig kanske. Men det e ok om jag tar bort den raden då?

Postat: 2005-06-16 11:09
av Holger
Bäst vore om du tar bort allt som har med country-hacket att göra ...

Postat: 2005-06-16 14:57
av Tumbo
Okej, tog bort allt som har med country-hacket att göra.

Laddade upp filerna igen och fick följande fel:

När jag valde gender i min profile, till "male" och tryckte på Submit fick jag:

Kod: Markera allt

Could not update users table

DEBUG MODE

SQL Error : -1 ERROR: column "user_gender" of relation "phpbb_users" does not exist

UPDATE phpbb_users SET user_email = 'audiholic@bredband.net', user_icq = '', user_website = 'http://www.euro-rap.com', user_occ = 'Athlete/student', user_from = 'Sweden', user_interests = 'Music, Sports, Cars, Simpsons...', user_sig = '
[img:687a2d5d2a]http://home.bip.net/p.sz/boardlogo.jpg[/img:687a2d5d2a] [b:687a2d5d2a][size=11:687a2d5d2a]\"Tumbo\", the moderator and creator of [url=http://www.euro-rap.com]T-Music[/url][/size:687a2d5d2a][/b:687a2d5d2a]
', user_sig_bbcode_uid = '687a2d5d2a', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = 'audiholic@hotmail.com', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 0, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 2, user_dateformat = 'd M Y h:i a', user_lang = 'english', user_style = 7, user_active = 1, user_actkey = '', user_gender = '1', user_country = 'nospec' WHERE user_id = 2

Line : 544
File : usercp_register.php
Sen när jag skulle titta på en topic:

Kod: Markera allt

Could not obtain post/user information.

DEBUG MODE

SQL Error : -1 ERROR: column u.user_gender does not exist

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_allow_viewonline, u.user_session_time, u.user_gender, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 2761 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 20

Line : 398
File : viewtopic.php

Postat: 2005-06-16 15:10
av Holger
Har du kört databas-skriptet?

Postat: 2005-06-16 15:13
av Tumbo
Holger skrev:Har du kört databas-skriptet?
Det här jag gjort ja. Fler gånger:
# This MOD need a database update.
# Then, as you must have now copied the gender_db_update.php file
# in your phpBB root directory, run it with your navigator...
# http://www.yourWebSite.xxx/phpbbRootDir ... update.php
#
# ...and then delete it from the phpBB root directory!!!
#
# Please, do it NOW! Before editing phpBB files by EM or manually!!!
# Otherwise, you may have an error message during your next
# connection.

Postat: 2005-06-16 16:02
av Holger
Du har fortfarande user_country någonstans i usercp_register.php!

Postat: 2005-06-16 16:05
av Tumbo
Holger skrev:Du har fortfarande user_country någonstans i usercp_register.php!
Men jag söker igenom hela usercp_register.php efter "user_country" eller "country". Den hittar inget!

Postat: 2005-06-16 16:13
av Holger
Could not update users table

DEBUG MODE

SQL Error : -1 ERROR: column "user_gender" of relation "phpbb_users" does not exist

UPDATE phpbb_users SET user_email = 'audiholic@bredband.net', user_icq = '', user_website = 'http://www.euro-rap.com', user_occ = 'Athlete/student', user_from = 'Sweden', user_interests = 'Music, Sports, Cars, Simpsons...', user_sig = '
[img:687a2d5d2a]http://home.bip.net/p.sz/boardlogo.jpg[/img:687a2d5d2a] [b:687a2d5d2a]\"Tumbo\", the moderator and creator of T-Music[/size:687a2d5d2a][/b:687a2d5d2a]
', user_sig_bbcode_uid = '687a2d5d2a', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = 'audiholic@hotmail.com', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 0, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 2, user_dateformat = 'd M Y h:i a', user_lang = 'english', user_style = 7, user_active = 1, user_actkey = '', user_gender = '1', user_country = 'nospec' WHERE user_id = 2

Line : 544
File : usercp_register.php

Postat: 2005-06-16 16:14
av Holger
Sök efter

Kod: Markera allt

				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) . "'" . $avatar_sql . ", user_gender = '$gender', user_country = '" . str_replace("\'", "''", $user_country) . "'

Postat: 2005-06-16 16:18
av Tumbo
Jo jag vet! Men jag har sökt igenom hela usercp_register och min dator hittar inget genom sökmetoden.

Har sökt efter "country", "user_country", "COUNTRY".... Den hittar inget!

Postat: 2005-06-16 16:20
av Tumbo
Holger skrev:Sök efter

Kod: Markera allt

				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) . "'" . $avatar_sql . ", user_gender = '$gender', user_country = '" . str_replace("\'", "''", $user_country) . "'
Den hittar inget. PM'ar filen till dig.

Postat: 2005-06-16 16:21
av Holger
Då kanske du inte har laddat upp den?

Postat: 2005-06-16 16:22
av Tumbo
Holger skrev:Då kanske du inte har laddat upp den?
Jodå. Laddade ner filen från min ftp precis och sökte igenom den. Inget där heller :?

Postat: 2005-06-16 16:24
av Holger
I filen du just PMade vimlar det COUNTRY.