def main():
usertype = utility.header("new game distributor", "")
if usertype != "A":
utility.redirect("login.py")
else:
generate_form()
def main():
# check if it is administrator
usertype = utility.header("new game", "")
if usertype != "A":
utility.redirect("login.py")
else:
generate_form()
def main():
user_type = utility.header("Update Profile", "player")
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") == 'V':
utility.redirect("home.py")
else:
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
latest_address_cursor = db.cursor()
current_address_cursor = db.cursor()
sql1 = "select PlayerID, AddressID, StartDate, EndDate \
from PlayerAddress \
where PlayerID = %s and EndDate is null" \
% (sess.data["UserID"])
latest_address_cursor.execute(sql1)
latest_address_row = latest_address_cursor.fetchone()
sql2 = "select * from PlayerAddress \
inner join Player On Player.PlayerID = PlayerAddress.PlayerID \
inner join Address on Address.AddressID = PlayerAddress.AddressID \
where PlayerAddress.PlayerID = %s \
and PlayerAddress.AddressID = %s " \
% (latest_address_row[0], latest_address_row[1] )
current_address_cursor.execute(sql2)
current_address_row = current_address_cursor.fetchone()
Gamehandle = to_null(current_address_row[12])
Email = to_null(current_address_row[11])
Phone = to_null(current_address_row[13])
Voip = to_null(current_address_row[14])
Street_num = to_null(current_address_row[16])
Street_num_suffix = to_null(current_address_row[17])
Street_name = to_null(current_address_row[18])
Street_type = to_null(current_address_row[19])
Address_type = to_null(current_address_row[20])
Minor = to_null(current_address_row[22])
Major = to_null(current_address_row[23])
District = to_null(current_address_row[24])
Post = to_null(current_address_row[25])
Country = to_null(current_address_row[26])
# close after use
db.close()
generate_form(Gamehandle, Email, Phone, Voip, Street_num,
Street_num_suffix, Street_name, Street_type,
Address_type, Minor, Major, District, Post, Country)
def main():
# check if it is administrator
usertype = utility.header("new equipment","")
if usertype != "A":
utility.redirect("login.py")
else:
generate_form()
def main():
usertype = utility.header("new game distributor","")
if usertype != "A":
utility.redirect("login.py")
else:
generate_form()
def main():
# get user type
usertype = utility.header("Upload Instance Run","")
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or sess.data.get("PlayerType")!="S":
utility.redirect("login.py")
else:
form = cgi.FieldStorage()
game_name = form.getvalue("game_name")
name = form.getvalue("name")
category = form.getvalue("category")
date = form.getvalue("date")
num_of_players = (int) (form.getvalue("num_of_players"))
num_of_videos = (int)(form.getvalue("num_of_videos"))
num_of_achievements = (int)(form.getvalue("num_of_achievements"))
notes = form.getvalue("notes")
generate_form(game_name, name, category, date,
num_of_players, num_of_videos, num_of_achievements, notes)
def main():
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") == 'V':
# redirect to login page
utility.redirect("login.py")
else:
display_profile()
def main():
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'V':
# redirect to login page
utility.redirect("login.py")
else:
display_profile()
def main():
utility.header("Upload Instance Run", "player")
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or sess.data.get("PlayerType") != "S":
utility.redirect("login.py")
else:
generate_form()
def main():
# print web header
utility.header("Add new Players","")
# check user identity
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or sess.data.get("UserType")!="A":
utility.redirect("login.py")
else:
generate_form()
def main():
# print web header
utility.header("Add new Players", "")
# check user identity
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or sess.data.get("UserType") != "A":
utility.redirect("login.py")
else:
generate_form()
def main():
user_type = utility.header("Update Instance Run", "player")
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn and user_type[1] != "S":
print " You don't have access"
utility.redirect("home.py")
else:
generate_form()
def main():
user_type = utility.header("Update Instance Run","player")
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn and user_type[1] != "S":
print " You don't have access"
utility.redirect("home.py")
else:
generate_form()
def main():
usertype = utility.header("New adding Players","")
if usertype != "A":
utility.redirect("login.py")
else:
# Define main function.
form = cgi.FieldStorage()
try:
num_of_players = (int) (form.getvalue("num_of_new_players"))
except:
utility.redirect("admin_add_Player.py")
sys.exit(0)
generate_form(num_of_players )
# Import the CGI moduleWork
import cgi, MySQLdb,utility,session,sys
sess = session.Session(expires=20*60, cookie_path='/')
# ---------------------------------------------------------------------------------------------------------------------
# send session cookie
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or sess.data.get("UserType")!="A":
utility.redirect("login.py")
sys.exit(0)
form = cgi.FieldStorage()
# connect to db
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
cursor=db.cursor()
cursor.execute("""show columns from GameDistributor""")
rows=cursor.fetchall()
cursor.execute("""insert into GameDistributor values (default,'{0}','{1}','{2}',{3})""".format(form.getvalue(rows[1][0]),form.getvalue(rows[2][0]),form.getvalue(rows[3][0]),form.getvalue(rows[4][0])))
cursor.execute("""set @EID=LAST_INSERT_ID()""")
cursor.execute("""select @EID""")
import sys, MySQLdb, utility, session, cgi
sess = session.Session(expires=20 * 60, cookie_path='/')
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'A':
utility.redirect("login.py")
sys.exit(0)
form = cgi.FieldStorage()
# no id or distributor then back
if not (form.has_key("id") and form.has_key("dis")):
utility.redirect("game_order.py")
sys.exit(0)
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
#create new order
cursor.execute(
"""insert into GameDistributorOrder Values (default,CURDATE(),{0})""".
format(form["dis"].value))
cursor.execute("""set @EID=LAST_INSERT_ID()""")
db.commit()
ids = form.getlist("id")
for id in ids:
def main():
user_type = utility.header("Update Instance Run", "player")
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn and user_type[1] != "S":
utility.redirect("login.py")
else:
form = cgi.FieldStorage()
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
# 0 for no
# 1 for yes
edit_instance_run = form.getvalue("edit_instance_run")
print edit_instance_run
instance_run_id = form.getvalue("instance_run_num ")
print instance_run_id
# 0 for no
# 1 for add into IR
# 2 for delete from IR
edit_player = form.getvalue("edit_player")
edit_video = form.getvalue("edit_video")
edit_achievement = form.getvalue("edit_achievement")
print edit_player
# -----------------------------------------------------------------------------------------------------
# update instance run detail
if edit_instance_run == "1":
# instance run detail for update
new_instance_run_name = form.getvalue("new_instance_run_name")
instance_run_date = form.getvalue("instance_run_date")
instance_run_cate = form.getvalue("instance_run_cate")
update_InstanceRun(db, instance_run_id, new_instance_run_name,
instance_run_date, instance_run_cate) #
# add one player into IR ------------------------------------------------------------------------------
if edit_player == "1":
# new player detail
player_chosed = form.getvalue("player_chosed_for_add")
insert_InstanceRunPlayer(db, player_chosed, instance_run_id) #
# delete player from IR
if edit_player == "2":
# player name for deletion
player_chosed_for_del = form.getvalue("player_chosed_for_del")
remove_InstanceRunPlayer(db, player_chosed_for_del,
instance_run_id) #
# add one Video related to IR -------------------------------------------------------------------------
if edit_video == "1":
# new Video detail
new_video_url = form.getvalue("new_video_url")
new_video_price = form.getvalue("new_video_price")
new_video_type = form.getvalue("new_video_type")
new_video_game = form.getvalue("game")
insert_Video(db, instance_run_id, new_video_url, new_video_price,
new_video_type, game) #
# delelte Video related to IR
if edit_video == "2":
# Video URL for deletion
video_url_for_delete = form.getvalue("video_url_for_delete")
remove_Video(db, video_url_for_delete) #
# add Achievement realted to IR -----------------------------------------------------------------------
if edit_achievement == "1":
# new achievement detail
achievement_date = form.getvalue("achievement_date")
achievement_name = form.getvalue("achievement_name")
achievement_reward = form.getvalue("achievement_reward")
insert_Achievement(db, instance_run_id, achievement_date,
achievement_name, achievement_reward) #
# delete Achievement realted to IR
if edit_achievement == "2":
# achievement name for deletion
achievement_for_delete = form.getvalue("achievement_for_delete")
remove_Achievement(db, achievement_for_delete) #
db.close()
import sys,MySQLdb,utility,session,cgi
sess = session.Session(expires=20*60, cookie_path='/')
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'A':
utility.redirect("login.py")
sys.exit(0)
form = cgi.FieldStorage()
# no id or distributor then back
if not form.has_key("disOrder"):
utility.redirect("admin_add_GameShipment.py")
sys.exit(0)
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
cursor.execute ("""insert into GameShipment Values (default,CURDATE(),{0})""".format(form["disOrder"].value))
cursor.execute("""set @EID=LAST_INSERT_ID()""")
db.commit()
cursor.execute("select @EID")
shipmentID=cursor.fetchone()[0]
utility.header("Log a Game Shipment","game")
# Import the CGI moduleWork
import cgi, MySQLdb, utility, session, sys
sess = session.Session(expires=20 * 60, cookie_path='/')
# ---------------------------------------------------------------------------------------------------------------------
# send session cookie
info = sess.data
loggedIn = info.get("loggedIn")
# check user identity
if not loggedIn or sess.data.get("UserType") != "A":
utility.redirect("login.py")
sys.exit(0)
utility.header("Adding new Players", "")
form = cgi.FieldStorage()
# connect to db
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
# get all attribute values
name = form.getvalue("game_name")
genre = form.getvalue("genre")
review = form.getvalue("review")
star = form.getvalue("star")
classification = form.getvalue("classification")
platform = form.getvalue("platform")
link = form.getvalue("link")
def main():
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'V':
utility.redirect("login.py")
else:
utility.header("Update Viewer", "player")
form = cgi.FieldStorage()
viewer_type = form.getvalue("viewer_type")
# 2 fields of Viewer
dob = form.getvalue("dob")
email = form.getvalue("email")
# 2 CrowdFundingViewer fields
first_name = form.getvalue("first_name")
last_name = form.getvalue("last_name")
a_num = 0
# 7 Compulsory fields of Address
Street_num = form.getvalue("Street_num")
if Street_num is not None:
a_num += 1
if Street_num.isdigit():
Street_num = int(Street_num)
Street_name = form.getvalue("Street_name")
if Street_name is not None:
a_num += 1
Street_type = form.getvalue("Street_type")
if Street_type is not None:
a_num += 1
Major = form.getvalue("Major")
if Major is not None:
a_num += 1
District = form.getvalue("District")
if District is not None:
a_num += 1
Post = form.getvalue("Post")
if Post is not None:
a_num += 1
Country = form.getvalue("Country")
if Country is not None:
a_num += 1
# 4 Voluntary fields of Address
Street_num_suffix = form.getvalue("Street_num_suffix")
Address_type = form.getvalue("Address_type")
Address_type_identifier = form.getvalue("Address_type_identifier")
Minor = form.getvalue("Minor")
# connect to database
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
#81 None pviewer RD None None Parkvile Melbourne VIC 3000 Australia
address_changed = check_detail(db, Street_num, Street_num_suffix,
Street_name, Street_type, Address_type,
Address_type_identifier, Minor, Major,
District, Post, Country)
# address is not changed
if address_changed == 0 or address_changed == 1:
# update Viewer
viewer_cursor = db.cursor()
sql1 = """UPDATE Viewer SET DateOfBirth ="%s", Email = '%s' \
WHERE ViewerID = %s """ \
% (dob, email, sess.data["UserID"])
viewer_detail_cursor = db.cursor()
sql2 = None
# update CrowdFundingViewer
if viewer_type == "C":
sql2 = """UPDATE CrowdFundingViewer SET FirstName='%s', LastName='%s' \
WHERE ViewerID = %s """ \
% (first_name , last_name, sess.data["UserID"])
try:
viewer_cursor.execute(sql1)
if (sql2 != None):
viewer_detail_cursor.execute(sql2)
db.commit()
except:
# Rollback in case there is any error
db.rollback()
print "up rollback"
# address is changed ----------------------------------------------------------------------------------------------------------------------------
if address_changed == 1 and a_num == 7:
# update address
address_cursor = db.cursor()
address_sql = "INSERT INTO Address(AddressID, StreetNumber, StreetNumberSuffix, StreetName, StreetType, AddressType, AddressTypeIdentifier, \
MinorMunicipality, MajorMunicipality, GoverningDistrict, PostalArea, Country) \
VALUES (%s, %s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" \
% ("default",
Street_num, Street_num_suffix,
Street_name, Street_type,
Address_type, Address_type_identifier,
Minor, Major, District, Post, Country)
# Commit if successs
try:
address_cursor.execute(address_sql)
db.commit()
print "Address is updated"
except:
# Rollback in case there is any error
db.rollback()
print "insert address -> rollback"
# ---------------------------------------------------------------------------
# update EndDate of last address
update_last_viewer_date(db)
# get address id just inserted
new_id = new_address_id(db)
# insert viewer address
insert_viewer_address(db, new_id)
print """
def main():
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'V':
utility.redirect("login.py")
else:
utility.header("Update Viewer","player")
form = cgi.FieldStorage()
viewer_type = form.getvalue("viewer_type")
# 2 fields of Viewer
dob = form.getvalue("dob")
email = form.getvalue("email")
# 2 CrowdFundingViewer fields
first_name = form.getvalue("first_name")
last_name = form.getvalue("last_name")
a_num = 0
# 7 Compulsory fields of Address
Street_num = form.getvalue("Street_num")
if Street_num is not None:
a_num += 1
if Street_num.isdigit():
Street_num = int(Street_num)
Street_name = form.getvalue("Street_name")
if Street_name is not None:
a_num += 1
Street_type = form.getvalue("Street_type")
if Street_type is not None:
a_num += 1
Major = form.getvalue("Major")
if Major is not None:
a_num += 1
District = form.getvalue("District")
if District is not None:
a_num += 1
Post = form.getvalue("Post")
if Post is not None:
a_num += 1
Country = form.getvalue("Country")
if Country is not None:
a_num += 1
# 4 Voluntary fields of Address
Street_num_suffix = form.getvalue("Street_num_suffix")
Address_type = form.getvalue("Address_type")
Address_type_identifier = form.getvalue("Address_type_identifier")
Minor = form.getvalue("Minor")
# connect to database
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
#81 None pviewer RD None None Parkvile Melbourne VIC 3000 Australia
address_changed = check_detail(db,
Street_num, Street_num_suffix,
Street_name, Street_type,
Address_type, Address_type_identifier,
Minor, Major, District, Post, Country)
# address is not changed
if address_changed == 0 or address_changed == 1:
# update Viewer
viewer_cursor = db.cursor()
sql1 = """UPDATE Viewer SET DateOfBirth ="%s", Email = '%s' \
WHERE ViewerID = %s """ \
% (dob, email, sess.data["UserID"])
viewer_detail_cursor = db.cursor()
sql2 = None
# update CrowdFundingViewer
if viewer_type == "C":
sql2 = """UPDATE CrowdFundingViewer SET FirstName='%s', LastName='%s' \
WHERE ViewerID = %s """ \
% (first_name , last_name, sess.data["UserID"])
try:
viewer_cursor.execute(sql1)
if (sql2 !=None):
viewer_detail_cursor.execute(sql2)
db.commit()
except:
# Rollback in case there is any error
db.rollback()
print "up rollback"
# address is changed ----------------------------------------------------------------------------------------------------------------------------
if address_changed == 1 and a_num == 7:
# update address
address_cursor = db.cursor()
address_sql = "INSERT INTO Address(AddressID, StreetNumber, StreetNumberSuffix, StreetName, StreetType, AddressType, AddressTypeIdentifier, \
MinorMunicipality, MajorMunicipality, GoverningDistrict, PostalArea, Country) \
VALUES (%s, %s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" \
% ("default",
Street_num, Street_num_suffix,
Street_name, Street_type,
Address_type, Address_type_identifier,
Minor, Major, District, Post, Country)
# Commit if successs
try:
address_cursor.execute(address_sql)
db.commit()
print "Address is updated"
except:
# Rollback in case there is any error
db.rollback()
print "insert address -> rollback"
# ---------------------------------------------------------------------------
# update EndDate of last address
update_last_viewer_date(db)
# get address id just inserted
new_id = new_address_id(db)
# insert viewer address
insert_viewer_address(db, new_id)
print """
import sys, MySQLdb, utility, session, cgi
sess = session.Session(expires=20 * 60, cookie_path='/')
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'A':
utility.redirect("login.py")
sys.exit(0)
form = cgi.FieldStorage()
# no id or distributor then back
if not (form.has_key("VenueName") and form.has_key("EquipmentID")):
utility.redirect("venue_create.py")
sys.exit(0)
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
cursor.execute("""show columns from Venue""")
rows = cursor.fetchall()
adds = []
for row in rows:
if form.has_key(row[0]):
adds.append(form[row[0]].value)
cursor.execute(
# Import the CGI moduleWork
import cgi, MySQLdb, utility, session, sys
sess = session.Session(expires=20 * 60, cookie_path='/')
# ---------------------------------------------------------------------------------------------------------------------
# send session cookie
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or sess.data.get("UserType") != "A":
utility.redirect("login.py")
sys.exit(0)
form = cgi.FieldStorage()
# connect to db
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
cursor.execute("""show columns from GameDistributor""")
rows = cursor.fetchall()
cursor.execute(
"""insert into GameDistributor values (default,'{0}','{1}','{2}',{3})""".
format(form.getvalue(rows[1][0]), form.getvalue(rows[2][0]),
form.getvalue(rows[3][0]), form.getvalue(rows[4][0])))
cursor.execute("""set @EID=LAST_INSERT_ID()""")
def main():
# check user identity
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") == 'V':
utility.redirect("login.py")
else:
utility.header("", "player")
form = cgi.FieldStorage()
p_num = 0
a_num = 0
# 3 Compulsory fields of Player
Gamehandle = form.getvalue("Gamehandle")
if Gamehandle is not None:
p_num += 1
Email = form.getvalue("Email")
if Email is not None:
p_num += 1
Voip = form.getvalue("Voip")
if Voip is not None:
p_num += 1
# 1 Voluntary fields of Player
Phone = to_null(form.getvalue("Phone"))
# 7 Compulsory fields of Address
Street_num = form.getvalue("Street_num")
# if string is an int
if Street_num is not None:
a_num += 1
if Street_num.isdigit():
Street_num = int(Street_num)
Street_name = form.getvalue("Street_name")
if Street_name is not None:
a_num += 1
Street_type = form.getvalue("Street_type")
if Street_type is not None:
a_num += 1
Major = form.getvalue("Major")
if Major is not None:
a_num += 1
District = form.getvalue("District")
if District is not None:
a_num += 1
Post = form.getvalue("Post")
if Post is not None:
a_num += 1
Country = form.getvalue("Country")
if Country is not None:
a_num += 1
# 3 Voluntary fields of Address
Street_num_suffix = to_null(form.getvalue("Street_num_suffix"))
Address_type = to_null(form.getvalue("Address_type"))
Minor = to_null(form.getvalue("Minor"))
# connect to database
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
player_cursor = db.cursor()
adrress_cursor = db.cursor()
player_address_cursor = db.cursor()
# Check what has been changed
#
# 0 - nothing changed
# 1 - player changed
# 2 - address changed
# 3 - both changed
status = check_detail(db, Gamehandle, Email, Voip, Phone, Street_num,
Street_num_suffix, Street_name, Street_type,
Address_type, Minor, Major, District, Post,
Country)
if status == 1 and p_num == 3:
update_player(db, Gamehandle, Email, Phone, Voip)
print """
<h2> "Your personal detail has been updated \n"</h2>
"""
elif status == 2 and a_num == 7:
# insert address entered as a new row into Address table
insert_address(db, Street_num, Street_num_suffix, Street_name,
Street_type, Address_type, Minor, Major, District,
Post, Country)
# update EndDate of last address
update_last_address_date(db)
# get latest inserted AddressId
current_address_id = new_address_id(db)
# insert player_address
insert_player_address(db, current_address_id)
print """
<h2> "Your address detail has been updated! \n"</h2>
"""
elif status == 3 and p_num == 3 and a_num == 7:
update_player(db, Gamehandle, Email, Phone, Voip)
# insert address entered as a new row into Address table
insert_address(db, Street_num, Street_num_suffix, Street_name,
Street_type, Address_type, Minor, Major, District,
Post, Country)
# update EndDate of last address
update_last_address_date(db)
# get latest inserted AddressId
current_address_id = new_address_id(db)
# insert player_address
insert_player_address(db, current_address_id)
print """
<h2> "Your personal detail has been updated! \n"</h2>
<h2> "Your address  detail has been updated! \n"</h2>
"""
else:
if p_num < 3 or a_num < 7:
print """
<h2> "Compulsory fields cannot be blank \n"</h2>
"""
else:
print """
<h2> "Nothing has changed! \n"</h2>
"""
db.close()
import sys, MySQLdb, utility, session, cgi
sess = session.Session(expires=20 * 60, cookie_path='/')
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'A':
utility.redirect("login.py")
sys.exit(0)
form = cgi.FieldStorage()
# no id or distributor then back
if not form.has_key("id"):
utility.redirect("admin_add_GameShipment2.py")
sys.exit(0)
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
ids = form.getlist("id")
for id in ids:
quantity = form[id + "Q"].value
cursor.execute(
"""insert into GameShipmentDetail values ({0},{1},{2})""".format(
id, form["shipID"].value, quantity))
db.commit()
utility.header("Shipment Logging Result", "game")
import cgi, MySQLdb, utility,sys
form = cgi.FieldStorage()
Id = form.getvalue("id")
if Id == None:
utility.redirect("player_display.py")
sys.exit(0)
else:
# Connect to DB
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
cursor.execute("SELECT * FROM Player WHERE PlayerID=%s"%Id)
# Fetch one row at a time
row = cursor.fetchone()
Id = row[0]
Supervisor_id = row[1]
First_name = row[2]
Last_name = row[3]
Gamehandle = row[8]
Role = row[4]
Type = row[5]
Description = row[6]
cursor.execute("SELECT * FROM Player WHERE PlayerID=%s"%Supervisor_id)
# Fetch one row at a time
row = cursor.fetchone()
Supervisor = row[2]+" "+row[3]
import sys,MySQLdb,utility,session,cgi
sess = session.Session(expires=20*60, cookie_path='/')
# check user identity, only supervisor has access to this functionality
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'P':
utility.redirect("login.py")
sys.exit(0)
elif info.get("PlayerType")!="S":
utility.redirect("login.py")
sys.exit(0)
# try get venueID
form = cgi.FieldStorage()
if not form.has_key("VenueID"):
utility.redirect("venue_update2.py")
sys.exit(0)
venueID=form["VenueID"].value
# connect to database
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
# get all attribute names in Venue
cursor.execute("""show columns from Venue""")
rows=cursor.fetchall()
import sys, MySQLdb, utility, session, cgi
sess = session.Session(expires=20 * 60, cookie_path='/')
# check user identity, only supervisor has access to this functionality
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'P':
utility.redirect("login.py")
sys.exit(0)
elif info.get("PlayerType") != "S":
utility.redirect("login.py")
sys.exit(0)
# try get venueID
form = cgi.FieldStorage()
if not form.has_key("VenueID"):
utility.redirect("venue_update2.py")
sys.exit(0)
venueID = form["VenueID"].value
# connect to database
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
# get all attribute names in Venue
cursor.execute("""show columns from Venue""")
rows = cursor.fetchall()
def main():
user_type = utility.header("Update Instance Run","player")
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn and user_type[1] != "S":
utility.redirect("login.py")
else:
form = cgi.FieldStorage()
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
# 0 for no
# 1 for yes
edit_instance_run = form.getvalue("edit_instance_run")
print edit_instance_run
instance_run_id = form.getvalue("instance_run_num ")
print instance_run_id
# 0 for no
# 1 for add into IR
# 2 for delete from IR
edit_player = form.getvalue("edit_player")
edit_video = form.getvalue("edit_video")
edit_achievement = form.getvalue("edit_achievement")
print edit_player
# -----------------------------------------------------------------------------------------------------
# update instance run detail
if edit_instance_run == "1":
# instance run detail for update
new_instance_run_name = form.getvalue("new_instance_run_name")
instance_run_date = form.getvalue("instance_run_date")
instance_run_cate = form.getvalue("instance_run_cate")
update_InstanceRun(db, instance_run_id, new_instance_run_name , instance_run_date, instance_run_cate)#
# add one player into IR ------------------------------------------------------------------------------
if edit_player == "1" :
# new player detail
player_chosed = form.getvalue("player_chosed_for_add")
insert_InstanceRunPlayer(db, player_chosed, instance_run_id)#
# delete player from IR
if edit_player == "2":
# player name for deletion
player_chosed_for_del = form.getvalue("player_chosed_for_del")
remove_InstanceRunPlayer(db, player_chosed_for_del, instance_run_id )#
# add one Video related to IR -------------------------------------------------------------------------
if edit_video == "1":
# new Video detail
new_video_url= form.getvalue("new_video_url")
new_video_price= form.getvalue("new_video_price")
new_video_type = form.getvalue("new_video_type")
new_video_game = form.getvalue("game")
insert_Video(db, instance_run_id, new_video_url, new_video_price, new_video_type, game)#
# delelte Video related to IR
if edit_video == "2":
# Video URL for deletion
video_url_for_delete = form.getvalue("video_url_for_delete")
remove_Video(db, video_url_for_delete) #
# add Achievement realted to IR -----------------------------------------------------------------------
if edit_achievement == "1":
# new achievement detail
achievement_date= form.getvalue("achievement_date")
achievement_name= form.getvalue("achievement_name")
achievement_reward= form.getvalue("achievement_reward")
insert_Achievement(db, instance_run_id, achievement_date, achievement_name, achievement_reward)#
# delete Achievement realted to IR
if edit_achievement == "2":
# achievement name for deletion
achievement_for_delete = form.getvalue("achievement_for_delete")
remove_Achievement(db, achievement_for_delete )#
db.close()
import sys,MySQLdb,utility,session,cgi
sess = session.Session(expires=20*60, cookie_path='/')
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'A':
utility.redirect("login.py")
sys.exit(0)
form = cgi.FieldStorage()
# no id or distributor then back
if not (form.has_key("VenueName") and form.has_key("EquipmentID")):
utility.redirect("venue_create.py")
sys.exit(0)
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
cursor.execute("""show columns from Venue""")
rows=cursor.fetchall()
adds=[]
for row in rows:
if form.has_key(row[0]):
adds.append(form[row[0]].value)
def main():
viewer_type = utility.header("Update Profile","")
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'V':
utility.redirect("home.py")
else:
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
vc_cursor = db.cursor()
vp_cursor = db.cursor()
first_name = ""
last_name = ""
donation = ""
renew_date = ""
# get detail of CrowdFundingViewer
if ( viewer_type == "VC" ) :
sql = "select * from CrowdFundingViewer \
where ViewerID = %s" \
% ( sess.data["UserID"])
vc_cursor.execute(sql)
detail_row = vc_cursor.fetchone()
first_name = detail_row[1]
last_name = detail_row[2]
donation = detail_row[3]
# get detail of PremiumViewer
if ( viewer_type == "VP" ) :
sql = "select * from PremiumViewer \
where ViewerID = %s" \
% ( sess.data["UserID"])
vp_cursor.execute(sql)
detail_row = vp_cursor.fetchone()
renew_date = detail_row[1]
# get latest address id ---------------------------------
sql1 = "select ViewerID, AddressID, StartDate, EndDate \
from ViewerAddress \
where ViewerID = %s and EndDate is null" \
% (sess.data["UserID"])
latest_address_cursor = db.cursor()
latest_address_cursor.execute(sql1)
latest_address_row = latest_address_cursor.fetchone()
# --------------------------------------------------------
# get current address ----------------------------------------------------------
sql2 = "select * from ViewerAddress \
inner join Viewer On Viewer.ViewerID = ViewerAddress.ViewerID \
inner join Address on Address.AddressID = ViewerAddress.AddressID \
where ViewerAddress.ViewerID = %s \
and ViewerAddress.AddressID = %s " \
% (latest_address_row[0], latest_address_row[1] )
current_address_cursor= db.cursor()
current_address_cursor.execute(sql2)
current_address_row = current_address_cursor.fetchone()
# ------------------------------------------------------------------------------
dob = to_null(current_address_row[6])
Email = to_null(current_address_row[7])
Street_num = to_null(current_address_row[9])
Street_num_suffix = to_null(current_address_row[10])
Street_name = current_address_row[11]
Street_type = current_address_row[12]
Address_type = current_address_row[13]
Address_type_identifier = to_null(current_address_row[14])
Minor = to_null(current_address_row[15])
Major = current_address_row[16]
District = current_address_row[17]
Post = current_address_row[18]
Country = current_address_row[19]
# close after use
db.close()
generate_form(viewer_type,
dob, Email,
first_name, last_name, donation,
Street_num, Street_num_suffix,
Street_name, Street_type,
Address_type,Address_type_identifier,
Minor, Major, District, Post, Country)
import sys,MySQLdb,utility,session,cgi,datetime
sess = session.Session(expires=20*60, cookie_path='/')
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn:
utility.redirect("login.py")
sys.exit(0)
elif info.get("UserType") != 'V':
sess.data["LoginError"]=1
utility.redirect("video_display.py")
sys.exit(0)
form = cgi.FieldStorage()
# no id then back
if not form.has_key("id"):
utility.redirect("video_order.py")
sys.exit(0)
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
if sess.data["ViewerType"]=="C":
perk=1
#check premium subscription
else:
perk=0
import sys,MySQLdb,utility,session,cgi
sess = session.Session(expires=20*60, cookie_path='/')
# check user identity
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'A':
utility.redirect("login.py")
sys.exit(0)
utility.header("Log a Game Shipment","game")
print"""
<h1>Log a Game Shipment</h1>
<h3>Please select a distributor order of the shippment.</h3>
<form method="post" action="admin_add_GameShipment2.py">"""
print """ <div class="col-lg-5">
<select name="disOrder" class="form-control" id="select">"""
# connect to database
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
cursor=db.cursor()
cursor.execute("""select * from GameDistributorOrder""")
rows=cursor.fetchall()
for row in rows:
# The libraries we'll need
import sys, cgi, redirect, session,utility
# Get the session and check if logged in
sess = session.Session(expires=20*60, cookie_path='/')
loggedIn = sess.data.get('loggedIn')
# ---------------------------------------------------------------------------------------------------------------------
# debug - what's in the session
#print(sess.data)
#sys.exit()
if loggedIn:
utility.redirect("home.py")
else:
utility.header("Login","home")
print"""
<div class="container marketing">
<div class="row featurette" >
<div class="well">
<form class="bs-example form-horizontal" method="post" action="do_login.py">
<fieldset>
<div class="form-group">
<div class="col-lg-5" col-lg-offset-5">
<p> <font size="4" color="red" > <b><u>Login</u></b> </font> </p>
<p>{0}</p>
import sys,MySQLdb,utility,session,cgi
sess = session.Session(expires=20*60, cookie_path='/')
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'A':
utility.redirect("login.py")
sys.exit(0)
form = cgi.FieldStorage()
if not form.has_key("entity"):
utility.redirect("admin_home.py")
sys.exit(0)
cur_name=form["entity"].value
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
cursor.execute ("""show columns from {0}""".format(cur_name))
rows=cursor.fetchall()
attris=[]
for row in rows:
attris.append(row[0])
cursor.execute("""select {0}ID from {0}""".format(cur_name))
rows=cursor.fetchall()
upd_list=[]
has=0
# The libraries we'll need
import sys, cgi, session,utility, MySQLdb
# ---------------------------------------------------------------------------------------------------------------------
sess = session.Session(expires=20*60, cookie_path='/')
loggedIn = sess.data.get('loggedIn')
# ---------------------------------------------------------------------------------------------------------------------
# ---------------------------------------------------------------------------------------------------------------------
# login logic
if loggedIn:
utility.redirect("home.py")
sys.exit(0)
else:
form = cgi.FieldStorage()
if not (form.has_key('username') and form.has_key('password')):
sess.data['loggedIn'] = 0
else:
# Check user's username and password
# Replace these values with your own login details
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
#get check if we get a row from the database for this user and password
cursor = db.cursor()
cursor.execute ("""
SELECT UserName,UserAccountID,UserType
FROM UserAccount
WHERE UserName = %s
AND UserPassword = %s
""", (form["username"].value, form["password"].value))
if cursor.rowcount == 1:
sess.data['loggedIn'] = 1
import cgi, MySQLdb, utility, sys, session
sess = session.Session(expires=20 * 60, cookie_path='/')
form = cgi.FieldStorage()
Id = form.getvalue("id")
if Id == None:
utility.redirect("video_display.py")
sys.exit(0)
else:
# Connect to DB
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
cursor.execute("SELECT * FROM Video WHERE VideoID=%s" % Id)
row = cursor.fetchone()
Url = row[1]
Price = row[2]
Type = row[3]
Instance_run_id = row[4]
Game_id = row[5]
cursor.execute("SELECT * FROM InstanceRun WHERE InstanceRunID=%s" %
Instance_run_id)
row = cursor.fetchone()
Instance_run_name = row[2]
cursor.execute("SELECT * FROM Game WHERE GameID=%s" % Game_id)
def main():
user_type = utility.header("Update Profile","player")
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") == 'V':
utility.redirect("home.py")
else:
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
latest_address_cursor = db.cursor()
current_address_cursor= db.cursor()
sql1 = "select PlayerID, AddressID, StartDate, EndDate \
from PlayerAddress \
where PlayerID = %s and EndDate is null" \
% (sess.data["UserID"])
latest_address_cursor.execute(sql1)
latest_address_row = latest_address_cursor.fetchone()
sql2 = "select * from PlayerAddress \
inner join Player On Player.PlayerID = PlayerAddress.PlayerID \
inner join Address on Address.AddressID = PlayerAddress.AddressID \
where PlayerAddress.PlayerID = %s \
and PlayerAddress.AddressID = %s " \
% (latest_address_row[0], latest_address_row[1] )
current_address_cursor.execute(sql2)
current_address_row = current_address_cursor.fetchone()
Gamehandle = to_null(current_address_row[12])
Email = to_null(current_address_row[11])
Phone = to_null(current_address_row[13])
Voip = to_null(current_address_row[14])
Street_num = to_null(current_address_row[16])
Street_num_suffix = to_null(current_address_row[17])
Street_name = to_null(current_address_row[18])
Street_type = to_null(current_address_row[19])
Address_type = to_null(current_address_row[20])
Minor = to_null(current_address_row[22])
Major = to_null(current_address_row[23])
District = to_null(current_address_row[24])
Post = to_null(current_address_row[25])
Country = to_null(current_address_row[26])
# close after use
db.close()
generate_form(Gamehandle, Email, Phone, Voip,
Street_num, Street_num_suffix,
Street_name, Street_type, Address_type,
Minor, Major, District, Post, Country)
import cgi, MySQLdb, utility
utility.header("Game detail", "game")
form = cgi.FieldStorage()
Id = form.getvalue("id")
if Id == None:
utility.redirect("game_display.py")
else:
# Connect to DB
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
cursor.execute("SELECT * FROM Game WHERE GameID=%s" % Id)
# Fetch one row at a time
row = cursor.fetchone()
Name = row[1]
Genre = row[2]
Review = row[3]
Star = row[4]
Classification = row[5]
Platform = row[6]
Promotion = row[7]
Cost = row[8]
print """
<ul>
import sys, MySQLdb, utility, session, cgi
sess = session.Session(expires=20 * 60, cookie_path='/')
# check user identity
info = sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") != 'A':
utility.redirect("login.py")
sys.exit(0)
utility.header("Log a Game Shipment", "game")
print """
<h1>Log a Game Shipment</h1>
<h3>Please select a distributor order of the shippment.</h3>
<form method="post" action="admin_add_GameShipment2.py">"""
print """ <div class="col-lg-5">
<select name="disOrder" class="form-control" id="select">"""
# connect to database
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15",
"info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
cursor.execute("""select * from GameDistributorOrder""")
rows = cursor.fetchall()
for row in rows:
cursor.execute(
import cgi, MySQLdb, utility,sys,session
sess = session.Session(expires=20*60, cookie_path='/')
form = cgi.FieldStorage()
Id = form.getvalue("id")
if Id == None:
utility.redirect("video_display.py")
sys.exit(0)
else:
# Connect to DB
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
cursor = db.cursor()
cursor.execute("SELECT * FROM Video WHERE VideoID=%s"%Id)
row = cursor.fetchone()
Url = row[1]
Price = row[2]
Type = row[3]
Instance_run_id = row[4]
Game_id = row[5]
cursor.execute("SELECT * FROM InstanceRun WHERE InstanceRunID=%s"%Instance_run_id)
row = cursor.fetchone()
Instance_run_name = row[2]
cursor.execute("SELECT * FROM Game WHERE GameID=%s"%Game_id)
row = cursor.fetchone()
Game_name = row[1]
def main():
# check user identity
info=sess.data
loggedIn = info.get("loggedIn")
if not loggedIn or info.get("UserType") == 'V':
utility.redirect("login.py")
else:
utility.header("","player")
form = cgi.FieldStorage()
p_num = 0
a_num = 0
# 3 Compulsory fields of Player
Gamehandle = form.getvalue("Gamehandle")
if Gamehandle is not None:
p_num += 1
Email = form.getvalue("Email")
if Email is not None:
p_num += 1
Voip = form.getvalue("Voip")
if Voip is not None:
p_num += 1
# 1 Voluntary fields of Player
Phone = to_null(form.getvalue("Phone"))
# 7 Compulsory fields of Address
Street_num = form.getvalue("Street_num")
# if string is an int
if Street_num is not None:
a_num += 1
if Street_num.isdigit():
Street_num = int(Street_num)
Street_name = form.getvalue("Street_name")
if Street_name is not None:
a_num += 1
Street_type = form.getvalue("Street_type")
if Street_type is not None:
a_num += 1
Major = form.getvalue("Major")
if Major is not None:
a_num += 1
District = form.getvalue("District")
if District is not None:
a_num += 1
Post = form.getvalue("Post")
if Post is not None:
a_num += 1
Country = form.getvalue("Country")
if Country is not None:
a_num += 1
# 3 Voluntary fields of Address
Street_num_suffix = to_null(form.getvalue("Street_num_suffix"))
Address_type = to_null(form.getvalue("Address_type"))
Minor = to_null(form.getvalue("Minor"))
# connect to database
db = MySQLdb.connect("info20003db.eng.unimelb.edu.au", "info20003g15", "info20003g15_2014", "info20003g15", 3306)
player_cursor = db.cursor()
adrress_cursor = db.cursor()
player_address_cursor = db.cursor()
# Check what has been changed
#
# 0 - nothing changed
# 1 - player changed
# 2 - address changed
# 3 - both changed
status = check_detail(db, Gamehandle, Email, Voip, Phone, Street_num, Street_num_suffix, Street_name, Street_type, Address_type, Minor, Major, District, Post, Country)
if status == 1 and p_num == 3:
update_player(db,Gamehandle, Email, Phone, Voip)
print"""
<h2> "Your personal detail has been updated \n"</h2>
"""
elif status == 2 and a_num == 7:
# insert address entered as a new row into Address table
insert_address(db, Street_num, Street_num_suffix, Street_name, Street_type, Address_type, Minor, Major, District, Post, Country)
# update EndDate of last address
update_last_address_date(db)
# get latest inserted AddressId
current_address_id = new_address_id(db)
# insert player_address
insert_player_address(db, current_address_id )
print"""
<h2> "Your address detail has been updated! \n"</h2>
"""
elif status == 3 and p_num == 3 and a_num == 7:
update_player(db,Gamehandle, Email, Phone, Voip)
# insert address entered as a new row into Address table
insert_address(db, Street_num, Street_num_suffix, Street_name, Street_type, Address_type, Minor, Major, District, Post, Country)
# update EndDate of last address
update_last_address_date(db)
# get latest inserted AddressId
current_address_id = new_address_id(db)
# insert player_address
insert_player_address(db, current_address_id )
print"""
<h2> "Your personal detail has been updated! \n"</h2>
<h2> "Your address  detail has been updated! \n"</h2>
"""
else:
if p_num < 3 or a_num <7:
print"""
<h2> "Compulsory fields cannot be blank \n"</h2>
"""
else:
print"""
<h2> "Nothing has changed! \n"</h2>
"""
db.close()
