list_please.py 965 B

1234567891011121314151617181920212223242526
  1. from .tool.func import *
  2. def list_please_2(conn):
  3. curs = conn.cursor()
  4. num = int(number_check(flask.request.args.get('num', '1')))
  5. sql_num = (num * 50 - 50) if num * 50 > 0 else 0
  6. curs.execute(db_change('select data from other where name = "count_all_title"'))
  7. if int(curs.fetchall()[0][0]) > 30000:
  8. return re_error('/error/25')
  9. div = '<ul class="inside_ul">'
  10. curs.execute(db_change("select distinct title from back where type = 'no' order by title asc limit ?, 50"), [sql_num])
  11. data_list = curs.fetchall()
  12. for data in data_list:
  13. div += '<li><a id="not_thing" href="/w/' + url_pas(data[0]) + '">' + data[0] + '</a></li>'
  14. div += '</ul>' + next_fix('/please?num=', num, data_list)
  15. return easy_minify(flask.render_template(skin_check(),
  16. imp = [load_lang('need_document'), wiki_set(), wiki_custom(), wiki_css([0, 0])],
  17. data = div,
  18. menu = [['other', load_lang('return')]]
  19. ))