vb.org Archive - Homepage Statistics Cache

Page 5 of 7

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Homepage Statistics Cache (https://vborg.vbsupport.ru/showthread.php?t=51163)

Boofo

04-25-2003 09:01 AM

Quote:

Yesterday at 05:23 PM Tigga said this in Post #39
Boofo - Actually the only thing that would affect is where it shows an admin the last time the cache was updated. The $datecut variable is what would need to be modified. ;)

It was just a guess, and not a very good one it seems. ;) I'll wait for your update then instead of messing it up. ;)

Sanjiyan

04-25-2003 10:05 AM

Can you get this to cache the front page stats on vbhome lite?

Heres the link to the stats listed:

www.theborg.cjb.net

the stats are along the left hand side.

thanks

Boofo

05-13-2003 03:17 AM

Quote:

04-24-03 at 06:23 PM Tigga said this in Post #39
Bofo - Actually the only thing that would affect is where it shows an admin the last time the cache was updated. The $datecut variable is what would need to be modified. ;)

Tigga, did you get a chance to look at this yet?

corsacrazy

05-18-2003 10:09 AM

mate how can i exempt a certain user id out of the Top Thread Starter ?

Tigga

05-18-2003 10:38 PM

Boofo - Actually I did. I just updated the text file with the new code. For anyone who's already installed this, you can just look for this code:

PHP Code:


		
			
$datecut = mktime(0,0,0,date("m"), date("d"), date("y"));

And replace it with this:

PHP Code:


		
			
$datecut = mktime(0,0,0,date('m',"$ourtimenow"), date('d',"$ourtimenow"), date('y',"$ourtimenow"));

There's no good way to have it go by the user's time offset, but this does at least go by your forum's default time.

corsacrazy - You would just need to look for this code:

PHP Code:


		
			
$topposter=$DB_site->query_first("SELECT username,posts,userid FROM user ORDER BY posts desc LIMIT 1");

And replace it with this:

PHP Code:


		
			
$topposter=$DB_site->query_first("SELECT username,posts,userid FROM user WHERE userid!='XX' ORDER BY posts desc LIMIT 1");

(Replace XX in that query with the user's id)

Boofo

05-18-2003 10:57 PM

Could you use that here, too?

PHP Code:


		
			
// members registered today

$datecut = mktime(0,0,0,date("m,$ourtimenow"), date("d,$ourtimenow"), date("y,$ourtimenow"));

$getmemstoday=$DB_site->query_first("SELECT count(*) AS count FROM user WHERE usergroupid=2 AND joindate>='$datecut'");

Boofo

05-18-2003 11:11 PM

Shouldn't this:

PHP Code:


		
			
$datecut = mktime(0,0,0,date("m,$ourtimenow"), date("d,$ourtimenow"), date("y,$ourtimenow"));

be like this?

PHP Code:


		
			
$datecut = mktime(0,0,0,date("m",$ourtimenow), date("d",$ourtimenow), date("y",$ourtimenow));

Tigga

05-18-2003 11:27 PM

Actually you can just remove that 2nd instance of $datecut. They will both have the same result, so there's no point in having it there twice. I thought I had already taken that out, but I guess I forgot about it.
Thanks for pointing out the errors in the code. I guess I was more tired than I thought when I did that. I updated the file and the post above with the correct code though. :)

corsacrazy

05-19-2003 06:09 AM

i set the user id to 0 as i hav the welcome hack installed and every time sum one registers a post is created to include the details of that person and the thread started is user id 0, so therefore the top thread starter is user id 0 but i get this error in index when adding 0 to where u said

PHP Code:


		
			
Invalid SQL: SELECT COUNT(*) AS count,postuserid,postusername FROM thread WHERE userid!='0' GROUP BY postuserid ORDER BY count DESC LIMIT 1

mysql error: Unknown column 'userid' in 'where clause'



mysql error number: 1054

Tigga

05-19-2003 01:42 PM

Blah, sorry about that. Try replacing userid with postuserid. :)

All times are GMT. The time now is 07:42 PM.

Page 5 of 7

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01172 seconds Memory Usage 1,756KB 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 (8)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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
Messages: