+
+
+
+
+
+
".$txt["combined"]." ".$txt["browse"]."
".$txt['games']."
"; ?>
0) {?>
:
:
".$weight_full_limit.",AVG(game_rate),IF(COUNT(ertekeltek.game_id)>".$weight_sub_limit.",AVG(game_rate)*".$weight_sub_ratio.",AVG(game_rate)*".$weight_min_ratio.")) AS weight, ROUND(AVG(game_rate),1) AS real_avg FROM games filmek LEFT JOIN rate_games ertekeltek ON filmek.game_id= ertekeltek.game_id AND ertekeltek.userid IN (".$_SESSION['active_list_userids'].") GROUP BY filmek.game_id ORDER BY filmek.game_id DESC LIMIT 33";
$eredmeny = mysql_query($parancs, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
if(mysql_num_rows($eredmeny)>0){
$pieces = explode(" ", $datetime);
$date=$pieces[0];
$currDate=$date;
$time=$pieces[1];
$datepieces = explode("-", $date);
$curryear=$datepieces[0];
$month=$datepieces[1];
$day=$datepieces[2];
while ( $sor = mysql_fetch_array($eredmeny)){
print "![](pix/gamecover/".$sor[)
";
print "";
$sorszam++;
}
}
?>
".$sor['title']."
"; if($lng=="hun"){ if (strlen($sor['hun_title'])>0 && $sor['hun_title']!=$sor['title'] ){ print $sor['hun_title']; } }else{ if (strlen($sor['eng_title'])>0){ print $sor['eng_title']; } } print "
".$sor['year']."
".$txt['average']."
";
if($_SESSION['belepett']==true){
$notlogged1="";
$notlogged2="";
}else{
$notlogged1="no";
$notlogged2="No";
}
print "".number_format($sor['real_avg'],1)."
".$sor['rate_num']." ".$txt['members']."";
$thiswannasee=0;
if($_SESSION['belepett']==true){
$parancs88 = "SELECT game_id FROM wannaplay WHERE game_id='".$sor['game_id']."' AND nick='".$_SESSION['nick']."' " ;
$eredmeny88 = mysql_query($parancs88, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
}
$thiswannasee=mysql_num_rows($eredmeny88);
$is_released=1;
$to_release;
if($sor['release_date']>$datetime){
$is_released=0;
$to_release;
$release_pieces = explode(" ", $sor['release_date']);
$release_date=$release_pieces[0];
$diff = abs(strtotime($release_date) - strtotime($currDate));
$to_release = floor($diff / (60*60*24));
$release_datepieces = explode("-", $release_date);
$release_year=$release_datepieces[0];
$release_nummonth=$release_datepieces[1];
$release_day=$release_datepieces[2];
switch ($release_nummonth) {
case 01:
$release_month=$txt["january"];
break;
case 02:
$release_month=$txt["february"];
break;
case 03:
$release_month=$txt["march"];
break;
case 04:
$release_month=$txt["april"];
break;
case 05:
$release_month=$txt["may"];
break;
case 06:
$release_month=$txt["june"];
break;
case 07:
$release_month=$txt["july"];
break;
case 8:
$release_month=$txt["august"];
break;
case 9:
$release_month=$txt["september"];
break;
case 10:
$release_month=$txt["october"];
break;
case 11:
$release_month=$txt["november"];
break;
case 12:
$release_month=$txt["december"];
break;
}
if ($lng=="hun"){
$release_date=$release_year.". ".$release_month." ".$release_day.".";
}else{
$release_date=$release_day." ".$release_month." ".$release_year;
}
}
if($_SESSION['belepett']==true){
$parancs99 = "SELECT game_rate FROM rate_games WHERE game_id='".$sor['game_id']."' AND nick='".$_SESSION['nick']."' " ;
$eredmeny99 = mysql_query($parancs99, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$thisgamerate=0;
while ( $sor99 = mysql_fetch_array($eredmeny99)){
$thisgamerate=$sor99['game_rate'];
}
}
if($is_released>0){
for($r=5;$r>=1;$r--){
print " ";
}
}
print " ";
if($is_released==0){
if ($lng=="hun"){
echo "
";
echo "";
echo "Premier: ".$to_release." nap
";
}else{
echo "";
echo "Premire: ".$to_release." days
";
}
}
print " i
";
echo "";
//echo "hellobello1";
echo "
";
print "