| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122 |
- from .tool.func import *
- def api_topic_sub_2(conn, topic_num):
- curs = conn.cursor()
- topic_change_data = topic_change(topic_num)
- name = topic_change_data[0]
- sub = topic_change_data[1]
- if flask.request.args.get('num', None):
- curs.execute(db_change("select id, data, date, ip, block, top from topic where title = ? and sub = ? and id + 0 = ? + 0 order by id + 0 asc"), [
- name,
- sub,
- flask.request.args.get('num', '')
- ])
- elif flask.request.args.get('top', None):
- curs.execute(db_change("select id, data, date, ip, block, top from topic where title = ? and sub = ? and top = 'O' order by id + 0 asc"), [name, sub])
- else:
- curs.execute(db_change("select id, data, date, ip, block, top from topic where title = ? and sub = ? order by id + 0 asc"), [name, sub])
- data = curs.fetchall()
- if data:
- json_data = {}
- admin = admin_check(3)
- for i in data:
- ip = ip_pas(i[3])
- if i[4] != 'O':
- t_data_f = i[1]
- b_color = 'toron_color'
- else:
- if admin == 1:
- t_data_f = i[1]
- b_color = 'toron_color_grey'
- else:
- t_data_f = ''
- b_color = 'toron_color_not'
- curs.execute(db_change("select who from re_admin where what = ? order by time desc limit 1"), [
- 'blind (' + name + ' - ' + sub + '#' + str(i[0]) + ')'
- ])
- who_blind = curs.fetchall()
- if who_blind:
- ip += ' (' + who_blind[0][0] + ' B)'
- else:
- ip += ' (B)'
- if flask.request.args.get('render', None):
- if i[0] == '1':
- s_user = i[3]
- else:
- if flask.request.args.get('num', None):
- curs.execute(db_change("select ip from topic where title = ? and sub = ? order by id + 0 asc limit 1"), [name, sub])
- g_data = curs.fetchall()
- if g_data:
- s_user = g_data[0][0]
- else:
- s_user = ''
- if flask.request.args.get('top', None):
- t_color = 'toron_color_red'
- elif i[3] == s_user and i[5] != '1':
- t_color = 'toron_color_green'
- elif i[5] == '1':
- t_color = 'toron_color_blue'
- else:
- t_color = 'toron_color'
- if admin == 1 or b_color != 'toron_color_not':
- ip += ' <a href="/thread/' + str(topic_num) + '/admin/' + i[0] + '">(' + load_lang('discussion_tool') + ')</a>'
- if t_data_f == '':
- t_data_f = '[br]'
- t_data_f = render_set(data = t_data_f, num = 2, include = 'topic_' + i[0])
- t_plus_data = t_data_f[1]
- t_data_f = t_data_f[0]
- all_data = '' + \
- '<table id="toron">' + \
- '<tbody>' + \
- '<tr>' + \
- '<td id="' + t_color + '">' + \
- '<a href="javascript:void(0);" id="' + i[0] + '">#' + i[0] + '</a> ' + ip + ' <span style="float: right;">' + i[2] + '</span>' + \
- '</td>' + \
- '</tr>' + \
- '<tr>' + \
- '<td id="' + b_color + '">' + t_data_f + '</td>' + \
- '</tr>' + \
- '</tbody>' + \
- '</table>' + \
- '<hr class="main_hr">' + \
- ''
- json_data[i[0]] = {
- "data" : all_data,
- "plus_data" : t_plus_data
- }
- else:
- if i[4] != 'O' or (i[4] == 'O' and admin == 1):
- t_data_f = i[1]
- else:
- curs.execute(db_change("select who from re_admin where what = ? order by time desc limit 1"), [
- 'blind (' + name + ' - ' + sub + '#' + str(i[0]) + ')'
- ])
- who_blind = curs.fetchall()
- if who_blind:
- t_data_f = '[[user:' + who_blind[0][0] + ']] block'
- else:
- t_data_f = 'block'
- json_data[i[0]] = {
- "data" : t_data_f,
- "date" : i[2],
- "ip" : ip_pas(i[3], 1),
- "block" : i[4],
- }
- return flask.jsonify(json_data)
- else:
- return flask.jsonify({})
|
