<?php

/*

 * Enano - an open-source CMS capable of wiki functions, Drupal-like sidebar blocks, and everything in between

 * Version 1.0.2 (Coblynau)

 * Copyright (C) 2006-2007 Dan Fuhry

 * install.php - handles everything related to installation and initial configuration

 *

 * This program is Free Software; you can redistribute and/or modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied

 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for details.

 */

@include('config.php');

if( ( defined('ENANO_INSTALLED') || defined('MIDGET_INSTALLED') ) && ((isset($_GET['mode']) && ($_GET['mode']!='finish' && $_GET['mode']!='css')) || !isset($_GET['mode']))) {

  $_GET['title'] = 'Enano:Installation_locked';

  require('includes/common.php');

  die_friendly('Installation locked', '<p>The Enano installer has found a Enano installation in this directory. You MUST delete config.php if you want to re-install Enano.</p><p>If you wish to upgrade an older Enano installation to this version, please use the <a href="upgrade.php">upgrade script</a>.</p>');

  exit;

}

define('IN_ENANO_INSTALL', 'true');

define('ENANO_VERSION', '1.0.2');

// In beta versions, define ENANO_BETA_VERSION here

if(!defined('scriptPath')) {

  $sp = dirname($_SERVER['REQUEST_URI']);

  if($sp == '/' || $sp == '\\') $sp = '';

  define('scriptPath', $sp);

}

if(!defined('contentPath')) {

  $sp = dirname($_SERVER['REQUEST_URI']);

  if($sp == '/' || $sp == '\\') $sp = '';

  define('contentPath', $sp);

}

global $_starttime, $this_page, $sideinfo;

$_starttime = microtime(true);

// Determine directory (special case for development servers)

if ( strpos(__FILE__, '/repo/') && file_exists('.enanodev') )

{

  $filename = str_replace('/repo/', '/', __FILE__);

}

else

{

  $filename = __FILE__;

}

define('ENANO_ROOT', dirname($filename));

function is_page($p)

{

  return true;

}

require('includes/wikiformat.php');

require('includes/constants.php');

require('includes/rijndael.php');

require('includes/functions.php');

strip_magic_quotes_gpc();

//die('Key size: ' . AES_BITS . '<br />Block size: ' . AES_BLOCKSIZE);

if(!function_exists('wikiFormat'))

{

  function wikiFormat($message, $filter_links = true)

  {

    $wiki = & Text_Wiki::singleton('Mediawiki');

    $wiki->setRenderConf('Xhtml', 'code', 'css_filename', 'codefilename');

    $wiki->setRenderConf('Xhtml', 'wikilink', 'view_url', contentPath);

    $result = $wiki->transform($message, 'Xhtml');

    // HTML fixes

    $result = preg_replace('#<tr>([\s]*?)<\/tr>#is', '', $result);

    $result = preg_replace('#<p>([\s]*?)<\/p>#is', '', $result);

    $result = preg_replace('#<br />([\s]*?)<table#is', '<table', $result);

    return $result;

  }

}

global $failed, $warned;

$failed = false;

$warned = false;

function not($var)

{

  if($var)

  {

    return false;

  } 

  else

  {

    return true;

  }

}

function run_test($code, $desc, $extended_desc, $warn = false)

{

  global $failed, $warned;

  static $cv = true;

  $cv = not($cv);

  $val = eval($code);

  if($val)

  {

    if($cv) $color='CCFFCC'; else $color='AAFFAA';

    echo "<tr><td style='background-color: #$color; width: 500px;'>$desc</td><td style='padding-left: 10px;'><img alt='Test passed' src='images/good.gif' /></td></tr>";

  } elseif(!$val && $warn) {

    if($cv) $color='FFFFCC'; else $color='FFFFAA';

    echo "<tr><td style='background-color: #$color; width: 500px;'>$desc<br /><b>$extended_desc</b></td><td style='padding-left: 10px;'><img alt='Test passed with warning' src='images/unknown.gif' /></td></tr>";

    $warned = true;

  } else {

    if($cv) $color='FFCCCC'; else $color='FFAAAA';

    echo "<tr><td style='background-color: #$color; width: 500px;'>$desc<br /><b>$extended_desc</b></td><td style='padding-left: 10px;'><img alt='Test failed' src='images/bad.gif' /></td></tr>";

    $failed = true;

  }

}

