((?:(?!\/div>).)*)<\/div>', enddata)
if(m):
result = m.groups()
left = result[0]
else:
left = ''
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, tn = 6, left = left, sub = '옛 문서')
else:
return '
'
else:
return '
'
else:
db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
rows = db_get()
if(rows):
enddata = namumark(name, rows[0]['data'])
m = re.search('
((?:(?!\/div>).)*)<\/div>', enddata)
if(m):
result = m.groups()
left = result[0]
else:
left = ''
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, tn = 6, left = left, sub = '옛 문서')
else:
return '
'
@app.route('/w/
/raw/')
def old_raw(name = None, num = None):
db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
row = db_get()
if(row):
if(owner_check() == 1):
db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
rows = db_get()
if(rows):
enddata = re.sub('<', '<', rows[0]['data'])
enddata = re.sub('>', '>', enddata)
enddata = re.sub('"', '"', enddata)
enddata = '' + enddata + '
'
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, sub = '옛 Raw')
else:
return ''
else:
return ''
else:
db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
rows = db_get()
if(rows):
enddata = re.sub('<', '<', rows[0]['data'])
enddata = re.sub('>', '>', enddata)
enddata = re.sub('"', '"', enddata)
enddata = '' + enddata + '
'
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, sub = '옛 Raw')
else:
return ''
@app.route('/raw/')
def raw_view(name = None):
db_ex("select * from data where title = '" + db_pas(name) + "'")
rows = db_get()
if(rows):
enddata = re.sub('<', '<', rows[0]['data'])
enddata = re.sub('>', '>', enddata)
enddata = re.sub('"', '"', enddata)
enddata = '' + enddata + '
'
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = enddata, tn = 7, sub = 'Raw')
else:
return ''
@app.route('/revert//r/', methods=['POST', 'GET'])
def revert(name = None, num = None):
ip = ip_check()
can = acl_check(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(owner_check() == 1):
db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
rows = db_get()
if(rows):
if(can == 1):
return ''
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 ''
else:
return ''
else:
return ''
else:
db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
rows = db_get()
if(rows):
if(can == 1):
return ''
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 ''
else:
return ''
else:
db_ex("select * from hidhi where title = '" + db_pas(name) + "' and re = '" + db_pas(str(num)) + "'")
row = db_get()
if(row):
if(owner_check() == 1):
if(can == 1):
return ''
else:
db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
rows = db_get()
if(rows):
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), r = url_pas(str(num)), tn = 13, plus = '정말 되돌리시겠습니까?', sub = '되돌리기')
else:
return ''
else:
return ''
else:
if(can == 1):
return ''
else:
db_ex("select * from history where title = '" + db_pas(name) + "' and id = '" + str(num) + "'")
rows = db_get()
if(rows):
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), r = url_pas(str(num)), tn = 13, plus = '정말 되돌리시겠습니까?', sub = '되돌리기')
else:
return ''
@app.route('/edit/', methods=['POST', 'GET'])
def edit(name = None):
ip = ip_check()
can = acl_check(ip, name)
if(request.method == 'POST'):
m = re.search('(?:[^A-Za-zㄱ-힣0-9 ])', request.form["send"])
if(m):
return ''
else:
today = get_time()
content = savemark(request.form["content"])
db_ex("select * from data where title = '" + db_pas(name) + "'")
rows = db_get()
if(rows):
if(rows[0]['data'] == content):
return ''
else:
if(can == 1):
return ''
else:
leng = leng_check(len(rows[0]['data']), len(content))
history_plus(name, content, today, ip, request.form["send"], leng)
db_ex("update data set data = '" + db_pas(content) + "' where title = '" + db_pas(name) + "'")
db_com()
else:
if(can == 1):
return ''
else:
leng = '+' + str(len(content))
history_plus(name, content, today, ip, request.form["send"], leng)
db_ex("insert into data (title, data, acl) value ('" + db_pas(name) + "', '" + db_pas(content) + "', '')")
db_com()
include_check(name, content)
return ''
else:
if(can == 1):
return ''
else:
db_ex("select * from data where title = '" + db_pas(set_data["help"]) + "'")
rows = db_get()
if(rows):
newdata = re.sub('^#(?:[Rr][Ee][Dd][Ii][Rr][Ee][Cc][Tt]|넘겨주기)\s(?P[^\n]*)', ' * [[\g]] 문서로 넘겨주기', rows[0]["data"])
left = namumark(name, newdata)
else:
left = ''
db_ex("select * from data where title = '" + db_pas(name) + "'")
rows = db_get()
if(rows):
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = rows[0]['data'], tn = 2, left = left, sub = '편집')
else:
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = '', tn = 2, left = left, sub = '편집')
@app.route('/edit//section/', methods=['POST', 'GET'])
def section_edit(name = None, num = None):
ip = ip_check()
can = acl_check(ip, name)
if(request.method == 'POST'):
m = re.search('(?:[^A-Za-zㄱ-힣0-9 ])', request.form["send"])
if(m):
return ''
else:
today = get_time()
content = savemark(request.form["content"])
db_ex("select * from data where title = '" + db_pas(name) + "'")
rows = db_get()
if(rows):
if(request.form["otent"] == content):
return ''
else:
if(can == 1):
return ''
else:
leng = leng_check(len(request.form['otent']), len(content))
content = rows[0]['data'].replace(request.form['otent'], content)
history_plus(name, content, today, ip, request.form["send"], leng)
db_ex("update data set data = '" + db_pas(content) + "' where title = '" + db_pas(name) + "'")
db_com()
include_check(name, content)
return ''
else:
return ''
else:
if(can == 1):
return ''
else:
db_ex("select * from data where title = '" + db_pas(set_data["help"]) + "'")
rows = db_get()
if(rows):
newdata = re.sub('^#(?:[Rr][Ee][Dd][Ii][Rr][Ee][Cc][Tt]|넘겨주기)\s(?P[^\n]*)', ' * [[\g]] 문서로 넘겨주기', rows[0]["data"])
left = namumark(name, newdata)
else:
left = ''
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):
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = gdata, tn = 2, left = left, section = 1, number = num, sub = '편집')
else:
return ''
else:
return ''
@app.route('/preview/', methods=['POST'])
def preview(name = None):
ip = ip_check()
can = acl_check(ip, name)
if(can == 1):
return ''
else:
newdata = request.form["content"]
newdata = re.sub('^#(?:[Rr][Ee][Dd][Ii][Rr][Ee][Cc][Tt]|넘겨주기)\s(?P[^\n]*)', ' * [[\g]] 문서로 넘겨주기', newdata)
enddata = namumark(name, newdata)
db_ex("select * from data where title = '" + db_pas(data["help"]) + "'")
rows = db_get()
if(rows):
newdata = re.sub('^#(?:[Rr][Ee][Dd][Ii][Rr][Ee][Cc][Tt]|넘겨주기)\s(?P[^\n]*)', ' * [[\g]] 문서로 넘겨주기', rows[0]["data"])
left = namumark(name, newdata)
else:
left = ''
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = request.form["content"], tn = 2, preview = 1, enddata = enddata, left = left, sub = '미리보기')
@app.route('/preview//section/', methods=['POST'])
def section_preview(name = None, num = None):
ip = ip_check()
can = acl_check(ip, name)
if(can == 1):
return ''
else:
newdata = request.form["content"]
newdata = re.sub('^#(?:[Rr][Ee][Dd][Ii][Rr][Ee][Cc][Tt]|넘겨주기)\s(?P[^\n]*)', ' * [[\g]] 문서로 넘겨주기', newdata)
enddata = namumark(name, newdata)
db_ex("select * from data where title = '" + db_pas(data["help"]) + "'")
rows = db_get()
if(rows):
newdata = re.sub('^#(?:[Rr][Ee][Dd][Ii][Rr][Ee][Cc][Tt]|넘겨주기)\s(?P[^\n]*)', ' * [[\g]] 문서로 넘겨주기', rows[0]["data"])
left = namumark(name, newdata)
else:
left = ''
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), data = request.form["content"], tn = 2, preview = 1, enddata = enddata, left = left, section = 1, number = num, odata = request.form["otent"], sub = '미리보기')
@app.route('/delete/', methods=['POST', 'GET'])
def delete(name = None):
ip = ip_check()
can = acl_check(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 ''
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 ''
else:
return ''
else:
db_ex("select * from data where title = '" + db_pas(name) + "'")
rows = db_get()
if(rows):
if(can == 1):
return ''
else:
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), tn = 8, plus = '정말 삭제 하시겠습니까?', sub = '삭제')
else:
return ''
@app.route('/move/', methods=['POST', 'GET'])
def move(name = None):
ip = ip_check()
can = acl_check(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 ''
else:
leng = '0'
db_ex("select * from history where title = '" + db_pas(request.form["title"]) + "'")
row = db_get()
if(row):
return ''
else:
history_plus(name, rows[0]['data'], today, ip, '' + name + ' 문서를 ' + request.form["title"] + ' 문서로 이동 했습니다.', leng)
if(rows):
db_ex("update data set title = '" + db_pas(request.form["title"]) + "' where title = '" + db_pas(name) + "'")
db_ex("update history set title = '" + db_pas(request.form["title"]) + "' where title = '" + db_pas(name) + "'")
db_com()
return ''
else:
if(can == 1):
return ''
else:
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], page = url_pas(name), tn = 9, plus = '정말 이동 하시겠습니까?', sub = '이동')
@app.route('/other')
def other():
return web_render('index.html', login = login_check(), title = '기타 메뉴', logo = set_data['name'], data = '기록
유저 차단 기록유저 가입 기록유저 기록기타
모든 문서업로드관리자 목록관리자 메뉴
이 오픈나무의 버전은 1.9.1 입니다.')
@app.route('/manager/', methods=['POST', 'GET'])
def manager(num = None):
if(num == 1):
return web_render('index.html', login = login_check(), title = '관리자 메뉴', logo = set_data['name'], data = '관리자 및 소유자
문서 ACL유저 체크유저 차단소유자
모든 역링크 재 생성관리자 권한 주기기타
이 메뉴에 없는 기능은 해당 문서의 역사나 토론에서 바로 사용 가능함')
elif(num == 2):
if(request.method == 'POST'):
return ''
else:
return web_render('index.html', login = login_check(), title = 'ACL 이동', logo = set_data['name'], data = '')
elif(num == 3):
if(request.method == 'POST'):
return ''
else:
return web_render('index.html', login = login_check(), title = '체크 이동', logo = set_data['name'], data = '')
elif(num == 4):
if(request.method == 'POST'):
return ''
else:
return web_render('index.html', login = login_check(), title = '차단 이동', logo = set_data['name'], data = '')
elif(num == 5):
if(request.method == 'POST'):
return ''
else:
return web_render('index.html', login = login_check(), title = '권한 이동', logo = set_data['name'], data = '')
elif(num == 6):
if(request.method == 'POST'):
return ''
else:
return web_render('index.html', login = login_check(), title = '기록 이동', logo = set_data['name'], data = '')
else:
return ''
@app.route('/titleindex')
def title_index():
i = 0
data = ''
db_ex("select title from data order by title asc")
title_list = db_get()
if(title_list):
while(True):
try:
a = title_list[i]
except:
break
data = data + '
' + str(i + 1) + '. ' + title_list[i]['title'] + ''
i += 1
data = data + '
'
return web_render('index.html', login = login_check(), logo = set_data['name'], rows = data + '
이 위키에는 총 ' + str(i) + '개의 문서가 있습니다.', tn = 4, title = '모든 문서')
else:
return web_render('index.html', login = login_check(), logo = set_data['name'], rows = '', tn = 4, title = '모든 문서')
@app.route('/topic/', methods=['POST', 'GET'])
def topic_list(name = None):
if(request.method == 'POST'):
return ''
else:
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:
a = rows[i]
except:
div = div + '
'
break
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(name, aa[0]['data'])
if(aa[0]['block'] == 'O'):
indata = '블라인드 되었습니다.'
block = 'style="background: gainsboro;"'
else:
block = ''
ip = ip_pas(aa[0]['ip'])
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 = div + '| #1 ' + ip + ' ' + aa[0]['date'] + ' |
| ' + indata + ' |
'
j += 1
i += 1
return web_render('index.html', login = login_check(), title = name, page = url_pas(name), logo = set_data['name'], plus = div, tn = 10, list = 1, sub = '토론 목록')
@app.route('/topic//close')
def close_topic_list(name = None):
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:
a = rows[i]
except:
div = div + '
'
break
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(name, row[0]['data'])
if(row[0]['block'] == 'O'):
indata = '블라인드 되었습니다.'
block = 'style="background: gainsboro;"'
else:
block = ''
ip = ip_pas(row[0]['ip'])
div = div + '| #1 ' + ip + ' ' + row[0]['date'] + ' |
| ' + indata + ' |
'
i += 1
return web_render('index.html', login = login_check(), title = name, page = url_pas(name), logo = set_data['name'], plus = div, tn = 10, sub = '닫힌 토론')
@app.route('/topic//agree')
def agree_topic_list(name = None):
div = ''
i = 0
db_ex("select * from agreedis where title = '" + db_pas(name) + "' order by sub asc")
agree_list = db_get()
while(True):
try:
a = agree_list[i]
except:
div = div + '
'
break
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(name, data[0]['data'])
if(data[0]['block'] == 'O'):
indata = '블라인드 되었습니다.'
block = 'style="background: gainsboro;"'
else:
block = ''
ip = ip_pas(data[0]['ip'])
div = div + '| #1 ' + 아이디 + ' ' + data[0]['date'] + ' |
| ' + indata + ' |
'
i += 1
return web_render('index.html', login = login_check(), title = name, page = url_pas(name), logo = set_data['name'], plus = div, tn = 10, sub = '합의된 토론')
@app.route('/topic//sub/', methods=['POST', 'GET'])
def topic(name = None, sub = None):
ip = ip_check()
ban = topic_check(ip, name, sub)
admin = admin_check()
if(request.method == 'POST'):
db_ex("select * 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 ''
else:
db_ex("select * from user where id = '" + db_pas(ip) + "'")
rows = db_get()
if(rows):
if(rows[0]['acl'] == 'owner' or rows[0]['acl'] == 'admin'):
ip = ip + ' - Admin'
today = get_time()
rd_plus(name, sub, today)
aa = request.form["content"]
aa = re.sub("\[\[(분류:(?:(?:(?!\]\]).)*))\]\]", "[br]", aa)
aa = savemark(aa)
db_ex("insert into topic (id, title, sub, data, date, ip, block) value ('" + str(number) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "', '" + db_pas(aa) + "', '" + today + "', '" + ip + "', '')")
db_com()
return ''
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 = ''
if(close):
div = div + '
(토론 열기) '
else:
div = div + '
(토론 닫기) '
if(stop):
div = div + '
(토론 재개) '
else:
div = div + '
(토론 정지) '
db_ex("select * from agreedis where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "'")
agree = db_get()
if(agree):
div = div + '
(합의 취소)'
else:
div = div + '
(합의 완료)'
div = div + '
'
else:
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 distop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' order by id+0 asc")
top = db_get()
i = 0
if(top):
while(True):
try:
a = top[i]
except:
break
num = int(top[i]['id']) - 1
if(i == 0):
start = rows[num]['ip']
top_data = namumark('', rows[num]['data'])
top_data = re.sub("(?P
#(?:[0-9]*))", '\g', top_data)
ip = ip_pas(rows[num]['ip'])
div = div + '
'
i = i + 1
i = 0
while(True):
try:
a = rows[i]
except:
div = div + ''
break
if(i == 0):
start = rows[i]['ip']
indata = namumark('', rows[i]['data'])
indata = re.sub("(?P
#(?:[0-9]*))", '\g', indata)
if(rows[i]['block'] == 'O'):
indata = '블라인드 되었습니다.'
block = 'style="background: gainsboro;"'
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 = ' (해제)'
else:
isblock = ' (블라인드)'
db_ex("select * from distop where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' and id = '" + db_pas(str(i + 1)) + "'")
row = db_get()
if(row):
isblock = isblock + ' (해제)'
else:
isblock = isblock + ' (공지)'
n = re.search("\- (?:Admin)$", rows[i]['ip'])
if(n):
ban = isblock
else:
db_ex("select * from ban where block = '" + db_pas(rows[i]['ip']) + "'")
row = db_get()
if(row):
ban = ' (해제)' + isblock
else:
ban = ' (차단)' + isblock
else:
ban = ""
ip = ip_pas(rows[i]['ip'])
if(rows[i]['ip'] == start):
j = i + 1
div = div + '
'
else:
j = i + 1
div = div + '
'
i += 1
return web_render('index.html', login = login_check(), title = name, page = url_pas(name), suburl = url_pas(sub), toron = sub, logo = set_data['name'], rows = div, tn = 11, ban = ban, style = style, sub = '토론')
@app.route('/topic//sub//b/')
def topic_block(name = None, sub = None, num = None):
if(admin_check() == 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 ''
else:
return ''
else:
return ''
@app.route('/topic//sub//notice/')
def topic_top(name = None, sub = None, num = None):
if(admin_check() == 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 distop where id = '" + str(num) + "' and title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "'")
top_data = db_get()
if(top_data):
db_ex("delete from distop where id = '" + str(num) + "' and title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "'")
else:
db_ex("insert into distop (id, title, sub) value ('" + db_pas(str(num)) + "', '" + db_pas(name) + "', '" + db_pas(sub) + "')")
db_com()
rd_plus(name, sub, get_time())
return ''
else:
return ''
else:
return ''
@app.route('/topic//sub//stop')
def topic_stop(name = None, sub = None):
if(admin_check() == 1):
ip = ip_check()
db_ex("select * from topic where title = '" + db_pas(name) + "' and sub = '" + db_pas(sub) + "' 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) 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) 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 ''
else:
return ''
else:
return ''
@app.route('/topic//sub//close')
def topic_close(name = None, sub = None):
if(admin_check() == 1):
ip = ip_check()
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) 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) 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 ''
else:
return ''
else:
return ''
@app.route('/topic//sub//agree')
def topic_agree(name = None, sub = None):
if(admin_check() == 1):
ip = ip_check()
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) 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) 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 ''
else:
return ''
else:
return ''
@app.route('/login', methods=['POST', 'GET'])
def login():
ip = ip_check()
ban = ban_check(ip)
if(request.method == 'POST'):
if(ban == 1):
return ''
else:
db_ex("select * from user where id = '" + db_pas(request.form["id"]) + "'")
user = db_get()
if(user):
if(session.get('Now') == True):
return ''
elif(bcrypt.checkpw(bytes(request.form["pw"], 'utf-8'), bytes(user[0]['pw'], 'utf-8'))):
session['Now'] = True
session['DREAMER'] = request.form["id"]
db_ex("insert into login (user, ip, today) value ('" + db_pas(request.form["id"]) + "', '" + db_pas(ip) + "', '" + db_pas(get_time()) + "')")
db_com()
return ''
else:
return ''
else:
return ''
else:
if(ban == 1):
return ''
else:
if(session.get('Now') == True):
return ''
else:
return web_render('index.html', login = login_check(), title = '로그인', enter = '로그인', logo = set_data['name'], tn = 15)
@app.route('/change', methods=['POST', 'GET'])
def change_password():
ip = ip_check()
ban = ban_check(ip)
if(request.method == 'POST'):
if(request.form["pw2"] == request.form["pw3"]):
if(ban == 1):
return ''
else:
db_ex("select * from user where id = '" + db_pas(request.form["id"]) + "'")
user = db_get()
if(user):
if(session.get('Now') == True):
session['Now'] = False
session.pop('DREAMER', None)
return ''
elif(bcrypt.checkpw(bytes(request.form["pw"], 'utf-8'), bytes(user[0]['pw'], 'utf-8'))):
hashed = bcrypt.hashpw(bytes(request.form["pw2"], 'utf-8'), bcrypt.gensalt())
db_ex("update user set pw = '" + db_pas(hashed.decode()) + "' where id = '" + db_pas(request.form["id"]) + "'")
db_com()
return ''
else:
return ''
else:
return ''
else:
return ''
else:
if(ban == 1):
return ''
else:
if(session.get('Now') == True):
session['Now'] = False
session.pop('DREAMER', None)
return ''
else:
return web_render('index.html', login = login_check(), title = '비밀번호 변경', enter = '변경', logo = set_data['name'], tn = 15)
@app.route('/check/')
def user_check(name = None, sub = None):
db_ex("select * from user where id = '" + db_pas(name) + "'")
user = db_get()
if(user and user[0]['acl'] == 'owner' or user and user[0]['acl'] == 'admin'):
return ''
else:
if(admin_check() == 1):
m = re.search('(?:[0-9](?:[0-9][0-9])?\.[0-9](?:[0-9][0-9])?\.[0-9](?:[0-9][0-9])?\.[0-9](?:[0-9][0-9])?)', name)
if(m):
db_ex("select * from login where ip = '" + db_pas(name) + "' order by today desc")
row = db_get()
if(row):
i = 0
c = ''
while(True):
try:
c = c + '| ' + row[i]['user'] + ' | ' + row[i]['ip'] + ' | ' + row[i]['today'] + ' |
'
except:
break
i += 1
return web_render('index.html', login = login_check(), title = '다중 검사', logo = set_data['name'], tn = 22, rows = c)
else:
return web_render('index.html', login = login_check(), title = '다중 검사', logo = set_data['name'], tn = 22, rows = '')
else:
db_ex("select * from login where user = '" + db_pas(name) + "' order by today desc")
row = db_get()
if(row):
i = 0
c = ''
while(True):
try:
c = c + '| ' + row[i]['user'] + ' | ' + row[i]['ip'] + ' | ' + row[i]['today'] + ' |
'
except:
break
i += 1
return web_render('index.html', login = login_check(), title = '다중 검사', logo = set_data['name'], tn = 22, rows = c)
else:
return web_render('index.html', login = login_check(), title = '다중 검사', logo = set_data['name'], tn = 22, rows = '')
else:
return ''
@app.route('/register', methods=['POST', 'GET'])
def register():
ip = ip_check()
ban = ban_check(ip)
if(request.method == 'POST'):
if(request.form["pw"] == request.form["pw2"]):
if(ban == 1):
return ''
else:
m = re.search('(?:[^A-Za-zㄱ-힣0-9 ])', request.form["id"])
if(m):
return ''
else:
if(len(request.form["id"]) > 20):
return ''
else:
db_ex("select * from user where id = '" + db_pas(request.form["id"]) + "'")
rows = db_get()
if(rows):
return ''
else:
hashed = bcrypt.hashpw(bytes(request.form["pw"], 'utf-8'), bcrypt.gensalt())
if(request.form["id"] == set_data['owner']):
db_ex("insert into user (id, pw, acl) value ('" + db_pas(request.form["id"]) + "', '" + db_pas(hashed.decode()) + "', 'owner')")
else:
db_ex("insert into user (id, pw, acl) value ('" + db_pas(request.form["id"]) + "', '" + db_pas(hashed.decode()) + "', 'user')")
db_com()
return ''
else:
return ''
else:
if(ban == 1):
return ''
else:
return web_render('index.html', login = login_check(), title = '회원가입', enter = '회원가입', logo = set_data['name'], tn = 15)
@app.route('/logout')
def logout():
session['Now'] = False
session.pop('DREAMER', None)
return ''
@app.route('/ban/', methods=['POST', 'GET'])
def user_ban(name = None):
db_ex("select * from user where id = '" + db_pas(name) + "'")
user = db_get()
if(user and user[0]['acl'] == 'owner' or user and user[0]['acl'] == 'admin'):
return ''
else:
if(request.method == 'POST'):
if(admin_check() == 1):
ip = ip_check()
if(not re.search("[0-9]{4}-[0-9]{2}-[0-9]{2}", request.form["end"])):
end = ''
else:
end = request.form["end"]
db_ex("select * from ban where block = '" + db_pas(name) + "'")
row = db_get()
if(row):
rb_plus(name, '해제', 시간(), ip, '')
db_ex("delete from ban where block = '" + db_pas(name) + "'")
else:
b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))$", name)
if(b):
rb_plus(name, end, 시간(), ip, request.form["why"])
db_ex("insert into ban (block, end, why, band) value ('" + db_pas(name) + "', '" + db_pas(end) + "', '" + db_pas(request.form["why"]) + "', 'O')")
else:
rb_plus(name, end, 시간(), ip, request.form["why"])
db_ex("insert into ban (block, end, why, band) value ('" + db_pas(name) + "', '" + db_pas(end) + "', '" + db_pas(request.form["why"]) + "', '')")
db_com()
return ''
else:
return ''
else:
if(admin_check() == 1):
db_ex("select * from ban where block = '" + db_pas(name) + "'")
row = db_get()
if(row):
now = '차단 해제'
else:
b = re.search("^([0-9](?:[0-9]?[0-9]?)\.[0-9](?:[0-9]?[0-9]?))$", name)
if(b):
now = '대역 차단'
else:
now = '차단'
return web_render('index.html', login = login_check(), title = name, page = url_pas(name), logo = set_data['name'], tn = 16, now = now, today = get_time(), sub = '차단')
else:
return ''
@app.route('/acl/', methods=['POST', 'GET'])
def acl(name = None):
if(request.method == 'POST'):
if(admin_check() == 1):
db_ex("select * from data where title = '" + db_pas(name) + "'")
row = db_get()
if(row):
if(request.form["select"] == 'admin'):
db_ex("update data set acl = 'admin' where title = '" + db_pas(name) + "'")
elif(request.form["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 ''
else:
return ''
else:
if(admin_check() == 1):
db_ex("select * 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 web_render('index.html', login = login_check(), title = name, page = url_pas(name), logo = set_data['name'], tn = 19, now = '현재 ACL 상태는 ' + now, sub = 'ACL')
else:
return ''
else:
return ''
@app.route('/admin/', methods=['POST', 'GET'])
def user_admin(name = None):
if(request.method == 'POST'):
if(owner_check() == 1):
db_ex("select * from user where id = '" + db_pas(name) + "'")
user = db_get()
if(user):
if(user[0]['acl'] == 'admin' or user[0]['acl'] == 'owner'):
db_ex("update user set acl = 'user' where id = '" + db_pas(name) + "'")
else:
db_ex("update user set acl = '" + db_pas(request.form["select"]) + "' where id = '" + db_pas(name) + "'")
db_com()
return ''
else:
return ''
else:
return ''
else:
if(owner_check() == 1):
db_ex("select * from user where id = '" + db_pas(name) + "'")
user = db_get()
if(user):
if(user[0]['acl'] == 'admin' or user[0]['acl'] == 'owner'):
now = '권한 해제'
else:
now = '권한 부여'
return web_render('index.html', login = login_check(), title = name, page = url_pas(name), logo = data['name'], tn = 18, now = now, sub = '권한 부여')
else:
return ''
else:
return ''
@app.route('/ban')
def are_you_ban():
ip = ip_check()
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 web_render('index.html', login = login_check(), title = '권한 오류', logo = set_data['name'], data = end), 401
@app.route('/w//r//diff/')
def diff_data(name = None, a = None, b = None):
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('<', '<', a_raw_data[0]['data'])
a_data = re.sub('>', '>', a_data)
a_data = re.sub('"', '"', a_data)
b_data = re.sub('<', '<', b_raw_data[0]['data'])
b_data = re.sub('>', '>', b_data)
b_data = re.sub('"', '"', b_data)
diff_data = difflib.SequenceMatcher(None, a_data, b_data)
result = diff(diff_data)
result = '' + result + '
'
return web_render('index.html', login = login_check(), title = name, logo = set_data['name'], data = result, sub = '비교')
else:
return ''
else:
return ''
@app.route('/user')
def user_info():
ip = ip_check()
raw_ip = ip
db_ex("select * from user where id = '" + db_pas(ip) + "'")
rows = db_get()
if(ban_check(ip) == 0):
if(rows):
if(rows[0]['acl'] == 'admin' or rows[0]['acl'] == 'owner'):
if(rows[0]['acl'] == 'admin'):
acl = '관리자'
else:
acl = '소유자'
else:
acl = '유저'
else:
acl = '일반'
else:
acl = '차단'
ip = ip_pas(ip)
return web_render('index.html', login = login_check(), title = '유저 메뉴', logo = set_data['name'], data = ip + '
권한 상태 : ' + acl + '로그인 관련
로그인로그아웃회원가입기타
비밀번호 변경기여 횟수기여 목록')
@app.route('/count')
def count_edit():
db_ex("select count(title) from history where ip = '" + ip_check() + "'")
i = db_get()
if(i):
return web_render('index.html', login = login_check(), title = '기여 횟수', logo = set_data['name'], data = "기여 횟수 : " + str(i[0]["count(title)"]))
else:
return web_render('index.html', login = login_check(), title = '기여 횟수', logo = set_data['name'], data = "기여 횟수 : 0")
@app.route('/random')
def random():
db_ex("select * from data order by rand() limit 1")
rows = db_get()
if(rows):
return ''
else:
return ''
@app.route('/error/')
def 오류(num = None):
if(num == 1):
return web_render('index.html', login = login_check(), title = '권한 오류', logo = set_data['name'], data = '비 로그인 상태 입니다.'), 401
elif(num == 2):
return web_render('index.html', login = login_check(), title = '권한 오류', logo = set_data['name'], data = '이 계정이 없습니다.'), 401
elif(num == 3):
return web_render('index.html', login = login_check(), title = '권한 오류', logo = set_data['name'], data = '권한이 모자랍니다.'), 401
elif(num == 4):
return web_render('index.html', login = login_check(), title = '권한 오류', logo = set_data['name'], data = '관리자는 차단, 검사 할 수 없습니다.'), 401
elif(num == 5):
return web_render('index.html', login = login_check(), title = '유저 오류', logo = set_data['name'], data = '그런 계정이 없습니다.'), 401
elif(num == 6):
return web_render('index.html', login = login_check(), title = '가입 오류', logo = set_data['name'], data = '동일한 아이디의 유저가 있습니다.'), 401
elif(num == 7):
return web_render('index.html', login = login_check(), title = '가입 오류', logo = set_data['name'], data = '아이디는 20글자보다 짧아야 합니다.'), 401
elif(num == 8):
return web_render('index.html', login = login_check(), title = '가입 오류', logo = set_data['name'], data = '아이디에는 한글과 알파벳과 공백만 허용 됩니다.'), 401
elif(num == 9):
return web_render('index.html', login = login_check(), title = '변경 오류', logo = set_data['name'], data = '그런 계정이 없습니다.'), 401
elif(num == 10):
return web_render('index.html', login = login_check(), title = '변경 오류', logo = set_data['name'], data = '비밀번호가 다릅니다.'), 401
elif(num == 11):
return web_render('index.html', login = login_check(), title = '로그인 오류', logo = set_data['name'], data = '이미 로그인 되어 있습니다.'), 401
elif(num == 12):
return web_render('index.html', login = login_check(), title = '로그인 오류', logo = set_data['name'], data = '그런 계정이 없습니다.'), 401
elif(num == 13):
return web_render('index.html', login = login_check(), title = '로그인 오류', logo = set_data['name'], data = '비밀번호가 다릅니다.'), 401
elif(num == 14):
return web_render('index.html', login = login_check(), title = '업로드 오류', logo = set_data['name'], data = 'jpg, gif, jpeg, png만 가능 합니다.'), 401
elif(num == 15):
return web_render('index.html', login = login_check(), title = '업로드 오류', logo = set_data['name'], data = '파일 명에 . / \ * < > | : ? 가 들어 갈 수 없습니다.'), 401
elif(num == 16):
return web_render('index.html', login = login_check(), title = '업로드 오류', logo = set_data['name'], data = '동일한 이름의 파일이 있습니다.'), 401
elif(num == 17):
return web_render('index.html', login = login_check(), title = '편집 오류', logo = set_data['name'], data = '편집 내용 기록에는 한글과 영어와 숫자, 공백만 허용 됩니다.'), 401
elif(num == 18):
return web_render('index.html', login = login_check(), title = '편집 오류', logo = set_data['name'], data = '내용이 원래 문서와 동일 합니다.'), 401
elif(num == 19):
return web_render('index.html', login = login_check(), title = '이동 오류', logo = set_data['name'], data = '이동 하려는 곳에 문서가 이미 있습니다.'), 401
elif(num == 20):
return web_render('index.html', login = login_check(), title = '비밀번호 오류', logo = set_data['name'], data = '재 확인이랑 비밀번호가 다릅니다.'), 401
else:
return ''
@app.errorhandler(404)
def uncaughtError(error):
return ''
@app.errorhandler(413)
def uncaughtError(error):
app.config['MAX_CONTENT_LENGTH'] = (1024**3)
return error, 401
if(__name__ == '__main__'):
app.run(host = '0.0.0.0', port = int(set_data['port']))