PageRenderTime 45ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/generatepack.php

https://github.com/beakid/md
PHP | 97 lines | 80 code | 9 blank | 8 comment | 19 complexity | 27ddeaa4d1c6035235ddaeaa0c4f637c MD5 | raw file
    

  1. <?php
    2. 

  2. function add_pack($exp,$draft_id, $pack_number, $user_id, $seat_number, $pack_type) {
    3. 

  3. global $_REQUEST;
    4. 

  4. if(!intval($exp)) $exp = mysql_result(mysql_query("SELECT pk_exp_id FROM md_exp WHERE exp_name = '".addslashes($exp)."'"),0);
    5. 

  5. 

  6. 	//create packrow in md_pack and generate pk_pack_id
    7. 

  7. 	mysql_query($apa = "INSERT INTO md_pack(fk_draft_id, fk_exp_id, pack_number, fk_user_id, seat_number, pack_type) SELECT '$draft_id', pk_exp_id, '$pack_number', '$user_id', '$seat_number', '$pack_type' FROM md_exp WHERE pk_exp_id = '$exp'");
    8. 

  8. #	echo $apa;
    9. 

  9. 	$pk_pack_id = mysql_insert_id();
    10. 

  10. 

  11. 	//foilpack or not?
    12. 

  12. 	//foil
    13. 

  13. 	if(rand(1,5) == 5) {
    14. 

  14. 		//reg cards
    15. 

  15. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) 
    16. 

  16. 		(SELECT '$pk_pack_id', pk_card_id FROM md_cards
    17. 

  17. 			WHERE fk_exp_id = '$exp' AND card_rarity = 'R' ORDER BY rand() LIMIT 1) UNION ALL 
    18. 

  18. 		(SELECT '$pk_pack_id', pk_card_id FROM md_cards
    19. 

  19. 			 WHERE fk_exp_id = '$exp' AND card_rarity = 'U' ORDER BY rand() LIMIT 3)");
    20. 

  20. 		
    21. 

  21. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_color = 'B' AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
    22. 

  22. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
    23. 

  23. 		$cq_values = mysql_fetch_array($cq_result);
    24. 

  24. 		$c1 = $cq_values[fk_card_id];
    25. 

  25. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_color = 'R' AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
    26. 

  26. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
    27. 

  27. 		$cq_values = mysql_fetch_array($cq_result);
    28. 

  28. 		$c2 = $cq_values[fk_card_id];
    29. 

  29. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_color = 'U' AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
    30. 

  30. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
    31. 

  31. 		$cq_values = mysql_fetch_array($cq_result);
    32. 

  32. 		$c3 = $cq_values[fk_card_id];
    33. 

  33. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_color = 'W' AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
    34. 

  34. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
    35. 

  35. 		$cq_values = mysql_fetch_array($cq_result);
    36. 

  36. 		$c4 = $cq_values[fk_card_id];
    37. 

  37. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_color = 'G' AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
    38. 

  38. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
    39. 

  39. 		$cq_values = mysql_fetch_array($cq_result);
    40. 

  40. 		$c5 = $cq_values[fk_card_id];
    41. 

  41. 

  42. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT DISTINCT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_type NOT LIKE 'Basic Land%' AND pk_card_id != $c1 AND pk_card_id != $c2 AND pk_card_id != $c3 AND pk_card_id != $c4 AND pk_card_id != $c5 ORDER BY rand() LIMIT 5");
    43. 

  43. 		
    44. 

  44. 		//foil
    45. 

  45. 		$foil = rand(1,15);
    46. 

  46. 		if($foil == 1) {
    47. 

  47. 			mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id, packcard_is_foil) SELECT '$pk_pack_id', pk_card_id, '1' FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'R' ORDER BY rand() LIMIT 1");
    48. 

  48. 		} elseif($foil > 1 && $foil < 5) {
    49. 

  49. 			mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id, packcard_is_foil) SELECT '$pk_pack_id', pk_card_id, '1' FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'U' ORDER BY rand() LIMIT 1");		
    50. 

  50. 		} elseif($foil > 4) { 
    51. 

  51. 			mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id, packcard_is_foil) SELECT '$pk_pack_id', pk_card_id, '1' FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' ORDER BY rand() LIMIT 1");
    52. 

  52. 		}
    53. 

  53. 		
    54. 

  54. 	//usual pack
    55. 

  55. 	} else {
    56. 

  56. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) 
    57. 

  57. 		(SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'R' ORDER BY rand() LIMIT 1) UNION ALL 
    58. 

  58. 		(SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'U' ORDER BY rand() LIMIT 3)");
    59. 

  59. 		
    60. 

  60. 		mysql_query($apa = "INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND FIND_IN_SET('B',card_color) AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
    61. 

  61. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
    62. 

  62. 		$cq_values = mysql_fetch_array($cq_result);
    63. 

  63. 		$c1 = $cq_values[fk_card_id];
    64. 

  64. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND FIND_IN_SET('R',card_color) AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
    65. 

  65. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
    66. 

  66. 		$cq_values = mysql_fetch_array($cq_result);
    67. 

  67. 		$c2 = $cq_values[fk_card_id];
    68. 

  68. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND FIND_IN_SET('U',card_color) AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
    69. 

  69. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
    70. 

  70. 		$cq_values = mysql_fetch_array($cq_result);
    71. 

  71. 		$c3 = $cq_values[fk_card_id];
    72. 

  72. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND FIND_IN_SET('W',card_color) AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
    73. 

  73. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
    74. 

  74. 		$cq_values = mysql_fetch_array($cq_result);
    75. 

  75. 		$c4 = $cq_values[fk_card_id];
    76. 

  76. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND FIND_IN_SET('G',card_color) AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
    77. 

  77. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
    78. 

  78. 		$cq_values = mysql_fetch_array($cq_result);
    79. 

  79. 		$c5 = $cq_values[fk_card_id];
    80. 

  80. 

  81. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT DISTINCT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_type NOT LIKE 'Basic Land%' AND pk_card_id != $c1 AND pk_card_id != $c2 AND pk_card_id != $c3 AND pk_card_id != $c4 AND pk_card_id != $c5 ORDER BY rand() LIMIT 6");
    82. 

  82. 	}
    83. 

  83. 	#om det är sealed, ge usern alla korten i packsen direkt
    84. 

  84. 	if($pack_type == "sealed")
    85. 

  85. 	{
    86. 

  86. 		mysql_query("UPDATE md_packcard SET fk_user_id = $_SESSION[md_userid] WHERE fk_pack_id = $pk_pack_id");
    87. 

  87. 	}
    88. 

  88. }
    89. 

  89. 

  90. function add_tourpack($draft_id,$tourpack,$booster1,$booster2){
    91. 

  91. 	add_pack($tourpack,$draft_id, "1", $_SESSION["md_userid"], 1, "sealed");
    92. 

  92. 	add_pack($tourpack,$draft_id, "2", $_SESSION["md_userid"], 1, "sealed");
    93. 

  93. 	add_pack($tourpack,$draft_id, "3", $_SESSION["md_userid"], 1, "sealed");
    94. 

  94. 	add_pack($booster1,$draft_id, "4", $_SESSION["md_userid"], 1, "sealed");
    95. 

  95. 	add_pack($booster2,$draft_id, "5", $_SESSION["md_userid"], 1, "sealed");
    96. 

  96. }
    97. 

  97. ?>
    98.