Need help with a query

[Mijae]

I cant make it work!

I need a query that takes the 5 most played games from the arcade.

Anyone can help me?

[Boofo]

Try this:


// <!-- TOP ARCADE GAMES -->
$mostactive = $DB_site->query_first("
SELECT COUNT(*) as total, gamesessions.gamename, games.title, games.gameid, MAX(gamesessions.score) as score, user.username, user.userid
FROM ".TABLE_PREFIX."gamesessions AS gamesessions
INNER JOIN " . TABLE_PREFIX . "games AS games ON(gamesessions.gamename = games.shortname)
INNER JOIN " . TABLE_PREFIX . "user AS user ON(games.highscorerid = user.userid)
WHERE gamesessions.valid=1
GROUP BY gamesessions.gamename
ORDER BY total
DESC LIMIT 0,5
");

[Mijae]

Ok, I'll work on the templates later on and see if it works :D

[Boofo]

Ok, I'll work on the templates later on and see if it works :D
It works. It the same one I use on my site for the top game. I just made it the top 5 for you.

[Mijae]

Want to give me the template code then and save me pain and agony? :P

[Boofo]

Yours would be different than mine since you have 5. ;)

[Mijae]

Give me what you have and I'll work from there :P

EDIT: Ok, I cant get it to work, I need your code :D

[Mijae]

Give me what you have and I'll work from there :P

EDIT: Ok, I cant get it to work, I need your code :D
Bump :D

[Boofo]

Have you tried using this in the template?

$mostactive[title]

[Mijae]

I hate you.

What other variables can I use? :P

Also, since I want 5 of those to appear, do I have to create a template with the code in it, and then call that template into arcade_main for example? This is new to me :P

EDIT: damn, I am so lost.

[Mijae]

Cant make it work :|

[Mijae]

Bump!

[Mijae]

Bumpity bump.