Remove all unactive members from database

Name: Remove all unactive members from database
Author: Diablosblizz

Nothing much here, just copy and paste this into a file!

I called it remove.php, but you can call it what you want:

PHP Code

<?php
session_start();
include "config.php"; // gets the config file to connect to database 
if($logged[userlevel] == 6) { // checks if the users level is 6 and if they are logged in
switch ($_GET['remove']) {
default:
echo "<center>Would you like to remove the unactive members in the database?<BR><a href='?remove=yes'>Yes</a> | <a href='?remove=no'>No</a>"; // asking if you want to remove them, yes or no
break;
 
case yes:
$remove = mysql_query("DELETE FROM `members` WHERE `userlevel` = '1'"); // removes them from database
echo "All the unactive members have been removed from the database!"; // hey! it worked! :D
break;
 
case no:
echo "You can leave this page and go back to your site."; // if you said no you get this! :O
break;
}
} else {
	echo "You are not logged in, or you are not a admin."; // you are not logged in / an admin. :)
}
// THE END!!!!! :D
?>

Simple enough! Enjoy!

Author:

Diablosblizz

Views:

3,229

Rating:

Posted on Wednesday 25^th June 2008 at 03:49 PM

DanielXP

user level is really it sets from 1 (not verified) to 2 (what is)

Posted on Monday 23^rd June 2008 at 05:28 PM

ilyas-shezad
ilyas-shezad's Avatar

nice script.
theres an easier way to do this though.

After activation a users Userlevel is set to 1 from 0. all those that are not activated will be deleted at userlevel 0.

Posted on Friday 18^th January 2008 at 12:51 AM

ShadowMage
ShadowMage's Avatar

haha yeah. that's why after a set amount of time you could make a different level to delete.

Posted on Thursday 17^th January 2008 at 03:45 PM

Thomas

Wouldn't this just delete all the users with a ;evel of one from the database? O_o

Posted on Saturday 28^th July 2007 at 02:29 PM

Diablosblizz
Diablosblizz's Avatar

Pretty easy, but thanks! :)

Posted on Friday 27^th July 2007 at 09:00 PM

SkillMaster
SkillMaster's Avatar

Thats a nice script. :)