def main():
if not html.check_player(loggedIn):
return
html.open_html(sess.cookie, loggedIn)
#Get data through SQL
achievements = sql.run_sql("""SELECT Achievement.AchievementID, Achievement.Name, Achievement.InstanceRunID, Achievement.WhenAchieved, Achievement.RewardBody
FROM Achievement""")
body.print_achievements("Achievements", ("Name", "Instance Run ID", "When Achieved", "Reward Body"), achievements, loggedIn)
html.close_html()
return
def main():
if not html.check_player(loggedIn):
return
html.open_html(sess.cookie, loggedIn)
#Get data through params and SQL
gameID = params['gameID'].value
game_data = sql.run_sql("""SELECT GameID, Name, Genre, Review, StarRating, ClassificationRating, PlatformNotes, PromotionLink, Cost FROM Game WHERE GameID = %s"""%(gameID))[0]
body.print_game(game_data)
html.close_html()
return
def main():
if not html.check_player(loggedIn):
return
html.open_html(sess.cookie, loggedIn)
#Get data through params and SQL
instance_runs = sql.run_sql("""SELECT IR.InstanceRunID, IR.Name, IR.RecordedTime, IR.CategoryName, P.GameHandle
FROM InstanceRun as IR, Player as P
WHERE P.PlayerID = IR.SupervisorID""")
body.print_instances("Instance Runs", ("Name", "Time", "Category Name", "Supervisor Handle"), instance_runs, loggedIn)
html.close_html()
return
def main():
if not html.check_player(loggedIn):
return
html.open_html(sess.cookie, loggedIn)
# Get data through params and SQL
achievementID = params["achievementID"].value
achievement_data = sql.run_sql(
"""SELECT AchievementID, Name, InstanceRunID, WhenAchieved, RewardBody FROM Achievement WHERE AchievementID = %s"""
% (achievementID)
)[0]
body.print_achievement(achievement_data)
html.close_html()
return
def main():
if not html.check_player(loggedIn):
return
html.open_html(sess.cookie, loggedIn)
if params.has_key('notFound'):
print """
<div style="text-align:center" class="col-lg-4 col-lg-offset-4">
<label class="col-lg-3 control-label">User Not Found</label>
</div>
"""
search_form()
html.close_html()
return
def main():
#Get Session from cookie and fieldstorage that has been passed on from previous page
sess = session.Session(expires=20*60, cookie_path='/')
username = sess.data.get('userName')
loggedIn = sess.data.get('loggedIn')
params= cgi.FieldStorage()
if not html.check_player(loggedIn):
return
#Get data through params and SQL
instanceRunID = params['instancerunID'].value
IR = sql.run_sql("""SELECT InstanceRun.InstanceRunID, InstanceRun.Name, InstanceRun.SupervisorId, InstanceRun.CategoryName FROM InstanceRun
WHERE InstanceRun.InstanceRunID = %s"""%instanceRunID)[0]
html.open_html(sess.cookie, loggedIn)
if IR:
body.edit_instancerun(IR)
html.close_html()
return
#######################################################################################################
#Get Session from cookie and fieldstorage that has been passed on from previous page
sess = session.Session(expires=20*60, cookie_path='/')
loggedIn = sess.data.get('loggedIn')
params= cgi.FieldStorage()
#######################################################################################################
#######################################################################################################
#edit only if run ends up being true
run = True
#Check if user is loggedIn with authority and does not have deletion flag set up
if not html.check_player(loggedIn):
run = False
if params.has_key('delete'):
run = False
#If run is still set to true, get all the information from CGI fieldstorage
if run:
achievementID= params['achievementID'].value
achievementName= params['achievementName'].value
instancerunID= params['instancerunID'].value
whenAchieved= params['whenAchieved'].value
rewardBody= params['rewardBody'].value
#######################################################################################################
def main():
#Run delete if deletion flag is set
