*/ public static $writableFilesAndFolders = array ( 'Configuration File' => './config.inc.php', 'Tabdata File' => './tabdata.php', 'Parent Tabdata File' => './parent_tabdata.php', 'Cache Directory' => './cache/', 'Image Cache Directory' => './cache/images/', 'Import Cache Directory' => './cache/import/', 'Storage Directory' => './storage/', 'User Privileges Directory' => './user_privileges/', 'Modules Directory' => './modules/', 'Cron Modules Directory' => './cron/modules/', 'Vtlib Test Directory' => './test/vtlib/', 'Vtlib Test HTML Directory' => './test/vtlib/HTML', 'Mail Merge Template Directory' => './test/wordtemplatedownload/', 'Product Image Directory' => './test/product/', 'User Image Directory' => './test/user/', 'Contact Image Directory' => './test/contact/', 'Logo Directory' => './test/logo/', 'Logs Directory' => './logs/', ); /** * Function returns all the files and folder that are not writable * @return */ public static function getFailedPermissionsFiles() { $writableFilesAndFolders = self::$writableFilesAndFolders; $failedPermissions = array(); require_once ('include/utils/VtlibUtils.php'); foreach ($writableFilesAndFolders as $index => $value) { if (!vtlib_isWriteable($value)) { $failedPermissions[$index] = $value; } } return $failedPermissions; } /** * Function returns the php.ini file settings required for installing vtigerCRM * @return */ static function getCurrentDirectiveValue() { $directiveValues = array(); if (ini_get('safe_mode') == '1' || stripos(ini_get('safe_mode'), 'On') > -1) $directiveValues['safe_mode'] = 'On'; if (ini_get('display_errors') != '1' || stripos(ini_get('display_errors'), 'Off') > -1) $directiveValues['display_errors'] = 'Off'; if (ini_get('file_uploads') != '1' || stripos(ini_get('file_uploads'), 'Off') > -1) $directiveValues['file_uploads'] = 'Off'; if (ini_get('register_globals') == '1' || stripos(ini_get('register_globals'), 'On') > -1) $directiveValues['register_globals'] = 'On'; if (ini_get(('output_buffering') < '4096' && ini_get('output_buffering') != '0') || stripos(ini_get('output_buffering'), 'Off') > -1) $directiveValues['output_buffering'] = 'Off'; if (ini_get('max_execution_time') < 600) $directiveValues['max_execution_time'] = ini_get('max_execution_time'); if (ini_get('memory_limit') < 32) $directiveValues['memory_limit'] = ini_get('memory_limit'); $errorReportingValue = E_WARNING & ~E_NOTICE; if(version_compare(PHP_VERSION, '5.5.0') >= 0){ $errorReportingValue = E_WARNING & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT; } else if(version_compare(PHP_VERSION, '5.3.0') >= 0) { $errorReportingValue = E_WARNING & ~E_NOTICE & ~E_DEPRECATED; } if (ini_get('error_reporting') != $errorReportingValue) $directiveValues['error_reporting'] = 'NOT RECOMMENDED'; if (ini_get('log_errors') == '1' || stripos(ini_get('log_errors'), 'On') > -1) $directiveValues['log_errors'] = 'On'; if (ini_get('short_open_tag') != '1' || stripos(ini_get('short_open_tag'), 'Off') > -1) $directiveValues['short_open_tag'] = 'Off'; return $directiveValues; } /** * Variable has the recommended php settings for smooth running of vtigerCRM * @var */ public static $recommendedDirectives = array ( 'safe_mode' => 'Off', 'display_errors' => 'On', 'file_uploads' => 'On', 'register_globals' => 'On', 'output_buffering' => 'On', 'max_execution_time' => '600', 'memory_limit' => '32', 'error_reporting' => 'E_WARNING & ~E_NOTICE', 'log_errors' => 'Off', 'short_open_tag' => 'On' ); /** * Returns the recommended php settings for vtigerCRM * @return type */ function getRecommendedDirectives(){ if(version_compare(PHP_VERSION, '5.5.0') >= 0){ self::$recommendedDirectives['error_reporting'] = 'E_WARNING & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT'; } else if(version_compare(PHP_VERSION, '5.3.0') >= 0) { self::$recommendedDirectives['error_reporting'] = 'E_WARNING & ~E_NOTICE & ~E_DEPRECATED'; } return self::$recommendedDirectives; } /** * Function checks for vtigerCRM installation prerequisites * @return */ function getSystemPreInstallParameters() { $preInstallConfig = array(); // Name => array( System Value, Recommended value, supported or not(true/false) ); $preInstallConfig['LBL_PHP_VERSION'] = array(phpversion(), '5.3.0', (version_compare(phpversion(), '5.3.0', '>='))); $preInstallConfig['LBL_IMAP_SUPPORT'] = array(function_exists('imap_open'), true, (function_exists('imap_open') == true)); $preInstallConfig['LBL_ZLIB_SUPPORT'] = array(function_exists('gzinflate'), true, (function_exists('gzinflate') == true)); if ($preInstallConfig['LBL_PHP_VERSION'] >= '5.5.0') { $preInstallConfig['LBL_MYSQLI_CONNECT_SUPPORT'] = array(extension_loaded('mysqli'), true, extension_loaded('mysqli')); } $preInstallConfig['LBL_OPEN_SSL'] = array(extension_loaded('openssl'), true, extension_loaded('openssl')); $preInstallConfig['LBL_CURL'] = array(extension_loaded('curl'), true, extension_loaded('curl')); $gnInstalled = false; if(!function_exists('gd_info')) { eval(self::$gdInfoAlternate); } $gd_info = gd_info(); if (isset($gd_info['GD Version'])) { $gnInstalled = true; } $preInstallConfig['LBL_GD_LIBRARY'] = array((extension_loaded('gd') || $gnInstalled), true, (extension_loaded('gd') || $gnInstalled)); $preInstallConfig['LBL_ZLIB_SUPPORT'] = array(function_exists('gzinflate'), true, (function_exists('gzinflate') == true)); return $preInstallConfig; } /** * Function that provides default configuration based on installer setup * @return */ function getDefaultPreInstallParameters() { include 'config.db.php'; $parameters = array( 'db_hostname' => '', 'db_username' => '', 'db_password' => '', 'db_name' => '', 'admin_name' => 'admin', 'admin_lastname'=> 'Administrator', 'admin_password'=>'', 'admin_email' => '', ); if (isset($dbconfig) && isset($vtconfig)) { if (isset($dbconfig['db_server']) && $dbconfig['db_server'] != '_DBC_SERVER_') { $parameters['db_hostname'] = $dbconfig['db_server'] . ':' . $dbconfig['db_port']; $parameters['db_username'] = $dbconfig['db_username']; $parameters['db_password'] = $dbconfig['db_password']; $parameters['db_name'] = $dbconfig['db_name']; $parameters['admin_password'] = $vtconfig['adminPwd']; $parameters['admin_email'] = $vtconfig['adminEmail']; } } return $parameters; } /** * Function returns gd library information * @var type */ public static $gdInfoAlternate = 'function gd_info() { $array = Array( "GD Version" => "", "FreeType Support" => 0, "FreeType Support" => 0, "FreeType Linkage" => "", "T1Lib Support" => 0, "GIF Read Support" => 0, "GIF Create Support" => 0, "JPG Support" => 0, "PNG Support" => 0, "WBMP Support" => 0, "XBM Support" => 0 ); $gif_support = 0; ob_start(); eval("phpinfo();"); $info = ob_get_contents(); ob_end_clean(); foreach(explode("\n", $info) as $line) { if(strpos($line, "GD Version")!==false) $array["GD Version"] = trim(str_replace("GD Version", "", strip_tags($line))); if(strpos($line, "FreeType Support")!==false) $array["FreeType Support"] = trim(str_replace("FreeType Support", "", strip_tags($line))); if(strpos($line, "FreeType Linkage")!==false) $array["FreeType Linkage"] = trim(str_replace("FreeType Linkage", "", strip_tags($line))); if(strpos($line, "T1Lib Support")!==false) $array["T1Lib Support"] = trim(str_replace("T1Lib Support", "", strip_tags($line))); if(strpos($line, "GIF Read Support")!==false) $array["GIF Read Support"] = trim(str_replace("GIF Read Support", "", strip_tags($line))); if(strpos($line, "GIF Create Support")!==false) $array["GIF Create Support"] = trim(str_replace("GIF Create Support", "", strip_tags($line))); if(strpos($line, "GIF Support")!==false) $gif_support = trim(str_replace("GIF Support", "", strip_tags($line))); if(strpos($line, "JPG Support")!==false) $array["JPG Support"] = trim(str_replace("JPG Support", "", strip_tags($line))); if(strpos($line, "PNG Support")!==false) $array["PNG Support"] = trim(str_replace("PNG Support", "", strip_tags($line))); if(strpos($line, "WBMP Support")!==false) $array["WBMP Support"] = trim(str_replace("WBMP Support", "", strip_tags($line))); if(strpos($line, "XBM Support")!==false) $array["XBM Support"] = trim(str_replace("XBM Support", "", strip_tags($line))); } if($gif_support==="enabled") { $array["GIF Read Support"] = 1; $array["GIF Create Support"] = 1; } if($array["FreeType Support"]==="enabled"){ $array["FreeType Support"] = 1; } if($array["T1Lib Support"]==="enabled") $array["T1Lib Support"] = 1; if($array["GIF Read Support"]==="enabled"){ $array["GIF Read Support"] = 1; } if($array["GIF Create Support"]==="enabled") $array["GIF Create Support"] = 1; if($array["JPG Support"]==="enabled") $array["JPG Support"] = 1; if($array["PNG Support"]==="enabled") $array["PNG Support"] = 1; if($array["WBMP Support"]==="enabled") $array["WBMP Support"] = 1; if($array["XBM Support"]==="enabled") $array["XBM Support"] = 1; return $array; }'; /** * Returns list of currencies * @return */ public static function getCurrencyList() { require_once 'modules/Utilities/Currencies.php'; return $currencies; } /** * Function checks if its mysql type * @param type $dbType * @return type */ static function isMySQL($dbType) { return (stripos($dbType ,'mysql') === 0); } /** * Function returns mysql version * @param type $serverInfo * @return type */ public static function getMySQLVersion($serverInfo) { if(!is_array($serverInfo)) { $version = explode('-',$serverInfo); $mysql_server_version=$version[0]; } else { $mysql_server_version = $serverInfo['version']; } return $mysql_server_version; } /** * Function checks the database connection * @param $db_type * @param $db_hostname * @param $db_username * @param $db_password * @param $db_name * @param $create_db * @param $create_utf8_db * @param $root_user * @param $root_password * @return */ public static function checkDbConnection($db_type, $db_hostname, $db_username, $db_password, $db_name, $create_db=false, $create_utf8_db=true, $root_user='', $root_password='') { $dbCheckResult = array(); $db_type_status = false; // is there a db type? $db_server_status = false; // does the db server connection exist? $db_creation_failed = false; // did we try to create a database and fail? $db_exist_status = false; // does the database exist? $db_utf8_support = false; // does the database support utf8? //Checking for database connection parameters if($db_type) { $conn = &NewADOConnection($db_type); $db_type_status = true; if(@$conn->Connect($db_hostname,$db_username,$db_password)) { $db_server_status = true; $serverInfo = $conn->ServerInfo(); if(self::isMySQL($db_type)) { $mysql_server_version = self::getMySQLVersion($serverInfo); } if($create_db) { // drop the current database if it exists $dropdb_conn = &NewADOConnection($db_type); if(@$dropdb_conn->Connect($db_hostname, $root_user, $root_password, $db_name)) { $query = "DROP DATABASE ".$db_name; $dropdb_conn->Execute($query); $dropdb_conn->Close(); } // create the new database $db_creation_failed = true; $createdb_conn = &NewADOConnection($db_type); if(@$createdb_conn->Connect($db_hostname, $root_user, $root_password)) { $query = "CREATE DATABASE ".$db_name; if($create_utf8_db == 'true') { if(self::isMySQL($db_type)) $query .= " DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci"; $db_utf8_support = true; } if($createdb_conn->Execute($query)) { $db_creation_failed = false; } $createdb_conn->Close(); } } if(@$conn->Connect($db_hostname, $db_username, $db_password, $db_name)) { $db_exist_status = true; if(!$db_utf8_support) { $db_utf8_support = Vtiger_Util_Helper::checkDbUTF8Support($conn); } } $conn->Close(); } } $dbCheckResult['db_utf8_support'] = $db_utf8_support; $error_msg = ''; $error_msg_info = ''; if(!$db_type_status || !$db_server_status) { $error_msg = getTranslatedString('ERR_DATABASE_CONNECTION_FAILED', 'Install').'. '.getTranslatedString('ERR_INVALID_MYSQL_PARAMETERS', 'Install'); $error_msg_info = getTranslatedString('MSG_LIST_REASONS', 'Install').':
- '.getTranslatedString('MSG_DB_PARAMETERS_INVALID', 'Install').' - '.getTranslatedString('MSG_DB_USER_NOT_AUTHORIZED', 'Install'); } elseif(self::isMySQL($db_type) && $mysql_server_version < 4.1) { $error_msg = $mysql_server_version.' -> '.getTranslatedString('ERR_INVALID_MYSQL_VERSION', 'Install'); } elseif($db_creation_failed) { $error_msg = getTranslatedString('ERR_UNABLE_CREATE_DATABASE', 'Install').' '.$db_name; $error_msg_info = getTranslatedString('MSG_DB_ROOT_USER_NOT_AUTHORIZED', 'Install'); } elseif(!$db_exist_status) { $error_msg = $db_name.' -> '.getTranslatedString('ERR_DB_NOT_FOUND', 'Install'); } else { $dbCheckResult['flag'] = true; return $dbCheckResult; } $dbCheckResult['flag'] = false; $dbCheckResult['error_msg'] = $error_msg; $dbCheckResult['error_msg_info'] = $error_msg_info; return $dbCheckResult; } /** * Function installs all the available modules */ public static function installModules() { require_once('vtlib/Vtiger/Package.php'); require_once('vtlib/Vtiger/Module.php'); require_once('include/utils/utils.php'); $moduleFolders = array('packages/vtiger/mandatory', 'packages/vtiger/optional'); foreach($moduleFolders as $moduleFolder) { if ($handle = opendir($moduleFolder)) { while (false !== ($file = readdir($handle))) { $packageNameParts = explode(".",$file); if($packageNameParts[count($packageNameParts)-1] != 'zip'){ continue; } array_pop($packageNameParts); $packageName = implode("",$packageNameParts); if (!empty($packageName)) { $packagepath = "$moduleFolder/$file"; $package = new Vtiger_Package(); $module = $package->getModuleNameFromZip($packagepath); if($module != null) { $moduleInstance = Vtiger_Module::getInstance($module); if($moduleInstance) { updateVtlibModule($module, $packagepath); } else { installVtlibModule($module, $packagepath); } } } } closedir($handle); } } } }