van het oude script staan de links hier :
---------------------------------------------------------------------------------
Tabel structuur voor tabel `my_category`
#
CREATE TABLE my_category (
cat int(11) NOT NULL default '0',
under int(11) NOT NULL default '0',
title varchar(40) default NULL,
info varchar(50) default NULL,
pathto varchar(250) NOT NULL default '',
ttlinks int(10) default '0',
KEY icat (cat),
KEY iunder (under),
KEY ipathto (pathto)
) TYPE=MyISAM;
#
# Gegevens worden uitgevoerd voor tabel `my_category`
#
INSERT INTO my_category VALUES (1, 0, 'Ijsselmeer', '', ':1:', 50);
INSERT INTO my_category VALUES (2, 0, 'Segeln', '', ':2:', 49);
INSERT INTO my_category VALUES (3, 0, 'Wassersport', '', ':3:', 15);
INSERT INTO my_category VALUES (4, 0, 'Jachthafen', '', ':4:', 267);
INSERT INTO my_category VALUES (5, 0, 'Jachtcharter', '', ':5:', 1);
INSERT INTO my_category VALUES (6, 0, 'Motorboot', '', ':6:', 7);
INSERT INTO my_category VALUES (7, 0, 'Jachtmakelars', '', ':7:', 9);
INSERT INTO my_category VALUES (8, 0, 'Surfen ( Kite )', '', ':8:', 22);
INSERT INTO my_category VALUES (9, 2, 'Makelars', '', ':2:9:', 31);
INSERT INTO my_category VALUES (10, 4, 'Noord - Holland', '', ':4:10:', 20);
INSERT INTO my_category VALUES (11, 4, 'Friesland', '', ':4:11:', 71);
INSERT INTO my_category VALUES (12, 4, 'Groningen', '', ':4:12:',
;
INSERT INTO my_category VALUES (13, 4, 'Drenthe', '', ':4:13:', 2);
--------------------------------------------------------------------
Tabel structuur voor tabel `my_links`
#
CREATE TABLE my_links (
idx int(11) NOT NULL default '0',
cat int(11) NOT NULL default '0',
title varchar(40) NOT NULL default '',
message varchar(255) default NULL,
link varchar(100) default NULL,
mod date NOT NULL default '0000-00-00',
updated date NOT NULL default '0000-00-00',
hits int(10) NOT NULL default '0',
lastip varchar(16) default NULL,
KEY icat (cat),
KEY ititle (title),
KEY imod (mod),
KEY iupdated (updated),
KEY ihits (hits)
) TYPE=MyISAM;
#
# Gegevens worden uitgevoerd voor tabel `my_links`
#
INSERT INTO my_links VALUES (0, 1, 'Havenwinkel Hoorn', '‘De Havenwinkel”, Supermarkt, Wäscherei im alten Innenhafen und im\r\nJachthafen, de Grashaven zu Hoorn, direkt am Ijsselmeer\r\nTäglich frisches Brot, frisches Gemüse,7Tage in der Woche geöffnet.\r\n', '
https://www.dehavenwinkel.nl/index_D.html', '2003-05-29', '0000-00-00', 6, '213.73.188.222');
INSERT INTO my_links VALUES (0, 7, 'boten te koop', 'boten zeilschepen te koop', '
https://www.botentekoop.nl/', '2003-05-29', '0000-00-00', 1, '213.73.188.222');
INSERT INTO my_links VALUES (0, 10, 'de zeil hoek', 'jachthaven noord holland', '
https://www.dezeilhoek.nl/', '2003-05-30', '0000-00-00', 1, '213.73.146.76');
INSERT INTO my_links VALUES (0, 10, 'hemmeland', 'jachthaven noord holland', '
https://www.hemmeland.nl/', '2003-05-30', '0000-00-00', 0, NULL);
INSERT INTO my_links VALUES (0, 10, 'jachthavenstenhuis', 'jachthaven /nh', '
https://www.jachthavenstenhuis.nl/', '2003-05-30', '0000-00-00', 0, NULL);
INSERT INTO my_links VALUES (0, 10, 'nicolaas witsen', 'jachthafen.', 'https:///www.nicolaaswitsen.nl/', '2003-05-30', '0000-00-00', 0, NULL);
INSERT INTO my_links VALUES (0, 10, 'ed peek', 'jachthafen reparatie -verkoop-huur-faciliteiten', '
https://www.ed-peek.nl/', '2003-05-30', '0000-00-00', 1, '213.73.146.76');
INSERT INTO my_links VALUES (0, 10, 'kemper watersport', 'jachthafen-reparatie-huur', '
https://www.kemperswatersport.nl/', '2003-05-30', '0000-00-00', 0, NULL);
INSERT INTO my_links VALUES (0, 10, 'jachthaven-regattacentre', 'moderne jachthaven', '
https://www.regattacenter.com/', '2003-05-30', '0000-00-00', 0, NULL);
INSERT INTO my_links VALUES (0, 10, 'jachthafen maarten', 'jachthafen', '
https://www.maartenfokke.nl/index_pc.html', '2003-05-30', '0000-00-00', 0, NULL);
--------------------------------------------------------------------------------
en ze moeten naar :
----------------------------------------------------------------------------
Tabel structuur voor tabel `wsnlinks_categories`
#
CREATE TABLE wsnlinks_categories (
id int(11) NOT NULL auto_increment,
name text NOT NULL,
parent int(11) NOT NULL default '0',
validated int(11) NOT NULL default '0',
description text NOT NULL,
time int(11) NOT NULL default '0',
parentnames text NOT NULL,
parentids text NOT NULL,
numlinks int(11) NOT NULL default '0',
hide int(11) NOT NULL default '0',
lastlinktime int(11) NOT NULL default '0',
custom text NOT NULL,
UNIQUE KEY id (id)
) TYPE=MyISAM;
#
# Gegevens worden uitgevoerd voor tabel `wsnlinks_categories`
#
INSERT INTO wsnlinks_categories VALUES (1, 'Segeln / Sailing', 0, 1, 'Segeln, Sailing Charters', 1054641256, '', '', 0, 0, 0, '');
INSERT INTO wsnlinks_categories VALUES (2, 'Motorboot / Motorboats', 0, 1, '', 1054641304, '', '', 0, 0, 0, '');
INSERT INTO wsnlinks_categories VALUES (3, 'Ijsselmeer Holland', 0, 1, 'Ijsselmeer / Markermeer / Wassersportbörse / Yachtbrokerage', 1054641345, '', '', 0, 0, 0, '');
INSERT INTO wsnlinks_categories VALUES (4, 'Jachtmakelars / Yachtbrokerage', 0, 1, '', 1054641403, '', '', 0, 0, 0, '');
INSERT INTO wsnlinks_categories VALUES (5, 'Bootvermietung / Rent A Boat', 0, 1, '', 1054641586, '', '', 0, 0, 0, '');
INSERT INTO wsnlinks_categories VALUES (6, 'Wassersports / Watersports', 0, 1, 'Holländisches Wassersportportal / Dutch watersports Portal', 1054641675, '', '', 0, 0, 0, '');
INSERT INTO wsnlinks_categories VALUES (7, 'General Information', 3, 1, '', 1054642623, 'Ijsselmeer Holland', '3', 0, 0, 0, '');
INSERT INTO wsnlinks_categories VALUES (8, 'Jachthafen / Harbors', 3, 1, '', 1054642677, 'Ijsselmeer Holland', '3', 0, 0, 0, '');
INSERT INTO wsnlinks_categories VALUES (9, 'Online Shops', 6, 1, '', 1054644506, 'Wassersports / Watersports', '6', 0, 0, 0, '');
INSERT INTO wsnlinks_categories VALUES (10, 'races / regatta's NL', 1, 1, '', 1054644593, 'Segeln / Sailing', '1', 0, 0, 0, '');
INSERT INTO wsnlinks_categories VALUES (11, 'races/regatta's EU', 1, 1, '', 1054644634