Search options (Page 15 of 26)

$result = $db->query("SELECT p.id, p.poster, p.poster_id, p.message, p.topic_id, p.first_post, t.subject, t.forum_id FROM ".$db->prefix."posts AS p INNER JOIN ".$db->prefix."topics AS t ON t.id=p.topic_id WHERE p.deleted=1");
if (!$db->num_rows($result))
    echo 'No deleted posts.';
else
{
?>
<table>
<tr>
<th style="width:250px;">Subject</th>
<th style="width:300px;">Message</th>
<th style="width:100px;">Poster</th>
</tr>
<?php
while ($deleted_post = $db->fetch_assoc($result))
{
$poster = '<a href="profile.php?id='.$deleted_post['poster_id'].'">'.$deleted_post['poster'].'</a>';
$db->query('SELECT id FROM '.$db->prefix.'posts WHERE first_post=1 AND topic_id='.$deleted_post['topic_id'].' AND id!='.$deleted_post['id']);
if ($db->num_rows($result) == '1')
    $restore = '0';
else
    $restore = '1';
?>
<form id="postlog" method="post" action="admin_loader.php?plugin=AMP_Deleted_post_log.php&id=<?php echo $deleted_post['id'] ?>&topic=<?php echo $deleted_post['topic_id'] ?>&forum=<?php echo $deleted_post['forum_id'] ?>&first_post=<?php echo $deleted_post['first_post'] ?>">
<tr>
<td style="width:250px;"><?php echo $deleted_post['subject'] ?></td>
<td style="width:300px;"><?php echo $deleted_post['message'] ?></td>
<td style="width:100px;"><?php echo $poster ?></td>
<td>
<input type="submit" name="delete" value="Delete forever" />
</td>
<td>
<input type="submit" name="restore" value="Restore" <?php if ($restore == '0') echo 'disabled ' ?>/>
</td>
</tr>
</form>
<?php
}
?>
</table>
<?php
}
?>

if ($db->num_rows($result))
    $restore = '0';
else
    $restore = '1';

##
##
##        Mod title:  Subscribe User 
##
##      Mod version:  1.0.1
##   Works on PunBB:  1.2.* (as far as I know) 
##     Release date:  05-20-2007 
##           Author:  Franz Liedke 
##
##      Description:  Adds the possibility (for admins and, I think, moderators, too) to subscribe a user to a topic if he has already posted there.
##
##       Affects DB:  No 
##
##   Affected files:  viewtopic.php 
##                    misc.php 
##
##            Notes:  Will display a link "Subscribe this user" under every post.
##
##      Changelog:  Version 1.0.1
##            some bugfixes -> first version that is actually working ;)
##
##     Generated By:  Auto Read-Me(by Caleb Champlin) - http://www.rscheatnet.com/Auto_Readme.zip
##
##       DISCLAIMER:  Please note that 'mods' are not officially supported by
##                    PunBB. Installation of this modification is done at your
##                    own risk. Backup your forum database and any and all
##                    applicable files before proceeding.
##