Auto send a greeting PM/Email to Birthday members daily?

[Byron]

Do we have a hack to auto send a greeting PM/Email to Birthday members daily?

If we do not have a hack, does anyone knows how to do this?

Hope to have this feature in the next VB version.

Thanks
Byron

[merk]

I think this would involve running a Cronjob that hits a certain script once every day...

Not sure.

[orca]

Yep, this would in fact need a cronjob. However, I guess it would be easier to hack that the popup would appear if the user would visit the forum that day. May you could specify a time frame within the popup appears.

[Byron]

Personally, I would prefer an email to be send to each birthday member on each day. This will help to increase return traffic too.

[Rcooper]

I agree a birthdya message e-mailed would be a great way to "remind":rolleyes: then of your board! I would also be interested in this!

Ryan
:rolleyes:

[amykhar]

This code ( a real ugly piece of work) will do it BUT php won't run as a cronjob on my host.

I use a windows scheduler program to hit the script with my browser every day at Midnight.


<?php
require "global.php";

$today=date("-m-d");
$result = $DB_site->query("SELECT username, email FROM user WHERE birthday like '%$today'");
for ($m=0; $m < mysql_num_rows($result); $m++) {
list($username, $email) = mysql_fetch_row($result);
echo $username . "<br>";
$message = "Happy Birthday $username! Come celebrate your day at http://www.yourforums.com";
mail ($email,"Happy Birthday!",$message,"From: \"webmaster@yourforums.com\" <You>");
}

?>

[bargie]

i was working on this script a little while ago, i need one more bit of code, can any one tell me what i would need to code this

Store todays date (Day and month) in a table (all-ready set the table up)
Check that the date isn't todays

i have got this so far
$today = date("m-d");

$ecardcheck=$DB_site->query("SELECT date FROM ecard");

if ($ecardcheck=$today) {

$DB_site->query("UPDATE ecard SET date='$today'");

there is alot of other code but this is what i need to know
anyone help
i will release the hack when i know this.

jamie

[M.C.]

xm.... i need that hack too, but i don`t know PHP :( so... i just lift up topic! ;)

[JulianD]

https://vborg.vbsupport.ru/showthread.php?s=&threadid=39663&highlight=birthday+greeting


Use the search tool next time :p

[Logician]

Originally posted by orca
Yep, this would in fact need a cronjob.
The referred hack can be used even if your hosting company does not give you cron job feature. It simulates cron in itself so will work even though you dont have cron jobs..

I planned to revise and enhance this cron simulation feature on its own but noticed that vb3 will integrated the feature by default so dropped the project..