Webmastersite.net
Register Log In

Import from Linker

Comments on Import from Linker

naxtor
Beginner

Usergroup: Member
Joined: Jan 22, 2005

Total Topics: 1
Total Comments: 2
naxtor
Posted Jan 29, 2005 - 7:09 AM:

I would use WSN Links instead of Linker (http://codelib.co.kr/enproject/)... I'll start from the Basic Edition and, if it's work, I'll buy the full version.
I would import the old data from Linker (links and categories)

The structure data is
[code]
CREATE TABLE `LINKER_CAT` (
`sid` mediumint(9) NOT NULL default '0',
`parent` mediumint(9) NOT NULL default '-1',
`pparent` mediumint(9) NOT NULL default '-1',
`relate` mediumint(9) NOT NULL default '-1',
`path` varchar(255) NOT NULL default '',
`pathtxt` text,
`sub_cat` mediumint(9) NOT NULL default '0',
`sub_link` mediumint(9) NOT NULL default '0',
`count` mediumint(9) NOT NULL default '0',
`uptime` int(10) NOT NULL default '0',
`lasttime` int(10) NOT NULL default '0',
`c_view` enum('0','1') NOT NULL default '1',
`c_link` enum('0','1') NOT NULL default '1',
`c_sub` enum('0','1','2') NOT NULL default '1',
`title` varchar(40) NOT NULL default '',
`descript` varchar(255) default NULL,
`meta_key` varchar(255) default NULL,
`header` text,
`footer` text,
`bingo1` varchar(100) default NULL,
`bingo2` varchar(100) default NULL,
`bingo3` varchar(100) default NULL,
`bingo4` varchar(100) default NULL,
`bingo5` varchar(100) default NULL,
PRIMARY KEY (`sid`),
KEY `parent` (`parent`),
KEY `pparent` (`pparent`)
) TYPE=MyISAM;

CREATE TABLE `LINKER_LINK` (
`sid` int(11) NOT NULL default '0',
`parent` int(11) NOT NULL default '0',
`path` varchar(255) NOT NULL default '',
`pathtxt` text,
`title` varchar(50) NOT NULL default '',
`url` varchar(255) default NULL,
`name` varchar(25) default NULL,
`email` varchar(100) default NULL,
`scont` varchar(255) default NULL,
`lcont` text,
`uptime` int(10) default NULL,
`passwd` varchar(20) default NULL,
`c_new` enum('0','1') NOT NULL default '0',
`c_pick` enum('0','1') NOT NULL default '0',
`count` mediumint(9) NOT NULL default '0',
`visit` mediumint(9) NOT NULL default '0',
`comment` smallint(6) NOT NULL default '0',
`upfile` varchar(255) default NULL,
`n1` mediumint(9) default '0',
`n2` mediumint(9) default '0',
`n3` mediumint(9) default '0',
`n4` mediumint(9) default '0',
`n5` mediumint(9) default '0',
`n6` mediumint(9) default '0',
`n7` mediumint(9) default '0',
`n8` mediumint(9) default '0',
`n9` mediumint(9) default '0',
`n10` mediumint(9) default '0',
`user1` varchar(150) default NULL,
`user2` varchar(150) default NULL,
`user3` varchar(150) default NULL,
`user4` varchar(150) default NULL,
`user5` varchar(150) default NULL,
`bingo1` varchar(100) default NULL,
`bingo2` varchar(100) default NULL,
`bingo3` varchar(100) default NULL,
`bingo4` varchar(100) default NULL,
`bingo5` varchar(100) default NULL,
PRIMARY KEY (`sid`),
KEY `parent` (`parent`)
) TYPE=MyISAM;
[code]

Ho can import my data? confused
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jan 30, 2005 - 6:54 AM:

Linker apparently really likes playing bingo. Anyhow, a slow but always-possible method is to use phpmyadmin with WSN and Linker DBs open in different windows and slowly rename Linker fields to their WSN equivilants, then delete extraneous Linker fields, then rename the linker tables to be the same names as the wsn tables, then export the data (not structure) from the Linker DB and import it into the WSN DB. Then regenerate counters in the WSN admin panel.

I might make an import script for it sometime, but I'm rather busy right now so it probably won't be soon.
naxtor
Beginner

Usergroup: Member
Joined: Jan 22, 2005

Total Topics: 1
Total Comments: 2
naxtor
Posted Jan 30, 2005 - 7:10 AM:

Is it more simple to create a php scripts that creates a "dump" from the old table using new fields name? confused
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.