Linker 2.0.4 to ArFooo Directory 1.0.5

[Eduardo]

Hi.. i want to change my old linker directory to a new arfooo directory script, can you make a script to export all my links to the new Arfooo DB?

I attach the SQL database structure, if you need something else... please tell me

Thank you in advance...

Code: Select all

CREATE TABLE LINKER_CAT(
sid mediumint default '0' not null,
parent mediumint default '-1' not null,
pparent mediumint default '-1' not null,
relate mediumint default '-1' not null ,
path varchar(255) not null,
pathtxt text,
sub_cat mediumint default '0' not null,
sub_link mediumint default '0' not null,
count mediumint default '0' not null,
uptime int(10) not null,
lasttime int(10) not null,
c_view enum('0','1') default '1' not null,
c_link enum('0','1') default '1' not null,
c_sub enum('0','1','2') default '1' not null,
title char(40) not null,
descript varchar(255),
meta_key varchar(255),
header text,
footer text,
bingo1 varchar(100),
bingo2 varchar(100),
bingo3 varchar(100),
bingo4 varchar(100),
bingo5 varchar(100),
primary key(sid),
INDEX parent (parent),
INDEX pparent (pparent)
);

insert into LINKER_CAT set path='0',pathtxt='HOME',uptime='0',lasttime='0',title='HOME',c_sub='2',c_link='0';


CREATE TABLE LINKER_LINK(
sid integer not null,
parent integer not null,
path char(255) not null,
pathtxt text,   
title varchar(50) not null,
url varchar(255),
name varchar(25),
email varchar(100),
scont varchar(255),
lcont text,
uptime int(10),
passwd varchar(20),
c_new enum('0','1') default '0' not null,
c_pick enum('0','1') default '0' not null,
count mediumint default '0' not null,
visit mediumint default '0' not null,
comment smallint default '0' not null,
upfile varchar(255),

n1 mediumint default '0',
n2 mediumint default '0',
n3 mediumint default '0',
n4 mediumint default '0',
n5 mediumint default '0',
n6 mediumint default '0',
n7 mediumint default '0',
n8 mediumint default '0',
n9 mediumint default '0',
n10 mediumint default '0',

user1 varchar(150),
user2 varchar(150),
user3 varchar(150),
user4 varchar(150),
user5 varchar(150),

bingo1 varchar(100),
bingo2 varchar(100),
bingo3 varchar(100),
bingo4 varchar(100),
bingo5 varchar(100),

primary key(sid),
INDEX parent (parent)
);


CREATE TABLE LINKER_COM(
sid mediumint default '0' not null,      
parent mediumint not null ,
content varchar(255),
email varchar(100),
home varchar(150),
name varchar(40),
ipaddr char(15),
vote int(2) default '1' not null,
uptime int(10),
passwd varchar(20),
primary key(sid),
INDEX comment (parent)   
);


CREATE TABLE LINKER_WAIT(
sid mediumint default '0' not null,   
parent integer not null,
path char(255) not null,
title varchar(50) not null,
url varchar(255),
name varchar(25),
email varchar(100),
scont varchar(255),
lcont text,
passwd varchar(20),
upfile varchar(255),
user1 varchar(150),
user2 varchar(150),
user3 varchar(150),
user4 varchar(150),
user5 varchar(150),

primary key(sid)
);


CREATE TABLE LINKER_TWORD (
  sid mediumint(9) not null primary key,
  kword varchar(50) not null,
  count int(11) default '1',
  unique key kword (kword)
);


CREATE TABLE LINKER_MAIL(
email varchar(100) not null primary key,
uptime int(10)
);


The url for the Linker 2.0.4 is: http://enproject.codelib.co.kr/

[Arf]

Hi and welcome Eduardo,
Of course, I will create as soon as possible the migration script for this directory.
As these are the holidays, we will have to wait a bit.
regards,
Arf.

[Eduardo]

Thank you Arf... you're cool!

[Arf]

Hi Eduardo,

Did you create a file htacess to rewrite the urls of linker 2.0.4?
I saw that the script is really old whit many duplicat content...
The migration script will be available tomorrow.

Best regards,
Arf.

[Eduardo]

Hello,
Thank you for making this migration.

Definitely linker is a very old script , and precisely I think many people who have used this script are looking for change by another script more modern (like Arfooo Directory) , I believe that this migration will allow many people to switch to a better system.

Thanks and greetings

[Arf]

Hi,

the migration script is online.

Arf

[Eduardo]

Cool!!! you rock bro!!!

I will test it to nigth...

Thx