uDiscordLink

event onLoad(){
    database.execute("CREATE TABLE IF NOT EXISTS uDiscordStats(
    steamid VARCHAR(17) PRIMARY KEY,
    name VARCHAR(255) NOT NULL DEFAULT 0,
    kills INT NOT NULL DEFAULT 0,
    deaths INT NOT NULL DEFAULT 0
    );");
}
event onPlayerDeath(player, cause, murdererId){
    if(isSet(murdererId)){
        murderer = toPlayer(murdererId);
        if(isSet(murderer)){
            database.execute(str.format("UPDATE uDiscordStats SET kills = kills + 1 WHERE steamid = '{0}';", murderer.id));
            database.execute(str.format("UPDATE uDiscordStats SET deaths = deaths + 1 WHERE steamid = '{0}';", player.id));
        }
    }
}
event onPlayerJoined(player){
    DBcheck = database.execute("SELECT * FROM uDiscordStats WHERE steamid = '" + player.id + "'");
    if(DBcheck.count == 0){
        database.execute("INSERT INTO uDiscordStats (steamid, name, kills, deaths) VALUES ('" + player.id + "', '" + player.name + "', 0, 0);");
    }
}