Automate categories config with SQL commands?
Posted: 01 Jul 2009, 20:05
I am building a photogallery for a skating team. I'm setting up a hierarchy of subcategories similar to [Year->Team->Competition->Skater]. Each year has 4 teams, each team has 6-10 competitions, each competition has 12-20 skaters. Skaters are allowed to upload pictures to the skater folders within each competition. I have uploaded the entire folder structure to create the categories and then go in to manually configure the setting.
[Sidebar]: A great new feature would be to allow for the duplication of some of this structure within Phoca Gallery. Right now, doing it manually for each subcategory is a bit of a pain. Another nice feature would be the ability to include a text file in the folder when it is uploaded which would include the category configuration information. Actually, thinking about it, that would be really cool.
The category configuration that I'm doing is:
Thanks!
Tim
[Sidebar]: A great new feature would be to allow for the duplication of some of this structure within Phoca Gallery. Right now, doing it manually for each subcategory is a bit of a pain. Another nice feature would be the ability to include a text file in the folder when it is uploaded which would include the category configuration information. Actually, thinking about it, that would be really cool.
The category configuration that I'm doing is:
- All categories except skaters:
Access Level: Registered
Access User rights: All Registered
Upload and Add User Rights: Administrator
Delete and Publish User Rights: Administrator
The title of the competition categories get a minor change and the description gets information about the event
- All skater categories:
Access Level: Registered
Access User rights: All Registered
Upload and Add User Rights: All Registered
Delete and Publish User Rights: All Registered
Set upload folder to current directory
Thanks!
Tim