openNAMU__openNAMU/app.py

from bottle import route, run, template, error, request, static_file, app
from bottle.ext import beaker
import bcrypt
import os
import difflib
import hashlib
import json
import pymysql

json_data = open('set.json').read()
set_data = json.loads(json_data)

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

app = beaker.middleware.SessionMiddleware(app(), session_opts)
    
def start():
    try:
        db_ex("create table data(title text, data longtext, acl text)")
    except:
        pass
    
    try:
        db_ex("create table history(id text, title text, data longtext, date text, ip text, send text, leng text)")
    except:
        pass
    
    try:
        db_ex("create table rd(title text, sub text, date text)")
    except:
        pass
    
    try:
        db_ex("create table user(id text, pw text, acl text)")
    except:
        pass
    
    try:
        db_ex("create table ban(block text, end text, why text, band text)")
    except:
        pass
    
    try:
        db_ex("create table topic(id text, title text, sub text, data longtext, date text, ip text, block text, top text)")
    except:
        pass
    
    try:
        db_ex("create table stop(title text, sub text, close text)")
    except:
        pass
    
    try:
        db_ex("create table rb(block text, end text, today text, blocker text, why text)")
    except:
        pass
    
    try:
        db_ex("create table login(user text, ip text, today text)")
    except:
        pass
    
    try:
        db_ex("create table back(title text, link text, type text)")
    except:
        pass
    
    try:
        db_ex("create table cat(title text, cat text)")
    except:
        pass
        
    try:
        db_ex("create table hidhi(title text, re text)")
    except:
        pass

    try:
        db_ex("create table agreedis(title text, sub text)")
    except:
        pass

    try:
        db_ex("create table custom(user text, css longtext)")
    except:
        pass
        
    try:
        db_ex("create table other(name text, data text)")
    except:
        pass
        
    try:
        db_ex("create table alist(name text, acl text)")
    except:
        pass
        
conn = pymysql.connect(host = set_data['host'], user = set_data['user'], password = set_data['pw'], charset = 'utf8mb4')
curs = conn.cursor(pymysql.cursors.DictCursor)

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

db_ex = curs.execute
db_pas = pymysql.escape_string

try:
    db_ex("use " + set_data['db'])
except:
    db_ex("create database " + set_data['db'])
    db_ex("use " + set_data['db'])
    db_ex("alter database " + set_data['db'] + " character set = utf8mb4 collate = utf8mb4_unicode_ci")

from func import *
from mark import *

def db_com():
    return conn.commit()
    
def db_get():
    return curs.fetchall()

start()

r_ver = '2.0.4'

db_ex('select data from other where name = "version"')
version = db_get()
if(version):
    t_ver = re.sub('\.', '', version[0]['data'])
    t_ver = re.sub('[a-z]$', '', t_ver)
    r_t_ver = re.sub('\.', '', r_ver)
    r_t_ver = re.sub('[a-z]$', '', r_t_ver)
    if(int(t_ver) <= int(r_t_ver)):
        db_ex("update other set data = '" + db_pas(r_ver) + "' where name = 'version'")
else:
    db_ex("insert into other (name, data) value ('version', '" + db_pas(r_ver) + "')")
    t_ver = 0
    
db_ex('select name from alist limit 1')
getalist = db_get()
if(getalist and int(t_ver) < 204):
    db_ex("delete from alist where name = 'owner'")
    db_ex("delete from alist where name = 'admin'")

if(int(t_ver) < 202 or not getalist):
    db_ex("insert into alist (name, acl) value ('owner', 'owner')")
    db_ex("insert into alist (name, acl) value ('admin', 'ban')")
    db_ex("insert into alist (name, acl) value ('admin', 'mdel')")
    db_ex("insert into alist (name, acl) value ('admin', 'toron')")
    db_ex("insert into alist (name, acl) value ('admin', 'check')")
    db_ex("insert into alist (name, acl) value ('admin', 'acl')")
    
if(int(t_ver) < 203):
    db_ex('select title from topic limit 1')
    gettop = db_get()
    if(gettop):
        db_ex('rename table topic to old_topic')
        db_ex('create table topic(id text, title text, sub text, data longtext, date text, ip text, block text, top text)')
        
        db_ex('select * from old_topic')
        topic_old = db_get()
        if(topic_old):
            i = 0
            while(True):
                try:
                    db_ex("select id from distop where id = '" + db_pas(topic_old[i]['id']) + "' and title = '" + db_pas(topic_old[i]['title']) + "' and sub = '" + db_pas(topic_old[i]['sub']) + "'")
                    distop = db_get()
                    if(distop):
                        top = 'O'
                    else:
                        top = ''
                        
                    db_ex("insert into topic (id, title, sub, data, date, ip, block, top) value ('" + db_pas(topic_old[i]['id']) + "', '" + db_pas(topic_old[i]['title']) + "', '" + db_pas(topic_old[i]['sub']) + "', '" + db_pas(topic_old[i]['data']) + "', '" + db_pas(topic_old[i]['date']) + "', '" + db_pas(topic_old[i]['ip']) + "', '" + db_pas(topic_old[i]['block']) + "', '" + db_pas(top) + "')")
                    
                    i += 1
                except:
                    break
        
        db_ex('drop table old_topic')
        db_ex('drop table distop')
    
db_com()

@route('/upload', method=['GET', 'POST'])
def upload():
    session = request.environ.get('beaker.session')
    MEMFILE_MAX = int(set_data['upload']) * 1024 * 1024
    
    ip = ip_check(session)
    ban = ban_check(ip)
    
    if(request.method == 'POST'):        
        if(ban == 1):
            return redirect('/ban')
        else:
            file = request.files.file
            if(file):
                exist = re.search('^(.+)(\.(?:[Jj][Pp][Gg]|[Gg][Ii][Ff]|[Jj][Pp][Ee][Gg]|[Pp][Nn][Gg]))$', file.filename)
                if(exist):
                    if((int(set_data['upload']) * 1024 * 1024) < request.content_length):
                        return redirect('/error/17')
                    else:
                        file_info = exist.groups()

                        file_data = file_info[0] + file_info[1]
                        file_name = sha224(file_info[0]) + file_info[1]
                                           
                        if(os.path.exists(os.path.join('image', file_name))):
                            return redirect('/error/16')
                        else:
                            file.save(os.path.join('image', file_name))
                            
                            db_ex("select title from data where title = '" + db_pas('파일:' + file_data) + "'")
                            exist_db = db_get()
                            if(not exist_db):
                                db_ex("insert into data (title, data, acl) value ('" + db_pas('파일:' + file_data) + "', '" + db_pas('[[파일:' + file_data + ']][br][br]{{{[[파일:' + file_data + ']]}}}') + "', '')")
                                db_com()
                            
                            history_plus('파일:' + file_data, '[[파일:' + file_data + ']][br][br]{{{[[파일:' + file_data + ']]}}}', get_time(), ip, '파일:' + file_data + ' 업로드', '0')
                            
                            return redirect('/w/' + url_pas('파일:' + file_data))
                else:
                    return redirect('/error/14')
            else:
                return redirect('/error/14')
    else:        
        if(ban == 1):
            return redirect('/ban')
        else:
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], title = '업로드', tn = 21, number = set_data['upload'])

@route('/image/<name:path>')
def static(name = None):
    session = request.environ.get('beaker.session')
    if(os.path.exists(os.path.join('image', name))):
        return static_file(name, root = 'image')
    else:
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], data = '이미지 없음.', title = '이미지 보기')

@route('/acllist')
def acl_list():
    session = request.environ.get('beaker.session')
    data = '<div>'
    i = 0

    db_ex("select title, acl from data where acl = 'admin' or acl = 'user' order by acl desc")
    list_data = db_get()
    if(list_data):
        while(True):
            try:            
                if(list_data[i]['acl'] == 'admin'):
                    acl = '관리자'
                else:
                    acl = '로그인'

                data += '<li>' + str(i + 1) + '. <a href="/w/' + url_pas(list_data[i]['title']) + '">' + list_data[i]['title'] + '</a> (' + acl + ')</li>'

                i += 1
            except:
                break
                
        data += '</div>'
    else:
        data = ''

    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], data = data, title = 'ACL 문서 목록')
    
@route('/listacl')
def list_acl():
    session = request.environ.get('beaker.session')
    data = '<div>'
    i = 0

    db_ex("select * from alist order by name desc")
    list_data = db_get()
    if(list_data):
        while(True):
            try:
                if(list_data[i]['acl'] == 'ban'):
                    acl = '차단'
                elif(list_data[i]['acl'] == 'mdel'):
                    acl = '많은 문서 삭제'
                elif(list_data[i]['acl'] == 'toron'):
                    acl = '토론 관리'
                elif(list_data[i]['acl'] == 'check'):
                    acl = '사용자 검사'
                elif(list_data[i]['acl'] == 'acl'):
                    acl = '문서 ACL'
                elif(list_data[i]['acl'] == 'hidel'):
                    acl = '역사 숨김'
                elif(list_data[i]['acl'] == 'owner'):
                    acl = '소유자'
                    
                data += '<li>' + str(i + 1) + '. <a href="/adminplus/' + url_pas(list_data[i]['name']) + '">' + list_data[i]['name'] + '</a> (' + acl + ')</li>'

                i += 1
            except:
                break
                
        data += '<br><a href="/manager/8">(새로 생성)</a></div>'
    else:
        data = ''

    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], data = data, title = 'ACL 목록')

@route('/adminplus/<name:path>', method=['POST', 'GET'])
def admin_plus(name = None):
    session = request.environ.get('beaker.session')
    if(admin_check(None, session) == 1):
        if(request.method == 'POST'):
            db_ex("delete from alist where name = '" + db_pas(name) + "'")
            
            if(request.forms.ban):
                db_ex("insert into alist (name, acl) value ('" + db_pas(name) + "', 'ban')")
            if(request.forms.mdel):
                db_ex("insert into alist (name, acl) value ('" + db_pas(name) + "', 'mdel')")    
            if(request.forms.toron):
                db_ex("insert into alist (name, acl) value ('" + db_pas(name) + "', 'toron')")
            if(request.forms.check):
                db_ex("insert into alist (name, acl) value ('" + db_pas(name) + "', 'check')")
            if(request.forms.acl):
                db_ex("insert into alist (name, acl) value ('" + db_pas(name) + "', 'acl')")
            if(request.forms.hidel):
                db_ex("insert into alist (name, acl) value ('" + db_pas(name) + "', 'hidel')")
            if(request.forms.owner):
                db_ex("insert into alist (name, acl) value ('" + db_pas(name) + "', 'owner')")
                
            db_com()
            return redirect('/')
        else:
            db_ex('select acl from alist where name = "' + db_pas(name) + '"')
            test = db_get()
            
            list = ''
            exist_list = ['', '', '', '', '', '', '', '', '']

            i = 0
            while(True):
                try:
                    if(test[i]['acl'] == 'ban'):
                        exist_list[0] = 'checked="checked"'
                    elif(test[i]['acl'] == 'mdel'):
                        exist_list[1] = 'checked="checked"'
                    elif(test[i]['acl'] == 'toron'):
                        exist_list[2] = 'checked="checked"'
                    elif(test[i]['acl'] == 'check'):
                        exist_list[3] = 'checked="checked"'
                    elif(test[i]['acl'] == 'acl'):
                        exist_list[4] = 'checked="checked"'
                    elif(test[i]['acl'] == 'hidel'):
                        exist_list[5] = 'checked="checked"'
                    elif(test[i]['acl'] == 'owner'):
                        exist_list[7] = 'checked="checked"'
                    i += 1
                except:
                    break

            list += '<li><input type="checkbox" name="ban" ' + exist_list[0] + '> 차단</li>'
            list += '<li><input type="checkbox" name="mdel" ' + exist_list[1] + '> 많은 문서 삭제</li>'
            list += '<li><input type="checkbox" name="toron" ' + exist_list[2] + '> 토론 관리</li>'
            list += '<li><input type="checkbox" name="check" ' + exist_list[3] + '> 사용자 검사</li>'
            list += '<li><input type="checkbox" name="acl" ' + exist_list[4] + '> 문서 ACL</li>'
            list += '<li><input type="checkbox" name="hidel" ' + exist_list[5] + '> 역사 숨김</li>'
            list += '<li><input type="checkbox" name="owner" ' + exist_list[7] + '> 소유자</li>'
            
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '관리 그룹 추가', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/adminplus/' + url_pas(name) + '">' + list + '<div class="form-actions"><button class="btn btn-primary" type="submit">저장</button></div></form>')
    else:
        return redirect('/error/3')
        
