restrictAccess(Auth::isManager()) ->addInlineJavascript('jQuery("#x").accordion({heightStyle: "content"});') ->addInlineJavascript('jQuery("#tree_stats").accordion();') ->addInlineJavascript('jQuery("#changes").accordion();') ->addInlineJavascript('jQuery("#content_container").css("visibility", "visible");') ->setPageTitle(WT_I18N::translate('Administration')) ->pageHeader(); // Check for updates $latest_version_txt=fetch_latest_version(); if (preg_match('/^[0-9.]+\|[0-9.]+\|/', $latest_version_txt)) { list($latest_version, $earliest_version, $download_url)=explode('|', $latest_version_txt); } else { // Cannot determine the latest version $latest_version=''; } // Delete old files (if we can). $old_files = array(); foreach (old_paths() as $path) { if (file_exists($path)) { if (!WT_File::delete($path)) { // We may be unable to delete it. If so, tell the user to delete it manually. $old_files[] = $path; } } } // Total number of users $total_users = User::count(); // Total number of administrators $total_administrators = WT_DB::prepare( "SELECT COUNT(*) FROM `##user_setting` WHERE setting_name='canadmin' AND setting_value=1" )->fetchOne(); // Total numbers of managers $total_managers = WT_DB::prepare( "SELECT gs.setting_value, COUNT(*)" . " FROM `##gedcom_setting` gs" . " JOIN `##user_gedcom_setting` ugs USING (gedcom_id)" . " WHERE ugs.setting_name = 'canedit' AND ugs.setting_value='admin'" . " AND gs.setting_name ='title'" . " GROUP BY gedcom_id" . " ORDER BY gs.setting_value" )->fetchAssoc(); // Number of users who have not verified their email address $unverified = WT_DB::prepare( "SELECT COUNT(*) FROM `##user_setting` WHERE setting_name='verified' AND setting_value=0" )->fetchOne(); // Number of users whose accounts are not approved by an administrator $unapproved = WT_DB::prepare( "SELECT COUNT(*) FROM `##user_setting` WHERE setting_name='verified_by_admin' AND setting_value=0" )->fetchOne(); // Number of users of each language $user_languages = WT_DB::prepare( "SELECT setting_value, COUNT(*)" . " FROM `##user_setting`" . " WHERE setting_name = 'language'" . " GROUP BY setting_value" )->fetchAssoc(); $stats = new WT_Stats(WT_GEDCOM); ?>