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


<?php

include_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!