Changeset 2367 in ExiteCMS

Timestamp:

07/29/10 18:36:47 (5 weeks ago)

Author:

root

Message:

added support for Trac 0.12 Multirepos - make sure the correct repo rev is displayed

File:

• modules/ExiteCMS/tracsvn/php-files/modules/tracsvn/tracsvn.side_panel.php (modified) (1 diff)

modules/ExiteCMS/tracsvn/php-files/modules/tracsvn/tracsvn.side_panel.php

@@ -26 +26 @@
 // get the last SVN commit from the database
 if (!empty($settings['tracsvn_database']) && dbtable_exists("revision", $settings['tracsvn_database'])) {
-    $result = dbquery("SELECT * FROM ".$settings['tracsvn_database'].".revision ORDER BY time DESC LIMIT 1");
+    if (empty($settings['tracsvn_repo'])) {
+        $result = dbquery("SELECT * FROM ".$settings['tracsvn_database'].".revision ORDER BY time DESC LIMIT 1");
+    } else {
+        $result = dbquery("SELECT * FROM ".$settings['tracsvn_database'].".revision JOIN ".$settings['tracsvn_database'].".repository on revision.repos = repository.id WHERE repository.name = 'name' AND repository.value = '".mysql_real_escape_string($settings['tracsvn_repo'])."' ORDER BY time DESC LIMIT 1");
+    }
     if (dbrows($result)) {
         $data = dbarray($result);