@route('/adminlist')
def admin_list():
    session = request.environ.get('beaker.session')
    i = 0
    div = '<div>'
    
    db_ex("select * from user where acl = 'admin' or acl = 'owner'")
    user_data = db_get()
    if(user_data):
        while(True):
            try:
                db_ex("select title from data where title = '사용자:" + user_data[i]['id'] + "'")
                user = db_get()
                if(user):
                    name = '<a href="/w/' + url_pas('사용자:' + user_data[i]['id']) + '">' + user_data[i]['id'] + '</a> (' + user_data[i]['acl'] + ')'
                else:
                    name = '<a class="not_thing" href="/w/' + url_pas('사용자:' + user_data[i]['id']) + '">' + user_data[i]['id'] + '</a> (' + user_data[i]['acl'] + ')'

                div += '<li>' + str(i + 1) + '. ' + name + '</li>'
                
                i += 1
            
            except:
                div += '</div>'
                break
            
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], data = div, title = '관리자 목록')
    else:
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], title = '관리자 목록')
        
@route('/recentchanges')
def recent_changes():
    session = request.environ.get('beaker.session')
    i = 0
    ydmin = admin_check(1, session)
    div = '<div><table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;">문서명</td><td style="text-align: center;width:33.33%;">기여자</td><td style="text-align: center;width:33.33%;">시간</td></tr>'
    
    db_ex("select id, title, date, ip, send, leng from history order by date desc limit 50")
    rows = db_get()
    if(rows):
        while(True):
            try:                
                if(rows[i]['send']):
                    if(re.search("^(?: *)$", rows[i]['send'])):
                        send = '<br>'
                    else:
                        send = rows[i]['send']
                else:
                    send = '<br>'
                    
                title = rows[i]['title']
                title = re.sub('<', '&lt;', title)
                title = re.sub('>', '&gt;', title)
                
                m = re.search("\+", rows[i]['leng'])
                n = re.search("\-", rows[i]['leng'])
                
                if(m):
                    leng = '<span style="color:green;">' + rows[i]['leng'] + '</span>'
                elif(n):
                    leng = '<span style="color:red;">' + rows[i]['leng'] + '</span>'
                else:
                    leng = '<span style="color:gray;">' + rows[i]['leng'] + '</span>'
                    
                if(ydmin == 1):
                    db_ex("select * from ban where block = '" + db_pas(rows[i]['ip']) + "'")
                    row = db_get()
                    if(row):
                        ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(해제)</a>'
                    else:
                        ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(차단)</a>'
                else:
                    ban = ''
                    
                ip = ip_pas(rows[i]['ip'], None)
                        
                if((int(rows[i]['id']) - 1) == 0):
                    revert = ''
                else:
                    revert = '<a href="/w/' + url_pas(rows[i]['title']) + '/r/' + str(int(rows[i]['id']) - 1) + '/diff/' + rows[i]['id'] + '">(비교)</a> <a href="/revert/' + url_pas(rows[i]['title']) + '/r/' + str(int(rows[i]['id']) - 1) + '">(되돌리기)</a>'
                    
                div += '<tr><td style="text-align: center;width:33.33%;"><a href="/w/' + url_pas(rows[i]['title']) + '">' + title + '</a> <a href="/history/' + url_pas(rows[i]['title']) + '/n/1">(역사)</a> ' + revert + ' (' + leng + ')</td><td style="text-align: center;width:33.33%;">' + ip + ban + '</td><td style="text-align: center;width:33.33%;">' + rows[i]['date'] + '</td></tr><tr><td colspan="3" style="text-align: center;width:100%;">' + send + '</td></tr>'
                
                i += 1
            except:
                div = div + '</tbody></table></div>'
                break
            
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = div, tn = 3, title = '최근 변경내역')
    else:
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = '<br>None', tn = 3, title = '최근 변경내역')
        
@route('/history/<name:path>/r/<num:int>/hidden')
def history_hidden(name = None, num = None):
    session = request.environ.get('beaker.session')
    if(admin_check(6, session) == 1):
        db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
        exist = db_get()
        if(exist):
            db_ex("delete from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
        else:
            db_ex("insert into hidhi (title, re) value ('" + db_pas(name) + "', '" + db_pas(str(num)) + "')")
            
        db_com()
        
        return redirect('/history/' + url_pas(name) + '/n/1')
    else:
        return redirect('/history/' + url_pas(name) + '/n/1')
        
@route('/record/<name:path>/n/<num:int>')
def user_record(name = None, num = None):
    session = request.environ.get('beaker.session')
    v = num * 50
    i = v - 50
    ydmin = admin_check(1, session)
    div = '<div><table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;">문서명</td><td style="text-align: center;width:33.33%;">기여자</td><td style="text-align: center;width:33.33%;">시간</td></tr>'
    
    db_ex("select * from history where ip = '" + db_pas(name) + "' order by date desc")
    rows = db_get()
    if(rows):
        while(True):
            try:       
                if(rows[i]['send']):
                    send = rows[i]['send']
                    send = re.sub('<a href="\/w\/(?P<in>[^"]*)">(?P<out>[^&]*)<\/a>', '<a href="/w/\g<in>">\g<out></a>', send)
                else:
                    send = '<br>'
                    
                title = rows[i]['title']
                title = re.sub('<', '&lt;', title)
                title = re.sub('>', '&gt;', title)
                
                m = re.search("\+", rows[i]['leng'])
                n = re.search("\-", rows[i]['leng'])
                
                if(m):
                    leng = '<span style="color:green;">' + rows[i]['leng'] + '</span>'
                elif(n):
                    leng = '<span style="color:red;">' + rows[i]['leng'] + '</span>'
                else:
                    leng = '<span style="color:gray;">' + rows[i]['leng'] + '</span>'
                    
                if(ydmin == 1):
                    db_ex("select * from ban where block = '" + db_pas(rows[i]['ip']) + "'")
                    row = db_get()
                    if(row):
                        ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(해제)</a>'
                    else:
                        ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(차단)</a>'
                else:
                    ban = ''
                    
                ip = ip_pas(rows[i]['ip'], None)
                        
                if((int(rows[i]['id']) - 1) == 0):
                    revert = ''
                else:
                    revert = '<a href="/revert/' + url_pas(rows[i]['title']) + '/r/' + str(int(rows[i]['id']) - 1) + '">(되돌리기)</a>'
                    
                div += '<tr><td style="text-align: center;width:33.33%;"><a href="/w/' + url_pas(rows[i]['title']) + '">' + title + '</a> (' + rows[i]['id'] + '판) <a href="/history/' + url_pas(rows[i]['title']) + '/n/1">(역사)</a> <a href="/w/' + url_pas(rows[i]['title']) + '/r/' + str(int(rows[i]['id']) - 1) + '/diff/' + rows[i]['id'] + '">(비교)</a> ' + revert + ' (' + leng + ')</td><td style="text-align: center;width:33.33%;">' + ip + ban +  '</td><td style="text-align: center;width:33.33%;">' + rows[i]['date'] + '</td></tr><tr><td colspan="3" style="text-align: center;width:100%;">' + send + '</td></tr>'
                
                if(i == v):
                    div += '</tbody></table></div>'
                    if(num == 1):
                        div += '<br><a href="/record/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)</a>'
                    else:
                        div += '<br><a href="/record/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전)</a> <a href="/record/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)</a>'
                    break

                i += 1
            except:
                div += '</tbody></table></div>'

                if(num != 1):
                    div += '<br><a href="/record/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전)</a>'

                break
                
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = div, tn = 3, title = '사용자 기록')
    else:
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = '<br>None', tn = 3, title = '사용자 기록')
        
@route('/userlog/n/<number:int>')
def user_log(number = None):
    session = request.environ.get('beaker.session')
    i = number * 50
    j = i - 50
    list_data = ''
    ydmin = admin_check(1, session)
    
    db_ex("select * from user")
    user_list = db_get()
    if(user_list):        
        while(True):
            try:
                a = user_list[j]
            except:
                if(number != 1):
                    list_data = list_data + '<br><a href="/userlog/n/' + str(number - 1) + '">(이전)'
                break
                
            if(ydmin == 1):
                db_ex("select * from ban where block = '" + db_pas(user_list[j]['id']) + "'")
                ban_exist = db_get()
                if(ban_exist):
                    ban_button = ' <a href="/ban/' + url_pas(user_list[j]['id']) + '">(해제)</a>'
                else:
                    ban_button = ' <a href="/ban/' + url_pas(user_list[j]['id']) + '">(차단)</a>'
            else:
                ban_button = ''
                
            ip = ip_pas(user_list[j]['id'], None)
                
            list_data += '<li>' + str(j + 1) + '. ' + ip + ban_button + '</li>'
            
            if(j == i):
                if(number == 1):
                    list_data += '<br><a href="/userlog/n/' + str(number + 1) + '">(다음)'
                else:
                    list_data += '<br><a href="/userlog/n/' + str(number - 1) + '">(이전) <a href="/userlog/n/' + str(number + 1) + '">(다음)'
                break
            else:
                j += 1
                
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], data = list_data, title = '사용자 가입 기록')
    else:
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], data = '', title = '사용자 가입 기록')
        
@route('/backreset')
def backlink_reset():
    session = request.environ.get('beaker.session')
    if(admin_check(None, session) == 1):
        i = 0
        
        db_ex("delete from back")
        db_com()
        
        db_ex("select * from data")
        all = db_get()
        if(all):
            while(True):
                try:
                    namumark(session, all[i]['title'], all[i]['data'])
                    
                    i += 1
                except:
                    break
        
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], data = '에러 없음', title = '완료')
    else:
        return redirect('/error/3')
        
@route('/backlink/<name:path>/n/<num:int>')
def backlink(name = None, num = None):
    session = request.environ.get('beaker.session')
    v = num * 50
    i = v - 50
    div = ''
    restart = 0
    
    db_ex("delete from back where title = '" + db_pas(name) + "' and link = ''")
    db_com()
    
    db_ex("select * from back where title = '" + db_pas(name) + "' order by link asc")
    rows = db_get()
    if(rows):        
        while(True):
            try:
                if(rows[i]['type'] == 'include' or rows[i]['type'] == 'file'):
                    db_ex("select * from back where title = '" + db_pas(name) + "' and link = '" + db_pas(rows[i]['link']) + "' and type = ''")
                    test = db_get()
                    if(test):
                        restart = 1
                        
                        db_ex("delete from back where title = '" + db_pas(name) + "' and link = '" + db_pas(rows[i]['link']) + "' and type = ''")
                        db_com()
                    
                if(not re.search('^사용자:', rows[i]['link'])):
                    db_ex("select * from data where title = '" + db_pas(rows[i]['link']) + "'")
                    row = db_get()
                    if(row):
                        data = row[0]['data']
                        data = re.sub("(?P<in>\[include\((?P<out>(?:(?!\)\]|,).)*)((?:,\s?(?:[^)]*))+)?\)\])", "\g<in>\n\n[[\g<out>]]\n\n", data)
                        data = re.sub("\[\[파일:(?P<in>(?:(?!\]\]|\|).)*)(?:\|((?:(?!\]\]).)*))?\]\]", "\n\n[[:파일:\g<in>]]\n\n", data)
                        data = re.sub('^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)', '[[\g<in>]]', data)
                        data = namumark(session, '', data)                    
                        
                        if(re.search("<a(?:(?:(?!href=).)*)?href=\"\/w\/" + url_pas(name) + "(?:\#[^\"]*)?\"(?:(?:(?!>).)*)?>([^<]*)<\/a>", data)):
                            div += '<li><a href="/w/' + url_pas(rows[i]['link']) + '">' + rows[i]['link'] + '</a>'
                            
                            if(rows[i]['type']):
                                div += ' (' + rows[i]['type'] + ')</li>'
                            else:
                                div += '</li>'
                                
                            if(i == v):
                                if(num == 1):
                                    div += '<br><a href="/backlink/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)'
                                else:
                                    div += '<br><a href="/backlink/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전) <a href="/backlink/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)'
                                    
                                break
                            else:
                                i += 1
                        else:
                            db_ex("delete from back where title = '" + db_pas(name) + "' and link = '" + db_pas(rows[i]['link']) + "'")
                            db_com()
                            
                            i += 1
                            v += 1
                    else:
                        db_ex("delete from back where title = '" + db_pas(name) + "' and link = '" + db_pas(rows[i]['link']) + "'")
                        db_com()
                        
                        i += 1
                        v += 1
                else:
                    db_ex("delete from back where title = '" + db_pas(name) + "' and link = '" + db_pas(rows[i]['link']) + "'")
                    db_com()
                    
                    i += 1
                    v += 1
            except:
                if(num != 1):
                    div += '<br><a href="/backlink/n/' + str(num - 1) + '">(이전)'
                
                break
                
        if(restart == 1):
            return redirect('/backlink/' + url_pas(name) + '/n/' + str(num))
        else:    
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], data = div, title = name, page = url_pas(name), sub = '역링크')
    else:
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], data = 'None', title = name, page = url_pas(name), sub = '역링크')
        
