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