modules/UpgradeWizard/silentUpgrade_step1.php

   1 <?php
   2
   3 /*********************************************************************************
   4  * SugarCRM Community Edition is a customer relationship management program developed by
   5  * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
   6  *
   7  * This program is free software; you can redistribute it and/or modify it under
   8  * the terms of the GNU Affero General Public License version 3 as published by the
   9  * Free Software Foundation with the addition of the following permission added
  10  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
  11  * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
  12  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
  13  *
  14  * This program is distributed in the hope that it will be useful, but WITHOUT
  15  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  16  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
  17  * details.
  18  *
  19  * You should have received a copy of the GNU Affero General Public License along with
  20  * this program; if not, see http://www.gnu.org/licenses or write to the Free
  21  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
  22  * 02110-1301 USA.
  23  *
  24  * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
  25  * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
  26  *
  27  * The interactive user interfaces in modified source and object code versions
  28  * of this program must display Appropriate Legal Notices, as required under
  29  * Section 5 of the GNU Affero General Public License version 3.
  30  *
  31  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
  32  * these Appropriate Legal Notices must retain the display of the "Powered by
  33  * SugarCRM" logo. If the display of the logo is not reasonably feasible for
  34  * technical reasons, the Appropriate Legal Notices must display the words
  35  * "Powered by SugarCRM".
  36  ********************************************************************************/
  37
  38
  39 //////////////////////////////////////////////////////////////////////////////////////////
  40 //// This is a stand alone file that can be run from the command prompt for upgrading a
  41 //// Sugar Instance. Three parameters are required to be defined in order to execute this file.
  42 //// php.exe -f silentUpgrade.php [Path to Upgrade Package zip] [Path to Log file] [Path to Instance]
  43 //// See below the Usage for more details.
  44 /////////////////////////////////////////////////////////////////////////////////////////
  45 ini_set('memory_limit',-1);
  46 ///////////////////////////////////////////////////////////////////////////////
  47 ////    UTILITIES THAT MUST BE LOCAL :(
  48 function prepSystemForUpgradeSilent() {
  49         global $subdirs;
  50         global $cwd;
  51         global $sugar_config;
  52
  53         // make sure dirs exist
  54         foreach($subdirs as $subdir) {
  55                 if(!is_dir("upload://upgrades/{$subdir}")) {
  56                 mkdir_recursive("upload://upgrades/{$subdir}");
  57                 }
  58         }
  59 }
  60
  61 //local function for clearing cache
  62 function clearCacheSU($thedir, $extension) {
  63         if ($current = @opendir($thedir)) {
  64                 while (false !== ($children = readdir($current))) {
  65                         if ($children != "." && $children != "..") {
  66                                 if (is_dir($thedir . "/" . $children)) {
  67                                         clearCacheSU($thedir . "/" . $children, $extension);
  68                                 }
  69                                 elseif (is_file($thedir . "/" . $children) && substr_count($children, $extension)) {
  70                                         unlink($thedir . "/" . $children);
  71                                 }
  72                         }
  73                 }
  74         }
  75  }
  76  //Bug 24890, 24892. default_permissions not written to config.php. Following function checks and if
  77  //no found then adds default_permissions to the config file.
  78  function checkConfigForPermissions(){
  79      if(file_exists(getcwd().'/config.php')){
  80          require(getcwd().'/config.php');
  81      }
  82      global $sugar_config;
  83      if(!isset($sugar_config['default_permissions'])){
  84              $sugar_config['default_permissions'] = array (
  85                      'dir_mode' => 02770,
  86                      'file_mode' => 0660,
  87                      'user' => '',
  88                      'group' => '',
  89              );
  90          ksort($sugar_config);
  91          if(is_writable('config.php') && write_array_to_file("sugar_config", $sugar_config,'config.php')) {
  92                 //writing to the file
  93                 }
  94      }
  95 }
  96 function checkLoggerSettings(){
  97         if(file_exists(getcwd().'/config.php')){
  98          require(getcwd().'/config.php');
  99      }
 100     global $sugar_config;
 101         if(!isset($sugar_config['logger'])){
 102             $sugar_config['logger'] =array (
 103                         'level'=>'fatal',
 104                     'file' =>
 105                      array (
 106                       'ext' => '.log',
 107                       'name' => 'sugarcrm',
 108                       'dateFormat' => '%c',
 109                       'maxSize' => '10MB',
 110                       'maxLogs' => 10,
 111                       'suffix' => '%m_%Y',
 112                     ),
 113                   );
 114                  ksort($sugar_config);
 115          if(is_writable('config.php') && write_array_to_file("sugar_config", $sugar_config,'config.php')) {
 116                 //writing to the file
 117                 }
 118          }
 119 }
 120
 121 function checkLeadConversionSettings() {
 122     if (file_exists(getcwd().'/config.php')) {
 123          require(getcwd().'/config.php');
 124     }
 125     global $sugar_config;
 126     if (!isset($sugar_config['lead_conv_activity_opt'])) {
 127         $sugar_config['lead_conv_activity_opt'] = 'copy';
 128         ksort($sugar_config);
 129         if (is_writable('config.php') && write_array_to_file("sugar_config", $sugar_config,'config.php')) {
 130             //writing to the file
 131         }
 132     }
 133 }
 134
 135 function checkResourceSettings(){
 136         if(file_exists(getcwd().'/config.php')){
 137          require(getcwd().'/config.php');
 138      }
 139     global $sugar_config;
 140         if(!isset($sugar_config['resource_management'])){
 141           $sugar_config['resource_management'] =
 142                   array (
 143                     'special_query_limit' => 50000,
 144                     'special_query_modules' =>
 145                     array (
 146                       0 => 'Reports',
 147                       1 => 'Export',
 148                       2 => 'Import',
 149                       3 => 'Administration',
 150                       4 => 'Sync',
 151                     ),
 152                     'default_limit' => 1000,
 153                   );
 154                  ksort($sugar_config);
 155          if(is_writable('config.php') && write_array_to_file("sugar_config", $sugar_config,'config.php')) {
 156                 //writing to the file
 157                 }
 158         }
 159 }
 160
 161
 162 function createMissingRels(){
 163         $relForObjects = array('leads'=>'Leads','campaigns'=>'Campaigns','prospects'=>'Prospects');
 164         foreach($relForObjects as $relObjName=>$relModName){
 165                 //assigned_user
 166                 $guid = create_guid();
 167                 $query = "SELECT id FROM relationships WHERE relationship_name = '{$relObjName}_assigned_user'";
 168                 $result= $GLOBALS['db']->query($query, true);
 169                 $a = null;
 170                 $a = $GLOBALS['db']->fetchByAssoc($result);
 171                 if(!isset($a['id']) && empty($a['id']) ){
 172                         $qRel = "INSERT INTO relationships (id,relationship_name, lhs_module, lhs_table, lhs_key, rhs_module, rhs_table, rhs_key, join_table, join_key_lhs, join_key_rhs, relationship_type, relationship_role_column, relationship_role_column_value, reverse, deleted)
 173                                                 VALUES ('{$guid}', '{$relObjName}_assigned_user','Users','users','id','{$relModName}','{$relObjName}','assigned_user_id',NULL,NULL,NULL,'one-to-many',NULL,NULL,'0','0')";
 174                         $GLOBALS['db']->query($qRel);
 175                 }
 176                 //modified_user
 177                 $guid = create_guid();
 178                 $query = "SELECT id FROM relationships WHERE relationship_name = '{$relObjName}_modified_user'";
 179                 $result= $GLOBALS['db']->query($query, true);
 180                 $a = null;
 181                 $a = $GLOBALS['db']->fetchByAssoc($result);
 182                 if(!isset($a['id']) && empty($a['id']) ){
 183                         $qRel = "INSERT INTO relationships (id,relationship_name, lhs_module, lhs_table, lhs_key, rhs_module, rhs_table, rhs_key, join_table, join_key_lhs, join_key_rhs, relationship_type, relationship_role_column, relationship_role_column_value, reverse, deleted)
 184                                                 VALUES ('{$guid}', '{$relObjName}_modified_user','Users','users','id','{$relModName}','{$relObjName}','modified_user_id',NULL,NULL,NULL,'one-to-many',NULL,NULL,'0','0')";
 185                         $GLOBALS['db']->query($qRel);
 186                 }
 187                 //created_by
 188                 $guid = create_guid();
 189                 $query = "SELECT id FROM relationships WHERE relationship_name = '{$relObjName}_created_by'";
 190                 $result= $GLOBALS['db']->query($query, true);
 191                 $a = null;
 192                 $a = $GLOBALS['db']->fetchByAssoc($result);
 193         if(!isset($a['id']) && empty($a['id']) ){
 194                         $qRel = "INSERT INTO relationships (id,relationship_name, lhs_module, lhs_table, lhs_key, rhs_module, rhs_table, rhs_key, join_table, join_key_lhs, join_key_rhs, relationship_type, relationship_role_column, relationship_role_column_value, reverse, deleted)
 195                                                 VALUES ('{$guid}', '{$relObjName}_created_by','Users','users','id','{$relModName}','{$relObjName}','created_by',NULL,NULL,NULL,'one-to-many',NULL,NULL,'0','0')";
 196                         $GLOBALS['db']->query($qRel);
 197         }
 198                 $guid = create_guid();
 199                 $query = "SELECT id FROM relationships WHERE relationship_name = '{$relObjName}_team'";
 200                 $result= $GLOBALS['db']->query($query, true);
 201                 $a = null;
 202                 $a = $GLOBALS['db']->fetchByAssoc($result);
 203                 if(!isset($a['id']) && empty($a['id']) ){
 204                         $qRel = "INSERT INTO relationships (id,relationship_name, lhs_module, lhs_table, lhs_key, rhs_module, rhs_table, rhs_key, join_table, join_key_lhs, join_key_rhs, relationship_type, relationship_role_column, relationship_role_column_value, reverse, deleted)
 205                                                         VALUES ('{$guid}', '{$relObjName}_team','Teams','teams','id','{$relModName}','{$relObjName}','team_id',NULL,NULL,NULL,'one-to-many',NULL,NULL,'0','0')";
 206                         $GLOBALS['db']->query($qRel);
 207                 }
 208         }
 209         //Also add tracker perf relationship
 210         $guid = create_guid();
 211         $query = "SELECT id FROM relationships WHERE relationship_name = 'tracker_monitor_id'";
 212         $result= $GLOBALS['db']->query($query, true);
 213         $a = null;
 214         $a = $GLOBALS['db']->fetchByAssoc($result);
 215         if(!isset($a['id']) && empty($a['id']) ){
 216                 $qRel = "INSERT INTO relationships (id,relationship_name, lhs_module, lhs_table, lhs_key, rhs_module, rhs_table, rhs_key, join_table, join_key_lhs, join_key_rhs, relationship_type, relationship_role_column, relationship_role_column_value, reverse, deleted)
 217                                         VALUES ('{$guid}', 'tracker_monitor_id','TrackerPerfs','tracker_perf','monitor_id','Trackers','tracker','monitor_id',NULL,NULL,NULL,'one-to-many',NULL,NULL,'0','0')";
 218                 $GLOBALS['db']->query($qRel);
 219         }
 220 }
 221
 222
 223 /**
 224  * This function will merge password default settings into config file
 225  * @param   $sugar_config
 226  * @param   $sugar_version
 227  * @return  bool true if successful
 228  */
 229 function merge_passwordsetting($sugar_config, $sugar_version) {
 230
 231      $passwordsetting_defaults = array (
 232         'passwordsetting' => array (
 233             'minpwdlength' => '',
 234             'maxpwdlength' => '',
 235             'oneupper' => '',
 236             'onelower' => '',
 237             'onenumber' => '',
 238             'onespecial' => '',
 239             'SystemGeneratedPasswordON' => '',
 240             'generatepasswordtmpl' => '',
 241             'lostpasswordtmpl' => '',
 242             'customregex' => '',
 243             'regexcomment' => '',
 244             'forgotpasswordON' => false,
 245             'linkexpiration' => '1',
 246             'linkexpirationtime' => '30',
 247             'linkexpirationtype' => '1',
 248             'userexpiration' => '0',
 249             'userexpirationtime' => '',
 250             'userexpirationtype' => '1',
 251             'userexpirationlogin' => '',
 252             'systexpiration' => '0',
 253             'systexpirationtime' => '',
 254             'systexpirationtype' => '0',
 255             'systexpirationlogin' => '',
 256             'lockoutexpiration' => '0',
 257             'lockoutexpirationtime' => '',
 258             'lockoutexpirationtype' => '1',
 259             'lockoutexpirationlogin' => '',
 260         ),
 261     );
 262
 263     $sugar_config = sugarArrayMerge($passwordsetting_defaults, $sugar_config );
 264
 265     // need to override version with default no matter what
 266     $sugar_config['sugar_version'] = $sugar_version;
 267
 268     ksort( $sugar_config );
 269
 270     if( write_array_to_file( "sugar_config", $sugar_config, "config.php" ) ){
 271         return true;
 272     }
 273     else {
 274         return false;
 275     }
 276 }
 277
 278 function addDefaultModuleRoles($defaultRoles = array()) {
 279         foreach($defaultRoles as $roleName=>$role){
 280         foreach($role as $category=>$actions){
 281             foreach($actions as $name=>$access_override){
 282                     $query = "SELECT * FROM acl_actions WHERE name='$name' AND category = '$category' AND acltype='$roleName' AND deleted=0 ";
 283                                         $result = $GLOBALS['db']->query($query);
 284                                         //only add if an action with that name and category don't exist
 285                                         $row=$GLOBALS['db']->fetchByAssoc($result);
 286                                         if ($row == null) {
 287                                 $guid = create_guid();
 288                                 $currdate = gmdate('Y-m-d H:i:s');
 289                                 $query= "INSERT INTO acl_actions (id,date_entered,date_modified,modified_user_id,name,category,acltype,aclaccess,deleted ) VALUES ('$guid','$currdate','$currdate','1','$name','$category','$roleName','$access_override','0')";
 290                                                 $GLOBALS['db']->query($query);
 291                         }
 292             }
 293         }
 294         }
 295 }
 296
 297 function verifyArguments($argv,$usage_regular){
 298     $upgradeType = '';
 299     $cwd = getcwd(); // default to current, assumed to be in a valid SugarCRM root dir.
 300     if(isset($argv[3])) {
 301         if(is_dir($argv[3])) {
 302             $cwd = $argv[3];
 303             chdir($cwd);
 304         } else {
 305             echo "*******************************************************************************\n";
 306             echo "*** ERROR: 3rd parameter must be a valid directory.  Tried to cd to [ {$argv[3]} ].\n";
 307             exit(1);
 308         }
 309     }
 310
 311     if(is_file("{$cwd}/include/entryPoint.php")) {
 312         //this should be a regular sugar install
 313         $upgradeType = constant('SUGARCRM_INSTALL');
 314         //check if this is a valid zip file
 315         if(!is_file($argv[1])) { // valid zip?
 316             echo "*******************************************************************************\n";
 317             echo "*** ERROR: First argument must be a full path to the patch file. Got [ {$argv[1]} ].\n";
 318             echo $usage_regular;
 319             echo "FAILURE\n";
 320             exit(1);
 321         }
 322         if(count($argv) < 5) {
 323             echo "*******************************************************************************\n";
 324             echo "*** ERROR: Missing required parameters.  Received ".count($argv)." argument(s), require 5.\n";
 325             echo $usage_regular;
 326             echo "FAILURE\n";
 327             exit(1);
 328         }
 329     } else {
 330         //this should be a regular sugar install
 331         echo "*******************************************************************************\n";
 332         echo "*** ERROR: Tried to execute in a non-SugarCRM root directory.\n";
 333         exit(1);
 334     }
 335
 336     if(isset($argv[7]) && file_exists($argv[7].'SugarTemplateUtilties.php')){
 337         require_once($argv[7].'SugarTemplateUtilties.php');
 338     }
 339
 340     return $upgradeType;
 341 }
 342
 343
 344
 345 function threeWayMerge(){
 346         //using threeway merge apis
 347 }
 348
 349 ////    END UTILITIES THAT MUST BE LOCAL :(
 350 ///////////////////////////////////////////////////////////////////////////////
 351
 352
 353 // only run from command line
 354 if(isset($_SERVER['HTTP_USER_AGENT'])) {
 355         fwrite(STDERR,'This utility may only be run from the command line or command prompt.');
 356         exit(1);
 357 }
 358 //Clean_string cleans out any file  passed in as a parameter
 359 $_SERVER['PHP_SELF'] = 'silentUpgrade.php';
 360
 361 $usage_regular =<<<eoq2
 362 Usage: php.exe -f silentUpgrade.php [upgradeZipFile] [logFile] [pathToSugarInstance] [admin-user]
 363
 364 On Command Prompt Change directory to where silentUpgrade.php resides. Then type path to
 365 php.exe followed by -f silentUpgrade.php and the arguments.
 366
 367 Example:
 368     [path-to-PHP/]php.exe -f silentUpgrade.php [path-to-upgrade-package/]SugarEnt-Upgrade-5.2.0-to-5.5.0.zip [path-to-log-file/]silentupgrade.log  [path-to-sugar-instance/] admin
 369
 370 Arguments:
 371     upgradeZipFile                       : Upgrade package file.
 372     logFile                              : Silent Upgarde log file.
 373     pathToSugarInstance                  : Sugar Instance instance being upgraded.
 374     admin-user                           : admin user performing the upgrade
 375 eoq2;
 376 ////    END USAGE
 377 ///////////////////////////////////////////////////////////////////////////////
 378
 379
 380
 381 ///////////////////////////////////////////////////////////////////////////////
 382 ////    STANDARD REQUIRED SUGAR INCLUDES AND PRESETS
 383 if(!defined('sugarEntry')) define('sugarEntry', true);
 384
 385 $_SESSION = array();
 386 $_SESSION['schema_change'] = 'sugar'; // we force-run all SQL
 387 $_SESSION['silent_upgrade'] = true;
 388 $_SESSION['step'] = 'silent'; // flag to NOT try redirect to 4.5.x upgrade wizard
 389
 390 $_REQUEST = array();
 391 $_REQUEST['addTaskReminder'] = 'remind';
 392
 393
 394 define('SUGARCRM_INSTALL', 'SugarCRM_Install');
 395 define('DCE_INSTANCE', 'DCE_Instance');
 396
 397 global $cwd;
 398 $cwd = getcwd(); // default to current, assumed to be in a valid SugarCRM root dir.
 399
 400 $upgradeType = verifyArguments($argv,$usage_regular);
 401
 402 ///////////////////////////////////////////////////////////////////////////////
 403 //////  Verify that all the arguments are appropriately placed////////////////
 404
 405 $path                   = $argv[2]; // custom log file, if blank will use ./upgradeWizard.log
 406 $subdirs                = array('full', 'langpack', 'module', 'patch', 'theme', 'temp');
 407
 408 //$_REQUEST['zip_from_dir'] = $zip_from_dir;
 409
 410 define('SUGARCRM_PRE_INSTALL_FILE', 'scripts/pre_install.php');
 411 define('SUGARCRM_POST_INSTALL_FILE', 'scripts/post_install.php');
 412 define('SUGARCRM_PRE_UNINSTALL_FILE', 'scripts/pre_uninstall.php');
 413 define('SUGARCRM_POST_UNINSTALL_FILE', 'scripts/post_uninstall.php');
 414
 415
 416
 417 echo "\n";
 418 echo "********************************************************************\n";
 419 echo "***************This Upgrade process may take sometime***************\n";
 420 echo "********************************************************************\n";
 421 echo "\n";
 422
 423 global $sugar_config;
 424 $isDCEInstance = false;
 425 $errors = array();
 426
 427
 428 if($upgradeType != constant('DCE_INSTANCE')) {
 429
 430         ini_set('error_reporting',1);
 431         require_once('include/entryPoint.php');
 432         require_once('include/SugarLogger/SugarLogger.php');
 433         require_once('include/utils/zip_utils.php');
 434
 435
 436
 437         require('config.php');
 438         //require_once('modules/UpgradeWizard/uw_utils.php'); // must upgrade UW first
 439         if(isset($argv[3])) {
 440                 if(is_dir($argv[3])) {
 441                         $cwd = $argv[3];
 442                         chdir($cwd);
 443                 }
 444         }
 445
 446         require_once("{$cwd}/sugar_version.php"); // provides $sugar_version & $sugar_flavor
 447
 448     $GLOBALS['log']     = LoggerManager::getLogger('SugarCRM');
 449         $patchName              = basename($argv[1]);
 450         $zip_from_dir   = substr($patchName, 0, strlen($patchName) - 4); // patch folder name (minus ".zip")
 451         $path                   = $argv[2]; // custom log file, if blank will use ./upgradeWizard.log
 452
 453         if($sugar_version < '5.1.0'){
 454                 $db                             = &DBManager :: getInstance();
 455         }
 456         else{
 457                 $db                             = &DBManagerFactory::getInstance();
 458         }
 459         $UWstrings              = return_module_language('en_us', 'UpgradeWizard');
 460         $adminStrings   = return_module_language('en_us', 'Administration');
 461         $mod_strings    = array_merge($adminStrings, $UWstrings);
 462         $subdirs                = array('full', 'langpack', 'module', 'patch', 'theme', 'temp');
 463         global $unzip_dir;
 464     $license_accepted = false;
 465     if(isset($argv[5]) && (strtolower($argv[5])=='yes' || strtolower($argv[5])=='y')){
 466         $license_accepted = true;
 467          }
 468         //////////////////////////////////////////////////////////////////////////////
 469         //Adding admin user to the silent upgrade
 470
 471         $current_user = new User();
 472         if(isset($argv[4])) {
 473            //if being used for internal upgrades avoid admin user verification
 474            $user_name = $argv[4];
 475            $q = "select id from users where user_name = '" . $user_name . "' and is_admin=1";
 476            $result = $GLOBALS['db']->query($q, false);
 477            $logged_user = $GLOBALS['db']->fetchByAssoc($result);
 478            if(isset($logged_user['id']) && $logged_user['id'] != null){
 479                 //do nothing
 480             $current_user->retrieve($logged_user['id']);
 481            }
 482            else{
 483                 echo "FAILURE: Not an admin user in users table. Please provide an admin user\n";
 484                 exit(1);
 485            }
 486         }
 487         else {
 488                 echo "*******************************************************************************\n";
 489                 echo "*** ERROR: 4th parameter must be a valid admin user.\n";
 490                 echo $usage;
 491                 echo "FAILURE\n";
 492                 exit(1);
 493         }
 494
 495
 496                 /////retrieve admin user
 497         global $sugar_config;
 498         $configOptions = $sugar_config['dbconfig'];
 499
 500
 501 ///////////////////////////////////////////////////////////////////////////////
 502 ////    UPGRADE PREP
 503 prepSystemForUpgradeSilent();
 504
 505 //repair tabledictionary.ext.php file if needed
 506 repairTableDictionaryExtFile();
 507
 508 $unzip_dir = sugar_cached("upgrades/temp");
 509 $install_file = "upload://upgrades/patch/".basename($argv[1]);
 510
 511 $_SESSION['unzip_dir'] = $unzip_dir;
 512 $_SESSION['install_file'] = $install_file;
 513 $_SESSION['zip_from_dir'] = $zip_from_dir;
 514 if(is_dir($unzip_dir.'/scripts'))
 515 {
 516         rmdir_recursive($unzip_dir.'/scripts');
 517 }
 518 if(is_file($unzip_dir.'/manifest.php'))
 519 {
 520         rmdir_recursive($unzip_dir.'/manifest.php');
 521 }
 522 mkdir_recursive($unzip_dir);
 523 if(!is_dir($unzip_dir)) {
 524         echo "\n{$unzip_dir} is not an available directory\nFAILURE\n";
 525         fwrite(STDERR,"\n{$unzip_dir} is not an available directory\nFAILURE\n");
 526         exit(1);
 527 }
 528
 529 unzip($argv[1], $unzip_dir);
 530 // mimic standard UW by copy patch zip to appropriate dir
 531 copy($argv[1], $install_file);
 532 ////    END UPGRADE PREP
 533 ///////////////////////////////////////////////////////////////////////////////
 534
 535 ///////////////////////////////////////////////////////////////////////////////
 536 ////    UPGRADE UPGRADEWIZARD
 537
 538 $zipBasePath = "$unzip_dir/{$zip_from_dir}";
 539 $uwFiles = findAllFiles("{$zipBasePath}/modules/UpgradeWizard", array());
 540 $destFiles = array();
 541
 542 foreach($uwFiles as $uwFile) {
 543         $destFile = str_replace($zipBasePath."/", '', $uwFile);
 544         copy($uwFile, $destFile);
 545 }
 546 require_once('modules/UpgradeWizard/uw_utils.php'); // must upgrade UW first
 547 removeSilentUpgradeVarsCache(); // Clear the silent upgrade vars - Note: Any calls to these functions within this file are removed here
 548 logThis("*** SILENT UPGRADE INITIATED.", $path);
 549 logThis("*** UpgradeWizard Upgraded  ", $path);
 550
 551 if(function_exists('set_upgrade_vars')){
 552         set_upgrade_vars();
 553 }
 554
 555 if($configOptions['db_type'] == 'mysql'){
 556         //Change the db wait_timeout for this session
 557         $now_timeout = $db->getOne("select @@wait_timeout");
 558         logThis('Wait Timeout before change ***** '.$now_timeout , $path);
 559         $now_timeout = $db->getOne("set wait_timeout=28800");
 560         logThis('Wait Timeout after change ***** '.$now_timeout , $path);
 561 }
 562
 563 ////    END UPGRADE UPGRADEWIZARD
 564 ///////////////////////////////////////////////////////////////////////////////
 565
 566 ///////////////////////////////////////////////////////////////////////////////
 567 ////    MAKE SURE PATCH IS COMPATIBLE
 568 if(is_file("$unzip_dir/manifest.php")) {
 569         // provides $manifest array
 570         include("$unzip_dir/manifest.php");
 571         if(!isset($manifest)) {
 572                 fwrite(STDERR,"\nThe patch did not contain a proper manifest.php file.  Cannot continue.\n\n");
 573             exit(1);
 574         } else {
 575                 copy("$unzip_dir/manifest.php", "upload://upgrades/patch/{$zip_from_dir}-manifest.php");
 576
 577                 $error = validate_manifest($manifest);
 578                 if(!empty($error)) {
 579                         $error = strip_tags(br2nl($error));
 580                         fwrite(STDERR,"\n{$error}\n\nFAILURE\n");
 581                         exit(1);
 582                 }
 583         }
 584 } else {
 585         fwrite(STDERR,"\nThe patch did not contain a proper manifest.php file.  Cannot continue.\n\n");
 586         exit(1);
 587 }
 588
 589 $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');
 590 $_SESSION['upgrade_from_flavor'] = $manifest['name'];
 591
 592 global $sugar_config;
 593 global $sugar_version;
 594 global $sugar_flavor;
 595
 596 ////    END MAKE SURE PATCH IS COMPATIBLE
 597 ///////////////////////////////////////////////////////////////////////////////
 598
 599 ///////////////////////////////////////////////////////////////////////////////
 600 ////    RUN SILENT UPGRADE
 601 ob_start();
 602 set_time_limit(0);
 603 if(file_exists('ModuleInstall/PackageManager/PackageManagerDisplay.php')) {
 604         require_once('ModuleInstall/PackageManager/PackageManagerDisplay.php');
 605 }
 606
 607         $parserFiles = array();
 608
 609 if(file_exists(clean_path("{$zipBasePath}/include/SugarFields"))) {
 610         $parserFiles = findAllFiles(clean_path("{$zipBasePath}/include/SugarFields"), $parserFiles);
 611 }
 612  //$cwd = clean_path(getcwd());
 613 foreach($parserFiles as $file) {
 614         $srcFile = clean_path($file);
 615         //$targetFile = clean_path(getcwd() . '/' . $srcFile);
 616     if (strpos($srcFile,".svn") !== false) {
 617           //do nothing
 618     }
 619     else{
 620     $targetFile = str_replace(clean_path($zipBasePath), $cwd, $srcFile);
 621
 622     if(!file_exists(dirname($targetFile)))
 623     {
 624                 logThis("Create directory " . dirname($targetFile), $path);
 625         mkdir_recursive(str_replace($argv[3], '', dirname($targetFile))); // make sure the directory exists
 626         }
 627
 628         if(!file_exists($targetFile))
 629          {
 630                 //logThis('Copying file to destination: ' . $targetFile, $path);
 631                 if(!copy($srcFile, $targetFile)) {
 632                         logThis('*** ERROR: could not copy file: ' . $targetFile, $path);
 633                 } else {
 634                         $copiedFiles[] = $targetFile;
 635                 }
 636         } else {
 637                 //logThis('Skipping file: ' . $targetFile, $path);
 638                 //$skippedFiles[] = $targetFile;
 639         }
 640    }
 641  }
 642         //copy minimum required files including sugar_file_utils.php
 643         if(file_exists("{$zipBasePath}/include/utils/sugar_file_utils.php")){
 644                 $destFile = clean_path(str_replace($zipBasePath, $cwd, "{$zipBasePath}/include/utils/sugar_file_utils.php"));
 645                 copy("{$zipBasePath}/include/utils/sugar_file_utils.php", $destFile);
 646         }
 647         if(file_exists('include/utils/sugar_file_utils.php')){
 648         require_once('include/utils/sugar_file_utils.php');
 649     }
 650
 651 /*
 652 $errors = preflightCheck();
 653 if((count($errors) == 1)) { // only diffs
 654         logThis('file preflight check passed successfully.', $path);
 655 }
 656 else{
 657         fwrite(STDERR,"\nThe user doesn't have sufficient permissions to write to database'.\n\n");
 658         exit(1);
 659 }
 660 */
 661 //If version less than 500 then look for modules to be upgraded
 662 if(function_exists('set_upgrade_vars')){
 663         set_upgrade_vars();
 664 }
 665 //Initialize the session variables. If upgrade_progress.php is already created
 666 //look for session vars there and restore them
 667 if(function_exists('initialize_session_vars')){
 668         initialize_session_vars();
 669 }
 670
 671 if(!didThisStepRunBefore('preflight')){
 672         set_upgrade_progress('preflight','in_progress');
 673         //Quickcreatedefs on the basis of editviewdefs
 674     if(substr($sugar_version,0,1) >= 5){
 675         updateQuickCreateDefs();
 676         }
 677         set_upgrade_progress('preflight','done');
 678 }
 679 ////////////////COMMIT PROCESS BEGINS///////////////////////////////////////////////////////////////
 680 ////    MAKE BACKUPS OF TARGET FILES
 681
 682 if(!didThisStepRunBefore('commit')){
 683         set_upgrade_progress('commit','in_progress','commit','in_progress');
 684         if(!didThisStepRunBefore('commit','commitMakeBackupFiles')){
 685                 set_upgrade_progress('commit','in_progress','commitMakeBackupFiles','in_progress');
 686                 $errors = commitMakeBackupFiles($rest_dir, $install_file, $unzip_dir, $zip_from_dir, array());
 687                 set_upgrade_progress('commit','in_progress','commitMakeBackupFiles','done');
 688         }
 689
 690         //Need to make sure we have the matching copy of SetValueAction for static/instance method matching
 691     if(file_exists("include/Expressions/Actions/SetValueAction.php")){
 692         require_once("include/Expressions/Actions/SetValueAction.php");
 693     }
 694
 695         ///////////////////////////////////////////////////////////////////////////////
 696         ////    HANDLE PREINSTALL SCRIPTS
 697         if(empty($errors)) {
 698                 $file = "{$unzip_dir}/".constant('SUGARCRM_PRE_INSTALL_FILE');
 699
 700                 if(is_file($file)) {
 701                         include($file);
 702                         if(!didThisStepRunBefore('commit','pre_install')){
 703                                 set_upgrade_progress('commit','in_progress','pre_install','in_progress');
 704                                 pre_install();
 705                                 set_upgrade_progress('commit','in_progress','pre_install','done');
 706                         }
 707                 }
 708         }
 709
 710         //Clean smarty from cache
 711         $cachedir = sugar_cached('smarty');
 712         if(is_dir($cachedir)){
 713                 $allModFiles = array();
 714                 $allModFiles = findAllFiles($cachedir,$allModFiles);
 715            foreach($allModFiles as $file){
 716                 //$file_md5_ref = str_replace(clean_path(getcwd()),'',$file);
 717                 if(file_exists($file)){
 718                                 unlink($file);
 719                 }
 720            }
 721         }
 722
 723                 //Also add the three-way merge here. The idea is after the 451 html files have
 724                 //been converted run the 3-way merge. If 500 then just run the 3-way merge
 725                 if(file_exists('modules/UpgradeWizard/SugarMerge/SugarMerge.php')){
 726                     set_upgrade_progress('end','in_progress','threewaymerge','in_progress');
 727                     require_once('modules/UpgradeWizard/SugarMerge/SugarMerge.php');
 728                     $merger = new SugarMerge($zipBasePath);
 729                     $merger->mergeAll();
 730                     set_upgrade_progress('end','in_progress','threewaymerge','done');
 731                 }
 732         ///////////////////////////////////////////////////////////////////////////////
 733         ////    COPY NEW FILES INTO TARGET INSTANCE
 734
 735      if(!didThisStepRunBefore('commit','commitCopyNewFiles')){
 736                         set_upgrade_progress('commit','in_progress','commitCopyNewFiles','in_progress');
 737                         $split = commitCopyNewFiles($unzip_dir, $zip_from_dir);
 738                         $copiedFiles = $split['copiedFiles'];
 739                         $skippedFiles = $split['skippedFiles'];
 740                         set_upgrade_progress('commit','in_progress','commitCopyNewFiles','done');
 741          }
 742         require_once(clean_path($unzip_dir.'/scripts/upgrade_utils.php'));
 743         $new_sugar_version = getUpgradeVersion();
 744     $origVersion = substr(preg_replace("/[^0-9]/", "", $sugar_version),0,3);
 745     $destVersion = substr(preg_replace("/[^0-9]/", "", $new_sugar_version),0,3);
 746     $siv_varset_1 = setSilentUpgradeVar('origVersion', $origVersion);
 747     $siv_varset_2 = setSilentUpgradeVar('destVersion', $destVersion);
 748     $siv_write    = writeSilentUpgradeVars();
 749     if(!$siv_varset_1 || !$siv_varset_2 || !$siv_write){
 750         logThis("Error with silent upgrade variables: origVersion write success is ({$siv_varset_1}) ".
 751                         "-- destVersion write success is ({$siv_varset_2}) -- ".
 752                         "writeSilentUpgradeVars success is ({$siv_write}) -- ".
 753                         "path to cache dir is ({$GLOBALS['sugar_config']['cache_dir']})", $path);
 754     }
 755      require_once('modules/DynamicFields/templates/Fields/TemplateText.php');
 756         ///////////////////////////////////////////////////////////////////////////////
 757     ///    RELOAD NEW DEFINITIONS
 758     global $ACLActions, $beanList, $beanFiles;
 759     include('modules/ACLActions/actiondefs.php');
 760     include('include/modules.php');
 761         /////////////////////////////////////////////
 762
 763     if (!function_exists("inDeveloperMode")) {
 764         //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
 765         function inDeveloperMode()
 766         {
 767             return isset($GLOBALS['sugar_config']['developerMode']) && $GLOBALS['sugar_config']['developerMode'];
 768         }
 769     }
 770         ///////////////////////////////////////////////////////////////////////////////
 771         ////    HANDLE POSTINSTALL SCRIPTS
 772         if(empty($errors)) {
 773                 logThis('Starting post_install()...', $path);
 774
 775                 $trackerManager = TrackerManager::getInstance();
 776         $trackerManager->pause();
 777         $trackerManager->unsetMonitors();
 778
 779                 if(!didThisStepRunBefore('commit','post_install')){
 780                         $file = "$unzip_dir/" . constant('SUGARCRM_POST_INSTALL_FILE');
 781                         if(is_file($file)) {
 782                                 //set_upgrade_progress('commit','in_progress','post_install','in_progress');
 783                                 $progArray['post_install']='in_progress';
 784                                 post_install_progress($progArray,'set');
 785                                     global $moduleList;
 786                                         include($file);
 787                                         post_install();
 788                                 // cn: only run conversion if admin selects "Sugar runs SQL"
 789                                 if(!empty($_SESSION['allTables']) && $_SESSION['schema_change'] == 'sugar')
 790                                         executeConvertTablesSql($_SESSION['allTables']);
 791                                 //set process to done
 792                                 $progArray['post_install']='done';
 793                                 //set_upgrade_progress('commit','in_progress','post_install','done');
 794                                 post_install_progress($progArray,'set');
 795                         }
 796                 }
 797             //clean vardefs
 798                 logThis('Performing UWrebuild()...', $path);
 799                 ob_start();
 800                         @UWrebuild();
 801                 ob_end_clean();
 802                 logThis('UWrebuild() done.', $path);
 803
 804                 logThis('begin check default permissions .', $path);
 805                 checkConfigForPermissions();
 806             logThis('end check default permissions .', $path);
 807
 808             logThis('begin check logger settings .', $path);
 809                 checkLoggerSettings();
 810             logThis('begin check logger settings .', $path);
 811
 812             logThis('begin check lead conversion settings .', $path);
 813             checkLeadConversionSettings();
 814             logThis('end check lead conversion settings .', $path);
 815
 816             logThis('begin check resource settings .', $path);
 817                         checkResourceSettings();
 818                 logThis('begin check resource settings .', $path);
 819
 820
 821                 require("sugar_version.php");
 822                 require('config.php');
 823                 global $sugar_config;
 824
 825                 if($ce_to_pro_ent){
 826                         if(isset($sugar_config['sugarbeet']))
 827                         {
 828                             //$sugar_config['sugarbeet'] is only set in COMM
 829                             unset($sugar_config['sugarbeet']);
 830                         }
 831                     if(isset($sugar_config['disable_team_access_check']))
 832                         {
 833                             //$sugar_config['disable_team_access_check'] is a runtime configration,
 834                             //no need to write to config.php
 835                             unset($sugar_config['disable_team_access_check']);
 836                         }
 837                         if(!merge_passwordsetting($sugar_config, $sugar_version)) {
 838                                 logThis('*** ERROR: could not write config.php! - upgrade will fail!', $path);
 839                                 $errors[] = 'Could not write config.php!';
 840                         }
 841
 842                 }
 843
 844                 logThis('Set default_theme to Sugar', $path);
 845                 $sugar_config['default_theme'] = 'Sugar';
 846
 847                 if( !write_array_to_file( "sugar_config", $sugar_config, "config.php" ) ) {
 848             logThis('*** ERROR: could not write config.php! - upgrade will fail!', $path);
 849             $errors[] = 'Could not write config.php!';
 850         }
 851
 852         logThis('Set default_max_tabs to 7', $path);
 853                 $sugar_config['default_max_tabs'] = '7';
 854
 855                 if( !write_array_to_file( "sugar_config", $sugar_config, "config.php" ) ) {
 856             logThis('*** ERROR: could not write config.php! - upgrade will fail!', $path);
 857             $errors[] = 'Could not write config.php!';
 858         }
 859
 860                 logThis('Upgrade the sugar_version', $path);
 861                 $sugar_config['sugar_version'] = $sugar_version;
 862                 if($destVersion == $origVersion)
 863                         require('config.php');
 864         if( !write_array_to_file( "sugar_config", $sugar_config, "config.php" ) ) {
 865             logThis('*** ERROR: could not write config.php! - upgrade will fail!', $path);
 866             $errors[] = 'Could not write config.php!';
 867         }
 868
 869                 logThis('post_install() done.', $path);
 870         }
 871
 872         ///////////////////////////////////////////////////////////////////////////////
 873         ////    REGISTER UPGRADE
 874         if(empty($errors)) {
 875                 logThis('Registering upgrade with UpgradeHistory', $path);
 876                 if(!didThisStepRunBefore('commit','upgradeHistory')){
 877                         set_upgrade_progress('commit','in_progress','upgradeHistory','in_progress');
 878                         $file_action = "copied";
 879                         // if error was encountered, script should have died before now
 880                         $new_upgrade = new UpgradeHistory();
 881                         $new_upgrade->filename = $install_file;
 882                         $new_upgrade->md5sum = md5_file($install_file);
 883                         $new_upgrade->name = $zip_from_dir;
 884                         $new_upgrade->description = $manifest['description'];
 885                         $new_upgrade->type = 'patch';
 886                         $new_upgrade->version = $sugar_version;
 887                         $new_upgrade->status = "installed";
 888                         $new_upgrade->manifest = (!empty($_SESSION['install_manifest']) ? $_SESSION['install_manifest'] : '');
 889
 890                         if($new_upgrade->description == null){
 891                                 $new_upgrade->description = "Silent Upgrade was used to upgrade the instance";
 892                         }
 893                         else{
 894                                 $new_upgrade->description = $new_upgrade->description." Silent Upgrade was used to upgrade the instance.";
 895                         }
 896                    $new_upgrade->save();
 897                    set_upgrade_progress('commit','in_progress','upgradeHistory','done');
 898                    set_upgrade_progress('commit','done','commit','done');
 899                 }
 900           }
 901
 902         //Clean modules from cache
 903             $cachedir = sugar_cached('smarty');
 904                 if(is_dir($cachedir)){
 905                         $allModFiles = array();
 906                         $allModFiles = findAllFiles($cachedir,$allModFiles);
 907                    foreach($allModFiles as $file){
 908                         //$file_md5_ref = str_replace(clean_path(getcwd()),'',$file);
 909                         if(file_exists($file)){
 910                                         unlink($file);
 911                         }
 912                    }
 913                 }
 914    //delete cache/modules before rebuilding the relations
 915         //Clean modules from cache
 916             $cachedir = sugar_cached('modules');
 917                 if(is_dir($cachedir)){
 918                         $allModFiles = array();
 919                         $allModFiles = findAllFiles($cachedir,$allModFiles);
 920                    foreach($allModFiles as $file){
 921                         //$file_md5_ref = str_replace(clean_path(getcwd()),'',$file);
 922                         if(file_exists($file)){
 923                                         unlink($file);
 924                         }
 925                    }
 926                 }
 927
 928                 //delete cache/themes
 929                 $cachedir = sugar_cached('themes');
 930                 if(is_dir($cachedir)){
 931                         $allModFiles = array();
 932                         $allModFiles = findAllFiles($cachedir,$allModFiles);
 933                    foreach($allModFiles as $file){
 934                         //$file_md5_ref = str_replace(clean_path(getcwd()),'',$file);
 935                         if(file_exists($file)){
 936                                         unlink($file);
 937                         }
 938                    }
 939                 }
 940         ob_start();
 941         if(!isset($_REQUEST['silent'])){
 942                 $_REQUEST['silent'] = true;
 943         }
 944         else if(isset($_REQUEST['silent']) && $_REQUEST['silent'] != true){
 945                 $_REQUEST['silent'] = true;
 946         }
 947
 948          //logThis('Checking for leads_assigned_user relationship and if not found then create.', $path);
 949         @createMissingRels();
 950          //logThis('Checked for leads_assigned_user relationship.', $path);
 951         ob_end_clean();
 952         //// run fix on dropdown lists that may have been incorrectly named
 953     //fix_dropdown_list();
 954 }
 955
 956 set_upgrade_progress('end','in_progress','end','in_progress');
 957 /////////////////////////Old Logger settings///////////////////////////////////////
 958 ///////////////////////////////////////////////////////////////////////////////
 959
 960 if(function_exists('deleteCache')){
 961         set_upgrade_progress('end','in_progress','deleteCache','in_progress');
 962         @deleteCache();
 963         set_upgrade_progress('end','in_progress','deleteCache','done');
 964 }
 965
 966 ///////////////////////////////////////////////////////////////////////////////
 967 ////    HANDLE REMINDERS
 968 if(empty($errors)) {
 969         commitHandleReminders($skippedFiles, $path);
 970 }
 971
 972 if(file_exists(clean_path(getcwd()).'/original451files')){
 973         rmdir_recursive(clean_path(getcwd()).'/original451files');
 974 }
 975
 976 require_once('modules/Administration/Administration.php');
 977 $admin = new Administration();
 978 $admin->saveSetting('system','adminwizard',1);
 979
 980 logThis('Upgrading user preferences start .', $path);
 981 if(function_exists('upgradeUserPreferences')){
 982    upgradeUserPreferences();
 983 }
 984 logThis('Upgrading user preferences finish .', $path);
 985
 986
 987 require_once('modules/Administration/upgrade_custom_relationships.php');
 988 upgrade_custom_relationships();
 989
 990 if($ce_to_pro_ent)
 991 {
 992         //check to see if there are any new files that need to be added to systems tab
 993         //retrieve old modules list
 994         logThis('check to see if new modules exist',$path);
 995         $oldModuleList = array();
 996         $newModuleList = array();
 997         include($argv[3].'/include/modules.php');
 998         $oldModuleList = $moduleList;
 999         include('include/modules.php');
1000         $newModuleList = $moduleList;
1001
1002         //include tab controller
1003         require_once('modules/MySettings/TabController.php');
1004         $newTB = new TabController();
1005
1006         //make sure new modules list has a key we can reference directly
1007         $newModuleList = $newTB->get_key_array($newModuleList);
1008         $oldModuleList = $newTB->get_key_array($oldModuleList);
1009
1010         //iterate through list and remove commonalities to get new modules
1011         foreach ($newModuleList as $remove_mod){
1012             if(in_array($remove_mod, $oldModuleList)){
1013                 unset($newModuleList[$remove_mod]);
1014             }
1015         }
1016
1017         $must_have_modules= array(
1018                           'Activities'=>'Activities',
1019                   'Calendar'=>'Calendar',
1020                   'Reports' => 'Reports',
1021                           'Quotes' => 'Quotes',
1022                           'Products' => 'Products',
1023                           'Forecasts' => 'Forecasts',
1024                           'Contracts' => 'Contracts',
1025                           'KBDocuments' => 'KBDocuments'
1026         );
1027         $newModuleList = array_merge($newModuleList,$must_have_modules);
1028
1029         //new modules list now has left over modules which are new to this install, so lets add them to the system tabs
1030         logThis('new modules to add are '.var_export($newModuleList,true),$path);
1031
1032         //grab the existing system tabs
1033         $tabs = $newTB->get_system_tabs();
1034
1035         //add the new tabs to the array
1036         foreach($newModuleList as $nm ){
1037           $tabs[$nm] = $nm;
1038         }
1039
1040         //now assign the modules to system tabs
1041         $newTB->set_system_tabs($tabs);
1042         logThis('module tabs updated',$path);
1043 }
1044
1045 //Also set the tracker settings if  flavor conversion ce->pro or ce->ent
1046 if(isset($_SESSION['current_db_version']) && isset($_SESSION['target_db_version'])){
1047         if($_SESSION['current_db_version'] == $_SESSION['target_db_version']){
1048             $_REQUEST['upgradeWizard'] = true;
1049             ob_start();
1050                         include('include/Smarty/internals/core.write_file.php');
1051                 ob_end_clean();
1052                 $db =& DBManagerFactory::getInstance();
1053                 if($ce_to_pro_ent){
1054                 //Also set license information
1055                 $admin = new Administration();
1056                         $category = 'license';
1057                         $value = 0;
1058                         $admin->saveSetting($category, 'users', $value);
1059                         $key = array('num_lic_oc','key','expire_date');
1060                         $value = '';
1061                         foreach($key as $k){
1062                                 $admin->saveSetting($category, $k, $value);
1063                         }
1064                 }
1065         }
1066 }
1067
1068         $phpErrors = ob_get_contents();
1069         ob_end_clean();
1070         logThis("**** Potential PHP generated error messages: {$phpErrors}", $path);
1071
1072         if(count($errors) > 0) {
1073                 foreach($errors as $error) {
1074                         logThis("****** SilentUpgrade ERROR: {$error}", $path);
1075                 }
1076                 echo "FAILED\n";
1077         }
1078
1079
1080 }
1081
1082
1083 /**
1084  * repairTableDictionaryExtFile
1085  *
1086  * There were some scenarios in 6.0.x whereby the files loaded in the extension tabledictionary.ext.php file
1087  * did not exist.  This would cause warnings to appear during the upgrade.  As a result, this
1088  * function scans the contents of tabledictionary.ext.php and then remove entries where the file does exist.
1089  */
1090 function repairTableDictionaryExtFile()
1091 {
1092         $tableDictionaryExtDirs = array('custom/Extension/application/Ext/TableDictionary', 'custom/application/Ext/TableDictionary');
1093
1094         foreach($tableDictionaryExtDirs as $tableDictionaryExt)
1095         {
1096
1097                 if(is_dir($tableDictionaryExt) && is_writable($tableDictionaryExt)){
1098                         $dir = dir($tableDictionaryExt);
1099                         while(($entry = $dir->read()) !== false)
1100                         {
1101                                 $entry = $tableDictionaryExt . '/' . $entry;
1102                                 if(is_file($entry) && preg_match('/\.php$/i', $entry) && is_writeable($entry))
1103                                 {
1104
1105                                                 if(function_exists('sugar_fopen'))
1106                                                 {
1107                                                         $fp = @sugar_fopen($entry, 'r');
1108                                                 } else {
1109                                                         $fp = fopen($entry, 'r');
1110                                                 }
1111
1112
1113                                             if($fp)
1114                                         {
1115                                              $altered = false;
1116                                              $contents = '';
1117
1118                                              while($line = fgets($fp))
1119                                                      {
1120                                                         if(preg_match('/\s*include\s*\(\s*[\'|\"](.*?)[\"|\']\s*\)\s*;/', $line, $match))
1121                                                         {
1122                                                            if(!file_exists($match[1]))
1123                                                            {
1124                                                               $altered = true;
1125                                                            } else {
1126                                                                   $contents .= $line;
1127                                                            }
1128                                                         } else {
1129                                                            $contents .= $line;
1130                                                         }
1131                                                      }
1132
1133                                                      fclose($fp);
1134                                         }
1135
1136
1137                                             if($altered)
1138                                             {
1139                                                         if(function_exists('sugar_fopen'))
1140                                                         {
1141                                                                 $fp = @sugar_fopen($entry, 'w');
1142                                                         } else {
1143                                                                 $fp = fopen($entry, 'w');
1144                                                         }
1145
1146                                                         if($fp && fwrite($fp, $contents))
1147                                                         {
1148                                                                 fclose($fp);
1149                                                         }
1150                                             }
1151                                 } //if
1152                         } //while
1153                 } //if
1154         }
1155 }
1156
1157
1158 /**
1159  * sugar_cached
1160  *
1161  * Inline this method here since it is not yet defined in utils.php
1162  *
1163  * @param $file The path to retrieve cache lookup information for
1164  * @return string The cached path according to $GLOBALS['sugar_config']['cache_dir'] or just appended with cache if not defined
1165  */
1166 function sugar_cached($file)
1167 {
1168     static $cdir = null;
1169     if(empty($cdir) && !empty($GLOBALS['sugar_config']['cache_dir'])) {
1170         $cdir = rtrim($GLOBALS['sugar_config']['cache_dir'], '/\\');
1171     }
1172     if(empty($cdir)) {
1173         $cdir = "cache";
1174     }
1175     return "$cdir/$file";
1176 }
1177
1178
1179 ?>