-
Notifications
You must be signed in to change notification settings - Fork 0
/
app.py
189 lines (146 loc) · 5.5 KB
/
app.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
import flask
from flask_cors import cross_origin
import json
from flask_socketio import SocketIO, join_room, emit
from flask import render_template
from flask_sqlalchemy import SQLAlchemy
from models.app_db import init, Model
from blueprint import apps
from flask_login import LoginManager, login_required, current_user
from flask_principal import Principal, Permission, RoleNeed, identity_loaded, UserNeed
import os
import sys
import hashlib
app = flask.Flask(__name__)
principals = Principal(app)
app.secret_key = "sctkey"
app.config["static_url_path"] = "assets"
app.config["static_folder"] = 'assets'
login_manager = LoginManager()
login_manager.init_app(app)
login_manager.session_protection = "strong"
login_manager.login_view = 'homepage'
socketio = SocketIO(app)
if len(sys.argv) and sys.argv[-1] == "debug":
app.config["T_DEBUG"] = True
else:
app.config["T_DEBUG"] = False
@login_manager.user_loader
def user_loader(usr):
user = Model.Users
return user.query.get(int(usr))
@identity_loaded.connect_via(app)
def on_identity_loaded(sender, identity):
identity.user = current_user
if hasattr(current_user, 'id'):
identity.provides.add(UserNeed(current_user.id))
if hasattr(current_user, 'role'):
if current_user.role:
for role in current_user.role:
identity.provides.add(RoleNeed(role))
@app.context_processor
def cache_busters():
return {
'assets':
'https://raw.githubusercontent.com/yl12053/LWMotherland/Dev/assets',
"local_assets": "/assets"
}
@app.after_request
def add_header(r):
if hasattr(r, 'ext_cac'):
return r
else:
r.headers["Cache-Control"] = "no-cache, no-store, must-revalidate"
r.headers["Pragma"] = "no-cache"
r.headers["Expires"] = "0"
r.headers['Cache-Control'] = 'public, max-age=0'
return r
app.config["TEMPLATES_AUTO_RELOAD"] = True
db = SQLAlchemy()
app.config[
"SQLALCHEMY_DATABASE_URI"] = "mysql+pymysql://lwmotherland:lwmotherland@db4free.net/lwmotherland"
init(db, app)
@app.route("/assets/<path:path>")
@cross_origin()
def assets(path):
rtv = flask.send_from_directory(
"assets",
path,
conditional=False,
as_attachment=False,
download_name=None,
)
rtv.headers['Cache-Control'] = "no-cache, must-revalidate"
rtv.make_conditional(flask.request)
rtv.ext_cac = True
return rtv
@app.route("/google95a4c2e4ac08c0ae.html", methods=["GET", "POST"])
def google_verification_verify():
return open("static_root/google95a4c2e4ac08c0ae.html").read()
if app.config["T_DEBUG"]:
@app.route("/")
def root():
#return open("index.html", "r").read()
return homepage()
@app.route("/lb")
def leaderboard():
return open("view.html", "r").read()
@app.route("/home")
def homepage():
return render_template("homepage/home.html")
else:
@app.route("/")
def root():
return render_template("homepage/home.html")
@app.route("/map")
@login_required
def map():
mdf = Model.player_position.query.filter_by(id=current_user.id).first()
if mdf is not None:
rerr = mdf.preventRedone
else:
rerr = 0
return render_template("map/map.html",
asset_file="/assets/video/newmap.mp4",
type_asset="video",
width="2020",
height="1520",
rerr=str(rerr))
for x in apps:
app.register_blueprint(x)
@app.route("/lbs")
def p():
tabd = Model.self_db.engine.execute(
"select concat(grps, ' (', mid(sec_to_time(pasg), 4, 8), ')') as 'grpn', avgTotal + ifnull(mks, 0) as 'fmks' from (select grps as 'grps', avg(total) as 'avgTotal', avg(game1tl) as 'pasg' from (select Auth.grp as 'grps', Auth.subindex as 'sid', sum(ifnull(Game1Details.timeLeftGame1, 0)) as 'game1tl', sum(if(Game1Bypass.passed = 0 or Game1Bypass.passed is null, 0, 130 - if(Game1Bypass.tipsGiven is NULL, 0, JSON_LENGTH(Game1Bypass.tipsGiven)*10)) + ifnull(Game1Details.correctCountGame1*10 + Game1Details.timeBonus, 0) + ifnull(Game2Details.marks, 0)) as 'total' from Game1BQ, (((Auth left join Game1Details on Auth.id=Game1Details.id) left join Game2Details on Auth.id=Game2Details.id) left join Game1Bypass on Auth.id=Game1Bypass.id) group by Auth.grp, Auth.subindex) as firstResult group by grps) as tabInterm left join (select `group` as grpst, sum(mark) as 'mks' from additional_mark group by grpst) as tabOuterm on tabInterm.grps = tabOuterm.grpst order by fmks desc, pasg desc;"
).all()
return flask.jsonify([[x[0], float(x[1])] for x in tabd])
@app.route("/<path:path>")
def asroot(path):
return flask.send_from_directory("As_Root",
path,
conditional=False,
as_attachment=False,
download_name=None)
@app.route(app.static_url_path + '/' + '<path:path>' + ".ts")
def jsonl_mime_type(path):
return flask.send_from_directory(directory=app.static_folder,
path=path + ".ts",
mimetype="text/javascript")
def hand(t, u):
with app.app_context():
usr = Model.Users.query.filter_by(id=u).first()
name = usr.used_name
socketio.emit('sdone', {"name": name, "time": t, "id": u}, to='manag')
@socketio.on('join')
def j(d):
join_room("manag")
print("[SocketIO] Teacher emitted event join")
emit('joined', {})
@socketio.on('connect')
def onCon(conn):
print("[SocketIO] Teacher joined")
emit('ableToJoin', {})
Model.handler = hand
print("[Main] Runway Clear!")
if __name__ == "__main__":
app.run("0.0.0.0", 5000)