<?php
/*******************************************************************************
 * Copyright (c) 2006-2014 Eclipse Foundation and others.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *    Denis Roy (Eclipse Foundation)- initial API and implementation
 *    Karl Matthias (Eclipse Foundation) - Database access management
 *    Christopher Guindon (Eclipse Foundation)
 *******************************************************************************/
class App {
  private $APPVERSION   = "1.0";
  private $APPNAME    = "Eclipse.org";


  private $DEFAULT_ROW_HEIGHT  = 20;

  private $POST_MAX_SIZE    = 262144;   # 256KB Max post
  private $OUR_DOWNLOAD_URL   = "http://download1.eclipse.org";
  private $PUB_DOWNLOAD_URL   = "http://download.eclipse.org";
  private $DOWNLOAD_BASE_PATH = "/home/data2/httpd/download.eclipse.org";
  private $DB_CLASS_PATH    = "/home/data/httpd/eclipse-php-classes/system/"; # ends with '/'

  private $WWW_PREFIX      = "";  # default is relative
  private $HTTP_PREFIX    = "http"; #default is http

  # Additional page-related variables
  public  $ExtraHtmlHeaders   = "";
  public  $ExtraJSFooter   = "";
  public  $PageRSS      = "";
  public  $PageRSSTitle    = "";
  public  $Promotion      = FALSE;
  public  $CustomPromotionPath = "";
  private $THEME_LIST     =  array("", "Nova", "solstice", "polarsys");

  #Open Graph Protocol Variables
  private $OGTitle            = "";
  private $OGDescription      = "Eclipse is probably best known as a Java IDE, but it is more: it is an IDE framework, a tools framework, an open source project, a community, an eco-system, and a foundation.";
  private $OGImage            = "https://www.eclipse.org/eclipse.org-common/themes/Nova/images/eclipse.png";

  #Doctype
  private $doctype       = FALSE;

  #Google Analytics Variables
  private $projectGoogleAnalyticsCode = "";
  private $googleJavaScript = "";

  #jQuery Variables
  private $jQueryVersion = FALSE;

  # Twitter Follow Widget Variables
  private $twitterScriptInserted = FALSE;

  # Variables for theme customization (Solstice and up).
  private $theme_variables = array();

  # Set to TRUE to disable all database operations
  private $DB_READ_ONLY    = FALSE;

  # Database config and handle cache
  private $databases;

  # Flag to determine whether the "deprecated" theme should be loaded.
  private $OutDated      = false;

  # Deprecated theme message.
  private $OutDatedMsg  = "";

  # Flag to determine whether this is development mode or not (for databases)
  public $devmode       = false;

  # Flag to log SQL even on production systems
  public $logsql        = false;

  # Arbitrary storage hash
  private $hash;

  # SQL Backtrace storage
  public $query_btrace;

  # Messages variable
  private $Messages = NULL;

  # Default constructor
  function App() {
    # Set value for WWW_PREFIX
    $valid_domains = array(
      'www.eclipse.org',
      'eclipse.org',
      'staging.eclipse.org',
      'eclipse.local',
      'www.eclipse.local'
    );

    $http_protocol = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') ? 'https://' : 'http://';
    // Force http://www.eclipse.org if the serve_name is not whitelisted.
    if (in_array($_SERVER['SERVER_NAME'], $valid_domains)) {
      $this->WWW_PREFIX = $http_protocol;
      $this->WWW_PREFIX .= isset($_SERVER['HTTP_HOST']) ? $_SERVER['HTTP_HOST'] : getenv('HTTP_HOST');
    }
    else {
      $this->WWW_PREFIX = $http_protocol . 'www.eclipse.org';
    }

    $this->databases = array();

    # Figure out if we're in devmode by whether the classes are installed or not
    if(!file_exists($this->DB_CLASS_PATH)) {
      $this->devmode = true;
    }

    # Configure databases (not connected)
    $this->configureDatabases();

    # Make it easy to override database and other settings (don't check app-config.php in to CVS!)
    if($this->devmode) {
      if(file_exists(getcwd() . '/app-config.php')) {
        include_once(getcwd() . '/app-config.php');
        # We call a function inside app-config.php and pass it a reference to ourselves because
        # this class is still in the constructor and might not be available externally by name.
        # File just contains a function called app_config() which is called.  Nothing more is needed.
        app_config($this);
      }
      else if(file_exists($_SERVER['DOCUMENT_ROOT'] . '/eclipse.org-common/system/app-config.php'))
      {
        include_once($_SERVER['DOCUMENT_ROOT'] . '/eclipse.org-common/system/app-config.php');
        app_config($this);
      }
    }

    # Initialize backtrace storage
    $this->query_btrace = array();

    # Set server timezone
    date_default_timezone_set("America/Montreal");
  }

/**
   * This function returns the Webmaster object
   * @return object
   * */
  public function getWebmaster($action = '') {
    switch ($action) {
      case "webmaster":
        require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/webmaster/webmaster.class.php");
        return new Webmaster($this);
        break;
      case "mirrors":
        require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/webmaster/mirrors.class.php");
        return new Mirrors($this);
        break;
      case "jobs":
        require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/webmaster/jobs.class.php");
        return new Jobs($this);
        break;
      case "committers":
        require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/webmaster/committers.class.php");
        return new Committers($this);
        break;
      case "firewall":
        require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/webmaster/firewall.class.php");
        return new Firewall($this);
        break;
      case "mailinglists":
        require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/webmaster/mailinglists.class.php");
        return new MailingLists($this);
        break;
    }
  }

  /**
   * This function returns the Subscriptions object
   * @return object
   * */
  public function getSubscriptions() {
    require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/subscriptions/subscriptions.class.php");
    return new Subscriptions($this);
  }

  /**
   * This function returns the CLA object
   * @return object
   * */
  public function getCla() {
    require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/users/cla.class.php");
    return new Cla($this);
  }

  /**
   * This function sets System Messages
   * @param $name - string containing the name of the message
   * @param $msg  - string containing the message itself
   * @param $type - string containing the type of the message
   * */
  public function setSystemMessage($name, $msg, $type) {
    if (get_class($this->Messages) !== 'Messages') {
      require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/messages.class.php");
      $this->Messages = new Messages();
    }
    $this->Messages->setMessages($name, $msg, $type);
  }

  /**
   * this function returns messages
   * @return array
   * */
  public function getSystemMessage() {
    if (get_class($this->Messages) !== 'Messages') {
      require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/messages.class.php");
      $this->Messages = new Messages();
    }
    return $this->Messages->getMessages();
  }

  function getAppVersion() {
    return $this->APPVERSION;
  }

