ucast.upm.edu.my ~ Shell I

Editing file /var/www/closeaccount.php (0775)

<?php

///////////////////////////////////////////////////////////////////////////////////////
// PHPmotion                                                http://www.phpmotion.com //
///////////////////////////////////////////////////////////////////////////////////////
// License: You are not to sell or distribute this software without permission       //
// Main Author: Brian Shawa -  bshawa@gmail.com                                      //
// Help and support please visit http://www.phpmotion.com                            //
// Copyright reserved                                                                //
///////////////////////////////////////////////////////////////////////////////////////

include_once("classes/config.php");
include_once('classes/login_check.php');
include_once('classes/menu.php') ;
include_once ('classes/sessions.php');
include_once("inc_mypicture.php");

//check if delete users has been pressed
    if ($_POST['submitted'] == 'yes') {

//===============================reusable delete member code============================
            $user_id = mysql_real_escape_string($user_id);
            //delete member profile
            $sql = "DELETE FROM member_profile WHERE user_id = $user_id";
            @mysql_query($sql);

//update videos by member (deleted) [NOTE: actual videos will be deleted on "server maintanance", i.e. all marked as pendingdelete]
            $sql = "UPDATE videos SET approved ='pendingdelete' WHERE user_id = $user_id";
            @mysql_query($sql);

//delete group videos by member (deleted)
            $sql = "DELETE FROM group_videos WHERE member_id = $user_id";
            @mysql_query($sql);

//delete group membership
            $sql = "DELETE FROM group_membership WHERE member_id = $user_id";
            @mysql_query($sql);

//delete from group_comments
            $sql = "DELETE FROM group_comments WHERE by_id = $user_id";
            @mysql_query($sql);

//delete from pictures
            $sql = "DELETE FROM pictures WHERE user_id = $user_id";
            @mysql_query($sql);

//delete from friends part 1
            $sql = "DELETE FROM friends WHERE user_id = $user_id";
            @mysql_query($sql);

//delete from friends part 2
            $sql = "DELETE FROM friends WHERE friends_id = $user_id";
            @mysql_query($sql);

//delete from flagging_comments
            $sql = "DELETE FROM flagging_comments WHERE user_id = $user_id";
            @mysql_query($sql);

//delete from favorites
            $sql = "DELETE FROM favorites WHERE WHERE owner_id = $user_id";
            @mysql_query($sql);

//delete from flagging
            $sql = "DELETE FROM flagging WHERE user_id = $user_id";
            @mysql_query($sql);

//delete from privacy
            $sql = "DELETE FROM privacy WHERE user_id = $user_id";
            @mysql_query($sql);

//delete from videocomments
            $sql = "DELETE FROM videocomments WHERE by_id = $user_id";
            @mysql_query($sql);

//delete entire groups i manage
            $sql = "DELETE FROM group_profile WHERE admin_id = $user_id";
            @mysql_query($sql);
            //===============================end of reusable============================
         @header("Location: " . "login.php"); //redirect to Myaccount page
 
    }

//////////////////////////////////
//displaying main page
//////////////////////////////////
$template = "templates/main_1.htm";
$inner_template1 = "templates/inner_myaccount_close.htm"; //middle of page
$TBS = new clsTinyButStrong ;
$TBS->NoErr = true; // no more error message displayed.
$TBS->LoadTemplate("$template") ;
$TBS->Render = TBS_OUTPUT;
$TBS->Show();
@mysql_close();
die();