gentoo-src/gentoo-stats/stats.inc.php

<?php
/**
 * Gentoo stats
 * Written by Meir Kriheli <mksoft@gentoo.org>
 * Based on gentoo-stats by Maik Schreiber <blizzy@gentoo.org>
 *
 * $Id: stats.inc.php,v 1.3 2003/04/29 16:26:14 mksoft Exp $
 *
 * vim: set tabstop=4 shiftwidth=4:
 */

/********** Config section *****************/

$db_server = 'localhost';
$db_name = 'gentoo';
$db_user = 'genstats';
$db_pass = 'a45fgt34';

// numbers of days considering the user is active
$active_days = 140;
$max_accepted_cpu_mhz = 4000;
$bar_width = 250;

/********** End of config section **********/

require_once('DB.php');
require_once('Smarty.class.php');

// get the db connection
$db = & DB::connect("mysql://$db_user:$db_pass@$db_server/$db_name");

$smarty = & new Smarty;
$smarty->assign('active_days',$active_days);


function getTotalUsers() {
        global $db;

        $sql = "SELECT COUNT(*) FROM t_users WHERE (u_last_update IS NOT NULL) " .
                " AND (u_last_update >= '2002-01-01 00:00:00')";
        $totalUsers = $db->getOne($sql);

        if (!DB::isError($totalUsers)) {
                return $totalUsers;
        }
        else {
                return false;
        }
}

function getActiveUsers() {
        global $db,$active_days;

        $sql= "SELECT count(*) FROM t_users WHERE (u_last_update IS NOT NULL) " .
                "AND (TO_DAYS(NOW()) - TO_DAYS(u_last_update) <= $active_days)";

        $totalUsers = $db->getOne($sql);

        if (!DB::isError($totalUsers)) {
                return $totalUsers;
        }
        else {
                return false;
        }
}

function getLastSystemUpdate() {
        global $db,$active_days;

        $sql= "SELECT MAX(u_last_update) FROM t_users WHERE " .
                "(u_last_update IS NOT NULL)";

        $last_update = $db->getOne($sql);

        if (!DB::isError($last_update)) {
                return $last_update;
        }
        else {
                return false;
        }
}

function getTotalCPUs() {
        global $db,$active_days;

        $sql= "SELECT count(*) FROM t_users u, t_users2cpus c WHERE " .
                "(u.u_id = c.u_id) AND (u_last_update IS NOT NULL) " .
                "AND (TO_DAYS(NOW()) - TO_DAYS(u_last_update) <= $active_days)";

        $totalCPUs = $db->getOne($sql);

        if (!DB::isError($totalCPUs)) {
                return $totalCPUs;
        }
        else {
                return false;
        }
}

function getCPUStats() {
        global $db,$active_days,$max_accepted_cpu_mhz;

        $max_mhz = $max_accepted_cpu_mhz * 10000;

        $sql= "SELECT MAX(c.c_mhz), MIN(c.c_mhz), avg(c.c_mhz) FROM t_users u, t_users2cpus c WHERE " .
                "(u.u_id = c.u_id) AND (u_last_update IS NOT NULL) " .
                "AND (TO_DAYS(NOW()) - TO_DAYS(u_last_update) <= $active_days) " .
                "AND (c_mhz IS NOT NULL) AND (c_mhz < $max_mhz)";
        $CPUStats = $db->getRow($sql);

        if (!DB::isError($CPUStats)) {
                return $CPUStats;
        }
        else {
                return false;
        }
}

function getKnownProfilesCount() {
        global $db,$active_days;

        $sql= "SELECT count(*) FROM t_users WHERE (pr_id IS NOT NULL) AND (u_last_update IS NOT NULL) " .
                "AND (TO_DAYS(NOW()) - TO_DAYS(u_last_update) <= $active_days)";

        $totalUsers = $db->getOne($sql);

        if (!DB::isError($totalUsers)) {
                return $totalUsers;
        }
        else {
                return false;
        }
}

