function add_tourpack($draft_id, $tourpack, $booster1, $booster2) { add_pack($tourpack, $draft_id, "1", $_SESSION["md_userid"], 1, "sealed"); add_pack($tourpack, $draft_id, "2", $_SESSION["md_userid"], 1, "sealed"); add_pack($tourpack, $draft_id, "3", $_SESSION["md_userid"], 1, "sealed"); add_pack($booster1, $draft_id, "4", $_SESSION["md_userid"], 1, "sealed"); add_pack($booster2, $draft_id, "5", $_SESSION["md_userid"], 1, "sealed"); }
$response->ini = $data[0]['rf_dig_ini']; $response->fin = $data[0]['rf_dig_fin']; $response->inter = $data[0]['rf_interventor']; $response->persona = $data[0]['rf_persona_entrega']; } else { $res = false; $response->mes = $msg->get_msg("e034"); } } $response->res = $res; echo json_encode($response); $con->disconnect(); } //validamos si es una petición ajax if (isset($_POST['action']) && !empty($_POST['action'])) { $action = $_POST['action']; switch ($action) { case 'save': add_pack(); break; case 'change': change_pack(); break; case 'get_row': load_row(); break; case 'update': edit_row(); break; } }
function start_draft($draft_id) { //starta draften mysql_query("UPDATE md_draft SET present_pack = 1, draft_status = 1, draft_start = NOW() WHERE pk_draft_id = {$draft_id}"); //hämta packnamn $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 "); for ($x = 1; $x <= 3; $x++) { $pack_names_values = mysql_fetch_array($pack_names_result); $pack[$x] = $pack_names_values[exp_name]; } $players_result = mysql_query("SELECT fk_user_id FROM md_draft2user WHERE fk_draft_id = {$draft_id} ORDER BY RAND()"); $x = 1; //genomgår spelarlistan och sammanställer query med seating. skapar packs while ($players = mysql_fetch_array($players_result)) { mysql_query("REPLACE INTO md_draft2user(fk_draft_id, fk_user_id, seat_number) VALUES({$draft_id}, {$players['fk_user_id']}, " . $x . ")"); mysql_query("INSERT INTO md_basicland (fk_user_id, fk_draft_id) VALUES ({$players['fk_user_id']}, {$draft_id})"); add_pack($pack[1], $draft_id, 1, $players[fk_user_id], $x, "draft"); add_pack($pack[2], $draft_id, 2, $players[fk_user_id], $x, "draft"); add_pack($pack[3], $draft_id, 3, $players[fk_user_id], $x++, "draft"); } //skicka usern till nu startar-draften-om-n√•gra-sekunder-sidan //√§r man den sista som joinade? skicka till nu startar draften sidan //sista spelarens status måste vara confirmed direkt }