openNAMU__openNAMU/app.py

from bottle import *
from bottle.ext import beaker
import bcrypt
import os
import difflib
import hashlib
import json
import sqlite3
import html

try:
    json_data = open('set.json').read()
    set_data = json.loads(json_data)
except:
    new_json = []

    print('DB 이름 : ', end = '')
    new_json += [input()]

    print('위키 포트 : ', end = '')
    new_json += [input()]

    with open("set.json", "w") as f:
        f.write('{ "db" : "' + new_json[0] + '", "port" : "' + new_json[1] + '" }')
    
    json_data = open('set.json').read()
    set_data = json.loads(json_data)

conn = sqlite3.connect(set_data['db'] + '.db')
curs = conn.cursor()

session_opts = {
    'session.type': 'file',
    'session.data_dir': './app_session/',
    'session.auto': 1
}

app = beaker.middleware.SessionMiddleware(app(), session_opts)

BaseRequest.MEMFILE_MAX = 1024 * 1024

def redirect(data):
    return('<meta http-equiv="refresh" content="0;url=' + data + '" />')
    
from func import *

r_ver = '2.2.3'
p_ver = ''

try:
    curs.execute('select data from other where name = "version"')
    version = curs.fetchall()
    if(version):
        t_ver = re.sub('\.', '', version[0][0])
        r_t_ver = re.sub('\.', '', r_ver)
        if(int(t_ver) < int(r_t_ver)):
            curs.execute("update other set data = ? where name = 'version'", [r_ver])    
    
    conn.commit()
except:
    pass

@route('/setup', method=['GET', 'POST'])
def setup():
    curs.execute("create table data(title text, data text, acl text)")
    curs.execute("create table history(id text, title text, data text, date text, ip text, send text, leng text)")
    curs.execute("create table rd(title text, sub text, date text)")
    curs.execute("create table user(id text, pw text, acl text)")
    curs.execute("create table ban(block text, end text, why text, band text)")
    curs.execute("create table topic(id text, title text, sub text, data text, date text, ip text, block text, top text)")
    curs.execute("create table stop(title text, sub text, close text)")
    curs.execute("create table rb(block text, end text, today text, blocker text, why text)")
    curs.execute("create table login(user text, ip text, today text)")
    curs.execute("create table back(title text, link text, type text)")
    curs.execute("create table cat(title text, cat text)")
    curs.execute("create table hidhi(title text, re text)")
    curs.execute("create table agreedis(title text, sub text)")
    curs.execute("create table custom(user text, css text)")
    curs.execute("create table other(name text, data text)")
    curs.execute("create table alist(name text, acl text)")

    curs.execute("insert into alist (name, acl) values ('owner', 'owner')")
    curs.execute("insert into other (name, data) values ('version', ?)", [r_ver])

    curs.execute('insert into other (name, data) values ("name", "wiki")')
    curs.execute('insert into other (name, data) values ("frontpage", "위키:대문")')
    curs.execute('insert into other (name, data) values ("license", "CC 0")')
    curs.execute('insert into other (name, data) values ("upload", "2")')
    conn.commit()

    return(redirect('/'))

