SWDB/application/action/new_team.php

<?php

    /**
     * File for the team creation action.
     *
     * Implements an action function to be called from the {@see Controller}.
     * 
     * @category Action
     */

    /**
     * Logs the user out and redirects to the login page.
     *
     * Reads the POST parameters looking for the following KEYS:
     *  player
     *  area_type
     *  area
     *  stage
     *  difficulty
     *  ids
     *  name
     *  description
     * Validates the data and creates the team in the database.
     * 
     * @return int 0 on success, negative values on error.
     * @category Action
     */
    function action(){

        $player = filter_input(INPUT_POST, 'player');
        $area_type = filter_input(INPUT_POST, 'area_type');
        $area = filter_input(INPUT_POST, 'area');
        $stage = filter_input(INPUT_POST, 'stage');
        $difficulty = filter_input(INPUT_POST, 'difficulty');
        if ($difficulty == ''){
            $difficulty = null;
        }
        $ids = filter_input(INPUT_POST, 'ids');
        $name = filter_input(INPUT_POST, 'name');
        $leader_id = filter_input(INPUT_POST, 'leader');
        $total_front = filter_input(INPUT_POST, 'front');
        $description = filter_input(INPUT_POST, 'description');
        $score = 0;
        $id = preg_split("/[\s,]+/", $ids);
        $id_count = sizeof($id);
        if ($name == null || strlen($name) == 0){
            return -1;
        }
        switch ($area_type){
            case AREA_TYPE_ID::SCENARIO:
                if ($stage < 0 || $stage > 7){
                    return -31;
                }
                if (!($difficulty == 0 || APPLICATION::valid_id("DIFFICULTY_ID", $difficulty) || $difficulty == DIFFICULTY_ID::EASY)){
                    return -32;
                }
                if ($id_count < 1 || $id_count > 4){
                    return -33;
                }
                if (!APPLICATION::valid_id("SCENARIO_ID", $area)){
                    return -34;
                }
                break;
            case AREA_TYPE_ID::CAIROS_DUNGEON:
                if ($stage < 0){
                    return -35;
                }
                if ($stage > 12 && (DUNGEON_ID::GIANTS_KEEP == $area || DUNGEON_ID::DRAGONS_LAIR == $area || DUNGEON_ID::NECROPOLIS == $area)){
                    return -35;
                }
                if ($stage > 10 && ($area != DUNGEON_ID::GIANTS_KEEP && $area != DUNGEON_ID::DRAGONS_LAIR && $area != DUNGEON_ID::NECROPOLIS)){
                    return -35;
                }
                $difficulty = null;
                if ($id_count < 1 || $id_count > 5){
                    return -36;
                }
                if (!APPLICATION::valid_id("DUNGEON_ID", $area)){
                    return -37;
                }
                break;
            case AREA_TYPE_ID::RIFT_DUNGEON:
                $stage = null;
                $difficulty = null;
                if ($id_count < 1 || $id_count > 6){
                    return -39;
                }
                if (!APPLICATION::valid_id("ELEMENTAL_RIFT_DUNGEON_ID", $area)){
                    return -40;
                }
                break;
            case AREA_TYPE_ID::RIFT_RAID:
                if ($stage < 0 || $stage > 5){
                    return -41;
                }
                $difficulty = null;
                if ($id_count < 1 || $id_count > 6){
                    return -42;
                }
                $area = null;
                break;
            case AREA_TYPE_ID::ARENA:
                $area = null;
                $stage = null;
                $difficulty = null;
                break;
            case AREA_TYPE_ID::GUILD_WAR:
                $area = null;
                $stage = null;
                $difficulty = null;
                break;
            case AREA_TYPE_ID::GUILD_SIEGE:
                $area = null;
                $stage = null;
                $difficulty = null;
                break;
            case AREA_TYPE_ID::TARTARUS_LABYRINTH:
                if ($difficulty != null && !APPLICATION::valid_id("DIFFICULTY_ID", $difficulty)){
                    return -43;
                }
                if ($id_count < 1 || $id_count > 5){
                    return -44;
                }
                if (!APPLICATION::valid_id("LABYRINTH_STAGES_ID", $stage)){
                    return -45;
                }
                break;
            case AREA_TYPE_ID::TRIAL_OF_ASCENSION:
                if ($difficulty != null && $difficulty != DIFFICULTY_ID::NORMAL && $difficulty != DIFFICULTY_ID::HARD){
                    $difficulty = null;
                }
                $stage = null;
                if ($id_count < 1 || $id_count > 5){
                    return -47;
                }
                $area = null;
                break;
            case AREA_TYPE_ID::DIMENSIONAL_HOLE:
                if ($stage < 0 || $stage > 5){
                    return -48;
                }
                $difficulty = null;
                if ($id_count < 1 || $id_count > 4){
                    return -49;
                }
                if (!APPLICATION::valid_id("DUNGEON_ID", $area)){
                    return -50;
                }
                break;
            case AREA_TYPE_ID::DIMENSIONAL_RIFT:
                if ($difficulty != 0 && $difficulty != DIFFICULTY_ID::NORMAL && $difficulty != DIFFICULTY_ID::HARD){
                    return -51;
                }
                $stage = null;
                if ($id_count < 1 || $id_count > 5){
                    return -52;
                }
                $area = null;
                break;
            default:
                return -3;
        }
        $unique_id = array_unique($id);
        if ($id_count != sizeof($unique_id)){
            return -4;
        }
        $s = "SELECT CASE WHEN MAX(id) IS NULL THEN 1 ELSE MAX(id) + 1 END AS id FROM team;";
        $q = get_context()->get_db()->query($s);
        $r = $q->fetchArray(SQLITE3_ASSOC);
        $team_id = $r["id"];
        $statement = get_context()->get_db()->prepare("
          INSERT INTO team (
            player,
            id,
            name,
            description,
            area_type,
            area,
            stage,
            difficulty,
            score
          ) VALUES (
            :player,
            :id,
            :name,
            :description,
            :area_type,
            :area,
            :stage,
            :difficulty,
            :score
          );
        ");
        $statement->bindValue(':player', $player, SQLITE3_TEXT);
        $statement->bindValue(':id', $team_id, SQLITE3_TEXT);
        $statement->bindValue(':name', $name, SQLITE3_TEXT);
        $statement->bindValue(':description', $description, SQLITE3_TEXT);
        $statement->bindValue(':area_type', $area_type, SQLITE3_TEXT);
        $statement->bindValue(':area', $area, SQLITE3_TEXT);
        $statement->bindValue(':stage', $stage, SQLITE3_TEXT);
        $statement->bindValue(':difficulty', $difficulty, SQLITE3_TEXT);
        $statement->bindValue(':score', $score, SQLITE3_TEXT);
        $res = $statement->execute();
        if (!$res){
            return -5;
        }

        $j = 0;
        foreach (explode(',', $ids) as $i){
            $leader = 0;
            if ((string) $i == (string) $leader_id){
                $leader = 1;
            }
            $front = 0;
            if ($j < $total_front){
                $front = 1;
            }
            $statement = get_context()->get_db()->prepare("
              INSERT INTO team_unit (team, unit, leader, front)
              VALUES (:team, :unit, :leader, :front);
            ");
            $statement->bindValue(':team', $team_id, SQLITE3_TEXT);
            $statement->bindValue(':unit', $i, SQLITE3_TEXT);
            $statement->bindValue(':leader', $leader, SQLITE3_TEXT);
            $statement->bindValue(':front', $front, SQLITE3_TEXT);
            $statement->execute();
            $j ++;
        }
        return 0;
    }
?>