Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 06-15-2004, 09:39 AM
meowmeow's Avatar
meowmeow meowmeow is offline
 
Join Date: May 2004
Location: Florence, Italy
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default changing statistics in index page (modified)

the forum statistics in the index page give some info about the forum.
one thing i'd like to change is the "newest member"
form index.php i can see it is taken from these two queries:

PHP Code:
$members = ("SELECT COUNT(*) AS users, MAX(userid) AS max FROM " TABLE_PREFIX "user");

and 
$newuser = ("SELECT userid, username FROM " TABLE_PREFIX "user WHERE userid = $members[max]"); 
I want to modify it so that instead of taking the MAX(userid) it takes the MAX(joindate)

so I changed it to this:

PHP Code:
$members = ("SELECT COUNT(*) AS users, MAX(joindate) AS max FROM " TABLE_PREFIX "user");
and
$newuser = ("SELECT userid, username FROM " TABLE_PREFIX "user WHERE joindate = $members[max]"); 
still it doesnt work!
when i tried these 2 queries on a test script it worked, but on the forum it didnt change.
I dont know when functions_databuild.php is called, so it could be that it just hasnt refreshed, otherwise i don't know what i'm doing wrong!
Reply With Quote
  #2  
Old 06-15-2004, 11:58 AM
meowmeow's Avatar
meowmeow meowmeow is offline
 
Join Date: May 2004
Location: Florence, Italy
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

could it have something to do with the template?
HTML Code:
<div><phrase 1="member.php?$session[sessionurl]u=$newuserid" 
2="$newusername">$vbphrase[welcome_to_our_newest_member_x]</phrase></div>
Reply With Quote
  #3  
Old 06-16-2004, 06:29 AM
meowmeow's Avatar
meowmeow meowmeow is offline
 
Join Date: May 2004
Location: Florence, Italy
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

nobody can help?? please...
I have the number of posts and the number of threads which update regularly, but the number of members and the newest member who havent changed for the past 2 weeks... here is the relevant code.
everything looks alright with me.
PHP Code:
// ### BOARD STATISTICS #################################################
// get total threads & posts from the forumcache
$totalthreads 0;
$totalposts 0;
if (
is_array($forumcache))
{
foreach (
$forumcache AS $forum)
{
  
$totalthreads += $forum['threadcount'];
  
$totalposts += $forum['replycount'];
}
}
$totalthreads vb_number_format($totalthreads);
$totalposts vb_number_format($totalposts);
// get total members and newest member from template
$userstats unserialize($datastore['userstats']);
$numbermembers vb_number_format($userstats['numbermembers']);
$newusername $userstats['newusername'];
$newuserid $userstats['newuserid']; 
and the sql selects in the previous post...
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:48 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07574 seconds
  • Memory Usage 2,193KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_html
  • (3)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete