list_user.py 990 B

123456789101112131415161718192021222324252627
  1. from .tool.func import *
  2. def list_user_2():
  3. with get_db_connect() as conn:
  4. curs = conn.cursor()
  5. num = int(number_check(flask.request.args.get('num', '1')))
  6. sql_num = (num * 50 - 50) if num * 50 > 0 else 0
  7. list_data = '<ul class="inside_ul">'
  8. curs.execute(db_change("select id, data from user_set where name = 'date' order by data desc limit ?, 50"), [sql_num])
  9. user_list = curs.fetchall()
  10. for data in user_list:
  11. list_data += '' + \
  12. '<li>' + \
  13. ip_pas(data[0]) + (' (' + data[1] + ')' if data[1] != '' else '') + \
  14. '</li>' + \
  15. ''
  16. list_data += '</ul>' + next_fix('/user_log?num=', num, user_list)
  17. return easy_minify(flask.render_template(skin_check(),
  18. imp = [load_lang('member_list'), wiki_set(), wiki_custom(), wiki_css([0, 0])],
  19. data = list_data,
  20. menu = [['other', load_lang('return')]]
  21. ))