Spiele";
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 = "Spiele Plattform
";
foreach ($sections AS $key => $value) {
$specialdata .= " $value
";
}
$specialdata .= "
";
$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 = '
';
break;
case 'desc':
$arrowlink = '
';
break;
default:
$arrowlink = '';
break;
}
if ($_REQUEST['order'] == 'title') {
$label_title = 'Titel ' . $arrowlink;
} else {
$label_title = 'Titel';
}
if ($_REQUEST['order'] == 'genre') {
$label_genre = 'Genre ' . $arrowlink;
} else {
$label_genre = 'Genre';
}
if ($_REQUEST['order'] == 'publisher') {
$label_publisher = 'Herausgeber ' . $arrowlink;
} else {
$label_publisher = 'Herausgeber';
}
if ($_REQUEST['order'] == 'developer') {
$label_developer = 'Entwickler ' . $arrowlink;
} else {
$label_developer = 'Entwickler';
}
if ($_REQUEST['order'] == 'release_date') {
$label_release = 'veröffentlicht am ' . $arrowlink;
} else {
$label_release = 'veröffentlicht am';
}
if ($_REQUEST['order'] == 'section') {
$label_section = 'Plattform ' . $arrowlink;
} else {
$label_section = 'Plattform';
}
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();
}
?>