@route('/edit_set', method=['POST', 'GET'])
def edit_set():
    if(admin_check(None) == 1):
        if(request.method == 'POST'):
            curs.execute("update other set data = ? where name = ?", [request.forms.name, 'name'])
            curs.execute("update other set data = ? where name = 'frontpage'", [request.forms.frontpage])
            curs.execute("update other set data = ? where name = 'license'", [request.forms.license])
            curs.execute("update other set data = ? where name = 'upload'", [request.forms.upload])
            conn.commit()

            return(redirect('/'))
        else:
            curs.execute('select data from other where name = ?', ['name'])
            name_d = curs.fetchall()

            curs.execute('select data from other where name = "frontpage"')
            frontpage_d = curs.fetchall()

            curs.execute('select data from other where name = "license"')
            license_d = curs.fetchall()

            curs.execute('select data from other where name = "upload"')
            upload_d = curs.fetchall()

            return(
                template(
                    'index', 
                    imp = ['설정 편집', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<form method="post"> \
                                <input style="width: 100%;" type="text" name="name" value="' + name_d[0][0] + '"> \
                                <br> \
                                <br> \
                                <input style="width: 100%;" type="text" name="frontpage" value="' + frontpage_d[0][0] + '"> \
                                <br> \
                                <br> \
                                <input style="width: 100%;" type="text" name="license" value="' + license_d[0][0] + '"> \
                                <br> \
                                <br> \
                                <input style="width: 100%;" type="text" name="upload" value="' + upload_d[0][0] + '"> \
                                <br> \
                                <br> \
                                <span>차례대로 위키 이름, 시작 페이지, 라이선스, 파일 올리기 최대 크기 입니다.</span> \
                                <br> \
                                <br> \
                                <button class="btn btn-primary" type="submit">저장</button> \
                            </form>',
                    menu = [['manager', '관리자']]
                )
            )
    else:
        return(redirect('/ban'))

@route('/update')
@route('/update/<num:int>')
def update(num = 1):
    if(admin_check(None) == 1):
        if(num == 1):
            return(
                template(
                    'index', 
                    imp = ['업데이트 목록', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<li><a href="/update/2">2.2.1</a></li>',
                    menu = [['manager', '관리자']]
                )
            )
        elif(num == 2):
            curs.execute('insert into other (name, data) values ("name", ?)', [set_data['name']])
            curs.execute('insert into other (name, data) values ("frontpage", ?)', [set_data['frontpage']])
            curs.execute('insert into other (name, data) values ("license", ?)', [set_data['license']])
            curs.execute('insert into other (name, data) values ("upload", ?)', [set_data['upload']])
            conn.commit()

            return(redirect('/'))
    else:
        return(redirect('/ban'))

@route('/not_close_topic')
def not_close_topic():
    div = ''
    i = 1

    curs.execute('select title, sub from rd order by date desc')
    n_list = curs.fetchall()
    for data in n_list:
        curs.execute('select * from stop where title = ? and sub = ? and close = "O"', [data[0], data[1]])
        is_close = curs.fetchall()
        if(not is_close):
            div += '<li>' + str(i) + '. <a href="/topic/' + url_pas(data[0]) + '/sub/' + url_pas(data[1]) + '">' + data[0] + ' (' + data[1] + ')</a></li>'
            i += 1

    return(
        template(
            'index', 
            imp = ['열린 토론 목록', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = div,
            menu = [['manager', '관리자']]
        )
    )

@route('/image/<name:path>')
def static(name = None):
    if(os.path.exists(os.path.join('image', name))):
        return(static_file(name, root = 'image'))
    else:
        return(redirect('/'))

@route('/acl_list')
def acl_list():
    div = ''
    i = 0

    curs.execute("select title, acl from data where acl = 'admin' or acl = 'user' order by acl desc")
    list_data = curs.fetchall()
    for data in list_data:
        if(data[1] == 'admin'):
            acl = '관리자'
        else:
            acl = '로그인'

        div += '<li>' + str(i + 1) + '. <a href="/w/' + url_pas(data[0]) + '">' + data[0] + '</a> (' + acl + ')</li>'
        
        i += 1
    
    return(
        template(
            'index', 
            imp = ['ACL 문서 목록', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = div,
            menu = [['other', '기타']]
        )
    )
    
@route('/list_acl')
def list_acl():
    div = ''
    i = 0

    curs.execute("select name, acl from alist order by name desc")
    list_data = curs.fetchall()
    for data in list_data:
        if(data[1] == 'ban'):
            acl = '차단'
        elif(data[1] == 'mdel'):
            acl = '많은 문서 삭제'
        elif(data[1] == 'toron'):
            acl = '토론 관리'
        elif(data[1] == 'check'):
            acl = '사용자 검사'
        elif(data[1] == 'acl'):
            acl = '문서 ACL'
        elif(data[1] == 'hidel'):
            acl = '역사 숨김'
        elif(data[1] == 'owner'):
            acl = '소유자'
            
        div += '<li>' + str(i + 1) + '. <a href="/admin_plus/' + url_pas(data[0]) + '">' + data[0] + '</a> (' + acl + ')</li>'
        
        i += 1
    else:        
        div +=  '<br> \
                <a href="/manager/8">(생성)</a>'

    return(
        template(
            'index',    
            imp = ['ACL 목록', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = re.sub('^<br>', '', div),
            menu = [['manager', '관리자']]
        )
    )

@route('/admin_plus/<name:path>', method=['POST', 'GET'])
def admin_plus(name = None):
    if(admin_check(None) == 1):
        if(request.method == 'POST'):
            curs.execute("delete from alist where name = ?", [name])
            
            if(request.forms.ban):
                curs.execute("insert into alist (name, acl) values (?, 'ban')", [name])

            if(request.forms.mdel):
                curs.execute("insert into alist (name, acl) values (?, 'mdel')", [name])   

            if(request.forms.toron):
                curs.execute("insert into alist (name, acl) values (?, 'toron')", [name])
                
            if(request.forms.check):
                curs.execute("insert into alist (name, acl) values (?, 'check')", [name])

            if(request.forms.acl):
                curs.execute("insert into alist (name, acl) values (?, 'acl')", [name])

            if(request.forms.hidel):
                curs.execute("insert into alist (name, acl) values (?, 'hidel')", [name])

            if(request.forms.owner):
                curs.execute("insert into alist (name, acl) values (?, 'owner')", [name])
                
            conn.commit()
            
            return(redirect('/admin_plus/admin'))
        else:
            curs.execute('select acl from alist where name = ?', [name])
            test = curs.fetchall()
            
            data = ''
            exist_list = ['', '', '', '', '', '', '', '', '']

            for go in test:
                if(go[0] == 'ban'):
                    exist_list[0] = 'checked="checked"'
                elif(go[0] == 'mdel'):
                    exist_list[1] = 'checked="checked"'
                elif(go[0] == 'toron'):
                    exist_list[2] = 'checked="checked"'
                elif(go[0] == 'check'):
                    exist_list[3] = 'checked="checked"'
                elif(go[0] == 'acl'):
                    exist_list[4] = 'checked="checked"'
                elif(go[0] == 'hidel'):
                    exist_list[5] = 'checked="checked"'
                elif(go[0] == 'owner'):
                    exist_list[7] = 'checked="checked"'

            data += '<li><input type="checkbox" name="ban" ' + exist_list[0] + '> 차단</li>'
            data += '<li><input type="checkbox" name="mdel" ' + exist_list[1] + '> 많은 문서 삭제</li>'
            data += '<li><input type="checkbox" name="toron" ' + exist_list[2] + '> 토론 관리</li>'
            data += '<li><input type="checkbox" name="check" ' + exist_list[3] + '> 사용자 검사</li>'
            data += '<li><input type="checkbox" name="acl" ' + exist_list[4] + '> 문서 ACL</li>'
            data += '<li><input type="checkbox" name="hidel" ' + exist_list[5] + '> 역사 숨김</li>'
            data += '<li><input type="checkbox" name="owner" ' + exist_list[7] + '> 소유자</li>'

            return(
                template(
                    'index', 
                    imp = ['관리 그룹 추가', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<form method="post">' \
                                + data + \
                                '<div class="form-actions"> \
                                    <button class="btn btn-primary" type="submit">저장</button> \
                                </div> \
                            </form>',
                    menu = [['manager', '관리자']]
                )
            )
    else:
        return(redirect('/error/3'))
        
@route('/admin_list')
def admin_list():
    i = 1
    div = ''
    
    curs.execute("select id, acl from user where not acl = 'user'")
    user_data = curs.fetchall()

    for data in user_data:
        name = ip_pas(data[0], 2) + ' (' + data[1] + ')'

        div += '<li>' + str(i) + '. ' + name + '</li>'
        
        i += 1
                
    return(
        template(
            'index', 
            imp = ['관리자 목록', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = div,
            menu = [['other', '기타']]
        )
    )
        
@route('/record/<name:path>')
@route('/record/<name:path>/n/<num:int>')
@route('/recent_changes')
def recent_changes(name = None, num = 1):
    ydmin = admin_check(1)
    zdmin = admin_check(6)
    ban = ''
    send = '<br>'
    div =  '<table style="width: 100%; text-align: center;"> \
                <tbody> \
                    <tr> \
                        <td style="width: 33.3%;">문서명</td> \
                        <td style="width: 33.3%;">기여자</td> \
                        <td style="width: 33.3%;">시간</td> \
                    </tr>'
    
    if(name):
        if(num * 50 <= 0):
            v = 50
        else:
            v = num * 50
            
        i = v - 50

        curs.execute("select id, title, date, ip, send, leng from history where ip = ? order by date desc limit ?, ?", [name, str(i), str(v)])
    else:
        curs.execute("select id, title, date, ip, send, leng from history order by date desc limit 50")

    rows = curs.fetchall()

    for data in rows:         
        send = '<br>'
        if(data[4]):
            if(not re.search("^(?: *)$", data[4])):
                send = data[4]
    
        title = html.escape(data[1])
        
        if(re.search("\+", data[5])):
            leng = '<span style="color:green;">' + data[5] + '</span>'
        elif(re.search("\-", data[5])):
            leng = '<span style="color:red;">' + data[5] + '</span>'
        else:
            leng = '<span style="color:gray;">' + data[5] + '</span>'
            
        if(ydmin == 1):
            curs.execute("select * from ban where block = ?", [data[3]])
            row = curs.fetchall()
            if(row):
                ban = ' <a href="/ban/' + url_pas(data[3]) + '">(해제)</a>'
            else:
                ban = ' <a href="/ban/' + url_pas(data[3]) + '">(차단)</a>'            
            
        ip = ip_pas(data[3], None)
                
        if((int(data[0]) - 1) == 0):
            revert = ''
        else:
            revert = '<a href="/w/' + url_pas(data[1]) + '/r/' + str(int(data[0]) - 1) + '/diff/' + data[0] + '">(비교)</a> <a href="/revert/' + url_pas(data[1]) + '/r/' + str(int(data[0]) - 1) + '">(되돌리기)</a>'
        
        style = ''
        curs.execute("select * from hidhi where title = ? and re = ?", [data[1], data[0]])
        row = curs.fetchall()
        if(zdmin == 1):    
            if(row):                            
                ip += ' (숨김)'                            
                hidden = ' <a href="/history/' + url_pas(data[1]) + '/r/' + data[0] + '/hidden">(공개)'
            else:
                hidden = ' <a href="/history/' + url_pas(data[1]) + '/r/' + data[0] + '/hidden">(숨김)'
        else:
            if(row):
                ip = '숨김'
                hidden = ''
                send = '숨김'
                ban = ''
                style = 'display:none;'
            else:
                hidden = ''      
            
        div += '<tr style="' + style + '"> \
                    <td> \
                        <a href="/w/' + url_pas(data[1]) + '">' + title + '</a> (<a href="/history/' + url_pas(data[1]) + '">' + data[0] + '판</a>) ' + revert + ' (' + leng + ') \
                    </td> \
                    <td>' + ip + ban + hidden + '</td> \
                    <td>' + data[2] + '</td> \
                </tr> \
                <tr> \
                    <td colspan="3">' + send + '</td> \
                </tr>'
    else:
        div +=      '</tbody> \
                </table>'

    if(name):
        curs.execute("select end, why from ban where block = ?", [name])
        ban_it = curs.fetchall()
        if(ban_it):
            sub = '(차단)'
        else:
            sub = 0

        title = '사용자 기록'
        menu = [['other', '기타'], ['user', '사용자']]
        div += '<br> \
                <a href="/record/' + url_pas(name) + '/n/' + str(num + 1) + '">(이전)</a> <a href="/record/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전)</a>'
    else:
        sub = 0
        menu = 0
        title = '최근 변경내역'
            
    return(
        template(
            'index', 
            imp = [title, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), sub],
            data = div,
            menu = menu
        )
    )
        
@route('/history/<name:path>/r/<num:int>/hidden')
def history_hidden(name = None, num = None):
    if(admin_check(6) == 1):
        curs.execute("select * from hidhi where title = ? and re = ?", [name, str(num)])
        exist = curs.fetchall()
        if(exist):
            curs.execute("delete from hidhi where title = ? and re = ?", [name, str(num)])
        else:
            curs.execute("insert into hidhi (title, re) values (?, ?)", [name, str(num)])
            
        conn.commit()
    
    return(redirect('/history/' + url_pas(name)))
        
@route('/userlog')
@route('/userlog/n/<num:int>')
def user_log(num = 1):
    if(num * 50 <= 0):
         i = 50
    else:
        i = num * 50
        
    j = i - 50
    list_data = ''
    ydmin = admin_check(1)
    
    curs.execute("select id from user limit ?, ?", [str(j), str(i)])
    user_list = curs.fetchall()
    for data in user_list:
        if(ydmin == 1):
            curs.execute("select block from ban where block = ?", [data[0]])
            ban_exist = curs.fetchall()
            if(ban_exist):
                ban_button = ' <a href="/ban/' + url_pas(data[0]) + '">(해제)</a>'
            else:
                ban_button = ' <a href="/ban/' + url_pas(data[0]) + '">(차단)</a>'
        else:
            ban_button = ''
            
        ip = ip_pas(data[0], 2)
            
        list_data += '<li>' + str(j + 1) + '. ' + ip + ban_button + '</li>'
        
        j += 1
    else:
        list_data +=    '<br> \
                        <a href="/userlog/n/' + str(num - 1) + '">(이전)</a> <a href="/userlog/n/' + str(num + 1) + '">(이후)</a>'

    return(
        template(
            'index', 
            imp = ['사용자 가입 기록', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = list_data,
            menu = [['other', '기타']]
        )
    )
        
@route('/back_reset')
def back_reset():
    if(admin_check(None) == 1):        
        curs.execute("delete from back")
        curs.execute("delete from cat")
        conn.commit()
        
        curs.execute("select title, data from data")
        data = curs.fetchall()
        for end in data:
            print(end[0])
            
            namumark(end[0], end[1], 1, 0)
        
        return(redirect('/'))
    else:
        
        return(redirect('/error/3'))
        
@route('/xref/<name:path>')
@route('/xref/<name:path>/n/<num:int>')
def xref(name = None, num = 1):
    if(num * 50 <= 0):
        v = 50
    else:
        v = num * 50
        
    i = v - 50
    div = ''
    
    curs.execute("delete from back where title = ? and link = ''", [name])
    conn.commit()
    
    curs.execute("select link, type from back where title = ? order by link asc limit ?, ?", [name, str(i), str(v)])
    rows = curs.fetchall()
    for data in rows:
        div += '<li><a href="/w/' + url_pas(data[0]) + '">' + data[0] + '</a>'
        
        if(data[1]):
            div += ' (' + data[1] + ')'
        
        div += '</li>'
    else:        
        div += '<br> \
                <a href="/xref/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전)</a> <a href="/xref/' + url_pas(name) + '/n/' + str(num + 1) + '">(이후)</a>'
    
    return(
        template(
            'index', 
            imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), ' (역링크)'],
            data = div,
            menu = [['w/' + url_pas(name), '문서']]
        )
    )
        
@route('/recent_discuss')
def recent_discuss():
    div =   '<table style="width: 100%; text-align: center;"> \
                <tbody> \
                    <tr> \
                        <td style="width: 50%;">토론명</td> \
                        <td style="width: 50%;">시간</td> \
                    </tr>'
    
    curs.execute("select title, sub, date from rd order by date desc limit 50")
    rows = curs.fetchall()
    for data in rows:
        title = html.escape(data[0])
        sub = html.escape(data[1])
        
        div += '<tr> \
                    <td> \
                        <a href="/topic/' + url_pas(data[0]) + '/sub/' + url_pas(data[1]) + '">' + title + '</a> (' + sub + ') \
                    </td> \
                    <td>' + data[2] + '</td> \
                </tr>'
    else:
        div +=      '</tbody> \
                </table>'
            
    return(
        template(
            'index', 
            imp = ['최근 토론내역', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = div,
            menu = 0
        )
    )

@route('/blocklog')
@route('/blocklog/n/<number:int>')
def blocklog(num = 1):
    if(num * 50 <= 0):
        v = 50
    else:
        v = num * 50
    
    i = v - 50
    div =   '<table style="width: 100%; text-align: center;"> \
                <tbody> \
                    <tr> \
                        <td style="width: 33.3%;">차단자</td> \
                        <td style="width: 33.3%;">관리자</td> \
                        <td style="width: 33.3%;">기간</td> \
                    </tr> \
                    <tr> \
                        <td colspan="2">이유</td> \
                        <td>시간</td> \
                    </tr>'
    
    curs.execute("select why, block, blocker, end, today from rb order by today desc limit ?, ?", [str(i), str(v)])
    rows = curs.fetchall()
    for data in rows:
        why = html.escape(data[0])
        
        b = re.search("^([0-9]{1,3}\.[0-9]{1,3})$", data[1])
        if(b):
            ip = data[1] + ' (대역)'
        else:
            ip = ip_pas(data[1], 2)

        if(not data[3] == ''):
            end = data[3]
        else:
            end = '무기한'
            
        div += '<tr> \
                    <td>' + ip + '</td> \
                    <td>' + ip_pas(data[2], 2) + '</td> \
                    <td>' + end + '</td> \
                </tr> \
                <tr> \
                    <td colspan="2">' + why + '</td> \
                    <td>' + data[4] + '</td> \
                </tr>'
    else:
        div +=      '</tbody> \
                </table> \
                <br> \
                <a href="/blocklog/n/' + str(num - 1) + '">(이전)</a> <a href="/blocklog/n/' + str(num + 1) + '">(이후)</a>'
                
    return(
        template(
            'index', 
            imp = ['차단 기록', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = div,
            menu = [['other', '기타']]
        )
    )

@route('/history/<name:path>', method=['POST', 'GET'])    
@route('/history/<name:path>/n/<num:int>', method=['POST', 'GET'])
def history_view(name = None, num = 1):
    if(request.method == 'POST'):
        return(redirect('/w/' + url_pas(name) + '/r/' + request.forms.b + '/diff/' + request.forms.a))
    else:
        select = ''
        if(num * 50 <= 0):
            i = 50
        else:
            i = num * 50
            
        j = i - 50
 
        admin1 = admin_check(1)
        admin2 = admin_check(6)
        
        div =   '<table style="width: 100%; text-align: center;"> \
                    <tbody> \
                        <tr> \
                            <td style="width: 33.3%;">판</td> \
                            <td style="width: 33.3%;">기여자</td> \
                            <td style="width: 33.3%;">시간</td> \
                        </tr>'
        
        curs.execute("select send, leng, ip, date, title, id from history where title = ? order by id + 0 desc limit ?, ?", [name, str(j), str(i)])
        all_data = curs.fetchall()
        for data in all_data:
            select += '<option value="' + data[5] + '">' + data[5] + '</option>'
            
            if(data[0]):
                send = data[0]
            else:
                send = '<br>'
                
            if(re.search("^\+", data[1])):
                leng = '<span style="color:green;">' + data[1] + '</span>'
            elif(re.search("^\-", data[1])):
                leng = '<span style="color:red;">' + data[1] + '</span>'
            else:
                leng = '<span style="color:gray;">' + data[1] + '</span>'
                
            ip = ip_pas(data[2], None)
            
            curs.execute("select block from ban where block = ?", [data[2]])
            ban_it = curs.fetchall()
            if(ban_it):
                if(admin1 == 1):
                    ban = ' <a href="/ban/' + url_pas(data[2]) + '">(해제)</a>'
                else:
                    ban = ' (X)'
            else:
                if(admin1 == 1):
                    ban = ' <a href="/ban/' + url_pas(data[2]) + '">(차단)</a>'
                else:
                    ban = ''
            
            curs.execute("select * from hidhi where title = ? and re = ?", [name, data[5]])
            hid_it = curs.fetchall()
            if(hid_it):
                if(admin2):
                    hidden = ' <a href="/history/' + url_pas(name) + '/r/' + url_pas(data[5]) + '/hidden">(공개)'
                    hid = 0
                else:
                    hid = 1
            else:
                if(admin2):
                    hidden = ' <a href="/history/' + url_pas(name) + '/r/' + url_pas(data[5]) + '/hidden">(숨김)'
                    hid = 0
                else:
                    hidden = ''
                    hid = 0
            
            if(hid == 1):
                div += '<tr> \
                            <td colspan="3">숨김</td> \
                        </tr>'
            else:
                div += '<tr> \
                            <td> \
                                ' + data[5] + '판</a> <a href="/w/' + url_pas(name) + '/r/' + url_pas(data[5]) + '">(보기)</a> \
                                    <a href="/raw/' + url_pas(name) + '/r/' + url_pas(data[5]) + '">(원본)</a> \
                                    <a href="/revert/' + url_pas(name) + '/r/' + url_pas(data[5]) + '">(되돌리기)</a> (' + leng + ') \
                            </td> \
                            <td>' + ip + ban + hidden + '</td> \
                            <td>' + data[3] + '</td> \
                        </tr> \
                        <tr> \
                            <td colspan="3">' + send + '</td> \
                        </tr>'
        else:
            div +=      '</tbody> \
                    </table> \
                    <br> \
                    <a href="/history/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전)</a> <a href="/history/' + url_pas(name) + '/n/' + str(num + 1) + '">(이후)</a>'

        div =   '<form method="post"> \
                    <select name="a"> \
                        ' + select + ' \
                    </select> \
                    <select name="b"> \
                        ' + select + ' \
                    </select> \
                    <button class="btn btn-primary" type="submit">비교</button> \
                </form>' + div

        return(
            template(
                'index', 
                imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), ' (역사)'],
                data = div,
                menu = [['w/' + url_pas(name), '문서']]
            )
        )
            
@route('/search', method=['POST'])
def search():
    return(redirect('/search/' + url_pas(request.forms.search)))

@route('/goto', method=['POST'])
def goto():
    curs.execute("select title from data where title = ?", [request.forms.search])
    data = curs.fetchall()
    if(data):
        return(redirect('/w/' + url_pas(request.forms.search)))
    else:
        return(redirect('/search/' + url_pas(request.forms.search)))

@route('/search/<name:path>')
@route('/search/<name:path>/n/<num:int>')
def deep_search(name = None, num = 1):
    if(num * 50 <= 0):
        v = num * 50
    else:
        v = 50

    i = v - 50

    div = ''
    div_plus = ''
    end = ''

    curs.execute("select title from data where title like ?", ['%' + name + '%'])
    title_list = curs.fetchall()

    curs.execute("select title from data where data like ?", ['%' + name + '%'])
    data_list = curs.fetchall()

    curs.execute("select title from data where title = ?", [name])
    exist = curs.fetchall()
    if(exist):
        div =   '<li>문서로 <a href="/w/' + url_pas(name) + '">바로가기</a></li> \
                <br>'
    else:
        div =   '<li>문서가 없습니다. <a class="not_thing" href="/w/' + url_pas(name) + '">바로가기</a></li> \
                <br>'

    if(title_list):
        no = 0

        if(data_list):
            all_list = title_list + data_list
        else:
            all_list = title_list
    else:
        if(data_list):
            no = 1

            all_list = data_list
        else:
            all_list = ''
    
    if(all_list != ''):
        for data in all_list:
            try:
                var_re = re.search(name, data[0])
            except:
                var_re = re.search('\\' + name, data[0])
                
            if(var_re):
                if(no == 0):
                    div += '<li><a href="/w/' + url_pas(data[0]) + '">' + data[0] + '</a> (문서명)</li>'
                else:
                    div_plus += '<li><a href="/w/' + url_pas(data[0]) + '">' + data[0] + '</a> (내용)</li>'
            else:
                no = 1

                div_plus += '<li><a href="/w/' + url_pas(data[0]) + '">' + data[0] + '</a> (내용)</li>'
    else:
        div += '<li>검색 결과 없음</li>'

    div += div_plus + end

    div += '<br> \
            <a href="/search/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전)</a> <a href="/search/' + url_pas(name) + '/n/' + str(num + 1) + '">(이후)</a>'
    
    return(
        template(
            'index', 
            imp = ['검색', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = div,
            menu = 0
        )
    )
         
@route('/raw/<name:path>')
@route('/raw/<name:path>/r/<num:int>')
def raw_view(name = None, num = None):
    if(num):
        curs.execute("select title from hidhi where title = ? and re = ?", [name, str(num)])
        hid = curs.fetchall()
        if(hid and admin_check(6) != 1):
            return(redirect('/error/3'))
        
        curs.execute("select data from history where title = ? and id = ?", [name, str(num)])
    else:
        curs.execute("select data from data where title = ?", [name])

    rows = curs.fetchall()
    if(rows):
        enddata = html.escape(rows[0][0])
        
        enddata = '<textarea readonly="" style="height: 80%;">' + enddata + '</textarea>'
        
        return(
            template(
                'index', 
                imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), ' (원본)'],
                data = enddata,
                menu = [['w/' + url_pas(name), '문서'], ['history/' + url_pas(name), '역사']]
            )
        )
    else:
        return(redirect('/w/' + url_pas(name)))
        
@route('/revert/<name:path>/r/<num:int>', method=['POST', 'GET'])
def revert(name = None, num = None):
    ip = ip_check()
    can = acl_check(ip, name)
    today = get_time()
    
    if(request.method == 'POST'):
        curs.execute("select title from hidhi where title = ? and re = ?", [name, str(num)])
        hid = curs.fetchall()
        if(hid and admin_check(6) != 1):
            return(redirect('/error/3'))

        if(can == 1):
            return(redirect('/ban'))
        else:
            curs.execute("delete from back where link = ?", [name])
            curs.execute("delete from cat where cat = ?", [name])
            conn.commit()

            curs.execute("select data from history where title = ? and id = ?", [name, str(num)])
            rows = curs.fetchall()
            if(rows):                                
                curs.execute("select data from data where title = ?", [name])
                row = curs.fetchall()
                if(row):
                    leng = leng_check(len(row[0][0]), len(rows[0][0]))
                    
                    curs.execute("update data set data = ? where title = ?", [rows[0][0], name])
                    conn.commit()
                else:
                    leng = '+' + str(len(rows[0][0]))
                    
                    curs.execute("insert into data (title, data, acl) values (?, ?, '')", [name, rows[0][0]])
                    conn.commit()
                    
                history_plus(
                    name, 
                    rows[0][0], 
                    today, 
                    ip, 
                    '문서를 ' + str(num) + '판으로 되돌렸습니다.', 
                    leng
                )
                
                return(redirect('/w/' + url_pas(name)))
    else:
        curs.execute("select title from hidhi where title = ? and re = ?", [name, str(num)])
        hid = curs.fetchall()
        if(hid and admin_check(6) != 1):
            return(redirect('/error/3'))    
                          
        if(can == 1):
            return(redirect('/ban'))
        else:
            curs.execute("select title from history where title = ? and id = ?", [name, str(num)])
            rows = curs.fetchall()
            if(rows):
                l_c = login_check()
                if(l_c == 0):
                    plus = '<br> \
                            <span>비 로그인 상태입니다. 비 로그인으로 작업 시 아이피가 역사에 기록됩니다.</span> \
                            <br> \
                            <br>'
                else:
                    plus = ''

                return(
                    template(
                        'index', 
                        imp = [name, wiki_set(1), wiki_set(3), l_c, custom_css(), custom_js(), ' (되돌리기)'],
                        data =  plus + ' \
                                <form method="post"> \
                                    <button class="btn btn-primary" type="submit">되돌리기</button> \
                                </form>',
                        menu = [['history/' + url_pas(name), '역사'], ['recent_changes', '최근 변경']]
                    )
                )
            else:
                return(redirect('/w/' + url_pas(name)))
                    
@route('/m_del', method=['POST', 'GET'])
def m_del():
    today = get_time()
    ip = ip_check()
    if(admin_check(2) == 1):
        if(request.method == 'POST'):
            data = request.forms.content + '\r\n'
            m = re.findall('(.*)\r\n', data)
            for g in m:
                curs.execute("select data from data where title = ?", [g])
                rows = curs.fetchall()
                if(rows):
                    curs.execute("delete from back where title = ?", [g])
                    curs.execute("delete from cat where title = ?", [g])

                    leng = '-' + str(len(rows[0][0]))
                    curs.execute("delete from data where title = ?", [g])
                    history_plus(
                        g, 
                        '', 
                        today, 
                        ip, 
                        request.forms.send + ' (대량 삭제)', 
                        leng
                    )
                data = re.sub('(.*)\r\n', '', data, 1)
            conn.commit()

            return(redirect('/'))
        else:
            return(
                template(
                    'index', 
                    imp = ['많은 문서 삭제', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<br> \
                            <span> \
                                문서명 A \
                                <br> \
                                문서명 B \
                                <br> \
                                문서명 C \
                                <br> \
                                <br> \
                                이런 식으로 기제 하시오 \
                            </span> \
                            <br> \
                            <br> \
                            <form method="post"> \
                                <textarea style="height: 80%;" name="content"></textarea> \
                                <br> \
                                <br> \
                                <input style="width: 100%;" class="form-control input-sm" name="send" type="text"> \
                                <br> \
                                <br> \
                                <div class="form-actions"> \
                                    <button class="btn btn-primary" type="submit">삭제</button> \
                                </div> \
                            </form>',
                    menu = [['manager', '관리자']]
                )
            )
    else:
        return(redirect('/error/3'))
                
@route('/edit/<name:path>', method=['POST', 'GET'])
@route('/edit/<name:path>/section/<num:int>', method=['POST', 'GET'])
def edit(name = None, num = None):
    ip = ip_check()
    can = acl_check(ip, name)
    
    if(request.method == 'POST'):
        if(len(request.forms.send) > 500):
            return(redirect('/error/15'))
        else:
            today = get_time()
            content = savemark(request.forms.content)

            if(can == 1):
                return(redirect('/ban'))
            else:
                curs.execute("delete from back where link = ?", [name])
                curs.execute("delete from cat where cat = ?", [name])

                curs.execute("select data from data where title = ?", [name])
                rows = curs.fetchall()
                if(rows):
                    if(request.forms.otent == content):
                        return(redirect('/error/18'))
                    else:
                        leng = leng_check(len(rows[0][0]), len(content))
                        if(num):
                            content = rows[0][0].replace(request.forms.otent, content)
                        curs.execute("update data set data = ? where title = ?", [content, name])
                else:
                    leng = '+' + str(len(content))
                    curs.execute("insert into data (title, data, acl) values (?, ?, '')", [name, content])
                
                history_plus(
                    name, 
                    content, 
                    today, 
                    ip,
                    send_p(request.forms.send), 
                    leng
                )
                        
                include_check(name, content)
                
                conn.commit()
                return(redirect('/w/' + url_pas(name)))
    else:        
        if(can == 1):
            return(redirect('/ban'))
        else:                
            curs.execute("select data from data where title = ?", [name])
            rows = curs.fetchall()
            if(rows):
                if(num):
                    i = 0
                    j = 0
                    
                    data = rows[0][0] + '\r\n'
                    while(1):
                        m = re.search("((?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n(?:(?:(?:(?!(?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n).)*)(?:\n)?)+)", data)
                        if(m):
                            if(i == num - 1):
                                g = m.groups()
                                data = re.sub("\r\n$", "", g[0])
                                
                                break
                            else:
                                data = re.sub("((?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n(?:(?:(?:(?!(?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n).)*)(?:\n)?)+)", "", data, 1)
                                
                                i += 1
                        else:
                            j = 1
                            
                            break
                            
                    if(j == 0):
                        data = re.sub("\r\n$", "", data)
                else:
                    data = rows[0][0]
            else:
                data = ''

            if(num):
                action = '/section/' + str(num)
            else:
                action = ''
            
            return(
                template(
                    'index', 
                    imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), ' (수정)'],
                    data = '<form name="edit_form" method="post" action="/edit/' + name + action + '"> \
                                <textarea style="height: 80%;" name="content">' + data + '</textarea> \
                                <textarea style="display: none; height: 80%;" name="otent">' + data + '</textarea> \
                                <br> \
                                <br> \
                                <input name="send" style="width: 100%;" type="text"> \
                                <br> \
                                <br> \
                                <div class="form-actions"> \
                                    <button class="btn btn-primary" type="submit" onclick="edit_form.action=\'/edit/' + name + action + '\';">저장</button> \
                                    <button class="btn" type="submit" onclick="edit_form.action=\'/preview/' + name + action + '\';">미리보기</button> \
                                </div> \
                            </form>',
                    menu = [['w/' + url_pas(name), '문서']]
                )
            )

@route('/preview/<name:path>/section/<num:int>', method=['POST'])
@route('/preview/<name:path>', method=['POST'])
def preview(name = None, num = None):
    ip = ip_check()
    can = acl_check(ip, name)
    
    if(can == 1):
        return(redirect('/ban'))
    else:            
        newdata = request.forms.content
        newdata = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', ' * [[\g<in>]] 문서로 넘겨주기', newdata)
        enddata = namumark(name, newdata, 0, 0)

        if(num):
            action = '/section/' + str(num)
        else:
            action = ''

        return(
            template(
                'index', 
                imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), ' (미리보기)'],
                data = '<form name="edit_form" method="post" action="/edit/' + name + action + '"> \
                            <textarea style="height: 80%;" name="content">' + request.forms.content + '</textarea> \
                            <textarea style="display: none; height: 80%;" name="otent">' + request.forms.otent + '</textarea> \
                            <br> \
                            <br> \
                            <input name="send" style="width: 100%;" type="text"> \
                            <br> \
                            <br> \
                            <div class="form-actions"> \
                                <button class="btn btn-primary" type="submit" onclick="edit_form.action=\'/edit/' + name + action + '\';">저장</button> \
                                <button class="btn" type="submit" onclick="edit_form.action=\'/preview/' + name + action + '\';">미리보기</button> \
                            </div> \
                        </form> \
                        <br>' + enddata,
                menu = [['w/' + url_pas(name), '문서']]
            )
        )
        
@route('/delete/<name:path>', method=['POST', 'GET'])
def delete(name = None):
    ip = ip_check()
    can = acl_check(ip, name)
    
    if(request.method == 'POST'):
        curs.execute("select data from data where title = ?", [name])
        rows = curs.fetchall()
        if(rows):
            if(can == 1):
                return(redirect('/ban'))

            today = get_time()

            curs.execute("delete from back where link = ?", [name])
            curs.execute("delete from cat where cat = ?", [name])
            
            leng = '-' + str(len(rows[0][0]))
            history_plus(
                name, 
                '', 
                today, 
                ip, 
                request.forms.send + ' (삭제)', 
                leng
            )
            
            curs.execute("delete from data where title = ?", [name])
            conn.commit()
            
        return(redirect('/w/' + url_pas(name)))
    else:
        curs.execute("select title from data where title = ?", [name])
        rows = curs.fetchall()
        if(rows):
            if(can == 1):
                return(redirect('/ban'))
            else:
                l_c = login_check()
                if(l_c == 0):
                    plus = '<span>비 로그인 상태입니다. 비 로그인으로 작업 시 아이피가 역사에 기록됩니다.</span><br><br>'
                else:
                    plus = ''

                return(
                    template(
                        'index', 
                        imp = [name, wiki_set(1), wiki_set(3), l_c, custom_css(), custom_js(), ' (삭제)'],
                        data = '<form method="post"> \
                                    ' + plus + ' \
                                    <input style="width: 100%;" class="form-control input-sm" name="send" type="text"> \
                                    <br> \
                                    <br> \
                                    <button class="btn btn-primary" type="submit">삭제</button> \
                                </form>',
                        menu = [['w/' + url_pas(name), '문서']]
                    )
                )
        else:
            return(redirect('/w/' + url_pas(name)))
            
@route('/move/<name:path>', method=['POST', 'GET'])
def move(name = None):
    ip = ip_check()
    can = acl_check(ip, name)
    today = get_time()

    if(can == 1):
        return(redirect('/ban'))
    
    if(request.method == 'POST'):
        curs.execute("select data from data where title = ?", [name])
        rows = curs.fetchall()

        leng = '0'
        curs.execute("select title from history where title = ?", [request.forms.title])
        row = curs.fetchall()
        if(row):
            return(redirect('/error/19'))

        history_plus(
            name, 
            rows[0][0], 
            today, 
            ip, 
            request.forms.send + ' (<a href="/w/' + url_pas(name) + '">' + name + '</a> - <a href="/w/' + url_pas(request.forms.title) + '">' + request.forms.title + '</a> 이동)', 
            leng
        )
        
        if(rows):
            curs.execute("update data set title = ? where title = ?", [request.forms.title, name])

            curs.execute("delete from back where link = ?", [name])
            curs.execute("delete from cat where cat = ?", [name])

        curs.execute("update history set title = ? where title = ?", [request.forms.title, name])
        conn.commit()
        
        return(redirect('/w/' + url_pas(request.forms.title)))
    else:
        l_c = login_check()
        if(l_c == 0):
            plus = '<span>비 로그인 상태입니다. 비 로그인으로 작업 시 아이피가 역사에 기록됩니다.</span><br><br>'
        else:
            plus = ''
            
        return(
            template(
                'index', 
                imp = [name, wiki_set(1), wiki_set(3), l_c, custom_css(), custom_js(), ' (이동)'],
                data = '<form method="post"> \
                            ' + plus + ' \
                            <input class="form-control input-sm" value="' + name + '" name="title" type="text"> \
                            <br> \
                            <br> \
                            <input style="width: 100%;" class="form-control input-sm" name="send" type="text"> \
                            <br> \
                            <br> \
                            <button class="btn btn-primary" type="submit">이동</button> \
                        </form>',
                menu = [['w/' + url_pas(name), '문서']]
            )
        )
            
@route('/other')
def other():
    return(
        template(
            'index', 
            imp = ['기타 메뉴', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = '<h2 style="margin-top: 0px;">기록</h2> \
                    <li><a href="/blocklog">사용자 차단 기록</a></li> \
                    <li><a href="/userlog">사용자 가입 기록</a></li> \
                    <li><a href="/manager/6">사용자 기록</a></li> \
                    <li><a href="/manager/7">사용자 토론 기록</a></li> \
                    <h2>기타</h2> \
                    <li><a href="/title_index">모든 문서</a></li> \
                    <li><a href="/acl_list">ACL 문서 목록</a></li> \
                    <li><a href="/admin_list">관리자 목록</a></li> \
                    <li><a href="/manager/1">관리자 메뉴</a></li> \
                    <br> \
                    이 오픈나무는 <a href="https://github.com/2DU/openNAMU/blob/SQLite/version.md">' + r_ver + p_ver + '</a>판 입니다.',
            menu = 0
        )
    )
    
@route('/manager', method=['POST', 'GET'])
@route('/manager/<num:int>', method=['POST', 'GET'])
def manager(num = 1):
    if(num == 1):
        return(
            template('index', 
                imp = ['관리자 메뉴', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                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> \
                        <li><a href="/manager/5">관리자 권한 주기</a></li> \
                        <li><a href="/m_del">많은 문서 삭제</a></li> \
                        <li><a href="/list_acl">ACL 목록</a></li> \
                        <li><a href="/not_close_topic">열린 토론 목록</a></li> \
                        <h2>소유자</h2> \
                        <li><a href="/back_reset">역링크, 분류 다시 생성</a></li> \
                        <li><a href="/manager/8">관리 그룹 생성</a></li> \
                        <li><a href="/update">업데이트 메뉴</a></li> \
                        <li><a href="/edit_set">설정 편집</a></li> \
                        <li><a href="/manager/9">문서 JSON 출력</a></li> \
                        <li><a href="/json_in">문서 JSON 입력</a></li> \
                        <h2>기타</h2> \
                        <li>이 메뉴에 없는 기능은 해당 문서의 역사나 토론에서 바로 사용 가능함</li>',
                menu = [['other', '기타']]
            )
        )
    elif(num == 2):
        if(request.method == 'POST'):
            return(redirect('/acl/' + url_pas(request.forms.name)))
        else:
            return(
                template('index', 
                    imp = ['ACL 이동', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<form method="post"> \
                                <input name="name" type="text"> \
                                <br> \
                                <br> \
                                <button class="btn btn-primary" type="submit">이동</button> \
                            </form>',
                    menu = [['manager', '관리자']]
                )
            )
    elif(num == 3):
        if(request.method == 'POST'):
            return(redirect('/check/' + url_pas(request.forms.name)))
        else:
            return(
                template('index', 
                    imp = ['검사 이동', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<form method="post"> \
                                <input name="name" type="text"> \
                                <br> \
                                <br> \
                                <button class="btn btn-primary" type="submit">이동</button> \
                            </form>',
                    menu = [['manager', '관리자']]
                )
            )
    elif(num == 4):
        if(request.method == 'POST'):
            return(redirect('/ban/' + url_pas(request.forms.name)))
        else:
            return(
                template('index', 
                    imp = ['차단 이동', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<form method="post"> \
                                <input name="name" type="text"> \
                                <br> \
                                <br> \
                                <button class="btn btn-primary" type="submit">이동</button> \
                            </form>',
                    menu = [['manager', '관리자']]
                )
            )
    elif(num == 5):
        if(request.method == 'POST'):
            return(redirect('/admin/' + url_pas(request.forms.name)))
        else:
            return(
                template('index', 
                    imp = ['권한 이동', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<form method="post"> \
                                <input name="name" type="text"> \
                                <br> \
                                <br> \
                                <button class="btn btn-primary" type="submit">이동</button> \
                            </form>',
                    menu = [['manager', '관리자']]
                )
            )
    elif(num == 6):
        if(request.method == 'POST'):
            return(redirect('/record/' + url_pas(request.forms.name)))
        else:
            return(
                template('index', 
                    imp = ['기록 이동', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<form method="post"> \
                                <input name="name" type="text"> \
                                <br> \
                                <br> \
                                <button class="btn btn-primary" type="submit">이동</button> \
                            </form>',
                    menu = [['other', '기타']]
                )
            )
    elif(num == 7):
        if(request.method == 'POST'):
            return(redirect('/user/' + url_pas(request.forms.name) + '/topic'))
        else:
            return(
                template('index', 
                    imp = ['토론 기록 이동', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<form method="post"> \
                                <input name="name" type="text"> \
                                <br> \
                                <br> \
                                <button class="btn btn-primary" type="submit">이동</button> \
                            </form>',
                    menu = [['other', '기타']]
                )
            )
    elif(num == 8):
        if(request.method == 'POST'):
            return(redirect('/admin_plus/' + url_pas(request.forms.name)))
        else:
            return(
                template('index', 
                    imp = ['그룹 생성 이동', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<form method="post"> \
                                <input name="name" type="text"> \
                                <br> \
                                <br> \
                                <button class="btn btn-primary" type="submit">이동</button> \
                            </form>',
                    menu = [['manager', '관리자']]
                )
            )
    elif(num == 9):
        if(request.method == 'POST'):
            return(redirect('/json_out/' + url_pas(request.forms.name)))
        else:
            return(
                template('index', 
                    imp = ['문서 출력 이동', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<form method="post"> \
                                <input name="name" type="text"> \
                                <br> \
                                <br> \
                                <button class="btn btn-primary" type="submit">이동</button> \
                            </form>',
                    menu = [['manager', '관리자']]
                )
            )
    else:
        return(redirect('/'))

@route('/json_out/<name:path>')
def json_out(name = None):
    if(admin_check(None) == 1):
        curs.execute('select data from data where title = ?', [name])
        get_d = curs.fetchall()
        if(get_d):
            da = get_d[0][0]
        else:
            da = ''

        curs.execute('select ip from history where title = ? order by ip asc', [name])
        get_h = curs.fetchall()

        var_n = ''
        hi_d = ''
        for hi in get_h:
            if(hi[0] != var_n):
                var_n = hi[0]
                hi_d += json.dumps(hi[0]) + ', '
        else:
            hi_d = re.sub(', $', '', hi_d)  

        if(hi_d == ''):
            return(redirect('/w/' + url_pas(name)))
        
        json_f = '{ "title" : ' + json.dumps(name) + ', "data" : ' + json.dumps(da) + ', "history" : [' + hi_d + '] }'

        return(json_f)
    else:
        return(redirect('/error/3'))

@route('/json_in', method=['POST', 'GET'])
def json_in():
    if(admin_check(None) == 1):
        if(request.method == 'POST'):
            data = json.loads(request.forms.data)
            title = data["title"]

            curs.execute('select title from history where title = ?', [title])
            get_d = curs.fetchall()
            if(get_d):
                return(redirect('/w/' + url_pas(title)))

            curs.execute('insert into data (title, data, acl) values (?, ?, "")', [title, data["data"]])

            i = 0
            date = get_time()
            for hi in data["history"]:
                i += 1
                curs.execute('insert into history (id, title, data, date, ip, send, leng) values (?, ?, "", ?, ?, "", "0")', [i, title, date, hi])

            conn.commit()
            return(redirect('/w/' + url_pas(title)))
        else:
            return(
                template('index', 
                    imp = ['문서 JSON 입력', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                    data = '<form method="post"> \
                                <textarea style="height: 80%;" name="data"></textarea> \
                                <br> \
                                <br> \
                                <button class="btn btn-primary" type="submit">입력</button> \
                            </form>',
                    menu = [['manager', '관리자']]
                )    
            )
    else:
        return(redirect('/error/3'))
        
@route('/title_index')
def title_index():
    i = [0, 0, 0, 0, 0, 0]
    data = ''
    curs.execute("select title from data order by title asc")
    title_list = curs.fetchall()

    for list_data in title_list:
        data += '<li>' + str(i[0] + 1) + '. <a href="/w/' + url_pas(list_data[0]) + '">' + list_data[0] + '</a></li>'

        if(re.search('^분류:', list_data[0])):
            i[1] += 1
        elif(re.search('^사용자:', list_data[0])):
            i[2] += 1
        elif(re.search('^틀:', list_data[0])):
            i[3] += 1
        elif(re.search('^파일:', list_data[0])):
            i[4] += 1
        else:
            i[5] += 1
    
        i[0] += 1

    if(title_list):        
        data += '<br> \
                    <li>이 위키에는 총 ' + str(i[0]) + '개의 문서가 있습니다.</li> \
                    <br> \
                    <li>틀 문서는 총 ' + str(i[3]) + '개의 문서가 있습니다.</li> \
                    <li>분류 문서는 총 ' + str(i[1]) + '개의 문서가 있습니다.</li> \
                    <li>사용자 문서는 총 ' + str(i[2]) + '개의 문서가 있습니다.</li> \
                    <li>파일 문서는 총 ' + str(i[4]) + '개의 문서가 있습니다.</li> \
                    <li>나머지 문서는 총 ' + str(i[5]) + '개의 문서가 있습니다.</li>'
    
    return(
        template('index', 
            imp = ['모든 문서', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = data,
            menu = [['other', '기타']]
        )    
    )
        
@route('/topic/<name:path>/sub/<sub:path>/b/<num:int>')
def topic_block(name = None, sub = None, num = None):
    if(admin_check(3) == 1):
        curs.execute("select block from topic where title = ? and sub = ? and id = ?", [name, sub, str(num)])
        block = curs.fetchall()
        if(block):
            if(block[0][0] == 'O'):
                curs.execute("update topic set block = '' where title = ? and sub = ? and id = ?", [name, sub, str(num)])
            else:
                curs.execute("update topic set block = 'O' where title = ? and sub = ? and id = ?", [name, sub, str(num)])
            conn.commit()
            
            rd_plus(
                name, 
                sub, 
                get_time()
            )
            
        return(redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub)))
    else:
        return(redirect('/error/3'))
        
@route('/topic/<name:path>/sub/<sub:path>/notice/<num:int>')
def topic_top(name = None, sub = None, num = None):
    if(admin_check(3) == 1):
        curs.execute("select * from topic where title = ? and sub = ? and id = ?", [name, sub, str(num)])
        topic_data = curs.fetchall()
        if(topic_data):
            curs.execute("select top from topic where id = ? and title = ? and sub = ?", [str(num), name, sub])
            top_data = curs.fetchall()
            if(top_data):
                if(top_data[0][0] == 'O'):
                    curs.execute("update topic set top = '' where title = ? and sub = ? and id = ?", [name, sub, str(num)])
                else:
                    curs.execute("update topic set top = 'O' where title = ? and sub = ? and id = ?", [name, sub, str(num)])

            conn.commit()
            
            rd_plus(
                name, 
                sub, 
                get_time()
            )

        return(redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub)))
    else:
        return(redirect('/error/3'))

@route('/topic/<name:path>/sub/<sub:path>/tool/agree')
def topic_agree(name = None, sub = None):
    if(admin_check(3) == 1):
        ip = ip_check()
        
        curs.execute("select id from topic where title = ? and sub = ? order by id + 0 desc limit 1", [name, sub])
        topic_check = curs.fetchall()
        if(topic_check):
            time = get_time()
            
            curs.execute("select title from agreedis where title = ? and sub = ?", [name, sub])
            agree = curs.fetchall()
            if(agree):
                curs.execute("insert into topic (id, title, sub, data, date, ip, block, top) values (?, ?, ?, '합의 결렬', ?, ?, '', '1')", [str(int(topic_check[0][0]) + 1), name, sub, time, ip])
                curs.execute("delete from agreedis where title = ? and sub = ?", [name, sub])
            else:
                curs.execute("insert into topic (id, title, sub, data, date, ip, block, top) values (?, ?, ?, '합의 완료', ?, ?, '', '1')", [str(int(topic_check[0][0]) + 1), name, sub, time, ip])
                curs.execute("insert into agreedis (title, sub) values (?, ?)", [name, sub])
            conn.commit()
            
            rd_plus(
                name, 
                sub, 
                time
            )
              
        return(redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub)))
    else:
        
        return(redirect('/error/3'))
        
@route('/topic/<name:path>/sub/<sub:path>/tool/<tool:path>')
def topic_stop(name = None, sub = None, tool = None):
    if(tool == 'close'):
        close = 'O'
        n_close = ''
        data = '토론 닫음'
        n_data = '토론 다시 열기'
    elif(tool == 'stop'):
        close = ''
        n_close = 'O'
        data = '토론 정지'
        n_data = '토론 재 시작'
    else:
        return(redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub)))

    if(admin_check(3) == 1):
        ip = ip_check()
        
        curs.execute("select id from topic where title = ? and sub = ? order by id + 0 desc limit 1", [name, sub])
        topic_check = curs.fetchall()
        if(topic_check):
            time = get_time()
            
            curs.execute("select title from stop where title = ? and sub = ? and close = ?", [name, sub, close])
            stop = curs.fetchall()
            if(stop):
                curs.execute("insert into topic (id, title, sub, data, date, ip, block, top) values (?, ?, ?, ?, ?, ?, '', '1')", [str(int(topic_check[0][0]) + 1), name, sub, n_data, time, ip])
                curs.execute("delete from stop where title = ? and sub = ? and close = ?", [name, sub, close])
            else:
                curs.execute("insert into topic (id, title, sub, data, date, ip, block, top) values (?, ?, ?, ?, ?, ?, '', '1')", [str(int(topic_check[0][0]) + 1), name, sub, data, time, ip])
                curs.execute("insert into stop (title, sub, close) values (?, ?, ?)", [name, sub, close])
                curs.execute("delete from stop where title = ? and sub = ? and close = ?", [name, sub, n_close])
                
            conn.commit()
            
            rd_plus(
                name, 
                sub, 
                time
            )
            
        return(redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub)))
    else:
        
        return(redirect('/error/3'))

@route('/topic/<name:path>/sub/<sub:path>', method=['POST', 'GET'])
def topic(name = None, sub = None):
    ip = ip_check()
    ban = topic_check(ip, name, sub)
    admin = admin_check(3)
    
    if(request.method == 'POST'):
        curs.execute("select id from topic where title = ? and sub = ? order by id + 0 desc limit 1", [name, sub])
        rows = curs.fetchall()
        if(rows):
            num = int(rows[0][0]) + 1
        else:
            num = 1
        
        if(ban == 1 and admin != 1):
            return(redirect('/ban'))
        else:                    
            today = get_time()
            rd_plus(
                name, 
                sub, 
                today
            )
            
            aa = re.sub("\[\[(분류:(?:(?:(?!\]\]).)*))\]\]", "[br]", request.forms.content)
            aa = savemark(aa)
            
            curs.execute("insert into topic (id, title, sub, data, date, ip, block, top) values (?, ?, ?, ?, ?, ?, '', '')", [str(num), name, sub, aa, today, ip])
            conn.commit()
            
            return(redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub)))
    else:
        style = ''
        div = ''

        curs.execute("select title from stop where title = ? and sub = ? and close = 'O'", [name, sub])
        close = curs.fetchall()

        curs.execute("select title from stop where title = ? and sub = ? and close = ''", [name, sub])
        stop = curs.fetchall()
        
        if(admin == 1):
            if(close):
                div += '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/tool/close">(토론 열기)</a> '
            else:
                div += '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/tool/close">(토론 닫기)</a> '
            
            if(stop):
                div += '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/tool/stop">(토론 재개)</a> '
            else:
                div += '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/tool/stop">(토론 정지)</a> '

            curs.execute("select title from agreedis where title = ? and sub = ?", [name, sub])
            agree = curs.fetchall()
            if(agree):
                div += '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/tool/agree">(합의 취소)</a>'
            else:
                div += '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/tool/agree">(합의 완료)</a>'
            
            div += '<br><br>'
        
        if((stop or close) and admin != 1):
            style = 'display:none;'
        
        curs.execute("select data, id, date, ip, block, top from topic where title = ? and sub = ? order by id + 0 asc", [name, sub])
        toda = curs.fetchall()

        curs.execute("select data, id, date, ip from topic where title = ? and sub = ? and top = 'O' order by id + 0 asc", [name, sub])
        top = curs.fetchall()

        for dain in top:                     
            top_data = namumark('', dain[0], 0, 0)
            top_data = re.sub("(?P<in>#(?:[0-9]*))", '<a href="\g<in>">\g<in></a>', top_data)
                    
            ip = ip_pas(dain[3], 1)
                                
            div += '<table id="toron"> \
                        <tbody> \
                            <tr> \
                                <td id="toron_color_red"> \
                                    <a href="#' + dain[1] + '">#' + dain[1] + '</a> ' + ip + ' <span style="float:right;">' + dain[2] + '</span> \
                                </td> \
                            </tr> \
                            <tr> \
                                <td>' + top_data + '</td> \
                            </tr> \
                        </tbody> \
                    </table> \
                    <br>'
                    
        i = 0          
        for dain in toda:
            if(i == 0):
                start = dain[3]
                
            indata = namumark('', dain[0], 0, 0)
            indata = re.sub("(?P<in>#(?:[0-9]*))", '<a href="\g<in>">\g<in></a>', indata)
            
            if(dain[4] == 'O'):
                indata = '<br>'
                block = 'style="display: none;"'
            else:
                block = ''

            if(admin == 1):
                if(dain[4] == 'O'):
                    isblock = ' <a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/b/' + str(i + 1) + '">(해제)</a>'
                else:
                    isblock = ' <a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/b/' + str(i + 1) + '">(가림)</a>'

                curs.execute("select id from topic where title = ? and sub = ? and id = ? and top = 'O'", [name, sub, str(i + 1)])
                row = curs.fetchall()
                if(row):
                    isblock = isblock + ' <a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/notice/' + str(i + 1) + '">(해제)</a>'
                else:
                    isblock = isblock + ' <a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/notice/' + str(i + 1) + '">(공지)</a>'
                    
                curs.execute("select end from ban where block = ?", [dain[3]])
                ban_it = curs.fetchall()
                if(ban_it):
                    ban = ' <a href="/ban/' + url_pas(dain[3]) + '">(해제)</a>' + isblock
                else:
                    ban = ' <a href="/ban/' + url_pas(dain[3]) + '">(차단)</a>' + isblock
            else:
                curs.execute("select end from ban where block = ?", [dain[3]])
                ban_it = curs.fetchall()
                if(ban_it):
                    ban = ' <a href="javascript:void(0);" title="차단자">†</a>'
                else:
                    ban = ''
            
            chad = ''
            curs.execute('select acl from user where id = ?', [dain[3]])
            adch = curs.fetchall()
            if(adch and adch[0][0] != 'user'):
                chad = ' <a href="javascript:void(0);" title="관리자">★</a>'

            ip = ip_pas(dain[3], 1)
                    
            if(dain[5] == '1'):
                color = '_blue'
            elif(dain[3] == start):
                color = '_green'
            else:
                color = ''
                         
            div += '<table id="toron"> \
                        <tbody> \
                            <tr> \
                                <td id="toron_color' + color + '"> \
                                    <a href="javascript:void(0);" id="' + str(i + 1) + '">#' + str(i + 1) + '</a> ' + ip + chad + ban + ' <span style="float:right;">' + dain[2] + '</span> \
                                </td> \
                            </tr> \
                            <tr ' + block + '> \
                                <td>' + indata + '</td> \
                            </tr> \
                        </tbody> \
                    </table> \
                    <br>'
                
            i += 1

        l_c = login_check()

        if(not ban == 1):
            data = '<a id="reload" href="javascript:void(0);" onclick="location.href.endsWith(\'#reload\') ?  location.reload(true) : location.href = \'#reload\'"> \
                        <i aria-hidden="true" class="fa fa-refresh"></i> \
                    </a> \
                    <form style="' + style + '" method="post"> \
                        <br> \
                        <textarea style="width: 100%; height: 100px;" name="content"></textarea> \
                        <br> \
                        <br> \
                        <button class="btn btn-primary" type="submit">전송</button> \
                    </form>'

            if(l_c == 0 and style == ''):
                data += '<span>비 로그인 상태입니다. 비 로그인으로 작업 시 아이피가 토론에 기록됩니다.</span>'
        else:
            data = ''


        return(
            template('index', 
                imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), ' (토론)'],
                data =  '<h2 style="margin-top: 0px;">' + sub + '</h2> \
                        <br> \
                        ' + div + ' \
                        ' + data,
                menu = [['topic/' + url_pas(name), '목록']]
            )    
        )
        
