Advertisement
Guest User

Untitled

a guest
Dec 10th, 2018
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 2.41 KB | None | 0 0
  1. def login(user=None):
  2.     if not session.get('key'):
  3.         if request.method == 'POST':
  4.             username = None
  5.             password = None
  6.             if 'username' in request.values:
  7.                 username = request.values['username']
  8.             if 'password' in request.values:
  9.                 password = request.values['password']
  10.             if 'over' in request.values:
  11.                 over = request.values['over']
  12.                 link = "https://www.google.com/recaptcha/api/siteverify?secret=6Ldfy3sUAAAAAFj3oiP4weo1L022m9oZRuCFcsG8&response=" + over
  13.                 jsonobj = json.loads(urllib.request.urlopen(link).read())
  14.                 # print(jsonobj)
  15.             if (username is not None) and (password is not None) and jsonobj['success']:
  16.                 conn = mysql.connect()
  17.                 cursor = conn.cursor()
  18.                 sql = "SELECT * FROM `user` WHERE user_name = %s"
  19.                 val = username
  20.                 cursor.execute(sql, val)
  21.                 res = cursor.fetchall()
  22.                 sql = "SELECT * FROM logs WHERE logs.username = %s AND logs.ip ='"+request.remote_addr+"';"
  23.                 cursor.execute(sql, val)
  24.                 res2 = cursor.fetchall()
  25.                 print(len(res2))
  26.                 sql = "INSERT INTO logs (ip, username) VALUES ('" + request.remote_addr + "','" + val + "');"
  27.                 if len(res) > 0:
  28.                     if check_password(res[0][2], password):
  29.                         session['key'] = res[0][0]
  30.                         session['name'] = res[0][1]
  31.                         return redirect("/home")
  32.                     else:
  33.                         if(len(res2) > 3):
  34.                             print("vymaze db")
  35.                             sql = "DELETE FROM logs WHERE ip ='"+request.remote_addr+"' AND logs.username=%s;"
  36.                             time.sleep(20)
  37.                             cursor.execute(sql,val)
  38.                         else:
  39.                             sql = "INSERT INTO logs (ip, username) VALUES ('" + request.remote_addr + "','" + val + "');"
  40.                             cursor.execute(sql)
  41.                         return render_template("login.html", name=user)
  42.                 else:
  43.                     cursor.execute(sql)
  44.                     return render_template("login.html", name=user)
  45.     else:
  46.         return redirect("/home")
  47.     return render_template("login.html", name=user)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement