main.py 108 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380
  1. from flask import Flask, request, session, render_template, send_file
  2. app = Flask(__name__)
  3. from urllib import parse
  4. import json
  5. import pymysql
  6. import time
  7. import re
  8. import bcrypt
  9. import os
  10. import difflib
  11. import hashlib
  12. json_data = open('set.json').read()
  13. set_data = json.loads(json_data)
  14. print('port : ' + set_data['port'])
  15. if(not set_data['log'] == "O"):
  16. import logging
  17. log = logging.getLogger('werkzeug')
  18. log.setLevel(logging.ERROR)
  19. def start():
  20. try:
  21. db_ex("select * from data limit 1")
  22. except:
  23. db_ex("create table data(title text, data longtext, acl text)")
  24. try:
  25. db_ex("select * from history limit 1")
  26. except:
  27. db_ex("create table history(id text, title text, data longtext, date text, ip text, send text, leng text)")
  28. try:
  29. db_ex("select * from rd limit 1")
  30. except:
  31. db_ex("create table rd(title text, sub text, date text)")
  32. try:
  33. db_ex("select * from user limit 1")
  34. except:
  35. db_ex("create table user(id text, pw text, acl text)")
  36. try:
  37. db_ex("select * from ban limit 1")
  38. except:
  39. db_ex("create table ban(block text, end text, why text, band text)")
  40. try:
  41. db_ex("select * from topic limit 1")
  42. except:
  43. db_ex("create table topic(id text, title text, sub text, data longtext, date text, ip text, block text)")
  44. try:
  45. db_ex("select * from stop limit 1")
  46. except:
  47. db_ex("create table stop(title text, sub text, close text)")
  48. try:
  49. db_ex("select * from rb limit 1")
  50. except:
  51. db_ex("create table rb(block text, end text, today text, blocker text, why text)")
  52. try:
  53. db_ex("select * from login limit 1")
  54. except:
  55. db_ex("create table login(user text, ip text, today text)")
  56. try:
  57. db_ex("select * from back limit 1")
  58. except:
  59. db_ex("create table back(title text, link text, type text)")
  60. try:
  61. db_ex("select * from cat limit 1")
  62. except:
  63. db_ex("create table cat(title text, cat text)")
  64. try:
  65. db_ex("select * from hidhi limit 1")
  66. except:
  67. db_ex("create table hidhi(title text, re text)")
  68. try:
  69. db_ex("select * from distop limit 1")
  70. except:
  71. db_ex("create table distop(id text, title text, sub text)")
  72. try:
  73. db_ex("select * from agreedis limit 1")
  74. except:
  75. db_ex("create table agreedis(title text, sub text)")
  76. conn = pymysql.connect(host = set_data['host'], user = set_data['user'], password = set_data['pw'], charset = 'utf8mb4')
  77. curs = conn.cursor(pymysql.cursors.DictCursor)
  78. def redirect(data):
  79. return '<meta http-equiv="refresh" content="0;url=' + data + '" />'
  80. def db_com():
  81. conn.commit()
  82. def url_pas(data):
  83. return parse.quote(data).replace('/','%2F')
  84. def db_get():
  85. return curs.fetchall()
  86. web_render = render_template
  87. db_ex = curs.execute
  88. db_pas = pymysql.escape_string
  89. try:
  90. db_ex("use " + set_data['db'])
  91. except:
  92. db_ex("create database " + set_data['db'])
  93. db_ex("use " + set_data['db'])
  94. db_ex("alter database " + set_data['db'] + " character set = utf8mb4 collate = utf8mb4_unicode_ci")
  95. start()
  96. from func import *
  97. from mark import *
  98. app.secret_key = hashlib.sha512(bytes(set_data['key'], 'ascii')).hexdigest()
  99. @app.route('/upload', methods=['GET', 'POST'])
  100. def upload():
  101. app.config['MAX_CONTENT_LENGTH'] = int(set_data['upload']) * 1024 * 1024
  102. ip = ip_check()
  103. ban = ban_check(ip)
  104. if(request.method == 'POST'):
  105. if(ban == 1):
  106. return redirect('/ban')
  107. else:
  108. file = request.files['file']
  109. if(file):
  110. if(re.search('^([^./\\*<>|:?"]+)\.([Jj][Pp][Gg]|[Gg][Ii][Ff]|[Jj][Pp][Ee][Gg]|[Pp][Nn][Gg])$', file.filename)):
  111. filename = file.filename
  112. if(os.path.exists(os.path.join('image', filename))):
  113. return redirect('/error/16')
  114. else:
  115. file.save(os.path.join('image', filename))
  116. db_ex("insert into data (title, data, acl) value ('" + db_pas('파일:' + filename) + "', '" + db_pas('[[파일:' + filename + ']][br][br]{{{[[파일:' + filename + ']]}}}') + "', '')")
  117. db_com()
  118. history_plus('파일:' + filename, '[[파일:' + filename + ']][br][br]{{{[[파일:' + filename + ']]}}}', get_time(), ip, '파일:' + filename + ' 업로드', '0')
  119. return redirect('/w/' + url_pas('파일:' + filename))
  120. else:
  121. return redirect('/error/15')
  122. else:
  123. return redirect('/error/14')
  124. else:
  125. if(ban == 1):
  126. return redirect('/ban')
  127. else:
  128. return web_render('index.html', login = login_check(), logo = set_data['name'], title = '업로드', tn = 21, number = set_data['upload'])
  129. @app.route('/image/<path:name>')
  130. def image_get(name = None):
  131. if(os.path.exists(os.path.join('image', name))):
  132. return send_file(os.path.join('image', name), mimetype='image')
  133. else:
  134. return web_render('index.html', login = login_check(), logo = set_data['name'], data = '이미지 없음.', title = '이미지 보기'), 404
  135. @app.route('/acllist')
  136. def acl_list():
  137. data = ''
  138. i = 1
  139. db_ex("select title, acl from data where acl = 'admin' or acl = 'user' order by acl desc")
  140. list_data = db_get()
  141. if(list_data):
  142. while(True):
  143. try:
  144. a = list_data[i]
  145. except:
  146. break
  147. if(list_data[i]['acl'] == 'admin'):
  148. acl = '관리자'
  149. else:
  150. acl = '로그인'
  151. data = data + '<li>' + str(i) + '. <a href="/w/' + url_pas(list_data[i]['title']) + '">' + list_data[i]['title'] + '</a> (' + acl + ')</li>'
  152. i += 1
  153. data = data + '</div>'
  154. else:
  155. data = ''
  156. return web_render('index.html', login = login_check(), logo = set_data['name'], data = data, title = 'ACL 문서 목록')
  157. @app.route('/adminlist')
  158. def admin_list():
  159. i = 0
  160. div = '<div>'
  161. db_ex("select * from user where acl = 'admin' or acl = 'owner'")
  162. user_data = db_get()
  163. if(user_data):
  164. while(True):
  165. try:
  166. a = user_data[i]
  167. except:
  168. div = div + '</div>'
  169. break
  170. if(user_data[i]['acl'] == 'owner'):
  171. acl = '소유자'
  172. else:
  173. acl = '관리자'
  174. db_ex("select title from data where title = '사용자:" + user_data[i]['id'] + "'")
  175. user = db_get()
  176. if(user):
  177. name = '<a href="/w/' + url_pas('사용자:' + user_data[i]['id']) + '">' + user_data[i]['id'] + '</a> (' + acl + ')'
  178. else:
  179. name = '<a class="not_thing" href="/w/' + url_pas('사용자:' + user_data[i]['id']) + '">' + user_data[i]['id'] + '</a> (' + acl + ')'
  180. div = div + '<li>' + str(i + 1) + '. ' + name + '</li>'
  181. i += 1
  182. return web_render('index.html', login = login_check(), logo = set_data['name'], data = div, title = '관리자 목록')
  183. else:
  184. return web_render('index.html', login = login_check(), logo = set_data['name'], title = '관리자 목록')
  185. @app.route('/recentchanges')
  186. def recent_changes():
  187. i = 0
  188. div = '<div>'
  189. db_ex("select * from history order by date desc limit 50")
  190. rows = db_get()
  191. if(rows):
  192. while(True):
  193. try:
  194. a = rows[i]
  195. except:
  196. div = div + '</div>'
  197. break
  198. if(rows[i]['send']):
  199. send = rows[i]['send']
  200. send = re.sub('<a href="\/w\/(?P<in>[^"]*)">(?P<out>[^&]*)<\/a>', '<a href="/w/\g<in>">\g<out></a>', send)
  201. else:
  202. send = '<br>'
  203. title = rows[i]['title']
  204. title = re.sub('<', '&lt;', title)
  205. title = re.sub('>', '&gt;', title)
  206. m = re.search("\+", rows[i]['leng'])
  207. n = re.search("\-", rows[i]['leng'])
  208. if(m):
  209. leng = '<span style="color:green;">' + rows[i]['leng'] + '</span>'
  210. elif(n):
  211. leng = '<span style="color:red;">' + rows[i]['leng'] + '</span>'
  212. else:
  213. leng = '<span style="color:gray;">' + rows[i]['leng'] + '</span>'
  214. if(admin_check() == 1):
  215. db_ex("select * from ban where block = '" + db_pas(rows[i]['ip']) + "'")
  216. row = db_get()
  217. if(row):
  218. ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(해제)</a>'
  219. else:
  220. ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(차단)</a>'
  221. else:
  222. ban = ''
  223. if(re.search('\.', rows[i]['ip'])):
  224. ip = rows[i]['ip'] + ' <a href="/record/' + url_pas(rows[i]['ip']) + '/n/1">(기록)</a>'
  225. else:
  226. db_ex("select title from data where title = '사용자:" + db_pas(rows[i]['ip']) + "'")
  227. row = db_get()
  228. if(row):
  229. ip = '<a href="/w/' + url_pas('사용자:' + rows[i]['ip']) + '">' + rows[i]['ip'] + '</a> <a href="/record/' + url_pas(rows[i]['ip']) + '/n/1">(기록)</a>'
  230. else:
  231. ip = '<a class="not_thing" href="/w/' + url_pas('사용자:' + rows[i]['ip']) + '">' + rows[i]['ip'] + '</a> <a href="/record/' + url_pas(rows[i]['ip']) + '/n/1">(기록)</a>'
  232. if((int(rows[i]['id']) - 1) == 0):
  233. revert = ''
  234. else:
  235. revert = '<a href="/revert/' + url_pas(rows[i]['title']) + '/r/' + str(int(rows[i]['id']) - 1) + '">(되돌리기)</a>'
  236. div = div + '<table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;"><a href="/w/' + url_pas(rows[i]['title']) + '">' + title + '</a> <a href="/history/' + url_pas(rows[i]['title']) + '/n/1">(역사)</a> ' + revert + ' (' + leng + ')</td><td style="text-align: center;width:33.33%;">' + ip + ban + '</td><td style="text-align: center;width:33.33%;">' + rows[i]['date'] + '</td></tr><tr><td colspan="3" style="text-align: center;width:100%;">' + send + '</td></tr></tbody></table>'
  237. i += 1
  238. return web_render('index.html', login = login_check(), logo = set_data['name'], rows = div, tn = 3, title = '최근 변경내역')
  239. else:
  240. return web_render('index.html', login = login_check(), logo = set_data['name'], rows = '', tn = 3, title = '최근 변경내역')
  241. @app.route('/history/<path:name>/r/<int:num>/hidden')
  242. def history_hidden(name = None, num = None):
  243. if(owner_check() == 1):
  244. db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
  245. exist = db_get()
  246. if(exist):
  247. db_ex("delete from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
  248. else:
  249. db_ex("insert into hidhi (title, re) value ('" + db_pas(name) + "', '" + db_pas(str(num)) + "')")
  250. db_com()
  251. return redirect('/history/' + url_pas(name) + '/n/1')
  252. else:
  253. return redirect('/history/' + url_pas(name) + '/n/1')
  254. @app.route('/record/<path:name>/n/<int:num>')
  255. def user_record(name = None, num = None):
  256. v = num * 50
  257. i = v - 50
  258. div = '<div>'
  259. db_ex("select * from history where ip = '" + db_pas(name) + "' order by date desc")
  260. rows = db_get()
  261. if(rows):
  262. while(True):
  263. try:
  264. a = rows[i]
  265. except:
  266. div = div + '</div>'
  267. if(num != 1):
  268. div = div + '<br><a href="/record/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전)'
  269. break
  270. if(rows[i]['send']):
  271. send = rows[i]['send']
  272. send = re.sub('<a href="\/w\/(?P<in>[^"]*)">(?P<out>[^&]*)<\/a>', '<a href="/w/\g<in>">\g<out></a>', send)
  273. else:
  274. send = '<br>'
  275. title = rows[i]['title']
  276. title = re.sub('<', '&lt;', title)
  277. title = re.sub('>', '&gt;', title)
  278. m = re.search("\+", rows[i]['leng'])
  279. n = re.search("\-", rows[i]['leng'])
  280. if(m):
  281. leng = '<span style="color:green;">' + rows[i]['leng'] + '</span>'
  282. elif(n):
  283. leng = '<span style="color:red;">' + rows[i]['leng'] + '</span>'
  284. else:
  285. leng = '<span style="color:gray;">' + rows[i]['leng'] + '</span>'
  286. if(admin_check() == 1):
  287. db_ex("select * from ban where block = '" + db_pas(rows[i]['ip']) + "'")
  288. row = db_get()
  289. if(row):
  290. ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(해제)</a>'
  291. else:
  292. ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(차단)</a>'
  293. else:
  294. ban = ''
  295. if(re.search('\.', rows[i]['ip'])):
  296. ip = rows[i]['ip']
  297. else:
  298. db_ex("select title from data where title = '사용자:" + db_pas(rows[i]['ip']) + "'")
  299. row = db_get()
  300. if(row):
  301. ip = '<a href="/w/' + url_pas('사용자:' + rows[i]['ip']) + '">' + rows[i]['ip'] + '</a>'
  302. else:
  303. ip = '<a class="not_thing" href="/w/' + url_pas('사용자:' + rows[i]['ip']) + '">' + rows[i]['ip'] + '</a>'
  304. if((int(rows[i]['id']) - 1) == 0):
  305. revert = ''
  306. else:
  307. revert = '<a href="/revert/' + url_pas(rows[i]['title']) + '/r/' + str(int(rows[i]['id']) - 1) + '">(되돌리기)</a>'
  308. div = div + '<table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;"><a href="/w/' + url_pas(rows[i]['title']) + '">' + title + '</a> (' + rows[i]['id'] + '판) <a href="/history/' + url_pas(rows[i]['title']) + '/n/1">(역사)</a> ' + revert + ' (' + leng + ')</td><td style="text-align: center;width:33.33%;">' + ip + ban + '</td><td style="text-align: center;width:33.33%;">' + rows[i]['date'] + '</td></tr><tr><td colspan="3" style="text-align: center;width:100%;">' + send + '</td></tr></tbody></table>'
  309. if(i == v):
  310. div = div + '</div>'
  311. if(num == 1):
  312. div = div + '<br><a href="/record/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)'
  313. else:
  314. div = div + '<br><a href="/record/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전) <a href="/record/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)'
  315. break
  316. i += 1
  317. return web_render('index.html', login = login_check(), logo = set_data['name'], rows = div, tn = 3, title = '사용자 기록')
  318. else:
  319. return web_render('index.html', login = login_check(), logo = set_data['name'], rows = '', tn = 3, title = '사용자 기록')
  320. @app.route('/userlog/n/<int:number>')
  321. def user_log(number = None):
  322. i = number * 50
  323. j = i - 50
  324. list = ''
  325. db_ex("select * from user")
  326. user_list = db_get()
  327. if(user_list):
  328. while(True):
  329. try:
  330. a = user_list[j]
  331. except:
  332. if(number != 1):
  333. list = list + '<br><a href="/userlog/n/' + str(number - 1) + '">(이전)'
  334. break
  335. if(admin_check() == 1):
  336. db_ex("select * from ban where block = '" + db_pas(user_list[j]['id']) + "'")
  337. ban_exist = db_get()
  338. if(ban_exist):
  339. ban_button = ' <a href="/ban/' + url_pas(user_list[j]['id']) + '">(해제)</a>'
  340. else:
  341. ban_button = ' <a href="/ban/' + url_pas(user_list[j]['id']) + '">(차단)</a>'
  342. else:
  343. ban_button = ''
  344. db_ex("select title from data where title = '사용자:" + db_pas(user_list[j]['id']) + "'")
  345. data = db_get()
  346. if(data):
  347. ip = '<a href="/w/' + url_pas('사용자:' + user_list[j]['id']) + '">' + user_list[j]['id'] + '</a> <a href="/record/' + url_pas(user_list[j]['id']) + '/n/1">(기록)</a>'
  348. else:
  349. ip = '<a class="not_thing" href="/w/' + url_pas('사용자:' + user_list[j]['id']) + '">' + user_list[j]['id'] + '</a> <a href="/record/' + url_pas(user_list[j]['id']) + '/n/1">(기록)</a>'
  350. list = list + '<li>' + str(j + 1) + '. ' + ip + ban_button + '</li>'
  351. if(j == i):
  352. if(number == 1):
  353. list = list + '<br><a href="/userlog/n/' + str(number + 1) + '">(다음)'
  354. else:
  355. list = list + '<br><a href="/userlog/n/' + str(number - 1) + '">(이전) <a href="/userlog/n/' + str(number + 1) + '">(다음)'
  356. break
  357. else:
  358. j += 1
  359. return web_render('index.html', login = login_check(), logo = set_data['name'], data = list, title = '사용자 가입 기록')
  360. else:
  361. return web_render('index.html', login = login_check(), logo = set_data['name'], data = '', title = '사용자 가입 기록')
  362. @app.route('/backreset')
  363. def backlink_reset():
  364. if(owner_check() == 1):
  365. i = 0
  366. db_ex("delete from back")
  367. db_com()
  368. db_ex("select * from data")
  369. all = db_get()
  370. if(all):
  371. while(True):
  372. try:
  373. a = all[i]
  374. except:
  375. break
  376. namumark(all[i]['title'], all[i]['data'])
  377. i += 1
  378. return web_render('index.html', login = login_check(), logo = set_data['name'], data = '에러 없음', title = '완료')
  379. else:
  380. return redirect('/error/3')
  381. @app.route('/backlink/<path:name>/n/<int:num>')
  382. def backlink(name = None, num = None):
  383. v = num * 50
  384. i = v - 50
  385. div = ''
  386. restart = 0
  387. db_ex("delete from back where title = '" + db_pas(name) + "' and link = ''")
  388. db_com()
  389. db_ex("select * from back where title = '" + db_pas(name) + "' order by link asc")
  390. rows = db_get()
  391. if(rows):
  392. while(True):
  393. try:
  394. a = rows[i]
  395. except:
  396. if(num != 1):
  397. div = div + '<br><a href="/backlink/n/' + str(num - 1) + '">(이전)'
  398. break
  399. if(rows[i]['type'] == 'include' or rows[i]['type'] == 'file'):
  400. db_ex("select * from back where title = '" + db_pas(name) + "' and link = '" + db_pas(rows[i]['link']) + "' and type = ''")
  401. test = db_get()
  402. if(test):
  403. restart = 1
  404. db_ex("delete from back where title = '" + db_pas(name) + "' and link = '" + db_pas(rows[i]['link']) + "' and type = ''")
  405. db_com()
  406. if(not re.search('^사용자:', rows[i]['link'])):
  407. db_ex("select * from data where title = '" + db_pas(rows[i]['link']) + "'")
  408. row = db_get()
  409. if(row):
  410. data = row[0]['data']
  411. data = re.sub("(?P<in>\[include\((?P<out>(?:(?!\)\]|,).)*)((?:,\s?(?:[^)]*))+)?\)\])", "\g<in>\n\n[[\g<out>]]\n\n", data)
  412. data = re.sub("\[\[파일:(?P<in>(?:(?!\]\]|\|).)*)(?:\|((?:(?!\]\]).)*))?\]\]", "\n\n[[:파일:\g<in>]]\n\n", data)
  413. data = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', '[[\g<in>]]', data)
  414. data = namumark('', data)
  415. if(re.search("<a(?:(?:(?!href=).)*)?href=\"\/w\/" + url_pas(name) + "(?:\#[^\"]*)?\"(?:(?:(?!>).)*)?>([^<]*)<\/a>", data)):
  416. div = div + '<li><a href="/w/' + url_pas(rows[i]['link']) + '">' + rows[i]['link'] + '</a>'
  417. if(rows[i]['type']):
  418. div = div + ' (' + rows[i]['type'] + ')</li>'
  419. else:
  420. div = div + '</li>'
  421. if(i == v):
  422. if(num == 1):
  423. div = div + '<br><a href="/backlink/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)'
  424. else:
  425. div = div + '<br><a href="/backlink/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전) <a href="/backlink/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)'
  426. break
  427. else:
  428. i += 1
  429. else:
  430. db_ex("delete from back where title = '" + db_pas(name) + "' and link = '" + db_pas(rows[i]['link']) + "'")
  431. db_com()
  432. i += 1
  433. v += 1
  434. else:
  435. db_ex("delete from back where title = '" + db_pas(name) + "' and link = '" + db_pas(rows[i]['link']) + "'")
  436. db_com()
  437. i += 1
  438. v += 1
  439. else:
  440. db_ex("delete from back where title = '" + db_pas(name) + "' and link = '" + db_pas(rows[i]['link']) + "'")
  441. db_com()
  442. i += 1
  443. v += 1
  444. if(restart == 1):
  445. return redirect('/backlink/' + url_pas(name) + '/n/' + str(num))
  446. else:
  447. return web_render('index.html', login = login_check(), logo = set_data['name'], data = div, title = name, page = url_pas(name), sub = '역링크')
  448. else:
  449. return web_render('index.html', login = login_check(), logo = set_data['name'], data = '', title = name, page = url_pas(name), sub = '역링크')
  450. @app.route('/recentdiscuss')
  451. def recent_discuss():
  452. i = 0
  453. div = '<div>'
  454. db_ex("select * from rd order by date desc limit 50")
  455. rows = db_get()
  456. if(rows):
  457. while(True):
  458. try:
  459. a = rows[i]
  460. except:
  461. div = div + '</div>'
  462. break
  463. title = rows[i]['title']
  464. title = re.sub('<', '&lt;', title)
  465. title = re.sub('>', '&gt;', title)
  466. sub = rows[i]['sub']
  467. sub = re.sub('<', '&lt;', sub)
  468. sub = re.sub('>', '&gt;', sub)
  469. div = div + '<table style="width: 100%;"><tbody><tr><td style="text-align: center;width:50%;"><a href="/topic/' + url_pas(rows[i]['title']) + '/sub/' + url_pas(rows[i]['sub']) + '">' + title + '</a> (' + sub + ')</td><td style="text-align: center;width:50%;">' + rows[i]['date'] + '</td></tr></tbody></table>'
  470. i += 1
  471. return web_render('index.html', login = login_check(), logo = set_data['name'], rows = div, tn = 12, title = '최근 토론내역')
  472. else:
  473. return web_render('index.html', login = login_check(), logo = set_data['name'], rows = '', tn = 12, title = '최근 토론내역')
  474. @app.route('/blocklog/n/<int:number>')
  475. def blocklog(number = None):
  476. v = number * 50
  477. i = v - 50
  478. div = '<div>'
  479. db_ex("select * from rb order by today desc")
  480. rows = db_get()
  481. if(rows):
  482. while(True):
  483. try:
  484. a = rows[i]
  485. except:
  486. div = div + '</div>'
  487. if(number != 1):
  488. div = div + '<br><a href="/blocklog/n/' + str(number - 1) + '">(이전)'
  489. break
  490. why = rows[i]['why']
  491. why = re.sub('<', '&lt;', why)
  492. why = re.sub('>', '&gt;', why)
  493. b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))$", rows[i]['block'])
  494. if(b):
  495. ip = rows[i]['block'] + ' (대역)'
  496. else:
  497. ip = rows[i]['block']
  498. div = div + '<table style="width: 100%;"><tbody><tr><td style="text-align: center;width:20%;">' + ip + '</a></td><td style="text-align: center;width:20%;">' + rows[i]['blocker'] + '</td><td style="text-align: center;width:20%;">' + rows[i]['end'] + '</td><td style="text-align: center;width:20%;">' + rows[i]['why'] + '</td><td style="text-align: center;width:20%;">' + rows[i]['today'] + '</td></tr></tbody></table>'
  499. if(i == v):
  500. div = div + '</div>'
  501. if(number == 1):
  502. div = div + '<br><a href="/blocklog/n/' + str(number + 1) + '">(다음)'
  503. else:
  504. div = div + '<br><a href="/blocklog/n/' + str(number - 1) + '">(이전) <a href="/blocklog/n/' + str(number + 1) + '">(다음)'
  505. break
  506. else:
  507. i += 1
  508. return web_render('index.html', login = login_check(), logo = set_data['name'], rows = div, tn = 20, title = '사용자 차단 기록')
  509. else:
  510. return web_render('index.html', login = login_check(), logo = set_data['name'], rows = '', tn = 20, title = '사용자 차단 기록')
  511. @app.route('/history/<path:name>/n/<int:num>', methods=['POST', 'GET'])
  512. def history_view(name = None, num = None):
  513. if(request.method == 'POST'):
  514. return redirect('/w/' + url_pas(name) + '/r/' + request.form["b"] + '/diff/' + request.form["a"])
  515. else:
  516. select = ''
  517. v = num * 50
  518. i = v - 50
  519. div = '<div>'
  520. db_ex("select send, leng, ip, date, title, id from history where title = '" + db_pas(name) + "' order by id + 0 desc")
  521. rows = db_get()
  522. if(rows):
  523. while(True):
  524. style = ''
  525. try:
  526. a = rows[i]
  527. except:
  528. div = div + '</div>'
  529. if(num != 1):
  530. div = div + '<br><a href="/history/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전)'
  531. break
  532. select = '<option value="' + str(i + 1) + '">' + str(i + 1) + '</option>' + select
  533. if(rows[i]['send']):
  534. send = rows[i]['send']
  535. send = re.sub('<a href="\/w\/(?P<in>[^"]*)">(?P<out>[^&]*)<\/a>', '<a href="/w/\g<in>">\g<out></a>', send)
  536. else:
  537. send = '<br>'
  538. m = re.search("\+", rows[i]['leng'])
  539. n = re.search("\-", rows[i]['leng'])
  540. if(m):
  541. leng = '<span style="color:green;">' + rows[i]['leng'] + '</span>'
  542. elif(n):
  543. leng = '<span style="color:red;">' + rows[i]['leng'] + '</span>'
  544. else:
  545. leng = '<span style="color:gray;">' + rows[i]['leng'] + '</span>'
  546. if(re.search("\.", rows[i]["ip"])):
  547. ip = rows[i]["ip"] + ' <a href="/record/' + url_pas(rows[i]["ip"]) + '/n/1">(기록)</a>'
  548. else:
  549. db_ex("select title from data where title = '사용자:" + db_pas(rows[i]['ip']) + "'")
  550. row = db_get()
  551. if(row):
  552. ip = '<a href="/w/' + url_pas('사용자:' + rows[i]['ip']) + '">' + rows[i]['ip'] + '</a> <a href="/record/' + url_pas(rows[i]["ip"]) + '/n/1">(기록)</a>'
  553. else:
  554. ip = '<a class="not_thing" href="/w/' + url_pas('사용자:' + rows[i]['ip']) + '">' + rows[i]['ip'] + '</a> <a href="/record/' + url_pas(rows[i]["ip"]) + '/n/1">(기록)</a>'
  555. if(admin_check() == 1):
  556. db_ex("select * from user where id = '" + db_pas(rows[i]['ip']) + "'")
  557. row = db_get()
  558. if(row):
  559. if(row[0]['acl'] == 'owner' or row[0]['acl'] == 'admin'):
  560. ban = ''
  561. else:
  562. db_ex("select * from ban where block = '" + db_pas(rows[i]['ip']) + "'")
  563. row = db_get()
  564. if(row):
  565. ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(해제)</a>'
  566. else:
  567. ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(차단)</a>'
  568. else:
  569. db_ex("select * from ban where block = '" + db_pas(rows[i]['ip']) + "'")
  570. row = db_get()
  571. if(row):
  572. ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(해제)</a>'
  573. else:
  574. ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(차단)</a>'
  575. if(owner_check() == 1):
  576. db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(rows[i]['id']) + "'")
  577. row = db_get()
  578. if(row):
  579. ip = ip + ' (숨김)'
  580. hidden = ' <a href="/history/' + url_pas(name) + '/r/' + rows[i]['id'] + '/hidden">(공개)'
  581. else:
  582. hidden = ' <a href="/history/' + url_pas(name) + '/r/' + rows[i]['id'] + '/hidden">(숨김)'
  583. else:
  584. db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(rows[i]['id']) + "'")
  585. row = db_get()
  586. if(row):
  587. ip = '숨김'
  588. hidden = ''
  589. send = '숨김'
  590. ban = ''
  591. style = 'display:none;'
  592. v += 1
  593. else:
  594. hidden = ''
  595. else:
  596. ban = ''
  597. db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(rows[i]['id']) + "'")
  598. row = db_get()
  599. if(row):
  600. ip = '숨김'
  601. hidden = ''
  602. send = '숨김'
  603. ban = ''
  604. style = 'display:none;'
  605. v += 1
  606. else:
  607. hidden = ''
  608. div = div + '<table style="width: 100%;' + style + '"><tbody><tr><td style="text-align: center;width:33.33%;">' + rows[i]['id'] + '판</a> <a href="/w/' + url_pas(rows[i]['title']) + '/r/' + rows[i]['id'] + '">(w)</a> <a href="/w/' + url_pas(rows[i]['title']) + '/raw/' + rows[i]['id'] + '">(Raw)</a> <a href="/revert/' + url_pas(rows[i]['title']) + '/r/' + rows[i]['id'] + '">(되돌리기)</a> (' + leng + ')</td><td style="text-align: center;width:33.33%;">' + ip + ban + hidden + '</td><td style="text-align: center;width:33.33%;">' + rows[i]['date'] + '</td></tr><tr><td colspan="3" style="text-align: center;width:100%;">' + send + '</td></tr></tbody></table>'
  609. if(i == v):
  610. div = div + '</div>'
  611. if(num == 1):
  612. div = div + '<br><a href="/history/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)'
  613. else:
  614. div = div + '<br><a href="/history/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전) <a href="/history/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)'
  615. break
  616. else:
  617. i += 1
  618. return web_render('index.html', login = login_check(), logo = set_data['name'], rows = div, tn = 5, title = name, page = url_pas(name), select = select, sub = '역사')
  619. else:
  620. return web_render('index.html', login = login_check(), logo = set_data['name'], rows = '', tn = 5, title = name, page = url_pas(name), select = select, sub = '역사')
  621. @app.route('/search', methods=['POST'])
  622. def search():
  623. return redirect('/search/' + url_pas(request.form["search"]) + '/n/1')
  624. @app.route('/goto', methods=['POST'])
  625. def goto():
  626. db_ex("select title from data where title = '" + db_pas(request.form["search"]) + "'")
  627. data = db_get()
  628. if(data):
  629. return redirect('/w/' + url_pas(request.form["search"]))
  630. else:
  631. return redirect('/search/' + url_pas(request.form["search"]) + '/n/1')
  632. @app.route('/search/<path:name>/n/<int:num>')
  633. def deep_search(name = None, num = None):
  634. v = num * 50
  635. i = v - 50
  636. div = ''
  637. div_plus = ''
  638. end = ''
  639. db_ex("select title from data where title like '%" + db_pas(name) + "%'")
  640. title_list = db_get()
  641. db_ex("select title from data where data like '%" + db_pas(name) + "%'")
  642. data_list = db_get()
  643. db_ex("select title from data where title = '" + db_pas(name) + "'")
  644. exist = db_get()
  645. if(exist):
  646. div = '<li>문서로 <a href="/w/' + url_pas(name) + '">바로가기</a></li><br>'
  647. else:
  648. div = '<li>문서가 없습니다. <a class="not_thing" href="/w/' + url_pas(name) + '">바로가기</a></li><br>'
  649. if(title_list):
  650. no = 0
  651. if(data_list):
  652. all_list = title_list + data_list
  653. else:
  654. all_list = title_list
  655. else:
  656. if(data_list):
  657. no = 1
  658. all_list = data_list
  659. else:
  660. all_list = ''
  661. if(not all_list == ''):
  662. while(True):
  663. try:
  664. re_title = re.compile(name, re.I)
  665. if(re.search(re_title, all_list[i]['title'])):
  666. if(no == 0):
  667. div = div + '<li><a href="/w/' + url_pas(all_list[i]['title']) + '">' + all_list[i]['title'] + '</a> (문서명)</li>'
  668. else:
  669. div_plus = div_plus + '<li><a href="/w/' + url_pas(all_list[i]['title']) + '">' + all_list[i]['title'] + '</a> (내용)</li>'
  670. else:
  671. no = 1
  672. div_plus = div_plus + '<li><a href="/w/' + url_pas(all_list[i]['title']) + '">' + all_list[i]['title'] + '</a> (내용)</li>'
  673. except:
  674. if(num != 1):
  675. end = '<br><a href="/search/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전)'
  676. break
  677. if(i == v):
  678. if(num == 1):
  679. end = '<br><a href="/search/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)'
  680. else:
  681. end = '<br><a href="/search/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전) <a href="/search/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)'
  682. break
  683. else:
  684. i += 1
  685. else:
  686. div = div + '<li>검색 결과 없음</li>'
  687. div = div + div_plus + end
  688. return web_render('index.html', login = login_check(), logo = set_data['name'], data = div, title = name, sub = '검색')
  689. @app.route('/w/<path:name>')
  690. @app.route('/w/<path:name>/from/<path:redirect>')
  691. def read_view(name = None, redirect = None):
  692. i = 0
  693. db_ex("select * from rd where title = '" + db_pas(name) + "' order by date asc")
  694. rows = db_get()
  695. while(True):
  696. try:
  697. a = rows[i]
  698. except:
  699. topic = ""
  700. break
  701. db_ex("select * from stop where title = '" + db_pas(rows[i]['title']) + "' and sub = '" + db_pas(rows[i]['sub']) + "' and close = 'O'")
  702. row = db_get()
  703. if(not row):
  704. topic = "open"
  705. break
  706. else:
  707. i += 1
  708. acl = ''
  709. m = re.search("^(.*)\/(.*)$", name)
  710. if(m):
  711. g = m.groups()
  712. uppage = g[0]
  713. style = ""
  714. else:
  715. uppage = ""
  716. style = "display:none;"
  717. if(admin_check() == 1):
  718. admin_memu = 'ACL'
  719. else:
  720. admin_memu = ''
  721. if(re.search("^분류:", name)):
  722. db_ex("select * from cat where title = '" + db_pas(name) + "' order by cat asc")
  723. rows = db_get()
  724. if(rows):
  725. div = ''
  726. i = 0
  727. while(True):
  728. try:
  729. a = rows[i]
  730. except:
  731. break
  732. db_ex("select * from data where title = '" + db_pas(rows[i]['cat']) + "'")
  733. row = db_get()
  734. if(row):
  735. aa = row[0]['data']
  736. aa = namumark('', aa)
  737. bb = re.search('<div style="width:100%;border: 1px solid #777;padding: 5px;margin-top: 1em;">분류:((?:(?!<\/div>).)*)<\/div>', aa)
  738. if(bb):
  739. cc = bb.groups()
  740. mm = re.search("^분류:(.*)", name)
  741. if(mm):
  742. ee = mm.groups()
  743. if(re.search("<a (class=\"not_thing\")? href=\"\/w\/" + url_pas(name) + "\">" + ee[0] + "<\/a>", cc[0])):
  744. div = div + '<li><a href="/w/' + url_pas(rows[i]['cat']) + '">' + rows[i]['cat'] + '</a></li>'
  745. i += 1
  746. else:
  747. db_ex("delete from cat where title = '" + db_pas(name) + "' and cat = '" + db_pas(rows[i]['cat']) + "'")
  748. db_com()
  749. i += 1
  750. else:
  751. db_ex("delete from cat where title = '" + db_pas(name) + "' and cat = '" + db_pas(rows[i]['cat']) + "'")
  752. db_com()
  753. i += 1
  754. else:
  755. db_ex("delete from cat where title = '" + db_pas(name) + "' and cat = '" + db_pas(rows[i]['cat']) + "'")
  756. db_com()
  757. i += 1
  758. else:
  759. db_ex("delete from cat where title = '" + db_pas(name) + "' and cat = '" + db_pas(rows[i]['cat']) + "'")
  760. db_com()
  761. i += 1
  762. div = '<h2>분류</h2>' + div
  763. else:
  764. div = ''
  765. else:
  766. div = ''
  767. db_ex("select * from data where title = '" + db_pas(name) + "'")
  768. rows = db_get()
  769. if(rows):
  770. if(rows[0]['acl'] == 'admin'):
  771. acl = '(관리자)'
  772. elif(rows[0]['acl'] == 'user'):
  773. acl = '(로그인)'
  774. else:
  775. if(not acl):
  776. acl = ''
  777. m = re.search("^사용자:(.*)", name)
  778. if(m):
  779. g = m.groups()
  780. db_ex("select * from user where id = '" + db_pas(g[0]) + "'")
  781. test = db_get()
  782. if(test):
  783. if(test[0]['acl'] == 'owner'):
  784. acl = '(소유자)'
  785. elif(test[0]['acl'] == 'admin'):
  786. acl = '(관리자)'
  787. db_ex("select * from ban where block = '" + db_pas(g[0]) + "'")
  788. user = db_get()
  789. if(user):
  790. elsedata = '{{{#!wiki style="border:2px solid red;padding:10px;"\r\n{{{+2 {{{#red 이 사용자는 차단 당했습니다.}}}}}}\r\n\r\n차단 해제 일 : ' + user[0]['end'] + '[br]사유 : ' + user[0]['why'] + '}}}[br]' + rows[0]['data']
  791. else:
  792. elsedata = rows[0]['data']
  793. else:
  794. elsedata = rows[0]['data']
  795. if(redirect):
  796. elsedata = re.sub("^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)", " * [[\g<in>]] 문서로 넘겨주기", elsedata)
  797. enddata = namumark(name, elsedata)
  798. m = re.search('<div id="toc">((?:(?!\/div>).)*)<\/div>', enddata)
  799. if(m):
  800. result = m.groups()
  801. left = result[0]
  802. else:
  803. left = ''
  804. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = enddata + div, license = set_data['license'], tn = 1, acl = acl, left = left, uppage = uppage, style = style, topic = topic, redirect = redirect, admin = admin_memu)
  805. else:
  806. m = re.search("^사용자:(.*)", name)
  807. if(m):
  808. g = m.groups()
  809. db_ex("select * from ban where block = '" + db_pas(g[0]) + "'")
  810. user = db_get()
  811. if(user):
  812. elsedata = '{{{#!wiki style="border:2px solid red;padding:10px;"\r\n{{{+2 {{{#red 이 사용자는 차단 당했습니다.}}}}}}\r\n\r\n차단 해제 일 : ' + user[0]['end'] + '[br]사유 : ' + user[0]['why'] + '}}}[br]' + '문서 없음'
  813. else:
  814. elsedata = '문서 없음'
  815. else:
  816. elsedata = '문서 없음'
  817. if(redirect):
  818. elsedata = re.sub("^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)", " * [[\g<in>]] 문서로 넘겨주기", elsedata)
  819. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = namumark(name, elsedata) + div, license = set_data['license'], tn = 1, uppage = uppage, style = style, acl = acl, topic = topic, redirect = redirect, admin = admin_memu), 404
  820. @app.route('/w/<path:name>/r/<int:num>')
  821. def old_view(name = None, num = None):
  822. db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
  823. row = db_get()
  824. if(row):
  825. if(owner_check() == 1):
  826. db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
  827. rows = db_get()
  828. if(rows):
  829. enddata = namumark(name, rows[0]['data'])
  830. m = re.search('<div id="toc">((?:(?!\/div>).)*)<\/div>', enddata)
  831. if(m):
  832. result = m.groups()
  833. left = result[0]
  834. else:
  835. left = ''
  836. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, tn = 6, left = left, sub = '옛 문서')
  837. else:
  838. return redirect('/history/' + url_pas(name))
  839. else:
  840. return redirect('/error/3')
  841. else:
  842. db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
  843. rows = db_get()
  844. if(rows):
  845. enddata = namumark(name, rows[0]['data'])
  846. m = re.search('<div id="toc">((?:(?!\/div>).)*)<\/div>', enddata)
  847. if(m):
  848. result = m.groups()
  849. left = result[0]
  850. else:
  851. left = ''
  852. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, tn = 6, left = left, sub = '옛 문서')
  853. else:
  854. return redirect('/history/' + url_pas(name))
  855. @app.route('/w/<path:name>/raw/<int:num>')
  856. def old_raw(name = None, num = None):
  857. db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
  858. row = db_get()
  859. if(row):
  860. if(owner_check() == 1):
  861. db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
  862. rows = db_get()
  863. if(rows):
  864. enddata = re.sub('<', '&lt;', rows[0]['data'])
  865. enddata = re.sub('>', '&gt;', enddata)
  866. enddata = re.sub('"', '&quot;', enddata)
  867. enddata = '<pre>' + enddata + '</pre>'
  868. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, sub = '옛 Raw')
  869. else:
  870. return redirect('/history/' + url_pas(name))
  871. else:
  872. return redirect('/error/3')
  873. else:
  874. db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
  875. rows = db_get()
  876. if(rows):
  877. enddata = re.sub('<', '&lt;', rows[0]['data'])
  878. enddata = re.sub('>', '&gt;', enddata)
  879. enddata = re.sub('"', '&quot;', enddata)
  880. enddata = '<pre>' + enddata + '</pre>'
  881. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, sub = '옛 Raw')
  882. else:
  883. return redirect('/history/' + url_pas(name))
  884. @app.route('/raw/<path:name>')
  885. def raw_view(name = None):
  886. db_ex("select * from data where title = '" + db_pas(name) + "'")
  887. rows = db_get()
  888. if(rows):
  889. enddata = re.sub('<', '&lt;', rows[0]['data'])
  890. enddata = re.sub('>', '&gt;', enddata)
  891. enddata = re.sub('"', '&quot;', enddata)
  892. enddata = '<pre>' + enddata + '</pre>'
  893. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, tn = 7, sub = 'Raw')
  894. else:
  895. return redirect('/w/' + url_pas(name))
  896. @app.route('/revert/<path:name>/r/<int:num>', methods=['POST', 'GET'])
  897. def revert(name = None, num = None):
  898. ip = ip_check()
  899. can = acl_check(ip, name)
  900. today = get_time()
  901. if(request.method == 'POST'):
  902. db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
  903. row = db_get()
  904. if(row):
  905. if(owner_check() == 1):
  906. db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
  907. rows = db_get()
  908. if(rows):
  909. if(can == 1):
  910. return redirect('/ban')
  911. else:
  912. db_ex("select * from data where title = '" + db_pas(name) + "'")
  913. row = db_get()
  914. if(row):
  915. leng = leng_check(len(row[0]['data']), len(rows[0]['data']))
  916. db_ex("update data set data = '" + db_pas(rows[0]['data']) + "' where title = '" + db_pas(name) + "'")
  917. db_com()
  918. else:
  919. leng = '+' + str(len(rows[0]['data']))
  920. db_ex("insert into data (title, data, acl) value ('" + db_pas(name) + "', '" + db_pas(rows[0]['data']) + "', '')")
  921. db_com()
  922. history_plus(name, rows[0]['data'], today, ip, '문서를 ' + str(num) + '판으로 되돌렸습니다.', leng)
  923. return redirect('/w/' + url_pas(name))
  924. else:
  925. return redirect('/w/' + url_pas(name))
  926. else:
  927. return redirect('/error/3')
  928. else:
  929. db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
  930. rows = db_get()
  931. if(rows):
  932. if(can == 1):
  933. return redirect('/ban')
  934. else:
  935. db_ex("select * from data where title = '" + db_pas(name) + "'")
  936. row = db_get()
  937. if(row):
  938. leng = leng_check(len(row[0]['data']), len(rows[0]['data']))
  939. db_ex("update data set data = '" + db_pas(rows[0]['data']) + "' where title = '" + db_pas(name) + "'")
  940. db_com()
  941. else:
  942. leng = '+' + str(len(rows[0]['data']))
  943. db_ex("insert into data (title, data, acl) value ('" + db_pas(name) + "', '" + db_pas(rows[0]['data']) + "', '')")
  944. db_com()
  945. history_plus(name, rows[0]['data'], today, ip, '문서를 ' + str(num) + '판으로 되돌렸습니다.', leng)
  946. return redirect('/w/' + url_pas(name))
  947. else:
  948. return redirect('/w/' + url_pas(name))
  949. else:
  950. db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
  951. row = db_get()
  952. if(row):
  953. if(owner_check() == 1):
  954. if(can == 1):
  955. return redirect('/ban')
  956. else:
  957. db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
  958. rows = db_get()
  959. if(rows):
  960. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), r = url_pas(str(num)), tn = 13, plus = '정말 되돌리시겠습니까?', sub = '되돌리기')
  961. else:
  962. return redirect('/w/' + url_pas(name))
  963. else:
  964. return redirect('/error/3')
  965. else:
  966. if(can == 1):
  967. return redirect('/ban')
  968. else:
  969. db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
  970. rows = db_get()
  971. if(rows):
  972. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), r = url_pas(str(num)), tn = 13, plus = '정말 되돌리시겠습니까?', sub = '되돌리기')
  973. else:
  974. return redirect('/w/' + url_pas(name))
  975. @app.route('/edit/<path:name>', methods=['POST', 'GET'])
  976. def edit(name = None):
  977. ip = ip_check()
  978. can = acl_check(ip, name)
  979. if(request.method == 'POST'):
  980. m = re.search('(?:[^A-Za-zㄱ-힣0-9 ])', request.form["send"])
  981. if(m):
  982. return redirect('/error/17')
  983. else:
  984. today = get_time()
  985. content = savemark(request.form["content"])
  986. db_ex("select * from data where title = '" + db_pas(name) + "'")
  987. rows = db_get()
  988. if(rows):
  989. if(rows[0]['data'] == content):
  990. return redirect('/error/18')
  991. else:
  992. if(can == 1):
  993. return redirect('/ban')
  994. else:
  995. leng = leng_check(len(rows[0]['data']), len(content))
  996. history_plus(name, content, today, ip, request.form["send"], leng)
  997. db_ex("update data set data = '" + db_pas(content) + "' where title = '" + db_pas(name) + "'")
  998. db_com()
  999. else:
  1000. if(can == 1):
  1001. return redirect('/ban')
  1002. else:
  1003. leng = '+' + str(len(content))
  1004. history_plus(name, content, today, ip, request.form["send"], leng)
  1005. db_ex("insert into data (title, data, acl) value ('" + db_pas(name) + "', '" + db_pas(content) + "', '')")
  1006. db_com()
  1007. include_check(name, content)
  1008. return redirect('/w/' + url_pas(name))
  1009. else:
  1010. if(can == 1):
  1011. return redirect('/ban')
  1012. else:
  1013. db_ex("select * from data where title = '" + db_pas(set_data["help"]) + "'")
  1014. rows = db_get()
  1015. if(rows):
  1016. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * [[\g<in>]] 문서로 넘겨주기', rows[0]["data"])
  1017. left = namumark(name, newdata)
  1018. else:
  1019. left = ''
  1020. db_ex("select * from data where title = '" + db_pas(name) + "'")
  1021. rows = db_get()
  1022. if(rows):
  1023. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = rows[0]['data'], tn = 2, left = left, sub = '편집')
  1024. else:
  1025. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = '', tn = 2, left = left, sub = '편집')
  1026. @app.route('/edit/<path:name>/section/<int:num>', methods=['POST', 'GET'])
  1027. def section_edit(name = None, num = None):
  1028. ip = ip_check()
  1029. can = acl_check(ip, name)
  1030. if(request.method == 'POST'):
  1031. m = re.search('(?:[^A-Za-zㄱ-힣0-9 ])', request.form["send"])
  1032. if(m):
  1033. return redirect('/error/17')
  1034. else:
  1035. today = get_time()
  1036. content = savemark(request.form["content"])
  1037. db_ex("select * from data where title = '" + db_pas(name) + "'")
  1038. rows = db_get()
  1039. if(rows):
  1040. if(request.form["otent"] == content):
  1041. return redirect('/error/18')
  1042. else:
  1043. if(can == 1):
  1044. return redirect('/ban')
  1045. else:
  1046. leng = leng_check(len(request.form['otent']), len(content))
  1047. content = rows[0]['data'].replace(request.form['otent'], content)
  1048. history_plus(name, content, today, ip, request.form["send"], leng)
  1049. db_ex("update data set data = '" + db_pas(content) + "' where title = '" + db_pas(name) + "'")
  1050. db_com()
  1051. include_check(name, content)
  1052. return redirect('/w/' + url_pas(name))
  1053. else:
  1054. return redirect('/w/' + url_pas(name))
  1055. else:
  1056. if(can == 1):
  1057. return redirect('/ban')
  1058. else:
  1059. db_ex("select * from data where title = '" + db_pas(set_data["help"]) + "'")
  1060. rows = db_get()
  1061. if(rows):
  1062. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * [[\g<in>]] 문서로 넘겨주기', rows[0]["data"])
  1063. left = namumark(name, newdata)
  1064. else:
  1065. left = ''
  1066. db_ex("select * from data where title = '" + db_pas(name) + "'")
  1067. rows = db_get()
  1068. if(rows):
  1069. i = 0
  1070. j = 0
  1071. gdata = rows[0]['data'] + '\r\n'
  1072. while(True):
  1073. m = re.search("((?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n(?:(?:(?:(?!(?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n).)*)(?:\n)?)+)", gdata)
  1074. if(m):
  1075. if(i == num - 1):
  1076. g = m.groups()
  1077. gdata = re.sub("\r\n$", "", g[0])
  1078. break
  1079. else:
  1080. gdata = re.sub("((?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n(?:(?:(?:(?!(?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n).)*)(?:\n)?)+)", "", gdata, 1)
  1081. i += 1
  1082. else:
  1083. j = 1
  1084. break
  1085. if(j == 0):
  1086. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = gdata, tn = 2, left = left, section = 1, number = num, sub = '편집')
  1087. else:
  1088. return redirect('/w/' + url_pas(name))
  1089. else:
  1090. return redirect('/w/' + url_pas(name))
  1091. @app.route('/preview/<path:name>', methods=['POST'])
  1092. def preview(name = None):
  1093. ip = ip_check()
  1094. can = acl_check(ip, name)
  1095. if(can == 1):
  1096. return redirect('/ban')
  1097. else:
  1098. newdata = request.form["content"]
  1099. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * [[\g<in>]] 문서로 넘겨주기', newdata)
  1100. enddata = namumark(name, newdata)
  1101. db_ex("select * from data where title = '" + db_pas(set_data["help"]) + "'")
  1102. rows = db_get()
  1103. if(rows):
  1104. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * [[\g<in>]] 문서로 넘겨주기', rows[0]["data"])
  1105. left = namumark(name, newdata)
  1106. else:
  1107. left = ''
  1108. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = request.form["content"], tn = 2, preview = 1, enddata = enddata, left = left, sub = '미리보기')
  1109. @app.route('/preview/<path:name>/section/<int:num>', methods=['POST'])
  1110. def section_preview(name = None, num = None):
  1111. ip = ip_check()
  1112. can = acl_check(ip, name)
  1113. if(can == 1):
  1114. return redirect('/ban')
  1115. else:
  1116. newdata = request.form["content"]
  1117. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * [[\g<in>]] 문서로 넘겨주기', newdata)
  1118. enddata = namumark(name, newdata)
  1119. db_ex("select * from data where title = '" + db_pas(set_data["help"]) + "'")
  1120. rows = db_get()
  1121. if(rows):
  1122. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * [[\g<in>]] 문서로 넘겨주기', rows[0]["data"])
  1123. left = namumark(name, newdata)
  1124. else:
  1125. left = ''
  1126. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = request.form["content"], tn = 2, preview = 1, enddata = enddata, left = left, section = 1, number = num, odata = request.form["otent"], sub = '미리보기')
  1127. @app.route('/delete/<path:name>', methods=['POST', 'GET'])
  1128. def delete(name = None):
  1129. ip = ip_check()
  1130. can = acl_check(ip, name)
  1131. if(request.method == 'POST'):
  1132. db_ex("select * from data where title = '" + db_pas(name) + "'")
  1133. rows = db_get()
  1134. if(rows):
  1135. if(can == 1):
  1136. return redirect('/ban')
  1137. else:
  1138. today = get_time()
  1139. leng = '-' + str(len(rows[0]['data']))
  1140. history_plus(name, '', today, ip, '문서를 삭제 했습니다.', leng)
  1141. db_ex("delete from data where title = '" + db_pas(name) + "'")
  1142. db_com()
  1143. return redirect('/w/' + url_pas(name))
  1144. else:
  1145. return redirect('/w/' + url_pas(name))
  1146. else:
  1147. db_ex("select * from data where title = '" + db_pas(name) + "'")
  1148. rows = db_get()
  1149. if(rows):
  1150. if(can == 1):
  1151. return redirect('/ban')
  1152. else:
  1153. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), tn = 8, plus = '정말 삭제 하시겠습니까?', sub = '삭제')
  1154. else:
  1155. return redirect('/w/' + url_pas(name))
  1156. @app.route('/move/<path:name>', methods=['POST', 'GET'])
  1157. def move(name = None):
  1158. ip = ip_check()
  1159. can = acl_check(ip, name)
  1160. today = get_time()
  1161. if(request.method == 'POST'):
  1162. db_ex("select * from data where title = '" + db_pas(name) + "'")
  1163. rows = db_get()
  1164. if(can == 1):
  1165. return redirect('/ban')
  1166. else:
  1167. leng = '0'
  1168. db_ex("select * from history where title = '" + db_pas(request.form["title"]) + "'")
  1169. row = db_get()
  1170. if(row):
  1171. return redirect('/error/19')
  1172. else:
  1173. history_plus(name, rows[0]['data'], today, ip, '<a href="/w/' + url_pas(name) + '">' + name + '</a> 문서를 <a href="/w/' + url_pas(request.form["title"]) + '">' + request.form["title"] + '</a> 문서로 이동 했습니다.', leng)
  1174. if(rows):
  1175. db_ex("update data set title = '" + db_pas(request.form["title"]) + "' where title = '" + db_pas(name) + "'")
  1176. db_ex("update history set title = '" + db_pas(request.form["title"]) + "' where title = '" + db_pas(name) + "'")
  1177. db_com()
  1178. return redirect('/w/' + url_pas(request.form["title"]))
  1179. else:
  1180. if(can == 1):
  1181. return redirect('/ban')
  1182. else:
  1183. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), tn = 9, plus = '정말 이동 하시겠습니까?', sub = '이동')
  1184. @app.route('/other')
  1185. def other():
  1186. return web_render('index.html', login = login_check(), title = '기타 메뉴', logo = set_data['name'], data = '<h2 style="margin-top: 0px;">기록</h2><li><a href="/blocklog/n/1">사용자 차단 기록</a></li><li><a href="/userlog/n/1">사용자 가입 기록</a></li><li><a href="/manager/6">사용자 기록</a></li><h2>기타</h2><li><a href="/titleindex">모든 문서</a></li><li><a href="/acllist">ACL 문서 목록</a></li><li><a href="/upload">업로드</a></li><li><a href="/adminlist">관리자 목록</a></li><li><a href="/manager/1">관리자 메뉴</a></li><br>이 오픈나무의 버전은 <a href="https://github.com/2DU/openNAMU/blob/master/version.md">1.9.3</a> 입니다.')
  1187. @app.route('/manager/<int:num>', methods=['POST', 'GET'])
  1188. def manager(num = None):
  1189. if(num == 1):
  1190. return web_render('index.html', login = login_check(), title = '관리자 메뉴', logo = set_data['name'], data = '<h2 style="margin-top: 0px;">관리자 및 소유자</h2><li><a href="/manager/2">문서 ACL</a></li><li><a href="/manager/3">사용자 체크</a></li><li><a href="/manager/4">사용자 차단</a></li><h2>소유자</h2><li><a href="/backreset">모든 역링크 재 생성</a></li><li><a href="/manager/5">관리자 권한 주기</a></li><h2>기타</h2><li>이 메뉴에 없는 기능은 해당 문서의 역사나 토론에서 바로 사용 가능함</li>')
  1191. elif(num == 2):
  1192. if(request.method == 'POST'):
  1193. return redirect('/acl/' + url_pas(request.form["name"]))
  1194. else:
  1195. return web_render('index.html', login = login_check(), title = 'ACL 이동', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/manager/2"><input name="name" type="text"><br><br><button class="btn btn-primary" type="submit">이동</button></form>')
  1196. elif(num == 3):
  1197. if(request.method == 'POST'):
  1198. return redirect('/check/' + url_pas(request.form["name"]))
  1199. else:
  1200. return web_render('index.html', login = login_check(), title = '체크 이동', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/manager/3"><input name="name" type="text"><br><br><button class="btn btn-primary" type="submit">이동</button></form>')
  1201. elif(num == 4):
  1202. if(request.method == 'POST'):
  1203. return redirect('/ban/' + url_pas(request.form["name"]))
  1204. else:
  1205. return web_render('index.html', login = login_check(), title = '차단 이동', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/manager/4"><input name="name" type="text"><br><br><button class="btn btn-primary" type="submit">이동</button><br><br><span>아이피 앞 두자리 (XXX.XXX) 입력하면 대역 차단</span></form>')
  1206. elif(num == 5):
  1207. if(request.method == 'POST'):
  1208. return redirect('/admin/' + url_pas(request.form["name"]))
  1209. else:
  1210. return web_render('index.html', login = login_check(), title = '권한 이동', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/manager/5"><input name="name" type="text"><br><br><button class="btn btn-primary" type="submit">이동</button></form>')
  1211. elif(num == 6):
  1212. if(request.method == 'POST'):
  1213. return redirect('/record/' + url_pas(request.form["name"]))
  1214. else:
  1215. return web_render('index.html', login = login_check(), title = '기록 이동', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/manager/6"><input name="name" type="text"><br><br><button class="btn btn-primary" type="submit">이동</button></form>')
  1216. else:
  1217. return redirect('/')
  1218. @app.route('/titleindex')
  1219. def title_index():
  1220. i = 0
  1221. data = '<div>'
  1222. db_ex("select title from data order by title asc")
  1223. title_list = db_get()
  1224. if(title_list):
  1225. while(True):
  1226. try:
  1227. a = title_list[i]
  1228. except:
  1229. break
  1230. data = data + '<li>' + str(i + 1) + '. <a href="/w/' + url_pas(title_list[i]['title']) + '">' + title_list[i]['title'] + '</a></li>'
  1231. i += 1
  1232. data = data + '</div>'
  1233. return web_render('index.html', login = login_check(), logo = set_data['name'], rows = data + '<br><span>이 위키에는 총 ' + str(i) + '개의 문서가 있습니다.</span>', tn = 4, title = '모든 문서')
  1234. else:
  1235. return web_render('index.html', login = login_check(), logo = set_data['name'], rows = '', tn = 4, title = '모든 문서')
  1236. @app.route('/topic/<path:name>', methods=['POST', 'GET'])
  1237. def topic_list(name = None):
  1238. if(request.method == 'POST'):
  1239. return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(request.form["topic"]))
  1240. else:
  1241. div = '<div>'
  1242. i = 0
  1243. j = 1
  1244. db_ex("select * from rd where title = '" + db_pas(name) + "' order by date asc")
  1245. rows = db_get()
  1246. while(True):
  1247. try:
  1248. a = rows[i]
  1249. except:
  1250. div = div + '</div>'
  1251. break
  1252. db_ex("select * from topic where title = '" + db_pas(rows[i]['title']) + "' and sub = '" + db_pas(rows[i]['sub']) + "' and id = '1' order by sub asc")
  1253. aa = db_get()
  1254. indata = namumark(name, aa[0]['data'])
  1255. if(aa[0]['block'] == 'O'):
  1256. indata = '블라인드 되었습니다.'
  1257. block = 'style="background: gainsboro;"'
  1258. else:
  1259. block = ''
  1260. ip = ip_pas(aa[0]['ip'])
  1261. db_ex("select * from stop where title = '" + db_pas(rows[i]['title']) + "' and sub = '" + db_pas(rows[i]['sub']) + "' and close = 'O'")
  1262. row = db_get()
  1263. if(not row):
  1264. div = div + '<h2><a href="/topic/' + url_pas(rows[i]['title']) + '/sub/' + url_pas(rows[i]['sub']) + '">' + str(j) + '. ' + rows[i]['sub'] + '</a></h2><table id="toron"><tbody><tr><td id="toroncolorgreen"><a href="javascript:void(0);" id="1">#1</a> ' + ip + ' <span style="float:right;">' + aa[0]['date'] + '</span></td></tr><tr><td ' + block + '>' + indata + '</td></tr></tbody></table><br>'
  1265. j += 1
  1266. i += 1
  1267. return web_render('index.html', login = login_check(), title = name, page = url_pas(name), logo = set_data['name'], plus = div, tn = 10, list = 1, sub = '토론 목록')
  1268. @app.route('/topic/<path:name>/close')
  1269. def close_topic_list(name = None):
  1270. div = '<div>'
  1271. i = 0
  1272. db_ex("select * from stop where title = '" + db_pas(name) + "' and close = 'O' order by sub asc")
  1273. rows = db_get()
  1274. while(True):
  1275. try:
  1276. a = rows[i]
  1277. except:
  1278. div = div + '</div>'
  1279. break
  1280. db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(rows[i]['sub']) + "' and id = '1'")
  1281. row = db_get()
  1282. if(row):
  1283. indata = namumark(name, row[0]['data'])
  1284. if(row[0]['block'] == 'O'):
  1285. indata = '블라인드 되었습니다.'
  1286. block = 'style="background: gainsboro;"'
  1287. else:
  1288. block = ''
  1289. ip = ip_pas(row[0]['ip'])
  1290. div = div + '<h2><a href="/topic/' + url_pas(name) + '/sub/' + url_pas(rows[i]['sub']) + '">' + str((i + 1)) + '. ' + rows[i]['sub'] + '</a></h2><table id="toron"><tbody><tr><td id="toroncolorgreen"><a href="javascript:void(0);" id="1">#1</a> ' + ip + ' <span style="float:right;">' + row[0]['date'] + '</span></td></tr><tr><td ' + block + '>' + indata + '</td></tr></tbody></table><br>'
  1291. i += 1
  1292. return web_render('index.html', login = login_check(), title = name, page = url_pas(name), logo = set_data['name'], plus = div, tn = 10, sub = '닫힌 토론')
  1293. @app.route('/topic/<path:name>/agree')
  1294. def agree_topic_list(name = None):
  1295. div = '<div>'
  1296. i = 0
  1297. db_ex("select * from agreedis where title = '" + db_pas(name) + "' order by sub asc")
  1298. agree_list = db_get()
  1299. while(True):
  1300. try:
  1301. a = agree_list[i]
  1302. except:
  1303. div = div + '</div>'
  1304. break
  1305. db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(agree_list[i]['sub']) + "' and id = '1'")
  1306. data = db_get()
  1307. if(data):
  1308. indata = namumark(name, data[0]['data'])
  1309. if(data[0]['block'] == 'O'):
  1310. indata = '블라인드 되었습니다.'
  1311. block = 'style="background: gainsboro;"'
  1312. else:
  1313. block = ''
  1314. ip = ip_pas(data[0]['ip'])
  1315. div = div + '<h2><a href="/topic/' + url_pas(name) + '/sub/' + url_pas(data[i]['sub']) + '">' + str(i + 1) + '. ' + data[i]['sub'] + '</a></h2><table id="toron"><tbody><tr><td id="toroncolorgreen"><a href="javascript:void(0);" id="1">#1</a> ' + 아이디 + ' <span style="float:right;">' + data[0]['date'] + '</span></td></tr><tr><td ' + block + '>' + indata + '</td></tr></tbody></table><br>'
  1316. i += 1
  1317. return web_render('index.html', login = login_check(), title = name, page = url_pas(name), logo = set_data['name'], plus = div, tn = 10, sub = '합의된 토론')
  1318. @app.route('/topic/<path:name>/sub/<path:sub>', methods=['POST', 'GET'])
  1319. def topic(name = None, sub = None):
  1320. ip = ip_check()
  1321. ban = topic_check(ip, name, sub)
  1322. admin = admin_check()
  1323. if(request.method == 'POST'):
  1324. db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' order by id + 0 desc limit 1")
  1325. rows = db_get()
  1326. if(rows):
  1327. number = int(rows[0]['id']) + 1
  1328. else:
  1329. number = 1
  1330. if(ban == 1 and not admin == 1):
  1331. return redirect('/ban')
  1332. else:
  1333. db_ex("select * from user where id = '" + db_pas(ip) + "'")
  1334. rows = db_get()
  1335. if(rows):
  1336. if(rows[0]['acl'] == 'owner' or rows[0]['acl'] == 'admin'):
  1337. ip = ip + ' - Admin'
  1338. today = get_time()
  1339. rd_plus(name, sub, today)
  1340. aa = request.form["content"]
  1341. aa = re.sub("\[\[(분류:(?:(?:(?!\]\]).)*))\]\]", "[br]", aa)
  1342. aa = savemark(aa)
  1343. db_ex("insert into topic (id, title, sub, data, date, ip, block) value ('" + str(number) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', '" + db_pas(aa) + "', '" + today + "', '" + ip + "', '')")
  1344. db_com()
  1345. return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
  1346. else:
  1347. style = ''
  1348. db_ex("select * from stop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and close = 'O'")
  1349. close = db_get()
  1350. db_ex("select * from stop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and close = ''")
  1351. stop = db_get()
  1352. if(admin == 1):
  1353. div = '<div>'
  1354. if(close):
  1355. div = div + '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/close">(토론 열기)</a> '
  1356. else:
  1357. div = div + '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/close">(토론 닫기)</a> '
  1358. if(stop):
  1359. div = div + '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/stop">(토론 재개)</a> '
  1360. else:
  1361. div = div + '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/stop">(토론 정지)</a> '
  1362. db_ex("select * from agreedis where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "'")
  1363. agree = db_get()
  1364. if(agree):
  1365. div = div + '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/agree">(합의 취소)</a>'
  1366. else:
  1367. div = div + '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/agree">(합의 완료)</a>'
  1368. div = div + '<br><br>'
  1369. else:
  1370. div = '<div>'
  1371. if(stop or close):
  1372. if(not admin == 1):
  1373. style = 'display:none;'
  1374. db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' order by id + 0 asc")
  1375. rows = db_get()
  1376. db_ex("select * from distop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' order by id + 0 asc")
  1377. top = db_get()
  1378. i = 0
  1379. if(top):
  1380. while(True):
  1381. try:
  1382. a = top[i]
  1383. except:
  1384. break
  1385. num = int(top[i]['id']) - 1
  1386. if(i == 0):
  1387. start = rows[num]['ip']
  1388. top_data = namumark('', rows[num]['data'])
  1389. top_data = re.sub("(?P<in>#(?:[0-9]*))", '<a href="\g<in>">\g<in></a>', top_data)
  1390. ip = ip_pas(rows[num]['ip'])
  1391. div = div + '<table id="toron"><tbody><tr><td id="toroncolorred"><a href="#' + top[i]['id'] + '" id="' + top[i]['id'] + '-nt">#' + top[i]['id'] + '</a> ' + ip + ' <span style="float:right;">' + rows[num]['date'] + '</span></td></tr><tr><td>' + top_data + '</td></tr></tbody></table><br>'
  1392. i = i + 1
  1393. i = 0
  1394. while(True):
  1395. try:
  1396. a = rows[i]
  1397. except:
  1398. div = div + '</div>'
  1399. break
  1400. if(i == 0):
  1401. start = rows[i]['ip']
  1402. indata = namumark('', rows[i]['data'])
  1403. indata = re.sub("(?P<in>#(?:[0-9]*))", '<a href="\g<in>">\g<in></a>', indata)
  1404. if(rows[i]['block'] == 'O'):
  1405. indata = '블라인드 되었습니다.'
  1406. block = 'style="background: gainsboro;"'
  1407. else:
  1408. block = ''
  1409. m = re.search("^([^-]*)\s\-\s(Close|Reopen|Stop|Restart|Agreement|Settlement)$", rows[i]['ip'])
  1410. if(m):
  1411. ban = ""
  1412. else:
  1413. if(admin == 1):
  1414. if(rows[i]['block'] == 'O'):
  1415. isblock = ' <a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/b/' + str(i + 1) + '">(해제)</a>'
  1416. else:
  1417. isblock = ' <a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/b/' + str(i + 1) + '">(블라인드)</a>'
  1418. db_ex("select * from distop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + db_pas(str(i + 1)) + "'")
  1419. row = db_get()
  1420. if(row):
  1421. isblock = isblock + ' <a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/notice/' + str(i + 1) + '">(해제)</a>'
  1422. else:
  1423. isblock = isblock + ' <a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/notice/' + str(i + 1) + '">(공지)</a>'
  1424. n = re.search("\- (?:Admin)$", rows[i]['ip'])
  1425. if(n):
  1426. ban = isblock
  1427. else:
  1428. db_ex("select * from ban where block = '" + db_pas(rows[i]['ip']) + "'")
  1429. row = db_get()
  1430. if(row):
  1431. ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(해제)</a>' + isblock
  1432. else:
  1433. ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(차단)</a>' + isblock
  1434. else:
  1435. ban = ""
  1436. ip = ip_pas(rows[i]['ip'])
  1437. if(rows[i]['ip'] == start):
  1438. j = i + 1
  1439. div = div + '<table id="toron"><tbody><tr><td id="toroncolorgreen"><a href="javascript:void(0);" id="' + str(j) + '">#' + str(j) + '</a> ' + ip + ban + ' <span style="float:right;">' + rows[i]['date'] + '</span></td></tr><tr><td ' + block + '>' + indata + '</td></tr></tbody></table><br>'
  1440. else:
  1441. j = i + 1
  1442. div = div + '<table id="toron"><tbody><tr><td id="toroncolor"><a href="javascript:void(0);" id="' + str(j) + '">#' + str(j) + '</a> ' + ip + ban + ' <span style="float:right;">' + rows[i]['date'] + '</span></td></tr><tr><td ' + block + '>' + indata + '</td></tr></tbody></table><br>'
  1443. i += 1
  1444. return web_render('index.html', login = login_check(), title = name, page = url_pas(name), suburl = url_pas(sub), toron = sub, logo = set_data['name'], rows = div, tn = 11, ban = ban, style = style, sub = '토론')
  1445. @app.route('/topic/<path:name>/sub/<path:sub>/b/<int:num>')
  1446. def topic_block(name = None, sub = None, num = None):
  1447. if(admin_check() == 1):
  1448. db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + str(num) + "'")
  1449. block = db_get()
  1450. if(block):
  1451. if(block[0]['block'] == 'O'):
  1452. db_ex("update topic set block = '' where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + str(num) + "'")
  1453. else:
  1454. db_ex("update topic set block = 'O' where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + str(num) + "'")
  1455. db_com()
  1456. rd_plus(name, sub, get_time())
  1457. return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
  1458. else:
  1459. return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
  1460. else:
  1461. return redirect('/error/3')
  1462. @app.route('/topic/<path:name>/sub/<path:sub>/notice/<int:num>')
  1463. def topic_top(name = None, sub = None, num = None):
  1464. if(admin_check() == 1):
  1465. db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + str(num) + "'")
  1466. topic_data = db_get()
  1467. if(topic_data):
  1468. db_ex("select * from distop where id = '" + str(num) + "' and title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "'")
  1469. top_data = db_get()
  1470. if(top_data):
  1471. db_ex("delete from distop where id = '" + str(num) + "' and title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "'")
  1472. else:
  1473. db_ex("insert into distop (id, title, sub) value ('" + db_pas(str(num)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "')")
  1474. db_com()
  1475. rd_plus(name, sub, get_time())
  1476. return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
  1477. else:
  1478. return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
  1479. else:
  1480. return redirect('/error/3')
  1481. @app.route('/topic/<path:name>/sub/<path:sub>/stop')
  1482. def topic_stop(name = None, sub = None):
  1483. if(admin_check() == 1):
  1484. ip = ip_check()
  1485. db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' limit 1")
  1486. topic_check = db_get()
  1487. if(topic_check):
  1488. time = get_time()
  1489. db_ex("select * from stop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and close = ''")
  1490. stop = db_get()
  1491. if(stop):
  1492. db_ex("insert into topic (id, title, sub, data, date, ip, block) value ('" + db_pas(str(int(topic_check[0]['id']) + 1)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', 'Restart', '" + db_pas(time) + "', '" + db_pas(ip) + " - Restart', '')")
  1493. db_ex("delete from stop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and close = ''")
  1494. else:
  1495. db_ex("insert into topic (id, title, sub, data, date, ip, block) value ('" + db_pas(str(int(topic_check[0]['id']) + 1)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', 'Stop', '" + db_pas(time) + "', '" + db_pas(ip) + " - Stop', '')")
  1496. db_ex("insert into stop (title, sub, close) value ('" + db_pas(name) + "', '" + db_pas(sub) + "', '')")
  1497. db_com()
  1498. rd_plus(name, sub, time)
  1499. return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
  1500. else:
  1501. return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
  1502. else:
  1503. return redirect('/error/3')
  1504. @app.route('/topic/<path:name>/sub/<path:sub>/close')
  1505. def topic_close(name = None, sub = None):
  1506. if(admin_check() == 1):
  1507. ip = ip_check()
  1508. db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' order by id + 0 desc limit 1")
  1509. topic_check = db_get()
  1510. if(topic_check):
  1511. time = get_time()
  1512. db_ex("select * from stop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and close = 'O'")
  1513. close = db_get()
  1514. if(close):
  1515. db_ex("insert into topic (id, title, sub, data, date, ip, block) value ('" + db_pas(str(int(topic_check[0]['id']) + 1)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', 'Reopen', '" + db_pas(time) + "', '" + db_pas(ip) + " - Reopen', '')")
  1516. db_ex("delete from stop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and close = 'O'")
  1517. else:
  1518. db_ex("insert into topic (id, title, sub, data, date, ip, block) value ('" + db_pas(str(int(topic_check[0]['id']) + 1)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', 'Close', '" + db_pas(time) + "', '" + db_pas(ip) + " - Close', '')")
  1519. db_ex("insert into stop (title, sub, close) value ('" + db_pas(name) + "', '" + db_pas(sub) + "', 'O')")
  1520. db_com()
  1521. rd_plus(name, sub, time)
  1522. return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
  1523. else:
  1524. return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
  1525. else:
  1526. return redirect('/error/3')
  1527. @app.route('/topic/<path:name>/sub/<path:sub>/agree')
  1528. def topic_agree(name = None, sub = None):
  1529. if(admin_check() == 1):
  1530. ip = ip_check()
  1531. db_ex("select id from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' order by id + 0 desc limit 1")
  1532. topic_check = db_get()
  1533. if(topic_check):
  1534. time = get_time()
  1535. db_ex("select * from agreedis where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "'")
  1536. agree = db_get()
  1537. if(agree):
  1538. db_ex("insert into topic (id, title, sub, data, date, ip, block) value ('" + db_pas(str(int(topic_check[0]['id']) + 1)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', 'Settlement', '" + db_pas(time) + "', '" + db_pas(ip) + " - Settlement', '')")
  1539. db_ex("delete from agreedis where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "'")
  1540. else:
  1541. db_ex("insert into topic (id, title, sub, data, date, ip, block) value ('" + db_pas(str(int(topic_check[0]['id']) + 1)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', 'Agreement', '" + db_pas(time) + "', '" + db_pas(ip) + " - Agreement', '')")
  1542. db_ex("insert into agreedis (title, sub) value ('" + db_pas(name) + "', '" + db_pas(sub) + "')")
  1543. db_com()
  1544. rd_plus(name, sub, time)
  1545. return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
  1546. else:
  1547. return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
  1548. else:
  1549. return redirect('/error/3')
  1550. @app.route('/login', methods=['POST', 'GET'])
  1551. def login():
  1552. ip = ip_check()
  1553. ban = ban_check(ip)
  1554. if(request.method == 'POST'):
  1555. if(ban == 1):
  1556. return redirect('/ban')
  1557. else:
  1558. db_ex("select * from user where id = '" + db_pas(request.form["id"]) + "'")
  1559. user = db_get()
  1560. if(user):
  1561. if(session.get('Now') == True):
  1562. return redirect('/error/11')
  1563. elif(bcrypt.checkpw(bytes(request.form["pw"], 'utf-8'), bytes(user[0]['pw'], 'utf-8'))):
  1564. session['Now'] = True
  1565. session['DREAMER'] = request.form["id"]
  1566. db_ex("insert into login (user, ip, today) value ('" + db_pas(request.form["id"]) + "', '" + db_pas(ip) + "', '" + db_pas(get_time()) + "')")
  1567. db_com()
  1568. return redirect('/user')
  1569. else:
  1570. return redirect('/error/13')
  1571. else:
  1572. return redirect('/error/12')
  1573. else:
  1574. if(ban == 1):
  1575. return redirect('/ban')
  1576. else:
  1577. if(session.get('Now') == True):
  1578. return redirect('/error/11')
  1579. else:
  1580. return web_render('index.html', login = login_check(), title = '로그인', enter = '로그인', logo = set_data['name'], tn = 15)
  1581. @app.route('/change', methods=['POST', 'GET'])
  1582. def change_password():
  1583. ip = ip_check()
  1584. ban = ban_check(ip)
  1585. if(request.method == 'POST'):
  1586. if(request.form["pw2"] == request.form["pw3"]):
  1587. if(ban == 1):
  1588. return redirect('/ban')
  1589. else:
  1590. db_ex("select * from user where id = '" + db_pas(request.form["id"]) + "'")
  1591. user = db_get()
  1592. if(user):
  1593. if(session.get('Now') == True):
  1594. session['Now'] = False
  1595. session.pop('DREAMER', None)
  1596. return redirect('/change')
  1597. elif(bcrypt.checkpw(bytes(request.form["pw"], 'utf-8'), bytes(user[0]['pw'], 'utf-8'))):
  1598. hashed = bcrypt.hashpw(bytes(request.form["pw2"], 'utf-8'), bcrypt.gensalt())
  1599. db_ex("update user set pw = '" + db_pas(hashed.decode()) + "' where id = '" + db_pas(request.form["id"]) + "'")
  1600. db_com()
  1601. return redirect('/login')
  1602. else:
  1603. return redirect('/error/10')
  1604. else:
  1605. return redirect('/error/9')
  1606. else:
  1607. return redirect('/error/20')
  1608. else:
  1609. if(ban == 1):
  1610. return redirect('/ban')
  1611. else:
  1612. if(session.get('Now') == True):
  1613. session['Now'] = False
  1614. session.pop('DREAMER', None)
  1615. return redirect('/change')
  1616. else:
  1617. return web_render('index.html', login = login_check(), title = '비밀번호 변경', enter = '변경', logo = set_data['name'], tn = 15)
  1618. @app.route('/check/<name>')
  1619. def user_check(name = None, sub = None):
  1620. db_ex("select * from user where id = '" + db_pas(name) + "'")
  1621. user = db_get()
  1622. if(user and user[0]['acl'] == 'owner' or user and user[0]['acl'] == 'admin'):
  1623. return redirect('/error/4')
  1624. else:
  1625. if(admin_check() == 1):
  1626. m = re.search('(?:[0-9](?:[0-9][0-9])?\.[0-9](?:[0-9][0-9])?\.[0-9](?:[0-9][0-9])?\.[0-9](?:[0-9][0-9])?)', name)
  1627. if(m):
  1628. db_ex("select * from login where ip = '" + db_pas(name) + "' order by today desc")
  1629. row = db_get()
  1630. if(row):
  1631. i = 0
  1632. c = ''
  1633. while(True):
  1634. try:
  1635. c = c + '<table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;">' + row[i]['user'] + '</td><td style="text-align: center;width:33.33%;">' + row[i]['ip'] + '</td><td style="text-align: center;width:33.33%;">' + row[i]['today'] + '</td></tr></tbody></table>'
  1636. except:
  1637. break
  1638. i += 1
  1639. return web_render('index.html', login = login_check(), title = '다중 검사', logo = set_data['name'], tn = 22, rows = c)
  1640. else:
  1641. return web_render('index.html', login = login_check(), title = '다중 검사', logo = set_data['name'], tn = 22, rows = '')
  1642. else:
  1643. db_ex("select * from login where user = '" + db_pas(name) + "' order by today desc")
  1644. row = db_get()
  1645. if(row):
  1646. i = 0
  1647. c = ''
  1648. while(True):
  1649. try:
  1650. c = c + '<table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;">' + row[i]['user'] + '</td><td style="text-align: center;width:33.33%;">' + row[i]['ip'] + '</td><td style="text-align: center;width:33.33%;">' + row[i]['today'] + '</td></tr></tbody></table>'
  1651. except:
  1652. break
  1653. i += 1
  1654. return web_render('index.html', login = login_check(), title = '다중 검사', logo = set_data['name'], tn = 22, rows = c)
  1655. else:
  1656. return web_render('index.html', login = login_check(), title = '다중 검사', logo = set_data['name'], tn = 22, rows = '')
  1657. else:
  1658. return redirect('/error/3')
  1659. @app.route('/register', methods=['POST', 'GET'])
  1660. def register():
  1661. ip = ip_check()
  1662. ban = ban_check(ip)
  1663. if(request.method == 'POST'):
  1664. if(request.form["pw"] == request.form["pw2"]):
  1665. if(ban == 1):
  1666. return redirect('/ban')
  1667. else:
  1668. m = re.search('(?:[^A-Za-zㄱ-힣0-9 ])', request.form["id"])
  1669. if(m):
  1670. return redirect('/error/8')
  1671. else:
  1672. if(len(request.form["id"]) > 20):
  1673. return redirect('/error/7')
  1674. else:
  1675. db_ex("select * from user where id = '" + db_pas(request.form["id"]) + "'")
  1676. rows = db_get()
  1677. if(rows):
  1678. return redirect('/error/6')
  1679. else:
  1680. hashed = bcrypt.hashpw(bytes(request.form["pw"], 'utf-8'), bcrypt.gensalt())
  1681. if(request.form["id"] == set_data['owner']):
  1682. db_ex("insert into user (id, pw, acl) value ('" + db_pas(request.form["id"]) + "', '" + db_pas(hashed.decode()) + "', 'owner')")
  1683. else:
  1684. db_ex("insert into user (id, pw, acl) value ('" + db_pas(request.form["id"]) + "', '" + db_pas(hashed.decode()) + "', 'user')")
  1685. db_com()
  1686. return redirect('/login')
  1687. else:
  1688. return redirect('/error/20')
  1689. else:
  1690. if(ban == 1):
  1691. return redirect('/ban')
  1692. else:
  1693. return web_render('index.html', login = login_check(), title = '회원가입', enter = '회원가입', logo = set_data['name'], tn = 15)
  1694. @app.route('/logout')
  1695. def logout():
  1696. session['Now'] = False
  1697. session.pop('DREAMER', None)
  1698. return redirect('/user')
  1699. @app.route('/ban/<name>', methods=['POST', 'GET'])
  1700. def user_ban(name = None):
  1701. db_ex("select * from user where id = '" + db_pas(name) + "'")
  1702. user = db_get()
  1703. if(user and user[0]['acl'] == 'owner' or user and user[0]['acl'] == 'admin'):
  1704. return redirect('/error/4')
  1705. else:
  1706. if(request.method == 'POST'):
  1707. if(admin_check() == 1):
  1708. ip = ip_check()
  1709. if(not re.search("[0-9]{4}-[0-9]{2}-[0-9]{2}", request.form["end"])):
  1710. end = ''
  1711. else:
  1712. end = request.form["end"]
  1713. db_ex("select * from ban where block = '" + db_pas(name) + "'")
  1714. row = db_get()
  1715. if(row):
  1716. rb_plus(name, '해제', 시간(), ip, '')
  1717. db_ex("delete from ban where block = '" + db_pas(name) + "'")
  1718. else:
  1719. b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))$", name)
  1720. if(b):
  1721. rb_plus(name, end, 시간(), ip, request.form["why"])
  1722. db_ex("insert into ban (block, end, why, band) value ('" + db_pas(name) + "', '" + db_pas(end) + "', '" + db_pas(request.form["why"]) + "', 'O')")
  1723. else:
  1724. rb_plus(name, end, 시간(), ip, request.form["why"])
  1725. db_ex("insert into ban (block, end, why, band) value ('" + db_pas(name) + "', '" + db_pas(end) + "', '" + db_pas(request.form["why"]) + "', '')")
  1726. db_com()
  1727. return redirect('/w/' + url_pas(data['frontpage']))
  1728. else:
  1729. return redirect('/error/3')
  1730. else:
  1731. if(admin_check() == 1):
  1732. db_ex("select * from ban where block = '" + db_pas(name) + "'")
  1733. row = db_get()
  1734. if(row):
  1735. now = '차단 해제'
  1736. else:
  1737. b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))$", name)
  1738. if(b):
  1739. now = '대역 차단'
  1740. else:
  1741. now = '차단'
  1742. return web_render('index.html', login = login_check(), title = name, page = url_pas(name), logo = set_data['name'], tn = 16, now = now, today = get_time(), sub = '차단')
  1743. else:
  1744. return redirect('/error/3')
  1745. @app.route('/acl/<path:name>', methods=['POST', 'GET'])
  1746. def acl(name = None):
  1747. if(request.method == 'POST'):
  1748. if(admin_check() == 1):
  1749. db_ex("select acl from data where title = '" + db_pas(name) + "'")
  1750. row = db_get()
  1751. if(row):
  1752. if(request.form["select"] == 'admin'):
  1753. db_ex("update data set acl = 'admin' where title = '" + db_pas(name) + "'")
  1754. elif(request.form["select"] == 'user'):
  1755. db_ex("update data set acl = 'user' where title = '" + db_pas(name) + "'")
  1756. else:
  1757. db_ex("update data set acl = '' where title = '" + db_pas(name) + "'")
  1758. db_com()
  1759. return redirect('/w/' + url_pas(name))
  1760. else:
  1761. return redirect('/error/3')
  1762. else:
  1763. if(admin_check() == 1):
  1764. db_ex("select acl from data where title = '" + db_pas(name) + "'")
  1765. row = db_get()
  1766. if(row):
  1767. if(row[0]['acl'] == 'admin'):
  1768. now = '관리자만'
  1769. elif(row[0]['acl'] == 'user'):
  1770. now = '로그인 이상'
  1771. else:
  1772. now = '일반'
  1773. return web_render('index.html', login = login_check(), title = name, page = url_pas(name), logo = set_data['name'], tn = 19, now = '현재 ACL 상태는 ' + now, sub = 'ACL')
  1774. else:
  1775. return redirect('/w/' + url_pas(name))
  1776. else:
  1777. return redirect('/error/3')
  1778. @app.route('/admin/<name>', methods=['POST', 'GET'])
  1779. def user_admin(name = None):
  1780. if(request.method == 'POST'):
  1781. if(owner_check() == 1):
  1782. db_ex("select * from user where id = '" + db_pas(name) + "'")
  1783. user = db_get()
  1784. if(user):
  1785. if(user[0]['acl'] == 'admin' or user[0]['acl'] == 'owner'):
  1786. db_ex("update user set acl = 'user' where id = '" + db_pas(name) + "'")
  1787. else:
  1788. db_ex("update user set acl = '" + db_pas(request.form["select"]) + "' where id = '" + db_pas(name) + "'")
  1789. db_com()
  1790. return redirect('/w/' + url_pas(data['frontpage']))
  1791. else:
  1792. return redirect('/error/5')
  1793. else:
  1794. return redirect('/error/3')
  1795. else:
  1796. if(owner_check() == 1):
  1797. db_ex("select * from user where id = '" + db_pas(name) + "'")
  1798. user = db_get()
  1799. if(user):
  1800. if(user[0]['acl'] == 'admin' or user[0]['acl'] == 'owner'):
  1801. now = '권한 해제'
  1802. else:
  1803. now = '권한 부여'
  1804. return web_render('index.html', login = login_check(), title = name, page = url_pas(name), logo = data['name'], tn = 18, now = now, sub = '권한 부여')
  1805. else:
  1806. return redirect('/error/5')
  1807. else:
  1808. return redirect('/error/3')
  1809. @app.route('/ban')
  1810. def are_you_ban():
  1811. ip = ip_check()
  1812. if(ban_check(ip) == 1):
  1813. db_ex("select * from ban where block = '" + db_pas(ip) + "'")
  1814. rows = db_get()
  1815. if(rows):
  1816. if(rows[0]['end']):
  1817. end = rows[0]['end'] + ' 까지 차단 상태 입니다. / 사유 : ' + rows[0]['why']
  1818. now = get_time()
  1819. now = re.sub(':', '', now)
  1820. now = re.sub('\-', '', now)
  1821. now = re.sub(' ', '', now)
  1822. now = int(now)
  1823. day = rows[0]['end']
  1824. day = re.sub('\-', '', day)
  1825. if(now >= int(day + '000000')):
  1826. db_ex("delete from ban where block = '" + db_pas(ip) + "'")
  1827. db_com()
  1828. end = '차단이 풀렸습니다. 다시 시도 해 보세요.'
  1829. else:
  1830. end = '영구 차단 상태 입니다. / 사유 : ' + rows[0]['why']
  1831. else:
  1832. b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))", ip)
  1833. if(b):
  1834. results = b.groups()
  1835. db_ex("select * from ban where block = '" + db_pas(results[0]) + "' and band = 'O'")
  1836. row = db_get()
  1837. if(row):
  1838. if(row[0]['end']):
  1839. end = row[0]['end'] + ' 까지 차단 상태 입니다. / 사유 : ' + rows[0]['why']
  1840. now = get_time()
  1841. now = re.sub(':', '', now)
  1842. now = re.sub('\-', '', now)
  1843. now = re.sub(' ', '', now)
  1844. now = int(now)
  1845. day = row[0]['end']
  1846. day = re.sub('\-', '', day)
  1847. if(now >= int(day + '000000')):
  1848. db_ex("delete from ban where block = '" + db_pas(results[0]) + "' and band = 'O'")
  1849. db_com()
  1850. end = '차단이 풀렸습니다. 다시 시도 해 보세요.'
  1851. else:
  1852. end = '영구 차단 상태 입니다. / 사유 : ' + row[0]['why']
  1853. else:
  1854. end = '권한이 맞지 않는 상태 입니다.'
  1855. return web_render('index.html', login = login_check(), title = '권한 오류', logo = set_data['name'], data = end), 401
  1856. @app.route('/w/<path:name>/r/<int:a>/diff/<int:b>')
  1857. def diff_data(name = None, a = None, b = None):
  1858. db_ex("select * from history where id = '" + db_pas(str(a)) + "' and title = '" + db_pas(name) + "'")
  1859. a_raw_data = db_get()
  1860. if(a_raw_data):
  1861. db_ex("select * from history where id = '" + db_pas(str(b)) + "' and title = '" + db_pas(name) + "'")
  1862. b_raw_data = db_get()
  1863. if(b_raw_data):
  1864. a_data = re.sub('<', '&lt;', a_raw_data[0]['data'])
  1865. a_data = re.sub('>', '&gt;', a_data)
  1866. a_data = re.sub('"', '&quot;', a_data)
  1867. b_data = re.sub('<', '&lt;', b_raw_data[0]['data'])
  1868. b_data = re.sub('>', '&gt;', b_data)
  1869. b_data = re.sub('"', '&quot;', b_data)
  1870. diff_data = difflib.SequenceMatcher(None, a_data, b_data)
  1871. result = diff(diff_data)
  1872. result = '<pre>' + result + '</pre>'
  1873. return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], data = result, sub = '비교')
  1874. else:
  1875. return redirect('/history/' + url_pas(name))
  1876. else:
  1877. return redirect('/history/' + url_pas(name))
  1878. @app.route('/user')
  1879. def user_info():
  1880. ip = ip_check()
  1881. raw_ip = ip
  1882. db_ex("select * from user where id = '" + db_pas(ip) + "'")
  1883. rows = db_get()
  1884. if(ban_check(ip) == 0):
  1885. if(rows):
  1886. if(rows[0]['acl'] == 'admin' or rows[0]['acl'] == 'owner'):
  1887. if(rows[0]['acl'] == 'admin'):
  1888. acl = '관리자'
  1889. else:
  1890. acl = '소유자'
  1891. else:
  1892. acl = '로그인'
  1893. else:
  1894. acl = '일반'
  1895. else:
  1896. acl = '차단'
  1897. ip = ip_pas(ip)
  1898. return web_render('index.html', login = login_check(), title = '사용자 메뉴', logo = set_data['name'], data = ip + '<br><br><span>권한 상태 : ' + acl + '<h2>로그인 관련</h2><li><a href="/login">로그인</a></li><li><a href="/logout">로그아웃</a></li><li><a href="/register">회원가입</a></li><h2>기타</h2><li><a href="/change">비밀번호 변경</a></li><li><a href="/count">기여 횟수</a></li><li><a href="/record/' + raw_ip + '/n/1">기여 목록</a></li>')
  1899. @app.route('/count')
  1900. def count_edit():
  1901. db_ex("select count(title) from history where ip = '" + ip_check() + "'")
  1902. i = db_get()
  1903. if(i):
  1904. return web_render('index.html', login = login_check(), title = '기여 횟수', logo = set_data['name'], data = "기여 횟수 : " + str(i[0]["count(title)"]))
  1905. else:
  1906. return web_render('index.html', login = login_check(), title = '기여 횟수', logo = set_data['name'], data = "기여 횟수 : 0")
  1907. @app.route('/random')
  1908. def random():
  1909. db_ex("select title from data order by rand() limit 1")
  1910. rows = db_get()
  1911. if(rows):
  1912. return redirect('/w/' + url_pas(rows[0]['title']))
  1913. else:
  1914. return redirect('/')
  1915. @app.route('/error/<int:num>')
  1916. def error_page(num = None):
  1917. if(num == 1):
  1918. return web_render('index.html', login = login_check(), title = '권한 오류', logo = set_data['name'], data = '비 로그인 상태 입니다.'), 401
  1919. elif(num == 2):
  1920. return web_render('index.html', login = login_check(), title = '권한 오류', logo = set_data['name'], data = '이 계정이 없습니다.'), 401
  1921. elif(num == 3):
  1922. return web_render('index.html', login = login_check(), title = '권한 오류', logo = set_data['name'], data = '권한이 모자랍니다.'), 401
  1923. elif(num == 4):
  1924. return web_render('index.html', login = login_check(), title = '권한 오류', logo = set_data['name'], data = '관리자는 차단, 검사 할 수 없습니다.'), 401
  1925. elif(num == 5):
  1926. return web_render('index.html', login = login_check(), title = '사용자 오류', logo = set_data['name'], data = '그런 계정이 없습니다.'), 401
  1927. elif(num == 6):
  1928. return web_render('index.html', login = login_check(), title = '가입 오류', logo = set_data['name'], data = '동일한 아이디의 사용자가 있습니다.'), 401
  1929. elif(num == 7):
  1930. return web_render('index.html', login = login_check(), title = '가입 오류', logo = set_data['name'], data = '아이디는 20글자보다 짧아야 합니다.'), 401
  1931. elif(num == 8):
  1932. return web_render('index.html', login = login_check(), title = '가입 오류', logo = set_data['name'], data = '아이디에는 한글과 알파벳과 공백만 허용 됩니다.'), 401
  1933. elif(num == 9):
  1934. return web_render('index.html', login = login_check(), title = '변경 오류', logo = set_data['name'], data = '그런 계정이 없습니다.'), 401
  1935. elif(num == 10):
  1936. return web_render('index.html', login = login_check(), title = '변경 오류', logo = set_data['name'], data = '비밀번호가 다릅니다.'), 401
  1937. elif(num == 11):
  1938. return web_render('index.html', login = login_check(), title = '로그인 오류', logo = set_data['name'], data = '이미 로그인 되어 있습니다.'), 401
  1939. elif(num == 12):
  1940. return web_render('index.html', login = login_check(), title = '로그인 오류', logo = set_data['name'], data = '그런 계정이 없습니다.'), 401
  1941. elif(num == 13):
  1942. return web_render('index.html', login = login_check(), title = '로그인 오류', logo = set_data['name'], data = '비밀번호가 다릅니다.'), 401
  1943. elif(num == 14):
  1944. return web_render('index.html', login = login_check(), title = '업로드 오류', logo = set_data['name'], data = 'jpg, gif, jpeg, png만 가능 합니다.'), 401
  1945. elif(num == 15):
  1946. return web_render('index.html', login = login_check(), title = '업로드 오류', logo = set_data['name'], data = '파일 명에 . / \ * < > | : ? 가 들어 갈 수 없습니다.'), 401
  1947. elif(num == 16):
  1948. return web_render('index.html', login = login_check(), title = '업로드 오류', logo = set_data['name'], data = '동일한 이름의 파일이 있습니다.'), 401
  1949. elif(num == 17):
  1950. return web_render('index.html', login = login_check(), title = '편집 오류', logo = set_data['name'], data = '편집 내용 기록에는 한글과 영어와 숫자, 공백만 허용 됩니다.'), 401
  1951. elif(num == 18):
  1952. return web_render('index.html', login = login_check(), title = '편집 오류', logo = set_data['name'], data = '내용이 원래 문서와 동일 합니다.'), 401
  1953. elif(num == 19):
  1954. return web_render('index.html', login = login_check(), title = '이동 오류', logo = set_data['name'], data = '이동 하려는 곳에 문서가 이미 있습니다.'), 401
  1955. elif(num == 20):
  1956. return web_render('index.html', login = login_check(), title = '비밀번호 오류', logo = set_data['name'], data = '재 확인이랑 비밀번호가 다릅니다.'), 401
  1957. else:
  1958. return redirect('/')
  1959. @app.errorhandler(404)
  1960. def uncaughtError(error):
  1961. return redirect('/w/' + url_pas(set_data['frontpage']))
  1962. @app.errorhandler(413)
  1963. def uncaughtError(error):
  1964. app.config['MAX_CONTENT_LENGTH'] = (1024**3)
  1965. return error, 401
  1966. if(__name__ == '__main__'):
  1967. app.run(host = '0.0.0.0', port = int(set_data['port']))