Ok I will just post my whole script
The problem is this script is for terminating a users account on my site, it works fine generally but sometimes, if a user has to much data and it is run, it will output an error talking about it ran out of memory and kills the script at some point through it, How can I avoid this?
<?
require_once "config/functions.inc.php";
@extract($_POST);
if($_POST['cancelmyaccount']!=''){
validlogin($url);
// image security code
$string = strtoupper($_SESSION['string']);
$userstring = strtoupper($_POST['captcha']);
if (($string == $userstring) && (strlen($string) > 4))
{
$captcha1="";
// code verified, just continue working
}
else {
$captcha1="Enter right value of captcha";
$_SESSION['sess_msg']=$captcha1;
header("Location: index.php?action=cancelaccount&type=member&unid=$unid");
exit;
}
// end
$sql = "delete from friend_reg_user where auto_id='$info[auto_id]'";
executequery($sql);
// for account setting
$sql = "delete from friend_acc_setting where user_id='$info[auto_id]'";
executequery($sql);
// for Friend list
$sql = "delete from friend_friend where userid='$info[auto_id]' or friendid='$info[auto_id]'";
executequery($sql);
// for image deletion
$sql = "select photo_name from friend_user_photo where userid='$info[auto_id]'";
$result=executequery($sql);
while($line=mysql_fetch_array($result)) {
$photo_name=$line[photo_name];
$file="../uploded_files/userphoto/".$photo_name;
if(file_exists($file)){
$fil_ext1 = pathinfo($photo_name);
$fil_ext = $fil_ext1["extension"];
$fil_explode='.'.$fil_ext;
$arr=explode($fil_explode,$photo_name);
$pic1=$arr[0]."_thumb".$fil_explode;
$pic2=$arr[0]."_thumb1".$fil_explode;
@unlink("../uploded_files/userphoto/".$photo_name);
@unlink("../uploded_files/userphoto/".$pic1);
@unlink("../uploded_files/userphoto/".$pic2);
}
}
$sql = "delete from friend_user_photo where userid='$info[auto_id]'";
executequery($sql);
// for Blocked list
$sql = "delete from friend_blockuser where user_id='$info[auto_id]' or block_user='$info[auto_id]'";
executequery($sql);
// for Blog table
$sql="select * from friend_blog where userid='$info[auto_id]'";
$result_blog=executequery($sql);
while($line_blog=mysql_fetch_array($result_blog)){
$sql = "delete from friend_blog_comment where blogid='$line_blog[autoid]'";
executequery($sql);
}
$sql = "delete from friend_blog where userid='$info[auto_id]'";
executequery($sql);
$sql = "delete from friend_blog_comment where userid='$info[auto_id]'";
executequery($sql);
$sql = "delete from friend_blog_subscrib where userid='$info[auto_id]' or subsuserid='$info[auto_id]'";
executequery($sql);
// for Bulletin table
$sql = "delete from friend_bulletin where user_id='$info[auto_id]'";
executequery($sql);
// for Classified table
$sql = "delete from friend_classified_itemmaster where user_id='$info[auto_id]'";
executequery($sql);
// for group
$sql=" select * from friend_create_group where user_id='$info[auto_id]'";
$result_group=executequery($sql);
while($line_group=mysql_fetch_array($result_group)){
$sql = "delete from friend_group_bulletin where group_id='$line_group[auto_id]'";
executequery($sql);
$sql = "delete from friend_group_picture where groupid='$line_group[auto_id]'";
executequery($sql);
$sql = "delete from friend_group_request where groupid='$line_group[auto_id]'";
executequery($sql);
}
$sql = "delete from friend_group_request where userid='$info[auto_id]' or friendid='$info[auto_id]'";
executequery($sql);
$sql = "delete from friend_group_bulletin where user_id='$info[auto_id]'";
executequery($sql);
$sql = "delete from friend_create_group where user_id='$info[auto_id]'";
executequery($sql);
$arr[]=$info[auto_id];
foreach($arr as $ind=>$val){
$groupuserid1=$val.",";
$groupuserid2=",".$val.",";
$groupuserid3=",".$val;
$sql="select * from friend_create_group where member_ids like '$groupuserid1%' or member_ids like '%$groupuserid2%' or member_ids like '$groupuserid3' or member_ids='$val' or req_memberids like '$groupuserid1%' or req_memberids like '%$groupuserid2%' or req_memberids like '%$groupuserid3' or req_memberids='$val'";
$result_group_mem=executequery($sql);
while($line_group_mem=mysql_fetch_array($result_group_mem)){
if($line_group_mem[member_ids]!=''){
$alreadymember=explode(",",$line_group_mem[member_ids]);
if(in_array($val, $alreadymember)){
foreach($alreadymember as $ind1=>$val1){
if($val1!=$val){
$alreadymember_temp[]=$val1;
}
}
}
} //endif
// for required member
if($line_group_mem[req_memberids]!=''){
$req_alreadymember=explode(",",$line_group_mem[req_memberids]);
if(in_array($val, $req_alreadymember)){
foreach($req_alreadymember as $ind1=>$val1){
if($val1!=$val){
$req_alreadymember_temp[]=$val1;
}
}
}
} //endif
$alreadymember=implode(",",$alreadymember_temp);
$req_alreadymember=implode(",",$req_alreadymember_temp);
// end required member
$sql="update friend_create_group set member_ids='$alreadymember', req_memberids='$req_alreadymember' where auto_id='$line_group_mem[auto_id]'";
executequery($sql);
} // end while
} // foreach
// $sql="select * from friend_create_group where ";
// for invitation to join site
$sql = "delete from friend_invitation where userid='$info[auto_id]'";
executequery($sql);
// for internel mail setting
$sql="select * from friend_mail_details where to_user='$info[auto_id]' or from_user='$info[auto_id]'";
$result_mail=executequery($sql);
while($line_mail=mysql_fetch_array($result_mail)){
$sql = "delete from friend_mail_setting where mail_id='$line_mail[auto_id]'";
executequery($sql);
}
$sql = "delete from friend_mail_setting where user_id='$info[auto_id]'";
executequery($sql);
$sql="delete from friend_mail_details where to_user='$info[auto_id]' or from_user='$info[auto_id]'";
executequery($sql);
// for votes
$sql = "delete from friend_vote where id='$info[auto_id]'";
executequery($sql);
// for event
$sql="select * from friend_event where userid='$info[auto_id]'";
$result=executeQuery($sql);
while($line=mysql_fetch_array($result)){
$sql_delete_invite="delete from friend_eventinvites where EventId='$line[autoid]'";
executeQuery($sql_delete_invite);
$sql_delete_comment="delete from friend_event_comment where event_id='$line[autoid]'";
executeQuery($sql_delete_comment);
}
$sql_delete="delete from friend_event where userid='$info[auto_id]'";
executeQuery($sql_delete);
$msg = "Your Account has Deleted Successfully!" ;
}
$_SESSION['sess_msg'] = $msg;
session_destroy();
header("Location: index.php");
exit;
?>
