Hi,
I've been having a think/look at this for you. I'm not really sure whats the best way to approach it. For example, its easy enough to just do:
SELECT * FROM glinks_Category WHERE CatDepth = 1 ORDER BY Number_of_Links DESC LIMIT 10
..which would grab the top level categories, with the highest number of links.
However, trying to "dig" into those sub-categories it quite a bit more difficult/confusing.
If you don't mind just a basic category list, with the top categories (at root level), then I can write you a global for that - but I don't really have time to play around with the other one =)
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've been having a think/look at this for you. I'm not really sure whats the best way to approach it. For example, its easy enough to just do:
SELECT * FROM glinks_Category WHERE CatDepth = 1 ORDER BY Number_of_Links DESC LIMIT 10
..which would grab the top level categories, with the highest number of links.
However, trying to "dig" into those sub-categories it quite a bit more difficult/confusing.
If you don't mind just a basic category list, with the top categories (at root level), then I can write you a global for that - but I don't really have time to play around with the other one =)
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!