[Gijs]

Hi,

I'm using BOOMER Tabbed Menu Mod and I wanted to use it in a more diverse way: intregrating "latest news" and getting th last 10 items displayed into one of the Tabs.

The forum is great thing for learning, espcialy how fellow members resolve problems. I came across a post of Leon, when it hit me :P
http://forum.x-cart.com/viewtopic.php?t=8414


It's a very basic mod. Simply wanted a thing something else ... especially since Jon's news mod with admin function is still in beta-testing.

Let's take it step by step.

Step 1:
Create in the Admin a language variable called "lbl_news_none".
I gave this contence: "The Latest News section is empty !"

Step 2:
make a new file or edit modules/News_Management/news_last.php and change the sql part to:

#
# define the first & latst news you want to retreve. Edit these values to your liking
#
$first=0;
$last=10;

$news_message = func_query("SELECT $sql_tbl[newsletter].* FROM $sql_tbl[newslists], $sql_tbl[newsletter] WHERE $sql_tbl[newsletter].listid = $sql_tbl[newslists].listid AND $sql_tbl[newslists].avail = 'Y' AND $sql_tbl[newslists].show_as_news = 'Y' AND $sql_tbl[newsletter].show_as_news = 'Y' ORDER BY $sql_tbl[newsletter].send_date DESC LIMIT $first,$last"); 
if (count($news_message) ==0) $news_message=""; 
    $smarty->assign("news_message", $news_message);

Step 3:
replace the contence of today_news.tpl with:

{* $Id: today_news.tpl,v 1.10 2004/05/31 06:25:32 max Exp $ *}
{capture name=latestnews} 
{if $news_message} 
<TABLE width=100% border=0 cellspacing=0 cellpadding=2> 
{section name=number loop=$news_message} 
<TR> 
<TD>
{$news_message[number].send_date|date_format:$config.Appearance.date_format}: {$news_message[number].subject}



{$news_message[number].body}



<HR>
</TD>
</TR>
{/section} 
</TABLE> 
{else}
<TABLE width=100% border=0 cellspacing=0 cellpadding=2> 
<TR>
<TD>
{$lng.lbl_news_none}


 
</TD>
</TR>
</TABLE> 
{/if}
{if $usertype eq "C"}
<TABLE width=100% border=0 cellspacing=0 cellpadding=2> 
<TR>
<TD>
{$lng.lbl_previous_news}
</TD>
</TR>
</TABLE> 
{/if}
{/capture} 
{include file="dialog.tpl" title=$lng.lbl_news content=$smarty.capture.latestnews extra="width=100%"} 

Step 4:
For people using BOOMERS Mod:
After you've edited the js-file properly and the TAB section in cartlab-tabs.tpl.
Simply include today_news.tpl in TAB CONTENT.

Example:
BTW "Laatste Nieuws" = Dutch for "Latest News"
http://www.gbhwebsolutions.com/xcart/latestnewsmod.jpg

H.I.H.

Gijs