PDA

View Full Version : flat-file database format


JDP
09-23-2009, 03:49 PM
Is there an available schema to the flat-file database?


I'm mainly trying to figure out what all the bold red pieces are and what they map too. Would love an answer.


<?php /*
Some text here |1|0|0|0|0|0[2X||-||-20|2455001|2455001|13:00:00|15:00:00|Once|0|More text here |Yet more text here
*/ ?>

Brian
09-23-2009, 08:17 PM
This may help:

https://www.easyphpcalendar.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=29

You may also try adding events to see how each events changes this information.

JDP
09-24-2009, 06:12 AM
Thanks but that is of no help really. The link is the column list for the mySQL database I believe.

While the second suggestion sounds logical, it doesn't map to the bold red characters in the string I listed. I was hoping I could get those identified or at least the last 3 groupings of |-20|2455001|2455001|

Thanks again.

ve9gra
09-24-2009, 06:57 AM
Actually, the separating character is -||-, so for your example it is not as you posted it.... it actually is

-||-20|2455001|2455001|13:00:00|15:00:00|Once|0|More text here |Yet more text here|1|0|0|0|0|0[2X||

First field being the eventID which is not included in the FAQ.. but the rest of the fields are in the same order.

JDP
09-24-2009, 07:08 AM
Ah that makes more sense. I had snipped it out of the CalDat.php file and didn't start at the proper place.

I take it 2455001 is the representation of the Start/End Date. The stuff on the end "|1|0|0|0|0|0[2X||" I guess I needn't worry since it the same for every date entry in my test file.

Thanks for this.