239117 Custom Jobs Fixes i) and ii)

There are 2 tasks here to be performed, namely a) and b) below: a)DELETE FROM 2 & not 1 TABLE There are codes written on my website to ensure that once emails sent are bounced back, the username associated with the bounced email id is queried from the database and immediately deleted. This is all fine. But there is another table with a specific table which tells the site to send out a particular email template to ALL members in that table regularly, and as you can guess: THE CORRESPONDING USERNAME from this other table is not SIMULTANEOUSLY DELETED. This cause emails to be sent out WITH NO RECIPIENT EMAIL ADDRESSES, as a result. So, the job here: to ensure that records of the same member are deleted from BOTH tables simultaneously and not just 1 table, ie. for the deletion of member from the database to be done SIMULTANEOUSLY to the current table PLUS: the member's record from the OTHER TABLE which contains the frequency to send out an email to each particular member. (Otherwise, there will be emails sent out with NO recipient email addresses) b) Ensure Email Sent Meets 2 'If' Conditions There is a certain email template which, driven by a cron job, is sent out to members on my social networking site periodically, ie. once per day for most members, but for some members weekly (ie. only once per week). I would like to temporarily stop the sending of anymore emails by you entering just a few lines of simple code to stop it for the moment. In addition, please enter a few more lines of code such that when I remove this temporary stoppage, the email will get sent out as usual, but additionally meeting 2 'IF' conditions: i) If member on my site has verified his membership by email, and ii) If member's profile has been approved by admin before. For i) and ii), there are already variables with stored values on my site that already differentiate whether a member is verified or non-verified after his registration. Status code=2 verified. Status code1=non-verified. Pretty straightforward !!!