function is_apache() { $r = strstr($_SERVER['SERVER_SOFTWARE'], 'Apache') ? true : false; return $r; }

require_once('includes/template.php');

if(!isset($_GET['mode'])) $_GET['mode'] = 'welcome';

switch($_GET['mode'])

{

  case 'mysql_test':

    error_reporting(0);

    $dbhost     = rawurldecode($_POST['host']);

    $dbname     = rawurldecode($_POST['name']);

    $dbuser     = rawurldecode($_POST['user']);

    $dbpass     = rawurldecode($_POST['pass']);

    $dbrootuser = rawurldecode($_POST['root_user']);

    $dbrootpass = rawurldecode($_POST['root_pass']);

    if($dbrootuser != '')

    {

      $conn = mysql_connect($dbhost, $dbrootuser, $dbrootpass);

      if(!$conn)

      {

        $e = mysql_error();

        if(strstr($e, "Lost connection"))

          die('host'.$e);

        else

          die('root'.$e);

      }

      $rsp = 'good';

      $q = mysql_query('USE '.$dbname, $conn);

      if(!$q)

      {

        $e = mysql_error();

        if(strstr($e, 'Unknown database'))

        {

          $rsp .= '_creating_db';

        }

      }

      mysql_close($conn);

      $conn = mysql_connect($dbhost, $dbuser, $dbpass);

      if(!$conn)

      {

        $e = mysql_error();

        if(strstr($e, "Lost connection"))

          die('host'.$e);

        else

          $rsp .= '_creating_user';

      }

      mysql_close($conn);

      die($rsp);

    }

    else

    {

      $conn = mysql_connect($dbhost, $dbuser, $dbpass);

      if(!$conn)

      {

        $e = mysql_error();

        if(strstr($e, "Lost connection"))

          die('host'.$e);

        else

          die('auth'.$e);

      }

      $q = mysql_query('USE '.$dbname, $conn);

      if(!$q)

      {

        $e = mysql_error();

        if(strstr($e, 'Unknown database'))

        {

          die('name'.$e);

        }

        else

        {

          die('perm'.$e);

        }

      }

    }

    $v = mysql_get_server_info();

    if(version_compare($v, '4.1.17', '<')) die('vers'.$v);

    mysql_close($conn);

    die('good');

    break;

  case 'pophelp':

    $topic = ( isset($_GET['topic']) ) ? $_GET['topic'] : 'invalid';

    switch($topic)

    {

      case 'admin_embed_php':

        $title = 'Allow administrators to embed PHP';

        $content = '<p>This option allows you to control whether anything between the standard &lt;?php and ?&gt; tags will be treated as

                        PHP code by Enano. If this option is enabled, and members of the Administrators group use these tags, Enano will

                        execute that code when the page is loaded. There are obvious potential security implications here, which should

                        be carefully considered before enabling this option.</p>

                    <p>If you are the only administrator of this site, or if you have a high level of trust for those will be administering

                       the site with you, you should enable this to allow extreme customization of pages.</p>

                    <p>Leave this option off if you are at all concerned about security – if your account is compromised and PHP embedding

                       is enabled, an attacker can run arbitrary code on your server! Enabling this will also allow administrators to

                       embed Javascript and arbitrary HTML and CSS.</p>

                    <p>If you don\'t have experience coding in PHP, you can safely disable this option. You may change this at any time

                       using the ACL editor by selecting the Administrators group and This Entire Website under the scope selection. <!-- , or by

                       using the "embedded PHP kill switch" in the administration panel. --></p>';

        break;

      default:

        $title = 'Invalid topic';

        $content = 'Invalid help topic.';

        break;

    }

    echo <<<EOF

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<html>

  <head>

    <title>Enano installation quick help &bull; {$title}</title>

    <meta http-equiv="Content-type" content="text/html; charset=utf-8" />

    <style type="text/css">

      body {

        font-family: trebuchet ms, verdana, arial, helvetica, sans-serif;

        font-size: 9pt;

      }

      h2          { border-bottom: 1px solid #90B0D0; margin-bottom: 0; }

      h3          { font-size: 11pt; font-weight: bold; }

      li          { list-style: url(../images/bullet.gif); }

      p           { margin: 1.0em; }

      blockquote  { background-color: #F4F4F4; border: 1px dotted #406080; margin: 1em; padding: 10px; max-height: 250px; overflow: auto; }

      a           { color: #7090B0; }

      a:hover     { color: #90B0D0; }

    </style>

  </head>

  <body>

    <h2>{$title}</h2>

    {$content}

    <p style="text-align: right;">

      <a href="#" onclick="window.close(); return false;">Close window</a>

    </p>

  </body>

</html>

EOF;

    exit;

    break;

  default:

    break;

}

$template = new template_nodb();

$template->load_theme('oxygen', 'bleu', false);

$modestrings = Array(

              'welcome' => 'Welcome',

              'license' => 'License Agreement',

              'sysreqs' => 'Server requirements',

              'database'=> 'Database information',

              'website' => 'Website configuration',

              'login'   => 'Administration login',

              'confirm' => 'Confirm installation',

              'install' => 'Database installation',

              'finish'  => 'Installation complete'

            );

$sideinfo = '';

$vars = $template->extract_vars('elements.tpl');

$p = $template->makeParserText($vars['sidebar_button']);

foreach ( $modestrings as $id => $str )

{

  if ( $_GET['mode'] == $id )

  {

    $flags = 'style="font-weight: bold; text-decoration: underline;"';

    $this_page = $str;

  }

  else

  {

    $flags = '';

  }

  $p->assign_vars(Array(

      'HREF' => '#',

      'FLAGS' => $flags . ' onclick="return false;"',

      'TEXT' => $str

    ));

  $sideinfo .= $p->run();

}

$template->init_vars();

if(isset($_GET['mode']) && $_GET['mode'] == 'css')

{

  header('Content-type: text/css');

  echo $template->get_css();

  exit;

}

$template->header();

if(!isset($_GET['mode'])) $_GET['mode'] = 'license';

switch($_GET['mode'])

{ 

  default:

  case 'welcome':

    ?>

    <div style="text-align: center; margin-top: 10px;">

      <img alt="[ Enano CMS Project logo ]" src="images/enano-artwork/installer-greeting-blue.png" style="display: block; margin: 0 auto; padding-left: 100px;" />

      <h2>Welcome to Enano</h2>

      <h3>version 1.0.2 &ndash; stable<br />

      <span style="font-weight: normal;">also affectionately known as "coblynau" <tt>:)</tt></span></h3>

      <?php

      if ( file_exists('./_nightly.php') )

      {

        echo '<div class="warning-box" style="text-align: left; margin: 10px 0;"><b>You are about to install a NIGHTLY BUILD of Enano.</b><br />Nightly builds are NOT upgradeable and may contain serious flaws, security problems, or extraneous debugging information. Installing this version of Enano on a production site is NOT recommended.</div>';

      }

      ?>

      <form action="install.php?mode=license" method="post">

        <input type="submit" value="Start installation" />

      </form>

    </div>

    <?php

    break;

  case "license":

    ?>

    <h3>Welcome to the Enano installer.</h3>

     <p>Thank you for choosing Enano as your CMS. You've selected the finest in design, the strongest in security, and the latest in Web 2.0 toys. Trust us, you'll like it.</p>

     <p>To get started, please read and accept the following license agreement. You've probably seen it before.</p>

     <div style="height: 500px; clip: rect(0px,auto,500px,auto); overflow: auto; padding: 10px; border: 1px dashed #456798; margin: 1em;">

       <h2>GNU General Public License</h2>

       <h3>Declaration of license usage</h3>

       <p>Enano is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.</p>

       <p>This program is distributed in the hope that it will be useful, but <u>without any warranty</u>; without even the implied warranty of <u>merchantability</u> or <u>fitness for a particular purpose</u>. See the GNU General Public License (below) for more details.</p>

       <p><b>By clicking the button below or otherwise continuing the installation, you indicate your acceptance of this license agreement.</b></p>

       <h3>Human-readable version</h3>

       <p>Enano is distributed under certain licensing terms that we believe make it of the greatest possible use to the public. The license we distribute it under, the GNU General Public License, provides certain terms and conditions that, rather than limit your use of Enano, allow you to get the most out of it. If you would like to read the full text, it can be found below. Here is a human-readable version that we think is a little easier to understand.</p>

       <ul>

       <li>You may to run Enano for any purpose.</li>

       <li>You may study how Enano works and adapt it to your needs.</li>

       <li>You may redistribute copies so you can help your neighbor.</li>

       <li>You may improve Enano and release your improvements to the public, so that the whole community benefits.</li>

       </ul>

       <p>You may exercise the freedoms specified here provided that you comply with the express conditions of this license. The principal conditions are:</p>

       <ul>

       <li>You must conspicuously and appropriately publish on each copy distributed an appropriate copyright notice and disclaimer of warranty and keep intact all the notices that refer to this License and to the absence of any warranty; and give any other recipients of Enano a copy of the GNU General Public License along with Enano. Any translation of the GNU General Public License must be accompanied by the GNU General Public License.</li>

       <li>If you modify your copy or copies of Enano or any portion of it, or develop a program based upon it, you may distribute the resulting work provided you do so under the GNU General Public License. Any translation of the GNU General Public License must be accompanied by the GNU General Public License.</li>

       <li>If you copy or distribute Enano, you must accompany it with the complete corresponding machine-readable source code or with a written offer, valid for at least three years, to furnish the complete corresponding machine-readable source code.</li>

       </ul>

       <p><b>Disclaimer</b>: The above text is not a license. It is simply a handy reference for understanding the Legal Code (the full license) &ndash; it is a human-readable expression of some of its key terms. Think of it as the user-friendly interface to the Legal Code beneath. The above text itself has no legal value, and its contents do not appear in the actual license.<br /><span style="color: #CCC">Text copied from the <a href="http://creativecommons.org/licenses/GPL/2.0/">Creative Commons GPL Deed page</a></span></p>

       <?php

       if ( defined('ENANO_BETA_VERSION') )

       {

         ?>

         <h3>Notice for prerelease versions</h3>

         <p>This version of Enano is designed only for testing and evaluation purposes. <b>It is not yet completely stable, and should not be used on production websites.</b> As with any Enano version, Dan Fuhry and the Enano team cannot be responsible for any damage, physical or otherwise, to any property as a result of the use of Enano. While security is a number one priority, sometimes things slip through.</p>

         <?php

       }

       ?>

       <h3>Lawyer-readable version</h3>

       <?php echo wikiFormat(file_get_contents(ENANO_ROOT . '/GPL')); ?>

     </div>

     <div class="pagenav">

       <form action="install.php?mode=sysreqs" method="post">

         <table border="0">

         <tr>

         <td><input type="submit" value="I agree to the license terms" /></td><td><p><span style="font-weight: bold;">Before clicking continue:</span><br />&bull; Ensure that you agree with the terms of the license<br />&bull; Have your database host, name, username, and password available</p></td>

         </tr>

         </table>

       </form>

     </div>

    <?php

    break;

  case "sysreqs":

    error_reporting(E_ALL);

    ?>

    <h3>Checking your server</h3>

     <p>Enano has several requirements that must be met before it can be installed. If all is good then note any warnings and click Continue below.</p>

    <table border="0" cellspacing="0" cellpadding="0">

    <?php

    run_test('return version_compare(\'4.3.0\', PHP_VERSION, \'<\');', 'PHP Version >=4.3.0', 'It seems that the version of PHP that your server is running is too old to support Enano properly. If this is your server, please upgrade to the most recent version of PHP, remembering to use the --with-mysql configure option if you compile it yourself. If this is not your server, please contact your webhost and ask them if it would be possible to upgrade PHP. If this is not possible, you will need to switch to a different webhost in order to use Enano.');

    run_test('return function_exists(\'mysql_connect\');', 'MySQL extension for PHP', 'It seems that your PHP installation does not have the MySQL extension enabled. If this is your own server, you may need to just enable the "libmysql.so" extension in php.ini. If you do not have the MySQL extension installed, you will need to either use your distribution\'s package manager to install it, or you will have to compile PHP from source. If you compile PHP from source, please remember to use the "--with-mysql" configure option, and you will have to have the MySQL development files installed (they usually are). If this is not your server, please contact your hosting company and ask them to install the PHP MySQL extension.');

    run_test('return @ini_get(\'file_uploads\');', 'File upload support', 'It seems that your server does not support uploading files. Enano *requires* this functionality in order to work properly. Please ask your server administrator to set the "file_uploads" option in php.ini to "On".');

    run_test('return is_apache();', 'Apache HTTP Server', 'Apparently your server is running a web server other than Apache. Enano will work nontheless, but there are some known bugs with non-Apache servers, and the "fancy" URLs will not work properly. The "Standard URLs" option will be set on the website configuration page, only change it if you are absolutely certain that your server is running Apache.', true);

    //run_test('return function_exists(\'finfo_file\');', 'Fileinfo PECL extension', 'The MIME magic PHP extension is used to determine the type of a file by looking for a certain "magic" string of characters inside it. This functionality is used by Enano to more effectively prevent malicious file uploads. The MIME magic option will be disabled by default.', true);

    run_test('return is_writable(ENANO_ROOT.\'/config.php\');', 'Configuration file writable', 'It looks like the configuration file, config.php, is not writable. Enano needs to be able to write to this file in order to install.<br /><br /><b>If you are installing Enano on a SourceForge web site:</b><br />SourceForge mounts the web partitions read-only now, so you will need to use the project shell service to symlink config.php to a file in the /tmp/persistent directory.');

    run_test('return file_exists(\'/usr/bin/convert\');', 'ImageMagick support', 'Enano uses ImageMagick to scale images into thumbnails. Because ImageMagick was not found on your server, Enano will use the width= and height= attributes on the &lt;img&gt; tag to scale images. This can cause somewhat of a performance increase, but bandwidth usage will be higher, especially if you use high-resolution images on your site.<br /><br />If you are sure that you have ImageMagick, you can set the location of the "convert" program using the administration panel after installation is complete.', true);

    run_test('return is_writable(ENANO_ROOT.\'/cache/\');', 'Cache directory writable', 'Apparently the cache/ directory is not writable. Enano will still work, but you will not be able to cache thumbnails, meaning the server will need to re-render them each time they are requested. In some cases, this can cause a significant slowdown.', true);

    run_test('return is_writable(ENANO_ROOT.\'/files/\');', 'File uploads directory writable', 'It seems that the directory where uploaded files are stored (' . ENANO_ROOT . '/files) cannot be written by the server. Enano will still function, but file uploads will not function, and will be disabled by default.', true);

    echo '</table>';

    if(!$failed)

    {

      ?>

      <div class="pagenav">

      <?php

      if($warned) {

        echo '<table border="0" cellspacing="0" cellpadding="0">';

        run_test('return false;', 'Some scalebacks were made due to your server configuration.', 'Enano has detected that some of the features or configuration settings on your server are not optimal for the best behavior and/or performance for Enano. As a result, certain features or enhancements that are part of Enano have been disabled to prevent further errors. You have seen those "fatal error" notices that spew from PHP, haven\'t you?<br /><br />Fatal error:</b> call to undefined function wannahokaloogie() in file <b>'.__FILE__.'</b> on line <b>'.__LINE__.'', true);

        echo '</table>';

      } else {

        echo '<table border="0" cellspacing="0" cellpadding="0">';

        run_test('return true;', '<b>Your server meets all the requirements for running Enano.</b><br />Click the button below to continue the installation.', 'You should never see this text. Congratulations for being an Enano hacker!');

        echo '</table>';

      }

      ?>

       <form action="install.php?mode=database" method="post">

         <table border="0">

         <tr>

         <td><input type="submit" value="Continue" /></td><td><p><span style="font-weight: bold;">Before clicking continue:</span><br />&bull; Ensure that you are satisfied with any scalebacks that may have been made to accomodate your server configuration<br />&bull; Have your database host, name, username, and password available</p></td>

         </tr>

         </table>

       </form>

     </div>

     <?php

    } else {

      if($failed) {

        echo '<div class="pagenav"><table border="0" cellspacing="0" cellpadding="0">';

        run_test('return false;', 'Your server does not meet the requirements for Enano to run.', 'As a precaution, Enano will not install until the above requirements have been met. Contact your server administrator or hosting company and convince them to upgrade. Good luck.');

        echo '</table></div>';

      }

    }

    ?>

    <?php

    break;

  case "database":

    ?>

    <script type="text/javascript">

      function ajaxGet(uri, f) {

        if (window.XMLHttpRequest) {

          ajax = new XMLHttpRequest();

        } else {

          if (window.ActiveXObject) {           

            ajax = new ActiveXObject("Microsoft.XMLHTTP");

          } else {

            alert('Enano client-side runtime error: No AJAX support, unable to continue');

            return;

          }

        }

        ajax.onreadystatechange = f;

        ajax.open('GET', uri, true);

        ajax.send(null);

      }

      function ajaxPost(uri, parms, f) {

        if (window.XMLHttpRequest) {

          ajax = new XMLHttpRequest();

        } else {

          if (window.ActiveXObject) {           

            ajax = new ActiveXObject("Microsoft.XMLHTTP");

          } else {

            alert('Enano client-side runtime error: No AJAX support, unable to continue');

            return;

          }

        }

        ajax.onreadystatechange = f;

        ajax.open('POST', uri, true);

        ajax.setRequestHeader("Content-type", "application/x-www-form-urlencoded");

        ajax.setRequestHeader("Content-length", parms.length);

        ajax.setRequestHeader("Connection", "close");

        ajax.send(parms);

      }

      function ajaxTestConnection()

      {

        v = verify();

        if(!v)

        {

          alert('One or more of the form fields is incorrect. Please correct any information in the form that has an "X" next to it.');

          return false;

        }

        var frm = document.forms.dbinfo;

        db_host      = escape(frm.db_host.value.replace('+', '%2B'));

        db_name      = escape(frm.db_name.value.replace('+', '%2B'));

        db_user      = escape(frm.db_user.value.replace('+', '%2B'));

        db_pass      = escape(frm.db_pass.value.replace('+', '%2B'));

        db_root_user = escape(frm.db_root_user.value.replace('+', '%2B'));

        db_root_pass = escape(frm.db_root_pass.value.replace('+', '%2B'));

        parms = 'host='+db_host+'&name='+db_name+'&user='+db_user+'&pass='+db_pass+'&root_user='+db_root_user+'&root_pass='+db_root_pass;

        ajaxPost('<?php echo scriptPath; ?>/install.php?mode=mysql_test', parms, function() {

            if(ajax.readyState==4)

            {

              s = ajax.responseText.substr(0, 4);

              t = ajax.responseText.substr(4, ajax.responseText.length);

              if(s.substr(0, 4)=='good')

              {

                document.getElementById('s_db_host').src='images/good.gif';

                document.getElementById('s_db_name').src='images/good.gif';

                document.getElementById('s_db_auth').src='images/good.gif';

                document.getElementById('s_db_root').src='images/good.gif';

                if(t.match(/_creating_db/)) document.getElementById('e_db_name').innerHTML = '<b>Warning:<\/b> The database you specified does not exist. It will be created during installation.';

                if(t.match(/_creating_user/)) document.getElementById('e_db_auth').innerHTML = '<b>Warning:<\/b> The specified regular user does not exist or the password is incorrect. The user will be created during installation. If the user already exists, the password will be reset.';

                document.getElementById('s_mysql_version').src='images/good.gif';

                document.getElementById('e_mysql_version').innerHTML = 'Your version of MySQL meets Enano requirements.';

              }

              else

              {

                switch(s)

                {

                case 'host':

                  document.getElementById('s_db_host').src='images/bad.gif';

                  document.getElementById('s_db_name').src='images/unknown.gif';

                  document.getElementById('s_db_auth').src='images/unknown.gif';

                  document.getElementById('s_db_root').src='images/unknown.gif';

                  document.getElementById('e_db_host').innerHTML = '<b>Error:<\/b> The database server "'+document.forms.dbinfo.db_host.value+'" couldn\'t be contacted.<br \/>'+t;

                  document.getElementById('e_mysql_version').innerHTML = 'The MySQL version that your server is running could not be determined.';

                  break;

                case 'auth':

                  document.getElementById('s_db_host').src='images/good.gif';

                  document.getElementById('s_db_name').src='images/unknown.gif';

                  document.getElementById('s_db_auth').src='images/bad.gif';