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

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-16-2001, 07:55 AM
Bane's Avatar
Bane Bane is offline
 
Join Date: Oct 2001
Posts: 411
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am using a php file to display the top ten posters:

PHP Code:
<?php 

require("global.php"); 

$db_link = @mysql_pconnect("$dbservername""$dbusername""$dbpassword"); 
mysql_select_db("$dbname"); 

?> 

<table cellpadding="4" cellspacing="1" width="100%"> 
<tr> 
<td><small><strong>TOP POSTERS</strong></small></td> 
<td align="center"><small><strong>POSTS</strong></small></td> 
</tr> 
<?php 
$top_post 
top_posters(); 
while( 
$row mysql_fetch_row($top_post) ) 

print(
'<tr>'); 
print(
'<td>'); 
print(
'<a href="member.php?s=&action=getinfo&userid='); 
print(
$row[0]); 
print(
'" target="_top">'); 
print(
$row[1]); 
print(
'</a></td>'); 
print(
'<td align="center">'); 
print(
$row[2]); 
print(
'</td>'); 
print(
'</tr>'); 

mysql_free_result ($top_post); 
?> 
</table> 

<?php 

function top_posters() 

$cur_time mktime(date(G), date(i), date(s), date(m), date(d), date(Y)); 
$query 'SELECT userid, username, posts ' 
'FROM user ' 
'ORDER BY posts DESC LIMIT 3'
$result mysql_query($query
or die(
'top_posters query failed'); 
return(
$result); 


?>
IRC may recognise this

My question is, is there a way to set this so it displays the top posters of the last 7 days and the number of posts during that time period?

I had tried changing some things and got the top list for last 7 days, but it would only display the total number of posts, not just for those 7 days..

I hope Im making sense.
Reply With Quote
 


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 06:08 PM.


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.08341 seconds
  • Memory Usage 2,773KB
  • Queries Executed 12 (?)
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
  • (3)bbcode_code
  • (4)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (19)post_thanks_box
  • (19)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (19)post_thanks_postbit_info
  • (19)postbit
  • (1)postbit_attachment
  • (1)postbit_onlinestatus
  • (19)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • 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
  • postbit_attachment
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete