plugins/generic/openAds/OpenAdsConnection.inc.php

<?php

// $Id: CounterPlugin.inc.php,v 1.0 2006/10/20 12:28pm

class OpenAdsConnection {
   var $installPath;

   var $config;

   var $errors;

   var $plugin;

   function OpenAdsConnection(&$plugin, $installPath) {
      $this->plugin =& $plugin;
      $this->installPath = $installPath;
      $this->errors = array();
   }

   function getConfigFilename() {
      $variablesScriptPath = $this->installPath . '/variables.php';
      if (!file_exists($variablesScriptPath)) return null;
      require_once($variablesScriptPath);
      return $this->installPath . '/var/' . getHostName() . '.conf.php';
   }

   function isConfigured() {
      return file_exists($this->getConfigFilename());
   }

   function loadConfig() {
      $fp = null;
      $config = @parse_ini_file($this->getConfigFilename(), true);
      if (!$config) {
         $this->errors[] = Locale::translate('plugins.generic.openads.error.configFileNotFound', array('filename' => $configFilename));
         return false;
      }

      if (  !isset($config['database']['type']) ||
         $config['database']['type'] != 'mysql' ||
         !isset($config['database']['username']) ||
         !isset($config['database']['password']) ||
         !isset($config['database']['name']) ||
         !isset($config['table']['prefix'])
      ) {
         // There was at least one missing required configuration item.
         $this->errors[] = Locale::translate('plugins.generic.openads.error.missingParameter');
         return false;
      }

      $this->config = $config;

      return true;
   }

   function getErrors() {
      return $this->errors;
   }

   function getAds() {
      $conn =& $this->getConnection();
      $result = mysql_query('SELECT * FROM ' . $this->config['table']['prefix'] . 'zones', $conn);

      $returner = array();
      $this->plugin->import('Ad');
      while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
         $ad =& new Ad($this);
         $ad->setName($row['zonename']);
         $ad->setAdId($row['zoneid']);
         $returner[] =& $ad;
         unset($ad);
      }

      mysql_free_result($result);
      mysql_close($conn);
      return $returner;
   }

   function &getConnection() {
      $dbPort = !empty($this->config['database']['port'])?((int) $this->config['database']['port']):3306;

      $dbHost = $this->config['database']['host'];
      $conn = mysql_connect ($dbHost . ':' . $dbPort, $this->config['database']['username'], $this->config['database']['password']);

      if (!$conn) {
         $this->errors[] = Locale::translate('plugins.generic.openads.error.dbConnectionError');
         $returner = false;
         return $returner;
      }
      mysql_select_db ($this->config['database']['name'], $conn);
      return $conn;
   }

   function getAdHtml($adId) {
      if (!$adId) return '';
      require_once($this->installPath . '/phpadsnew.inc.php');
      if (!isset($phpAds_context)) $phpAds_context = array();
      $result = view_raw ("zone:$adId", 0, '', '', '0', $phpAds_context);
      return $result['html'];
   }
}

?>

---