XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk




1
Liawlius
Re: News Topic Block

  • 2005/5/3 14:35

  • Liawlius

  • Just popping in

  • Posts: 4

  • Since: 2005/4/29


I have some problems with news topics block too. I need to remove the selectbox and insted of it there must be a list of topics. Could someone plese give me any directions how I could get what I need?
Edit: I use altern8news if it matters.
Topic | Forum


2
Liawlius
Multilanguage Website

  • 2005/5/1 20:33

  • Liawlius

  • Just popping in

  • Posts: 4

  • Since: 2005/4/29


I need to make a website, in lithuanian/english languages. It's needed, that uses would me able to change language enen without registering.
1st problem is that i don't have ant idea how to make a button for changing language. 2nd problem is blocks' an modules' names. How cam I make them different when different language is chosen?
P.S. I'm sorry for my bad english.
Topic | Forum


3
Liawlius
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
Topic | Forum


4
Liawlius
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
Topic | Forum



TopTop



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

128 user(s) are online (67 user(s) are browsing Support Forums)

Members: 0

Guests: 128

more...

Donat-O-Meter

Stats
Goal: AU$15.00
Due Date: Jul 31
Gross Amount: AU$0.00
Net Balance: AU$0.00
Left to go: AU$15.00
Make donations with PayPal!

Latest GitHub Commits