Advertisement
Guest User

Untitled

a guest
Jul 30th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.32 KB | None | 0 0
  1.     def getMessagesFromDB(s, count, username):
  2.         db = mysql.connector.connect(user="sql11187729", password="fXDcUfiMeL", host="sql11.freemysqlhosting.net", database="sql11187729")
  3.         cursor = db.cursor()
  4.         query = "SELECT username, message FROM messages WHERE anon = 1 ORDER BY id DESC LIMIT " + count
  5.         cursor.execute(query)
  6.         result = cursor.fetchall()
  7.         messages = []
  8.         for item in result:
  9.             messages.append(item[0] + ": " + item[1])
  10.  
  11.         messages = " | ".join(messages).encode("utf-8")
  12.         print(messages)
  13.         utils.mess(s, "/w " + username + " " + messages)
  14.         db.close()
  15.  
  16.  
  17.  
  18.  
  19.     def getLastUserMessages(s, count, userToGet, username):
  20.         db = mysql.connector.connect(user="sql11187729", password="fXDcUfiMeL", host="sql11.freemysqlhosting.net", database="sql11187729")
  21.         cursor = db.cursor()
  22.         query = "SELECT username, message FROM messages WHERE username=\"" + userToGet + "\" ORDER BY id DESC LIMIT " + count
  23.         cursor.execute(query)
  24.         result = cursor.fetchall()
  25.         messages = []
  26.         for item in result:
  27.             messages.append(item[0] + ": " + item[1])
  28.  
  29.         messages = "".join(messages).encode("utf-8")
  30.         print(messages)
  31.         utils.mess(s, "/w " + username + " " + messages)
  32.         db.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement