def addStory():
if (request.method=="GET"):
return render_template("addStory.html")
else:
Story = request.form["Story"]
Title = request.form["Title"]
Append.addStory(Story,Title,session['n'],Append.GreatestStoryID() + 1,datetime.date.today().strftime("%B,%d,%Y"))
return redirect(url_for("storypage"))
def register():
if (request.method == "GET"):
return render_template("register.html")
else:
username = request.form["username"]
password = request.form["password"]
Append.register(username, password)
return redirect(url_for("login"))
def register():
if (request.method == "GET"):
return render_template("register.html")
else:
username = request.form["username"]
password = request.form["password"]
Append.register(username,password)
return redirect(url_for("login"))
def addStory():
if (request.method == "GET"):
return render_template("addStory.html")
else:
Story = request.form["Story"]
Title = request.form["Title"]
Append.addStory(Story, Title, session['n'],
Append.GreatestStoryID() + 1,
datetime.date.today().strftime("%B,%d,%Y"))
return redirect(url_for("storypage"))
def register():
if (request.method == "GET"):
return render_template("register.html")
else:
username = request.form["username"]
password = request.form["password"]
if Append.validuname(username):
error = "Username already exists. Please try again."
return render_template("register.html", err = error)
else:
Append.register(username,password)
return redirect(url_for("login"))
def storypage():
if (request.method == "POST"):
Append.comment(request.form["button"], request.form["comment"],
datetime.date.today().strftime("%B %d, %Y"))
q = """
SELECT *
FROM Stories;
"""
conn = sqlite3.connect("StoryBase.db")
c = conn.cursor()
xonn = sqlite3.connect("StoryBase.db")
x = xonn.cursor()
MainHTML = ""
result = c.execute(q)
for r in result:
StoryHTML = """
<table>
<tr>
<td style="font-size:200%"> """ + r[1] + """
</td> <td style="font-size:150%">
by """ + r[2] + """
</td> <td style="font-size:150%"> on """ + r[4] + """
</td>
</tr><tr style="font-size:120%">
<td colspan="3">
""" + r[0] + """
</td>
</tr>
</table>
<hr>
<form method="POST">
Add a Comment: <input type="text" name="comment">
<input type="submit" name="button" value=%s>
</form>
Comments: <br><hr>""" % (r[3])
d = """
SELECT *
FROM comments where storyID = %s;
""" % (r[3])
comments = x.execute(d)
for y in comments:
StoryHTML += '<p style="font-size:70%">'
commentHTML = """
%s <span style="color: #ff0000"> on %s </span>
<hr>
""" % (y[1], y[2])
commentHTML += "</p>"
StoryHTML = StoryHTML + commentHTML
MainHTML = MainHTML + StoryHTML
return render_template("storypage.html", result=MainHTML)
def storypage():
if (request.method == "POST"):
Append.comment(request.form["button"],request.form["comment"],datetime.date.today().strftime("%B %d, %Y"))
q="""
SELECT *
FROM Stories;
"""
conn = sqlite3.connect("StoryBase.db")
c = conn.cursor()
xonn = sqlite3.connect("StoryBase.db")
x = xonn.cursor()
MainHTML = ""
result = c.execute(q)
for r in result:
StoryHTML = """
<table>
<tr>
<td style="font-size:200%"> """ + r[1] + """
</td> <td style="font-size:150%">
by """+r[2]+"""
</td> <td style="font-size:150%"> on """ + r[4] +"""
</td>
</tr><tr style="font-size:120%">
<td colspan="3">
"""+ r[0]+ """
</td>
</tr>
</table>
<hr>
<form method="POST">
Add a Comment: <input type="text" name="comment">
<input type="submit" name="button" value=%s>
</form>
Comments: <br><hr>""" % (r[3])
d="""
SELECT *
FROM comments where storyID = %s;
""" % (r[3])
comments = x.execute(d)
for y in comments:
StoryHTML += '<p style="font-size:70%">'
commentHTML = """
%s <span style="color: #ff0000"> on %s </span>
<hr>
""" % (y[1],y[2])
commentHTML += "</p>"
StoryHTML = StoryHTML + commentHTML
MainHTML = MainHTML + StoryHTML
return render_template("storypage.html", result=MainHTML)
def addStory():
connection = MongoClient()
db = connection['StoryBase']
if 'n' not in session:
return redirect("/login")
if (request.method=="GET"):
return render_template("addStory.html")
else:
Story = request.form["Story"]
Title = request.form["Title"]
ID = 0
curs = db.stories.find()
ID = curs.count()
Append.addStory(ID,Story,Title,session['n'],datetime.date.today().strftime("%B,%d,%Y"))
return redirect(url_for("storypage"))
def MainMenu():
print("Enter 1 to Create a Game file manually")
print("Enter 2 to Edit a Game file")
print("Enter 3 to View a Game file")
print("Enter 4 to Delete a Game file")
print("Enter 5 to play a game and create it's file")
print("Enter 0 to Exit")
choice = int(input("Please enter now: "))
if (choice == 1):
Create.CreateFile()
elif (choice == 2):
Append.AppendFile()
elif (choice == 3):
View.ViewFile()
elif (choice == 4):
Delete.DeleteFile()
elif (choice == 5):
Game.GAME()
elif (choice == 0):
print("Have a great day!!")
sys.exit(0)
else:
print('\f')
print(
"It seems your input was not according to our references. Please view the choices again"
)
return
def storypage():
connection = MongoClient()
db = connection['StoryBase']
if (request.method == "POST"):
Append.comment(request.form["button"],request.form["comment"],datetime.date.today().strftime("%B %d, %Y"))
#connectionComments = MongoClient()
#dbComments = connectionComments['Comments']
MainHTML = ""
result = Append.getStory()
for r in result:
print r["uname"]
StoryHTML = """
<table>
<tr>
<td style="font-size:200%"> """ + r["title"] + """
</td> <td style="font-size:150%">
by """+r["uname"]+"""
</td> <td style="font-size:150%"> on """ + r["date"] +"""
</td>
</tr><tr style="font-size:120%">
<td colspan="3">
"""+ r["content"] + """
</td>
</tr>
</table>
<hr>
<form method="POST">
Add a Comment: <input type="text" name="comment">
<button type="submit" name="button" value=%s>Submit</button>
</form>
Comments: <br><hr>""" % (r["storyID"])
print r["storyID"]
coms = Append.getCommentsSpec(str(r["storyID"]))
MainHTML = MainHTML + StoryHTML
for y in coms:
print y["CContent"]
commentHTML = '<p style="font-size:70%">'
commentHTML += """
%s <span style="color: #ff0000"> on %s </span>
<hr>
""" % (y["CContent"],y["Date"])
commentHTML += "</p>"
MainHTML = MainHTML + commentHTML
return render_template("storypage.html", result=MainHTML)
def login():
if (request.method == "GET"):
return render_template("login.html")
else:
username = request.form["username"]
password = request.form["password"]
session['username'] = request.form["username"]
if (Append.authenticate(username, password)):
session['n']=username
return redirect(url_for("storypage"))
else:
error = "Your Username or Password is incorrect. Please try again."
return render_template("login.html", problem = error )
