Un Publishing

[melon]

Is there any way to un publish photos? i uploaded 94 images and intended to have one show per day, but i published them all, and short of manually changing the dates ( if that works ) i cant remove them.

it would be nice if there was a plug in to take a bunch of photos and span them in the future.

[kevincrafts]

If you can change all the dates to a future date, which can be done through a database admin, you can then use this addon to date the photos backwards

[austriaka+]

Future posts are only viewable by you if you are logged in as Administrator.
It is no fun to do this now but you can edit each of your photos to become published one day after the last one. The "future post feature" is the draft function in Pixelpost

[melon]

Any idea how long it would take to have the future post made?

just so i know if i should bother making it my self.

i'm sure if i back up my DB i could attempt to slap some code together.

Thinking out loud.

get current date,

get day.

count images.

increment day + 1.

ahh yes might be a bit tricky once you hit the next month.

well let me know if anything happens, ill attempt to make it my self.

[kevincrafts]

If you use the mysql date functions you don't have to worry about the end of the month. You can hack my back dater addon if you want and just have it add instead of subtract.

[melon]

I almost have a future Dater, i can display the dates incremented into the future, but it gets saved as 0000000 in the DB?

any ideas?

[melon]

PHP Code:

foreach ($moderate_image_boxes as $valueId)    {
    $tomorrow = mktime(0,0,0,date("c"),date("d")+$i,date("y"));
    $futureDate = date("c/d/y", $tomorrow);

    $batchFutureSql = "UPDATE ".$pixelpost_db_prefix."pixelpost SET
        datetime='$tomorrow'
          WHERE id = $valueId LIMIT 1";
    
    echo $tomorrow."<br>";
     
    # execute SQL statement
    mysql_query($batchFutureSql);

    # check for errors
    if (mysql_error()) { print "Database Error: $sql " . mysql_error(); }
    $i++;
} 


Like i said the dates echo correctly but they dont show up in the DB

[Dennis+]

Probably the date format you use is not compatible with MYSQL date format.

Date time format in the pixelpost table is: 2007-06-16 00:00:49

yyyy-mm-dd hh:mm:ss

[melon]

Ill try this then

o-m-d G:i:s

that would be 2008-03-.6 15:28:12

[melon]

Yay, i figured it out, thanks alot!

ill do some cleanup on it and upload it to the addons.

Thanks for the help