Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Will this work?

Quote Reply
Will this work?
Hey everyone,

First off, thanks for reading my post. I just purchased a license for LinksSQL from my friend who re-sold it to me for like $30 (his site went under)...

Anyway, I currently run Links 2 on my site, www.digital-sea.com, and want to know how difficult it would be to integrate my current database (with 5,000+ links) to LinksSQL.

Just for reference, here is my links.cfg file:

Code:
# Database Definition: LINKS
# --------------------------------------------------------
# Definition of your database file.
%db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
Title => [1, 'alpha', 40, 75, 1, '', ''],
DownloadURL => [2, 'alpha', 40, 75, 1, '', '^http|news|mailto|ftp'],
Date => [3, 'date', 15, 15, 1, \&get_date, ''],
DateAdded => [4, 'date', 15, 15, 0, \&get_date, ''],
Category => [5, 'alpha', 0, 150, 1, '', ''],
ShortDescription => [6, 'alpha', 40, 150, 1, '', ''],
Description => [7, 'alpha', '40x3', 1000, 0, '', ''],
Size => [8, 'alpha', 40, 75, 1, '', ''],
Version => [9, 'alpha', 40, 75, 1, '', ''],
System => [10, 'alpha', 0, 75, 1, '', ''],
Licence => [11, 'alpha', 40, 75, 1, '', ''],
Price => [12, 'alpha', 40, 75, 0, '', ''],
Language => [13, 'alpha', 0, 75, 1, '', ''],
'Contact Name' => [14, 'alpha', 40, 75, 1, '', ''],
'Contact Email' => [15, 'alpha', 40, 75, 1, '', '.+@.+\..+'],
Website => [16, 'alpha', 40, 75, 0, '', '^http|news|mailto|ftp'],
Hits => [17, 'numer', 10, 10, 1, '0', '\d+'],
isNew => [18, 'alpha', 0, 5, 0, 'No', ''],
isPopular => [19, 'alpha', 0, 5, 0, 'No', ''],
isPick => [20, 'alpha', 0, 5, 0, 'No', ''],
Rating => [21, 'numer', 10, 10, 1, 0, '^[\d\.]+$'],
Votes => [22, 'numer', 10, 10, 1, 0, '^\d+$'],
ReceiveMail => [23, 'alpha', 10, 10, 1, 'Yes', 'No|Yes']
);

Would importing my data into LinksSQL cause any problems? Some of my links have null values (like no Website listed). Also, which options would I select in LinksSQL when I import to make sure that the database is kept in tact and like the original?

Thanks in advance!

-digitalsea
http://www.digital-sea.com/

Last edited by:

digitalsea: Jul 30, 2003, 9:28 AM