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-2011 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, $authLevel, $administration, $timedate;
47 $info = getBaseSystemInfo($send_usage_info);
50 if(isset($_SERVER['SERVER_ADDR']))
51 $info['ip_address'] = $_SERVER['SERVER_ADDR'];
53 $info['ip_address'] = '127.0.0.1';
55 $info['application_key']=$sugar_config['unique_key'];
56 $info['php_version']=phpversion();
57 if(isset($_SERVER['SERVER_SOFTWARE'])) {
58 $info['server_software'] = $_SERVER['SERVER_SOFTWARE'];
63 $user_list = get_user_array(false, "Active", "", false, null, " AND is_group=0 AND portal_only=0 ", false);
67 $info['users']=count($user_list);
68 if(empty($administration)){
70 $administration = new Administration();
72 $administration->retrieveSettings('system');
73 $info['system_name'] = (!empty($administration->settings['system_name']))?substr($administration->settings['system_name'], 0 ,255):'';
76 $query="select count(*) count from users where status='Active' and deleted=0 and is_admin='1'";
77 $result=$db->query($query, 'fetching admin count', false);
78 $row = $db->fetchByAssoc($result);
80 $info['admin_users'] = $row['count'];
82 if(empty($authLevel)){
85 $query="select count(*) count from users";
86 $result=$db->query($query, 'fetching all users count', false);
87 $row = $db->fetchByAssoc($result);
90 $info['registered_users'] = $row['count'];
92 $lastMonth = db_convert("'". $timedate->getNow()->modify("-30 days")->asDb(false) . "'", 'datetime');
93 if( !$send_usage_info){
94 $info['users_active_30_days'] = -1;
97 $query = "SELECT count( DISTINCT users.id ) user_count FROM tracker, users WHERE users.id = tracker.user_id AND tracker.date_modified >= $lastMonth";
98 $result=$db->query($query, 'fetching last 30 users count', false);
99 $row = $db->fetchByAssoc($result);
100 $info['users_active_30_days'] = $row['user_count'];
107 if(!$send_usage_info){
108 $info['latest_tracker_id'] = -1;
110 $query="select id from tracker order by date_modified desc";
111 $id=$db->getOne($query,'fetching most recent tracker entry',false);
113 $info['latest_tracker_id'] = $id;
116 $dbManager = &DBManagerFactory::getInstance();
117 $info['db_type']=$sugar_config['dbconfig']['db_type'];
118 $info['db_version']=$dbManager->version();
120 if(file_exists('distro.php')){
121 include('distro.php');
122 if(!empty($distro_name))$info['distro_name'] = $distro_name;
124 $info['auth_level'] = $authLevel;
125 $info['os'] = php_uname('s');
126 $info['os_version'] = php_uname('r');
127 $info['timezone_u'] = $GLOBALS['current_user']->getPreference('timezone');
128 $info['timezone'] = date('e');
129 if($info['timezone'] == 'e'){
130 $info['timezone'] = date('T');
136 function getBaseSystemInfo($send_usage_info=true){
138 include('sugar_version.php');
141 if($send_usage_info){
142 $info['sugar_db_version']=$sugar_db_version;
144 $info['sugar_version']=$sugar_version;
145 $info['sugar_flavor']=$sugar_flavor;
146 $info['auth_level'] = $authLevel;
155 function check_now($send_usage_info=true, $get_request_data=false, $response_data = false, $from_install=false ) {
156 global $sugar_config, $timedate;
157 global $db, $license;
160 $return_array=array();
161 if(!$from_install && empty($license))loadLicense(true);
166 $info = getBaseSystemInfo(false);
169 $info = getSystemInfo($send_usage_info);
172 require_once('include/nusoap/nusoap.php');
174 $GLOBALS['log']->debug('USING HTTPS TO CONNECT TO HEARTBEAT');
175 $sclient = new nusoapclient('https://updates.sugarcrm.com/heartbeat/soap.php', false, false, false, false, false, 15, 15);
176 $ping = $sclient->call('sugarPing', array());
177 if(empty($ping) || $sclient->getError()){
182 $GLOBALS['log']->debug('USING HTTP TO CONNECT TO HEARTBEAT');
183 $sclient = new nusoapclient('http://updates.sugarcrm.com/heartbeat/soap.php', false, false, false, false, false, 15, 15);
191 $key = '4829482749329';
195 $encoded = sugarEncode($key, serialize($info));
197 if($get_request_data){
198 $request_data = array('key'=>$key, 'data'=>$encoded);
199 return serialize($request_data);
201 $encodedResult = $sclient->call('sugarHome', array('key'=>$key, 'data'=>$encoded));
204 $encodedResult = $response_data['data'];
205 $key = $response_data['key'];
209 if($response_data || !$sclient->getError()){
210 $serializedResultData = sugarDecode($key,$encodedResult);
211 $resultData = unserialize($serializedResultData);
212 if($response_data && empty($resultData))
214 $resultData = array();
215 $resultData['validation'] = 'invalid validation key';
219 $resultData = array();
220 $resultData['versions'] = array();
224 if($response_data || !$sclient->getError() )
226 if(!empty($resultData['msg'])){
227 if(!empty($resultData['msg']['admin'])){
228 $license->saveSetting('license', 'msg_admin', base64_encode($resultData['msg']['admin']));
230 $license->saveSetting('license', 'msg_admin','');
232 if(!empty($resultData['msg']['all'])){
233 $license->saveSetting('license', 'msg_all', base64_encode($resultData['msg']['all']));
235 $license->saveSetting('license', 'msg_all','');
238 $license->saveSetting('license', 'msg_admin','');
239 $license->saveSetting('license', 'msg_all','');
241 $license->saveSetting('license', 'last_validation', 'success');
242 unset($_SESSION['COULD_NOT_CONNECT']);
246 $resultData = array();
247 $resultData['versions'] = array();
249 $license->saveSetting('license', 'last_connection_fail', TimeDate::getInstance()->nowDb());
250 $license->saveSetting('license', 'last_validation', 'no_connection');
252 if( empty($license->settings['license_last_validation_success']) && empty($license->settings['license_last_validation_fail']) && empty($license->settings['license_vk_end_date'])){
253 $license->saveSetting('license', 'vk_end_date', TimeDate::getInstance()->nowDb());
255 $license->saveSetting('license', 'validation_key', base64_encode(serialize(array('verified'=>false))));
257 $_SESSION['COULD_NOT_CONNECT'] =TimeDate::getInstance()->nowDb();
260 if(!empty($resultData['versions'])){
262 $license->saveSetting('license', 'latest_versions',base64_encode(serialize($resultData['versions'])));
264 $resultData['versions'] = array();
265 $license->saveSetting('license', 'latest_versions','') ;
271 include('sugar_version.php');
273 if(sizeof($resultData) == 1 && !empty($resultData['versions'][0]['version']) && $resultData['versions'][0]['version'] < $sugar_version)
275 $resultData['versions'][0]['version'] = $sugar_version;
276 $resultData['versions'][0]['description'] = "You have the latest version.";
280 return $resultData['versions'];
282 function set_CheckUpdates_config_setting($value) {
285 $admin=new Administration();
286 $admin->saveSetting('Update','CheckUpdates',$value);
288 /* return's value for the 'CheckUpdates' config setting
289 * if the setting does not exist one gets created with a default value of automatic.
291 function get_CheckUpdates_config_setting() {
293 $checkupdates='automatic';
296 $admin=new Administration();
297 $admin=$admin->retrieveSettings('Update',true);
298 if (empty($admin->settings) or empty($admin->settings['Update_CheckUpdates'])) {
299 $admin->saveSetting('Update','CheckUpdates','automatic');
301 $checkupdates=$admin->settings['Update_CheckUpdates'];
303 return $checkupdates;
306 function set_last_check_version_config_setting($value) {
309 $admin=new Administration();
310 $admin->saveSetting('Update','last_check_version',$value);
312 function get_last_check_version_config_setting() {
316 $admin=new Administration();
317 $admin=$admin->retrieveSettings('Update');
318 if (empty($admin->settings) or empty($admin->settings['Update_last_check_version'])) {
321 return $admin->settings['Update_last_check_version'];
326 function set_last_check_date_config_setting($value) {
329 $admin=new Administration();
330 $admin->saveSetting('Update','last_check_date',$value);
332 function get_last_check_date_config_setting() {
336 $admin=new Administration();
337 $admin=$admin->retrieveSettings('Update');
338 if (empty($admin->settings) or empty($admin->settings['Update_last_check_date'])) {
341 return $admin->settings['Update_last_check_date'];
345 function set_sugarbeat($value) {
346 global $sugar_config;
347 $_SUGARBEAT="sugarbeet";
348 $sugar_config[$_SUGARBEAT] = $value;
349 write_array_to_file( "sugar_config", $sugar_config, "config.php" );
351 function get_sugarbeat() {
354 global $sugar_config;
355 $_SUGARBEAT="sugarbeet";
357 if (isset($sugar_config[$_SUGARBEAT]) && $sugar_config[$_SUGARBEAT] == false) {
366 function shouldCheckSugar(){
367 global $license, $timedate;
370 get_CheckUpdates_config_setting() == 'automatic' ){
379 function loadLicense($firstLogin=false){
381 $GLOBALS['license']=new Administration();
382 $GLOBALS['license']=$GLOBALS['license']->retrieveSettings('license', $firstLogin);
386 function loginLicense(){
387 global $current_user, $license, $authLevel;
392 if (shouldCheckSugar()) {
395 $last_check_date=get_last_check_date_config_setting();
396 $current_date_time=time();
397 $time_period=3*23*3600 ;
398 if (($current_date_time - $last_check_date) > $time_period
400 $version = check_now(get_sugarbeat());
402 unset($_SESSION['license_seats_needed']);
404 set_last_check_date_config_setting("$current_date_time");
405 include('sugar_version.php');
407 if(!empty($version)&& count($version) == 1 && $version[0]['version'] > $sugar_version && is_admin($current_user))
409 //set session variables.
410 $_SESSION['available_version']=$version[0]['version'];
411 $_SESSION['available_version_description']=$version[0]['description'];
412 set_last_check_version_config_setting($version[0]['version']);