View Full Version : flat-file database format
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.
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
09-23-2009, 08:17 PM
This may help:
You may also try adding events to see how each events changes this information.
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|
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.
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.
vBulletin® v3.8.4, Copyright ©2000-2013, Jelsoft Enterprises Ltd.