reset_game.html

<?php
    session_start();

    include('connect_db.php');

    $user_id = $_SESSION['user_id'];

    if($user_id != 1) {
        exit('error');
    }
    exit('error');

    $query = "DELETE FROM assign_bank_manager";
	$conn->query($query);

	$query = "DELETE FROM assign_ministers_law";
	$conn->query($query);

	$query = "DELETE FROM assign_titles";
	$conn->query($query);

	$query = "DELETE FROM average_product_price";
    $conn->query($query);
    
    $query = "DELETE FROM bank_currency";
    $conn->query($query);
    
    $query = "DELETE FROM bank_product";
    $conn->query($query);
    
    $query = "DELETE FROM bank_details";
    $conn->query($query);
    
    $query = "DELETE FROM battle_budget";
    $conn->query($query);
    
    $query = "DELETE FROM battle_user_damage";
    $conn->query($query);
    
    $query = "DELETE FROM battles";
    $conn->query($query);
    
    $query = "DELETE FROM black_market";
    $conn->query($query);
    
    $query = "DELETE FROM black_market_history";
    $conn->query($query);
    
    $query = "DELETE FROM bought_workers";
    $conn->query($query);
    
    $query = "DELETE FROM budget_allocation";
    $conn->query($query);

    $query = "UPDATE building_policy SET price = 0.25";
    $conn->query($query);
    
    $query = "DELETE FROM building_policy_law";
    $conn->query($query);
    
    $query = "DELETE FROM change_capital_region";
    $conn->query($query);
    
    $query = "DELETE FROM change_credit_deposit_rate";
    $conn->query($query);
    
    $query = "DELETE FROM change_gov_salary";
    $conn->query($query);
    
    $query = "DELETE FROM change_gov_term_length";
    $conn->query($query);
    
    $query = "DELETE FROM change_region_owner";
    $conn->query($query);
    
    $query = "DELETE FROM change_responsibilities";
    $conn->query($query);
    
    $query = "DELETE FROM change_timezone";
    $conn->query($query);
    
    $query = "DELETE FROM change_welcome_message";
    $conn->query($query);
    
    $query = "DELETE FROM citizenship_change";
    $conn->query($query);
    
    $query = "DELETE FROM citizenship_change_history";
    $conn->query($query);
    
    $query = "DELETE FROM collected_products_user_research";
    $conn->query($query);
    
    $query = "DELETE FROM collected_weekly_mission_rewards";
    $conn->query($query);
    
    $query = "DELETE FROM company_market";
    $conn->query($query);
    
    $query = "DELETE FROM company_market_history";
    $conn->query($query);

    $query = "UPDATE congress_details SET salary = 0";
    $conn->query($query);

    $query = "UPDATE congress_details SET elected = CURRENT_DATE";
    $conn->query($query);
    
    $query = "DELETE FROM congress_elections";
    $conn->query($query);
    
    $query = "DELETE FROM congress_members";
    $conn->query($query);
    
    $query = "DELETE FROM core_creation";
    $conn->query($query);
    
    $query = "DELETE FROM corporation_building";
    $conn->query($query);
    
    $query = "DELETE FROM corporation_product";
    $conn->query($query);
    
    $query = "DELETE FROM corporation_members";
    $conn->query($query);
    
    $query = "DELETE FROM corporation_user_invested";
    $conn->query($query);
    
    $query = "DELETE FROM corporation_user_products";
    $conn->query($query);
    
    $query = "DELETE FROM corporations";
    $conn->query($query);
    
    $query = "UPDATE country_congress_seats SET seats = 10";
    $conn->query($query);
    
    $query = "DELETE FROM country_core_regions";
    $conn->query($query);

    $query = "SELECT region_id, rightful_owner FROM regions";
	$result = $conn->query($query);
	while($row = $result->fetch_row()) {
		list($region_id, $rightful_owner) = $row;
		$query = "INSERT INTO country_core_regions VALUES('$region_id', '$rightful_owner', 2160)"; 
		$conn->query($query);
	}
    
    $query = "DELETE FROM country_currency";
    $conn->query($query);
    
    $query = "DELETE FROM country_current_population";
    $conn->query($query);
    
    $query = "DELETE FROM country_daily_income";
    $conn->query($query);
    
    $query = "UPDATE country_government SET user_id = NULL";
    $conn->query($query);
    
    $query = "UPDATE country_government SET salary = 0";
    $conn->query($query);

    $query = "UPDATE country_government SET elected = CURRENT_DATE";
    $conn->query($query);
    
    $query = "DELETE FROM country_government_history";
    $conn->query($query);
    
    $query = "DELETE FROM country_law_info";
    $conn->query($query);
    
    $query = "DELETE FROM country_orders";
    $conn->query($query);
    
    $query = "DELETE FROM country_people_born";
    $conn->query($query);
    
    $query = "DELETE FROM country_people_die";
    $conn->query($query);
    
    $query = "DELETE FROM country_product";
    $conn->query($query);
    
    $query = "DELETE FROM country_product_income";
    $conn->query($query);
    
    $query = "DELETE FROM country_unions";
    $conn->query($query);
    
    $query = "DELETE FROM country_wars";
    $conn->query($query);
    
    $query = "DELETE FROM create_new_union";
    $conn->query($query);
    
    $query = "DELETE FROM currency_purchase_history";
    $conn->query($query);
    
    $query = "DELETE FROM day_count";
    $conn->query($query);

    $query = "INSERT INTO day_count VALUES(1, CURRENT_DATE)";
    $conn->query($query);
    
    $query = "DELETE FROM declare_war";
    $conn->query($query);
    
    $query = "DELETE FROM defence_agreements";
    $conn->query($query);
    
    $query = "DELETE FROM defence_const_in_process";
    $conn->query($query);
    
    $query = "DELETE FROM donated_war_resources_history";
    $conn->query($query);
    
    $query = "DELETE FROM election_info";
    $conn->query($query);
    
    $query = "DELETE FROM foreign_building_policy";
    $conn->query($query);
    
    $query = "DELETE FROM foreign_building_policy_law";
    $conn->query($query);
    
    $query = "DELETE FROM gold_market_history";
    $conn->query($query);
    
    $query = "DELETE FROM government_country_responsibilities";
    $conn->query($query);

    $query = "SELECT responsibility_id FROM political_responsibilities";
	$result = $conn->query($query);
	$x = 0;
	$responsibilities_arr = array();
	while($row = $result->fetch_row()) {
		list($responsibility_id) = $row;	
		$responsibilities_arr[$x] = $responsibility_id;
		$x++;
    }
    
    $query = "SELECT country_id FROM country";
	$result = $conn->query($query);
	$x = 0;
	$countries = array();
	while($row = $result->fetch_row()) {
		list($country_id) = $row;	
		$countries[$x] = $country_id;
		$x++;
    }

	for($c = 0; $c < count($countries); $c++) {
            for($a = 0; $a < count($responsibilities_arr); $a++) {
                $query = "INSERT INTO government_country_responsibilities VALUES('$countries[$c]', 1, 
                        '$responsibilities_arr[$a]', TRUE, TRUE)";
                $conn->query($query);
        }
    }
    
    for($c = 0; $c < count($countries); $c++) {
        for($a = 0; $a < count($responsibilities_arr); $a++) {
            $query = "INSERT INTO government_country_responsibilities VALUES('$countries[$c]', 3, 
                    '$responsibilities_arr[$a]', TRUE, TRUE)";
            $conn->query($query);
        }
    }
    
    $query = "UPDATE government_term_length SET term = 20";
    $conn->query($query);
    
    $query = "DELETE FROM hired_workers";
    $conn->query($query);

    $query = "UPDATE income_tax SET tax = 10";
    $conn->query($query);
    
    $query = "DELETE FROM job_market";
    $conn->query($query);
    
    $query = "DELETE FROM join_leave_union";
    $conn->query($query);
    
    $query = "DELETE FROM last_bank_changes";
    $conn->query($query);
    
    $query = "DELETE FROM ministry_budget";
    $conn->query($query);
    
    $query = "DELETE FROM ministry_product";
    $conn->query($query);
    
    $query = "DELETE FROM monetary_market";
    $conn->query($query);
    
    $query = "DELETE FROM new_production_tax_law";
    $conn->query($query);
    
    $query = "DELETE FROM new_tax_law";
    $conn->query($query);
    
    $query = "DELETE FROM new_union_leader";
    $conn->query($query);
    
    $query = "DELETE FROM people";
    $conn->query($query);
    
    $query = "DELETE FROM people_purchase_history";
    $conn->query($query);
    
    $query = "DELETE FROM person_battle_losses";
    $conn->query($query);
    
    $query = "DELETE FROM president_elections";
    $conn->query($query);
    
    $query = "DELETE FROM print_money";
    $conn->query($query);
    
    $query = "DELETE FROM processing_union_application";
    $conn->query($query);
    
    $query = "DELETE FROM processing_union_leader";
    $conn->query($query);
    
    $query = "DELETE FROM product_allocation";
    $conn->query($query);
    
    $query = "DELETE FROM product_import_law_info";
    $conn->query($query);
    
    $query = "DELETE FROM product_import_tax";
    $conn->query($query);
    
    $query = "DELETE FROM product_market";
    $conn->query($query);
    
    $query = "UPDATE product_production_tax SET tax = 1";
    $conn->query($query);
    
    $query = "DELETE FROM product_purchase_history";
    $conn->query($query);

    $query = "UPDATE product_sale_tax SET tax = 1";
    $conn->query($query);
    
    $query = "DELETE FROM product_warehouse";
    $conn->query($query);
    
    $query = "UPDATE region_defence_systems SET strength = 10000";
    $conn->query($query);

    $query = "UPDATE region_defence_systems SET def_loc_id = 1";
    $conn->query($query);
    
    $query = "DELETE FROM region_product_productivity";
    $conn->query($query);
    
    $query = "DELETE FROM region_roads";
    $conn->query($query);
    
    $query = "DELETE FROM remove_country_union";
    $conn->query($query);
    
    $query = "DELETE FROM remove_country_union_application";
    $conn->query($query);
    
    $query = "DELETE FROM repair_defence_construction";
    $conn->query($query);
    
    $query = "DELETE FROM repair_road_const_product";
    $conn->query($query);
    
    $query = "DELETE FROM resistance_war_prep";
    $conn->query($query);
    
    $query = "DELETE FROM resistance_war_resources";
    $conn->query($query);
    
    $query = "DELETE FROM resource_warehouse";
    $conn->query($query);
    
    $query = "DELETE FROM sign_defence_agreement";
    $conn->query($query);
    
    $query = "DELETE FROM sign_peace_treaty";
    $conn->query($query);
    
    $query = "DELETE FROM travel_agreement";
    $conn->query($query);
    
    $query = "DELETE FROM travel_agreement_law";
    $conn->query($query);
    
    $query = "DELETE FROM unions";
    $conn->query($query);
    
    $query = "DELETE FROM user_achievements";
    $conn->query($query);
    
    $query = "DELETE FROM user_battle_legend_rewards";
    $conn->query($query);
    
    $query = "DELETE FROM user_battle_uses";
    $conn->query($query);

    $query = "DELETE FROM user_blog_subscribers_rewards";
    $conn->query($query);

    $query = "DELETE FROM post_views_rewards";
    $conn->query($query);
    
    $query = "UPDATE user_born_bar SET born_bar = 0";
    $conn->query($query);
    
    $query = "DELETE FROM user_building";
    $conn->query($query);
    
    $query = "DELETE FROM user_country_invest_history";
    $conn->query($query);
    
    $query = "DELETE FROM user_credit";
    $conn->query($query);
    
    $query = "DELETE FROM user_currency";
    $conn->query($query);
    
    $query = "DELETE FROM user_currency_bought";
    $conn->query($query);
    
    $query = "DELETE FROM user_currency_sold";
    $conn->query($query);
    
    $query = "DELETE FROM user_daily_missions";
    $conn->query($query);
    
    $query = "DELETE FROM user_deposit";
    $conn->query($query);
    
    $query = "DELETE FROM user_hard_worker_rewards";
    $conn->query($query);
    
    $query = "DELETE FROM user_level_rewards";
    $conn->query($query);
    
    $query = "DELETE FROM user_levels";
    $conn->query($query);
    
    $query = "UPDATE user_people_slots SET slot_number = 5";
    $conn->query($query);
    
    $query = "DELETE FROM user_product";
    $conn->query($query);
    
    $query = "DELETE FROM user_researches";
    $conn->query($query);
    
    $query = "DELETE FROM user_rewards";
    $conn->query($query);
    
    $query = "DELETE FROM user_timezone_change";
    $conn->query($query);

    $query = "DELETE FROM user_total_damage";
    $conn->query($query);
    
    $query = "DELETE FROM user_warehouse";
    $conn->query($query);
    
    $query = "DELETE FROM users_cloning_farms";
    $conn->query($query);

    $query = "DELETE FROM users_voted";
    $conn->query($query);
    
    $query = "DELETE FROM users_voted_for_laws";
    $conn->query($query);
    
    $query = "DELETE FROM users_weekly_missions_progress";
    $conn->query($query);
    
    $query = "DELETE FROM weekly_missions";
    $conn->query($query);
    
    $query = "DELETE FROM weekly_missions_rewards";
    $conn->query($query);
    
    $query = "DELETE FROM work_journal";
    $conn->query($query);
    
    $query = "DELETE FROM work_quantity";
    $conn->query($query);
    
    $query = "DELETE FROM companies";
    $conn->query($query);
    
    $query = "UPDATE user_profile SET experience = 0";
    $conn->query($query);

    $query = "DELETE FROM tutorial_rewards";
    $conn->query($query);

    $query = "UPDATE regions SET country_id = rightful_owner";
    $conn->query($query);

    $query = "DELETE FROM country_core_regions";
    $conn->query($query);

    $query = "SELECT region_id, rightful_owner FROM regions";
    $result = $conn->query($query);
    while($row = $result->fetch_row()) {
        list($region_id, $country_id) = $row;

        $query = "INSERT INTO country_core_regions VALUES ('$region_id', '$country_id', 2160)";
        $conn->query($query);
    }
?>