[kh99]

Prefix just means a string that is at the beginning. I think it's so you can have multiple vBulletin installations (or vbulletin and something else) in the same database without worrying about the table names being the same.

Like I said above, if it's not obvious what I mean from lookig at the list of tables in your database, then you probably just need to use 'post'.

--------------- Added [DATE]1293469271[/DATE] at [TIME]1293469271[/TIME] ---------------

Originally Posted by lycheepassion

so it should be prefix_post? sorry thanks

no, just post. Forget all about the prefix stuff, just use this:

SELECT username, COUNT(*) as count FROM post 
WHERE dateline BETWEEN UNIX_TIMESTAMP(YYYYMMDD) AND UNIX_TIMESTAMP(YYYYMMDD)
   AND visible = 1
GROUP BY userid
ORDER BY count DESC

(but still replace the dates, of course).