Пример #1
0
    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()