@route('/recentdiscuss')
def recent_discuss():
    session = request.environ.get('beaker.session')
    i = 0
    div = '<div><table style="width: 100%;"><tbody><tr><td style="text-align: center;width:50%;">토론명</td><td style="text-align: center;width:50%;">시간</td></tr>'
    
    db_ex("select * from rd order by date desc limit 50")
    rows = db_get()
    if(rows):
        while(True):
            try:
                title = rows[i]['title']
                title = re.sub('<', '&lt;', title)
                title = re.sub('>', '&gt;', title)
                
                sub = rows[i]['sub']
                sub = re.sub('<', '&lt;', sub)
                sub = re.sub('>', '&gt;', sub)
                
                div += '<tr><td style="text-align: center;width:50%;"><a href="/topic/' + url_pas(rows[i]['title']) + '/sub/' + url_pas(rows[i]['sub']) + '">' + title + '</a> (' + sub + ')</td><td style="text-align: center;width:50%;">' + rows[i]['date'] + '</td></tr>'
                
                i += 1
            except:
                div += '</tbody></table></div>'
                
                break
            
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = div, tn = 3, title = '최근 토론내역')
    else:
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = '<br>None', tn = 3, title = '최근 토론내역')

@route('/blocklog/n/<number:int>')
def blocklog(number = None):
    session = request.environ.get('beaker.session')
    v = number * 50
    i = v - 50
    div = '<div><table style="width: 100%;"><tbody><tr><td style="text-align: center;width:20%;">차단자</td><td style="text-align: center;width:20%;">관리자</td><td style="text-align: center;width:20%;">언제까지</td><td style="text-align: center;width:20%;">왜</td><td style="text-align: center;width:20%;">시간</td></tr>'
    
    db_ex("select * from rb order by today desc")
    rows = db_get()
    if(rows):
        while(True):
            try: 
                why = rows[i]['why']
                why = re.sub('<', '&lt;', why)
                why = re.sub('>', '&gt;', why)
                
                b = re.search("^([0-9]{1,3}\.[0-9]{1,3})$", rows[i]['block'])
                if(b):
                    ip = rows[i]['block'] + ' (대역)'
                else:
                    ip = rows[i]['block']
                    
                div += '<tr><td style="text-align: center;width:20%;">' + ip + '</a></td><td style="text-align: center;width:20%;">' + rows[i]['blocker'] + '</td><td style="text-align: center;width:20%;">' + rows[i]['end'] + '</td><td style="text-align: center;width:20%;">' + rows[i]['why'] + '</td><td style="text-align: center;width:20%;">' + rows[i]['today'] + '</td></tr>'
                
                if(i == v):
                    div += '</tbody></table></div>'
                    
                    if(number == 1):
                        div += '<br><a href="/blocklog/n/' + str(number + 1) + '">(다음)</a>'
                    else:
                        div += '<br><a href="/blocklog/n/' + str(number - 1) + '">(이전)</a> <a href="/blocklog/n/' + str(number + 1) + '">(다음)</a>'
                        
                    break
                else:
                    i += 1
            except:
                div += '</tbody></table></div>'
                
                if(number != 1):
                    div = div + '<br><a href="/blocklog/n/' + str(number - 1) + '">(이전)</a>'
                    
                break
                
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = div, tn = 3, title = '사용자 차단 기록')
    else:
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = '<br>None', tn = 3, title = '사용자 차단 기록')
        
@route('/history/<name:path>/n/<num:int>', method=['POST', 'GET'])
def history_view(name = None, num = None):
    session = request.environ.get('beaker.session')
    if(request.method == 'POST'):
        return redirect('/w/' + url_pas(name) + '/r/' + request.forms.b + '/diff/' + request.forms.a)
    else:
        select = ''
        v = num * 50
        i = v - 50
        ydmin = admin_check(1, session)
        zdmin = admin_check(6, session)
        div = '<div><table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;">판</td><td style="text-align: center;width:33.33%;">기여자</td><td style="text-align: center;width:33.33%;">시간</td></tr>'
        
        db_ex("select send, leng, ip, date, title, id from history where title = '" + db_pas(name) + "' order by id + 0 desc")
        rows = db_get()
        if(rows):
            while(True):
                try:
                    style = ''
                    
                    select += '<option value="' + rows[i]['id'] + '">' + rows[i]['id'] + '</option>'
                    
                    if(rows[i]['send']):
                        send = rows[i]['send']
                    else:
                        send = '<br>'
                        
                    m = re.search("\+", rows[i]['leng'])
                    n = re.search("\-", rows[i]['leng'])
                    if(m):
                        leng = '<span style="color:green;">' + rows[i]['leng'] + '</span>'
                    elif(n):
                        leng = '<span style="color:red;">' + rows[i]['leng'] + '</span>'
                    else:
                        leng = '<span style="color:gray;">' + rows[i]['leng'] + '</span>'                    
                        
                    ip = ip_pas(rows[i]['ip'], None)
                            
                    db_ex("select * from user where id = '" + db_pas(rows[i]['ip']) + "'")
                    row = db_get()
                    if(row):
                        if(ydmin == 1):
                            ban = ''
                        else:
                            db_ex("select * from ban where block = '" + db_pas(rows[i]['ip']) + "'")
                            row = db_get()
                            if(row):
                                ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(해제)</a>'
                            else:
                                ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(차단)</a>'
                    else:
                        db_ex("select * from ban where block = '" + db_pas(rows[i]['ip']) + "'")
                        row = db_get()
                        if(row):
                            ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(해제)</a>'
                        else:
                            ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(차단)</a>'
                                
                    if(zdmin == 1):
                        db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(rows[i]['id']) + "'")
                        row = db_get()
                        if(row):                            
                            ip += ' (숨김)'                            
                            hidden = ' <a href="/history/' + url_pas(name) + '/r/' + rows[i]['id'] + '/hidden">(공개)'
                        else:
                            hidden = ' <a href="/history/' + url_pas(name) + '/r/' + rows[i]['id'] + '/hidden">(숨김)'
                    else:
                        db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(rows[i]['id']) + "'")
                        row = db_get()
                        if(row):
                            ip = '숨김'
                            hidden = ''
                            send = '숨김'
                            ban = ''
                            style = 'display:none;'
                            v += 1
                        else:
                            hidden = ''      
                            
                    div += '<tr style="' + style + '"><td style="text-align: center;width:33.33%;">' + rows[i]['id'] + '판</a> <a href="/w/' + url_pas(rows[i]['title']) + '/r/' + rows[i]['id'] + '">(w)</a> <a href="/w/' + url_pas(rows[i]['title']) + '/raw/' + rows[i]['id'] + '">(Raw)</a> <a href="/revert/' + url_pas(rows[i]['title']) + '/r/' + rows[i]['id'] + '">(되돌리기)</a> (' + leng + ')</td><td style="text-align: center;width:33.33%;">' + ip + ban + hidden + '</td><td style="text-align: center;width:33.33%;">' + rows[i]['date'] + '</td></tr><tr><td colspan="3" style="text-align: center;width:100%;">' + send + '</td></tr>'
                    
                    if(i == v):
                        div += '</tbody></table></div>'
                        
                        if(num == 1):
                            div += '<br><a href="/history/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)</a>'
                        else:
                            div += '<br><a href="/history/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전)</a> <a href="/history/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)</a>'
                            
                        break
                    else:
                        i += 1

                except:
                    div += '</tbody></table></div>'
                    
                    if(num != 1):
                        div = div + '<br><a href="/history/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전)</a>'

                    break
                    
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = div, tn = 5, title = name, page = url_pas(name), select = select, sub = '역사')
        else:
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = '<br>None', tn = 5, title = name, page = url_pas(name), select = select, sub = '역사')
            
@route('/search', method=['POST'])
def search():
    session = request.environ.get('beaker.session')
    return redirect('/search/' + url_pas(request.forms.search) + '/n/1')

@route('/goto', method=['POST'])
def goto():
    session = request.environ.get('beaker.session')
    db_ex("select title from data where title = '" + db_pas(request.forms.search) + "'")
    data = db_get()
    if(data):
        return redirect('/w/' + url_pas(request.forms.search))
    else:
        return redirect('/search/' + url_pas(request.forms.search) + '/n/1')

@route('/search/<name:path>/n/<num:int>')
def deep_search(name = None, num = None):
    session = request.environ.get('beaker.session')
    v = num * 50
    i = v - 50

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

    db_ex("select title from data where title like '%" + db_pas(name) + "%'")
    title_list = db_get()

    db_ex("select title from data where data like '%" + db_pas(name) + "%'")
    data_list = db_get()

    db_ex("select title from data where title = '" + db_pas(name) + "'")
    exist = db_get()
    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(not all_list == ''):
        while(True):
            try:
                re_title = re.compile(name, re.I)
                if(re.search(re_title, all_list[i]['title'])):
                    if(no == 0):
                        div += '<li><a href="/w/' + url_pas(all_list[i]['title']) + '">' + all_list[i]['title'] + '</a> (문서명)</li>'
                    else:
                        div_plus += '<li><a href="/w/' + url_pas(all_list[i]['title']) + '">' + all_list[i]['title'] + '</a> (내용)</li>'
                else:
                    no = 1

                    div_plus += '<li><a href="/w/' + url_pas(all_list[i]['title']) + '">' + all_list[i]['title'] + '</a> (내용)</li>'
            except:
                if(num != 1):
                    end = '<br><a href="/search/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전)'

                break

            if(i == v):
                if(num == 1):
                    end = '<br><a href="/search/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)'
                else:
                    end = '<br><a href="/search/' + url_pas(name) + '/n/' + str(num - 1) + '">(이전) <a href="/search/' + url_pas(name) + '/n/' + str(num + 1) + '">(다음)'

                break
            else:
                i += 1
    else:
        div += '<li>검색 결과 없음</li>'

    div = div + div_plus + end

    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], data = div, title = name, sub = '검색')
        
@route('/w/<name:path>/r/<num:int>')
def old_view(name = None, num = None):
    session = request.environ.get('beaker.session')
    db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
    row = db_get()
    if(row):
        if(admin_check(6, session) == 1):
            db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
            rows = db_get()
            if(rows):
                enddata = namumark(session, name, rows[0]['data'])
                
                m = re.search('<div id="toc">((?:(?!\/div>).)*)<\/div>', enddata)
                if(m):
                    result = m.groups()
                    left = result[0]
                else:
                    left = ''
                    
                return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, tn = 6, left = left, sub = '옛 문서')
            else:
                return redirect('/history/' + url_pas(name))
        else:
            return redirect('/error/3')
    else:
        db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
        rows = db_get()
        if(rows):
            enddata = namumark(session, name, rows[0]['data'])
            
            m = re.search('<div id="toc">((?:(?!\/div>).)*)<\/div>', enddata)
            if(m):
                result = m.groups()
                left = result[0]
            else:
                left = ''
                
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, tn = 6, left = left, sub = '옛 문서')
        else:
            return redirect('/history/' + url_pas(name))
            
