PDA

View Full Version : MySQL Tables - Preview?


rolevine
07-09-2005, 06:50 AM
Hi,

I'm considering purchasing EasyPHPCalendar and so I have looked over all the on-line demo stuff and I have a few questions about the mySQL integration and I'm hoping some of them can be answered with a detailed description of the mySQL tables used for this product - at the very least a "describe" of each of the tables used would be very helpful. I want to see how well this will integrate with my plan for the rest of the site.

Off the top of my head the first questions that come to mind revolve around the location and the event details. For our situation, 9 times out of 10 the event will be at the home of a member, so instead of choosing "Home" or "School" I'd like to be able to pick a specific member from a list and have that show up in the event as a clickable link. I guess we can do that by hand using raw html to provide a link but that leads to my second question which is what I'd really like to do is have a drop-list of events that I've set up like "Book Club", "Dinner Club" etc and then choose a member and when event is added to the calendar it knows to contain a link to certain page based on what event was chosen. This is to avoid having to have a computer novice admin enter http://... tags in the "details" section. In other words, the admin selects an Event Category, a member that is hosting it, enters some details and the time and the result is that the event has some clickable link that tells it to go to page xyz for more details.

Any thoughts?

Kind regards,
Rob

Brian
07-09-2005, 09:06 AM
This may be possible with categories. I can't test this at the moment, but you may try using a full href tag for the description of a category in the Setup Manager...

rolevine
07-09-2005, 09:25 AM
Hi,

Thanks for the quick reply.

I've been thinking that what might be a better idea is for me to write my own interface to the page that adds the actual events (or at least extend what's in the package), so that brings me back to my original question of whether there's a way I can look at the database tables to see what data is stored and used?

Kind regards,
Rob

Brian
07-09-2005, 01:24 PM
startDate Julian Day number of the start date
endDate Julian Day number of the end date
startTime Time event starts in 24HR format
endTime Time event ends in 24HR format
type Whether is a single, reoccurring or floating event
repeat For repeating events - how often it repeats
title Title
descr Description
days Number of days an event lasts
stop Number of time an event occurs
month For floating - month event starts
weekDay For floating - week day event occurs
weekNumber For floating - week number event starts
category The categorie(s) assigned to the event
eventKey Not used