phpBB.de

Code: Alles auswählen

Parse error: parse error, unexpected T_VARIABLE in /home/vhosts/5000128608/cheating4free.de/htdocs/he/viewtopic.php on line 83

Code: Alles auswählen

$sql = "SELECT p.post_id
					FROM " . POSTS_TABLE . " p, " . SESSIONS_TABLE . " s,  " . USERS_TABLE . " u
					WHERE s.session_id = '$session_id'
						AND u.user_id = s.session_user_id
						AND p.topic_id = $topic_id
						AND p.post_time >= u.user_lastvisit
					ORDER BY p.post_time ASC";
					LIMIT $start, ".$board_config['posts_per_page'];

Code: Alles auswählen

$sql = "SELECT p.post_id
					FROM " . POSTS_TABLE . " p, " . SESSIONS_TABLE . " s,  " . USERS_TABLE . " u
					WHERE s.session_id = '$session_id'
						AND u.user_id = s.session_user_id
						AND p.topic_id = $topic_id
						AND p.post_time >= u.user_lastvisit
					ORDER BY p.post_time ASC
					LIMIT $start, ".$board_config['posts_per_page'];

Code: Alles auswählen

Could not obtain post/user 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 'ASC LIMIT 0, 20' at line 7

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_from_flag, 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_warnings, u.user_level, u.user_allow_viewonline, u.user_session_time, 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 = 18 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC ASC LIMIT 0, 20

Line : 504
File : /home/vhosts/5000128608/cheating4free.de/htdocs/he/viewtopic.php

Code: Alles auswählen

ORDER BY p.post_time $post_time_order $post_time_order
	LIMIT $start, ".$board_config['posts_per_page']";

Code: Alles auswählen

ORDER BY p.post_time $post_time_order
	LIMIT $start, ".$board_config['posts_per_page']";