Topics

User Functions

Events

There are no upcoming events

What's New

Stories

No new stories

Comments last 2 weeks

No new comments

Trackbacks last 2 weeks

No new trackback comments

Links last 2 weeks

No recent new links

NEW FILES last 14 days

No new files

Welcome to Geeklog Tuesday, May 21 2013 @ 09:18 PM EDT

> >

Adding archive material

Geeklog
  • Sunday, May 05 2002 @ 08:31 PM EDT
  • Contributed by:
    Anonymous
  • Views:
    3,224
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?

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.

Post a Comment

Your Name
Create Account
Allowed HTML Tags:
 

Security code
This question is for testing whether you are a human visitor and to prevent automated spam submissions.

What code is in the image?
Enter the bolded text, case sensitive!
Important Stuff
  • Please try to keep posts on topic.
  • Try to reply to other people comments instead of starting new threads.
  • Read other people's messages before posting your own to avoid simply duplicating what has already been said.
  • Use a clear subject that describes what your message is about.
  • Your email address will NOT be made public.