@route('/topic/<name:path>', method=['POST', 'GET'])
@route('/topic/<name:path>/<tool:path>', method=['GET'])
def close_topic_list(name = None, tool = None):
    div = ''
    i = 0
    list_d = 0

    if(request.method == 'POST'):
        t_num = ''
        while(1):
            curs.execute("select title from topic where title = ? and sub = ? limit 1", [name, request.forms.topic + t_num])
            t_data = curs.fetchall()
            if(t_data):
                if(t_num == ''):
                    t_num = ' 2'
                else:
                    t_num = ' ' + str(int(t_num.replace(' ', '')) + 1)
            else:
                break

        return(redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(request.forms.topic + t_num)))
    else:
        plus = ''
        menu = [['topic/' + url_pas(name), '목록']]
        if(tool == 'close'):
            curs.execute("select sub from stop where title = ? and close = 'O' order by sub asc", [name])
            sub = '닫힘'
        elif(tool == 'agree'):
            curs.execute("select sub from agreedis where title = ? order by sub asc", [name])
            sub = '합의'
        else:
            curs.execute("select sub from rd where title = ? order by date desc", [name])
            sub = '토론 목록'
            menu = [['w/' + url_pas(name), '문서']]
            plus =  '<br> \
                    <a href="/topic/' + url_pas(name) + '/close">(닫힘)</a> <a href="/topic/' + url_pas(name) + '/agree">(합의)</a> \
                    <br> \
                    <br> \
                    <input class="form-control" name="topic" style="width: 100%;"> \
                    <br> \
                    <br> \
                    <button class="btn btn-primary" type="submit">만들기</button>'

        rows = curs.fetchall()
        for data in rows:
            curs.execute("select data, date, ip, block from topic where title = ? and sub = ? and id = '1'", [name, data[0]])
            row = curs.fetchall()
            if(row):
                indata = namumark(name, row[0][0], 0, 0)
                
                if(row[0][3] == 'O'):
                    indata = '<br>'
                    block = 'id="block"'
                else:
                    block = ''

                ip = ip_pas(row[0][2], 1)
                
                it_p = 0
                if(sub == '토론 목록'):
                    curs.execute("select title from stop where title = ? and sub = ? and close = 'O' order by sub asc", [name, data[0]])
                    close = curs.fetchall()
                    if(close):
                        it_p = 1
                
                if(not it_p == 1):
                    div += '<h2> \
                                <a href="/topic/' + url_pas(name) + '/sub/' + url_pas(data[0]) + '">' + str((i + 1)) + '. ' + data[0] + '</a> \
                            </h2> \
                            <table id="toron"> \
                                <tbody> \
                                    <tr> \
                                        <td id="toron_color_green"> \
                                            <a href="javascript:void(0);" id="1">#1</a> ' + ip + ' <span style="float:right;">' + row[0][1] + '</span> \
                                        </td> \
                                    </tr> \
                                    <tr> \
                                        <td ' + block + '>' + indata + '</td> \
                                    </tr> \
                                </tbody> \
                            </table> \
                            <br>'
                
                i += 1
        
        return(
            template('index', 
                imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), ' (' + sub + ')'],
                data =  '<form style="margin-top: 0px;" method="post"> \
                            ' + div + plus + ' \
                        </form>',
                menu = menu
            )    
        )
        
