// Npszer jtk - Szls panelos

if (!defined("DB_VGAME")) {
	define("DB_VGAME", DB_PREFIX."varcade_games");
}

// Jtk Beolvassa
$g_info = dbquery("SELECT * FROM ".DB_VGAME." ORDER BY played DESC LIMIT 5 ");
openside("Npszer jtkunk");
while ($ajanlo_game_info = dbarray($g_info)){
$ajanlo_kiskep = "<img src='".INFUSIONS."varcade/uploads/thumb/".$ajanlo_game_info['icon']."' width='40' alt='' />";
echo "<table align='center' width='100%' cellpadding='0' cellspacing='0'><tr>";
echo "<td class='tbl2' width='40' align='left'>".$ajanlo_kiskep."</td>\n";
echo "<td class='tbl2' align='right'><a href='".INFUSIONS."varcade/arcade.php?game=".$ajanlo_game_info['lid']."'><b>".trimlink($ajanlo_game_info['title'],20)."</b></a><br />Megnyitva: <b>".$ajanlo_game_info['played']."</b><br />Rekord: <b>".number_format($ajanlo_game_info['hiscore'])."</b><br />".showdate("%Y.%m.%d %H:%M",$ajanlo_game_info['hiscoredate'])."<br />Bajnok: <b>".trimlink($ajanlo_game_info['hi_player'],15)."</b></td>\n";
echo "</tr>\n</table>\n";
}
closeside();



// Most jtszottak vele - Szls panelos

if (!defined("DB_VGAME")) {
	define("DB_VGAME", DB_PREFIX."varcade_games");
}

$g_info = dbquery("SELECT * FROM ".DB_VGAME." WHERE lastplayed!='0' && hiscoredate!='' ORDER BY lastplayed DESC LIMIT 10 ");
openside("Most jtszottak vele");
while ($ajanlo_game_info = dbarray($g_info)){
$ajanlo_kiskep = "<img src='".INFUSIONS."varcade/uploads/thumb/".$ajanlo_game_info['icon']."' width='40' alt='' border='' title='' />";
echo "<table align='center' width='100%' cellpadding='0' cellspacing='0'><tr>";
	echo "<td class='tbl2' width='40' align='left'>".$ajanlo_kiskep."</td>\n";
	echo "<td class='tbl2' align='right'><a href='".INFUSIONS."varcade/arcade.php?game=".$ajanlo_game_info['lid']."'><b>".trimlink($ajanlo_game_info['title'],13)."</b></a><br />Rekord: ".number_format($ajanlo_game_info['hiscore'])."<br />".showdate("%Y.%m.%d %H:%M",$ajanlo_game_info['hiscoredate'])."<br />Bajnok: ".trimlink($ajanlo_game_info['hi_player'],13)."</td>\n";
echo "</tr>\n</table>\n";
}
closeside();


// Kedvncekbl vlaszt

if (!defined("DB_VGAME")) {
	define("DB_VGAME", DB_PREFIX."varcade_games");
}
if (!defined("DB_VFAVORIT")) {
	define("DB_VFAVORIT", DB_PREFIX."varcade_favourites");
}
if (!defined("DB_VSCORE")) {
	define("DB_VSCORE", DB_PREFIX."varcade_score");
}

opentable("Kedvencek");
echo "<fieldset><legend>[ Ezek a jtkot mr szerepelnek a kedvencek kztt ]</legend>\n";
echo "<table align='center' width='100%' cellpadding='1' cellspacing='1'>";
echo "<tr>";
echo "
<td class='tbl1' align='center'>Ikon</td>\n
<td class='tbl1' align='center'>Jtk Neve</td>\n
<td class='tbl1' align='center'>Kinek Kedvence</td>\n
<td class='tbl1' align='center'>Jtszottl mr vele ?</td>\n

