Is it Possible to add thousands of links if not using Linux

New Member Joined: Jul 15, 2004 Posts: 12

Hi Raven,

Question, If you are not using Linux, is there a script that will allow you to create the MySQL insert commands to enter thousands of links into the Web Links module?

I tried creating my own, and I get inserts, but not with the link data, just blank entries.

This is what I used:

INSERT INTO nuke_links_links,( lid, cid, sid, title, url, description, date, name, email, hits, submitter, linkratingsummary, totalvotes, totalcomments ),VALUES,'001','0',Shopping with Women,http://www.shoppingwithwomen.com/,No Description Available,OK (Jul 27, 2004),

The values are extracted from a table, using the column headers - but I don't quite understand how to make the values I am entering correspond to the columns in the existing Web Links table.

Can you help?

Thanks, Chandra

[/img]

Posted: Tue Jul 27, 2004 1:10 pm

Oops, forgot to say, that I'm using your 7.1 version

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

It has nothing to do with Linux Smile

. Is that a real INSERT state,emt? If so, an immediate issue is that you haven't quoted your text strings.

Posted: Tue Jul 27, 2004 5:45 pm

Ok, Raven

btw - hope you are enjoying your travels.

I should have included this bit of information at first.

How can I use the following phrase, without a Linux system, to create the MySQL commands for a load of web links, with the descriptions that I need to insert into my upgraded and empty Web Links db.

s/<li><a href="$[^"]*$">$.*$<\/a>$.*$$/INSERT INTO nuke_links_links
( lid, cid, sid, title, url, description, date, name, email, hits, submitter, linkratingsummary, totalvotes, totalcomments )
VALUES ( '0', '100', '0', '\2', '\1', '\3', '2003-06-23 06:05:45',
", ", ", ", ", ", ");/p

This is suggested at http://phpnuke.org/modules.php?name=PHP-Nuke_HOWTO&page=enter-thousands-of-web-links.html

But there is a note included, saying that it works in Linux.

I am not married to this method, if you know of another way I can get 3,500 links back into the database without having to type each one, I would love to hear it. Smile

Thanks, Chandra