490337 Search for ids and then run queries for vBulletin

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) [url removed, login to view]

hotma1l (at) [url removed, login to view]

yah0o (at) [url removed, login to view]

gma1l (at) [url removed, login to view]

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) [url removed, login to view]

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:

[url removed, login to view] [url removed, login to view]

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.

Beceriler: Her şey Kabul, MySQL, PHP, vBulletin

Daha fazlasını gör: search match, run, queries, vbulletin php mysql, vbulletin connect, skip list, script php vbulletin, vbulletin delete user, vbulletin vbulletin connect, vbulletin mysql queries, php script vbulletin, php text search, vbulletin script, matching mysql script, search email addresses, php mysql address search, mysql search address, email address search, vbulletin mysql, vbulletin php script, need ids, search address, address search, vbulletin search php, search text file php

İşveren Hakkında:
( 2 değerlendirme ) Canada

Proje NO: #2236248



Ready script can give for test

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(17 Değerlendirme)