Games positions

[5hey]

How can i change the position of games in the same categorie? because I want to display the newer ones first or to sort them by name.
and is there any possibility that I can choose what games should be displayed on the home page.
Please I need help.
Thanks.

[5hey]

I sent an email to you.

[kurt]

In /pages/base_home.php is where the SQL query is set up. A couple of lines that read

Code: [Select]


$ir = $db->query(sprintf('SELECT * FROM dd_games WHERE category=\'%u\' LIMIT 0,'.$limitboxgames.'', $row['ID']));


You can add an "ORDER BY....." and choose what field you want it sorted by and place it in where the "....." is.

Code: [Select]


$ir = $db->query(sprintf('SELECT * FROM dd_games WHERE category=\'%u\'  ORDER BY ID desc LIMIT 0,'.$limitboxgames.'', $row['ID']));


I personaly changed it to "ORDER BY  rand()" so that it shows different games each time on the arcade I'm working on.

Code: [Select]


$ir = $db->query(sprintf('SELECT * FROM dd_games WHERE category=\'%u\'  ORDER BY rand () LIMIT 0,'.$limitboxgames.'', $row['ID']));



This is something I'm hoping to catch in the next zip file.

[5hey]

Yes it works now.
Thank you very much.