Bad Credit Loans - Health 2007 - Online Advertising - Credit Cards - Arcade Games
PDA

View Full Version : Help me with Gamesitescript!!!

lightstarm2k
Dec 24th 2008, 12:44 am
I want to change from order ASC/DESC by alphabetic on category page to order by latest games.

Thanks
sandstorm140
Dec 24th 2008, 1:07 am
you should will need to add a field with dates and time the game was added and then the sql part would be ".......ORDER BY date ASC".
Or if you have IDs setup working correctly sort by IDs (which I wouldn't recommend).
lightstarm2k
Dec 24th 2008, 2:12 am
you should will need to add a field with dates and time the game was added and then the sql part would be ".......ORDER BY date ASC".
Or if you have IDs setup working correctly sort by IDs (which I wouldn't recommend).

I tried to order by IDs, but it doesn't work
here is the original code of the GSS.

$games = get_games("order=deforder&sort=defsort&shortdesc=".$themecfg['maxdesclength']."&page="._sp($params[2])."&thecat="._sp($category['name']));
planemaniac
Dec 24th 2008, 4:08 am
You would need a field which holds the date of the game, then you would "ORDER BY date ASC" on the SQL query. It's not that hard, but you would also have to update the script that puts the games into the database to include the date.