Database usage

| Command / method | Table | Currently set to database connection | | !setrules | tblDuelPlayer | local | | !tchallenge | tblDuelTournyGame tblDuelTourny | local | | !enable | tblDuelPlayer | local | | !rank | tblDuelLeague | local | | !alias | tblDuelPlayer | local | | do_addPlayer() | tblDuelPlayer (DBPlayerData) | local | | endDuel() | (DBPlayerData) tblDuelMatch tblDuelLeague tblDuelPlayer | local | | updateInactives() | tblDuelPlayer tblDuelLeague | local | | tournyTalk() | tblDuelTournyGame tblDuelTourny | local | | checkForfeits() | tblDuelTournyGame tblDuelTourny | local | | sql_getPlayer() | tblDuelPlayer | local | | sql_createLeagueData() | tblDuelLeague | local | | sql_banned() | tblDuelBan | local | | sql_banPlayer() | tblDuelBan | local | | sql_bannedPlayers() | tblDuelBan | local | | sql_recommentBan() | tblDuelBan | local | | sql_getComment() | tblDuelBan | local | | sql_unbanPlayer() | tblDuelBan | local | | sql_getUserInfo() | tblDuelBan | local | | sql_storeUserLoseRating() | tblDuelLeague | local | | sql_storeUserWinRating() | tblDuelLeague | local | | sql_verifyRecord() | tblDuelLeague | local | | sql_enabledUser() | tblDuelPlayer | local | | sql_enableUser() | (DBPlayerData) tblDuelPlayer | local | | sql_disableUser() | (DBPlayerData) tblDuelPlayer (DBPlayerData) tblDuelLeague | local | | sql_getUserIPMID() | tblDuelPlayer | local | | sql_gameLimitReached() | tblDuelMatch | local | | sql_getName() | tblUser | local | | sql_updateTournyAvailability() | tblDuelTournyGame | local | | sql_updateTournyMatchData() | tblDuelTournyGame | local | | sql_getTournyGameID() | tblDuelTournyGame tblDuelTourny | local | | sql_lagInfo() | tblDuelPlayer | local | | updatePlayoffBracket() | tblDuelTournyGame tblDuelTourny tblMessageSystem | local | | advancePlayer() | tblDuelTournyGame tblDuelPlayer tblMessageSystem | local |

Cumulative DuelBot's tables:

• DBPlayerData
• tblDuelBan
• tblDuelLeague
• tblDuelMatch
• tblDuelPlayer
• tblDuelTourny
• tblDuelTournyGame
• tblMessageSystem
• tblUser