openNAMU__openNAMU/route/login_find_key.py

from .tool.func import *

def login_find_key():
    with get_db_connect() as conn:
        curs = conn.cursor()
        if flask.request.method == 'POST':
            if captcha_post(flask.request.form.get('g-recaptcha-response', flask.request.form.get('g-recaptcha', ''))) == 1:
                return re_error('/error/13')
            else:
                captcha_post('', 0)
            
            input_key = flask.request.form.get('key', '')
            curs.execute(db_change('select id from user_set where name = "random_key" and data = ?'), [input_key])
            db_data = curs.fetchall()
            if not db_data:
                return redirect('/user')
            else:
                user_id = db_data[0][0]
            
            key = load_random_key(32)
            curs.execute(db_change("update user_set set data = ? where name = 'pw' and id = ?"), [
                pw_encode(key), 
                user_id
            ])
            
            curs.execute(db_change('select data from user_set where name = "2fa" and id = ?'), [user_id])
            if curs.fetchall():
                curs.execute(db_change("update user_set set data = '' where name = '2fa' and id = ?"), [user_id])
            
            curs.execute(db_change('select data from other where name = "reset_user_text"'))
            sql_d = curs.fetchall()
            b_text = (sql_d[0][0] + '<hr class="main_hr">') if sql_d and sql_d[0][0] != '' else ''
            
            return easy_minify(flask.render_template(skin_check(),
                    imp = [load_lang('reset_user_ok'), wiki_set(), wiki_custom(), wiki_css([0, 0])],
                    data = '' + \
                        b_text + \
                        load_lang('id') + ' : ' + user_id + \
                        '<hr class="main_hr">' + \
                        load_lang('password') + ' : ' + key + \
                    '',
                    menu = [['user', load_lang('return')]]
                ))
        else:
            return easy_minify(flask.render_template(skin_check(),
                imp = [load_lang('password_search'), wiki_set(), wiki_custom(), wiki_css([0, 0])],
                data = '''
                    <form method="post">
                        <input placeholder="''' + load_lang('key') + '''" name="key" type="password">
                        <hr class="main_hr">
                        ''' + captcha_get() + '''
                        <button type="submit">''' + load_lang('send') + '''</button>
                    </form>
                ''',
                menu = [['user', load_lang('return')]]
            ))