Beispiel #1
0
def admin_edit_post(charid):
    cur = g.db.cursor(cursor_factory=psycopg2.extras.NamedTupleCursor)

    cur.execute("select creator, level from chars where charid = %s", (charid,))
    if cur.rowcount == 1:
        row = cur.fetchone()
        creator = row.creator
        level = row.level
        if current_user.uid == creator:
            check, values = validate_form(current_user, request, charid)
            if check:
                try:
                    # change this if values changes index!
                    if level != values[4]:
                        expires = interval(values[4])
                        if expires == False:
                            return render_template("fail.html", message="Invalid level.")
                        elif expires == None:
                            cur.execute("update chars set expires = null where charid = %s", (charid,))
                            g.db.commit()
                        else:
                            cur.execute(
                                "update chars set expires = current_timestamp + interval %s where charid = %s",
                                (expires, charid),
                            )
                            g.db.commit()
                    cur.execute(
                        "update chars set name = %s, password = %s, moves = %s, hitpoints = %s, level = %s, race = %s, char_class = %s, homeland = %s, stat_str = %s, stat_int = %s, stat_wil = %s, stat_dex = %s, stat_con = %s, notes = %s, rent = %s, sex = %s where charid = %s",
                        (values),
                    )
                    g.db.commit()

                    return redirect(url_for("admin_view_char", charid=charid))
                except:
                    return render_template("fail.html", message="Unable to update record.")
            else:
                return render_template("fail.html", message=values)
        else:
            return render_template("fail.html", message="This is not your character.")
    else:
        return render_template("fail.html", message="That character does not exist.")
Beispiel #2
0
def admin_renew_char(charid):
    cur = g.db.cursor(cursor_factory=psycopg2.extras.NamedTupleCursor)
    cur.execute("select creator, level from chars where charid = %s", (charid,))
    if cur.rowcount == 1:
        row = cur.fetchone()
        if current_user.uid == row.creator:
            expires = interval(row.level)
            if expires == False:
                return render_template("fail.html", message="Couldn't renew character.")
            elif expires == None:
                cur.execute("update chars set expires = null where charid = %s", (charid,))
                g.db.commit()
            else:
                cur.execute(
                    "update chars set expires = current_timestamp + interval %s where charid = %s", (expires, charid)
                )
                g.db.commit()
                # return render_template("success.html")
            return redirect(request.referrer or url_for("admin"))
        else:
            return render_template("fail.html", message="This is not your character.")
    else:
        return render_template("fail.html", message="That character does not exist.")