Query to get number of post for a user today?

[007]

That's what I did to start with, and it worked fine. That's why I think it has something to do with how vb3.5 needs to have queries typed in differently somehow

[White_Snake]

hmmm i see, well, the query works, but im not sure how to deal with queries that complex, what i have seen from your original was that you wasnt recalling the userid properly and you wasnt cutting the php time variable from the sql sentance

im not sure what else you can do :S

[007]

Well thanks for trying. I appreciate it!

On that note, if anybody else has any ideas, I really would like to get this going if possible. Thanks a lot!

[Marco van Herwaarden]

Put a global $vbulletin before the query.

[007]

Hey MarchoH, thanks, but how would that look. Aren't the queries that WhiteSnake entered above already using the $vbulletin before them?

[Nullifi3d]

White Snake, your codes have several errors. As Boofo said: the correct code would be $db->query_first, but it depends on the hook you're inserting this code into.

The following should work with most hooks:

PHP Code:

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


Display the count in a template with $postcount[total]

[007]

HotLinkHosting, now I am back to the Fatal Error from before:

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

The hook I am using is postbit_display_start.. I have tried it in other postbit hooks with the same problem however.. I think that is the right hook to use though. It makes sense at least according to where it is in the code..

[White_Snake]

Originally Posted by 007

HotLinkHosting, now I am back to the Fatal Error from before:

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

The hook I am using is postbit_display_start.. I have tried it in other postbit hooks with the same problem however.. I think that is the right hook to use though. It makes sense at least according to where it is in the code..

so well, exaclty which error are you reciving using whit the code i gave you?

well try this now, inspired on Hotlink code:

PHP Code:

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


[Boofo]

Shouldn't it be this:

PHP Code:

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


[White_Snake]

Originally Posted by Boofo

Shouldn't it be this:

PHP Code:

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


hmmm i see, so, what's the function of global $vbulletin with the whole query?