This looks really kool and i am sure it's just what i was seeking :)

Please tell me that it works with vb3.0.0 ??

Thanks

Should work just fine. ;)

sorry to ask boofo

I am getting db error, can you tell me what i may have done wrong please and thanks

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT user.userid, user.username, COUNT(post.postid) AS postcount
FROM vb3_post
LEFT JOIN vb3_thread ON (post.threadid = thread.threadid)
LEFT JOIN vb3_user ON (post.userid = user.userid)
WHERE thread.forumid=2
GROUP BY post.userid
ORDER BY postcount DESC
LIMIT 1

mysql error: Unknown table 'user' in field list

mysql error number: 1109

Did you change this:

" . TABLE_PREFIX . "

to vb3

by chance?

sorry boofo "newbie alert here" :( lol

Do you mean when i installed vb? if so then yes my db is set to vb3_

So I guess I have messed up now then?

No, I mean when you ran the query? Did you change the query to show that yourself? ;)

That's the top poster query, right? If it is, here is what you need to run for that query:

ok i have missed something here :( I have not run any db query, so I must have missed something in your instructions. I have just made edits to forumdisplay.php file, by way of copy and paste from your instructions. Done template and new settings.

(-0-0-) Do you think I need some? lol

Thanks

No, you did right. When you entered a forum, it runs the queries. Did you get any more errors or was that the only one?

Check the forumdisplay.php and make sure the query for the top poster is the one I posted in that last message. Let me know what you find out. We'll get it going for you, hang in there. ;)

thanks boofo :)

okay I have double checked all the instructions, inc edits to forumdisplay.php, templates and new setting.

Now I am lost, because I do not even have the new template displayed, which i didnt before.

I am assuming that I should have run a sql query via phpadmin? or something I am missing something really silly here. lol lol :o