You are not logged in. Please login or register.
PunBB Forums → Supported extensions → Real posts count
Real posts count extension changes PunBB's post counter so that it will lower the post count when post is deleted.
//Note: Extension recounts users posts when installed
Download v1.0a (with fixes by Astro)
GitHub
Hey thanks for the efforts. Got error when installing.
Database reported: Unknown column 'posts.poster_id' in 'where clause' (Errno: 1054).
Failed query: UPDATE prefix_users AS u SET u.num_posts = (SELECT count(*) FROM prefix_posts WHERE posts.poster_id = u.id GROUP BY posts.poster_id)
Weird... what db engine do you use in your forum?
Wamp. MySQL. After i change posts.poster id to poster_id then it install. But not work how it have to.
So? Any news?
Hello
it works for punbb 1.3.x ?
There were two typos in the manifest.xml file.
Lines 26–31 (typo is on line 28)
$subquery = array(
'SELECT' => 'count(*)',
'FROM' => 'posts',
'WHERE' => 'posts.poster_id = u.id',
'GROUP BY' => 'posts.poster_id'
);should have been
$subquery = array(
'SELECT' => 'count(*)',
'FROM' => 'posts as posts',
'WHERE' => 'posts.poster_id = u.id',
'GROUP BY' => 'posts.poster_id'
);and line 68
<hook id="fn_delete_post_qr_delete_post'">should have been
<hook id="fn_delete_post_qr_delete_post">Tested and works with 1.4.2.
Hello
This is a great plug in
But....I have some problems
I can't install
it's always show me I should install later when I try to install every time......
my pun 1.4.2 was installed with SQLite
Are there any extensions should be install first?..or require..
Any guides to help me thank a lots
Have you made the changes described in #7 before installation?
PS: Additionaly I've corrected the extension for those who don't want to fix it themselves, so if you didn't you can easily download it by clicking on this link and install right away.
This is very useful feature.
It has to be included in PunBB core. Or at minimum PunBB developers has to make this extension official.
I don't think that this will ever be included into the core (read more, focus on posts by Rickard). Actually I don't really think that it is a good idea to use this extension because it doesn't recover values upon uninstallation, so if you are (or ever were) forced to prune old posts due to database capacity or whatever the reason for pruning database could be or you just change your mind – either way you are going to lose information about who has contributed the most in the past.
lose information about who has contributed the most in the past
Spam we delete is not a contribute.
Without this feature "Number of posts" must be renamed to "Number of postings".
..
P.S.
Your "read more" link is broken.
I tried to download and install the file which was fixed ...
but....still...Error
Please try again after 5-10min...
So sad (T口T) Problem still here
may be it isn't for sqlite _~_"?
anyway thanks @v@ I will decrease the post counter manually on my punbb forum site
^^ Oh yeah It is work if use Grez's original manifest.xml
Thanks Astro and Grez
If someone have the same problem remind you install later after x mins
you could
creat a blank txt file
copy and paste the original code from manifest.xml Post by Grez
changes described in #7 before installation Post By Astro
save and rename to manifest.xml
thx astro..
your script is work 
I've approved fixes by Astro and updated first post. Enjoy!
This little mod not working how it have to. When deleting topics via topic moderate no effect on post count at all.
With fixes by Astro works perfectly, but last posted timestamp leaves unchanged. Please improve to update last posted too.
Works for 1.4.4. Thanks.
I installed this extension on my 1.4.4 (now 1.4.6) and it seems it stops working after deleting several posts at a time. So if you want it to work again, you need to install it again! 
PunBB Forums → Supported extensions → Real posts count
Powered by PunBB, supported by Informer Technologies, Inc.