app.py 185 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534
  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. data = json.loads(json_data)
  14. print('오픈나무 시작 포트 : ' + data['port'])
  15. import logging
  16. log = logging.getLogger('werkzeug')
  17. log.setLevel(logging.ERROR)
  18. app.config['MAX_CONTENT_LENGTH'] = int(data['upload']) * 1024 * 1024
  19. def start():
  20. try:
  21. curs.execute("select * from data limit 1")
  22. except:
  23. curs.execute("create table data(title text, data longtext, acl text)")
  24. try:
  25. curs.execute("select * from history limit 1")
  26. except:
  27. curs.execute("create table history(id text, title text, data longtext, date text, ip text, send text, leng text)")
  28. try:
  29. curs.execute("select * from rd limit 1")
  30. except:
  31. curs.execute("create table rd(title text, sub text, date text)")
  32. try:
  33. curs.execute("select * from user limit 1")
  34. except:
  35. curs.execute("create table user(id text, pw text, acl text)")
  36. try:
  37. curs.execute("select * from ban limit 1")
  38. except:
  39. curs.execute("create table ban(block text, end text, why text, band text)")
  40. try:
  41. curs.execute("select * from topic limit 1")
  42. except:
  43. curs.execute("create table topic(id text, title text, sub text, data longtext, date text, ip text, block text)")
  44. try:
  45. curs.execute("select * from stop limit 1")
  46. except:
  47. curs.execute("create table stop(title text, sub text, close text)")
  48. try:
  49. curs.execute("select * from rb limit 1")
  50. except:
  51. curs.execute("create table rb(block text, end text, today text, blocker text, why text)")
  52. try:
  53. curs.execute("select * from login limit 1")
  54. except:
  55. curs.execute("create table login(user text, ip text, today text)")
  56. try:
  57. curs.execute("select * from back limit 1")
  58. except:
  59. curs.execute("create table back(title text, link text, type text)")
  60. try:
  61. curs.execute("select * from cat limit 1")
  62. except:
  63. curs.execute("create table cat(title text, cat text)")
  64. try:
  65. curs.execute("select * from hidhi limit 1")
  66. except:
  67. curs.execute("create table hidhi(title text, re text)")
  68. try:
  69. conn = pymysql.connect(host = data['host'], user = data['user'], password = data['pw'], db = data['db'], charset = 'utf8mb4')
  70. curs = conn.cursor(pymysql.cursors.DictCursor)
  71. start()
  72. except:
  73. conn = pymysql.connect(host = data['host'], user = data['user'], password = data['pw'], charset = 'utf8mb4')
  74. curs = conn.cursor(pymysql.cursors.DictCursor)
  75. curs.execute("create database " + data['db'])
  76. curs.execute("alter database " + data['db'] + " character set = utf8mb4 collate = utf8mb4_unicode_ci")
  77. curs.execute("use " + data['db'])
  78. start()
  79. app.secret_key = hashlib.sha512(bytes(data['key'], 'ascii')).hexdigest()
  80. def show_diff(seqm):
  81. output= []
  82. for opcode, a0, a1, b0, b1 in seqm.get_opcodes():
  83. if(opcode == 'equal'):
  84. output.append(seqm.a[a0:a1])
  85. elif(opcode == 'insert'):
  86. output.append("<span style='background:#CFC;'>" + seqm.b[b0:b1] + "</span>")
  87. elif(opcode == 'delete'):
  88. output.append("<span style='background:#FDD;'>" + seqm.a[a0:a1] + "</span>")
  89. return ''.join(output)
  90. def admincheck():
  91. if(session.get('Now') == True):
  92. ip = getip(request)
  93. curs.execute("select * from user where id = '" + pymysql.escape_string(ip) + "'")
  94. rows = curs.fetchall()
  95. if(rows):
  96. if(rows[0]['acl'] == 'owner' or rows[0]['acl'] == 'admin'):
  97. return 1
  98. def ownercheck():
  99. if(session.get('Now') == True):
  100. ip = getip(request)
  101. curs.execute("select * from user where id = '" + pymysql.escape_string(ip) + "'")
  102. rows = curs.fetchall()
  103. if(rows):
  104. if(rows[0]['acl'] == 'owner'):
  105. return 1
  106. def isin(name):
  107. if(re.search('^틀:', name)):
  108. curs.execute("select * from back where title = '" + pymysql.escape_string(name) + "' and type = 'include'")
  109. include = curs.fetchall()
  110. if(include):
  111. i = 0
  112. while(True):
  113. try:
  114. curs.execute("select * from data where title = '" + pymysql.escape_string(include[i]['link']) + "'")
  115. file = curs.fetchall()
  116. if(file):
  117. namumark(include[i]['link'], file[0]['data'])
  118. except:
  119. break
  120. i = i + 1
  121. def namumark(title, data):
  122. while(True):
  123. m = re.search("<((?:\/)?(?:div|span|embed|iframe)(?:[^>]*))>", data)
  124. if(m):
  125. g = m.groups()
  126. n = re.search('src="http(?:s)?:\/\/([^\/]*)\/(?:[^"]*)"', g[0])
  127. if(n):
  128. gm = n.groups()
  129. if(gm[0] == "www.youtube.com" or gm[0] == "serviceapi.nmv.naver.com" or gm[0] == "tv.kakao.com" or gm[0] == "tvple.com" or gm[0] == "tvpot.daum.net"):
  130. r = g[0]
  131. else:
  132. r = re.sub('src="([^"]*)"', '', g[0])
  133. else:
  134. r = g[0]
  135. r = re.sub('"', '#.#', r)
  136. data = re.sub("<((?:\/)?(?:div|span|embed|iframe)(?:[^>]*))>", "[" + r + "]", data, 1)
  137. else:
  138. break
  139. data = re.sub('<', '&lt;', data)
  140. data = re.sub('>', '&gt;', data)
  141. data = re.sub('"', '&quot;', data)
  142. data = re.sub("\[(?P<in>(?:\/)?(?:div|span|embed|iframe)(?:[^\]]*))\]", "<\g<in>>", data)
  143. data = re.sub('#.#', '"', data)
  144. jjjj = 0
  145. while(True):
  146. p = re.compile("{{{((?:(?!{{{)(?!}}}).)*)}}}", re.DOTALL)
  147. m = p.search(data)
  148. if(m):
  149. results = m.groups()
  150. q = re.compile("^\+([1-5])\s(.*)$", re.DOTALL)
  151. n = q.search(results[0])
  152. w = re.compile("^\-([1-5])\s(.*)$", re.DOTALL)
  153. a = w.search(results[0])
  154. e = re.compile("^(#[0-9a-f-A-F]{6})\s(.*)$", re.DOTALL)
  155. b = e.search(results[0])
  156. r = re.compile("^(#[0-9a-f-A-F]{3})\s(.*)$", re.DOTALL)
  157. c = r.search(results[0])
  158. t = re.compile("^#(\w+)\s(.*)$", re.DOTALL)
  159. d = t.search(results[0])
  160. qqq = re.compile("^@([0-9a-f-A-F]{6})\s(.*)$", re.DOTALL)
  161. qqe = qqq.search(results[0])
  162. qqw = re.compile("^@([0-9a-f-A-F]{3})\s(.*)$", re.DOTALL)
  163. qqa = qqw.search(results[0])
  164. qwe = re.compile("^@(\w+)\s(.*)$", re.DOTALL)
  165. qsd = qwe.search(results[0])
  166. qawe = re.compile("^#!noin\s(.*)$", re.DOTALL)
  167. qasd = qawe.search(results[0])
  168. y = re.compile("^#!wiki\sstyle=&quot;((?:(?!&quot;|\n).)*)&quot;\n?\s\n(.*)$", re.DOTALL)
  169. l = y.search(results[0])
  170. html = re.compile("^#!html\s(.*)$", re.DOTALL)
  171. htmlr = html.search(results[0])
  172. ppp = re.compile("^#!folding\s((?:(?!\n).)*)\n?\s\n(.*)$", re.DOTALL)
  173. ooo = ppp.search(results[0])
  174. if(n):
  175. result = n.groups()
  176. data = p.sub('<span class="font-size-' + result[0] + '">' + result[1] + '</span>', data, 1)
  177. elif(a):
  178. result = a.groups()
  179. data = p.sub('<span class="font-size-small-' + result[0] + '">' + result[1] + '</span>', data, 1)
  180. elif(b):
  181. result = b.groups()
  182. data = p.sub('<span style="color:' + result[0] + '">' + result[1] + '</span>', data, 1)
  183. elif(c):
  184. result = c.groups()
  185. data = p.sub('<span style="color:' + result[0] + '">' + result[1] + '</span>', data, 1)
  186. elif(d):
  187. result = d.groups()
  188. data = p.sub('<span style="color:' + result[0] + '">' + result[1] + '</span>', data, 1)
  189. elif(qqe):
  190. result = qqe.groups()
  191. data = p.sub('<span style="background:#' + result[0] + '">' + result[1] + '</span>', data, 1)
  192. elif(qqa):
  193. result = qqa.groups()
  194. data = p.sub('<span style="background:#' + result[0] + '">' + result[1] + '</span>', data, 1)
  195. elif(qsd):
  196. result = qsd.groups()
  197. data = p.sub('<span style="background:' + result[0] + '">' + result[1] + '</span>', data, 1)
  198. elif(l):
  199. result = l.groups()
  200. data = p.sub('<div style="' + result[0] + '">' + result[1] + '</div>', data, 1)
  201. elif(htmlr):
  202. result = htmlr.groups()
  203. data = p.sub(result[0], data, 1)
  204. elif(ooo):
  205. result = ooo.groups()
  206. data = p.sub("<div>" + result[0] + "<span style='float:right;'><div id='folding_" + str(jjjj + 1) + "' style='display:block;'>[<a href='javascript:void(0);' onclick='var f=document.getElementById(\"folding_" + str(jjjj) + "\");var s=f.style.display==\"block\";f.style.display=s?\"none\":\"block\";this.className=s?\"\":\"opened\";var f=document.getElementById(\"folding_" + str(jjjj + 1) + "\");var s=f.style.display==\"none\";f.style.display=s?\"block\":\"none\";var f=document.getElementById(\"folding_" + str(jjjj + 2) + "\");var s=f.style.display==\"block\";f.style.display=s?\"none\":\"block\";'>펼치기</a>]</div><div id='folding_" + str(jjjj + 2) + "' style='display:none;'>[<a href='javascript:void(0);' onclick='var f=document.getElementById(\"folding_" + str(jjjj) + "\");var s=f.style.display==\"block\";f.style.display=s?\"none\":\"block\";this.className=s?\"\":\"opened\";var f=document.getElementById(\"folding_" + str(jjjj + 1) + "\");var s=f.style.display==\"none\";f.style.display=s?\"block\":\"none\";var f=document.getElementById(\"folding_" + str(jjjj + 2) + "\");var s=f.style.display==\"block\";f.style.display=s?\"none\":\"block\";'>접기</a>]</div></a></span><div id='folding_" + str(jjjj) + "' style='display:none;'><br>" + result[1] + "</div></div>", data, 1)
  207. jjjj = jjjj + 3
  208. elif(qasd):
  209. result = qasd.groups()
  210. data = p.sub(result[0], data, 1)
  211. else:
  212. data = p.sub('<code>' + results[0] + '</code>', data, 1)
  213. else:
  214. break
  215. while(True):
  216. a = re.compile("<code>(((?!<\/code>).)*)<\/code>", re.DOTALL)
  217. m = a.search(data)
  218. if(m):
  219. g = m.groups()
  220. j = re.sub("<\/span>", "}}}", g[0])
  221. j = re.sub("<\/div>", "}}}", j)
  222. j = re.sub('<span class="font\-size\-(?P<in>[1-6])">', "{{{+\g<in> ", j)
  223. j = re.sub('<span class="font\-size\-small\-(?P<in>[1-6])">', "{{{-\g<in> ", j)
  224. j = re.sub('<span style="color:(?:#)?(?P<in>[^"]*)">', "{{{#\g<in> ", j)
  225. j = re.sub('<span style="background:(?:#)?(?P<in>[^"]*)">', "{{{@\g<in> ", j)
  226. j = re.sub('<div style="(?P<in>[^"]*)">', "{{{#!wiki style=&quot;\g<in>&quot;\n", j)
  227. j = re.sub("(?P<in>.)", "<span>\g<in></span>", j)
  228. data = a.sub(j, data, 1)
  229. else:
  230. break
  231. data = re.sub("<span>&</span><span>l</span><span>t</span><span>;</span>", "<span>&lt;</span>", data)
  232. data = re.sub("<span>&</span><span>g</span><span>t</span><span>;</span>", "<span>&gt;</span>", data)
  233. data = re.sub("\[anchor\((?P<in>[^\[\]]*)\)\]", '<span id="\g<in>"></span>', data)
  234. data = re.sub('\[date\(now\)\]', getnow(), data)
  235. while(True):
  236. m = re.search("\[include\(((?:(?!\)\]|,).)*)((?:,\s?(?:[^)]*))+)?\)\]", data)
  237. if(m):
  238. results = m.groups()
  239. if(results[0] == title):
  240. data = re.sub("\[include\(((?:(?!\)\]|,).)*)((?:,\s?(?:[^)]*))+)?\)\]", "<b>" + results[0] + "</b>", data, 1)
  241. else:
  242. curs.execute("select * from data where title = '" + pymysql.escape_string(results[0]) + "'")
  243. rows = curs.fetchall()
  244. if(rows):
  245. curs.execute("select * from back where title = '" + pymysql.escape_string(results[0]) + "' and link = '" + pymysql.escape_string(title) + "' and type = 'include'")
  246. abb = curs.fetchall()
  247. if(not abb):
  248. curs.execute("insert into back (title, link, type) value ('" + pymysql.escape_string(results[0]) + "', '" + pymysql.escape_string(title) + "', 'include')")
  249. conn.commit()
  250. enddata = rows[0]['data']
  251. enddata = re.sub("\[include\(((?:(?!\)\]|,).)*)((?:,\s?(?:[^)]*))+)?\)\]", "", enddata)
  252. while(True):
  253. m = re.search("<((?:\/)?(?:div|span|embed|iframe)(?:[^>]*))>", enddata)
  254. if(m):
  255. g = m.groups()
  256. n = re.search('src="http(?:s)?:\/\/([^\/]*)\/(?:[^"]*)"', g[0])
  257. if(n):
  258. gm = n.groups()
  259. if(gm[0] == "www.youtube.com" or gm[0] == "serviceapi.nmv.naver.com" or gm[0] == "tv.kakao.com" or gm[0] == "tvple.com" or gm[0] == "tvpot.daum.net"):
  260. r = g[0]
  261. else:
  262. r = re.sub('src="([^"]*)"', '', g[0])
  263. else:
  264. r = g[0]
  265. r = re.sub('"', '#.#', r)
  266. enddata = re.sub("<((?:\/)?(?:div|span|embed|iframe)(?:[^>]*))>", "[" + r + "]", enddata, 1)
  267. else:
  268. break
  269. enddata = re.sub('<', '&lt;', enddata)
  270. enddata = re.sub('>', '&gt;', enddata)
  271. enddata = re.sub('"', '&quot;', enddata)
  272. enddata = re.sub("\[(?P<in>(?:\/)?(?:div|span|embed|iframe)(?:[^\]]*))\]", "<\g<in>>", enddata)
  273. enddata = re.sub('#.#', '"', enddata)
  274. while(True):
  275. p = re.compile("{{{((?:(?!{)(?!}).)*)}}}", re.DOTALL)
  276. m = p.search(enddata)
  277. if(m):
  278. nnn = m.groups()
  279. q = re.compile("^\+([1-5])\s(.*)$", re.DOTALL)
  280. n = q.search(nnn[0])
  281. w = re.compile("^\-([1-5])\s(.*)$", re.DOTALL)
  282. a = w.search(nnn[0])
  283. e = re.compile("^(#[0-9a-f-A-F]{6})\s(.*)$", re.DOTALL)
  284. b = e.search(nnn[0])
  285. r = re.compile("^(#[0-9a-f-A-F]{3})\s(.*)$", re.DOTALL)
  286. c = r.search(nnn[0])
  287. t = re.compile("^#(\w+)\s(.*)$", re.DOTALL)
  288. d = t.search(nnn[0])
  289. qqq = re.compile("^@([0-9a-f-A-F]{6})\s(.*)$", re.DOTALL)
  290. qqe = qqq.search(nnn[0])
  291. qqw = re.compile("^@([0-9a-f-A-F]{3})\s(.*)$", re.DOTALL)
  292. qqa = qqw.search(nnn[0])
  293. qwe = re.compile("^@(\w+)\s(.*)$", re.DOTALL)
  294. qsd = qwe.search(nnn[0])
  295. qawe = re.compile("^#!noin\s(.*)$", re.DOTALL)
  296. qasd = qawe.search(nnn[0])
  297. y = re.compile("^#!wiki\sstyle=&quot;((?:(?!&quot;|\n).)*)&quot;\n?\s\n(.*)$", re.DOTALL)
  298. l = y.search(nnn[0])
  299. html = re.compile("^#!html\s(.*)$", re.DOTALL)
  300. htmlr = html.search(nnn[0])
  301. ppp = re.compile("^#!folding\s((?:(?!\n).)*)\n?\s\n(.*)$", re.DOTALL)
  302. ooo = ppp.search(nnn[0])
  303. if(n):
  304. result = n.groups()
  305. enddata = p.sub('<span class="font-size-' + result[0] + '">' + result[1] + '</span>', enddata, 1)
  306. elif(a):
  307. result = a.groups()
  308. enddata = p.sub('<span class="font-size-small-' + result[0] + '">' + result[1] + '</span>', enddata, 1)
  309. elif(b):
  310. result = b.groups()
  311. enddata = p.sub('<span style="color:' + result[0] + '">' + result[1] + '</span>', enddata, 1)
  312. elif(c):
  313. result = c.groups()
  314. enddata = p.sub('<span style="color:' + result[0] + '">' + result[1] + '</span>', enddata, 1)
  315. elif(d):
  316. result = d.groups()
  317. enddata = p.sub('<span style="color:' + result[0] + '">' + result[1] + '</span>', enddata, 1)
  318. elif(qqe):
  319. result = qqe.groups()
  320. enddata = p.sub('<span style="background:#' + result[0] + '">' + result[1] + '</span>', enddata, 1)
  321. elif(qqa):
  322. result = qqa.groups()
  323. enddata = p.sub('<span style="background:#' + result[0] + '">' + result[1] + '</span>', enddata, 1)
  324. elif(qsd):
  325. result = qsd.groups()
  326. enddata = p.sub('<span style="background:' + result[0] + '">' + result[1] + '</span>', enddata, 1)
  327. elif(l):
  328. result = l.groups()
  329. enddata = p.sub('<div style="' + result[0] + '">' + result[1] + '</div>', enddata, 1)
  330. elif(htmlr):
  331. result = htmlr.groups()
  332. data = p.sub(result[0], enddata, 1)
  333. elif(ooo):
  334. result = ooo.groups()
  335. enddata = p.sub("<div>" + result[0] + "<span style='float:right;'><div id='folding_" + str(jjjj + 1) + "' style='display:block;'>[<a href='javascript:void(0);' onclick='var f=document.getElementById(\"folding_" + str(jjjj) + "\");var s=f.style.display==\"block\";f.style.display=s?\"none\":\"block\";this.className=s?\"\":\"opened\";var f=document.getElementById(\"folding_" + str(jjjj + 1) + "\");var s=f.style.display==\"none\";f.style.display=s?\"block\":\"none\";var f=document.getElementById(\"folding_" + str(jjjj + 2) + "\");var s=f.style.display==\"block\";f.style.display=s?\"none\":\"block\";'>펼치기</a>]</div><div id='folding_" + str(jjjj + 2) + "' style='display:none;'>[<a href='javascript:void(0);' onclick='var f=document.getElementById(\"folding_" + str(jjjj) + "\");var s=f.style.display==\"block\";f.style.display=s?\"none\":\"block\";this.className=s?\"\":\"opened\";var f=document.getElementById(\"folding_" + str(jjjj + 1) + "\");var s=f.style.display==\"none\";f.style.display=s?\"block\":\"none\";var f=document.getElementById(\"folding_" + str(jjjj + 2) + "\");var s=f.style.display==\"block\";f.style.display=s?\"none\":\"block\";'>접기</a>]</div></a></span><div id='folding_" + str(jjjj) + "' style='display:none;'><br>" + result[1] + "</div></div>", enddata, 1)
  336. jjjj = jjjj + 3
  337. elif(qasd):
  338. enddata = p.sub("", enddata, 1)
  339. else:
  340. enddata = p.sub('<code>' + nnn[0] + '</code>', enddata, 1)
  341. else:
  342. break
  343. while(True):
  344. a = re.compile("<code>(((?!<\/code>).)*)<\/code>", re.DOTALL)
  345. m = a.search(enddata)
  346. if(m):
  347. g = m.groups()
  348. j = re.sub("<\/span>", "}}}", g[0])
  349. j = re.sub("<\/div>", "}}}", j)
  350. j = re.sub('<span class="font\-size\-(?P<in>[1-6])">', "{{{+\g<in> ", j)
  351. j = re.sub('<span class="font\-size\-small\-(?P<in>[1-6])">', "{{{-\g<in> ", j)
  352. j = re.sub('<span style="color:(?:#)?(?P<in>[^"]*)">', "{{{#\g<in> ", j)
  353. j = re.sub('<span style="background:(?:#)?(?P<in>[^"]*)">', "{{{@\g<in> ", j)
  354. j = re.sub('<div style="(?P<in>[^"]*)">', "{{{#!wiki style=&quot;\g<in>&quot;\n", j)
  355. j = re.sub("(?P<in>.)", "<span>\g<in></span>", j)
  356. enddata = a.sub(j, enddata, 1)
  357. else:
  358. break
  359. enddata = re.sub("<span>&</span><span>l</span><span>t</span><span>;</span>", "<span>&lt;</span>", enddata)
  360. enddata = re.sub("<span>&</span><span>g</span><span>t</span><span>;</span>", "<span>&gt;</span>", enddata)
  361. if(results[1]):
  362. a = results[1]
  363. while(True):
  364. g = re.search("([^= ,]*)\=([^,]*)", a)
  365. if(g):
  366. result = g.groups()
  367. enddata = re.sub("@" + result[0] + "@", result[1], enddata)
  368. a = re.sub("([^= ,]*)\=([^,]*)", "", a, 1)
  369. else:
  370. break
  371. data = re.sub("\[include\(((?:(?!\)\]|,).)*)((?:,\s?(?:[^)]*))+)?\)\]", '\n<div>' + enddata + '</div>\n', data, 1)
  372. else:
  373. curs.execute("select * from back where title = '" + pymysql.escape_string(results[0]) + "' and link = '" + pymysql.escape_string(title) + "' and type = 'include'")
  374. abb = curs.fetchall()
  375. if(not abb):
  376. curs.execute("insert into back (title, link, type) value ('" + pymysql.escape_string(results[0]) + "', '" + pymysql.escape_string(title) + "', 'include')")
  377. conn.commit()
  378. data = re.sub("\[include\(((?:(?!\)\]|,).)*)((?:,\s?(?:[^)]*))+)?\)\]", "<a class=\"not_thing\" href=\"" + parse.quote(results[0]).replace('/','%2F') + "\">" + results[0] + "</a>", data, 1)
  379. else:
  380. break
  381. while(True):
  382. m = re.search('^#(?:redirect|넘겨주기)\s([^\n]*)', data)
  383. if(m):
  384. results = m.groups()
  385. aa = re.search("^(.*)(#(?:.*))$", results[0])
  386. if(aa):
  387. results = aa.groups()
  388. data = re.sub('^#(?:redirect|넘겨주기)\s([^\n]*)', '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(results[0]).replace('/','%2F') + '/from/' + parse.quote(title).replace('/','%2F') + results[1] + '" />', data, 1)
  389. else:
  390. data = re.sub('^#(?:redirect|넘겨주기)\s([^\n]*)', '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(results[0]).replace('/','%2F') + '/from/' + parse.quote(title).replace('/','%2F') + '" />', data, 1)
  391. curs.execute("select * from back where title = '" + pymysql.escape_string(results[0]) + "' and link = '" + pymysql.escape_string(title) + "' and type = 'redirect'")
  392. abb = curs.fetchall()
  393. if(not abb):
  394. curs.execute("insert into back (title, link, type) value ('" + pymysql.escape_string(results[0]) + "', '" + pymysql.escape_string(title) + "', 'redirect')")
  395. conn.commit()
  396. else:
  397. break
  398. data = '\n' + data + '\n'
  399. while(True):
  400. m = re.search("\n&gt;\s?((?:[^\n]*)(?:(?:(?:(?:\n&gt;\s?)(?:[^\n]*))+)?))", data)
  401. if(m):
  402. result = m.groups()
  403. blockquote = result[0]
  404. blockquote = re.sub("\n&gt;\s?", "\n", blockquote)
  405. data = re.sub("\n&gt;\s?((?:[^\n]*)(?:(?:(?:(?:\n&gt;\s?)(?:[^\n]*))+)?))", "\n<blockquote>" + blockquote + "</blockquote>", data, 1)
  406. else:
  407. break
  408. m = re.search('\[목차\]', data)
  409. if(not m):
  410. data = re.sub("(?P<in>(={1,6})\s?([^=]*)\s?(?:={1,6})(?:\s+)?\n)", "[목차]\n\g<in>", data, 1)
  411. i = 0
  412. h0c = 0
  413. h1c = 0
  414. h2c = 0
  415. h3c = 0
  416. h4c = 0
  417. h5c = 0
  418. last = 0
  419. rtoc = '<div id="toc"><span id="toc-name">목차</span><br><br>'
  420. while(True):
  421. i = i + 1
  422. m = re.search('(={1,6})\s?([^=]*)\s?(?:={1,6})(?:\s+)?\n', data)
  423. if(m):
  424. result = m.groups()
  425. wiki = len(result[0])
  426. if(last < wiki):
  427. last = wiki
  428. else:
  429. last = wiki;
  430. if(wiki == 1):
  431. h1c = 0
  432. h2c = 0
  433. h3c = 0
  434. h4c = 0
  435. h5c = 0
  436. elif(wiki == 2):
  437. h2c = 0
  438. h3c = 0
  439. h4c = 0
  440. h5c = 0
  441. elif(wiki == 3):
  442. h3c = 0
  443. h4c = 0
  444. h5c = 0
  445. elif(wiki == 4):
  446. h4c = 0
  447. h5c = 0
  448. elif(wiki == 5):
  449. h5c = 0
  450. if(wiki == 1):
  451. h0c = h0c + 1
  452. elif(wiki == 2):
  453. h1c = h1c + 1
  454. elif(wiki == 3):
  455. h2c = h2c + 1
  456. elif(wiki == 4):
  457. h3c = h3c + 1
  458. elif(wiki == 5):
  459. h4c = h4c + 1
  460. else:
  461. h5c = h5c + 1
  462. toc = str(h0c) + '.' + str(h1c) + '.' + str(h2c) + '.' + str(h3c) + '.' + str(h4c) + '.' + str(h5c) + '.'
  463. toc = re.sub("(?P<in>[0-9]0(?:[0]*)?)\.", '\g<in>#.', toc)
  464. toc = re.sub("0\.", '', toc)
  465. toc = re.sub("#\.", '.', toc)
  466. toc = re.sub("\.$", '', toc)
  467. rtoc = rtoc + '<a href="#s-' + toc + '">' + toc + '</a>. ' + result[1] + '<br>'
  468. c = re.sub(" $", "", result[1])
  469. data = re.sub('(={1,6})\s?([^=]*)\s?(?:={1,6})(?:\s+)?\n', '<h' + str(wiki) + ' id="' + c + '"><a href="#toc" id="s-' + toc + '">' + toc + '.</a> ' + c + ' <span style="font-size:11px;">[<a href="/edit/' + parse.quote(title).replace('/','%2F') + '/section/' + str(i) + '">편집</a>]</span></h' + str(wiki) + '>', data, 1);
  470. else:
  471. rtoc = rtoc + '</div>'
  472. break
  473. data = re.sub("\[목차\]", rtoc, data)
  474. category = ''
  475. while(True):
  476. m = re.search("\[\[(분류:(?:(?:(?!\]\]).)*))\]\]", data)
  477. if(m):
  478. g = m.groups()
  479. if(not title == g[0]):
  480. curs.execute("select * from cat where title = '" + pymysql.escape_string(g[0]) + "' and cat = '" + pymysql.escape_string(title) + "'")
  481. abb = curs.fetchall()
  482. if(not abb):
  483. curs.execute("insert into cat (title, cat) value ('" + pymysql.escape_string(g[0]) + "', '" + pymysql.escape_string(title) + "')")
  484. conn.commit()
  485. if(category == ''):
  486. curs.execute("select * from data where title = '" + pymysql.escape_string(g[0]) + "'")
  487. exists = curs.fetchall()
  488. if(exists):
  489. red = ""
  490. else:
  491. red = 'class="not_thing"'
  492. category = category + '<a ' + red + ' href="/w/' + parse.quote(g[0]).replace('/','%2F') + '">' + re.sub("분류:", "", g[0]) + '</a>'
  493. else:
  494. curs.execute("select * from data where title = '" + pymysql.escape_string(g[0]) + "'")
  495. exists = curs.fetchall()
  496. if(exists):
  497. red = ""
  498. else:
  499. red = 'class="not_thing"'
  500. category = category + ' / ' + '<a ' + red + ' href="/w/' + parse.quote(g[0]).replace('/','%2F') + '">' + re.sub("분류:", "", g[0]) + '</a>'
  501. data = re.sub("\[\[(분류:(?:(?:(?!\]\]).)*))\]\]", '', data, 1)
  502. else:
  503. break
  504. data = re.sub("'''(?P<in>.+?)'''(?!')", '<b>\g<in></b>', data)
  505. data = re.sub("''(?P<in>.+?)''(?!')", '<i>\g<in></i>', data)
  506. data = re.sub('~~(?P<in>.+?)~~(?!~)', '<s>\g<in></s>', data)
  507. data = re.sub('--(?P<in>.+?)--(?!-)', '<s>\g<in></s>', data)
  508. data = re.sub('__(?P<in>.+?)__(?!_)', '<u>\g<in></u>', data)
  509. data = re.sub('\^\^(?P<in>.+?)\^\^(?!\^)', '<sup>\g<in></sup>', data)
  510. data = re.sub(',,(?P<in>.+?),,(?!,)', '<sub>\g<in></sub>', data)
  511. data = re.sub('&lt;math&gt;(?P<in>((?!&lt;math&gt;).)*)&lt;\/math&gt;', '$\g<in>$', data)
  512. data = re.sub('{{\|(?P<in>(?:(?:(?:(?!\|}}).)*)(?:\n?))+)\|}}', '<table><tbody><tr><td>\g<in></td></tr></tbody></table>', data)
  513. data = re.sub('\[ruby\((?P<in>[^\|]*)\|(?P<out>[^\)]*)\)\]', '<ruby>\g<in><rp>(</rp><rt>\g<out></rt><rp>)</rp></ruby>', data)
  514. data = re.sub("##\s?(?P<in>[^\n]*)\n", "<div style='display:none;'>\g<in></div>", data);
  515. while(True):
  516. m = re.search("\[\[파일:((?:(?!\]\]|\|).)*)(?:\|((?:(?!\]\]).)*))?\]\]", data)
  517. if(m):
  518. c = m.groups()
  519. if(c[1]):
  520. n = re.search("width=([^ \n&]*)", c[1])
  521. e = re.search("height=([^ \n&]*)", c[1])
  522. if(n):
  523. a = n.groups()
  524. width = a[0]
  525. else:
  526. width = ''
  527. if(e):
  528. b = e.groups()
  529. height = b[0]
  530. else:
  531. height = ''
  532. img = re.sub("\.(?P<in>[Jj][Pp][Gg]|[Pp][Nn][Gg]|[Gg][Ii][Ff]|[Jj][Pp][Ee][Gg])", "#\g<in>#", c[0])
  533. data = re.sub("\[\[파일:((?:(?!\]\]|\?).)*)(?:\?((?:(?!\]\]).)*))?\]\]", '<a href="/w/파일:' + img + '"><img src="/image/' + img + '" width="' + width + '" height="' + height + '"></a>', data, 1)
  534. else:
  535. img = re.sub("\.(?P<in>[Jj][Pp][Gg]|[Pp][Nn][Gg]|[Gg][Ii][Ff]|[Jj][Pp][Ee][Gg])", "#\g<in>#", c[0])
  536. data = re.sub("\[\[파일:((?:(?!\]\]|\?).)*)(?:\?((?:(?!\]\]).)*))?\]\]", "<a href='/w/파일:" + img + "'><img src='/image/" + img + "'></a>", data, 1)
  537. if(not re.search("^파일:([^\n]*)", title)):
  538. curs.execute("select * from back where title = '" + pymysql.escape_string(c[0]) + "' and link = '" + pymysql.escape_string(title) + "' and type = 'redirect'")
  539. abb = curs.fetchall()
  540. if(not abb):
  541. curs.execute("insert into back (title, link, type) value ('파일:" + pymysql.escape_string(c[0]) + "', '" + pymysql.escape_string(title) + "', 'file')")
  542. conn.commit()
  543. else:
  544. break
  545. data = re.sub("\[br\]",'<br>', data);
  546. while(True):
  547. m = re.search("\[youtube\(((?:(?!,|\)\]).)*)(?:,\s)?(?:width=((?:(?!,|\)\]).)*))?(?:,\s)?(?:height=((?:(?!,|\)\]).)*))?(?:,\s)?(?:width=((?:(?!,|\)\]).)*))?\)\]", data)
  548. if(m):
  549. result = m.groups()
  550. if(result[1]):
  551. if(result[2]):
  552. width = result[1]
  553. height = result[2]
  554. else:
  555. width = result[1]
  556. height = '315'
  557. elif(result[2]):
  558. if(result[3]):
  559. height = result[2]
  560. width = result[3]
  561. else:
  562. height = result[2]
  563. width = '560'
  564. else:
  565. width = '560'
  566. height = '315'
  567. data = re.sub("\[youtube\(((?:(?!,|\)\]).)*)(?:,\s)?(?:width=((?:(?!,|\)\]).)*))?(?:,\s)?(?:height=((?:(?!,|\)\]).)*))?(?:,\s)?(?:width=((?:(?!,|\)\]).)*))?\)\]", '<iframe width="' + width + '" height="' + height + '" src="https://www.youtube.com/embed/' + result[0] + '" frameborder="0" allowfullscreen></iframe>', data, 1)
  568. else:
  569. break
  570. data = re.sub("\[\[(?::(?P<in>(?:분류|파일):(?:(?:(?!\]\]).)*)))\]\]", "[[\g<in>]]", data)
  571. while(True):
  572. m = re.search("\[\[(((?!\]\]).)*)\]\]", data)
  573. if(m):
  574. result = m.groups()
  575. a = re.search("((?:(?!\|).)*)\|(.*)", result[0])
  576. if(a):
  577. results = a.groups()
  578. aa = re.search("^(.*)(#(?:.*))$", results[0])
  579. if(aa):
  580. g = results[1]
  581. results = aa.groups()
  582. b = re.search("^http(?:s)?:\/\/", results[0])
  583. if(b):
  584. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a class="out_link" href="' + results[0] + results[1] + '">' + g + '</a>', data, 1)
  585. else:
  586. if(results[0] == title):
  587. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<b>' + g + '</b>', data, 1)
  588. else:
  589. curs.execute("select * from data where title = '" + pymysql.escape_string(results[0]) + "'")
  590. rows = curs.fetchall()
  591. if(rows):
  592. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a title="' + results[0] + results[1] + '" href="/w/' + parse.quote(results[0]).replace('/','%2F') + results[1] + '">' + g + '</a>', data, 1)
  593. else:
  594. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a title="' + results[0] + results[1] + '" class="not_thing" href="/w/' + parse.quote(results[0]).replace('/','%2F') + results[1] + '">' + g + '</a>', data, 1)
  595. curs.execute("select * from back where title = '" + pymysql.escape_string(results[0]) + "' and link = '" + pymysql.escape_string(title) + "'")
  596. rows = curs.fetchall()
  597. if(not rows):
  598. curs.execute("insert into back (title, link, type) value ('" + pymysql.escape_string(results[0]) + "', '" + pymysql.escape_string(title) + "', '')")
  599. conn.commit()
  600. else:
  601. b = re.search("^http(?:s)?:\/\/", results[0])
  602. if(b):
  603. c = re.search("(?:\.[Jj][Pp][Gg]|\.[Pp][Nn][Gg]|\.[Gg][Ii][Ff]|\.[Jj][Pp][Ee][Gg])", results[0])
  604. if(c):
  605. img = results[0]
  606. img = re.sub("\.(?P<in>[Jj][Pp][Gg]|[Pp][Nn][Gg]|[Gg][Ii][Ff]|[Jj][Pp][Ee][Gg])", "#\g<in>#", img)
  607. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a class="out_link" href="' + img + '">' + results[1] + '</a>', data, 1)
  608. else:
  609. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a class="out_link" href="' + results[0] + '">' + results[1] + '</a>', data, 1)
  610. else:
  611. if(results[0] == title):
  612. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<b>' + results[1] + '</b>', data, 1)
  613. else:
  614. curs.execute("select * from data where title = '" + pymysql.escape_string(results[0]) + "'")
  615. rows = curs.fetchall()
  616. if(rows):
  617. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a title="' + results[0] + '" href="/w/' + parse.quote(results[0]).replace('/','%2F') + '">' + results[1] + '</a>', data, 1)
  618. else:
  619. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a title="' + results[0] + '" class="not_thing" href="/w/' + parse.quote(results[0]).replace('/','%2F') + '">' + results[1] + '</a>', data, 1)
  620. curs.execute("select * from back where title = '" + pymysql.escape_string(results[0]) + "' and link = '" + pymysql.escape_string(title) + "'")
  621. rows = curs.fetchall()
  622. if(not rows):
  623. curs.execute("insert into back (title, link, type) value ('" + pymysql.escape_string(results[0]) + "', '" + pymysql.escape_string(title) + "', '')")
  624. conn.commit()
  625. else:
  626. aa = re.search("^(.*)(#(?:.*))$", result[0])
  627. if(aa):
  628. result = aa.groups()
  629. b = re.search("^http(?:s)?:\/\/", result[0])
  630. if(b):
  631. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a class="out_link" href="' + result[0] + result[1] + '">' + result[0] + result[1] + '</a>', data, 1)
  632. else:
  633. if(result[0] == title):
  634. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<b>' + result[0] + result[1] + '</b>', data, 1)
  635. else:
  636. curs.execute("select * from data where title = '" + pymysql.escape_string(result[0]) + "'")
  637. rows = curs.fetchall()
  638. if(rows):
  639. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a href="/w/' + parse.quote(result[0]).replace('/','%2F') + result[1] + '">' + result[0] + result[1] + '</a>', data, 1)
  640. else:
  641. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a class="not_thing" href="/w/' + parse.quote(result[0]).replace('/','%2F') + result[1] + '">' + result[0] + result[1] + '</a>', data, 1)
  642. curs.execute("select * from back where title = '" + pymysql.escape_string(result[0]) + "' and link = '" + pymysql.escape_string(title) + "'")
  643. rows = curs.fetchall()
  644. if(not rows):
  645. curs.execute("insert into back (title, link, type) value ('" + pymysql.escape_string(result[0]) + "', '" + pymysql.escape_string(title) + "', '')")
  646. conn.commit()
  647. else:
  648. b = re.search("^http(?:s)?:\/\/", result[0])
  649. if(b):
  650. c = re.search("(?:\.[Jj][Pp][Gg]|\.[Pp][Nn][Gg]|\.[Gg][Ii][Ff]|\.[Jj][Pp][Ee][Gg])", result[0])
  651. if(c):
  652. img = result[0]
  653. img = re.sub("\.(?P<in>[Jj][Pp][Gg]|[Pp][Nn][Gg]|[Gg][Ii][Ff]|[Jj][Pp][Ee][Gg])", "#\g<in>#", img)
  654. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a class="out_link" href="' + img + '">' + img + '</a>', data, 1)
  655. else:
  656. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a class="out_link" href="' + result[0] + '">' + result[0] + '</a>', data, 1)
  657. else:
  658. if(result[0] == title):
  659. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<b>' + result[0] + '</b>', data, 1)
  660. else:
  661. curs.execute("select * from data where title = '" + pymysql.escape_string(result[0]) + "'")
  662. rows = curs.fetchall()
  663. if(rows):
  664. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a href="/w/' + parse.quote(result[0]).replace('/','%2F') + '">' + result[0] + '</a>', data, 1)
  665. else:
  666. data = re.sub('\[\[(((?!\]\]).)*)\]\]', '<a class="not_thing" href="/w/' + parse.quote(result[0]).replace('/','%2F') + '">' + result[0] + '</a>', data, 1)
  667. curs.execute("select * from back where title = '" + pymysql.escape_string(result[0]) + "' and link = '" + pymysql.escape_string(title) + "'")
  668. rows = curs.fetchall()
  669. if(not rows):
  670. curs.execute("insert into back (title, link, type) value ('" + pymysql.escape_string(result[0]) + "', '" + pymysql.escape_string(title) + "', '')")
  671. conn.commit()
  672. else:
  673. break
  674. while(True):
  675. m = re.search("(http(?:s)?:\/\/(?:(?:(?:(?!\.[Jj][Pp][Gg]|\.[Pp][Nn][Gg]|\.[Gg][Ii][Ff]|\.[Jj][Pp][Ee][Gg]|#[Jj][Pp][Gg]#|#[Pp][Nn][Gg]#|#[Gg][Ii][Ff]#|#[Jj][Pp][Ee][Gg]#).)*)(?:\.[Jj][Pp][Gg]|\.[Pp][Nn][Gg]|\.[Gg][Ii][Ff]|\.[Jj][Pp][Ee][Gg])))(?:(?:(?:\?)width=((?:[0-9]*)(?:px|%)?))?(?:(?:\?|&)height=((?:[0-9]*)(?:px|%)?))?(?:(?:&)width=((?:[0-9]*)(?:px|%)?))?)?", data)
  676. if(m):
  677. result = m.groups()
  678. if(result[1]):
  679. if(result[2]):
  680. width = result[1]
  681. height = result[2]
  682. else:
  683. width = result[1]
  684. height = ''
  685. elif(result[2]):
  686. if(result[3]):
  687. height = result[2]
  688. width = result[3]
  689. else:
  690. height = result[2]
  691. width = ''
  692. else:
  693. width = ''
  694. height = ''
  695. c = result[0]
  696. c = re.sub("\.(?P<in>[Jj][Pp][Gg]|[Pp][Nn][Gg]|[Gg][Ii][Ff]|[Jj][Pp][Ee][Gg])", "#\g<in>#", c)
  697. data = re.sub("(http(?:s)?:\/\/(?:(?:(?:(?!\.[Jj][Pp][Gg]|\.[Pp][Nn][Gg]|\.[Gg][Ii][Ff]|\.[Jj][Pp][Ee][Gg]|#[Jj][Pp][Gg]#|#[Pp][Nn][Gg]#|#[Gg][Ii][Ff]#|#[Jj][Pp][Ee][Gg]#).)*)(?:\.[Jj][Pp][Gg]|\.[Pp][Nn][Gg]|\.[Gg][Ii][Ff]|\.[Jj][Pp][Ee][Gg])))(?:(?:(?:\?)width=((?:[0-9]*)(?:px)?))?(?:(?:\?|&)height=((?:[0-9]*)(?:px)?))?(?:(?:&)width=((?:[0-9]*)(?:px)?))?)?", "<img width='" + width + "' height='" + height + "' src='" + c + "'>", data, 1)
  698. else:
  699. break
  700. while(True):
  701. m = re.search("((?:(?:\s\*\s[^\n]*)\n?)+)", data)
  702. if(m):
  703. result = m.groups()
  704. end = str(result[0])
  705. end = re.sub("\s\*\s(?P<in>[^\n]*)", "<li>\g<in></li>", end)
  706. end = re.sub("\n", '', end)
  707. data = re.sub("((?:(?:\s\*\s[^\n]*)\n?)+)", '<ul id="list">' + end + '</ul>', data, 1)
  708. else:
  709. break
  710. data = re.sub('\[date\]', getnow(), data)
  711. data = re.sub("#(?P<in>[Jj][Pp][Gg]|[Pp][Nn][Gg]|[Gg][Ii][Ff]|[Jj][Pp][Ee][Gg])#", ".\g<in>", data)
  712. data = re.sub("-{4,11}", "<hr>", data)
  713. while(True):
  714. b = re.search("\r\n( +)", data)
  715. if(b):
  716. result = b.groups()
  717. tp = len(result[0])
  718. up = ''
  719. i = 0
  720. while(True):
  721. up = up + '<span id="in"></span>'
  722. i = i + 1
  723. if(i == tp):
  724. break
  725. data = re.sub("\r\n( +)", '<br>' + up, data, 1)
  726. else:
  727. break
  728. a = 1
  729. tou = "<hr id='footnote'><div class='wiki-macro-footnote'><br>"
  730. while(True):
  731. b = re.search("\[\*([^\s]*)\s(((?!\]).)*)\]", data)
  732. if(b):
  733. results = b.groups()
  734. if(results[0]):
  735. c = results[1]
  736. c = re.sub("<(?:[^>]*)>", '', c)
  737. tou = tou + "<span class='footnote-list'><a href=\"#rfn-" + str(a) + "\" id=\"fn-" + str(a) + "\">[" + results[0] + "]</a> " + results[1] + "</span><br>"
  738. data = re.sub("\[\*([^\s]*)\s(((?!\]).)*)\]", "<sup><a class=\"footnotes\" title=\"" + c + "\" id=\"rfn-" + str(a) + "\" href=\"#fn-" + str(a) + "\">[" + results[0] + "]</a></sup>", data, 1)
  739. else:
  740. c = results[1]
  741. c = re.sub("<(?:[^>]*)>", '', c)
  742. tou = tou + "<span class='footnote-list'><a href=\"#rfn-" + str(a) + "\" id=\"fn-" + str(a) + "\">[" + str(a) + "]</a> " + results[1] + "</span><br>"
  743. data = re.sub("\[\*([^\s]*)\s(((?!\]).)*)\]", '<sup><a class="footnotes" title="' + c + '" id="rfn-' + str(a) + '" href="#fn-' + str(a) + '">[' + str(a) + ']</a></sup>', data, 1)
  744. a = a + 1
  745. else:
  746. tou = tou + '</div>'
  747. if(tou == "<hr id='footnote'><div class='wiki-macro-footnote'><br></div>"):
  748. tou = ""
  749. break
  750. data = re.sub("\[각주\](?:(?:<br>| |\r|\n)+)?$", "", data)
  751. data = re.sub("(?:(?:<br>| |\r|\n)+)$", "", data)
  752. data = re.sub("\[각주\]", "<br>" + tou, data)
  753. data = data + tou
  754. if(category):
  755. data = data + '<div style="width:100%;border: 1px solid #777;padding: 5px;margin-top: 1em;">분류: ' + category + '</div>'
  756. while(True):
  757. m = re.search("(\|\|(?:(?:(?:.*)\n?)\|\|)+)", data)
  758. if(m):
  759. results = m.groups()
  760. table = results[0]
  761. while(True):
  762. a = re.search("^(\|\|(?:(?:\|\|)+)?)((?:&lt;(?:(?:(?!&gt;).)*)&gt;)+)?", table)
  763. if(a):
  764. row = ''
  765. cel = ''
  766. celstyle = ''
  767. rowstyle = ''
  768. alltable = ''
  769. result = a.groups()
  770. if(result[1]):
  771. q = re.search("&lt;table\s?width=((?:(?!&gt;).)*)&gt;", result[1])
  772. w = re.search("&lt;table\s?height=((?:(?!&gt;).)*)&gt;", result[1])
  773. e = re.search("&lt;table\s?align=((?:(?!&gt;).)*)&gt;", result[1])
  774. alltable = 'style="'
  775. celstyle = 'style="'
  776. rowstyle = 'style="'
  777. if(q):
  778. resultss = q.groups()
  779. alltable = alltable + 'width:' + resultss[0] + ';'
  780. if(w):
  781. resultss = w.groups()
  782. alltable = alltable + 'height:' + resultss[0] + ';'
  783. if(e):
  784. resultss = e.groups()
  785. if(resultss[0] == 'right'):
  786. alltable = alltable + 'margin-left:auto;'
  787. elif(resultss[0] == 'center'):
  788. alltable = alltable + 'margin:auto;'
  789. else:
  790. alltable = alltable + 'margin-right:auto;'
  791. ee = re.search("&lt;table\s?textalign=((?:(?!&gt;).)*)&gt;", result[1])
  792. if(ee):
  793. resultss = ee.groups()
  794. if(resultss[0] == 'right'):
  795. alltable = alltable + 'text-align:right;'
  796. elif(resultss[0] == 'center'):
  797. alltable = alltable + 'text-align:center;'
  798. else:
  799. alltable = alltable + 'text-align:left;'
  800. r = re.search("&lt;-((?:(?!&gt;).)*)&gt;", result[1])
  801. if(r):
  802. resultss = r.groups()
  803. cel = 'colspan="' + resultss[0] + '"'
  804. else:
  805. cel = 'colspan="' + str(round(len(result[0]) / 2)) + '"'
  806. t = re.search("&lt;\|((?:(?!&gt;).)*)&gt;", result[1])
  807. if(t):
  808. resultss = t.groups()
  809. row = 'rowspan="' + resultss[0] + '"'
  810. ba = re.search("&lt;rowbgcolor=(#[0-9a-f-A-F]{6})&gt;", result[1])
  811. bb = re.search("&lt;rowbgcolor=(#[0-9a-f-A-F]{3})&gt;", result[1])
  812. bc = re.search("&lt;rowbgcolor=(\w+)&gt;", result[1])
  813. if(ba):
  814. resultss = ba.groups()
  815. rowstyle = rowstyle + 'background:' + resultss[0] + ';'
  816. elif(bb):
  817. resultss = bb.groups()
  818. rowstyle = rowstyle + 'background:' + resultss[0] + ';'
  819. elif(bc):
  820. resultss = bc.groups()
  821. rowstyle = rowstyle + 'background:' + resultss[0] + ';'
  822. z = re.search("&lt;table\s?bordercolor=(#[0-9a-f-A-F]{6})&gt;", result[1])
  823. x = re.search("&lt;table\s?bordercolor=(#[0-9a-f-A-F]{3})&gt;", result[1])
  824. c = re.search("&lt;table\s?bordercolor=(\w+)&gt;", result[1])
  825. if(z):
  826. resultss = z.groups()
  827. alltable = alltable + 'border:' + resultss[0] + ' 2px solid;'
  828. elif(x):
  829. resultss = x.groups()
  830. alltable = alltable + 'border:' + resultss[0] + ' 2px solid;'
  831. elif(c):
  832. resultss = c.groups()
  833. alltable = alltable + 'border:' + resultss[0] + ' 2px solid;'
  834. aq = re.search("&lt;table\s?bgcolor=(#[0-9a-f-A-F]{6})&gt;", result[1])
  835. aw = re.search("&lt;table\s?bgcolor=(#[0-9a-f-A-F]{3})&gt;", result[1])
  836. ae = re.search("&lt;table\s?bgcolor=(\w+)&gt;", result[1])
  837. if(aq):
  838. resultss = aq.groups()
  839. alltable = alltable + 'background:' + resultss[0] + ';'
  840. elif(aw):
  841. resultss = aw.groups()
  842. alltable = alltable + 'background:' + resultss[0] + ';'
  843. elif(ae):
  844. resultss = ae.groups()
  845. alltable = alltable + 'background:' + resultss[0] + ';'
  846. j = re.search("&lt;bgcolor=(#[0-9a-f-A-F]{6})&gt;", result[1])
  847. k = re.search("&lt;bgcolor=(#[0-9a-f-A-F]{3})&gt;", result[1])
  848. l = re.search("&lt;bgcolor=(\w+)&gt;", result[1])
  849. if(j):
  850. resultss = j.groups()
  851. celstyle = celstyle + 'background:' + resultss[0] + ';'
  852. elif(k):
  853. resultss = k.groups()
  854. celstyle = celstyle + 'background:' + resultss[0] + ';'
  855. elif(l):
  856. resultss = l.groups()
  857. celstyle = celstyle + 'background:' + resultss[0] + ';'
  858. aa = re.search("&lt;(#[0-9a-f-A-F]{6})&gt;", result[1])
  859. ab = re.search("&lt;(#[0-9a-f-A-F]{3})&gt;", result[1])
  860. ac = re.search("&lt;(\w+)&gt;", result[1])
  861. if(aa):
  862. resultss = aa.groups()
  863. celstyle = celstyle + 'background:' + resultss[0] + ';'
  864. elif(ab):
  865. resultss = ab.groups()
  866. celstyle = celstyle + 'background:' + resultss[0] + ';'
  867. elif(ac):
  868. resultss = ac.groups()
  869. celstyle = celstyle + 'background:' + resultss[0] + ';'
  870. qa = re.search("&lt;width=((?:(?!&gt;).)*)&gt;", result[1])
  871. qb = re.search("&lt;height=((?:(?!&gt;).)*)&gt;", result[1])
  872. if(qa):
  873. resultss = qa.groups()
  874. celstyle = celstyle + 'width:' + resultss[0] + ';'
  875. if(qb):
  876. resultss = qb.groups()
  877. celstyle = celstyle + 'height:' + resultss[0] + ';'
  878. i = re.search("&lt;\)&gt;", result[1])
  879. o = re.search("&lt;:&gt;", result[1])
  880. p = re.search("&lt;\(&gt;", result[1])
  881. if(i):
  882. celstyle = celstyle + 'text-align:right;'
  883. elif(o):
  884. celstyle = celstyle + 'text-align:center;'
  885. elif(p):
  886. celstyle = celstyle + 'text-align:left;'
  887. alltable = alltable + '"'
  888. celstyle = celstyle + '"'
  889. rowstyle = rowstyle + '"'
  890. table = re.sub("^(\|\|(?:(?:\|\|)+)?)((?:&lt;(?:(?:(?!&gt;).)*)&gt;)+)?", "<table " + alltable + "><tbody><tr " + rowstyle + "><td " + cel + " " + row + " " + celstyle + ">", table, 1)
  891. else:
  892. cel = 'colspan="' + str(round(len(result[0]) / 2)) + '"'
  893. table = re.sub("^(\|\|(?:(?:\|\|)+)?)((?:&lt;(?:(?:(?!&gt;).)*)&gt;)+)?", "<table><tbody><tr><td " + cel + ">", table, 1)
  894. else:
  895. break
  896. table = re.sub("\|\|$", "</td></tr></tbody></table>", table)
  897. while(True):
  898. b = re.search("\|\|\r\n(\|\|(?:(?:\|\|)+)?)((?:&lt;(?:(?:(?!&gt;).)*)&gt;)+)?", table)
  899. if(b):
  900. row = ''
  901. cel = ''
  902. celstyle = ''
  903. rowstyle = ''
  904. result = b.groups()
  905. if(result[1]):
  906. celstyle = 'style="'
  907. rowstyle = 'style="'
  908. r = re.search("&lt;-((?:(?!&gt;).)*)&gt;", result[1])
  909. if(r):
  910. resultss = r.groups()
  911. cel = 'colspan="' + resultss[0] + '"'
  912. else:
  913. cel = 'colspan="' + str(round(len(result[0]) / 2)) + '"'
  914. t = re.search("&lt;\|((?:(?!&gt;).)*)&gt;", result[1])
  915. if(t):
  916. resultss = t.groups()
  917. row = 'rowspan="' + resultss[0] + '"'
  918. ba = re.search("&lt;rowbgcolor=(#[0-9a-f-A-F]{6})&gt;", result[1])
  919. bb = re.search("&lt;rowbgcolor=(#[0-9a-f-A-F]{3})&gt;", result[1])
  920. bc = re.search("&lt;rowbgcolor=(\w+)&gt;", result[1])
  921. if(ba):
  922. resultss = ba.groups()
  923. rowstyle = rowstyle + 'background:' + resultss[0] + ';'
  924. elif(bb):
  925. resultss = bb.groups()
  926. rowstyle = rowstyle + 'background:' + resultss[0] + ';'
  927. elif(bc):
  928. resultss = bc.groups()
  929. rowstyle = rowstyle + 'background:' + resultss[0] + ';'
  930. j = re.search("&lt;bgcolor=(#[0-9a-f-A-F]{6})&gt;", result[1])
  931. k = re.search("&lt;bgcolor=(#[0-9a-f-A-F]{3})&gt;", result[1])
  932. l = re.search("&lt;bgcolor=(\w+)&gt;", result[1])
  933. if(j):
  934. resultss = j.groups()
  935. celstyle = celstyle + 'background:' + resultss[0] + ';'
  936. elif(k):
  937. resultss = k.groups()
  938. celstyle = celstyle + 'background:' + resultss[0] + ';'
  939. elif(l):
  940. resultss = l.groups()
  941. celstyle = celstyle + 'background:' + resultss[0] + ';'
  942. aa = re.search("&lt;(#[0-9a-f-A-F]{6})&gt;", result[1])
  943. ab = re.search("&lt;(#[0-9a-f-A-F]{3})&gt;", result[1])
  944. ac = re.search("&lt;(\w+)&gt;", result[1])
  945. if(aa):
  946. resultss = aa.groups()
  947. celstyle = celstyle + 'background:' + resultss[0] + ';'
  948. elif(ab):
  949. resultss = ab.groups()
  950. celstyle = celstyle + 'background:' + resultss[0] + ';'
  951. elif(ac):
  952. resultss = ac.groups()
  953. celstyle = celstyle + 'background:' + resultss[0] + ';'
  954. qa = re.search("&lt;width=((?:(?!&gt;).)*)&gt;", result[1])
  955. qb = re.search("&lt;height=((?:(?!&gt;).)*)&gt;", result[1])
  956. if(qa):
  957. resultss = qa.groups()
  958. celstyle = celstyle + 'width:' + resultss[0] + ';'
  959. if(qb):
  960. resultss = qb.groups()
  961. celstyle = celstyle + 'height:' + resultss[0] + ';'
  962. i = re.search("&lt;\)&gt;", result[1])
  963. o = re.search("&lt;:&gt;", result[1])
  964. p = re.search("&lt;\(&gt;", result[1])
  965. if(i):
  966. celstyle = celstyle + 'text-align:right;'
  967. elif(o):
  968. celstyle = celstyle + 'text-align:center;'
  969. elif(p):
  970. celstyle = celstyle + 'text-align:left;'
  971. celstyle = celstyle + '"'
  972. rowstyle = rowstyle + '"'
  973. table = re.sub("\|\|\r\n(\|\|(?:(?:\|\|)+)?)((?:&lt;(?:(?:(?!&gt;).)*)&gt;)+)?", "</td></tr><tr " + rowstyle + "><td " + cel + " " + row + " " + celstyle + ">", table, 1)
  974. else:
  975. cel = 'colspan="' + str(round(len(result[0]) / 2)) + '"'
  976. table = re.sub("\|\|\r\n(\|\|(?:(?:\|\|)+)?)((?:&lt;(?:(?:(?!&gt;).)*)&gt;)+)?", "</td></tr><tr><td " + cel + ">", table, 1)
  977. else:
  978. break
  979. while(True):
  980. c = re.search("(\|\|(?:(?:\|\|)+)?)((?:&lt;(?:(?:(?!&gt;).)*)&gt;)+)?", table)
  981. if(c):
  982. row = ''
  983. cel = ''
  984. celstyle = ''
  985. result = c.groups()
  986. if(result[1]):
  987. celstyle = 'style="'
  988. r = re.search("&lt;-((?:(?!&gt;).)*)&gt;", result[1])
  989. if(r):
  990. resultss = r.groups()
  991. cel = 'colspan="' + resultss[0] + '"';
  992. else:
  993. cel = 'colspan="' + str(round(len(result[0]) / 2)) + '"'
  994. t = re.search("&lt;\|((?:(?!&gt;).)*)&gt;", result[1])
  995. if(t):
  996. resultss = t.groups()
  997. row = 'rowspan="' + resultss[0] + '"';
  998. j = re.search("&lt;bgcolor=(#[0-9a-f-A-F]{6})&gt;", result[1])
  999. k = re.search("&lt;bgcolor=(#[0-9a-f-A-F]{3})&gt;", result[1])
  1000. l = re.search("&lt;bgcolor=(\w+)&gt;", result[1])
  1001. if(j):
  1002. resultss = j.groups()
  1003. celstyle = celstyle + 'background:' + resultss[0] + ';'
  1004. elif(k):
  1005. resultss = k.groups()
  1006. celstyle = celstyle + 'background:' + resultss[0] + ';'
  1007. elif(l):
  1008. resultss = l.groups()
  1009. celstyle = celstyle + 'background:' + resultss[0] + ';'
  1010. aa = re.search("&lt;(#[0-9a-f-A-F]{6})&gt;", result[1])
  1011. ab = re.search("&lt;(#[0-9a-f-A-F]{3})&gt;", result[1])
  1012. ac = re.search("&lt;(\w+)&gt;", result[1])
  1013. if(aa):
  1014. resultss = aa.groups()
  1015. celstyle = celstyle + 'background:' + resultss[0] + ';'
  1016. elif(ab):
  1017. resultss = ab.groups()
  1018. celstyle = celstyle + 'background:' + resultss[0] + ';'
  1019. elif(ac):
  1020. resultss = ac.groups()
  1021. celstyle = celstyle + 'background:' + resultss[0] + ';'
  1022. qa = re.search("&lt;width=((?:(?!&gt;).)*)&gt;", result[1])
  1023. qb = re.search("&lt;height=((?:(?!&gt;).)*)&gt;", result[1])
  1024. if(qa):
  1025. resultss = qa.groups()
  1026. celstyle = celstyle + 'width:' + resultss[0] + ';'
  1027. if(qb):
  1028. resultss = qb.groups()
  1029. celstyle = celstyle + 'height:' + resultss[0] + ';'
  1030. i = re.search("&lt;\)&gt;", result[1])
  1031. o = re.search("&lt;:&gt;", result[1])
  1032. p = re.search("&lt;\(&gt;", result[1])
  1033. if(i):
  1034. celstyle = celstyle + 'text-align:right;'
  1035. elif(o):
  1036. celstyle = celstyle + 'text-align:center;'
  1037. elif(p):
  1038. celstyle = celstyle + 'text-align:left;'
  1039. celstyle = celstyle + '"'
  1040. table = re.sub("(\|\|(?:(?:\|\|)+)?)((?:&lt;(?:(?:(?!&gt;).)*)&gt;)+)?", "</td><td " + cel + " " + row + " " + celstyle + ">", table, 1)
  1041. else:
  1042. cel = 'colspan="' + str(round(len(result[0]) / 2)) + '"'
  1043. table = re.sub("(\|\|(?:(?:\|\|)+)?)((?:&lt;(?:(?:(?!&gt;).)*)&gt;)+)?", "</td><td " + cel + ">", table, 1)
  1044. else:
  1045. break
  1046. data = re.sub("(\|\|(?:(?:(?:.*)\n?)\|\|)+)", table, data, 1)
  1047. else:
  1048. break
  1049. data = re.sub('<\/blockquote>((\r)?\n){2}<blockquote>', '</blockquote><br><blockquote>', data)
  1050. data = re.sub('\n', '<br>', data)
  1051. data = re.sub('^<br>', '', data)
  1052. return str(data)
  1053. def getip(request):
  1054. if(session.get('Now') == True):
  1055. ip = format(session['DREAMER'])
  1056. else:
  1057. if(request.headers.getlist("X-Forwarded-For")):
  1058. ip = request.headers.getlist("X-Forwarded-For")[0]
  1059. else:
  1060. ip = request.remote_addr
  1061. return ip
  1062. def getcan(ip, name):
  1063. m = re.search("^사용자:(.*)", name)
  1064. n = re.search("^파일:(.*)", name)
  1065. if(m):
  1066. g = m.groups()
  1067. if(ip == g[0]):
  1068. if(re.search("\.", g[0])):
  1069. return 1
  1070. else:
  1071. curs.execute("select * from ban where block = '" + pymysql.escape_string(ip) + "'")
  1072. rows = curs.fetchall()
  1073. if(rows):
  1074. return 1
  1075. else:
  1076. return 0
  1077. else:
  1078. return 1
  1079. elif(n):
  1080. return 1
  1081. else:
  1082. b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))", ip)
  1083. if(b):
  1084. results = b.groups()
  1085. curs.execute("select * from ban where block = '" + pymysql.escape_string(results[0]) + "' and band = 'O'")
  1086. rowss = curs.fetchall()
  1087. if(rowss):
  1088. return 1
  1089. else:
  1090. curs.execute("select * from ban where block = '" + pymysql.escape_string(ip) + "'")
  1091. rows = curs.fetchall()
  1092. if(rows):
  1093. return 1
  1094. else:
  1095. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  1096. row = curs.fetchall()
  1097. if(row):
  1098. curs.execute("select * from user where id = '" + pymysql.escape_string(ip) + "'")
  1099. rows = curs.fetchall()
  1100. if(row[0]['acl'] == 'user'):
  1101. if(rows):
  1102. return 0
  1103. else:
  1104. return 1
  1105. elif(row[0]['acl'] == 'admin'):
  1106. if(rows):
  1107. if(rows[0]['acl'] == 'admin' or rows[0]['acl'] == 'owner'):
  1108. return 0
  1109. else:
  1110. return 1
  1111. else:
  1112. return 1
  1113. else:
  1114. return 0
  1115. else:
  1116. return 0
  1117. else:
  1118. curs.execute("select * from ban where block = '" + pymysql.escape_string(ip) + "'")
  1119. rows = curs.fetchall()
  1120. if(rows):
  1121. return 1
  1122. else:
  1123. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  1124. row = curs.fetchall()
  1125. if(row):
  1126. curs.execute("select * from user where id = '" + pymysql.escape_string(ip) + "'")
  1127. rows = curs.fetchall()
  1128. if(row[0]['acl'] == 'user'):
  1129. if(rows):
  1130. return 0
  1131. else:
  1132. return 1
  1133. elif(row[0]['acl'] == 'admin'):
  1134. if(rows):
  1135. if(rows[0]['acl'] == 'admin' or rows[0]['acl'] == 'owner'):
  1136. return 0
  1137. else:
  1138. return 1
  1139. else:
  1140. return 1
  1141. else:
  1142. return 0
  1143. else:
  1144. return 0
  1145. def getban(ip):
  1146. b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))", ip)
  1147. if(b):
  1148. results = b.groups()
  1149. curs.execute("select * from ban where block = '" + pymysql.escape_string(results[0]) + "' and band = 'O'")
  1150. rowss = curs.fetchall()
  1151. if(rowss):
  1152. return 1
  1153. else:
  1154. curs.execute("select * from ban where block = '" + pymysql.escape_string(ip) + "'")
  1155. rows = curs.fetchall()
  1156. if(rows):
  1157. return 1
  1158. else:
  1159. return 0
  1160. else:
  1161. curs.execute("select * from ban where block = '" + pymysql.escape_string(ip) + "'")
  1162. rows = curs.fetchall()
  1163. if(rows):
  1164. return 1
  1165. else:
  1166. return 0
  1167. def getdiscuss(ip, name, sub):
  1168. b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))", ip)
  1169. if(b):
  1170. results = b.groups()
  1171. curs.execute("select * from ban where block = '" + pymysql.escape_string(results[0]) + "' and band = 'O'")
  1172. rowss = curs.fetchall()
  1173. if(rowss):
  1174. return 1
  1175. else:
  1176. curs.execute("select * from ban where block = '" + pymysql.escape_string(ip) + "'")
  1177. rows = curs.fetchall()
  1178. if(rows):
  1179. return 1
  1180. else:
  1181. curs.execute("select * from stop where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "'")
  1182. rows = curs.fetchall()
  1183. if(rows):
  1184. return 1
  1185. else:
  1186. return 0
  1187. else:
  1188. curs.execute("select * from ban where block = '" + pymysql.escape_string(ip) + "'")
  1189. rows = curs.fetchall()
  1190. if(rows):
  1191. return 1
  1192. else:
  1193. curs.execute("select * from stop where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "'")
  1194. rows = curs.fetchall()
  1195. if(rows):
  1196. return 1
  1197. else:
  1198. return 0
  1199. def getnow():
  1200. now = time.localtime()
  1201. s = "%04d-%02d-%02d %02d:%02d:%02d" % (now.tm_year, now.tm_mon, now.tm_mday, now.tm_hour, now.tm_min, now.tm_sec)
  1202. return s
  1203. def discuss(title, sub, date):
  1204. curs.execute("select * from rd where title = '" + pymysql.escape_string(title) + "' and sub = '" + pymysql.escape_string(sub) + "'")
  1205. rows = curs.fetchall()
  1206. if(rows):
  1207. curs.execute("update rd set date = '" + pymysql.escape_string(date) + "' where title = '" + pymysql.escape_string(title) + "' and sub = '" + pymysql.escape_string(sub) + "'")
  1208. else:
  1209. curs.execute("insert into rd (title, sub, date) value ('" + pymysql.escape_string(title) + "', '" + pymysql.escape_string(sub) + "', '" + pymysql.escape_string(date) + "')")
  1210. conn.commit()
  1211. def block(block, end, today, blocker, why):
  1212. curs.execute("insert into rb (block, end, today, blocker, why) value ('" + pymysql.escape_string(block) + "', '" + pymysql.escape_string(end) + "', '" + today + "', '" + pymysql.escape_string(blocker) + "', '" + pymysql.escape_string(why) + "')")
  1213. conn.commit()
  1214. def history(title, data, date, ip, send, leng):
  1215. curs.execute("select * from history where title = '" + pymysql.escape_string(title) + "' order by id+0 desc limit 1")
  1216. rows = curs.fetchall()
  1217. if(rows):
  1218. number = int(rows[0]['id']) + 1
  1219. curs.execute("insert into history (id, title, data, date, ip, send, leng) value ('" + str(number) + "', '" + pymysql.escape_string(title) + "', '" + pymysql.escape_string(data) + "', '" + date + "', '" + pymysql.escape_string(ip) + "', '" + pymysql.escape_string(send) + "', '" + leng + "')")
  1220. conn.commit()
  1221. else:
  1222. curs.execute("insert into history (id, title, data, date, ip, send, leng) value ('1', '" + pymysql.escape_string(title) + "', '" + pymysql.escape_string(data) + "', '" + date + "', '" + pymysql.escape_string(ip) + "', '" + pymysql.escape_string(send + ' (새 문서)') + "', '" + leng + "')")
  1223. conn.commit()
  1224. def getleng(existing, change):
  1225. if(existing < change):
  1226. leng = change - existing
  1227. leng = '+' + str(leng)
  1228. elif(change < existing):
  1229. leng = existing - change
  1230. leng = '-' + str(leng)
  1231. else:
  1232. leng = '0'
  1233. return leng
  1234. @app.route('/upload', methods=['GET', 'POST'])
  1235. def upload():
  1236. if(request.method == 'POST'):
  1237. ip = getip(request)
  1238. ban = getban(ip)
  1239. if(ban == 1):
  1240. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  1241. else:
  1242. file = request.files['file']
  1243. if(file):
  1244. if(re.search('^([^./\\*<>|:?"]+)\.([Jj][Pp][Gg]|[Gg][Ii][Ff]|[Jj][Pp][Ee][Gg]|[Pp][Nn][Gg])$', file.filename)):
  1245. filename = file.filename
  1246. if(os.path.exists(os.path.join('image', filename))):
  1247. return '<meta http-equiv="refresh" content="0;url=/error/16" />'
  1248. else:
  1249. file.save(os.path.join('image', filename))
  1250. curs.execute("insert into data (title, data, acl) value ('" + pymysql.escape_string('파일:' + filename) + "', '" + pymysql.escape_string('[[파일:' + filename + ']][br][br]{{{[[파일:' + filename + ']]}}}') + "', '')")
  1251. conn.commit()
  1252. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote('파일:' + filename).replace('/','%2F') + '" />'
  1253. else:
  1254. return '<meta http-equiv="refresh" content="0;url=/error/15" />'
  1255. else:
  1256. return '<meta http-equiv="refresh" content="0;url=/error/14" />'
  1257. else:
  1258. ip = getip(request)
  1259. ban = getban(ip)
  1260. if(ban == 1):
  1261. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  1262. else:
  1263. return render_template('index.html', logo = data['name'], title = '업로드', tn = 21, number = data['upload'])
  1264. @app.route('/image/<path:name>')
  1265. def image(name = None):
  1266. if(os.path.exists(os.path.join('image', name))):
  1267. return send_file(os.path.join('image', name), mimetype='image')
  1268. else:
  1269. return render_template('index.html', logo = data['name'], data = '이미지 없음.', title = '이미지 보기'), 404
  1270. @app.route('/recentchanges')
  1271. def recentchanges():
  1272. i = 0
  1273. div = '<div>'
  1274. curs.execute("select * from history order by date desc limit 50")
  1275. rows = curs.fetchall()
  1276. if(rows):
  1277. admin = admincheck()
  1278. while(True):
  1279. try:
  1280. a = rows[i]
  1281. except:
  1282. div = div + '</div>'
  1283. break
  1284. if(rows[i]['send']):
  1285. send = rows[i]['send']
  1286. send = re.sub('<a href="\/w\/(?P<in>[^"]*)">(?P<out>[^&]*)<\/a>', '<a href="/w/\g<in>">\g<out></a>', send)
  1287. else:
  1288. send = '<br>'
  1289. title = rows[i]['title']
  1290. title = re.sub('<', '&lt;', title)
  1291. title = re.sub('>', '&gt;', title)
  1292. m = re.search("\+", rows[i]['leng'])
  1293. n = re.search("\-", rows[i]['leng'])
  1294. if(m):
  1295. leng = '<span style="color:green;">' + rows[i]['leng'] + '</span>'
  1296. elif(n):
  1297. leng = '<span style="color:red;">' + rows[i]['leng'] + '</span>'
  1298. else:
  1299. leng = '<span style="color:gray;">' + rows[i]['leng'] + '</span>'
  1300. if(admin == 1):
  1301. curs.execute("select * from ban where block = '" + pymysql.escape_string(rows[i]['ip']) + "'")
  1302. row = curs.fetchall()
  1303. if(row):
  1304. ban = ' <a href="/ban/' + parse.quote(rows[i]['ip']).replace('/','%2F') + '">(해제)</a>'
  1305. else:
  1306. ban = ' <a href="/ban/' + parse.quote(rows[i]['ip']).replace('/','%2F') + '">(차단)</a>'
  1307. else:
  1308. ban = ''
  1309. if(re.search('\.', rows[i]['ip'])):
  1310. ip = rows[i]['ip']
  1311. else:
  1312. curs.execute("select * from data where title = '사용자:" + pymysql.escape_string(rows[i]['ip']) + "'")
  1313. row = curs.fetchall()
  1314. if(row):
  1315. ip = '<a href="/w/' + parse.quote('사용자:' + rows[i]['ip']).replace('/','%2F') + '">' + rows[i]['ip'] + '</a>'
  1316. else:
  1317. ip = '<a class="not_thing" href="/w/' + parse.quote('사용자:' + rows[i]['ip']).replace('/','%2F') + '">' + rows[i]['ip'] + '</a>'
  1318. if((int(rows[i]['id']) - 1) == 0):
  1319. revert = ''
  1320. else:
  1321. revert = '<a href="/revert/' + parse.quote(rows[i]['title']).replace('/','%2F') + '/r/' + str(int(rows[i]['id']) - 1) + '">(되돌리기)</a>'
  1322. div = div + '<table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;"><a href="/w/' + parse.quote(rows[i]['title']).replace('/','%2F') + '">' + title + '</a> <a href="/history/' + parse.quote(rows[i]['title']).replace('/','%2F') + '/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>'
  1323. i = i + 1
  1324. return render_template('index.html', logo = data['name'], rows = div, tn = 3, title = '최근 변경내역')
  1325. else:
  1326. return render_template('index.html', logo = data['name'], rows = '', tn = 3, title = '최근 변경내역')
  1327. @app.route('/history/<path:name>/r/<int:num>/hidden')
  1328. def hidden(name = None, num = None):
  1329. if(ownercheck() == 1):
  1330. curs.execute("select * from hidhi where title = '" + pymysql.escape_string(name) + "' and re = '" + pymysql.escape_string(str(num)) + "'")
  1331. rows = curs.fetchall()
  1332. if(rows):
  1333. curs.execute("delete from hidhi where title = '" + pymysql.escape_string(name) + "' and re = '" + pymysql.escape_string(str(num)) + "'")
  1334. else:
  1335. curs.execute("insert into hidhi (title, re) value ('" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(str(num)) + "')")
  1336. conn.commit()
  1337. return '<meta http-equiv="refresh" content="0;url=/history/' + parse.quote(name).replace('/','%2F') + '/n/1" />'
  1338. else:
  1339. return '<meta http-equiv="refresh" content="0;url=/history/' + parse.quote(name).replace('/','%2F') + '/n/1" />'
  1340. @app.route('/record/<path:name>/n/<int:number>')
  1341. def record(name = None, number = None):
  1342. v = number * 50
  1343. i = v - 50
  1344. div = '<div>'
  1345. curs.execute("select * from history where ip = '" + pymysql.escape_string(name) + "' order by date desc")
  1346. rows = curs.fetchall()
  1347. if(rows):
  1348. admin = admincheck()
  1349. while(True):
  1350. try:
  1351. a = rows[i]
  1352. except:
  1353. div = div + '</div>'
  1354. if(number != 1):
  1355. div = div + '<br><a href="/record/' + parse.quote(name).replace('/','%2F') + '/n/' + str(number - 1) + '">(이전)'
  1356. break
  1357. if(rows[i]['send']):
  1358. send = rows[i]['send']
  1359. send = re.sub('<a href="\/w\/(?P<in>[^"]*)">(?P<out>[^&]*)<\/a>', '<a href="/w/\g<in>">\g<out></a>', send)
  1360. else:
  1361. send = '<br>'
  1362. title = rows[i]['title']
  1363. title = re.sub('<', '&lt;', title)
  1364. title = re.sub('>', '&gt;', title)
  1365. m = re.search("\+", rows[i]['leng'])
  1366. n = re.search("\-", rows[i]['leng'])
  1367. if(m):
  1368. leng = '<span style="color:green;">' + rows[i]['leng'] + '</span>'
  1369. elif(n):
  1370. leng = '<span style="color:red;">' + rows[i]['leng'] + '</span>'
  1371. else:
  1372. leng = '<span style="color:gray;">' + rows[i]['leng'] + '</span>'
  1373. if(admin == 1):
  1374. curs.execute("select * from ban where block = '" + pymysql.escape_string(rows[i]['ip']) + "'")
  1375. row = curs.fetchall()
  1376. if(row):
  1377. ban = ' <a href="/ban/' + parse.quote(rows[i]['ip']).replace('/','%2F') + '">(해제)</a>'
  1378. else:
  1379. ban = ' <a href="/ban/' + parse.quote(rows[i]['ip']).replace('/','%2F') + '">(차단)</a>'
  1380. else:
  1381. ban = ''
  1382. if(re.search('\.', rows[i]['ip'])):
  1383. ip = rows[i]['ip']
  1384. else:
  1385. curs.execute("select * from data where title = '사용자:" + pymysql.escape_string(rows[i]['ip']) + "'")
  1386. row = curs.fetchall()
  1387. if(row):
  1388. ip = '<a href="/w/' + parse.quote('사용자:' + rows[i]['ip']).replace('/','%2F') + '">' + rows[i]['ip'] + '</a>'
  1389. else:
  1390. ip = '<a class="not_thing" href="/w/' + parse.quote('사용자:' + rows[i]['ip']).replace('/','%2F') + '">' + rows[i]['ip'] + '</a>'
  1391. if((int(rows[i]['id']) - 1) == 0):
  1392. revert = ''
  1393. else:
  1394. revert = '<a href="/revert/' + parse.quote(rows[i]['title']).replace('/','%2F') + '/r/' + str(int(rows[i]['id']) - 1) + '">(되돌리기)</a>'
  1395. div = div + '<table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;"><a href="/w/' + parse.quote(rows[i]['title']).replace('/','%2F') + '">' + title + '</a> r' + rows[i]['id'] + ' <a href="/history/' + parse.quote(rows[i]['title']).replace('/','%2F') + '/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>'
  1396. if(i == v):
  1397. div = div + '</div>'
  1398. if(number == 1):
  1399. div = div + '<br><a href="/record/' + parse.quote(name).replace('/','%2F') + '/n/' + str(number + 1) + '">(다음)'
  1400. else:
  1401. div = div + '<br><a href="/record/' + parse.quote(name).replace('/','%2F') + '/n/' + str(number - 1) + '">(이전) <a href="/record/' + parse.quote(name).replace('/','%2F') + '/n/' + str(number + 1) + '">(다음)'
  1402. break
  1403. else:
  1404. i = i + 1
  1405. return render_template('index.html', logo = data['name'], rows = div, tn = 3, title = '유저 기록')
  1406. else:
  1407. return render_template('index.html', logo = data['name'], rows = '', tn = 3, title = '유저 기록')
  1408. @app.route('/userlog/n/<int:number>')
  1409. def userlog(number = None):
  1410. v = number * 50
  1411. i = v - 50
  1412. div = ''
  1413. curs.execute("select * from user")
  1414. rows = curs.fetchall()
  1415. if(rows):
  1416. admin = admincheck()
  1417. while(True):
  1418. try:
  1419. a = rows[i]
  1420. except:
  1421. if(number != 1):
  1422. div = div + '<br><a href="/userlog/n/' + str(number - 1) + '">(이전)'
  1423. break
  1424. if(admin == 1):
  1425. curs.execute("select * from ban where block = '" + pymysql.escape_string(rows[i]['id']) + "'")
  1426. row = curs.fetchall()
  1427. if(row):
  1428. ban = ' <a href="/ban/' + parse.quote(rows[i]['id']).replace('/','%2F') + '">(해제)</a>'
  1429. else:
  1430. ban = ' <a href="/ban/' + parse.quote(rows[i]['id']).replace('/','%2F') + '">(차단)</a>'
  1431. else:
  1432. ban = ''
  1433. if(re.search('\.', rows[i]['id'])):
  1434. ip = rows[i]['id']
  1435. else:
  1436. curs.execute("select * from data where title = '사용자:" + pymysql.escape_string(rows[i]['id']) + "'")
  1437. row = curs.fetchall()
  1438. if(row):
  1439. ip = '<a href="/w/' + parse.quote('사용자:' + rows[i]['id']).replace('/','%2F') + '">' + rows[i]['id'] + '</a>'
  1440. else:
  1441. ip = '<a class="not_thing" href="/w/' + parse.quote('사용자:' + rows[i]['id']).replace('/','%2F') + '">' + rows[i]['id'] + '</a>'
  1442. div = div + '<li>' + str(i + 1) + '. ' + ip + ban + '</li>'
  1443. if(i == v):
  1444. if(number == 1):
  1445. div = div + '<br><a href="/userlog/n/' + str(number + 1) + '">(다음)'
  1446. else:
  1447. div = div + '<br><a href="/userlog/n/' + str(number - 1) + '">(이전) <a href="/userlog/n/' + str(number + 1) + '">(다음)'
  1448. break
  1449. else:
  1450. i = i + 1
  1451. return render_template('index.html', logo = data['name'], data = div, title = '유저 가입 기록')
  1452. else:
  1453. return render_template('index.html', logo = data['name'], data = '', title = '유저 가입 기록')
  1454. @app.route('/backlink/<path:name>/n/<int:number>')
  1455. def backlink(name = None, number = None):
  1456. v = number * 50
  1457. i = v - 50
  1458. div = ''
  1459. restart = 0
  1460. curs.execute("select * from back where title = '" + pymysql.escape_string(name) + "' order by link asc")
  1461. rows = curs.fetchall()
  1462. if(rows):
  1463. while(True):
  1464. try:
  1465. a = rows[i]
  1466. except:
  1467. if(number != 1):
  1468. div = div + '<br><a href="/backlink/n/' + str(number - 1) + '">(이전)'
  1469. break
  1470. if(rows[i]['type'] == 'include'):
  1471. curs.execute("select * from back where title = '" + pymysql.escape_string(name) + "' and link = '" + pymysql.escape_string(rows[i]['link']) + "' and type = ''")
  1472. test = curs.fetchall()
  1473. if(test):
  1474. restart = 1
  1475. curs.execute("delete from back where title = '" + pymysql.escape_string(name) + "' and link = '" + pymysql.escape_string(rows[i]['link']) + "' and type = ''")
  1476. conn.commit()
  1477. if(not re.search('^사용자:', rows[i]['link'])):
  1478. curs.execute("select * from data where title = '" + pymysql.escape_string(rows[i]['link']) + "'")
  1479. row = curs.fetchall()
  1480. if(row):
  1481. aa = row[0]['data']
  1482. aa = re.sub("(?P<in>\[include\((?P<out>(?:(?!\)\]|,).)*)((?:,\s?(?:[^)]*))+)?\)\])", "\g<in>\n\n[[\g<out>]]\n\n", aa)
  1483. aa = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', '[[\g<in>]]', aa)
  1484. aa = namumark('', aa)
  1485. if(re.search("<a(?:(?:(?!href=).)*)?href=\"\/w\/" + parse.quote(name).replace('/','%2F') + "(?:\#[^\"]*)?\">([^<]*)<\/a>", aa)):
  1486. div = div + '<li><a href="/w/' + parse.quote(rows[i]['link']).replace('/','%2F') + '">' + rows[i]['link'] + '</a>'
  1487. if(rows[i]['type']):
  1488. div = div + ' (' + rows[i]['type'] + ')</li>'
  1489. else:
  1490. div = div + '</li>'
  1491. if(i == v):
  1492. if(number == 1):
  1493. div = div + '<br><a href="/backlink/' + parse.quote(name).replace('/','%2F') + '/n/' + str(number + 1) + '">(다음)'
  1494. else:
  1495. div = div + '<br><a href="/backlink/' + parse.quote(name).replace('/','%2F') + '/n/' + str(number - 1) + '">(이전) <a href="/backlink/' + parse.quote(name).replace('/','%2F') + '/n/' + str(number + 1) + '">(다음)'
  1496. break
  1497. else:
  1498. i = i + 1
  1499. else:
  1500. curs.execute("delete from back where title = '" + pymysql.escape_string(name) + "' and link = '" + pymysql.escape_string(rows[i]['link']) + "'")
  1501. conn.commit()
  1502. i = i + 1
  1503. v = v + 1
  1504. else:
  1505. curs.execute("delete from back where title = '" + pymysql.escape_string(name) + "' and link = '" + pymysql.escape_string(rows[i]['link']) + "'")
  1506. conn.commit()
  1507. i = i + 1
  1508. v = v + 1
  1509. else:
  1510. curs.execute("delete from back where title = '" + pymysql.escape_string(name) + "' and link = '" + pymysql.escape_string(rows[i]['link']) + "'")
  1511. conn.commit()
  1512. i = i + 1
  1513. v = v + 1
  1514. if(restart == 1):
  1515. return '<meta http-equiv="refresh" content="0;url=/backlink/' + parse.quote(name).replace('/','%2F') + '/n/' + str(number) + '" />'
  1516. else:
  1517. return render_template('index.html', logo = data['name'], data = div, title = name, sub = '역링크')
  1518. else:
  1519. return render_template('index.html', logo = data['name'], data = '', title = name, sub = '역링크')
  1520. @app.route('/recentdiscuss')
  1521. def recentdiscuss():
  1522. i = 0
  1523. div = '<div>'
  1524. curs.execute("select * from rd order by date desc limit 50")
  1525. rows = curs.fetchall()
  1526. if(rows):
  1527. while(True):
  1528. try:
  1529. a = rows[i]
  1530. except:
  1531. div = div + '</div>'
  1532. break
  1533. title = rows[i]['title']
  1534. title = re.sub('<', '&lt;', title)
  1535. title = re.sub('>', '&gt;', title)
  1536. sub = rows[i]['sub']
  1537. sub = re.sub('<', '&lt;', sub)
  1538. sub = re.sub('>', '&gt;', sub)
  1539. div = div + '<table style="width: 100%;"><tbody><tr><td style="text-align: center;width:50%;"><a href="/topic/' + parse.quote(rows[i]['title']).replace('/','%2F') + '/sub/' + parse.quote(rows[i]['sub']).replace('/','%2F') + '">' + title + '</a> (' + sub + ')</td><td style="text-align: center;width:50%;">' + rows[i]['date'] + '</td></tr></tbody></table>'
  1540. i = i + 1
  1541. return render_template('index.html', logo = data['name'], rows = div, tn = 12, title = '최근 토론내역')
  1542. else:
  1543. return render_template('index.html', logo = data['name'], rows = '', tn = 12, title = '최근 토론내역')
  1544. @app.route('/blocklog/n/<int:number>')
  1545. def blocklog(number = None):
  1546. v = number * 50
  1547. i = v - 50
  1548. div = '<div>'
  1549. curs.execute("select * from rb order by today desc")
  1550. rows = curs.fetchall()
  1551. if(rows):
  1552. while(True):
  1553. try:
  1554. a = rows[i]
  1555. except:
  1556. div = div + '</div>'
  1557. if(number != 1):
  1558. div = div + '<br><a href="/blocklog/n/' + str(number - 1) + '">(이전)'
  1559. break
  1560. why = rows[i]['why']
  1561. why = re.sub('<', '&lt;', why)
  1562. why = re.sub('>', '&gt;', why)
  1563. b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))$", rows[i]['block'])
  1564. if(b):
  1565. ip = rows[i]['block'] + ' (대역)'
  1566. else:
  1567. ip = rows[i]['block']
  1568. div = div + '<table style="width: 100%;"><tbody><tr><td style="text-align: center;width:20%;">' + ip + '</a></td><td style="text-align: center;width:20%;">' + rows[i]['blocker'] + '</td><td style="text-align: center;width:20%;">' + rows[i]['end'] + '</td><td style="text-align: center;width:20%;">' + rows[i]['why'] + '</td><td style="text-align: center;width:20%;">' + rows[i]['today'] + '</td></tr></tbody></table>'
  1569. if(i == v):
  1570. div = div + '</div>'
  1571. if(number == 1):
  1572. div = div + '<br><a href="/blocklog/n/' + str(number + 1) + '">(다음)'
  1573. else:
  1574. div = div + '<br><a href="/blocklog/n/' + str(number - 1) + '">(이전) <a href="/blocklog/n/' + str(number + 1) + '">(다음)'
  1575. break
  1576. else:
  1577. i = i + 1
  1578. return render_template('index.html', logo = data['name'], rows = div, tn = 20, title = '유저 차단 기록')
  1579. else:
  1580. return render_template('index.html', logo = data['name'], rows = '', tn = 20, title = '유저 차단 기록')
  1581. @app.route('/history/<path:name>/n/<int:number>', methods=['POST', 'GET'])
  1582. def gethistory(name = None, number = None):
  1583. if(request.method == 'POST'):
  1584. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '/r/' + request.form["b"] + '/diff/' + request.form["a"] + '" />'
  1585. else:
  1586. select = ''
  1587. v = number * 50
  1588. i = v - 50
  1589. div = '<div>'
  1590. curs.execute("select * from history where title = '" + pymysql.escape_string(name) + "' order by id+0 desc")
  1591. rows = curs.fetchall()
  1592. if(rows):
  1593. admin = admincheck()
  1594. while(True):
  1595. try:
  1596. a = rows[i]
  1597. except:
  1598. div = div + '</div>'
  1599. if(number != 1):
  1600. div = div + '<br><a href="/history/' + parse.quote(name).replace('/','%2F') + '/n/' + str(number - 1) + '">(이전)'
  1601. break
  1602. select = '<option value="' + str(i + 1) + '">' + str(i + 1) + '</option>' + select
  1603. if(rows[i]['send']):
  1604. send = rows[i]['send']
  1605. send = re.sub('<a href="\/w\/(?P<in>[^"]*)">(?P<out>[^&]*)<\/a>', '<a href="/w/\g<in>">\g<out></a>', send)
  1606. else:
  1607. send = '<br>'
  1608. m = re.search("\+", rows[i]['leng'])
  1609. n = re.search("\-", rows[i]['leng'])
  1610. if(m):
  1611. leng = '<span style="color:green;">' + rows[i]['leng'] + '</span>'
  1612. elif(n):
  1613. leng = '<span style="color:red;">' + rows[i]['leng'] + '</span>'
  1614. else:
  1615. leng = '<span style="color:gray;">' + rows[i]['leng'] + '</span>'
  1616. if(re.search("\.", rows[i]["ip"])):
  1617. ip = rows[i]["ip"]
  1618. else:
  1619. curs.execute("select * from data where title = '사용자:" + pymysql.escape_string(rows[i]['ip']) + "'")
  1620. row = curs.fetchall()
  1621. if(row):
  1622. ip = '<a href="/w/' + parse.quote('사용자:' + rows[i]['ip']).replace('/','%2F') + '">' + rows[i]['ip'] + '</a>'
  1623. else:
  1624. ip = '<a class="not_thing" href="/w/' + parse.quote('사용자:' + rows[i]['ip']).replace('/','%2F') + '">' + rows[i]['ip'] + '</a>'
  1625. if(admin == 1):
  1626. curs.execute("select * from user where id = '" + pymysql.escape_string(rows[i]['ip']) + "'")
  1627. row = curs.fetchall()
  1628. if(row):
  1629. if(row[0]['acl'] == 'owner' or row[0]['acl'] == 'admin'):
  1630. ban = ''
  1631. else:
  1632. curs.execute("select * from ban where block = '" + pymysql.escape_string(rows[i]['ip']) + "'")
  1633. row = curs.fetchall()
  1634. if(row):
  1635. ban = ' <a href="/ban/' + parse.quote(rows[i]['ip']).replace('/','%2F') + '">(해제)</a>'
  1636. else:
  1637. ban = ' <a href="/ban/' + parse.quote(rows[i]['ip']).replace('/','%2F') + '">(차단)</a>'
  1638. else:
  1639. curs.execute("select * from ban where block = '" + pymysql.escape_string(rows[i]['ip']) + "'")
  1640. row = curs.fetchall()
  1641. if(row):
  1642. ban = ' <a href="/ban/' + parse.quote(rows[i]['ip']).replace('/','%2F') + '">(해제)</a>'
  1643. else:
  1644. ban = ' <a href="/ban/' + parse.quote(rows[i]['ip']).replace('/','%2F') + '">(차단)</a>'
  1645. if(ownercheck() == 1):
  1646. curs.execute("select * from hidhi where title = '" + pymysql.escape_string(name) + "' and re = '" + pymysql.escape_string(rows[i]['id']) + "'")
  1647. row = curs.fetchall()
  1648. if(row):
  1649. ip = ip + ' (숨김)'
  1650. hidden = ' <a href="/history/' + parse.quote(name).replace('/','%2F') + '/r/' + rows[i]['id'] + '/hidden">(공개)'
  1651. else:
  1652. hidden = ' <a href="/history/' + parse.quote(name).replace('/','%2F') + '/r/' + rows[i]['id'] + '/hidden">(숨김)'
  1653. else:
  1654. curs.execute("select * from hidhi where title = '" + pymysql.escape_string(name) + "' and re = '" + pymysql.escape_string(rows[i]['id']) + "'")
  1655. row = curs.fetchall()
  1656. if(row):
  1657. ip = '숨김'
  1658. hidden = ''
  1659. send = '숨김'
  1660. ban = ''
  1661. else:
  1662. hidden = ''
  1663. else:
  1664. ban = ''
  1665. curs.execute("select * from hidhi where title = '" + pymysql.escape_string(name) + "' and re = '" + pymysql.escape_string(rows[i]['id']) + "'")
  1666. row = curs.fetchall()
  1667. if(row):
  1668. ip = '숨김'
  1669. hidden = ''
  1670. send = '숨김'
  1671. ban = ''
  1672. else:
  1673. hidden = ''
  1674. div = div + '<table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;">r' + rows[i]['id'] + '</a> <a href="/w/' + parse.quote(rows[i]['title']).replace('/','%2F') + '/r/' + rows[i]['id'] + '">(w)</a> <a href="/w/' + parse.quote(rows[i]['title']).replace('/','%2F') + '/raw/' + rows[i]['id'] + '">(Raw)</a> <a href="/revert/' + parse.quote(rows[i]['title']).replace('/','%2F') + '/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>'
  1675. if(i == v):
  1676. div = div + '</div>'
  1677. if(number == 1):
  1678. div = div + '<br><a href="/history/' + parse.quote(name).replace('/','%2F') + '/n/' + str(number + 1) + '">(다음)'
  1679. else:
  1680. div = div + '<br><a href="/history/' + parse.quote(name).replace('/','%2F') + '/n/' + str(number - 1) + '">(이전) <a href="/history/' + parse.quote(name).replace('/','%2F') + '/n/' + str(number + 1) + '">(다음)'
  1681. break
  1682. else:
  1683. i = i + 1
  1684. return render_template('index.html', logo = data['name'], rows = div, tn = 5, title = name, page = parse.quote(name).replace('/','%2F'), select = select, sub = '역사')
  1685. else:
  1686. return render_template('index.html', logo = data['name'], rows = '', tn = 5, title = name, page = parse.quote(name).replace('/','%2F'), select = select, sub = '역사')
  1687. @app.route('/search', methods=['POST'])
  1688. def search():
  1689. curs.execute("select * from data where title = '" + pymysql.escape_string(request.form["search"]) + "'")
  1690. rows = curs.fetchall()
  1691. if(rows):
  1692. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(request.form["search"]).replace('/','%2F') + '" />'
  1693. else:
  1694. curs.execute("select * from data where title like '%" + pymysql.escape_string(request.form["search"]) + "%'")
  1695. rows = curs.fetchall()
  1696. if(rows):
  1697. i = 0
  1698. div = '<li>문서가 없습니다. <a href="/w/' + parse.quote(request.form["search"]).replace('/','%2F') + '">바로가기</a></li><br>'
  1699. while(True):
  1700. try:
  1701. div = div + '<li><a href="/w/' + parse.quote(rows[i]['title']).replace('/','%2F') + '">' + rows[i]['title'] + '</a></li>'
  1702. except:
  1703. break
  1704. i = i + 1
  1705. else:
  1706. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(request.form["search"]).replace('/','%2F') + '" />'
  1707. return render_template('index.html', logo = data['name'], data = div, title = '검색')
  1708. @app.route('/w/<path:name>')
  1709. def w(name = None):
  1710. i = 0
  1711. curs.execute("select * from rd where title = '" + pymysql.escape_string(name) + "' order by date asc")
  1712. rows = curs.fetchall()
  1713. while(True):
  1714. try:
  1715. a = rows[i]
  1716. except:
  1717. topic = ""
  1718. break
  1719. curs.execute("select * from stop where title = '" + pymysql.escape_string(rows[i]['title']) + "' and sub = '" + pymysql.escape_string(rows[i]['sub']) + "' and close = 'O'")
  1720. row = curs.fetchall()
  1721. if(not row):
  1722. topic = "open"
  1723. break
  1724. else:
  1725. i = i + 1
  1726. acl = ''
  1727. m = re.search("^(.*)\/(.*)$", name)
  1728. if(m):
  1729. g = m.groups()
  1730. uppage = g[0]
  1731. style = ""
  1732. else:
  1733. uppage = ""
  1734. style = "display:none;"
  1735. if(re.search("^분류:", name)):
  1736. curs.execute("select * from cat where title = '" + pymysql.escape_string(name) + "' order by cat asc")
  1737. rows = curs.fetchall()
  1738. if(rows):
  1739. div = ''
  1740. i = 0
  1741. while(True):
  1742. try:
  1743. a = rows[i]
  1744. except:
  1745. break
  1746. curs.execute("select * from data where title = '" + pymysql.escape_string(rows[i]['cat']) + "'")
  1747. row = curs.fetchall()
  1748. if(row):
  1749. aa = row[0]['data']
  1750. aa = namumark('', aa)
  1751. bb = re.search('<div style="width:100%;border: 1px solid #777;padding: 5px;margin-top: 1em;">분류:((?:(?!<\/div>).)*)<\/div>', aa)
  1752. if(bb):
  1753. cc = bb.groups()
  1754. mm = re.search("^분류:(.*)", name)
  1755. if(mm):
  1756. ee = mm.groups()
  1757. if(re.search("<a (class=\"not_thing\")? href=\"\/w\/" + parse.quote(name).replace('/','%2F') + "\">" + ee[0] + "<\/a>", cc[0])):
  1758. div = div + '<li><a href="/w/' + parse.quote(rows[i]['cat']).replace('/','%2F') + '">' + rows[i]['cat'] + '</a></li>'
  1759. i = i + 1
  1760. else:
  1761. curs.execute("delete from cat where title = '" + pymysql.escape_string(name) + "' and cat = '" + pymysql.escape_string(rows[i]['cat']) + "'")
  1762. conn.commit()
  1763. i = i + 1
  1764. else:
  1765. curs.execute("delete from cat where title = '" + pymysql.escape_string(name) + "' and cat = '" + pymysql.escape_string(rows[i]['cat']) + "'")
  1766. conn.commit()
  1767. i = i + 1
  1768. else:
  1769. curs.execute("delete from cat where title = '" + pymysql.escape_string(name) + "' and cat = '" + pymysql.escape_string(rows[i]['cat']) + "'")
  1770. conn.commit()
  1771. i = i + 1
  1772. else:
  1773. curs.execute("delete from cat where title = '" + pymysql.escape_string(name) + "' and cat = '" + pymysql.escape_string(rows[i]['cat']) + "'")
  1774. conn.commit()
  1775. i = i + 1
  1776. div = '<h2>분류</h2>' + div
  1777. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  1778. bb = curs.fetchall()
  1779. if(bb):
  1780. if(bb[0]['acl'] == 'admin'):
  1781. acl = '(관리자)'
  1782. elif(bb[0]['acl'] == 'user'):
  1783. acl = '(유저)'
  1784. else:
  1785. if(not acl):
  1786. acl = ''
  1787. enddata = namumark(name, bb[0]['data'])
  1788. m = re.search('<div id="toc">((?:(?!\/div>).)*)<\/div>', enddata)
  1789. if(m):
  1790. result = m.groups()
  1791. left = result[0]
  1792. else:
  1793. left = ''
  1794. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = enddata + '<br>' + div, license = data['license'], tn = 1, uppage = uppage, style = style, acl = acl, topic = topic)
  1795. else:
  1796. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = div, license = data['license'], tn = 1, uppage = uppage, style = style, acl = acl, topic = topic)
  1797. else:
  1798. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = '분류 문서 없음', license = data['license'], tn = 1, uppage = uppage, style = style, acl = acl, topic = topic), 404
  1799. else:
  1800. m = re.search("^사용자:(.*)", name)
  1801. if(m):
  1802. g = m.groups()
  1803. curs.execute("select * from user where id = '" + pymysql.escape_string(g[0]) + "'")
  1804. rows = curs.fetchall()
  1805. if(rows):
  1806. if(rows[0]['acl'] == 'owner'):
  1807. acl = '(소유자)'
  1808. elif(rows[0]['acl'] == 'admin'):
  1809. acl = '(관리자)'
  1810. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  1811. rows = curs.fetchall()
  1812. if(rows):
  1813. if(rows[0]['acl'] == 'admin'):
  1814. acl = '(관리자)'
  1815. elif(rows[0]['acl'] == 'user'):
  1816. acl = '(유저)'
  1817. else:
  1818. if(not acl):
  1819. acl = ''
  1820. enddata = namumark(name, rows[0]['data'])
  1821. m = re.search('<div id="toc">((?:(?!\/div>).)*)<\/div>', enddata)
  1822. if(m):
  1823. result = m.groups()
  1824. left = result[0]
  1825. else:
  1826. left = ''
  1827. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = enddata, license = data['license'], tn = 1, acl = acl, left = left, uppage = uppage, style = style, topic = topic)
  1828. else:
  1829. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = '문서 없음', license = data['license'], tn = 1, uppage = uppage, style = style, acl = acl, topic = topic), 404
  1830. @app.route('/w/<path:name>/from/<path:redirect>')
  1831. def redirectw(name = None, redirect = None):
  1832. i = 0
  1833. curs.execute("select * from rd where title = '" + pymysql.escape_string(name) + "' order by date asc")
  1834. rows = curs.fetchall()
  1835. while(True):
  1836. try:
  1837. a = rows[i]
  1838. except:
  1839. topic = ""
  1840. break
  1841. curs.execute("select * from stop where title = '" + pymysql.escape_string(rows[i]['title']) + "' and sub = '" + pymysql.escape_string(rows[i]['sub']) + "' and close = 'O'")
  1842. row = curs.fetchall()
  1843. if(not row):
  1844. topic = "open"
  1845. break
  1846. else:
  1847. i = i + 1
  1848. acl = ''
  1849. m = re.search("^(.*)\/(.*)$", name)
  1850. if(m):
  1851. g = m.groups()
  1852. uppage = g[0]
  1853. style = ""
  1854. else:
  1855. uppage = ""
  1856. style = "display:none;"
  1857. if(re.search("^분류:", name)):
  1858. curs.execute("select * from cat where title = '" + pymysql.escape_string(name) + "' order by cat asc")
  1859. rows = curs.fetchall()
  1860. if(rows):
  1861. div = ''
  1862. i = 0
  1863. while(True):
  1864. try:
  1865. a = rows[i]
  1866. except:
  1867. break
  1868. curs.execute("select * from data where title = '" + pymysql.escape_string(rows[i]['cat']) + "'")
  1869. row = curs.fetchall()
  1870. if(row):
  1871. aa = row[0]['data']
  1872. aa = namumark('', aa)
  1873. bb = re.search('<div style="width:100%;border: 1px solid #777;padding: 5px;margin-top: 1em;">분류:((?:(?!<\/div>).)*)<\/div>', aa)
  1874. if(bb):
  1875. cc = bb.groups()
  1876. mm = re.search("^분류:(.*)", name)
  1877. if(mm):
  1878. ee = mm.groups()
  1879. if(re.search("<a (class=\"not_thing\")? href=\"\/w\/" + parse.quote(name).replace('/','%2F') + "\">" + ee[0] + "<\/a>", cc[0])):
  1880. div = div + '<li><a href="/w/' + parse.quote(rows[i]['cat']).replace('/','%2F') + '">' + rows[i]['cat'] + '</a></li>'
  1881. i = i + 1
  1882. else:
  1883. curs.execute("delete from cat where title = '" + pymysql.escape_string(name) + "' and cat = '" + pymysql.escape_string(rows[i]['cat']) + "'")
  1884. conn.commit()
  1885. i = i + 1
  1886. else:
  1887. curs.execute("delete from cat where title = '" + pymysql.escape_string(name) + "' and cat = '" + pymysql.escape_string(rows[i]['cat']) + "'")
  1888. conn.commit()
  1889. i = i + 1
  1890. else:
  1891. curs.execute("delete from cat where title = '" + pymysql.escape_string(name) + "' and cat = '" + pymysql.escape_string(rows[i]['cat']) + "'")
  1892. conn.commit()
  1893. i = i + 1
  1894. else:
  1895. curs.execute("delete from cat where title = '" + pymysql.escape_string(name) + "' and cat = '" + pymysql.escape_string(rows[i]['cat']) + "'")
  1896. conn.commit()
  1897. i = i + 1
  1898. div = '<h2>분류</h2>' + div
  1899. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  1900. bb = curs.fetchall()
  1901. if(bb):
  1902. if(bb[0]['acl'] == 'admin'):
  1903. acl = '(관리자)'
  1904. elif(bb[0]['acl'] == 'user'):
  1905. acl = '(유저)'
  1906. else:
  1907. if(not acl):
  1908. acl = ''
  1909. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * \g<in> 문서로 넘겨주기', bb[0]['data'])
  1910. enddata = namumark(name, newdata)
  1911. m = re.search('<div id="toc">((?:(?!\/div>).)*)<\/div>', enddata)
  1912. if(m):
  1913. result = m.groups()
  1914. left = result[0]
  1915. else:
  1916. left = ''
  1917. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = enddata + '<br>' + div, license = data['license'], tn = 1, uppage = uppage, style = style, acl = acl, topic = topic, redirect = '<a href="/w/' + parse.quote(redirect).replace('/','%2F') + '/from/' + parse.quote(name).replace('/','%2F') + '">' + redirect + '</a>에서 넘어 왔습니다.')
  1918. else:
  1919. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = div, license = data['license'], tn = 1, uppage = uppage, style = style, acl = acl, topic = topic, redirect = '<a href="/w/' + parse.quote(redirect).replace('/','%2F') + '/from/' + parse.quote(name).replace('/','%2F') + '">' + redirect + '</a>에서 넘어 왔습니다.')
  1920. else:
  1921. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = '분류 문서 없음', license = data['license'], tn = 1, uppage = uppage, style = style, acl = acl, topic = topic, redirect = '<a href="/w/' + parse.quote(redirect).replace('/','%2F') + '/from/' + parse.quote(name).replace('/','%2F') + '">' + redirect + '</a>에서 넘어 왔습니다.'), 404
  1922. else:
  1923. m = re.search("^사용자:(.*)", name)
  1924. if(m):
  1925. g = m.groups()
  1926. curs.execute("select * from user where id = '" + pymysql.escape_string(g[0]) + "'")
  1927. rows = curs.fetchall()
  1928. if(rows):
  1929. if(rows[0]['acl'] == 'owner'):
  1930. acl = '(소유자)'
  1931. elif(rows[0]['acl'] == 'admin'):
  1932. acl = '(관리자)'
  1933. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  1934. rows = curs.fetchall()
  1935. if(rows):
  1936. if(rows[0]['acl'] == 'admin'):
  1937. acl = '(관리자)'
  1938. elif(rows[0]['acl'] == 'user'):
  1939. acl = '(유저)'
  1940. else:
  1941. if(not acl):
  1942. acl = ''
  1943. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * \g<in> 문서로 넘겨주기', rows[0]["data"])
  1944. enddata = namumark(name, newdata)
  1945. m = re.search('<div id="toc">((?:(?!\/div>).)*)<\/div>', enddata)
  1946. if(m):
  1947. result = m.groups()
  1948. left = result[0]
  1949. else:
  1950. left = ''
  1951. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = enddata, license = data['license'], tn = 1, acl = acl, left = left, uppage = uppage, style = style, topic = topic, redirect = '<a href="/w/' + parse.quote(redirect).replace('/','%2F') + '/from/' + parse.quote(name).replace('/','%2F') + '">' + redirect + '</a>에서 넘어 왔습니다.')
  1952. else:
  1953. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = '문서 없음', license = data['license'], tn = 1, uppage = uppage, style = style, acl = acl, topic = topic, redirect = '<a href="/w/' + parse.quote(redirect).replace('/','%2F') + '/from/' + parse.quote(name).replace('/','%2F') + '">' + redirect + '</a>에서 넘어 왔습니다.'), 404
  1954. @app.route('/w/<path:name>/r/<int:number>')
  1955. def rew(name = None, number = None):
  1956. curs.execute("select * from hidhi where title = '" + pymysql.escape_string(name) + "' and re = '" + pymysql.escape_string(str(number)) + "'")
  1957. row = curs.fetchall()
  1958. if(row):
  1959. if(ownercheck() == 1):
  1960. curs.execute("select * from history where title = '" + pymysql.escape_string(name) + "' and id = '" + str(number) + "'")
  1961. rows = curs.fetchall()
  1962. if(rows):
  1963. enddata = namumark(name, rows[0]['data'])
  1964. m = re.search('<div id="toc">((?:(?!\/div>).)*)<\/div>', enddata)
  1965. if(m):
  1966. result = m.groups()
  1967. left = result[0]
  1968. else:
  1969. left = ''
  1970. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = enddata, license = data['license'], tn = 6, left = left, sub = '옛 문서')
  1971. else:
  1972. return '<meta http-equiv="refresh" content="0;url=/history/' + parse.quote(name).replace('/','%2F') + '" />'
  1973. else:
  1974. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  1975. else:
  1976. curs.execute("select * from history where title = '" + pymysql.escape_string(name) + "' and id = '" + str(number) + "'")
  1977. rows = curs.fetchall()
  1978. if(rows):
  1979. enddata = namumark(name, rows[0]['data'])
  1980. m = re.search('<div id="toc">((?:(?!\/div>).)*)<\/div>', enddata)
  1981. if(m):
  1982. result = m.groups()
  1983. left = result[0]
  1984. else:
  1985. left = ''
  1986. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = enddata, license = data['license'], tn = 6, left = left, sub = '옛 문서')
  1987. else:
  1988. return '<meta http-equiv="refresh" content="0;url=/history/' + parse.quote(name).replace('/','%2F') + '" />'
  1989. @app.route('/w/<path:name>/raw/<int:number>')
  1990. def reraw(name = None, number = None):
  1991. curs.execute("select * from hidhi where title = '" + pymysql.escape_string(name) + "' and re = '" + pymysql.escape_string(str(number)) + "'")
  1992. row = curs.fetchall()
  1993. if(row):
  1994. if(ownercheck() == 1):
  1995. curs.execute("select * from history where title = '" + pymysql.escape_string(name) + "' and id = '" + str(number) + "'")
  1996. rows = curs.fetchall()
  1997. if(rows):
  1998. enddata = re.sub('<', '&lt;', rows[0]['data'])
  1999. enddata = re.sub('>', '&gt;', enddata)
  2000. enddata = re.sub('"', '&quot;', enddata)
  2001. enddata = re.sub("\n", '<br>', enddata)
  2002. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = enddata, license = data['license'])
  2003. else:
  2004. return '<meta http-equiv="refresh" content="0;url=/history/' + parse.quote(name).replace('/','%2F') + '" />'
  2005. else:
  2006. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2007. else:
  2008. curs.execute("select * from history where title = '" + pymysql.escape_string(name) + "' and id = '" + str(number) + "'")
  2009. rows = curs.fetchall()
  2010. if(rows):
  2011. enddata = re.sub('<', '&lt;', rows[0]['data'])
  2012. enddata = re.sub('>', '&gt;', enddata)
  2013. enddata = re.sub('"', '&quot;', enddata)
  2014. enddata = re.sub("\n", '<br>', enddata)
  2015. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = enddata, license = data['license'])
  2016. else:
  2017. return '<meta http-equiv="refresh" content="0;url=/history/' + parse.quote(name).replace('/','%2F') + '" />'
  2018. @app.route('/raw/<path:name>')
  2019. def raw(name = None):
  2020. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  2021. rows = curs.fetchall()
  2022. if(rows):
  2023. enddata = re.sub('<', '&lt;', rows[0]['data'])
  2024. enddata = re.sub('>', '&gt;', enddata)
  2025. enddata = re.sub('"', '&quot;', enddata)
  2026. enddata = re.sub("\n", '<br>', enddata)
  2027. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = enddata, license = data['license'], tn = 7, sub = 'Raw')
  2028. else:
  2029. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2030. @app.route('/revert/<path:name>/r/<int:number>', methods=['POST', 'GET'])
  2031. def revert(name = None, number = None):
  2032. if(request.method == 'POST'):
  2033. curs.execute("select * from hidhi where title = '" + pymysql.escape_string(name) + "' and re = '" + pymysql.escape_string(str(number)) + "'")
  2034. row = curs.fetchall()
  2035. if(row):
  2036. if(ownercheck() == 1):
  2037. curs.execute("select * from history where title = '" + pymysql.escape_string(name) + "' and id = '" + str(number) + "'")
  2038. rows = curs.fetchall()
  2039. if(rows):
  2040. ip = getip(request)
  2041. can = getcan(ip, name)
  2042. if(can == 1):
  2043. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2044. else:
  2045. today = getnow()
  2046. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  2047. row = curs.fetchall()
  2048. if(row):
  2049. leng = getleng(len(row[0]['data']), len(rows[0]['data']))
  2050. curs.execute("update data set data = '" + pymysql.escape_string(rows[0]['data']) + "' where title = '" + pymysql.escape_string(name) + "'")
  2051. conn.commit()
  2052. else:
  2053. leng = '+' + str(len(rows[0]['data']))
  2054. curs.execute("insert into data (title, data, acl) value ('" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(rows[0]['data']) + "', '')")
  2055. conn.commit()
  2056. history(name, rows[0]['data'], today, ip, '문서를 ' + str(number) + '판으로 되돌렸습니다.', leng)
  2057. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2058. else:
  2059. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2060. else:
  2061. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2062. else:
  2063. curs.execute("select * from history where title = '" + pymysql.escape_string(name) + "' and id = '" + str(number) + "'")
  2064. rows = curs.fetchall()
  2065. if(rows):
  2066. ip = getip(request)
  2067. can = getcan(ip, name)
  2068. if(can == 1):
  2069. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2070. else:
  2071. today = getnow()
  2072. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  2073. row = curs.fetchall()
  2074. if(row):
  2075. leng = getleng(len(row[0]['data']), len(rows[0]['data']))
  2076. curs.execute("update data set data = '" + pymysql.escape_string(rows[0]['data']) + "' where title = '" + pymysql.escape_string(name) + "'")
  2077. conn.commit()
  2078. else:
  2079. leng = '+' + str(len(rows[0]['data']))
  2080. curs.execute("insert into data (title, data, acl) value ('" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(rows[0]['data']) + "', '')")
  2081. conn.commit()
  2082. history(name, rows[0]['data'], today, ip, '문서를 ' + str(number) + '판으로 되돌렸습니다.', leng)
  2083. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2084. else:
  2085. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2086. else:
  2087. curs.execute("select * from hidhi where title = '" + pymysql.escape_string(name) + "' and re = '" + pymysql.escape_string(str(number)) + "'")
  2088. row = curs.fetchall()
  2089. if(row):
  2090. if(ownercheck() == 1):
  2091. ip = getip(request)
  2092. can = getcan(ip, name)
  2093. if(can == 1):
  2094. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2095. else:
  2096. curs.execute("select * from history where title = '" + pymysql.escape_string(name) + "' and id = '" + str(number) + "'")
  2097. rows = curs.fetchall()
  2098. if(rows):
  2099. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), r = parse.quote(str(number)).replace('/','%2F'), tn = 13, plus = '정말 되돌리시겠습니까?', sub = '되돌리기')
  2100. else:
  2101. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2102. else:
  2103. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2104. else:
  2105. ip = getip(request)
  2106. can = getcan(ip, name)
  2107. if(can == 1):
  2108. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2109. else:
  2110. curs.execute("select * from history where title = '" + pymysql.escape_string(name) + "' and id = '" + str(number) + "'")
  2111. rows = curs.fetchall()
  2112. if(rows):
  2113. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), r = parse.quote(str(number)).replace('/','%2F'), tn = 13, plus = '정말 되돌리시겠습니까?', sub = '되돌리기')
  2114. else:
  2115. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2116. @app.route('/edit/<path:name>', methods=['POST', 'GET'])
  2117. def edit(name = None):
  2118. if(request.method == 'POST'):
  2119. m = re.search('(?:[^A-Za-zㄱ-힣0-9 ])', request.form["send"])
  2120. if(m):
  2121. return '<meta http-equiv="refresh" content="0;url=/error/17" />'
  2122. else:
  2123. today = getnow()
  2124. content = re.sub("\[date\(now\)\]", today, request.form["content"])
  2125. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  2126. rows = curs.fetchall()
  2127. if(rows):
  2128. if(rows[0]['data'] == content):
  2129. return '<meta http-equiv="refresh" content="0;url=/error/18" />'
  2130. else:
  2131. ip = getip(request)
  2132. can = getcan(ip, name)
  2133. if(can == 1):
  2134. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2135. else:
  2136. leng = getleng(len(rows[0]['data']), len(content))
  2137. history(name, content, today, ip, request.form["send"], leng)
  2138. curs.execute("update data set data = '" + pymysql.escape_string(content) + "' where title = '" + pymysql.escape_string(name) + "'")
  2139. conn.commit()
  2140. else:
  2141. ip = getip(request)
  2142. can = getcan(ip, name)
  2143. if(can == 1):
  2144. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2145. else:
  2146. leng = '+' + str(len(content))
  2147. history(name, content, today, ip, request.form["send"], leng)
  2148. curs.execute("insert into data (title, data, acl) value ('" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(content) + "', '')")
  2149. conn.commit()
  2150. isin(name)
  2151. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2152. else:
  2153. ip = getip(request)
  2154. can = getcan(ip, name)
  2155. if(can == 1):
  2156. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2157. else:
  2158. curs.execute("select * from data where title = '" + pymysql.escape_string(data["help"]) + "'")
  2159. rows = curs.fetchall()
  2160. if(rows):
  2161. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * \g<in> 문서로 넘겨주기', rows[0]["data"])
  2162. left = namumark(name, newdata)
  2163. else:
  2164. left = ''
  2165. if(re.search('\.', ip)):
  2166. notice = '비 로그인 상태 입니다. 비 로그인으로 편집시 아이피가 역사에 기록 됩니다. 편집 시 동의 함으로 간주 됩니다.'
  2167. else:
  2168. notice = ''
  2169. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  2170. rows = curs.fetchall()
  2171. if(rows):
  2172. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = rows[0]['data'], tn = 2, notice = notice, left = left, sub = '편집')
  2173. else:
  2174. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = '', tn = 2, notice = notice, left = left, sub = '편집')
  2175. @app.route('/edit/<path:name>/section/<int:number>', methods=['POST', 'GET'])
  2176. def secedit(name = None, number = None):
  2177. if(request.method == 'POST'):
  2178. m = re.search('(?:[^A-Za-zㄱ-힣0-9 ])', request.form["send"])
  2179. if(m):
  2180. return '<meta http-equiv="refresh" content="0;url=/error/17" />'
  2181. else:
  2182. today = getnow()
  2183. content = re.sub("\[date\(now\)\]", today, request.form["content"])
  2184. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  2185. rows = curs.fetchall()
  2186. if(rows):
  2187. if(request.form["otent"] == content):
  2188. return '<meta http-equiv="refresh" content="0;url=/error/18" />'
  2189. else:
  2190. ip = getip(request)
  2191. can = getcan(ip, name)
  2192. if(can == 1):
  2193. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2194. else:
  2195. leng = getleng(len(request.form['otent']), len(content))
  2196. content = rows[0]['data'].replace(request.form['otent'], content)
  2197. history(name, content, today, ip, request.form["send"], leng)
  2198. curs.execute("update data set data = '" + pymysql.escape_string(content) + "' where title = '" + pymysql.escape_string(name) + "'")
  2199. conn.commit()
  2200. isin(name)
  2201. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2202. else:
  2203. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2204. else:
  2205. ip = getip(request)
  2206. can = getcan(ip, name)
  2207. if(can == 1):
  2208. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2209. else:
  2210. curs.execute("select * from data where title = '" + pymysql.escape_string(data["help"]) + "'")
  2211. rows = curs.fetchall()
  2212. if(rows):
  2213. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * \g<in> 문서로 넘겨주기', rows[0]["data"])
  2214. left = namumark(name, newdata)
  2215. else:
  2216. left = ''
  2217. if(re.search('\.', ip)):
  2218. notice = '비 로그인 상태 입니다. 비 로그인으로 편집시 아이피가 역사에 기록 됩니다. 편집 시 동의 함으로 간주 됩니다.'
  2219. else:
  2220. notice = ''
  2221. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  2222. rows = curs.fetchall()
  2223. if(rows):
  2224. i = 0
  2225. j = 0
  2226. gdata = rows[0]['data'] + '\r\n'
  2227. while(True):
  2228. m = re.search("((?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n(?:(?:(?:(?!(?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n).)*)(?:\n)?)+)", gdata)
  2229. if(m):
  2230. if(i == number - 1):
  2231. g = m.groups()
  2232. gdata = re.sub("\r\n$", "", g[0])
  2233. break
  2234. else:
  2235. gdata = re.sub("((?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n(?:(?:(?:(?!(?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n).)*)(?:\n)?)+)", "", gdata, 1)
  2236. i = i + 1
  2237. else:
  2238. j = 1
  2239. break
  2240. if(j == 0):
  2241. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = gdata, tn = 2, notice = notice, left = left, section = 1, number = number, sub = '편집')
  2242. else:
  2243. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2244. else:
  2245. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2246. @app.route('/preview/<path:name>', methods=['POST'])
  2247. def preview(name = None):
  2248. ip = getip(request)
  2249. can = getcan(ip, name)
  2250. if(can == 1):
  2251. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2252. else:
  2253. if(re.search('\.', ip)):
  2254. notice = '비 로그인 상태 입니다. 비 로그인으로 편집시 아이피가 역사에 기록 됩니다. 편집 시 동의 함으로 간주 됩니다.'
  2255. else:
  2256. notice = ''
  2257. newdata = request.form["content"]
  2258. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * \g<in> 문서로 넘겨주기', newdata)
  2259. enddata = namumark(name, newdata)
  2260. curs.execute("select * from data where title = '" + pymysql.escape_string(data["help"]) + "'")
  2261. rows = curs.fetchall()
  2262. if(rows):
  2263. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * \g<in> 문서로 넘겨주기', rows[0]["data"])
  2264. left = namumark(name, newdata)
  2265. else:
  2266. left = ''
  2267. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = request.form["content"], tn = 2, preview = 1, enddata = enddata, left = left, notice = notice, sub = '미리보기')
  2268. @app.route('/preview/<path:name>/section/<int:number>', methods=['POST'])
  2269. def secpreview(name = None, number = None):
  2270. ip = getip(request)
  2271. can = getcan(ip, name)
  2272. if(can == 1):
  2273. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2274. else:
  2275. if(re.search('\.', ip)):
  2276. notice = '비 로그인 상태 입니다. 비 로그인으로 편집시 아이피가 역사에 기록 됩니다. 편집 시 동의 함으로 간주 됩니다.'
  2277. else:
  2278. notice = ''
  2279. newdata = request.form["content"]
  2280. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * \g<in> 문서로 넘겨주기', newdata)
  2281. enddata = namumark(name, newdata)
  2282. curs.execute("select * from data where title = '" + pymysql.escape_string(data["help"]) + "'")
  2283. rows = curs.fetchall()
  2284. if(rows):
  2285. newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * \g<in> 문서로 넘겨주기', rows[0]["data"])
  2286. left = namumark(name, newdata)
  2287. else:
  2288. left = ''
  2289. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), data = request.form["content"], tn = 2, preview = 1, enddata = enddata, left = left, notice = notice, section = 1, number = number, odata = request.form["otent"], sub = '미리보기')
  2290. @app.route('/delete/<path:name>', methods=['POST', 'GET'])
  2291. def delete(name = None):
  2292. if(request.method == 'POST'):
  2293. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  2294. rows = curs.fetchall()
  2295. if(rows):
  2296. ip = getip(request)
  2297. can = getcan(ip, name)
  2298. if(can == 1):
  2299. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2300. else:
  2301. today = getnow()
  2302. leng = '-' + str(len(rows[0]['data']))
  2303. history(name, '', today, ip, '문서를 삭제 했습니다.', leng)
  2304. curs.execute("delete from data where title = '" + pymysql.escape_string(name) + "'")
  2305. conn.commit()
  2306. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2307. else:
  2308. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2309. else:
  2310. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  2311. rows = curs.fetchall()
  2312. if(rows):
  2313. ip = getip(request)
  2314. can = getcan(ip, name)
  2315. if(can == 1):
  2316. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2317. else:
  2318. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), tn = 8, plus = '정말 삭제 하시겠습니까?', sub = '삭제')
  2319. else:
  2320. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2321. @app.route('/move/<path:name>', methods=['POST', 'GET'])
  2322. def move(name = None):
  2323. if(request.method == 'POST'):
  2324. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  2325. rows = curs.fetchall()
  2326. if(rows):
  2327. ip = getip(request)
  2328. can = getcan(ip, name)
  2329. if(can == 1):
  2330. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2331. else:
  2332. today = getnow()
  2333. leng = '0'
  2334. curs.execute("select * from history where title = '" + pymysql.escape_string(request.form["title"]) + "'")
  2335. row = curs.fetchall()
  2336. if(row):
  2337. return '<meta http-equiv="refresh" content="0;url=/error/19" />'
  2338. else:
  2339. history(name, rows[0]['data'], today, ip, '<a href="/w/' + parse.quote(name).replace('/','%2F') + '">' + name + '</a> 문서를 <a href="/w/' + parse.quote(request.form["title"]).replace('/','%2F') + '">' + request.form["title"] + '</a> 문서로 이동 했습니다.', leng)
  2340. curs.execute("update data set title = '" + pymysql.escape_string(request.form["title"]) + "' where title = '" + pymysql.escape_string(name) + "'")
  2341. curs.execute("update history set title = '" + pymysql.escape_string(request.form["title"]) + "' where title = '" + pymysql.escape_string(name) + "'")
  2342. conn.commit()
  2343. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(request.form["title"]).replace('/','%2F') + '" />'
  2344. else:
  2345. ip = getip(request)
  2346. can = getcan(ip, name)
  2347. if(can == 1):
  2348. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2349. else:
  2350. today = getnow()
  2351. leng = '0'
  2352. curs.execute("select * from history where title = '" + pymysql.escape_string(request.form["title"]) + "'")
  2353. row = curs.fetchall()
  2354. if(row):
  2355. return '<meta http-equiv="refresh" content="0;url=/error/19" />'
  2356. else:
  2357. history(name, '', today, ip, '<a href="/w/' + parse.quote(name).replace('/','%2F') + '">' + name + '</a> 문서를 <a href="/w/' + parse.quote(request.form["title"]).replace('/','%2F') + '">' + request.form["title"] + '</a> 문서로 이동 했습니다.', leng)
  2358. curs.execute("update history set title = '" + pymysql.escape_string(request.form["title"]) + "' where title = '" + pymysql.escape_string(name) + "'")
  2359. conn.commit()
  2360. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(request.form["title"]).replace('/','%2F') + '" />'
  2361. else:
  2362. ip = getip(request)
  2363. can = getcan(ip, name)
  2364. if(can == 1):
  2365. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2366. else:
  2367. return render_template('index.html', title = name, logo = data['name'], page = parse.quote(name).replace('/','%2F'), tn = 9, plus = '정말 이동 하시겠습니까?', sub = '이동')
  2368. @app.route('/other')
  2369. def other():
  2370. return render_template('index.html', title = '기타 메뉴', logo = data['name'], data = '<li><a href="/titleindex">모든 문서</a></li><li><a href="/blocklog/n/1">유저 차단 기록</a></li><li><a href="/userlog/n/1">유저 가입 기록</a></li><li><a href="/upload">업로드</a></li><li><a href="/manager/1">관리자 메뉴</a></li><li><a href="/manager/6">유저 기록</a></li><br>이 오픈나무의 버전은 <a href="https://github.com/2DU/openNAMU/blob/master/version.md">1.8.1</a> 입니다.')
  2371. @app.route('/manager/<int:num>', methods=['POST', 'GET'])
  2372. def manager(num = None):
  2373. if(num == 1):
  2374. return render_template('index.html', title = '관리자 메뉴', logo = 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="/manager/5">관리자 권한 주기</a></li>')
  2375. elif(num == 2):
  2376. if(request.method == 'POST'):
  2377. return '<meta http-equiv="refresh" content="0;url=/acl/' + parse.quote(request.form["name"]).replace('/','%2F') + '" />'
  2378. else:
  2379. return render_template('index.html', title = 'ACL 이동', logo = 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>')
  2380. elif(num == 3):
  2381. if(request.method == 'POST'):
  2382. return '<meta http-equiv="refresh" content="0;url=/check/' + parse.quote(request.form["name"]).replace('/','%2F') + '" />'
  2383. else:
  2384. return render_template('index.html', title = '체크 이동', logo = 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>')
  2385. elif(num == 4):
  2386. if(request.method == 'POST'):
  2387. return '<meta http-equiv="refresh" content="0;url=/ban/' + parse.quote(request.form["name"]).replace('/','%2F') + '" />'
  2388. else:
  2389. return render_template('index.html', title = '차단 이동', logo = 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>')
  2390. elif(num == 5):
  2391. if(request.method == 'POST'):
  2392. return '<meta http-equiv="refresh" content="0;url=/admin/' + parse.quote(request.form["name"]).replace('/','%2F') + '" />'
  2393. else:
  2394. return render_template('index.html', title = '권한 이동', logo = 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>')
  2395. elif(num == 6):
  2396. if(request.method == 'POST'):
  2397. return '<meta http-equiv="refresh" content="0;url=/record/' + parse.quote(request.form["name"]).replace('/','%2F') + '/n/1" />'
  2398. else:
  2399. return render_template('index.html', title = '기록 이동', logo = 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>')
  2400. else:
  2401. return '<meta http-equiv="refresh" content="0;url=/" />'
  2402. @app.route('/titleindex')
  2403. def titleindex():
  2404. i = 0
  2405. div = '<div>'
  2406. curs.execute("select * from data order by title asc")
  2407. rows = curs.fetchall()
  2408. if(rows):
  2409. while(True):
  2410. try:
  2411. a = rows[i]
  2412. except:
  2413. div = div + '</div>'
  2414. break
  2415. div = div + '<li>' + str(i + 1) + '. <a href="/w/' + parse.quote(rows[i]['title']).replace('/','%2F') + '">' + rows[i]['title'] + '</a></li>'
  2416. i = i + 1
  2417. return render_template('index.html', logo = data['name'], rows = div + '<br><span>이 위키에는 총 ' + str(i) + '개의 문서가 있습니다.</span>', tn = 4, title = '모든 문서')
  2418. else:
  2419. return render_template('index.html', logo = data['name'], rows = '', tn = 4, title = '모든 문서')
  2420. @app.route('/topic/<path:name>', methods=['POST', 'GET'])
  2421. def topic(name = None):
  2422. if(request.method == 'POST'):
  2423. return '<meta http-equiv="refresh" content="0;url=/topic/' + parse.quote(name).replace('/','%2F') + '/sub/' + parse.quote(request.form["topic"]).replace('/','%2F') + '" />'
  2424. else:
  2425. div = '<div>'
  2426. i = 0
  2427. j = 1
  2428. curs.execute("select * from rd where title = '" + pymysql.escape_string(name) + "' order by date asc")
  2429. rows = curs.fetchall()
  2430. while(True):
  2431. try:
  2432. a = rows[i]
  2433. except:
  2434. div = div + '</div>'
  2435. break
  2436. curs.execute("select * from topic where title = '" + pymysql.escape_string(rows[i]['title']) + "' and sub = '" + pymysql.escape_string(rows[i]['sub']) + "' and id = '1' order by sub asc")
  2437. aa = curs.fetchall()
  2438. indata = namumark(name, aa[0]['data'])
  2439. if(aa[0]['block'] == 'O'):
  2440. indata = '블라인드 되었습니다.'
  2441. block = 'style="background: gainsboro;"'
  2442. else:
  2443. block = ''
  2444. curs.execute("select * from stop where title = '" + pymysql.escape_string(rows[i]['title']) + "' and sub = '" + pymysql.escape_string(rows[i]['sub']) + "' and close = 'O'")
  2445. row = curs.fetchall()
  2446. if(not row):
  2447. div = div + '<h2><a href="/topic/' + parse.quote(rows[i]['title']).replace('/','%2F') + '/sub/' + parse.quote(rows[i]['sub']).replace('/','%2F') + '">' + str(j) + '. ' + rows[i]['sub'] + '</a></h2>'
  2448. div = div + '<table id="toron"><tbody><tr><td id="toroncolorgreen"><a href="javascript:void(0);" id="1">#1</a> ' + aa[0]['ip'] + ' <span style="float:right;">' + aa[0]['date'] + '</span></td></tr><tr><td ' + block + '>' + indata + '</td></tr></tbody></table><br>'
  2449. j = j + 1
  2450. i = i + 1
  2451. return render_template('index.html', title = name, page = parse.quote(name).replace('/','%2F'), logo = data['name'], plus = div, tn = 10, list = 1, sub = '토론 목록')
  2452. @app.route('/topic/<path:name>/close')
  2453. def topicstoplist(name = None):
  2454. if(request.method == 'POST'):
  2455. return '<meta http-equiv="refresh" content="0;url=/topic/' + parse.quote(name).replace('/','%2F') + '/sub/' + parse.quote(request.form["topic"]).replace('/','%2F') + '" />'
  2456. else:
  2457. div = '<div>'
  2458. i = 0
  2459. curs.execute("select * from stop where title = '" + pymysql.escape_string(name) + "' and close = 'O' order by sub asc")
  2460. rows = curs.fetchall()
  2461. while(True):
  2462. try:
  2463. a = rows[i]
  2464. except:
  2465. div = div + '</div>'
  2466. break
  2467. curs.execute("select * from topic where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(rows[i]['sub']) + "' and id = '1'")
  2468. row = curs.fetchall()
  2469. if(row):
  2470. j = i + 1
  2471. indata = namumark(name, row[0]['data'])
  2472. if(row[0]['block'] == 'O'):
  2473. indata = '블라인드 되었습니다.'
  2474. block = 'style="background: gainsboro;"'
  2475. else:
  2476. block = ''
  2477. div = div + '<h2><a href="/topic/' + parse.quote(name).replace('/','%2F') + '/sub/' + parse.quote(rows[i]['sub']).replace('/','%2F') + '">' + str((i + 1)) + '. ' + rows[i]['sub'] + '</a></h2>'
  2478. div = div + '<table id="toron"><tbody><tr><td id="toroncolorgreen"><a href="javascript:void(0);" id="' + str(j) + '">#' + str(j) + '</a> ' + row[0]['ip'] + ' <span style="float:right;">' + row[0]['date'] + '</span></td></tr><tr><td ' + block + '>' + indata + '</td></tr></tbody></table><br>'
  2479. i = i + 1
  2480. return render_template('index.html', title = name, page = parse.quote(name).replace('/','%2F'), logo = data['name'], plus = div, tn = 10, sub = '토론 목록')
  2481. @app.route('/topic/<path:name>/sub/<path:sub>', methods=['POST', 'GET'])
  2482. def sub(name = None, sub = None):
  2483. if(request.method == 'POST'):
  2484. curs.execute("select * from topic where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' order by id+0 desc limit 1")
  2485. rows = curs.fetchall()
  2486. if(rows):
  2487. number = int(rows[0]['id']) + 1
  2488. else:
  2489. number = 1
  2490. ip = getip(request)
  2491. ban = getdiscuss(ip, name, sub)
  2492. admin = admincheck()
  2493. if(ban == 1 and not admin == 1):
  2494. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2495. else:
  2496. curs.execute("select * from user where id = '" + pymysql.escape_string(ip) + "'")
  2497. rows = curs.fetchall()
  2498. if(rows):
  2499. if(rows[0]['acl'] == 'owner' or rows[0]['acl'] == 'admin'):
  2500. ip = ip + ' - Admin'
  2501. today = getnow()
  2502. discuss(name, sub, today)
  2503. aa = request.form["content"]
  2504. aa = re.sub("\[\[(분류:(?:(?:(?!\]\]).)*))\]\]", "[br]", aa)
  2505. aa = re.sub("\[date\(now\)\]", today, aa)
  2506. curs.execute("insert into topic (id, title, sub, data, date, ip, block) value ('" + str(number) + "', '" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(sub) + "', '" + pymysql.escape_string(aa) + "', '" + today + "', '" + ip + "', '')")
  2507. conn.commit()
  2508. return '<meta http-equiv="refresh" content="0;url=/topic/' + parse.quote(name).replace('/','%2F') + '/sub/' + parse.quote(sub).replace('/','%2F') + '" />'
  2509. else:
  2510. style = ''
  2511. ip = getip(request)
  2512. ban = getdiscuss(ip, name, sub)
  2513. admin = admincheck()
  2514. if(admin == 1):
  2515. div = '<div>'
  2516. curs.execute("select * from stop where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' and close = 'O'")
  2517. rows = curs.fetchall()
  2518. if(rows):
  2519. div = div + '<a href="/topic/' + parse.quote(name).replace('/','%2F') + '/sub/' + parse.quote(sub).replace('/','%2F') + '/close">(토론 열기)</a> '
  2520. else:
  2521. div = div + '<a href="/topic/' + parse.quote(name).replace('/','%2F') + '/sub/' + parse.quote(sub).replace('/','%2F') + '/close">(토론 닫기)</a> '
  2522. curs.execute("select * from stop where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' and close = ''")
  2523. rows = curs.fetchall()
  2524. if(rows):
  2525. div = div + '<a href="/topic/' + parse.quote(name).replace('/','%2F') + '/sub/' + parse.quote(sub).replace('/','%2F') + '/stop">(토론 재개)</a>'
  2526. else:
  2527. div = div + '<a href="/topic/' + parse.quote(name).replace('/','%2F') + '/sub/' + parse.quote(sub).replace('/','%2F') + '/stop">(토론 정지)</a>'
  2528. div = div + '<br><br>'
  2529. else:
  2530. div = '<div>'
  2531. i = 0
  2532. curs.execute("select * from stop where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "'")
  2533. rows = curs.fetchall()
  2534. if(rows):
  2535. if(not admin == 1):
  2536. style = 'display:none;'
  2537. curs.execute("select * from topic where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' order by id+0 asc")
  2538. rows = curs.fetchall()
  2539. while(True):
  2540. try:
  2541. a = rows[i]
  2542. except:
  2543. div = div + '</div>'
  2544. break
  2545. if(i == 0):
  2546. start = rows[i]['ip']
  2547. indata = namumark(name, rows[i]['data'])
  2548. if(rows[i]['block'] == 'O'):
  2549. indata = '블라인드 되었습니다.'
  2550. block = 'style="background: gainsboro;"'
  2551. else:
  2552. block = ''
  2553. m = re.search("^([^-]*)\s\-\s(Close|Reopen|Stop|Restart)$", rows[i]['ip'])
  2554. if(m):
  2555. ban = ""
  2556. else:
  2557. if(admin == 1):
  2558. curs.execute("select * from ban where block = '" + pymysql.escape_string(rows[i]['ip']) + "'")
  2559. row = curs.fetchall()
  2560. if(rows[i]['block'] == 'O'):
  2561. isblock = ' <a href="/topic/' + parse.quote(name).replace('/','%2F') + '/sub/' + parse.quote(sub).replace('/','%2F') + '/b/' + str(i + 1) + '">(해제)</a>'
  2562. else:
  2563. isblock = ' <a href="/topic/' + parse.quote(name).replace('/','%2F') + '/sub/' + parse.quote(sub).replace('/','%2F') + '/b/' + str(i + 1) + '">(블라인드)</a>'
  2564. n = re.search("\- (?:Admin)$", rows[i]['ip'])
  2565. if(n):
  2566. ban = isblock
  2567. else:
  2568. if(row):
  2569. ban = ' <a href="/ban/' + parse.quote(rows[i]['ip']).replace('/','%2F') + '">(해제)</a>' + isblock
  2570. else:
  2571. ban = ' <a href="/ban/' + parse.quote(rows[i]['ip']).replace('/','%2F') + '">(차단)</a>' + isblock
  2572. else:
  2573. ban = ""
  2574. m = re.search("([^-]*)\s\-\s(Close|Reopen|Stop|Restart|Admin)$", rows[i]['ip'])
  2575. if(m):
  2576. g = m.groups()
  2577. curs.execute("select * from data where title = '사용자:" + pymysql.escape_string(g[0]) + "'")
  2578. row = curs.fetchall()
  2579. if(row):
  2580. ip = '<a href="/w/' + parse.quote('사용자:' + g[0]).replace('/','%2F') + '">' + g[0] + '</a> - ' + g[1]
  2581. else:
  2582. ip = '<a class="not_thing" href="/w/' + parse.quote('사용자:' + g[0]).replace('/','%2F') + '">' + g[0] + '</a> - ' + g[1]
  2583. elif(re.search("\.", rows[i]["ip"])):
  2584. ip = rows[i]["ip"]
  2585. else:
  2586. curs.execute("select * from data where title = '사용자:" + pymysql.escape_string(rows[i]['ip']) + "'")
  2587. row = curs.fetchall()
  2588. if(row):
  2589. ip = '<a href="/w/' + parse.quote('사용자:' + rows[i]['ip']).replace('/','%2F') + '">' + rows[i]['ip'] + '</a>'
  2590. else:
  2591. ip = '<a class="not_thing" href="/w/' + parse.quote('사용자:' + rows[i]['ip']).replace('/','%2F') + '">' + rows[i]['ip'] + '</a>'
  2592. if(rows[i]['ip'] == start):
  2593. j = i + 1
  2594. 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>'
  2595. else:
  2596. j = i + 1
  2597. 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>'
  2598. i = i + 1
  2599. return render_template('index.html', title = name, page = parse.quote(name).replace('/','%2F'), suburl = parse.quote(sub).replace('/','%2F'), toron = sub, logo = data['name'], rows = div, tn = 11, ban = ban, style = style, sub = '토론')
  2600. @app.route('/topic/<path:name>/sub/<path:sub>/b/<number>')
  2601. def blind(name = None, sub = None, number = None):
  2602. if(admincheck() == 1):
  2603. curs.execute("select * from topic where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' and id = '" + number + "'")
  2604. row = curs.fetchall()
  2605. if(row):
  2606. if(row[0]['block'] == 'O'):
  2607. curs.execute("update topic set block = '' where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' and id = '" + number + "'")
  2608. else:
  2609. curs.execute("update topic set block = 'O' where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' and id = '" + number + "'")
  2610. conn.commit()
  2611. return '<meta http-equiv="refresh" content="0;url=/topic/' + name + '/sub/' + sub + '" />'
  2612. else:
  2613. return '<meta http-equiv="refresh" content="0;url=/topic/' + name + '/sub/' + sub + '" />'
  2614. else:
  2615. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2616. @app.route('/topic/<path:name>/sub/<path:sub>/stop')
  2617. def topicstop(name = None, sub = None):
  2618. if(admincheck() == 1):
  2619. ip = getip(request)
  2620. curs.execute("select * from topic where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' order by id+0 desc limit 1")
  2621. row = curs.fetchall()
  2622. if(row):
  2623. today = getnow()
  2624. curs.execute("select * from stop where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' and close = ''")
  2625. rows = curs.fetchall()
  2626. if(rows):
  2627. curs.execute("insert into topic (id, title, sub, data, date, ip, block) value ('" + pymysql.escape_string(str(int(row[0]['id']) + 1)) + "', '" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(sub) + "', 'Restart', '" + pymysql.escape_string(today) + "', '" + pymysql.escape_string(ip) + " - Restart', '')")
  2628. curs.execute("delete from stop where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' and close = ''")
  2629. else:
  2630. curs.execute("insert into topic (id, title, sub, data, date, ip, block) value ('" + pymysql.escape_string(str(int(row[0]['id']) + 1)) + "', '" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(sub) + "', 'Stop', '" + pymysql.escape_string(today) + "', '" + pymysql.escape_string(ip) + " - Stop', '')")
  2631. curs.execute("insert into stop (title, sub, close) value ('" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(sub) + "', '')")
  2632. conn.commit()
  2633. return '<meta http-equiv="refresh" content="0;url=/topic/' + name + '/sub/' + sub + '" />'
  2634. else:
  2635. return '<meta http-equiv="refresh" content="0;url=/topic/' + name + '/sub/' + sub + '" />'
  2636. else:
  2637. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2638. @app.route('/topic/<path:name>/sub/<path:sub>/close')
  2639. def topicclose(name = None, sub = None):
  2640. if(admincheck() == 1):
  2641. ip = getip(request)
  2642. curs.execute("select * from topic where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' order by id+0 desc limit 1")
  2643. row = curs.fetchall()
  2644. if(row):
  2645. today = getnow()
  2646. curs.execute("select * from stop where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' and close = 'O'")
  2647. rows = curs.fetchall()
  2648. if(rows):
  2649. curs.execute("insert into topic (id, title, sub, data, date, ip, block) value ('" + pymysql.escape_string(str(int(row[0]['id']) + 1)) + "', '" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(sub) + "', 'Reopen', '" + pymysql.escape_string(today) + "', '" + pymysql.escape_string(ip) + " - Reopen', '')")
  2650. curs.execute("delete from stop where title = '" + pymysql.escape_string(name) + "' and sub = '" + pymysql.escape_string(sub) + "' and close = 'O'")
  2651. else:
  2652. curs.execute("insert into topic (id, title, sub, data, date, ip, block) value ('" + pymysql.escape_string(str(int(row[0]['id']) + 1)) + "', '" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(sub) + "', 'Close', '" + pymysql.escape_string(today) + "', '" + pymysql.escape_string(ip) + " - Close', '')")
  2653. curs.execute("insert into stop (title, sub, close) value ('" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(sub) + "', 'O')")
  2654. conn.commit()
  2655. return '<meta http-equiv="refresh" content="0;url=/topic/' + name + '/sub/' + sub + '" />'
  2656. else:
  2657. return '<meta http-equiv="refresh" content="0;url=/topic/' + name + '/sub/' + sub + '" />'
  2658. else:
  2659. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2660. @app.route('/login', methods=['POST', 'GET'])
  2661. def login():
  2662. if(request.method == 'POST'):
  2663. ip = getip(request)
  2664. ban = getban(ip)
  2665. if(ban == 1):
  2666. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2667. else:
  2668. curs.execute("select * from user where id = '" + pymysql.escape_string(request.form["id"]) + "'")
  2669. rows = curs.fetchall()
  2670. if(rows):
  2671. if(session.get('Now') == True):
  2672. return '<meta http-equiv="refresh" content="0;url=/error/11" />'
  2673. elif(bcrypt.checkpw(bytes(request.form["pw"], 'utf-8'), bytes(rows[0]['pw'], 'utf-8'))):
  2674. session['Now'] = True
  2675. session['DREAMER'] = request.form["id"]
  2676. curs.execute("insert into login (user, ip, today) value ('" + pymysql.escape_string(request.form["id"]) + "', '" + pymysql.escape_string(ip) + "', '" + pymysql.escape_string(getnow()) + "')")
  2677. conn.commit()
  2678. return '<meta http-equiv="refresh" content="0;url=/user" />'
  2679. else:
  2680. return '<meta http-equiv="refresh" content="0;url=/error/13" />'
  2681. else:
  2682. return '<meta http-equiv="refresh" content="0;url=/error/12" />'
  2683. else:
  2684. ip = getip(request)
  2685. ban = getban(ip)
  2686. if(ban == 1):
  2687. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2688. else:
  2689. if(session.get('Now') == True):
  2690. return '<meta http-equiv="refresh" content="0;url=/error/11" />'
  2691. else:
  2692. return render_template('index.html', title = '로그인', enter = '로그인', logo = data['name'], tn = 15)
  2693. @app.route('/change', methods=['POST', 'GET'])
  2694. def change():
  2695. if(request.method == 'POST'):
  2696. ip = getip(request)
  2697. ban = getban(ip)
  2698. if(request.form["pw2"] == request.form["pw3"]):
  2699. if(ban == 1):
  2700. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2701. else:
  2702. curs.execute("select * from user where id = '" + pymysql.escape_string(request.form["id"]) + "'")
  2703. rows = curs.fetchall()
  2704. if(rows):
  2705. if(session.get('Now') == True):
  2706. session['Now'] = False
  2707. session.pop('DREAMER', None)
  2708. return '<meta http-equiv="refresh" content="0;url=/change" />'
  2709. elif(bcrypt.checkpw(bytes(request.form["pw"], 'utf-8'), bytes(rows[0]['pw'], 'utf-8'))):
  2710. hashed = bcrypt.hashpw(bytes(request.form["pw2"], 'utf-8'), bcrypt.gensalt())
  2711. curs.execute("update user set pw = '" + pymysql.escape_string(hashed.decode()) + "' where id = '" + pymysql.escape_string(request.form["id"]) + "'")
  2712. conn.commit()
  2713. return '<meta http-equiv="refresh" content="0;url=/login" />'
  2714. else:
  2715. return '<meta http-equiv="refresh" content="0;url=/error/10" />'
  2716. else:
  2717. return '<meta http-equiv="refresh" content="0;url=/error/9" />'
  2718. else:
  2719. return '<meta http-equiv="refresh" content="0;url=/error/20" />'
  2720. else:
  2721. ip = getip(request)
  2722. ban = getban(ip)
  2723. if(ban == 1):
  2724. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2725. else:
  2726. if(session.get('Now') == True):
  2727. session['Now'] = False
  2728. session.pop('DREAMER', None)
  2729. return '<meta http-equiv="refresh" content="0;url=/change" />'
  2730. else:
  2731. return render_template('index.html', title = '비밀번호 변경', enter = '변경', logo = data['name'], tn = 15)
  2732. @app.route('/check/<name>')
  2733. def check(name = None, sub = None, number = None):
  2734. curs.execute("select * from user where id = '" + pymysql.escape_string(name) + "'")
  2735. rows = curs.fetchall()
  2736. if(rows and rows[0]['acl'] == 'owner' or rows and rows[0]['acl'] == 'admin'):
  2737. return '<meta http-equiv="refresh" content="0;url=/error/4" />'
  2738. else:
  2739. if(admincheck() == 1):
  2740. 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)
  2741. if(m):
  2742. curs.execute("select * from login where ip = '" + pymysql.escape_string(name) + "' order by today desc")
  2743. row = curs.fetchall()
  2744. if(row):
  2745. i = 0
  2746. c = ''
  2747. while(True):
  2748. try:
  2749. 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>'
  2750. except:
  2751. break
  2752. i = i + 1
  2753. return render_template('index.html', title = '다중 검사', logo = data['name'], tn = 22, rows = c)
  2754. else:
  2755. return render_template('index.html', title = '다중 검사', logo = data['name'], tn = 22, rows = '')
  2756. else:
  2757. curs.execute("select * from login where user = '" + pymysql.escape_string(name) + "' order by today desc")
  2758. row = curs.fetchall()
  2759. if(row):
  2760. i = 0
  2761. c = ''
  2762. while(True):
  2763. try:
  2764. 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>'
  2765. except:
  2766. break
  2767. i = i + 1
  2768. return render_template('index.html', title = '다중 검사', logo = data['name'], tn = 22, rows = c)
  2769. else:
  2770. return render_template('index.html', title = '다중 검사', logo = data['name'], tn = 22, rows = '')
  2771. else:
  2772. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2773. @app.route('/register', methods=['POST', 'GET'])
  2774. def register():
  2775. if(request.method == 'POST'):
  2776. ip = getip(request)
  2777. ban = getban(ip)
  2778. if(request.form["pw"] == request.form["pw2"]):
  2779. if(ban == 1):
  2780. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2781. else:
  2782. m = re.search('(?:[^A-Za-zㄱ-힣0-9 ])', request.form["id"])
  2783. if(m):
  2784. return '<meta http-equiv="refresh" content="0;url=/error/8" />'
  2785. else:
  2786. if(len(request.form["id"]) > 20):
  2787. return '<meta http-equiv="refresh" content="0;url=/error/7" />'
  2788. else:
  2789. curs.execute("select * from user where id = '" + pymysql.escape_string(request.form["id"]) + "'")
  2790. rows = curs.fetchall()
  2791. if(rows):
  2792. return '<meta http-equiv="refresh" content="0;url=/error/6" />'
  2793. else:
  2794. hashed = bcrypt.hashpw(bytes(request.form["pw"], 'utf-8'), bcrypt.gensalt())
  2795. if(request.form["id"] == data['owner']):
  2796. curs.execute("insert into user (id, pw, acl) value ('" + pymysql.escape_string(request.form["id"]) + "', '" + pymysql.escape_string(hashed.decode()) + "', 'owner')")
  2797. else:
  2798. curs.execute("insert into user (id, pw, acl) value ('" + pymysql.escape_string(request.form["id"]) + "', '" + pymysql.escape_string(hashed.decode()) + "', 'user')")
  2799. conn.commit()
  2800. return '<meta http-equiv="refresh" content="0;url=/login" />'
  2801. else:
  2802. return '<meta http-equiv="refresh" content="0;url=/error/20" />'
  2803. else:
  2804. ip = getip(request)
  2805. ban = getban(ip)
  2806. if(ban == 1):
  2807. return '<meta http-equiv="refresh" content="0;url=/ban" />'
  2808. else:
  2809. return render_template('index.html', title = '회원가입', enter = '회원가입', logo = data['name'], tn = 15)
  2810. @app.route('/logout')
  2811. def logout():
  2812. session['Now'] = False
  2813. session.pop('DREAMER', None)
  2814. return '<meta http-equiv="refresh" content="0;url=/user" />'
  2815. @app.route('/ban/<name>', methods=['POST', 'GET'])
  2816. def ban(name = None):
  2817. curs.execute("select * from user where id = '" + pymysql.escape_string(name) + "'")
  2818. rows = curs.fetchall()
  2819. if(rows and rows[0]['acl'] == 'owner' or rows and rows[0]['acl'] == 'admin'):
  2820. return '<meta http-equiv="refresh" content="0;url=/error/4" />'
  2821. else:
  2822. if(request.method == 'POST'):
  2823. if(admincheck() == 1):
  2824. ip = getip(request)
  2825. curs.execute("select * from ban where block = '" + pymysql.escape_string(name) + "'")
  2826. row = curs.fetchall()
  2827. if(row):
  2828. block(name, '해제', getnow(), ip, '')
  2829. curs.execute("delete from ban where block = '" + pymysql.escape_string(name) + "'")
  2830. else:
  2831. b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))$", name)
  2832. if(b):
  2833. block(name, request.form["end"], getnow(), ip, request.form["why"])
  2834. curs.execute("insert into ban (block, end, why, band) value ('" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(request.form["end"]) + "', '" + pymysql.escape_string(request.form["why"]) + "', 'O')")
  2835. else:
  2836. block(name, request.form["end"], getnow(), ip, request.form["why"])
  2837. curs.execute("insert into ban (block, end, why, band) value ('" + pymysql.escape_string(name) + "', '" + pymysql.escape_string(request.form["end"]) + "', '" + pymysql.escape_string(request.form["why"]) + "', '')")
  2838. conn.commit()
  2839. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(data['frontpage']).replace('/','%2F') + '" />'
  2840. else:
  2841. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2842. else:
  2843. if(admincheck() == 1):
  2844. curs.execute("select * from ban where block = '" + pymysql.escape_string(name) + "'")
  2845. row = curs.fetchall()
  2846. if(row):
  2847. now = '차단 해제'
  2848. else:
  2849. b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))$", name)
  2850. if(b):
  2851. now = '대역 차단'
  2852. else:
  2853. now = '차단'
  2854. return render_template('index.html', title = name, page = parse.quote(name).replace('/','%2F'), logo = data['name'], tn = 16, now = now, today = getnow(), sub = '차단')
  2855. else:
  2856. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2857. @app.route('/acl/<path:name>', methods=['POST', 'GET'])
  2858. def acl(name = None):
  2859. if(request.method == 'POST'):
  2860. if(admincheck() == 1):
  2861. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  2862. row = curs.fetchall()
  2863. if(row):
  2864. if(request.form["select"] == 'admin'):
  2865. curs.execute("update data set acl = 'admin' where title = '" + pymysql.escape_string(name) + "'")
  2866. elif(request.form["select"] == 'user'):
  2867. curs.execute("update data set acl = 'user' where title = '" + pymysql.escape_string(name) + "'")
  2868. else:
  2869. curs.execute("update data set acl = '' where title = '" + pymysql.escape_string(name) + "'")
  2870. conn.commit()
  2871. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2872. else:
  2873. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2874. else:
  2875. if(admincheck() == 1):
  2876. curs.execute("select * from data where title = '" + pymysql.escape_string(name) + "'")
  2877. row = curs.fetchall()
  2878. if(row):
  2879. if(row[0]['acl'] == 'admin'):
  2880. now = '관리자만'
  2881. elif(row[0]['acl'] == 'user'):
  2882. now = '유저 이상'
  2883. else:
  2884. now = '일반'
  2885. return render_template('index.html', title = name, page = parse.quote(name).replace('/','%2F'), logo = data['name'], tn = 19, now = '현재 ACL 상태는 ' + now, sub = 'ACL')
  2886. else:
  2887. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(name).replace('/','%2F') + '" />'
  2888. else:
  2889. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2890. @app.route('/admin/<name>', methods=['POST', 'GET'])
  2891. def admin(name = None):
  2892. if(request.method == 'POST'):
  2893. if(ownercheck() == 1):
  2894. curs.execute("select * from user where id = '" + pymysql.escape_string(name) + "'")
  2895. row = curs.fetchall()
  2896. if(row):
  2897. if(row[0]['acl'] == 'admin' or row[0]['acl'] == 'owner'):
  2898. curs.execute("update user set acl = 'user' where id = '" + pymysql.escape_string(name) + "'")
  2899. else:
  2900. curs.execute("update user set acl = '" + pymysql.escape_string(request.form["select"]) + "' where id = '" + pymysql.escape_string(name) + "'")
  2901. conn.commit()
  2902. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(data['frontpage']).replace('/','%2F') + '" />'
  2903. else:
  2904. return '<meta http-equiv="refresh" content="0;url=/error/5" />'
  2905. else:
  2906. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2907. else:
  2908. if(ownercheck() == 1):
  2909. curs.execute("select * from user where id = '" + pymysql.escape_string(name) + "'")
  2910. row = curs.fetchall()
  2911. if(row):
  2912. if(row[0]['acl'] == 'admin' or row[0]['acl'] == 'owner'):
  2913. now = '권한 해제'
  2914. else:
  2915. now = '권한 부여'
  2916. return render_template('index.html', title = name, page = parse.quote(name).replace('/','%2F'), logo = data['name'], tn = 18, now = now, sub = '권한 부여')
  2917. else:
  2918. return '<meta http-equiv="refresh" content="0;url=/error/5" />'
  2919. else:
  2920. return '<meta http-equiv="refresh" content="0;url=/error/3" />'
  2921. @app.route('/ban')
  2922. def aban():
  2923. ip = getip(request)
  2924. if(getban(ip) == 1):
  2925. curs.execute("select * from ban where block = '" + pymysql.escape_string(ip) + "'")
  2926. rows = curs.fetchall()
  2927. if(rows):
  2928. if(rows[0]['end']):
  2929. end = rows[0]['end'] + ' 까지 차단 상태 입니다. / 사유 : ' + rows[0]['why']
  2930. now = getnow()
  2931. now = re.sub(':', '', now)
  2932. now = re.sub('\-', '', now)
  2933. now = re.sub(' ', '', now)
  2934. now = int(now)
  2935. day = rows[0]['end']
  2936. day = re.sub('\-', '', day)
  2937. if(now >= int(day + '000000')):
  2938. curs.execute("delete from ban where block = '" + pymysql.escape_string(ip) + "'")
  2939. conn.commit()
  2940. end = '차단이 풀렸습니다. 다시 시도 해 보세요.'
  2941. else:
  2942. end = '영구 차단 상태 입니다. / 사유 : ' + rows[0]['why']
  2943. else:
  2944. b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))", ip)
  2945. if(b):
  2946. results = b.groups()
  2947. curs.execute("select * from ban where block = '" + pymysql.escape_string(results[0]) + "' and band = 'O'")
  2948. row = curs.fetchall()
  2949. if(row):
  2950. if(row[0]['end']):
  2951. end = row[0]['end'] + ' 까지 차단 상태 입니다. / 사유 : ' + rows[0]['why']
  2952. now = getnow()
  2953. now = re.sub(':', '', now)
  2954. now = re.sub('\-', '', now)
  2955. now = re.sub(' ', '', now)
  2956. now = int(now)
  2957. day = row[0]['end']
  2958. day = re.sub('\-', '', day)
  2959. if(now >= int(day + '000000')):
  2960. curs.execute("delete from ban where block = '" + pymysql.escape_string(results[0]) + "' and band = 'O'")
  2961. conn.commit()
  2962. end = '차단이 풀렸습니다. 다시 시도 해 보세요.'
  2963. else:
  2964. end = '영구 차단 상태 입니다. / 사유 : ' + row[0]['why']
  2965. else:
  2966. end = '권한이 맞지 않는 상태 입니다.'
  2967. return render_template('index.html', title = '권한 오류', logo = data['name'], data = end), 401
  2968. @app.route('/w/<path:name>/r/<int:a>/diff/<int:b>')
  2969. def diff(name = None, a = None, b = None):
  2970. curs.execute("select * from history where id = '" + pymysql.escape_string(str(a)) + "' and title = '" + pymysql.escape_string(name) + "'")
  2971. rows = curs.fetchall()
  2972. if(rows):
  2973. curs.execute("select * from history where id = '" + pymysql.escape_string(str(b)) + "' and title = '" + pymysql.escape_string(name) + "'")
  2974. row = curs.fetchall()
  2975. if(row):
  2976. indata = re.sub('<', '&lt;', rows[0]['data'])
  2977. indata = re.sub('>', '&gt;', indata)
  2978. indata = re.sub('"', '&quot;', indata)
  2979. indata = re.sub('\n', '<br>', indata)
  2980. enddata = re.sub('<', '&lt;', row[0]['data'])
  2981. enddata = re.sub('>', '&gt;', enddata)
  2982. enddata = re.sub('"', '&quot;', enddata)
  2983. enddata = re.sub('\n', '<br>', enddata)
  2984. sm = difflib.SequenceMatcher(None, indata, enddata)
  2985. c = show_diff(sm)
  2986. return render_template('index.html', title = name, logo = data['name'], data = c, sub = '비교')
  2987. else:
  2988. return '<meta http-equiv="refresh" content="0;url=/history/' + parse.quote(name).replace('/','%2F') + '" />'
  2989. else:
  2990. return '<meta http-equiv="refresh" content="0;url=/history/' + parse.quote(name).replace('/','%2F') + '" />'
  2991. @app.route('/user')
  2992. def user():
  2993. ip = getip(request)
  2994. curs.execute("select * from user where id = '" + pymysql.escape_string(ip) + "'")
  2995. rows = curs.fetchall()
  2996. if(getban(ip) == 0):
  2997. if(rows):
  2998. if(rows[0]['acl'] == 'admin' or rows[0]['acl'] == 'owner'):
  2999. if(rows[0]['acl'] == 'admin'):
  3000. acl = '관리자'
  3001. else:
  3002. acl = '소유자'
  3003. else:
  3004. acl = '유저'
  3005. else:
  3006. acl = '일반'
  3007. else:
  3008. acl = '차단'
  3009. if(not re.search('\.', ip)):
  3010. curs.execute("select * from data where title = '사용자:" + pymysql.escape_string(ip) + "'")
  3011. row = curs.fetchall()
  3012. if(row):
  3013. ip = '<a href="/w/' + parse.quote('사용자:' + ip).replace('/','%2F') + '">' + ip + '</a>'
  3014. else:
  3015. ip = '<a class="not_thing" href="/w/' + parse.quote('사용자:' + ip).replace('/','%2F') + '">' + ip + '</a>'
  3016. return render_template('index.html', title = '유저 메뉴', logo = data['name'], data = ip + '<br><br><span>권한 상태 : ' + acl + '<br><br><li><a href="/login">로그인</a></li><li><a href="/logout">로그아웃</a></li><li><a href="/register">회원가입</a></li><li><a href="/change">비밀번호 변경</a></li>')
  3017. @app.route('/random')
  3018. def random():
  3019. curs.execute("select * from data order by rand() limit 1")
  3020. rows = curs.fetchall()
  3021. if(rows):
  3022. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(rows[0]['title']).replace('/','%2F') + '" />'
  3023. else:
  3024. return '<meta http-equiv="refresh" content="0;url=/" />'
  3025. @app.route('/error/<int:num>')
  3026. def error(num = None):
  3027. if(num == 1):
  3028. return render_template('index.html', title = '권한 오류', logo = data['name'], data = '비 로그인 상태 입니다.'), 401
  3029. elif(num == 2):
  3030. return render_template('index.html', title = '권한 오류', logo = data['name'], data = '이 계정이 없습니다.'), 401
  3031. elif(num == 3):
  3032. return render_template('index.html', title = '권한 오류', logo = data['name'], data = '권한이 모자랍니다.'), 401
  3033. elif(num == 4):
  3034. return render_template('index.html', title = '권한 오류', logo = data['name'], data = '관리자는 차단, 검사 할 수 없습니다.'), 401
  3035. elif(num == 5):
  3036. return render_template('index.html', title = '유저 오류', logo = data['name'], data = '그런 계정이 없습니다.'), 401
  3037. elif(num == 6):
  3038. return render_template('index.html', title = '가입 오류', logo = data['name'], data = '동일한 아이디의 유저가 있습니다.'), 401
  3039. elif(num == 7):
  3040. return render_template('index.html', title = '가입 오류', logo = data['name'], data = '아이디는 20글자보다 짧아야 합니다.'), 401
  3041. elif(num == 8):
  3042. return render_template('index.html', title = '가입 오류', logo = data['name'], data = '아이디에는 한글과 알파벳과 공백만 허용 됩니다.'), 401
  3043. elif(num == 9):
  3044. return render_template('index.html', title = '변경 오류', logo = data['name'], data = '그런 계정이 없습니다.'), 401
  3045. elif(num == 10):
  3046. return render_template('index.html', title = '변경 오류', logo = data['name'], data = '비밀번호가 다릅니다.'), 401
  3047. elif(num == 11):
  3048. return render_template('index.html', title = '로그인 오류', logo = data['name'], data = '이미 로그인 되어 있습니다.'), 401
  3049. elif(num == 12):
  3050. return render_template('index.html', title = '로그인 오류', logo = data['name'], data = '그런 계정이 없습니다.'), 401
  3051. elif(num == 13):
  3052. return render_template('index.html', title = '로그인 오류', logo = data['name'], data = '비밀번호가 다릅니다.'), 401
  3053. elif(num == 14):
  3054. return render_template('index.html', title = '업로드 오류', logo = data['name'], data = 'jpg, gif, jpeg, png만 가능 합니다.'), 401
  3055. elif(num == 15):
  3056. return render_template('index.html', title = '업로드 오류', logo = data['name'], data = '파일 명에 . / \ * < > | : ? 가 들어 갈 수 없습니다.'), 401
  3057. elif(num == 16):
  3058. return render_template('index.html', title = '업로드 오류', logo = data['name'], data = '동일한 이름의 파일이 있습니다.'), 401
  3059. elif(num == 17):
  3060. return render_template('index.html', title = '편집 오류', logo = data['name'], data = '편집 내용 기록에는 한글과 영어와 숫자, 공백만 허용 됩니다.'), 401
  3061. elif(num == 18):
  3062. return render_template('index.html', title = '편집 오류', logo = data['name'], data = '내용이 원래 문서와 동일 합니다.'), 401
  3063. elif(num == 19):
  3064. return render_template('index.html', title = '이동 오류', logo = data['name'], data = '이동 하려는 곳에 문서가 이미 있습니다.'), 401
  3065. elif(num == 20):
  3066. return render_template('index.html', title = '비밀번호 오류', logo = data['name'], data = '재 확인이랑 비밀번호가 다릅니다.'), 401
  3067. else:
  3068. return '<meta http-equiv="refresh" content="0;url=/" />'
  3069. @app.errorhandler(404)
  3070. def uncaughtError(error):
  3071. return '<meta http-equiv="refresh" content="0;url=/w/' + parse.quote(data['frontpage']).replace('/','%2F') + '" />'
  3072. if __name__ == '__main__':
  3073. app.run(host = '0.0.0.0', port = int(data['port']))