Comments on Import from Linker

•naxtor Beginner Usergroup: Member Joined: Jan 22, 2005 Total Topics: 1 Total Comments: 2	•naxtor #1 - Quote - Permalink 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?
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7867	•Paul #2 - Quote - Permalink 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 #3 - Quote - Permalink 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?

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