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()
