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

12>>>

On this site

pieter
#1 2009-05-27 04:15
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.
... can we help you ...
This post was edited by pieter (2009-05-28 17:33, 14 years ago)
Dayver
#2 2009-05-27 06:11
+1 agree

and on index page it would be useful to see plugin recentcomments :-/
Pavlo Tkachenko aka Dayver
robofreak111
#3 2009-05-27 07:03
I agree x2
Those are two great plugins
Kingsley
#4 2009-05-28 23:42
would be nice indeed..
Kilandor
#5 2009-05-29 19:21
Done
Kingsley
#6 2009-05-29 19:27
Thx man..
pieter
#7 2009-05-29 20:46
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.
... can we help you ...
GHengeveld
#8 2009-05-29 21:28
Now that we're requesting, I'd love to see the notifier plugin installed on this site.
Lombi
#9 2009-05-29 21:29
Until that's filled you can use the site's RSS feed for forums to monitor the discussions.
<a href="http://www.domenlo.com">Surreal Art</a>
pieter
#10 2009-07-15 14:40
# 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. :-(
... can we help you ...
Trustmaster
#11 2009-07-15 15:19
Sorry, I've overwritten the templates :-)
May the Source be with you!
foxhound
#12 2010-03-13 21:38
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? :)
<img src="http://www.armaholic.com/datas/thumbs/green-sea-battalion-uniforms-version-03-preview_4.jpg" alt="green-sea-battalion-uniforms-version-03-" />
Trustmaster
#13 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!
foxhound
#14 2010-03-15 07:19
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)
<img src="http://www.armaholic.com/datas/thumbs/green-sea-battalion-uniforms-version-03-preview_4.jpg" alt="green-sea-battalion-uniforms-version-03-" />
Alex300
#15 2010-03-24 06:03
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
Есть миры, не здесь, там, где небеса горят, и моря засыпают, и реки дремлют; люди сделаны из дыма, а города – из песен. Где-то опасность, где-то несправедливость, даже где-то остыл чай. Идем Эйс, у нас много работы!...
...Sorry for my english...
Бесплатные расширения для Cotonti: https://lily-software.com/free-scripts/

12>>>