Ability to access fields via mysql?

werufm · Joined: 27 Mar 2008 Posts: 36

Hi there,

Our station is in need of a community calendar, and so far Thyme is perfect. One thing we want is for a shortened description of an event that anyone posts to be able to be accessed for our programmers on air. An example:

A user submits an event. They fill out the date, time, location, name of event, contact info, and description.

Is there any way to get everything except the description to show on the calendar? Say in the week view? The programmers can't be reading a lengthy description, nor do we have the time as staff to be able to edit every lengthy event that comes in.

Just curious if that can be done.

Thanks!

esoft_ian · Joined: 12 Sep 2005 Posts: 5188

Hi,

I'm sorry, but there is no setting for this.

werufm · Joined: 27 Mar 2008 Posts: 36

Thanks. Is the information from the calendar stored in an sql database?

esoft_ian · Joined: 12 Sep 2005 Posts: 5188

Hi,

Yes. All the event information is stored in the thyme_Events table.

werufm · Joined: 27 Mar 2008 Posts: 36

Ok awesome. I'll just pull the info from that. Thanks

werufm · Joined: 27 Mar 2008 Posts: 36

Hmm...maybe you can help me locate that table? I can't seem to find it.

Thanks

esoft_ian · Joined: 12 Sep 2005 Posts: 5188

Hi,

It should be in the same database as all of Thyme's other tables. Do you remember which database you installed Thyme in?

werufm · Joined: 27 Mar 2008 Posts: 36

Nope. Did I have to set one up for the trial version?

esoft_ian · Joined: 12 Sep 2005 Posts: 5188

Hi,

If Thyme is installed, it must be in a database somewhere. If you check the line containing _CAL_DBNAME_ in include/config.php inside of Thyme's folder, it should tell you which database Thyme is installed in.

werufm · Joined: 27 Mar 2008 Posts: 36

Weird. All that's in that file is:

<?php
?>

I've installed it and can use it. It's at www.tingull.com/WERU_Calendar

But no database or anything. Again, I'm usinga trial version right now, so that has nothing to do with it?

werufm · Joined: 27 Mar 2008 Posts: 36

Oops...guess it helps to not look at the local folder....found it.

Thanks!

werufm · Joined: 27 Mar 2008 Posts: 36

I've pulled data from the database and I'm trying to make sense of some things.

The starttime comes out with all these numers, 121xxxxxxx and I can't figure out the rhyme or reason to it. Any help is appreciated, as we need to be able to pull this data to our on air studio to be read.

Thanks for telling me how to figure out those numbers.

esoft_ian · Joined: 12 Sep 2005 Posts: 5188

Hi,

That is the timestamp in unix format or number of seconds since January 01 1970. If you are pulling this into PHP code, you can use the gmdate() function to translate it into a readable date.

Let me know if you have any questions at all.