Re: Status update

Hi,

Mozilla allows you to set multiple languages I think... will have to check what headers it sends then...

news and events can be translated in the new admin area (http://wwwdevel2.postgresql.org/admin/ - don't miss the trailing slash!), you can add yourself to the .htaccess in that directory to have a look at it. It's password protected as it acts on the live database - please be careful on it ;) I will add the possibility to translate the polls, too - this is implemented in the website, but missint in the admin area.

It's currently implemented in a way that every news and event is added in english and then translated by us in the admin area. Those entries not yet translated automatically fall back to the english ones...

There are some new database tables for it, called events_text, news_text and survey_questions.

Documentation can be translated by simply adding the new entries to the documentation table in the database using the correct language code.

----- Original-Nachricht -----
Von: "Justin Clift" <justin(at)postgresql(dot)org>
An: webmaster(at)letzplay(dot)de
CC: pgsql-www(at)postgresql(dot)org
Datum: Saturday, August 30, 2003 05:48 PM
Betreff: [pgsql-www] Status update

> Hi Andreas,
>
> This definitely looks like a good start. Found it difficult to get the
> German version of the site to load automatically (Mozilla probably
> needed a restart after changing the language selection, but I had too
> many other windows open with interesting things in them to want to close
> them...).
>
> Is there a strategy in place for creating news and events in languages
> other than English?
>
> We'd probably want to manage the events and news a bit seperately from
> each other... or at least have a "language" field for each news/event so
> it only displays the relevant ones.
>
> This might or might not have been considered already though, with me
> having missed the conversation...
>
> ;-)
>
> Regards and best wishes,
>
> Justin Clift
>
>
> Andreas GrabmXller wrote:
>
> > Hi,
> >
> > I think the new multilingual website system is working now (well, the technical side works, I have not added all pages and files yet). You can find it on http://wwwdevel2.postgresql.org
> >
> > It would be good to get some comments / suggestions on the code now... you can find it at /home/www.postgresql.com/andreas/public_html or view it on the web at http://svn.gamecrashnet.de/repos/pgsql_org/
> >
> > Some comments on how the system works:
> >
> > Every request goes through some RewriteRules in the .htaccess file. If the files exists in the cache directory, this one is delivered (for performance reasons). If the is for a file in the /admin, /layout or the /files directory, nothing happens. Every other request gets redirected to the script /system/handler.php (or /system/handleform.php which handles every dynamic request) where the pages get built and delivered dynamically.
> >
> > There is a script in the /tools directory called "rebuildcache" written in PHP, this can rebuild parts or or the whole cache directory. just call it without arguments to get the help. The cache directory contains all static pages and elements, so this can be used to mirror the whole website (all dynamic contents get linked to postgresql.org statically).
> >
> > Is there a problem with this? Or is something missing?
> >
> > Mit freundlichen Grüßen
> > Andreas Grabmüller
> >
> > --
> > LetzPlay.de
> > | Freemail: http://www.letzplay.de/mail
> > | Forenhosting: http://www.letzplay.de/foren
> > ---------------------------(end of broadcast)---------------------------
> > TIP 8: explain analyze is your friend

--
LetzPlay.de
| Freemail: http://www.letzplay.de/mail
| Forenhosting: http://www.letzplay.de/foren
>From pgsql-www-owner(at)postgresql(dot)org Sat Aug 30 15:59:43 2003
X-Original-To: pgsql-www-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [64.117.224.130])
by svr1.postgresql.org (Postfix) with ESMTP id 9635FD1B8B7
for <pgsql-www-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Sat, 30 Aug 2003 18:59:42 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024)
with ESMTP id 53641-03
for <pgsql-www-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Sat, 30 Aug 2003 15:59:12 -0300 (ADT)
Received: from www.postgresql.com (unknown [64.117.225.209])
by svr1.postgresql.org (Postfix) with ESMTP id D6C33D1B8B1
for <pgsql-www(at)postgresql(dot)org>; Sat, 30 Aug 2003 15:59:10 -0300 (ADT)
Received: by www.postgresql.com (Postfix, from userid 80)
id CB53BCF4A48; Sat, 30 Aug 2003 15:59:10 -0300 (ADT)
To: pgsql-www(at)postgresql(dot)org
Subject: New News Entry
Message-Id: <20030830185910(dot)CB53BCF4A48(at)www(dot)postgresql(dot)com>
Date: Sat, 30 Aug 2003 15:59:10 -0300 (ADT)
From: www(at)www(dot)postgresql(dot)com (World Wide Web Owner)
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=BAYES_30,
HTML_10_20
X-Spam-Level:
X-Archive-Number: 200308/40
X-Sequence-Number: 2465

A new entry has been added to the news database.

Database Admin: http://www.postgresql.org/admin/edit_news.php?149

Submitted by: justin(at)postgresql(dot)org
Headline: pgAdmin3 (the next generation PostgreSQL GUI) is looking for translators!
Summary:

pgAdmin, one of the most widely popular cross platform GUI\'s for PostgreSQL, is soon to announce it\'s third major release and needs more translators!

Can you assist?

Story:

pgAdmin, one of the most widely popular cross platform GUI\'s for PostgreSQL, is soon to announce it\'s third major release and needs more translators!

It has been designed from near the beginning to handle multiple languages, and has already been mostly translated into 16 non-English ones so far:

Danish, German, Farsi, French, Croatian, Hungarian, Indonesian, Japanese, Norwegian Bokmål, Polish, Portuguese-Brazilian, Romanian, Russian, Turkish, Chinese simplified, and Chinese traditional

We\'re trying to get a lot more ready in time for this release, so that PostgreSQL is available for the widest possible audience.

If you have some time to assist, then <b>please</b> take a look at the <a href=\"http://pgadmin.postgresql.org/pgadmin3/translation.php\">pgAdmin3 Translation page</a> and contact either <a href=\"mailto:jm(at)poure(dot)com\">Jean-Michel Poure</a> or <a href=\"mailto:dpage(at)vale-housing(dot)co(dot)uk\">Dave Page</a> to get involved:

<a href=\"http://pgadmin.postgresql.org/pgadmin3/translation.php\">http://pgadmin.postgresql.org/pgadmin3/translation.php</a>