";
echo "</tr>\n";
	$result = dbquery("SELECT ts.*, tu.*, tp.*, tk.* FROM ".DB_VFAVORIT." ts
	LEFT JOIN ".DB_VGAME." tu ON tu.icon = ts.fav_icon
	LEFT JOIN ".DB_VSCORE." tp ON tp.game_id = tu.lid
	LEFT JOIN ".DB_USERS." tk ON tk.user_id = ts.fav_user
	WHERE tp.game_score > 0
	ORDER BY RAND() LIMIT 5 ");
		while ($fg = dbarray($result)){
		$kiskep = "<img src='".INFUSIONS."varcade/uploads/thumb/".$fg['icon']."' width='50' alt='' border='0'/>";
		if (iMEMBER){
			$jatszott = dbquery("SELECT * FROM ".DB_VSCORE." WHERE game_id='".$fg['lid']."' && player_id='".$userdata['user_id']."' ");
		}
		echo "<tr>";
		echo "<td class='tbl2' width='50'>".$kiskep."</td>\n";
		echo "<td class='tbl2'><a href='".INFUSIONS."varcade/arcade.php?game=".$fg['lid']."'><b>".trimlink($fg['title'],20)."</b></a>".(checkRights("I")?"<br /><a href='".INFUSIONS."varcade/admin/admin.php?a_page=main&amp;step=edit&amp;stats_id=".$fg['lid']."'>Jtk Szerkesztse</a>":"")."</td>\n";
		echo "<td class='tbl2' align='center'>".($fg['user_avatar'] ? "<img src='".IMAGES."avatars/".$fg['user_avatar']."' width='30px' alt='' /><br />" : "<img src='".IMAGES."noav2.png' border='0' width='30px' alt='' />")."<br /><a href='".BASEDIR."profile.php?lookup=".$fg['user_id']."'>".trimlink($fg['user_name'],15)."</a></td>\n";
		if (iMEMBER){ 
			echo "<td class='tbl2' align='center'>".(dbrows($jatszott)>0 ? "Igen" : "Mg nem")."</td>\n";
		} else {
			echo "<td class='tbl2' align='center'>Csak <a href='".BASEDIR."login.php'>belps</a> utn!</td>\n";
		}
		echo "</tr>\n";
		}
echo "</table>\n";
echo "</fieldset>\n";
closetable();





// Most szereztek vele pontot

if (!defined("DB_VGAME")) {
	define("DB_VGAME", DB_PREFIX."varcade_games");
}

if (!defined("DB_VSCORE")) {
	define("DB_VSCORE", DB_PREFIX."varcade_score");
}

$resultm = dbquery("SELECT ts.*, tu.* FROM ".DB_VSCORE." ts LEFT JOIN ".DB_USERS." tu ON ts.player_id = tu.user_id ORDER BY score_date DESC LIMIT 5");
opentable("Legutbbi eredmnyek");
echo "<fieldset><legend>[ Most szereztek pontot a kvetkezkkel ]</legend>";
echo "<table align='center' width='100%' cellpadding='1' cellspacing='1'>";
echo "<tr>
	<td class='tbl' width='40' align='center'>Ikon</td>\n
	<td class='tbl' align='center'>Jtk Neve</td>\n
	<td class='tbl' align='center'>Pont</td>\n
	<td class='tbl' align='center'>Jtkos</td>\n
	<td class='tbl' align='center'>Megnyitva</td>\n
	<td class='tbl' align='center'>Rekord</td>\n
</tr>\n";

while ($ut_game = dbarray($resultm)){
	$utolso_game_info = dbarray(dbquery("SELECT * FROM ".DB_VGAME." WHERE lid ='".$ut_game['game_id']."' "));
	$kiskep = "<img src='".INFUSIONS."varcade/uploads/thumb/".$utolso_game_info['icon']."' width='40' border='0' alt='' />";
	echo "<tr>";	
	echo "<td class='tbl2'>".$kiskep."</td>\n";
	echo "<td class='tbl2'><a href='".INFUSIONS."varcade/arcade.php?game=".$utolso_game_info['lid']."'><b>".trimlink($utolso_game_info['title'],15)."</b></a></td>\n";
	echo "<td class='tbl2' align='right'>".number_format($ut_game['game_score'])."</td>\n";
	echo "<td class='tbl2' align='center'><a href='".BASEDIR."profile.php?lookup=".$ut_game['user_id']."'>".trimlink($ut_game['user_name'],15)."</a></td>\n";
	echo "<td class='tbl2' align='center'>".($utolso_game_info['played']!=0 ? "<br />".$utolso_game_info['played'] : "Sosem")."</td>\n";
	echo "<td class='tbl2' align='right'>".number_format($utolso_game_info['hiscore'])."</td>\n";
	echo "</tr>\n";
	}
echo "</table>\n</fieldset>";
closetable();

// 4 jtkot vlaszt

opentable("Jtk Ajnlatunk");
$rresult5 = dbquery ("SELECT lid, icon, title, hi_player, hiscore FROM ".$db_prefix."varcade_games WHERE ".groupaccess('access')." AND status='2' && icon!='' ORDER BY RAND() LIMIT 4");
echo"<table width='100%' align='center' cellspacing='2' cellpadding='2'><tr>";
while ($rdata = dbarray($rresult5)){

if (file_exists(INFUSIONS."varcade/uploads/thumb/".$rdata['icon'])) {
	$ikon = "<a href='".INFUSIONS."varcade/arcade.php?game=".$rdata['lid']."'><img src='".INFUSIONS."varcade/uploads/thumb/".$rdata['icon']."' width='75' height='70' border='0' alt='' /></a>";
} else {
	$ikon = "<img src='".INFUSIONS."varcade/img/no_image.jpg' width='75' height='70' border='0' alt='' />";
}
echo "<td class='tbl2' align='center'>";
echo $ikon."<br />";
		echo trimlink($rdata['title'],15);
		echo "<br />Bajnok: ".trimlink($rdata['hi_player'],15);
		echo "<br />Pont: ".$rdata['hiscore'];
		echo "</td>\n"; 
	}
echo "</tr>\n</table>\n";
closetable();




// Jtk ajnl top listval


if (!defined("DB_VGAME")) {
define("DB_VGAME", DB_PREFIX."varcade_games");
}

$ii = 1;
// Jtk Beolvassa
$game_info = dbarray(dbquery("SELECT * FROM ".DB_VGAME." WHERE title!='' && status='2' && icon!='' ORDER BY RAND() LIMIT 1 "));


if (file_exists(INFUSIONS."varcade/uploads/thumb/".$game_info['icon'])) {
	$kiskep = "<img src='".INFUSIONS."varcade/uploads/thumb/".$game_info['icon']."' width='50' height='50' border='0' alt='' />";
} else {
	$kiskep = "<img src='".INFUSIONS."varcade/img/no_image.jpg' width='50' height='50' border='0' alt='' />";
}

opentable("Jtk Ajnl");
echo "<fieldset><legend>[ Legjobb 8 jtkos ebben a jtkban. ]</legend>\n";
echo "<table align='center' width='100%' cellpadding='0' cellspacing='0'><tr>";
	echo "<td class='tbl2' width='50'>".$kiskep."</td>\n";
	echo "<td class='tbl2'>Jtk neve:<br /><a href='".INFUSIONS."varcade/arcade.php?game=".$game_info['lid']."'><b>".trimlink($game_info['title'],15)."</b></a>".(checkRights("I") ? "<br /><a href='".INFUSIONS."varcade/admin/admin.php?a_page=main&amp;step=edit&amp;stats_id=".$game_info['lid']."'>Jtk Szerkesztse</a>" : "")."</td>\n";
	echo "<td class='tbl2' align='center'>".($game_info['played']!=0 ? "Ennyiszer jtszottak vele:<br />".$game_info['played'] : "Mg nem jtszottak vele")."</td>\n";
	echo "<td class='tbl2' align='center'>".($game_info['lastplayed']!=0 ? "Utoljra jtszottak vele:<br />".showdate("%Y.%m.%d<br />%H:%M",$game_info['lastplayed']) : "Mg nem jtszottak vele")."</td>\n";
echo "</tr>\n</table>\n";

echo "<div style='margin:10px'></div>\n";

echo "<table align='center' width='100%' cellpadding='0' cellspacing='0'><tr>";
echo "<td class='tbl2' align='left'>Jtk lers:</td>\n";
echo "<td class='tbl2' align='center'>".($game_info['description']!='' ? $game_info['description'] : "Nem tallhat lers errl a jtkrl")."</td>\n";
echo "</tr>\n</table>\n";

echo "<div style='margin:10px'></div>\n";


echo "<table align='center' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr><td class='tbl1' align='center' width='1%'><b>Helyezs</b></td>\n<td class='tbl1' align='center' width='40'><b>Avatar</b></td>\n<td class='tbl1' align='center'><b>Jtkos neve</b></td>\n<td class='tbl1' align='center'><b>Pontszma</b></td>\n<td class='tbl1' align='center'><b>Dtum</b></td>\n</tr>\n";

$resultm = dbquery("SELECT * FROM ".$db_prefix."varcade_score WHERE game_id = '".$game_info['lid']."' ORDER BY game_score DESC LIMIT 0,8");
while ($datam = dbarray($resultm)) {
	$nick = dbarray(dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id =".$datam['player_id']));
	echo "<tr>";
		echo "<td align='center' class='tbl2'>".$ii."</td>\n";
		echo "<td class='tbl2'>".($nick['user_avatar'] ? "<img src='".IMAGES."avatars/".$nick['user_avatar']."' width='40px' alt='' border='0' /><br />" : "<img src='".IMAGES."noav2.png' border='0' width='40px' alt='' /")."</td>\n";
		echo "<td align='center' class='tbl2'><a href='".BASEDIR."profile.php?lookup=".$nick['user_id']."'>".$nick['user_name']."</a></td>\n";
		echo "<td align='right' class='tbl2'>".number_format($datam['game_score'])."</td>\n";
		echo "<td align='right' class='tbl2'>".showdate("%Y.%m.%d",$datam['score_date'])."</td>\n";
		$ii++;
	echo "</tr>\n";
}
echo "</table>\n</fieldset>\n";
closetable();

 
// Senki sem jtszott vele

opentable("Senki nem jtszott vele");
echo "<table width='100%' cellspacing='1' cellpadding='1' align='center'><tr>";
$rresult5 = dbquery ("SELECT * FROM ".$db_prefix."varcade_games WHERE status='2' &&  played='0' && icon!='' ORDER BY RAND() LIMIT 4");
while($rdata = dbarray($rresult5)) {
if (file_exists(INFUSIONS."varcade/uploads/thumb/".$rdata['icon'])) {
	$ikon = "<a href='".INFUSIONS."varcade/arcade.php?game=".$rdata['lid']."'><img src='".INFUSIONS."varcade/uploads/thumb/".$rdata['icon']."' width='75' height='70' border='0' alt='' /></a>";
} else {
	$ikon = "<img src='".INFUSIONS."varcade/img/no_image.jpg' width='75' height='70' border='0' alt='' />";
}

$info = "<div class='tbl2'>".trimlink($rdata['title'],12)."</div>\n".$ikon;
echo "<td class='tbl1' width='25%' align='center'>".$info."</td>\n";
}
echo "</tr>\n</table>\n";
closetable();