openNAMU__openNAMU/route/edit_move.py

from .tool.func import *

def edit_move_2(conn, name):
    curs = conn.cursor()

    if acl_check(name) == 1:
        return re_error('/ban')

    if flask.request.method == 'POST':
        if captcha_post(flask.request.form.get('g-recaptcha-response', flask.request.form.get('g-recaptcha', ''))) == 1:
            return re_error('/error/13')
        else:
            captcha_post('', 0)

        if slow_edit_check() == 1:
            return re_error('/error/24')

        move_title = flask.request.form.get('title', 'test')

        curs.execute(db_change("select title from history where title = ?"), [move_title])
        if curs.fetchall():
            if flask.request.form.get('move_option', 'normal') == 'merge' and admin_check(None, 'merge documents') == 1:
                curs.execute(db_change("select data from data where title = ?"), [move_title])
                data = curs.fetchall()
                if data:
                    curs.execute(db_change("delete from data where title = ?"), [move_title])
                    curs.execute(db_change("delete from back where link = ?"), [move_title])

                curs.execute(db_change("select data from data where title = ?"), [name])
                data = curs.fetchall()
                if data:
                    curs.execute(db_change("update data set title = ? where title = ?"), [move_title, name])
                    curs.execute(db_change("update back set link = ? where link = ?"), [move_title, name])

                    data_in = data[0][0]
                else:
                    data_in = ''

                history_plus(
                    name,
                    data_in,
                    get_time(),
                    ip_check(),
                    flask.request.form.get('send', ''),
                    '0',
                    'merge <a>' + name + '</a> - <a>' + move_title + '</a> move'
                )

                curs.execute(db_change("update back set type = 'no' where title = ? and not type = 'cat' and not type = 'no'"), [name])
                curs.execute(db_change("delete from back where title = ? and not type = 'cat' and type = 'no'"), [move_title])

                curs.execute(db_change("select id from history where title = ? order by id + 0 desc limit 1"), [move_title])
                data = curs.fetchall()

                num = data[0][0]

                curs.execute(db_change("select id from history where title = ? order by id + 0 asc"), [name])
                data = curs.fetchall()
                for move in data:
                    curs.execute(db_change("update rc set title = ?, id = ? where title = ? and id = ?"), [
                        move_title, 
                        str(int(num) + int(move[0])), 
                        name, 
                        move[0]
                    ])
                    curs.execute(db_change("update history set title = ?, id = ? where title = ? and id = ?"), [
                        move_title, 
                        str(int(num) + int(move[0])), 
                        name, 
                        move[0]
                    ])

                conn.commit()

                return redirect('/w/' + url_pas(move_title))
            elif flask.request.form.get('move_option', 'normal') == 'reverse':
                var_name = ''
                i = 0
                while 1:
                    curs.execute(db_change("select title from history where title = ?"), ['test ' + str(i)])
                    if not curs.fetchall():
                        curs.execute(db_change("select data from data where title = ?"), [name])
                        data = curs.fetchall()
                        if data:
                            curs.execute(db_change("update data set title = ? where title = ?"), ['test ' + str(i), name])
                            curs.execute(db_change("update back set link = ? where link = ?"), ['test ' + str(i), name])

                        curs.execute(db_change("update history set title = ? where title = ?"), ['test ' + str(i), name])
                        curs.execute(db_change("update rc set title = ? where title = ?"), ['test ' + str(i), name])

                        break
                    else:
                        i += 1

                for title_name in [[move_title, name], ['test ' + str(i), move_title]]:
                    curs.execute(db_change("select data from data where title = ?"), [title_name[0]])
                    data = curs.fetchall()
                    if data:
                        curs.execute(db_change("update data set title = ? where title = ?"), [title_name[1], title_name[0]])
                        curs.execute(db_change("update back set link = ? where link = ?"), [title_name[1], title_name[0]])

                        data_in = data[0][0]
                    else:
                        data_in = ''

                    history_plus(
                        title_name[0],
                        data_in,
                        get_time(),
                        ip_check(),
                        flask.request.form.get('send', ''),
                        '0',
                        '<a>' + (title_name[0] if title_name[0] != 'test ' + str(i) else name) + '</a> - <a>' + title_name[1] + '</a> move'
                    )

                    curs.execute(db_change("update history set title = ? where title = ?"), [title_name[1], title_name[0]])
                    curs.execute(db_change("update rc set title = ? where title = ?"), [title_name[1], title_name[0]])
                    conn.commit()

                return redirect('/w/' + url_pas(move_title))
            else:
                return re_error('/error/19')
        else:
            curs.execute(db_change("select data from data where title = ?"), [name])
            data = curs.fetchall()
            if data:
                curs.execute(db_change("update data set title = ? where title = ?"), [move_title, name])
                curs.execute(db_change("update back set link = ? where link = ?"), [move_title, name])

                data_in = data[0][0]
            else:
                data_in = ''

            history_plus(
                name,
                data_in,
                get_time(),
                ip_check(),
                flask.request.form.get('send', ''),
                '0',
                '<a>' + name + '</a> - <a>' + move_title + '</a> move'
            )

            curs.execute(db_change("update back set type = 'no' where title = ? and not type = 'cat' and not type = 'no'"), [name])
            curs.execute(db_change("delete from back where title = ? and not type = 'cat' and type = 'no'"), [move_title])

            curs.execute(db_change("update history set title = ? where title = ?"), [move_title, name])
            curs.execute(db_change("update rc set title = ? where title = ?"), [move_title, name])
            conn.commit()

            return redirect('/w/' + url_pas(move_title))
    else:
        return easy_minify(flask.render_template(skin_check(),
            imp = [name, wiki_set(), custom(), other2(['(' + load_lang('move') + ')', 0])],
            data = '''
                <form method="post">
                    ''' + ip_warring() + '''
                    <input placeholder="''' + load_lang('document_name') + '" value="' + name + '''" name="title" type="text">
                    <hr class=\"main_hr\">
                    <input placeholder="''' + load_lang('why') + '''" name="send" type="text">
                    <hr class=\"main_hr\">
                    <select name="move_option">
                        <option value="normal"> ''' + load_lang('normal') + '''</option>
                        <option value="reverse"> ''' + load_lang('replace_move') + '''</option>
                        ''' + ('<option value="merge"> ' + load_lang('merge_move') + '</option>' if admin_check() == 1 else '') + '''
                    </select>
                    <hr class=\"main_hr\">
                    ''' + captcha_get() + '''
                    <button type="submit">''' + load_lang('move') + '''</button>
                </form>
            ''',
            menu = [['w/' + url_pas(name), load_lang('return')]]
        ))