The Ultimate Weblog System

Resources

Getting started

Support

Development

Sections

Home

Geeklog (190)

Geeklog 2 (28)

Announcements (201)

Summer of Code (8)

Security (55)

Plugins (50)

Server (26)

Spam (10)

User Functions

Don't have an account yet? Sign up as a New User
Lost your password?

What's New

STORIES

No new stories

COMMENTS last 2 days

No new comments

TRACKBACKS last 2 days

No new trackback comments

NEW FILES last 14 days

LINKS last 2 weeks

No recent new links

Older Stories

Welcome to Geeklog
Thursday, May 15 2008 @ 11:40 PM EDT

Adding archive material

Sunday, May 05 2002 @ 08:31 PM EDT
Contributed by: Anonymous
Views: 1,954

Since my RDF question was answered so quickly, I figured I'd see if I could go 2-for-2...

I have a lot of material that I wrote for my previous site (plain HTML) that I'd like to copy over to my Geeklog-enabled site. I'd like to assign dates before this year, and the only way I've found to do this is to set the system date on my server back. Is there a way to accomplish this without screwing with my system date?

What's Related

Story Options

Printable Story Format

Adding archive material | 3 comments | Create New Account

The following comments are owned by whomever posted them. This site is not responsible for what they say.

Enter the stories as Admin

Authored by: Dirk on Sunday, May 05 2002 @ 11:59 PM EDT

The (Story)Admin can choose a date and time for a story. This is actually meant so that you can enter a story to automatically be published at a future date (e.g. when you're away at that time), but you can also use this to create stories with a date and time in the past.

bye, Dirk

Enter the stories as Admin

Authored by: gotroot801 on Monday, May 06 2002 @ 07:20 AM EDT

That\'s true, but only within the current calendar year. The drop-down box starts with the current year and goes forward.

I\'m sure I could make the changes with an SQL script if need be, but I\'d rather not take that route, since my SQL would probably be buggy...

Not totally accurate...

Authored by: Tony on Monday, May 06 2002 @ 07:25 AM EDT

Dirk is not quite accurate in that statement. You can set the month/day and time to anytime in the past. You can\'t, however, set the year to a date in the past. What I would do is pick an arbitrary point in the future, say 01/01/2003 00:00:00. Assign all your story to that date/time. Then do this:

\"update stores set date = \'YYYY-DD-MM HH:MM:SS\' where date = \'2003-01-01 00:00:00\'\"

You can either do that story by story or on a batch at a time. NOTE: if all your plain HTML stories are from this year then you CAN just edit them in admin/story.php. If they are from 2001 or prior use this method.