Calendar & Date field

Hi Ted,

Yes, we have a date field that pops up a calendar when you click on it. Create a field of Post Metadata that uses a control of type Date. We support a variety of formats for the date as well.

We don’t have restrictions on it, though. That’s something we can consider for future releases, but it’s not available today.

If i would like a make CRON to create .ics

Could you give my an exemple to make a SELECT ? To get my Date with Business Directory ?

Thanks,

Ted

Hi Ted,

I’m not sure I fully understand what you’re asking here.

Sounds like you want a cron job to create ICS files for something…but what? And when?

I’m not sure what example you’re looking for when you say “Could you give my an exemple to make a SELECT ? To get my Date with Business Directory”. Creating the date field is easy–that’s just going under Directory Admin->Manage Form Fields. The documentation covers that here: https://businessdirectoryplugin.com/docs/#admin-form-fields

But I suspect you’re looking to do something way more substantial here…can you please explain? (I suspect you’ll have to customize things to make that work)

Yes, i want to create a .ics with a CRON every night.
With this export you can sync with google calendar.

Indeed, i can use an another plug in to make a calendar with google.

If some-one need to SELECT on DB just follow the relational DB Concepts :

SELECT meta_value FROM wp_postmeta WHERE meta_key LIKE ‘_wpbdp[fields][numberofyourfield]’

You can make it by listing :

SELECT * FROM wp_posts WHERE ID LIKE ‘numberofyourpostID’

SELECT * FROM wp_postmeta WHERE post_id LIKE ‘numberofyourpostID’

Hi tederic,

BD listings are just custom post type in WordPress of type “wpbdp_listing”, so you can query the wp_posts table for that type to get the listings of just BD. If you want the data for that one field, you can further select it down by meta_key as you mentioned above.