How to make Edition go LIVE on a particular hour?
Hi,
I'm setting up a newspaper site with the help of CCK node-reference, panels, views etc.
I have 2 basic content types: Story and Edition.
This daily newspaper is publishing 1 Edition each day. "Edition" is a content type consisting of many node-references containing Stories.
The basic content type is the Story. Roughly 20-30 are being submitted by columnists and journalists, but they must not be visible or searchable until the next day when the Edition goes live.
I need your help in sorting out how to:
1) How to exclude tomorrow's Stories submitted today from being accessible to the general public? It looks like even if the story is unpublished, people can still find and read it.
2) How to schedule that on a particular hour each morning (e.g. 4am) (except Saturday and Sunday) the latest Edition goes live??? By "Live" I mean the Edition gets published, becomes visible to the public, all Stories within it become visible to the public, and the full node of the new Edition replaces the front page of the website, while yesterday's edition disappears from the front page.
I'm assuming that the best way is to use Rules module. But I have searched and searched for a good tutorial, but I still can't make sense of how to get these automated processed to work.
Please help. If you know a good tutorial please post a link. If not, even a basic set of links and modules or suggestions would be greatly appreciated.
Many thanks in advance!

1) If the story is
1) If the story is unpublished, people should not be able to still find and read it. Likely you're still seeing it in place, because you have the permissions set in Drupal to allow your "role" to see all unpublished content. If you logout to view it as a anonymous or regular authenticated user, it should be unavailable.
2) You're right that the Rules module should allow you to do this. As far as I know there isn't a plug and play solution for what you're trying to do, so you'll need to explore it a bit deeper. But the basic format that you'll likely use is setting up a rule to publish based on a "publish date" CCK field. http://drupal.org/node/520012
Alternatively, you can take a look at the Deploy module (http://drupal.org/project/deploy), which is based of the idea that you would stage the edition on a separate backend server, then push it all up at once to make it live on the site. It is my understanding that this is how Foreign Affairs handles the publishing of their editions. http://drupal.org/node/518314
Gary
CCK Activation and Expiry Date/Time
We created a CCK field for each issue of the newspaper as well CCK fields for Activation and Expiry Date/Time, which are attriubutes of both an issue and each article .
We use those to make the new issue go live each week.