openNAMU__openNAMU/route/user_alarm.py

from .tool.func import *

def user_alarm_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

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

    curs.execute(db_change("select data, date from alarm where name = ? order by date desc limit ?, 50"), [ip_check(), sql_num])
    data_list = curs.fetchall()
    if data_list:
        data = '<a href="/alarm/delete">(' + load_lang('delete') + ')</a><hr class=\"main_hr\">' + data

        for data_one in data_list:
            data += '<li>' + data_one[0] + ' (' + data_one[1] + ')</li>'

    data += '</ul>' + next_fix('/alarm?num=', num, data_list)

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