Multiple <{$xoops_banner}>? [Theme templates and Smarty help]

Multiple <{$xoops_banner}>?

2005/1/18 4:03
jmc286642
Just popping in
Posts: 1
Since: 2005/1/18

Is there a way to declare multiple <{$xoops_banner}> elements in theme.html and have XOOPS bring up two different banners? Perhaps with some creative Smarty loops?

Example markup:

 <td> 
  <{$xoops_banner}> 
  <br/> 
  <{$xoops_banner}> 
td>

Declaring <{$xoops_banner}> twice as in the example above merely causes XOOPS to bring up two instances of the same banner ad.

Re: Multiple ?

2005/1/18 7:20
Mithrandir
XOOPS is my life!
Posts: 6320
Since: 2003/6/21

As you have discovered, a Smarty variable points to the same value no matter how many times you place it in your theme.

You will have to edit the xoops_getbanner() function in include/functions.php to return an array of banners which you will then be able to use with <{$xoops_banner.0}>, <{$xoops_banner.1}> etc. depending on how you build the array in the function.

Solution

2005/4/29 18:48
Liawlius
Just popping in
Posts: 4
Since: 2005/4/29

I solved this problem like this:

 function xoops_getbanner() 
{ 
    global $xoopsConfig; 
    $db =& Database::getInstance(); 
    $bresult = $db->query("SELECT COUNT(*) FROM ".$db->prefix("banner")); 
    list ($numrows) = $db->fetchRow($bresult); 
    while ($numrows <> 0) { 
    $numrows = $numrows - 1; 
    $bannum = $numrows; 
        $bresult = $db->query("SELECT * FROM ".$db->prefix("banner"), 1, $bannum); 
        list ($bid, $cid, $imptotal, $impmade, $clicks, $imageurl, $clickurl, $date, $htmlbanner, $htmlcode) = $db->fetchRow($bresult); 
        if ($xoopsConfig['my_ip'] == xoops_getenv('REMOTE_ADDR')) { 
            // EMPTY 
        } else { 
            $db->queryF(sprintf("UPDATE %s SET impmade = impmade+1 WHERE bid = %u", $db->prefix("banner"), $bid)); 
        } 
        /* Check if this impression is the last one and print the banner */ 
        if ( $imptotal == $impmade ) { 
            $newid = $db->genId($db->prefix("bannerfinish")."_bid_seq"); 
            $sql = sprintf("INSERT INTO %s (bid, cid, impressions, clicks, datestart, dateend) VALUES (%u, %u, %u, %u, %u, %u)", $db->prefix("bannerfinish"), $newid, $cid, $impmade, $clicks, $date, time()); 
            $db->queryF($sql); 
            $db->queryF(sprintf("DELETE FROM %s WHERE bid = %u", $db->prefix("banner"), $bid)); 
        } 
        if ($htmlbanner){ 
            $bannerobject = $htmlcode; 
        } else{ 
            $bannerobject = '.XOOPS_URL.'/banners.php?op=click&bid='.$bid.'" target="_blank">'; 
            if (stristr($imageurl, '.swf')) { 
                $bannerobject = $bannerobject 
                    .'' 
                    .'.$imageurl.'">' 
                    .'' 
                    .'.$imageurl.'" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"; type="application/x-shockwave-flash" width="468" height="60">' 
                    .'' 
                    .''; 
            } else { 
                $bannerobject = $bannerobject.'.$imageurl.'" alt="" />'; 
            } 
 
            $bannerobject = $bannerobject.'
'; 
        } 
     $banner_ret = $banner_ret.'
'.$bannerobject; 
     
} 
        return $banner_ret; 
 
}

Now this function repeats banner adding routine until no more banners left. If you can suggest better solution dont be shy

Re: Multiple ?

2005/4/29 18:49
Liawlius
Just popping in
Posts: 4
Since: 2005/4/29

My solution:

 function xoops_getbanner() 
{ 
    global $xoopsConfig; 
    $db =& Database::getInstance(); 
    $bresult = $db->query("SELECT COUNT(*) FROM ".$db->prefix("banner")); 
    list ($numrows) = $db->fetchRow($bresult); 
    while ($numrows <> 0) { 
    $numrows = $numrows - 1; 
    $bannum = $numrows; 
        $bresult = $db->query("SELECT * FROM ".$db->prefix("banner"), 1, $bannum); 
        list ($bid, $cid, $imptotal, $impmade, $clicks, $imageurl, $clickurl, $date, $htmlbanner, $htmlcode) = $db->fetchRow($bresult); 
        if ($xoopsConfig['my_ip'] == xoops_getenv('REMOTE_ADDR')) { 
            // EMPTY 
        } else { 
            $db->queryF(sprintf("UPDATE %s SET impmade = impmade+1 WHERE bid = %u", $db->prefix("banner"), $bid)); 
        } 
        /* Check if this impression is the last one and print the banner */ 
        if ( $imptotal == $impmade ) { 
            $newid = $db->genId($db->prefix("bannerfinish")."_bid_seq"); 
            $sql = sprintf("INSERT INTO %s (bid, cid, impressions, clicks, datestart, dateend) VALUES (%u, %u, %u, %u, %u, %u)", $db->prefix("bannerfinish"), $newid, $cid, $impmade, $clicks, $date, time()); 
            $db->queryF($sql); 
            $db->queryF(sprintf("DELETE FROM %s WHERE bid = %u", $db->prefix("banner"), $bid)); 
        } 
        if ($htmlbanner){ 
            $bannerobject = $htmlcode; 
        } else{ 
            $bannerobject = '.XOOPS_URL.'/banners.php?op=click&bid='.$bid.'" target="_blank">'; 
            if (stristr($imageurl, '.swf')) { 
                $bannerobject = $bannerobject 
                    .'' 
                    .'.$imageurl.'">' 
                    .'' 
                    .'.$imageurl.'" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"; type="application/x-shockwave-flash" width="468" height="60">' 
                    .'' 
                    .''; 
            } else { 
                $bannerobject = $bannerobject.'.$imageurl.'" alt="" />'; 
            } 
 
            $bannerobject = $bannerobject.'
'; 
        } 
     $banner_ret = $banner_ret.'
'.$bannerobject; 
     
} 
        return $banner_ret; 
 
}

Its loop whitch repeats banner adding routine untill no more banner left to add.

----
I edited this post and the previous one to use the [ code ] tag - Dave_L

Re: Multiple <{$xoops_banner}>?

2005/5/10 20:09
Anonymous
Posts: 0
Since:

Hi,

Is possible now to use more than banner in many blocks, example : <{$xoops_banner1}>,<{$xoops_banner2}>, .. etc ?

Stats
Goal:	$100.00
Due Date:	Jul 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Multiple <{$xoops_banner}>?

Re: Multiple ?

Solution

Re: Multiple ?

Re: Multiple <{$xoops_banner}>?

Login

Search

Recent Posts

PHP 8.4.0 Alpha 1 released

Overview of the Composer packages in Admin

Re: xoops_getBaseDomain

xoops_getBaseDomain

Re: Test 3

Test 3

Re: Test2

Re: Test2

Re: Test2

Test2

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}