Featured Articles on Forum Home

[Creed]

When I tried putting the Featured Articles hack in, I get this database error on my forumhome:

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

Any ideas?

[cinq]

The settings are saved already right ?

[Creed]

I've removed the limit, line and it seemingly works..but I'm sure I need it. Now I have an issue with the arcitles icon's not showing up, and I assume that is because its calling a template that doesn't exist:

if ($articon) { eval('$articonimg = "' . fetch_template('vbArticles_articonimg') . '";'); }
else { $articonimg = ''; }

vbArticles_articonimg doesn't exist. What if anything should that be changed to?


BTW, the limit line was

LIMIT ".$vboptions['numfeaturedarticlehome']."

Any ideas?

Btw, yes I did update the options. I have set to 4 featured articles on forum home :)

In an update, I created a test.php including:

<?

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');
require_once('./includes/functions_bigthree.php');
require_once('./includes/functions_forumlist.php');

echo "Hello World";

echo $vboptions['numfeaturedarticlehome'] ;

?>

And all I get is Hello World :(

[cinq]

OH ! I just realized you are talking about an ADD ON ??
If so, please don't use the add-ons first.

Most ( if not all ) won't work properly with v2.0.
I will update them soon.

[Creed]

Sweet, thats kinda what I assumed. I've got it basically working, just missing icons now :) Sorry ;)

[cinq]

Which missing icons ?
I see them fine here :
http://www.hdclan.org/forums/articles.php ?

[Creed]

Oh, I was just referring to the ones on forumhome, but again thats an add-on which eventually will be fixed :)

http://www.hdclan.org/forums/forum.php