'-1') { $sql = "SELECT id,identifier FROM ifguide_data WHERE identifier LIKE '$firma%'"; $result = mysql_query($sql,$conn); $p=mysql_fetch_array($result,MYSQL_ASSOC); $zeige=$p["id"]; $numeric="0"; } if ($firma == '-1') { $sql = "SELECT identifier,id FROM ifguide_data WHERE id='$zeige'"; $result = mysql_query($sql,$conn); $p=mysql_fetch_array($result,MYSQL_ASSOC); $firma=$p["identifier"]; $numeric="1"; } // spill out the content-table for html.... ?>


\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
  \n"; echo "

 

The Interactive Fiction Collector's Guide

Copyright (c) 1997 - 2001 by Manuel Schulz
 

\"$alt\"
Index by Manufacturer
Index by Title
Essay
Table of Contents
\"Backward\"
\"Forward\"
\n"; echo "

 \n"; // get the data from the database and show the game $sql = "SELECT title,callname,\"release\",publisher,systems,media,produntil,packaging,dimensions,contents,value,relations FROM ifguide_data WHERE id=$zeige "; $result = mysql_query($sql,$conn); echo "\n"; echo ""; echo "\n"; } if (!file_exists($testfile)) { echo "\"$alt\"\n"; } echo "
\n"; $ergebnis=mysql_fetch_array($result); $p=$ergebnis["title"]; $alt=$p; echo "
$p

\n"; echo "
 
 
"; echo "\n"; $suchees=$p; while (strpos($suchees,",") <> '') { $zaehler++; $relati[$zaehler]=substr($suchees,0,strpos($suchees,",")); $suchees=substr($suchees,strpos($suchees,",")+1); } $zaehler++; $relati[$zaehler]=$suchees; if ($relati[1] <> 'None') { echo "
"; $p=$ergebnis["callname"]; echo "Characterization: $p
\n"; $p=$ergebnis["release"]; echo "Release Date: $p
\n"; $p=$ergebnis["publisher"]; echo "Publisher: $p
\n"; $p=$ergebnis["systems"]; // $selbst=$argv[0]; echo "Systems: $p
\n"; $p=$ergebnis["media"]; echo "Media: $p
\n"; $p=$ergebnis["produntil"]; echo "Production until: $p
\n"; $p=$ergebnis["packaging"]; echo "Packaging: $p
\n"; $p=$ergebnis["dimensions"]; echo "Dimensions: $p
\n"; $p=$ergebnis["contents"]; echo "Contents: $p
\n"; $p=$ergebnis["value"]; echo "Value: $p
\n"; $p=$ergebnis["relations"]; // calculate the relationz... if (!$p) { $p="None"; } echo "Relations: "; for ($i=1;$i<=$zaehler;$i++) { $e=$relati[$i]; $sql = "SELECT id,callname FROM ifguide_data WHERE id='$e'"; $result = mysql_query($sql,$conn); $next=mysql_fetch_array($result,MYSQL_ASSOC); $p=$next["id"]; $q=$next["callname"]; $q=substr($q,0,(strlen($q)-1)); if ($numeric == '0') { echo "$q
\n"; } if ($numeric == '1') { echo "$q
\n"; } } echo "
\n"; } if ($relati[1] == 'None') { echo "None
\n"; } echo "
\n"; // show the pic $testfile="../scans/$zeige."."jpg"; clearstatcache(); if (file_exists($testfile)) { echo "\"$alt\"
\n"; // und ende... ?>