def post(self):
title = self.get_argument("title", "")
content = self.get_argument("content", "")
if conn_remote.get("SELECT * FROM event_slide WHERE title = %s", title):
conn_remote.execute("UPDATE event_slide SET content = %s WHERE title = %s", content, title)
else:
conn_remote.execute("INSERT INTO event_slide (title, content) VALUES (%s, %s)", title, content)
self.finish({})
def post(self):
login = self.get_argument("login")
password = self.get_argument("password")
user = conn_remote.get("SELECT * FROM users WHERE login = %s", login)
if user and user["password"] == hashlib.sha1(password).hexdigest():
user_id = user["id"]
self.set_secure_cookie("user", tornado.escape.json_encode({"user_id": user_id, "time": time.time()}))
self.redirect("/network")
return
self.redirect("/login?status=error")
def get(self):
#/wifi/login/?gw_address=10.0.0.1&gw_port=2060&gw_id=0C8268174423&url=http%3A//init-p01st.push.apple.com/bag
#gw_address = self.get_argument("gw_address")
#gw_port = self.get_argument("gw_port")
#gw_id = self.get_argument("gw_id")
#url = self.get_argument("url")
# find mac by ip?
remote_ip = self.request.remote_ip if self.request.remote_ip != '127.0.0.1' else self.request.headers['X-Forwarded-For']
device_logs = conn.query("SELECT * FROM device_log WHERE ipv4 = %s ORDER BY id DESC", remote_ip)
if len(device_logs) == 0:
self.finish("Something wrong!")
return
mac = device_logs[0]["mac"]
# find email by mac?
reg = conn_remote.get("SELECT * FROM event_reg_mac WHERE mac = %s", mac)
if reg:
self.redirect("http://10.0.0.1:2060/wifidog/auth?token=%s" % mac)
return
self.render("../template/wifi/login.html")
def get(self):
title = self.get_argument("title", "")
slide = conn_remote.get("SELECT * FROM event_slide WHERE title = %s", title)
self.finish({"title": slide.title, "content": slide.content})
