All pastes #566692 Raw Edit

Someone

public text v1 · immutable
·published 2007-06-14 15:57 UTC
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 .= "&nbsp;<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&section='.$_REQUEST[section].'&order='.$_REQUEST[order].'"><img src="images/arrow-down.png" border="0"></a>';
         break;
      case 'desc':
         $arrowlink = '<a href="games.php?sort=asc&section='.$_REQUEST[section].'&order='.$_REQUEST[order].'"><img src="images/arrow-up.png" border="0"></a>';
         break;
      default:
         $arrowlink = '<a href="games.php?sort=desc&section='.$_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&section='.$_REQUEST[section].'&sort='.$_REQUEST[sort].'">Titel</a>';
   }

   if ($_REQUEST['order'] == 'genre') {
      $label_genre = 'Genre ' . $arrowlink;
   } else {
      $label_genre = '<a href="games.php?order=genre&section='.$_REQUEST[section].'&sort='.$_REQUEST[sort].'">Genre</a>';
   }

   if ($_REQUEST['order'] == 'publisher') {
      $label_publisher = 'Herausgeber ' . $arrowlink;
   } else {
      $label_publisher = '<a href="games.php?order=publisher&section='.$_REQUEST[section].'&sort='.$_REQUEST[sort].'">Herausgeber</a>';
   }

   if ($_REQUEST['order'] == 'developer') {
      $label_developer = 'Entwickler ' . $arrowlink;
   } else {
      $label_developer = '<a href="games.php?order=developer&section='.$_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&section='.$_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&section='.$_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();

   }

?>