[ADDON] cinq's vbArticles Latest Featured Articles on ForumHome

A small addon to show the latest featured articles on your Forum Home page.
This add on is for cinq's vbArticles Hack v2.0

Hack version 1.0


Install instructions
===========================================

1. In your 'FORUMHOME' template

FIND :

<!-- main -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">

ADD BELOW :

<!-- vbArticles Featured Articles -->
<thead>
<tr>
<td class="thead" colspan="5">
<span style="float:$stylevar[right]"><a href="articles.php">More articles here</a></span>
Featured Articles in the $vbphrase[vbarticles]
</td></tr>

<tr>
<td class="alt1" colspan="5">
 <table cellpadding="$stylevar[cellpadding]" cellspacing="1" border="0" width="100%">
     <tr>
   $featuredbitonforumhome
    </tr>
    </table>
</td></tr>
</thead>
<!-- /vbArticles Featured Articles -->

2. Create a new template : 'vbArticles_featuredbitonforumhome'

<td valign="top" align="center" class="alt2" width="33%">
<br>$articonimg<br>
<a href="articles.php?action=viewarticle&artid=$artid">
<span class="smallfont"><b>$title</b></span></a>
<br>$starrating<br><br></td>

3. Make the following code changes to your forum index.php

FIND:

PHP Code:

$specialtemplates = array(
    'userstats',
    'birthdaycache',
    'maxloggedin',
    'iconcache',
    'eventcache',
    'mailqueue'
); 

REPLACE WITH:

PHP Code:

$specialtemplates = array(
    'userstats',
    'birthdaycache',
    'maxloggedin',
    'iconcache',
    'eventcache',
    'mailqueue',
    'vbart_options'
); 

FIND:

PHP Code:

require_once('./includes/functions_forumlist.php'); 

ADD BELOW:

PHP Code:

$vbart_options = unserialize($datastore['vbart_options']);
unset($datastore['vbart_options']); 

FIND :

PHP Code:

// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ### 

ADD ABOVE :

PHP Code:

########################### vbArticles Hack by cinq ##############################
$artquery = $DB_site->query("
    SELECT a.title, a.articles_articleid, a.icon, SUM(r.rating) / COUNT(r.rating) avg
    FROM " . TABLE_PREFIX . "articles_article a
    LEFT JOIN " . TABLE_PREFIX . "articles_rating r
    ON a.articles_articleid = r.articleid
    WHERE a.featured=1
    GROUP BY a.articles_articleid 
    ORDER BY RAND()
    LIMIT ".$vbart_options['numfeaturedarticlehome']."
    ");

if($DB_site->num_rows($artquery)>0) 
{
  while($artlisting=$DB_site->fetch_array($artquery))
  {
      $artid=$artlisting['articles_articleid'];
    $title=$artlisting['title'];
    $articon=$artlisting["icon"];
    $rated = round($artlisting['avg']);
    $starrating ="<img src=\"$stylevar[imgdir_rating]/rating_".$rated.".gif\" alt=\"Rating: $rated/5\" border=\"0\">";
    $articon = ereg_replace($vbart_options['vbartartimgpathab'].$artid.'/',"",$articon);
    $articonimg = "<img title=\"".$title."\" src=\"articles.php?action=thumb&artid=".$artid."&id=".$articon."\" border=\"0\" width=".$vbart_options['vbartssthumbwidth'].">";
      eval('$featuredbitonforumhome .= "' . fetch_template('vbArticles_featuredbitonforumhome') . '";');
  }
}
########################### vbArticles Hack by cinq ############################## 

Save and upload index.php


4. Done

- cinq

[Deviant++]

yep worked ty

[Creed]

Great, got my images back Although there is a typo in your info

In the FORUMHOME template edit:

change this:

Featured Articles in the $vbphrase[vbarticles]

to this:

Featured Articles in the $vbphrase[vbart_vbarticles]

[kall]

Originally Posted by TTG

Would be good .. but ..

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /usr/home/********/public_html/retreat/index.php on line 33

At a guess, you made an error in the edit of the specialtemplates bit.

Make sure it looks exactly like the example above.

[TTG]

Originally Posted by kall

At a guess, you made an error in the edit of the specialtemplates bit.

Make sure it looks exactly like the example above.

sorry .. deleted my post at the same time as you posted .. found the error.

I have a few more items listed under "$specialtemplates = array(" and forgot to add "," :ermm:

[shadiguy1]

installed perfectly. no problems.

[i-Symbian.Com]

I have installed this perfectly but there is something I need your guys' assistance. I have included the screenshot in the attachment.

The Featured articles list is not displayed properly I think. It doesnt stretch like the forum. I marked the part with blue for your guys' reference.

Any assistance would be very appreciated. :-)

Cheers!

[Creed]

in the FORUMHOME template edit find and change:

colspan="5">

to:

colspan="6">

There are two instances of this!

[i-Symbian.Com]

@Creed,

Thanks for your instruction! It is displayed properly now :-) Thanks a million!!!

[Creed]

No problem, glad I could help.