Outer join was the wrong way round...
authorphilipp <philipp@7aebc617-e5e2-0310-91dc-80fb5f6d2477>
Sun, 22 Dec 2019 22:15:03 +0000 (22:15 +0000)
committerphilipp <philipp@7aebc617-e5e2-0310-91dc-80fb5f6d2477>
Sun, 22 Dec 2019 22:15:03 +0000 (22:15 +0000)
git-svn-id: http://www.winterrodeln.org/svn/servermediawiki/mediawiki_extensions/wrreport/trunk@2888 7aebc617-e5e2-0310-91dc-80fb5f6d2477

wrreport_body.php

index 8937e543db23208172a2c11be680ed695b02a68d..0afeb5bbc6679bcffab0edc2db69f6e4ab192211 100644 (file)
@@ -766,7 +766,7 @@ class WrReport {
                                                        $where_array,
                                                        'bahnentabelleParserHook',
                                                        ['ORDER BY' => 'p.page_title'],
-                                                       ['p' => ['JOIN', 'p.page_id=c.page_id'], 'r' => ['JOIN', 's.intermaps_sledrun_id=r.intermaps_sledrun_id'], 'AA' => ['LEFT OUTER JOIN', 'p.page_id=s.wr_page_id']]
+                                                       ['c' => ['JOIN', 'p.page_id=c.page_id'], 's' => ['JOIN', 's.intermaps_sledrun_id=r.intermaps_sledrun_id'], 'BB' => ['LEFT OUTER JOIN', 'p.page_id=s.wr_page_id']]
                                                );
 
                global $wgUser;
@@ -831,9 +831,6 @@ class WrReport {
                                                $td->appendText($row->status);
                                        }
                                }
-                               // s_closed
-                               // no info
-                               // check whether info should be shown at all
                        }
 
                        $tr->appendElement('td')->appendElement('a', array('href' => $title->getLocalURL()))->appendText($title->getPrefixedText());