PMango Installer

Execute("DROP DATABASE IF EXISTS ".$dbname); 
	 $existing_db = false;
  }

  if (! $existing_db) {
		dPmsg("Creating new Database");
		$db->Execute("CREATE DATABASE ".$dbname); 
         $dbError = $db->ErrorNo();
         if ($dbError <> 0 && $dbError <> 1007) {
                 $dbErr = true;
                $dbMsg .= "A Database Error occurred. Database has not been created! The provided database details are probably not correct.
".$db->ErrorMsg()."
";

         }
   }
 }

 // For some reason a db->SelectDB call here doesn't work.
 $db->Execute('USE ' . $dbname);
 $db_version = InstallGetVersion($mode, $db);

 if ($mode == 'upgrade') {
  dPmsg("Applying database updates");
  $last_version = $db_version['code_version'];
  // Convert the code version to a version string.
  if ($last_version != $current_version) {
    // Check for from and to versions
    $from_key = array_search($last_version, $versionPath);
    $to_key = array_search($current_version, $versionPath);
    for ($i = $from_key; $i < $to_key; $i++) {
      $from_version = str_replace(array('.','-'), '', $versionPath[$i]);
      $to_version = str_replace(array('.','-'), '', $versionPath[$i+1]);
      InstallLoadSql("$baseDir/db/upgrade_{$from_version}_to_{$to_version}.sql");
    }
  } else if (file_exists("$baseDir/db/upgrade_latest.sql")) {
    // Need to get the installed version again, as it should have been
    // updated by the from/to stuff.
    InstallLoadSql("$baseDir/db/upgrade_latest.sql", $db_version['last_db_update']);
  }
 } else {
  dPmsg("Installing database");
  InstallLoadSql("$baseDir/db/mango.sql");// CREAZIONE DEL DB
  
  if ($_POST['sql_file'] != '' & !$dbErr) {
		dPmsg("Import data from file");
	  	InstallLoadSql($_POST['sql']);
	  	$dbError = $db->ErrorNo();
		// Si devono inserire gli utenti ma si fa in upgrade_permissions
			
		if ($dbError <> 0 && $dbError <> 1007) {
		     $dbErr = true; echo "\nDB ERROR\n";
		     $dbMsg .= "A Database Error occurred. Database has probably not been populated completely!
".$db->ErrorMsg()."
";
		}
		else 
		     $dbErr = false;
		if ($dbErr) {
			 $dbMsg ="Import data incomplete - the following errors occured:
".$dbMsg;
	 	} else {
	  		 $dbMsg ="Database successfully setup and populated
";
	 	}
  }
  // After all the updates, find the new version information.
  $new_version = InstallGetVersion($mode, $db);
  $lastDBUpdate = $new_version['last_db_update'];
 }

 $dbError = $db->ErrorNo();

 if ($dbError <> 0 && $dbError <> 1007) {
      $dbErr = true; echo "\nDB ERROR\n";
      $dbMsg .= "A Database Error occurred. Database has probably not been populated completely!
".$db->ErrorMsg()."
";
 }
 else 
 	  $dbErr = false;

 if ($dbErr) {
  $dbMsg ="DB setup incomplete - the following errors occured:
".$dbMsg;
 } else {
  $dbMsg ="Database successfully setup
";
 }

 $code_updated = '';
 if ($mode == 'upgrade') {
  dPmsg("Applying data modifications");
  // Check for an upgrade script and run it if necessary.
  $to_version = str_replace(array('-', '.'), '', $current_version);
  if ($last_version != $current_version) {
	  if (file_exists("$baseDir/db/upgrade_to_{$to_version}.php")) {
		 include_once "$baseDir/db/upgrade_to_{$to_version}.php";
		 
		 $code_updated = dPupgrade($db_version['code_version'], $current_version, $db_version['last_code_update']);
		}
  } else if (file_exists("$baseDir/db/upgrade_latest.php")) {
   include_once "$baseDir/db/upgrade_latest.php";
   $code_updated = dPupgrade($db_version['code_version'], $current_version, $db_version['last_code_update']);
  } else {
		dPmsg("No data updates required");
	}
 } else {
  include_once "$baseDir/db/upgrade_permissions.php"; // Always required on install.
 }

 dPmsg("Updating version information");
 // No matter what occurs we should update the database version in the dpversion table.
 $sql = "UPDATE dpversion
 SET db_version = '$dp_version_major',
 last_db_update = '$lastDBUpdate',
 code_version = '$current_version',
 last_code_update = '$code_updated'
 WHERE 1";
 $db->Execute($sql);
} else {
	 $dbMsg = "Not Created";
	 if (! $dbc) {
		$dbErr=1;
		$dbMsg .= "
No Database Connection available! "  . ($db ? $db->ErrorMsg() : '');
	 }
}

// always create the config file content

 dPmsg("Creating config");
 $config = "";
 $config = trim($config);

if ($do_cfg || $do_db_cfg){
 if ( (is_writable("../includes/config.php")  || ! is_file("../includes/config.php") ) && ($fp = fopen("../includes/config.php", "w"))) {
  fputs( $fp, $config, strlen( $config ) );
  fclose( $fp );
  $cFileMsg = "Config file written successfully\n";
 } else {
  $cFileErr = true;
  $cFileMsg = "Config file could not be written\n";
 }
}
 

?>




        

            
Database Installation Feedback:
     		

     			 

		   Please note that errors relating to dropping indexes during upgrades are NORMAL and do not indicate a problem.
			 
			 
         
  

            
Config File Creation Feedback:
     

  

 

     
The following Content should go to ./includes/config.php. Create that text file manually and copy the following lines in by hand. Delete all empty lines and empty spaces after '?>' and save. This file should be readable by the webserver.
  
         

            
<?php echo $msg.$config; ?>
         

 

     

Login and Configure the PMango System Environment
  

	

		
The Administrator login has been set to admin with a password of passwd. It is a good idea to change this password when you first log in