@route('/w/<name:path>/raw/<num:int>')
def old_raw(name = None, num = None):
    session = request.environ.get('beaker.session')
    db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
    row = db_get()
    if(row):
        if(admin_check(6, session) == 1):
            db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
            rows = db_get()
            if(rows):
                enddata = re.sub('<', '&lt;', rows[0]['data'])
                enddata = re.sub('>', '&gt;', enddata)
                enddata = re.sub('"', '&quot;', enddata)
                
                enddata = '<pre>' + enddata + '</pre>'
                
                return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, sub = '옛 Raw')
            else:
                return redirect('/history/' + url_pas(name))
        else:
            return redirect('/error/3')
    else:
        db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
        rows = db_get()
        if(rows):
            enddata = re.sub('<', '&lt;', rows[0]['data'])
            enddata = re.sub('>', '&gt;', enddata)
            enddata = re.sub('"', '&quot;', enddata)
            
            enddata = '<pre>' + enddata + '</pre>'
            
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, sub = '옛 Raw')
        else:
            return redirect('/history/' + url_pas(name))
            
@route('/raw/<name:path>')
def raw_view(name = None):
    session = request.environ.get('beaker.session')
    db_ex("select * from data where title = '" + db_pas(name) + "'")
    rows = db_get()
    if(rows):
        enddata = re.sub('<', '&lt;', rows[0]['data'])
        enddata = re.sub('>', '&gt;', enddata)
        enddata = re.sub('"', '&quot;', enddata)
        
        enddata = '<pre>' + enddata + '</pre>'
        
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, tn = 6, sub = 'Raw')
    else:
        return redirect('/w/' + url_pas(name))
        
@route('/revert/<name:path>/r/<num:int>', method=['POST', 'GET'])
def revert(name = None, num = None):
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    can = acl_check(session, ip, name)
    today = get_time()
    
    if(request.method == 'POST'):
        db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
        row = db_get()
        if(row):
            if(admin_check(6, session) == 1):        
                db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
                rows = db_get()
                if(rows):
                    if(can == 1):
                        return redirect('/ban')
                    else:
                        db_ex("select * from data where title = '" + db_pas(name) + "'")
                        row = db_get()
                        if(row):
                            leng = leng_check(len(row[0]['data']), len(rows[0]['data']))
                            
                            db_ex("update data set data = '" + db_pas(rows[0]['data']) + "' where title = '" + db_pas(name) + "'")
                            db_com()
                        else:
                            leng = '+' + str(len(rows[0]['data']))
                            
                            db_ex("insert into data (title, data, acl) value ('" + db_pas(name) + "', '" + db_pas(rows[0]['data']) + "', '')")
                            db_com()
                            
                        history_plus(name, rows[0]['data'], today, ip, '문서를 ' + str(num) + '판으로 되돌렸습니다.', leng)
                        
                        return redirect('/w/' + url_pas(name))
                else:
                    return redirect('/w/' + url_pas(name))
            else:
                return redirect('/error/3')
        else:
            db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
            rows = db_get()
            if(rows):                
                if(can == 1):
                    return redirect('/ban')
                else:                    
                    db_ex("select * from data where title = '" + db_pas(name) + "'")
                    row = db_get()
                    if(row):
                        leng = leng_check(len(row[0]['data']), len(rows[0]['data']))
                        
                        db_ex("update data set data = '" + db_pas(rows[0]['data']) + "' where title = '" + db_pas(name) + "'")
                        db_com()
                    else:
                        leng = '+' + str(len(rows[0]['data']))
                        
                        db_ex("insert into data (title, data, acl) value ('" + db_pas(name) + "', '" + db_pas(rows[0]['data']) + "', '')")
                        db_com()
                        
                    history_plus(name, rows[0]['data'], today, ip, '문서를 ' + str(num) + '판으로 되돌렸습니다.', leng)
                    
                    return redirect('/w/' + url_pas(name))
            else:
                return redirect('/w/' + url_pas(name))            
    else:
        db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
        row = db_get()
        if(row):
            if(admin_check(6, session) == 1):                
                if(can == 1):
                    return redirect('/ban')
                else:
                    db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
                    rows = db_get()
                    if(rows):
                        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), r = url_pas(str(num)), tn = 13, plus = '정말 되돌리시겠습니까?', sub = '되돌리기')
                    else:
                        return redirect('/w/' + url_pas(name))
            else:
                return redirect('/error/3')
        else:            
            if(can == 1):
                return redirect('/ban')
            else:
                db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
                rows = db_get()
                if(rows):
                    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), r = url_pas(str(num)), tn = 13, plus = '정말 되돌리시겠습니까?', sub = '되돌리기')
                else:
                    return redirect('/w/' + url_pas(name))
                    
@route('/manydel', method=['POST', 'GET'])
def many_del():
    session = request.environ.get('beaker.session')
    today = get_time()
    ip = ip_check(session)
    if(admin_check(2, session) == 1):
        if(request.method == 'POST'):
            data = request.forms.content + '\r\n'
            while(True):
                m = re.search('(.*)\r\n', data)
                if(m):
                    g = m.groups()
                    db_ex("select data from data where title = '" + db_pas(g[0]) + "'")
                    rows = db_get()
                    if(rows):
                        leng = '-' + str(len(rows[0]['data']))
                        db_ex("delete from data where title = '" + db_pas(g[0]) + "'")
                        history_plus(g[0], '', today, ip, '문서를 삭제 했습니다.', leng)
                    data = re.sub('(.*)\r\n', '', data, 1)
                else:
                    break
            db_com()
            return redirect('/')
        else:
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '많은 문서 삭제', logo = set_data['name'], tn = 4)
    else:
        return redirect('/error/3')
    
                
@route('/edit/<name:path>/section/<num:int>', method=['POST', 'GET'])
def section_edit(name = None, num = None):
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    can = acl_check(session, ip, name)
    
    if(request.method == 'POST'):
        if(len(request.forms.send) > 500):
            return redirect('/error/15')
        else:
            today = get_time()
            
            content = savemark(session, request.forms.content)
            
            db_ex("select * from data where title = '" + db_pas(name) + "'")
            rows = db_get()
            if(rows):
                if(request.forms.otent == content):
                    return redirect('/error/18')
                else:                    
                    if(can == 1):
                        return redirect('/ban')
                    else:
                        leng = leng_check(len(request.forms.otent), len(content))
                        
                        content = rows[0]['data'].replace(request.forms.otent, content)
                        
                        history_plus(name, content, today, ip, html_pas(request.forms.send, 2), leng)
                        
                        db_ex("update data set data = '" + db_pas(content) + "' where title = '" + db_pas(name) + "'")
                        db_com()
                        
                    include_check(name, content)
                    
                    return redirect('/w/' + url_pas(name))
            else:
                return redirect('/w/' + url_pas(name))
    else:        
        if(can == 1):
            return redirect('/ban')
        else:                
            db_ex("select * from data where title = '" + db_pas(name) + "'")
            rows = db_get()
            if(rows):
                i = 0
                j = 0
                
                gdata = rows[0]['data'] + '\r\n'
                while(True):
                    m = re.search("((?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n(?:(?:(?:(?!(?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n).)*)(?:\n)?)+)", gdata)
                    if(m):
                        if(i == num - 1):
                            g = m.groups()
                            gdata = re.sub("\r\n$", "", g[0])
                            break
                        else:
                            gdata = re.sub("((?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n(?:(?:(?:(?!(?:={1,6})\s?(?:[^=]*)\s?(?:={1,6})(?:\s+)?\n).)*)(?:\n)?)+)", "", gdata, 1)
                            
                            i += 1
                    else:
                        j = 1
                        
                        break
                        
                if(j == 0):
                    gdata = re.sub("\r\n$", "", gdata)

                    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), data = gdata, tn = 2, section = 1, number = num, sub = '편집')
                else:
                    return redirect('/w/' + url_pas(name))
            else:
                return redirect('/w/' + url_pas(name))

@route('/edit/<name:path>', method=['POST', 'GET'])
def edit(name = None):
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    can = acl_check(session, ip, name)
    
    if(request.method == 'POST'):
        if(len(request.forms.send) > 500):
            return redirect('/error/15')
        else:
            today = get_time()
            
            content = savemark(session, request.forms.content)
            
            db_ex("select * from data where title = '" + db_pas(name) + "'")
            rows = db_get()
            if(rows):
                if(rows[0]['data'] == content):
                    return redirect('/error/18')
                else:                    
                    if(can == 1):
                        return redirect('/ban')
                    else:                        
                        leng = leng_check(len(rows[0]['data']), len(content))
                        history_plus(name, content, today, ip, html_pas(request.forms.send, 2), leng)
                        
                        db_ex("update data set data = '" + db_pas(content) + "' where title = '" + db_pas(name) + "'")
                        db_com()
            else:                
                if(can == 1):
                    return redirect('/ban')
                else:
                    leng = '+' + str(len(content))
                    history_plus(name, content, today, ip, html_pas(request.forms.send, 2), leng)
                    
                    db_ex("insert into data (title, data, acl) value ('" + db_pas(name) + "', '" + db_pas(content) + "', '')")
                    db_com()
                    
            include_check(name, content)
            
            return redirect('/w/' + url_pas(name))
    else:        
        if(can == 1):
            return redirect('/ban')
        else:                
            db_ex("select * from data where title = '" + db_pas(name) + "'")
            rows = db_get()
            if(rows):
                return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), data = rows[0]['data'], tn = 2, sub = '편집')
            else:
                return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), data = '', tn = 2, sub = '편집')

@route('/preview/<name:path>/section/<num:int>', method=['POST'])
def section_preview(name = None, num = None):
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    can = acl_check(session, 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(session, name, newdata)
            
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), data = request.forms.content, tn = 2, preview = 1, enddata = enddata, section = 1, number = num, odata = request.forms.otent, sub = '미리보기')
                
@route('/preview/<name:path>', method=['POST'])
def preview(name = None):
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    can = acl_check(session, 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(session, name, newdata)
            
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), data = request.forms.content, tn = 2, preview = 1, enddata = enddata, sub = '미리보기')
        
@route('/delete/<name:path>', method=['POST', 'GET'])
def delete(name = None):
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    can = acl_check(session, ip, name)
    
    if(request.method == 'POST'):
        db_ex("select * from data where title = '" + db_pas(name) + "'")
        rows = db_get()
        if(rows):
            if(can == 1):
                return redirect('/ban')
            else:
                today = get_time()
                
                leng = '-' + str(len(rows[0]['data']))
                history_plus(name, '', today, ip, '문서를 삭제 했습니다.', leng)
                
                db_ex("delete from data where title = '" + db_pas(name) + "'")
                db_com()
                
                return redirect('/w/' + url_pas(name))
        else:
            return redirect('/w/' + url_pas(name))
    else:
        db_ex("select * from data where title = '" + db_pas(name) + "'")
        rows = db_get()
        if(rows):
            if(can == 1):
                return redirect('/ban')
            else:
                return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), tn = 8, plus = '정말 삭제 하시겠습니까?', sub = '삭제')
        else:
            return redirect('/w/' + url_pas(name))
            
@route('/move/<name:path>', method=['POST', 'GET'])
def move(name = None):
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    can = acl_check(session, ip, name)
    today = get_time()
    
    if(request.method == 'POST'):
        db_ex("select * from data where title = '" + db_pas(name) + "'")
        rows = db_get()

        if(can == 1):
            return redirect('/ban')
        else:
            leng = '0'
            db_ex("select * from history where title = '" + db_pas(request.forms.title) + "'")
            row = db_get()
            if(row):
                return redirect('/error/19')
            else:
                history_plus(name, rows[0]['data'], today, ip, '<a href="/w/' + url_pas(name) + '">' + name + '</a> 문서를 <a href="/w/' + url_pas(request.forms.title) + '">' + request.forms.title + '</a> 문서로 이동 했습니다.', leng)
                
                if(rows):
                    db_ex("update data set title = '" + db_pas(request.forms.title) + "' where title = '" + db_pas(name) + "'")

                db_ex("update history set title = '" + db_pas(request.forms.title) + "' where title = '" + db_pas(name) + "'")
                db_com()
                return redirect('/w/' + url_pas(request.forms.title))
    else:
        if(can == 1):
            return redirect('/ban')
        else:
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), tn = 9, plus = '정말 이동 하시겠습니까?', sub = '이동')
            
