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:
     *  uid
     *  team
     *  score
     * Validates the data and sets the score.
     * 
     * @return int 0 on success, negative values on error.
     * @category Action
     * @global resource Database connection.
     */
    function action(){
        global $db;
        $player = filter_input(INPUT_GET, 'uid');
        $team = filter_input(INPUT_GET, 'team');
        $score = intval(filter_input(INPUT_GET, 'score'));
        $statement = $db->prepare('UPDATE team SET score = :score WHERE uid = :uid AND id = :team;');
        $statement->bindValue(':score', $score);
        $statement->bindValue(':uid', $player);
        $statement->bindValue(':team', $team);
        $res = $statement->execute();
        return 0;
    }
?>