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:

PHP Code:

// <!-- 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

[Boofo]

Originally Posted by Mijae

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

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

[Mijae]

Originally Posted by 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

Bump

[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.