[dizzy100]

Originally Posted by imported_Alpine

That worked lovely for my Forum home, But now the prob is reversed in the Actual Classified section, Looks like I will have to live with it,

Can someone please post up the original sr_classifieds_newadbit code, As per the instructions above I over wrote it and the disk I saved it on is corrupt.

Sorry about that, i forgot i altered a lot of the layout when i used the code before.

You could have just reverted the template though.

Heres a fix to allow your forum home to work as you wanted without affecting your classified ads system

Create a new template. Call it sr_classifieds_forumhome

In that paste

PHP Code:

<td><a href="sr_classifieds.php?do=ad&id=$newad[classifiedid]"> <img src="$vboptions[bburl]/sr_classifieds/uploaded/thumbnails/$newad[image]" border="0"> </a></td> 


Then Create a plugin and hook it to forumhome_start (if you haven't already. If you have, just paste the code in to it below),

Insert the following code

PHP Code:

$newads_get = $vbulletin->db->query_read("
        SELECT classified.classifiedid AS classifiedid, classified.categoryid AS categoryid, classified.userid AS userid, 
        classified.dateline AS dateline, classified.timeframe AS timeframe, classified.title AS title, classified.price AS price, 
        classified.type AS type, user.*,
        upload.classifiedid, upload.image AS image
        FROM " . TABLE_PREFIX . "sr_classifieds AS classified
        LEFT JOIN " . TABLE_PREFIX . "sr_classifieds_uploads AS upload ON (upload.classifiedid=classified.classifiedid)
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid=classified.userid)
        ORDER BY dateline DESC
        LIMIT 7
    ");

    while($newad = $vbulletin->db->fetch_array($newads_get)){
    $newad[dateline] = vbdate($vbulletin->options['dateformat'], $newad['dateline'], '', '');
    eval('$newadbit .= "' . fetch_template('sr_classifieds_forumhome') . '";');
    } 


Then add in your NAVBAR template (At the bottom)

<table cellpadding="5" cellspacing="$stylevar[sellcellspacing]" width="100%" >
<tr><td colspan="7" class="thead">Latest Classified Ads</td></tr>
<tr>
$newadbit</tr>
</table>

I haven't tested that as i no longer use that particular classifieds system but all we've effectively done is change the template we call when outputting the plugins data.