Changeset 443

Timestamp:

04/16/08 18:08:05 (5 years ago)

Author:

d0nut

Message:

sitemaps wbb, last update=last posting

Location:

sitemaps/optionals/de.easy-coding.wbb.sitemaps

Files:

• files/lib/system/event/listener/SitemapsPageWBBListener.class.php (modified) (3 diffs)
• package.xml (modified) (2 diffs)

sitemaps/optionals/de.easy-coding.wbb.sitemaps/files/lib/system/event/listener/SitemapsPageWBBListener.class.php

@@ -152 +152 @@
                         $this->boardThreadsPerPage();
 
-                        $sql = "SELECT          board.*
-                                FROM            wbb".WBB_N."_board board
+                        $sql = "SELECT          board.*,
+                                                t.lastPostTime
+                                FROM            wbb".WBB_N."_board board
+                                NATURAL JOIN    wbb".WBB_N."_board_last_post blp
+                                JOIN            wbb".WBB_N."_thread t 
+                                ON              blp.threadID = t.threadID
                                 WHERE           board.threads > 0
                                 AND             board.boardID IN (".$boardIDs.")
                                 ".(count($this->boardIDs) && $this->boardIDs[0] ? "AND board.boardID IN (".implode(',', $this->boardIDs).")" : "")."
+                                AND blp.languageID=0
                                 ORDER BY        board.time DESC";
 
@@ -165 +170 @@
                                 $this->boards[$i] = new SitemapsBoard($row['boardID'], $row);
                                 $this->boards[$i]->full = true;
+                                $this->boards[$i]->time = $row['lastPostTime'];
+
                                 if(intval($this->boards[$i]->getThreads()) == 0) {
                                         continue;
@@ -254 +261 @@
                                 $tpl = '<url><loc>'.PAGE_URL.'/%s</loc><lastmod>%s</lastmod></url>';
                                 foreach($this->boards as $board) {
-                                        printf($tpl, $board->url, date('c', $board->time));
+                                        printf($tpl, $board->url, date('c', $board->lastPostTime));
                                 }
                         } else {

sitemaps/optionals/de.easy-coding.wbb.sitemaps/package.xml

@@ -9 +9 @@
                 <packagedescription language="de"><![CDATA[XML Sitemaps fÃŒr Woltlab Burning Board.]]></packagedescription>
                 <packagedescription language="fr"><![CDATA[Sitemaps XML pour Woltlab Burning Board]]></packagedescription>
-                <version>1.0.1</version>
+                <version>1.2.1</version>
                 <date>DATE</date>
                 <plugin>com.woltlab.wbb</plugin>
@@ -31 +31 @@
         </instructions>
         
+        <instructions type="update" fromversion="1.0.1">
+                <files>files.tar</files>
+        </instructions>
+        
         <instructions type="update" fromversion="1.0.0">
                 <files>files.tar</files>