2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
3 /*********************************************************************************
4 * SugarCRM Community Edition is a customer relationship management program developed by
5 * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
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.
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
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
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.
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.
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 ********************************************************************************/
38 /*********************************************************************************
40 ********************************************************************************/
41 require_once('include/utils/encryption_utils.php');
43 function getSystemInfo($send_usage_info=true){
45 global $db, $administration, $timedate;
47 $info = getBaseSystemInfo($send_usage_info);
49 $info['application_key']=$sugar_config['unique_key'];
50 $info['php_version']=phpversion();
51 if(isset($_SERVER['SERVER_SOFTWARE'])) {
52 $info['server_software'] = $_SERVER['SERVER_SOFTWARE'];
57 $query = "SELECT count(*) as total from users WHERE " . User::getLicensedUsersWhere();
58 $result = $db->getOne($query, false, 'fetching active users count');
59 if ($result !== false) {
60 $info['users'] = $result;
63 if(empty($administration)){
65 $administration = new Administration();
67 $administration->retrieveSettings('system');
68 $info['system_name'] = (!empty($administration->settings['system_name']))?substr($administration->settings['system_name'], 0 ,255):'';
71 $result=$db->getOne("select count(*) count from users where status='Active' and deleted=0 and is_admin='1'", false, 'fetching admin count');
72 if($result !== false) {
73 $info['admin_users'] = $result;
77 $result=$db->getOne("select count(*) count from users", false, 'fetching all users count');
78 if($result !== false) {
79 $info['registered_users'] = $result;
82 $lastMonth = $db->convert("'". $timedate->getNow()->modify("-30 days")->asDb(false) . "'", 'datetime');
83 if( !$send_usage_info) {
84 $info['users_active_30_days'] = -1;
86 $info['users_active_30_days'] = $db->getOne("SELECT count( DISTINCT users.id ) user_count FROM tracker, users WHERE users.id = tracker.user_id AND tracker.date_modified >= $lastMonth", false, 'fetching last 30 users count');
92 if(!$send_usage_info){
93 $info['latest_tracker_id'] = -1;
95 $id=$db->getOne("select id from tracker order by date_modified desc", false, 'fetching most recent tracker entry');
97 $info['latest_tracker_id'] = $id;
100 $info['db_type']=$sugar_config['dbconfig']['db_type'];
101 $info['db_version']=$db->version();
103 if(file_exists('distro.php')){
104 include('distro.php');
105 if(!empty($distro_name))$info['distro_name'] = $distro_name;
107 $info['os'] = php_uname('s');
108 $info['os_version'] = php_uname('r');
109 $info['timezone_u'] = $GLOBALS['current_user']->getPreference('timezone');
110 $info['timezone'] = date('e');
111 if($info['timezone'] == 'e'){
112 $info['timezone'] = date('T');
118 function getBaseSystemInfo($send_usage_info=true){
119 include('sugar_version.php');
122 if($send_usage_info){
123 $info['sugar_db_version']=$sugar_db_version;
125 $info['sugar_version']=$sugar_version;
126 $info['sugar_flavor']=$sugar_flavor;
127 $info['auth_level'] = 0;
136 function check_now($send_usage_info=true, $get_request_data=false, $response_data = false, $from_install=false ) {
137 global $sugar_config, $timedate;
138 global $db, $license;
139 include('sugar_version.php');
142 $return_array=array();
143 if(!$from_install && empty($license))loadLicense(true);
148 $info = getBaseSystemInfo(false);
151 $info = getSystemInfo($send_usage_info);
154 require_once('include/nusoap/nusoap.php');
156 $GLOBALS['log']->debug('USING HTTPS TO CONNECT TO HEARTBEAT');
157 $sclient = new nusoapclient('https://updates.sugarcrm.com/heartbeat/soap.php', false, false, false, false, false, 15, 15);
158 $ping = $sclient->call('sugarPing', array());
159 if (empty($ping) || $sclient->getError()) {
160 if (!$get_request_data) {
163 'version' => $sugar_version,
164 'description' => "You have the latest version."
171 $key = '4829482749329';
175 $encoded = sugarEncode($key, serialize($info));
177 if($get_request_data){
178 $request_data = array('key'=>$key, 'data'=>$encoded);
179 return serialize($request_data);
181 $encodedResult = $sclient->call('sugarHome', array('key'=>$key, 'data'=>$encoded));
184 $encodedResult = $response_data['data'];
185 $key = $response_data['key'];
189 if($response_data || !$sclient->getError()){
190 $serializedResultData = sugarDecode($key,$encodedResult);
191 $resultData = unserialize($serializedResultData);
192 if($response_data && empty($resultData))
194 $resultData = array();
195 $resultData['validation'] = 'invalid validation key';
199 $resultData = array();
200 $resultData['versions'] = array();
204 if($response_data || !$sclient->getError() )
206 if(!empty($resultData['msg'])){
207 if(!empty($resultData['msg']['admin'])){
208 $license->saveSetting('license', 'msg_admin', base64_encode($resultData['msg']['admin']));
210 $license->saveSetting('license', 'msg_admin','');
212 if(!empty($resultData['msg']['all'])){
213 $license->saveSetting('license', 'msg_all', base64_encode($resultData['msg']['all']));
215 $license->saveSetting('license', 'msg_all','');
218 $license->saveSetting('license', 'msg_admin','');
219 $license->saveSetting('license', 'msg_all','');
221 $license->saveSetting('license', 'last_validation', 'success');
222 unset($_SESSION['COULD_NOT_CONNECT']);
226 $resultData = array();
227 $resultData['versions'] = array();
229 $license->saveSetting('license', 'last_connection_fail', TimeDate::getInstance()->nowDb());
230 $license->saveSetting('license', 'last_validation', 'no_connection');
232 if( empty($license->settings['license_last_validation_success']) && empty($license->settings['license_last_validation_fail']) && empty($license->settings['license_vk_end_date'])){
233 $license->saveSetting('license', 'vk_end_date', TimeDate::getInstance()->nowDb());
235 $license->saveSetting('license', 'validation_key', base64_encode(serialize(array('verified'=>false))));
237 $_SESSION['COULD_NOT_CONNECT'] =TimeDate::getInstance()->nowDb();
240 if(!empty($resultData['versions'])){
242 $license->saveSetting('license', 'latest_versions',base64_encode(serialize($resultData['versions'])));
244 $resultData['versions'] = array();
245 $license->saveSetting('license', 'latest_versions','') ;
248 if(sizeof($resultData) == 1 && !empty($resultData['versions'][0]['version'])
249 && compareVersions($sugar_version, $resultData['versions'][0]['version']))
251 $resultData['versions'][0]['version'] = $sugar_version;
252 $resultData['versions'][0]['description'] = "You have the latest version.";
256 return $resultData['versions'];
259 * returns true if $ver1 > $ver2
261 function compareVersions($ver1, $ver2)
263 return (version_compare($ver1, $ver2) === 1);
265 function set_CheckUpdates_config_setting($value) {
268 $admin=new Administration();
269 $admin->saveSetting('Update','CheckUpdates',$value);
271 /* return's value for the 'CheckUpdates' config setting
272 * if the setting does not exist one gets created with a default value of automatic.
274 function get_CheckUpdates_config_setting() {
276 $checkupdates='automatic';
279 $admin=new Administration();
280 $admin=$admin->retrieveSettings('Update',true);
281 if (empty($admin->settings) or empty($admin->settings['Update_CheckUpdates'])) {
282 $admin->saveSetting('Update','CheckUpdates','automatic');
284 $checkupdates=$admin->settings['Update_CheckUpdates'];
286 return $checkupdates;
289 function set_last_check_version_config_setting($value) {
292 $admin=new Administration();
293 $admin->saveSetting('Update','last_check_version',$value);
295 function get_last_check_version_config_setting() {
299 $admin=new Administration();
300 $admin=$admin->retrieveSettings('Update');
301 if (empty($admin->settings) or empty($admin->settings['Update_last_check_version'])) {
304 return $admin->settings['Update_last_check_version'];
309 function set_last_check_date_config_setting($value) {
312 $admin=new Administration();
313 $admin->saveSetting('Update','last_check_date',$value);
315 function get_last_check_date_config_setting() {
319 $admin=new Administration();
320 $admin=$admin->retrieveSettings('Update');
321 if (empty($admin->settings) or empty($admin->settings['Update_last_check_date'])) {
324 return $admin->settings['Update_last_check_date'];
328 function set_sugarbeat($value) {
329 global $sugar_config;
330 $_SUGARBEAT="sugarbeet";
331 $sugar_config[$_SUGARBEAT] = $value;
332 write_array_to_file( "sugar_config", $sugar_config, "config.php" );
334 function get_sugarbeat() {
337 global $sugar_config;
338 $_SUGARBEAT="sugarbeet";
340 if (isset($sugar_config[$_SUGARBEAT]) && $sugar_config[$_SUGARBEAT] == false) {
349 function shouldCheckSugar(){
350 global $license, $timedate;
353 get_CheckUpdates_config_setting() == 'automatic' ){
362 function loadLicense($firstLogin=false){
364 $GLOBALS['license']=new Administration();
365 $GLOBALS['license']=$GLOBALS['license']->retrieveSettings('license', $firstLogin);
369 function loginLicense(){
370 global $current_user, $license;
374 if (shouldCheckSugar()) {
377 $last_check_date=get_last_check_date_config_setting();
378 $current_date_time=time();
379 $time_period=3*23*3600 ;
380 if (($current_date_time - $last_check_date) > $time_period
382 $version = check_now(get_sugarbeat());
384 unset($_SESSION['license_seats_needed']);
386 set_last_check_date_config_setting("$current_date_time");
387 include('sugar_version.php');
390 if (!empty($version) && count($version) == 1)
392 $newVersion = $version[0]['version'];
395 if (version_compare($newVersion, $sugar_version, '>') && is_admin($current_user))
397 //set session variables.
398 $_SESSION['available_version']=$version[0]['version'];
399 $_SESSION['available_version_description']=$version[0]['description'];
400 set_last_check_version_config_setting($version[0]['version']);