Joomla! Discussion Forums

<?php
/**
* @version $Id: mod_flexcontent.php 2456 2006-04-18 $
* @package JoomlaExtensions
* @copyright Copyright (C) 2006 Matthew Pettitt/Excel Publishing. Inspired by D4J_Content_Listing from DesignForJoomla.com
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* Joomla! is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See COPYRIGHT.php for copyright notices and details.
*/

// no direct access
defined( '_VALID_MOS' ) or die( 'Restricted access' );
//error_reporting(E_ALL);
//ini_set('display_errors',true);
require_once($mainframe->getPath('front', 'com_flexadvert'));

// locationid must be an integer
$locationid = intval($params->get( 'locationid', '' ));
$moduleclass_sfx = $params->get('moduleclass_sfx', '');
$id = intval(mosGetParam( $_REQUEST, 'id' ,NULL ));
$task = mosGetParam($_REQUEST, 'task', NULL);
$loadlast = ((bool) $params->get('loadlast', 0));
$newwindow = ((bool) $params->get('newwindow', 0));
$enablecsa = ((bool) $params->get('enablecsa', 0));
$enabletrans = ((bool) $params->get('enabletrans', 0));
$details = array("sectionid" => NULL, "categoryid" =>NULL, "contentid" => NULL);

if ($id!=0){
switch($task){
  case 'view':
    $contentitem = new flexAdContent($database);
    $contentitem->load($id);
    $details = array("sectionid" => $contentitem->sectionid, "categoryid" => $contentitem->catid, "contentid" => $contentitem->id);
    break;
  case 'blogcategory':
  case 'category':
    $categoryid = $id;
    $category = new flexAdCategories($database);
    $category->load($id);
    $details = array("sectionid" => $category->section, "categoryid" => $category->id, "contentid" => NULL);
    break;
  case 'blogsection':
  case 'section':
    $details = array("sectionid" => $id, "categoryid" => NULL, "contentid" => NULL);
    break;
  default:
    //echo "Not in a category, section or content item view";
    break;
}
}

$contentif = '';

if ($enablecsa){

if (!is_null($details['contentid']) and $details['categoryid']==0 and $details['sectionid']==0){
  $contentif = "AND IF((select count(distinct bannerid) from `#__fabannerin`
                        where `#__fabannerin`.`contentid` = ".$details['contentid'].")>0,
                       `#__fabanner`.`bannerid` in (SELECT `#__fabannerin`.`bannerid` FROM `#__fabannerin`
                                                    WHERE `#__fabannerin`.`contentid` = '" . $details['contentid'] . "')
                                                    AND `#__fabanner`.`restrictbyid`=1,
                       `#__fabanner`.`restrictbyid`=0)";

}elseif (!is_null($details['contentid'])){
  $contentif = "AND IF((select count(distinct bannerid) from `#__fabannerin` where `#__fabannerin`.`contentid` = ".$details['contentid'].")>0,
                       `#__fabanner`.`bannerid` in (SELECT `#__fabannerin`.`bannerid` FROM `#__fabannerin` WHERE `#__fabannerin`.`contentid` = '" . $details['contentid'] . "') AND `#__fabanner`.`restrictbyid`=1,
                       IF(`#__fabanner`.`restrictbyid` and (select count(distinct bannerid) from `#__fabannerin` where `#__fabannerin`.`categoryid` = ".$details['categoryid'].")>0,
                          `#__fabanner`.`bannerid` in (SELECT `#__fabannerin`.`bannerid` FROM `#__fabannerin` WHERE `#__fabannerin`.`categoryid` = '" . $details['categoryid'] . "') AND `#__fabanner`.`restrictbyid`=1,
                          IF(`#__fabanner`.`restrictbyid` and (select count(distinct bannerid) from `#__fabannerin` where `#__fabannerin`.`sectionid` = ".$details['sectionid'].")>0,
                             `#__fabanner`.`bannerid` in (SELECT `#__fabannerin`.`bannerid` FROM `#__fabannerin` WHERE `#__fabannerin`.`sectionid` = '" . $details['sectionid'] . "') AND `#__fabanner`.`restrictbyid`=1,
                             `#__fabanner`.`restrictbyid`=0)))";

}elseif (!is_null($details['categoryid'])){
  $contentif = "AND IF((select count(distinct bannerid) from `#__fabannerin` where `#__fabannerin`.`categoryid` = ".$details['categoryid'].")>0,
                        `#__fabanner`.`bannerid` in (SELECT `#__fabannerin`.`bannerid` FROM `#__fabannerin` WHERE `#__fabannerin`.`categoryid` = '" . $details['categoryid'] . "') AND `#__fabanner`.`restrictbyid`=1,
                        IF(`#__fabanner`.`restrictbyid` and (select count(distinct bannerid) from `#__fabannerin` where `#__fabannerin`.`sectionid` = ".$details['sectionid'].")>0,
                           `#__fabanner`.`bannerid` in (SELECT `#__fabannerin`.`bannerid` FROM `#__fabannerin` WHERE `#__fabannerin`.`sectionid` = '" . $details['sectionid'] . "') AND `#__fabanner`.`restrictbyid`=1,
                           `#__fabanner`.`restrictbyid`=0))";
}elseif (!is_null($details['sectionid'])){
  $contentif = "AND IF((select count(distinct bannerid) from `#__fabannerin` where `#__fabannerin`.`sectionid` = ".$details['sectionid'].")>0,
                       `#__fabanner`.`bannerid` in (SELECT `#__fabannerin`.`bannerid` FROM `#__fabannerin` WHERE `#__fabannerin`.`sectionid` = '" . $details['sectionid'] . "') AND `#__fabanner`.`restrictbyid`=1,
                       `#__fabanner`.`restrictbyid`=0)";
}else{
  $contentif = "AND `#__fabanner`.`restrictbyid`=0";
}

}


