"; function FindFullPictureName($cardname, $edition = NULL){ // zkopírujeme obrázek do složky /karty a vrátíme jeho název... global $docroot, $db; // jméno karty správně písmena if ($cardname == strtolower($cardname)) { $res = query("select name from ${db["oracle"]} where lower(name) = lower('" . mysql_real_escape_string($cardname) . "')"); $cardname = mysql_result($res, 0, 0); } // pokud není zadaná edice, musíme ji spočítat... if (!is_int($edition)) { // převést jméno edice na číslo $query = "select id from ${db["editions"]} where lower(name)=lower('" . mysql_real_escape_string($edition) . "')"; $res = query($query); if (@mysql_num_rows($res) == 0) { $edition = NULL; } else { $edition = mysql_result($res, 0, 0); } } if ($edition == NULL) { /// TODO $xname = strtolower(mysql_real_escape_string($cardname)); $query = "select o.name,v.edition from ${db["oracle"]} o join ${db["variant"]} v on o.id=v.oid join ${db["quality"]} q on v.id=q.vid join {$db["editions"]} e on v.edition=e.id where lower(o.name)='$xname' order by released DESC"; $res=query($query); if (@mysql_num_rows($res) == 0) { return false; } $edition = mysql_result($res, 0, "edition"); $cardname = mysql_result($res, 0, "name"); } $dir = "$docroot/big/".ed2path($edition)."/"; // zkusíme oddělit příponu if (strpos($cardname, "|")) { $atoms = explode("|", $cardname); $suffix = $atoms[1]; $cardname = $atoms[0]; } else { $suffix = "1"; } $cardname = str_replace(" // ", urlencode("+"), $cardname); $cardname = str_replace(array(":", "\""), "", $cardname); $pic = $dir.$cardname." ($suffix).jpg"; return ($pic); } function FindSmallPictureName($cardname, $edition = NULL){ // zkopírujeme obrázek do složky /karty a vrátíme jeho název... global $docroot, $db; // jméno karty správně písmena if ($cardname == strtolower($cardname)) { $res = query("select name from ${db["oracle"]} where lower(name) = lower('" . mysql_real_escape_string($cardname) . "')"); $cardname = mysql_result($res, 0, 0); } // pokud není zadaná edice, musíme ji spočítat... if (!is_int($edition)) { // převést jméno edice na číslo $edition = mysql_real_escape_string($edition); $query = "select id from ${db["editions"]} where lower(name)=lower('$edition')"; $res = query($query); if (@mysql_num_rows($res) == 0) { $edition = NULL; } else { $edition = mysql_result($res, 0, 0); } } if ($edition == NULL) { $xname = strtolower(mysql_real_escape_string($cardname)); $query = "select o.name,v.edition from ${db["oracle"]} o join ${db["variant"]} v on o.id=v.oid join ${db["quality"]} q on v.id=q.vid join {$db["editions"]} e on v.edition=e.id where lower(o.name)='$xname' order by released DESC"; $res=query($query); if (@mysql_num_rows($res) == 0) { return false; } $edition = mysql_result($res, 0, "edition"); $cardname = mysql_result($res, 0, "name"); } $dir = "$docroot/small/".ed2path($edition)."/"; if (strpos($cardname, "|")) { $atoms = explode("|", $cardname); $suffix = $atoms[1]; $cardname = $atoms[0]; } else { $suffix = "1"; } $cardname = str_replace(" // ", urlencode("+"), $cardname); $cardname = str_replace(":", "", $cardname); $pic = $dir.$cardname." ($suffix).jpg"; return ($pic); } if (!FindFullPictureName($name, $edition)) { $im = @imagecreatefromjpeg("cardback.jpg"); // if (!$im) { echo "Nenalezen defaultní obrázek"; } } else { // echo "dobrý název
"; $imgname = "..".FindFullPictureName($name, $edition); //echo GetFullPictureName($name); //echo $imgname; $im = @imagecreatefromjpeg($imgname); if (!$im) { $im = @imagecreatefromjpeg("cardback.jpg"); // echo "není obrázek
"; } } if (1) { header('Content-Type: image/jpeg'); imagejpeg($im); imagedestroy($im); } ?>