Ok, stopniowo poradziłem se z problemem, ale co jest teraz źle? Zobaczcie, gdy edytuję usera by nadać mu daną range wyskakuje mi błąd:
Kod:
Admin_user_fail
DEBUG MODE
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 'WHERE user_id = 2' at line 3
UPDATE phpbb_users SET user_email = 'filu95@vp.pl', user_icq = '', user_website = 'http://filu.yoyo.pl', user_occ = '', user_from = 'Dębica', user_interests = '', user_sig = '[size=9:cab8fa8926][b:cab8fa8926][color=blue:cab8fa8926]Nie pomagam na PW, GG. Pytaj na forum![/color:cab8fa8926] [url=http://filu.yoyo.pl][color=red:cab8fa8926]Support[/color:cab8fa8926][/url] ~ phpBB by Filu. [url=http://www.filu.yoyo.pl/forum/profile.php?mode=register&sid=16f31dd62035834d462603c3da9438a4][color=red:cab8fa8926]Rejestracja[/color:cab8fa8926][/url] ~ w supporcie.[/b:cab8fa8926][/size:cab8fa8926]', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_sig_bbcode_uid = 'cab8fa8926', user_allowsmile = 1, user_allowhtml = 0, user_allowavatar = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_allow_pm = 1, user_notify_pm = 1, user_popup_pm = 1, user_lang = 'polish', user_style = 1, user_timezone = 0, user_dateformat = 'd M Y h:i a', user_active = 1, user_rank = 5, user_urank WHERE user_id = 2
Line : 710
File : admin_users.php
oraz cos z vievforum:
Kod:
Could not obtain topic information
DEBUG MODE
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 ' u.user_rank, u2.user_posts as posts2, u2.user_rank as rank2 p.post_username FR' at line 1
SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time,, u.user_rank, u2.user_posts as posts2, u2.user_rank as rank2 p.post_username FROM phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_users u2 WHERE t.forum_id = 1 AND t.topic_poster = u.user_id AND p.post_id = t.topic_last_post_id AND p.poster_id = u2.user_id AND t.topic_type = 2 ORDER BY t.topic_last_post_id DESC
Line : 297
File : viewforum.php