| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647 |
- from .tool.func import *
- async def recent_record_topic(name = 'Test'):
- with get_db_connect() as 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
- div = '''
- <table id="main_table_set">
- <tr id="main_table_top_tr">
- <td id="main_table_width">''' + await get_lang('discussion_name') + '''</td>
- <td id="main_table_width">''' + await get_lang('writer') + '''</td>
- <td id="main_table_width">''' + await get_lang('time') + '''</td>
- </tr>
- '''
- sub = '(' + html.escape(name) + ')'
- pas_name = await ip_pas(name)
- curs.execute(db_change("select code, id, date from topic where ip = ? order by date desc limit ?, 50"), [name, sql_num])
- data_list = curs.fetchall()
- for data in data_list:
- title = html.escape(data[0])
- curs.execute(db_change("select title, sub from rd where code = ?"), [data[0]])
- other_data = curs.fetchall()
- div += '' + \
- '<tr>' + \
- '<td>' + \
- '<a href="/thread/' + data[0] + '#' + data[1] + '">' + other_data[0][1] + '#' + data[1] + '</a> (' + other_data[0][0] + ')' + \
- '</td>' + \
- '<td>' + pas_name + '</td>' + \
- '<td>' + data[2] + '</td>' + \
- '</tr>' + \
- ''
- div += '</table>'
- div += await get_next_page_bottom('/record/topic/' + url_pas(name) + '?num={}', num, data_list)
- return await render_template(
- await get_lang('discussion_record'),
- div,
- sub,
- [['other', await get_lang('other')], ['user/' + url_pas(name), await get_lang('user_tool')]]
- )
|
