Search options (Page 3 of 4)

<?php
/**
* Punn BB creates an RSS feed for New Posts since last visit
* half written half hacked by Chris Neal
*/

// set header
header("Content-Type: text/xml");
// call Punn BB constants
define('PUN_ROOT', './');
define('PUN_QUIET_VISIT', 1);
require PUN_ROOT.'include/common.php';

//set configuation options
$title = pun_htmlspecialchars($pun_config['o_board_title']);
$desc = $title." Rss Feed";
$baseURL = $pun_config['o_base_url'];

//find out if user has a cookie
if (isset($_COOKIE['fa_cookie']))
    list($cookie['user_id'], $cookie['password_hash']) = @unserialize($_COOKIE['fa_cookie']);
if ($cookie['user_id'] > 1)
{
    $result = $db->query('SELECT t.id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_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 t.last_post>'.$pun_user['last_visit']) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
} else{
    $result = $db->query('SELECT t.id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_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 t.last_post>'.(time() - 86400)) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
}
//run query functions
$num_hits = $db->num_rows($result);
if (!$num_hits){
echo '<?xml version="1.0" encoding="ISO-8859-1" ?>'."\n";
echo '    <rss version="2.0">'."\n";
echo '        <channel>'."\n";
echo '            <title>'.$title .'</title>'."\n";
echo '            <link>'.$baseURL.'</link>'."\n";
echo '            <description>'.$desc .' '.count($search_set).'</description>'."\n";
echo '            <language>en</language>'."\n";
echo '            <copyright>© '.$title .'</copyright>'."\n";
echo '            <lastBuildDate>'.date("r").'</lastBuildDate>'."\n";
echo '            <item>'."\n"; 
echo '            <title>No Recent Posts</title> '."\n";
echo '            <link>'.$baseURL.'/</link>'."\n";
echo '            <description>No new Posts</description> '."\n";
echo'            </item>'."\n";
echo'        </channel>'."\n";
echo'    </rss>';
} else {
$sort_by = 4;
$search_ids = array();
while ($row = $db->fetch_row($result))
    $search_ids[] = $row[0];
$db->free_result($result);
$show_as = 'topics';
// Final search results
$search_results = implode(',', $search_ids);
// Fill an array with our results and search properties
$temp['search_results'] = $search_results;
$temp['num_hits'] = $num_hits;
$temp['sort_by'] = $sort_by;
$temp['sort_dir'] = $sort_dir;
$temp['show_as'] = $show_as;
$temp = serialize($temp);
$search_id = mt_rand(1, 2147483647);
//set results 
$sort_by_sql = 't.last_post';
$sql = 'SELECT t.id AS tid, t.poster, t.subject, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_replies, t.closed, t.forum_id FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'topics AS t ON t.id=p.topic_id WHERE t.id IN('.$search_results.') GROUP BY t.id, t.poster, t.subject, t.last_post, t.last_post_id, t.last_poster, t.num_replies, t.closed, t.forum_id'.$group_by_sql.' ORDER BY '.$sort_by_sql;
$result = $db->query($sql) or error('Unable to fetch search results', __FILE__, __LINE__, $db->error());
$search_set = array();
while ($row = $db->fetch_assoc($result))
    $search_set[] = $row;
$db->free_result($result);

// Write out feed
echo '<?xml version="1.0" encoding="ISO-8859-1" ?>'."\n";
echo '    <rss version="2.0">'."\n";
echo '        <channel>'."\n";
echo '            <title>'.$title .'</title>'."\n";
echo '            <link>'.$baseURL.'</link>'."\n";
echo '            <description>'.$desc .' '.count($search_set).'</description>'."\n";
echo '            <language>en</language>'."\n";
echo '            <copyright>© '.$title .'</copyright>'."\n";
echo '            <lastBuildDate>'.date("r").'</lastBuildDate>'."\n";
//loop through items
for ($i = 0; $i < count($search_set); ++$i) {
echo '            <item>'."\n"; 
echo '            <title> '.$search_set[$i]['subject'].' </title> '."\n";
                if ($search_set[$i]['question'] == "")
echo '            <link>'.$baseURL.'/viewtopic.php?id='.$search_set[$i]['tid'].'</link>'."\n";
                else
echo '            <link>'.$baseURL.'/viewpoll.php?id='.$search_set[$i]['tid'].'</link>'."\n";
echo '            <description>'.str_replace("\n", '<br />', pun_htmlspecialchars($search_set[$i]['message'])).'</description> '."\n";
echo'            </item>'."\n";
}

// end feed
echo'        </channel>'."\n";
echo'    </rss>';
}
?>

