Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function freeradius_SuspendAccount($params) {
- $username = $params["username"];
- $password = $params["password"];
- $sqlhost = $params["serverip"];
- $sqlusername = $params["serverusername"];
- $sqlpassword = $params["serverpassword"];
- $sqldbname = $params["serveraccesshash"];
- $freeradiussql = mysql_connect($sqlhost,$sqlusername,$sqlpassword);
- mysql_select_db($sqldbname);
- $query = "SELECT COUNT(*) FROM radcheck WHERE username='$username'";
- $result = mysql_query($query,$freeradiussql);
- if (!$result) {
- freeradius_Reconnect();
- return "FreeRadius Database Query Error: ".mysql_error();
- }
- $data = mysql_fetch_array($result);
- $count = $data[0];
- if (!$count) {
- freeradius_Reconnect();
- return "User Not Found";
- }
- $query = "SELECT COUNT(*) FROM radcheck WHERE username='$username' AND attribute='Expiration'";
- $result = mysql_query($query,$freeradiussql);
- if (!$result) {
- freeradius_Reconnect();
- return "FreeRadius Database Query Error: ".mysql_error();
- }
- $data = mysql_fetch_array($result);
- $count = $data[0];
- if (!$count) {
- $query = "INSERT INTO radcheck (username,attribute,value,op) VALUES ('$username','Expiration','".date("d F Y")."',':=')";
- } else {
- $query = "UPDATE radcheck SET value='".date("d F Y")."' WHERE username='$username' AND attribute='Expiration'";
- }
- $result = mysql_query($query,$freeradiussql);
- if (!$result) {
- freeradius_Reconnect();
- return "FreeRadius Database Query Error: ".mysql_error();
- }
- freeradius_Reconnect();
- return "success";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement