Send email message for birthday - Let's do it

[hprod]

Dear Ayeka,
I'm really really grateful to you for ypur script!
I installed it and it is doing a good job.

I would like to ask you again for your help. Now, I received some bounced mails for those who have their mailboxes full or doesnt exist. And I realized that some of the ages are false, cause I obtain negative ages.
I would like to automatically delete these users from the YaBBSE database:
- Those who have false age. Less than 1 year old or more than 99 year
- Those whom I received bounced mails

Who can it be done automatically?

Thanks again!!!!!

[Ayeka]

I'm not sure of any way that you could automate removal of members based on bounced messages.

As for false ages, I could write a script that would check for members ages between the years of 1 and 99 and delete those that do not qualify.  Give me a bit of time though.

[Black Hawk]

Can somebody mod it?

[hprod]

Thanks a lot Ayeka!!

[Black Hawk]

Can somebody mod it?

Lol, did anybody listen?

[Ayeka]

Place this script in your board directory.
Run this from your browser, you can also use the scheduling agent to automate this process.  I named my copy delbadage.php

Make sure to change the following before running this!
include_once ("./path/settings.php");
$db_server = "server";
$db_user = "username";
$db_pass = "password";
$db_name = "yabbse";

Code Select Expand

<?phpinclude_once ("./path/settings.php");$db_server = "servername";$db_user = "username";$db_pass = "password";$db_name = "yabbse"; mysql_connect ($db_server, $db_user, $db_pass);mysql_select_db ($db_name);$request = mysql_query ("SELECT * FROM {$db_prefix}members;") or mysql_error();$counter = 0;while ($result = mysql_fetch_assoc ($request)){   $birthyear = substr ($result['birthdate'], 0, 4);   $currentyear = date ("Y", date ("U"));   if ($birthyear !='0000')   {      if ($currentyear - $birthyear <= 1)      {         $deleteArray[] = $result['memberName'];         $counter ++;      }      if ($currentyear - $birthyear > 99)      {         $deleteArray[] = $result['memberName'];         $counter ++;      }   }}for ($c = 0; $c < $counter; $c++){   $request2 = mysql_query ("DELETE FROM {$db_prefix}members WHERE '$deleteArray[$c]' = memberName;") or mysql_error();   echo $deleteArray[$c] . '<br>';}echo $counter . ' total users deleted from the system due to invalid birthdates.<br>';?>




I have tested this so I know it works.  Becareful when using this script as it DELETES from your database!!  This script will not affect any users that have not filled in their birthdates!