Gossamer Forum
Home : Products : Gossamer Links : Discussions :

editor's pick - how to?

Quote Reply
editor's pick - how to?
Dear All,

If I add a field to links table to flag some links as editor's pick, then I want to display the flagged links in a separated section which will appear before the regular links. Flagged links may still be built into regular links section. This is what yahoo have done. Is it easy to implement this in Links SQL NG and how to?

I appreciate your answering.

Long

Quote Reply
Re: editor's pick - how to? In reply to
Yes!

1. Go to Database->Links->Properties and hit Go.
2. Click on Add Column
3. Enter:
Column Name = EditorPick
Column Type = ENUM
Column Values = Yes No (one per line)
Default = No
Form Type = SELECT
Form Size = 1
Form Names = Yes No (one per line)
Form Values = Yes No (one per line)
4. You should now have the field in your database, then in your link.html template you do:
<%if EditorPick eq 'Yes'%>
special image/html here
<%endif%>

And that's it.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: editor's pick - how to? In reply to
Alex, this is pretty cool, I didn't realize that it was so easy. Just thought I might add that if you want to make the editor's picks show at the top of the category or your search results, just add the EditorPick field to the front of your buid settings for sorting the categories and searches.


Rob Bartlett
AAA Internet Publishing, Inc.
http://www.AAAInternet.com
Quote Reply
Re: editor's pick - how to? In reply to
Alex, Thank a lot. I implemented this very easily and it works great. But I need something fancier than this. Since now the editor's pick links scatter among other links, I want all Editor's Pick links under a certain categroy to appear at the top of other links as shown below:

Categories:

_______________________________________
Editor's Pick:

______________________________________
Links:


__________________________________________

Editor's pick may still or may not appear in regular links (it doesn't matter).

Best,

Long

Quote Reply
Re: editor's pick - how to? In reply to
Hi,

If you don't care about an extra title between Editor's Picks and regular links, then you can just set the sorting so Editors Pick shows up first. Usually if you add an icon beside each one this does the trick.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: editor's pick - how to? In reply to
Hey guys!!

Works great on my site!!

I did the same thing for sponsors. If a person places a banner ad, they show up at the top of their category.

Lance Rasmussen
Bowlingzone.com

Quote Reply
editor's pick - sorting problem In reply to
I once got this working with linksql beta, but somehow in linksql 2.01 links of EditorPick don't show up at the top.

In setup -> build, the setting for 'build_sort_order_category' is 'EditorPick, isNew, isPopular,Title'

After adding the EditorPick field to my links table I have resync my Database and a icon is able to show up along with links defined as EditorPick. Donno what's wrong.

Thanks for any help.

Yanz

http://www.biomedgate.com
****Portal to life****
Quote Reply
Re: editor's pick - how to? In reply to
Hey Alex, what if I *did* want a title to appear before the regular links? Is that possible?

Quote Reply
Re: editor's pick - sorting problem In reply to
Try using the following for your sort order. They changed the way it works in the final release, for some reason you now have to add the DESC part to some fields:

"EditorPick,isNew DESC,isPopular DESC,Title"



Rob Bartlett
AAA Internet Publishing, Inc.
http://www.AAAInternet.com
Quote Reply
Re: editor's pick - sorting problem In reply to
Thanks robfromaaa, it works.


Yanz


http://www.biomedgate.com
****Portal to life****