Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Featured Listing & Admin Add Links Questions

Quote Reply
Featured Listing & Admin Add Links Questions
I am a new owner of LinksSQL after using Hyperseek for the past 3 years. I'm really getting into this product, and I think it's great :)

However, I've come across two issues that I need help solving...

1] Featured Listings/Sponsors: Most of our links are free, however, we have a very small percentage of our links that are paid by sponsors. For their sponsorship, we give them priority placement over the over links in their category. On the Hypseek, we used the "Cool Links" feature where if links had a rating higher than "x", then it would be marked as "cool" (which we just changed to 'sponsors'). How can I recreate that on here?

2] Admin Additions. I want to have one of my employees add a few thousand links from our old site however, I'd like the link owners to be able to change them in the future. Is there a way to add links from the admin side (with the link owner's email), and allow the link owner to be able to change it in the future?

Thanks for your help!
Quote Reply
Re: [Me2Be] Featured Listing & Admin Add Links Questions In reply to
1) Quite easy. Just follow these instructions;

~ Click on Database > Links (drop) > Properties (drop)

~ Then at the bottom of the page there is a link called 'Add Column'. Click this.

~ Then set as follows;

Column Name - Priority
Column Type - INT
Form Display - Priority
Form Type - Select
Form Size - 4
Form Names - 1 then return, then 0
Form Values - Yes then return then No
Search Weight - 0

Then press Add Field To Links


~ Then add another field as follows;

Column Name - PriorityImage
Column Type - TEXT
Form Display - Priority Image
Form Type - Text
Form Size - 12
Search Weight - 0

Then press Add Field To Links again.

Then in your link.html template add the following (or similar);

<%if Priority%>
<%PriorityImage%>
<%endif%>

I'm not sure about the other question, but hopefully this will answer your first question thoroughly Smile

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [AndyNewby] Featured Listing & Admin Add Links Questions In reply to
Thanks for your help Andy! Well, the "sponsor" image works great, however, it doesn't prioritize the listing above the rest of the regular listings. What I'm trying to accomplish is:
--> Sponsor Listing
--> Sponsor Listing
--> Regular Listing
--> Regular Listing
--> Regular Listing
--> Regular Listing

Can you help me with this too? :)
Quote Reply
Re: [Me2Be] Featured Listing & Admin Add Links Questions In reply to
Ooops...forgot one major thing. Goto;

Setup > Build Options

Then find build_sort_order_category and add in Priority DESC, like so;

Priority DESC, isNew DESC,isPopular DESC,Title

Sorry about that. I'm such a scatter brain Crazy

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [AndyNewby] Featured Listing & Admin Add Links Questions In reply to
In Reply To:
Sorry about that. I'm such a scatter brain Crazy
That worked perfectly Andy -- thank you!

Sounds like you and I are having the same kind of day today, except I'm a scatter brain more often than not lately ;)
Quote Reply
Re: [Me2Be] Featured Listing & Admin Add Links Questions In reply to
Quote:
Admin Additions. I want to have one of my employees add a few thousand links from our old site however, I'd like the link owners to be able to change them in the future. Is there a way to add links from the admin side (with the link owner's email), and allow the link owner to be able to change it in the future?


You would need to import the users first. Once the users are imported, when you hit add, you can enter the username into the LinkOwner field.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Featured Listing & Admin Add Links Questions In reply to
In Reply To:
You would need to import the users first. Once the users are imported, when you hit add, you can enter the username into the LinkOwner field.
Quote Reply
Re: [Me2Be] Featured Listing & Admin Add Links Questions In reply to
Did you mean to say something in that reply?

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [AndyNewby] Featured Listing & Admin Add Links Questions In reply to
In Reply To:
Did you mean to say something in that reply?


Yes, must have deleted it before I posted (talk about scatterbrained)!

My question was, I don't have a previous version of Links, only the information on an excel spreadsheet. Is there a way to import the users that way?
Quote Reply
Re: [AndyNewby] Featured Listing & Admin Add Links Questions In reply to
Hi guys,

I'm having problems getting this priority links mod to work in Links SQL 2.1

I had it working perfectly in version 2.05 and "premium" links displayed at the top of the "list" for both search results and in the general category views.

However, in 2.1 the display premium listings above all others has stopped working for the build_sort_order_search (search results) view: in fact the premium links appear at the bottom of the pile!

Any ideas?

Hannah
Quote Reply
Re: [hannahmackenzie] Featured Listing & Admin Add Links Questions In reply to
Yes, please -- has anyone gotten this to work in SQL 2.1.0??



Please let us know if you do . . .

I've already made the mistake of installing a 2.0.5 mod into my 2.1.0 version.

Also, I've contact run-down.com and they don't have a version of the "featured" and/or "priority" mod for SQL 1.11.



Didn't realize so many mods, plug-ins, etc. would only work with 2.0.5 Unsure
A. Lougheed
IndyLinks.com
webmaster@indylinks.com
Quote Reply
Re: [aprillougheed] Featured Listing & Admin Add Links Questions In reply to
The priority mod is working for me on 2.1 just as Andy explained it -- not sure why it isn't working for you!
Quote Reply
Re: [hannahmackenzie] Featured Listing & Admin Add Links Questions In reply to
I'm having the same issue. My priority links are at the bottom. I have it set to:

Has_Priority,Has_Rating,isNew DESC,isPopular DESC,Title