@route('/login', method=['POST', 'GET'])
def login():
    session = request.environ.get('beaker.session')
    ip = ip_check()
    ban = ban_check(ip)
        
    if(request.method == 'POST'):        
        if(ban == 1):
            return(redirect('/ban'))

        curs.execute("select pw from user where id = ?", [request.forms.id])
        user = curs.fetchall()
        if(user):
            if(session.get('Now') == 1):
                return(redirect('/error/11'))

            if(bcrypt.checkpw(bytes(request.forms.pw, 'utf-8'), bytes(user[0][0], 'utf-8'))):
                session['Now'] = 1
                session['DREAMER'] = request.forms.id

                curs.execute("select css from custom where user = ?", [request.forms.id])
                css_data = curs.fetchall()
                if(css_data):
                    session['Daydream'] = css_data[0][0]
                else:
                    session['Daydream'] = ''
                
                curs.execute("insert into login (user, ip, today) values (?, ?, ?)", [request.forms.id, ip, get_time()])
                conn.commit()
                
                return(redirect('/user'))
            else:
                return(redirect('/error/10'))
        else:
            return(redirect('/error/5'))
    else:        
        if(ban == 1):
            return(redirect('/ban'))

        if(session.get('Now') == 1):
            return(redirect('/error/11'))

        return(
            template(
                'index',    
                imp = ['로그인', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                data = '<form method="post"> \
                            <span>아이디</span> \
                            <br> \
                            <br> \
                            <input name="id" type="text"> \
                            <br> \
                            <br> \
                            <span>비밀번호</span> \
                            <br> \
                            <br> \
                            <input name="pw" type="password"> \
                            <br> \
                            <br> \
                            <button class="btn btn-primary" type="submit">로그인</button> \
                            <br> \
                            <br> \
                            <span>주의 : 만약 HTTPS 연결이 아닌 경우 데이터가 유출될 가능성이 있습니다. 이에 대해 책임지지 않습니다.</span> \
                        </form>',
                menu = [['user', '사용자']]
            )
        )
                
@route('/change', method=['POST', 'GET'])
def change_password():
    ip = ip_check()
    ban = ban_check(ip)
    
    if(request.method == 'POST'):      
        if(request.forms.pw2 == request.forms.pw3):
            if(ban == 1):
                return(redirect('/ban'))

            curs.execute("select pw from user where id = ?", [request.forms.id])
            user = curs.fetchall()
            if(user):
                if(not re.search('(\.|:)', ip)):
                    return(redirect('/logout'))
                else:
                    if(bcrypt.checkpw(bytes(request.forms.pw, 'utf-8'), bytes(user[0][0], 'utf-8'))):
                        hashed = bcrypt.hashpw(bytes(request.forms.pw2, 'utf-8'), bcrypt.gensalt())
                        
                        curs.execute("update user set pw = ? where id = ?", [hashed.decode(), request.forms.id])
                        conn.commit()
                        
                        return(redirect('/login'))
                    else:
                        return(redirect('/error/10'))
            else:
                return(redirect('/error/5'))
        else:
            return(redirect('/error/20'))
    else:        
        if(ban == 1):
            return(redirect('/ban'))

        if(not re.search('(\.|:)', ip)):
            return(redirect('/logout'))

        return(
            template(
                'index',    
                imp = ['비밀번호 변경', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                data = '<form method="post"> \
                            <span>아이디</span> \
                            <br> \
                            <br> \
                            <input name="id" type="text"> \
                            <br> \
                            <br> \
                            <span>현재 비밀번호</span> \
                            <br> \
                            <br> \
                            <input name="pw" type="password"> \
                            <br> \
                            <br> \
                            <span>변경할 비밀번호</span> \
                            <br> \
                            <br> \
                            <input name="pw2" type="password"> \
                            <br> \
                            <br> \
                            <span>재 확인</span> \
                            <br> \
                            <br> \
                            <input name="pw3" type="password"> \
                            <br> \
                            <br> \
                            <button class="btn btn-primary" type="submit">변경</button> \
                            <br> \
                            <br> \
                            <span>주의 : 만약 HTTPS 연결이 아닌 경우 데이터가 유출될 가능성이 있습니다. 이에 대해 책임지지 않습니다.</span> \
                        </form>',
                menu = [['user', '사용자']]
            )
        )
                
@route('/check/<name:path>')
def user_check(name = None):
    curs.execute("select acl from user where id = ?", [name])
    user = curs.fetchall()
    if(user and user[0][0] != 'user'):
        return(redirect('/error/4'))

    if(admin_check(4) == 1):
        if(re.search('^(?:[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}?)$', name)):
            curs.execute("select user, ip, today from login where ip = ? order by today desc", [name])
        else:
            curs.execute("select user, ip, today from login where user = ? order by today desc", [name])
        row = curs.fetchall()
        if(row):
            c = '<table style="width: 100%; text-align: center;"> \
                    <tbody> \
                        <tr> \
                            <td style="width: 33.3%;">이름</td> \
                            <td style="width: 33.3%;">아이피</td> \
                            <td style="width: 33.3%;">언제</td> \
                        </tr>'

            for data in row:
                c +=    '<tr> \
                            <td>' + ip_pas(data[0], 2) + '</td> \
                            <td>' + ip_pas(data[1], 2) + '</td> \
                            <td>' + data[2] + '</td> \
                        </tr>'
            else:
                c +=        '</tbody> \
                        </table>'
        else:
            c = ''
                
        return(
            template(
                'index',    
                imp = ['다중 검사', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                data = c,
                menu = [['manager', '관리자']]
            )
        )
    else:
        return(redirect('/error/3'))
                
@route('/register', method=['POST', 'GET'])
def register():
    ip = ip_check()
    ban = ban_check(ip)

    if(ban == 1):
        return(redirect('/ban'))
    
    if(request.method == 'POST'):        
        if(request.forms.pw == request.forms.pw2):
            m = re.search('(?:[^A-Za-zㄱ-힣0-9 ])', request.forms.id)
            if(m):
                return(redirect('/error/8'))

            if(len(request.forms.id) > 20):
                return(redirect('/error/7'))

            curs.execute("select id from user where id = ?", [request.forms.id])
            rows = curs.fetchall()
            if(rows):
                return(redirect('/error/6'))

            hashed = bcrypt.hashpw(bytes(request.forms.pw, 'utf-8'), bcrypt.gensalt())
            
            curs.execute("select id from user limit 1")
            user_ex = curs.fetchall()
            if(not user_ex):
                curs.execute("insert into user (id, pw, acl) values (?, ?, 'owner')", [request.forms.id, hashed.decode()])
            else:
                curs.execute("insert into user (id, pw, acl) values (?, ?, 'user')", [request.forms.id, hashed.decode()])
            conn.commit()
            
            return(redirect('/login'))
        else:
            return(redirect('/error/20'))
    else:        
        return(
            template(
                'index',    
                imp = ['회원가입', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                data = '<form method="post"> \
                            <span>아이디</span> \
                            <br> \
                            <br> \
                            <input name="id" type="text"> \
                            <br> \
                            <br> \
                            <span>비밀번호</span> \
                            <br> \
                            <br> \
                            <input name="pw" type="password"> \
                            <br> \
                            <br> \
                            <span>재 확인</span> \
                            <br> \
                            <br> \
                            <input name="pw2" type="password"> \
                            <br> \
                            <br> \
                            <button class="btn btn-primary" type="submit">가입</button> \
                            <br> \
                            <br> \
                            <span>주의 : 만약 HTTPS 연결이 아닌 경우 데이터가 유출될 가능성이 있습니다. 이에 대해 책임지지 않습니다.</span> \
                        </form>',
                menu = [['user', '사용자']]
            )
        )
            
@route('/logout')
def logout():
    session = request.environ.get('beaker.session')
    session['Now'] = 0
    session.pop('DREAMER', None)

    return(redirect('/user'))
    
@route('/ban/<name:path>', method=['POST', 'GET'])
def user_ban(name = None):
    curs.execute("select acl from user where id = ?", [name])
    user = curs.fetchall()
    if(user and user[0][0] != 'user'):
        return(redirect('/error/4'))

    if(request.method == 'POST'):
        if(admin_check(1) == 1):
            ip = ip_check()
            
            if(not re.search("[0-9]{4}-[0-9]{2}-[0-9]{2}", request.forms.end)):
                end = ''
            else:
                end = request.forms.end

            curs.execute("select block from ban where block = ?", [name])
            row = curs.fetchall()
            if(row):
                rb_plus(name, '해제', get_time(), ip, '')
                
                curs.execute("delete from ban where block = ?", [name])
            else:
                b = re.search("^([0-9]{1,3}\.[0-9]{1,3})$", name)
                if(b):
                    band_d = 'O'
                else:
                    band_d = ''

                rb_plus(name, end, get_time(), ip, request.forms.why)

                curs.execute("insert into ban (block, end, why, band) values (?, ?, ?, ?)", [name, end, request.forms.why, band_d])
            conn.commit()

            return(redirect('/ban/' + url_pas(name)))
        else:
            return(redirect('/error/3'))
    else:
        if(admin_check(1) == 1):
            curs.execute("select * from ban where block = ?", [name])
            row = curs.fetchall()
            if(row):
                now = '차단 해제'
                data = ''
            else:
                b = re.search("^([0-9]{1,3}\.[0-9]{1,3})$", name)
                if(b):
                    now = '대역 차단'
                else:
                    now = '차단'
                
                data = '<input class="form-control" name="end" style="width: 100%;"> \
                        <br> \
                        <br> \
                        <span>아무것도 안 적으면 무기한 차단입니다.</span> \
                        <br> \
                        <br> \
                        <span>차단 일 지정시 형식은 YYYY-MM-DD로 기록해야 합니다. (예시: 2017-01-20, 2017-10-15)</span> \
                        <br> \
                        <br> \
                        <span>지금 시각은 ' + get_time() + ' 입니다.</span> \
                        <br> \
                        <br> \
                        <input class="form-control" name="why" style="width: 100%;"> \
                        <br> \
                        <br> \
                        <span>사유를 쓰는 곳입니다.</span> \
                        <br> \
                        <br>'

            return(
                template('index', 
                    imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), ' (' + now + ')'],
                    data = '<form method="post"> \
                                ' + data + ' \
                                <button class="btn btn-primary" type="submit">' + now + '</button> \
                            </form>',
                    menu = [['manager', '관리자']]
                )
            )
        else:
            return(redirect('/error/3'))
                
@route('/acl/<name:path>', method=['POST', 'GET'])
def acl(name = None):
    if(request.method == 'POST'):
        if(admin_check(5) == 1):
            curs.execute("select acl from data where title = ?", [name])
            row = curs.fetchall()
            if(row):
                if(request.forms.select == 'admin'):
                   curs.execute("update data set acl = 'admin' where title = ?", [name])
                elif(request.forms.select == 'user'):
                    curs.execute("update data set acl = 'user' where title = ?", [name])
                else:
                    curs.execute("update data set acl = '' where title = ?", [name])
                    
                conn.commit()
                
            return(redirect('/w/' + url_pas(name)))
        else:
            return(redirect('/error/3'))
    else:
        if(admin_check(5) == 1):
            curs.execute("select acl from data where title = ?", [name])
            row = curs.fetchall()
            if(row):
                if(row[0][0] == 'admin'):
                    now = '관리자만'
                elif(row[0][0] == 'user'):
                    now = '로그인 이상'
                else:
                    now = '일반'
                
                return(
                    template('index', 
                        imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), ' (ACL)'],
                        data = '<br> \
                                <span>현재 ACL : ' + now + '</span> \
                                <br> \
                                <br> \
                                <form method="post"> \
                                    <select name="select"> \
                                        <option value="admin" selected="selected">관리자만</option> \
                                        <option value="user">유저 이상</option> \
                                        <option value="normal">일반</option> \
                                    </select> \
                                    <br> \
                                    <br> \
                                    <button class="btn btn-primary" type="submit">ACL 변경</button> \
                                </form>',
                        menu = [['w/' + url_pas(name), '문서'], ['manager', '관리자']]
                    )
                )
            else:
                return(redirect('/w/' + url_pas(name)) )
        else:
            return(redirect('/error/3'))
            