  function getHeaderPath($_theme) {
    return $_SERVER["DOCUMENT_ROOT"] . "/eclipse.org-common/themes/" . $_theme . "/header.php";
  }
  function getMenuPath($_theme) {
    return $_SERVER["DOCUMENT_ROOT"] . "/eclipse.org-common/themes/" . $_theme . "/menu.php";
  }
  function getNavPath($_theme) {
    return $_SERVER["DOCUMENT_ROOT"] . "/eclipse.org-common/themes/" . $_theme . "/nav.php";
  }
  function getFooterPath($_theme) {
    return $_SERVER["DOCUMENT_ROOT"] . "/eclipse.org-common/themes/" . $_theme . "/footer.php";
  }
  function getPromotionPath($_theme) {
    return $_SERVER["DOCUMENT_ROOT"] . "/home/promotions/promotion.php";
  }

  /**
   * Get eclipse.org cookie domain and prefix based off the current environment
   *
   * @return array
   */
  public function getEclipseDomain(){

    $server['dev'] = array(
      'cookie' => '.eclipse.local',
      'domain' => 'www.eclipse.local:50243',
      'dev_domain' => 'dev.eclipse.local:51143',
      'allowed_hosts' => array(
        'eclipse.local',
        'www.eclipse.local',
        'dev.eclipse.local',
        'docker.local'
      ),
    );

    $server['staging'] = array(
      'cookie' => '.eclipse.org',
      'domain' => 'staging.eclipse.org',
      // We currently dont have a staging server for dev.eclipse.org
      'dev_domain' => 'dev.eclipse.org',
      'allowed_hosts' => array(
        'staging.eclipse.org'
      ),
    );

    $server['prod'] = array(
      'cookie' => '.eclipse.org',
      'domain' => 'www.eclipse.org',
      'dev_domain' => 'dev.eclipse.org',
      'allowed_hosts' => array(
        // Empty, since it's the default.
      ),
    );

    // It should not matter if we are on http or https here.
    $host = parse_url('http://' . $_SERVER['HTTP_HOST'], PHP_URL_HOST);
    if (!empty($host)) {
      foreach ($server as $type) {
        if (in_array($host, $type['allowed_hosts'])) {
          return $type;
        }
      }
    }
    return $server['prod'];
  }

  function getAppName() {
    return $this->APPNAME;
  }
  function getPostMaxSize() {
    return $this->POST_MAX_SIZE;
  }
  function getDefaultRowHeight() {
    return $this->DEFAULT_ROW_HEIGHT;
  }
  function getDBReadOnly() {
    return $this->DB_READ_ONLY;
  }

  function sendXMLHeader() {
    header("Content-type: text/xml");
  }

  function getOurDownloadServerUrl() {
    return $this->OUR_DOWNLOAD_URL;
  }

  function getDownloadBasePath() {
    return $this->DOWNLOAD_BASE_PATH;
  }

  function getPubDownloadServerUrl() {
    return $this->PUB_DOWNLOAD_URL;
  }

  function getWWWPrefix() {
    return $this->WWW_PREFIX;
  }

  /**
   * @return: a string
   *
   * return https if $_SERVER['HTTPS'] exist otherwise this function returns http
   */
  function getHTTPPrefix() {
    $protocol = $this->HTTP_PREFIX;
    if(isset($_SERVER['HTTPS'])) {
      if($_SERVER['HTTPS']){
        $protocol = "https";
      }
    }
    $this->HTTP_PREFIX = $protocol;
    return $this->HTTP_PREFIX ;
  }

  function getUserLanguage() {
    /* @return: String
     *
     * Check the browser's default language and return
     *
     * 2006-06-28: droy
     *
     */

    $validLanguages = array('en', 'de', 'fr');
    $defaultLanguage = "en";

    # get the default browser language (first one reported)
    $language = substr($_SERVER['HTTP_ACCEPT_LANGUAGE'], 0, 2);

    if(array_search($language, $validLanguages)) {
        return $language;
    }
    else {
      return $defaultLanguage;
    }
  }

  function getLocalizedContentFilename() {
    /* @return: String
     *
     * return the content/xx_filename.php filename, according to availability of the file
     *
     * 2006-06-28: droy
     *
     */

    $language = $this->getUserLanguage();
    $filename = "content/" . $language . "_" . $this->getScriptName();

    if(!file_exists($filename)) {
      $filename = "content/en_" . $this->getScriptName();
    }

    return $filename;
  }


  function getScriptName() {
    # returns only the filename portion of a script
    return substr($_SERVER['SCRIPT_NAME'], strrpos($_SERVER['SCRIPT_NAME'], "/") + 1);
  }

  function getProjectCommon() {
    /** @return: String
     *
     * Walk up the directory structure to find the closest _projectCommon.php file
     *
     * 2005-12-06: droy
     * - created basic code to walk up all the way to the DocumentRoot
     *
     */

    $currentScript   = $_SERVER['SCRIPT_FILENAME'];
    $strLen     = strlen($currentScript);
    $found       = false;
    $antiLooper    = 0;

    # default to /home/_projectCommon.php
    $rValue     = $_SERVER['DOCUMENT_ROOT'] . "/home/_projectCommon.php";


    while($strLen > 1 && ! $found) {
      $currentScript   = substr($_SERVER['SCRIPT_FILENAME'], 0, strrpos($currentScript, "/"));
      $testPath     = $currentScript . "/_projectCommon.php";

      if(file_exists($testPath)) {
        $found   = true;
        $rValue = $testPath;
      }
      $strLen = strlen($currentScript);

      # break free from endless loops
      $antiLooper++;
      if($antiLooper > 20) {
        $found = true;
      }
    }
    return $rValue;
  }

