\n");
printf ("| %s |
", $headlineText, $headlineText);
print ("");
print ("| | ");
print ("Name (Deu/Eng) | ");
print ("Skill- level | ");
print ("Spieler- level | ");
print ("Attribute | ");
print (" | ");
print ("Komponenten (Anzahl) |
\n");
$query = "select rezept.*, locType.* from rezept, reztype, attribute, rez_atr, locType " .
"where reztype.typeName = \"Schneider\" " .
" and rezept.typeIndex = reztype.typeIndex" .
" and attribute.name_de in (" . $Filter . ")" .
" and rez_atr.atrIndex = attribute.atrIndex " .
" and rezept.rezIndex = rez_atr.rezIndex " .
" and locType.locIndex = rezept.locIndex " .
" order by rezept.locIndex, skilllevel, playerlevel";
$iconPath = "../icons/";
$link = mysql_connect("mysql3.kontent.de", "net1182731", "jf310500")
or die("DB Verbindung nicht möglich");
mysql_select_db("net1182731");
$res = mysql_query($query, $link);
if ( !$res )
die("Die Anfrage '$query' konnte nicht ausgeführt werden.");
// Daten auslesen
while ( $row = mysql_fetch_array($res, MYSQL_ASSOC) )
{
print ("");
printf ("![\"%s\"](\"%s%s\") | ",
$iconPath, $row["picture"], $row["name_de"]);
printf ("%s
%s",
$row["name_de"], $row["name_en"]);
if ($row["bemerkung"] == NULL)
print(" | ");
else
printf ("
", $row["bemerkung"]);
printf ("%s | ", $row["skilllevel"]);
printf ("%s | ", $row["playerlevel"]);
printf ("%s | ", getAttributesWithHighlight ($row["rezIndex"], $Keyword, $highColor, $link));
printf ("%s | ", $row["locName"]);
printf ("%s | ", getIngredients($row["rezIndex"], $link));
print ("
\n");
}
?>
