Query to get number of post for a user today?

[007]

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)

PHP Code:

$cutoff=time()-86400; 
$postcount=$DB_site->query_first("SELECT COUNT(*) AS total FROM post WHERE userid='$userid' AND dateline >= $cutoff"); 


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?

[White_Snake]

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:

PHP Code:

$cutoff=time()-86400; 
$postcount=$vbulletin->db->query_first("SELECT COUNT(*) AS total FROM post WHERE userid='$userid' AND dateline >= $cutoff"); 


[007]

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?

[Boofo]

Try:

$db->query_first

[007]

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

[White_Snake]

0k, now try this:

PHP Code:

$cutoff=time()-86400; 
$postcount=$vbulletin->db->query_first("SELECT COUNT(*) AS total FROM post WHERE userid='".vbulletin->userinfo[$userid]."' AND dateline >= $cutoff"); 


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

PHP Code:

$cutoff=time()-86400; 
$postcount=$vbulletin->db->query_first("SELECT COUNT(*) AS total FROM post WHERE userid='".vbulletin->userinfo['$userid']."' AND dateline >= $cutoff"); 


[007]

Getting closer..

I get this:

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

[White_Snake]

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

PHP Code:

 $cutoff=time()-86400; 
$postcount=$vbulletin->db->query_first("SELECT COUNT(*) AS total FROM post WHERE userid='".vbulletin->userinfo[$userid]."' AND dateline >=".$cutoff.""); 


or

PHP Code:

 $cutoff=time()-86400; 
$postcount=$vbulletin->db->query_first("SELECT COUNT(*) AS total FROM post WHERE userid='".vbulletin->userinfo['$userid']."' AND dateline >=".$cutoff.""); 


[007]

Bad news...

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

[White_Snake]

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