request : mass delete for users have 0 posts

how ?

make a hack for me :D

<?php

require("global.php");

$DB_site->query("DELETE from user where POSTS = 0");
echo ("Worthless 0 Postin' users NUKED");

?>

// Paste this to a file, such as delete.php
// Upload it to your server in your vB directory and
// open it in your browser.

thank you :)
it worked

echo ("Worthless 0 Postin' users NUKED");


LOL! Gotta love it :D

~Chris

Can you add a parameter so that I can delete users with 0 posts that joined more than, say, two months ago?

Originally posted by Troy Roberts
Can you add a parameter so that I can delete users with 0 posts that joined more than, say, two months ago?

Sure thats simple enough

<?php

require("global.php");

$DB_site->query("DELETE from user WHERE POSTS = 0 AND joindate<UNIX_TIMESTAMP('2000-02-01')");
echo ("Worthless 0 Postin' users NUKED");


?>


That will delete users that have 0 posts and have registered before february 1st, 2000 (2000-02-01) the date is in yyyy-mm-dd format so be carefull with it!

BACKUP ALL DATA BEFORE EVER ATTEMPTING TO MANUALLY DELETE FROM YOUR DATABASE!!!!!!!!!!

~Chris

Thank you. I'll give it a try.