2
0

func.py 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879
  1. import email.mime.text
  2. import urllib.request
  3. import sqlite3
  4. import hashlib
  5. import smtplib
  6. import bcrypt
  7. import flask
  8. import json
  9. import html
  10. import sys
  11. import re
  12. import os
  13. try:
  14. import css_html_js_minify
  15. except:
  16. pass
  17. if sys.version_info < (3, 6):
  18. import sha3
  19. from set_mark.tool import *
  20. from mark import *
  21. def load_conn(data):
  22. global conn
  23. global curs
  24. conn = data
  25. curs = conn.cursor()
  26. load_conn2(data)
  27. def send_email(who, title, data):
  28. smtp = smtplib.SMTP_SSL('smtp.gmail.com', 465)
  29. try:
  30. curs.execute('select name, data from other where name = "g_email" or name = "g_pass"')
  31. rep_data = curs.fetchall()
  32. if rep_data:
  33. g_email = ''
  34. g_pass = ''
  35. for i in rep_data:
  36. if i[0] == 'g_email':
  37. g_email = i[1]
  38. else:
  39. g_pass = i[1]
  40. smtp.login(g_email, g_pass)
  41. msg = email.mime.text.MIMEText(data)
  42. msg['Subject'] = title
  43. smtp.sendmail(g_email, who, msg.as_string())
  44. smtp.quit()
  45. except:
  46. print('error : email login error')
  47. def easy_minify(data, tool = None):
  48. try:
  49. if not tool:
  50. data = css_html_js_minify.html_minify(data)
  51. else:
  52. if tool == 'css':
  53. data = css_html_js_minify.css_minify(data)
  54. elif tool == 'js':
  55. data = css_html_js_minify.js_minify(data)
  56. except:
  57. data = re.sub('\n +<', '\n<', data)
  58. data = re.sub('>(\n| )+<', '> <', data)
  59. return data
  60. def render_set(title = '', data = '', num = 0):
  61. if acl_check(title, 'render') == 1:
  62. return 'HTTP Request 401.3'
  63. else:
  64. return namumark(title, data, num)
  65. def captcha_get():
  66. data = ''
  67. if custom()[2] == 0:
  68. curs.execute('select data from other where name = "recaptcha"')
  69. recaptcha = curs.fetchall()
  70. if recaptcha and recaptcha[0][0] != '':
  71. curs.execute('select data from other where name = "sec_re"')
  72. sec_re = curs.fetchall()
  73. if sec_re and sec_re[0][0] != '':
  74. data += recaptcha[0][0] + '<hr class=\"main_hr\">'
  75. return data
  76. def update():
  77. # v3.0.8 rd, agreedis, stop 테이블 통합
  78. try:
  79. curs.execute("select title, sub, close from stop")
  80. for i in curs.fetchall():
  81. if i[2] == '':
  82. curs.execute("update rd set stop = 'S' where title = ? and sub = ?", [i[0], i[1]])
  83. else:
  84. curs.execute("update rd set stop = 'O' where title = ? and sub = ?", [i[0], i[1]])
  85. except:
  86. pass
  87. try:
  88. curs.execute("select title, sub from agreedis")
  89. for i in curs.fetchall():
  90. curs.execute("update rd set agree = 'O' where title = ? and sub = ?", [i[0], i[1]])
  91. except:
  92. pass
  93. try:
  94. curs.execute("drop table if exists stop")
  95. curs.execute("drop table if exists agreedis")
  96. except:
  97. pass
  98. def pw_encode(data, data2 = '', type_d = ''):
  99. if type_d == '':
  100. curs.execute('select data from other where name = "encode"')
  101. set_data = curs.fetchall()
  102. type_d = set_data[0][0]
  103. if type_d == 'sha256':
  104. return hashlib.sha256(bytes(data, 'utf-8')).hexdigest()
  105. elif type_d == 'sha3':
  106. if sys.version_info < (3, 6):
  107. return sha3.sha3_256(bytes(data, 'utf-8')).hexdigest()
  108. else:
  109. return hashlib.sha3_256(bytes(data, 'utf-8')).hexdigest()
  110. else:
  111. if data2 != '':
  112. salt_data = bytes(data2, 'utf-8')
  113. else:
  114. salt_data = bcrypt.gensalt(11)
  115. return bcrypt.hashpw(bytes(data, 'utf-8'), salt_data).decode()
  116. def pw_check(data, data2, type_d = 'no', id_d = ''):
  117. curs.execute('select data from other where name = "encode"')
  118. db_data = curs.fetchall()
  119. if type_d != 'no':
  120. if type_d == '':
  121. set_data = 'bcrypt'
  122. else:
  123. set_data = type_d
  124. else:
  125. set_data = db_data[0][0]
  126. while 1:
  127. if set_data in ['sha256', 'sha3']:
  128. data3 = pw_encode(data = data, type_d = set_data)
  129. if data3 == data2:
  130. re_data = 1
  131. else:
  132. re_data = 0
  133. break
  134. else:
  135. try:
  136. if pw_encode(data, data2, 'bcrypt') == data2:
  137. re_data = 1
  138. else:
  139. re_data = 0
  140. break
  141. except:
  142. set_data = db_data[0][0]
  143. if db_data[0][0] != set_data and re_data == 1 and id_d != '':
  144. curs.execute("update user set pw = ?, encode = ? where id = ?", [pw_encode(data), db_data[0][0], id_d])
  145. return re_data
  146. def captcha_post(re_data, num = 1):
  147. if num == 1:
  148. if custom()[2] == 0 and captcha_get() != '':
  149. curs.execute('select data from other where name = "sec_re"')
  150. sec_re = curs.fetchall()
  151. if sec_re and sec_re[0][0] != '':
  152. data = urllib.request.urlopen('https://www.google.com/recaptcha/api/siteverify?secret=' + sec_re[0][0] + '&response=' + re_data)
  153. if not data:
  154. return 0
  155. else:
  156. json_data = data.read().decode(data.headers.get_content_charset())
  157. json_data = json.loads(json_data)
  158. if data.getcode() == 200 and json_data['success'] == True:
  159. return 0
  160. else:
  161. return 1
  162. else:
  163. return 0
  164. else:
  165. return 0
  166. else:
  167. pass
  168. def load_lang(data, num = 2):
  169. if num == 1:
  170. curs.execute("select data from other where name = 'language'")
  171. rep_data = curs.fetchall()
  172. json_data = open(os.path.join('lang', rep_data[0][0] + '.json'), 'rt', encoding='utf-8').read()
  173. lang = json.loads(json_data)
  174. if data in lang:
  175. return html.escape(lang[data])
  176. else:
  177. return html.escape(data + ' (M)')
  178. else:
  179. curs.execute('select data from user_set where name = "lang" and id = ?', [ip_check()])
  180. rep_data = curs.fetchall()
  181. if rep_data:
  182. try:
  183. json_data = open(os.path.join('lang', rep_data[0][0] + '.json'), 'rt', encoding='utf-8').read()
  184. lang = json.loads(json_data)
  185. except:
  186. return load_lang(data, 1)
  187. if data in lang:
  188. return html.escape(lang[data])
  189. else:
  190. return load_lang(data, 1)
  191. else:
  192. return load_lang(data, 1)
  193. def load_oauth(provider):
  194. oauth = json.loads(open('oauthsettings.json', encoding='utf-8').read())
  195. return oauth[provider]
  196. def update_oauth(provider, target, content):
  197. oauth = json.loads(open('oauthsettings.json', encoding='utf-8').read())
  198. oauth[provider][target] = content
  199. with open('oauthsettings.json', 'w', encoding='utf-8') as f:
  200. json.dump(oauth, f)
  201. return 'Done'
  202. def ip_or_user(data):
  203. if re.search('(\.|:)', data):
  204. return 1
  205. else:
  206. return 0
  207. def edit_help_button():
  208. # https://stackoverflow.com/questions/11076975/insert-text-into-textarea-at-cursor-position-javascript
  209. js_data = '''
  210. <script>
  211. function insert_data(name, data) {
  212. if(document.selection) {
  213. document.getElementById(name).focus();
  214. sel = document.selection.createRange();
  215. sel.text = data;
  216. } else if(document.getElementById(name).selectionStart || document.getElementById(name).selectionStart == '0') {
  217. var startPos = document.getElementById(name).selectionStart;
  218. var endPos = document.getElementById(name).selectionEnd;
  219. document.getElementById(name).value = document.getElementById(name).value.substring(0, startPos) + data + document.getElementById(name).value.substring(endPos, document.getElementById(name).value.length);
  220. } else {
  221. document.getElementById(name).value += data;
  222. }
  223. }
  224. </script>
  225. '''
  226. insert_list = [['[[|]]', '[[|]]'], ['[*()]', '[*()]'], ['{{{#!}}}', '{{{#!}}}'], ['||<>||', '||<>||'], ["\\'\\'\\'", "\'\'\'"]]
  227. data = ''
  228. for insert_data in insert_list:
  229. data += '<a href="javascript:void(0);" onclick="insert_data(\'content\', \'' + insert_data[0] + '\');">(' + insert_data[1] + ')</a> '
  230. return [js_data, data + '<hr class=\"main_hr\">']
  231. def ip_warring():
  232. if custom()[2] == 0:
  233. curs.execute('select data from other where name = "no_login_warring"')
  234. data = curs.fetchall()
  235. if data and data[0][0] != '':
  236. text_data = '<span>' + data[0][0] + '</span><hr class=\"main_hr\">'
  237. else:
  238. text_data = '<span>' + load_lang('no_login_warring') + '</span><hr class=\"main_hr\">'
  239. else:
  240. text_data = ''
  241. return text_data
  242. def skin_check():
  243. skin = './views/neo_yousoro/'
  244. curs.execute('select data from other where name = "skin"')
  245. skin_exist = curs.fetchall()
  246. if skin_exist and skin_exist[0][0] != '':
  247. if os.path.exists(os.path.abspath('./views/' + skin_exist[0][0] + '/index.html')) == 1:
  248. skin = './views/' + skin_exist[0][0] + '/'
  249. curs.execute('select data from user_set where name = "skin" and id = ?', [ip_check()])
  250. skin_exist = curs.fetchall()
  251. if skin_exist and skin_exist[0][0] != '':
  252. if os.path.exists(os.path.abspath('./views/' + skin_exist[0][0] + '/index.html')) == 1:
  253. skin = './views/' + skin_exist[0][0] + '/'
  254. return skin + 'index.html'
  255. def next_fix(link, num, page, end = 50):
  256. list_data = ''
  257. if num == 1:
  258. if len(page) == end:
  259. list_data += '<hr class=\"main_hr\"><a href="' + link + str(num + 1) + '">(' + load_lang('next') + ')</a>'
  260. elif len(page) != end:
  261. list_data += '<hr class=\"main_hr\"><a href="' + link + str(num - 1) + '">(' + load_lang('previous') + ')</a>'
  262. else:
  263. list_data += '<hr class=\"main_hr\"><a href="' + link + str(num - 1) + '">(' + load_lang('previous') + ')</a> <a href="' + link + str(num + 1) + '">(' + load_lang('next') + ')</a>'
  264. return list_data
  265. def other2(data):
  266. return data + ['']
  267. def wiki_set(num = 1):
  268. if num == 1:
  269. data_list = []
  270. curs.execute('select data from other where name = ?', ['name'])
  271. db_data = curs.fetchall()
  272. if db_data and db_data[0][0] != '':
  273. data_list += [db_data[0][0]]
  274. else:
  275. data_list += ['wiki']
  276. curs.execute('select data from other where name = "license"')
  277. db_data = curs.fetchall()
  278. if db_data and db_data[0][0] != '':
  279. data_list += [db_data[0][0]]
  280. else:
  281. data_list += ['CC 0']
  282. data_list += ['', '']
  283. curs.execute('select data from other where name = "logo"')
  284. db_data = curs.fetchall()
  285. if db_data and db_data[0][0] != '':
  286. data_list += [db_data[0][0]]
  287. else:
  288. data_list += [data_list[0]]
  289. curs.execute("select data from other where name = 'head'")
  290. db_data = curs.fetchall()
  291. if db_data and db_data[0][0] != '':
  292. data_list += [db_data[0][0]]
  293. else:
  294. data_list += ['']
  295. return data_list
  296. if num == 2:
  297. var_data = 'FrontPage'
  298. curs.execute('select data from other where name = "frontpage"')
  299. elif num == 3:
  300. var_data = '2'
  301. curs.execute('select data from other where name = "upload"')
  302. db_data = curs.fetchall()
  303. if db_data and db_data[0][0] != '':
  304. return db_data[0][0]
  305. else:
  306. return var_data
  307. def diff(seqm):
  308. output = []
  309. for opcode, a0, a1, b0, b1 in seqm.get_opcodes():
  310. if opcode == 'equal':
  311. output += [seqm.a[a0:a1]]
  312. elif opcode == 'insert':
  313. output += ["<span style='background:#CFC;'>" + seqm.b[b0:b1] + "</span>"]
  314. elif opcode == 'delete':
  315. output += ["<span style='background:#FDD;'>" + seqm.a[a0:a1] + "</span>"]
  316. elif opcode == 'replace':
  317. output += ["<span style='background:#FDD;'>" + seqm.a[a0:a1] + "</span>"]
  318. output += ["<span style='background:#CFC;'>" + seqm.b[b0:b1] + "</span>"]
  319. end = ''.join(output)
  320. end = end.replace('\r\n', '\n')
  321. sub = ''
  322. if not re.search('\n', end):
  323. end += '\n'
  324. num = 0
  325. left = 1
  326. while 1:
  327. data = re.search('((?:(?!\n).)*)\n', end)
  328. if data:
  329. data = data.groups()[0]
  330. left += 1
  331. if re.search('<span style=\'(?:(?:(?!\').)+)\'>', data):
  332. num += 1
  333. if re.search('<\/span>', data):
  334. num -= 1
  335. sub += str(left) + ' : ' + re.sub('(?P<in>(?:(?!\n).)*)\n', '\g<in>', data, 1) + '<br>'
  336. else:
  337. if re.search('<\/span>', data):
  338. num -= 1
  339. sub += str(left) + ' : ' + re.sub('(?P<in>(?:(?!\n).)*)\n', '\g<in>', data, 1) + '<br>'
  340. else:
  341. if num > 0:
  342. sub += str(left) + ' : ' + re.sub('(?P<in>.*)\n', '\g<in>', data, 1) + '<br>'
  343. end = re.sub('((?:(?!\n).)*)\n', '', end, 1)
  344. else:
  345. break
  346. return sub
  347. def admin_check(num = None, what = None):
  348. ip = ip_check()
  349. curs.execute("select acl from user where id = ?", [ip])
  350. user = curs.fetchall()
  351. if user:
  352. reset = 0
  353. while 1:
  354. if num == 1 and reset == 0:
  355. check = 'ban'
  356. elif num == 3 and reset == 0:
  357. check = 'toron'
  358. elif num == 4 and reset == 0:
  359. check = 'check'
  360. elif num == 5 and reset == 0:
  361. check = 'acl'
  362. elif num == 6 and reset == 0:
  363. check = 'hidel'
  364. elif num == 7 and reset == 0:
  365. check = 'give'
  366. else:
  367. check = 'owner'
  368. curs.execute('select name from alist where name = ? and acl = ?', [user[0][0], check])
  369. if curs.fetchall():
  370. if what:
  371. curs.execute("insert into re_admin (who, what, time) values (?, ?, ?)", [ip, what, get_time()])
  372. conn.commit()
  373. return 1
  374. else:
  375. if reset == 0:
  376. reset = 1
  377. else:
  378. break
  379. return 0
  380. def ip_pas(raw_ip):
  381. hide = 0
  382. if re.search("(\.|:)", raw_ip):
  383. if not re.search("^tool:", raw_ip):
  384. curs.execute("select data from other where name = 'ip_view'")
  385. data = curs.fetchall()
  386. if data and data[0][0] != '':
  387. ip = '<span style="font-size: 75%;">' + hashlib.md5(bytes(raw_ip, 'utf-8')).hexdigest() + '</span>'
  388. if not admin_check('ban', None):
  389. hide = 1
  390. else:
  391. ip = raw_ip
  392. else:
  393. ip = raw_ip
  394. hide = 1
  395. else:
  396. curs.execute("select title from data where title = ?", ['user:' + raw_ip])
  397. if curs.fetchall():
  398. ip = '<a href="/w/' + url_pas('user:' + raw_ip) + '">' + raw_ip + '</a>'
  399. else:
  400. ip = '<a id="not_thing" href="/w/' + url_pas('user:' + raw_ip) + '">' + raw_ip + '</a>'
  401. if hide == 0:
  402. ip += ' <a href="/tool/' + url_pas(raw_ip) + '">(' + load_lang('tool') + ')</a>'
  403. return ip
  404. def custom():
  405. if 'head' in flask.session:
  406. user_head = flask.session['head']
  407. else:
  408. user_head = ''
  409. if 'state' in flask.session and flask.session['state'] == 1:
  410. curs.execute('select name from alarm where name = ? limit 1', [ip_check()])
  411. if curs.fetchall():
  412. user_icon = 2
  413. else:
  414. user_icon = 1
  415. else:
  416. user_icon = 0
  417. if user_icon != 0:
  418. curs.execute('select data from user_set where name = "email" and id = ?', [ip_check()])
  419. data = curs.fetchall()
  420. if data:
  421. email = data[0][0]
  422. else:
  423. email = ''
  424. else:
  425. email = ''
  426. if user_icon != 0:
  427. user_name = ip_check()
  428. else:
  429. user_name = load_lang('user')
  430. return ['', '', user_icon, user_head, email, user_name]
  431. def load_skin(data = ''):
  432. div2 = ''
  433. system_file = ['main_css', 'easter_egg.html']
  434. if data == '':
  435. ip = ip_check()
  436. curs.execute('select data from user_set where name = "skin" and id = ?', [ip])
  437. data = curs.fetchall()
  438. for skin_data in os.listdir(os.path.abspath('views')):
  439. if not skin_data in system_file:
  440. if not data:
  441. curs.execute('select data from other where name = "skin"')
  442. sql_data = curs.fetchall()
  443. if sql_data and sql_data[0][0] == skin_data:
  444. div2 = '<option value="' + skin_data + '">' + skin_data + '</option>' + div2
  445. else:
  446. div2 += '<option value="' + skin_data + '">' + skin_data + '</option>'
  447. elif data[0][0] == skin_data:
  448. div2 = '<option value="' + skin_data + '">' + skin_data + '</option>' + div2
  449. else:
  450. div2 += '<option value="' + skin_data + '">' + skin_data + '</option>'
  451. else:
  452. for skin_data in os.listdir(os.path.abspath('views')):
  453. if not skin_data in system_file:
  454. if data == skin_data:
  455. div2 = '<option value="' + skin_data + '">' + skin_data + '</option>' + div2
  456. else:
  457. div2 += '<option value="' + skin_data + '">' + skin_data + '</option>'
  458. return div2
  459. def acl_check(name, tool = ''):
  460. ip = ip_check()
  461. if tool == 'render':
  462. curs.execute("select view from acl where title = ?", [name])
  463. acl_data = curs.fetchall()
  464. if acl_data:
  465. if acl_data[0][0] == 'user':
  466. if not user_data:
  467. return 1
  468. if acl_data[0][0] == 'admin':
  469. if not user_data:
  470. return 1
  471. if not admin_check(5, 'view (' + name + ')') == 1:
  472. return 1
  473. return 0
  474. else:
  475. if ban_check() == 1:
  476. return 1
  477. acl_c = re.search("^user:([^/]*)", name)
  478. if acl_c:
  479. acl_n = acl_c.groups()
  480. if admin_check(5, None) == 1:
  481. return 0
  482. curs.execute("select dec from acl where title = ?", ['user:' + acl_n[0]])
  483. acl_data = curs.fetchall()
  484. if acl_data:
  485. if acl_data[0][0] == 'all':
  486. return 0
  487. if acl_data[0][0] == 'user' and not re.search("(\.|:)", ip):
  488. return 0
  489. if ip != acl_n[0] or re.search("(\.|:)", ip):
  490. return 1
  491. if ip == acl_n[0] and not re.search("(\.|:)", ip) and not re.search("(\.|:)", acl_n[0]):
  492. return 0
  493. else:
  494. return 1
  495. file_c = re.search("^file:(.*)", name)
  496. if file_c and admin_check(5, 'edit (' + name + ')') != 1:
  497. return 1
  498. curs.execute("select acl from user where id = ?", [ip])
  499. user_data = curs.fetchall()
  500. curs.execute("select dec from acl where title = ?", [name])
  501. acl_data = curs.fetchall()
  502. if acl_data:
  503. if acl_data[0][0] == 'user':
  504. if not user_data:
  505. return 1
  506. if acl_data[0][0] == 'admin':
  507. if not user_data:
  508. return 1
  509. if not admin_check(5, 'edit (' + name + ')') == 1:
  510. return 1
  511. curs.execute('select data from other where name = "edit"')
  512. set_data = curs.fetchall()
  513. if set_data:
  514. if set_data[0][0] == 'login':
  515. if not user_data:
  516. return 1
  517. if set_data[0][0] == 'admin':
  518. if not user_data:
  519. return 1
  520. if not admin_check(5, None) == 1:
  521. return 1
  522. return 0
  523. def ban_check(ip = None, tool = None):
  524. if not ip:
  525. ip = ip_check()
  526. band = re.search("^([0-9]{1,3}\.[0-9]{1,3})", ip)
  527. if band:
  528. band_it = band.groups()[0]
  529. else:
  530. band_it = '-'
  531. curs.execute("select end, login from ban where block = ?", [band_it])
  532. band_d = curs.fetchall()
  533. curs.execute("select end, login from ban where block = ?", [ip])
  534. ban_d = curs.fetchall()
  535. data = band_d or ban_d
  536. if data and (data[0][0] == '' or data[0][0] > get_time()):
  537. if tool and tool == 'login':
  538. if data[0][1] == 'O':
  539. return 0
  540. return 1
  541. return 0
  542. def topic_check(name, sub):
  543. ip = ip_check()
  544. if ban_check() == 1:
  545. return 1
  546. curs.execute("select acl from user where id = ?", [ip])
  547. user_data = curs.fetchall()
  548. curs.execute('select data from other where name = "discussion"')
  549. acl_data = curs.fetchall()
  550. if acl_data:
  551. if acl_data[0][0] == 'login':
  552. if not user_data:
  553. return 1
  554. if acl_data[0][0] == 'admin':
  555. if not user_data:
  556. return 1
  557. if not admin_check(3, 'topic (' + name + ')') == 1:
  558. return 1
  559. curs.execute("select dis from acl where title = ?", [name])
  560. acl_data = curs.fetchall()
  561. if acl_data:
  562. if acl_data[0][0] == 'user':
  563. if not user_data:
  564. return 1
  565. if acl_data[0][0] == 'admin':
  566. if not user_data:
  567. return 1
  568. if not admin_check(3, 'topic (' + name + ')') == 1:
  569. return 1
  570. curs.execute("select title from rd where title = ? and sub = ? and not stop = ''", [name, sub])
  571. if curs.fetchall():
  572. if not admin_check(3, 'topic (' + name + ')') == 1:
  573. return 1
  574. return 0
  575. def ban_insert(name, end, why, login, blocker):
  576. now_time = get_time()
  577. if re.search("^([0-9]{1,3}\.[0-9]{1,3})$", name):
  578. band = 'O'
  579. else:
  580. band = ''
  581. curs.execute("select block from ban where block = ?", [name])
  582. if curs.fetchall():
  583. curs.execute("insert into rb (block, end, today, blocker, why, band) values (?, ?, ?, ?, ?, ?)", [name, load_lang('release', 1), now_time, blocker, '', band])
  584. curs.execute("delete from ban where block = ?", [name])
  585. else:
  586. if login != '':
  587. login = 'O'
  588. else:
  589. login = ''
  590. if end != '0':
  591. time = datetime.datetime.now()
  592. plus = datetime.timedelta(seconds = int(end))
  593. r_time = (time + plus).strftime("%Y-%m-%d %H:%M:%S")
  594. else:
  595. r_time = ''
  596. curs.execute("insert into rb (block, end, today, blocker, why, band) values (?, ?, ?, ?, ?, ?)", [name, r_time, now_time, blocker, why, band])
  597. curs.execute("insert into ban (block, end, why, band, login) values (?, ?, ?, ?, ?)", [name, r_time, why, band, login])
  598. conn.commit()
  599. def rd_plus(title, sub, date):
  600. curs.execute("select title from rd where title = ? and sub = ?", [title, sub])
  601. if curs.fetchall():
  602. curs.execute("update rd set date = ? where title = ? and sub = ?", [date, title, sub])
  603. else:
  604. curs.execute("insert into rd (title, sub, date) values (?, ?, ?)", [title, sub, date])
  605. def history_plus(title, data, date, ip, send, leng):
  606. curs.execute("select id from history where title = ? order by id + 0 desc limit 1", [title])
  607. id_data = curs.fetchall()
  608. curs.execute("insert into history (id, title, data, date, ip, send, leng, hide) values (?, ?, ?, ?, ?, ?, ?, '')", [str(int(id_data[0][0]) + 1) if id_data else '1', title, data, date, ip, send, leng])
  609. def leng_check(first, second):
  610. if first < second:
  611. all_plus = '+' + str(second - first)
  612. elif second < first:
  613. all_plus = '-' + str(first - second)
  614. else:
  615. all_plus = '0'
  616. return all_plus
  617. def edit_filter_do(data):
  618. if admin_check(1, 'edit_filter pass') != 1:
  619. curs.execute("select regex, sub from filter")
  620. for data_list in curs.fetchall():
  621. match = re.compile(data_list[0], re.I)
  622. if match.search(data):
  623. ban_insert(
  624. ip_check(),
  625. '0' if data_list[1] == 'X' else data_list[1],
  626. load_lang('edit', 1) + ' ' + load_lang('filter', 1),
  627. None,
  628. load_lang('tool', 1) + ':' + load_lang('edit', 1) + ' ' + load_lang('filter', 1)
  629. )
  630. return 1
  631. return 0
  632. def redirect(data):
  633. return flask.redirect(data)
  634. def re_error(data):
  635. conn.commit()
  636. if data == '/ban':
  637. ip = ip_check()
  638. end = '<li>' + load_lang('why') + ' : ' + load_lang('authority_error') + '</li>'
  639. if ban_check() == 1:
  640. curs.execute("select end, why from ban where block = ?", [ip])
  641. end_data = curs.fetchall()
  642. if not end_data:
  643. match = re.search("^([0-9]{1,3}\.[0-9]{1,3})", ip)
  644. if match:
  645. curs.execute("select end, why from ban where block = ?", [match.groups()[0]])
  646. end_data = curs.fetchall()
  647. if end_data:
  648. end = '<li>' + load_lang('state') + ' : ' + load_lang('ban') + '</li><li>'
  649. if end_data[0][0]:
  650. now = int(re.sub('(\-| |:)', '', get_time()))
  651. day = int(re.sub('(\-| |:)', '', end_data[0][0]))
  652. if now >= day:
  653. curs.execute("delete from ban where block = ?", [ip])
  654. conn.commit()
  655. end += '<script>location.reload();</script>'
  656. else:
  657. end += 'end : ' + end_data[0][0]
  658. else:
  659. end += load_lang('limitless')
  660. end += '</li>'
  661. if end_data[0][1] != '':
  662. end += '<li>' + load_lang('why') + ' : ' + end_data[0][1] + '</li>'
  663. return easy_minify(flask.render_template(skin_check(),
  664. imp = ['error', wiki_set(1), custom(), other2([0, 0])],
  665. data = '<h2>error</h2><ul>' + end + '</ul>',
  666. menu = 0
  667. ))
  668. else:
  669. error_data = re.search('\/error\/([0-9]+)', data)
  670. if error_data:
  671. num = int(error_data.groups()[0])
  672. if num == 1:
  673. data = load_lang('no_login_error')
  674. elif num == 2:
  675. data = load_lang('no_exist_user_error')
  676. elif num == 3:
  677. data = load_lang('authority_error')
  678. elif num == 4:
  679. data = load_lang('no_admin_block_error')
  680. elif num == 5:
  681. data = load_lang('skin_error')
  682. elif num == 6:
  683. data = load_lang('same_id_exist_error')
  684. elif num == 7:
  685. data = load_lang('long_id_error')
  686. elif num == 8:
  687. data = load_lang('id_char_error') + ' <a href="/name_filter">(' + load_lang('id') + ' ' + load_lang('filter') + ')</a>'
  688. elif num == 9:
  689. data = load_lang('file_exist_error')
  690. elif num == 10:
  691. data = load_lang('password_error')
  692. elif num == 13:
  693. data = load_lang('recaptcha_error')
  694. elif num == 14:
  695. data = load_lang('file_extension_error')
  696. elif num == 15:
  697. data = load_lang('edit_record_error')
  698. elif num == 16:
  699. data = load_lang('same_file_error')
  700. elif num == 17:
  701. data = load_lang('file_capacity_error') + ' ' + wiki_set(3)
  702. elif num == 19:
  703. data = load_lang('decument_exist_error')
  704. elif num == 20:
  705. data = load_lang('password_diffrent_error')
  706. elif num == 21:
  707. data = load_lang('edit_filter_error')
  708. elif num == 22:
  709. data = load_lang('file_name_error')
  710. else:
  711. data = '???'
  712. return easy_minify(flask.render_template(skin_check(),
  713. imp = ['error', wiki_set(1), custom(), other2([0, 0])],
  714. data = '<h2>error</h2><ul><li>' + data + '</li></ul>',
  715. menu = 0
  716. ))
  717. else:
  718. return redirect('/')