Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Links 2.0 to Links SQL. With all links 2 mods?

Quote Reply
Links 2.0 to Links SQL. With all links 2 mods?
I currently have Links 2 with several mods installed.

"Tell A Friend Script", "SUBCATEGORIES LIKE YAHOO v2.1" and the "Yahoo Map Mod".

My links.def and category.def files have also been modified.

If I upgrade to Links SQL will I be able to use these mods? If so, how would I go about doing it?

If someone could take a look at our site and let me know if this can be done in links sql I would really appreciate it. www.everythingelpaso.com

Thanks,

RCWolfie
Quote Reply
Re: [rcwolfie] Links 2.0 to Links SQL. With all links 2 mods? In reply to
Hi,

All custom fields are carried over from Links2 to Links SQL - they are added automatically by the import wizard.

The sub-categories like Yahoo mod can be achieved using the free Yahoo sub-categories plugin.

The tell a friend functionality is also available via a plugin I made (see attached file).

I'm not sure what the map mod is.
Quote Reply
Re: [Paul] Links 2.0 to Links SQL. With all links 2 mods? In reply to
Paul,

Plain and simple, can I get everything that I have on my site now if I transfer to Links SQL?

Take a look at the links.def file:

Code:


# Database Definition: LINKS

# --------------------------------------------------------

# Definition of your database file.

%db_def = (

ID => [0, 'numer', 5, 8, 1, '', ''],

Title => [1, 'alpha', 40, 75, 1, '', ''],

URL => [2, 'alpha', 40, 150, 0, '', '^http|news|mailto|ftp'],

Date => [3, 'date', 15, 15, 1, \&get_date,''],

Category => [4, 'alpha', 0, 150, 1, '', ''],

Description => [5, 'alpha', '40x3', 5000, 0, '', ''],

'Contact Name' => [6, 'alpha', 40, 75, 1, '', ''],

'Contact Email' => [7, 'alpha', 40, 75, 0, '', '.+@.+\..+'],

Hits => [8, 'numer', 10, 10, 1, '1', '\d+'],

isNew => [9, 'alpha', 0, 5, 0, 'Yes', ''],

isPopular => [10, 'alpha', 0, 5, 0, 'No', ''],

Rating => [11, 'numer', 10, 10, 1, 10, '^[\d\.]+$'],

Votes => [12, 'numer', 10, 10, 1, 1, '^\d+$'],

ReceiveMail => [13, 'alpha', 10, 10, 1, 'Yes', 'No|Yes'],

Graphic => [14, 'alpha', 40, 300, 0, '', '^http|news|mailto|ftp'],

Gwidth => [15, 'alpha', 5, 5, 0, '101', ''],

Gheight => [16, 'alpha', 5, 5, 0, '15', ''],

Priority => [17, 'alpha', 0, 5, 1, 'No', 'No|Yes'],

isLinked => [18, 'alpha', 0, 5, 1, '', 'No|Yes'],

Address => [19, 'alpha', 40, 75, 1, '', ''],

City => [20, 'alpha', 40, 75, 1, '', ''],

State => [21, 'alpha', 40, 75, 1, '', ''],

Zip_Code => [22, 'alpha', 40, 75, 1, '', ''],

Phone => [23, 'numer', 40, 75, 1, '', ''],

Map => [24, 'alpha', 0, 5, 0, '', 'No|Yes'],

Driving => [25, 'alpha', 0, 5, 0, '', 'No|Yes'],

Fax => [26, 'numer', 40, 75, 0, '', ''],

Profile => [27, 'alpha', 0, 5, 0, '', 'No|Yes'],

Coupon => [28, 'alpha', 40, 150, 0, '', '^http|news|mailto|ftp'],

Job => [29, 'alpha', 40, 150, 0, '', '^http|news|mailto|ftp'],

AltCategories => [30, 'alpha', 0, 500, 0, '', ''],

Logo => [31, 'alpha', 40, 300, 0, '', '^http|news|mailto|ftp'],

Lwidth => [32, 'alpha', 5, 5, 0, '', ''],

Lheight => [33, 'alpha', 5, 5, 0, '', '']

);



# Database file to use -- defined in links.cfg.

$db_file_name = $db_links_name;

# Counter file to use -- defined in links.cfg.

