Move Post 1.1.1 исправленый

        $new_topic_id = $_POST['topic_to_move'];

<?php
/***********************************************************************

  Frщdщric Pouget (editeur at georezo dot net)

  This file is part of the mod: Move Post 1.1.1 for PunBB.

************************************************************************/

/***********************************************************************

  Copyright (C) 2002-2005  Rickard Andersson (rickard@punbb.org)

  PunBB is free software; you can redistribute it and/or modify it
  under the terms of the GNU General Public License as published
  by the Free Software Foundation; either version 2 of the License,
  or (at your option) any later version.

  PunBB is distributed in the hope that it will be useful, but
  WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with this program; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place, Suite 330, Boston,
  MA  02111-1307  USA

************************************************************************/

define('PUN_ROOT', './');
require PUN_ROOT.'include/common.php';

if ($pun_user['g_id'] > PUN_MOD)
    message($lang_common['No permission']);

if (isset($_GET['id']))
{
    $sort_order_ ='';
    $sort_list_='last_post';

    $post_id = intval($_GET['id']);
    
    //Find the information from the original post
    $result = $db->query('
SELECT p.message, t.id, t.subject, t.forum_id, f.forum_name, c.cat_name, f.moderators
FROM '.$db->prefix.'posts as p
INNER JOIN '.$db->prefix.'topics as t
ON p.topic_id=t.id
INNER JOIN '.$db->prefix.'forums as f
ON t.forum_id=f.id
INNER JOIN '.$db->prefix.'categories AS c
ON c.id=f.cat_id
WHERE p.id='.$post_id) or error('Unable to find information for the post', __FILE__, __LINE__, $db->error());
    if (!$db->num_rows($result))
        message($lang_common['Bad request']);
        
    list($message, $old_topic_id, $subject, $old_fid, $forum_name, $cat_name, $moderators) = $db->fetch_row($result);

    // Sort out who the moderators are and if we are currently a moderator (or an admin)
    $mods_array = ($moderators != '') ? unserialize($moderators) : array();
    $is_admmod = ($pun_user['g_id'] == PUN_ADMIN || ($pun_user['g_id'] == PUN_MOD && array_key_exists($pun_user['username'], $mods_array))) ? true : false;

    // Do we have permission to move this post?
    if (!$is_admmod)
        message($lang_common['No permission']);

        
    //Same forum or new one ?
    if (isset($_GET['new_fid']))
    {
        $fid =$new_fid = intval($_GET['new_fid']);
        
        if ($new_fid != $old_fid)
            $new_forum = TRUE;
        else
            $fid = $old_fid;

        // Fetch some info about new forum
        $result = $db->query('SELECT f.moderators FROM '.$db->prefix.'forums AS f WHERE f.id='.$fid) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());
        if (!$db->num_rows($result))
            message($lang_common['Bad request']);

        list($moderators2) = $db->fetch_row($result);

        // Sort out who the moderators are and if we are currently a moderator (or an admin)
        $mods_array = ($moderators2 != '') ? unserialize($moderators2) : array();
        $is_admmod2 = ($pun_user['g_id'] == PUN_ADMIN || ($pun_user['g_id'] == PUN_MOD && array_key_exists($pun_user['username'], $mods_array))) ? true : false;

        // Do we have permission to move this post?
        if (!$is_admmod2)
            message($lang_common['No permission']);
    }
    else
        $fid = $old_fid;
    
    
    //Should be not necessary but in case ...
    if ($fid < 1)
        message($lang_common['Bad request']);
    
    
    //Count the post in the first topic
    //if result=1 (only one post in this topic) --> different process 
    $result = $db->query('SELECT count(id) FROM '.$db->prefix.'posts WHERE topic_id='.$old_topic_id) or error('Unable to count posts in topic', __FILE__, __LINE__, $db->error());
    $num_post = $db->result($result);
    if ($num_post < 1)
        message($lang_common['Bad request']);
    if ($num_post == 1)
        $del_old_topic=TRUE;
    
    
    // Load the movepost.php language file
    require PUN_ROOT.'lang/'.$pun_user['language'].'/movepost.php';
    require PUN_ROOT.'lang/'.$pun_user['language'].'/post.php';
    
    if (isset($_POST['form_sent']))
    {
        $form_sent = intval($_POST['form_sent']);
        
        $new_topic_id = $_POST['topic_to_move'];
        if ($new_topic_id == '' && $form_sent != 2)
            message($lang_movepost['Bad topic']);
        
        
        // If it's a creation of a new topic
        if ($form_sent == 2)
        {
            $new_subject = pun_trim($_POST['create_topic']);
            
            if ($new_subject == '')
                $errors[] = $lang_post['No subject'];
            else if (pun_strlen($new_subject) > 70)
                $errors[] = $lang_post['Too long subject'];
            else if ($pun_config['p_subject_all_caps'] == '0' && mb_strtoupper($subject) == $subject && $pun_user['g_id'] > PUN_MOD)
                $subject = ucwords(mb_strtolower($subject));

            if (!empty($errors)) {message($errors[0]);}
            
            // Create the topic
            $db->query('INSERT INTO '.$db->prefix.'topics (subject, forum_id) VALUES(\''.$db->escape($new_subject).'\', '.$fid.')') or error('Unable to create topic', __FILE__, __LINE__, $db->error());
            $new_topic_id = $db->insert_id();
        }
        
        
        // If all the posts move
        if (isset($_POST['move_all_post']))
        {
            // Create the list of the post
            $result = $db->query('SELECT id FROM '.$db->prefix.'posts WHERE topic_id='.$old_topic_id) or error('Unable to update user last visit data', __FILE__, __LINE__, $db->error());
            if ($db->num_rows($result))
            {
                $all_id = '';
                while ($row = $db->fetch_row($result))
                    $all_id .= (($all_id != '') ? ',' : '').$row[0];
            }
        }
        
        
        //Move post in the new topic
        if ($all_id)
            $db->query('UPDATE '.$db->prefix.'posts SET topic_id='.$new_topic_id.' WHERE id IN('.$all_id.')') or error('Unable to update user last visit data', __FILE__, __LINE__, $db->error());
        else
            $db->query('UPDATE '.$db->prefix.'posts SET topic_id='.$new_topic_id.' WHERE id='.$post_id) or error('Unable to update user last visit data', __FILE__, __LINE__, $db->error());
        
        
        //Update topics and forum if required
        update_topic($new_topic_id);
        
        
        if($del_old_topic || $all_id)
        {
            delete_topic($old_topic_id);
            update_forum($old_fid); // Update the forum FROM which the topic was moved
            
            if($new_forum)
                update_forum($new_fid);    // Update the forum FROM which the topic was moved
            
            require PUN_ROOT.'include/search_idx.php';
            // Bit silly should be probably improved: in order to remove the subject from the old topic, we need:
            // 1. remove all the words (message and subject) from the search tables 
            // 2. add the words from the message only in the search tables !!! 
            strip_search_index($post_id); 
            update_search_index('post', $post_id, $message); 
        }
        else
        {
            update_topic($old_topic_id);
            
            if($new_forum)
            {
                update_forum($old_fid);    // Update the forum FROM which the topic was moved
                update_forum($new_fid);    // Update the forum TO which the topic was moved
            }
        }
        
        redirect('viewtopic.php?pid='.$post_id.'#p'.$post_id, $lang_movepost['Mark move redirect']);
    }
    else
    {
        //Count the topics to diplayed
        $result = $db->query('SELECT count(id) FROM '.$db->prefix.'topics WHERE forum_id ='.$fid.' AND moved_to IS NULL') or error('Unable to count topics in forum', __FILE__, __LINE__, $db->error());
        $num_topics = $db->result($result);
        
        //Not add the original topic
        if ($fid == $old_fid)
            $num_topics = $num_topics-1;
        
        
        //Sort query (based on $_GET['new_fid'], $_GET['sort'] and $_GET['desc'])
        $var_query_img = $var_query = '';
        if (isset($_GET['new_fid']))
            $var_query_img .= $var_query .='&new_fid='.$fid;

        if (isset($_GET['sort']))
        {    
            $s_g=$_GET['sort'];
//            if ($s_g!='subject' && $s_g!='poster' && $s_g!='last_post' && $s_g!='num_replies') $s_g='subject';
            if (!in_array($s_g,array('subject','poster','last_post','num_replies'))) $s_g='last_post';
            $sort_list.= $s_g;
            $sort_list_=$sort_list;
            $var_query .='&sort='.$sort_list;
            
            if (isset($_GET['desc']))
            {
                $sort_list .=' DESC';
                $var_query .='&desc=1';
                $sort_order_ ='desc';
            }
        }
        else
            $sort_list= 'last_post DESC';

        $sort_list.=', subject';
        
        
        // Determine the topic offset (based on $_GET['p'])
        $num_pages = ceil($num_topics / $pun_user['disp_topics']);
        $p = (!isset($_GET['p']) || $_GET['p'] <= 1 || $_GET['p'] > $num_pages) ? 1 : $_GET['p'];
        $start_from = $pun_user['disp_topics'] * ($p - 1);
        
        
        // Generate paging links
        $paging_links = $lang_common['Pages'].': '.paginate($num_pages, $p, 'movepost.php?id='.$post_id.$var_query);
        
        
        //The topic query
        $result_topic = $db->query('SELECT id, subject, poster, last_post, num_replies FROM '.$db->prefix.'topics WHERE moved_to IS NULL AND forum_id='.$fid.' AND id <> '.$old_topic_id.' ORDER BY '.$sort_list.' LIMIT '.$start_from.','.$pun_user['disp_topics']) or error('Unable to find topics in forum', __FILE__, __LINE__, $db->error());
        
        $page_title = 'MovePost | '.pun_htmlspecialchars($pun_config['o_board_title']);        
        require PUN_ROOT.'header.php';
        
        ?>
<div class="blockform">
<h2><span><?php echo $lang_movepost['Mod move post'] ?></span></h2>
<div class="box">
<form id="qjump" method="get" action="movepost.php?id=<?php echo $post_id ?>">
<p><strong><?php echo "<a href=\"viewtopic.php?pid=".$post_id."#p".$post_id."\" />" ?><?php echo $lang_common['Go back'] ?></a></strong></p><br />
<fieldset>
<legend><?php echo $lang_movepost['Introduction'] ?></legend>
<div class="infldset">
<p><?php echo $lang_movepost['Intro'] ?></p><br />
<p><?php echo $lang_movepost['Original topic'] ?> <strong><?php echo pun_htmlspecialchars($subject) ?></strong></p>
<p><?php echo $lang_movepost['Original forum'] ?> <strong>(<?php echo pun_htmlspecialchars($cat_name).') '.pun_htmlspecialchars($forum_name) ?></strong></p>
<p><?php echo $lang_movepost['Select forum'] ?>:</p>
<div>
<select name="id" onchange="window.location=('movepost.php?id=<?php echo $post_id ?>&new_fid='+this.options[this.selectedIndex].value)">
<?php 
    $result = $db->query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.moderators FROM '.$db->prefix.'categories AS c INNER JOIN '.$db->prefix.'forums AS f ON c.id=f.cat_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND f.redirect_url IS NULL ORDER BY c.disp_position, c.id, f.disp_position', true) or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());
        $cur_category = 0;
        while ($cur_forum = $db->fetch_assoc($result))
        {
                $mods_array = ($cur_forum['moderators'] != '') ? unserialize($cur_forum['moderators']) : array();
            $is_admmod = ($pun_user['g_id'] == PUN_ADMIN || ($pun_user['g_id'] == PUN_MOD && array_key_exists($pun_user['username'], $mods_array))) ? true : false;
            if (!$is_admmod) continue;



            if ($cur_forum['cid'] != $cur_category)    // A new category since last iteration?
            {
                if ($cur_category)
                    echo '</optgroup>'."\n";
                
                echo '<optgroup label="'.pun_htmlspecialchars($cur_forum['cat_name']).'">'."\n";
                $cur_category = $cur_forum['cid'];
            }
            
            echo "<option value=".$cur_forum['fid'];
                if ($cur_forum['fid'] == $fid) echo " selected='selected'";
            echo " >".pun_htmlspecialchars($cur_forum['forum_name'])."</option>\n";
        }
if ($cur_category) echo '</optgroup>'
    ?>
</select>
</div>
</div>
</fieldset>
<input type="hidden" name="form_sent" value="1" />
</form>
<form id="movepost_create" method="post" action="movepost.php?id=<?php echo $post_id ?>&new_fid=<?php echo $fid ?>">
<fieldset>
<legend><?php echo $lang_movepost['Create topic'] ?></legend>
<div class="infldset">
<p><?php echo $lang_movepost['Explain create topic'] ?></p><br />
<input name="create_topic" size="70" maxlength="70" tabindex="1" type="text" />
<input name="save" value="<?php echo $lang_common['Submit'] ?>" type="submit" />
<br /><br />
<p><?php echo $lang_movepost['Move all posts'] ?> (<strong><?php echo $num_post ?></strong>)</p>
<div class="rbox">
<label><input name="move_all_post" value="1" type="checkbox" /><?php echo $lang_movepost['Explain move all posts'] ?> <br /></label>
</div>
</div>
</fieldset>
<input type="hidden" name="form_sent" value="2" />
</form>
<form id="movepost_move" method="post" action="movepost.php?id=<?php echo $post_id ?>">
<fieldset>
<legend><?php echo $lang_movepost['Move post'] ?></legend>
<div class="infldset">
<p><?php echo $lang_movepost['Explain move post'] ?></p><br />
<p><?php echo $lang_movepost['Move all posts'] ?> (<strong><?php echo $num_post ?></strong>)</p>
<div class="rbox">
<label><input name="move_all_post" value="1" type="checkbox" /><?php echo $lang_movepost['Explain move all posts'] ?> <br /></label>
</div>
<p style="TEXT-ALIGN:center;"><input name="save" value="<?php echo $lang_common['Submit'] ?>" type="submit" /></p>
<p class="pagelink conl"><?php echo $paging_links ?></p><p>&nbsp;</p>
<table class="aligntop" cellspacing="0">
<tr>
<th class="tc2" scope="col">
&nbsp;
</th>
<th scope="col"><strong>
<?php 
echo "<a href=\"movepost.php?id=".$post_id.$var_query_img.'&sort=subject';
if ($sort_list_=='subject') { if ($sort_order_!='desc') echo '&desc=1';}
echo "\">".$lang_common['Topic']."</a>";
if ($sort_list_=='subject') { if ($sort_order_=='desc') echo ' ▲'; else echo ' ▼'; }?>
</th>
</strong><th scope="col"><strong>
<?php 
echo "<a href=\"movepost.php?id=".$post_id.$var_query_img.'&sort=poster';
if ($sort_list_=='poster') { if ($sort_order_!='desc') echo '&desc=1';}
echo "\">".$lang_movepost['Poster']."</a>";
if ($sort_list_=='poster') { if ($sort_order_=='desc') echo ' ▲'; else echo ' ▼'; }?>
</th>
</strong><th scope="col"><strong>
<?php 
echo "<a href=\"movepost.php?id=".$post_id.$var_query_img.'&sort=last_post';
if ($sort_list_=='last_post') { if ($sort_order_!='desc') echo '&desc=1';}
echo "\">".$lang_movepost['Last']."</a>";
if ($sort_list_=='last_post') { if ($sort_order_=='desc') echo ' ▲'; else echo ' ▼'; }?>
</th>
</strong><th class="tc2" scope="col"><strong>
<?php 
echo "<a href=\"movepost.php?id=".$post_id.$var_query_img.'&sort=num_replies';
if ($sort_list_=='num_replies') { if ($sort_order_!='desc') echo '&desc=1';}
echo "\">".$lang_common['Replies']."</a>";
if ($sort_list_=='num_replies') { if ($sort_order_=='desc') echo ' ▲'; else echo ' ▼'; }?>
</strong></th>
</tr>
<?php
        // If there are topics in this forum.
        if ($db->num_rows($result_topic))
        {
            while ($cur_topic = $db->fetch_assoc($result_topic))
            {
                ?>
<tr>
<td class="tc2"><input name="topic_to_move" style="height:10pt" value="<?php echo $cur_topic['id'] ?>" type="radio" /></td>
<td><?php echo pun_htmlspecialchars($cur_topic['subject']) ?></td>
<td><?php echo pun_htmlspecialchars($cur_topic['poster']) ?></td>
<td><?php echo format_time($cur_topic['last_post']) ?></td>
<td class="tc2"><?php echo $cur_topic['num_replies'] ?></td>
</tr>
<?php
            }
        } 
?>
</table>
<p class="pagelink conl"><?php echo $paging_links ?></p><p>&nbsp;</p>
<p style= "TEXT-ALIGN: center;"><input name="save" value="<?php echo $lang_common['Submit'] ?>" type="submit" /></p>
</div>
</fieldset>
<input type="hidden" name="form_sent" value="3" />
<br /><p><strong><?php echo "<a href=\"viewtopic.php?pid=".$post_id."#p".$post_id."\" />" ?><?php echo $lang_common['Go back'] ?></a></strong></p>
</form>
</div>
</div>
<?php

    require PUN_ROOT.'footer.php';
    }
}
else
    message($lang_common['Bad request']);