RSform and DBirthdays?

DBirthdays module (mod_dbirthdays) shows nearest birthdays (future or past) of your site users.

RSform and DBirthdays?

Postby torch » Thu May 20, 2010 2:14 am

The DBirthdays module is unique and a great contribution. Thanks for making it available.

Pardon my asking, but it it possible that the DBirthdays Joomla module can work from a RSForm!Pro data file?

I also created two text inputs into an RSform!Pro form (birth_month in ‘F’ format and birth_date in ‘d’ format) so that people would not have to give their age. Now I am too ignorant to know how to get a list of those people with a recent birthday from the RSForm data.
Thanks for considering my problem.

torch
 
Posts: 4
Joined: Thu May 20, 2010 2:09 am

Re: RSform and DBirthdays?

Postby Darkick » Thu May 20, 2010 4:25 am

It's hard to me to answer so I didn't use RSForm. But several months ago I helped a man to configure this Birthdays module and RSForm, unfortunately I could not find this information now :(

At first, you don't need to use two separate fields for date, because you can configure date output format to hide age and years.
Can you post table structure (screenshot from phpMyAdmin, for example)?

Darkick
 
Posts: 204
Joined: Fri Sep 04, 2009 10:16 pm
Location: Russia, Ekaterinburg

Re: RSform and DBirthdays?

Postby torch » Fri May 21, 2010 3:23 am

Thanks so much for trying to help! I really appreciate it. Here's the Php structures from a screen shot.
Thanks again,
David
Project1.gif

torch
 
Posts: 4
Joined: Thu May 20, 2010 2:09 am

Re: RSform and DBirthdays?

Postby Darkick » Fri May 21, 2010 4:13 am

I am afraid there is no way to get date from two fields/rows for this module (at least in this version) :(. The best way is to use for date any standard DATE type.

Darkick
 
Posts: 204
Joined: Fri Sep 04, 2009 10:16 pm
Location: Russia, Ekaterinburg

Re: RSform and DBirthdays?

Postby torch » Fri May 21, 2010 4:47 am

Thanks for trying. If I add a DATE field named "birthdate", could you guide me by telling me the parameters to enter for RSForm?
Thanks again,
David

torch
 
Posts: 4
Joined: Thu May 20, 2010 2:09 am

Re: RSform and DBirthdays?

Postby Darkick » Fri May 21, 2010 5:29 am

Ok. I tried to write configuration for this case (with field birthdate). But there is another bad news: we can't get name of the user from jos_rsform_submission_values table (LastName and FirstName :( ). Only, we can get Username of the form poster from jos_rsform_submissions table. You can try this, but I am afraid it's not exactly you want. Sorry :(

Table Birthdays settings
  • Table Birthdays: #__rsform_submission_values
  • Field "Birthday": FieldValue
  • Field of Identificator: SubmissionId

Table Users settings
  • Table Users: #__rsform_submissions
  • Field of Identificator: SubmissionId
  • Field "Name": Username
  • WHERE condition: b.FieldName = 'birthdate'

Darkick
 
Posts: 204
Joined: Fri Sep 04, 2009 10:16 pm
Location: Russia, Ekaterinburg

Re: RSform and DBirthdays?

Postby torch » Fri May 21, 2010 6:50 am

You got me started - THANK YOU!

torch
 
Posts: 4
Joined: Thu May 20, 2010 2:09 am


Return to DBirthdays

Who is online

Users browsing this forum: No registered users and 1 guest