1
0

auth_export.php 1.8 KB

123456789101112131415161718192021222324252627282930
  1. <?php
  2. require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/auth.php");
  3. require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/languages/" . HTML_LANG . ".php");
  4. if (!defined("CONFIG")) die("Not defined");
  5. if (isset($_POST["ExportAuth"])) {
  6. print "login;ip;mac;description;dns name;last_found;connected\n";
  7. if (isset($_POST["a_selected"]) and $_POST["a_selected"] * 1) {
  8. //export selected only
  9. $auth_id = $_POST["fid"];
  10. foreach ($auth_id as $key => $val) {
  11. if ($val) {
  12. $sSQL = "SELECT user_list.login, user_auth.ip, user_auth.mac, user_auth.description, user_auth.dns_name, user_auth.last_found FROM user_auth, user_list WHERE user_auth.user_id = user_list.id AND user_auth.id = " . $val;
  13. $record = get_record_sql($db_link, $sSQL);
  14. print $record['login'] . ';' . $record['ip'] . ';' . $record['mac'] . ';' . $record['description'] . ';' . $record['dns_name'] . ';' . $record['last_found'] . ';' . get_connection_string($db_link, $val)."\n";
  15. }
  16. }
  17. } else {
  18. //export all
  19. $ip_filter = '';
  20. $sort = 'user_auth.ip_int';
  21. if (!empty($_POST["ip-filter"])) { $ip_filter = $_POST['ip-filter']; }
  22. if (!empty($_POST["ip-sort"])) { $sort = $_POST['ip-sort']; }
  23. $sSQL = "SELECT user_auth.*, user_list.login, user_list.enabled as UEnabled, user_list.blocked as UBlocked FROM user_auth, user_list WHERE user_auth.user_id = user_list.id AND user_auth.deleted = 0 $ip_filter ORDER BY $sort";
  24. $auth_table = get_records_sql($db_link, $sSQL);
  25. foreach ($auth_table as $record) {
  26. print $record['login'] . ';' . $record['ip'] . ';' . $record['mac'] . ';' . $record['description'] . ';' . $record['dns_name'] . ';' . $record['last_found'] .';' . get_connection_string($db_link, $record['id']). "\n";
  27. }
  28. }