Swithced fromWSN links to phplink and need to transfer DB of links

Hello all;

So I had to scratch the wsnlinks since I was coming up on a year and it's just not worth paying them again. I switched to php Link Directory and need to transfer the links (your links ) from the old DB format to the phpld one. Several thousand.

Is there a program for this? Here is the example of the formatfor WSNlinks;

INSERT INTO `wsnlinks_links` (`id`, `title`, `url`, `description`, `rating`, `votes`, `validated`, `catid`, `sumofvotes`, `email`, `time`, `hits`, `numcomments`, `hide`, `ownerid`, `voterips`, `voterids`, `lastedit`, `type`, `notify`, `suspect`, `pendingedit`, `funds`, `suspended`, `alias`, `expire`, `ip`, `inalbum`, `typeorder`, `recipurl`, `hitsin`, `recipwith`, `hitsinips`, `hitsoutips`, `lastcomment`, `related`, `inhidden`, `viewers`, `threadviewers`, `hitsintemp`, `hitsouttemp`, `origtype`, `importance`, `parentids`, `timesdead`, `timesemailed`, `threadclosed`, `threadposters`, `lastposterid`, `lastpostername`, `ownername`, `deleted`, `deletionreason`, `movedto`, `deletedby`, `timevalidated`, `filefield`, `message`, `sticky`, `downloads`, `pollid`, `posticon`, `savedby`, `pagerank`) VALUES
(1, 'Hip Hop Jewelry', 'http://www.misterbling.com', 'Bling bling, hip hop jewelry, iced out,', 5, 1, 1, 29, 5, 'sales@misterbling.com', 1124928720, 5, 0, 0, 1, '68.70.66.97 ', '', 1124928720, 'regular', '', 0, '', 0, 0, 0, 0, '68.70.66.97', 0, 9150, 'http://', 0, '', '', '', 0, '||||||', 0, '', '', 0, 1, '', 7, '|||24|||11|||', 0, 0, 0, '', 0, '', 'misterbling', 0, '', 0, 0, 1124928720, '0', '', 0, 0, 0, '', '', 0),

Code (markup):

And need it link this for phplinkdirectory;

INSERT INTO `PLD_LINK` (`ID`, `TITLE`, `DESCRIPTION`, `URL`, `CATEGORY_ID`, `RECPR_URL`, `RECPR_REQUIRED`, `STATUS`, `VALID`, `RECPR_VALID`, `OWNER_NAME`, `OWNER_EMAIL`, `OWNER_NOTIF`, `IPADDRESS`, `DATE_MODIFIED`, `DATE_ADDED`, `HITS`, `LAST_CHECKED`, `RECPR_LAST_CHECKED`, `PAGERANK`, `RECPR_PAGERANK`, `FEATURED`, `EXPIRY_DATE`, `NOFOLLOW`, `RECPR_ID`, `PAYED`, `LINK_TYPE`) VALUES (1, 'Hip Hop Directory', 'A hip hop directory.', 'http://www.bling-hip-hop-directory.com', 55, '', 0, 2, 1, 0, 'admin', 'admin@bling-hip-hop-directory.com', 0, '69.160.149.211', '2006-05-24 15:41:53', '2006-05-17 14:52:50', 2, '2006-05-17 14:52:50', NULL, 4, -1, 1, NULL, 0, '391398', 0, 4),
(2, 'Hip Hop Jewelry', 'Your urban fashion jeweler misterbling brings you the best of hip hop jewelry and bling bling', 'http://www.misterbling.com', 135, '', 0, 2, 1, 0, 'admin', 'admin@misterbling.com', 1, '69.160.149.211', '2006-05-24 14:59:47', '2006-05-24 14:57:01', 1, '2006-05-24 14:57:01', NULL, 4, -1, 0, NULL, 0, '156722', -1, 2),

Code (markup):

Obviously a few I can do manually but for thousands there has to be a method. thanks.

 

I would go to phpLD forum, they have a bunch of topnotch people there.

 

yep...go there and if you can't find what you are looking for ask someone there, there are people that will do that for you for a little donation