is there a shortcode for birthdays? | Directory | Support

Support Forum

We use and recommend UK2 for hosting - get a month free

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register sp_MemberList Members

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
is there a shortcode for birthdays?
23rd September 2013
4:29 pm
Avatar
Member
Members
Forum Posts: 11
Member Since:
18th September 2013
sp_UserOfflineSmall Offline

Hi,

when checking the list of available shortcodes I did not find anything to display birthdays (neither in church_admin_frontend_directory () nor as a separate for e.g. upcoming birthdays for the next nn days)

Is there something planned?

Thanks

Martin

25th September 2013
3:49 pm
Avatar
Member
Members
Forum Posts: 11
Member Since:
18th September 2013
sp_UserOfflineSmall Offline

just sent a short script printing a table of names where the next birthday is only 'n' days away.

May be there is a chance to create a shortcut for it and integrate into the next build

Thanks
Martin

26th September 2013
9:46 am
Avatar
Admin
Forum Posts: 675
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

Thanks - I've modified it slightly to make it valid xhtml and turned it into a shortcode and widget!

Just uploaded 0.569 so should be available shortly!

If you are finding the plugin useful, please subscribe to the app - it's free for your congregation to use and only £9.99pm for a church subscription

26th September 2013
6:27 pm
Avatar
Member
Members
Forum Posts: 11
Member Since:
18th September 2013
sp_UserOfflineSmall Offline

made another small modification to take care of given member_type_id:
foreach($memb AS $key=>$value){if(ctype_digit($value)) $membsql[]='member_type_id='.$value;}
if(!empty($membsql)) {$memb_sql=' WHERE ('.implode(' || ',$membsql).')';}else{$memb_sql='';}

AS upcoming_days FROM '.CA_PEO_TBL.$memb_sql.

modified file alse sent

Thanks
Martin

28th September 2013
11:15 am
Avatar
Member
Members
Forum Posts: 11
Member Since:
18th September 2013
sp_UserOfflineSmall Offline

with v0.571 you made birthdays.php to create incorrect SQL syntax

line #10 looks like:
if(!empty($membsql)) {$memb_sql=' AND ('.implode(' || ',$membsql).')';}else{$memb_sql='';}

but it should be:
if(!empty($membsql)) {$memb_sql=' WHERE ('.implode(' || ',$membsql).')';}else{$memb_sql='';}

Thanks

Martin

28th September 2013
1:41 pm
Avatar
Admin
Forum Posts: 675
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

Thanks fixed for 0.572 just uploaded

If you are finding the plugin useful, please subscribe to the app - it's free for your congregation to use and only £9.99pm for a church subscription

Forum Timezone: Europe/London

Most Users Ever Online: 35

Currently Online:
2 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

David Z.: 76

Rich Cox: 60

Allen: 51

rrfranks: 40

Gavin: 35

Janeen: 23

365sussex: 21

ehout: 20

Jay Jones: 19

matta: 18

Member Stats:

Guest Posters: 39

Members: 362

Moderators: 0

Admins: 1

Forum Stats:

Groups: 4

Forums: 13

Topics: 431

Posts: 1628

Administrators: andymoyle: 675