X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F1314D1B53B for ; Tue, 11 Nov 2003 01:20:47 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 24615-10 for ; Mon, 10 Nov 2003 21:20:20 -0400 (AST) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id C12B2D1B537 for ; Mon, 10 Nov 2003 21:20:16 -0400 (AST) Received: from myrealbox.com grzm@smtp-send.myrealbox.com [210.231.39.78] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 3.44 $ on Novell NetWare; Mon, 10 Nov 2003 18:20:19 -0700 Date: Tue, 11 Nov 2003 10:20:16 +0900 Subject: Re: Considerations on a Multi-Lingual Site Content-Type: text/plain; charset=ISO-8859-1; format=flowed Mime-Version: 1.0 (Apple Message framework v552) From: Michael Glaesemann To: pgsql-www@postgresql.org Content-Transfer-Encoding: quoted-printable In-Reply-To: <20031110230329.25019.qmail@osiris.gamecrashnet.de> Message-Id: <354B25E4-13E5-11D8-A2E4-0005029FC1A7@myrealbox.com> X-Mailer: Apple Mail (2.552) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/137 X-Sequence-Number: 2784 On Tuesday, November 11, 2003, at 08:03 AM, Andreas Grabm=FCller wrote: > It's difficult to create elements like lists without knowing HTML. Couldn't it be done along the lines of building selects? Say you've got=20 an array of list items: $list_array =3D array ('apples','oranges','grapes'); $list_string =3D '
    '; foreach $list_array as $this_item { $list_string .=3D '
  • '.$this_item.'
  • '; } $list_string .=3D '
'; This doesn't solve the problem of how you get the list into the=20 database, but that shouldn't be too hard. > I think we have two options here: a bbcode parser that allows some=20 > input like the popular bulletin boards do or using a WYSIWYG editor A bbcode parser would probably be adequate. Wiki markup isn't too hard=20 and parsers are easy to come by. > If a translator creates a page in its own language, should it be not=20 > available to other languages or appear in that foreign language for=20 > the english people? Should they be able to change the menu (just for=20 > their own language or for all)? I could see a link with something like "Translate this item" if a=20 translation isn't available in the preferred language of the viewer.=20 That then brings them to the bbcode page (requiring whatever=20 authentication you want, if you want to limit the translations to be=20 done only be authorized translators). As for what news is displayed, I think it might be a good idea to=20 display all of the items, with as many translated as translations are=20 available. For languages that haven't got a full version of everything=20 translated, you might get some pretty sparse pages, and people wouldn't=20 necessarily know what they're missing. It might be nice if you could store a language preference order in the=20 cookie. So for example, if I wanted English first, then German, then=20 Japanese, I'd get the translation of the highest preference that was=20 available. This may have already been hashed out. I haven't looked closely enough=20 at that section of the code yet. Michael