*
* File Name : termine.html
* Last Update : 2009-03-27
*/
include('glob/start.php');
create_thispage($thispage['id'],$thispage['uri'],$thispage['title']);
$releasetyparr = array('1'=>'Release demnächst','2'=>'Bereits erschienene Titel');
$seasonarr = explode(', ', RELEASETYPLIST);
$result = $sm_db->query("SELECT games_id, typ, date, date_format(date, '%Y') as dateyearfull, date_format(date, '%d') as dateday, date_format(date, '%m') as datemonth, date_format(date, '%y') as dateyear, str, IF(date<=now() && date_format(date, '%m'),'2','1') as releasetyp FROM games_d WHERE date>DATE_SUB(CURDATE(), INTERVAL 9 MONTH) ORDER BY date") or mysql_die($sm_db);
while($result && $db = mysqli_fetch_assoc($result)){
$games_id = $db['games_id'];
if(array_key_exists($games_id, $games_online)){
$count_platform[$games_id]++;
$typ = $db['typ'];
$dateday = $db['dateday'];
$datemonth = $db['datemonth'];
$dateyear = $db['dateyear'];
$dateyearfull = $db['dateyearfull'];
$output_text = $db['str'];
$releasetyp = $db['releasetyp'];
$gamtitle[$games_id] = ($games_online[$games_id])?''.$games_title[$games_id].'':$games_title[$games_id];
$dateyeararr[$releasetyp][] = $dateyear;
if($datemonth==0){
if(!in_array($output_text,$seasonarr)){
array_push($seasonarr, $output_text);
}
$showreleaseend[$releasetyp][$dateyear][$output_text] .= '
| '.$output_text.' '.((!$output_text)?$dateyearfull:$dateyear).' |
'.$gamtitle[$games_id].' ('.$cattitle[$typ].') |
';
}else{
$showrelease[$releasetyp][$dateyear] .= '
| '.(($dateday==0)?$monthtitle[$datemonth].' '.$dateyear:$dateday.'.'.$datemonth.'.'.$dateyear).' |
'.$gamtitle[$games_id].' ('.$cattitle[$typ].') |
';
}
}
}
while(list($releasetyp, $val) = each($releasetyparr)){
if($showrelease[$releasetyp] or $showreleaseend[$releasetyp]){
$c_body .= '
'.$val.'
';
$dateyeararr[$releasetyp] = array_unique($dateyeararr[$releasetyp]);
foreach($dateyeararr[$releasetyp] as $dateyear){
if($showrelease[$releasetyp][$dateyear]){
$c_body .= '
'.$showrelease[$releasetyp][$dateyear].'
';
}
}
foreach($seasonarr as $season){
if($showreleaseend[$releasetyp][$dateyear][$season]){
$c_body .= '
'.$showreleaseend[$releasetyp][$dateyear][$season].'
';
}
}
$c_body .= '
';
}
}
$c_body .= '
';
include('glob/end.php');
?>