top posters over a 7 day period

[sabret00the]

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

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

[sabret00the]

*bump*

[Issvar]

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]

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

$posts10 being the function i'm declaring

and

$DB_site->query('SELECT userid,username,posts FROM user ORDER BY posts DESC LIMIT 5');

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]

Execute the query in phpmyadmin, it does work ;)

[sabret00the]

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

[Lesane]

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

[assassingod]

$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:

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


Untested but that should do it for you

[sabret00the]

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