i'm trying to get the progress of the deletion to print to the screen as it occurs. here's the function that deletes a user (note, to even see this choice on the "admin page" you have to be a full administrator or the webmaster, and there's a double check in the function itself. all variables not taken from post or cookies or db retrievals, are set in the includes.)
Code: Select all
function delu(){ # delete a user
include("/home/joshua/includes/fyd.altincs.php"); # includes file (precautionary measure)
$un=$_COOKIE['un']; $pw=$_COOKIE['pw']; $deluser=$_POST['deluser'];
# check for access in the db
$db=mysql_connect($host, $login3, $pass3) or die("cannot access mysql"); # connect to the db
$fyd=mysql_select_db('findyourdesire', $db) or die("cannot access db"); # get the db
$accessfind=mysql_query("SELECT site_access FROM users WHERE username='$un' AND password='$pw'", $db);
$accessret=mysql_fetch_array($accessfind); $sa=$accessret['site_access'];
if(($sa!=$adm)&&($sa!=$wbm)){ error(); } # if not full admin or webmaster, error
else{ # we're authorized to delete
if(isset($_POST['action'])){ # we're gonna delete
$deluser=$_POST['deluser']; $gone=0; $errs='<p>';
$findinfo=mysql_query("SELECT uid,email FROM users WHERE username='$deluser'", $db);
if(mysql_num_rows($findinfo)){ // we found the user
$getinfo=mysql_fetch_array($findinfo); $email=$getinfo['email']; $todel=$getinfo['uid']; $delerr=0;
if($_POST['reason']!=''){ # if there was a reason given for the deletion
$from='Administration_Of_FindYourDesire.com'; $reason=$_POST['reason'];
$message="Your account was terminated. If you join again and continue this behaviour your ISP will be contacted.
Our reason for terminating your account:
$reason";
mail($to, 'Deletion of your Account', $message, $from);
}
echo " <p>Deleting $deluser...\n"; $imgbase=$faup; $npib=$fuup;
foreach($images as $key=>$value){ # for each possible picture
echo " <br />Checking for $value\n"; $pica=$imgbase.$key.$deluser.'.jpg';
$picb=$imgbase.'old.'.$key.$deluser.'.jpg'; $picc=$npib.$key.$deluser.'.jpg';
/* delete the pics if they exist */
if(is_file($pica)){ unlink($pica); echo " <br />Removing $pica\n"; }
if(is_file($picb)){ unlink($picb); echo " <br />Removing $picb\n"; }
if(is_file($picc)){ unlink($picc); echo " <br />Removing $picc\n"; }
}
echo " <br />Deleting of user $deluser from table BIO";
$dfs=mysql_query("DELETE FROM bio WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){ // successful deletion
$gone++; echo " <br />Removed $deluser (user # $todel) from table BIO";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db); $delerr=1;
$errs.="<br />Bio:$errno: $error";
}
echo " <br />Deleting of user $deluser from table COMMENTS";
$dfs=mysql_query("DELETE FROM comments WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table COMMENTS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Comments:$errno: $error";
}
echo " <br />Deleting of user $deluser from table FRIENDS";
$dfs=mysql_query("DELETE FROM friends WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table FRIENDS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Friends:$errno: $error";
}
echo " <br />Deleting of user $deluser from table INTERESTS";
$dfs=mysql_query("DELETE FROM interests WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table INTERESTS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db); $delerr=1;
$errs.="<br />Interests:$errno: $error";
}
echo " <br />Deleting of user $deluser from table MAIL";
$dfs=mysql_query("DELETE FROM mail WHERE to_id='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table MAIL";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Mail:$errno: $error";
}
echo " <br />Deleting of user $deluser from table MSGS";
$dfs=mysql_query("DELETE FROM msgs WHERE to_id='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table MSGS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Msgs:$errno: $error";
}
echo " <br />Deleting of user $deluser from table PESTS";
$dfs=mysql_query("DELETE FROM pests WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table POSTS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Posts:$errno: $error";
}
echo " <br />Deleting of user $deluser from table POSTS";
$dfs=mysql_query("DELETE FROM posts WHERE author='$deluser'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table POSTS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Posts:$errno: $error";
}
echo " <br />Deleting of user $deluser from table STATS";
$dfs=mysql_query("DELETE FROM stats WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table STATS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db); $delerr=1;
$errs.="<br />Stats:$errno: $error";
}
echo " <br />Deleting of user $deluser from table THREADS";
$dfs=mysql_query("DELETE FROM threads WHERE thread_auth='$deluser'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table THREADS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Threads:$errno: $error";
}
echo " <br />Deleting of user $deluser from table TOPS";
$dfs=mysql_query("DELETE FROM tops WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table TOPS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Tops:$errno: $error";
}
echo " <br />Deleting of user $deluser from table VOTES";
$dfs=mysql_query("DELETE FROM votes WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table VOTES";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Votes:$errno: $error";
}
$errs.='</p>';
if(!($delerr)){ # stats,bio,interests did not result in an error (may be expanded to more)
echo " <br />Deleting of user $deluser from table USERS";
$dfs=mysql_query("DELETE FROM users WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
echo " <br />Deletion of user $deluser complete.</p>\n$errs";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db); $delerr=1;
echo "<br />Users:$errno: $error</p>\n$errs";
}
}else{ // something is wrong
echo " <br />Deletion of user $deluser encountered errors. uid=$todel username=$deluser";
echo " </p>\n$errs";
}
}else{ // we made a mistake
$errno=mysql_errno($db); $error=mysql_error($db); // what's wrong
$err="<p>query: SELECT uid,email FROM users WHERE username='$deluser'<br />$errno:$error</p>";
echo $err; // tell admin what went wrong
}
}
echo <<<END
<form action="$_SERVER[PHP_SELF]" method="POST" style="margin:0">
<input type="hidden" name="fn" value="delu">
<input type="hidden" name="action" value="delete">
$tsnw
<tr><td><u>User Name</u></td><td><u>Reason</u></td><td>User Deletion</td></tr>
<tr>
<td><input type="text" name="deluser" size="15" maxlength="15"></td>
<td><input type="text" name="reason" size="15"></td>
<td><input type="submit" value="Delete!"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
END;
}
}