main.py 108 KB

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