Add current post counter to each post!

This hack adds a static counter to each post, in addition to the dynamic (total user posts) counter, which is currently used. It will show "Posts: 55/73" under the poster name, which indicated that this is the 55th post by this user, who has posted until now 73 posts in total.

This hack does NOT add any load to your board (except for deleting threads/posts, but this is optional). It is easy to install, just download the attached text file, and read the instructions.

What's new in version 1.1?
- Old posts counters are updated correctly (requested by bira)
- Correctly dealing with forums where posts should not count
- Fixed displayed counters for guests and imported posts

What's new in version 1.2?
- Static post counter is updated when deleting posts/threads (requested by bira)

What's new in version 1.3?
- Added support for single users update (useful in several situations)

What's new in version 2.0? (major release)
- Installer and updater integrated in the Admin control panel
- Option to update total users' post counts at the same time

What's new in version 2.1?
- Fixed bug in v2.0 installation (upgrade was still smooth)


Links:
- DOWNLOAD the hack
- Live Demo
- Admin control panel screenshot

Good luck!

[Tommy Boy]

You should update the users' post counts in the admin control panel.

[FWC]

[QUOTE]Originally posted by Tommy Boy
You should update the users' post counts in the admin control panel.

[Tommy Boy]

My pleasure!

[Tommy Boy]

Screenshot of version 2.0's integration in the Admin control panel...

[FWC]

The download link in the first message is no good. It's a link to the first message again.

[Tommy Boy]

Actually, it links to post #15 in this thread, but sometimes browsers don't like to "jump" to an internal anchor for some reason... So just go there yourself, and download it.

To upgrade from an early version, just apply the changes to the admin/misc.php file.

Let me know how you like it, considering you're 33% of my users of this hack!

[FWC]

[QUOTE]Originally posted by Tommy Boy
Let me know how you like it, considering you're 33% of my users of this hack!

[FWC]

Tommy, I installed the upgrade on both my public and test boards. I just tried it out on the test board. Very nice! Good job.

[Sadie Frost]

Okay, yet another really stupid question from me - was there supposed to be an update-post-counters.php file in the download? Cause I can't find it in my files anywhere and I only received a text file in the download.

I'm asking cause when I was installing and went to update my post counters, I got this database error:

Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: SELECT postcount FROM post LIMIT 1
mysql error: Unknown column 'postcount' in 'field list'

mysql error number: 1054

If I try to go into update counters again, I get a parse error in my misc.php file at line 433 which is part of the following:

$deletethreads=$DB_site->query("SELECT threadid FROM thread WHERE title='".addslashes($thread[title])."' AND forumid=$thread[forumid] AND postusername='".addslashes($thread[postusername])."' AND dateline=$thread[dateline] AND threadid>$thread[threadid]");

Can anyone help? Thanks

[pipi]

got same error...do we need update-post-counters.php file ?? where to download it??