[exodus]

is this the accumlative post number? or like they have here on vB.org where every post in a specific thread gets numbered? post #1, post #2, etc...

?

[bira]

this is a very nice idea.

If I understand correctly, this is the number of post per USER, not per thread.

Meaning, when you read this post now, this is my 115th post out of 115 total posts I made on this Bulletin Board.

But the next time I post (here or in a different thread), this will show it to be my 115th post out of a total of 116th, etc.

So it will allow users to easily see at what point in your posting history this post was made. Was it your very first post? Was it your very last? etc.

I'll try this hack - the idea is nice.

[pipi]

Any demo? thanks for your hard work

[bira]

Ok, I am trying this hack on my development server which has NO traffic at all, and I can already tell you of one big pitfall in this hack:

The update-post-counters.php runs an UPDATE post SET ... query on ALL YOUR POSTS. With over half a million posts in my database, and for other websites with a lot of posts, this process will take A LONG TIME, and will eventually exceed the execution timeout limit in php.ini (if not crash your MySQL!)

You MUST change your hack installer to run at X number of posts at a time (like the "update counters" does). You cannot just release this installer without making this modification, because it will not be fully installed, and most posts will show 0/xxx.

I myself can't even get the hack installed yet because I have so many posts in the db. So I don't even know what it looks like or how it works

[bira]

After editing your update-post-counters.php to use limit and startat points, I've managed to install this hack.

Here is why the hack is at the moment worthless for existing bulletin boards:

Pitfall 1:

Users will now show in all of their existing posts totalposts/totalposts.

Eg, if I had 3000 posts so far, all my posts up to now will show 3000/3000 -- not very informative.

Pitfall 2:

If I delete a post, or an admin deletes a post, the currentpost will be bigger than the total posts.

Eg, if to use the same example as above, all my posts up to now will show:

3000/2999

....

Sorry, but only a new Bulletin Board owner should use this hack. It's worthless for boards that have been operating as long as I have

If you want to make it valuable, you need to change it to:

ORDER BY dateline ASC

and add $postcount = 1 before the loop, and $postcount++ after the loop. That will at least solve pitfall #1. It won't solve pitfal #2. Nothing normal will.

Either way, a word of warning: installing this hack takes, on moderate to big boards, close to one hour. And it takes a LOT or resources.

[Tommy Boy]

Hehe, it's amazing, I was just thinking about these things when I went to sleep last night! If you want to wait, I'll provide a fix when I come back from work.

This hack IS possible, and has a lot of potential. Please give me a chance to prove it.

[Tommy Boy]

Ok, I couldn't wait, so I released the fix already (first post updated)

Bira, please try it on your huge database, it should work fine, but let me know if it doesn't, for any reason... It takes less than 5 seconds to run on my database, and I have over 60k posts.

So anyway, this fixes your pitfall #1. Now let's talk about your pitfall #2. First of all, many people will not consider it a problem, but a "feature", since even though some of this user's posts were deleted, this still remains his Xth post, and there is no reason to modify this. This is a "logical" issue, if you will. In any case, I have decided to make it part of the hack after all.

Anything else I can do for you, sir?

[bira]

Tommy I'm a girl!

I want to send you something by e-mail. I can't attach files to an e-mail via the BB, so can you please e-mail me at goren@atlasf1.com your addy, so I can send it to you?

I think you'll like it

[bira]

Tommy did you upload a new zip file? The one I just downloaded has exactly the same php file

[Tommy Boy]

Oops, sorry about that, m'lady!

Email sent.

[Tommy Boy]

Originally posted by bira
Tommy did you upload a new zip file? The one I just downloaded has exactly the same php file

It must be your cache... Anyway, I have uploaded it under another name now, so please try to download it again.

[bira]

Tommy this is so weird. When I click on the link to the zip file, even though it's named ***v12, it downloads static-post-counter.zip -- the old zip.

I cleared my cache and it still does that

Can you e-mail it to me please?

[Tommy Boy]

Sure, there you go girl!

[Tommy Boy]

I removed the attachment from the first post by mistake, and now I can't add it back

So download the hack from here please. Thank you!