Advertisement
Guest User

Untitled

a guest
May 28th, 2017
363
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. function freeradius_SuspendAccount($params) {
  2.  
  3. $username = $params["username"];
  4. $password = $params["password"];
  5.  
  6. $sqlhost = $params["serverip"];
  7. $sqlusername = $params["serverusername"];
  8. $sqlpassword = $params["serverpassword"];
  9. $sqldbname = $params["serveraccesshash"];
  10. $freeradiussql = mysql_connect($sqlhost,$sqlusername,$sqlpassword);
  11. mysql_select_db($sqldbname);
  12.  
  13. $query = "SELECT COUNT(*) FROM radcheck WHERE username='$username'";
  14. $result = mysql_query($query,$freeradiussql);
  15. if (!$result) {
  16. freeradius_Reconnect();
  17. return "FreeRadius Database Query Error: ".mysql_error();
  18. }
  19. $data = mysql_fetch_array($result);
  20. $count = $data[0];
  21. if (!$count) {
  22. freeradius_Reconnect();
  23. return "User Not Found";
  24. }
  25. $query = "SELECT COUNT(*) FROM radcheck WHERE username='$username' AND attribute='Expiration'";
  26. $result = mysql_query($query,$freeradiussql);
  27. if (!$result) {
  28. freeradius_Reconnect();
  29. return "FreeRadius Database Query Error: ".mysql_error();
  30. }
  31. $data = mysql_fetch_array($result);
  32. $count = $data[0];
  33. if (!$count) {
  34. $query = "INSERT INTO radcheck (username,attribute,value,op) VALUES ('$username','Expiration','".date("d F Y")."',':=')";
  35. } else {
  36. $query = "UPDATE radcheck SET value='".date("d F Y")."' WHERE username='$username' AND attribute='Expiration'";
  37. }
  38. $result = mysql_query($query,$freeradiussql);
  39. if (!$result) {
  40. freeradius_Reconnect();
  41. return "FreeRadius Database Query Error: ".mysql_error();
  42. }
  43. freeradius_Reconnect();
  44. return "success";
  45.  
  46. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement