Пример #1
0
def registration():
    #Looks through the datebase for existing users
    is_valid = True
    mysql = connectToMySQL('button_game')
    query = 'SELECT * FROM users WHERE username=%(username)s;'
    data = {"username": request.form['username']}
    existing_users = mysql.query_db(query, data)
    #Checks for username requirements
    if len(request.form['username']) < 1 or not user_rex.match(
            request.form['username']):
        is_valid = False
        flash("Please enter a valid username")
        return redirect('/signup')
    #Checks if the user exists
    if existing_users:
        is_valid = False
        flash("Username already in use")
        return redirect('/signup')
    #Checks for password requirements
    if not password_rex.match(request.form['password']):
        is_valid = False
        flash("Please enter a password")
        return redirect('/signup')
    #Check if the confirmation password matches the entered password
    if request.form['password'] != request.form['confirm_pw']:
        is_valid = False
        flash("Password does not match")
        # print('false')
        return redirect('/signup')
    #addes new user to the database
    if is_valid:
        password = bcrypt.generate_password_hash(request.form['password'])
        data = {"username": request.form["username"], "password": password}
        mysql = connectToMySQL('button_game')
        query = "INSERT INTO button_game.users (username, password, created_at) VALUES (%(username)s, %(password)s, NOW());"
        userid = mysql.query_db(query, data)
        session['id'] = userid
        data = {"points": int(0), "user_id": session['id']}
        mysql = connectToMySQL('button_game')
        query = "INSERT INTO button_game.points (points, user_id, created_at) VALUES (%(points)s, %(user_id)s, NOW());"
        mysql.query_db(query, data)
        session['username'] = request.form['username']
        session['logged_in'] = True
        return redirect('/button')
Пример #2
0
def createComments():
    if len(request.form['message']) > 255 or len(request.form['message']) < 1:
        flash('Invalid amount of characters')
        return redirect('/button')
    else:
        mysql = connectToMySQL('button_game')
        query = "INSERT INTO comments (comment, user_id, created_at) VALUES (%(comment)s, %(user_id)s, NOW());"
        data = {"comment": request.form["message"], "user_id": session['id']}
        mysql.query_db(query, data)
        flash('Posted!')
        return redirect('/button')
Пример #3
0
def arelogged():
    if session.get('logged_in'):
        username = session['username']
        #Shows points
        mysql = connectToMySQL('button_game')
        query = 'SELECT * FROM users JOIN points ON users.id = points.user_id ORDER BY points DESC;'
        total_points = mysql.query_db(query)
        #Shows current user points
        mysql = connectToMySQL('button_game')
        query = 'SELECT * FROM points WHERE user_id=%(user_id)s;'
        data = {"user_id": session['id']}
        getpoints = mysql.query_db(query, data)
        session['points'] = getpoints[0]["points"]
        #Shows comments
        mysql = connectToMySQL('button_game')
        querry = 'SELECT * FROM users JOIN comments ON users.id = comments.user_id ORDER BY comments.id DESC;'
        comments = mysql.query_db(querry)
        return render_template("button.html",
                               username=username,
                               total_points=total_points,
                               comments=comments,
                               points=session['points'])
    else:
        return redirect('/')
Пример #4
0
def login():
    mysql = connectToMySQL('button_game')
    query = 'SELECT * FROM users WHERE username=%(username)s;'
    data = {"username": request.form['username']}
    query_result = mysql.query_db(query, data)
    #Checks for the entered username in the database
    if not query_result:
        flash('Username/Password is incorrect')
        return redirect('/login')
    pw_hash = query_result[0]["password"]
    password_check = bcrypt.check_password_hash(pw_hash,
                                                request.form['password'])
    if query_result:
        if password_check:
            session['username'] = query_result[0]["username"]
            session['id'] = query_result[0]["id"]
            session['logged_in'] = True
            return redirect('/button')
    else:
        flash("Username/Password is incorrect")
        return redirect('/login')
Пример #5
0
def gainLoss():
    session['points'] = int(session['points']) + random.randint(-5, 10)
    mysql = connectToMySQL('button_game')
    query = "UPDATE points SET points= %(points)s, updated_at = NOW() WHERE user_id= %(user_id)s;"
    data = {"user_id": session['id'], "points": session['points']}
    mysql.query_db(query, data)
    if session['points'] > 100 and session['points'] < 120:
        flash('Good job you made it over 100 points!', 'error')
        return redirect('/button')
    if session['points'] > 500 and session['points'] < 520:
        flash('Good job you made it over 500 points!', 'error')
        return redirect('/button')
    if session['points'] > 1000 and session['points'] < 1020:
        flash('Good job you made it over 1000 points!', 'error')
        return redirect('/button')
    if session['points'] > 1500 and session['points'] < 1520:
        flash('Good job you made it over 1500 points!', 'error')
        return redirect('/button')
    if session['points'] > 2000 and session['points'] < 2020:
        flash('Good job you made it over 2000 points!', 'error')
        return redirect('/button')
    if session['points'] > 2500 and session['points'] < 2520:
        flash('Good job you made it over 2500 points!', 'error')
        return redirect('/button')
    if session['points'] > 3000 and session['points'] < 3020:
        flash('Good job you made it over 3000 points!', 'error')
        return redirect('/button')
    if session['points'] > 3500 and session['points'] < 3520:
        flash('Good job you made it over 3500 points!', 'error')
        return redirect('/button')
    #This is for testing the Flash Message
    # if session['points'] > 1:
    #     flash('Good job you made it over test points!', 'error')
    #     return redirect('/button')
    else:
        return redirect('/button')
Пример #6
0
def renderHomepage():
    mysql = connectToMySQL('button_game')
    query = 'SELECT * FROM users JOIN points ON users.id = points.user_id ORDER BY points DESC;'
    total_points = mysql.query_db(query)
    return render_template("homepage.html", total_points=total_points)