def ForumsList(self):
p = ByteArray("\x02\x02")
p.writeUTF(self.langue)
dbcur.execute("SELECT * FROM forum_forums where id < 1000")
threads = dbcur.fetchall()
for thread in threads:
if str(thread[1]) in self.pf and self.priv < 4:
pass
else:
p.writeInt(int(thread[1]))
p.writeUTF(str(thread[0]))
p.writeShort(int(thread[2]))
if self.login:
dbcur.execute("SELECT tribe FROM users where name = ?",
[self.username])
td = dbcur.fetchone()
if not td[0] == None:
tdc = td[0].split("#")[1]
dbcur.execute("SELECT * FROM tribu where Code = ?", [tdc])
ntd = dbcur.fetchone()
p.writeInt(int(tdc) + 2000)
p.writeUTF("xx")
p.writeShort(9)
p.writeByte(False)
p.writeUTF(ntd[1], True)
self.transport.write(p.toPack())
def openThread(self, thread_id, page):
if page == -1: page = 0
if page != 0: limit1, limit2 = (page * 20) - 1, page * 40
else: limit1, limit2 = 0, 20
dbcur.execute("SELECT * FROM forum_threads where thread_id = ?",
[thread_id])
topicData = dbcur.fetchone()
dbcur.execute(
"SELECT * FROM forum_comments where thread_id = ? ORDER BY time LIMIT ?, ?;",
[thread_id, limit1, limit2])
topicStartMessage = dbcur.fetchall()[0]
forum_id = topicData[0]
self.forum_id = forum_id
self.thread_id = thread_id
p = ByteArray("\x02\x05")
# [FORUM INFO] #
p.writeInt(forum_id) # forumEnCours
p.writeInt(thread_id) # sujetEnCours
canEdit = self.user_type in self.userTypeNeededForPeutModerer
if canEdit: canEdit = 10
elif self.username == topicStartMessage[3]: canEdit = 1
p.writeByte(canEdit) # edition
p.writeBoolean(self.user_type != 19) # peutSuppr
peutReponder = self.username != ""
if bool(topicData[7]): peutReponder = False
if not self.login: openthread = False
if self.username in om: peutReponder = False
p.writeBoolean(peutReponder) # peutRepondre
p.writeBoolean(bool(topicData[7])) # fin
p.writeBoolean(self.user_type != 19) # modTribu
p.writeUTF(topicData[2]) # titre
p.writeInt(page) # pageEnCours
p.writeInt(int(
len(self.getcommentsbythread(thread_id, forum_id)) /
20)) # nobrePage
dbcur.execute(
"SELECT * FROM forum_comments where thread_id = ? ORDER BY time LIMIT ?, ?",
[thread_id, limit1, limit2])
messages = dbcur.fetchall()
p.writeByte(len(messages) - 1) # message
for message in messages:
p.writeInt(message[2]) # id
p.writeByte(self.getJoueurType(
message[3].encode("cp1251"))) # typeAuteurMessage
p.writeUTF(message[3]) # auteur
p.writeByte(self.getJoueurType(
message[3].encode("cp1251"))) # typeAuteurCourant
p.writeInt(10000) # avatar
p.writeInt(message[6]) # date
p.writeUTF(message[5]) # texte
p.writeByte(message[7]) # etat
p.writeUTF(message[8].encode('utf-8', 'replace')) # nomModerateur
p.writeUTF(message[9].encode('utf-8', 'replace')) # raisonEtat
p.writeUTF("") # infos
p.writeBoolean(True) # multiLangues
p.writeBoolean(False) # etatSignalement
#p.writeUTF("TEST Title")
self.transport.write(p.toPack())
def dataReceived(self, data): # 446, 44442, 5557, 3726, 6114
print data
if data == "<policy-file-request/>\x00":
self.transport.write(
"""<cross-domain-policy><allow-access-from domain="127.0.0.1" to-ports="443,44444,44440,5555,3724,6112" /></cross-domain-policy>\x00"""
)
else:
opcode1 = data[4:5]
opcode2 = data[5:6]
opcodes = bytes([opcode1, opcode2])
data = data[6:len(data)]
print repr(opcodes)
if opcode1 == "\x1c":
if opcode2 == "\x01":
#Version
p = ByteArray(data)
v = p.readInt()
print v
if v == self.version:
#ForaList
self.versionValidated = True
self.online()
self.ForumsList()
else:
self.transport.connectionLost()
elif opcode2 == "\x1c":
# Moderating Functions
self.RequireLevel(self.userTypeNeededForPeutModerer)
p = ByteArray(data)
params = p.readUTF().split(",")
if params[0] == "[E]renommer_sujet":
# Thread Rename
thread_id, message_id, new_title = params[
1], p.readShort(), p.readUTF()
dbcur.execute(
"INSERT INTO forum_log VALUES(?, ?, ?, ?, ?)", [
self.username, self.forum_id, thread_id,
message_id, "Konu İsmi", new_title,
"Olarak Değiştirildi."
])
dbcur.execute(
"UPDATE forum_threads SET topic = ? WHERE thread_id = ?",
[new_title, thread_id])
self.openThread(int(thread_id), 0)
elif params[0] == "[E]mute":
# Kullanıcı susturma
mm = int(params[1])
ms = int(params[3])
mn = str(params[2])
fi = int(params[4])
ki = int(params[5])
mi = int(params[6])
p = ByteArray(data.split("\x01")[1])
sebep = p.readUTF()
if ms == 0:
if mn in om:
om.remove(mn)
dbcur.execute(
"DELETE FROM forum_mute where isim = ?", [mn])
self.message_forum(
mn + " Adlı Kullanıcının Mute'si Kaldırıldı.")
else:
if mm == 1:
dbcur.execute(
'select * from forum_mute where isim = ?',
[mn])
rrf = dbcur.fetchone()
if rrf is None:
mod = "isim"
if mn in nlol.online:
md = "Online"
om.append(mn)
else:
md = "Offline"
self.message_forum(
mn + " Adlı Kullanıcı " + str(ms) +
" Saat Boyunca Mutelendi.")
dbcur.execute(
"INSERT INTO forum_mute VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
[
self.username, mn, fi, ki, mi,
sebep, "ip",
time.time(), ms, md
])
else:
self.message_forum(
rrf[1] + " " + rrf[0] +
" Tarafından Mutelenmiş Zaten")
else:
self.message_forum(
"Şimdilik Sadece Oyuncu Mutelenebiliyor ^_^"
)
elif params[0] == "deplacer_sujet":
# Thread Replace
thread_id, forum_id = int(params[1]), int(params[2])
dbcur.execute(
"INSERT INTO forum_log VALUES(?, ?, ?, ?, ?)", [
self.username, self.forum_id, thread_id, "",
"Konu " + forum_id + " Forumuna Taşındı."
])
dbcur.execute(
"UPDATE forum_threads SET forum_id = ? WHERE thread_id = ?",
[forum_id, thread_id])
dbcur.execute(
"UPDATE forum_comments SET forum_id = ? WHERE thread_id = ?",
[forum_id, thread_id])
self.openForums(forum_id, 0)
self.openThread(thread_id, 0)
elif self.versionValidated:
print opcode1 + " - " + opcode2
if opcode1 == "\x02":
if opcode2 == "\x03":
# REQUEST_FORUMS_LIST
self.online()
self.ForumsList()
elif opcode2 == "\x04":
# REQUEST_THREAD_LIST
p = ByteArray(data)
forum_id = p.readInt()
page = p.readInt()
self.forum_id = forum_id
self.openForums(forum_id, page)
elif opcode2 == "\x05":
print "rophl"
# REQUEST_MESSAGE_LIST
p = ByteArray(data)
thread_id = p.readInt()
page = p.readShort()
self.page = page
self.thread_id = thread_id
self.openThread(thread_id, page)
elif opcode1 == "\x04":
if opcode2 == "\x02":
# New Thread
p = ByteArray(data)
forum_id = p.readInt()
self.forum_id = forum_id
if self.forum_id == 1:
self.RequireLevel(
self.userTypeNeededForPeutModerer)
threadTitle = str(p.readUTF()).decode(
'utf-8', 'replace')
message_utf = str(p.readLongString()).decode(
'utf-8', 'replace')
dbcur.execute(
"INSERT INTO forum_threads VALUES (?, NULL, ?, ?, ?, ?, 0, 0)",
[
int(forum_id), threadTitle,
str(time.time()).replace('.', '')[:10],
self.username, self.username
])
thread_id = dbcur.lastrowid
self.thread_id = thread_id
dbcur.execute(
"INSERT INTO forum_comments VALUES (?, ?, NULL, ?, ?, ?, ?, 0, '', '')",
[
int(forum_id), thread_id, self.username,
threadTitle, message_utf,
str(time.time()).replace('.', '')[:10]
])
self.openForums(self.forum_id, 0)
self.openThread(thread_id, 0)
elif opcode2 == "\x04":
# Repondre Sujet
p = ByteArray(data)
thread_id = p.readInt()
message_utf = str(p.readLongString()).decode(
'utf-8', 'replace')
dbcur.execute(
"INSERT INTO forum_comments VALUES (?, ?, NULL, ?, ' ', ?, ?, 0, '', '')",
[
self.forum_id, thread_id, self.username,
message_utf,
str(time.time()).replace('.', '')[:10]
])
self.openThread(thread_id, 0)
elif opcode2 == "\x06":
# Message Edit
# needed edit for long string
self.RequireLevel(self.userTypeNeededForPeutModerer)
p = ByteArray(data)
thread_id = p.readInt()
message_id = p.readInt()
message_utf = str(p.readLongString()).decode(
'utf-8', 'replace')
dbcur.execute(
"SELECT * FROM forum_comments WHERE thread_id = ? AND message_id = ? AND username = ?",
[thread_id, message_id, self.username])
if len(dbcur.fetchall()) == 0:
self.RequireLevel(
self.userTypeNeededForPeutModerer)
dbcur.execute(
"INSERT INTO forum_log VALUES(?, ?, ?, ?, ?)", [
self.username, self.forum_id, thread_id,
message_id, message_utf
])
dbcur.execute(
"UPDATE forum_comments SET message = ? WHERE thread_id = ? AND message_id = ?;",
[message_utf, thread_id, message_id])
self.openThread(thread_id, 0)
elif opcode1 == "\x28":
if opcode2 == "\x02":
# Auth
p = ByteArray(data)
username, passwordHash = p.readUTF(), p.readUTF()
p = ByteArray("\x28\x02")
#print passwordHash
valid, forumPriv, validUsername = self.authenticate(
username,
hashlib.sha512(passwordHash).hexdigest())
p.writeByte(valid)
if valid != 0:
username = username.lower()
username = username.capitalize()
dbcur.execute(
"SELECT isim FROM forum_sentinel WHERE isim = ?",
[username])
sd = dbcur.fetchone()
try:
za = sd[0]
self.sentinel = True
forumPriv = 11
except:
pass
self.username = str(validUsername)
self.user_type = forumPriv
p.writeUTF(self.username)
p.writeInt(10000)
p.writeInt(forumPriv)
nlol.online.append(self.username)
self.login = True
self.mc() #Mute Controller
self.transport.write(p.toPack())
self.online()
elif opcode2 == "\x16":
p = ByteArray(data)
ri, fa, fi, ti, ci, rml = p.readUTF(), p.readUTF(
), p.readInt(), p.readInt(), p.readInt(), p.readUTF()
print ri, fa, fi, ti, ci, rml
self.message_forum(
"Raporlama Sistemi Daha Hazır Değil ^_^")
#### Bu Kod Rapor Kodudur Ancak Daha Bitmemiştir.####
elif opcode2 == "\n":
file = open("avatars/" + self.username + ".png", 'wb')
file.write(data)
file = open("avatars/" + self.username + ".png", 'rb')
img = Image.open(file)
img.load()
img.thumbnail((100, 100), Image.ANTIALIAS)
img.save("./avatars/" + self.username + "_Resize.png")
data = open("avatars/" + self.username + "_Resize.png",
"rb")
upload.upload_file(self.username + ".png", data)
elif opcode2 == "\x0a":
# Avatar Change
try:
pass
## file = open("avatars/"+self.username+".png", 'wb')
## file.write(data)
## basewidth = 100
## img = Image.open(StringIO.StringIO(file))
## wpercent = (basewidth/float(img.size[0]))
## hsize = int((float(img.size[1])*float(wpercent)))
## img = img.resize((basewidth,hsize), PIL.Image.ANTIALIAS)
## img.save("avatars/"+self.username+".png")
except:
pass
elif opcode2 == "\x0b":
# Close Theme
if not self.sentinel:
self.RequireLevel(
self.userTypeNeededForPeutModerer)
else:
if not str(self.forum_id) in self.sf:
self.RequireLevel(
self.userTypeNeededForPeutModerer)
p = ByteArray(data)
thread_id, closed = p.readInt(), p.readBoolean()
dbcur.execute(
"SELECT closed FROM forum_threads where thread_id=?",
[thread_id])
if int(dbcur.fetchone()[0]) == 0:
dbcur.execute(
"INSERT INTO forum_log VALUES(?, ?, ?, ?, ?)",
[
self.username, self.forum_id, thread_id,
"", "Konu Kilitlendi."
])
dbcur.execute(
"UPDATE forum_threads SET closed=1 WHERE thread_id = ?",
[thread_id])
else:
dbcur.execute(
"INSERT INTO forum_log VALUES(?, ?, ?, ?, ?)",
[
self.username, self.forum_id, thread_id,
"", "Konu Kilidi Kaldırıldı."
])
dbcur.execute(
"UPDATE forum_threads SET closed=0 WHERE thread_id = ?",
[thread_id])
if closed:
dbcur.execute(
"INSERT INTO forum_log VALUES(?, ?, ?, ?, ?)",
[
self.username, self.forum_id, thread_id,
"", "Konu Arşive Taşındı."
])
dbcur.execute(
"UPDATE forum_threads SET forum_id = ? WHERE thread_id = ?",
[611, thread_id])
dbcur.execute(
"UPDATE forum_comments SET forum_id = ? WHERE thread_id = ?",
[611, thread_id])
self.forum_id = 611
self.openForums(self.forum_id, 0)
self.openThread(thread_id, 0)
elif opcode2 == "\x0c":
# Stick Theme
if not self.sentinel:
self.RequireLevel(
self.userTypeNeededForPeutModerer)
else:
if not str(self.forum_id) in self.sf:
self.RequireLevel(
self.userTypeNeededForPeutModerer)
p = ByteArray(data)
thread_id = p.readInt()
dbcur.execute(
"SELECT sticky FROM forum_threads where thread_id=?",
[thread_id])
if int(dbcur.fetchone()[0]) == 0:
dbcur.execute(
"INSERT INTO forum_log VALUES(?, ?, ?, ?, ?)",
[
self.username, self.forum_id, thread_id,
"", "Konu Sabitlendi."
])
dbcur.execute(
"UPDATE forum_threads SET sticky=1 WHERE thread_id = ?",
[thread_id])
else:
dbcur.execute(
"INSERT INTO forum_log VALUES(?, ?, ?, ?, ?)",
[
self.username, self.forum_id, thread_id,
"", "Konu Sabit'ten Çıkarıldı."
])
dbcur.execute(
"UPDATE forum_threads SET sticky=0 WHERE thread_id = ?",
[thread_id])
self.openForums(self.forum_id, 0)
self.openThread(thread_id, 0)
elif opcode2 == "\x0f":
# Moderate theme
self.RequireLevel(self.userTypeNeededForPeutModerer)
p = ByteArray(data)
thread_id = p.readInt()
message_id = p.readInt()
type_modere = p.readInt()
comment = p.readUTF()
dbcur.execute(
"INSERT INTO forum_log VALUES(?, ?, ?, ?, ?)", [
self.username, self.forum_id, thread_id,
message_id, comment
])
if type_modere == 0:
# Unsupperme Message
dbcur.execute(
"UPDATE forum_comments SET deleted=0, nomModerateur='', reason='' WHERE thread_id = ? AND message_id = ?",
[thread_id, message_id])
if type_modere == 1:
# Supperme Message
dbcur.execute(
"UPDATE forum_comments SET deleted=1, nomModerateur=?, reason=? WHERE thread_id = ? AND message_id = ?",
[
self.username, comment, thread_id,
message_id
])
if type_modere == 2:
# Delete Message
dbcur.execute(
"UPDATE forum_comments SET deleted=2, nomModerateur=?, reason=? WHERE thread_id = ? AND message_id = ?",
[
self.username, comment, thread_id,
message_id
])
self.openForums(self.forum_id, 0)
self.openThread(thread_id, 0)
elif opcode2 == "\x10":
# Moderer > 1 message
self.RequireLevel(self.userTypeNeededForPeutModerer)
p = ByteArray(data)
username = p.readUTF()
type_modere = p.readInt()
comment = p.readUTF()
dbcur.execute(
"INSERT INTO forum_log VALUES(?, ?, ?, ?, ?)",
[self.username, self.forum_id, "", "", comment])
if type_modere == 0:
# Unsupperme Message
dbcur.execute(
"UPDATE forum_comments SET deleted=0, nomModerateur='', reason='' WHERE username = ?",
[username])
if type_modere == 1:
# Supperme Message
dbcur.execute(
"UPDATE forum_comments SET deleted=1, nomModerateur=?, reason=? WHERE username = ?",
[self.username, comment, username])
if type_modere == 2:
# Delete Message
dbcur.execute(
"UPDATE forum_comments SET deleted=2, nomModerateur=?, reason=? WHERE username = ?",
[self.username, comment, username])
elif opcode2 == "\x17":
# Sanctions # In progress...
self.message_forum("You has no sanctions.")
elif opcode2 == "\x28":
# Online
threading.Timer(15.0, self.online).start()
#self.online()
elif opcode1 == "(":
print repr(opcode2)
print repr(data)
else:
pass #print repr(data)
else:
self.transport.connectionLost()
def openForums(self, forum_id, page):
if page == -1: page = 0
self.forum_id = forum_id
if page != 0: limit1, limit2 = page * 20, page * 40
else: limit1, limit2 = 0, 20
p = ByteArray("\x02\x04")
if forum_id == 1:
openthread = self.user_type in [17, 18, 14, 20]
else:
openthread = True
if self.username in om:
openthread = False
if not self.login:
openthread = False
p.writeBoolean(openthread) # peutCreerSujet
# [FORUM INFO] #
###Tribe Forums###
if forum_id > 2000:
dbcur.execute("SELECT * FROM forum_forums where id = ?",
[int(forum_id)])
td = dbcur.fetchone()
if not td == None:
pass
else:
dbcur.execute("INSERT INTO forum_forums VALUES (?,?,?)",
["xx", (forum_id), "9"])
dbcur.execute("SELECT * FROM tribu where Code = ?",
[int(forum_id) - 2000])
ntd = dbcur.fetchone()
p.writeInt(forum_id)
p.writeUTF("xx")
p.writeShort(9)
p.writeByte(False)
p.writeUTF(ntd[1], True)
dbcur.execute("SELECT * FROM forum_forums where id=?", [forum_id])
forum = dbcur.fetchone()
else:
dbcur.execute("SELECT * FROM forum_forums where id=?", [forum_id])
forum = dbcur.fetchone()
p.writeInt(int(forum[1])) # forumId
p.writeUTF(str(forum[0])) # forumCountry
p.writeShort(int(forum[2])) # forumIcon
p.writeInt(page) # pageCurrent
p.writeInt(self.generateThreadsPage(forum_id) + 1) # pageTotal
#
p.writeBoolean(
False) # masquerSujetCourrant # публичный форум : boolean
dbcur.execute(
"SELECT * FROM forum_threads where forum_id=? ORDER BY sticky DESC, date DESC LIMIT ?, ?",
[forum_id, limit1, limit2])
threads = dbcur.fetchall()
threadNum = 0
for row in threads:
z = row[1]
# [InfoServeurSujet] #
dbcur.execute(
"SELECT * FROM forum_comments where thread_id=? ORDER BY time DESC",
[z])
topicLastMessage = dbcur.fetchall()[0]
p.writeInt(row[1]) # code
p.writeUTF(row[2]) # titre
p.writeInt(int(row[3])) # date
p.writeUTF(row[4].encode("cp1251")) # auteur
p.writeByte(self.getJoueurType(
row[4].encode("cp1251"))) # typeAuteur
p.writeUTF(topicLastMessage[3].encode("cp1251")) # last_posteur
p.writeInt(len(self.getcommentsbythread(row[1],
forum[1]))) # numMessage
typeThread = 0
if bool(row[7]): typeThread = 2
p.writeByte(typeThread) # type
p.writeBoolean(bool(row[6])) # postIt
p.writeInt(threadNum) # nombreSignalements
threadNum += 1
self.transport.write(p.toPack())
def online(self):
p = ByteArray("\x28\x28")
p.writeInt(len(nlol.online))
self.transport.write(p.toPack())
def message_forum(self, msg):
p = ByteArray("\x1c\x1c")
p.writeUTF(msg)
self.transport.write(p.toPack())
