[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

[shadiguy1]

i noticed sinse installing this it always says alot of people are viewing aticles section even if there not . Any suggestions.

[Paul M]

Curious, why have you released an addon to your own hack as a seperate hack in the addons section.

[cinq]

I think this is the only way the addon gets linked to the main hack in the main hack thread's add-ons side bar ?

Correct me if I'm wrong ( i did ask this in the Site feedback section a while back ).

[Creed]

Yup, that is correct

[subnet_rx]

anyone want to post a demo of this?

[RichieBoy67]

Yeah, screenshot please or demo??? I am waiting to install until I can see it...

Thanks

[She Unlimited]

Would someone help me install this? Paid

[mike.fro]

http://www.discusspromotion.com has it up (my site).

link:
http://www.discusspromotion.com/articles.php? is the hack.

[She Unlimited]

index.php Which template do I go into to make these changes...(sorry a bit new to doing hacks myself).

Thank you

Also, how do I change the width to reflect the width of my Featured Articles now?

:nervous:

[Marco van Herwaarden]

index.php is not a template but a file in either your forumhome, or your ./admincp directory (read hack instructions carefull to find out which to edit).