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("delete from ban where (end < ? and end like '2%')"), [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':
                plus_t += [data[0][0]]
            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>']

            match = re.search("^([0-9]{1,3}\.[0-9]{1,3})", name)
            match = match.groups()[0] if match else '-'
            regex_ban = 0

            curs.execute(db_change("select login, block, end, why from ban where band = 'regex'"))
            for test_r in curs.fetchall():
                if re.compile(test_r[1]).search(name):
                    plus_t[1] += load_lang('type') + ' : ' + load_lang('regex') + '<br>'
                    plus_t[1] += 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 ban where block = ? or block = ?"), [name, match])
                block_data = curs.fetchall()
                if block_data:
                    plus_t[1] += load_lang('type') + ' : ' + load_lang('normal') + '<br>'
                    plus_t[1] += load_lang('period') + ' : ' + (block_data[0][0] if block_data[0][0] != '' else load_lang('limitless'))
                    plus_t[1] += ('<br>' + load_lang('login_able') if block_data[0][1] != '' else '')
                    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({})