main.py 108 KB

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