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
}
