2 require('../conf/config.php3');
3 require('../lib/functions.php3');
4 require('../lib/defaults.php3');
5 if (is_file("../lib/$config[general_lib_type]/user_info.php3"))
6 include("../lib/$config[general_lib_type]/user_info.php3");
8 if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php3"))
9 include_once("../lib/sql/drivers/$config[sql_type]/functions.php3");
13 $vars = array( 'Dialup-Access' => 'TRUE','Dialup-Lock-Msg' => '-',
14 'Max-Weekly-Session' => 0,'Max-Daily-Session' => 0);
15 foreach($vars as $key => $val){
16 $val = ($item_vals["$key"][0] != "") ? $item_vals["$key"][0] : $default_vals["$key"][0];
19 $vars['Dialup-Access'] = ($vars['Dialup-Access'] == 'FALSE') ? 'inactive' : 'active';
20 $vars['Max-Daily-Session'] = time2strclock($vars['Max-Daily-Session']);
21 $vars['Max-Weekly-Session'] = time2strclock($vars['Max-Weekly-Session']);
24 $week = $now - date('w') * 86400;
25 $now_str = date("$config[sql_date_format]",$now + 86400);
26 $week_str = date("$config[sql_date_format]",$week);
27 $today = date("$config[sql_date_format]",$now);
29 $link = @da_sql_pconnect($config);
31 $search = @da_sql_query($link,$config,
32 "SELECT COUNT(*) AS counter, sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE
33 username = '$login' AND acctstoptime >= '$week_str' AND
34 acctstoptime <= '$now_str';");
36 $row = @da_sql_fetch_array($search,$config);
37 $weekly_used = time2strclock($row[sum_sess_time]);
38 $weekly_conns = $row[counter];
40 $search = @da_sql_query($link,$config,
41 "SELECT COUNT(*) AS counter,sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE
42 username = '$login' AND acctstoptime >= '$today 00:00:00'
43 AND acctstoptime <= '$today 23:59:59';");
45 $row = @da_sql_fetch_array($search,$config);
46 $daily_used = time2strclock($row[sum_sess_time]);
47 $daily_conns = $row[counter];
52 foreach($vars as $val){
55 echo "$weekly_used\n$weekly_conns\n$daily_used\n$daily_conns";