rendered paste body<?php
error_reporting(E_ALL & ~E_NOTICE);
@set_magic_quotes_runtime(0);
$location .= " > <b>Spiele</b>";
require_once("global.php");
if (empty($_REQUEST['do'])) {
@@ $sql = "SELECT *,date_format(`release_date`, '%d.%m.%Y') FROM `sp_games` ";
if (!empty($_REQUEST['title'])) {
$sql .= "WHERE `title` LIKE '$_REQUEST[title]%' ";
if (!empty($_REQUEST['section'])) {
$sql .= " AND `section` = '$_REQUEST[section]' ";
}
$sql .= " AND `published` = '1' ";
} else {
if (!empty($_REQUEST['section'])) {
$sql .= "WHERE `section` = '$_REQUEST[section]' AND `published` = '1' ";
} else {
$sql .= "WHERE `published` = '1' ";
}
}
if (isset($_REQUEST[order])) {
$sql .= " ORDER BY `$_REQUEST[order]` ";
} else {
$sql .= " ORDER BY `title` ";
}
switch($_REQUEST['sort']) {
case 'asc':
$sql .= " ASC ";
break;
case 'desc':
$sql .= " DESC ";
break;
default:
$sql .= " ASC ";
break;
}
if ($sql == "SELECT *,date_format(release_date, '%d.%m.%Y') AS date_release FROM `sp_games` WHERE `published` = '1' ORDER BY `title` ASC") {
$sql .= " LIMIT 0,20 ";
}
$sections = array();
$sql2 = $db->Execute("SELECT * FROM `sp_games_sections` ORDER BY `title`");
while ($srow = $sql2->FetchNextObject()) {
$sections["$srow->ID"] = stripslashes($srow->TITLE);
}
$specialdata = "<b>Spiele Plattform</b><br />";
foreach ($sections AS $key => $value) {
$specialdata .= " <a href=\"games.php?section=$key\">$value</a><br />";
}
$specialdata .= "<br />";
$companies = array();
$company_sql = $db->Execute("SELECT * FROM `sp_companies` ORDER BY `title`");
while ($crow = $company_sql->FetchNextObject()) {
$companies["$crow->ID"] = stripslashes($crow->TITLE);
}
do_header();
switch ($_REQUEST['sort']) {
case 'asc':
$arrowlink = '<a href="games.php?sort=desc§ion='.$_REQUEST[section].'&order='.$_REQUEST[order].'"><img src="images/arrow-down.png" border="0"></a>';
break;
case 'desc':
$arrowlink = '<a href="games.php?sort=asc§ion='.$_REQUEST[section].'&order='.$_REQUEST[order].'"><img src="images/arrow-up.png" border="0"></a>';
break;
default:
$arrowlink = '<a href="games.php?sort=desc§ion='.$_REQUEST[section].'&order='.$_REQUEST[order].'"><img src="images/arrow-down.png" border="0"></a>';
break;
}
if ($_REQUEST['order'] == 'title') {
$label_title = 'Titel ' . $arrowlink;
} else {
$label_title = '<a href="games.php?order=title§ion='.$_REQUEST[section].'&sort='.$_REQUEST[sort].'">Titel</a>';
}
if ($_REQUEST['order'] == 'genre') {
$label_genre = 'Genre ' . $arrowlink;
} else {
$label_genre = '<a href="games.php?order=genre§ion='.$_REQUEST[section].'&sort='.$_REQUEST[sort].'">Genre</a>';
}
if ($_REQUEST['order'] == 'publisher') {
$label_publisher = 'Herausgeber ' . $arrowlink;
} else {
$label_publisher = '<a href="games.php?order=publisher§ion='.$_REQUEST[section].'&sort='.$_REQUEST[sort].'">Herausgeber</a>';
}
if ($_REQUEST['order'] == 'developer') {
$label_developer = 'Entwickler ' . $arrowlink;
} else {
$label_developer = '<a href="games.php?order=developer§ion='.$_REQUEST[section].'&sort='.$_REQUEST[sort].'">Entwickler</a>';
}
if ($_REQUEST['order'] == 'release_date') {
$label_release = 'veröffentlicht am ' . $arrowlink;
} else {
$label_release = '<a href="games.php?order=release_date§ion='.$_REQUEST[section].'&sort='.$_REQUEST[sort].'">veröffentlicht am</a>';
}
if ($_REQUEST['order'] == 'section') {
$label_section = 'Plattform ' . $arrowlink;
} else {
$label_section = '<a href="games.php?order=section§ion='.$_REQUEST[section].'&sort='.$_REQUEST[sort].'">Plattform</a>';
}
include("templates/games_listheader.inc.php");
$result = $db->Execute($sql) or die($db->ErrorMsg());
while ($row = $result->FetchNextObject()) {
$bgcolor = ($bgcolor == "#FFFFFF" ? "#E9E9E9" : "#FFFFFF");
$section = stripslashes($sections["$row->SECTION"]);
$publisher = stripslashes($companies["$row->PUBLISHER"]);
$developer = stripslashes($companies["$row->DEVELOPER"]);
include("templates/games_listbit.inc.php");
}
include("templates/games_listfooter.inc.php");
do_footer();
}
?>