How do I delete members in "Users Awaiting Email Confirmation" via MySQL query

[freehtml]

How do I delete members in "Users Awaiting Email Confirmation" via MySQL query (using phpMyAdmin)

Because I don't want to delete them one by one, its too tedious.

What MySQL query do I issue to do it?

And what MySQL query to issue to delete zero post members via phpMyAdmin also>

[JulianD]

Admin CP > Users > Move/Prune

[freehtml]

Originally posted by JulianD
Admin CP > Users > Move/Prune

I had used vB for almost a year yet I am unaware of this great features .. LOL

[Jake Bunce]

looks like there are a lot of queries to completely remove a user. from the forum/admin/user.php file:

// ###################### Start Kill #######################

if ($HTTP_POST_VARS['action']=="kill") {

  $user=$DB_site->query_first("SELECT username FROM user WHERE userid='$userid'");
  $DB_site->query("UPDATE post SET username='".addslashes($user[username])."',userid=0 WHERE userid='$userid'");
  $DB_site->query("DELETE FROM user WHERE userid='$userid'");
  $DB_site->query("DELETE FROM userfield WHERE userid='$userid'");
  $DB_site->query("DELETE FROM access WHERE userid='$userid'");
  $DB_site->query("DELETE FROM calendar_events WHERE userid='$userid'");
  $DB_site->query("DELETE FROM customavatar WHERE userid='$userid'");
  $DB_site->query("DELETE FROM moderator WHERE userid='$userid'");
  $DB_site->query("DELETE FROM privatemessage WHERE userid='$userid'");
  $DB_site->query("DELETE FROM subscribeforum WHERE userid='$userid'");
  $DB_site->query("DELETE FROM subscribethread WHERE userid='$userid'");
  $DB_site->query("DELETE FROM session WHERE userid='$userid'");

  echo "<p>User deleted successfully</p>";

  $action="modify";
} 

there are your queries. i think this is the right section.

[jeremyalyea]

Admin CP > Users > Move/Prune

I wish I would have known that a long time ago. Thanks for your help!