Welcome to Geeklog, Anonymous Saturday, December 21 2024 @ 09:22 am EST

Geeklog Forums

Feature request: article language


Status: offline

Euan

Forum User
Full Member
Registered: 04/22/02
Posts: 292
brainy
A feature request for the next 1.3 release.

It would be useful to have an extra db field for articles, static pages and links etc. (pretty much everything in fact) that could be used as a language flag. This should have no effect on basic installations, but would allow some of us to develop truly multilingual sites in the future.

Alternatively, the ability to edit article ids as you can for static pages would be a start (then we can do things like my_article_en, my_article_ja, etc.)

Cheers,

Euan.
-- Heather Engineering
-- No job too small
 Quote

an

Anonymous
To do this properly would require more than an extra field -- the stories table would need to be separated into the parts that are language independent (date, author, topic etc.) and those that are language dependent (title, content). You'd then have a M:1 relationship between the tables.
 Quote

Status: offline

Euan

Forum User
Full Member
Registered: 04/22/02
Posts: 292
Not necessarily. If you then create a reference table that has

master_key
article_en_id
article_ja_id

etc. fields, you can then map multiple articles to a single master key, and show the correct article depending on the language. But then, if you think about it, you don't need the flag if you do that.....

Cheers,

Euan.
-- Heather Engineering
-- No job too small
 Quote

Status: offline

exdeath

Forum User
Junior
Registered: 02/13/04
Posts: 23
I could make use of an feature like that.
 Quote

an

Anonymous
I thought about this some more.

If you want to be able to have the same content in multiple languages then you will need an extra table. This would be the best way to internationalise static pages for example. The scenario is that the user selects their language and sees the page in that language.

But with stories it's probably different. On a bilingual site admins/users will post stories in their own language and other admins/users may translate them or they may not. It's unlikely you'd have exactly the same content available in both languages.

In this context a flag in the story table makes sense as it allows users to select the stories in their language.
 Quote

All times are EST. The time is now 09:22 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content