Re: Candidate new site design

Josh Berkus wrote:
<snip>
> Someday we should also augment the "Submit Event/News" scripts so that they
> automatically post to pgsql-announce; it would save some effort.

Hmmmm, that'll require adding a check to the News and Event editing
code, so that it recognises the first time a news or event item goes
from the "not active" to "active" state.

We'll probably just need a boolean field added to the news items
database records, and the same for events.  Then the:

http://www.postgresql.org/admin/edit_news.php

script updated to check that boolean for the first time it changes.

The only potential problem point I can see is that the text is often
customised with HTML tags to display properly in users browsers.
However, that's not going to be so optimal for text-only mail outs.

Trying to think of a more workable approach:

  + Perhaps stripping/processing all HTML tags and mailing out the result?
    (sounds difficult/messy)
  + Perhaps having another textarea field in the edit_news.php page for
text only, and that gets mailed out to the pgsql-announce mailing list.
  It'd automatically contain the same initial text as the body of the
news item, but the person looking it over would make sure it was
suitable for text mailout.
  + If we want to get fancy, we could have a "Test Email" button that
sends the email out to a (user defined) email address for the person
looking things over to verify that the email to be sent will look ok,
prior to doing it for real.

Hope that's helpful.

:)

Regards and best wishes,

Justin Clift