Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

Upgrade Customized Links>>>Links SQL

Quote Reply
Upgrade Customized Links>>>Links SQL
I run a customized links 2.0 for advertisments, not as a search-engine.

Can I change to links sql, without customizing the templates again?

Just change the config files?

Michael

Quote Reply
Re: Upgrade Customized Links>>>Links SQL In reply to
You can use the templates that you are using now, however your modifications will not work in Links SQL

Paul Wilson. Shocked
(Dont blame me if I'm wrong!)
Quote Reply
Re: Upgrade Customized Links>>>Links SQL In reply to
Mhhm,

do I need to customize agian, or is it not possible to customize?

I need a lot of additional fields.

Michael

Quote Reply
Re: Upgrade Customized Links>>>Links SQL In reply to
The additional fields are no problem but because Links SQL uses a MySQL database to store its data then you may have to modify your modifications to work with MySQL and LinksSQL otherwise it is Internal Server Error city.....

Paul Wilson. Shocked
(Dont blame me if I'm wrong!)
Quote Reply
Re: Upgrade Customized Links>>>Links SQL In reply to
Maybe I must phrase it with other words :)

What do I need to change?

I customized links 2.0 a lot of times. Is there any problem to do the same with sql?

Michael

Quote Reply
Re: Upgrade Customized Links>>>Links SQL In reply to
No, you can customize LinksSQl as long as you know what you are doing.

I don't know what you need to change as I don't know what you changed, do I !

Paul Wilson. Shocked
(Dont blame me if I'm wrong!)
Quote Reply
Re: Upgrade Customized Links>>>Links SQL In reply to
It took me two months to convert ten formal modification and twenty or so custom mods I wrote for Links 2.0 into LINKS SQL v.1.12.

Happy coding...as junko says...be prepared to spend some time upgrading those MODS. However, keep in mind that with the NEW plugin system for NG version, it will be easier...not easy...EASIER.

Good luck!

Regards,

Eliot Lee
Quote Reply
Re: Upgrade Customized Links>>>Links SQL In reply to
Eliot,

I like to work with links 2.0 very much, because I know it since years and customized it so many times for a lot of different projects.

Problem is that links 2.0 probably canīt handle unlimited data. I have some databases which does not build up without problems. Building stops, and I need to reduce the links on each site down to 25 or so.

For example db with approx. 47 fields and 400 entries .... unstable ...

db with regular fields and 2000 entries ...... unstable

I was thinking about sql that it could handle this better, so i can set 50 or 100 entries on each site.

Whatīs so complicated to customize sql?

I just need more fields. Modifying the templates canīt be so complicated.

Michael

Quote Reply
Re: Upgrade Customized Links>>>Links SQL In reply to
In Reply To:
Whatīs so complicated to customize sql?
Uh...because you basically have to RE-WRITE most of the MODs written for Links 2.0 (flat file version).

The routines and processes are TOTALLY different. For instance, rather than OPENing, WRITing, MODIFYing, and DELETing data from a flat file, you have to access an actual database, typically MySQL, which means changing the syntax of the scripts to work with MySQL.

In addition, Links SQL operates under mod_perl and strict, meaning that the Perl codes in LINKS 2.0 would have to be re-written to work with Links SQL!

That is why it is not a piece of cake to upgrade as you have assumed.

Good luck!

Regards,

Eliot Lee
Quote Reply
Re: Upgrade Customized Links>>>Links SQL In reply to
What about just adding more fields?

This should not make trouble, isnīt it?

Michael

Quote Reply
Re: Upgrade Customized Links>>>Links SQL In reply to
Adding extra fields is not a problem.

Regards,

Eliot Lee
Quote Reply
Re: Upgrade Customized Links>>>Links SQL In reply to
Hi,

I think you'll find making mods for Links SQL is easier then Links 2.0. The interface to access data is documented in the help (i.e. to insert, delete, search on users, links or categories is very easy).

Also, there is a web based interface to do a lot of structure changes (adding columns, etc).

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Upgrade Customized Links>>>Links SQL In reply to
I have to agree with Alex on this.

Once you get past the learning curve (and GT has done whatever they could to lessen it), you'll be able to generate modifications fairly quickly and easily, since you won't have to study all the various library routines. You'll just have to create a plug-in or global tag, and make sure it's mod_perl compatible. That's all.



PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://LinkSQL.com/FAQ