<?php
include('../../mainfile.php');
include_once('cache/config.php');
include_once('classes/class.pagenav.php');
include_once('include/arcade_func.php');
include(XOOPS_ROOT_PATH."/header.php");

global $db, $myts, $xoopsUser, $xoopsConfig, $HTTP_GET_VARS, $HTTP_POST_VARS;

if(file_exists($xoopsConfig['root_path']."modules/arcade/language/".$xoopsConfig['language']."/blocks.php")){
include($xoopsConfig['root_path']."modules/arcade/language/".$xoopsConfig['language']."/blocks.php");
}else{
include($xoopsConfig['root_path']."modules/arcade/language/english/blocks.php");
}

if ($xoopsUser) {

$sort_dir = $HTTP_GET_VARS['sortdir'];
$order_by = $HTTP_GET_VARS['orderby'];

if (!$sort_dir || ($sortdir != 'ASC' &amp;&amp; $sortdir != 'DESC')) {
$sort_dir='ASC';
}
if (!$order_by) {
$order_by='gtitle';
}


OpenTable();
array();
echo "<p align='center'><img border='0' src='cache/images/trophy.gif' width='15' height='15'> <u><b>"._MDB_TITLE."</b></u> <img border='0' src='cache/images/trophy.gif' width='15' height='15'><br><br>";
echo "<table cellspacing='10'><tr bgcolor='#CCCCCC'><td></td>";

$arrow_up = XOOPS_URL."/modules/arcade/images/up.gif";
$arrow_down = XOOPS_URL."/modules/arcade/images/down.gif";

echo "<td nowrap><a href='hscores.php?orderby=gtitle&amp;orderdir=ASC'><img src=".$arrow_up." alt='"._MDB_ASC."'></a><b>&amp;nbsp;"._MDB_GAME."&amp;nbsp;</b>";
echo "<a href='hscores.php?orderby=gtitle&amp;sortdir=DESC'><img src=".$arrow_down." alt='"._MDB_DESC."'></a></td>";

echo "<td><a href='hscores.php?orderby=gcount&amp;orderdir=ASC'><img src=".$arrow_up." alt='"._MDB_ASC."'></a><b>&amp;nbsp;"._MDB_PLAYED."&amp;nbsp;</b>";
echo "<a href='hscores.php?orderby=gcount&amp;sortdir=DESC'><img src=".$arrow_down." alt='"._MDB_DESC."'></a></td>";

echo "<td><a href='hscores.php?orderby=uid&amp;orderdir=ASC'><img src=".$arrow_up." alt='"._MDB_ASC."'></a><b>&amp;nbsp;"._MDB_USER."&amp;nbsp;</b>";
echo "<a href='hscores.php?orderby=uid&amp;sortdir=DESC'><img src=".$arrow_down." alt='"._MDB_DESC."'></a></td>";

echo "<td nowrap><a href='hscores.php?orderby=score&amp;orderdir=ASC'><img src=".$arrow_up." alt='"._MDB_ASC."'></a><b>&amp;nbsp;"._MDB_SCORE."&amp;nbsp;</b>";
echo "<a href='hscores.php?orderby=score&amp;sortdir=DESC'><img src=".$arrow_down." alt='"._MDB_DESC."'></a></td>";

echo "<td><a href='hscores.php?orderby=score_date&amp;orderdir=ASC'><img src=".$arrow_up." alt='"._MDB_ASC."'></a><b>&amp;nbsp;"._MDB_SCOREDATE."&amp;nbsp;</b>";
echo "<a href='hscores.php?orderby=score_date&amp;sortdir=DESC'><img src=".$arrow_down." alt='"._MDB_DESC."'></a></td>";

echo "<td></td>";

$sql = "select g.gid, s.gid AS gid, g.gname, g.gcount, g.gtitle, g.active, s.uid AS uid, max(s.score) AS score, s.score_date as score_date from ".$db->prefix('arcade_games')." g
INNER JOIN ".$db->prefix("arcade_scores")." s
ON g.gid=s.gid group by s.gid HAVING active=1 ORDER BY ".$order_by." ".$sort_dir;
$res = $db->query($sql);


while ($row = $db->fetch_object($res))
{

$highscore = _get_game_highscore($row->gid);

echo "<tr><td><img src='".XOOPS_URL."/modules/arcade/cache/images/".$row->gname."2.gif'></td>";
echo "<td><a href='".XOOPS_URL."/modules/arcade/index.php?act=play_game&amp;gid=".$row->gid."'><b>".$row->gtitle."</b></a></td>";
echo "<td><p align='center'>".$row->gcount."x</p></td><td>".$highscore[uname]."</a></td>";
echo "<td>".$row->score."</td>";
echo "<td>".formatTimestamp($row->score_date, 'm')."</td>";
echo "<td> (<a href='".XOOPS_URL."/modules/arcade/index.php?act=show_stats&amp;gid=".$row->gid."'>"._MDB_ALLSCORES."</a>)</td></tr>";
echo "<tr><td colspan='7'><hr></td></tr>";
}

echo "</table></p>";
CloseTable();

} else {
redirect_header("index.php", 3, _NOPERM);
exit();
}

include("../../footer.php");

?>

<?php

$config = array(

gname => '123',
gtitle => '123 das coole Spiel',
bgcolor => '000000',
gwidth => '650',
gheight => '600',
active => '1',
gcat => '1',

//optional
gwords => ' Schiese und lerne Mathe ',
object => ' Beschiese so viele 1,2 oder 3 wie nur geht. ',
gkeys => ' Spielt man mit Maus oder tastatur ',

);?>

INSERT INTO arcade_games VALUES (gid(ID), 'gname(123)', ' gwords(Schiese und lerne Mathe) ', gcount(0), 'gtitle(123 das coole Spiel)', 'bgcolor(000000)', active(1), gwitdth(650), gheight(600), position(1), cat_id(1), 'objekt(Beschiese so viele 1,2 oder 3 wie nur geht)', 'gkeys(Spielt man mit Maus oder tastatur)', date_addes(0));