Invalid mail > move user to another group
 

]Heypeople.

Well... I got a forum with about 40000 users, we just moved a server and I mailed all users at once from ACP with new URL. Some of the users had invalid mails (not existed or full etc)... So server have been under heavy load in about a day or so. :speechless:

Anyway. I collected all mails from ACP in format of

mail1@domain1.com
mail2@domain2.com
etc

imported it into Advanced Email Verifier and let it run by night. I found out that over 3000 mails were bad.

Now, I don't really want to delete those users and as you understand I can't do it for all 3000 users manually :(


I thought if it was possible to create a small 1 function PHP file which will simply go throught the txt file with mals (looping it), search for a member with that mail, move him to group called "Awaiting e-mail confirmation" and unsubscribe him from everything he's subscribed to. Script should check usergroup (if admin or mod then take next mail).

I had same problem with this some months ago or so, but I haven't found any solutions. If any of you could help me out in this subject, I would greatly appreciate it.

With best regards wooolF[RM]

*p00p*

]let's try again... :(

What version is your vBulletin? Since scripting for vB2 is different than vB3.

]2.2.6 ( i know I should have updated, but because of some hacks etc (as attachments as files) I can't do it and I think I will upgrade to clean vbb 3.x when it's out as RC )

anyway, I thought of this hack as just single php file that loads all settings from config in the admin folder, loops throught txt file with invalid mails and queries the database with relevant actions. I dont know if there are any difference between vbb 2.x and 3.x yet as I haven't tried it yet, sorry :p

Thanx for replie by the way :)

And one more thing - I think of this hack as one of the major problems for all boards (especially with a lot of users). More invalid users = more load for whole server etc...

Regards

/me pokes Velocd :x

:\

Here you go.. Put it under you admin dir and run it..

Apply to a test board first.. It is not tested!

] Thanx for the try Logician. Apreciatted. Thought I have looked at source file and it doesn't meet the requirements at all (sorry to say so) :(...

Idea was to read *not responding* mails from a txt file and that php file doesn't even look at it >_<

Please try reread 1st posy...

Best Regards, wooolF[RM]

*bump* :x