function getBoxContent()
 {
     $html = array();
     if (!checkPerm('view_org_chart', true, 'directory', 'framework')) {
         return $html;
     }
     require_once _base_ . '/lib/lib.userselector.php';
     $user_dir = new UserSelector();
     $user_stats = $user_dir->getUsersStats();
     $lang =& DoceboLanguage::createInstance('dashboard', 'framework');
     if (Get::sett('welcome_use_feed') == 'on') {
         require_once _base_ . '/lib/lib.fsock_wrapper.php';
         $fp = new Fsock();
         $released_version = $fp->send_request('http://www.formalms.org/versions/release.txt');
         if (!$fp) {
             $released_version = '<strong class="old_release">' . $lang->def('_UNKNOWN_RELEASE') . '</strong>';
         } else {
             if ($released_version == false) {
                 $released_version = '<strong class="ok_release">' . $lang->def('_UNKNOWN_RELEASE') . '</strong>';
             }
             if ($released_version == Get::sett('core_version')) {
                 $released_version = '<strong class="ok_release">' . $released_version . '</strong>';
             } else {
                 $released_version = '<strong class="old_release">' . $released_version . ' (' . $lang->def('_NEW_RELEASE_AVAILABLE') . ')</strong>';
             }
         }
     }
     $html[] = '<h2 class="inline">' . $lang->def('_USERS_PANEL') . '</h2>' . '<p>' . $lang->def('_TOTAL_USER') . ': <b>' . ($user_stats['all'] - 1) . '</b>;<br />' . $lang->def('_SUSPENDED') . ': <b>' . $user_stats['suspended'] . '</b>;<br />' . (checkPerm('approve_waiting_user', true, 'directory', 'framework') ? $lang->def('_WAITING_USERS') . ': <b>' . $user_stats['waiting'] . '</b>;' : '') . '</p><p>' . $lang->def('_SUPERADMIN_USER') . ': <b>' . $user_stats['superadmin'] . '</b>;<br />' . $lang->def('_ADMIN_USER') . ': <b>' . $user_stats['admin'] . '</b>;<br />' . $lang->def('_PUBLIC_ADMIN_USER') . ': <b>' . $user_stats['public_admin'] . '</b>;' . '</p><p>' . $lang->def('_REG_TODAY') . ': <b>' . $user_stats['register_today'] . '</b>;<br />' . $lang->def('_REG_YESTERDAY') . ': <b>' . $user_stats['register_yesterday'] . '</b>;<br />' . $lang->def('_REG_LASTSEVENDAYS') . ': <b>' . $user_stats['register_7d'] . '</b>;' . '</p><p>' . $lang->def('_INACTIVE_USER') . ': <b>' . $user_stats['inactive_30d'] . '</b>;<br />' . $lang->def('_ONLINE_USER') . ': <b>' . $user_stats['now_online'] . '</b>;' . '</p><p>' . $lang->def('_CORE_VERSION') . ': <b>' . Get::sett('core_version') . '</b>;<br />' . (Get::sett('welcome_use_feed') == 'on' ? $lang->def('_LAST_RELEASED') . ': ' . $released_version . ';' : '') . '</p>';
     return $html;
 }
 public function getVersionExternalInfo()
 {
     $version = array('db_version' => Get::sett('core_version'), 'file_version' => _file_version_, 'string' => '');
     // check for differences beetween files and database version
     if (version_compare($version['file_version'], $version['db_version']) == 1) {
         switch ($version['db_version']) {
             // handling old docebo ce version
             case "3.6.0.3":
             case "3.6.0.4":
             case "4.0.0":
             case "4.0.5":
                 break;
             case "4.0.1":
             case "4.0.2":
             case "4.0.3":
             case "4.0.4":
                 $version['db_version'] = $this->updateVersion($version['db_version'], "4.0.5");
                 break;
                 // new formalms versions
             // new formalms versions
             case "1.0":
             case "1.1":
             case "1.2":
                 break;
         }
     }
     // check for differences beetween files and database version
     if (version_compare($version['file_version'], $version['db_version']) != 0) {
         $version['string'] .= '<br/>' . 'Different from core file version:' . '<span class="red"><b>' . $version['file_version'] . '</b></span>' . '<br/>' . '<a href="../upgrade" class="red"><b>' . 'You need database upgrade' . '</b></a>';
     }
     if (Get::sett('welcome_use_feed') == 'on') {
         require_once _base_ . '/lib/lib.fsock_wrapper.php';
         $fp = new Fsock();
         $_online_version = $fp->send_request('http://www.formalms.org/versions/release.txt');
         if (!$fp || !$_online_version) {
             $version = array('string' => '<b class="red">' . Lang::t('_UNKNOWN_RELEASE', 'dashboard') . '</b>');
         } elseif (version_compare($_online_version, $version['file_version']) == 1) {
             $version['string'] .= '<br/>' . '<a href="http://www.formalms.org/downloads/?versions" class="red">' . Lang::t('_NEW_RELEASE_AVAILABLE', 'dashboard') . ': <b>' . $_online_version . '</b></a>';
         }
     }
     return $version;
 }