[Sommaire] [Imprimer]

   1  global $sql, $tp, $ns, $menu_pref;
   2  $ret = "";
   3  
   4  unset($text);
   5  mt_srand ((double) microtime() * 1000000);
   6  $seed = mt_rand(1,2000000000);
   7  
   8  $query = " (banner_startdate=0 OR banner_startdate<=".time().") AND (banner_enddate=0 OR banner_enddate>".time().") AND (banner_impurchased=0 OR banner_impressions<=banner_impurchased)".($parm ? " AND banner_campaign='".$tp -> toDB($parm)."'" : "")." 
   9  AND banner_active IN (".USERCLASS_LIST.")
  10  ORDER BY RAND($seed)";
  11  
  12  if($sql -> db_Select("banner", "*", $query)){
  13      $row = $sql->db_Fetch();
  14  
  15      if(!$row['banner_image'])
  16      {
  17          return "<a href='".e_HTTP."banner.php?".$row['banner_id']."' rel='external'>no image assigned to this banner</a>";
  18      }
  19  
  20      $fileext1 = substr(strrchr($row['banner_image'], "."), 1);
  21      $sql->db_Update("banner", "banner_impressions=banner_impressions+1 WHERE banner_id='{$row['banner_id']}' ");
  22      if ($fileext1 == 'swf')
  23      {
  24          return "
  25          <object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0\" width=\"468\" height=\"60\">\n
  26              <param name=\"movie\" value=\"".e_IMAGE_ABS."banners/".$row['banner_image']."\">\n
  27              <param name=\"quality\" value=\"high\">\n
  28              <param name=\"SCALE\" value=\"noborder\">\n
  29              <embed src=\"".e_IMAGE_ABS."banners/".$row['banner_image']."\" width=\"468\" height=\"60\" scale=\"noborder\" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"></embed>
  30          </object>
  31          ";
  32      }
  33      elseif($fileext1 == 'php' || $fileext1 == 'html' || $fileext1 == 'js')
  34      {
  35          $file_data = file_get_contents(e_IMAGE."banners/".$row['banner_image']);
  36          return $file_data;
  37      }
  38      else
  39      {
  40          return "<a href='".e_HTTP."banner.php?".$row['banner_id']."' rel='external'><img src='".e_IMAGE_ABS."banners/".$row['banner_image']."' alt='".$row['banner_clickurl']."' style='border:0' /></a>";
  41      }
  42  } else {
  43      return "&nbsp;";
  44  }