Home Page ~ Subitems display

[LorenGK]

I don't see subitems displayed on the home page with articles, is there a button that does shows them?

What I would like is to display Subitems (which I have renamed in mine to News Briefs) above Articles on the home page is it possible to provide me with details?

Also how do i remove from the xooarticles article script from home page 'title'?

[Sergey Hmelevsky]

To show last subitems on Home Page(this is true for xooArticles v1.1):
1. In file index.php add following lines above $xaSmarty->display('index.tpl');:

PHP Code:

$subitems =& $xaFront->getSubitems(0, 5); // This shows last 5 subitems
$xaSmarty->assign_by_ref('subitems', $subitems); 


2. In the file templates/Default/index.tpl find line

PHP Code:

{include file="box-header.tpl" color="green" caption=$gLang.latest_articles} 


and insert next code above

PHP Code:

{if $subitems}
    {include file="box-header.tpl" color="green" caption="Latest Subitems"}
    {foreach from=$subitems item=subitem}
        {include file="brief-subitem.tpl"}
    {/foreach}    
    {include file="box-footer.tpl" color="green"}
{/if} 


3. In the file classes/xaFront.class.php find function

PHP Code:

    function &getSubitems($aStart = 0, $aLimit = 0, $aWhere = '')
    {
        $sql = "SELECT t1.*, t2.`title` scategory, t3.`username` owner ";
        $sql .= "FROM `{$this->mPrefix}subitems` t1 ";
        $sql .= "LEFT JOIN `{$this->mPrefix}subitem_categories` t2 ";
        $sql .= "ON t1.`id_subitem_category` = t2.`id` ";
        $sql .= "LEFT JOIN `{$this->mPrefix}accounts` t3 ";
        $sql .= "ON t1.`id_account` = t3.`id` ";
        $sql .= " WHERE t1.`status`='active' ";
        if ($aWhere)
        {
            $sql .= $aWhere;
        }
        $sql .= $aLimit ? "LIMIT {$aStart}, {$aLimit}" : '';

        return $this->getAll($sql);
    } 


and change it tho this

PHP Code:

    function &getSubitems($aStart = 0, $aLimit = 0, $aWhere = '')
    {
        $sql = "SELECT t1.*, t2.`title` scategory, t3.`username` owner ";
        $sql .= "FROM `{$this->mPrefix}subitems` t1 ";
        $sql .= "LEFT JOIN `{$this->mPrefix}subitem_categories` t2 ";
        $sql .= "ON t1.`id_subitem_category` = t2.`id` ";
        $sql .= "LEFT JOIN `{$this->mPrefix}accounts` t3 ";
        $sql .= "ON t1.`id_account` = t3.`id` ";
        $sql .= " WHERE t1.`status`='active' ";
        if ($aWhere)
        {
            $sql .= $aWhere;
        }
        $sql .= " ORDER BY t1.`posted` DESC ";
        $sql .= $aLimit ? "LIMIT {$aStart}, {$aLimit}" : '';

        return $this->getAll($sql);
    } 


[Sergey Hmelevsky]

To change Home Page title find in "Language Manager" phrase by variable name "site_title" (as shown on attached image) and change its value.
Attachment 7

[LorenGK]

Thank You Hun!

[Sergey Hmelevsky]

don't hesitate to ask for help

[LorenGK]

That worked a treat! And i have even managed to work out how to put my amazon Iframe ad!

Bless you for that, it's looking gooood!

[Sergey Hmelevsky]

Well, will be considered that this thread is solved.

[LorenGK]

Absolutely!

[Sergey Hmelevsky]

Don't think that i am a strange fellow, I post last message in solved thread in order to faster orientate on forum.

[LorenGK]

Nah...your just trying to get more posts coz you can see I am catching you up!!LOL