Re: database driven user quotes

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Gavin M(dot) Roy" <gmr(at)ehpg(dot)net>, "Marc G(dot)Fournier" <scrappy(at)postgresql(dot)org>
Cc: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>, <pgsql-www(at)postgresql(dot)org>
Subject: Re: database driven user quotes
Date: 2005-08-18 09:10:02
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE6C78C9@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

Yeah. But none of this is really necessary as long as we can live with
the quote being changed only once per hour. Makes things a lot simpler
:-) (we're doing this already with the surveys, comments, news etc etc)

//Magnus

> -----Original Message-----
>
> The other side of that is, there should be a default one
> incase the user has javascript disabled. Then the javascript
> would replace the innerHTML of the div that contains it with
> a random quote. I can provide code if needed.
>
> Gavin
>
> On Aug 17, 2005, at 7:13 PM, Marc G. Fournier wrote:
>
> > On Wed, 17 Aug 2005, Gavin M. Roy wrote:
> >
> >
> >> Could use javascript to fill an array of quotes and
> randomly pic one.
> >>
> >
> > That works ...
> >
> >>
> >> On Aug 17, 2005, at 12:56 PM, 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?

Responses

Browse pgsql-www by date

  From Date Subject
Next Message Robert Treat 2005-08-18 15:31:25 [Fwd: [GENERAL] New Drupal PostgreSQL Maintainer Wanted]
Previous Message Josh Berkus 2005-08-18 04:03:39 Re: database driven user quotes