#
#---------[ 1. OPEN ]---------------------------------------------------------
#
Viewtopic.php

#
#---------[ 2. FIND ]---------------------------------------------
#

            <div class="postleft">
                <dl>
                    <dt><strong><?php echo $username ?></strong></dt>
                    <dd class="usertitle"><strong><?php echo $user_title ?></strong></dd>
                    <dd class="postavatar"><?php echo $user_avatar ?></dd>
<?php if (count($user_info)) echo "\t\t\t\t\t".implode('</dd>'."\n\t\t\t\t\t", $user_info).'</dd>'."\n"; ?>
<?php if (count($user_contacts)) echo "\t\t\t\t\t".'<dd class="usercontacts">'.implode('  ', $user_contacts).'</dd>'."\n"; ?>
                </dl>
            </div>
            <div class="postright">
                <h3><?php if (($post_count + $start_from) > 1) echo ' Re: '; ?><?php echo pun_htmlspecialchars($cur_topic['subject']) ?></h3>

#
#---------[ 3. REPLACE WITH ]------------------------------------------------
#

<!-- VBMOD start -->
    <div class="userinfo">
        <table cellpadding="0" cellspacing="10" border="0" width="100%">
        <tr>
            <td class="userimg"><?php echo $user_avatar ?></td>
            <td nowrap="nowrap">
                <div id="username">
                    <strong><?php echo $username ?></strong>
                </div>
                <div class="user_title"><?php echo $user_title ?></div>
            </td>
            <td width="100%"> </td>
            <td valign="top" nowrap="nowrap">    
                <div class="userinfo">
                    <?php if (count($user_info)) echo "\t\t\t\t\t".implode('</dd>'."\n\t\t\t\t\t", $user_info).'</dd>'."\n"; ?>
                    <?php if (count($user_contacts)) echo "\t\t\t\t\t".'<dd class="usercontacts">'.implode('  ', $user_contacts).'</dd>'."\n"; ?>
                    <?php if ($cur_post['poster_id'] > 1) echo '<p>'.$is_online.'</p>'; ?>
                </div>
            </td>
        </tr>
        </table>
    </div>
<!-- VBMOD stop -->

#
#---------[ 4. OPEN ]---------------------------------------------------------
#

style\imports\base.css

#
#---------[ 5. Add at the end]------------------------------------------------
#

/************************************************
    VB VIEWTOPIC MOD
************************************************/
div.userinfo td {
    
    BORDER-WIDTH: 0px
}

div.postmsg {

    margin: 5px;
}

$result = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'posts WHERE topic_id='.$tid) or error('Unable to fetch post count for topic', __FILE__, __LINE__, $db->error());

$result = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'posts WHERE topic_id='.$tid.' AND deleted=0') or error('Unable to fetch post count for topic', __FILE__, __LINE__, $db->error());

$result = $db->query('SELECT id, poster, posted FROM '.$db->prefix.'posts WHERE topic_id='.$topic_id.' ORDER BY id DESC LIMIT 2') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());

$result = $db->query('SELECT id, poster, posted FROM '.$db->prefix.'posts WHERE topic_id='.$topic_id.' AND deleted=0 ORDER BY id DESC LIMIT 2') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());

$img_tag = '<img width="500" class="postimg" src="'.$url.'" alt="'.htmlspecialchars($url).'" /> <br> This image has been resized, click <a href="'.htmlspecialchars($url).'">here</a> to view the full-sized image.';

$img_tag = '<center><img width="500" class="postimg" src="'.$url.'" alt="'.htmlspecialchars($url).'" /> <br> This image has been resized, click <a href="'.htmlspecialchars($url).'">here</a> to view the full-sized image.</center>';

$img_tag = '<a href="'.$url.'" rel="lightbox"><img width="500" class="postimg" src="'.$url.'" alt="'.htmlspecialchars($url).'" /></a> <br> This image has been resized, click <a href="'.htmlspecialchars($url).'">here</a> to view the full-sized image.';

$img_tag = '<center><a href="'.$url.'" rel="lightbox"><img width="500" class="postimg" src="'.$url.'" alt="'.htmlspecialchars($url).'" /></a> <br> This image has been resized, click <a href="'.htmlspecialchars($url).'">here</a> to view the full-sized image.</center>';