Auto Email/PM for Birthday Greetings Hack. Are you interested?

[c-pr0mpt]

I tested this today on my beta board. The install was quick and painless, and after that I set my birthday to June 5th. My internet has been off and on today and I just now finally got back online (1:30am) and I had the PM and the email waiting for me.

So as far as I can see, there are no problems off the bat. Wonderful hack and I thank you muchos for it!

[Dean C]

i would love to test this now... i have my sql queries working again !!!

rapstar10@hotmail.com !!

[Boofo]

Please read post# 39 above. It will be released shortly.

Originally posted by Mist
i would love to test this too !

rapstar10@hotmail.com !!

[Logician]

Originally posted by Me2Be
Would it be too difficult to add an option where you can specify how recently a user has visited? I don't think members who haven't visited in, let's say, six months will be coming back to the boards (at least on our site!)

@Me2Be: If what you are suggesting is to send greetings to only users who have visited the board in the last X days/months, yes this can be achievable. However I'm not very keen to integrate this feature to the hack, because after every integration I need to test it more to debug and this testing time already took too long

However after I release the hack, remind me you want this feature and without officially integrating it as a default feature, I'll give you the code you can modify yourself to have it.

But if I were you I would choose to send emails (instead of PMs) with this hack and this would help your "missing" members to remind you and get them back to your board.

@Mist: Thx for your help, but I will release it very soon..

Regards,
Logician

[Boofo]

I'd be interested in getting that code also.

Originally posted by Logician

@Me2Be: If what you are suggesting is to send greetings to only users who have visited the board in the last X days/months, yes this can be achievable. However I'm not very keen to integrate this feature to the hack, because after every integration I need to test it more to debug and this testing time already took too long

However after I release the hack, remind me you want this feature and without officially integrating it as a default feature, I'll give you the code you can modify yourself to have it.

But if I were you I would choose to send emails (instead of PMs) with this hack and this would help your "missing" members to remind you and get them back to your board.

@Mist: Thx for your help, but I will release it very soon..

Regards,
Logician

[Highlander]

okay logician..i installed it..and all seems to bee good..now i will have wait two days..till the next members got birthday..and then 4 of my members should get an email and PM....if something should be tested ..tell me i will do..

[Highlander]

my board version is 2.2.5 and portal runnin..also i have several hacks installed nd your webtemplates..(i lov them..) ..maybe i will install the unsubscribe hack..it might be useful too

[Boofo]

The Unsubscribe hack is one of the best out there. It works great! I wouldn't want to run a board without it.

Originally posted by Highlander
my board version is 2.2.5 and portal runnin..also i have several hacks installed nd your webtemplates..(i lov them..) ..maybe i will install the unsubscribe hack..it might be useful too

[c-pr0mpt]

I was installing on another board and ran into a weird problem at the query process. I did the queries just as the install says, then when I run.

SELECT leftdate from timetick where action='birthday';

I just get

Error 
SQL-query: 

SELECT leftdate from timetick where action='birthday';
MySQL said:

Mysql doesn't say anything. But when I browse the table timetick its all there...sshot attached.

What am I doing wrong with the queries? Please cure my confusion.

[Logician]

Originally posted by c-pr0mpt
I was installing on another board and ran into a weird problem at the query process. I did the queries just as the install says, then when I run.

yep it's weird. For one thing there cant be anything wrong with the queries: These are very simple and basic queries and their syntax are correct. Besides they run correctly in all beta testers' board. I suspect something got wrong when you run the query: Maybe a corrupt table or smt.

I suggest deleting this table (timetick) from your db and start from the begining (maybe you should use "logician_query" file to run them).

Please let me know afterwards, thank you..

Logician