def new_user():
r = request.form
error = False
if 'user' in session:
return redirect(url_for('index'))
users = con_login()
if request.method == 'POST':
for u in users:
if u[0] == r['username']:
error = True
return rend('new_user.html', error=error)
if r['confirm'] != r['password']:
error = True
return rend('new_user.html', error=error)
with login_connection.cursor() as cursor:
cursor.execute(f"""INSERT INTO User (user, pass, nafn) VALUES
('{request.form['username']}', '{request.form['password']}', '{request.form['name']}');"""
)
return redirect(url_for('login'))
return rend('new_user.html', error=error)
def login():
r=request.form
cursor.execute("""select * from users where user="******";""" % r["username"])
rows = cursor.fetchall()
if rows!=():
user = rows[0]
if verify_password(user[1],r["password"]):
session["user"] = {"username":user[0],"nafn":user[2],"pass":user[1]}
print(session["user"])
else:
return rend("login.html", code=1)
else:
print(rows)
return rend("login.html", code=1)
return rend("login.html", code=0)
def index():
cursor.execute("select * from posts;")
posts = cursor.fetchall()
if "user" not in session.keys():
session["user"] = {"name": None, "pass": None}
user = session["user"]
return rend("index.html", user=user, posts=posts)
def company(name):
return rend('company.html',
name=name,
data=data,
timestamp=timestamp,
low_bensin=low_bensin,
low_disel=low_disel)
def login():
r = request.form
cursor.execute("""select * from users where username=%s;""" %
(connection.escape(r['username'])))
rows = cursor.fetchall()
if rows != ():
user = rows[0]
if verify_password(user[1], r["password"]):
session["user"] = {"name": user[0], "pass": user[1]}
print(session["user"])
else:
return rend("login.html", code=1)
else:
print(rows)
return rend("login.html", code=1)
return redirect(url_for("index"))
def kennitala(KT):
for x in range(lenB):
if KT == people[x]['kt']:
p = people[x]
n, k, s = p['name'], p['kt'], 0
for x in KT: s += int(x)
return rend('kennitala.html', name=n, kt=k, people=people, len=lenB, sum=s)
def index():
return rend('index.html',
stations=stations,
timestamp=timestamp,
data=data,
low_bensin=low_bensin,
low_disel=low_disel)
def profile():
if 'user' in session:
user = session['user']
else:
return redirect(url_for('login'))
return rend('profile.html', user=user)
def update_comment(id):
r = request.form
if 'user' not in session:
return redirect(url_for('index'))
user = session['user']
comments = con_forum('comments')
if request.method == 'POST':
for c in comments:
if user['username'] == c[1]:
if id == c[0]:
with forum_connection.cursor() as cursor:
cursor.execute(f"""UPDATE comments SET
content='{r['content']}'
WHERE original_post_id='{id}'
and author_key='{c[1]}'
and post_date='{c[3]}'
and content='{c[2]}';""")
return redirect(url_for('index'))
return rend('update_post.html')
def write_comment(id):
r = request.form
error = False
if 'user' not in session:
return redirect(url_for('index'))
posts = con_forum('posts')
if id > len(posts) - 1:
return redirect(url_for('index'))
user = session['user']
if request.method == 'POST':
error = True
with forum_connection.cursor() as cursor:
cursor.execute(
f"""INSERT INTO Comments (original_post_id, author_key, content, post_date) VALUES
(
{id},
'{user['username']}',
'{r['content']}',
'{time()}'
);""")
return redirect(url_for('index'))
return rend('comment.html', user=user, error=error)
def karfa_p():
verd = 0
output = []
for x in session["karfa"]:
output.append(hlutir[x])
verd += hlutir[x][1]
return rend("karfa.html", karfa=output, verd=verd)
def frett(frett):
if frett in frettir.keys():
return rend("frett.html",
title=frettir[frett][0],
content=frettir[frett][1],
pic=frettir[frett][2])
else:
return page_not_found(None)
def update_screen(post):
print(session)
if session["user"]["name"] != None:
cursor.execute("select * from posts where id=%s;" % (post))
post = cursor.fetchall()[0]
return rend("update.html", post=post)
else:
return redirect(url_for("index"))
def index():
if not "karfa" in session:
print("reset")
session["karfa"] = []
print(hlutir)
return rend("bud.html",
title="index",
hlutir=hlutir.items(),
karfa=len(session["karfa"]))
def index():
if "user" not in session.keys():
user = {"uname":None,"pass":None,"nafn":None}
else:
user = session["user"]
cursor.execute("SELECT * FROM posts")
rows = cursor.fetchall()
print(rows)
return rend("index.html", user = user, rows = rows)
def index():
posts = con_forum('posts')
comments = con_forum('comments')
if 'user' in session:
user = session['user']
else:
user = {"username": "******", "password": "******", "name": "none"}
return rend('index.html', user=user, posts=posts, comments=comments)
def account():
if "user" in session.keys():
sql= "SELECT postur FROM posts WHERE user ="******"user"]
prent = user['nafn']
cursor.execute(sql+"'"+prent+"'")
gogn = cursor.fetchall()
if session["user"]["username"] != None:
return rend("account.html", user = session["user"], gogn = gogn)
return index()
def index():
with connection.cursor() as cursor:
cursor.execute("SELECT * FROM user")
users = cursor.fetchall()
if 'user' in session:
user = session['user']
else:
user = {"username":"******", "password":"******", "name":"none"}
return rend('index.html', user=user)
def gas_station(key):
for x in data:
if x['key'] == key:
station = x
break
return rend('station.html',
key=key,
data=data,
station=station,
timestamp=timestamp,
low_bensin=low_bensin,
low_disel=low_disel)
def article(ID):
for x in range(len(articles)):
if int(ID) == articles[x]['id']:
author = articles[x]['author']
title = articles[x]['title']
content = articles[x]['content']
return rend('layout.html',
author=author,
title=title,
content=content,
articles=articles,
len=lenA)
def addusr():
r=request.form
print(r)
cursor.execute("SELECT * FROM users")
rows = cursor.fetchall()
if request.form['name'] in map(lambda x: x[0], rows):
pass
cursor.execute("""INSERT INTO users (user, pass, nafn) VALUES
(%s, %s, %s);""" %
(connection.escape(r['username']),
connection.escape(r['password']),
connection.escape(r['name'])))
return rend("signup.html",code=0)
def addusr():
r = request.form
cursor.execute("SELECT * FROM users")
rows = cursor.fetchall()
if request.form['username'] in map(lambda x: x[0], rows):
return rend("signup.html", code=1)
cursor.execute("INSERT INTO users (username, pass) VALUES (%s, %s);" %
(connection.escape(r['username']),
connection.escape(hash_password(r['password']))))
session["user"] = {
"name": r["username"],
"pass": hash_password(r['password'])
}
return redirect(url_for("index"))
def addpost():
r=request.form
user2 = session["user"]
num = 1
name = (user2["nafn"])
cursor.execute("SELECT * FROM posts")
rows = cursor.fetchall()
if request.form['postur'] in map(lambda x: x[0], rows):
pass
cursor.execute("""INSERT INTO posts (user, postur, num) VALUES
(%s, %s, %s);""" %
(connection.escape(name),
connection.escape(r['postur']),
connection.escape(num)))
return rend("index.html", user = user2, rows =rows)
def cart():
cart, cartQuantity, price_sum = [], [], .0
if 'cart' not in session:
return rend('cart.html',
cart="Cart empty",
books=books,
cartQuantity=[],
price_sum=price_sum)
for item in session['cart']:
cart.append(int(item))
for item in books:
if int(item['id']) in cart:
cartQuantity.append([item, cart.count(item['id'])])
for item in cartQuantity:
item.append(float(item[0]['value']) * item[1])
price_sum += float(item[0]['value']) * item[1]
for item in cartQuantity:
item[2] = round(item[2], 3)
price_sum = round(price_sum, 3)
return rend('cart.html',
cart=cart,
books=books,
cartQuantity=cartQuantity,
price_sum=price_sum)
def eida():
if "user" in session.keys():
sql2= "SELECT postur FROM posts WHERE user ="******"user"]
prent = user['nafn']
cursor.execute(sql2+"'"+prent+"'")
gogn = cursor.fetchall()
user = session["user"]
prent = user['nafn']
print(prent)
print(user)
sql = "DELETE FROM posts WHERE user ="******"'"+prent+"'")
cursor.execute(sql+"'"+prent+"'")
return rend("account.html", user = session["user"], gogn = gogn)
else: return index()
def update_post(id):
r = request.form
if 'user' not in session:
return redirect(url_for('index'))
user = session['user']
posts = con_forum('posts')
if request.method == 'POST':
if user['username'] == posts[id][1]:
with forum_connection.cursor() as cursor:
cursor.execute(f"""UPDATE posts SET
content='{r['content']}'
WHERE post_id='{id}'""")
return redirect(url_for('index'))
return rend('update_post.html')
def login():
r = request.form
error = False
if 'user' in session:
return redirect(url_for('index'))
with connection.cursor() as cursor:
cursor.execute("SELECT * FROM user")
users = cursor.fetchall()
if request.method == 'POST':
error = True
for u in users:
if r['username'] == u[0]:
if r['password'] == u[1]:
session['user'] = {"username":u[0], "password":u[1], "name":u[2]}
return redirect(url_for('index'))
return rend('login.html', error=error)
def login():
r = request.form
error = False
if 'user' in session:
return redirect(url_for('index'))
users = con_login()
if request.method == 'POST':
error = True
for u in users:
if r['username'] == u[0]:
if r['password'] == u[1]:
session['user'] = {
"username": u[0],
"password": u[1],
"name": u[2]
}
return redirect(url_for('index'))
return rend('login.html', error=error)
def write_post():
r = request.form
error = False
if 'user' not in session:
return redirect(url_for('index'))
posts = con_forum('posts')
user = session['user']
if request.method == 'POST':
error = True
if len(posts) != 0:
with forum_connection.cursor() as cursor:
cursor.execute(
f"""INSERT INTO Posts (post_id, author_key, title, content, post_date) VALUES
(
{int(posts[-1][0] + 1)},
'{user['username']}',
'{r['title']}',
'{r['content']}',
'{time()}'
);""")
else:
with forum_connection.cursor() as cursor:
cursor.execute(
f"""INSERT INTO Posts (post_id, author_key, title, content, post_date) VALUES
(
{0},
'{user['username']}',
'{r['title']}',
'{r['content']}',
'{time()}'
);""")
return redirect(url_for('index'))
return rend('post.html', user=user, error=error)
def login_page():
return rend("login.html",code = None)
