def ban(self, ip): result = mysqlStatement( "SELECT banned FROM users WHERE ip = '" + ip.strip() + "'", self._server).execute().fetchall().close().result if len(result) >= 1 and len(result[0]) >= 1 and result[0][0] == 0: mysqlStatement( "UPDATE users SET banned = '1' WHERE ip = '" + ip.strip() + "'", self._server).escape().execute().commit().close()
def createChannel(self, channelName, channelDescription, channnelPassword, channelRequired_auth_level): self._server.createLogsUtil.printandwriteserverlog( self._server.serverPrefix + "created new channel" + channelName) mysqlStatement( "INSERT INTO channels (name, description, password, required_auth_level) VALUES ('" + channelName.strip() + "', '" + channelDescription.strip() + "', '" + channnelPassword.strip() + "', '" + channelRequired_auth_level.strip() + "')", self._server).escape().execute().commit().close() return True
def register(self, username, password, email): if len( mysqlStatement( "SELECT * FROM users WHERE (username = '******' OR email = '" + email + "')", self._server).execute().fetchall().close().result) > 0: return False else: mysqlStatement( "INSERT INTO users (username, password, email) VALUES ('" + username + "', '" + password + "', '" + email + "')", self._server).escape().execute().commit().close() return True
def deleteChannel(self, channelName): if len( mysqlStatement( "SELECT * FROM channels WHERE name = '" + channelName.strip() + "'", self._server).execute().fetchall().close().result) > 0: mysqlStatement( "DELETE FROM channels WHERE name = '" + channelName.strip() + "'", self._server).escape().execute().commit().close() self._server.createLogsUtil.printandwriteserverlog( self._server.serverPrefix + "deleted channel" + channelName) return True else: return False
def editChannel(self, channelName, toEdit, argument): if len( mysqlStatement( "SELECT * FROM channels WHERE name = '" + channelName.strip() + "'", self._server).execute().fetchall().close().result) > 0: mysqlStatement( "UPDATE channels SET " + toEdit.strip() + " = '" + argument.strip() + "' WHERE name = '" + channelName.strip() + "'", self._server).escape().execute().commit().close() self._server.createLogsUtil.printandwriteserverlog( self._server.serverPrefix + "edited channel" + channelName) return True else: return False
def checkLogin(self, useroremail, password): return len( mysqlStatement( "SELECT * FROM users WHERE (username = '******' OR email = '" + useroremail + "') AND password = '******'", self._server).execute().fetchall().close().result) > 0
def changeAuth_level(self, username, auth_level): if len( mysqlStatement( "SELECT * FROM users WHERE username = '******'", self._server).execute().fetchall().close().result) > 0: mysqlStatement( "UPDATE users SET auth_level = '" + auth_level.strip() + "' WHERE username = '******'", self._server).escape().execute().commit().close() self._server.createLogsUtil.printandwriteserverlog( self._server.serverPrefix + "changed Auth_level of " + username + " to " + auth_level) return True else: return False
def isBanned(self, ip): try: return mysqlStatement( "SELECT banned FROM users WHERE ip = '" + ip + "' ORDER BY banned DESC", self._server).execute().fetchall().close().result[0][0] == 1 except: var = None
def checkRegister(self, username): if len( mysqlStatement( "SELECT * FROM users WHERE username = '******'", self._server).execute().fetchall().close().result) > 0: print("true") else: print("false") return True
def getChannels(self): result = mysqlStatement( "SELECT name, description FROM channels", self._server).execute().fetchall().close().result channels = dict() currentChannel = None for row in result: for column in row: if currentChannel is None: currentChannel = column else: channels[currentChannel] = column currentChannel = None return channels
def getBannedClients(self): result = mysqlStatement( "SELECT ip, banned FROM users", self._server).execute().fetchall().close().result banned_users = dict() banned = None for row in result: for column in row: if banned is None: banned = column else: banned_users[banned] = column banned = None return banned_users
def updateIp(self, username, address): mysqlStatement( "UPDATE users SET ip = '" + address + "' WHERE username = '******'", self._server).escape().execute().commit().close()