vb.org Archive
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Query to get number of post for a user today? (https://vborg.vbsupport.ru/showthread.php?t=96380)

007 09-16-2005 05:57 PM
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 09-16-2005 06:08 PM
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 09-16-2005 06:10 PM
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 09-16-2005 06:37 PM
Put a global $vbulletin before the query.

007 09-16-2005 06:40 PM
Hey MarchoH, thanks, but how would that look. Aren't the queries that WhiteSnake entered above already using the $vbulletin before them?

Nullifi3d 09-16-2005 06:58 PM
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 09-16-2005 07:08 PM
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 09-16-2005 07:16 PM
Quote:
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 09-16-2005 07:20 PM
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 09-16-2005 07:22 PM
Quote:
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?


All times are GMT. The time now is 07:29 AM.
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01706 seconds
  • Memory Usage 1,748KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete