stats-ajax.php 2.35 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
<?php
#
# Copyright (c) 2000-2015 University of Utah and the Flux Group.
# 
# {{{EMULAB-LICENSE
# 
# This file is part of the Emulab network testbed software.
# 
# This file is free software: you can redistribute it and/or modify it
# under the terms of the GNU Affero General Public License as published by
# the Free Software Foundation, either version 3 of the License, or (at
# your option) any later version.
# 
# This file is distributed in the hope that it will be useful, but WITHOUT
# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
# FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public
# License for more details.
# 
# You should have received a copy of the GNU Affero General Public License
# along with this file.  If not, see <http://www.gnu.org/licenses/>.
# 
# }}}
#
chdir("..");
include("defs.php3");
chdir("apt");
include("quickvm_sup.php");

29 30 31 32 33
# 
# Allow this to be fetched from pages loaded anywhere
#
header("Access-Control-Allow-Origin: *");

34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
#
# For the Cloudlab front page, to display some current stats.
#
$blob = array();

#
# Number of active experiments.
#
$query_result =
    DBQueryFatal("select count(uuid) from apt_instances");
if ($query_result) {
    $row = mysql_fetch_array($query_result);
    $blob["active_experiments"] = $row[0];
}

49 50 51 52 53 54 55 56 57 58
#
# Number of experiments ever
#
$query_result =
    DBQueryFatal("select count(uuid) from apt_instance_history where servername='www.cloudlab.us'");
if ($query_result) {
    $row = mysql_fetch_array($query_result);
    $blob["total_experiments"] = $row[0];
}

59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
#
# Number Cloudlab projects.
#
$query_result =
    DBQueryFatal("select count(pid) from projects ".
                 "where approved=1 and genesis='cloudlab'");
if ($query_result) {
    $row = mysql_fetch_array($query_result);
    $blob["projects"] = $row[0];
}

#
# Number of users who have ever created an experiment.
#
$query_result =
    DBQueryFatal("(select distinct creator from apt_instance_history) ".
                 "union ".
                 "(select distinct creator from apt_instances)");
if ($query_result) {
    $blob["distinct_users"] = mysql_num_rows($query_result);
}

81 82 83 84 85 86 87 88 89 90
#
# Number of profiles (both public and private)
#
$query_result =
    DBQueryFatal("select count(uuid) from apt_profiles");
if ($query_result) {
    $row = mysql_fetch_array($query_result);
    $blob["profiles"] = $row[0];
}

91
echo json_encode($blob);