This script is for vBulletin
I have a list of email addresses in a text file.
Each email address is listed on a separate line. ie:
email (at) hotma1l.com
hotma1l (at) yah0o.com
yah0o (at) gma1l.com
gma1l (at) a0l.com
I need a php script which when run will:
a) match each email address with a userid (each email address may only have one userid) ie:
select from userid from user where email = gma1l (at) a0l.com
b) take the userid and automatically run these 5 queries:
DELETE FROM subscribethread WHERE userid = ######
DELETE FROM subscribeforum WHERE userid = ######
DELETE FROM subscribeevent WHERE userid = ######
DELETE FROM subscribegroup WHERE userid = ######
DELETE FROM subscribediscussion WHERE userid = ######
I should be able to run the script like this:
name_of_script.php name_of_file.txt
The script should be smart enough to skip email addresses that don’t have a matching userid (ie don’t run delete from subscrbeforum where userid = ”;)
The script should also have an area at the top where I can specify the mysql connect parameters.
