programming publications

Nevil

Posted on 05 Jul 2012, 14:48:30

Access: Member
Total Posts: 32
Joined: 2010-01-08

hi everyone,

My question is : can i program the publications of articles several weeks in advance by giving them date in the future ?

The purpose is to continue publishing when i am in holidays.

thx

#3897

Chris

Posted on 08 Jul 2012, 20:07:05

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

Yes you can. If you set the date to a date in the future, that article won't be displayed on your site until that date is reached.

#3899

Nevil

Posted on 21 Jul 2012, 23:41:30

Access: Member
Total Posts: 32
Joined: 2010-01-08

that's great, thank you for our work.

#3906

Last edited by Nevil at 2012-07-21 23:41:59 Reason: orthographe

Nevil

Posted on 03 Aug 2012, 13:17:05

Access: Member
Total Posts: 32
Joined: 2010-01-08

Hi, programing publication of the articles on my site work perfectly when i put a future date in my article but i've just see that the rss flux publish them automaticaly, without taking in account the real date. For exemple i've just program all the articles i want to publish in august with the futures dates, the site "waits" before publishing them, but the problem is all the articles are already in the rss flux. Do you have a solution to solve this ?

thx

#3926

Last edited by Nevil at 2012-08-03 13:17:38 Reason: details

Chris

Posted on 03 Aug 2012, 17:34:44

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

You've found a bug I overlooked. If you edit rss.php, around line 75~ you'll see this line of code

$sql .= "SELECT storyid FROM " . NEWS_GROUPCATS . " WHERE type = 'news' AND catid IN (SELECT catid FROM " . NEWS_GROUPCATS . " WHERE type = 'rss' AND storyid = ?) ) AND archived = '0' ORDER BY timestamp DESC LIMIT 0, $rssamount";

If you change it to the following

$sql .= "SELECT storyid FROM " . NEWS_GROUPCATS . " WHERE type = 'news' AND catid IN (SELECT catid FROM " . NEWS_GROUPCATS . " WHERE type = 'rss' AND storyid = ?) ) AND archived = '0' AND timestamp <= '" . time() . "ORDER BY timestamp DESC LIMIT 0, $rssamount";

The RSS feeds should now show the correct articles.

#3927

Nevil

Posted on 03 Aug 2012, 20:47:36

Access: Member
Total Posts: 32
Joined: 2010-01-08

hi,

thx for the answer, i try your solution, the result is the rss flux show now no aticles at all, just the title of the flux.

You can see it there http://nevil.fr/news/rss.php?feed=Nevil-news

Is there something to do ?

thx

#3928

Last edited by Nevil at 2012-08-03 20:58:57 Reason: complement

Chris

Posted on 04 Aug 2012, 09:51:15

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

Whoops, typo on my part. Try this instead

$sql .= "SELECT storyid FROM " . NEWS_GROUPCATS . " WHERE type = 'news' AND catid IN (SELECT catid FROM " . NEWS_GROUPCATS . " WHERE type = 'rss' AND storyid = ?) ) AND archived = '0' AND timestamp <= '" . time() . "' ORDER BY timestamp DESC LIMIT 0, $rssamount";

#3929

Nevil

Posted on 04 Aug 2012, 13:14:35

Access: Member
Total Posts: 32
Joined: 2010-01-08

great, it works

thx a lot.

#3930