is there a shortcode for birthdays?

About › Support › Directory › is there a shortcode for birthdays?

  • This topic is empty.
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • 23rd September 2013 at 4:29 pm #2525
    Avatar for mkirchhoefermkirchhoefer
    Member

    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 at 3:49 pm #3240
    Avatar for mkirchhoefermkirchhoefer
    Member

    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 at 9:46 am #3241
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    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!

    26th September 2013 at 6:27 pm #3242
    Avatar for mkirchhoefermkirchhoefer
    Member

    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 at 11:15 am #3243
    Avatar for mkirchhoefermkirchhoefer
    Member

    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 at 1:41 pm #3244
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    Thanks fixed for 0.572 just uploaded

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.