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:


Thanks for any help!

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

---

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!

Thanks Andy. At present it is:

PriorityTier DESC,Title

Thanks,
--Jo

Hi,

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

Cheers

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!

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

Hi,

Ah, I see.

Yeah, you prob need a new field

Hope that helps.

Cheers

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!

Hi,

Ah, I see.

Yeah, you prob need a new field

Hope that helps.

Cheers

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!

Thanks Andy. That seems to confirm my suspicions

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...

Thanks,
--Jo

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

---

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!

Many thanks again, Andy.

Thanks,
--Jo