Gossamer Forum
Home : Products : Gossamer Links : Discussions :

SQL 2.x capabilities - would like to upgrade

Quote Reply
SQL 2.x capabilities - would like to upgrade
Hi All

I'd like to switch to Links SQL 2, but I've added many features to my flatfile system that I'm not sure are available or compatible with SQL 2, though I know that some of these are available for 1.x. I've been hunting around (searches, Gossamer FAQ, demo site, user sites) and looking at various FAQ sites (thank you for these!), but I still have a few questions about features and functions. I've installed some mysql stuff before. So, I can do a little of the speak. If anyone is able to help me out with these, I would be most grateful.

In no particular order:

1. Adding Extra tags in links.cfg
I know that there is no links.cfg in SQL, but what is nice in flatfile is that we could just add extra tags and their contents in links.cfg and then plug them into the templates. Is there something like this in SQL?

2. Site Map (Tree)
Is there a static site map or tree building function? I found something called treelinks doing some searches, but I couldn't find anything that describes this.

3. Adding Fields - links
I have to add about 10 extra fields, including Image, additional description fields, and a few others.

4. Adding Fields - categories
I'd love to add Category Heading and Meta Title fields. The Category Heading would be an additional description field that would go below the category title on that cat page. The Meta Title would be in addition to the Meta Descrip and Meta Keywords fields.

5. Universal Header and Footer
This would be a site-wide header and footer (added to template pages, as well), instead of just category header/footer.

6. Extra Static Templates
Yes, I found this over at Pugdog's FAQ. Thanks! I need to about 6 more static template pages like Policy, Help, etc.

7. Webring Mod
This creates Next and Prev links within each category of detailed pages. The user doesn't have to jump back to the category page. They can stay on the detail page and jump to the next detail page.

8. Bulk additions, deletions, modifications
When adding a category, I might have upwards of 5,000 items. I'd like to be able to use a text file and import the whole list all in one shot, rather than having to add one item at a time. Also, if I just wanted to modify a current database or table, and still keep what is already installed, can I do this, or do I have to reinstall the entire list (including the additional material)? I'd like to be able to do selective bulk deletions, as well. Like, all files in X category beginning with the letter Q, or older than 6 weeks, etc.

9. Backup
Can we make backups of the mysql db's?

10. Yahoo 2.1 Style Subcats
In addition to being able to show linked subcats, I'd also like to be able to include a descrip of the main cat below the cat name but above the subcats.

Main Cat
description...
sub1, sub2, sub3...

11. Hopto Mod
Ability to jump from one main cat to any other main cat

12. List Category Subcats in sidebar
Create a list of a Main Cat's subcats and place them in the side bar.

13. Priority Mod
I know that this exists for 1.x, but is it available for 2.x ?

14. AltaVista-style Span Pages

15. Multi link.html templates within same category AND from category to category
A - Vary link template WITHIN category (could switch between link1a.html and link1b.html back and forth within a single category)
B - Could use link1.html for cat 1, and link2.html for cat 2. I saw something like this where you can enable different template sets for each category, but is there a way to just have 2 link.html's instead of 2 separate template sets?

16. Vary vary numbers of columns for home page versus category and subcat pages.

17. Category Pic
I believe Pugdog has this for 2.x, but is Pugdog running an "NG" version that is different? Is this also the upload mod?

18. Jump to detail and Random jump to detail. I want to display items for sale. So, for these categories, I want jump.cgi to go to an internal link, rather than external. To do this in the flatfile, I had to modify jump.cgi to build a separate URL db to search for the random function.

19. Build static detailed pages under their respective categories and subcategories. I happen to like this, rather than having one large detail directory.

20. Build homepage in root doc directory, but the rest of the pages are built within a subdirectory

/index.html
/subcat/rest-of-links

21. Related Links - like related categories, but you can specify links

Sorry for such a long list. I've been trying to piece things together, and I look forward to upgrading. I appreciate your help.

Super Thanks Smile

DT

Subject Author Views Date
Thread SQL 2.x capabilities - would like to upgrade DogTags 2771 Jul 29, 2001, 9:34 AM
Thread Re: SQL 2.x capabilities - would like to upgrade
pugdog 2717 Jul 29, 2001, 4:10 PM
Thread Re: SQL 2.x capabilities - would like to upgrade
DogTags 2705 Jul 29, 2001, 11:16 PM
Thread Re: SQL 2.x capabilities - would like to upgrade
Alex 2678 Jul 31, 2001, 12:03 AM
Thread Re: SQL 2.x capabilities - would like to upgrade
DogTags 2684 Jul 31, 2001, 2:43 AM
Thread Re: SQL 2.x capabilities - would like to upgrade
pugdog 2703 Jul 31, 2001, 2:14 PM
Post Re: SQL 2.x capabilities - would like to upgrade
DogTags 2637 Aug 2, 2001, 3:51 AM
Post Re: [pugdog] SQL 2.x capabilities - would like to upgrade
DogTags 2496 Sep 15, 2001, 6:20 PM