Query to get number of post for a user today?
 

I need help with a query please...

I haven't been able to get anything to work with the plug in system, but I have seen similar hacks that use a similar idea.

The query needs to pull the number of posts a user has so far today for display in the posbit. (Not the past 24 hours, just in the current day).

How can I do this? Thanks.

~007

Here's the code that worked on 3.0: (rolling 24 hours, however, but this doesn't work either on 3.5)

I am trying to put it in postbit_start.

It comes up with "Call to a member function on a non-object" and I'm guessing it's because syntax has changed in 3.5... but I haven't the slightest clue where to begin. Any ideas?

well, the syntaxis error i can see is that you're using $DB_site-> and as far as i know that's from vb 3.0.x

so the proper command should be

$vbulletin->db->query_frist, so, making the whole sentence be:

Thanks, but I get the following with that:

Fatal error: Call to a member function on a non-object in ...../includes/class_postbit.php(251) : eval()'d code on line 2

:( What should I do?

Try:

$db->query_first

Hey, I get the same error with that.. Hmmm..

0k, now try this:

if that one doesnt do the trick, try this one:

Getting closer..

I get this:

Parse error: parse error in ..../includes/class_postbit.php(251) : eval()'d code on line 2

none of em worked, hmmmm =/ what else can be the error, well, i think this one of this 2 should work:

or

Bad news... :(

No go. Thanks for helping though. The COUNT (*) isn't the problem is it?

hmmm, well, try the query frist via phpmyadmin without variables or vbulletin commands, something like:
[SQL]
"SELECT COUNT(*) AS total FROM post WHERE userid='1' AND dateline >= 86400 ");
[/SQL]

if it doesnt work, well, maybe you have an sql syntaxis error, that's the only way to know if you're right