vb.org Archive - top posters over a 7 day period

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

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - top posters over a 7 day period (https://vborg.vbsupport.ru/showthread.php?t=58386)

sabret00the

11-04-2003 08:05 PM

top posters over a 7 day period

how would i edit this query to show the top posters over a 7 day period?

[sql]$posts10 = $DB_site->query('SELECT userid,username,posts FROM user ORDER BY posts DESC LIMIT 5');[/sql]

sabret00the

11-04-2003 10:51 PM

*bump*

Issvar

11-05-2003 08:17 AM

Code:

SELECT 

  userid,

  username,

  COUNT(*) as weekpostcount

FROM

  post

WHERE

  dateline > (UNIX_TIMESTAMP() - 7*24*60*60)

GROUP BY

  username,

  userid

ORDER BY

  weekpostcount DESC

LIMIT 5

For Help Me Finish it's usual to try doing something yourself first, otherwise post in MySQL/PHP

sabret00the

11-05-2003 12:55 PM

altho i appreciate your help, the query is apart of something

PHP Code:


		
			
$posts10

being the function i'm declaring

and
[sql]
$DB_site->query('SELECT userid,username,posts FROM user ORDER BY posts DESC LIMIT 5');
[/sql]
being the string that query's the database, as you can see in the php box in the first post i don't apprear to make use of the function anywhere, which would mean that i got the rest of the hack somewhere else (of which i require no help with), being that this is the last obstacle before finish, i would say it's a matter of HELP ME FINISH

btw your query didn't work :)

Lesane

11-05-2003 02:07 PM

Execute the query in phpmyadmin, it does work ;)

sabret00the

11-06-2003 05:51 AM

sorry should've been clearer, the query works fine in php my admin just not on the page :(

Lesane

11-06-2003 06:22 AM

Post the php code with query so we can help you.

assassingod

11-06-2003 06:29 AM

PHP Code:


		
			
$toppostersquery = $DB_site->query("
 SELECT 
   userid,
   username,
   COUNT(*) as weekpostcount
 FROM
   post
 WHERE
   dateline > (UNIX_TIMESTAMP() - 7*24*60*60)
 GROUP BY
   username,
   userid
 ORDER BY
   weekpostcount DESC
 LIMIT 5
");
while ($topposters  = $DB_site->fetch_array($toppostersquery))
{
  eval("\$toppostersbit = \"".gettemplate('topposters_7days')."\";");
}

Then you'd use something like in the topposters_7days template:

Code:

<b>$topposters[username]</b> -$topposters[posts]

Untested but that should do it for you

sabret00the

11-10-2003 12:45 AM

when i get access to my pc i'll post it up, thank you very much for all of your help thus far tho :)

All times are GMT. The time now is 07:55 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02274 seconds Memory Usage 1,727KB 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 (2)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: