Forums / Cotonti / General / [4 admin cotonti] User pages / User posts at Cotonti.com

On this site

Trustmaster
#23536 2010-03-14 23:56
Yes, it's fixed in SVN but hasn't been fixed here yet. Find the SQL near line 50 in userlatestposts.php and replace it with:
$sqluserlatestposts = sed_sql_query("SELECT p.fp_id, p.fp_updated, t.ft_title, t.ft_id, s.fs_id, s.fs_title, s.fs_category
	FROM $db_forum_posts AS p
		LEFT JOIN $db_forum_topics AS t ON p.fp_topicid=t.ft_id
			LEFT JOIN $db_forum_sections AS s ON p.fp_sectionid=s.fs_id
	WHERE fp_posterid={$urr['user_id']}
	GROUP BY t.ft_id
	ORDER BY fp_updated DESC
	LIMIT $df, ".$cfg['plugin']['userlatestposts']['countonpage']);
The same query is used in userlatestposts.ajax.php near line 58.
May the Source be with you!