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

foxhound

Vr, 26 Mrt 2010 17:07:02 -0000

# Alex300 : Here working Bug Fix:

Find the SQL near line 34 in userlatestposts.php and replace it with:
$totalitems = sed_sql_result(sed_sql_query("SELECT COUNT(*) FROM $db_forum_posts WHERE fp_posterid=".$urr['user_id']), 0, 0);
Find the SQL near line 51 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 p, $db_forum_topics t, $db_forum_sections s
		 WHERE fp_posterid='".$urr['user_id']."'
		 AND p.fp_topicid=t.ft_id
		 AND p.fp_sectionid=s.fs_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. Change it too.

Enjoy :)

Thanks a lot for your help, but this too does not fix it. Pressing the "last page" button of the pagination still shows "none" instead.

Added 38 days later:

Any updates on this? it does not really matter wether the person has 100000 posts or just 20, navigating to the last few pages of his posts (using this plugin) will result in no posts being displayed at all.

Alex300

Wo, 24 Mrt 2010 17:14:58 -0000

Yes.
The topic can be big and messages can be on different pages.
Or make it optional and turn it on/off on plug-in options page.

Trustmaster

Wo, 24 Mrt 2010 14:16:35 -0000

So you think if the user have posted 10 his latest posts in the same topic, we should display links to all of these posts in his profile?

Alex300

Wo, 24 Mrt 2010 06:03:09 -0000

Here working Bug Fix:

Find the SQL near line 34 in userlatestposts.php and replace it with:

$totalitems = sed_sql_result(sed_sql_query("SELECT COUNT(*) FROM $db_forum_posts WHERE fp_posterid=".$urr['user_id']), 0, 0);

Find the SQL near line 51 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 p, $db_forum_topics t, $db_forum_sections s
		 WHERE fp_posterid='".$urr['user_id']."'
		 AND p.fp_topicid=t.ft_id
		 AND p.fp_sectionid=s.fs_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. Change it too.

Enjoy

Trustmaster
I think in a trunk it is necessary to use this code too.
Because that variant, that now is in a trunk outputs not all posts (removes posts with identical fp_topicid)

$totalitems = sed_sql_result(sed_sql_query("SELECT COUNT(DISTINCT fp_topicid)
	                FROM $db_forum_posts
	                WHERE fp_posterid=".$urr['user_id

We should not use DISTINCT in this case

foxhound

Ma, 15 Mrt 2010 07:19:44 -0000

Thanks for that, but the error still exists, even with that sql replaced.
I can click to page 256 of my latest posts using the pagination. Clicking on page 257 closes it again like I reported earlier. According to the pagination I have 500 pages. (500 x 15 lines)

Trustmaster

Zo, 14 Mrt 2010 23:56:52 -0000

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.

foxhound

Za, 13 Mrt 2010 21:38:02 -0000

There is an issue with the User's recent posts, not just here but in general with that plugin.
If the user has xx ammount of posts the pagination comes up under those topic links. Try clicking the button to move to the last page, all topics will dissapear.
It also happens if you for example want to go to page 10, try this user to see for yourself:
http://www.cotonti.com/users/Alex300

Click to go to page 5, click to go to page 10 and pufff, all topics are gone.
Having this fixed here would be nice and maybe share how it was fixed?

Trustmaster

Wo, 15 Jul 2009 15:19:00 -0000

Sorry, I've overwritten the templates

pieter

Wo, 15 Jul 2009 14:40:25 -0000

# pieter : 1000x Thanks Kilandor.

One small layout error:

05-28 11:33: Forums / Cotonti / General [4 admin cotonti] User pages / User posts at Cotonti.com

There should be a "/" between path and topic-title.

After the update the recent post/topics are gone again.

Lombi

Vr, 29 Mei 2009 21:29:24 -0000

Until that's filled you can use the site's RSS feed for forums to monitor the discussions.

GHengeveld

Vr, 29 Mei 2009 21:28:11 -0000

Now that we're requesting, I'd love to see the notifier plugin installed on this site.

pieter

Vr, 29 Mei 2009 20:46:25 -0000

1000x Thanks Kilandor.

One small layout error:

05-28 11:33: Forums / Cotonti / General [4 admin cotonti] User pages / User posts at Cotonti.com

There should be a "/" between path and topic-title.

Kingsley

Vr, 29 Mei 2009 19:27:41 -0000

Thx man..

Kilandor

Vr, 29 Mei 2009 19:21:14 -0000

Done

Kingsley

Thu, 28 Mei 2009 23:42:35 -0000

would be nice indeed..

robofreak111

Wo, 27 Mei 2009 07:03:59 -0000

I agree x2
Those are two great plugins

Dayver

Wo, 27 Mei 2009 06:11:25 -0000

+1 agree

and on index page it would be useful to see plugin recentcomments

pieter

Wo, 27 Mei 2009 04:15:00 -0000

Hello Admins,

Is it possible to install the 2 plugins below on this site.
User's recent posts
User's pages

At neocrome it was installed and a nice feature of the site.
Sometimes you know user X has answered something and you can't find it in search.
Then you can look via that way.

Just an idea.