Latest news on the index (invision function)

[Eagle Creek]

Howdy!

Take a look overhere please:
http://eaglecreek.j-p-it.nl/forum/


As you can see at the top of the forums there is a sentence "[EC] Eagle Creek Clan Forum latest news: Forums and site updated"..

In the Admin Panel of the Invision Board I can turn this feature on or off and I can fill in the section ID of the section which one should be shows.

It justs shows the title of the most recent posted thread in that forum.

Is this a standardoption on VB? Or should I go ask for a hack like this?

All the best, EC

[cinq]

Not a default feature, but can be easily added by placing code in php_include and editting your FORUMHOME template

[Eagle Creek]

Uuhm.. I'm not really a PHPhero (I will be, one , I bought books , anyway ).. Can you make something for me?

Or is that much work?

[cinq]

The thread there "Forums and site updated", is it being pulled from just a specific forum(s) ? Or is it just the latest thread with a reply ?

[Eagle Creek]

No, it's for specific forum(s).. In Invision Board I can give up the forumID of the forum I want to get displayed.. (only one forum is possible overthere, but maybe more forumID's are possible when you make it yourself).

So; it shows the threadtitle from the forum I gave the ID and it links to the thread.

[cinq]

Not tested but something you can try :

Put this in your phpinclude_start ( Styles & Templates > Style Manager > All Style Options )

PHP Code:

$getnews = $DB_site->query_first("SELECT threadid, title FROM ".TABLE_PREFIX."thread WHERE forumid=X ORDER BY lastpost DESC LIMIT 1"); 


You will need to put the forumid of the specific forum you want in place of the X at forumid=X

Now, in your FORUMHOME template, add this whereever you want it to be shown :

[EC] Eagle Creek Clan Forum latest news: <a href="showthread.php?t=$getnews[threadid]">$getnews[title]</a>

[Eagle Creek]

It isn't for EC forums but I will try this out! Thanks alot!

Where do I have to place it in phpinclude_start?

/*
// Example of how to include a seperate file:

ob_start();
include('yourheader.html');
$your_code = ob_get_contents();
ob_end_clean();

// Now place a reference to $your_code where you want the resulting HTML to be displayed.
// This will most likely be the header or footer template.
*/

[cinq]

After :

// This will most likely be the header or footer template.
*/

[Eagle Creek]

Database error in vBulletin 3.0.4:

Invalid SQL: SELECT threadid, title thread WHERE forumid=X ORDER BY lastpost DESC LIMIT 1
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 'WHERE forumid=X ORDER BY lastpost DESC LIMIT 1' at line 1

mysql error number: 1064

Date: Thursday 12th of May 2005 02:21:08 PM
Script: http://www.antispywareoffensief.nl/f...e&pp=60&page=1
Referer: http://www.antispywareoffensief.nl/f...e&pp=60&page=1
Username: Admin
IP Address: *

[cinq]

Originally Posted by cinq

You will need to put the forumid of the specific forum you want in place of the X at forumid=X

erm...