Yes, they do. Add the posts and threads together before you divide. ;)

2322 + 595 = 2917

200 / 2917 = 0.0685636

0.0685636 = 6.85 %

You are the man. ;)

wtf that's so wrong

ADD threads and posts???
that's double counting

if you have an empty board (like my test board) and make 1 thread, then you will have 1 thread, 1 post, BBQ posted 1 post (50%)

Now, that's just wrong. There is only 1 post and that's the thread post. You don't add threads and posts together

Look at how vBulletin counts them before you claim anything is wrong.

All I did was follow their way of doing it.

If you think it is wrong, just take out the code for the percentages. I'm going to remove it in the update, anyway.

And give me a link to your test board in pm so I can check it out.

Take out the percentages?

Nah, i just fixed your formule (yes fixed :p )
$statscache['topposterpercent'] = round(100 * ($topposter[posts] / ($totalposts)), 2);

now it's right again :D

First of all this satement is wrong:

If should be:

Second of all, if you have read the thread, you would see that this only works on small boards. On bigger boards you will get something like 15,300 % (your number would be different, but you get the idea) with your code.

And third, you are only counting replies this way, so you should call it Top Replier. ;)

Do what you want, but the code will come out of it in the next update. It's not worth messing with anymore.

hey boofo I'm back for round 2 attempt lol oh no he says...........

when i run the query iget error:
#1146 - Table **********.datastore' doesn't exist

so i guess i am missing something, should i be changing the title of the query?

please and thanks

Don't worry about the first query (the one with datastore in it). The datastore entries will be made when you install the code in the index.php and run the hack for the first time. ;)

:( lol lol

I have a different error now boofo, would you have any ideas please? seem like 1 error is solved then i get another........ lol

At least this time I did see the template, before i got the error lol ;)

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT profileviews,username,userid
FROM vb3_user
ORDER BY profileviews
DESC LIMIT 1

mysql error: Unknown column 'profileviews' in 'field list'

mysql error number: 1054

[high]* BarBeQue gives up.... how can he convince boofo that adding posts with threads is doublecounting......
[/high]

I counted each post on my board damnit and you do NOT add the threads to it cause threadposts are already included in the postcount

Make a new thread and you'll notice your postcount go up by 1.