  /**
   * Getting the IP address of the user
   * @param string
   * */
  function getRemoteIPAddress() {
    if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
      return $_SERVER['HTTP_CLIENT_IP'];
    } else if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
      return $_SERVER['HTTP_X_FORWARDED_FOR'];
    }
    return $_SERVER['REMOTE_ADDR'];
  }

  /**
   * Getting the subnet the user is in right now.
   * @param string
   * */
  function getSubnet(){
    $ip_address = $this->getRemoteIPAddress();
    $subnet = preg_replace('~(\d+)\.(\d+)\.(\d+)\.(\d+)~', "$1.$2.$3", $ip_address);
    return $subnet;
  }


  /**
   * This function look for the word staging in the URL
   * @return boolean
   * */
  function is_staging() {
    if(strpos($_SERVER['HTTP_HOST'], 'staging')){
      return TRUE;
    }
    return FALSE;
  }

  /**
   *  Sets the headers to prevent caching for the different browsers.
   *
   *  *** Deprecated function ***
   *  Please use preventCaching() instead.
   */
  function runStdWebAppCacheable() {
    $this->preventCaching();
  }

  /**
   *  Sets the headers to prevent caching for the different browsers.
   */
  function preventCaching() {
     session_start();
     header("Cache-Control: no-store, no-cache, private, must-revalidate, max-age=0, max-stale=0");
     header("Cache-Control: post-check=0, pre-check=0", FALSE);
     header("Pragma: no-cache");
     header("Expires: 0");
  }

  function getAlphaCode($_NumChars)
  {
    # Accept: int - number of chars
    # return: string - random alphanumeric code


    # Generate alpha code
    $addstring = "";
    for ($i = 1; $i <= $_NumChars; $i++) {
      if(rand(0,1) == 1) {
        # generate character
        $addstring = $addstring . chr(rand(0,5) + 97);
      }
      else {
        $addstring = $addstring . rand(0,9);
      }
    }
    return $addstring;
  }

  function getCURDATE() {
    return date("Y-m-d");
  }

  function addOrIfNotNull($_String) {
    # Accept: String - String to be AND'ed
    # return: string - AND'ed String

    if($_String != "") {
      $_String = $_String . " OR ";
    }

    return $_String;
  }

  function addAndIfNotNull($_String) {
    # Accept: String - String to be AND'ed
    # return: string - AND'ed String

    if($_String != "") {
      $_String = $_String . " AND ";
    }

    return $_String;
  }

  function getNumCode($_NumChars)
  {
    # Accept: int - number of chars
    # return: int - random numeric code


    # Generate code
    $addstring = "";
    for ($i = 1; $i <= $_NumChars; $i++) {
      if($i > 1) {
        # generate first digit
        $addstring = $addstring . rand(1,9);
      }
      else {
        $addstring = $addstring . rand(0,9);
      }
    }
    return $addstring;
  }

  function str_replace_count($find, $replace,$subject, $count) {
    # Replaces $find with $replace in $subnect $count times only

    $nC = 0;

    $subjectnew = $subject;
    $pos = strpos($subject, $find);
    if ($pos !== FALSE)   {
      while ($pos !== FALSE) {
        $nC++;
        $temp = substr($subjectnew, $pos+strlen($find));
        $subjectnew = substr($subjectnew, 0, $pos) . $replace . $temp;
        if ($nC >= $count)   {
          break;
        }
            $pos = strpos($subjectnew, $find);
      }
    }
    return $subjectnew;
  }

  function returnQuotedString($_String)
  {
    # Accept: String - String to be quoted
    # return: string - Quoted String

    // replace " with '
    # $_String = str_replace('"', "'", $_String);
    # https://bugs.eclipse.org/bugs/show_bug.cgi?id=299682#c1
    $_String = addslashes($_String);

    return "\"" . $_String . "\"";
  }

  function returnHTMLSafeString($_String)
  {
    # Accept: String - String to be HTMLSafified
    # return: string

    // replace " with '
    $_String = str_replace('<', "&lt;", $_String);
    $_String = str_replace('<', "&gt;", $_String);
    $_String = str_replace("\n", "<br />", $_String);

    return $_String;
  }

  function returnJSSAfeString($_String)
  {
    # Accept: String - String to be quoted
    # return: string - Quoted String

    // replace " with '
    $_String = str_replace("'", "\\'", $_String);

    return $_String;
  }

  function replaceEnterWithBR($_String) {
    return str_replace("\n", "<br />", $_String);
  }

  function generatePage($theme, $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html, $Breadcrumb = NULL) {
    # Strip html tags from the page title.
    $pageTitle = strip_tags($pageTitle);

    # Breadcrumbs for the new solstice theme.
    if ($Breadcrumb == NULL || !is_object($Breadcrumb)) {
      require_once('breadcrumbs.class.php');
      $Breadcrumb = new Breadcrumb();
    }

    if ($theme != "solstice" && $theme != "Nova" && $theme != "polarsys" ) {
      $theme = "solstice";
    }

    if($pageTitle == "") {
      $pageTitle = "eclipse.org page";
    }

    # page-specific RSS feed
    if($this->PageRSS != "") {
      if ($this->PageRSSTitle != "") {
        $this->PageRSSTitle = "Eclipse RSS Feed";
      }
      $this->ExtraHtmlHeaders .= '<link rel="alternate" title="' . $this->PageRSSTitle . '" href="' . $this->PageRSS . '" type="application/rss+xml"/>';
    }

    $extraHtmlHeaders = $this->ExtraHtmlHeaders;

    include($this->getHeaderPath($theme));

    if ($Menu != NULL)
    include($this->getMenuPath($theme));

    if ($Nav != NULL)
    include($this->getNavPath($theme));

    echo $html;

    $gaCode = $this->projectGoogleAnalyticsCode;
    if (!is_null($gaCode)) {
      $gaCode = ($gaCode == "") ? 'UA-910670-2' : $gaCode;
      #first lets insert the sitewide Analytics
      $this->googleJavaScript  = <<<EOHTML
      <script type="text/javascript">

        var _gaq = _gaq || [];
        _gaq.push(['_setAccount', '$gaCode']);
        _gaq.push(['_trackPageview']);

        (function() {
          var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
          ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
          var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
        })();

      </script>
EOHTML;

    }

    if ($theme != "solstice")  {
      echo $this->googleJavaScript;
    }

    $google_javascript = $this->googleJavaScript;
    include($this->getFooterPath($theme));
  }

  function AddExtraHtmlHeader( $string ) {
    $this->ExtraHtmlHeaders .= $string;
  }

  function AddExtraJSFooter( $string ) {
    $this->ExtraJSFooter.= $string;
  }

  function getThemeURL($_theme) {
  	if ($_theme != "solstice" || $_theme != "Nova" || $_theme != "polarsys" ) {
      $theme = "solstice";
    }

    return "/eclipse.org-common/themes/" . $_theme;

  }

  function getHTTPParameter($_param_name, $_method="") {
    /** @author droy
     * @since version - Oct 19, 2006
     * @param String _param_name name of the HTTP GET/POST parameter
     * @param String _method GET or POST, or the empty string for POST,GET order
     * @return String HTTP GET/POST parameter value, or the empty string
     *
     * Fetch the HTTP parameter
     *
     */

    $rValue = "";
    $_method = strtoupper($_method);

    # Always fetch the GET VALUE, override with POST unless a GET was specifically requested
    if(isset($_GET[$_param_name])) {
      $rValue = $_GET[$_param_name];
    }
    if(isset($_FILES[$_param_name]) && $_method == "FILES") {
      $rValue = $_FILES[$_param_name];
    }
    if((isset($_POST[$_param_name])) && ($_method != "GET" || $_method != "FILES")) {
      $rValue = $_POST[$_param_name];
    }
    return $rValue;
  }

  function getClientOS() {

        $UserAgent = $_SERVER['HTTP_USER_AGENT'];

        $regex_windows  = '/([^dar]win[dows]*)[\s]?([0-9a-z]*)[\w\s]?([a-z0-9.]*)/i';
        $regex_mac      = '/(68[k0]{1,3})|(mac os x)|(darwin)/i';
        $regex_os2      = '/os\/2|ibm-webexplorer/i';
        $regex_sunos    = '/(sun|i86)[os\s]*([0-9]*)/i';
        $regex_irix     = '/(irix)[\s]*([0-9]*)/i';
        $regex_hpux     = '/(hp-ux)[\s]*([0-9]*)/i';
        $regex_aix      = '/aix([0-9]*)/i';
        $regex_dec      = '/dec|osfl|alphaserver|ultrix|alphastation/i';
        $regex_vms      = '/vax|openvms/i';
        $regex_sco      = '/sco|unix_sv/i';
        $regex_linux    = '/x11|inux/i';
        $regex_bsd      = '/(free)?(bsd)/i';
        $regex_amiga    = '/amiga[os]?/i';
        $regex_ppc    = '/ppc/i';

        $regex_x86_64   = "/x86_64/i";

        // look for Windows Box
        if(preg_match_all($regex_windows,$UserAgent,$match))  {


      $v  = $match[2][count($match[0])-1];
            $v2 = $match[3][count($match[0])-1];

      // Establish NT 6.0 as Vista
      if(stristr($v,'NT') && $v2 == 6.0) $v = 'win32';

      // Establish NT 5.1 as Windows XP
      elseif(stristr($v,'NT') && $v2 == 5.1) $v = 'win32';

      // Establish NT 5.0 and Windows 2000 as win2k
            elseif($v == '2000') $v = '2k';
      elseif(stristr($v,'NT') && $v2 == 5.0) $v = 'win32';

      // Establish 9x 4.90 as Windows 98
            elseif(stristr($v,'9x') && $v2 == 4.9) $v = 'win32';
      // See if we're running windows 3.1
            elseif($v.$v2 == '16bit') $v = 'win16';
                // otherwise display as is (31,95,98,NT,ME,XP)
      else $v .= $v2;
      // update browser info container array
      if(empty($v)) $v = 'win32';
      return (strtolower($v));
    }

                //  look for amiga OS
                elseif(preg_match($regex_amiga,$UserAgent,$match))  {
                        if(stristr($UserAgent,'morphos')) {
                        // checking for MorphOS
                                return ('morphos');
                                }
                }
                        elseif(stristr($UserAgent,'mc680x0')) {
                        // checking for MC680x0
                        return ('mc680x0');
                        }
                        elseif(preg_match('/(AmigaOS [\.1-9]?)/i',$UserAgent,$match)) {
                              // checking for AmigaOS version string
                                return ($match[1]);
                        }
                // look for OS2
                elseif( preg_match($regex_os2,$UserAgent))  {
                        return ('os2');
                }
                // look for mac
                // sets: platform = mac ; os = 68k or ppc
                elseif( preg_match($regex_mac,$UserAgent,$match) )
                {
                    $os = !empty($match[1]) ? 'mac68k' : '';
                    $os = !empty($match[2]) ? 'macosx' : $os;
                    $os = !empty($match[3]) ? 'macppc' : $os;
                    $os = !empty($match[4]) ? 'macosx' : $os;
                    return ('macosx');
                }
                //  look for *nix boxes
                //  sunos sets: platform = *nix ; os = sun|sun4|sun5|suni86
                elseif(preg_match($regex_sunos,$UserAgent,$match))
                {
                    if(!stristr('sun',$match[1])) $match[1] = 'sun'.$match[1];
                    return ('solaris');
                }
                //  irix sets: platform = *nix ; os = irix|irix5|irix6|...
                elseif(preg_match($regex_irix,$UserAgent,$match))
                {
                    return ($match[1].$match[2]);
                }
                //  hp-ux sets: platform = *nix ; os = hpux9|hpux10|...
                elseif(preg_match($regex_hpux,$UserAgent,$match))
                {
                    $match[1] = str_replace('-','',$match[1]);
                    $match[2] = (int) $match[2];
                    return ('hpux');
                }
                //  aix sets: platform = *nix ; os = aix|aix1|aix2|aix3|...
                elseif(preg_match($regex_aix,$UserAgent,$match))
                {
                    return ('aix');
                }
                //  dec sets: platform = *nix ; os = dec
                elseif(preg_match($regex_dec,$UserAgent,$match))
                {
                    return ('dec');
                }
                //  vms sets: platform = *nix ; os = vms
                elseif(preg_match($regex_vms,$UserAgent,$match))
                {
                    return ('vms');
                }
                //  dec sets: platform = *nix ; os = dec
                elseif(preg_match($regex_dec,$UserAgent,$match))
                {
                    return ('dec');
                }
                //  vms sets: platform = *nix ; os = vms
                elseif(preg_match($regex_vms,$UserAgent,$match))
                {
                    return ('vms');
                }
                //  sco sets: platform = *nix ; os = sco
                elseif(preg_match($regex_sco,$UserAgent,$match))
                {
                    return ('sco');
                }
                //  unixware sets: platform = *nix ; os = unixware
                elseif(stristr($UserAgent,'unix_system_v'))
               {
                    return ('unixware');
                }
                //  mpras sets: platform = *nix ; os = mpras
                elseif(stristr($UserAgent,'ncr'))
                {
                    return ('mpras');
                }
                //  reliant sets: platform = *nix ; os = reliant
                elseif(stristr($UserAgent,'reliantunix'))
                {
                    return ('reliant');
                }
                //  sinix sets: platform = *nix ; os = sinix
                elseif(stristr($UserAgent,'sinix'))
                {
                    return ('sinix');
                }
                //  bsd sets: platform = *nix ; os = bsd|freebsd
                elseif(preg_match($regex_bsd,$UserAgent,$match))
                {
                    return ($match[1].$match[2]);
                }
                //  last one to look for
                //  linux sets: platform = *nix ; os = linux
                elseif(preg_match($regex_linux,$UserAgent,$match))
                {

                        if(preg_match($regex_x86_64,$UserAgent,$match)) {
                                return "linux-x64";
                        }
                        elseif(preg_match($regex_ppc,$UserAgent,$match)) {
                                return "linux-ppc";
                        }
                        else {
                                return ('linux');
                        }
                }
        }


        function isValidTheme($_theme) {
    /* @return: bool
     *
     * returns true if supplied theme is in the array of valid themes
     *
     * 2005-12-07: droy
     *
     */
          return array_search($_theme, $this->THEME_LIST);
        }


        function getUserPreferedTheme() {
    /* @return: String
     *
     * returns theme name in a browser cookie, or the Empty String
     *
     * 2005-12-07: droy
     *
     */
          if(isset($_COOKIE["theme"])) {
        $theme = $_COOKIE["theme"];

        if($this->isValidTheme($theme)) {
          return $theme;
        }
        else {
          return "";
        }
          }
        }

        /**
         * @param layout string Button layout (standard, condensed)
         * @param showfaces bool
         * @author droy
         * @since 2011-05-18
         * @return: HTML string for facebook like
         * Generate HTML string for facebook like button
         */
        function getFacebookLikeButtonHTML($_layout="standard", $_showfaces=false) {

          $width   = 450;
          $height  =  22;

          if($_layout == "condensed") {
            $width = 90;
            $_layout = "button_count";
          }
          else {
            $_layout = "standard";
          }

          if($_showfaces) {
            $height = 82;
          }
          $str = "<iframe src='//www.facebook.com/plugins/like.php?href=" . $this->getCurrentURL() . "&layout=" . $_layout . "&" . ($_showfaces ? "show_faces=true" : "") . "&width=$width&action=like' style='border: medium none; overflow: hidden; width: " . $width . "px; height: " . $height . "px;' frameborder='0' scrolling='no'></iframe>";
          return $str;
        }
        /**
         * @author droy
         * @since 2011-05-18
         * @return URL of the current PHP page
         * Construct and return URL of the current script
         */
        function getCurrentURL() {
          return "http" . ((empty($_SERVER['HTTPS']) && $_SERVER['SERVER_PORT']!=443) ? "" : "s") . "://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
        }

        function usePolls() {
          require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/polls/poll.php");
        }
        function useJSON() {
          require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/json/JSON.php");
        }

        /**
         * Returns a new REST client
         * @return RestClient
         * @since 2015-06-24
         * @author droy
         */
        function RESTClient() {
          require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/rest/restclient.class.php");
          return new RestClient();
        }

        function useProjectInfo() {
          require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/projects/projectInfoList.class.php");
        }
        /*
         * This function applies standard formatting to a date.
         *
         * The first parameter is either a string or a number representing a date.
         * If it's a string, it must be in a format that is parseable by the
         * strtotime() function. If it is a number, it must be an integer representing
         * a UNIX timestamp (number of seconds since January 1 1970 00:00:00 GMT)
         * which, conveniently, is the output of the strtotime() function.
         *
         * The second (optional) parameter is the format for the result. This must
         * one of 'short', or 'long'.
         */
        function getFormattedDate($date, $format = 'long') {
          if (is_string($date)) $date = strtotime($date);
          switch ($format) {
            case 'long' : return date("F j, Y", $date);
            case 'short' : return date("d M y", $date);
          }
        }

        /*
         * This function applies standard formatting to a date range.
         *
         * See the comments for getFormattedDate($date, $format) for information
         * concerning what's expected in the parameters of this method).
         */
        function getFormattedDateRange($start_date, $end_date, $format) {
          if (is_string($start_date)) $start_date = strtotime($start_date);
          if (is_string($end_date)) $end_date = strtotime($end_date);
          switch ($format) {
            case 'long' :
              if ($this->same_year($start_date, $end_date)) {
            if ($this->same_month($start_date, $end_date)) {
              return date("F", $start_date)
                . date(" d", $start_date)
                . date("-d, Y", $end_date);
            } else {
              return date("F d", $start_date)
                . date("-F d, Y", $end_date);
            }
          } else {
            return date("F d, Y", $start_date)
              . date("-F d, Y", $end_date);
          }
            case 'short' :
              if ($this->same_year($start_date, $end_date)) {
            if ($this->same_month($start_date, $end_date)) {
              return date("d", $start_date)
                . date ("-d", $end_date)
                . date(" M", $start_date)
                . date(" y", $end_date);
            } else {
              return date("d M", $start_date)
                . date("-d M y", $end_date);
            }
          } else {
            return date("d M y", $start_date)
              . date("-d M y", $end_date);
          }
          }
        }

        /*
         * This method answers true if the two provided values represent
         * dates that occur in the same year.
         */
    function same_year($a, $b) {
      return date("Y", $a) == date("Y", $b);
    }

        /*
         * This method answers true if the two provided values represent
         * dates that occur in the same month.
         */
    function same_month($a, $b) {
      return date("F", $a) == date("F", $b);
    }

    /**
     * Returns a string representing the size of a file in the downloads area
     * @author droy
     * @since Jun 7, 2007
     * @param string file File name relative to http://download.eclipse.org (the &file= parameter used)
     * @return string Returns a string in the format of XX MB
     */
    function getDownloadFileSizeString($_file) {
      $fileSize = "N/A";
      $filesizebytes  = filesize($this->getDownloadBasePath() . $_file);
      if($filesizebytes > 0) {
        $fileSize = floor($filesizebytes / 1048576) . " MB";
      }
      return $fileSize;
    }

    /**
     * useSession(String) - use auth sessions
     * @author droy
     * @since Jun 7, 2007
     * @param string 'optional' or 'required'
     * @return Session object
     */
    function useSession($required="") {
      require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/session.class.php");
          $ssn = new Session();  # constructor calls validate
          if ($ssn->getGID() == "" && $required == "required") {
            $ssn->redirectToLogin();
      }
          return $ssn;
    }

    function isValidCaller($_pathArray) {
      $a = debug_backtrace();
      $caller = $a[1]['file'];  # Caller 0 is the class that called App();
      $validCaller = false;
      for($i = 0; $i < count($_pathArray); $i++) {
        # TODO: use regexp's to match the leftmost portion for better security
        if(strstr($caller, $_pathArray[$i])) {
          $validCaller = true;
          break;
        }
      }
      return $validCaller;
    }

    function sqlSanitize($_value, $_dbh=NULL) {
     /**
     * Sanitize incoming value to prevent SQL injections
     * @param string value to sanitize
     * @param dbh database resource to use
     * @return string santized string
     */
      if ($_dbh==NULL) {
        $_dbh = $this->database( "eclipse", "" );
      }
      $_value = mysql_real_escape_string($_value, $_dbh);
          return $_value;
    }
  function getOGTitle(){
    return '<meta property="og:title" content="' . $this->OGTitle . '" />' . PHP_EOL;
  }

  function setOGTitle($title){
    $this->OGTitle = $title;
  }

  function getOGDescription(){
    return '<meta property="og:description" content="' . $this->OGDescription . '" />' . PHP_EOL;
  }

  function setOGDescription($description){
    $this->OGDescription = $description;
  }

  function getOGImage(){
    return '<meta property="og:image" content="' . $this->OGImage . '" />' . PHP_EOL;
  }

  function setOGImage($image){
    $this->OGImage = $image;
  }

  function setDoctype($doctype) {
    $accepted = array('html5', 'xhtml');
    if (in_array($doctype, $accepted)) {
      $this->doctype = $doctype;
    }
    return;
  }

  function getDoctype() {
    $doc = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML+RDFa 1.0//EN" "http://www.w3.org/MarkUp/DTD/xhtml-rdfa-1.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">';
    switch ($this->doctype) {
      case 'html5':
        $doc = '<!DOCTYPE html>
<html>';
        break;
    }
    return $doc;
  }

  /**
   * Get theme Variables
   *
   * Fetch solstice custom variables
   *
   * @return array
   */
  public function getThemeVariables() {
    $v = $this->theme_variables;
    // Set default variables for all themes.
    if (empty($v)) {
      $v['body_classes'] = '';
      $v['breadcrumbs_html'] = "";
      $v['hide_breadcrumbs'] = FALSE;
      $v['leftnav_html'] = '';
      $v['main_container_classes'] = 'container';
      $v['main_container_html'] = '';
      $v['header_nav'] = array();
      $v['btn_cfa'] = array();
      $this->theme_variables = $v;
    }

    return $this->theme_variables;
  }

  /**
   * Set theme Variables
   *
   * This function allow pages to pass extra
   * parameters to the solstice theme.
   */
  public function setThemeVariables($variables) {
    $current_variables = $this->getThemeVariables();
    if (is_array($variables)) {
      $this->theme_variables = array_merge($current_variables, $variables);
    }
  }

  /**
   * Function to validate a date
   * @param string $date
   * @return boolean
   */
  private function validateDateFormat($date) {
    if (preg_match ("/^([0-9]{4})-([0-9]{2})-([0-9]{2})$/", $date, $d)) {
      //date validation
      if (checkdate($d[2],$d[3],$d[1])) {
        return TRUE;
      }
    }
    return FALSE;
  }

  /**
   * Function to set the OutDated flag
   * @param string $when.
   *   Accepted formats 'YYYY-MM-DD' or 'now'.
   *
   * @return boolean
   */
  function setOutDated($when = 'now', $msg = "") {
    if (is_string($msg)) {
      $this->OutDatedMsg = $msg;
    }

    if (strtolower($when) == 'now' || ($this->validateDateFormat($when) && time() >= strtotime($when))) {
      $this->OutDated = TRUE;
      return TRUE;
    }
    return FALSE;
  }

  /**
   * Return value of the private property OutDatedMsg.
   */
  function getOutDatedMessage() {
    if (empty($this->OutDatedMsg)) {
      $this->OutDatedMsg = "This page is deprecated and may contain some information that is no longer relevant or accurate.";
    }
    return $this->OutDatedMsg;
  }

  /**
   * Return value of the private property OutDated.
   */
  function getOutDated() {
    return $this->OutDated;
  }

  /**
   * Function to set the version of jQuery
   * @param string $version
   *
   * @return boolean
   */
  function setjQueryVersion($version = FALSE){
    //Only set jQueryVersion if we have a copy on eclipse.org
    $supported = array('1.4.4', '1.5.1', '1.5.2', '1.7.2', '1.9.1', '2.0.0');
    if(in_array($version, $supported)){
      $this->jQueryVersion = $version;
      return TRUE;
    }
    return FALSE;
  }

  /**
   * Return markup needed to load jQuery
   * @return string|boolean
   */
  function getjQuery(){
    if($this->jQueryVersion){
      $strn = <<<EOHTML
  <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/$this->jQueryVersion/jquery.min.js"></script>
  <script type="text/javascript">
  /* <![CDATA[ */
  window.jQuery || document.write('<script src="/eclipse.org-common/lib/jquery/jquery-$this->jQueryVersion.min.js"><\/script>')
  /* ]]> */
  </script>
EOHTML;
      return $strn;
    }
    return FALSE;
  }

  /**
   * Return The Eclipse Foundation Twitter and Facebook badge
   * @return string
   */
  function getSocialBadge(){
    $protocol = $this->getHTTPPrefix();
    $strn = <<<EOHTML
    <script type="text/javascript">
    /* <![CDATA[ */
    document.write('<div id=\"badge_facebook\"><iframe src=\"$protocol:\/\/www.facebook.com\/plugins\/like.php?href=http:\/\/www.facebook.com\/pages\/Eclipse\/259655700571&amp;layout=button_count&amp;show_faces=false&amp;width=90&amp;action=like\" frameborder=\"0\" scrolling=\"no\"><\/iframe><\/div><div id=\"badge_twitter\"><a href=\"https:\/\/twitter.com\/EclipseFdn\" class=\"twitter-follow-button\" data-show-count=\"false\">Follow @EclipseFdn<\/a><script type=\"text\/javascript\">!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=\"\/\/platform.twitter.com\/widgets.js\";fjs.parentNode.insertBefore(js,fjs);}}(document,\"script\",\"twitter-wjs\");<\/script><\/div>');
    /* ]]> */
    </script>
EOHTML;
    return $strn;
  }

  function getTwitterFollowWidget($_twitterhandle)
  {
    $output = '';
    $output = '<a href="https://twitter.com/'. $_twitterhandle .'" class="twitter-follow-button" data-show-count="false">Follow @' .$_twitterhandle . '</a>';
    // Only include the script once per page
    if ($this->twitterScriptInserted == FALSE) {
      $this->twitterScriptInserted = TRUE;
      $output .= "<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+'://platform.twitter.com/widgets.js';fjs.parentNode.insertBefore(js,fjs);}}(document, 'script', 'twitter-wjs');</script>";
    }
    return $output;

  }

  function getGoogleSearchHTML() {
    $strn = <<<EOHTML
    <form action="//www.google.com/cse" id="searchbox_017941334893793413703:sqfrdtd112s">
     <input type="hidden" name="cx" value="017941334893793413703:sqfrdtd112s" />
      <input type="text" name="q" size="25" />
      <input type="submit" name="sa" value="Search" />
    </form>
    <script type="text/javascript" src="//www.google.com/coop/cse/brand?form=searchbox_017941334893793413703%3Asqfrdtd112s&lang=en"></script>
EOHTML;
    return $strn;
  }

  /**
   * Set Google Analytics Tracking code
   *
   * @param string OR Null $gaUniqueID
   *
   * Setting $gaUniqueID to NULL will remove Google Analytics
   * from the page.
   */
  function setGoogleAnalyticsTrackingCode($gaUniqueID) {
    $this->projectGoogleAnalyticsCode = $gaUniqueID;
  }

  function setPromotionPath($_path) {
    $this->CustomPromotionPath = $_SERVER['DOCUMENT_ROOT'] . $_path;
  }

  /**
   * Use reCAPTCHA service
   *
   * @param bool $ssl
   *
   * @return Captcha
   */
  public function useCaptcha($ssl = true) {
    include_once($_SERVER['DOCUMENT_ROOT'] . '/eclipse.org-common/classes/captcha/captcha.class.php');
    return new Captcha($ssl);
  }

  # Record a database record
  public function setDatabase( $key, $host, $user, $pwd, $db ) {
    $rec = array() ;
    $rec['HOST'] = $host;
    $rec['USERNAME'] = $user;
    $rec['PASSWORD'] = $pwd;
    $rec['DATABASE'] = $db;
    $rec['CONNECTION'] = null;
    $this->databases[$key] = $rec;
    }

    # Setup the handling of database connections.  On production systems, reference the database connection
    # classes, but on development systems, use the standardized local database distribution.
  private function configureDatabases() {
    #-----------------------------------------------------------------------------------------------------
    # Dev Mode Databases
    $this->setDatabase( "myfoundation", "localhost", "dashboard", "draobhsad", "myfoundation_demo" );
    $this->setDatabase( "foundation",   "localhost", "dashboard", "draobhsad", "myfoundation_demo" );
    $this->setDatabase( "eclipse",      "localhost", "dashboard", "draobhsad", "myfoundation_demo" );
    $this->setDatabase( "bugzilla",     "localhost", "dashboard", "draobhsad", "myfoundation_demo" );
    $this->setDatabase( "downloads",  "localhost", "dashboard", "draobhsad", "myfoundation_demo" );
    $this->setDatabase( "polls",     "localhost", "dashboard", "draobhsad", "myfoundation_demo" );
    $this->setDatabase( "projectinfo",  "localhost", "dashboard", "draobhsad", "myfoundation_demo" );
    $this->setDatabase( "packaging",   "localhost", "dashboard", "draobhsad", "packaging_demo" );
    $this->setDatabase( "infra",     "localhost", "dashboard", "draobhsad", "infra_demo" );
    $this->setDatabase( "ipzilla",     "localhost", "dashboard", "draobhsad", "ipzilla_demo" );
    $this->setDatabase( "ipzillatest",  "localhost", "dashboard", "draobhsad", "ipzilla_demo" );
    $this->setDatabase( "live",      "localhost", "dashboard", "draobhsad", "live_demo" );
    $this->setDatabase( "epic",     "localhost", "dashboard", "draobhsad", "epic_demo" );
    $this->setDatabase( "conferences",  "localhost", "dashboard", "draobhsad", "conferences_demo" );
    $this->setDatabase( "marketplace",   "localhost", "dashboard", "draobhsad", "marketplace_demo" );
    #-----------------------------------------------------------------------------------------------------

    #-----------------------------------------------------------------------------------------------------
    # Production Databases
    $this->set("bugzilla_db_classfile_ro",  'dbconnection_bugs_ro.class.php');
    $this->set("bugzilla_db_class_ro",    'DBConnectionBugs');
    $this->set("bugzilla_db_classfile",     'dbconnection_bugs_rw.class.php');
    $this->set("bugzilla_db_class",       'DBConnectionBugsRW');
    $this->set("dashboard_db_classfile",  'dbconnection_dashboard_rw.class.php');
    $this->set("dashboard_db_class",     'DBConnectionDashboard');
    $this->set("downloads_db_classfile_ro",  'dbconnection_downloads_ro.class.php');
    $this->set("downloads_db_class_ro",     'DBConnectionDownloads');
    $this->set("epic_db_classfile_ro",     'dbconnection_epic_ro.class.php');
    $this->set("epic_db_class_ro",        'DBConnectionEPIC');
    $this->set("packaging_db_classfile_ro",  'dbconnection_packaging_ro.class.php');
    $this->set("packaging_db_class_ro",    'DBConnectionPackaging');
    $this->set("foundation_db_classfile",  'dbconnection_workaround.class.php');
    $this->set("foundation_db_class",     'FoundationDBConnectionRW');
    $this->set("foundation_db_classfile_ro",'dbconnection_foundation_ro.class.php');
    $this->set("foundation_db_class_ro",   'DBConnectionFoundation');
    $this->set("gerrit_db_classfile_ro",  'dbconnection_gerrit_ro.class.php');
    $this->set("gerrit_db_class_ro",    'DBConnectionGerrit');
    $this->set("infra_db_classfile",     'dbconnection_infra_ro.class.php');
    $this->set("infra_db_class",        'DBConnectionInfraRO');
    $this->set("ipzilla_db_classfile_ro",  'dbconnection_ipzilla_ro.class.php');
    $this->set("ipzilla_db_class_ro",     'DBConnectionIPZillaRO');
    $this->set("ipzilla_db_classfile",     'dbconnection_ipzilla_rw.class.php');
    $this->set("ipzilla_db_class",        'DBConnectionIPZillaRW');
    $this->set("ipzillatest_db_classfile",  'dbconnection_ipzillatest_rw.class.php');
    $this->set("ipzillatest_db_class",     'DBConnectionIPZillaRW');
    $this->set("live_db_classfile",        'dbconnection_live_rw.class.php');
    $this->set("live_db_class",          'DBConnectionLIVE');
    $this->set("polls_db_classfile",     'dbconnection_polls_rw.class.php');
    $this->set("polls_db_class",       'DBConnectionPollsRW');
    $this->set("myfoundation_db_classfile",  'dbconnection_portal_rw.class.php');
    $this->set("myfoundation_db_class",     'DBConnectionPortalRW');
    $this->set("projectinfo_db_classfile_ro",'dbconnection_projectinfo_ro.class.php');
    $this->set("projectinfo_db_class_ro",   'DBConnectionProjectInfo');
    $this->set("eclipse_db_classfile",     'dbconnection_rw.class.php');
    $this->set("eclipse_db_class",       'DBConnectionRW');
    $this->set("eclipse_db_classfile_ro",  'dbconnection.class.php');
    $this->set("eclipse_db_class_ro",     'DBConnection');
    $this->set("conferences_db_classfile",  'dbconnection.conferences_rw.class.php');
    $this->set("conferences_db_class",      'DBConnectionConferencesRW');
    $this->set("marketplace_db_classfile_ro",     'dbconnection_marketplace_ro.class.php');
    $this->set("marketplace_db_class_ro",      'DBConnectionMarket');
    #-----------------------------------------------------------------------------------------------------
  }

  # Open a database and store the record
  public function database( $key, $query ) {
    $rec = $this->databases[$key];
    $dbh = null;
    if($this->devmode) {   # For DEV machines
        $dbh = $rec['CONNECTION'];
        if( $dbh == null ) {
          $dbh = mysql_connect( $rec['HOST'], $rec['USERNAME'], $rec['PASSWORD']);
           mysql_select_db($rec['DATABASE'], $dbh);
        }
        if(get_magic_quotes_gpc())
        {
          trigger_error("magic_quotes_gpc is currently set to ON in your php.ini. This is highly DISCOURAGED.  Please change your setting or comment out this line.");
        }
    } else {         # For PRODUCTION machines
      $class = null;
      if( (strtoupper(substr(trim($query), 0, 6)) == 'SELECT' && strtoupper(substr(trim($query), 0, 23)) != "SELECT /* USE MASTER */")
        || $query == "") {  // Try to use read-only when possible. Blank queries occur when we call sqlSanitize.

        $classfile = $this->get($key . '_db_classfile_ro');
        $class = $this->get($key . '_db_class_ro');
      }

      if($class == null) {
        $classfile = $this->get($key . '_db_classfile');
        $class = $this->get($key . '_db_class');
      }

      require_once($this->DB_CLASS_PATH . $classfile);
      $dbc = new $class();
      $dbh = $dbc->connect();
    }
    $this->databases[$key]['CONNECTION'] = $dbh;
    $this->set('DBHANDLEMAP ' . $dbh, $key);
    return $dbh;
  }

  # Return a record for a database by name
  public function databaseName( $key ) {
    $rec = $this->databases[$key];
    return $rec['DATABASE'];
  }

  # Return the name of a database by database handle
  public function databaseNameForHandle($dbh) {
    return $this->get('DBHANDLEMAP ' . $dbh);
  }

  # Storage functions for arbitraray hash
  public function get( $key ) {
    if(isset($this->hash[$key])) {
      return $this->hash[$key];
    }
  }

  # Storage functions for arbitraray hash
  public function set( $key, $value ) {
    $this->hash[$key] = $value;
  }

  # Storage functions for arbitraray hash
  public function ifEmptyThenSet( $key, $value ) {
    if( !isset($this->hash[$key])) {
      $this->hash[$key] = $value;
    }
  }

  # Display a backtrace of all the SQL queries run in this session.  Only available when devmode == true or logsql == true.
  function SQLBacktrace () {
    if(($this->devmode && (count($this->query_btrace) > 0)) || $this->logsql){
        $row = 1;
        echo "<p><table cellpadding=10 width=800 bgcolor=#ffcccc><tr><td>";
        echo "<p><font size=\"+2\">Query Trace: </font> In ascending order from oldest to newest";
        echo "<div style=\"font-family: courier;\">";
        foreach ($this->query_btrace as $query) {
          echo "&nbsp;&nbsp;&nbsp;&nbsp;<b>$row.) " .
            $query{0} ." (" . $query{2} . ")rows:</b> " . $query{1} . "<br>\n";
          $row++;
        }
        echo "</div>";
        echo "</p>\n";
        echo "</table></p>\n";
      }
  }

  # Check if a MySQL error occurred and display it.  If $this->devmode then an
  # SQL backtrace is shown as well.
  function mysqlErrorCheck () {
    $error = mysql_error();
    if ($error) {
      echo "<p><table cellpadding=10 width=400 bgcolor=#ffcccc><tr><td><font size=+2>SQL Trouble: </font>";
      echo "<font color=red>";
      echo htmlspecialchars ($error);
      echo "</font>\n";
      if($this->devmode || $this->logsql) {
        $backtrace = debug_backtrace();
        $file = $backtrace[2]['file'];
        $line = $backtrace[2]['line'];
        $function = $backtrace[2]['function'];
        echo "<br/>file: $file<br/>line: $line<br/>function: $function<br/>";
      }
    echo "</table></p>\n";
    if($this->devmode || $this->logsql) {
      $this->SQLBacktrace();
    }
    exit();
    }
  }

  # All in one query function
  function sql ($statement, $dbname, $logstring = null) {
    $dbh = $this->database( $dbname, $statement );

    $result = mysql_query($statement, $dbh);
    $rowcount = 0;

    # Only keep information in devmode so we don't waste RAM
    if($this->devmode || $this->logsql) {
      # Report on the number of rows affected by the query
      if(($result !== TRUE) && ($result !== FALSE)) {
        $rowcount = mysql_num_rows($result);
      } else {
        $rowcount = mysql_affected_rows($dbh);
      }

      if($logstring) {
        # This is used when inserting binary blobs so that the blob does not appear in the log
        $this->query_btrace[] = array($this->databaseNameForHandle($dbh), $logstring, $rowcount);
      } else {
        $this->query_btrace[] = array($this->databaseNameForHandle($dbh), $statement, $rowcount);
      }
    }

    $this->mysqlErrorCheck();
    return $result;
  }

  # These don't match the naming convention in $App but are used in the portal and submissions systems like this
  # so we'll leave them alone for consistency.
  function bugzilla_sql ($statement)   { return $this->sql ($statement, "bugzilla"); }     // Bugzilla
  function conference_sql ($statement){ return $this->sql ($statement, "conferences"); }    // Conferences
  function dashboard_sql ($statement) { return $this->sql ($statement, "dashboard"); }    // Dash
  function downloads_sql ($statement) { return $this->sql ($statement, "downloads"); }    // Downloads
  function eclipse_sql ($statement)   { return $this->sql ($statement, "eclipse"); }      // Whole Eclipse database
  function epic_sql ($statement)     { return $this->sql ($statement, "epic"); }        // EPIC (read-only!)
  function foundation_sql($statement) { return $this->sql ($statement, "foundation"); }    // Foundation internal database
  function gerrit_sql($statement)   { return $this->sql ($statement, "gerrit"); }      // Gerrit
  function ipzilla_sql ($statement)   { return $this->sql ($statement, "ipzilla"); }      // IPZilla
  function infra_sql ($statement)   { return $this->sql ($statement, "infra"); }      // Infra
  function ipzillatest_sql ($statement) { return $this->sql ($statement, "ipzillatest"); }  // IPZilla test database
  function live_sql ($statement)     { return $this->sql ($statement, "live"); }        // Eclipse Live (read-only!)
  function polls_sql ($statement)   { return $this->sql ($statement, "polls"); }      // Polls
  function portal_sql  ($statement)   { return $this->sql ($statement, "myfoundation"); }    // MyFoundation Portal
  function projectinfo_sql ($statement) { return $this->sql ($statement, "projectinfo"); }  // ProjectInfo tables only (read-only!)
  function packaging_sql ($statement)  { return $this->sql ($statement, "packaging"); }     // Packaging Database
  function marketplace_sql ($statement) { return $this->sql ($statement, "marketplace"); }   // Marketplace (read-only)
}