Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Priority sort order

Quote Reply
Priority sort order
I currently have three levels for links:
- Premium
- Value
- Basic
and they display in that order because the column (PriorityTier) is first in build_sort_order_category.

I'd now Value not to display in the second tier but to display alphabetically along with Basic (it will be distinguished by colour etc). I can't figure out how to do this - I either get everything displayed alphabetically or Premium and Value displayed at the top.

Can I keep the PriorityTier column and get the sorting to work through links.html, which is currently set up as:

Code:
<%if PriorityTier eq 'Premium'%>
Premium listing html
<%endif%>

<%if PriorityTier eq 'Value'%>
Value listing html
<%endif%>

<%if PriorityTier eq 'Basic'%>
Basic listing html
<%endif%>

Thanks for any help!
Quote Reply
Re: [iplay] Priority sort order In reply to
Hi,

I guess it depends. What do you currently have set in build_category_sort_order in Setup > Build Options?

Cheers

Andy (mod)
andy@ultranerds.co.uk


IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Quote Reply
Re: [Andy] Priority sort order In reply to
Thanks Andy. At present it is:

PriorityTier DESC,Title

Thanks,
--Jo
Quote Reply
Re: [iplay] Priority sort order In reply to
Hi,

Mmm. I think that should already do what your asking :/ (unless I'm mis-understanding you =))

Cheers

Andy (mod)
andy@ultranerds.co.uk


IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Quote Reply
Re: [Andy] Priority sort order In reply to
I probably didn't explain well. The setup is as mentioned, but doesn't produce the output I need, which is as follows:

premium listing X
premium listing Y
basic listing A
basic listing B
value listing C
basic listing D
value listing E
basic listing F
basic listing G

(Value and Basic listings are in strict alphabetical order, but Premium listings go at the top regardless.)

Any ideas? :)

PS: I think I can see how it could be done with another column to define a value listing separately, but if possible I'd rather have the 3 levels together in the PriorityTier column.

Thanks,
--Jo
Quote Reply
Re: [iplay] Priority sort order In reply to
Hi,

Ah, I see.

Yeah, you prob need a new field Smile

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk


IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Quote Reply
Re: [iplay] Priority sort order In reply to
Hi,

Ah, I see.

Yeah, you prob need a new field Smile

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk


IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Quote Reply
Re: [Andy] Priority sort order In reply to
Thanks Andy. That seems to confirm my suspicions Pirate

I can add a new column, but does anyone know if it's possible to re-order the display of columns in the Admin viewer (for example at Database > Links > Add)? Whenever you add a new column it naturally appears at the bottom, but that isn't necessarily the ideal position. Just a question. I suspect the answer is no... Crazy

Thanks,
--Jo
Quote Reply
Re: [iplay] Priority sort order In reply to
Hi,

If I understand what your asking, this should work (Database > SQLMonitor)

- for Premium listings:

UPDATE glinks_Links SET New_Field = 'value_you_want' WHERE PriorityTier = 'Pemium'


- for free and value ones:

UPDATE glinks_Links SET New_Field = 'value_you_want' WHERE PriorityTier = 'Basic' OR PriorityTier = 'Value'

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk


IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Quote Reply
Re: [Andy] Priority sort order In reply to
Many thanks again, Andy.

Thanks,
--Jo