$statement = $connection->prepare("INSERT INTO $database.$hero" . "_avg
        (internal_ID, power_score, kills, deaths, guardian_damage, wins, losses, kda, wounds_given, summons, damage_dealt, healing_given, assists, time_played, damage_soaked, total_games, medals_earned, motiga_skill, rank)
        VALUES (:internal_ID, :power_score, :kills, :deaths, :guardian_damage, :wins, :losses, :kda, :wounds_given, :summons, :damage_dealt, :healing_given, :assists, :time_played, :damage_soaked, :total_games, :medals_earned, :motiga_skill, :rank)
        ON DUPLICATE KEY UPDATE power_score = :power_score, kills = :kills, deaths = :deaths, guardian_damage = :guardian_damage, wins = :wins, losses = :losses, kda = :kda, wounds_given = :wounds_given, summons = :summons, damage_dealt = :damage_dealt, healing_given = :healing_given, assists = :assists, time_played = :time_played, damage_soaked = :damage_soaked, total_games = :total_games, medals_earned = :medals_earned, motiga_skill = :motiga_skill, rank = :rank;");
        //print_r($statement);
        $statement->bindValue(':interal_ID', $username, PDO::PARAM_STR);
        $statement->bindValue(':power_score', $data[$hero]['avg']['power_score'], PDO::PARAM_INT);
        $statement->bindValue(':kills', $data[$hero]['avg']['kills'], PDO::PARAM_INT);
        $statement->bindValue(':deaths', $data[$hero]['avg']['deaths'], PDO::PARAM_INT);
        $statement->bindValue(':guardian_damage', $data[$hero]['avg']['guardian_damage'], PDO::PARAM_INT);
        $statement->bindValue(':wins', $data[$hero]['avg']['wins'], PDO::PARAM_INT);
        $statement->bindValue(':losses', $data[$hero]['avg']['losses'], PDO::PARAM_INT);
        $statement->bindValue(':kda', $data[$hero]['avg']['kda'], PDO::PARAM_INT);
        $statement->bindValue(':wounds_given', $data[$hero]['avg']['wounds_given'], PDO::PARAM_INT);
        $statement->bindValue(':summons', $data[$hero]['avg']['summons'], PDO::PARAM_INT);
        $statement->bindValue(':damage_dealt', $data[$hero]['avg']['damage_dealt'], PDO::PARAM_INT);
        $statement->bindValue(':healing_given', $data[$hero]['avg']['healing_given'], PDO::PARAM_INT);
        $statement->bindValue(':assists', $data[$hero]['avg']['assists'], PDO::PARAM_INT);
        $statement->bindValue(':time_played', $data[$hero]['avg']['time_played'], PDO::PARAM_INT);
        $statement->bindValue(':damage_soaked', $data[$hero]['avg']['damage_soaked'], PDO::PARAM_INT);
        $statement->bindValue(':total_games', $data[$hero]['avg']['total_games'], PDO::PARAM_INT);
        $statement->bindValue(':medals_earned', $data[$hero]['avg']['medals_earned'], PDO::PARAM_INT);
        $statement->bindValue(':motiga_skill', $data[$hero]['avg']['motiga_skill'], PDO::PARAM_INT);
        $statement->bindValue(':rank', $data[$hero]['avg']['rank'], PDO::PARAM_INT);
        prettyprint($statement);
        $debug = $statement->debugDumpParams();
        //prettyprint($debug);
        $statement->execute();