function cardid2filename($text)
{
$kort = mysql_fetch_array(mysql_query("SELECT name, exp, version FROM cards WHERE id = " . $text));
$exp = eregi_replace(" ", "", $kort[exp]);
$exp = eregi_replace("'", "", $exp);
$text = strtolower($exp) . "/" . cardname2filename($kort[name], $kort[version]);
return $text;
}
echo $rarity[$r];
?>
, <?php
echo $exp_info["exp_name"];
?>
</span></h1>
<div class="cardstats text">
<?php
$cards = mysql_query($query = "SELECT *, '' AS version FROM md_cards\n\t\t\t\t\tWHERE\n\t\t\t\t\tIF('{$r}'='all',true,card_rarity = '{$r}') AND IF('{$c}'='all',true,FIND_IN_SET('{$c}',card_color))\n\t\t\t\t\tAND fk_exp_id = '{$e}'\n\t\t\t\t\tORDER BY card_current_rating DESC");
$bildexp = eregi_replace(' ', "", stripslashes($exp_info[exp_name]));
$bildexp = eregi_replace("'", "", strtolower($bildexp));
$xet = $col = 0;
while ($card = mysql_fetch_array($cards)) {
$xet++;
$col++;
$bildurl = "../cardpics/" . $bildexp . "/" . cardname2filename($card[card_name], $card[version]);
if (!$firstcard_src) {
$firstcard_src = $bildurl;
}
?>
<div class="card shadow"><img src="<?php
echo $bildurl;
?>
" onmouseover="viewCard('<?php
echo $bildurl;
?>
');" alt="" class="cardpic" />
<div class="starbox">
<h3><?php
echo $xet;
?>
$bildexp = eregi_replace("'", "", strtolower($bildexp));
}
if ($pick[pk_card_id] == $_POST[chosen_card]) {
$kortnamn = "<span class=\"" . color2class($pick[card_color]) . "\">" . $pick["card_name"] . "</span>";
if ($xet == 1) {
$title = "Sweet!";
$grade = "We think you made the right pick since {$kortnamn} has higher points than the rest.";
} elseif ($xet == 2) {
$title = "OK!";
$grade = "We think you made an alright pick since {$kortnamn} has the second best points of the three.";
} elseif ($xet == 3) {
$title = "Ouch...";
$grade = "Nooo... bad choice. At least does the community think so since {$kortnamn} is rated as the worst card of the three.";
}
}
$list_output .= "\n\t\t\t\t<li><span onmouseover=\"viewCard('../cardpics/" . $bildexp . "/" . cardname2filename($pick[card_name], $pick[version]) . "')\" class=\"pointer " . color2class($pick[card_color]) . "\">" . $pick[card_name] . "</span>\n\t\t\t\t <br /><span class=\"grey\">" . $pick[stats_rating] . " points</span></li>";
}
?>
<h1><?php
echo $title;
?>
</h1><br />
<p class="text"><?php
echo $grade;
?>
</p>
<ol class="small">
<?php
echo $list_output;
?>
?>
You were the first to pick today! :)<?php
}
?>
</span></h2>
<ol class="small">
<?php
while ($pick = mysql_fetch_array($picks)) {
$bildexp = eregi_replace(' ', "", stripslashes($pick[exp_name]));
$bildexp = eregi_replace("'", "", strtolower($bildexp));
?>
<li><span onmouseover="viewCard('cardpics/<?php
echo $bildexp;
?>
/<?php
echo cardname2filename($pick[card_name], $pick[version]);
?>
')" class="pointer <?php
echo color2class($pick[card_color]);
?>
"><?php
echo $pick[card_name];
?>
</span>
<br /><span class="grey"><?php
echo round($pick[nmb] / $nmb_voters * 100);
?>
% (<?php
echo $pick[nmb];
?>
)</span></li>
if ($card[packcard_is_foil]) {
?>
<div class="foil" <?php
echo $mouseover;
?>
></div><?php
}
?>
<img id="cardimg_<?php
echo $x;
?>
" src="../cardpics/<?php
echo $bildexp;
?>
/<?php
echo cardname2filename($card[name], $card[version]);
?>
"<?php
if (!$card[packcard_is_foil]) {
echo " " . $mouseover;
}
?>
alt="<?php
echo stripslashes($card[name]);
?>
" class="cardpic" />
</div>
<input type="hidden" name="cardarray[<?php
echo $card[fk_card_id];
?>
]" value="<?php
function printDraftPicks($draft_id, $_sort_order = "time", $_color_array = false)
{
global $draft_info;
global $cards_drafted;
if (!$_color_array) {
$_color_array = $_SESSION["color_array"];
}
if ($_sort_order == "color") {
$sort_order = "find_in_set(card_color, 'L,A,G,R,B,U,W') DESC, card_cmcost DESC";
} elseif ($_sort_order == "cost") {
$sort_order = "card_cmcost";
} elseif ($_sort_order == "cardtype") {
$sort_order = "card_toughness DESC, card_type";
} elseif ($_sort_order == "time") {
$sort_order = "fk_pack_id DESC, pick_number DESC";
}
$_SESSION["sort_order"] = $_sort_order;
$_SESSION["color_array"] = $_color_array;
$color_filter = " AND (";
foreach ($_color_array as $one_color) {
$color_filter .= "FIND_IN_SET('" . $one_color . "',card_color) OR ";
}
$color_filter = substr($color_filter, 0, -4) . ")";
include_once "../include/kortparm_functions.php";
$cards = mysql_query($apa = "SELECT card_name, '' as version, fk_card_id, COUNT(fk_card_id) AS nmb, exp_name, packcard_is_foil, IF(CHAR_LENGTH(card_color) > 1,'Multi',card_color) AS card_color, pk_packcard_id, card_rarity, card_cmcost, IF(card_type LIKE 'Creature%','Creature',card_type) AS card_type, card_toughness\n\t\tFROM md_packcard, md_pack,md_cards \n\t\tINNER JOIN md_exp ON md_cards.fk_exp_id = pk_exp_id\n\t\tWHERE fk_card_id = pk_card_id AND fk_pack_id = pk_pack_id AND md_packcard.fk_user_id = {$_SESSION['md_userid']} AND md_pack.fk_draft_id = {$draft_id} AND packcard_hidden = 0\n\t\t{$color_filter}\n\t\tGROUP BY fk_card_id\n\t\tORDER BY {$sort_order}");
$nmb_deck = mysql_num_rows($cards);
$x = 0;
if ($draft_info[show_picks] == "1" || ($cards_drafted == 15 || $cards_drafted == 30)) {
$output = "<h2>My picks</h2>";
$output .= "<span class=\"text\" id=\"deckstats\">" . deckstats($draft_id) . "</span>";
$output .= "<p class=\"mini\">Order by <span class=\"orange pointer\" onclick=\"javascript:setXYposition('indicator',event); javascript:orderDeck('picks','" . $draft_id . "','time',true);\">time</span> | <span class=\"orange pointer\" onclick=\"javascript:setXYposition('indicator',event); javascript:orderDeck('picks','" . $draft_id . "','color',true);\">color</span> | <span class=\"orange pointer\" onclick=\"javascript:setXYposition('indicator',event); javascript:orderDeck('picks','" . $draft_id . "','cost',true);\">cost</span> | <span class=\"orange pointer\" onclick=\"javascript:setXYposition('indicator',event); javascript:orderDeck('picks','" . $draft_id . "','cardtype',true);\">type</span></p>";
$output .= '<div class="breaker"></div><div class="filter_buttons small">
<img id="color_W" src="../images/button_white_small.png"';
if (array_search("W", $_color_array) !== false) {
$output .= ' class="active"';
}
$output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'W\',\'' . $draft_id . '\',\'picks\',\'' . $_sort_order . '\');" alt="" />
<img id="color_U" src="../images/button_blue_small.png"';
if (array_search("U", $_color_array) !== false) {
$output .= ' class="active"';
}
$output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'U\',\'' . $draft_id . '\',\'picks\',\'' . $_sort_order . '\');" alt="" />
<img id="color_B" src="../images/button_black_small.png"';
if (array_search("B", $_color_array) !== false) {
$output .= ' class="active"';
}
$output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'B\',\'' . $draft_id . '\',\'picks\',\'' . $_sort_order . '\');" alt="" />
<img id="color_R" src="../images/button_red_small.png"';
if (array_search("R", $_color_array) !== false) {
$output .= ' class="active"';
}
$output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'R\',\'' . $draft_id . '\',\'picks\',\'' . $_sort_order . '\');" alt="" />
<img id="color_G" src="../images/button_green_small.png"';
if (array_search("G", $_color_array) !== false) {
$output .= ' class="active"';
}
$output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'G\',\'' . $draft_id . '\',\'picks\',\'' . $_sort_order . '\');" alt="" />
<img id="color_A" src="../images/button_artifacts_small.png"';
if (array_search("A", $_color_array) !== false) {
$output .= ' class="active"';
}
$output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'A\',\'' . $draft_id . '\',\'picks\',\'' . $_sort_order . '\');" alt="" />
<img id="color_L" src="../images/button_lands_small.png"';
if (array_search("L", $_color_array) !== false) {
$output .= ' class="active"';
}
$output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'L\',\'' . $draft_id . '\',\'picks\',\'' . $_sort_order . '\');" alt="" />
</div>';
while ($card = mysql_fetch_array($cards)) {
if ($_sort_order == "cardtype") {
if (strpos($card[card_type], "Creature") > -1 || $card[card_toughness] > "") {
$cardtype = "Creature";
} elseif (strpos($card[card_type], "Enchantment") > -1) {
$cardtype = "Enchantment";
} elseif (strpos($card[card_type], "Artifact") > -1) {
$cardtype = "Artifact";
} elseif (strpos($card[card_type], "Sorcery") > -1) {
$cardtype = "Sorcery";
} elseif (strpos($card[card_type], "Instant") > -1 || strrpos($card[card_type], "Interrupt") > -1) {
$cardtype = "Instant";
} elseif (strpos($card[card_type], "Land") > -1) {
$cardtype = "Land";
}
}
$bildexp = eregi_replace(' ', "", stripslashes($card[exp_name]));
$bildexp = eregi_replace("'", "", strtolower($bildexp));
if ($_sort_order == "cost" && $lastcmcost != $card["card_cmcost"]) {
$output .= "<div class=\"breaker grey mini\">" . $card["card_cmcost"] . "cc</div>";
} elseif ($_sort_order == "color" && $lastcolor != $card["card_color"]) {
$output .= "<div class=\"breaker grey mini\">" . colortag2word($card["card_color"]) . "</div>";
} elseif ($_sort_order == "cardtype" && !strstr($card["card_type"], $lastcardtype)) {
$output .= "<div class=\"breaker grey mini\">" . $card["card_type"] . "</div>";
}
$mouseover = "onmouseover=\"viewCard('../cardpics/" . $bildexp . "/" . cardname2filename($card[card_name], $card[version]) . "',event);\"\n\t\t\tonclick=\"javascript:hideCard('" . $card[pk_packcard_id] . "');\"";
$output .= '<div alt="' . stripslashes($card[card_name]) . '" class="mini card" style="" id="card' . $card[pk_packcard_id] . '" ' . $mouseover . '>';
if ($card[packcard_is_foil]) {
$output .= '<div class="foil" ' . $mouseover . '></div>';
}
if ($card[nmb] > 1) {
$output .= "<div class=\"cardcount\">" . $card[nmb] . "</div>";
}
$output .= '<img src="../cardpics/' . $bildexp . '/' . cardname2filename($card[card_name], $card[version]) . '"';
if (!$card[packcard_is_foil]) {
$output .= " " . $mouseover;
}
$output .= 'alt="' . stripslashes($card[card_name]) . '" class="mini cardpic" /></div>';
$lastcolor = $card[card_color];
$lastcmcost = $card[card_cmcost];
$lastcardtype = $cardtype;
}
}
$output .= "<div class=\"breaker\"></div>";
return $output;
}
<form action="draft.php" method="post">
<input type="hidden" name="action" value="build_deck">
<br />
<div id="deck">
<?php
echo printDeck($draft_id, "deck", $_SESSION["sort_order"]);
?>
</div>
</form>
</div>
<?php
$first_card = mysql_fetch_array(mysql_query($apa = "SELECT card_name AS name, '' AS version, exp_name AS exp\n\t\tFROM md_packcard, md_pack, md_cards, md_exp\n\t\tWHERE fk_card_id = pk_card_id AND fk_pack_id = pk_pack_id AND md_cards.fk_exp_id = pk_exp_id\n\t\tAND md_packcard.fk_user_id = {$_SESSION['md_userid']} AND md_pack.fk_draft_id = {$draft_id} AND in_deck = '0'\n\t\tLIMIT 0,1"));
$bildexp = eregi_replace(' ', "", stripslashes($first_card[exp]));
$bildexp = eregi_replace("'", "", strtolower($bildexp));
$firstcard_src = "../cardpics/" . $bildexp . "/" . cardname2filename($first_card[name], $first_card[version]);
?>
<div id="right" style="width: 350px;">
<div style="float: right;" class="small" id="show_cardviewer"><img src="<?php
echo $path;
?>
/images/zoom.png" alt="" style="vertical-align: middle;"> <span class="text blue pointer" onclick="toggleCardViewer('show');">Show cardviewer</span></div>
<div id="cardviewer" class="mini"><div onclick="toggleCardViewer('hide');" id="closecard"><img src="<?php
echo $path;
?>
/images/close.png"></div><div id="cardcloseup"><img src="<?php
echo $firstcard_src;
?>
"></div></div>
<br />
