Hi,
I have a CMS I made, based on two tables.
One table, is CMS_MNU.
The other table, is CMS_Content
My CMS works like this:
On first page load, it gathers "page default" and shows that page as default.
Each page, must have a content.
Home -> one content
Info -> one content
Info about us -> one content
... etc
I can then build a tree-structure, based on a field "is_mother" and a field "parent_id".
I only allow mother or child, not grandparents.
I wonder, when letting the user choose bilingual content, should I only do so on the mother categories?
Also, How should I store the alternative languages for the content?
As far as I can tell, there are two ways to do it:
1: Add more fields, like "a3_cc" (3 char countrycode) and "original_lang_id"
2: Add a new table, so I can run a query based on that table too. (1 page : Many languages)
My plans for the future *may* include the possibilities for letting my users make alternative languages for the pages.
ps. it's all stored in mySQL and retrieved thru php.
I already have made php functions for getFlag(), so I can get any of the flags for any countries.
my CMS is also up and running, so I only lack some design for bilingual functions.
I hope someone here can tell me (FAST) how I should design this.
I want to get the page up ASAP, as the old one is very limited in functions atm. and I have 1300++ users, where 60% are Norwegian and the rest are international.
Olav Alexander Mjelde
Admin & Webmaster
I have a CMS I made, based on two tables.
One table, is CMS_MNU.
The other table, is CMS_Content
My CMS works like this:
On first page load, it gathers "page default" and shows that page as default.
Each page, must have a content.
Home -> one content
Info -> one content
Info about us -> one content
... etc
I can then build a tree-structure, based on a field "is_mother" and a field "parent_id".
I only allow mother or child, not grandparents.
I wonder, when letting the user choose bilingual content, should I only do so on the mother categories?
Also, How should I store the alternative languages for the content?
As far as I can tell, there are two ways to do it:
1: Add more fields, like "a3_cc" (3 char countrycode) and "original_lang_id"
2: Add a new table, so I can run a query based on that table too. (1 page : Many languages)
My plans for the future *may* include the possibilities for letting my users make alternative languages for the pages.
ps. it's all stored in mySQL and retrieved thru php.
I already have made php functions for getFlag(), so I can get any of the flags for any countries.
my CMS is also up and running, so I only lack some design for bilingual functions.
I hope someone here can tell me (FAST) how I should design this.
I want to get the page up ASAP, as the old one is very limited in functions atm. and I have 1300++ users, where 60% are Norwegian and the rest are international.
Olav Alexander Mjelde
Admin & Webmaster