SWDB/application/action/rate_team.php

<?php

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

    /**
     * Sets the score for a team.
     *
     * Reads the POST parameters looking for the following KEYS:
     *  player
     *  team
     *  score
     * Validates the data and sets the score.
     *
     * @return int 0 on success, negative values on error.
     * @category Action
     */
    function action(){
        $player = filter_input(INPUT_GET, "player");
        $team = filter_input(INPUT_GET, "team");
        $score = intval(filter_input(INPUT_GET, "score"));
        $statement = get_context()->get_db()->prepare("
          UPDATE team
          SET score = :score
          WHERE
            player = :player AND
            id = :team;
        ");
        $statement->bindValue(":score", $score, SQLITE3_TEXT);
        $statement->bindValue(":player", $player, SQLITE3_TEXT);
        $statement->bindValue(":team", $team, SQLITE3_TEXT);
        $statement->execute();
        return 0;
    }
?>