def __init__(self, bot, md): BotInterface.__init__(self, bot, md) bot.register_module_info( __name__, "MysqLtest", "The Junky", "mysqlclient for ss", ".01" ) self._db = Amysql(self.logger) # self._db.setDbCredentialsFromFile( # self.module_path + R"/db.conf", "db") self._db.setDbCredentialsFromFile( self.module_path + R"/egnetdb.conf", "db") self._db.start() self.clist = [COMMAND_TYPE_PUBLIC, COMMAND_TYPE_TEAM, COMMAND_TYPE_FREQ, COMMAND_TYPE_PRIVATE, COMMAND_TYPE_CHAT] self._sql_command_id = bot.register_command( '!sql', None, 9, self.clist, "web", "[query]", 'sql it zz') self._sqlnl_command_id = bot.register_command( '!sqlnl', None, 9, self.clist, "web", "[query]", 'sql it zz') self.level = logging.DEBUG self.timer_man = TimerManager.TimerManager() self.timer_man.set(.01, 1) self.timer_man.set(300, 2) self.chat = bot.add_chat("st4ff") formatter = logging.Formatter('%(message)s') handler = LoggingRemoteHandler(logging.DEBUG, bot, "Ratio") handler.setFormatter(formatter) self.logger.addHandler(handler)
def __init__(self, bot, md): BotInterface.__init__(self, bot, md) bot.register_module_info(__name__, "MysqLtest", "The Junky", "mysqlclient for ss", ".01") self._db = Amysql(self.logger) # self._db.setDbCredentialsFromFile( # self.module_path + R"/db.conf", "db") self._db.setDbCredentialsFromFile(self.module_path + R"/egnetdb.conf", "db") self._db.start() self.clist = [ COMMAND_TYPE_PUBLIC, COMMAND_TYPE_TEAM, COMMAND_TYPE_FREQ, COMMAND_TYPE_PRIVATE, COMMAND_TYPE_CHAT ] self._sql_command_id = bot.register_command('!sql', None, 9, self.clist, "web", "[query]", 'sql it zz') self._sqlnl_command_id = bot.register_command('!sqlnl', None, 9, self.clist, "web", "[query]", 'sql it zz') self.level = logging.DEBUG self.timer_man = TimerManager.TimerManager() self.timer_man.set(.01, 1) self.timer_man.set(300, 2) self.chat = bot.add_chat("st4ff") formatter = logging.Formatter('%(message)s') handler = LoggingRemoteHandler(logging.DEBUG, bot, "Ratio") handler.setFormatter(formatter) self.logger.addHandler(handler)
def __init__(self, bot, md): BotInterface.__init__(self, bot, md) bot.register_module_info( __name__, "stats", "The Junky", "Stats Retrieval Module", ".01" ) self._db = Amysql(self.logger) self._db.setDbCredentialsFromFile( self.module_path + R"/statsdb.conf", "db") self._db.start() # self.clist = [COMMAND_TYPE_PUBLIC, COMMAND_TYPE_TEAM, # COMMAND_TYPE_FREQ, COMMAND_TYPE_PRIVATE, COMMAND_TYPE_CHAT] self.clist = [COMMAND_TYPE_PRIVATE] # self._sql_command_id = bot.register_command( # '!sql', None, 9, self.clist, "web", "[query]", 'sql it zz') # self._sqlnl_command_id = bot.register_command( # '!sqlnl', None, 9, self.clist, "web", "[query]", 'sql it zz') self._last_jp = bot.register_command( '!jackpots', None, 0, self.clist, "Stats", "", 'last jackpots won') self._recs = bot.register_command( '!recs', None, 0, self.clist, "Stats", "[reset id]", 'top ratios') self._points = bot.register_command( '!points', None, 0, self.clist, "Stats", "[reset id]", 'Top points') self._squads = bot.register_command( '!squads', None, 0, self.clist, "Stats", "[reset id]", 'top squads') self._resets = bot.register_command( '!resets', None, 0, self.clist, "Stats", "", 'recentreset ids') self.level = logging.DEBUG self.timer_man = TimerManager.TimerManager() self.timer_man.set(.01, 1) self.timer_man.set(300, 2) self.chat = bot.add_chat("st4ff") self.cache = { # !cmd: (Cached_result, time) "!jackpots": (None, 0, "jackpots.txt"), "!recs": (None, 0, "recs.txt"), "!points": (None, 0, "points.txt"), "!squads": (None, 0, "squads.txt") } formatter = logging.Formatter('%(message)s') handler = LoggingRemoteHandler(logging.DEBUG, bot, "Ratio") handler.setFormatter(formatter) self.logger.addHandler(handler)
def __init__(self, bot, md): BotInterface.__init__(self, bot, md) bot.register_module_info(__name__, "stats", "The Junky", "Stats Retrieval Module", ".01") self._db = Amysql(self.logger) self._db.setDbCredentialsFromFile(self.module_path + R"/statsdb.conf", "db") self._db.start() # self.clist = [COMMAND_TYPE_PUBLIC, COMMAND_TYPE_TEAM, # COMMAND_TYPE_FREQ, COMMAND_TYPE_PRIVATE, COMMAND_TYPE_CHAT] self.clist = [COMMAND_TYPE_PRIVATE] # self._sql_command_id = bot.register_command( # '!sql', None, 9, self.clist, "web", "[query]", 'sql it zz') # self._sqlnl_command_id = bot.register_command( # '!sqlnl', None, 9, self.clist, "web", "[query]", 'sql it zz') self._last_jp = bot.register_command('!jackpots', None, 0, self.clist, "Stats", "", 'last jackpots won') self._recs = bot.register_command('!recs', None, 0, self.clist, "Stats", "[reset id]", 'top ratios') self._points = bot.register_command('!points', None, 0, self.clist, "Stats", "[reset id]", 'Top points') self._squads = bot.register_command('!squads', None, 0, self.clist, "Stats", "[reset id]", 'top squads') self._resets = bot.register_command('!resets', None, 0, self.clist, "Stats", "", 'recentreset ids') self.level = logging.DEBUG self.timer_man = TimerManager.TimerManager() self.timer_man.set(.01, 1) self.timer_man.set(300, 2) self.chat = bot.add_chat("st4ff") self.cache = { # !cmd: (Cached_result, time) "!jackpots": (None, 0, "jackpots.txt"), "!recs": (None, 0, "recs.txt"), "!points": (None, 0, "points.txt"), "!squads": (None, 0, "squads.txt") } formatter = logging.Formatter('%(message)s') handler = LoggingRemoteHandler(logging.DEBUG, bot, "Ratio") handler.setFormatter(formatter) self.logger.addHandler(handler)
def __init__(self, bot, md): BotInterface.__init__(self, bot, md) bot.register_module_info( __name__, "MysqLtest", "The Junky", "egdldb helper", ".01b" ) self._db = Amysql(self.logger) self._db.setDbCredentialsFromFile( self.module_path + R"/egdldb.conf", "db") self._db.start() self.clist = [COMMAND_TYPE_PUBLIC, COMMAND_TYPE_TEAM, COMMAND_TYPE_FREQ, COMMAND_TYPE_PRIVATE, COMMAND_TYPE_CHAT] self.commands = { # bot.register_command( # '!sql', # None, # 9, # self.clist, # "db", # "[query]", # 'sql it zz' # ): (self.cmd_sql, ""), bot.register_command( '!sqlnl', None, 9, self.clist, "db", "[query]", 'sql it zz' ): (self.cmd_sql, "nl"), bot.register_command( '!addplayer', "!ap", 5, self.clist, "egdl", "[name:vp:squadid]", 'create/add new player to current league' ): (self.cmd_ap, ""), bot.register_command( '!changeplayer', "!cp", 5, self.clist, "egdl", "[name:vp:squadid]", 'update existing player' ): (self.cmd_cp, ""), bot.register_command( '!deleteplayer', "!dp", 5, self.clist, "egdl", "[name]", 'update existing player' ): (self.cmd_dp, ""), bot.register_command( '!listsquads', "!ls", 5, self.clist, "egdl", "", 'list squads' ): (self.cmd_ls, ""), bot.register_command( '!listplayers', "!lp", 5, self.clist, "egdl", "[squad]", 'list squads' ): (self.cmd_lp, "") } self.level = logging.DEBUG self.timer_man = TimerManager.TimerManager() self.timer_man.set(.01, 1) self.timer_man.set(300, 2) self.chat = bot.add_chat("st4ff") formatter = logging.Formatter('%(message)s') handler = LoggingRemoteHandler(logging.DEBUG, bot, "Ratio") handler.setFormatter(formatter) self.logger.addHandler(handler)