def start_page():
print(session.get("username"))
print(session.get("logged_in"))
if not session.get("logged_in"):
print("No username found in session")
return log_in()
else:
print("Success")
img = fetchone(
"select img from(profile join registration on profile.pid = registration.pid) where username = %s",
[session["username"]])
profileInfo = []
profileInfo = fetchall(
"select * from(profile join registration on profile.pid = registration.pid) where username = %s",
[session["username"]])
personName = fetchone(
"select name from(person join registration on person.pid = registration.pid) where username = %s",
[session["username"]])
session["logged_in"] = True
return render_template("welcome.html",
picture=img,
user=session["username"],
profileInfo=profileInfo,
personName=personName)
def user_log():
if user_login.log_in() == True:
username = request.form["userName"]
img = fetchone(
"select img from(profile join registration on profile.pid = registration.pid) where username = %s",
[username])
profileInfo = []
profileInfo = fetchall(
"select * from(profile join registration on profile.pid = registration.pid) where username = %s",
[username])
personName = fetchone(
"select name from(person join registration on person.pid = registration.pid) where username = %s",
[username])
session["username"] = username
session["logged_in"] = True
return render_template("welcome.html",
picture=img,
user=session["username"],
profileInfo=profileInfo,
personName=personName)
elif user_login.log_in() == False:
flash("Fel lösenord eller användarnamn")
return render_template("log_in.html", username="")
def validatepicture(username):
if request.method == "POST":
print("1 validate")
print(request.files)
if request.files:
print("2 validate")
image = request.files["image"]
print(image)
if image.filename == "":
asd = fetchone(
"select pid from registration where username = %s",
[username])
oldpic = fetchone("select img from profile where pid = %s",
[asd])
return oldpic
if not allowed_image(image.filename):
print(image.filename)
print("That image extension is not allowed")
return redirect(request.url)
else:
filename = secure_filename(image.filename)
print(image)
image.save(os.path.join(UPLOAD_FOLDER, image.filename))
return "static/img/uploads/" + str(image.filename)
def booking_game(matchid):
matchid = int(matchid)
players = request.form["players"]
print(players)
if players == "0":
flash("Var vänlig och boka en plats")
print("players = 0" + players)
return render_template("match_profile.html",
match=show_match.show_Match_Profile(matchid))
else:
print("antal högre än 0:" + players)
booked = fetchone("select booked from match where matchid = %s",
[matchid])
def new_booked():
print(players)
if (int(players) + booked[0]) > 4:
return "4"
else:
return int(players) + booked[0]
print(matchid, session["username"])
creatorName = fetchone("select creator from match where matchid = %s",
[matchid])
sql = "insert into booking values(%s,%s,%s,%s)"
val = matchid, session["username"], creatorName, players
insert(sql, val)
sql = "UPDATE match SET booked = %s WHERE matchid = %s;"
val = new_booked(), matchid
update(sql, val)
sql = "UPDATE match SET players = %s WHERE matchid = %s;"
searching = fetchone("select players from match where matchid = %s",
[matchid])
print(searching[0])
searching = searching[0] - int(players)
val = searching, matchid
update(sql, val)
return start_page()
sql = "UPDATE match SET players = %s WHERE matchid = %s;"
searching = fetchone("select players from match where matchid = %s",
[matchid])
print(searching[0])
searching = searching[0] - int(players)
val = searching, matchid
update(sql, val)
return start_page()
def editProfile(username):
asd = fetchone("select pid from registration where username = %s",
[username])
oldpic = fetchone("select img from profile where pid = %s", [asd])
img = validatepicture(username)
info = request.form["info"]
level = request.form["level"]
age = request.form["age"]
if img == oldpic and age == "" and info == "":
print("ifsats 1")
sql = "update profile set level = %s where pid = %s"
val = (level, asd)
update(sql, val)
elif img == oldpic and age == "":
print("ifsats 2")
sql = "update profile set level = %s, info = %s where pid = %s"
val = (level, info, asd)
update(sql, val)
elif img == oldpic:
print("ifsats 3")
sql = "update profile set level = %s, info = %s, age = %s where pid = %s"
val = (level, info, age, asd)
update(sql, val)
elif img != oldpic and age == "" and info == "":
print("ifsats 4")
sql = "update profile set level = %s, img = %s where pid =%s"
val = (level, img, asd)
update(sql, val)
elif img != oldpic and age == "":
print("ifsats 5")
sql = "update profile set level = %s, img = %s, info = %s where pid = %s"
val = (level, img, info, asd)
update(sql, val)
else:
print("ifsats 6")
sql = "update profile set level = %s, img = %s, info = %s, age = %s where pid =%s"
val = (level, img, info, age, asd)
update(sql, val)
for item in oldpic:
if os.path.exists(str(item)):
os.remove(str(item.rsplit('/')[3]))
print("bild borttagen")
def editProfile(username):
img = request.form["img"]
info = request.form["info"]
level = request.form["level"]
age = request.form["age"]
asd = fetchone("select pid from registration where username = %s",
[username])
sql = "update profile set img = %s, info = %s, level = %s, age = %s where pid = %s"
val = (img, info, level, age, asd)
update(sql, val)
def profil():
profile.editProfile(session["username"])
img = fetchone(
"select img from(profile join registration on profile.pid = registration.pid) where username = %s",
[session["username"]])
profileInfo = []
profileInfo = fetchall(
"select * from(profile join registration on profile.pid = registration.pid) where username = %s",
[session["username"]])
personName = fetchone(
"select name from(person join registration on person.pid = registration.pid) where username = %s",
[session["username"]])
return render_template("welcome.html",
picture=img,
user=session["username"],
profileInfo=profileInfo,
personName=personName)
def changeProfile():
informationProfile = fetchall(
"select * from (profile join registration on profile.pid = registration.pid) where username = %s",
[session["username"]])
img = fetchone(
"select img from(profile join registration on profile.pid = registration.pid) where username = %s",
[session["username"]])
return render_template("edit_profile.html",
user=session["username"],
info=informationProfile,
pics=img)
def show_chatt(matchid):
matchid = int(matchid)
print(matchid)
antal = request.form["antal"]
booked = fetchone("select booked from match where matchid = %s", [matchid])
print(booked[0])
new_booked = int(antal) + booked[0]
print(matchid, session["username"])
creatorName = fetchone("select skapare from match where matchid = %s",
[matchid])
sql = "insert into booking values(%s,%s,%s)"
val = matchid, session["username"], creatorName
insert(sql, val)
sql = "UPDATE match SET booked = %s WHERE matchid = %s;"
val = new_booked, matchid
print(matchid, session["username"])
update(sql, val)
sql = "UPDATE match SET antal = %s WHERE matchid = %s;"
sökes = fetchone("select antal from match where matchid = %s", [matchid])
print(sökes[0])
sökes = sökes[0] - int(antal)
val = sökes, matchid
update(sql, val)
# Future chatt fnction
# def sessions():
# return render_template('session.html')
# def messageReceived(methods=['GET', 'POST']):
# print('message was received!!!')
# @socketio.on('my event')
# def handle_my_custom_event(json, methods=['GET', 'POST']):
# print('received my event: ' + str(json))
# socketio.emit('my response', json, callback=messageReceived)
# return render_template('session.html')
return start_page()
def insert_match():
players = request.form["players"]
show_match.create_Game(session["username"])
matchid = fetchone("select max(matchid) from match where matchid > %s",
"0")
if matchid[0] == None:
matchid = 1
sql = "insert into booking (matchid,username,creatorname,booked) values (%s,%s,%s,%s)"
val = matchid, session["username"], session["username"], players
insert(sql, val)
return start_page()
def remove_booking(matchid):
sql = "select booked from booking where matchid=%s AND username=%s"
val = matchid, session["username"]
current_booking = fetchone(sql, val)
sql = "update match set players=(players+%s) where matchid =%s"
val = current_booking, matchid
update(sql, val)
sql = "update match set booked=(booked-%s) where matchid =%s"
val = current_booking, matchid
update(sql, val)
sql = "delete from booking where matchid=%s AND username=%s"
val = matchid, session["username"]
update(sql, val)
return show_my_games()
def change_password(password, new_password):
cred = fetchone("select password from registration where username=%s",
[session["username"]])
stored_password = cred[0]
user_login.verify_password(stored_password, password)
if user_login.verify_password(stored_password, password) == True:
new_password = user_registration.hash_password(new_password)
sql = "update registration set password = %s WHERE username = %s"
val = new_password, session["username"]
update(sql, val)
print("update")
return True
else:
flash("Fel lösenord")
return False
def insert_match():
ort = request.form["ort"]
klass = request.form["klass"]
antal = request.form["antal"]
show_match.create_Game(session["username"])
matchid = fetchone("select max(matchid) from match where matchid > %s",
"0")
print(matchid)
if matchid[0] == None:
matchid = 1
print(matchid)
sql = "insert into booking (matchid,username,creatorname) values (%s,%s,%s)"
val = matchid, session["username"], session["username"]
insert(sql, val)
print(matchid, session["username"])
return render_template("find_match.html",
games=show_match.show_Game(ort, klass, antal))
def log_in():
cred = []
cred = fetchall("select username from registration", "")
usernameList = ("".join(str(cred)))
username = request.form["userName"]
password = request.form["pwd"]
if username in usernameList:
usernameToFind = (username, )
cred = fetchone("select password from registration where username=%s",
usernameToFind)
stored_password = cred[0]
print(stored_password)
print(password)
if verify_password(stored_password, password):
print("Password is correct")
return True
else:
print(stored_password)
print(password)
print("fel lösenord")
return False
else:
return False
