openNAMU__openNAMU/route/api_user_info.py

from .tool.func import *

def api_user_info_2(conn, name):
    curs = conn.cursor()

    if flask.request.args.get('render', None):
        plus_d = ''
        plus_t = []

        curs.execute(db_change("update rb set ongoing = '' where end < ? and end != '' and ongoing = '1'"), [get_time()])
        conn.commit()

        plus_d = '''
            <table class="user_info_table">
                <tbody>
                    <tr>
                        <td>''' + load_lang('user_name') + '''</td>
                        <td>{}</td>
                    </tr>
                    <tr>
                        <td>''' + load_lang('authority') + '''</td>
                        <td>{}</td>
                    </tr>
                    <tr>
                        <td>''' + load_lang('state') + '''</td>
                        <td>{}</td>
                    </tr>
                </tbody>
            </table>
        '''

        curs.execute(db_change("select acl from user where id = ?"), [name])
        data = curs.fetchall()
        if data:
            if data[0][0] != 'user':
                curs.execute(db_change("select name from alist where name = ?"), [data[0][0]])
                if curs.fetchall():
                    plus_t += [data[0][0]]
                else:
                    plus_t += [load_lang('member')]
            else:
                plus_t += [load_lang('member')]
        else:
            plus_t += [load_lang('normal')]

        if ban_check(name) == 0:
            plus_t += [load_lang('normal')]
        else:
            plus_t += [load_lang('blocked') + '<br>']
            regex_ban = 0

            curs.execute(db_change("select login, block, end, why from rb where band = 'regex' and ongoing = '1'"))
            for test_r in curs.fetchall():
                if re.compile(test_r[1]).search(name):
                    plus_t[1] += load_lang('type') + ' : ' + load_lang('regex')
                    plus_t[1] += '<br>' + load_lang('period') + ' : ' + (test_r[2] if test_r[2] != '' else load_lang('limitless'))
                    plus_t[1] += ('<br>' + load_lang('login_able') if test_r[0] == 'O' else '')
                    plus_t[1] += ('<br>' + load_lang('why') + ' : ' + test_r[3] if test_r[3] != '' else '')
                    regex_ban = 1

            if regex_ban == 0:
                curs.execute(db_change("select end, login, band, why from rb where block = ? and ongoing = '1'"), [name])
                block_data = curs.fetchall()
                if block_data:
                    plus_t[1] += load_lang('type') + ' : ' + (load_lang('band_blocked') if block_data[0][2] == 'O' else load_lang('normal'))
                    plus_t[1] += (' (' + load_lang('login_able') + ')' if block_data[0][1] != '' else '')
                    plus_t[1] += '<br>' + load_lang('period') + ' : ' + (block_data[0][0] if block_data[0][0] != '' else load_lang('limitless'))
                    plus_t[1] += ('<br>' + load_lang('band_blocked') if block_data[0][2] == 'O' else '')
                    plus_t[1] += ('<br>' + load_lang('why') + ' : ' + block_data[0][3] if block_data[0][3] != '' else '')

        plus_d = plus_d.format(ip_pas(name), plus_t[0], plus_t[1])

        return flask.jsonify({ "data" : plus_d })
    else:
        return flask.jsonify({})