root/original/common/class.killboard.php

<?
  require_once( "db.php" );

  class Killboard {

    function Killboard( $site )
    {
      $this->qry_ = new DBQuery();

      $this->site_ = $site;
      $this->config_ = new Config( $site );
    }

    function isSuspended()
    {
      $this->execQuery();
      return $this->row_['rtl_suspended'] == "1";
    }

    function getConfig()
    {
      $this->execQuery();
      return $this->config_;
    }

    function hasCampaigns( $active = false )
    {
      $qry = new DBQuery();
      $sql =  "select ctr_id
                 from kb3_contracts
                 where ctr_campaign = 1
                   and ctr_site = '".$this->site_."'";
      if ( $active ) $sql .= " and ctr_ended is null";
      $qry->execute( $sql ) or die ( $qry->getErrorMessage() );
      return ( $qry->recordCount() > 0 );
    }

    function hasContracts( $active = false )
    {
      $qry = new DBQuery();
      $sql =  "select ctr_id
                 from kb3_contracts
                 where ctr_campaign = 0
                   and ctr_site = '".$this->site_."'";
      if ( $active ) $sql .= " and ( ctr_ended is null or now() <= ctr_ended )";
      $qry->execute( $sql ) or die ( $qry->getErrorMessage() );
      return ( $qry->recordCount() > 0 );
    }

    function execQuery()
    {
    }
  }

  class Config
  {
    function Config( $site )
    {
      $this->qry_ = new DBQuery();
      $this->sql_ = "select *
                       from kb3_config
                      where cfg_site = '".$site."'";

      $this->site_ = $site;
    }

    function getStyleName()
    {
      $this->execQuery();
      return $this->style_name_;
    }

    function getStyleBanner()
    {
      $this->execQuery();
      return $this->style_banner_;
    }

    function getPostPassword()
    {
      $this->execQuery();
      return $this->post_password_;
    }

    function getPostMailto()
    {
      $this->execQuery();
      return $this->post_mailto_;
    }

    function getKillPoints()
    {
      $this->execQuery();
      return $this->kill_points_;
    }

    function getLeastActive()
    {
      $this->execQuery();
      return $this->least_active_;
    }

    function setConfig( $key, $value )
    {
      $qry = new DBQuery();
      $qry->execute( "select cfg_value from kb3_config
                       where cfg_key = '".$key."'
                         and cfg_site = '".$this->site_."'" );
      if ( $qry->recordCount() ) {
        $sql = "update kb3_config
                   set cfg_value = '".$value."'
                 where cfg_site = '".$this->site_."'
                   and cfg_key = '".$key."'";
      } else {
        $sql = "insert into kb3_config values ( '".$this->site_."',
                                                '".$key."',
                                                '".$value."' )";
      }
      $qry->execute( $sql ) or die( $qry->getErrorMsg() );
    }
    
    function setStyleName( $name )
    {
      $this->setConfig( "style_name", $name );
    }

    function setStyleBanner( $banner )
    {
      $this->setConfig( "style_banner", $banner );
    }

    function setPostPassword( $password )
    {
      $this->setConfig( "post_password", $password );
    }

    function setPostMailto( $mailto )
    {
      $this->setConfig( "post_mailto", $mailto );
    }

    function setKillPoints( $flag )
    {
      $this->setConfig( "kill_points", $flag );
    }

    function setLeastActive( $flag )
    {
      $this->setConfig( "least_active", $flag );
    }

    function execQuery()
    {
      if ( !$this->qry_->executed_ ) {
        $this->qry_->execute( $this->sql_ );

        while ( $row = $this->qry_->getRow() )
        {
          switch( $row['cfg_key'] ) {
            case 'style_name':
              $this->style_name_ = $row['cfg_value'];
              break;
            case 'style_banner':
              $this->style_banner_ = $row['cfg_value'];
              break;
            case 'post_password':
              $this->post_password_ = $row['cfg_value'];
              break;
            case 'post_mailto':
              $this->post_mailto_ = $row['cfg_value'];
              break;
            case 'kill_points':
              $this->kill_points_ = $row['cfg_value'];
              break;
            case 'least_active':
              $this->least_active_ = $row['cfg_value'];
              break;
          }
        }
      }
    }
  }
?>