@route('/admin/<name:path>', method=['POST', 'GET'])
def user_admin(name = None):
    if(request.method == 'POST'):
        if(admin_check(None) == 1):
            curs.execute("select acl from user where id = ?", [name])
            user = curs.fetchall()
            if(user):
                if(user[0][0] != 'user'):
                    curs.execute("update user set acl = 'user' where id = ?", [name])
                else:
                    curs.execute("update user set acl = ? where id = ?", [request.forms.select, name])
                conn.commit()
                
                return(redirect('/admin/' + url_pas(name)))
            else:
                return(redirect('/error/5'))
        else:
            return(redirect('/error/3'))
    else:
        if(admin_check(None) == 1):
            curs.execute("select acl from user where id = ?", [name])
            user = curs.fetchall()
            if(user):
                if(user[0][0] != 'user'):
                    now = '권한 해제'
                else:
                    now = '권한 부여'
                    
                div = ''
                    
                curs.execute('select name from alist order by name asc')
                get_alist = curs.fetchall()
                if(get_alist):
                    i = 0
                    name_rem = ''
                    for data in get_alist:
                        if(name_rem != data[0]):
                            name_rem = data[0]
                            div += '<option value="' + data[0] + '" selected="selected">' + data[0] + '</option>'

                if(now == '권한 부여'):
                    plus = '<select name="select"> \
                                ' + div + ' \
                            </select> \
                            <br> \
                            <br>'
                else:
                    plus = ''
                
                return(
                    template(
                        'index', 
                        imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), ' (권한 부여)'],
                        data =  '<form method="post"> \
                                    ' + plus + ' \
                                    <button class="btn btn-primary" type="submit">' + now + '</button> \
                                </form>',
                        menu = [['manager', '관리자']]
                    )
                )
            else:
                return(redirect('/error/5'))
        else:
            return(redirect('/error/3'))
            
