random quotes update - Mailing list pgsql-www

From Robert Treat
Subject random quotes update
Date
Msg-id 200508201240.46418.xzilla@users.sourceforge.net
Whole thread Raw
Responses Re: random quotes update
List pgsql-www
I've got the random quote feature pretty much working.  As of now you can
add/edit/delete/translate quotes through the admin interface, like anything
else.

On the main page, it will pull a random quote from the list of quotes and
display it in the featured user box just like now. I wrote the sql so that it
will seed quotes entered within the last 8 days first and then once all
quotes are older than 8 days, it will just grab a random quote. (This way
when we add a new quote, it gets preference initially).

You can also add quotes in unapproved or inactive status, which will hide them
from the being picked for the main page; activating & approving them will put
them in the rotation (and this action will send an email to the notification
list).

There are two rough spots that are not done that I am inclined to gloss over
unless someone feels a strong urge (in which case i'd be happy to let them
code it ;-). First is that the email to the notice list contains a link to
individual quotes for viewing that does not work.  Second, the quote preview
just reuses the news preview pop-up form, so the fields are mislabled.

In the future I think it might be nice to create an rss feed of the quotes, so
anyone could grab them and make use of them, but we'll see if there is really
an demand for such a thing.  In the mean time I'm ready to commit unless
someone has something more in mind.

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

pgsql-www by date:

Previous
From: Josh Berkus
Date:
Subject: Re: database driven user quotes
Next
From: Josh Berkus
Date:
Subject: Re: random quotes update