@route('/other')
def other():
    session = request.environ.get('beaker.session')
    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '기타 메뉴', logo = set_data['name'], data = '<h2 style="margin-top: 0px;">기록</h2><li><a href="/blocklog/n/1">사용자 차단 기록</a></li><li><a href="/userlog/n/1">사용자 가입 기록</a></li><li><a href="/manager/6">사용자 기록</a></li><li><a href="/manager/7">사용자 토론 기록</a></li><h2>기타</h2><li><a href="/titleindex">모든 문서</a></li><li><a href="/acllist">ACL 문서 목록</a></li><li><a href="/upload">업로드</a></li><li><a href="/adminlist">관리자 목록</a></li><li><a href="/manager/1">관리자 메뉴</a></li><br>이 오픈나무의 버전은 <a href="https://github.com/2DU/openNAMU/blob/normal/version.md">' + r_ver + '</a> 입니다.')
    
@route('/manager/<num:int>', method=['POST', 'GET'])
def manager(num = None):
    session = request.environ.get('beaker.session')
    if(num == 1):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '관리자 메뉴', logo = set_data['name'], data = '<h2 style="margin-top: 0px;">목록</h2><li><a href="/manager/2">문서 ACL</a></li><li><a href="/manager/3">사용자 체크</a></li><li><a href="/manager/4">사용자 차단</a></li><li><a href="/manager/5">관리자 권한 주기</a></li><li><a href="/manydel">많은 문서 삭제</a></li><h2>소유자</h2><li><a href="/backreset">모든 역링크 재 생성</a></li><li><a href="/manager/8">새로운 관리 그룹 생성</a></li><h2>기타</h2><li>이 메뉴에 없는 기능은 해당 문서의 역사나 토론에서 바로 사용 가능함</li>')
    elif(num == 2):
        if(request.method == 'POST'):
            return redirect('/acl/' + url_pas(request.forms.name))
        else:
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = 'ACL 이동', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/manager/2"><input name="name" type="text"><br><br><button class="btn btn-primary" type="submit">이동</button></form>')
    elif(num == 3):
        if(request.method == 'POST'):
            return redirect('/check/' + url_pas(request.forms.name))
        else:
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '체크 이동', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/manager/3"><input name="name" type="text"><br><br><button class="btn btn-primary" type="submit">이동</button></form>')
    elif(num == 4):
        if(request.method == 'POST'):
            return redirect('/ban/' + url_pas(request.forms.name))
        else:
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '차단 이동', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/manager/4"><input name="name" type="text"><br><br><button class="btn btn-primary" type="submit">이동</button><br><br><span>아이피 앞 두자리 (XXX.XXX) 입력하면 대역 차단</span></form>')
    elif(num == 5):
        if(request.method == 'POST'):
            return redirect('/admin/' + url_pas(request.forms.name))
        else:
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '권한 이동', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/manager/5"><input name="name" type="text"><br><br><button class="btn btn-primary" type="submit">이동</button></form>')   
    elif(num == 6):
        if(request.method == 'POST'):
            return redirect('/record/' + url_pas(request.forms.name) + '/n/1')
        else:
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '기록 이동', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/manager/6"><input name="name" type="text"><br><br><button class="btn btn-primary" type="submit">이동</button></form>')    
    elif(num == 7):
        if(request.method == 'POST'):
            return redirect('/user/' + url_pas(request.forms.name) + '/topic/1')
        else:
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '토론 기록 이동', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/manager/7"><input name="name" type="text"><br><br><button class="btn btn-primary" type="submit">이동</button></form>')    
    elif(num == 8):
        if(request.method == 'POST'):
            return redirect('/adminplus/' + url_pas(request.forms.name))
        else:
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '그룹 생성 이동', logo = set_data['name'], data = '<form id="usrform" method="POST" action="/manager/8"><input name="name" type="text"><br><br><button class="btn btn-primary" type="submit">이동</button></form>')    
    else:
        return redirect('/')
        
@route('/titleindex')
def title_index():
    session = request.environ.get('beaker.session')
    i = [0, 0, 0, 0, 0, 0]
    data = '<div>'
    db_ex("select title from data order by title asc")
    title_list = db_get()
    if(title_list):
        while(True):
            try:
                data += '<li>' + str(i[0] + 1) + '. <a href="/w/' + url_pas(title_list[i[0]]['title']) + '">' + title_list[i[0]]['title'] + '</a></li>'

                if(re.search('^분류:', title_list[i[0]]['title'])):
                    i[1] += 1
                elif(re.search('^사용자:', title_list[i[0]]['title'])):
                    i[2] += 1
                elif(re.search('^틀:', title_list[i[0]]['title'])):
                    i[3] += 1
                elif(re.search('^파일:', title_list[i[0]]['title'])):
                    i[4] += 1
                else:
                    i[5] += 1
            
                i[0] += 1
                
            except:
                data += '</div>'
                break

        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = 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>', tn = 3, title = '모든 문서')
    else:
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = '<br>None', tn = 3, title = '모든 문서')
        