@route('/ban')
def are_you_ban():
    ip = ip_check()
    
    if(ban_check(ip) == 1):
        curs.execute("select end, why from ban where block = ?", [ip])
        rows = curs.fetchall()
        if(not rows):
            data = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))", ip)
            if(data):
                results = data.groups()
                curs.execute("select end, why from ban where block = ? and band = 'O'", [results[0]])

                rows = curs.fetchall()

        if(rows):
            if(rows[0][0]):
                end = rows[0][0] + ' 까지 차단 상태 입니다. / 사유 : ' + rows[0][1]                

                now = re.sub(':', '', get_time())
                now = re.sub('\-', '', now)
                now = int(re.sub(' ', '', now))
                
                day = re.sub('\-', '', rows[0][0])    
                
                if(now >= int(day + '000000')):
                    curs.execute("delete from ban where block = ?", [ip])
                    conn.commit()
                    
                    end = '차단이 풀렸습니다. 다시 시도 해 보세요.'
            else:
                end = '영구 차단 상태 입니다. / 사유 : ' + rows[0][1]
        else:
            end = '권한이 맞지 않는 상태 입니다.'
    else:
        end = '권한이 맞지 않는 상태 입니다.'

    return(
        template(
            'index', 
            imp = ['권한 오류', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = '<br>' + end,
            menu = 0
        )
    )
    
@route('/w/<name:path>/r/<a:int>/diff/<b:int>')
def diff_data(name = None, a = None, b = None):
    curs.execute("select data from history where id = ? and title = ?", [str(a), name])
    a_raw_data = curs.fetchall()
    if(a_raw_data):
        curs.execute("select data from history where id = ? and title = ?", [str(b), name])
        b_raw_data = curs.fetchall()
        if(b_raw_data):
            a_data = html.escape(a_raw_data[0][0])            
            b_data = html.escape(b_raw_data[0][0])
            
            diff_data = difflib.SequenceMatcher(None, a_data, b_data)
            result = diff(diff_data)
            
            result = '<pre>' + result + '</pre>'
            
            return(
                template(
                    'index', 
                    imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), ' (비교)'],
                    data = result,
                    menu = [['history/' + url_pas(name), '역사']]
                )
            )

    return(redirect('/history/' + url_pas(name)))
        
