Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def getMessagesFromDB(s, count, username):
- db = mysql.connector.connect(user="sql11187729", password="fXDcUfiMeL", host="sql11.freemysqlhosting.net", database="sql11187729")
- cursor = db.cursor()
- query = "SELECT username, message FROM messages WHERE anon = 1 ORDER BY id DESC LIMIT " + count
- cursor.execute(query)
- result = cursor.fetchall()
- messages = []
- for item in result:
- messages.append(item[0] + ": " + item[1])
- messages = " | ".join(messages).encode("utf-8")
- print(messages)
- utils.mess(s, "/w " + username + " " + messages)
- db.close()
- def getLastUserMessages(s, count, userToGet, username):
- db = mysql.connector.connect(user="sql11187729", password="fXDcUfiMeL", host="sql11.freemysqlhosting.net", database="sql11187729")
- cursor = db.cursor()
- query = "SELECT username, message FROM messages WHERE username=\"" + userToGet + "\" ORDER BY id DESC LIMIT " + count
- cursor.execute(query)
- result = cursor.fetchall()
- messages = []
- for item in result:
- messages.append(item[0] + ": " + item[1])
- messages = "".join(messages).encode("utf-8")
- print(messages)
- utils.mess(s, "/w " + username + " " + messages)
- db.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement