com web/doc: get_misstags(): sort results by di r and then by file: include/lib_revcheck.inc. php

Commit:    4a9f68540fc69a395a57093e67767a16b9bfa346
Author:    Sobak <[email protected]>         Tue, 1 Jul 2014 05:46:42 +0200
Parents:   bed4291f69b1ca13713706c83f885be538e95575
Branches:  master

Link:       http://git.php.net/?p=web/doc.git;a=commitdiff;h=4a9f68540fc69a395a57093e67767a16b9bfa346

Log:
get_misstags(): sort results by dir and then by file

It prevents the situation when files from directory headers were
shown multiple times, each time with other files. Now it's much
easier to read it in "Missing revision numbers" tool.

Changed paths:
  M  include/lib_revcheck.inc.php


Diff:
diff --git a/include/lib_revcheck.inc.php b/include/lib_revcheck.inc.php
index b1f9e41..d4578d5 100644
--- a/include/lib_revcheck.inc.php
+++ b/include/lib_revcheck.inc.php
@@ -177,7 +177,8 @@ function get_misstags($idx, $lang)
      FROM files a, dirs d 
      LEFT JOIN files b ON a.dir = b.dir AND a.name = b.name 
      WHERE a.lang="'.$lang.'" AND b.lang="en" AND (a.revision IS NULL OR a.revision = "n/a")
-     AND a.size IS NOT NULL AND a.dir = d.id';
+     AND a.size IS NOT NULL AND a.dir = d.id
+     ORDER BY dir, name';
 
     $result = $idx->query($sql);
     while($row = $result->fetchArray()) {