@route('/down/<name:path>')
def down(name = None):
    curs.execute("select title from data where title like ?", ['%' + name + '/%'])
    under = curs.fetchall()
    
    div = ''
    i = 0

    for data in under:
        div += '<li>' + str(i + 1) + '. <a href="/w/' + url_pas(data[0]) + '">' + data[0] + '</a></li>'
        i += 1
    
    return(
        template(
            'index', 
            imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), ' (하위)'],
            data = div,
            menu = [['w/' + url_pas(name), '문서']]
        )
    )

@route('/w/<name:path>')
@route('/w/<name:path>/r/<num:int>')
@route('/w/<name:path>/from/<redirect:path>')
def read_view(name = None, num = None, redirect = None):
    data_none = 0
    sub = ''
    acl = ''
    div = ''
    topic = 0
    
    curs.execute("select sub from rd where title = ? order by date desc", [name])
    rows = curs.fetchall()
    for data in rows:
        curs.execute("select title from stop where title = ? and sub = ? and close = 'O'", [name, data[0]])
        row = curs.fetchall()
        if(not row):
            topic = 1
            
            break
                
    curs.execute("select title from data where title like ?", ['%' + name + '/%'])
    under = curs.fetchall()
    if(under):
        down = 1
    else:
        down = 0
        
    m = re.search("^(.*)\/(.*)$", name)
    if(m):
        uppage = m.groups()[0]
    else:
        uppage = 0
        
    if(admin_check(5) == 1):
        admin_memu = 1
    else:
        admin_memu = 0
        
    if(re.search("^분류:", name)):
        curs.execute("delete from cat where title = ? and cat = ''", [name])
        conn.commit()
        
        curs.execute("select cat from cat where title = ? order by cat asc", [name])
        rows = curs.fetchall()
        if(rows):
            div = '<h2>분류</h2>'
            u_div = ''
            i = 0
            
            for data in rows:       
                if(re.search('^분류:', data[0])):
                    if(u_div == ''):
                        u_div = '<h3>하위 분류</h3>'

                    u_div += '<li><a href="/w/' + url_pas(data[0]) + '">' + data[0] + '</a></li>'
                else:
                    div += '<li><a href="/w/' + url_pas(data[0]) + '">' + data[0] + '</a></li>'

            div += u_div

    if(num):
        curs.execute("select title from hidhi where title = ? and re = ?", [name, str(num)])
        hid = curs.fetchall()
        if(hid and admin_check(6) != 1):
            return(redirect('/history/' + url_pas(name)))

        curs.execute("select title, data from history where title = ? and id = ?", [name, str(num)])
    else:
        curs.execute("select acl, data from data where title = ?", [name])

    rows = curs.fetchall()
    if(rows):
        if(not num):
            if(rows[0][0] == 'admin'):
                acl = ' (관리자)'
            elif(rows[0][0] == 'user'):
                acl = ' (로그인)'
                
        elsedata = rows[0][1]
    else:
        data_none = 1
        response.status = 404
        elsedata = ''

    m = re.search("^사용자:([^/]*)", name)
    if(m):
        g = m.groups()
        
        curs.execute("select acl from user where id = ?", [g[0]])
        test = curs.fetchall()
        if(test and test[0][0] != 'user'):
            acl = ' (관리자)'

        curs.execute("select block from ban where block = ?", [g[0]])
        user = curs.fetchall()
        if(user):
            sub = ' (차단)'
            
    if(redirect):
        elsedata = re.sub("^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)", " * [[\g<in>]] 문서로 넘겨주기", elsedata)
            
    enddata = namumark(name, elsedata, 1, 0)

    if(data_none == 1):
        menu = [['edit/' + url_pas(name), '생성'], ['topic/' + url_pas(name), topic], ['move/' + url_pas(name), '이동'], ['history/' + url_pas(name), '역사'], ['xref/' + url_pas(name), '역링크']]
    else:
        menu = [['edit/' + url_pas(name), '수정'], ['topic/' + url_pas(name), topic], ['delete/' + url_pas(name), '삭제'], ['raw/' + url_pas(name), '원본'], ['move/' + url_pas(name), '이동'], ['history/' + url_pas(name), '역사'], ['xref/' + url_pas(name), '역링크']]
        if(admin_memu == 1):
            menu[0] += ['acl/' + url_pas(name), 'ACL']

    if(redirect):
        enddata =   '<li style="margin-top: -20px;"><a href="/w/' + url_pas(redirect) + '/from/' + url_pas(name) + '">' + redirect + '</a>에서 넘어 왔습니다.</li> \
                    <br>' + enddata
        menu[0] += ['w/' + url_pas(name), '넘기기']

    if(not uppage == 0):
        menu[0] += ['w/' + url_pas(uppage), '상위']

    if(down):
        menu[0] += ['down/' + url_pas(name), '하위']


    return(
        template('index', 
            imp = [name, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), sub + acl],
            data = '<br>' + enddata + div,
            menu = menu
        )
    )

