08 Nov 09 How To Change Weblink Sort Order in Joomla
- Image via Wikipedia
I’ve been adding new links to the weblinks section of my Joomla installation (Sliced Wikizine)for some time now and have managed to build quite a nice collection of very cool Web 2.0 type links in a range of categories (including: Animation Blogging Code Graphics Web Design Social Media Multimedia Writing and Online Tools )
One thing that always bothered me was that the new links I added always displayed last on the list of links. Of course, links can be manually reordered using the admin backend but I couldn’t help thinking there had to be an easier way.
Of course there is…
To change the sort order of weblinks, you need to edit one file in your Joomla installation. Go to: yoursite/joomla_folder/components/com_weblinks/models/category.php
Edit the file ‘category.php’ (It’s a good idea to download a backup copy of the file first, just in case…). Use notepad or another text editor to edit the file. Code editor in cpanel works just fine.
Between lines 224 and 231 you’ll find this statement:
$query = ‘SELECT *’ .
‘ FROM #__weblinks’ .
‘ WHERE catid = ‘. (int) $this->_id.
‘ AND published = 1′ .
‘ AND archived = 0′.
‘ ORDER BY ‘. $filter_order .’ ‘. $filter_order_dir .’, ordering’;
return $query;
Make this change on line 229:
$query = ‘SELECT *’ .
‘ FROM #__weblinks’ .
‘ WHERE catid = ‘. (int) $this->_id.
‘ AND published = 1′ .
‘ AND archived = 0′.
//’ ORDER BY ‘. $filter_order .’ ‘. $filter_order_dir .’, ordering’;
‘ ORDER BY date DESC’;
return $query;
What we have done is commented out the line //’ ORDER BY ‘. $filter_order .’ ‘. $filter_order_dir .’, ordering’; to make it inactive. All links will now be sorted by date in descending order (most recent first).
Other sort options can be created by using these fields: url, title, description, date, hits.
For example, you could sort all weblinks alphabetically by title by changing the statement which now appears on line 230 to:
‘ ORDER BY title ASC’;
Related articles by Zemanta
- CkEditor.com – Quite An Interesting Editor (killerstartups.com)
- The Acid Base Book (doctorrw.blogspot.com)
- Make Your Life Easier when Working with Text (chris.pirillo.com)
- Make fantastic wallpapers using Google Maps (en.onsoftware.com)
- How to view Page Source in your Favorite Text Editor? (technology.johnsamuel.in)
- Coda: A Collection of 120+ Plugins, Clips, Snippets and Tuts For Designers and Developers (macstories.net)
- WeatherBug With Your Joomla Install! (lockergnome.com)
- Google unleashes internal JavaScript tools (theregister.co.uk)
![Reblog this post [with Zemanta]](http://img.zemanta.com/reblog_e.png?x-id=083f1384-dfa3-48e0-8f60-85af2e32bf43)
Tags: Animation, joomla, Languages, links, most recent first, newest first, PHP, Programming, sort order, Text editor, Web 2.0, web design, weblinks
Liam, I am glad that you are among people who goes for “Joomla!”
.-= Hicham´s last blog ..Justice and Stereotype =-.
I hosted my new site from powweb, and did a little work on it, then I downloaded joomla and I am navagating through joomla trying to find how to upload my material from powweb? I tried to get into powweb website maker and it doesn’t work… obviously because I downloaded joomla. Now, I also can’t access joomla from powweb, I have to go to the joomla website. If someone could help me out that would be great because i’m very confused!!!!!! This is my first time ever making a site so… speak english
.-= search engine marketing tips´s last blog ..Web directory submissions- get high pace outputs =-.
Thank you for this post
I successfully changed the sorting order of my weblinks to alphabetical
You’re welcome; surprisingly easy, isn’t it? Glad it was helpful
Great tip! I spent some time searching for a mod or plugin to did this, and all those were pretty much overkill. Then, I stumbled upon your page. Just utilized it for a pretty large Link list on betterworldstrategies.com (in production).
Thanks so much,
Gene
I spent a long time myself searching for a solution so I thought I’d share it. I’m very glad the article was helpful!
Nice post! you did it good. I look forward to future post.
I’m new in Joomla system. I’m used wordpess but my hobby is learn Joomla and drupal.
Thanks a lot for sharing,
Reference:
german language schools
Nice post, but I wish there was an easier way. What happens at the next upgrade?
It’s a shame Joomla hasn’t built options like this into the admin back end. Why would anyone want their oldest links to be displayed first? Oversights like this force users to to find fixes such as the one I posted which can be quite a headache. If an upgrade means I have to re do all my work arounds, I may consider not upgrading or maybe using another CMS!
Thanks alot for this post.
Really helpful!
I own a blog and due to some personal reasons, I would like to be inaccessible to anyone for the time being. I used Blogger. I have changed the weblink and made the blog invisible to public.
yes, i found it.. thanks my friend