@route('/topic/<name:path>/sub/<sub:path>/b/<num:int>')
def topic_block(name = None, sub = None, num = None):
    session = request.environ.get('beaker.session')
    if(admin_check(3, session) == 1):
        db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + str(num) + "'")
        block = db_get()
        if(block):
            if(block[0]['block'] == 'O'):
                db_ex("update topic set block = '' where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + str(num) + "'")
            else:
                db_ex("update topic set block = 'O' where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + str(num) + "'")
            db_com()
            
            rd_plus(name, sub, get_time())
            
            return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
        else:
            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):
    session = request.environ.get('beaker.session')
    if(admin_check(3, session) == 1):
        db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + str(num) + "'")
        topic_data = db_get()
        if(topic_data):
            db_ex("select * from topic where id = '" + str(num) + "' and title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "'")
            top_data = db_get()
            if(top_data):
                if(top_data[0]['top'] == 'O'):
                    db_ex("update topic set top = '' where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + str(num) + "'")
                else:
                    db_ex("update topic set top = 'O' where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + str(num) + "'")

            db_com()
            
            rd_plus(name, sub, get_time())

            return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
        else:
            return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
    else:
        return redirect('/error/3')
        
@route('/topic/<name:path>/sub/<sub:path>/stop')
def topic_stop(name = None, sub = None):
    session = request.environ.get('beaker.session')
    if(admin_check(3, session) == 1):
        ip = ip_check(session)
        
        db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' order by id + 0 desc limit 1")
        topic_check = db_get()
        if(topic_check):
            time = get_time()
            
            db_ex("select * from stop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and close = ''")
            stop = db_get()
            if(stop):
                db_ex("insert into topic (id, title, sub, data, date, ip, block, top) value ('" + db_pas(str(int(topic_check[0]['id']) + 1)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', 'Restart', '" + db_pas(time) + "', '" + db_pas(ip) + " - Restart', '', '')")
                db_ex("delete from stop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and close = ''")
            else:
                db_ex("insert into topic (id, title, sub, data, date, ip, block, top) value ('" + db_pas(str(int(topic_check[0]['id']) + 1)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', 'Stop', '" + db_pas(time) + "', '" + db_pas(ip) + " - Stop', '', '')")
                db_ex("insert into stop (title, sub, close) value ('" + db_pas(name) + "', '" + db_pas(sub) + "', '')")
            db_com()
            
            rd_plus(name, sub, time)
            
            return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
        else:
            return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
    else:
        return redirect('/error/3')
        
@route('/topic/<name:path>/sub/<sub:path>/close')
def topic_close(name = None, sub = None):
    session = request.environ.get('beaker.session')
    if(admin_check(3, session) == 1):
        ip = ip_check(session)
        
        db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' order by id + 0 desc limit 1")
        topic_check = db_get()
        if(topic_check):
            time = get_time()
            
            db_ex("select * from stop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and close = 'O'")
            close = db_get()
            if(close):
                db_ex("insert into topic (id, title, sub, data, date, ip, block, top) value ('" + db_pas(str(int(topic_check[0]['id']) + 1)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', 'Reopen', '" + db_pas(time) + "', '" + db_pas(ip) + " - Reopen', '', '')")
                db_ex("delete from stop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and close = 'O'")
            else:
                db_ex("insert into topic (id, title, sub, data, date, ip, block, top) value ('" + db_pas(str(int(topic_check[0]['id']) + 1)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', 'Close', '" + db_pas(time) + "', '" + db_pas(ip) + " - Close', '', '')")
                db_ex("insert into stop (title, sub, close) value ('" + db_pas(name) + "', '" + db_pas(sub) + "', 'O')")
            db_com()
            
            rd_plus(name, sub, time)
            
            return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
        else:
            return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
    else:
        return redirect('/error/3')
        
@route('/topic/<name:path>/sub/<sub:path>/agree')
def topic_agree(name = None, sub = None):
    session = request.environ.get('beaker.session')
    if(admin_check(3, session) == 1):
        ip = ip_check(session)
        
        db_ex("select id from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' order by id + 0 desc limit 1")
        topic_check = db_get()
        if(topic_check):
            time = get_time()
            
            db_ex("select * from agreedis where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "'")
            agree = db_get()
            if(agree):
                db_ex("insert into topic (id, title, sub, data, date, ip, block, top) value ('" + db_pas(str(int(topic_check[0]['id']) + 1)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', 'Settlement', '" + db_pas(time) + "', '" + db_pas(ip) + " - Settlement', '', '')")
                db_ex("delete from agreedis where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "'")
            else:
                db_ex("insert into topic (id, title, sub, data, date, ip, block, top) value ('" + db_pas(str(int(topic_check[0]['id']) + 1)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', 'Agreement', '" + db_pas(time) + "', '" + db_pas(ip) + " - Agreement', '', '')")
                db_ex("insert into agreedis (title, sub) value ('" + db_pas(name) + "', '" + db_pas(sub) + "')")
            db_com()
            
            rd_plus(name, sub, time)
            
            return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
        else:
            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):
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    ban = topic_check(ip, name, sub)
    admin = admin_check(3, session)
    
    if(request.method == 'POST'):
        db_ex("select id from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' order by id + 0 desc limit 1")
        rows = db_get()
        if(rows):
            number = int(rows[0]['id']) + 1
        else:
            number = 1
        
        if(ban == 1 and not admin == 1):
            return redirect('/ban')
        else:
            db_ex("select * from user where id = '" + db_pas(ip) + "'")
            rows = db_get()
            if(rows):
                if(not rows[0]['acl'] == 'user'):
                    ip = ip + ' - Admin'
                    
            today = get_time()
            rd_plus(name, sub, today)
            
            aa = request.forms.content
            aa = re.sub("\[\[(분류:(?:(?:(?!\]\]).)*))\]\]", "[br]", aa)
            aa = savemark(session, aa)
            
            db_ex("insert into topic (id, title, sub, data, date, ip, block, top) value ('" + str(number) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', '" + db_pas(aa) + "', '" + today + "', '" + ip + "', '', '')")
            db_com()
            
            return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(sub))
    else:
        style = ''

        db_ex("select * from stop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and close = 'O'")
        close = db_get()

        db_ex("select * from stop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and close = ''")
        stop = db_get()
        
        if(admin == 1):
            div = '<div>'
            
            if(close):
                div += '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/close">(토론 열기)</a> '
            else:
                div += '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/close">(토론 닫기)</a> '
            
            if(stop):
                div += '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/stop">(토론 재개)</a> '
            else:
                div += '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/stop">(토론 정지)</a> '

            db_ex("select * from agreedis where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "'")
            agree = db_get()
            if(agree):
                div += '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/agree">(합의 취소)</a>'
            else:
                div += '<a href="/topic/' + url_pas(name) + '/sub/' + url_pas(sub) + '/agree">(합의 완료)</a>'
            
            div += '<br><br>'
        else:
            div = '<div>'
        
        if(stop or close):
            if(not admin == 1):
                style = 'display:none;'
        
        db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' order by id + 0 asc")
        rows = db_get()

        db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and top = 'O' order by id + 0 asc")
        top = db_get()

        i = 0
        if(top):
            while(True):
                try:                        
                    top_data = namumark(session, '', top[i]['data'])
                    top_data = re.sub("(?P<in>#(?:[0-9]*))", '<a href="\g<in>">\g<in></a>', top_data)
                            
                    ip = ip_pas(top[i]['ip'], 1)
                                       
                    div += '<table id="toron"><tbody><tr><td id="toroncolorred"><a href="#' + top[i]['id'] + '" id="' + top[i]['id'] + '-nt">#' + top[i]['id'] + '</a> ' + ip + ' <span style="float:right;">' + top[i]['date'] + '</span></td></tr><tr><td>' + top_data + '</td></tr></tbody></table><br>'
                        
                    i += 1
                except:
                    break
                    
        i = 0        
        while(True):
            try:
                if(i == 0):
                    start = rows[i]['ip']
                    
                indata = namumark(session, '', rows[i]['data'])
                indata = re.sub("(?P<in>#(?:[0-9]*))", '<a href="\g<in>">\g<in></a>', indata)
                
                if(rows[i]['block'] == 'O'):
                    indata = '블라인드 되었습니다.'
                    block = 'id="block"'
                else:
                    block = ''

                m = re.search("^([^-]*)\s\-\s(Close|Reopen|Stop|Restart|Agreement|Settlement)$", rows[i]['ip'])
                if(m):
                    ban = ""
                else:
                    if(admin == 1):
                        if(rows[i]['block'] == '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>'

                        db_ex("select id from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + db_pas(str(i + 1)) + "' and top = 'O'")
                        row = db_get()
                        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>'
                            
                        n = re.search("\- (?:Admin)$", rows[i]['ip'])
                        if(n):
                            ban = isblock
                        else:
                            db_ex("select end from ban where block = '" + db_pas(rows[i]['ip']) + "'")
                            row = db_get()
                            if(row):
                                ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(해제)</a>' + isblock
                            else:
                                ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(차단)</a>' + isblock
                    else:
                        ban = ""

                ip = ip_pas(rows[i]['ip'], 1)
                        
                if(rows[i]['ip'] == start):
                    j = i + 1
                    
                    div += '<table id="toron"><tbody><tr><td id="toroncolorgreen"><a href="javascript:void(0);" id="' + str(j) + '">#' + str(j) + '</a> ' + ip + ban + ' <span style="float:right;">' + rows[i]['date'] + '</span></td></tr><tr><td ' + block + '>' + indata + '</td></tr></tbody></table><br>'
                else:
                    j = i + 1
                    
                    div += '<table id="toron"><tbody><tr><td id="toroncolor"><a href="javascript:void(0);" id="' + str(j) + '">#' + str(j) + '</a> ' + ip + ban + ' <span style="float:right;">' + rows[i]['date'] + '</span></td></tr><tr><td ' + block + '>' + indata + '</td></tr></tbody></table><br>'
                    
                i += 1
            except:
                div += '</div>'
                
                break
            
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, page = url_pas(name), suburl = url_pas(sub), toron = sub, logo = set_data['name'], rows = div, tn = 11, ban = ban, style = style, sub = '토론')
        
@route('/topic/<name:path>/close')
def close_topic_list(name = None):
    session = request.environ.get('beaker.session')
    div = '<div>'
    i = 0
    
    db_ex("select * from stop where title = '" + db_pas(name) + "' and close = 'O' order by sub asc")
    rows = db_get()
    while(True):
        try:
            db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(rows[i]['sub']) + "' and id = '1'")
            row = db_get()
            if(row):
                indata = namumark(session, name, row[0]['data'])
                
                if(row[0]['block'] == 'O'):
                    indata = '블라인드 되었습니다.'
                    block = 'id="block"'
                else:
                    block = ''

                ip = ip_pas(row[0]['ip'], 1)
                    
                div += '<h2><a href="/topic/' + url_pas(name) + '/sub/' + url_pas(rows[i]['sub']) + '">' + str((i + 1)) + '. ' + rows[i]['sub'] + '</a></h2><table id="toron"><tbody><tr><td id="toroncolorgreen"><a href="javascript:void(0);" id="1">#1</a> ' + ip + ' <span style="float:right;">' + row[0]['date'] + '</span></td></tr><tr><td ' + block + '>' + indata + '</td></tr></tbody></table><br>'
                
            i += 1
        except:
            div += '</div>'
            
            break
        
    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, page = url_pas(name), logo = set_data['name'], plus = div, tn = 10, sub = '닫힌 토론')
    
@route('/topic/<name:path>/agree')
def agree_topic_list(name = None):
    session = request.environ.get('beaker.session')
    div = '<div>'
    i = 0
    
    db_ex("select * from agreedis where title = '" + db_pas(name) + "' order by sub asc")
    agree_list = db_get()
    while(True):
        try:            
            db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(agree_list[i]['sub']) + "' and id = '1'")
            data = db_get()
            if(data):
                indata = namumark(session, name, data[0]['data'])
                
                if(data[0]['block'] == 'O'):
                    indata = '블라인드 되었습니다.'
                    block = 'id="block"'
                else:
                    block = ''

                ip = ip_pas(data[0]['ip'], 1)
                    
                div += '<h2><a href="/topic/' + url_pas(name) + '/sub/' + url_pas(data[i]['sub']) + '">' + str(i + 1) + '. ' + data[i]['sub'] + '</a></h2><table id="toron"><tbody><tr><td id="toroncolorgreen"><a href="javascript:void(0);" id="1">#1</a> ' + 아이디 + ' <span style="float:right;">' + data[0]['date'] + '</span></td></tr><tr><td ' + block + '>' + indata + '</td></tr></tbody></table><br>'
                
            i += 1
        except:
            div += '</div>'
            
            break
        
    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, page = url_pas(name), logo = set_data['name'], plus = div, tn = 10, sub = '합의된 토론')

@route('/topic/<name:path>', method=['POST', 'GET'])
def topic_list(name = None):
    session = request.environ.get('beaker.session')
    if(request.method == 'POST'):
        return redirect('/topic/' + url_pas(name) + '/sub/' + url_pas(request.forms.topic))
    else:
        div = '<div>'
        i = 0
        j = 1
        db_ex("select * from rd where title = '" + db_pas(name) + "' order by date asc")
        rows = db_get()
        while(True):
            try:                    
                db_ex("select * from topic where title = '" + db_pas(rows[i]['title']) + "' and sub = '" + db_pas(rows[i]['sub']) + "' and id = '1' order by sub asc")
                aa = db_get()
                
                indata = namumark(session, name, aa[0]['data'])
                
                if(aa[0]['block'] == 'O'):
                    indata = '블라인드 되었습니다.'
                    block = 'id="block"'
                else:
                    block = ''

                ip = ip_pas(aa[0]['ip'], 1)
                    
                db_ex("select * from stop where title = '" + db_pas(rows[i]['title']) + "' and sub = '" + db_pas(rows[i]['sub']) + "' and close = 'O'")
                row = db_get()
                if(not row):
                    div += '<h2><a href="/topic/' + url_pas(rows[i]['title']) + '/sub/' + url_pas(rows[i]['sub']) + '">' + str(j) + '. ' + rows[i]['sub'] + '</a></h2><table id="toron"><tbody><tr><td id="toroncolorgreen"><a href="javascript:void(0);" id="1">#1</a> ' + ip + ' <span style="float:right;">' + aa[0]['date'] + '</span></td></tr><tr><td ' + block + '>' + indata + '</td></tr></tbody></table><br>'
                    j += 1
                    
                i += 1
            
            except:
                div = div + '</div>'
                break
            
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, page = url_pas(name), logo = set_data['name'], plus = div, tn = 10, list = 1, sub = '토론 목록')
        
@route('/login', method=['POST', 'GET'])
def login():
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    ban = ban_check(ip)
        
    if(request.method == 'POST'):        
        if(ban == 1):
            return redirect('/ban')
        else:
            db_ex("select * from user where id = '" + db_pas(request.forms.id) + "'")
            user = db_get()
            if(user):
                if(session.get('Now') == True):
                    return redirect('/error/11')
                elif(bcrypt.checkpw(bytes(request.forms.pw, 'utf-8'), bytes(user[0]['pw'], 'utf-8'))):
                    session['Now'] = True
                    session['DREAMER'] = request.forms.id

                    db_ex("select * from custom where user = '" + db_pas(request.forms.id) + "'")
                    css_data = db_get()
                    if(css_data):
                        session['Daydream'] = css_data[0]['css']
                    else:
                        session['Daydream'] = ''
                    
                    db_ex("insert into login (user, ip, today) value ('" + db_pas(request.forms.id) + "', '" + db_pas(ip) + "', '" + db_pas(get_time()) + "')")
                    db_com()
                    
                    return redirect('/user')
                else:
                    return redirect('/error/13')
            else:
                return redirect('/error/12')
    else:        
        if(ban == 1):
            return redirect('/ban')
        else:
            if(session.get('Now') == True):
                return redirect('/error/11')
            else:
                return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '로그인', enter = '로그인', logo = set_data['name'], tn = 15)
                
@route('/change', method=['POST', 'GET'])
def change_password():
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    ban = ban_check(ip)
    
    if(request.method == 'POST'):      
        if(request.forms.pw2 == request.forms.pw3):
            if(ban == 1):
                return redirect('/ban')
            else:
                db_ex("select * from user where id = '" + db_pas(request.forms.id) + "'")
                user = db_get()
                if(user):
                    if(session.get('Now') == True):
                        return redirect('/logout')
                    elif(bcrypt.checkpw(bytes(request.forms.pw, 'utf-8'), bytes(user[0]['pw'], 'utf-8'))):
                        hashed = bcrypt.hashpw(bytes(request.forms.pw2, 'utf-8'), bcrypt.gensalt())
                        
                        db_ex("update user set pw = '" + db_pas(hashed.decode()) + "' where id = '" + db_pas(request.forms.id) + "'")
                        db_com()
                        
                        return redirect('/login')
                    else:
                        return redirect('/error/10')
                else:
                    return redirect('/error/9')
        else:
            return redirect('/error/20')
    else:        
        if(ban == 1):
            return redirect('/ban')
        else:
            if(session.get('Now') == True):
                return redirect('/logout')
            else:
                return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '비밀번호 변경', enter = '변경', logo = set_data['name'], tn = 15)
                
@route('/check/<name:path>')
def user_check(name = None):
    session = request.environ.get('beaker.session')
    db_ex("select * from user where id = '" + db_pas(name) + "'")
    user = db_get()
    if(user and not user[0]['acl'] == 'user'):
        return redirect('/error/4')
    else:
        if(admin_check(4, session) == 1):
            m = re.search('^(?:[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}?)$', name)
            if(m):
                db_ex("select * from login where ip = '" + db_pas(name) + "' order by today desc")
                row = db_get()
                if(row):
                    i = 0
                    c = '<div><table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;">유저</td><td style="text-align: center;width:33.33%;">아이피</td><td style="text-align: center;width:33.33%;">언제</td></tr>'
                    while(True):
                        try:
                            c += '<tr><td style="text-align: center;width:33.33%;">' + row[i]['user'] + '</td><td style="text-align: center;width:33.33%;">' + row[i]['ip'] + '</td><td style="text-align: center;width:33.33%;">' + row[i]['today'] + '</td></tr>'

                            i += 1
                        except:
                            c += '</tbody></table></div>'

                            break
                        
                    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '다중 검사', logo = set_data['name'], tn = 3, rows = c)
                else:
                    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '다중 검사', logo = set_data['name'], tn = 3, rows = '<br>None')
            else:
                db_ex("select * from login where user = '" + db_pas(name) + "' order by today desc")
                row = db_get()
                if(row):
                    i = 0
                    c = '<div><table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;">유저</td><td style="text-align: center;width:33.33%;">아이피</td><td style="text-align: center;width:33.33%;">언제</td></tr>'
                    while(True):
                        try:
                            c += '<tr><td style="text-align: center;width:33.33%;">' + row[i]['user'] + '</td><td style="text-align: center;width:33.33%;">' + row[i]['ip'] + '</td><td style="text-align: center;width:33.33%;">' + row[i]['today'] + '</td></tr>'

                            i += 1
                        except:
                            c += '</tbody></table></div>'
                            
                            break
                        
                    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '다중 검사', logo = set_data['name'], tn = 3, rows = c)
                else:
                    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '다중 검사', logo = set_data['name'], tn = 3, rows = '<br>None')
        else:
            return redirect('/error/3')
                
@route('/register', method=['POST', 'GET'])
def register():
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    ban = ban_check(ip)
    
    if(request.method == 'POST'):        
        if(request.forms.pw == request.forms.pw2):
            if(ban == 1):
                return redirect('/ban')
            else:
                m = re.search('(?:[^A-Za-zㄱ-힣0-9 ])', request.forms.id)
                if(m):
                    return redirect('/error/8')
                else:
                    if(len(request.forms.id) > 20):
                        return redirect('/error/7')
                    else:
                        db_ex("select * from user where id = '" + db_pas(request.forms.id) + "'")
                        rows = db_get()
                        if(rows):
                            return redirect('/error/6')
                        else:
                            hashed = bcrypt.hashpw(bytes(request.forms.pw, 'utf-8'), bcrypt.gensalt())
                            
                            db_ex("select * from user limit 1")
                            user_ex = db_get()
                            if(not user_ex):
                                db_ex("insert into user (id, pw, acl) value ('" + db_pas(request.forms.id) + "', '" + db_pas(hashed.decode()) + "', 'owner')")
                            else:
                                db_ex("insert into user (id, pw, acl) value ('" + db_pas(request.forms.id) + "', '" + db_pas(hashed.decode()) + "', 'user')")
                            db_com()
                            
                            return redirect('/login')
        else:
            return redirect('/error/20')
    else:        
        if(ban == 1):
            return redirect('/ban')
        else:
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '회원가입', enter = '회원가입', logo = set_data['name'], tn = 15)
            
@route('/logout')
def logout():
    session = request.environ.get('beaker.session')
    session['Now'] = False
    session.pop('DREAMER', None)
    session.pop('Daydream', None)

    return redirect('/user')
    
@route('/ban/<name:path>', method=['POST', 'GET'])
def user_ban(name = None):
    session = request.environ.get('beaker.session')
    db_ex("select * from user where id = '" + db_pas(name) + "'")
    user = db_get()
    if(user and not user[0]['acl'] == 'user'):
        return redirect('/error/4')
    else:
        if(request.method == 'POST'):
            if(admin_check(1, session) == 1):
                ip = ip_check(session)
                
                if(not re.search("[0-9]{4}-[0-9]{2}-[0-9]{2}", request.forms.end)):
                    end = ''
                else:
                    end = request.forms.end

                db_ex("select * from ban where block = '" + db_pas(name) + "'")
                row = db_get()
                if(row):
                    rb_plus(name, '해제', get_time(), ip, '')
                    
                    db_ex("delete from ban where block = '" + db_pas(name) + "'")
                else:
                    b = re.search("^([0-9]{1,3}\.[0-9]{1,3})$", name)
                    if(b):
                        rb_plus(name, end, get_time(), ip, request.forms.why)
                        
                        db_ex("insert into ban (block, end, why, band) value ('" + db_pas(name) + "', '" + db_pas(end) + "', '" + db_pas(request.forms.why) + "', 'O')")
                    else:
                        rb_plus(name, end, get_time(), ip, request.forms.why)
                        
                        db_ex("insert into ban (block, end, why, band) value ('" + db_pas(name) + "', '" + db_pas(end) + "', '" + db_pas(request.forms.why) + "', '')")
                db_com()
                
                return redirect('/')
            else:
                return redirect('/error/3')
        else:
            if(admin_check(1, session) == 1):
                db_ex("select * from ban where block = '" + db_pas(name) + "'")
                row = db_get()
                if(row):
                    now = '차단 해제'
                else:
                    b = re.search("^([0-9]{1,3}\.[0-9]{1,3})$", name)
                    if(b):
                        now = '대역 차단'
                    else:
                        now = '차단'
                        
                return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, page = url_pas(name), logo = set_data['name'], tn = 16, now = now, today = get_time(), sub = '차단')
            else:
                return redirect('/error/3')
                
@route('/acl/<name:path>', method=['POST', 'GET'])
def acl(name = None):
    session = request.environ.get('beaker.session')
    if(request.method == 'POST'):
        if(admin_check(5, session) == 1):
            db_ex("select acl from data where title = '" + db_pas(name) + "'")
            row = db_get()
            if(row):
                if(request.forms.select == 'admin'):
                   db_ex("update data set acl = 'admin' where title = '" + db_pas(name) + "'")
                elif(request.forms.select == 'user'):
                    db_ex("update data set acl = 'user' where title = '" + db_pas(name) + "'")
                else:
                    db_ex("update data set acl = '' where title = '" + db_pas(name) + "'")
                    
                db_com()
                
            return redirect('/w/' + url_pas(name)) 
        else:
            return redirect('/error/3')
    else:
        if(admin_check(5, session) == 1):
            db_ex("select acl from data where title = '" + db_pas(name) + "'")
            row = db_get()
            if(row):
                if(row[0]['acl'] == 'admin'):
                    now = '관리자만'
                elif(row[0]['acl'] == 'user'):
                    now = '로그인 이상'
                else:
                    now = '일반'
                    
                return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, page = url_pas(name), logo = set_data['name'], tn = 19, now = '현재 ACL 상태는 ' + now, sub = 'ACL')
            else:
                return redirect('/w/' + url_pas(name)) 
        else:
            return redirect('/error/3')
            
@route('/admin/<name:path>', method=['POST', 'GET'])
def user_admin(name = None):
    session = request.environ.get('beaker.session')
    if(request.method == 'POST'):
        if(admin_check(None, session) == 1):
            db_ex("select * from user where id = '" + db_pas(name) + "'")
            user = db_get()
            if(user):
                if(not user[0]['acl'] == 'user'):
                    db_ex("update user set acl = 'user' where id = '" + db_pas(name) + "'")
                else:
                    db_ex("update user set acl = '" + db_pas(request.forms.select) + "' where id = '" + db_pas(name) + "'")
                db_com()
                
                return redirect('/')
            else:
                return redirect('/error/5')
        else:
            return redirect('/error/3')
    else:
        if(admin_check(None, session) == 1):
            db_ex("select * from user where id = '" + db_pas(name) + "'")
            user = db_get()
            if(user):
                if(not user[0]['acl'] == 'user'):
                    now = '권한 해제'
                else:
                    now = '권한 부여'
                    
                div = ''
                    
                db_ex('select name from alist order by name asc')
                get_alist = db_get()
                if(get_alist):
                    i = 0
                    name_rem = ''
                    while(True):
                        try:
                            if(not name_rem == get_alist[i]['name']):
                                name_rem = get_alist[i]['name']
                                div += '<option value="' + get_alist[i]['name'] + '" selected="selected">' + get_alist[i]['name'] + '</option>'
                            i += 1
                        except:
                            break                            
                    
                return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, page = url_pas(name), datalist = div, logo = set_data['name'], tn = 18, now = now, sub = '권한 부여')
            else:
                return redirect('/error/5')
        else:
            return redirect('/error/3')
            
@route('/ban')
def are_you_ban():
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    
    if(ban_check(ip) == 1):
        db_ex("select * from ban where block = '" + db_pas(ip) + "'")
        rows = db_get()
        if(rows):
            if(rows[0]['end']):
                end = rows[0]['end'] + ' 까지 차단 상태 입니다. / 사유 : ' + rows[0]['why']                
                now = get_time()
                
                now = re.sub(':', '', now)
                now = re.sub('\-', '', now)
                now = re.sub(' ', '', now)
                now = int(now)
                
                day = rows[0]['end']
                day = re.sub('\-', '', day)    
                
                if(now >= int(day + '000000')):
                    db_ex("delete from ban where block = '" + db_pas(ip) + "'")
                    db_com()
                    
                    end = '차단이 풀렸습니다. 다시 시도 해 보세요.'
            else:
                end = '영구 차단 상태 입니다. / 사유 : ' + rows[0]['why']
        else:
            b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))", ip)
            if(b):
                results = b.groups()
                
                db_ex("select * from ban where block = '" + db_pas(results[0]) + "' and band = 'O'")
                row = db_get()
                if(row):
                    if(row[0]['end']):
                        end = row[0]['end'] + ' 까지 차단 상태 입니다. / 사유 : ' + rows[0]['why']             
                        
                        now = get_time()
                        now = re.sub(':', '', now)
                        now = re.sub('\-', '', now)
                        now = re.sub(' ', '', now)
                        now = int(now)    
                        
                        day = row[0]['end']
                        day = re.sub('\-', '', day)
                        
                        if(now >= int(day + '000000')):
                            db_ex("delete from ban where block = '" + db_pas(results[0]) + "' and band = 'O'")
                            db_com()
                            
                            end = '차단이 풀렸습니다. 다시 시도 해 보세요.'
                    else:
                        end = '영구 차단 상태 입니다. / 사유 : ' + row[0]['why']                
    else:
        end = '권한이 맞지 않는 상태 입니다.'
        
    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '권한 오류', logo = set_data['name'], data = end)
    
