1
scurvyd
File Format for importing links needed
  • 2004/1/31 6:49

  • scurvyd

  • Just popping in

  • Posts: 23

  • Since: 2004/1/28


I have created my categories and now I have many links to add.

I am familiar with how to run an SQL query on the Db, however I require the file formats and any possible special instructions if necessary.

I figure I am not the first to ask so is there a link to the docs on this I can read, please.

Thank you really enjoying Xoops.



2
scurvyd
Re: File Format for importing links needed
  • 2004/1/31 22:01

  • scurvyd

  • Just popping in

  • Posts: 23

  • Since: 2004/1/28


OK then no answers.

I have this SQL code


THis is to insert a catagory, easy enough.

le="color: #000000"><?php INSERT INTO `xoops_mylinks_cat` VALUES (1, 0, 'Communities', 'http://');


This is the SQL for inserting a link.

le="color: #000000"><?php INSERT INTO `xoops_mylinks_links` VALUES (1, 1, 'ScurvyDawg.com', 'http://www.scurvydawg.com/', '', 1, 1, 1075533187, 0, '0.0000', 0, 0);


Now my question is, the date reads - 1075533187 - What is this number is it the date? is it ok if I import a whack of links with this the same on all of them??

Any caveats would be welcome before I do a mass import.

Thank you.

3
christian
Re: File Format for importing links needed
  • 2004/2/1 0:59

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


For the date, you can test with
unix_timestamp('2004-02-01')

Here others samples with date

Best regards
(Sorry for my english)

4
Mithrandir
Re: File Format for importing links needed

Shouldn't matter if the timestamp is the same on all of them. It's just a timestamp for creation.