def get(self): cookie_user = self.get_secure_cookie("username") if cookie_user is None: self.redirect('/login') else: usertype = common.get_usertype(cookie_user) self.render("admin.html",usertype=usertype,cookieUser=cookie_user)
def post(self): setvip_username = self.get_argument("username1", None) cancelvip_username = self.get_argument("username2", None) delete_username = self.get_argument("username3", None) delete_roomname = self.get_argument("roomname", None) cookie_user = self.get_secure_cookie("username") if cookie_user is None: self.redirect('/login') else: usertype = common.get_usertype(cookie_user) if setvip_username: sql = "update user set usertype = 1 where username = '******' " % ( setvip_username) conn.execute(sql) conn.commit() self.write("设置成功") self.render("admin.html", userType=usertype) if cancelvip_username: sql = "update user set usertype = 0 where username = '******' " % ( cancelvip_username) conn.execute(sql) conn.commit() self.write("取消成功") self.render("admin.html", userType=usertype) if delete_username: sql = "delete from user where username = '******' " % (delete_username) conn.execute(sql) conn.commit() self.write("删除成功") self.render("admin.html", userType=usertype) if delete_roomname: sql = "delete from room where roomname = '%s' " % (delete_roomname) conn.execute(sql) conn.commit() self.redirect("/chatroom")
def get(self): cookie_user = self.get_secure_cookie("username") if cookie_user: usertype = common.get_usertype(cookie_user) self.render('createroom.html', cookieUser=cookie_user, usertype = usertype,Error=False) else: self.render('login.html', cookieUser=None, Error = False)
def post(self): setvip_username = self.get_argument("username1", None) cancelvip_username = self.get_argument("username2", None) delete_username = self.get_argument("username3", None) delete_roomname = self.get_argument("roomname", None) cookie_user = self.get_secure_cookie("username") if cookie_user is None: self.redirect('/login') else: usertype = common.get_usertype(cookie_user) if setvip_username: sql = "update user set usertype = 1 where username = '******' " %(setvip_username); conn.execute(sql) conn.commit() self.write("设置成功") self.render("admin.html",userType=usertype) if cancelvip_username: sql = "update user set usertype = 0 where username = '******' " %(cancelvip_username) conn.execute(sql) conn.commit() self.write("取消成功") self.render("admin.html",userType=usertype) if delete_username: sql = "delete from user where username = '******' " %(delete_username) conn.execute(sql) conn.commit() self.write("删除成功") self.render("admin.html",userType=usertype) if delete_roomname: sql = "delete from room where roomname = '%s' " %(delete_roomname) conn.execute(sql) conn.commit() self.redirect("/chatroom")
def get(self): uri_list = self.request.uri.split('/') roomid = int(uri_list[-1]) self.set_secure_cookie("roomid", str(roomid), 1) cookie_user = self.get_secure_cookie("username") if cookie_user: usertype = common.get_usertype(cookie_user) roominfo = common.getRoomInfo(roomid) if roominfo is None: #跳转404 self.render("404err.html") #成功合法跳转某聊天房 else: sql = "select username,msg,created_time from message where roomid = %d order by msgid \ desc limit 100" % (roomid) cursor = conn.execute(sql) #最近50条聊天记录 msginfoList = list(cursor.fetchall()) msginfoList.reverse() self.render('chat.html', cookieUser=cookie_user, usertype=usertype, roominfo=roominfo, msginfo=msginfoList) else: self.render('login.html', cookieUser=None, Error=False)
def get(self): uri_list = self.request.uri.split('/') roomid = int(uri_list[-1]) self.set_secure_cookie("roomid", str(roomid),1) cookie_user = self.get_secure_cookie("username") if cookie_user: usertype = common.get_usertype(cookie_user) roominfo = common.getRoomInfo(roomid) if roominfo is None: #跳转404 self.render("404err.html") #成功合法跳转某聊天房 else: sql = "select username,msg,created_time from message where roomid = %d order by msgid \ desc limit 100" % (roomid) cursor = conn.execute(sql) #最近50条聊天记录 msginfoList = list(cursor.fetchall()) msginfoList.reverse() self.render('chat.html', cookieUser=cookie_user, usertype = usertype, roominfo=roominfo, msginfo=msginfoList) else: self.render('login.html', cookieUser=None, Error = False)
def get(self): cookie_user = self.get_secure_cookie("username") if cookie_user is None: self.redirect('/login') else: usertype = common.get_usertype(cookie_user) self.render("admin.html", usertype=usertype, cookieUser=cookie_user)
def get(self): cookie_user = self.get_secure_cookie("username") roomlist = common.getRoomList() if cookie_user: usertype = common.get_usertype(cookie_user) self.render('chatroom.html', cookieUser=cookie_user, usertype = usertype,Error=False, roomlist=roomlist) else: self.render('login.html', cookieUser=None, Error = False)
def get(self): cookie_user = self.get_secure_cookie("username") if cookie_user: usertype = common.get_usertype(cookie_user) self.render('createroom.html', cookieUser=cookie_user, usertype=usertype, Error=False) else: self.render('login.html', cookieUser=None, Error=False)
def get(self): cookie_user = self.get_secure_cookie("username") roomlist = common.getRoomList() if cookie_user: usertype = common.get_usertype(cookie_user) self.render('chatroom.html', cookieUser=cookie_user, usertype=usertype, Error=False, roomlist=roomlist) else: self.render('login.html', cookieUser=None, Error=False)
def get(self): uri_list = self.request.uri.split('/') roomid = int(uri_list[-1]) #print 'roomid: ',roomid self.set_secure_cookie("roomid", str(roomid),1) cookie_user = self.get_secure_cookie("username") if cookie_user: usertype = common.get_usertype(cookie_user) roominfo = common.getRoomInfo(roomid) print roominfo self.render('chat.html', cookieUser=cookie_user, usertype = usertype, roominfo=roominfo) else: self.render('login.html', cookieUser=None, Error = False)
def post(self): roomname = self.get_argument('roomname') username = self.get_secure_cookie('username') #roomname被使用过 if self.check_is_userd(roomname): usertype = common.get_usertype(username) self.render('createroom.html', cookieUser=username, usertype = usertype, Error=True) return sql = "select userid from user where username = '******' " % (username) cursor = conn.execute(sql) for row in cursor: userid = row[0] #创建 sql = "insert into room (roomname, created_time, owner_id) \ values('%s', datetime('now'), %d)" %(roomname, userid) conn.execute(sql) conn.commit() self.redirect("/chatroom")
def get(self, action=None): uri_list = self.request.uri.split('/') roomid = int(uri_list[-1]) self.set_secure_cookie("roomid", str(roomid), 1) cookie_user = self.get_secure_cookie("username") try: cookie_user = cookie_user.decode() except: cookie_user = cookie_user client_id = self.room_handler.add_room(roomid, cookie_user) self.set_cookie("ftc_cid", str(client_id)) if cookie_user: usertype = common.get_usertype(cookie_user) roominfo = common.getRoomInfo(roomid) if roominfo is None: #跳转404 self.render("404err.html") #成功合法跳转某聊天房 else: sql = "select username,msg,created_time from message where roomid = %d order by msgid \ desc limit 100" % (roomid) cursor = conn.execute(sql) #最近50条聊天记录 msginfoList = list(cursor.fetchall()) msginfoList.reverse() for msg in msginfoList: if msg.get("username") == cookie_user: msg["userself"] = True # render self.render('chat.html', cookieUser=cookie_user, usertype=usertype, roominfo=roominfo, msginfo=msginfoList) else: self.render('login.html', cookieUser=None, Error=False)
def post(self): roomname = self.get_argument('roomname') username = self.get_secure_cookie('username') #roomname被使用过 if self.check_is_userd(roomname): usertype = common.get_usertype(username) self.render('createroom.html', cookieUser=username, usertype=usertype, Error=True) return sql = "select userid from user where username = '******' " % (username) cursor = conn.execute(sql) for row in cursor: userid = row[0] #创建 sql = "insert into room (roomname, created_time, owner_id) \ values('%s', datetime('now'), %d)" % (roomname, userid) conn.execute(sql) conn.commit() self.redirect("/chatroom")
def post(self): roomname = self.get_argument('roomname') username = self.get_secure_cookie('username') try: username = username.decode() except NameError: username = username #roomname被使用过 if self.check_is_userd(roomname): usertype = common.get_usertype(username) self.render('createroom.html', cookieUser=username, usertype=usertype, Error=True) return sql = "select userid from user where username = '******' " % (username) cursor = conn.execute(sql) userid = 0 rows = cursor.fetchone() # print (rows ) userid = rows["userid"] # for row in cursor: # userid = row[0] # if userid <= 0: self.redirect("/login") return #创建 sql = "insert into room (roomname, created_time, owner_id) \ values('%s', datetime('now'), %d)" % (roomname, userid) conn.execute(sql) conn.commit() self.redirect("/chatroom")