__init__.py 文件源码

def verify_email():
    page_init()
    if 'i' in request.args and 't' in request.args:
        db = get_db()
        cur = db.cursor()
        cur.execute('SELECT email_conf_token, email_confirmed FROM users WHERE id='+app.sqlesc,(request.args.get('i'),))
        t = cur.fetchall()
        if len(t) == 0:
            g.error = _('Account does not exist!')
            return render_template('error.html',**page_args())
        elif t[0][1] == True:
            flash({'message':'<p>'+_('Already confirmed email address!')+'</p>'})
            return redirect(url_for('home'))
        else:
            if t[0][0] == request.args.get('t'):
                cur.execute('UPDATE users SET email_confirmed='+app.sqlesc+' WHERE id='+app.sqlesc,(True,request.args.get('i')))
                db.commit()
                flash({'message':'<p>'+_("Account email address confirmed!")+'</p>'})
                return redirect(url_for('home'))
    g.error = _('Malformed verification string!')
    return render_template('error.html',**page_args())