[ADDON] cinq's vbArticles Latest 3 Featured Articles CMPS Module

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

Hack version 1.1

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

1. Upload the cmps-articles.php file to your modules directory.

2. Create 2 new templates:

a. First template:

adv_portal_articlesbits

	<tr>
		<td class="$getbgrow" width="100%">
		<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="0" class="tborder" width="100%">
		<tr>
		<td width="20%" align="center">$articonimg</td>
		<td width="80%" align="left"><span class="smallfont"><b>Title: <a href=$vboptions[bburl]/articles.php?action=viewarticle&artid=$articleid>$title</a></b>
		<br>$summary</span></td>
		</tr>
		</table>
		</td>
	</tr>

b. Second template:

adv_portal_articles

<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">
	<tr>
		<td class="tcat"><span class="smallfont"><strong>$vba_options[portal_blockbullet] Featured Articles</strong></span></td>
	</tr>
$articlesbits
</table>
<br />

3. Next, perform the following file edits.

a. In your global.php file

FIND

PHP Code:

$specialtemplates = array_merge($specialtemplates, 
        array(
            'adv_modules',
            'adv_portal_opts',
            'attachmentcache',
            'bbcodecache',
            'birthdaycache',
            'eventcache',
            'iconcache',
            'maxloggedin',
            'smiliecache',
            'userstats'
        )
    ); 


REPLACE WITH

PHP Code:

$specialtemplates = array_merge($specialtemplates, 
        array(
            'adv_modules',
            'adv_portal_opts',
            'attachmentcache',
            'bbcodecache',
            'birthdaycache',
            'eventcache',
            'iconcache',
            'maxloggedin',
            'smiliecache',
            'userstats',
            'vbart_options'
        )
    ); 


Save and upload global.php


b. In your includes/vba_cmps_include_top.php file

FIND

PHP Code:

$portalopts = unserialize($datastore['adv_portal_opts']); 


ADD ABOVE

PHP Code:

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


Save and upload includes/vba_cmps_include_top.php


4. Next, create the new module using the drop down menu, selecting "cmps-articles.php".
In the "templates used" field enter the following templates: 'adv_portal_articles, adv_portal_articlesbits'

5. Don't forget to update your index pages(s) to show the new module.

6. Done !

===========================================

Enjoy
- cinq

[subnet_rx]

I've installed this hack but can't get it to show up, what should I check? What do you mean by refreshing the index page? I'm using vBAdvanced.

EDIT: I just installed the top_rep hack for vBA with no problems. The box for this hack isn't even showing up.

[ncangler]

I've installed everything identical to my 3.0.5 setup on another site but this 3.0.7 install doesn't show the image on the CMPS page. It shows fine within the Articles portion of the site. (www.triumphowners.org)

Any ideas?

[ncangler]

In the attached photo you'll notice that there is a larger border on the middle of three articles being featured on the CMPS page. How can I change the border on the center display so that all three featured articles look the same? Thanks!

I'll bet it is the alternating colors 1 and 2 isn't it? How would I override that for this display?

[ncangler]

I'm stumped. I've done everything I can think of but the image does not show up on the CMPS page. I've attached an image showing the article image displayed on the ARticles page and an image that shows the image no show on the CMPS.

It is very strange cause it works on one of my sites but not the other. The files on both sites are identical (except path info). The only difference between the two sites is that the one that works is running vBulletin 3.0.5 and the one that doesn't is running 3.0.7. Any ideas are appeciated. Thanks.

[ncangler]

Be sure to activate the new module (mine is called "Featured Articles") in your AdminCP (vBa CMPS, Edit Modules, Featured Articles). Then you need to make sure it is turned on for the particular page where you want it to appear. I have mine on my main page so I edit the Default/Home Page (AdminCP, vBa CMPS, Edit Pages, Default/Home Page). Hope this helps!

Originally Posted by subnet_rx

I've installed this hack but can't get it to show up, what should I check? What do you mean by refreshing the index page? I'm using vBAdvanced.

EDIT: I just installed the top_rep hack for vBA with no problems. The box for this hack isn't even showing up.

[subnet_rx]

yep, both are checked. I may move away from this system anyway, since it will be paid in the future.

[redcow]

thanks

[ncangler]

Okay I've got to quit working on the computer so much. I found the problem. Somehow in the process of editing three sites I forgot to add the vba_cmps_include_top.php edit. Sorry!

Originally Posted by ncangler

I'm stumped. I've done everything I can think of but the image does not show up on the CMPS page.

[TTG]

Installed and module shows without picture .. when I try and add the vba_cmps_include_top.php edited file I receive error :-

Database error in vBulletin 3.0.6:

Invalid SQL:  
    SELECT a.title, a.articles_articleid, a.icon, SUM(r.rating) / COUNT(r.rating) avg 
    FROM articles_article a 
    LEFT JOIN articles_rating r 
    ON a.articles_articleid = r.articleid 
    WHERE a.featured=1 
    GROUP BY a.articles_articleid 
    ORDER BY RAND() 
    LIMIT  
    
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 8

mysql error number: 1064

[kissmans]

please tell me what happen when i install it.

SELECT a.article_articleid, a.title, a.summary, a.iconid
FROM nhactinhvienxu_us_-_diendan.article a
LEFT JOIN nhactinhvienxu_us_-_diendan.article_category c
ON a.categoryid = c.article_categoryid
WHERE a.categoryid != '0' AND a.draft !='1' AND a.featured=1
ORDER BY a.publishdate DESC
LIMIT 3
mysql error: You have an error in your SQL syntax near '-_diendan.article a
LEFT JOIN nhactinhvienxu_us_-_diendan.article_catego' at line 3

My Full Database infor


Database nhactinhvienxu_us_-_diendan - Table article running on localhost