DuelBot

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