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!

[FWC]

[QUOTE]Originally posted by Sadie Frost
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'

[Tommy Boy]

I'm sorry for that. It's my fault, since I took a code from another hack, without testing it first... Anyway, the attachment was updated (v2.1), and if you already installed v2.0, just make this small modification:

Open admin/misc.php, and look for:

PHP Code:

  // Add post counter column to post table, if needed 
$DB_site->query ("SELECT postcount FROM post LIMIT 1"); 
  if ($DB_site->errno) 
    $DB_site->query ("ALTER TABLE post ADD postcount int unsigned not null AFTER userid"); 


Change it to:

PHP Code:

  // Add post counter column to post table, if needed 
$col_exists = $DB_site->query_first ("SHOW columns FROM post LIKE 'postcount'"); 
  if (!$col_exists) 
    $DB_site->query ("ALTER TABLE post ADD postcount int unsigned not null AFTER userid"); 


As for your question, update-post-counters.php is no longer needed, as long as the above change is applied.

[Sadie Frost]

Thanks for helping me with that

No to be a pain but I'm still getting a parse error when I try to go to update counters - think that's an unrelated problem?

[Tommy Boy]

I think so too. Send me your misc.php file, and I'll tell you what's wrong with it. I sent you an email, so you will know mine.

[Sadie Frost]

It's working great now! I always thought posts should say the order in which they were posted - it's terrific. Thanks!

[kidney]

Ok, got a question,

Why does my total post counter increase, but not the other.
Here is what I mean, I get 1/16 or 1/17.
When ever I post the last two digit increase, but I alway get 1/?? anywhere No mather which post I look I get 1/##, it always remains at 1/##, any clue!!

[kidney]

Ok, it only increments whitin the same thread, Isn't suppose to work accross the forum?

[Tommy Boy]

Yes it is. It might be conflicting with another hack you have installed. Try reapplying it, but use another name instead of "postcount".

[kidney]

Yup it's conflicting with Biras' "Post Counter & Direct Link"

I know that you can fix it, but I figured that I have already done it, so I will pm the new file...

[julius]

Mysql error when you delete a thread. (vb 2.3.0.)