From: Neil S. <sir...@us...> - 2003-06-13 15:19:26
|
CVSROOT : /cvsroot/publicdnsadmin Module : publicdnsadmin Commit time: 2003-06-13 15:19:22 UTC Modified files: users.php docs/CHANGELOG Added files: delete_user.php Log message: Author: SiRVu|caN Log message: We can now delete users. ---------------------- diff included ---------------------- Index: publicdnsadmin/delete_user.php diff -u /dev/null publicdnsadmin/delete_user.php:1.1 --- /dev/null Fri Jun 13 08:19:22 2003 +++ publicdnsadmin/delete_user.php Fri Jun 13 08:19:11 2003 @@ -0,0 +1,71 @@ +<?php +/* + Public DNS Administator + Originally Written by Trond Arve Nordheim <tr...@no...> + Modified By Neil Spierling <sir...@si...> + + Distributed under the GPL license, see LICENSE for + more information + + $Id: +*/ + +require("lib/prepend.php"); +require("lib/header.php"); + +if (userHasAccess($_SESSION["_UID"], "users") && ($_GET["id"] != 1)) { + + $perms = getUserPermissions($_SESSION["_UID"]); + $userid = trim(addslashes($_GET["id"])); + $dbh = db_connect(); + $getuser = $dbh->query("SELECT username FROM users where id='$userid'"); + if (!$dbh->isError($getuser) && $getuser->numRows()) { + $urow = $getuser->fetchRow(); + $username = $urow["username"]; + } else { + echo "<h3>Delete user</h3>"; + echo "<p>Fatal Error, User Does Not Exist Most Likely</p>"; + $dbh->disconnect(); + require("lib/footer.php"); + die(); + } + +?> +<h3>Delete user</h3> +<?php + if ($_GET["confirm"]) { + + $result = $dbh->query("SELECT user_id, domain_id FROM domain_owners WHERE user_id = '$id'"); + if (!$dbh->isError($result) && $result->numRows()) { + while ($row = $result->fetchRow()) { + $checkdomain = $row["domain_id"]; + $domcheck = $dbh->query("SELECT user_id, domain_id FROM domain_owners WHERE domain_id='$checkdomain'"); + if (!$dbh->isError($domcheck) && $domcheck->numRows()) { + if ($domcheck->numRows() == 1) { + $dbh->query("DELETE FROM domains WHERE id = '$checkdomain'"); + $dbh->query("DELETE FROM domain_owners WHERE domain_id = 'checkdomain'"); + $dbh->query("DELETE FROM records WHERE domain_id = '$checkdomain'"); + } else { + $dbh->query("DELETE FROM domain_owners WHERE domain_id = '$checkdomain'"); + } + } + } + } + + $dbh->query("DELETE FROM users WHERE id = '$id'"); + echo "<p>$username and all their domains/records were successfully deleted</p>\n"; + } else { + echo "<p>Are you sure you wish to delete $username?</p>\n"; + echo "<p><input type=\"button\" value=\"Yes\" onClick=\"javascript:document.location.href='delete_user.php?id=$userid&confirm=1';\"> <input type=\"button\" value=\"No\" onClick=\"javascript:history.go(-1);\"></p>\n"; + } + + + $dbh->disconnect(); +} else { + displayNoAccess(); +} + +require("lib/footer.php"); + +?> + Index: publicdnsadmin/docs/CHANGELOG diff -u publicdnsadmin/docs/CHANGELOG:1.3 publicdnsadmin/docs/CHANGELOG:1.4 --- publicdnsadmin/docs/CHANGELOG:1.3 Fri Jun 13 07:09:28 2003 +++ publicdnsadmin/docs/CHANGELOG Fri Jun 13 08:19:12 2003 @@ -10,3 +10,4 @@ - Added documentation for the dbbackup setup into INSTALL, i will improve the way it works later. - Fixed path for .gz backup download link. +SiRVu|caN <sir...@si...> - 14/6/2003 - Added delete_user.php for deleting users. Index: publicdnsadmin/users.php diff -u publicdnsadmin/users.php:1.1.1.1 publicdnsadmin/users.php:1.2 --- publicdnsadmin/users.php:1.1.1.1 Wed Apr 16 00:19:07 2003 +++ publicdnsadmin/users.php Fri Jun 13 08:19:11 2003 @@ -23,7 +23,7 @@ $result = $dbh->query("SELECT * FROM users ORDER BY username"); if (!$dbh->isError($result) && $result->numRows()) { - echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr><td style=\"background: #000000;\"><table border=\"0\" cellspacing=\"1\" cellpadding=\"2\"><tr><th>Username</th><th>Name</th><th>E-mail</th><th>Company</th><th>Domains</th></tr>\n"; + echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr><td style=\"background: #000000;\"><table border=\"0\" cellspacing=\"1\" cellpadding=\"2\"><tr><th>Username</th><th>Name</th><th>E-mail</th><th>Company</th><th>Domains</th><th></th></tr>\n"; $row_id = 0; while ($row = $result->fetchRow()) { @@ -43,6 +43,11 @@ echo "<td class=\"row$row_id\"><a href=\"mailto:".htmlentities($row["email"])."\">".htmlentities($row["email"])."</a></td>\n"; echo "<td class=\"row$row_id\">".htmlentities($row["company"])."</td>\n"; echo "<td class=\"row$row_id\" align=\"center\">$domain_count</td>\n"; + if ($row["id"] != 1) { + echo "<td class=\"row$row_id\" align=\"center\"><a href=\"delete_user.php?id=".$row["id"]."\"><img src=\"images/trash.png\" alt=\"Delete User\" border=0></a></td>\n"; + } else { + echo "<td class=\"row$row_id\" align=\"center\"></td>\n"; + } echo "</tr>\n"; if ($row_id == 2) { $row_id = 0; } ----------------------- End of diff ----------------------- |