@route('/w/<name:path>/r/<a:int>/diff/<b:int>')
def diff_data(name = None, a = None, b = None):
    session = request.environ.get('beaker.session')
    db_ex("select * from history where id = '" + db_pas(str(a)) + "' and title = '" + db_pas(name) + "'")
    a_raw_data = db_get()
    if(a_raw_data):
        db_ex("select * from history where id = '" + db_pas(str(b)) + "' and title = '" + db_pas(name) + "'")
        b_raw_data = db_get()
        if(b_raw_data):
            a_data = re.sub('<', '&lt;', a_raw_data[0]['data'])
            a_data = re.sub('>', '&gt;', a_data)
            a_data = re.sub('"', '&quot;', a_data)
            
            b_data = re.sub('<', '&lt;', b_raw_data[0]['data'])
            b_data = re.sub('>', '&gt;', b_data)
            b_data = re.sub('"', '&quot;', b_data)
            
            diff_data = difflib.SequenceMatcher(None, a_data, b_data)
            result = diff(diff_data)
            
            result = '<pre>' + result + '</pre>'
            
            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], data = result, sub = '비교', page = url_pas(name))
        else:
            return redirect('/history/' + url_pas(name))
    else:
        return redirect('/history/' + url_pas(name))

@route('/w/<name:path>')
@route('/w/<name:path>/from/<redirect:path>')
def read_view(name = None, redirect = None):
    session = request.environ.get('beaker.session')
    i = 0
    
    db_ex("select * from rd where title = '" + db_pas(name) + "' order by date asc")
    rows = db_get()
    while(True):
        try:
            a = rows[i]
        except:
            topic = ""
            break
            
        db_ex("select * from stop where title = '" + db_pas(rows[i]['title']) + "' and sub = '" + db_pas(rows[i]['sub']) + "' and close = 'O'")
        row = db_get()
        if(not row):
            topic = "open"
            break
        else:
            i += 1
            
    acl = ''
    
    m = re.search("^(.*)\/(.*)$", name)
    if(m):
        g = m.groups()
        uppage = g[0]
        style = ""
    else:
        uppage = ""
        style = "display:none;"
        
    if(admin_check(5, session) == 1):
        admin_memu = 'ACL'
    else:
        admin_memu = ''
    
    if(re.search("^분류:", name)):
        db_ex("select * from cat where title = '" + db_pas(name) + "' order by cat asc")
        rows = db_get()
        if(rows):
            div = ''
            i = 0
            
            while(True):
                try:
                    a = rows[i]
                except:
                    break
                    
                db_ex("select * from data where title = '" + db_pas(rows[i]['cat']) + "'")
                row = db_get()
                if(row):
                    aa = row[0]['data']                  
                    aa = namumark(session, '', aa)
                    bb = re.search('<div style="width:100%;border: 1px solid #777;padding: 5px;margin-top: 1em;">분류:((?:(?!<\/div>).)*)<\/div>', aa)
                    if(bb):
                        cc = bb.groups()
                        
                        mm = re.search("^분류:(.*)", name)
                        if(mm):
                            ee = mm.groups()
                            
                            if(re.search("<a (class=\"not_thing\")? href=\"\/w\/" + url_pas(name) + "\">" + ee[0] + "<\/a>", cc[0])):
                                div += '<li><a href="/w/' + url_pas(rows[i]['cat']) + '">' + rows[i]['cat'] + '</a></li>'
                                
                                i += 1
                            else:
                                db_ex("delete from cat where title = '" + db_pas(name) + "' and cat = '" + db_pas(rows[i]['cat']) + "'")
                                db_com()
                                
                                i += 1
                        else:
                            db_ex("delete from cat where title = '" + db_pas(name) + "' and cat = '" + db_pas(rows[i]['cat']) + "'")
                            db_com()
                            
                            i += 1
                    else:
                        db_ex("delete from cat where title = '" + db_pas(name) + "' and cat = '" + db_pas(rows[i]['cat']) + "'")
                        db_com()
                        
                        i += 1
                else:
                    db_ex("delete from cat where title = '" + db_pas(name) + "' and cat = '" + db_pas(rows[i]['cat']) + "'")
                    db_com()
                    
                    i += 1
                    
            div = '<h2>분류</h2>' + div
        else:
            div = ''
    else:
        div = ''
    
    db_ex("select * from data where title = '" + db_pas(name) + "'")
    rows = db_get()
    if(rows):
        if(rows[0]['acl'] == 'admin'):
            acl = '(관리자)'
        elif(rows[0]['acl'] == 'user'):
            acl = '(로그인)'
        else:
            if(not acl):
                acl = ''

        m = re.search("^사용자:(.*)", name)
        if(m):
            g = m.groups()
            
            db_ex("select * from user where id = '" + db_pas(g[0]) + "'")
            test = db_get()
            if(test):
                if(test[0]['acl'] == 'owner'):
                    acl = '(소유자)'
                elif(test[0]['acl'] == 'admin'):
                    acl = '(관리자)'

            db_ex("select * from ban where block = '" + db_pas(g[0]) + "'")
            user = db_get()
            if(user):
                elsedata = '{{{#!wiki style="border:2px solid red;padding:10px;"\r\n{{{+2 {{{#red 이 사용자는 차단 당했습니다.}}}}}}\r\n\r\n차단 해제 일 : ' + user[0]['end'] + '[br]사유 : ' + user[0]['why'] + '}}}[br]' + rows[0]['data']
            else:
                elsedata = rows[0]['data']
        else:
            elsedata = rows[0]['data']
                
        if(redirect):
            elsedata = re.sub("^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)", " * [[\g<in>]] 문서로 넘겨주기", elsedata)
                
        enddata = namumark(session, name, elsedata)
        
        m = re.search('<div id="toc">((?:(?!\/div>).)*)<\/div>', enddata)
        if(m):
            result = m.groups()
            left = result[0]
        else:
            left = ''
            
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), data = enddata + div, tn = 1, acl = acl, left = left, uppage = uppage, style = style, topic = topic, redirect = redirect, admin = admin_memu)
    else:
        m = re.search("^사용자:(.*)", name)
        if(m):
            g = m.groups()
            
            db_ex("select * from ban where block = '" + db_pas(g[0]) + "'")
            user = db_get()
            if(user):
                elsedata = '{{{#!wiki style="border:2px solid red;padding:10px;"\r\n{{{+2 {{{#red 이 사용자는 차단 당했습니다.}}}}}}\r\n\r\n차단 해제 일 : ' + user[0]['end'] + '[br]사유 : ' + user[0]['why'] + '}}}[br]' + 'None'
            else:
                elsedata = 'None'
        else:
            elsedata = 'None'
            
        if(redirect):
            elsedata = re.sub("^#(?:redirect|넘겨주기)\s(?P<in>[^\n]*)", " * [[\g<in>]] 문서로 넘겨주기", elsedata)
        
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = name, logo = set_data['name'], page = url_pas(name), data = namumark(session, name, elsedata) + div, tn = 1, uppage = uppage, style = style, acl = acl, topic = topic, redirect = redirect, admin = admin_memu, data_none = True)