?>
1	mksoft	1.1	<?php
2			/**
3			* Gentoo stats
4	mksoft	1.2	* Written by Meir Kriheli <mksoft@gentoo.org>
5	mksoft	1.1	* Based on gentoo-stats by Maik Schreiber <blizzy@gentoo.org>
6			*
7	mksoft	1.4	* $Id: stats.inc.php,v 1.3 2003/04/29 16:26:14 mksoft Exp $
8	mksoft	1.1	*
9			* vim: set tabstop=4 shiftwidth=4:
10			*/
11
12			/******** Config section ***************/
13
14			$db_server = 'localhost';
15			$db_name = 'gentoo';
16			$db_user = 'genstats';
17			$db_pass = 'a45fgt34';
18
19			// numbers of days considering the user is active
20	mksoft	1.4	$active_days = 140;
21	mksoft	1.1	$max_accepted_cpu_mhz = 4000;
22	mksoft	1.3	$bar_width = 250;
23	mksoft	1.1
24			/******** End of config section ********/
25
26			require_once('DB.php');
27			require_once('Smarty.class.php');
28
29			// get the db connection
30			$db = & DB::connect("mysql://$db_user:$db_pass@$db_server/$db_name");
31	mksoft	1.2
32	mksoft	1.1	$smarty = & new Smarty;
33	mksoft	1.2	$smarty->assign('active_days',$active_days);
34	mksoft	1.1
35
36			function getTotalUsers() {
37			global $db;
38
39			$sql = "SELECT COUNT(*) FROM t_users WHERE (u_last_update IS NOT NULL) " .
40			" AND (u_last_update >= '2002-01-01 00:00:00')";
41			$totalUsers = $db->getOne($sql);
42
43			if (!DB::isError($totalUsers)) {
44			return $totalUsers;
45			}
46			else {
47			return false;
48			}
49			}
50
51			function getActiveUsers() {
52			global $db,$active_days;
53
54			$sql= "SELECT count(*) FROM t_users WHERE (u_last_update IS NOT NULL) " .
55			"AND (TO_DAYS(NOW()) - TO_DAYS(u_last_update) <= $active_days)";
56
57			$totalUsers = $db->getOne($sql);
58
59			if (!DB::isError($totalUsers)) {
60			return $totalUsers;
61			}
62			else {
63			return false;
64			}
65			}
66
67			function getLastSystemUpdate() {
68			global $db,$active_days;
69
70			$sql= "SELECT MAX(u_last_update) FROM t_users WHERE " .
71			"(u_last_update IS NOT NULL)";
72
73			$last_update = $db->getOne($sql);
74
75			if (!DB::isError($last_update)) {
76			return $last_update;
77			}
78			else {
79			return false;
80			}
81			}
82
83			function getTotalCPUs() {
84			global $db,$active_days;
85
86			$sql= "SELECT count(*) FROM t_users u, t_users2cpus c WHERE " .
87			"(u.u_id = c.u_id) AND (u_last_update IS NOT NULL) " .
88			"AND (TO_DAYS(NOW()) - TO_DAYS(u_last_update) <= $active_days)";
89
90			$totalCPUs = $db->getOne($sql);
91
92			if (!DB::isError($totalCPUs)) {
93			return $totalCPUs;
94			}
95			else {
96			return false;
97			}
98			}
99
100			function getCPUStats() {
101			global $db,$active_days,$max_accepted_cpu_mhz;
102
103			$max_mhz = $max_accepted_cpu_mhz * 10000;
104
105			$sql= "SELECT MAX(c.c_mhz), MIN(c.c_mhz), avg(c.c_mhz) FROM t_users u, t_users2cpus c WHERE " .
106			"(u.u_id = c.u_id) AND (u_last_update IS NOT NULL) " .
107			"AND (TO_DAYS(NOW()) - TO_DAYS(u_last_update) <= $active_days) " .
108			"AND (c_mhz IS NOT NULL) AND (c_mhz < $max_mhz)";
109			$CPUStats = $db->getRow($sql);
110
111			if (!DB::isError($CPUStats)) {
112			return $CPUStats;
113			}
114			else {
115			return false;
116			}
117			}
118	mksoft	1.3
119			function getKnownProfilesCount() {
120			global $db,$active_days;
121
122			$sql= "SELECT count(*) FROM t_users WHERE (pr_id IS NOT NULL) AND (u_last_update IS NOT NULL) " .
123			"AND (TO_DAYS(NOW()) - TO_DAYS(u_last_update) <= $active_days)";
124
125			$totalUsers = $db->getOne($sql);
126
127			if (!DB::isError($totalUsers)) {
128			return $totalUsers;
129			}
130			else {
131			return false;
132			}
133			}
134
135	mksoft	1.1	?>