Delete non-activated users script

Try this: http://www.php-fusion.co.uk/infusions...ddon_id=98

I think that you are asking to Delete which Members are not Activated their Accounts through E-Mails. Am I right ?

This is a Simple Script.

But, Please Don't make it Public ! Its for personal use only... Delete after Use or make password protection

Save this file as a PHP file(whatever name) and run it in browser :

[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]<?php
if($_POST['areyousure'] == 'yes' || $_POST['areyousure'] == 'YES' || $_POST['areyousure'] == 'Yes'
{
require_once "maincore.php";
$deleteall = dbquery("DELETE FROM ".DB_NEW_USERS."";
echo "<h2>All Non Activated Members Deleted Successfully </h2>";
}
else
{
require_once "maincore.php";
$result = dbquery("SELECT * FROM ".DB_NEW_USERS."";
echo "<form method='post' action='".$_SERVER['PHP_SELF']."'>
<h2>Do you really want to Delete All UnActivated Members ? :-o</h2>
For Security Check, Please Enter Yes in the Box : <input type='text' name='areyousure' />
</form>";
echo "<b>Members E-Mail which are Currently Not Activated</b><br />";
while($data = dbarray($result))
{
echo "<u>";
echo $data['user_email'];
echo "</u><br />";
}
}
?>[/syntaxhighlighter]

You can simply truncate the database table PREFIX_new_users...

Hi again.
I have no data in new_users.

I want do delete all users where user_status = 2

Can someone change the code from Akur so it fits my needs :-)

Thanks alot for your help

Yeah !

@jannik : The script is doing what Marcus said....



Ok ! But when you will use this Code first time, please check whether the E-Mails showing below are correect/Non-Activated?
Because I've tested the script given on above post, but not this one I am giving... So Please Be Sure to use this script as I don't want anyone to loose their data

[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]<?php
if($_POST['areyousure'] == 'yes' || $_POST['areyousure'] == 'YES' || $_POST['areyousure'] == 'Yes'
{
require_once "maincore.php";
$deleteall = dbquery("DELETE FROM ".DB_USERS." WHERE user_status='2'";
echo "<h2>All Non Activated Members Deleted Successfully </h2>";
}
else
{
require_once "maincore.php";
$result = dbquery("SELECT user_email FROM ".DB_USERS." WHERE user_status='2'";
echo "<form method='post' action='".$_SERVER['PHP_SELF']."'>
<h2>Do you really want to Delete All UnActivated Members ? :-o</h2>
For Security Check, Please Enter Yes in the Box : <input type='text' name='areyousure' />
</form>";
echo "<b>Members E-Mail which are Currently Not Activated</b>";
while($data = dbarray($result))
{
echo "<u>";
echo $data['user_email'];
echo "</u>";
}
}
?>[/syntaxhighlighter]

Hi Ankur. Thanks for your script, and sorry for my late respons.

When I write Yes I just is sent to index.php and nothing is being deleted from the DB, so all the members is still there...

do you know what is wrong?

regards
Jannik

How are you using this file ? In a different php file ? or added as a custom page ?

I've tested the same code 2 times and it worked fine for me ! There doesn't seem to be a logical r syntax error from my side ! you may Try again B) !