keii.dev
1from flask import Blueprint, Flask, render_template, request, Response, send_file
2import mysql.connector
3import json, time, uuid
4from markupsafe import escape
5
6def getUserPermission(userid):
7 mydb = mysql.connector.connect(
8 host="localhost",
9 user="willem",
10 password="Dinkel2006!",
11 database="shykeiichicom"
12 )
13
14 mycursor = mydb.cursor()
15
16 mycursor.execute(f"SELECT * FROM elevated_permissions WHERE userid={userid}")
17
18 permission = mycursor.fetchone()
19
20 if(permission == None):
21 return 0
22
23 return permission[2]
24
25def isValidSession(sessionid):
26 mydb = mysql.connector.connect(
27 host="localhost",
28 user="willem",
29 password="Dinkel2006!",
30 database="shykeiichicom"
31 )
32
33 mycursor = mydb.cursor()
34
35 mycursor.execute(f"SELECT * FROM sessions WHERE sessionid={sessionid}")
36
37 myresult = mycursor.fetchone()
38
39 if myresult == None:
40 return False
41
42 if(int(time.time() - int(myresult[2])) > 2419200):
43 mycursor.execute(f"DELETE FROM sessions WHERE sessionid={sessionid}")
44 return False
45
46 return {
47 "sessionid": myresult[0],
48 "userid": myresult[1],
49 "timestamp": myresult[2]
50 }