def confirm_order():
if not html.check_logged_in(loggedIn):
return
viewerID = sql.run_sql("""SELECT ViewerID FROM ViewerLogin
WHERE UserName = '******'"""%username)[0][0]
videoids = sql.run_sql("""SELECT VideoID FROM ViewerOrderLine
WHERE ViewerOrderID IN (SELECT ViewerOrderID FROM ViewerOrder
WHERE ViewerID = %d)"""%viewerID)
for item in videoids:
if int(vidid) in item:
redirect.refresh("viewer_order.py?error=1", sess.cookie)
return
viewerorderID = sql.run_insert("""INSERT INTO ViewerOrder VALUES
(DEFAULT, CURDATE(), NULL, 'Pending', %d)"""%viewerID)
viewerType = sql.run_sql("""SELECT ViewerType FROM Viewer
WHERE ViewerID = %d"""%viewerID)[0][0]
if viewerType == 'C':
viewerType = 1
else:
viewerType = 0
sql.run_insert("""INSERT INTO ViewerOrderLine VALUES
(%s, %s, %s)"""%(vidid, viewerorderID, str(bool(viewerType)).upper()))
redirect.refresh("viewer_order.py", sess.cookie)
return
def main():
if cancel:
cancelSubscription()
else:
renewSubscription()
redirect.refresh("login.py", sess.cookie)
return
def main():
#Print error if any exist
if error:
redirect.refresh("player_edit_profile.py?error=1", sess.cookie)
return
updateViewerInfo()
redirect.refresh("player_edit_profile.py", sess.cookie)
return
def main():
#If error, redirect back to add page
if error == 1:
redirect.refresh("add_video.py?error=1", sess.cookie)
return
#Insertion successful, redirect to newly created video's edit page
id = addVideoInfo()
redirect.refresh("viewer_order.py?vidid=%s "%(id), sess.cookie)
return
def main():
#If error, redirect back to add page
if error == 1:
redirect.refresh("add_instance.py?error=1", sess.cookie)
return
#Insertion successful, redirect to newly created instanceRun's edit page
id = addInstanceInfo()
redirect.refresh("player_edit_instancerun.py?instancerunID=%s "%(id), sess.cookie)
return
def main():
#If error, redirect back to add page
if error == 1:
redirect.refresh("add_game.py?error=1", sess.cookie)
return
#Insertion successful, redirect to newly created game's edit page
addGameInfo()
redirect.refresh("player_manage_games.py", sess.cookie)
return
def main():
#If error, redirect back to add page
if error == 1:
redirect.refresh("add_achievement.py?error=1", sess.cookie)
return
#Insertion successful, redirect to newly created achievement's edit page
id = addAchievementInfo()
redirect.refresh("player_edit_an_achievement.py?achievementID=%s "%(id), sess.cookie)
return
def main():
if loggedIn in (1, 2):
redirect.refresh("home.py", sess.cookie)
return
params = cgi.FieldStorage()
cookie = sess.cookie
html.open_html(cookie, 0)
form.print_form(params.has_key('error'))
html.close_html()
sess.close()
return
def main():
#Run delete if deletion flag is set
if loggedIn == 2 and params.has_key('delete'):
achievementid= params["achievementID"].value
remove_achievement(achievementid)
#redirect to view achievement page
redirect.refresh("player_view_achievements.py",sess.cookie)
return
#Else, update information
updateAchievementInfo()
#redirect to edit page of the achievement that just got editted
redirect.refresh("player_edit_an_achievement.py?achievementID=%s"%achievementID, sess.cookie)
return
def main():
#Run delete if deletion flag is set
if loggedIn == 2 and params.has_key('delete'):
instanceRunID= params["instancerunID"].value
remove_instance(instanceRunID)
#redirect to view instanceRun page
redirect.refresh("player_view_instanceruns.py",sess.cookie)
return
#Else, update information
updateInstanceInfo()
#redirect to edit page of the instanceRun that just got editted
redirect.refresh("player_edit_instancerun.py?instancerunID=%s"%instancerunID, sess.cookie)
return
def main():
if not html.check_logged_in(loggedIn):
return
html.open_html(sess.cookie, loggedIn)
error = False
username = params['userName'].value
if (loggedIn != 2) and (sess.data['userName'] != username):
redirect.refresh("home.py", sess.cookie)
return
if params.has_key('error'):
error = True
print_body(username, error)
html.close_html()
sess.close()
return
def main():
if not html.check_logged_in(loggedIn):
return
html.open_html(sess.cookie, loggedIn)
error = False
# Get data through params and SQL
username = sess.data["userName"]
if loggedIn != 2:
redirect.refresh("home.py", sess.cookie)
return
if params.has_key("error"):
error = True
print_body(username, error)
html.close_html()
sess.close()
return
def main():
if error == 1:
redirect.refresh("register_viewer.py?error=1", sess.cookie)
return
if checkAccount() == 3:
redirect.refresh("register_viewer.py?error=3", sess.cookie)
return
if checkAccount() == 4:
redirect.refresh("register_viewer.py?error=4", sess.cookie)
return
addViewerInfo()
redirect.refresh("login.py", sess.cookie)
return
def main():
if loggedIn == 2 and params.has_key('delete'):
viewerID = params["viewerID"].value
remove_viewer(viewerID)
redirect.refresh("home.py",sess.cookie)
return
if error:
redirect.refresh("viewer_edit_profile.py?error=1", sess.cookie)
return
updateViewerInfo()
redirect.refresh("viewer_edit_profile.py?userName=%s"%username, sess.cookie)
return
def main():
if delete:
delete_video(videoID)
redirect.refresh("home.py", sess.cookie)
return
price = process_price(videoPrice)
error = check_price(price)
error = check_supervisor(supervisorID)
if error:
redirect.refresh("home.py?error=1", sess.cookie)
return
updateVideoInfo(price)
redirect.refresh(("viewer_order.py?vidid=%s")%(videoID), sess.cookie)
return
def main():
#Run delete if deletion flag is set
if loggedIn == 2 and params.has_key('delete'):
gameID = params['gameID'].value
delete_game(gameID)
#redirect to view achievement page
redirect.refresh("player_manage_games.py",sess.cookie)
return
#Else, update information
price = process_price(gamePrice)
error = check_price(price)
if error:
redirect.refresh("player_manage_games.py?error=1", sess.cookie)
return
updateGameInfo(price)
#redirect to edit page of the achievement that just got editted
redirect.refresh("player_manage_games.py", sess.cookie)
return
#######################################################################################################
# Authors: Beaudan Campbell-Brown, Derek Mui, Ha Jin Song, Jerry Chen
# INFO20003 assessment
# File to handle editting of viewer player using player
#######################################################################################################
import cgi, sql_handler as sql, redirect, session, html_template as html
#######################################################################################################
# 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()
#######################################################################################################
viewerID = params["viewerID"].value
result = sql.run_sql("""SELECT UserName FROM ViewerLogin WHERE ViewerLogin.ViewerID = %s""" % viewerID)
if result:
username = result[0][0]
if html.check_logged_in(loggedIn):
redirect.refresh("viewer_edit_profile.py?userName=%s" % (username), sess.cookie)
else:
redirect.refresh("player_find_viewer.py?notFound=1", sess.cookie)
redirect.refresh("add_achievement.py?error=1", sess.cookie)
return
#Insertion successful, redirect to newly created achievement's edit page
id = addAchievementInfo()
redirect.refresh("player_edit_an_achievement.py?achievementID=%s "%(id), sess.cookie)
return
#######################################################################################################
#Valide fieldstorage and make sure all required input are given by user
def validate_params():
if not (params.has_key('AchievementName') and params.has_key('RewardBody')):
return 2
return
#######################################################################################################
#Run SQL insertion and get newly added achievement's ID
def addAchievementInfo():
achievementID= sql.run_insert("""INSERT INTO Achievement VALUES
(DEFAULT, NULL, NULL, '%s', '%s')
"""%(name,reward))
return achievementID
#Check for error
if validate_params() == 2:
redirect.refresh("add_achievement.py?error=2", sess.cookie)
#Add new achievement given input
else:
name= params['AchievementName'].value
reward= params['RewardBody'].value
error = 0
main()
def validate_params():
if not (params.has_key('gameName') and params.has_key('genre')
and params.has_key('review') and params.has_key('starRating')
and params.has_key('classificationRating') and params.has_key('platformNotes')
and params.has_key('promotionLink') and params.has_key('price')):
return 2
return
#######################################################################################################
#Run SQL insertion and get newly added game's ID
def addGameInfo():
addressID = sql.run_insert("""INSERT INTO Game VALUES
(DEFAULT, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')
"""%(gameName, genre, review, starRating, classificationRating, platformNotes, promotionLink, price))
return
#Check for error
if validate_params() == 2:
redirect.refresh("add_game.py?error=2", sess.cookie)
#Add new game given input
else:
gameName = params['gameName'].value
genre = params['genre'].value
review = params['review'].value
starRating = params['starRating'].value
classificationRating = params['classificationRating'].value
platformNotes = params['platformNotes'].value
promotionLink = params['promotionLink'].value
price = params['price'].value
error = 0
main()
id = addInstanceInfo()
redirect.refresh("player_edit_instancerun.py?instancerunID=%s "%(id), sess.cookie)
return
#######################################################################################################
#Valide fieldstorage and make sure all required input are given by user
def validate_params():
if not (params.has_key('Name') and params.has_key('supervisorName')
and params.has_key('Category')):
return 2
return
#######################################################################################################
#Run SQL insertion and get newly added instanceRun's ID
def addInstanceInfo():
superID= sql.run_sql("""SELECT playerID FROM Player WHERE GameHandle = "%s" """ % (superName))[0][0]
instancerunID= sql.run_insert("""INSERT INTO InstanceRun VALUES
(DEFAULT, %s, '%s',NOW(), '%s')
"""%(superID,name,category))
return instancerunID
#Check for error
if validate_params() == 2:
redirect.refresh("add_instance.py?error=2", sess.cookie)
#Add new instanceRun given input
else:
superName= params['supervisorName'].value
name= params['Name'].value
category= params['Category'].value
error = 0
main()
viewerCity, viewerState,
viewerPCode, viewerCountry))
viewerID = sql.run_insert("""INSERT INTO Viewer VALUES
(DEFAULT, 'N', '%s-%s-%s', '%s')"""%(viewerDOBYear, viewerDOBMonth, viewerDOBDay, viewerEmail))
sql.run_insert("""INSERT INTO ViewerLogin VALUES
('%s', '%s', %d)"""%(viewerUserName, viewerPwd1, viewerID))
sql.run_insert("""INSERT INTO ViewerAddress VALUES
(%d, %d, CURDATE(), NULL)"""%(viewerID, addressID))
return
#######################################################################################################
#Only store paramater values if they have all been entered, check date is valid
if validate_params() == 2:
redirect.refresh("register_viewer.py?error=2", sess.cookie)
else:
viewerUserName = params['username'].value
viewerPwd1 = params['password1'].value
viewerPwd2 = params['password2'].value
viewerDOBYear = params['year'].value
viewerDOBMonth = params['month'].value
viewerDOBDay = params['day'].value
viewerEmail = params['email'].value
viewerStNo = params['streetNo'].value
viewerStName = params['streetName'].value
viewerStType = params['streetType'].value
viewerSuburb = params['suburb'].value
viewerCity = params['city'].value
viewerState = params['state'].value
def validate_params():
if not (params.has_key('videoName') and params.has_key('gameName')
and params.has_key('videoURL') and params.has_key('videoType')
and params.has_key('videoPrice') and params.has_key('InstanceName')):
return 2
return
#######################################################################################################
#Run SQL insertion and get newly added video's ID
def addVideoInfo():
gameID = sql.run_sql("""SELECT GameID FROM Game WHERE Name = "%s" """ % (GameName))[0][0]
instancerunID = sql.run_sql("""SELECT InstanceRunID FROM InstanceRun WHERE Name = "%s" """ % (InstanceRunName))[0][0]
videoID= sql.run_insert("""INSERT INTO Video VALUES
(DEFAULT, '%s', '%s', '%s', '%s', '%s', '%s')
"""%(videoName,videoURL,videoPrice,videoType,instancerunID,gameID))
return videoID
#Check for error
if validate_params() == 2:
redirect.refresh("home.py?error=2", sess.cookie)
#Add new video given input
else:
videoName= params['videoName'].value
videoURL= params['videoURL'].value
videoType= params['videoType'].value
videoPrice= params['videoPrice'].value
InstanceRunName= params['InstanceName'].value
GameName= params['gameName'].value
error = 0
main()
def check_player(loggedIn):
if loggedIn != 2:
redirect.refresh("login.py", sess.cookie)
return False
return True
def check_logged_in(loggedIn):
if loggedIn not in (1, 2):
redirect.refresh("login.py", sess.cookie)
return False
return True
