random quotes update

Поиск
Список
Период
Сортировка
От Robert Treat
Тема random quotes update
Дата
Msg-id 200508201240.46418.xzilla@users.sourceforge.net
обсуждение исходный текст
Ответы Re: random quotes update  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: database driven user quotes
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: random quotes update