Kimai_Database_Mysql::get_rate PHP Method

    public function get_rate($userID, $projectID, $activityID)
    {
        // validate input
        if ($userID == null || !is_numeric($userID)) {
            $userID = "NULL";
        }
        if ($projectID == null || !is_numeric($projectID)) {
            $projectID = "NULL";
        }
        if ($activityID == null || !is_numeric($activityID)) {
            $activityID = "NULL";
        }
        $query = "SELECT rate FROM " . $this->kga['server_prefix'] . "rates WHERE " . ($userID == "NULL" ? "userID is NULL" : "userID = {$userID}") . " AND " . ($projectID == "NULL" ? "projectID is NULL" : "projectID = {$projectID}") . " AND " . ($activityID == "NULL" ? "activityID is NULL" : "activityID = {$activityID}");
        $result = $this->conn->Query($query);
        if ($this->conn->RowCount() == 0) {
            return false;
        }
        $data = $this->conn->rowArray(0, MYSQLI_ASSOC);
        return $data['rate'];
    }