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

From Robert Treat
Subject Re: database driven user quotes
Date
Msg-id 200508171606.46123.xzilla@users.sourceforge.net
Whole thread Raw
In response to database driven user quotes  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-www
Just like we do now with events and news and such. When we build the site from
the master, the quote will get pulled from the db and put into the static
page.

Incidentally, for those concerned, I'll handle translation like we do now with
news/events type stuff, that architecture should be fine for what I am doing.

Robert Treat

On Wednesday 17 August 2005 15:56, Marc G. Fournier wrote:
> Ummm, how are you planning on handling the web servers, which are all
> static pages generated by the master site?
>
> On Wed, 17 Aug 2005, Robert Treat wrote:
> > 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?
> >
> > --
> > Robert Treat
> > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
>
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

pgsql-www by date:

Previous
From: Robert Treat
Date:
Subject: database driven user quotes
Next
From: "Marc G. Fournier"
Date:
Subject: Re: database driven user quotes