Re: database driven user quotes - Mailing list pgsql-www

From Magnus Hagander
Subject Re: database driven user quotes
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C78C4@algol.sollentuna.se
Whole thread Raw
In response to database driven user quotes  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-www
> Hey guys,
>
> I'm thinking about making the user quotes on the main website
> database driven .  Two goals behind this would be to allow
> for a page where we could display all user quotes, and also
> to allow the quotes on the main page to be randomly generated
> for each site build, making the front page a little less
> static.  The one tricky part seems to be how best to handle
> translations. I had a thought to make the database table
> something simple like quote, tagline, & lang, which would be
> fine for storing the content, however I'm not sure the best
> way for extracting it.  I was thinking the calls to func_lang
> could be replaced with a get_quote, and then use $_LANGUAGE
> for system/handler.php as an argument to get the appropriate
> quote.  I figure this will also mean we need an addition to
> the admin screens for inputing quotes. Does this sound reasonable?

Seems good to me. If translation is a lot of work, I'd even say skip
that. From what I can tell, very little of our content is actually
translated. Looking at news items, that's exactly zero items since the
start of the db which is back in 2002. So I honestly don't see why we
bother. But if it's not too much work, it doesn't hurt :-)

//Magnus

pgsql-www by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: Re: database driven user quotes
Next
From: "Marc G. Fournier"
Date:
Subject: Re: database driven user quotes