openNAMU__openNAMU/route/topic_acl.py

from .tool.func import *

def topic_acl_2(conn, topic_num):
    curs = conn.cursor()

    if admin_check(3) != 1:
        return re_error('/error/3')

    ip = ip_check()
    time = get_time()
    topic_num = str(topic_num)

    curs.execute(db_change("select title, sub from rd where code = ?"), [topic_num])
    rd_d = curs.fetchall()
    if not rd_d:
        return redirect('/')

    if flask.request.method == 'POST':
        admin_check(3, 'topic_acl_set (code ' + topic_num + ')')

        curs.execute(db_change("select id from topic where code = ? order by id + 0 desc limit 1"), [topic_num])
        topic_check = curs.fetchall()
        if topic_check:
            acl_data = flask.request.form.get('acl', '')

            curs.execute(db_change("update rd set acl = ? where code = ?"), [
                acl_data,
                topic_num
            ])

            curs.execute(db_change("insert into topic (id, data, date, ip, top, code) values (?, ?, ?, ?, '1', ?)"), [
                str(int(topic_check[0][0]) + 1),
                'acl change ' + acl_data,
                time,
                ip,
                topic_num
            ])

            rd_plus(topic_num, time)

        return redirect('/thread/' + topic_num)
    else:
        acl_list = get_acl_list()
        acl_html_list = ''

        curs.execute(db_change("select acl from rd where code = ?"), [topic_num])
        topic_acl_get = curs.fetchall()
        for data_list in acl_list:
            if topic_acl_get and topic_acl_get[0][0] == data_list:
                check = 'selected="selected"'
            else:
                check = ''

            acl_html_list += '<option value="' + data_list + '" ' + check + '>' + (data_list if data_list != '' else 'normal') + '</option>'

        return easy_minify(flask.render_template(skin_check(),
            imp = [load_lang('topic_acl_setting'), wiki_set(), custom(), other2([0, 0])],
            data = '''
                <form method="post">
                    <a href="/acl/TEST#exp">(''' + load_lang('reference') + ''')</a>
                    <hr>
                    <select name="acl">
                    ''' + acl_html_list + '''
                    </select>
                    <hr class=\"main_hr\">
                    <button type="submit">''' + load_lang('save') + '''</button>
                </form>
            ''',
            menu = [['thread/' + topic_num + '/tool', load_lang('return')]]
        ))