[geeklog-devel] Question about internationalization and look-ups
Tony Bibbs
tony at tonybibbs.com
Fri Feb 8 15:33:49 EST 2008
Only problem with that then is in order to translate Geeklog using Flexy would be a combination of flat files and database stuff.
I should probably just take a look at one of the other CMS's engines out there. Somebody has probably already fixed this.
--Tony
----- Original Message ----
From: Joe Mucchiello <joe at ThrowingDice.com>
To: Geeklog Development <geeklog-devel at lists.geeklog.net>
Sent: Friday, February 8, 2008 2:10:37 PM
Subject: Re: [geeklog-devel] Question about internationalization and look-ups
At 02:35 PM 2/8/2008, Tony Bibbs wrote:
>I'm at a point where I've got some internationalization problems
>that would make people like Dirk cringe.
Well, Dirk (or someone else) solved this problem with the Language
arrays that mirror the drop down tables. COM_optionList in
lib-common.php.
>Two problems:
>1) Values in the drop down come from the database in English only
Why? Internationalize the database. Make the table be LISTNAME,
VALUE, DESCRIPTION, LANGUAGE and then require LISTNAME and LANGUAGE
in the query. If the query comes back empty, default to the system's
default language.
>2) the '-- Select Type --' is meant to be the first option in the
drop-down.
Put an ORDERBY field in the above table. This way if the fields are
('temperature', 'cold', 'cold', 'en', 1), ('temperature', 'hot',
'hot', 'en', 2) in English, they can be ('temperature', 'cold',
'froid', 'fr','2),('temperature','hot','chaud',1) in French and the
order by keeps the words in alphabetical order.
SELECT value, description FROM listofeverything WHERE listname =
'temperature' AND language = 'en' ORDER BY orderby
>Any suggestions on how to elegantly fix these problem?
Elegant? You're talking about natural language semantics. There's
nothing elegant about that. :-)
----
Joe Mucchiello
Throwing Dice Games
http://www.throwingdice.com
_______________________________________________
geeklog-devel mailing list
geeklog-devel at lists.geeklog.net
http://eight.pairlist.net/mailman/listinfo/geeklog-devel
More information about the geeklog-devel
mailing list