Sitemap.xml with Drupal order by lastmod

If you have a Drupal 6 based site, you've probably installed the xmlsitemap module which works fairly well. A few days ago I reviewd mine and I saw that links were generated with no particular order, so I decided that it is good to show them ordered by lastmod to get the latest post first.
To make this work you need to change the source code of the xmlsitemap module file: xmlsitemap.generate.inc
Do a backup first!

And just find the function:

$query = array(
    'SELECT'   => 'SELECT x.loc, x.lastmod, x.changefreq,  x.changecount, x.priority, x.language',
    'FROM'     => 'FROM {xmlsitemap} x',
    'WHERE'    => 'WHERE x.access = 1 AND x.status = 1',
    'ORDER BY' => 'ORDER BY x.language, x.loc',
  );

and change it to:

$query = array(
    'SELECT'   => 'SELECT x.loc, x.lastmod, x.changefreq, x.changecount, x.priority, x.language',
    'FROM'     => 'FROM {xmlsitemap} x',
    'WHERE'    => 'WHERE x.access = 1 AND x.status = 1',
    'ORDER BY' => 'ORDER BY x.lastmod DESC',
  );


I know that it is not recommended to edit Drupal source code directly but the line in red did the trick! And now my sitemap.xml file is in descendant order showing the latest posts first.

Comments

Post a Comment

Your opinion is very appreciated, thank you!

Popular posts from this blog

Repair Dolce Gusto Circolo Leaking Problem

Image
My Dolce Gusto coffee machine started leaking without even plugin in to the socket. Water was leaking at the base, the tank would get completely empty in a few seconds, so I dismounted the back cover to see. Use a Torx tool.  Fisrt start removing the two screws down besides the reservoir connector. Down there you see the join inside the water connector. That small rubber joint was apparently in a good shape but the problem really came from it. I took the small water filter and descaled it by diping it in white vinegar for a few minutes. Then I took a rubber tap joint from my tool box and put it on top of the rubber joint as you see it in the circle. Then I mounted all back again and it works! The joint was just too used, and you can replace it with a tap rubber joint, just find the right size. Descale the coffe machine This is always a good thing to do every two or three months to keep the inside clean. I descaled completely by filling the water tank with a mixture
Read more

Root Nook Simple Touch with updated NookManager

Image
I have just rooted my Nook Simple Touch and it works really well. The screen quality is better than some other android readers which are really expensive on the market. After rooting everything flows and works fine, even browsing with Opera Mini. Upgrade the firmware to 1.2.2 With the old firmware 1.1.0 the wifi network does not work, so to upgrade the firmware you have to side download it to the reader and once it gets in sleep mode it will begin to upgrade itself Go to the page: https://help.barnesandnoble.com/hc/en-us/articles/5379840873371-Having-trouble-connecting-to-your-NOOK-#ManualDL and follow the instructions, then download the file: https://su.barnesandnoble.com/nook/nook2/1.2.2/351e26527e80156183e74be2da2ce89f/nook_1_2_update.zip Upgrade the firmware Register your Nook Simple Touch Root the Nook Simple Touch This update is only for firmware 1.2.2, I was impatient and tried to do it on the old firmware and it does not work well as you cannot install apk files or have Wi
Read more

How to Change the Gear Shift Knob of the Peugeot 306

Image
Well, last week the gear shift knob of my car got teared down in my hand as I was driving as you can see it in the picture. It was so really broken that the official knob from Peugeot would not fit anymore. The good thing about it is that now I can replace it by a nice one. But it was a real pain to figure out how to dismount it, the main thing is to lift up the leather bag around it first, from the bottom and then turn the knob twice to the left and then pull from it till it comes off . As you can see the white base support was broken too, so I had to dismount the whole thing and look for an universal knob to replace it. Well here is the gear shift itself all alone, I had to stick around it a piece of plastic and then tighten it up with a wire (I did this with my pliers to hold it tight), so that the leather bag will not move down later. Here is the new knob, it has a nice fairy on it, well, I know you are smiling :) but it was the only one in the store one that fitted
Read more