from .tool.func import *

def list_please_2(conn):
    curs = conn.cursor()

    num = int(number_check(flask.request.args.get('num', '1')))
    sql_num = (num * 50 - 50) if num * 50 > 0 else 0

    curs.execute(db_change('select data from other where name = "count_all_title"'))
    if int(curs.fetchall()[0][0]) > 30000:
        return re_error('/error/25')

    div = '<ul class="inside_ul">'

    curs.execute(db_change("select distinct title, link from back where type = 'no' order by title asc limit ?, 50"), [sql_num])
    data_list = curs.fetchall()
    for data in data_list:
        div += '' + \
            '<li>' + \
                '<a id="not_thing" href="/w/' + url_pas(data[0]) + '">' + html.escape(data[0]) + '</a> ' + \
                '<a href="/w/' + url_pas(data[1]) + '">(' + html.escape(data[1]) + ')</a>' + \
            '</li>' + \
        ''

    div += '</ul>' + next_fix('/please?num=', num, data_list)

    return easy_minify(flask.render_template(skin_check(),
        imp = [load_lang('need_document'), wiki_set(), wiki_custom(), wiki_css([0, 0])],
        data = div,
        menu = [['other', load_lang('return')]]
    ))