phpBB.nl

Code: Selecteer alles

Couldn't access list of unread posts from forums

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 '/-- fin mod : keep unread -------------------------------------

SELECT p.forum_id, p.topic_id, p.post_time, p.post_username, u.username, u.user_id, t.topic_last_post_id, t.topic_title FROM phpbb_posts p, phpbb_topics t, phpbb_users u WHERE ( p.post_time > 1077870617 OR p.post_id IN (1) ) //-- fin mod : keep unread ------------------------------------------------------------------------- AND p.post_id = t.topic_last_post_id AND t.topic_id = p.topic_id AND t.forum_id = p.forum_id AND t.topic_moved_id = 0 AND u.user_id = p.poster_id

Line : 253
File : D:\Server\forum\includes\functions_categories_hierarchy.php
 

Code: Selecteer alles

				if ( $key != "$nkey" )
				{
					$tree['data'][$idx][$key] = $row[$key];
				}
			}
		}
	}

//-- mod : keep unread -----------------------------------------------------------------------------
//-- add
	// update the unread topics from the list readed
	$board_config['tracking_unreads'] = $new_unreads;

	// except the cookies
	write_cookies($userdata);
//-- fin mod : keep unread -------------------------------------------------------------------------

	// set the unread flag
	$tree['unread_topics'] = array();
	for ($i=0; $i < count($tree['data']); $i++)
	{

Code: Selecteer alles

//-- mod : keep unread -----------------------------------------------------------------------------
// here we added
//	 $sql_unreads
//-- modify
	$sql = "SELECT p.forum_id, p.topic_id, p.post_time, p.post_username, u.username, u.user_id, t.topic_last_post_id, t.topic_title
				FROM " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u
				WHERE ( p.post_time > $user_lastvisit $sql_last_posts $sql_unreads )
					//-- fin mod : keep unread -------------------------------------------------------------------------
						AND p.post_id = t.topic_last_post_id
						AND t.topic_id = p.topic_id AND t.forum_id = p.forum_id AND t.topic_moved_id = 0
						AND u.user_id = p.poster_id";
	if ( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, 'Couldn\'t access list of unread posts from forums', '', __LINE__, __FILE__, $sql);
	}
	$new_topic_data = array();
	while ($row = $db->sql_fetchrow($result))
	{