";
// list preserved files (templates, etc.)
$preserve = '';
foreach($preserveFiles as $pf) {
if(empty($preserve)) {
$preserve .= "| ";
$preserve .= $mod_strings['LBL_UW_PREFLIGHT_PRESERVE_FILES'];
$preserve .= " |
";
}
$preserve .= "| ".str_replace(getcwd(), '.', $pf)." |
";
}
if(!empty($preserve)) {
$preserve .= '
';
}
$diffs = $preserve.$diffs;
} else { // NO FILE DIFFS REQUIRED
$diffs = $mod_strings['LBL_UW_PREFLIGHT_NO_DIFFS'];
}
echo $diffs;
return $persistence;
}
/**
* loads the sql file into an array
* @param array persistence
* @param bool preflight Flag to load for Preflight or Commit
* @return array persistence
*/
function preflightCheckJsonPrepSchemaCheck($persistence, $preflight=true) {
global $mod_strings;
global $db;
global $sugar_db_version;
global $manifest;
unset($persistence['sql_to_run']);
$persistence['sql_to_check'] = array();
$persistence['sql_to_check_backup'] = array();
if(isset($persistence['sql_check_done'])) {
// reset flag to not check (on Recheck)
unset($persistence['sql_check_done']);
unset($persistence['sql_errors']);
}
// get schema script if not loaded
if($preflight)
logThis('starting schema preflight check...');
else
logThis('Preparing SQL statements for sequential execution...');
if(!isset($sugar_db_version) || empty($sugar_db_version)) {
include('./sugar_version.php');
}
if(!isset($manifest['version']) || empty($manifest['version'])) {
include($persistence['unzip_dir'].'/manifest.php');
}
$current_version = substr(preg_replace("#[^0-9]#", "", $sugar_db_version),0,3);
$targetVersion = substr(preg_replace("#[^0-9]#", "", $manifest['version']),0,3);
$sqlScript = $persistence['unzip_dir'].'/scripts/'.$current_version.'_to_'.$targetVersion.'_'.$db->dbType.'.sql';
$newTables = array();
logThis('looking for schema script at: '.$sqlScript);
if(is_file($sqlScript)) {
logThis('found schema upgrade script: '.$sqlScript);
$fp = sugar_fopen($sqlScript, 'r');
$contents = fread($fp, filesize($sqlScript));
if(rewind($fp)) {
$completeLine = '';
while($line = fgets($fp)) {
if(strpos($line, '--') === false) {
$completeLine .= " ".trim($line);
if(strpos($line, ';') !== false) {
$completeLine = str_replace(';','',$completeLine);
$persistence['sql_to_check'][] = $completeLine;
$completeLine = ''; //reset for next loop
}
}
}
$persistence['sql_total'] = count($persistence['sql_to_check']);
} else {
logThis('*** ERROR: could not read schema script: '.$sqlScript);
$persistence['sql_errors'][] = $mod_strings['ERR_UW_FILE_NOT_READABLE'].'::'.$sqlScript;
}
}
// load a new array if for commit
if($preflight) {
$persistence['sql_to_check_backup'] = $persistence['sql_to_check'];
$persistence['sql_to_run'] = $persistence['sql_to_check'];
echo "1% ".$mod_strings['LBL_UW_DONE'];
} else {
$persistence['sql_to_run'] = $persistence['sql_to_check'];
unset($persistence['sql_to_check']);
}
return $persistence;
}
function preflightCheckJsonSchemaCheck($persistence) {
global $mod_strings;
global $db;
if(!isset($persistence['sql_check_done']) || $persistence['sql_check_done'] != true) {
// must keep sql in order
$completeLine = array_shift($persistence['sql_to_check']);
$whatsLeft = count($persistence['sql_to_check']);
// populate newTables array to prevent "getting sample data" from non-existent tables
$newTables = array();
if(strtoupper(substr($completeLine,1,5)) == 'CREAT')
$newTables[] = getTableFromQuery($completeLine);
$bad = verifySqlStatement(trim($completeLine), $db->dbType, $newTables);
if(!empty($bad)) {
logThis('*** ERROR: schema change script has errors: '.$completeLine);
$persistence['sql_errors'][] = $bad;
}
$persistence = ajaxSqlProgress($persistence, $completeLine, 'sql_to_check');
} else {
$persistence['sql_to_check'] = $persistence['sql_to_check_backup'];
echo 'done';
}
return $persistence;
}
function preflightCheckJsonGetSchemaErrors($persistence) {
global $mod_strings;
if(isset($persistence['sql_errors']) && count($persistence['sql_errors'] > 0)) {
$out = "{$mod_strings['ERR_UW_PREFLIGHT_ERRORS']}: ";
$out .= "{$mod_strings['LBL_UW_SHOW_SQL_ERRORS']}";
foreach($persistence['sql_errors'] as $sqlError) {
$out .= "
{$sqlError}";
}
$out .= "
";
} else {
$out = '';
}
// reset errors if Rechecking
if(isset($persistence['sql_errors']))
//unset($persistence['sql_errors']);
echo $out;
return $persistence;
}
function preflightCheckJsonFillSchema() {
global $mod_strings;
global $persistence;
global $sugar_db_version;
global $manifest;
global $db;
if(empty($sugar_db_version)) {
include('sugar_version');
}
if(empty($manifest)) {
include($persistence['unzip_dir'].'/manifest.php');
}
///////////////////////////////////////////////////////////////////////////////
//// SCHEMA SCRIPT HANDLING
$schema = '';
$alterTableSchemaOut = '';
$current_version = substr(preg_replace("#[^0-9]#", "", $sugar_db_version),0,3);
$targetVersion = substr(preg_replace("#[^0-9]#", "", $manifest['version']),0,3);
$sqlScript = $persistence['unzip_dir'].'/scripts/'.$current_version.'_to_'.$targetVersion.'_'.$db->dbType.'.sql';
$newTables = array();
logThis('looking for SQL script for DISPLAY at '.$sqlScript);
if(file_exists($sqlScript)) {
$fp = sugar_fopen($sqlScript, 'r');
$contents = fread($fp, filesize($sqlScript));
$schema = "{$mod_strings['LBL_UW_SHOW_SCHEMA']}";
$schema .= "
";
$schema .= "";
$schema .= "
";
}
//// END SCHEMA SCRIPT HANDLING
///////////////////////////////////////////////////////////////////////////////
ob_start();
echo $schema;
ob_flush();
}
function preflightCheckJsonAlterTableCharset() {
global $mod_strings;
global $sugar_db_version;
global $persistence;
if(empty($sugar_db_version))
include('sugar_version.php');
$current_version = substr(preg_replace("#[^0-9]#", "", $sugar_db_version),0,3);
if(version_compare($current_version, '450', "<")) {
if(isset($persistence['allTables']) && !empty($persistence['allTables'])) {
$alterTableContents = printAlterTableSql($persistence['allTables']);
$alterTableSchema = "{$mod_strings['LBL_UW_CHARSET_SCHEMA_CHANGE']}";
$alterTableSchema .= "
";
$alterTableSchema .= "";
$alterTableSchema .= "
";
}
} else {
$alterTableSchema = ''.$mod_strings['LBL_UW_PREFLIGHT_NOT_NEEDED'].'';
}
ob_start();
echo $alterTableSchema;
ob_flush();
}
///////////////////////////////////////////////////////////////////////////////
//// SYSTEMCHECK AJAX FUNCTIONS
function systemCheckJsonGetFiles($persistence) {
global $sugar_config;
global $mod_strings;
// add directories here that should be skipped when doing file permissions checks (cache/upload is the nasty one)
$skipDirs = array(
$sugar_config['upload_dir'],
getcwd().'/themes',
);
if(!isset($persistence['dirs_checked'])) {
$the_array = array();
$files = array();
$dir = getcwd();
$d = dir($dir);
while($f = $d->read()) {
if($f == "." || $f == "..") // skip *nix self/parent
continue;
if(is_dir("$dir/$f"))
$the_array[] = clean_path("$dir/$f");
else {
$files[] = clean_path("$dir/$f");
}
}
$persistence['files_to_check'] = $files;
$persistence['dirs_to_check'] = $the_array;
$persistence['dirs_total'] = count($the_array);
$persistence['dirs_checked'] = false;
$out = "1% {$mod_strings['LBL_UW_DONE']}";
return $persistence;
} elseif($persistence['dirs_checked'] == false) {
$dir = array_pop($persistence['dirs_to_check']);
$files = uwFindAllFiles($dir, array(), true, $skipDirs);
$persistence['files_to_check'] = array_merge($persistence['files_to_check'], $files);
$whatsLeft = count($persistence['dirs_to_check']);
if(!isset($persistence['dirs_to_check']) || $whatsLeft < 1) {
$whatsLeft = 0;
$persistence['dirs_checked'] = true;
}
$out = round((($persistence['dirs_total'] - $whatsLeft) / 21) * 100, 1)."% {$mod_strings['LBL_UW_DONE']}";
$out .= " [{$mod_strings['LBL_UW_SYSTEM_CHECK_CHECKING_JSON']} {$dir}]";
} else {
$out = "Done";
}
echo trim($out);
return $persistence;
}
/**
* checks files for permissions
* @param array files Array of files with absolute paths
* @return string result of check
*/
function systemCheckJsonCheckFiles($persistence) {
global $mod_strings;
global $persistence;
$filesNotWritable = array();
$i=0;
$filesOut = "
{$mod_strings['LBL_UW_SHOW_NW_FILES']}
| {$mod_strings['LBL_UW_FILE']} |
{$mod_strings['LBL_UW_FILE_PERMS']} |
{$mod_strings['LBL_UW_FILE_OWNER']} |
{$mod_strings['LBL_UW_FILE_GROUP']} |
";
$isWindows = is_windows();
foreach($persistence['files_to_check'] as $file) {
// while($file = array_pop($persistence['files_to_check'])) {
// admin deletes a bad file mid-check:
if(!file_exists($file))
continue;
if($isWindows) {
if(!is_writable_windows($file)) {
logThis('WINDOWS: File ['.$file.'] not readable - saving for display');
// don't warn yet - we're going to use this to check against replacement files
$filesNotWritable[$i] = $file;
$filesNWPerms[$i] = substr(sprintf('%o',fileperms($file)), -4);
$filesOut .= "".
"| {$file} | ".
"{$filesNWPerms[$i]} | ".
"".$mod_strings['ERR_UW_CANNOT_DETERMINE_USER']." | ".
"".$mod_strings['ERR_UW_CANNOT_DETERMINE_GROUP']." | ".
"
";
}
} else {
if(!is_writable($file)) {
logThis('File ['.$file.'] not writable - saving for display');
// don't warn yet - we're going to use this to check against replacement files
$filesNotWritable[$i] = $file;
$filesNWPerms[$i] = substr(sprintf('%o',fileperms($file)), -4);
$owner = posix_getpwuid(fileowner($file));
$group = posix_getgrgid(filegroup($file));
$filesOut .= "".
"| {$file} | ".
"{$filesNWPerms[$i]} | ".
"".$owner['name']." | ".
"".$group['name']." | ".
"
";
}
}
$i++;
}
$filesOut .= '
';
// not a stop error
$persistence['filesNotWritable'] = (count($filesNotWritable) > 0) ? true : false;
if(count($filesNotWritable) < 1) {
$filesOut = "{$mod_strings['LBL_UW_FILE_NO_ERRORS']}";
$persistence['step']['systemCheck'] = 'success';
}
echo $filesOut;
return $persistence;
}
?>