user_state.php   [plain text]

<?php
require('../conf/config.php');
require('../lib/functions.php');
require('../lib/defaults.php');
if (is_file("../lib/$config[general_lib_type]/user_info.php"))
	include("../lib/$config[general_lib_type]/user_info.php");

if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))
	include_once("../lib/sql/drivers/$config[sql_type]/functions.php");
else
	exit();

$vars = array( 'Dialup-Access' => 'TRUE','Dialup-Lock-Msg' => '-',
		'Max-Weekly-Session' => 0,'Max-Daily-Session' => 0);
foreach($vars as $key => $val){
	$val = ($item_vals["$key"][0] != "") ? $item_vals["$key"][0] : $default_vals["$key"][0];
	$vars["$key"]=$val;
}
$vars['Dialup-Access'] = ($vars['Dialup-Access'] == 'FALSE') ? 'inactive' : 'active';
$vars['Max-Daily-Session'] = time2strclock($vars['Max-Daily-Session']);
$vars['Max-Weekly-Session'] = time2strclock($vars['Max-Weekly-Session']);

$now = time();
$week = $now - date('w') * 86400;
$now_str = date("$config[sql_date_format]",$now + 86400);
$week_str = date("$config[sql_date_format]",$week);
$today = date("$config[sql_date_format]",$now);
$open_conns = $daily_conns = $weekly_conns = 0;
$weekly_used = $daily_used = $online_time = time2strclock(0);

$link = @da_sql_pconnect($config);
if ($link){
	$search = @da_sql_query($link,$config,
	"SELECT COUNT(*) AS counter, sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE
	username = '$login' AND acctstoptime >= '$week_str' AND
	acctstoptime <= '$now_str';");
	if ($search){
		if ($row = @da_sql_fetch_array($search,$config)){
			$weekly_used = time2strclock($row[sum_sess_time]);
			$weekly_conns = $row[counter];
		}
	}
	$search = @da_sql_query($link,$config,
	"SELECT COUNT(*) AS counter,sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE
	username = '$login' AND acctstoptime >= '$today 00:00:00'
	AND acctstoptime <= '$today 23:59:59';");
	if ($search){
		if ($row = @da_sql_fetch_array($search,$config)){
			$daily_used = time2strclock($row[sum_sess_time]);
			$daily_conns = $row[counter];
		}
	}
	$search = @da_sql_query($link,$config,
	"SELECT COUNT(*) AS counter, unix_timestamp() - unix_timestamp(acctstarttime) as diff FROM
	$config[sql_accounting_table] WHERE acctstoptime is null AND username = '$login'
	GROUP BY username;");
	if ($search){
		if ($row = @da_sql_fetch_array($search,$config)){
			$open_conns = $row[counter];
			$online_time = $row[diff];
			$weekly_used += $online_time;
			$daily_used += $online_time;
			$daily_conns += $open_conns;
			$weekly_conns += $open_conns;
			$online_time = time2strclock($online_time);
		}
	}
	$weekly_used = time2strclock($weekly_used);
	$daily_used = time2strclock($daily_used);
}


foreach($vars as $val){
	echo "$val\n";
}
echo "$weekly_used\n$weekly_conns\n$daily_used\n$daily_conns\n$open_conns\n$online_time";
?>