PageRenderTime 98ms CodeModel.GetById 25ms RepoModel.GetById 0ms app.codeStats 0ms

/functions.php

https://github.com/beakid/md
PHP | 1098 lines | 1022 code | 47 blank | 29 comment | 327 complexity | 45a14e28df84ea0ab491557cd2443358 MD5 | raw file

Large files files are truncated, but you can click here to view the full file

    

  1. <?
    2. 

  2. #seatstatus
    3. 

  3. #0 = joinat draften, men draften är inte startad
    4. 

  4. #1 = confirmat att man är där, men draften har inte startat
    5. 

  5. #2 = pickar just nu
    6. 

  6. #3 = jag har pickat, väntar på att andra ska bli klara
    7. 

  7. if(!$_SESSION["color_array"]) $_SESSION["color_array"] = array("L","A","G","R","B","U","W");
    8. 

  8. if(!$_SESSION["sort_order"]) $_SESSION["sort_order"] = "color";
    9. 

  9. 

  10. 

  11. 

  12. require_once("xajax/xajax_core/xajax.inc.php");
    13. 

  13. $xajax = new xajax();
    14. 

  14. $xajax->registerFunction("login");
    15. 

  15. $xajax->registerFunction("chat");
    16. 

  16. $xajax->registerFunction("reloadchat");
    17. 

  17. $xajax->registerFunction("reloadDrafterlist");
    18. 

  18. $xajax->registerFunction("addCard2Deck");
    19. 

  19. $xajax->registerFunction("sortDeck");
    20. 

  20. $xajax->registerFunction("updateBasics");
    21. 

  21. $xajax->registerFunction("printStats");
    22. 

  22. $xajax->registerFunction("confirmDraft");
    23. 

  23. $xajax->registerFunction("addSeat");
    24. 

  24. $xajax->registerFunction("removeSeat");
    25. 

  25. $xajax->registerFunction("filterColors");
    26. 

  26. $xajax->registerFunction("hideCard");
    27. 

  27. 

  28. $xajax->processRequest();
    29. 

  29. 

  30. if($_GET["logout"])
    31. 

  31. {
    32. 

  32. 	logout();
    33. 

  33. }
    34. 

  34. 

  35. function logout()
    36. 

  36. {
    37. 

  37. 	session_destroy();
    38. 

  38. 	header("Location: ".str_replace("?logout=true","",$_SERVER[REQUEST_URI])); die();
    39. 

  39. }
    40. 

  40. function printHeader($title, $page, $draft_id = false)
    41. 

  41. {
    42. 

  42. 	global $path;
    43. 

  43. 	global $xajax;
    44. 

  44. 

  45. 	?>
    46. 

  46. 	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    47. 

  47. 	<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
    48. 

  48. 	<head>
    49. 

  49. 		<meta http-equiv="Content-type" content="text/html; charset=utf-8">
    50. 

  50. 		<link rel="stylesheet" href="<?=$path;?>/css/stylesheet.css.php" type="text/css" media="screen" charset="utf-8">
    51. 

  51. 		<script src="<?=$path;?>/javascript/script.js" type="text/javascript"></script>
    52. 

  52. 		<script src="<?=$path;?>/javascript/ajax.js" type="text/javascript"></script>
    53. 

  53. 		<script src="<?=$path;?>/javascript/prototype.js" type="text/javascript"></script>
    54. 

  54. 		<script src="<?=$path;?>/javascript/scriptaculous.js" type="text/javascript"></script>
    55. 

  55. 		<title><?=$title;?></title>
    56. 

  56. 		<? if($xajax) {$xajax->printJavascript($path."/xajax");} ?>
    57. 

  57. 		
    58. 

  58. 	</head>
    59. 

  59. 	<body onkeydown="cardcloseup(event);" onkeyup="cardclosedown(event);">
    60. 

  60. 		<form id="coordinates" name="coordinates">
    61. 

  61. 		<input type="text" name="MouseX" value="0" size="4"><input type="text" name="MouseY" value="0" size="4">
    62. 

  62. 		</form>
    63. 

  63. 		<div id="blackscreen">
    64. 

  64. 			<img src="<?=$path;?>/images/magicdraft_ani_black.gif" style="opacity: 1; z-index: 11; margin-top: 300px;"/><br />
    65. 

  65. 			<h1 id="blackscreen_title"></h1>
    66. 

  66. 		</div>
    67. 

  67. 		<span id="sound"></span>
    68. 

  68. 		<img src="<?=$path;?>/images/indicator.gif" id="indicator" alt="" />
    69. 

  69. 		<div id="top">
    70. 

  70. 			<a href="<?=$path;?>"><img src="<?=$path;?>/images/logo.png" alt="MagicDraft" id="logotype"/></a>
    71. 

  71. 			<div id="next_to_logo">
    72. 

  72. 				<div id="login">
    73. 

  73. 					<?=printLogin($page)?>
    74. 

  74. 					<? if($draft_id && $_SESSION["md_userid"]) {?>
    75. 

  75. 					<div class="draftchat"><div id="chat_<?=$draft_id;?>" class="chatdiv mini"><?=printChat($draft_id);?></div></div>
    76. 

  76. 					<? } ?>
    77. 

  77. 				</div>
    78. 

  78. 			</div>
    79. 

  79. 			<div class="breaker"></div>
    80. 

  80. 		</div>
    81. 

  81. 		<div class="breaker"></div>
    82. 

  82. 		<div id="menu_holder">
    83. 

  83. 			<?=printMenu($page)?>
    84. 

  84. 		</div>
    85. 

  85. 	<?
    86. 

  86. }
    87. 

  87. #prints the menu and makes the current page active
    88. 

  88. #also prints specific buttons if the visitor is a logged in user
    89. 

  89. function printMenu($_active, $_logged_in = false)
    90. 

  90. {
    91. 

  91. 	global $path;
    92. 

  92. 	$active_array = array();
    93. 

  93. 	$active_array[$_active] = "_active";
    94. 

  94. 	if(!$_SESSION["md_userid"]) $output = "<div id=\"menu\" class=\"visitor\">"; else $output = "<div id=\"menu\" class=\"user\">";
    95. 

  95. 	$output .= "<a href=\"$path/\"><img src=\"$path/images/menu_home".$active_array["home"].".png\" id=\"menu_home\" class=\"active\" alt=\"Home\" title=\"Home\"";
    96. 

  96. 		if(!$active_array["home"]) { $output .= "onmouseover=\"this.src='$path/images/menu_home_hover.png';\" onmouseout=\"this.src='$path/images/menu_home.png';\""; }
    97. 

  97. 	$output .= "/></a>";
    98. 

  98. 	
    99. 

  99. 	$output .= "<a href=\"$path/draft\"><img src=\"$path/images/menu_draft".$active_array["draft"].".png\" id=\"menu_draft\" class=\"active\" alt=\"Draft\" title=\"Draft\"";
    100. 

  100. 		if(!$active_array["draft"]) { $output .= "onmouseover=\"this.src='$path/images/menu_draft_hover.png';\" onmouseout=\"this.src='$path/images/menu_draft.png';\""; }
    101. 

  101. 	$output .= "/></a>";
    102. 

  102. 	
    103. 

  103. 	$output .= "<a href=\"$path/stats\"><img src=\"$path/images/menu_stats".$active_array["stats"].".png\" id=\"menu_stats\" class=\"active\" alt=\"Stats\" title=\"Stats\"";
    104. 

  104. 		if(!$active_array["stats"]) { $output .= "onmouseover=\"this.src='$path/images/menu_stats_hover.png';\" onmouseout=\"this.src='$path/images/menu_stats.png';\""; }
    105. 

  105. 	$output .= "/></a>";
    106. 

  106. 

  107. 	$output .= "<a href=\"$path/forum\"><img src=\"$path/images/menu_forum".$active_array["forum"].".png\" id=\"menu_forum\" class=\"active\" alt=\"Forum\" title=\"Forum\"";
    108. 

  108. 		if(!$active_array["forum"]) { $output .= "onmouseover=\"this.src='$path/images/menu_forum_hover.png';\" onmouseout=\"this.src='$path/images/menu_forum.png';\""; }
    109. 

  109. 	$output .= "/></a>";
    110. 

  110. 	
    111. 

  111. 	$output .= "<a href=\"$path/about\"><img src=\"$path/images/menu_about".$active_array["about"].".png\" id=\"menu_about\" class=\"active\" alt=\"About\" title=\"About\"";
    112. 

  112. 		if(!$active_array["about"]) { $output .= "onmouseover=\"this.src='$path/images/menu_about_hover.png';\" onmouseout=\"this.src='$path/images/menu_about.png';\""; }
    113. 

  113. 	$output .= "/></a>";
    114. 

  114. 

  115. 	$output .= "<a href=\"$path/mystuff\"><img "; if(!$_SESSION["md_userid"]) { $output .= "style=\"display: none;\""; } 
    116. 

  116. 	$output .= "src=\"$path/images/menu_mystuff".$active_array["mystuff"].".png\" id=\"menu_mystuff\" alt=\"My stuff\" title=\"My stuff\"";
    117. 

  117. 	if(!$active_array["mystuff"]) { $output .= "onmouseover=\"this.src='".$path."/images/menu_mystuff_hover.png';\" onmouseout=\"this.src='".$path."/images/menu_mystuff.png';\""; } 
    118. 

  118. 	$output .= "/></a>
    119. 

  119. 	</div>
    120. 

  120. 	<div class=\"breaker\"></div>";
    121. 

  121. 	return $output;
    122. 

  122. }
    123. 

  123. #prints an errormessage including pic
    124. 

  124. function errormess($_text, $_class = "error")
    125. 

  125. {
    126. 

  126. 	global $path;
    127. 

  127. 	return "<img src=\"".$path."/images/error.png\" class=\"errorpic\" alt=\"Error!\" /><span class=\"text\"><span class=\"".$_class."\">".$_text."</span>";
    128. 

  128. }
    129. 

  129. function printLogin($page, $error = false, $form = false)
    130. 

  130. {
    131. 

  131. 	global $path;
    132. 

  132. 	global $_REQUEST;
    133. 

  133. 	if(!$_SESSION["md_userid"])
    134. 

  134. 	{
    135. 

  135. 		$output = '<form id="loginform" action="javascript:void(null);" onsubmit="submitLogin();">
    136. 

  136. 			<div id="login_fields">
    137. 

  137. 				<div>USERNAME<br />
    138. 

  138. 					<input type="text" class="textfield" name="user_name" value="'.$form[user_name].'" />
    139. 

  139. 				</div>
    140. 

  140. 				<div>PASSWORD<br />
    141. 

  141. 					<input type="password" class="textfield" name="user_password" value="'.$form[user_password].'" />
    142. 

  142. 				</div>
    143. 

  143. 				<div><br />
    144. 

  144. 					<input type="hidden" name="page" value="'.$page.'" />
    145. 

  145. 					<input type="image" class="loginbutton" src="'.$path.'/images/button_login.png" alt="Login" value="submit" />
    146. 

  146. 				</div>
    147. 

  147. 			</div>
    148. 

  148. 		
    149. 

  149. 			<div class="mini"><br />
    150. 

  150. 				<div id="login_extras">
    151. 

  151. 				<span id="logging_in">'; if($error) $output .= $error."<br />"; $output .= '</span>
    152. 

  152. 				> <a href="'.$path.'/getpassword">Forgot your password?</a><br />
    153. 

  153. 				> Not a user? <a href="'.$path.'/register">Register for free!</a>
    154. 

  154. 			</div>
    155. 

  155. 		</form>';
    156. 

  156. 	}
    157. 

  157. 	else
    158. 

  158. 	{
    159. 

  159. 		$output = '<div id="loggedin_info" class="mini"><br />
    160. 

  160. 			Logged in as '.$_SESSION[md_username].'<br />
    161. 

  161. 			<a href="?logout=true">Logout</a>
    162. 

  162. 		</div>';
    163. 

  163. #		<div id="chat_1" class="chatdiv mini">'.printChat().'</div>';
    164. 

  164. 	}
    165. 

  165. 	return $output;
    166. 

  166. }
    167. 

  167. 

  168. #ajax-stuff
    169. 

  169. function chat($form)
    170. 

  170. {
    171. 

  171. 	$objResponse = new xajaxResponse();
    172. 

  172. 	if(!empty($form[chat_message])) mysql_query("INSERT INTO md_chat VALUES('','".$form[draft_id]."', '".$form[user_id]."', '".addslashes($form[chat_message])."', NOW())");
    173. 

  173. 	$objResponse->assign("chat_".$form[draft_id],"innerHTML",printChat($form[draft_id]));
    174. 

  174. 	$objResponse->assign("chat_input_".$form[draft_id],"focus()",true);
    175. 

  175. 	return $objResponse;
    176. 

  176. }
    177. 

  177. function updateBasics($_land, $_nmb, $_draft_id)
    178. 

  178. {
    179. 

  179. 	mysql_query("UPDATE md_basicland SET nmb_".$_land." = $_nmb WHERE fk_draft_id = $_draft_id AND fk_user_id = $_SESSION[md_userid]");
    180. 

  180. }
    181. 

  181. function confirmDraft($_draft_id)
    182. 

  182. {
    183. 

  183. 	$objResponse = new xajaxResponse();
    184. 

  184. 	$_SESSION["draft_start"] = false;
    185. 

  185. 	mysql_query("UPDATE md_draft2user SET seat_status = '1' WHERE fk_draft_id = $_draft_id AND fk_user_id = $_SESSION[md_userid]");
    186. 

  186. 	return $objResponse;
    187. 

  187. }
    188. 

  188. function login($form,$url)
    189. 

  189. {
    190. 

  190. 	global $path;
    191. 

  191. 	$objResponse = new xajaxResponse();
    192. 

  192. 	if ($form["user_name"] && $form["user_password"])
    193. 

  193. 	{
    194. 

  194. 		$user = mysql_query("SELECT pk_user_id, user_name, user_rating FROM md_user WHERE user_name = '$form[user_name]' AND user_password = '$form[user_password]'");
    195. 

  195. 		if(mysql_num_rows($user))
    196. 

  196. 		{
    197. 

  197. 			$info = mysql_fetch_array($user);
    198. 

  198. 			$_SESSION["md_userid"] = $info[pk_user_id];
    199. 

  199. 			$_SESSION["md_username"] = $info[user_name];
    200. 

  200. 			$_SESSION["md_rating"] = $info[user_rating];
    201. 

  201. 			$output = printLogin($form["page"]);
    202. 

  202. 			$menu = printMenu($form["page"]);
    203. 

  203. 			$objResponse->assign("login","innerHTML",$output);
    204. 

  204. 			$objResponse->assign("menu_holder","innerHTML",$menu);
    205. 

  205. 			$objResponse->redirect($url);
    206. 

  206. 		}
    207. 

  207. 		else
    208. 

  208. 		{
    209. 

  209. 			$error = errormess("Wrong details","white");
    210. 

  210. 			$output = printLogin($page, $error, $form);
    211. 

  211. 			$objResponse->assign("blackscreen","style.display","none");
    212. 

  212. 			$objResponse->assign("login","innerHTML",$output);
    213. 

  213. 		}
    214. 

  214. 	}
    215. 

  215. 	else
    216. 

  216. 	{
    217. 

  217. 		$error = errormess("Fill in all fields","white");
    218. 

  218. 		$output = printLogin($page, $error, $form);
    219. 

  219. 		$objResponse->assign("login","innerHTML",$output);
    220. 

  220. 	}
    221. 

  221. 	return $objResponse;
    222. 

  222. }
    223. 

  223. function reloadchat($_draft_id)
    224. 

  224. {
    225. 

  225. 	if($_SESSION["md_userid"])
    226. 

  226. 	{
    227. 

  227. 		$objResponse = new xajaxResponse();
    228. 

  228. 		$messages = printChatMessages($_draft_id);
    229. 

  229. 		$objResponse->assign("chatmessages_".$_draft_id,"innerHTML",$messages);
    230. 

  230. 	}
    231. 

  231. 	else $objResponse = false;
    232. 

  232. 	return $objResponse;
    233. 

  233. }
    234. 

  234. function reloadDrafterlist($_draft_id,$_picking,$draft_status)
    235. 

  235. {
    236. 

  236. 	$objResponse = new xajaxResponse();
    237. 

  237. 	if($_SESSION["md_userid"])
    238. 

  238. 	{
    239. 

  239. 		#just reload the page if the status is not the same as the one i draftlist, then we need fresh data and a new page
    240. 

  240. 		$draft_info = mysql_fetch_array(mysql_query("SELECT * FROM md_draft WHERE pk_draft_id = $_draft_id"));
    241. 

  241. 		if($draft_info["draft_status"] != $draft_status)
    242. 

  242. 		{
    243. 

  243. 			$_SESSION["draft_start"] = false;
    244. 

  244. 			$objResponse->redirect("draft.php?id=".$_draft_id);
    245. 

  245. 		}
    246. 

  246. 		else
    247. 

  247. 		{
    248. 

  248. 			#are all there in an non-started draft?
    249. 

  249. 			$seat_status = mysql_query("SELECT seat_status FROM md_draft2user WHERE fk_draft_id = $_draft_id ORDER BY seat_status ASC");
    250. 

  250. 			if(mysql_result($seat_status,0) != "0" && mysql_num_rows($seat_status) == $draft_info["max_players"])
    251. 

  251. 			{
    252. 

  252. 				#start the draft (if it's status 1 -> waiting to start)
    253. 

  253. 				mysql_query("UPDATE md_draft SET draft_status = '2' WHERE draft_status = '1' AND pk_draft_id = $_draft_id");
    254. 

  254. 				#startades den?
    255. 

  255. 				if(mysql_affected_rows()) 
    256. 

  256. 				{
    257. 

  257. 					mysql_query("UPDATE md_draft2user SET seat_status = '2' WHERE fk_draft_id = $_draft_id");
    258. 

  258. 					$_SESSION["draft_start"] = false;
    259. 

  259. 					$objResponse->redirect("draft.php?id=".$_draft_id);
    260. 

  260. 					return $objResponse;
    261. 

  261. 				}
    262. 

  262. 				#ok, då var den redan startad och igång. då kollar vi om man väntar på ett pack ($_picking = false, dvs man pickar inte)
    263. 

  263. 				#och isf om det packet är redo för pickning
    264. 

  264. 				elseif($_picking == "false")
    265. 

  265. 				{
    266. 

  266. 					$present_pack = $draft_info["present_pack"];
    267. 

  267. 					#kollar om det finns ett pack jag ska packa i draften
    268. 

  268. 					$pack_id_result = mysql_query("SELECT a1.pk_pack_id FROM md_pack as a1, md_draft2user as a2 WHERE 
    269. 

  269. 						a2.fk_draft_id = $_draft_id aND a2.fk_user_id = $_SESSION[md_userid] AND 
    270. 

  270. 						a2.seat_number = a1.seat_number AND a1.fk_draft_id = $_draft_id AND 
    271. 

  271. 						a1.pack_number = $present_pack AND a1.pack_status = 0");
    272. 

  272. 					#fanns det nåt pack att picka? ladda isf om sidan
    273. 

  273. 					if(mysql_num_rows($pack_id_result))
    274. 

  274. 					{
    275. 

  275. 						$_SESSION["draft_start"] = false;
    276. 

  276. 						$objResponse->redirect("draft.php?id=".$_draft_id);
    277. 

  277. 						return $objResponse;
    278. 

  278. 					}
    279. 

  279. 				}
    280. 

  280. 			}
    281. 

  281. 			$drafterlist = drafterList($_draft_id);
    282. 

  282. 			$objResponse->assign("drafterlist","innerHTML",$drafterlist);
    283. 

  283. 		}
    284. 

  284. 		return $objResponse;
    285. 

  285. 	}
    286. 

  286. 	else return false;
    287. 

  287. }
    288. 

  288. function addCard2Deck($_card_id, $part)
    289. 

  289. {
    290. 

  290. 	$indeck = "1";
    291. 

  291. 	if($part == "sideboard") {$indeck = "0"; }
    292. 

  292. 	
    293. 

  293. 	$_card_id = eregi_replace("card","",$_card_id);
    294. 

  294. 	mysql_query("UPDATE md_packcard SET in_deck = $indeck WHERE pk_packcard_id = $_card_id");
    295. 

  295. }
    296. 

  296. function sortDeck($_part, $_draft_id, $_sort_order)
    297. 

  297. {
    298. 

  298. 	$objResponse = new xajaxResponse();
    299. 

  299. 	if($_part == "picks") $output = printDraftPicks($_draft_id, $_sort_order);
    300. 

  300. 	else $output = printdeck($_draft_id, $_part, $_sort_order);
    301. 

  301. 	$objResponse->assign($_part,"innerHTML",$output);
    302. 

  302. 	return $objResponse;
    303. 

  303. }
    304. 

  304. function printStats($_draft_id)
    305. 

  305. {
    306. 

  306. 	$objResponse = new xajaxResponse();
    307. 

  307. 	$output = deckstats($_draft_id);
    308. 

  308. 	$objResponse->assign("deckstats","innerHTML",$output);
    309. 

  309. 	return $objResponse;
    310. 

  310. }
    311. 

  311. 

  312. function deckstats($draft_id)
    313. 

  313. {
    314. 

  314. 	global $draft_info;
    315. 

  315. 	if(!$draft_info) $draft_info = mysql_fetch_array(mysql_query("SELECT * FROM md_draft
    316. 

  316. 		WHERE pk_draft_id = $draft_id"));
    317. 

  317. 	$indeck = "1";
    318. 

  318. 	if($draft_info["draft_status"] != 3) $indeck = "0";
    319. 

  319. 

  320. 	$nmb_deck = mysql_num_rows(mysql_query("SELECT fk_card_id
    321. 

  321. 		FROM md_packcard, md_pack,md_cards 
    322. 

  322. 		WHERE 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 in_deck = '$indeck'"));
    323. 

  323. 		
    324. 

  324. 	$nmb_creatures = mysql_num_rows(mysql_query("SELECT fk_card_id
    325. 

  325. 		FROM md_packcard, md_pack,md_cards 
    326. 

  326. 		WHERE 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 in_deck = '$indeck'
    327. 

  327. 		AND card_toughness != ''"));
    328. 

  328. 		
    329. 

  329. 	$nmb_lands = $nmb_basiclands = 0;
    330. 

  330. 	if($draft_info["draft_status"] == 3) {
    331. 

  331. 	$nmb_lands = mysql_num_rows(mysql_query("SELECT fk_card_id
    332. 

  332. 		FROM md_packcard, md_pack,md_cards 
    333. 

  333. 		WHERE 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 in_deck = '$indeck'
    334. 

  334. 		AND card_toughness = '' AND (card_type LIKE 'Basic Land%' OR card_type  LIKE 'Land%')"));
    335. 

  335. 		
    336. 

  336. 	$nmb_basiclands = mysql_result(mysql_query("SELECT (nmb_island+nmb_plains+nmb_mountain+nmb_swamp+nmb_forest) AS totallands FROM md_basicland
    337. 

  337. 	WHERE fk_draft_id = $draft_id AND fk_user_id = $_SESSION[md_userid]"),0); }
    338. 

  338. 	
    339. 

  339. 	$nmb_spells = $nmb_deck-($nmb_creatures+$nmb_lands);
    340. 

  340. 

  341. 	$nmb_lands += $nmb_basiclands;
    342. 

  342. 	$nmb_deck += $nmb_basiclands;
    343. 

  343. 

  344. 	if($draft_info["draft_status"] != 3)
    345. 

  345. 	{
    346. 

  346. 		$output = " <span class=\"grey\"><span id=\"nmb_creatures_in_deck\">".$nmb_creatures."</span> creatures, <span id=\"nmb_spells_in_deck\">".$nmb_spells."</span> spells</span>";
    347. 

  347. 	}
    348. 

  348. 	else
    349. 

  349. 	{
    350. 

  350. 		$output = " (<span id=\"nmb_cards_in_deck\">".$nmb_deck."</span> cards) <span class=\"grey\"><span id=\"nmb_creatures_in_deck\">".$nmb_creatures."</span> creatures, <span id=\"nmb_spells_in_deck\">".$nmb_spells."</span> spells, <span id=\"nmb_land_in_deck\">".$nmb_lands."</span> land</span>";
    351. 

  351. 		if($nmb_deck > 39) $output .= " <a href=\"makedeck.php?draft_id=".$draft_id."\" title=\"Save deck\"><img style=\"float: right;\" src=\"../images/button_savedeck.png\" alt=\"Save deck\" /></a>";
    352. 

  352. 		else $output .= " <img style=\"float: right;\" src=\"../images/button_savedeck_grey.png\" alt=\"Save deck\" title=\"Your deck needs ".(40-$nmb_deck)." more cards before you can save\"/>";
    353. 

  353. 	}
    354. 

  354. 	return $output;
    355. 

  355. }
    356. 

  356. 

  357. function printdeck($draft_id, $part = "deck", $_sort_order = false, $_color_array = false)
    358. 

  358. {
    359. 

  359. 	if(!$_color_array) $_color_array = $_SESSION["color_array"];
    360. 

  360. 	if(!$_sort_order) $_sort_order = $_SESSION["sort_order"];
    361. 

  361. 

  362. 	$_SESSION["sort_order"] = $_sort_order;
    363. 

  363. 	$_SESSION["color_array"] = $_color_array;
    364. 

  364. 	
    365. 

  365. 	if($part == "deck")
    366. 

  366. 		$indeck = "1";
    367. 

  367. 	elseif($part == "sideboard")
    368. 

  368. 		{
    369. 

  369. 			$indeck = "0";
    370. 

  370. 			$color_filter = " AND (";
    371. 

  371. 			foreach($_color_array as $one_color)
    372. 

  372. 			{
    373. 

  373. 				$color_filter .= "FIND_IN_SET('".$one_color."',card_color) OR ";
    374. 

  374. 			}
    375. 

  375. 			$color_filter = substr($color_filter,0,-4).")";
    376. 

  376. 		}
    377. 

  377. 		
    378. 

  378. 	if($_sort_order == "color") $sort_order = "find_in_set(card_color, 'L,A,G,R,B,U,W') DESC, card_cmcost DESC";
    379. 

  379. 	elseif($_sort_order == "cost") $sort_order = "card_cmcost";
    380. 

  380. 	elseif($_sort_order == "cardtype") $sort_order = "card_toughness DESC, card_type";
    381. 

  381. 	elseif($_sort_order == "rarity") $sort_order = "card_rarity = 'R' DESC, card_rarity = 'U' DESC, card_rarity = 'C' DESC, find_in_set(card_color, 'L,A,G,R,B,U,W') DESC, card_cmcost DESC";
    382. 

  382. 		
    383. 

  383. 	include_once("../include/kortparm_functions.php");
    384. 

  384. 	$cards = mysql_query($apa = "SELECT card_name, '' as version, fk_card_id, exp_name, packcard_is_foil, IF(CHAR_LENGTH(card_color) > 1,'Multi',card_color) AS card_color, pk_packcard_id, card_rarity, card_cmcost, card_type, card_toughness
    385. 

  385. 		FROM md_packcard, md_pack,md_cards 
    386. 

  386. 		INNER JOIN md_exp ON pk_exp_id = md_cards.fk_exp_id
    387. 

  387. 		WHERE 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 in_deck = '$indeck'
    388. 

  388. 		$color_filter
    389. 

  389. 		ORDER BY $sort_order");
    390. 

  390. 		
    391. 

  391. 	$nmb_deck = mysql_num_rows($cards);
    392. 

  392. 	if($part == "deck") 
    393. 

  393. 	{
    394. 

  394. 		$nmb_basiclands = mysql_result(mysql_query("select (nmb_island+nmb_plains+nmb_mountain+nmb_swamp+nmb_forest) AS totallands FROM md_basicland
    395. 

  395. 		WHERE fk_draft_id = $draft_id AND fk_user_id = $_SESSION[md_userid]"),0);
    396. 

  396. 		$nmb_deck+=$nmb_basiclands;	
    397. 

  397. 	}
    398. 

  398. 	$x = 0;
    399. 

  399. 	$stacks = 0;
    400. 

  400. 	$marginleft = 0;
    401. 

  401. 	$x_in_stack = 0;
    402. 

  402. 	$lastbiggestpile = 0;
    403. 

  403. 	$rows = 1;
    404. 

  404. 	$output = "<h2>".ucwords($part);
    405. 

  405. 	if($part == "deck") $output .= "<span id=\"deckstats\">".deckstats($draft_id)."</span>";
    406. 

  406. 	else $output .= " (<span id=\"nmb_cards_in_sideboard\">".$nmb_deck."</span> cards)";
    407. 

  407. 	$output .= "</h2>";
    408. 

  408. 	
    409. 

  409. 	if($part == "deck") $output .= "<p class=\"small\">Order by <span class=\"orange pointer\" onclick=\"javascript:setXYposition('indicator',event); javascript:orderDeck('".$part."','".$draft_id."','color',false);\">color</span> | <span class=\"orange pointer\" onclick=\"javascript:setXYposition('indicator',event); javascript:orderDeck('".$part."','".$draft_id."','cost',false);\">cost</span> | <span class=\"orange pointer\" onclick=\"javascript:setXYposition('indicator',event); javascript:orderDeck('".$part."','".$draft_id."','cardtype',false);\">cardtype</span> | <span class=\"orange pointer\" onclick=\"javascript:setXYposition('indicator',event); javascript:orderDeck('".$part."','".$draft_id."','rarity',false);\">rarity</span></p>";
    410. 

  410. 	$stacks_per_row = 5;
    411. 

  411. 	if($part == "sideboard") 
    412. 

  412. 	{
    413. 

  413. 		$stacks_per_row = 3;
    414. 

  414. 		$output .= '<br />
    415. 

  415. 		<div class="filter_buttons">
    416. 

  416. 			<img id="color_W" src="../images/button_white.png"'; if(array_search("W",$_color_array) !== false) $output .= ' class="active"'; $output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'W\',\''.$draft_id.'\',\'sideboard\',\''.$_sort_order.'\');" alt="" />
    417. 

  417. 			<img id="color_U" src="../images/button_blue.png"'; if(array_search("U",$_color_array) !== false) $output .= ' class="active"'; $output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'U\',\''.$draft_id.'\',\'sideboard\',\''.$_sort_order.'\');" alt="" />
    418. 

  418. 			<img id="color_B" src="../images/button_black.png"'; if(array_search("B",$_color_array) !== false) $output .= ' class="active"'; $output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'B\',\''.$draft_id.'\',\'sideboard\',\''.$_sort_order.'\');" alt="" />
    419. 

  419. 			<img id="color_R" src="../images/button_red.png"'; if(array_search("R",$_color_array) !== false) $output .= ' class="active"'; $output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'R\',\''.$draft_id.'\',\'sideboard\',\''.$_sort_order.'\');" alt="" />
    420. 

  420. 			<img id="color_G" src="../images/button_green.png"'; if(array_search("G",$_color_array) !== false) $output .= ' class="active"'; $output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'G\',\''.$draft_id.'\',\'sideboard\',\''.$_sort_order.'\');" alt="" />
    421. 

  421. 			<img id="color_A" src="../images/button_artifacts.png"'; if(array_search("A",$_color_array) !== false) $output .= ' class="active"'; $output .= ' onclick="setXYposition(\'indicator\',event); filterColors(\'A\',\''.$draft_id.'\',\'sideboard\',\''.$_sort_order.'\');" alt="" />
    422. 

  422. 		</div>
    423. 

  423. 		';
    424. 

  424. 	}
    425. 

  425. 	
    426. 

  426. 	while($card = mysql_fetch_array($cards))
    427. 

  427. 	{
    428. 

  428. 		if($_sort_order == "cardtype")
    429. 

  429. 		{
    430. 

  430. 			if(strpos($card[card_type], "Creature") > -1 || $card[card_toughness] != "") { $cardtype = "Creature"; }
    431. 

  431. 			elseif(strpos($card[card_type], "Enchantment") > -1) { $cardtype = "Enchantment"; }
    432. 

  432. 			elseif(strpos($card[card_type], "Artifact") > -1) { $cardtype = "Artifact"; }
    433. 

  433. 			elseif(strpos($card[card_type], "Sorcery") > -1) { $cardtype = "Sorcery"; }
    434. 

  434. 			elseif(strpos($card[card_type], "Instant") > -1 || strrpos($card[card_type], "Interrupt") > -1) { $cardtype = "Instant"; }
    435. 

  435. 			elseif(strpos($card[card_type], "Land") > -1) { $cardtype = "Land"; }
    436. 

  436. 		}
    437. 

  437. 		$bildexp = eregi_replace(' ',"", stripslashes($card[exp_name]));
    438. 

  438. 		$bildexp = eregi_replace("'","", strtolower($bildexp));
    439. 

  439. 		if(($card[card_color] != $lastcolor && $_sort_order == "color") || ($card[card_cmcost] != $lastcmcost && $_sort_order == "cost") || ($cardtype != $lastcardtype && $_sort_order == "cardtype") || ($card[card_rarity] != $lastrarity && $_sort_order == "rarity"))
    440. 

  440. 		{
    441. 

  441. 			if(!$biggestpile) $biggestpile = $x_in_stack;
    442. 

  442. 			elseif($x_in_stack>$biggestpile) $biggestpile = $x_in_stack;
    443. 

  443. 			$x_in_stack = 0;
    444. 

  444. 			$stacks++;
    445. 

  445. 			if($stacks == ($stacks_per_row+1) or $stacks == ($stacks_per_row*2+1)) $rows++;
    446. 

  446. 			if($rows == 1)
    447. 

  447. 			{
    448. 

  448. 				$marginleft = 110*($stacks-1);
    449. 

  449. 				$margintop = 0;
    450. 

  450. 			}
    451. 

  451. 			elseif($rows == 2)
    452. 

  452. 			{
    453. 

  453. 				if($stacks == ($stacks_per_row+1)) {$lastbiggestpile = $biggestpile; $biggestpile = false; }
    454. 

  454. 				$marginleft = 110*($stacks-($stacks_per_row+1));
    455. 

  455. 				$margintop = (15*$lastbiggestpile)+120;
    456. 

  456. 			}
    457. 

  457. 			elseif($rows == 3)
    458. 

  458. 			{
    459. 

  459. 				if($stacks == ($stacks_per_row*2+1)){ $lastlastbiggestpile = $lastbiggestpile + $biggestpile; }
    460. 

  460. 				$marginleft = 110*($stacks-($stacks_per_row*2+1));
    461. 

  461. 				$margintop = (15*$lastlastbiggestpile)+240;
    462. 

  462. 			}
    463. 

  463. 		}
    464. 

  464. 		$x_in_stack++;
    465. 

  465. 		$x++;
    466. 

  466. 		$margintop = $margintop+15;
    467. 

  467. 		
    468. 

  468. 		$mouseover = "onmouseover=\"viewCard('../cardpics/".$bildexp."/".cardname2filename($card[card_name],$card[version])."');\"
    469. 

  469. 			onclick=\"javascript:increaseZindex('card".$card[pk_packcard_id]."');\"";
    470. 

  470. 	$output .= '<div alt="'.stripslashes($card[card_name]).'" class="card shadow '.$part.'_card" style="margin-top: '.$margintop.'px; left: '.$marginleft.'px; 
    471. 

  471. 				position: absolute; z-index: '.$x.'" id="card'.$card[pk_packcard_id].'" '.$mouseover.'>'; 
    472. 

  472. 	
    473. 

  473. 	if($card[packcard_is_foil]) { $output .= '<div class="foil" '.$mouseover.'></div>'; } 
    474. 

  474. 	
    475. 

  475. 	$output .= '<img id="cardimg_'.$x.'" src="../cardpics/'.$bildexp.'/'.cardname2filename($card[card_name],$card[version]).'"'; 
    476. 

  476. 	
    477. 

  477. 	if(!$card[packcard_is_foil]) $output .= " ".$mouseover; 
    478. 

  478. 	
    479. 

  479. 	$output .= 'alt="'.stripslashes($card[card_name]).'" class="cardpic" /></div>';
    480. 

  480. 			$output .= '<script type="text/javascript">
    481. 

  481. 			new Draggable(\'card'.$card[pk_packcard_id].'\',{starteffect: false, endeffect: false});
    482. 

  482. 			</script>';
    483. 

  483. 	$lastcolor = $card[card_color];
    484. 

  484. 	$lastcmcost = $card[card_cmcost];
    485. 

  485. 	$lastrarity = $card[card_rarity];
    486. 

  486. 	$lastcardtype = $cardtype;
    487. 

  487. 	}
    488. 

  488. 

  489. 	#basiclands
    490. 

  490. 	if($part == "deck")
    491. 

  491. 	{
    492. 

  492. 		$deck_margintop = $lastbiggestpile*15 + $lastlastbiggestpile*15 + $biggestpile*15 + 120;
    493. 

  493. 		$basiclands = mysql_fetch_array(mysql_query("SELECT * FROM md_basicland WHERE fk_user_id = ".$_SESSION["md_userid"]." AND fk_draft_id = ".$draft_id));
    494. 

  494. 		for ($i=0; $i < 5; $i++) 
    495. 

  495. 		{ 
    496. 

  496. 			if($i == 0) $land = "island"; elseif($i == 1) $land = "plains"; elseif($i == 2) $land = "forest";
    497. 

  497. 			elseif($i == 3) $land = "mountain"; elseif($i == 4) $land = "swamp";
    498. 

  498. 			if($land != "plains") $lands = ucwords($land)."s"; else $lands = "Plains";
    499. 

  499. 

  500. 			$x = 0;
    501. 

  501. 			$margintop = $deck_margintop+165;
    502. 

  502. 			$marginleft = 110*$i;
    503. 

  503. 			$output .= "<div class=\"mini\" style=\"margin-left: ".$marginleft."px; margin-top: ".$margintop."px; position: absolute;\"><select name=\"nmb_".$land."\" size=\"1\" onchange=\"showBasicLands('".$land."', this.value, '".$draft_id."'); printStats('".$draft_id."');\">";
    504. 

  504. 			for ($iet=0; $iet < 19; $iet++) { 
    505. 

  505. 				$output .= "<option value=\"".$iet."\"";
    506. 

  506. 				if($iet == $basiclands["nmb_".$land]) $output .= " selected=\"selected\"";
    507. 

  507. 				$output .= ">".$iet."</option>";
    508. 

  508. 			}
    509. 

  509. 			$output .= "</select> ".$lands."</div>";
    510. 

  510. 

  511. 			$margintop += 10;
    512. 

  512. 			$output .= "<div id=\"basiclands_".$land."\" style=\"position: absolute;\">";
    513. 

  513. 			for ($x=0; $x < 18; $x++) 
    514. 

  514. 			{ 
    515. 

  515. 				$display = "";
    516. 

  516. 				if($x >= $basiclands["nmb_".$land])
    517. 

  517. 				{
    518. 

  518. 					$display = "display: none; ";
    519. 

  519. 				}
    520. 

  520. 				$margintop = $margintop+15;
    521. 

  521. 				$output .= '<div alt="'.ucwords($land).'" class="basicland" style="'.$display.'margin-top: '.$margintop.'px; left: '.$marginleft.'px; 
    522. 

  522. 							position: absolute; z-index: '.$x.'">'; 
    523. 

  523. 				$output .= '<img id="cardimg_'.$x.'" src="../cardpics/10thedition/'.$land.'1.full.jpg" alt="'.ucwords($land).'" class="cardpic" /></div>';
    524. 

  524. 			}
    525. 

  525. 			$output .= "</div>";
    526. 

  526. 		}
    527. 

  527. 	}
    528. 

  528. 	return $output;
    529. 

  529. }
    530. 

  530. 

  531. 

  532. function printChat($_draft_id = 1)
    533. 

  533. {
    534. 

  534. 	$output = "<ul id=\"chatmessages_".$_draft_id."\">";
    535. 

  535. 	$output .= printChatMessages($_draft_id);
    536. 

  536. 	$output .= '</ul>
    537. 

  537. 	<form id="chatform_'.$_draft_id.'" action="javascript:void(null);" onsubmit="submitChat('.$_draft_id.');">
    538. 

  538. 	<input type="text" id="chat_input_'.$_draft_id.'" class="mini" maxlength="55" name="chat_message" />
    539. 

  539. 	<input type="hidden" name="draft_id" value="'.$_draft_id.'" />
    540. 

  540. 	<input type="hidden" name="user_id" value="'.$_SESSION[md_userid].'" />
    541. 

  541. 	</form>';
    542. 

  542. 	return $output;
    543. 

  543. }
    544. 

  544. function printChatMessages($_draft_id)
    545. 

  545. {
    546. 

  546. 	$the_limit = 3;
    547. 

  547. 	global $path;
    548. 

  548. 	$output = "";
    549. 

  549. 	$latest_3 = mysql_query("SELECT pk_chat_id FROM md_chat
    550. 

  550. 		INNER JOIN md_user ON fk_user_id = pk_user_id
    551. 

  551. 		WHERE fk_draft_id = '$_draft_id'
    552. 

  552. 		ORDER BY chat_date DESC LIMIT 0,$the_limit");
    553. 

  553. 		$sql = "(";
    554. 

  554. 	while($late = mysql_fetch_array($latest_3))
    555. 

  555. 	{
    556. 

  556. 		$sql .= "pk_chat_id = '$late[pk_chat_id]' OR ";
    557. 

  557. 	}
    558. 

  558. 	$sql = " AND ".substr($sql,0,-4).")";
    559. 

  559. 	if(!mysql_num_rows($latest_3)) $sql = "";
    560. 

  560. 	$chats = mysql_query("SELECT user_name, user_country, chat_message, date_format(chat_date, '%H:%i:%s') as chat_datum FROM md_chat 
    561. 

  561. 	INNER JOIN md_user ON fk_user_id = pk_user_id
    562. 

  562. 	WHERE fk_draft_id = '$_draft_id' $sql
    563. 

  563. 	ORDER BY chat_date");
    564. 

  564. 	while($chat = mysql_fetch_array($chats))
    565. 

  565. 	{
    566. 

  566. 		if(!$odd) $odd = "odd"; else $odd = "even";
    567. 

  567. 		$output .= "<li class=\"".$odd."\">".$chat[chat_datum]." <img src=\"".$path."/images/flags/".$chat[user_country].".png\" class=\"avatar\"/> &lt;".$chat[user_name]."&gt; ".stripslashes($chat[chat_message])."</li>";
    568. 

  568. 		if($odd == "even") $odd = false;
    569. 

  569. 	}
    570. 

  570. 	$output .= '<script type="text/javascript">setTimeout("reloadChat('.$_draft_id.')",5000);</script>';
    571. 

  571. 	return $output;
    572. 

  572. }
    573. 

  573. function drafterList($draft_id)
    574. 

  574. {
    575. 

  575. 	global $path;
    576. 

  576. 	$draftinfo = mysql_fetch_array(mysql_query("SELECT * FROM md_draft WHERE pk_draft_id = $draft_id"));
    577. 

  577. 	$output = '<ul id="drafter_list">';
    578. 

  578. 		$drafters = mysql_query("SELECT pk_user_id, user_name, user_country, seat_status, seat_number FROM md_draft2user
    579. 

  579. 		INNER JOIN md_user ON fk_user_id = pk_user_id
    580. 

  580. 		WHERE fk_draft_id = $draft_id
    581. 

  581. 		ORDER BY seat_number");
    582. 

  582. 		$xet = 0;
    583. 

  583. 		while($drafter = mysql_fetch_array($drafters))
    584. 

  584. 		{
    585. 

  585. 			if($drafter["pk_user_id"] == $_SESSION["md_userid"]) {$mystatus = $drafter[seat_status]; $myseat = $drafter["seat_number"];}
    586. 

  586. 			$xet++;
    587. 

  587. 			if($drafter[seat_status] == 0 || $drafter[seat_status] == 2) $class = "waiting"; else $class = "done";
    588. 

  588. 			$output .= '<li class="'.$class.'"';
    589. 

  589. 			if($xet == 1) $output .= " style=\"padding-top: 7px;\"";
    590. 

  590. 			$output .= '>
    591. 

  591. 			<span class="mini">'.$xet.'</span>
    592. 

  592. 			<img src="'.$path.'/images/flags/'.$drafter[user_country].'.png" class="avatar" alt="" /> '.$drafter[user_name].'</li>';
    593. 

  593. 		}
    594. 

  594. 		$picking_or_thinking = "false";
    595. 

  595. 		if($mystatus == 0 || $mystatus == 2) $picking_or_thinking = "true";
    596. 

  596. 		#printing free seats
    597. 

  597. 		for ($xet=$xet+1; $xet <= $draftinfo["max_players"]; $xet++) { 
    598. 

  598. 			$output .= '
    599. 

  599. 			<li class="open">
    600. 

  600. 				<span class="mini">'.$xet.'</span> - seat open -';
    601. 

  601. 				#if you're seat #1 (creator) you can add and delete open seats
    602. 

  602. 				if($myseat == 1 && $xet == $draftinfo["max_players"])
    603. 

  603. 				{
    604. 

  604. 					$output .= '<img src="../images/close.png" class="remove_user pointer" alt="Close" onclick="javascript:setXYposition(\'indicator\',event); javascript:removeSeat('.$draft_id.');" />';
    605. 

  605. 				}
    606. 

  606. 			$output .='</li>';
    607. 

  607. 		}
    608. 

  608. 	$output .= '</ul>';
    609. 

  609. 	
    610. 

  610. 	#place a add-seat-button if you're a) creator and b) not full draft
    611. 

  611. 	if($myseat == 1 && $draftinfo["max_players"] < 8 && $draftinfo["draft_status"] == '0')
    612. 

  612. 	{
    613. 

  613. 		$output .= '<span onclick="javascript:setXYposition(\'indicator\',event); javascript:addSeat('.$draft_id.');"><img src="../images/add.png" class="pointer vertmiddle" alt="Add a seat" /> <a class="adduser" href="#">Add a seat</a></span>';
    614. 

  614. 	}
    615. 

  615. 	
    616. 

  616. 	#klockan
    617. 

  617. 	$clock = "";
    618. 

  618. 	if($picking_or_thinking == "true" && $draftinfo["draft_status"] == 2)
    619. 

  619. 	{
    620. 

  620. 		$tiden = time();
    621. 

  621. 		if(!$_SESSION["draft_start"]) $_SESSION["draft_start"] = $tiden;
    622. 

  622. 		if($tiden - $_SESSION["draft_start"] <= 10) $clock = '<img class="clock" src="../images/draftclock_green.gif" alt="" /> <span class="clock_green">Browse the pack</span>';
    623. 

  623. 		elseif($tiden - $_SESSION["draft_start"] <= 15) $clock = '<img class="clock" src="../images/draftclock_yellow.gif" alt="" /> <span class="clock_yellow">Make your choice</span>';
    624. 

  624. 		elseif($tiden - $_SESSION["draft_start"] <= 25) $clock = '<img class="clock" src="../images/draftclock_red.gif" alt="" /> <span class="clock_red">Pick your card!</span>';
    625. 

  625. 		else
    626. 

  626. 		{
    627. 

  627. 			$clock = '<img class="clock" src="../images/draftclock_ringing.gif" alt="" /> <span class="red inverted">Pick! Pick! Pick!</span>';
    628. 

  628. 			if($tiden - $_SESSION["draft_start"] > 30) $clock .= "<span id=\"autograb\"></span>";
    629. 

  629. 		}
    630. 

  630. 		$output .= "<span id=\"picking\"></span>";
    631. 

  631. 	}
    632. 

  632. #	$clock = "";
    633. 

  633. 	$output .= "<span id=\"draft_status\">".$draftinfo["draft_status"]."</span>";
    634. 

  634. 	$output .= $clock.'<script type="text/javascript">setTimeout("reloadDrafterlist('.$draft_id.','.$picking_or_thinking.')",3000);</script>';
    635. 

  635. 	return $output;
    636. 

  636. }
    637. 

  637. function numeric($number)
    638. 

  638. {
    639. 

  639. 	$output = "";
    640. 

  640. 	if(substr($number,-1) == 1) $output = $number."st";
    641. 

  641. 	elseif(substr($number,-1) == 2) $output = $number."nd";
    642. 

  642. 	elseif(substr($number,-1) == 3) $output = $number."rd";
    643. 

  643. 	else $output = $number."th";
    644. 

  644. 	return $output;
    645. 

  645. }
    646. 

  646. function draftPacks($draft_info)
    647. 

  647. {
    648. 

  648. 	#if the draft isn't started, no pack show be shown as present
    649. 

  649. 	if($draft_info[draft_status] != 2) $draft_info[present_pack] = false;
    650. 

  650. 	global $path;
    651. 

  651. 	$pack1name = mysql_result(mysql_query("SELECT exp_name FROM md_exp WHERE pk_exp_id = $draft_info[pack_1]"),0);
    652. 

  652. 	$pack2name = mysql_result(mysql_query("SELECT exp_name FROM md_exp WHERE pk_exp_id = $draft_info[pack_2]"),0);
    653. 

  653. 	$pack3name = mysql_result(mysql_query("SELECT exp_name FROM md_exp WHERE pk_exp_id = $draft_info[pack_3]"),0);
    654. 

  654. 	?>
    655. 

  655. 	<div id="drafting_these_packs">
    656. 

  656. 		<div class="pack<? if($draft_info[present_pack] == 1) echo " currently_drafting"; ?>">
    657. 

  657. 			<? if($draft_info[present_pack] == 1) echo "<img src=\"../images/arrow_right.png\" class=\"arrow\" alt=\"\" /> ";?><img src="<?=$path;?>/images/pack_<?=$draft_info[pack_1];?>.jpg" class="packpic" alt="<?=$pack1name;?>" /><div class="packname"><?=$pack1name;?></div>
    658. 

  658. 			<div class="breaker"></div>
    659. 

  659. 		</div>
    660. 

  660. 		<div class="breaker"></div>
    661. 

  661. 		<div class="pack<? if($draft_info[present_pack] == 2) echo " currently_drafting"; ?>">
    662. 

  662. 			<? if($draft_info[present_pack] == 2) echo "<img src=\"../images/arrow_right.png\" class=\"arrow\" alt=\"\" /> ";?><img src="<?=$path;?>/images/pack_<?=$draft_info[pack_2];?>.jpg" class="packpic" alt="<?=$pack2name;?>" /><div class="packname"><?=$pack2name;?></div>
    663. 

  663. 			<div class="breaker"></div>
    664. 

  664. 		</div>
    665. 

  665. 		<div class="breaker"></div>
    666. 

  666. 		<div class="pack<? if($draft_info[present_pack] == 3) echo " currently_drafting"; ?>">
    667. 

  667. 			<? if($draft_info[present_pack] == 3) echo "<img src=\"../images/arrow_right.png\" class=\"arrow\" alt=\"\" /> ";?><img src="<?=$path;?>/images/pack_<?=$draft_info[pack_3];?>.jpg" class="packpic" alt="<?=$pack3name;?>" /><div class="packname"><?=$pack3name;?></div>
    668. 

  668. 			<div class="breaker"></div>
    669. 

  669. 		</div>
    670. 

  670. 		<div class="breaker"></div>
    671. 

  671. 	</div>
    672. 

  672. 	<?
    673. 

  673. }
    674. 

  674. function countrylist($country)
    675. 

  675. {
    676. 

  676. 	?>
    677. 

  677. 	<option value="BE"<? if($country =="BE") echo " selected";?>>Belgium</option>
    678. 

  678. 	<option value="DK"<? if($country =="DK") echo " selected";?>>Denmark</option>
    679. 

  679. 	<option value="NO"<? if($country =="NO") echo " selected";?>>Norway</option>
    680. 

  680. 	<option value="FR"<? if($country =="FR") echo " selected";?>>France</option>
    681. 

  681. 	<option value="DE"<? if($country =="DE") echo " selected";?>>Germany</option>
    682. 

  682. 	<option value="IT"<? if($country =="IT") echo " selected";?>>Italy</option>
    683. 

  683. 	<option value="JP"<? if($country =="JP") echo " selected";?>>Japan</option>
    684. 

  684. 	<option value="NL"<? if($country =="NL") echo " selected";?>>Netherlands</option>
    685. 

  685. 	<option value="ES"<? if($country =="ES") echo " selected";?>>Spain</option>
    686. 

  686. 	<option value="SE"<? if($country =="SE") echo " selected";?>>Sweden</option>
    687. 

  687. 	<option value="GB"<? if($country =="GB") echo " selected";?>>United Kingdom</option>
    688. 

  688. 	<option value="US"<? if($country =="US") echo " selected";?>>U.S.A</option>
    689. 

  689. 	<option value="">-------------</option>
    690. 

  690. 	<option value="AL"<? if($country =="AL") echo " selected";?>>Albania</option>
    691. 

  691. 	<option value="DZ"<? if($country =="DZ") echo " selected";?>>Algeria</option>
    692. 

  692. 	<option value="AD"<? if($country =="AD") echo " selected";?>>Andorra</option>
    693. 

  693. 	<option value="AO"<? if($country =="AO") echo " selected";?>>Angola</option>
    694. 

  694. 	<option value="AI"<? if($country =="AI") echo " selected";?>>Anguilla</option>
    695. 

  695. 	<option value="AG"<? if($country =="AG") echo " selected";?>>Antigua And Barbuda</option>
    696. 

  696. 	<option value="AE"<? if($country =="AE") echo " selected";?>>Arab Emirates</option>
    697. 

  697. 	<option value="AR"<? if($country =="AR") echo " selected";?>>Argentina</option>
    698. 

  698. 	<option value="AM"<? if($country =="AM") echo " selected";?>>Armenia</option>
    699. 

  699. 	<option value="AW"<? if($country =="AW") echo " selected";?>>Aruba</option>
    700. 

  700. 	<option value="AU"<? if($country =="AU") echo " selected";?>>Australia</option>
    701. 

  701. 	<option value="AT"<? if($country =="AT") echo " selected";?>>Austria</option>
    702. 

  702. 	<option value="AZ"<? if($country =="AZ") echo " selected";?>>Azerbaijan</option>
    703. 

  703. 	<option value="BS"<? if($country =="BS") echo " selected";?>>The Bahamas</option>
    704. 

  704. 	<option value="BH"<? if($country =="BH") echo " selected";?>>Bahrain</option>
    705. 

  705. 	<option value="BD"<? if($country =="BD") echo " selected";?>>Bangladesh</option>
    706. 

  706. 	<option value="BB"<? if($country =="BB") echo " selected";?>>Barbados</option>
    707. 

  707. 	<option value="BY"<? if($country =="BY") echo " selected";?>>Belarus</option>
    708. 

  708. 	<option value="BZ"<? if($country =="BZ") echo " selected";?>>Belize</option>
    709. 

  709. 	<option value="BM"<? if($country =="BM") echo " selected";?>>Bermuda</option>
    710. 

  710. 	<option value="BO"<? if($country =="BO") echo " selected";?>>Bolivia</option>
    711. 

  711. 	<option value="BA"<? if($country =="BA") echo " selected";?>>Bosnia And Herzegovina</option>
    712. 

  712. 	<option value="BW"<? if($country =="BW") echo " selected";?>>Botswana</option>
    713. 

  713. 	<option value="BR"<? if($country =="BR") echo " selected";?>>Brazil</option>
    714. 

  714. 	<option value="BN"<? if($country =="BN") echo " selected";?>>Brunei</option>
    715. 

  715. 	<option value="BG"<? if($country =="BG") echo " selected";?>>Bulgaria</option>
    716. 

  716. 	<option value="KH"<? if($country =="KH") echo " selected";?>>Cambodia</option>
    717. 

  717. 	<option value="CM"<? if($country =="CM") echo " selected";?>>Cameroon</option>
    718. 

  718. 	<option value="CA"<? if($country =="CA") echo " selected";?>>Canada</option>
    719. 

  719. 	<option value="KY"<? if($country =="KY") echo " selected";?>>Cayman Islands</option>
    720. 

  720. 	<option value="TD"<? if($country =="TD") echo " selected";?>>Chad</option>
    721. 

  721. 	<option value="CL"<? if($country =="CL") echo " selected";?>>Chile</option>
    722. 

  722. 	<option value="HK"<? if($country =="HK") echo " selected";?>>China,Hong Kong S.A.R.</option>
    723. 

  723. 	<option value="CN"<? if($country =="CN") echo " selected";?>>China P.Rep.</option>
    724. 

  724. 	<option value="CC"<? if($country =="CC") echo " selected";?>>Cocos Islands</option>
    725. 

  725. 	<option value="CO"<? if($country =="CO") echo " selected";?>>Colombia</option>
    726. 

  726. 	<option value="CD"<? if($country =="CD") echo " selected";?>>Congo, Democratic Republic Of</option>
    727. 

  727. 	<option value="CK"<? if($country =="CK") echo " selected";?>>Cook Islands</option>
    728. 

  728. 	<option value="CR"<? if($country =="CR") echo " selected";?>>Costa Rica</option>
    729. 

  729. 	<option value="HR"<? if($country =="HR") echo " selected";?>>Croatia</option>
    730. 

  730. 	<option value="CU"<? if($country =="CU") echo " selected";?>>Cuba</option>
    731. 

  731. 	<option value="CY"<? if($country =="CY") echo " selected";?>>Cyprus</option>
    732. 

  732. 	<option value="CZ"<? if($country =="CZ") echo " selected";?>>Czech Republic</option>
    733. 

  733. 	<option value="CS"<? if($country =="CS") echo " selected";?>>Czechoslovakia</option>
    734. 

  734. 	<option value="DM"<? if($country =="DM") echo " selected";?>>Dominica</option>
    735. 

  735. 	<option value="DO"<? if($country =="DO") echo " selected";?>>Dominican Repl.</option>
    736. 

  736. 	<option value="EC"<? if($country =="EC") echo " selected";?>>Ecuador</option>
    737. 

  737. 	<option value="EG"<? if($country =="EG") echo " selected";?>>Egypt</option>
    738. 

  738. 	<option value="SV"<? if($country =="SV") echo " selected";?>>El Salvador</option>
    739. 

  739. 	<option value="EE"<? if($country =="EE") echo " selected";?>>Estonia</option>
    740. 

  740. 	<option value="ET"<? if($country =="ET") echo " selected";?>>Ethiopia</option>
    741. 

  741. 	<option value="FK"<? if($country =="FK") echo " selected";?>>Falkland Islands (Malvinas)</option>
    742. 

  742. 	<option value="FO"<? if($country =="FO") echo " selected";?>>Faroe Islands</option>
    743. 

  743. 	<option value="FJ"<? if($country =="FJ") echo " selected";?>>Fiji</option>
    744. 

  744. 	<option value="FI"<? if($country =="FI") echo " selected";?>>Finland</option>
    745. 

  745. 	<option value="PF"<? if($country =="PF") echo " selected";?>>Fr. Polynesia</option>
    746. 

  746. 	<option value="GF"<? if($country =="GF") echo " selected";?>>French Guiana</option>
    747. 

  747. 	<option value="GM"<? if($country =="GM") echo " selected";?>>Gambia</option>
    748. 

  748. 	<option value="GA"<? if($country =="GA") echo " selected";?>>Gabon</option>
    749. 

  749. 	<option value="GE"<? if($country =="GE") echo " selected";?>>Georgia (Republic Of)</option>
    750. 

  750. 	<option value="GH"<? if($country =="GH") echo " selected";?>>Ghana</option>
    751. 

  751. 	<option value="GI"<? if($country =="GI") echo " selected";?>>Gibraltar</option>
    752. 

  752. 	<option value="GR"<? if($country =="GR") echo " selected";?>>Greece</option>
    753. 

  753. 	<option value="GL"<? if($country =="GL") echo " selected";?>>Greenland</option>
    754. 

  754. 	<option value="GD"<? if($country =="GD") echo " selected";?>>Grenada</option>
    755. 

  755. 	<option value="GP"<? if($country =="GP") echo " selected";?>>Guadeloupe</option>
    756. 

  756. 	<option value="GT"<? if($country =="GT") echo " selected";?>>Guatemala</option>
    757. 

  757. 	<option value="GN"<? if($country =="GN") echo " selected";?>>Guinea</option>
    758. 

  758. 	<option value="GY"<? if($country =="GY") echo " selected";?>>Guyana</option>
    759. 

  759. 	<option value="HT"<? if($country =="HT") echo " selected";?>>Haiti</option>
    760. 

  760. 	<option value="HN"<? if($country =="HN") echo " selected";?>>Honduras</option>
    761. 

  761. 	<option value="HU"<? if($country =="HU") echo " selected";?>>Hungary</option>
    762. 

  762. 	<option value="IS"<? if($country =="IS") echo " selected";?>>Iceland</option>
    763. 

  763. 	<option value="IN"<? if($country =="IN") echo " selected";?>>India</option>
    764. 

  764. 	<option value="ID"<? if($country =="ID") echo " selected";?>>Indonesia</option>
    765. 

  765. 	<option value="IR"<? if($country =="IR") echo " selected";?>>Iran</option>
    766. 

  766. 	<option value="IQ"<? if($country =="IQ") echo " selected";?>>Iraq</option>
    767. 

  767. 	<option value="IE"<? if($country =="IE") echo " selected";?>>Ireland</option>
    768. 

  768. 	<option value="IL"<? if($country =="IL") echo " selected";?>>Israel</option>
    769. 

  769. 	<option value="CI"<? if($country =="CI") echo " selected";?>>Ivory Coast</option>
    770. 

  770. 	<option value="JM"<? if($country =="JM") echo " selected";?>>Jamaica</option>
    771. 

  771. 	<option value="JO"<? if($country =="JO") echo " selected";?>>Jordan</option>
    772. 

  772. 	<option value="KZ"<? if($country =="KZ") echo " selected";?>>Kazakhstan</option>
    773. 

  773. 	<option value="KE"<? if($country =="KE") echo " selected";?>>Kenya</option>
    774. 

  774. 	<option value="KW"<? if($country =="KW") echo " selected";?>>Kuwait</option>
    775. 

  775. 	<option value="KG"<? if($country =="KG") echo " selected";?>>Kyrgyzstan</option>
    776. 

  776. 	<option value="LA"<? if($country =="LA") echo " selected";?>>Laos</option>
    777. 

  777. 	<option value="LV"<? if($country =="LV") echo " selected";?>>Latvia</option>
    778. 

  778. 	<option value="LB"<? if($country =="LB") echo " selected";?>>Lebanon</option>
    779. 

  779. 	<option value="LR"<? if($country =="LR") echo " selected";?>>Liberia</option>
    780. 

  780. 	<option value="LY"<? if($country =="LY") echo " selected";?>>Libya</option>
    781. 

  781. 	<option value="LI"<? if($country =="LI") echo " selected";?>>Liechtenstein</option>
    782. 

  782. 	<option value="LT"<? if($country =="LT") echo " selected";?>>Lithuania</option>
    783. 

  783. 	<option value="LU"<? if($country =="LU") echo " selected";?>>Luxembourg</option>
    784. 

  784. 	<option value="MO"<? if($country =="MO") echo " selected";?>>Macau</option>
    785. 

  785. 	<option value="MK"<? if($country =="MK") echo " selected";?>>Macedonia, Former Yugoslav Rep.</option>
    786. 

  786. 	<option value="MG"<? if($country =="MG") echo " selected";?>>Madagascar</option>
    787. 

  787. 	<option value="MW"<? if($country =="MW") echo " selected";?>>Malawi</option>
    788. 

  788. 	<option value="MY"<? if($country =="MY") echo " selected";?>>Malaysia</option>
    789. 

  789. 	<option value="ML"<? if($country =="ML") echo " selected";?>>Mali</option>
    790. 

  790. 	<option value="MT"<? if($country =="MT") echo " selected";?>>Malta</option>
    791. 

  791. 	<option value="MH"<? if($country =="MH") echo " selected";?>>Marshall Islands</option>
    792. 

  792. 	<option value="MQ"<? if($country =="MQ") echo " selected";?>>Martinique</option>
    793. 

  793. 	<option value="MR"<? if($country =="MR") echo " selected";?>>Mauritania</option>
    794. 

  794. 	<option value="MU"<? if($country =="MU") echo " selected";?>>Mauritius</option>
    795. 

  795. 	<option value="MX"<? if($country =="MX") echo " selected";?>>Mexico</option>
    796. 

  796. 	<option value="MD"<? if($country =="MD") echo " selected";?>>Moldova, Republic Of</option>
    797. 

  797. 	<option value="MC"<? if($country =="MC") echo " selected";?>>Monaco</option>
    798. 

  798. 	<option value="MA"<? if($country =="MA") echo " selected";?>>Morocco</option>
    799. 

  799. 	<option value="MM"<? if($country =="MM") echo " selected";?>>Myanmar</option>
    800. 

  800. 	<option value="NA"<? if($country =="NA") echo " selected";?>>Namibia</option>
    801. 

  801. 	<option value="NP"<? if($country =="NP") echo " selected";?>>Nepal</option>
    802. 

  802. 	<option value="AN"<? if($country =="AN") echo " selected";?>>Neth. Antilles</option>
    803. 

  803. 	<option value="NC"<? if($country =="NC") echo " selected";?>>New Caledonia</option>
    804. 

  804. 	<option value="PG"<? if($country =="PG") echo " selected";?>>New Guinea</option>
    805. 

  805. 	<option value="NZ"<? if($country =="NZ") echo " selected";?>>New Zealand</option>
    806. 

  806. 	<option value="NI"<? if($country =="NI") echo " selected";?>>Nicaragua</option>
    807. 

  807. 	<option value="NE"<? if($country =="NE") echo " selected";?>>Niger</option>
    808. 

  808. 	<option value="NG"<? if($country =="NG") echo " selected";?>>Nigeria</option>
    809. 

  809. 	<option value="NF"<? if($country =="NF") echo " selected";?>>Norfolk Island</option>
    810. 

  810. 	<option value="KP"<? if($country =="KP") echo " selected";?>>North Korea</option>
    811. 

  811. 	<option value="OM"<? if($country =="OM") echo " selected";?>>Oman</option>
    812. 

  812. 	<option value="PK"<? if($country =="PK") echo " selected";?>>Pakistan</option>
    813. 

  813. 	<option value="PA"<? if($country =="PA") echo " selected";?>>Panama</option>
    814. 

  814. 	<option value="PY"<? if($country =="PY") echo " selected";?>>Paraguay</option>
    815. 

  815. 	<option value="PE"<? if($country =="PE") echo " selected";?>>Peru</option>
    816. 

  816. 	<option value="PH"<? if($country =="PH") echo " selected";?>>Philippines</option>
    817. 

  817. 	<option value="PL"<? if($country =="PL") echo " selected";?>>Poland</option>
    818. 

  818. 	<option value="PT"<? if($country =="PT") echo " selected";?>>Portugal</option>
    819. 

  819. 	<option value="PW"<? if($country =="PW") echo " selected";?>>Palau</option>
    820. 

  820. 	<option value="QA"<? if($country =="QA") echo " selected";?>>Qatar</option>
    821. 

  821. 	<option value="RO"<? if($country =="RO") echo " selected";?>>Romania</option>
    822. 

  822. 	<option value="RU"<? if($country =="RU") echo " selected";?>>Russian Federation</option>
    823. 

  823. 	<option value="KN"<? if($country =="KN") echo " selected";?>>Saint Kitts And Nevis</option>
    824. 

  824. 	<option value="SM"<? if($country =="SM") echo " selected";?>>San Marino</option>
    825. 

  825. 	<option value="SA"<? if($country =="SA") echo " selected";?>>Saudi Arabia</option>
    826. 

  826. 	<option value="SN"<? if($country =="SN") echo " selected";?>>Senegal</option>
    827. 

  827. 	<option value="SL"<? if($country =="SL") echo " selected";?>>Sierra Leone</option>
    828. 

  828. 	<option value="SG"<? if($country =="SG") echo " selected";?>>Singapore</option>
    829. 

  829. 	<option value="SK"<? if($country =="SK") echo " selected";?>>Slovakia</option>
    830. 

  830. 	<option value="SI"<? if($country =="SI") echo " selected";?>>Slovenia</option>
    831. 

  831. 	<option value="SB"<? if($country =="SB") echo " selected";?>>Solomon Islands</option>
    832. 

  832. 	<option value="ZA"<? if($country =="ZA") echo " selected";?>>South Africa</option>
    833. 

  833. 	<option value="KR"<? if($country =="KR") echo " selected";?>>South Korea</option>
    834. 

  834. 	<option value="LK"<? if($country =="LK") echo " selected";?>>Sri Lanka</option>
    835. 

  835. 	<option value="LC"<? if($country =="LC") echo " selected";?>>St. Lucia</option>
    836. 

  836. 	<option value="VC"<? if($country =="VC") echo " selected";?>>St. Vincent/Grenadines</option>
    837. 

  837. 	<option value="SD"<? if($country =="SD") echo " selected";?>>Sudan</option>
    838. 

  838. 	<option value="SR"<? if($country =="SR") echo " selected";?>>Suriname</option>
    839. 

  839. 	<option value="SZ"<? if($country =="SZ") echo " selected";?>>Swaziland</option>
    840. 

  840. 	<option value="CH"<? if($country =="CH") echo " selected";?>>Switzerland</option>
    841. 

  841. 	<option value="SY"<? if($country =="SY") echo " selected";?>>Syria</option>
    842. 

  842. 	<option value="TW"<? if($country =="TW") echo " selected";?>>Taiwan</option>
    843. 

  843. 	<option value="TZ"<? if($country =="TZ") echo " selected";?>>Tanzania</option>
    844. 

  844. 	<option value="TH"<? if($country =="TH") echo " selected";?>>Thailand</option>
    845. 

  845. 	<option value="TT"<? if($country =="TT") echo " selected";?>>Trinidad/Tobago</option>
    846. 

  846. 	<option value="TN"<? if($country =="TN") echo " selected";?>>Tunisia</option>
    847. 

  847. 	<option value="TR"<? if($country =="TR") echo " selected";?>>Turkey</option>
    848. 

  848. 	<option value="TC"<? if($country =="TC") echo " selected";?>>Turks And Caicos Islands</option>
    849. 

  849. 	<option value="SU"<? if($country =="SU") echo " selected";?>>U.S.S.R.</option>
    850. 

  850. 	<option value="UG"<? if($country =="UG") echo " selected";?>>Uganda</option>
    851. 

  851. 	<option value="UA"<? if($country =="UA") echo " selected";?>>Ukraine</option>
    852. 

  852. 	<option value="UY"<? if($country =="UY") echo " selected";?>>Uruguay</option>
    853. 

  853. 	<option value="UZ"<? if($country =="UZ") echo " selected";?>>Uzbekistan</option>
    854. 

  854. 	<option value="VU"<? if($country =="VU") echo " selected";?>>Vanuatu (New Hebrides)</option>
    855. 

  855. 	<option value="VA"<? if($country =="VA") echo " selected";?>>Vatican City State (Holy See)</option>
    856. 

  856. 	<option value="VE"<? if($country =="VE") echo " selected";?>>Venezuela</option>
    857. 

  857. 	<option value="VN"<? if($country =="VN") echo " selected";?>>Viet Nam</option>
    858. 

  858. 	<option value="VG"<? if($country =="VG") echo " selected";?>>Virgin (British) Islands</option>
    859. 

  859. 	<option value="YE"<? if($country =="YE") echo " selected";?>>Yemen</option>
    860. 

  860. 	<option value="YU"<? if($country =="YU") echo " selected";?>>Yugoslavia</option>
    861. 

  861. 	<option value="ZM"<? if($country =="ZM") echo " selected";?>>Zambia</option>
    862. 

  862. 	<option value="ZW"<? if($country =="ZW") echo " selected";?>>Zimbabwe</option>
    863. 

  863. 	<?
    864. 

  864. }
    865. 

  865. function addSeat($_draft_id)
    866. 

  866. {
    867. 

  867. 	$objResponse = new xajaxResponse();
    868. 

  868. 	mysql_query("UPDATE md_draft SET max_players = max_players + 1 WHERE max_players < 8 AND draft_status = 0 AND pk_draft_id = $_draft_id");
    869. 

  869. 	$drafterlist = drafterList($_draft_id);
    870. 

  870. 	$objResponse->assign("drafterlist","innerHTML",$drafterlist);
    871. 

  871. 	return $objResponse;
    872. 

  872. }
    873. 

  873. function removeSeat($_draft_id)
    874. 

  874. {
    875. 

  875. 	$objResponse = new xajaxResponse();
    876. 

  876. 	#how many are in the draft?
    877. 

  877. 	$players = mysql_num_rows(mysql_query("SELECT fk_user_id FROM md_draft2user WHERE fk_draft_id = $_draft_id"));
    878. 

  878. 	mysql_query("UPDATE md_draft SET max_players = max_players - 1 WHERE max_players > $players AND draft_status = 0 AND pk_draft_id = $_draft_id");
    879. 

  879. 

  880. 	$draft_info = mysql_fetch_array(mysql_query("SELECT * FROM md_draft
    881. 

  881. 		WHERE pk_draft_id = $_draft_id"));
    882. 

  882. 	$drafterlist = drafterList($_draft_id);
    883. 

  883. 	$objResponse->assign("drafterlist","innerHTML",$drafterlist);
    884. 

  884. 	if($players == $draft_info["max_players"])
    885. 

  885. 	{
    886. 

  886. 		$objResponse->redirect("draft.php?id=".$_draft_id);
    887. 

  887. 	}
    888. 

  888. 	return $objResponse;
    889. 

  889. }
    890. 

  890. function start_draft($draft_id)
    891. 

  891. {
    892. 

  892. 	//starta draften
    893. 

  893. 	mysql_query("UPDATE md_draft SET present_pack = 1, draft_status = 1, draft_start = NOW() WHERE pk_draft_id = $draft_id");
    894. 

  894. 	//hämta packnamn
    895. 

  895. 	$pack_names_result = mysql_query("SELECT exp_name FROM md_exp, md_draft WHERE pk_draft_id = $draft_id AND pack_1 = pk_exp_id UNION ALL SELECT exp_name FROM md_exp, md_draft WHERE pk_draft_id = $draft_id AND pack_2 = pk_exp_id  UNION ALL SELECT exp_name FROM md_exp, md_draft WHERE pk_draft_id = $draft_id AND pack_3 = pk_exp_id ");
    896. 

  896. 	for($x=1; $x<=3; $x++) {
    897. 

  897. 		$pack_names_values = mysql_fetch_array($pack_names_result);
    898. 

  898. 		$pack[$x] = $pack_names_values[exp_name];
    899. 

  899. 	}
    900. 

  900. 	
    901. 

  901. 	$players_result = mysql_query("SELECT fk_user_id FROM md_draft2user WHERE fk_draft_id = $draft_id ORDER BY RAND()");
    902. 

  902. 	$x = 1;
    903. 

  903. 	//genomgår spelarlistan och sammanställer query med seating. skapar packs
    904. 

  904. 	while($players = mysql_fetch_array($players_result)) {
    905. 

  905. 		mysql_query("REPLACE INTO md_draft2user(fk_draft_id, fk_user_id, seat_number) VALUES($draft_id, $players[fk_user_id], ".$x.")");
    906. 

  906. 		mysql_query("INSERT INTO md_basicland (fk_user_id, fk_draft_id) VALUES ($players[fk_user_id], $draft_id)");
    907. 

  907. 		add_pack($pack[1],$draft_id, 1, $players[fk_user_id], $x, "draft");
    908. 

  908. 		add_pack($pack[2],$draft_id, 2, $players[fk_user_id], $x, "draft");
    909. 

  909. 		add_pack($pack[3],$draft_id, 3, $players[fk_user_id], $x++, "draft");
    910. 

  910. 	}
    911. 

  911. 	
    912. 

  912. 	//skicka usern till nu startar-draften-om-några-sekunder-sidan
    913. 

  913. 	//är man den sista som joinade? skicka till nu startar draften sidan
    914. 

  914. 	//sista spelarens status måste vara confirmed direkt
    915. 

  915. }
    916. 

  916. 

  917. function printDraftPicks($draft_id, $_sort_order = "time", $_color_array = false)
    918. 

  918. {
    919. 

  919. 	global $draft_info; global $cards_drafted;
    920. 

  920. 	if(!$_color_array) $_color_array = $_SESSION["color_array"];
    921. 

  921. 	
    922. 

  922. 	if($_sort_order == "color") $sort_order = "find_in_set(card_color, 'L,A,G,R,B,U,W') DESC, card_cmcost DESC";
    923. 

  923. 	elseif($_sort_order == "…
    924.

Large files files are truncated, but you can click here to view the full file