#
#-----[ OPEN ]----------------------------------------------------------------
#
profilcp_home_last_topics.php
#
#-----[ FIND ]----------------------------------------------------------------
#
AND p2.post_time >= $topics_last_floor
$limit_topics_time
ORDER BY t.topic_type DESC, p2.post_time DESC";
#
#-----[ REPLACE WITH ]--------------------------------------------------------
#
ORDER BY t.topic_type DESC, p2.post_time DESC LIMIT 10";
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------------
#
# EoM
...
AND t.topic_poster = u.user_id
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND u2.user_id = p2.poster_id
//AND p2.post_time >= $topics_last_floor
//$limit_topics_time
//ORDER BY t.topic_type DESC, p2.post_time DESC";
ORDER BY t.topic_type DESC, p2.post_time DESC LIMIT 10";
if ( !$result = $db->sql_query($sql) )
...
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time, f.forum_name
FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2, " . FORUMS_TABLE . " f
WHERE t.forum_id IN ($s_forum_ids)
AND f.forum_id = t.forum_id
AND t.topic_poster = u.user_id
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND u2.user_id = p2.poster_id
ORDER BY t.topic_type DESC, p2.post_time DESC
LIMIT 10";
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time, f.forum_name FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2, " . FORUMS_TABLE . " f WHERE t.forum_id IN ($s_forum_ids) AND f.forum_id = t.forum_id AND t.topic_poster = u.user_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id ORDER BY t.topic_type DESC, p2.post_time DESC LIMIT 10";
Could not query watched topics 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 'LIMIT 0, 10' at line 10
SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time, f.forum_name FROM topics t, users u, posts p, posts p2, users u2, forums f WHERE t.forum_id IN (1) AND f.forum_id = t.forum_id AND t.topic_poster = u.user_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id ORDER BY t.topic_type DESC, p2.post_time DESC LIMIT 10 LIMIT 0, 10
Line : 153
File : profilcp_home_last_topics.php
Mitglieder in diesem Forum: 0 Mitglieder und 1 Gast