@route('/user/<name:path>/topic/<num:int>')
def close_topic_list(name = None, num = None):
    session = request.environ.get('beaker.session')
    v = num * 50
    i = v - 50
    ydmin = admin_check(1, session)
    div = '<div><table style="width: 100%;"><tbody><tr><td style="text-align: center;width:33.33%;">토론명</td><td style="text-align: center;width:33.33%;">작성자</td><td style="text-align: center;width:33.33%;">시간</td></tr>'
    
    db_ex("select * from topic where ip = '" + db_pas(name) + "' or ip = '" + db_pas(name) + " - Admin' order by date desc")
    rows = db_get()
    if(rows):
        while(True):
            try:                    
                title = rows[i]['title']
                title = re.sub('<', '&lt;', title)
                title = re.sub('>', '&gt;', title)

                sub = rows[i]['sub']
                sub = re.sub('<', '&lt;', sub)
                sub = re.sub('>', '&gt;', sub)
                    
                if(ydmin == 1):
                    db_ex("select * from ban where block = '" + db_pas(rows[i]['ip']) + "'")
                    row = db_get()
                    if(row):
                        ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(해제)</a>'
                    else:
                        ban = ' <a href="/ban/' + url_pas(rows[i]['ip']) + '">(차단)</a>'
                else:
                    ban = ''
                    
                ip = ip_pas(rows[i]['ip'], 1)
                    
                div += '<tr><td style="text-align: center;width:33.33%;"><a href="/topic/' + url_pas(rows[i]['title']) + '/sub/' + url_pas(sub) + '#' + rows[i]['id'] + '">' + title + '</a> (' + sub + ') (#' + rows[i]['id'] + ') </td><td style="text-align: center;width:33.33%;">' + ip + ban +  '</td><td style="text-align: center;width:33.33%;">' + rows[i]['date'] + '</td></tr>'
                
                if(i == v):
                    div = div + '</tbody></table></div>'
                    if(num == 1):
                        div += '<br><a href="/user/' + url_pas(name) + '/topic/' + str(num + 1) + '">(다음)</a>'
                    else:
                        div += '<br><a href="/user/' + url_pas(name) + '/topic/' + str(num - 1) + '">(이전)</a> <a href="/user/' + url_pas(name) + '/topic/' + str(num + 1) + '">(다음)</a>'
                    break

                i += 1
            except:
                div += '</tbody></table></div>'

                if(num != 1):
                    div += '<br><a href="/user/' + url_pas(name) + '/topic/' + str(num - 1) + '">(이전)</a>'

                break
                
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = div, tn = 3, title = '사용자 토론 기록')
    else:
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), logo = set_data['name'], rows = '<br>None', tn = 3, title = '사용자 토론 기록')
        
@route('/user')
def user_info():
    session = request.environ.get('beaker.session')
    ip = ip_check(session)
    raw_ip = ip
    
    db_ex("select * from user where id = '" + db_pas(ip) + "'")
    rows = db_get()
    if(ban_check(ip) == 0):
        if(rows):
            if(not rows[0]['acl'] == 'user'):
                acl = rows[0]['acl']
            else:
                acl = '로그인'
        else:
            acl = '일반'
    else:
        acl = '차단'
        
    ip = ip_pas(ip, 2)
        
    return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '사용자 메뉴', logo = set_data['name'], data = ip + '<br><br><span>권한 상태 : ' + acl + '<h2>로그인 관련</h2><li><a href="/login">로그인</a></li><li><a href="/logout">로그아웃</a></li><li><a href="/register">회원가입</a></li><h2>기타</h2><li><a href="/change">비밀번호 변경</a></li><li><a href="/count">기여 횟수</a></li><li><a href="/record/' + raw_ip + '/n/1">기여 목록</a></li><li><a href="/custom">커스텀 CSS</a></li>')

@route('/custom', method=['GET', 'POST'])
def custom_css():
    session = request.environ.get('beaker.session')
    if(not session.get('Now') == True):
        return redirect('/login')
    else:
        ip = ip_check(session)

        if(request.method == 'POST'):
            db_ex("select * from custom where user = '" + db_pas(ip) + "'")
            css_data = db_get()
            if(css_data):
                db_ex("update custom set css = '" + db_pas(request.forms.content) + "' where user = '" + db_pas(ip) + "'")
            else:
                db_ex("insert into custom (user, css) value ('" + db_pas(ip) + "', '" + db_pas(request.forms.content) + "')")
            db_com()

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

            return redirect('/user')
        else:
            db_ex("select * from custom where user = '" + db_pas(ip) + "'")
            css_data = db_get()
            if(css_data):
                data = css_data[0]['css']
            else:
                data = ''

            return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '커스텀 CSS', logo = set_data['name'], data = '<form id="usrform" name="f1" method="POST" action="/custom"><textarea rows="30" cols="100" name="content" form="usrform">' + data + '</textarea><div class="form-actions"><button class="btn btn-primary" type="submit">저장</button></div></form>')
    
@route('/count')
def count_edit():
    session = request.environ.get('beaker.session')
    db_ex("select count(title) from history where ip = '" + ip_check(session) + "'")
    i = db_get()
    if(i):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '기여 횟수', logo = set_data['name'], data = "기여 횟수 : " + str(i[0]["count(title)"]))
    else:
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '기여 횟수', logo = set_data['name'], data = "기여 횟수 : 0")
        
@route('/random')
def random():
    session = request.environ.get('beaker.session')
    db_ex("select title from data order by rand() limit 1")
    rows = db_get()
    if(rows):
        return redirect('/w/' + url_pas(rows[0]['title']))
    else:
        return redirect('/')

@route('/static/<name:path>')
def static(name = None):
    session = request.environ.get('beaker.session')
    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 = './static' + plus)
        
@route('/error/<num:int>')
def error_test(num = None):
    session = request.environ.get('beaker.session')
    if(num == 1):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '권한 오류', logo = set_data['name'], data = '비 로그인 상태 입니다.')
    elif(num == 2):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '권한 오류', logo = set_data['name'], data = '이 계정이 없습니다.')
    elif(num == 3):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '권한 오류', logo = set_data['name'], data = '권한이 모자랍니다.')
    elif(num == 4):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '권한 오류', logo = set_data['name'], data = '관리자는 차단, 검사 할 수 없습니다.')
    elif(num == 5):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '사용자 오류', logo = set_data['name'], data = '그런 계정이 없습니다.')
    elif(num == 6):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '가입 오류', logo = set_data['name'], data = '동일한 아이디의 사용자가 있습니다.')
    elif(num == 7):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '가입 오류', logo = set_data['name'], data = '아이디는 20글자보다 짧아야 합니다.')
    elif(num == 8):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '가입 오류', logo = set_data['name'], data = '아이디에는 한글과 알파벳과 공백만 허용 됩니다.')
    elif(num == 9):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '변경 오류', logo = set_data['name'], data = '그런 계정이 없습니다.')
    elif(num == 10):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '변경 오류', logo = set_data['name'], data = '비밀번호가 다릅니다.')
    elif(num == 11):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '로그인 오류', logo = set_data['name'], data = '이미 로그인 되어 있습니다.')
    elif(num == 12):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '로그인 오류', logo = set_data['name'], data = '그런 계정이 없습니다.')
    elif(num == 13):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '로그인 오류', logo = set_data['name'], data = '비밀번호가 다릅니다.')
    elif(num == 14):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '업로드 오류', logo = set_data['name'], data = 'jpg, gif, jpeg, png(대 소문자 상관 없음)만 가능 합니다.')
    elif(num == 15):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '편집 오류', logo = set_data['name'], data = '편집 기록은 500자를 넘을 수 없습니다.')
    elif(num == 16):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '업로드 오류', logo = set_data['name'], data = '동일한 이름의 파일이 있습니다.')
    elif(num == 17):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '업로드 오류', logo = set_data['name'], data = '파일 용량은 ' + set_data['upload'] + 'MB를 넘길 수 없습니다.')
    elif(num == 18):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '편집 오류', logo = set_data['name'], data = '내용이 원래 문서와 동일 합니다.')
    elif(num == 19):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '이동 오류', logo = set_data['name'], data = '이동 하려는 곳에 문서가 이미 있습니다.')
    elif(num == 20):
        return template('index', custom = custom_css_user(session), license = set_data['license'], login = login_check(session), title = '비밀번호 오류', logo = set_data['name'], data = '재 확인이랑 비밀번호가 다릅니다.')
    else:
        return redirect('/')

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