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)