PDA

View Full Version : Where are category values stored?


dg_name
03-12-2008, 05:26 PM
Looking through the database, events list numerical id numbers for their associated category/selections, but I don't see any table containing the actual mappings of numbers to categories, is it stored in a text file? I've looked through the files on the server and I don't see anything.

The reason I ask is that I like the script a lot, but I'm going to need to create a lot of categories since only one selection can be made per category, and I don't want the admin area to be cluttered up with tons of dropdown boxes with only one selection, so I'm thinking that it may be simplest to create my own backend for maintaining the database, with a multi-select dropdown of Category/Selection pairs.

In my case, a given event may need to show up in both "Arts and Entertainment" and "Community Resources" for example, ideally those should both be selections of "Event Type," but since I need to be able to select both, there will need to be categories for each instead, right?

I like everything else about the script, much cleaner than anything else I've looked at, still testing but will likely buy a license in the next few days if I can find solutions to this!

David

ve9gra
03-12-2008, 09:01 PM
Categories are saved in the config.inc.php and you pretty much need to use the Setup Manager to create them as there's a numbering system that comes into play. I do believe that version 7 will be using the database to save the categories definitions.

dg_name
03-12-2008, 11:17 PM
Thanks for the quick response, I edited the config.inc.php file manually and was able to add categories and selections, then view and use them from the Setup Manager, so I think I've decoded the numbering system, except that at the end of a set of selections, there's something like |-||-9| or |-||-9|5 at the very end of the string -- i'm guessing that the 5 is the next category id number that should be used, but the dash and negative numbers stump me, they don't seem to affect anything, can you explain what they're for?