PageRenderTime 51ms CodeModel.GetById 25ms RepoModel.GetById 0ms app.codeStats 0ms

/attic/purgeports.inc.php

https://bitbucket.org/MelFlynn/observium
PHP | 46 lines | 39 code | 6 blank | 1 comment | 4 complexity | 104ef7d20663cb558df27dc4983ab6fb MD5 | raw file
Possible License(s): GPL-3.0, MIT
  1. <?php
  2. # FIXME there's a delete port function in the functions... merge?!
  3. function delete_port($interface_id)
  4. {
  5. $ipaddrs = mysql_query("SELECT * FROM `ipaddr` WHERE `interface_id` = '$interface_id'");
  6. while ($ipaddr = mysql_fetch_assoc($ipaddrs))
  7. {
  8. echo("<div style='padding-left:8px; font-weight: normal;'>Deleting IPv4 address " . $ipaddr['addr'] . "/" . $ipaddr['cidr']);
  9. mysql_query("DELETE FROM addr WHERE id = '".$addr['id']."'");
  10. echo("</div>");
  11. }
  12. $ip6addr = mysql_query("SELECT * FROM `ip6addr` WHERE `interface_id` = '$interface_id'");
  13. while ($ip6addr = mysql_fetch_assoc($ip6addrs))
  14. {
  15. echo("<div style='padding-left:8px; font-weight: normal;'>Deleting IPv6 address " . $ip6addr['ip6_comp_addr'] . "/" . $ip6addr['ip6_prefixlen']);
  16. mysql_query("DELETE FROM ip6addr WHERE ip6_addr_id = '".$ip6addr['ip6_addr_id']."'");
  17. echo("</div>");
  18. }
  19. $ip6addr = mysql_query("SELECT * FROM `ip6addr` WHERE `interface_id` = '$interface_id'");
  20. while ($ip6addr = mysql_fetch_assoc($ip6addrs))
  21. {
  22. echo("<div style='padding-left:8px; font-weight: normal;'>Deleting IPv6 address " . $ip6addr['ip6_comp_addr'] . "/" . $ip6addr['ip6_prefixlen']);
  23. mysql_query("DELETE FROM ip6addr WHERE ip6_addr_id = '".$ip6addr['ip6_addr_id']."'");
  24. echo("</div>");
  25. }
  26. mysql_query("DELETE FROM `pseudowires` WHERE `interface_id` = '$interface_id'");
  27. mysql_query("DELETE FROM `mac_accounting` WHERE `interface_id` = '$interface_id'");
  28. mysql_query("DELETE FROM `links` WHERE `local_interface_id` = '$interface_id'");
  29. mysql_query("DELETE FROM `links` WHERE `remote_interface_id` = '$interface_id'");
  30. mysql_query("DELETE FROM `ports_perms` WHERE `interface_id` = '$interface_id'");
  31. mysql_query("DELETE FROM `ports` WHERE `interface_id` = '$interface_id'");
  32. }
  33. $ports = mysql_query("SELECT * FROM `ports` WHERE `deleted` = '1'");
  34. while ($port = mysql_fetch_assoc($ports))
  35. {
  36. echo("<div style='font-weight: bold;'>Deleting port " . $port['interface_id'] . " - " . $port['ifDescr']);
  37. delete_port($port['interface_id']);
  38. echo("</div>");
  39. }
  40. ?>