1
sitekeep
How can I convert posting dates from old CMS articles??
  • 2003/2/8 2:00

  • sitekeep

  • Just popping in

  • Posts: 12

  • Since: 2003/2/7 7


I switched to XOOPS from another CMS and I was wondering how can I change the dates of news stories to the original posting date of the article?

I am looking at the php.net and the MySQL site as I write this but I am still at a loss as to how XOOPS stores the date information.

Is there any easy way to convert the dates? Is there a simple script I can use to convert the dates?

Thanks in advance....

2
onokazu
Re: How can I convert posting dates from old CMS articles??
  • 2003/2/8 4:34

  • onokazu

  • XOOPS Founder

  • Posts: 617

  • Since: 2001/12/13


It depends on how the original date was stored in DB. In XOOPS, all date related data are stored as timestamp generated by php time() function.

3
sitekeep
Re: How can I convert posting dates from old CMS articles??
  • 2003/2/8 4:46

  • sitekeep

  • Just popping in

  • Posts: 12

  • Since: 2003/2/7 7


In the old CMS's mySQL file the old dates are stored as: '2002-07-02 03:29:48' in XOOPS MySQL it is: '1042657588'. How can I convert the known dates ('2002-07-02 03:29:48') into how XOOPS store them.

I hope this explaines what I want to do...

4
onokazu
Re: How can I convert posting dates from old CMS articles??
  • 2003/2/8 4:52

  • onokazu

  • XOOPS Founder

  • Posts: 617

  • Since: 2001/12/13


Maybe you can try the php strtotime() function or UNIXTIMESTAMP function in mysql.

5
broyle
Re: How can I convert posting dates from old CMS articles??
  • 2003/2/8 6:57

  • broyle

  • Just popping in

  • Posts: 15

  • Since: 2003/1/19


Which CMS were you using before?

6
sitekeep
Re: How can I convert posting dates from old CMS articles??
  • 2003/2/8 7:23

  • sitekeep

  • Just popping in

  • Posts: 12

  • Since: 2003/2/7 7


Let me explain myself better...

I have the MySQL files from my old CMS's MYphpNuke and Mambo. I have cut and pasted many of the old articles into XOOPS 2 but the I can't get dates to show up right.

I want to edit the created or published dates in the XOOPS MySQL through phpMyAdmin. the dates are listed in XOOPS sql as:
created:1042750922
published:1042750922

Is there any way to edit these dates and have it show up correctly.2003/1/16 21:02:02





7
razzrezz
Re: How can I convert posting dates from old CMS articles??
  • 2004/7/15 20:17

  • razzrezz

  • Just popping in

  • Posts: 3

  • Since: 2004/7/8 3


Hi,
I know very little about MySQL outside of what I can do throught phpMyAdmin, so I relied upon this Unix to Human time converter to convert the dates from how I understand them to how the the OS reads them.

You insert the human date and it spits out the unix date: newbie-MAGIC!

Hope it helps you out.

8
Grumpy
Re: How can I convert posting dates from old CMS articles??
  • 2004/7/15 21:26

  • Grumpy

  • Just popping in

  • Posts: 10

  • Since: 2003/7/18


Once you figure out how to change the date, you should be able to use MySQL Control Center to connect and and edit the database.

MYSQL Control Center

Goodluck!

9
Grumpy
Re: How can I convert posting dates from old CMS articles??
  • 2004/7/16 15:15

  • Grumpy

  • Just popping in

  • Posts: 10

  • Since: 2003/7/18


Hmmm so it is. Hope he figured it out.


Login

Who's Online

138 user(s) are online (60 user(s) are browsing Support Forums)


Members: 0


Guests: 138


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits