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")
