login_register_submit.py 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. from .tool.func import *
  2. def login_register_submit_2():
  3. with get_db_connect() as conn:
  4. curs = conn.cursor()
  5. if not 'submit_id' in flask.session:
  6. return redirect('/register')
  7. curs.execute(db_change('select data from other where name = "approval_question"'))
  8. sql_data = curs.fetchall()
  9. if not sql_data:
  10. return redirect('/register')
  11. data_que = sql_data[0][0]
  12. if flask.request.method == 'POST':
  13. curs.execute(db_change('select data from other where name = "encode"'))
  14. data_encode = curs.fetchall()
  15. data_encode = data_encode[0][0]
  16. user_ip = ip_check()
  17. user_agent = flask.request.headers.get('User-Agent', '')
  18. user_app_data = {}
  19. user_app_data['id'] = flask.session['submit_id']
  20. user_app_data['pw'] = pw_encode(flask.session['submit_pw'])
  21. user_app_data['encode'] = data_encode
  22. user_app_data['question'] = data_que
  23. user_app_data['answer'] = flask.request.form.get('answer', '')
  24. if 'submit_email' in flask.session:
  25. user_app_data['email'] = flask.session['submit_email']
  26. else:
  27. user_app_data['email'] = ''
  28. curs.execute(db_change(
  29. "insert into user_set (id, name, data) values (?, ?, ?)"
  30. ), [
  31. flask.session['submit_id'],
  32. 'application',
  33. json.dumps(user_app_data)
  34. ])
  35. conn.commit()
  36. return redirect('/')
  37. else:
  38. return easy_minify(flask.render_template(skin_check(),
  39. imp = [load_lang('approval_question'), wiki_set(), wiki_custom(), wiki_css([0, 0])],
  40. data = '''
  41. <form method="post">
  42. ''' + load_lang('approval_question') + ' : ' + data_que + '''
  43. <hr class="main_hr">
  44. <input placeholder="''' + load_lang('approval_question') + '''" name="answer">
  45. <hr class="main_hr">
  46. <button type="submit">''' + load_lang('save') + '''</button>
  47. </form>
  48. ''',
  49. menu = [['user', load_lang('return')]]
  50. ))