<% ################################################### # (Disney-) Lexikon (c) Thomas.Tausend@DLPfan.ORG # ################################################### # timestamp_mysql2german - wandelt ein MySQL-Timestamp # in ein traditionelles deutsches Datum um. # require("../../temp/ref.htm"); require("./dfunctions.html"); if (!$number) $number = 10; if(!$start OR $start<0) $start=0; require("../../scripts/dbdetails.php"); $dbcode = mysql_connect($host,$user,$pw); if(!$dbcode): echo "Kein Kontakt zur Datenbank"; endif; if ($id): $query="SELECT keywords.*,keywordsSUB.id AS refid, keywordsSUB.headline AS refheadline FROM (keywords LEFT JOIN keywords AS keywordsSUB ON keywords.ref = keywordsSUB.id) WHERE keywords.id=$id"; elseif ($suchtext): $query="SELECT keywords.*,keywordsSUB.id AS refid, keywordsSUB.headline AS refheadline FROM (keywords LEFT JOIN keywords AS keywordsSUB ON keywords.ref = keywordsSUB.id) WHERE keywords.ok!=\"\" AND keywords.headline LIKE \"%$suchtext%\" ORDER BY keywords.headline"; elseif ($bst): $query="SELECT keywords.*,keywordsSUB.id AS refid, keywordsSUB.headline AS refheadline FROM (keywords LEFT JOIN keywords AS keywordsSUB ON keywords.ref = keywordsSUB.id) WHERE keywords.ok!=\"\" AND keywords.headline LIKE \"$bst%\" ORDER BY keywords.headline"; else: $query="SELECT keywords.*,keywordsSUB.id as refid, keywordsSUB.headline as refheadline from (keywords LEFT JOIN keywords AS keywordsSUB ON keywords.ref = keywordsSUB.id) WHERE keywords.ok!=\"\" ORDER BY keywords.headline"; endif; $result = mysql_db_query($db,$query); $all=mysql_numrows($result); $result = mysql_db_query($db,$query." LIMIT $start, $number"); if($mode!="single"): %>

Das DLPfan.ORG Disney-Lexikon

Gib einfach einen Suchbegriff ein oder blättere alphabetisch durch die Einträge!

<% require ("./bsttab.html"); $anzahl=mysql_numrows($result); echo "
Einträge " . ($start+1) . " bis " . ($start+$anzahl) . " von $all
"; endif; %> <% while($row = mysql_fetch_array($result)): %> <% $link=$row["id"]; $query="SELECT * FROM date WHERE linkto = $link ORDER BY date"; $dateresult = mysql_query($query); $dateanzahl=mysql_numrows($dateresult); if ($dateanzahl>0): %> <% while($drow = mysql_fetch_array($dateresult)): %> <% endwhile; %> <% endif; if ($row["refid"]): %> <% endif; %> <% endwhile; mysql_free_result($result); %>
<% if($mode=="reflookup"): %> <%echo $row["headline"]; %> <% else: %>  <% echo $row["headline"]; %> <% endif; %>
<% echo $row["text"]; %>
<% echo $drow["datetext"] . ": " . mysql2de($drow["date"]); %>
siehe auch: "><%echo $row["refheadline"]; %>
<% echo mysqlts2de($row["added"]); %>
<% echo $row["author"]; %>
<% if ($mode!="single"): require ("./bsttab.html"); endif; %>