modules/UpgradeWizard/commit.php

   1 <?php
   2 if(!defined('sugarEntry') || !sugarEntry)
   3         die('Not A Valid Entry Point');
   4 /*********************************************************************************
   5  * SugarCRM Community Edition is a customer relationship management program developed by
   6  * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
   7  *
   8  * This program is free software; you can redistribute it and/or modify it under
   9  * the terms of the GNU Affero General Public License version 3 as published by the
  10  * Free Software Foundation with the addition of the following permission added
  11  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
  12  * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
  13  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
  14  *
  15  * This program is distributed in the hope that it will be useful, but WITHOUT
  16  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  17  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
  18  * details.
  19  *
  20  * You should have received a copy of the GNU Affero General Public License along with
  21  * this program; if not, see http://www.gnu.org/licenses or write to the Free
  22  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
  23  * 02110-1301 USA.
  24  *
  25  * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
  26  * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
  27  *
  28  * The interactive user interfaces in modified source and object code versions
  29  * of this program must display Appropriate Legal Notices, as required under
  30  * Section 5 of the GNU Affero General Public License version 3.
  31  *
  32  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
  33  * these Appropriate Legal Notices must retain the display of the "Powered by
  34  * SugarCRM" logo. If the display of the logo is not reasonably feasible for
  35  * technical reasons, the Appropriate Legal Notices must display the words
  36  * "Powered by SugarCRM".
  37  ********************************************************************************/
  38
  39 /*********************************************************************************
  40
  41  * Description:
  42  * Portions created by SugarCRM are Copyright(C) SugarCRM, Inc. All Rights
  43  * Reserved. Contributor(s): ______________________________________..
  44  * *******************************************************************************/
  45 require_once('include/SugarLogger/SugarLogger.php');
  46
  47 $trackerManager = TrackerManager::getInstance();
  48 $trackerManager->pause();
  49 $trackerManager->unsetMonitors();
  50
  51 $_SESSION['upgrade_complete'] = '';
  52 $_REQUEST['upgradeWizard'] = true;
  53
  54
  55 logThis('[At commit.php]');
  56 $stop = true; // flag to show "next"
  57
  58 //refreshing mod_strings
  59
  60 global $mod_strings;
  61 $curr_lang = 'en_us';
  62 if(isset($GLOBALS['current_language']) && ($GLOBALS['current_language'] != null)){
  63         $curr_lang = $GLOBALS['current_language'];
  64 }
  65 return_module_language($curr_lang, 'UpgradeWizard', true);
  66
  67
  68 $standardErrorLevel = error_reporting();
  69 logThis("Setting error_reporting() to E_ERROR while running upgrade");
  70 error_reporting(E_ERROR);
  71
  72 set_time_limit(0);
  73 /*
  74  * [unzip_dir] => /Users/curisu/www/head/cache/upload//upgrades/temp/QSugp3
  75  * [zip_from_dir]  => SugarEnt-Upgrade-4.0.1-to-4.2.1
  76  * rest_dir: /Users/curisu/www/head/cache/upload/SugarEnt-Upgrade-4.0.1-to-4.2.1-restore
  77  */
  78
  79 // flag upgradeSql script run method
  80 $_SESSION['schema_change'] = $_REQUEST['schema_change'];
  81 if(didThisStepRunBefore('commit')){
  82         $_SESSION['committed'] = true;
  83 }
  84 else{
  85         set_upgrade_progress('commit','in_progress','commit','in_progress');
  86 }
  87 //Initialize session errors array
  88 if(!isset($_SESSION['sqlSkippedQueries']) && !is_array($_SESSION['sqlSkippedQueries'])){
  89         $_SESSION['sqlSkippedQueries'] = array();
  90 }
  91 // prevent "REFRESH" double commits
  92 if(!isset($_SESSION['committed'])) {
  93         //$_SESSION['committed'] = true; // flag to prevent refresh double-commit
  94         //set the flag at the end though
  95         unset($_SESSION['rebuild_relationships']);
  96         unset($_SESSION['rebuild_extensions']);
  97     //put checks for follwing files
  98
  99         if(!isset($_SESSION['unzip_dir']) || empty($_SESSION['unzip_dir'])) {
 100                 logThis('unzipping files in upgrade archive...');
 101                 $errors                                 = array();
 102                 list($base_upgrade_dir, $base_tmp_upgrade_dir) = getUWDirs();
 103                 $unzip_dir = '';
 104                 //also come up with mechanism to read from upgrade-progress file
 105                 if(!isset($_SESSION['install_file']) || empty($_SESSION['install_file']) || !is_file($_SESSION['install_file'])) {
 106                         if (file_exists(clean_path($base_tmp_upgrade_dir)) && $handle = opendir(clean_path($base_tmp_upgrade_dir))) {
 107                                 while (false !== ($file = readdir($handle))) {
 108                                 if($file !="." && $file !="..") {
 109                                          //echo $base_tmp_upgrade_dir."/".$file.'</br>';
 110                                          if(is_file($base_tmp_upgrade_dir."/".$file."/manifest.php")){
 111                                                 require_once($base_tmp_upgrade_dir."/".$file."/manifest.php");
 112                                                 $package_name= $manifest['copy_files']['from_dir'];
 113                                                 //echo file_exists($base_tmp_upgrade_dir."/".$file."/".$package_name).'</br>';
 114                                                 if(file_exists($base_tmp_upgrade_dir."/".$file."/".$package_name) && file_exists($base_tmp_upgrade_dir."/".$file."/scripts") && file_exists($base_tmp_upgrade_dir."/".$file."/manifest.php")){
 115                                                         //echo 'Yeah this the directory '. $base_tmp_upgrade_dir."/".$file;
 116                                                         $unzip_dir = $base_tmp_upgrade_dir."/".$file;
 117                                                         if(file_exists("$base_upgrade_dir/patch/".$package_name.'.zip')){
 118                                                                 $_SESSION['install_file'] = $package_name.'.zip';
 119                                                                 break;
 120                                                         }
 121                                                 }
 122                                           }
 123                                 }
 124                         }
 125                         }
 126                 }
 127         if(!isset($_SESSION['install_file']) || empty($_SESSION['install_file'])){
 128                 unlinkUWTempFiles();
 129                 resetUwSession();
 130                 echo 'Upload File not found so redirecting to Upgrade Start ';
 131                 $redirect_new_wizard = $sugar_config['site_url' ].'/index.php?module=UpgradeWizard&action=index';
 132                 echo '<form name="redirect" action="' .$redirect_new_wizard. '"  method="POST">';
 133             $upgrade_directories_not_found =<<<eoq
 134         <table cellpadding="3" cellspacing="0" border="0">
 135                 <tr>
 136                         <th colspan="2" align="left">
 137                                 <span class='error'><b>'Upload file missing or has been deleted. Refresh the page to go back to UpgradeWizard start'</b></span>
 138                         </th>
 139                 </tr>
 140         </table>
 141 eoq;
 142             $uwMain = $upgrade_directories_not_found;
 143                         return '';
 144         }
 145                 $install_file                   = "$base_upgrade_dir/patch/".basename(urldecode( $_SESSION['install_file'] ));
 146                 $show_files                             = true;
 147                 if(empty($unzip_dir)){
 148                         $unzip_dir                              = mk_temp_dir( $base_tmp_upgrade_dir );
 149                 }
 150                 $zip_from_dir                   = ".";
 151                 $zip_to_dir                             = ".";
 152                 $zip_force_copy                 = array();
 153
 154                 if(!$unzip_dir){
 155                         logThis('Could not create a temporary directory using mk_temp_dir( $base_tmp_upgrade_dir )');
 156                         die($mod_strings['ERR_UW_NO_CREATE_TMP_DIR']);
 157                 }
 158
 159                 //double check whether unzipped .
 160                 if(file_exists($unzip_dir ."/scripts") && file_exists($unzip_dir."/manifest.php")){
 161                 //already unzipped
 162                 }
 163                 else{
 164                         unzip( $install_file, $unzip_dir );
 165                 }
 166
 167                 // assumption -- already validated manifest.php at time of upload
 168                 require_once( "$unzip_dir/manifest.php" );
 169
 170                 if( isset( $manifest['copy_files']['from_dir'] ) && $manifest['copy_files']['from_dir'] != "" ){
 171                     $zip_from_dir   = $manifest['copy_files']['from_dir'];
 172                 }
 173                 if( isset( $manifest['copy_files']['to_dir'] ) && $manifest['copy_files']['to_dir'] != "" ){
 174                     $zip_to_dir     = $manifest['copy_files']['to_dir'];
 175                 }
 176                 if( isset( $manifest['copy_files']['force_copy'] ) && $manifest['copy_files']['force_copy'] != "" ){
 177                     $zip_force_copy     = $manifest['copy_files']['force_copy'];
 178                 }
 179                 if( isset( $manifest['version'] ) ){
 180                     $version    = $manifest['version'];
 181                 }
 182                 if( !is_writable( "config.php" ) ){
 183                         return $mod_strings['ERR_UW_CONFIG'];
 184                 }
 185
 186                 $_SESSION['unzip_dir'] = clean_path($unzip_dir);
 187                 $_SESSION['zip_from_dir'] = clean_path($zip_from_dir);
 188                 logThis('unzip done.');
 189         } else {
 190                 $unzip_dir = $_SESSION['unzip_dir'];
 191                 $zip_from_dir = $_SESSION['zip_from_dir'];
 192         }
 193
 194     //check if $_SESSION['unzip_dir'] and $_SESSION['zip_from_dir'] exist
 195         if(!isset($_SESSION['unzip_dir']) || !file_exists($_SESSION['unzip_dir'])
 196                 || !isset($_SESSION['install_file']) || empty($_SESSION['install_file']) || !file_exists($_SESSION['install_file'])){
 197                     //redirect to start
 198             unlinkUWTempFiles();
 199                 resetUwSession();
 200                 echo 'Upload File not found so redirecting to Upgrade Start ';
 201                 $redirect_new_wizard = $sugar_config['site_url' ].'/index.php?module=UpgradeWizard&action=index';
 202                 echo '<form name="redirect" action="' .$redirect_new_wizard. '"  method="POST">';
 203         $upgrade_directories_not_found =<<<eoq
 204         <table cellpadding="3" cellspacing="0" border="0">
 205                 <tr>
 206                         <th colspan="2" align="left">
 207                                 <span class='error'><b>'Upload file missing or has been deleted. Refresh the page to go back to UpgradeWizard start'</b></span>
 208                         </th>
 209                 </tr>
 210         </table>
 211 eoq;
 212         $uwMain = $upgrade_directories_not_found;
 213                 return '';
 214         }
 215         $install_file           = "$base_upgrade_dir/patch/".basename(urldecode( $_SESSION['install_file'] ));
 216         $file_action            = "";
 217         $uh_status                      = "";
 218         $errors                         = array();
 219         $out                            = '';
 220         $backupFilesExist       = false;
 221         $rest_dir                       = remove_file_extension($install_file) . "-restore";
 222
 223         ///////////////////////////////////////////////////////////////////////////////
 224         ////    MAKE BACKUPS OF TARGET FILES
 225         if(!didThisStepRunBefore('commit','commitMakeBackupFiles')){
 226                 set_upgrade_progress('commit','in_progress','commitMakeBackupFiles','in_progress');
 227                 $errors = commitMakeBackupFiles($rest_dir, $install_file, $unzip_dir, $zip_from_dir, array());
 228                 set_upgrade_progress('commit','in_progress','commitMakeBackupFiles','done');
 229         }
 230         ////    END MAKE BACKUPS OF TARGET FILES
 231         ///////////////////////////////////////////////////////////////////////////////
 232
 233
 234         ///////////////////////////////////////////////////////////////////////////////
 235         ////    HANDLE PREINSTALL SCRIPTS
 236         if(empty($errors)) {
 237                 $file = "$unzip_dir/" . constant('SUGARCRM_PRE_INSTALL_FILE');
 238                 if(is_file($file)) {
 239                         $out .= "{$mod_strings['LBL_UW_INCLUDING']}: {$file} <br>\n";
 240                         include($file);
 241                         if(!didThisStepRunBefore('commit','pre_install')){
 242                                 logThis('Running pre_install()...');
 243                                 set_upgrade_progress('commit','in_progress','pre_install','in_progress');
 244                                 pre_install();
 245                                 set_upgrade_progress('commit','in_progress','pre_install','done');
 246                                 logThis('pre_install() done.');
 247                         }
 248                 }
 249         }
 250
 251         ////    HANDLE PREINSTALL SCRIPTS
 252         ///////////////////////////////////////////////////////////////////////////////
 253         //Clean smarty from cache
 254             $cachedir = sugar_cached('smarty');
 255             if(is_dir($cachedir)){
 256                 $allModFiles = array();
 257                 $allModFiles = findAllFiles($cachedir,$allModFiles);
 258            foreach($allModFiles as $file){
 259                         //$file_md5_ref = str_replace(clean_path(getcwd()),'',$file);
 260                         if(file_exists($file)){
 261                                         unlink($file);
 262                         }
 263            }
 264         }
 265
 266
 267                 //Also add the three-way merge here. The idea is after the 451 html files have
 268                 //been converted run the 3-way merge. If 500 then just run the 3-way merge
 269         $ce_to_pro_ent = isset($manifest['name']) && ($manifest['name'] == 'SugarCE to SugarPro' || $manifest['name'] == 'SugarCE to SugarEnt' || $manifest['name'] == 'SugarCE to SugarCorp' || $manifest['name'] == 'SugarCE to SugarUlt');
 270
 271                 if(file_exists('modules/UpgradeWizard/SugarMerge/SugarMerge.php')){
 272                     require_once('modules/UpgradeWizard/SugarMerge/SugarMerge.php');
 273                     if(isset($_SESSION['unzip_dir']) && isset($_SESSION['zip_from_dir']) && !isset($_SESSION['sugarMergeRunResults'])){
 274                         $merger = new SugarMerge($_SESSION['unzip_dir'].'/'.$_SESSION['zip_from_dir']);
 275                         //Perform the actual merge and store which modules were merged.  We will rolllback the files if the
 276                         //user determines that they did not want to upgade a particular module.
 277                         $_SESSION['sugarMergeRunResults'] = $merger->mergeAll(TRUE,TRUE,TRUE);
 278                         logThis('Commit step finished SugarMerge run with the following results:' . print_r($_SESSION['sugarMergeRunResults'], true));
 279                     }
 280                 }
 281
 282         //Bug #47110
 283         if(file_exists("include/Expressions/Actions/SetValueAction.php")){
 284             require_once("include/Expressions/Actions/SetValueAction.php");
 285         }
 286
 287          //COPY ALL FILES FROM UPLOADED UPGRADE PACKAGE
 288          if(!didThisStepRunBefore('commit','commitCopyNewFiles')){
 289                                 set_upgrade_progress('commit','in_progress','commitCopyNewFiles','in_progress');
 290                                 $split = commitCopyNewFiles($unzip_dir, $zip_from_dir);
 291                                 $copiedFiles = $split['copiedFiles'];
 292                                 $skippedFiles = $split['skippedFiles'];
 293                                 set_upgrade_progress('commit','in_progress','commitCopyNewFiles','done');
 294          }
 295                  //END COPY NEW FILES INTO TARGET INSTANCE
 296     ///////////////////////////////////////////////////////////////////////////////
 297         ////    HANDLE POSTINSTALL SCRIPTS
 298         logThis('Starting post_install()...');
 299     if (!function_exists("inDeveloperMode")) {
 300         //this function was introduced from tokyo in the file include/utils.php, so when upgrading from 5.1x and 5.2x we should declare the this function
 301         function inDeveloperMode()
 302         {
 303             return isset($GLOBALS['sugar_config']['developerMode']) && $GLOBALS['sugar_config']['developerMode'];
 304         }
 305     }
 306         if(empty($errors)) {
 307                 if(!didThisStepRunBefore('commit','post_install')){
 308                         $file = "$unzip_dir/" . constant('SUGARCRM_POST_INSTALL_FILE');
 309                         if(is_file($file)) {
 310                                 //set_upgrade_progress('commit','in_progress','post_install','in_progress');
 311                                 $progArray['post_install']='in_progress';
 312                                 post_install_progress($progArray,'set');
 313                                 include($file);
 314                                 post_install();
 315                                 //set process to done
 316                                 $progArray['post_install']='done';
 317                                 //set_upgrade_progress('commit','in_progress','post_install','done');
 318                                 post_install_progress($progArray,'set');
 319                         }
 320                 }
 321
 322            require("sugar_version.php");
 323
 324        if($_SESSION['current_db_version'] != $_SESSION['target_db_version']){
 325                         logThis('Performing UWrebuild()...');
 326                         UWrebuild();
 327                         logThis('UWrebuild() done.');
 328        }
 329
 330                 //set the logger before rebuilding config
 331                 if(!isset($sugar_config['logger'])){
 332                         $sugar_config['logger'] =array (
 333                                 'level'=>'fatal',
 334                             'file' =>
 335                               array (
 336                                       'ext' => '.log',
 337                                       'name' => 'sugarcrm',
 338                                       'dateFormat' => '%c',
 339                                       'maxSize' => '10MB',
 340                                       'maxLogs' => 10,
 341                                       'suffix' => '%m_%Y',
 342                                   ),
 343                         );
 344                 }
 345
 346         // Set the default max tabs to 7
 347         $sugar_config['default_max_tabs'] = '7';
 348
 349                 if(!rebuildConfigFile($sugar_config, $sugar_version)) {
 350                         logThis('*** ERROR: could not write config.php! - upgrade will fail!');
 351                         $errors[] = $mod_strings['ERR_UW_CONFIG_WRITE'];
 352                 }
 353         }
 354         logThis('post_install() done.');
 355         //// END POSTINSTALL SCRIPTS
 356         ///////////////////////////////////////////////////////////////////////////////
 357
 358 logThis('check if current_db_version in $_SESSION equals target_db_version in $_SESSION');
 359 if($_SESSION['current_db_version'] == $_SESSION['target_db_version']){
 360
 361         logThis('current_db_version in $_SESSION and target_db_version in $_SESSION are equal');
 362         $_SESSION['license_seats_needed'] = '';
 363         //Clean modules from cache
 364         $cachedir = sugar_cached("modules");
 365     if(is_dir($cachedir)){
 366                 logThis("clear $cachedir files");
 367         $allModFiles = array();
 368         $allModFiles = findAllFiles($cachedir,$allModFiles);
 369        foreach($allModFiles as $file){
 370                 //$file_md5_ref = str_replace(clean_path(getcwd()),'',$file);
 371                 if(file_exists($file))
 372                 {
 373                         logThis('unlink ' . $file);
 374                                 unlink($file);
 375                 }
 376        }
 377     }
 378     //Clean jsLanguage from cache
 379     $cachedir = sugar_cached("jsLanguage");
 380     if(is_dir($cachedir)){
 381                 logThis("clear $cachedir files");
 382         $allModFiles = array();
 383         $allModFiles = findAllFiles($cachedir,$allModFiles);
 384        foreach($allModFiles as $file){
 385                 //$file_md5_ref = str_replace(clean_path(getcwd()),'',$file);
 386                 if(file_exists($file))
 387                 {
 388                         logThis('unlink ' . $file);
 389                                 unlink($file);
 390                 }
 391        }
 392     }
 393
 394 }
 395 logThis('finished check to see if current_db_version in $_SESSION equals target_db_version in $_SESSION');
 396
 397 //Look for chance folder and delete it if found. Bug 23595
 398 if(function_exists('deleteChance'))
 399 {
 400         logThis('running deleteChance() function');
 401         @deleteChance();
 402 }
 403
 404 //also add the cache cleaning here.
 405 if(function_exists('deleteCache'))
 406 {
 407         logThis('running deleteCache() function');
 408         @deleteCache();
 409 }
 410
 411 //add tabs
 412 $from_dir = remove_file_extension($install_file) . "-restore";
 413 logThis('call addNewSystemTabsFromUpgrade(' . $from_dir . ')');
 414 addNewSystemTabsFromUpgrade($from_dir);
 415 logThis('finished addNewSystemTabsFromUpgrade');
 416
 417 //run fix on dropdown lists that may have been incorrectly named
 418 //fix_dropdown_list();
 419
 420         ///////////////////////////////////////////////////////////////////////////////
 421         ////    REGISTER UPGRADE
 422
 423         logThis('Registering upgrade with UpgradeHistory');
 424         if(!didThisStepRunBefore('commit','upgradeHistory')){
 425                 set_upgrade_progress('commit','in_progress','upgradeHistory','in_progress');
 426                 if(empty($errors)) {
 427                         $file_action = "copied";
 428                         // if error was encountered, script should have died before now
 429                         $new_upgrade = new UpgradeHistory();
 430                         $new_upgrade->filename = $install_file;
 431                         $new_upgrade->md5sum = md5_file($install_file);
 432                         $new_upgrade->type = 'patch';
 433                         $new_upgrade->version = $sugar_version;
 434                         $new_upgrade->status = "installed";
 435                         $new_upgrade->manifest =(!empty($_SESSION['install_manifest']) ? $_SESSION['install_manifest'] : '');
 436                         $new_upgrade->save();
 437                 }
 438                 set_upgrade_progress('commit','in_progress','upgradeHistory','done');
 439         }
 440         ////    REGISTER UPGRADE
 441         ///////////////////////////////////////////////////////////////////////////////
 442 }else{
 443     $backupFilesExist = false;
 444     $copiedFiles = array();
 445     $skippedFiles = array();
 446 }
 447
 448 // flag to prvent double-commits via refresh
 449 $_SESSION['committed'] = true;
 450
 451 ///////////////////////////////////////////////////////////////////////////////
 452 ////    FINISH AND OUTPUT
 453 if(empty($errors)) {
 454         $stop = false;
 455 }
 456
 457 $backupDesc = '';
 458 if($backupFilesExist) {
 459         $backupDesc .= "<b>{$mod_strings['LBL_UW_BACKUP_FILES_EXIST_TITLE']}</b><br />";
 460         $backupDesc .= $mod_strings['LBL_UW_BACKUP_FILES_EXIST'] . ': ' . $rest_dir;
 461 }
 462
 463 $customized_mods_Desc = '';
 464 $old_schema= '';
 465 $old_schema_opt = '';
 466 $skipped_queries = '';
 467 if($_SESSION['current_db_version'] != $_SESSION['target_db_version']){
 468     global $sugar_version;
 469     $origVersion = substr(preg_replace("/[^0-9]/", "", $_SESSION['current_db_version']),0,3);
 470         $destVersion = substr(preg_replace("/[^0-9]/", "", $_SESSION['target_db_version']),0,3);
 471
 472         //old schema to be dropped
 473         $old_schema_contents = '';
 474         if(file_exists($_SESSION['unzip_dir'].'/scripts/drop_'.$origVersion.'_schema_after_upgrade_'.$destVersion.'.php')){
 475                 require_once($_SESSION['unzip_dir'].'/scripts/drop_'.$origVersion.'_schema_after_upgrade_'.$destVersion.'.php');
 476                 ob_start();
 477                         $old_schema_contents=@drop_preUpgardeSchema(true);
 478                 ob_end_clean();
 479         }
 480         if($old_schema_contents != null && strlen($old_schema_contents) >0){
 481                 $old_schema  = "<p><a href='javascript:void(0); toggleNwFiles(\"old_schemashow\");'>{$mod_strings['LBL_UW_SHOW_OLD_SCHEMA_TO_DROP']}</a>";
 482                 $old_schema .= "<div id='old_schemashow' style='display:none;'>";
 483                 $old_schema .= "<textarea readonly cols='80' rows='10'>{$old_schema_contents}</textarea>";
 484                 $old_schema .= "</div></p>";
 485
 486                 $old_schema_opt="<b>{$mod_strings['LBL_UW_DROP_SCHEMA_METHOD']}</b>
 487                                                 <select name=\"schema_drop\" id=\"select_schema_drop\" onchange=\"checkSchemaDropStatus();\">
 488                                                         <option value=\"manual\">{$mod_strings['LBL_UW_DROP_SCHEMA_MANUAL']}</option>
 489                                                         <option value=\"sugar\">{$mod_strings['LBL_UW_DROP_SCHEMA_UPGRADE_WIZARD']}</option>
 490                                                 </select>
 491                                         ";
 492         }
 493
 494         //also add the cache cleaning here.
 495         if(function_exists('deleteCache')){
 496                 @deleteCache();
 497         }
 498 }
 499
 500 $copiedDesc = '';
 501 if(count($copiedFiles) > 0) {
 502         $copiedDesc .= "<b>{$mod_strings['LBL_UW_COPIED_FILES_TITLE']}</b><br />";
 503         $copiedDesc .= "<a href='javascript:void(0); toggleNwFiles(\"copiedFiles\");'>{$mod_strings['LBL_UW_SHOW']}</a>";
 504         $copiedDesc .= "<div id='copiedFiles' style='display:none;'>";
 505
 506         foreach($copiedFiles as $file) {
 507                 $copiedDesc .= $file . "<br />";
 508         }
 509         $copiedDesc .= "</div>";
 510 }
 511
 512 $skippedDesc = '';
 513 if(count($skippedFiles) > 0) {
 514         $skippedDesc .= "<b>{$mod_strings['LBL_UW_SKIPPED_FILES_TITLE']}</b><br />";
 515         $skippedDesc .= "<a href='javascript:void(0); toggleNwFiles(\"skippedFiles\");'>{$mod_strings['LBL_UW_SHOW']}</a>";
 516         $skippedDesc .= "<div id='skippedFiles' style='display:none;'>";
 517
 518         foreach($skippedFiles as $file) {
 519                 $skippedDesc .= $file . "<br />";
 520         }
 521         $skippedDesc .= "</div>";
 522 }
 523
 524 $rebuildResult = "<b>{$mod_strings['LBL_UW_REBUILD_TITLE']}</b><br />";
 525 $rebuildResult .= "<a href='javascript:void(0); toggleRebuild();'>{$mod_strings['LBL_UW_SHOW']}</a> <div id='rebuildResult'></div>";
 526
 527 $rebuildResult = '';
 528
 529 $skipped_queries_Desc='';
 530 if(isset($_SESSION['sqlSkippedQueries']) && $_SESSION['sqlSkippedQueries'] != null && is_array($_SESSION['sqlSkippedQueries']) && sizeof($_SESSION['sqlSkippedQueries'])>0){
 531         $skipped_queries_Desc .= "<b>{$mod_strings['LBL_UW_SKIPPED_QUERIES_ALREADY_EXIST']}</b><br />";
 532         $skipped_queries_Desc .= "<a href='javascript:void(0); toggleNwFiles(\"skippedQueries\");'>{$mod_strings['LBL_UW_SHOW']}</a>";
 533         $skipped_queries_Desc .= "<div id='skippedQueries' style='display:none;'>";
 534         if($_SESSION['sqlSkippedQueries'] != null){
 535              $skipped_queries_Desc .= $mod_strings['LBL_UW_SKIPPED_QUERIES_ALREADY_EXIST']. "<br />";
 536              foreach($_SESSION['sqlSkippedQueries'] as $skippedQ) {
 537                         $skipped_queries_Desc .= $skippedQ . "<br />";
 538                  }
 539         }
 540  }
 541 $delete_chance='';
 542 if(isset($_SESSION['chance']) && $_SESSION['chance'] != null){
 543         $delete_chance .= "<b>Remove the folder: {$_SESSION['chance']}</b><br />";
 544  }
 545 if(empty($mod_strings['LBL_UPGRADE_TAKES_TIME_HAVE_PATIENCE'])){
 546                 $mod_strings['LBL_UPGRADE_TAKES_TIME_HAVE_PATIENCE'] = 'Upgrade may take some time';
 547 }
 548
 549 ///////////////////////////////////////////////////////////////////////////////
 550 ////    HANDLE REMINDERS
 551 commitHandleReminders($skippedFiles);
 552 ////    HANDLE REMINDERS
 553 ///////////////////////////////////////////////////////////////////////////////
 554
 555
 556 logThis("Resetting error_reporting() to system level.");
 557 error_reporting($standardErrorLevel);
 558
 559 ///////////////////////////////////////////////////////////////////////////////
 560 ////    OUTPUT
 561 $uwMain =<<<eoq
 562 <script type="text/javascript" language="javascript">
 563         function toggleRebuild() {
 564                 var target = document.getElementById('rebuildResult');
 565
 566                 if(target.innerHTML == '') {
 567                         target.innerHTML = rebuildResult; // found in UWrebuild()
 568                 } else {
 569                         target.innerHTML = '';
 570                 }
 571         }
 572 </script>
 573 <table cellpadding="3" cellspacing="0" border="0">
 574         <tr>
 575                 <td>
 576                         &nbsp;
 577                 </td>
 578         </tr>
 579         <tr>
 580                 <td align="left">
 581                         <p>
 582                         {$delete_chance}
 583                         </p>
 584                         <p>
 585                         {$backupDesc}
 586                         </p>
 587                         <p>
 588                         {$customized_mods_Desc}
 589                         </p>
 590                         <p>
 591                         {$copiedDesc}
 592                         </p>
 593                         <p>
 594                         {$skippedDesc}
 595                         </p>
 596                         <p>
 597                         {$skipped_queries_Desc}
 598                         </p>
 599                         <p>
 600                         {$rebuildResult}
 601                         </p>
 602                 </td>
 603         </tr>
 604         <tr><td>
 605                 <p>
 606                 {$old_schema}
 607                 </p>
 608         </td></tr>
 609         <tr><td>
 610                 {$old_schema_opt}
 611         </td></tr>
 612 </table>
 613 <div id="upgradeDiv" style="display:none">
 614     <table cellspacing="0" cellpadding="0" border="0">
 615         <tr><td>
 616            <p><!--not_in_theme!--><img src='modules/UpgradeWizard/processing.gif' alt='Processing'> <br></p>
 617         </td></tr>
 618      </table>
 619  </div>
 620  <script>
 621 function checkSchemaDropStatus() {
 622         if(document.getElementById('select_schema_drop') != null){
 623                 var schemaSelect = document.getElementById('select_schema_drop');
 624                 var schemaDropMethod = document.getElementById('schema_drop');
 625                 if(schemaSelect.options[schemaSelect.selectedIndex].value == 'manual') {
 626                         schemaDropMethod.value = 'manual';
 627                 } else {
 628                         schemaDropMethod.value = 'sugar';
 629                 }
 630    }
 631 }
 632  checkSchemaDropStatus();
 633  </script>
 634 eoq;
 635
 636 //set the upgrade progress status.
 637 set_upgrade_progress('commit','done','commit','done');
 638 $showBack = false;
 639 $showCancel = false;
 640 $showRecheck = false;
 641 $showNext =($stop) ? false : true;
 642
 643 $GLOBALS['top_message'] = "<b>{$mod_strings['LBL_UW_COMMIT_DESC']}</b>";
 644 $stepBack = $_REQUEST['step'] - 1;
 645 //Skip ahead to the end page as no layouts need to be merged.
 646 $skipLayouts = true;
 647 foreach($_SESSION['sugarMergeRunResults'] as $mergeModule => $mergeModuleFileList){
 648     if(!empty($mergeModuleFileList)){
 649         $skipLayouts = false;
 650     }
 651 }
 652 $stepNext = $skipLayouts ? $_REQUEST['step'] + 2 : $_REQUEST['step'] + 1;
 653 $stepCancel = -1;
 654 $stepRecheck = $_REQUEST['step'];
 655
 656 $_SESSION['step'][$steps['files'][$_REQUEST['step']]] =($stop) ? 'failed' : 'success';
 657
 658 // clear out the theme cache
 659 if(!class_exists('SugarThemeRegistry')){
 660     require_once('include/SugarTheme/SugarTheme.php');
 661 }
 662
 663 $themeObject = SugarThemeRegistry::current();
 664
 665 $styleJSFilePath = sugar_cached($themeObject->getJSPath() . DIRECTORY_SEPARATOR .  'style-min.js');
 666 if( file_exists($styleJSFilePath) )
 667 {
 668     logThis("Rebuilding style js file: $styleJSFilePath");
 669     unlink($styleJSFilePath);
 670     SugarThemeRegistry::current()->clearJSCache();
 671     SugarThemeRegistry::current()->getJS();
 672 }
 673 SugarThemeRegistry::buildRegistry();
 674 SugarThemeRegistry::clearAllCaches();
 675
 676 //Clean out the language files
 677 logThis("Rebuilding language cache");
 678 sugar_cache_reset_full();
 679 LanguageManager::clearLanguageCache();
 680
 681 // re-minify the JS source files
 682 $_REQUEST['root_directory'] = getcwd();
 683 $_REQUEST['js_rebuild_concat'] = 'rebuild';
 684 require_once('jssource/minify.php');