vote_close.py 832 B

1234567891011121314151617181920212223242526272829
  1. from .tool.func import *
  2. def vote_close_2(conn, num):
  3. curs = conn.cursor()
  4. if admin_check() != 1:
  5. return re_error('/ban')
  6. curs.execute(db_change('select type from vote where id = ? and user = ""'), [num])
  7. data_list = curs.fetchall()
  8. if not data_list:
  9. return redirect('/vote')
  10. if data_list[0][0] == 'close':
  11. type_set = 'open'
  12. elif data_list[0][0] == 'n_close':
  13. type_set = 'n_open'
  14. elif data_list[0][0] == 'open':
  15. type_set = 'close'
  16. else:
  17. type_set = 'n_close'
  18. curs.execute(db_change("update vote set type = ? where user = '' and id = ?"), [type_set, num])
  19. conn.commit()
  20. if data_list[0][0] == 'close' or data_list[0][0] == 'n_close':
  21. return redirect('/vote')
  22. else:
  23. return redirect('/vote?close=y')