$db_id_file_name = $db_links_id_file_name;

# The column name for the database key.

$db_key = 'ID';

# Database delimeter.

$db_delim = '|';

# Title used in admin output.

$html_title = 'Directory Database';

$html_object = 'Link';

# Field Number of some important fields. The number is from %db_def above

# where the first field equals 0.

$db_alt = 30;

$db_title = 1; $db_url = 2; $db_modified = 3; $db_category = 4; $db_contact_name = 6; $db_contact_email = 7; $db_hits = 8; $db_isnew = 9; $db_ispop = 10; $db_rating = 11; $db_votes = 12; $db_mail = 13; $db_priority = 17; $db_islinked = 18;

$db_address = 19; $db_city = 20; $db_state = 21; $db_zip_code = 22; $db_phone = 23; $db_Map = 24; $db_Driving = 25; $db_Profile = 27;

# Field number to sort links by:

$db_sort_links = 1;

# Field names you want to allow visitors to search on:

@search_fields = (1,2,5,19,22,23);

# System defaults. When adding new links or modifying links, these fields

# can not be overwritten by a user.

%add_system_fields = (

isNew => 'Yes',

isPopular => 'No',

Hits => '1',

Priority => 'No',

isLinked => 'No',

Rating => 10,

Votes => 1,

ReceiveMail => 'Yes',

Gwidth => '101',

Gheight => '15',

Map => 'No',

Driving => 'No',

Profile => 'No'

);

# Hash of column names to possible options. If you want to use a select form

# field, you can use &build_select_field in your HTML page. This routine will

# make a <SELECT> input tag using the following values:

%db_select_fields = (

isNew => 'Yes,No',

isPopular => 'Yes,No',

ReceiveMail => 'Yes,No',

Priority => 'Yes,No',

isLinked => 'Yes,No',

Map => 'Yes,No',

Driving => 'Yes,No',

Profile => 'Yes,No'

);

# Hash of column names to radio values. If you use &build_radio_field, it will

# make a <INPUT TYPE="RADIO"> tag for you using the options specified in the hash.

%db_radio_fields = ( );

# Maximum number of hits returned in a search. Can be overridden in the search

# options.

$db_max_hits = 10;

# Use the built in key tracker.

$db_key_track = 1;

# ===========================================================================

# Build up some variables from your definitions. Internal use only.

@db_cols = ();

foreach (sort { $db_def{$a}[0] <=> $db_def{$b}[0] } keys %db_def) {

push (@db_cols, $_);

$db_sort{$_} = $db_def{$_}[1];

$db_form_len{$_} = $db_def{$_}[2];

$db_lengths{$_} = $db_def{$_}[3];

$db_not_null{$_} = $db_def{$_}[4];

$db_defaults{$_} = $db_def{$_}[5];

$db_valid_types{$_} = $db_def{$_}[6];

($_ eq $db_key) and $db_key_pos = $db_def{$_}[0];

}

1;



I just want to make sure that I can get all this into the Links SQL.

Thanks

RCWolfie
Quote Reply
Re: [rcwolfie] Links 2.0 to Links SQL. With all links 2 mods? In reply to
Yes, all custom fields you added in Links 2 are automatically created in Links SQL, so all the data you have is imported.

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [rcwolfie] Links 2.0 to Links SQL. With all links 2 mods? In reply to
If you did not change the original date format, the Links 2.0 database will be imported without problem.
I'm not sure there is a Yahoo Map plugin on LSQL. You may contact the original author, if he as a 'Yahoo Map plugin' for LSQL.

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Quote Reply
Re: [webmaster33] Links 2.0 to Links SQL. With all links 2 mods? In reply to
if you changed the date format, i can send you a smal script which

converts the date format. but it is written for my own use so it is

not very usual in practice Pirate

eljot
Quote Reply
Re: [eljot] Links 2.0 to Links SQL. With all links 2 mods? In reply to
Well, it it enough to change 2 lines in L2S2.pm module in such case.

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Quote Reply
Re: [webmaster33] Links 2.0 to Links SQL. With all links 2 mods? In reply to
any changes which I've made in this pm around
the date format produce an fatal error.
my script also sort the fields as I would like use it
in links sql. but this has no effect as I've described
in another tread.

Best regards from
Bremen/Germany

Lothar