@route('/user/<name:path>/topic')
@route('/user/<name:path>/topic/<num:int>')
def user_topic_list(name = None, num = 1):
    if(num * 50 <= 0):
        v = 50
    else:
        v = num * 50
    
    i = v - 50
    ydmin = admin_check(1)
    div =   '<table style="width: 100%; text-align: center;"> \
                <tbody> \
                    <tr> \
                        <td style="width: 33.3%;">토론명</td> \
                        <td style="width: 33.3%;">작성자</td> \
                        <td style="width: 33.3%;">시간</td> \
                    </tr>'
    
    curs.execute("select title, id, sub, ip, date from topic where ip = ? order by date desc limit ?, ?", [name, str(i), str(v)])
    rows = curs.fetchall()
    if(rows):
        for data in rows:
            title = html.escape(data[0])
            sub = html.escape(data[2])
                
            if(ydmin == 1):
                curs.execute("select * from ban where block = ?", [data[3]])
                row = curs.fetchall()
                if(row):
                    ban = ' <a href="/ban/' + url_pas(data[3]) + '">(해제)</a>'
                else:
                    ban = ' <a href="/ban/' + url_pas(data[3]) + '">(차단)</a>'
            else:
                ban = ''
                
            ip = ip_pas(data[3], 1)
                
            div += '<tr> \
                        <td> \
                            <a href="/topic/' + url_pas(data[0]) + '/sub/' + url_pas(data[2]) + '#' + data[1] + '">' + title + '#' + data[1] + '</a> (' + sub + ') \
                        </td> \
                        <td>' + ip + ban +  '</td> \
                        <td>' + data[4] + '</td> \
                    </tr>'
        else:
            div +=      '</tbody> \
                    </table>'
    else:
        div = ''
        
    div += '<br> \
            <a href="/user/' + url_pas(name) + '/topic/' + str(num - 1) + '">(이전)</a> <a href="/user/' + url_pas(name) + '/topic/' + str(num + 1) + '">(이후)</a>'
                
    curs.execute("select end, why from ban where block = ?", [name])
    ban_it = curs.fetchall()
    if(ban_it):
        sub = ' (차단)'
    else:
        sub = 0 
    
    return(
        template('index', 
            imp = ['토론 기록', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), sub],
            data = div,
            menu = [['other', '기타'], ['user', '사용자']]
        )
    )
        
@route('/user')
def user_info():
    ip = ip_check()
    raw_ip = ip
    
    curs.execute("select acl from user where id = ?", [ip])
    rows = curs.fetchall()
    if(ban_check(ip) == 0):
        if(rows):
            if(rows[0][0] != 'user'):
                acl = rows[0][0]
            else:
                acl = '로그인'
        else:
            acl = '일반'
    else:
        acl = '차단'
        
    ip = ip_pas(ip, 2)

    if(login_check() == 1):
        plus = '<li><a href="/logout">로그아웃</a></li>'
    else:
        plus = '<li><a href="/login">로그인</a></li>'

    return(
        template(
            'index', 
            imp = ['사용자 메뉴', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = '<br> \
                    ' + ip + ' \
                    <br> \
                    <br> \
                    <span>권한 상태 : ' + acl + '</span> \
                    <h2>로그인 관련</h2> \
                    ' + plus + ' \
                    <li><a href="/register">회원가입</a></li> \
                    <h2>기타</h2> \
                    <li><a href="/change">비밀번호 변경</a></li> \
                    <li><a href="/count">기여 횟수</a></li> \
                    <li><a href="/custom_css">커스텀 CSS</a></li> \
                    <li><a href="/custom_js">커스텀 JS</a></li>',
            menu = 0
        )
    )

@route('/custom_css', method=['GET', 'POST'])
def custom_css_view():
    session = request.environ.get('beaker.session')
    ip = ip_check()
    if(request.method == 'POST'):
        if(not re.search('(\.|:)', ip)):
            curs.execute("select * from custom where user = ?", [ip])
            css_data = curs.fetchall()
            if(css_data):
                curs.execute("update custom set css = ? where user = ?", [request.forms.content, ip])
            else:
                curs.execute("insert into custom (user, css) values (?, ?)", [ip, request.forms.content])
            conn.commit()

        session['Daydream'] = request.forms.content

        return(redirect('/user'))
    else:
        if(not re.search('(\.|:)', ip)):
            start = ''
            curs.execute("select css from custom where user = ?", [ip])
            css_data = curs.fetchall()
            if(css_data):
                data = css_data[0][0]
            else:
                data = ''
        else:
            start = '<span>비 로그인의 경우에는 로그인하면 날아갑니다.</span><br><br>'
            try:
                data = session['Daydream']
            except:
                data = ''

        return(
            template(
                'index', 
                imp = ['커스텀 CSS', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                data =  '<br> \
                        ' + start + ' \
                        <form method="post"> \
                            <textarea rows="30" cols="100" name="content">'\
                                 + data + \
                            '</textarea> \
                            <br> \
                            <br> \
                            <div class="form-actions"> \
                                <button class="btn btn-primary" type="submit">저장</button> \
                            </div> \
                        </form>',
                menu = [['user', '사용자']]
            )
        )

@route('/custom_js', method=['GET', 'POST'])
def custom_js_view():
    session = request.environ.get('beaker.session')
    ip = ip_check()
    if(request.method == 'POST'):
        if(not re.search('(\.|:)', ip)):
            curs.execute("select * from custom where user = ?", [ip + ' (js)'])
            js_data = curs.fetchall()
            if(js_data):
                curs.execute("update custom set css = ? where user = ?", [request.forms.content, ip + ' (js)'])
            else:
                curs.execute("insert into custom (user, css) values (?, ?)", [ip + ' (js)', request.forms.content])
            conn.commit()
        session['AQUARIUM'] = request.forms.content

        return(redirect('/user'))
    else:
        if(not re.search('(\.|:)', ip)):
            start = ''
            curs.execute("select css from custom where user = ?", [ip + ' (js)'])
            js_data = curs.fetchall()
            if(js_data):
                data = js_data[0][0]
            else:
                data = ''
        else:
            start = '<span>비 로그인의 경우에는 로그인하면 날아갑니다.</span><br><br>'
            try:
                data = session['AQUARIUM']
            except:
                data = ''

        return(
            template(
                'index', 
                imp = ['커스텀 JS', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                data =  '<br> \
                        ' + start + ' \
                        <form method="post"> \
                            <textarea rows="30" cols="100" name="content">'\
                                 + data + \
                            '</textarea> \
                            <br> \
                            <br> \
                            <div class="form-actions"> \
                                <button class="btn btn-primary" type="submit">저장</button> \
                            </div> \
                        </form>',
                menu = [['user', '사용자']]
            )
        )

@route('/count')
@route('/count/<name:path>')
def count_edit(name = None):
    if(name == None):
        that = ip_check()
    else:
        that = name

    curs.execute("select count(title) from history where ip = ?", [that])
    count = curs.fetchall()
    if(count):
        data = count[0][0]
    else:
        data = 0

    curs.execute("select count(title) from topic where ip = ?", [that])
    count = curs.fetchall()
    if(count):
        t_data = count[0][0]
    else:
        t_data = 0

    return(
        template(
            'index', 
            imp = ['기여 횟수', wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
            data = namumark("", "||<-2><:> " + that + " ||\r\n||<:> 기여 횟수 ||<:> " + str(data) + "||\r\n||<:> 토론 횟수 ||<:> " + str(t_data) + "||", 0, 1),
            menu = [['user', '사용자']]
        )
    )
        
@route('/random')
def random():
    curs.execute("select title from data order by random() limit 1")
    rows = curs.fetchall()
    if(rows):
        return(redirect('/w/' + url_pas(rows[0][0])))
    else:
        return(redirect('/'))
    
@route('/views/<name:path>')
def views(name = None):
    if(re.search('\/', name)):
        m = re.search('^(.*)\/(.*)$', name)
        if(m):
            n = m.groups()
            plus = '/' + n[0]
            rename = n[1]
        else:
            plus = ''
            rename = name
    else:
        plus = ''
        rename = name
        
    return(
        static_file(rename, 
            root = './views' + plus
        )
    )
        
@route('/error/<num:int>')
def error_test(num = None):
    response.status = 404
    if(num == 1):
        title = '권한 오류'
        data = '비 로그인 상태 입니다.'
    elif(num == 2):
        title = '권한 오류'
        data = '이 계정이 없습니다.'
    elif(num == 3):
        title = '권한 오류'
        data = '권한이 모자랍니다.'
    elif(num == 4):
        title = '권한 오류'
        data = '관리자는 차단, 검사 할 수 없습니다.'
    elif(num == 5):
        title = '사용자 오류'
        data = '그런 계정이 없습니다.'
    elif(num == 6):
        title = '가입 오류'
        data = '동일한 아이디의 사용자가 있습니다.'
    elif(num == 7):
        title = '가입 오류'
        data = '아이디는 20글자보다 짧아야 합니다.'
    elif(num == 8):
        title = '가입 오류'
        data = '아이디에는 한글과 알파벳과 공백만 허용 됩니다.'
    elif(num == 10):
        title = '변경 오류'
        data = '비밀번호가 다릅니다.'
    elif(num == 11):
        title = '로그인 오류'
        data = '이미 로그인 되어 있습니다.'
    elif(num == 14):
        title = '파일 올리기 오류'
        data = 'jpg, gif, jpeg, png만 가능 합니다.'
    elif(num == 15):
        title = '편집 오류'
        data = '편집 기록은 500자를 넘을 수 없습니다.'
    elif(num == 16):
        title = '파일 올리기 오류'
        data = '동일한 이름의 파일이 있습니다.'
    elif(num == 17):
        title = '파일 올리기 오류'
        data = '파일 용량은 ' + wiki_set(4) + 'MB를 넘길 수 없습니다.'
    elif(num == 18):
        title = '편집 오류'
        data = '내용이 원래 문서와 동일 합니다.'
    elif(num == 19):
        title = '이동 오류'
        data = '이동 하려는 곳에 문서가 이미 있습니다.'
    elif(num == 20):
        title = '비밀번호 오류'
        data = '재 확인이랑 비밀번호가 다릅니다.'

    if(title):
        return(
            template(
                'index', 
                imp = [title, wiki_set(1), wiki_set(3), login_check(), custom_css(), custom_js(), 0],
                data = '<br>' + data,
                menu = 0
            )
        )
    else:
        return(redirect('/'))

@error(404)
def error_404(error):
    return(redirect('/w/' + url_pas(wiki_set(2))))
    
run(
    app = app, 
    server = 'tornado', 
    host = '0.0.0.0', 
    port = int(set_data['port'])
)