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