#!/usr/bin/php -q
<?php

$login_data = parse_ini_file("/etc/origo/origo.conf");

$host     = 'localhost';
$db       = 'origo';

mysql_connect($host, $login_data['snmp_user'], $login_data['snmp_password']) or die ("0");
mysql_select_db($db) or die("0");
$res_stat = mysql_query("SELECT COUNT(*) FROM user") or die("0");
$registered = mysql_result($res_stat, 0, 0);
$res_stat = mysql_query("SELECT COUNT(*) FROM `user` WHERE disabled = true") or die ("0");
$dis_users = mysql_result($res_stat, 0, 0);
$res_stat = mysql_query("SELECT COUNT(DISTINCT user_id) FROM session") or die("0");
$online = mysql_result($res_stat, 0, 0);
$res_stat = mysql_query("SELECT COUNT(*) FROM project") or die("0");
$projects = mysql_result($res_stat, 0, 0);
$res_stat = mysql_query("SELECT COUNT(*) FROM project WHERE closed_source = true");
$closed_source_projects = mysql_result($res_stat, 0,0);

$res_stat = mysql_query("SELECT COUNT(*) FROM `workitem` GROUP BY type_id ORDER BY type_id ASC");
$wi_issue = mysql_result($res_stat, 0, 0);
$wi_release = mysql_result($res_stat, 1, 0);
$wi_commit = mysql_result($res_stat, 2, 0);
$wi_wiki = mysql_result($res_stat, 3, 0);
$wi_blog = mysql_result($res_stat, 4, 0);
$wi_comment = mysql_result($res_stat, 5, 0);
$workitems = $wi_issue + $wi_release + $wi_commit + $wi_wiki + $wi_blog + $wi_comment;

$res_stat = mysql_query("SELECT COUNT(*) FROM `project` WHERE hidden = true");
$hidden_projects = mysql_result($res_stat, 0, 0);

$res_stat = mysql_query("SELECT COUNT(*) FROM user_information WHERE last_login > UNIX_TIMESTAMP()-86400*7");
$user_7_percentile = mysql_result($res_stat, 0, 0);
$res_stat = mysql_query("SELECT COUNT(*) FROM user_information WHERE last_login > UNIX_TIMESTAMP()-86400");
$user_1_percentile = mysql_result($res_stat, 0, 0);
$res_stat = mysql_query("SELECT COUNT(*) FROM user_information WHERE last_login > UNIX_TIMESTAMP()-86400*30");
$user_30_percentile = mysql_result($res_stat, 0, 0);


mysql_close();

$nl = "\n";

echo $registered . $nl;
echo $online . $nl;
echo $projects . $nl;
echo $workitems . $nl;
echo $closed_source_projects . $nl;
echo $wi_issue . $nl;
echo $wi_release . $nl;
echo $wi_commit . $nl;
echo $wi_wiki . $nl;
echo $wi_blog . $nl;
echo $wi_comment . $nl;
echo $hidden_projects . $nl;
echo $dis_users . $nl;
echo $user_1_percentile . $nl;
echo $user_7_percentile . $nl;
echo $user_30_percentile . $nl;
?>