Search options (Page 15 of 16)

10  3   Test subject     I'm saving a copy of this message.  admin_user  2   1153866671  127.0.0.1   1   0   0
11  2   Test subject     I'm saving a copy of this message.  test_user   3   1153866671  127.0.0.1   1   1   1

$wee['inlagg'] = preparse_bbcode($wee['inlagg'], $errors);
$wee['inlagg'] = parse_message($wee['inlagg'], false);
echo $wee['inlagg'];

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

  Copyright (C) 2006  guardian34 (publicbox@fmguy.com)

  This file is part of PunBB.

  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

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


// Make sure no one attempts to run this script "directly"
if (!defined('PUN'))
    exit;

// Tell admin_loader.php that this is indeed a plugin and that it is loaded
define('PUN_PLUGIN_LOADED', 1);

if (isset($_POST['update']))
{
    // Make sure post id was entered
    if (trim($_POST['post_id']) == '')
        message('You didn\'t enter a post id!');

    // Make sure user id was entered
    if (trim($_POST['user_id']) == '')
        message('You didn\'t specifiy an user!');

    $post_id = intval($_POST['post_id']);
    $user_id = intval($_POST['user_id']);

    // Get username
    $result = $db->query('SELECT username FROM '.$db->prefix.'users WHERE id='.$user_id) or error('Unable to fetch username', __FILE__, __LINE__, $db->error());
    $username = $db->result($result);

    // Get topic id
    $result = $db->query('SELECT topic_id FROM '.$db->prefix.'posts WHERE id='.$post_id) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());
    $topic_id = $db->result($result);

    // Get topic post id
    $result = $db->query('SELECT id FROM '.$db->prefix.'posts WHERE topic_id='.$topic_id.' ORDER BY posted LIMIT 1') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());
    $topic_post_id = $db->result($result);
    
    
    // Update post
    $db->query('UPDATE '.$db->prefix.'posts SET poster=\''.$username.'\', '.'poster_id='.$user_id.' WHERE id = '.$post_id);
    if ($db->affected_rows() < 1)
        $msg = 'The post author was <b>not</b> updated.<br />'."\n\t\t\t\t";
    else
        $msg = 'The post author was updated successfully. '.
            '(Post: <a href="viewtopic.php?pid='.$post_id.'#p'.$user_id.'">'.$post_id.'</a>;'.
            ' User: <a href="profile.php?id='.$user_id.'">'.$username.'</a>)<br />'."\n\t\t\t\t";

    // Try to update "topic post"
    if ($post_id == $topic_post_id)
        $db->query('UPDATE '.$db->prefix.'topics SET poster = \''.$username.'\' WHERE id = '.$topic_id);

    // Try to update last_poster
    $db->query('UPDATE '.$db->prefix.'topics SET last_poster = \''.$username.'\' WHERE last_post_id = '.$post_id);
    
    // Update forum
    $result = $db->query('SELECT forum_id FROM '.$db->prefix.'topics WHERE id = '.$topic_id);
    update_forum($db->result($result, 0));


    // Display the admin navigation menu
    generate_admin_menu($plugin);
?>
    <div class="block">
        <h2><span>Post Author Update - v1.2</span></h2>
        <div class="box">
            <div class="inbox">
                <p>This plugin modifies a post's author.</p>
            </div>
        </div>
    </div>
        
    <div class="block">
        <h2 class="block2"><span>Result</span></h2>
        <div class="box">
            <div class="inbox">
                <p><?php echo $msg; ?></p>
            </div>
        </div>
    </div>
<?php
}
else
{
    // Display the admin navigation menu
    generate_admin_menu($plugin);
?>
    <div class="block">
        <h2><span>Post Author Update - v1.2</span></h2>
        <div class="box">
            <div class="inbox">
                <p>This plugin modifies a post's author.</p>
            </div>
        </div>
    </div>
        
    <div class="blockform">
        <h2 class="block2"><span>Input</span></h2>
        <div class="box">
            <form method="post" action="<?php echo $_SERVER['REQUEST_URI'] ?>">
                <div class="inform">
                    <fieldset>
                        <legend>IDs</legend>
                        <div class="infldset">
                            <table class="aligntop" cellspacing="0">
                                <tr>
                                    <th scope="row">Post ID:</th>
                                    <td><input type="text" name="post_id" size="16" tabindex="1" /></td>
                                </tr>
                                <tr>
                                    <th scope="row">User:</th>
                                    <td>
                                        <?php
                                        
                                        echo '<select name="user_id" tabindex="2">'."\n";
                                        
                                        $result = $db->query('SELECT id, username FROM '.$db->prefix.'users WHERE id > 1 ORDER BY username ASC') or error('Unable to get user list', __FILE__, __LINE__, $db->error());

                                        while ($cur_user = $db->fetch_assoc($result))
                                            echo "\t\t\t\t\t\t\t\t\t\t".'<option value="'.$cur_user['id'].'">'.pun_htmlspecialchars($cur_user['username']).'</option>'."\n";
                                        ?>
                                    </select>
                                    </td>    
                                </tr>
                            </table>
                        </div>
                    </fieldset>
                </div>
            <p class="submitend"><input type="submit" name="update" value="Update" tabindex="3" /></p>
            </form>
        </div>
    </div>
<?php
}
?>