0,0 → 1,116 |
<?php |
require('../lib/sql/attrmap.php'); |
if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php")) |
include_once("../lib/sql/drivers/$config[sql_type]/functions.php"); |
else{ |
echo "<b>Could not include SQL library</b><br>\n"; |
exit(); |
} |
if ($config[sql_use_operators] == 'true'){ |
$op = ',op'; |
$use_op = 1; |
}else{ |
$op = ""; |
$use_op = 0; |
} |
$group_exists = 'no'; |
$link = @da_sql_pconnect($config); |
if ($link){ |
if ($login == ''){ |
unset($existing_groups); |
|
$res = @da_sql_query($link,$config, |
"SELECT COUNT(*) as counter,groupname FROM $config[sql_usergroup_table] |
GROUP BY groupname;"); |
if ($res){ |
while(($row = @da_sql_fetch_array($res,$config))){ |
$name = $row[groupname]; |
$existing_groups["$name"] = $row[counter]; |
} |
if (isset($existing_groups)) |
ksort($existing_groups); |
} |
else |
echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n"; |
} |
else{ |
unset($item_vals); |
unset($tmp); |
unset($group_members); |
unset($existing_groups); |
|
$res = @da_sql_query($link,$config, |
"SELECT attribute,value $op FROM $config[sql_groupcheck_table] WHERE groupname = '$login';"); |
if ($res){ |
if (@da_sql_num_rows($res,$config)) |
$group_exists = 'yes'; |
while(($row = @da_sql_fetch_array($res,$config))){ |
$attr = $row[attribute]; |
$val = $row[value]; |
if ($use_op){ |
$oper = $row[op]; |
$tmp["$attr"][operator][]="$oper"; |
} |
$tmp["$attr"][]="$val"; |
$tmp["$attr"][count]++; |
} |
$res = @da_sql_query($link,$config, |
"SELECT attribute,value $op FROM $config[sql_groupreply_table] WHERE groupname = '$login';"); |
if ($res){ |
if (@da_sql_num_rows($res,$config)) |
$group_exists = 'yes'; |
while(($row = @da_sql_fetch_array($res,$config))){ |
$attr = $row[attribute]; |
$val = $row[value]; |
/*Ajout en vue de l'impression des données (thank's to Geoffroy MUSITELLI)*/ |
if($attr == "Session-Timeout") $sto_imp = $val; |
if($attr == "Max-Daily-Session") $mds_imp = $val; |
if($attr == "Max-Monthly-Session") $mms_imp = $val; |
/*Fin Ajout*/ |
if ($use_op){ |
$oper = $row[op]; |
$tmp["$attr"][operator][]="$oper"; |
} |
$tmp["$attr"][] = "$val"; |
$tmp["$attr"][count]++; |
} |
} |
else |
echo "<b>Database query failed partially: " . da_sql_error($link,$config) . "</b><br>\n"; |
$res = @da_sql_query($link,$config, |
"SELECT username FROM $config[sql_usergroup_table] WHERE groupname = '$login' ORDER BY username;"); |
if ($res){ |
if (@da_sql_num_rows($res,$config)) |
$group_exists = 'yes'; |
while(($row = @da_sql_fetch_array($res,$config))){ |
$member = $row[username]; |
$group_members[] = "$member"; |
} |
} |
else |
echo "<b>Database query failed partially: " . da_sql_error($link,$config) . "</b><br>\n"; |
if (isset($tmp)){ |
foreach(array_keys($tmp) as $val){ |
if ($val == '') |
continue; |
$key = $rev_attrmap["$val"]; |
if ($key == ''){ |
$key = $val; |
$attrmap["$key"] = $val; |
$attr_type["$key"] = 'replyItem'; |
$rev_attrmap["$val"] = $key; |
} |
$item_vals["$key"] = $tmp[$val]; |
$item_vals["$key"][count] = $tmp[$val][count]; |
if ($use_op) |
$item_vals["$key"][operator] = $tmp[$val][operator]; |
} |
} |
} |
else |
echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n"; |
} |
} |
else |
echo "<b>Could not connect to SQL database</b><br>\n"; |
?> |