def detect_ip(data): conn = F.db_get_conn() cursor = conn.cursor() for ip in data: rez = F.ping_host(ip) if rez: sql = 'insert into xpp_log (ip,status,create_time) values ("%s",1,%s)'%(ip,str(time.time())[:10]) else: sql = 'insert into xpp_log (ip,status,create_time) values ("%s",0,%s)'%(ip,str(time.time())[:10]) cursor.execute(sql) conn.commit() cursor.close() conn.close()
def isonline(ip): if not session.get('log_in'): return redirect(url_for('login')) if F.ping_host(ip): return 'online' return 'offline'