| /web/acc/manager/htdocs/accounting.php |
|---|
| 28,15 → 28,15 |
| if ($config['sql_type'] == 'pg'){ |
| $operators=array( '=','<', '>', '<=', '>=', '~', 'like', '~*', '~~*', '<<=' ); |
| } |
| $link = da_sql_pconnect ($config) or die('cannot connect to sql databse'); |
| $fields = da_sql_list_fields($config[sql_accounting_table],$link,$config); |
| $no_fields = da_sql_num_fields($fields,$config); |
| $fields = da_sql_list_fields($config['sql_accounting_table'],$link,$config); |
| unset($items); |
| for($i=0;$i<$no_fields;$i++){ |
| $key = strtolower(da_sql_field_name($fields,$i,$config)); |
| while($row = $fields->fetch_array()) |
| { |
| $key = strtolower($row[0]); |
| $val = $sql_attrs[$key]['desc']; |
| if ($val == '') |
| continue; |
| 120,6 → 120,10 |
| <TABLE width="100%" border="1" cellspacing="0" cellpadding="1"> |
| <tr><td> |
| <?php |
| if(!isset($queryflag)) |
| { |
| $queryflag = 0; |
| } |
| if(!$queryflag) { |
| echo <<<EOM |
| <form method=post> |
| 178,7 → 182,7 |
| $number=1; |
| $offset=0; |
| while (${"item_of_w$number"}) { |
| while (isset(${"item_of_w$number"}) && ${"item_of_w$number"}) { |
| if(${"delete_w$number"}==1) {$offset=1;$number++;} |
| else { |
| $designator=$number-$offset; |
| 188,7 → 192,7 |
| $number++; |
| } |
| } |
| if($add==1) { |
| if(isset($add) && $add==1) { |
| ${"w$number"} = new Qi("w$number","$item_name","$operators[0]"); |
| ${"w$number"}->show(); |
| } |
| 211,8 → 215,10 |
| } |
| if ($queryflag == 1){ |
| if(!isset($where)) |
| $where = ""; |
| $i = 1; |
| while (${"item_of_w$i"}){ |
| while (isset(${"item_of_w$i"}) && ${"item_of_w$i"}){ |
| $op_found = 0; |
| foreach ($operators as $operator){ |
| if (${"operator_of_w$i"} == $operator){ |
| 223,7 → 229,7 |
| if (!$op_found) |
| die("L'opération demandé n'est pas valide. Sortie anormale."); |
| ${"item_of_w$i"} = preg_replace('/\s/','',${"item_of_w$i"}); |
| ${"value_of_w$i"} = da_sql_escape_string(${"value_of_w$i"}); |
| ${"value_of_w$i"} = da_sql_escape_string($link,${"value_of_w$i"}); |
| $where .= ($i == 1) ? ' WHERE ' . ${"item_of_w$i"} . ' ' . ${"operator_of_w$i"} . " '" . ${"value_of_w$i"} . "'" : |
| ' AND ' . ${"item_of_w$i"} . ' ' . ${"operator_of_w$i"} . " '" . ${"value_of_w$i"} . "'" ; |
| $i++; |
| 237,14 → 243,25 |
| if (!is_numeric($maxresults)) |
| die("Max Results is not in numeric form. Exiting abnormally."); |
| unset($query_view); |
| $query_view = ''; |
| foreach ($accounting_show_attrs as $val) |
| $query_view .= $val . ','; |
| $query_view = ereg_replace(',$','',$query_view); |
| unset($sql_extra_query); |
| if ($config[sql_accounting_extra_query] != '') |
| $sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config); |
| $sql_extra_query = da_sql_escape_string($sql_extra_query); |
| if (isset($config['sql_accounting_extra_query'])){ |
| $sql_extra_query = xlat($config['sql_accounting_extra_query'],$login,$config); |
| $sql_extra_query = da_sql_escape_string($link,$sql_extra_query); |
| } |
| else |
| { |
| $sql_extra_query = ""; |
| } |
| if(!isset($where)) |
| { |
| $where = ""; |
| } |
| $query="SELECT " . da_sql_limit($maxresults,0,$config) . " $query_view FROM $config[sql_accounting_table] |
| $where $sql_extra_query " . da_sql_limit($maxresults,1,$config) . |
| " ORDER BY $order DESC " . da_sql_limit($maxresults,2,$config) . ";"; |
| 257,8 → 274,14 |
| <tr bgcolor="#d0ddb0"> |
| </tr> |
| EOM; |
| foreach($accounting_show_attrs as $val){ |
| $desc = $sql_attrs[$val][desc]; |
| $desc = $sql_attrs[$val]['desc']; |
| if($val == 'acctoutputoctets') |
| $desc = "Upload"; |
| if($val == 'acctinputoctets') |
| $desc = "Download"; |
| echo "<th>$desc</th>\n"; |
| } |
| echo "</tr>\n"; |
| 266,13 → 289,16 |
| $search = da_sql_query($link,$config,$query); |
| if ($search){ |
| while( $row = da_sql_fetch_array($search,$config) ){ |
| $num++; |
| //$num++; |
| echo "<tr align=center>\n"; |
| foreach($accounting_show_attrs as $val){ |
| $info = $row[$val]; |
| if($val == "acctoutputoctets" || $val == "acctinputoctets") |
| $info = bytes2str($info); |
| if($val == "acctsessiontime") |
| $info = time2strclock($info); |
| if ($info == '') |
| $info = '-'; |
| $info = $sql_attrs[$val][func]($info); |
| if ($val == 'username'){ |
| $Info = urlencode($info); |
| $info = "<a href=\"user_admin.php?login=$Info\" title=\"Edit user $info\">$info<a/>"; |
| /web/acc/manager/htdocs/badusers.php |
|---|
| 26,8 → 26,8 |
| $now_str = ($now_str != '') ? "$now_str" : date($config[sql_date_format],$now + 86400); |
| $prev_str = ($prev_str != '') ? "$prev_str" : "0001-01-01 00:00:00"; |
| $now_str = da_sql_escape_string($now_str); |
| $prev_str = da_sql_escape_string($prev_str); |
| $now_str = da_sql_escape_string($link,$now_str); |
| $prev_str = da_sql_escape_string($link,$prev_str); |
| $num = 0; |
| $pagesize = ($pagesize) ? $pagesize : 10; |
| 139,7 → 139,7 |
| <?php |
| $auth_user = $_SERVER["PHP_AUTH_USER"]; |
| if ($config[general_restrict_badusers_access] == 'yes'){ |
| $auth_user = da_sql_escape_string($auth_user); |
| $auth_user = da_sql_escape_string($link,$auth_user); |
| $extra_query = "AND admin == '$auth_user'"; |
| } |
| $link = da_sql_pconnect($config); |
| /web/acc/manager/htdocs/failed_logins.php |
|---|
| 33,8 → 33,8 |
| $now_str = date($config[sql_full_date_format],$now); |
| $prev_str = date($config[sql_full_date_format],$start); |
| $now_str = da_sql_escape_string($now_str); |
| $prev_str = da_sql_escape_string($prev_str); |
| $now_str = da_sql_escape_string($link,$now_str); |
| $prev_str = da_sql_escape_string($link,$prev_str); |
| $pagesize = ($pagesize) ? $pagesize : 10; |
| if (!is_numeric($pagesize) && $pagesize != 'all') |
| 46,11 → 46,11 |
| $order = 'desc'; |
| $selected[$order] = 'selected'; |
| if ($callerid != ''){ |
| $callerid = da_sql_escape_string($callerid); |
| $callerid = da_sql_escape_string($link,$callerid); |
| $callerid_str = "AND callingstationid = '$callerid'"; |
| } |
| if ($server != '' && $server != 'all'){ |
| $server = da_sql_escape_string($server); |
| $server = da_sql_escape_string($link,$server); |
| $server_str = "AND nasipaddress = '$server'"; |
| } |
| 106,7 → 106,7 |
| unset($sql_extra_query); |
| if ($config[sql_accounting_extra_query] != ''){ |
| $sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config); |
| $sql_extra_query = da_sql_escape_string($sql_extra_query); |
| $sql_extra_query = da_sql_escape_string($link,$sql_extra_query); |
| } |
| ?> |
| </tr> |
| /web/acc/manager/htdocs/find.php |
|---|
| 95,7 → 95,7 |
| <a href="clear_opensessions.php?login=$User" title="$l_open_sessions"><img src=/images/state_ok.gif></a> |
| <a href="user_delete.php?login=$User" title="$l_remove"><img src=/images/state_error.gif></a></td><td> |
| EOM; |
| if (isset($member_groups)) foreach ($member_groups as $group) { $msg .= "$group";} |
| if (isset($member_groups)) foreach ($member_groups as $group) { $msg .= "$group ";} |
| else $msg .= " "; |
| $msg .= "</td>"; |
| } |
| /web/acc/manager/htdocs/import_user.php |
|---|
| 162,8 → 162,8 |
| { |
| $password = GenPassword(); |
| } |
| $login = da_sql_escape_string($login); |
| $passwd = da_sql_escape_string($passwd); |
| $login = da_sql_escape_string($link,$login); |
| $passwd = da_sql_escape_string($link,$passwd); |
| $passwd = da_encrypt($password); |
| // insertion (login + password) dans la table "radcheck" (si l'usager existe --> changement de mot de passe) |
| $res = @da_sql_query($link,$config,"INSERT INTO $config[sql_check_table] (attribute,value,username $text) VALUES ('$config[sql_password_attribute]','$passwd','$login' $passwd_op);"); |
| 199,7 → 199,7 |
| echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n"; |
| if ($group != '') |
| { |
| $group = da_sql_escape_string($group); |
| $group = da_sql_escape_string($link,$group); |
| $res = @da_sql_query($link,$config,"SELECT username FROM $config[sql_usergroup_table] WHERE username = '$login' AND groupname = '$group';"); |
| if ($res) |
| { |
| /web/acc/manager/htdocs/stats.php |
|---|
| 30,30 → 30,37 |
| $date = strftime('%A, %e %B %Y, %T %Z'); |
| $now = time(); |
| if ($before == '') |
| $before = date($config[sql_date_format], $now + 86400); |
| $after = ($after != '') ? "$after" : date($config[sql_date_format], $now - 604800 ); |
| $after_time = date2time($after); |
| $before_time = date2time($before); |
| if (!isset($before)) |
| { |
| $before = date($config['sql_date_format'], $now + 86400); |
| } |
| if (!isset($after)) |
| { |
| $after = date($config['sql_date_format'], $now - 604800 ); |
| } |
| $after_time = strtotime($after); |
| $before_time = strtotime($before); |
| $days[0] = $after; |
| $counter = $after_time + 86400; |
| $i = 1; |
| while($counter < $before_time){ |
| $days[$i++] = date($config[sql_date_format],$counter); |
| $days[$i++] = date($config['sql_date_format'],$counter); |
| $counter += 86400; |
| } |
| $days[$i] = $before; |
| $num_days = $i; |
| $column1 = ($column1 != '') ? "$column1" : 'sessions'; |
| $column2 = ($column2 != '') ? "$column2" : 'usage'; |
| $column3 = ($column3 != '') ? "$column3" : 'download'; |
| $column1 = (isset($column1)) ? "$column1" : 'sessions'; |
| $column[1] = "$column1"; |
| $selected1["$column1"] = 'selected'; |
| $column2 = (isset($column2)) ? "$column2" : 'usage'; |
| $column[2] = "$column2"; |
| $selected2["$column2"] = 'selected'; |
| $column3 = (isset($column3)) ? "$column3" : 'download'; |
| $column[3] = "$column3"; |
| $selected1["$column1"] = 'selected'; |
| $selected2["$column2"] = 'selected'; |
| $selected3["$column3"] = 'selected'; |
| $message['sessions'] = 'sessions'; |
| 61,7 → 68,7 |
| $message['usage'] = 'temps d\'utilisation total '; |
| $message['upload'] = 'uploads'; |
| $message['download'] = 'downloads'; |
| if ($config[general_stats_use_totacct] == 'yes'){ |
| if ($config['general_stats_use_totacct'] == 'yes'){ |
| $sql_val['sessions'] = 'connnum'; |
| $sql_val['usage'] = 'conntotduration'; |
| $sql_val['upload'] = 'inputoctets'; |
| 72,38 → 79,57 |
| $sql_val['upload'] = 'acctinputoctets'; |
| $sql_val['download'] = 'acctoutputoctets'; |
| } |
| $fun['sessions'] = nothing; |
| $fun['usage'] = time2strclock; |
| $fun['upload'] = bytes2str; |
| $fun['download'] = bytes2str; |
| $sql_val['user'] = ($login == '') ? "WHERE username LIKE '%'" : "WHERE username = '$login'"; |
| $fun['sessions'] = 'nothing'; |
| $fun['usage'] = 'time2strclock'; |
| $fun['upload'] = 'bytes2str'; |
| $fun['download'] = 'bytes2str'; |
| $sql_val['user'] = (!isset($login) || $login == '' ) ? "WHERE username LIKE '%'" : "WHERE username = '$login'"; |
| for ($j = 1; $j <= 3; $j++){ |
| $tmp = "{$sql_val[$column[$j]]}"; |
| $res[$j] = ($tmp == "") ? "COUNT(radacctid) AS res_$j" : "sum($tmp) AS res_$j"; |
| $res[$j] = (!isset($tmp)) ? "COUNT(radacctid) AS res_$j" : "sum($tmp) AS res_$j"; |
| } |
| $i = 1; |
| $servers[all] = 'all'; |
| $servers['all'] = 'all'; |
| foreach ($nas_list as $nas){ |
| $name = $nas[name]; |
| if ($nas[ip] == '') |
| $name = $nas['name']; |
| if ($nas['ip'] == '') |
| continue; |
| $servers[$name] = $nas[ip]; |
| $servers[$name] = $nas['ip']; |
| $i++; |
| } |
| ksort($servers); |
| if ($server != 'all' && $server != ''){ |
| $server = da_sql_escape_string($server); |
| $s = "AND nasipaddress = '$server'"; |
| if(isset($server)) |
| { |
| if ($server != 'all' && $server != ''){ |
| $server = da_sql_escape_string($link,$server); |
| $s = "AND nasipaddress = '$server'"; |
| } |
| } |
| $sql_extra_query = ''; |
| if ($config[sql_accounting_extra_query] != '') |
| $sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config); |
| if (isset($config['sql_accounting_extra_query'])) |
| { |
| $sql_extra_query = xlat($config['sql_accounting_extra_query'],$login,$config); |
| } |
| else |
| { |
| $sql_extra_query = ""; |
| } |
| $link = @da_sql_pconnect($config); |
| if ($link){ |
| if ($link) |
| { |
| $data['sum'] = array(); |
| $data['sum'][1] = ""; |
| $data['sum'][2] = ""; |
| $data['sum'][3] = ""; |
| $stats_num[1] = ""; |
| $stats_num[2] = ""; |
| $stats_num[3] = ""; |
| for ($i = $num_days;$i > -1; $i--){ |
| $day = "$days[$i]"; |
| if ($config[general_stats_use_totacct] == 'yes') |
| if ($config['general_stats_use_totacct'] == 'yes') |
| $search = @da_sql_query($link,$config, |
| "SELECT $res[1],$res[2],$res[3] FROM $config[sql_total_accounting_table] |
| $sql_val[user] AND acctdate = '$day' $s $sql_extra_query;"); |
| 114,14 → 140,14 |
| AND acctstoptime <= '$day 23:59:59' $s $sql_extra_query;"); |
| if ($search){ |
| $row = @da_sql_fetch_array($search,$config); |
| $data[$day][1] = $row[res_1]; |
| $data[sum][1] += $row[res_1]; |
| $data[$day][1] = $row['res_1']; |
| $data['sum'][1] += $row['res_1']; |
| $stats_num[1] = ($data[$day][1]) ? $stats_num[1] + 1 : $stats_num[1]; |
| $data[$day][2] = $row[res_2]; |
| $data[sum][2] += $row[res_2]; |
| $data[$day][2] = $row['res_2']; |
| $data['sum'][2] += $row['res_2']; |
| $stats_num[2] = ($data[$day][2]) ? $stats_num[2] + 1 : $stats_num[2]; |
| $data[$day][3] = $row[res_3]; |
| $data[sum][3] += $row[res_3]; |
| $data[$day][3] = $row['res_3']; |
| $data['sum'][3] += $row['res_3']; |
| $stats_num[3] = ($data[$day][3]) ? $stats_num[3] + 1 : $stats_num[3]; |
| } |
| else |
| 147,6 → 173,10 |
| $data['sum'][2] = $fun[$column[2]]($data['sum'][2]); |
| $data['sum'][3] = $fun[$column[3]]($data['sum'][3]); |
| $max[1] = 0; |
| $max[2] = 0; |
| $max[3] = 0; |
| for ($i = 0; $i <= $num_days; $i++){ |
| $day = "$days[$i]"; |
| $max[1] = ($max[1] > $data[$day][1] ) ? $max[1] : $data[$day][1]; |
| 178,9 → 208,9 |
| $data[$day][3] = $fun[$column[3]]($data[$day][3]); |
| } |
| $data[max][1] = $fun[$column[1]]($max[1]); |
| $data[max][2] = $fun[$column[2]]($max[2]); |
| $data[max][3] = $fun[$column[3]]($max[3]); |
| $data['max'][1] = $fun[$column[1]]($max[1]); |
| $data['max'][2] = $fun[$column[2]]($max[2]); |
| $data['max'][3] = $fun[$column[3]]($max[3]); |
| require('../html/stats.html.php'); |
| ?> |
| /web/acc/manager/htdocs/ticket_voucher.php |
|---|
| 125,8 → 125,7 |
| // création des données uniques |
| $login = GenRandUsersName(); |
| $passwd = GenPassword(); |
| $login = da_sql_escape_string($login); |
| $passwd = da_sql_escape_string($passwd); |
| // création des variables d'impression |
| $login_imp = $login; |
| $passwd1_imp = $passwd; |
| /web/acc/manager/htdocs/user_accounting.php |
|---|
| 56,8 → 56,6 |
| $link = da_sql_pconnect($config); |
| $now_str = da_sql_escape_string($link, $now_str); |
| $prev_str = da_sql_escape_string($link, $prev_str); |
| //$now_str = da_sql_escape_string($now_str); |
| //$prev_str = da_sql_escape_string($prev_str); |
| unset($da_name_cache); |
| if (isset($_SESSION['da_name_cache'])) |
| /web/acc/manager/htdocs/user_edit.php |
|---|
| 397,12 → 397,16 |
| </td> |
| <td> |
| EOM; |
| if (isset($member_groups)){ |
| echo "<select size=5 name=\"edited_groups[]\" multiple OnChange=\"this.form.group_change.value=1\">"; |
| if (isset($member_groups)){ |
| echo "<select size=5 name=\"edited_groups[]\" OnChange=\"this.form.group_change.value=1\">"; |
| if ($config['sql_show_all_groups'] == 'true'){ |
| foreach ($existing_groups as $group => $count){ |
| if ($member_groups[$group] == $group) |
| if (isset($member_groups[$group]) && ($member_groups[$group] == $group)) |
| echo "<option selected value=\"$group\">$group\n"; |
| else if(isset($member_groups[0]) && ($member_groups[0] == $group)) |
| echo "<option selected value=\"$group\">$group\n"; |
| else |
| echo "<option value=\"$group\">$group\n"; |
| } |
| 413,7 → 417,7 |
| echo "</select></td></tr>"; |
| } |
| else{ |
| echo "aucun group</td></tr>"; |
| echo "Aucun groupe</td></tr>"; |
| } |
| } |
| echo "</table><br>"; |
| /web/acc/manager/htdocs/user_finger.php |
|---|
| 43,7 → 43,7 |
| $sql_extra_query = ''; |
| if ($config[sql_accounting_extra_query] != ''){ |
| $sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config); |
| $sql_extra_query = da_sql_escape_string($sql_extra_query); |
| $sql_extra_query = da_sql_escape_string($link,$sql_extra_query); |
| } |
| $link = @da_sql_pconnect($config); |
| /web/acc/manager/htdocs/user_stats.php |
|---|
| 24,47 → 24,17 |
| exit(); |
| } |
| if ($start == '' && $stop == ''){ |
| if (!isset($start) && !isset($stop)){ |
| //if($start == '' && $stop == ''){ |
| $now = time(); |
| $stop = date($config[sql_date_format],$now); |
| $stop = date($config['sql_date_format'],$now); |
| $now -= 604800; |
| $start = date($config[sql_date_format],$now); |
| $start = date($config['sql_date_format'],$now); |
| } |
| $start = da_sql_escape_string($start); |
| $stop = da_sql_escape_string($stop); |
| $pagesize = ($pagesize) ? $pagesize : 10; |
| if (!is_numeric($pagesize) && $pagesize != 'all') |
| $pagezise = 10; |
| if ($pagesize > 100) |
| $pagesize = 100; |
| $limit = ($pagesize == 'all') ? '100' : "$pagesize"; |
| $selected[$pagesize] = 'selected'; |
| $order = ($order) ? $order : $config[general_accounting_info_order]; |
| if ($order != 'desc' && $order != 'asc') |
| $order = 'desc'; |
| if ($sortby != '') |
| $order_attr = ($sortby == 'num') ? 'connnum' : 'conntotduration'; |
| else |
| $order_attr = 'connnum'; |
| if ($server != '' && $server != 'all'){ |
| $server = da_sql_escape_string($server); |
| $server_str = "AND nasipaddress = '$server'"; |
| } |
| $login_str = ($login) ? "AND username = '$login' " : ''; |
| $start = da_sql_escape_string($link,$start); |
| $stop = da_sql_escape_string($link,$stop); |
| $selected[$order] = 'selected'; |
| $selected[$sortby] = 'selected'; |
| $sql_extra_query = ''; |
| if ($config[sql_accounting_extra_query] != ''){ |
| $sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config); |
| $sql_extra_query = da_sql_escape_string($sql_extra_query); |
| } |
| unset($da_name_cache); |
| if (isset($_SESSION['da_name_cache'])) |
| $da_name_cache = $_SESSION['da_name_cache']; |
| ?> |
| <head> |
| 95,20 → 65,75 |
| <table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top> |
| <tr><td> |
| <?php |
| if(isset($pagesize)) |
| { |
| echo <<<EOM |
| De <b>$start</b> à <b>$stop</b> |
| EOM; |
| ?> |
| <p> |
| <table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top> |
| <tr bgcolor="#d0ddb0"> |
| <th>#</th><th>Identifiant</th><th>Date</th><th>Serveur</th><th>Nombres de connections</th><th>Durée des connections</th><th>Upload</th><th>Download</th> |
| <th>#</th><th>Identifiant</th><th>Date</th><th>Serveur</th><th>Nombres de connections</th><th>Durée des connections</th><th>Upload</th><th>Download</th><th>Serveur</th> |
| </tr> |
| EOM; |
| <?php |
| $pagesize = ($pagesize) ? $pagesize : 10; |
| $selected[5] = ""; |
| $selected[10] = ""; |
| $selected[15] = ""; |
| $selected[20] = ""; |
| $selected[40] = ""; |
| $selected[80] = ""; |
| $selected['all'] = ""; |
| $selected['num'] = ""; |
| $selected['time'] = ""; |
| $selected['asc'] = ""; |
| $selected['desc'] = ""; |
| if (!is_numeric($pagesize) && $pagesize != 'all') |
| $pagezise = 10; |
| if ($pagesize > 100) |
| $pagesize = 100; |
| $limit = ($pagesize == 'all') ? '100' : "$pagesize"; |
| $selected[$pagesize] = 'selected'; |
| $order = ($order) ? $order : $config['general_accounting_info_order']; |
| if ($order != 'desc' && $order != 'asc') |
| $order = 'desc'; |
| if ($sortby != '') |
| $order_attr = ($sortby == 'num') ? 'connnum' : 'conntotduration'; |
| else |
| $order_attr = 'connnum'; |
| if ($server != '' && $server != 'all'){ |
| $server = da_sql_escape_string($link,$server); |
| $server_str = "AND nasipaddress = '$server'"; |
| } |
| else |
| { |
| $server_str = ""; |
| } |
| $login_str = ($login) ? "AND username = '$login' " : ''; |
| $selected[$order] = 'selected'; |
| $selected[$sortby] = 'selected'; |
| $sql_extra_query = ''; |
| if (isset($config['sql_accounting_extra_query'])){ |
| $sql_extra_query = xlat($config['sql_accounting_extra_query'],$login,$config); |
| $sql_extra_query = da_sql_escape_string($link,$sql_extra_query); |
| } |
| unset($da_name_cache); |
| if (isset($_SESSION['da_name_cache'])) |
| $da_name_cache = $_SESSION['da_name_cache']; |
| $link = @da_sql_pconnect($config); |
| if ($link){ |
| $num = 0; |
| $search = @da_sql_query($link,$config, |
| "SELECT " . da_sql_limit($limit,0,$config) . " * FROM $config[sql_total_accounting_table] |
| WHERE acctdate >= '$start' AND acctdate <= '$stop' $server_str $login_str $sql_extra_query " . da_sql_limit($limit,1,$config) |
| 117,7 → 142,7 |
| if ($search){ |
| while( $row = @da_sql_fetch_array($search,$config) ){ |
| $num++; |
| $acct_login = $row[username]; |
| $acct_login = $row['username']; |
| if ($acct_login == '') |
| $acct_login = '-'; |
| else{ |
| 124,23 → 149,22 |
| $Acct_login = urlencode($acct_login); |
| $acct_login = "<a href=\"user_admin.php?login=$Acct_login\" title=\"Editer l'utilisateur $acct_login\">$acct_login</a>"; |
| } |
| $acct_time = $row[conntotduration]; |
| $acct_time = $row['conntotduration']; |
| $acct_time = time2str($acct_time); |
| $acct_conn_num = $row[connnum]; |
| $acct_date = $row[acctdate]; |
| $acct_upload = $row[inputoctets]; |
| $acct_download = $row[outputoctets]; |
| $acct_conn_num = $row['connnum']; |
| $acct_date = $row['acctdate']; |
| $acct_upload = $row['inputoctets']; |
| $acct_download = $row['outputoctets']; |
| $acct_upload = bytes2str($acct_upload); |
| $acct_download = bytes2str($acct_download); |
| $acct_server = $da_name_cache[$row[nasipaddress]]; |
| if (!isset($acct_server)){ |
| $acct_server = @gethostbyaddr($row[nasipaddress]); |
| if (!isset($da_name_cache) && $config[general_use_session] == 'yes'){ |
| $da_name_cache[$row[nasipaddress]] = $acct_server; |
| $acct_server = @gethostbyaddr($row['nasipaddress']); |
| if (!isset($da_name_cache) && $config['general_use_session'] == 'yes'){ |
| $da_name_cache[$row['nasipaddress']] = $acct_server; |
| session_register('da_name_cache'); |
| } |
| else |
| $da_name_cache[$row[nasipaddress]] = $acct_server; |
| $da_name_cache[$row['nasipaddress']] = $acct_server; |
| } |
| if ($acct_server == '') |
| $acct_server = '-'; |
| 154,15 → 178,42 |
| <td>$acct_time</td> |
| <td>$acct_upload</td> |
| <td>$acct_download</td> |
| <td>$acct_server</td> |
| </tr> |
| EOM; |
| } |
| } |
| } |
| echo <<<EOM |
| </table> |
| <tr><td> |
| <hr> |
| EOM; |
| } |
| else |
| { |
| //create dummy selected |
| if(!isset($selected)) |
| { |
| $selected = array(); |
| $selected[5] = ""; |
| $selected[10] = ""; |
| $selected[15] = ""; |
| $selected[20] = ""; |
| $selected[40] = ""; |
| $selected[80] = ""; |
| $selected['all'] = ""; |
| $selected['num'] = ""; |
| $selected['time'] = ""; |
| $selected['asc'] = ""; |
| $selected['desc'] = ""; |
| } |
| } |
| echo <<<EOM |
| <tr><td align="left"> |
| <form action="user_stats.php" method="post" name="master"> |
| <table border=0> |
| 173,7 → 224,8 |
| <input type="text" name="start" size="11" value="$start"></td> |
| <td><input type="text" name="stop" size="11" value="$stop"></td> |
| <td><select name="pagesize"> |
| <option $selected[5] value="5" >05 |
| <option $selected[5] value="5" >5 |
| <option $selected[10] value="10">10 |
| <option $selected[15] value="15">15 |
| <option $selected[20] value="20">20 |
| 194,6 → 246,7 |
| </select> |
| </td> |
| EOM; |
| ?> |
| <td><input type="submit" class=button value="show"></td></tr> |
| 205,8 → 258,8 |
| <select name="server"> |
| <?php |
| foreach ($nas_list as $nas){ |
| $name = $nas[name]; |
| if ($nas[ip] == '') |
| $name = $nas['name']; |
| if ($nas['ip'] == '') |
| continue; |
| $servers[$name] = $nas[ip]; |
| } |
| 217,7 → 270,7 |
| else |
| echo "<option value=\"$ip\">$name\n"; |
| } |
| if ($server == '' || $server == 'all') |
| if (isset($server) && ($server == '' || $server == 'all')) |
| echo "<option selected value=\"all\">tous\n"; |
| else |
| echo "<option value=\"all\">tous\n"; |
| 224,7 → 277,7 |
| ?> |
| </select> |
| </td> |
| <td><input type="text" name="login" size="11" value="<?php echo $login ?>"></td> |
| <td><input type="text" name="login" size="11" value="<?php if(!isset($login)){echo "";}else{ echo $login;} ?>"></td> |
| </tr> |
| </table></td></tr></form> |
| </table> |
| /web/acc/manager/html/stats.html.php |
|---|
| 12,6 → 12,10 |
| </tr> |
| <tr valign=middle> |
| <?php |
| if(!isset($login)) |
| { |
| $login = ""; |
| } |
| echo <<<EOM |
| <td valign=middle><input type="text" name="after" size="12" value="$after" ></td> |
| <td valign=middle><input type="text" name="before" size="12" value="$before"></td> |
| 91,29 → 95,30 |
| <tr> |
| <td align="center"> |
| <table border=0 cellpadding=0 cellspacing=1 width="100%"> |
| <?php |
| echo <<<EOM |
| <tr> |
| <td>Champs affichés :</td><td colspan=10 align=center nowrap><select name="column1"> |
| <option $selected1[sessions] value="sessions">Nbre de sessions |
| <option $selected1[usage] value="usage">Temps d'utilisation total |
| <option <?php if(isset($selected1[sessions])){print($selected1[session]);} ?> value="sessions">Nbre de sessions |
| <option <?php if(isset($selected1[usage])){print($selected1[usage]);} ?> value="usage">Temps d'utilisation total |
| <option value="upload">------------------ |
| <option $selected1[upload] value="upload">uploads |
| <option $selected1[download] value="download">downloads |
| <option <?php if(isset($selected1[upload])){print($selected1[upload]);} ?> value="upload">uploads |
| <option <?php if(isset($selected1[download])){print($selected1[download]);} ?> value="download">downloads |
| </select> <select name="column2"> |
| <option $selected2[sessions] value="sessions">Nbre de sessions |
| <option $selected2[usage] value="usage">Temps d'utilisation total |
| <option <?php if(isset($selected2[sessions])){print($selected2[session]);} ?> value="sessions">Nbre de sessions |
| <option <?php if(isset($selected2[usage])){print($selected2[usage]);} ?> value="usage">Temps d'utilisation total |
| <option value="upload">------------------ |
| <option $selected2[upload] value="upload">uploads |
| <option $selected2[download] value="download">downloads |
| <option <?php if(isset($selected2[upload])){print($selected2[upload]);} ?> value="upload">uploads |
| <option <?php if(isset($selected2[download])){print($selected2[download]);} ?> value="download">downloads |
| </select> <select name="column3"> |
| <option $selected3[sessions] value="sessions">Nbre de sessions |
| <option $selected3[usage] value="usage">Temps d'utilisation total |
| <option <?php if(isset($selected3[sessions])){print($selected3[session]);} ?> value="sessions">Nbre de sessions |
| <option <?php if(isset($selected3[usage])){print($selected3[usage]);} ?> value="usage">Temps d'utilisation total |
| <option value="upload">------------------ |
| <option $selected3[upload] value="upload">uploads |
| <option $selected3[download] value="download">downloads |
| EOM; |
| ?> |
| <option <?php if(isset($selected3[upload])){print($selected3[upload]);} ?> value="upload">uploads |
| <option <?php if(isset($selected3[download])){print($selected3[download]);} ?> value="download">downloads |
| </select> |
| </td> |
| </tr> |
| 240,21 → 245,21 |
| echo <<<EOM |
| <tr align=center bgcolor="#efefe4"> |
| <td>maximum</td> |
| <td>{$data[max][1]}</td> |
| <td>{$data[max][2]}</td> |
| <td>{$data[max][3]}</td> |
| <td>{$data['max'][1]}</td> |
| <td>{$data['max'][2]}</td> |
| <td>{$data['max'][3]}</td> |
| </tr> |
| <tr align=center bgcolor="#f7f7e4"> |
| <td>moyenne</td> |
| <td>{$data[avg][1]}</td> |
| <td>{$data[avg][2]}</td> |
| <td>{$data[avg][3]}</td> |
| <td>{$data['avg'][1]}</td> |
| <td>{$data['avg'][2]}</td> |
| <td>{$data['avg'][3]}</td> |
| </tr> |
| <tr align=center bgcolor="#efefe4"> |
| <td>récapitulatif</td> |
| <td>{$data[sum][1]}</td> |
| <td>{$data[sum][2]}</td> |
| <td>{$data[sum][3]}</td> |
| <td>{$data['sum'][1]}</td> |
| <td>{$data['sum'][2]}</td> |
| <td>{$data['sum'][3]}</td> |
| </tr> |
| EOM; |
| ?> |
| /web/acc/manager/lib/acctshow.php |
|---|
| 4,17 → 4,26 |
| if (isset($_SESSION['sql_attrs'])) |
| $sql_attrs = $_SESSION["sql_attrs"]; |
| if (!isset($sql_attrs)){ |
| $ARR = file($config[general_sql_attrs_file]); |
| $ARR = file($config['general_sql_attrs_file']); |
| foreach($ARR as $val){ |
| $val=chop($val); |
| if (preg_match('/^[[:space:]]*#/',$val) || preg_match('/^[[:space:]]*$/',$val)) |
| continue; |
| list($key,$desc,$show,$func)=preg_split("/\t+/",$val); |
| $sql_attrs[strtolower($key)][desc] = "$desc"; |
| $sql_attrs[strtolower($key)][show] = "$show"; |
| $sql_attrs[strtolower($key)][func] = ($func == "") ? "nothing" : "$func"; |
| $list_val=preg_split("/\t+/",$val); |
| $key = $list_val[0]; |
| $desc = $list_val[1]; |
| $show = $list_val[2]; |
| $sql_attrs[strtolower($key)]['desc'] = "$desc"; |
| $sql_attrs[strtolower($key)]['show'] = "$show"; |
| if(isset($list_val[3])){ |
| $func = $list_val[3]; |
| $sql_attrs[strtolower($key)]['func'] = ($func == "") ? "nothing" : "$func"; |
| } |
| } |
| if ($config[general_use_session] == 'yes') |
| if ($config['general_use_session'] == 'yes') |
| session_register('sql_attrs'); |
| } |
| ?> |
| /web/acc/manager/lib/functions.php |
|---|
| 89,15 → 89,6 |
| return ($now - $timest); |
| } |
| function date2time($date) |
| { |
| list($day,$time)=explode(' ',$date); |
| $day = explode('-',$day); |
| $time = explode(':',$time); |
| $timest = mktime($time[0] ?"":0,$time[1],$time[2],$day[1],$day[2],$day[0]); |
| return $timest; |
| } |
| function bytes2str($bytes) |
| { |
| $bytes=floor($bytes); |
| 117,7 → 108,7 |
| } |
| function check_defaults($val,$op,$def) |
| { |
| for($i=0;$i<$def['count'];$i++){ |
| for($i=0;isset($def['count']) && $i<$def['count'];$i++){ |
| if ($val == $def[$i] && ($op == '' || $op == $def['operator'][$i])) |
| return 1; |
| } |
| /web/acc/manager/lib/langues.php |
|---|
| 50,7 → 50,7 |
| $l_manage_selected_user= "Gérer l'usager sélectionné"; |
| $l_group_member = "Membre du groupe"; |
| $l_group_empty = "La liste des groupes est vide"; |
| $l_main_group = "Le groupe principal est surligné"; |
| $l_main_group = "Le groupe de l'utilisateur est surligné en bleu"; |
| $l_no_open_session = "Aucune session ouverte"; |
| $l_opened_sessions = "session(s) ouverte(s)"; |
| $l_active_accounting = "comptabilité(s) active(s)"; |
| 158,7 → 158,7 |
| $l_manage_selected_user= "Manage the selected user"; |
| $l_group_member = "Member of group"; |
| $l_group_empty = "The group list is empty"; |
| $l_main_group = "The main group is highlighted"; |
| $l_main_group = "The current user group is highlighted in blue"; |
| $l_no_open_session = "No open session"; |
| $l_opened_sessions = "opened session(s)"; |
| $l_active_accounting = "active accounting(s)"; |
| /web/acc/manager/lib/sql/change_passwd.php |
|---|
| 20,7 → 20,7 |
| if (is_file("../lib/crypt/$config[general_encryption_method].php")){ |
| include("../lib/crypt/$config[general_encryption_method].php"); |
| $passwd = da_encrypt($passwd); |
| $passwd = da_sql_escape_string($passwd); |
| $passwd = da_sql_escape_string($link,$passwd); |
| $res = da_sql_query($link,$config, |
| "SELECT value FROM $config[sql_check_table] WHERE username = '$login' |
| AND attribute = '$config[sql_password_attribute]';"); |
| /web/acc/manager/lib/sql/defaults.php |
|---|
| 1,6 → 1,7 |
| <?php |
| require('../lib/sql/attrmap.php'); |
| if ((isset($login) && $login != '') && (isset($user_type) && $user_type !== 'group')){ |
| if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php")) |
| include_once("../lib/sql/drivers/$config[sql_type]/functions.php"); |
| else{ |
| 66,7 → 67,10 |
| $tmp["$attr"]['operator'][]="$oper"; |
| } |
| $tmp["$attr"][] = "$val"; |
| $tmp["$attr"]['count']++; |
| if(isset($tmp["$attr"]['count'])) |
| { |
| $tmp["$attr"]['count']++; |
| } |
| } |
| } |
| else |
| 124,11 → 128,23 |
| unset($member_groups); |
| $link = da_sql_pconnect($config); |
| if ($link){ |
| $res = da_sql_query($link,$config, |
| "SELECT DISTINCT groupname FROM $config[sql_usergroup_table];"); |
| if(isset($login) && $login != '') |
| { |
| #affiche le groupe appartenant à l'utilisateur |
| $res = da_sql_query($link,$config, |
| "SELECT DISTINCT groupname FROM $config[sql_usergroup_table] WHERE username = '$login';"); |
| } |
| else |
| { |
| #affiche la liste de groupe disponible (dans le cas de la creation d'un utilisateur) |
| $res = da_sql_query($link,$config, |
| "SELECT DISTINCT groupname FROM $config[sql_usergroup_table] ;"); |
| } |
| if ($res){ |
| while(($row = da_sql_fetch_array($res,$config))) |
| while(($row = da_sql_fetch_array($res,$config))){ |
| $member_groups[] = $row['groupname']; |
| } |
| } |
| else |
| echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n"; |
| /web/acc/manager/lib/sql/drivers/mysql/functions.php |
|---|
| 120,7 → 120,7 |
| function da_sql_num_fields($fields,$config) |
| { |
| return mysqli_num_fields($fields); |
| return mysqli_num_fields($fields); |
| } |
| function da_sql_field_name($fields,$num,$config) |
| /web/acc/manager/lib/sql/group_change.php |
|---|
| 11,7 → 11,7 |
| $del_groups = array_diff($member_groups,$edited_groups); |
| if (isset($del_groups)){ |
| foreach ($del_groups as $del){ |
| $del = da_sql_escape_string($del); |
| $del = da_sql_escape_string($link,$del); |
| $res = da_sql_query($link,$config, |
| "DELETE FROM $config[sql_usergroup_table] WHERE username = '$login' AND groupname = '$del';"); |
| if (!$res) |
| 23,7 → 23,7 |
| $new_groups = array_diff($edited_groups,$member_groups); |
| if (isset($new_groups)){ |
| foreach($new_groups as $new){ |
| $new = da_sql_escape_string($new); |
| $new = da_sql_escape_string($link,$new); |
| $res = da_sql_query($link,$config, |
| "INSERT INTO $config[sql_usergroup_table] (groupname,username) |
| VALUES ('$new','$login');"); |
| /web/acc/manager/lib/sql/nas_list.php |
|---|
| 5,7 → 5,7 |
| unset($da_name_cache); |
| if (isset($_SESSION['da_name_cache'])) |
| $da_name_cache = $_SESSION['da_name_cache']; |
| if ($config[sql_nas_table] != ''){ |
| if ($config['sql_nas_table'] != ''){ |
| if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php")) |
| include_once("../lib/sql/drivers/$config[sql_type]/functions.php"); |
| 17,7 → 17,7 |
| if ($link){ |
| $auth_user = $_SERVER["PHP_AUTH_USER"]; |
| $extra = ''; |
| if (isset($mappings[$auth_user][nasdb])){ |
| if (isset($mappings[$auth_user]['nasdb'])){ |
| $NAS_ARR = array(); |
| $NAS_ARR = preg_split('/,/',$mappings[$auth_user][nasdb]); |
| $extra = 'WHERE nasname IN ('; |
| /web/acc/manager/lib/sql/user_info.php |
|---|
| 99,7 → 99,9 |
| foreach(array_keys($tmp) as $val){ |
| if ($val == '') |
| continue; |
| if(isset($rev_attrmap["$val"])) $key = $rev_attrmap["$val"]; |
| if(isset($rev_attrmap["$val"])) { |
| $key = $rev_attrmap["$val"]; |
| } |
| if ($key == ''){ |
| $key = $val; |
| $attrmap["$key"] = $val; |
| 119,4 → 121,5 |
| } |
| else |
| echo "<b>Could not connect to SQL database</b><br>\n"; |
| ?> |
| /web/pass/sql/drivers/oracle/functions.php |
|---|
| File deleted |
| /web/pass/sql/drivers/pg/functions.php |
|---|
| File deleted |
| /web/pass/sql/drivers/dbx/functions.php |
|---|
| File deleted |
| /web/pass/sql/drivers/sqlrelay/functions.php |
|---|
| File deleted |