app.py 183 KB

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