Mass Deletion of Users...

is this possible?
So you could delete all users with 0 or 0-3 etc posts...
i really need this..

<?

require("admin/config.php");

if($action=="") {

    print("<form action=\"delete.php\" method=\"post\"><input type=\"hidden\" name=\"action\" value=\"deleteusers\"><p>Delete users with less than <input type=\"text\" size=\"5\" name=\"numberposts\"> posts.</p><p><input type=\"submit\" value=\"DELETE USERS\"></form>");
}

if($action==deleteusers) {

    $query = mysql_query("DELETE from USER where POSTS < '$numberposts'");

    print("You have successfully deleted all users with less than $numberposts posts.")
}
?>

Put that into a file called delete.php and stick it in your forums directory. There is no error checking in it or anything like that, but it should do the basic thing you're looking for.

HTH, or at least sets you in the right direction.

-jim

thanks alot

it doesn't work..
i pu it in the /admin directory and changed

require("admin/config.php");

to

require("config.php");

does it matter anything what directory it's in?

Jim, you forgot to connect to MySQL.

[code]<?php

require("global.php");

if($action=="") {

print("<form action=\"delete.php\" method=\"post\"><input type=\"hidden\" name=\"action\" value=\"deleteusers\"><p>Delete users with less than <input type=\"text\" size=\"5\" name=\"numberposts\"> posts.</p><p><input type=\"submit\" value=\"DELETE USERS\"></form>");
}

if($action==deleteusers) {

$DB_site->query("DELETE FROM user WHERE posts < '$numberposts'");

print("You have successfully deleted all users with less than $numberposts posts.")
}
?>

Originally posted by Ed Sullivan
Jim, you forgot to connect to MySQL.

Yeah I realized that - was just coming back to fix.

-jim

can you please post the whole text for delete.php ?!

PLEASE!!!!

this is the code:

<?php 

require("global.php"); 

if($action=="") { 

print("<form action=\"delete.php\" method=\"post\"><input type=\"hidden\" name=\"action\" value=\"deleteusers\"><p>Delete users with less than <input type=\"text\" size=\"5\" name=\"numberposts\"> posts.</p><p><input type=\"submit\" value=\"DELETE USERS\"></form>"); 
} 

if($action==deleteusers) { 

$DB_site->query("DELETE FROM user WHERE posts < '$numberposts'"); 

print("You have successfully deleted all users with less than $numberposts posts.") 
} 
?>

i've tried that but it doesn't work~~~~

The quick way:

Just run this query in PHPMyAdmin:

DELETE FROM user WHERE posts < 4

or whatever number of posts you like.