$sql = "SELECT `#__fabanner`.`bannerid`,
               `#__falocation`.`locationname`,
               `#__fabanner`.`imageurl`,
               `#__fabanner`.`imagealt`,
               `#__fabanner`.`customcode`,
               `#__fabanner`.`startdate`,
               `#__fabanner`.`enddate`,
               `#__fabanner`.`lastreset`,
               `#__fabanner`.`impressions`,
               `#__fabanner`.`clicks`,
               `#__fabanner`.`maximpressions`,
               `#__fabanner`.`maxclicks`,
               `#__fabanner`.`linkid`,
               `#__fasize`.`width`,
               `#__fasize`.`height`,
               `#__fabanner`.`restrictbyid`,
               `#__fabanner`.`dailyimpressions`,
               if(`#__faclient`.`barred` OR `#__fabanner`.`finished`OR NOT `#__fabanner`.`published`, 0, 1) as `valid`
        FROM   `#__fabanner`
        Inner Join `#__fabannerlocation` ON `#__fabanner`.`bannerid` = `#__fabannerlocation`.`bannerid`
        Inner Join `#__faclient` ON `#__fabanner`.`clientid` = `#__faclient`.`clientid`
        Inner Join `#__falocation` ON `#__fabannerlocation`.`locationid` = `#__falocation`.`locationid`
        Inner Join `#__falocationsize` ON `#__falocation`.`locationid` = `#__falocationsize`.`locationid`
        Inner Join `#__fasize` ON `#__fabanner`.`sizeid` = `#__fasize`.`sizeid`
               AND `#__falocationsize`.`sizeid` = `#__fasize`.`sizeid`
        WHERE `#__falocation`.`locationid` = $locationid $contentif
          AND `#__fabanner`.`published` = 1
        ORDER BY `restrictbyid` desc, `dailyimpressions`";

$database->setQuery( $sql );
$database->query();
if( $database->getNumRows()>0){
  $database->loadObject($banner);
  $bannerdetails = new flexAdBanner($database);
  $bannerdetails->load($banner->bannerid);
  $bannerdetails->impressions += 1;
  $bannerdetails->dailyimpressions += 1;
  $bannerdetails->store();

  $link     = sefRelToAbs( 'index.php?option=com_flexadvert&task=click&bannerid='. $banner->bannerid );
  $imageurl = $mosConfig_live_site . "/images/banners/" . $banner->imageurl;
  if (trim( $banner->customcode )) {
    echo stripslashes($banner->customcode);
  }elseif (eregi("\.swf$", $banner->imageurl)) {
    $imageurl = "$mosConfig_live_site/images/banners/".$banner->imageurl;
    ?>
    <script type="text/javascript" src="<?php echo $mosConfig_live_site; ?>/modules/swfobject.js"></script>


    <div id="flashcontent<?php echo $moduleclass_sfx; ?>">
   

   
    <div class="advert<?php echo $moduleclass_sfx; ?>" style="display:block;width:<?php echo $banner->width;?>px;height:<?php echo $banner->height; ?>px;background:url(<?php echo $imageurl; ?>.jpg) no-repeat;">
    <a href="<?php echo $link; ?>" style="width:<?php echo $banner->width;?>px;height:<?php echo $banner->height; ?>px;display:block;margin:0;padding:0;border:0;text-decoration:none;"
    <?php  if ($newwindow){ echo 'target="_blank"'; } ?>> </a></div>
    </div>
   
    <script type="text/javascript">
      var so = new SWFObject("<?php echo $imageurl; ?>", "mymovie", "<?php echo $banner->width;?>", "<?php echo $banner->height;?>", "6", "#ffffff");
      <?php if($enabletrans){ ?>
        so.addParam("wmode", "transparent");
      <?php } ?>
      so.write("flashcontent<?php echo $moduleclass_sfx; ?>");
    </script>
     <?php
  }else{
    if ($loadlast){
      echo '<div class="advert' .  $moduleclass_sfx . '" style="display:block;width:'.$banner->width.'px;height:'.$banner->height.'px;background:url('.$imageurl.') no-repeat;">';
      echo '<a href="' . $link . '" style="width:'.$banner->width.'px;height:'.$banner->height.'px;display:block;margin:0;padding:0;border:0;text-decoration:none;" ';
      if ($newwindow){ echo 'target="_blank"'; }
      echo '> ';
      echo '</a>';
      echo '</div>';
    }else{
      echo '<div class="advert' . $moduleclass_sfx . '">';
      echo '<a href="' . $link . '"';
      if ($newwindow){ echo 'target="_blank"'; }
      echo '>';
      echo '<img src="' . $imageurl . '" alt="' . $banner->imagealt . '" width="' . $banner->width . '" height="' . $banner->height . '"/>';
      echo '</a>';
      echo '</div>';
    }
  }
}
?>