def post(self):
email = self.get_argument("email")
"""
reg = conn_remote.get("SELECT * FROM event_reg WHERE email = %s", email)
if not reg:
self.finish("You email is not registered.")
return
"""
regs = conn_remote.query("SELECT * FROM event_reg_mac WHERE email = %s", email)
if len(regs) >= 2:
self.finish("Sorry, your email has been used for too many times")
return
# 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"]
conn_remote.execute("INSERT INTO event_reg_mac (email, mac) VALUES(%s, %s)", email, mac)
# create an unquie token in database
self.redirect("http://10.0.0.1:2060/wifidog/auth?token=%s" % mac)
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):
title = self.get_argument("title", "")
conn_remote.execute("DELETE FROM event_slide WHERE title = %s", title)
self.finish({})
