Changeset 1320 in ExiteCMS

Timestamp:

02/28/08 00:23:53 (4 years ago)

Author:

hverton

Message:

Trac Project Management and SVN interface module

Location:

modules/ExiteCMS/tracsvn/php-files/modules/tracsvn

Files:

• admin.php (modified) (1 diff)
• module_installer.php (modified) (7 diffs)
• svn.php (added)
• svn_panel.php (deleted)
• templates/modules.tracsvn.admin.tpl (added)
• templates/modules.tracsvn.admin_panel.tpl (deleted)
• templates/modules.tracsvn.side_panel.tpl (added)
• templates/modules.tracsvn.svn.tpl (added)
• templates/modules.tracsvn.svn_panel.tpl (deleted)
• templates/modules.tracsvn.trac.tpl (added)
• trac.php (added)
• tracsvn.side_panel.php (added)
• tracsvn_include.php (added)

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

@@ -13 +13 @@
 require_once PATH_ROOT."/includes/theme_functions.php";
 
+require_once "tracsvn_include.php";
+
+// check for the proper admin access rights
+if (!checkrights("wT") || !defined("iAUTH") || $aid != iAUTH) fallback(BASEDIR."index.php");
+
+// load the locale for this module
+locale_load("modules.tracsvn");
+
+// define the variables for this panel
+$variables = array();
+
+if (isset($_POST['savesettings'])) {
+    // extract and validate the input
+    $database = stripinput($_POST['database']);
+    $url = stripinput($_POST['url']);
+    $cmd = stripinput($_POST['cmd']);
+    $auth = stripinput($_POST['auth']);
+    $extensions = stripinput($_POST['extensions']);
+    $variables['message'] = "";
+    
+    // check if the database exists and is a Trac database
+    if (empty($database) || !dbtable_exists("revision", $database)) {
+        $variables['message'] = ($variables['message'] == "" ? "" : "<br />") . $locale['406'];
+    } else {
+        // check if the cmd points to svn
+        $_tmp = explode(" ", $cmd);
+        if (CMS_GetOS() == "Windows") {
+            $_tmp = substr(strrchr($_tmp[0], "\\"),1);
+            if ($_tmp != "svn.exe") {
+                $variables['message'] = ($variables['message'] == "" ? "" : "<br />") . $locale['444'];
+            }
+        } else {
+            $_tmp = substr(strrchr($_tmp[0], "/"),1);
+            if ($_tmp != "svn") {
+                $variables['message'] = ($variables['message'] == "" ? "" : "<br />") . $locale['444'];
+            }
+        }
+        // add a trailing slash if needed
+        if (!empty($url) && substr($url, -1) != "/") {
+            $url .= "/";
+        }
+        if ($variables['message'] == "") {
+            // executable is valid. check if the repository is readable
+            $output = tracsvn_extCmd($cmd." info ".$url." ".$auth);
+            if (!is_array($output) || !isset($output[5]) || $output[5] != "Node Kind: directory") {
+                $variables['message'] = ($variables['message'] == "" ? "" : "<br />") . $locale['449'];
+                foreach($output as $line) {
+                    $variables['message'] .= "<br />" . $line;
+                }
+            }
+        }
+    }
+    // if no errors are found, update
+    if ($variables['message'] == "") {
+        $result = dbquery("UPDATE ".$db_prefix."configuration SET cfg_value = '".$database."' WHERE cfg_name = 'tracsvn_database'");
+        $result = dbquery("UPDATE ".$db_prefix."configuration SET cfg_value = '".$url."' WHERE cfg_name = 'tracsvn_url'");
+        $result = dbquery("UPDATE ".$db_prefix."configuration SET cfg_value = '".$cmd."' WHERE cfg_name = 'tracsvn_svncmd'");
+        $result = dbquery("UPDATE ".$db_prefix."configuration SET cfg_value = '".$auth."' WHERE cfg_name = 'tracsvn_svnauth'");
+        $result = dbquery("UPDATE ".$db_prefix."configuration SET cfg_value = '".$extensions."' WHERE cfg_name = 'tracsvn_extensions'");
+        redirect(FUSION_SELF.$aidlink);
+    }
+} else {
+    $database = $settings['tracsvn_database'];
+    $url = $settings['tracsvn_url'];
+    $cmd = $settings['tracsvn_svncmd'];
+    $auth = $settings['tracsvn_svnauth'];
+    $extensions = $settings['tracsvn_extensions'];
+}
+
+// store the variables
+$variables['database'] = $database;
+$variables['url'] = $url;
+$variables['cmd'] = $cmd;
+$variables['auth'] = $auth;
+$variables['extensions'] = $extensions;
+
 // define the body panel variables
-$template_panels[] = array('type' => 'body', 'name' => 'tracsvn.admin_panel', 'template' => 'modules.tracsvn.admin_panel.tpl', 'locale' => "modules.tracsvn");
+$template_panels[] = array('type' => 'body', 'name' => 'tracsvn.admin_panel', 'template' => 'modules.tracsvn.admin.tpl', 'locale' => "modules.tracsvn");
 $template_variables['tracsvn.admin_panel'] = $variables;
 

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

@@ -16 +16 @@
 +----------------------------------------------------*/
 $mod_title = "Trac-SVN reports";
-$mod_description = "This ExiteCMS module provides a reporting interface on the Trac SVN Project management database (needs to be on the same MySQL server as ExiteCMS!)";
-$mod_version = "0.0.1";
+$mod_description = "This ExiteCMS module provides a reporting of Trac Project management, and connects to SVN to retrieve details status information";
+$mod_version = "0.0.15";
 $mod_developer = "WanWizard";
 $mod_email = "wanwizard@gmail.com";
@@ -38 +38 @@
 
 // check for a minumum version of the ExiteCMS engine
-if (str_replace(".", "", $settings['version']) < 710) {
-    $mod_errors .= sprintf($locale['mod001'], '7.10');
+if (str_replace(".", "", $settings['version']) < 700) {
+    $mod_errors .= sprintf($locale['mod001'], '7.00');
 }
 // check for a maximum version of the ExiteCMS engine
@@ -55 +55 @@
 
 $mod_site_links = array();
+$mod_site_links[] = array('name' => 'Trac Reporting', 'url' => 'trac.php', 'panel' => '', 'visibility' => 102);
+$mod_site_links[] = array('name' => 'SVN Reporting', 'url' => 'svn.php', 'panel' => '', 'visibility' => 102);
 
 /*---------------------------------------------------+
@@ -62 +64 @@
 $localestrings = array();
 $localestrings['en'] = array();
-$localestrings['en']['400'] = "Trac & SVN Reporting";
+$localestrings['en']['400'] = "Project Management";
 $localestrings['en']['401'] = "SVN - Now running...";
 $localestrings['en']['402'] = "SVN Revision";
@@ -68 +70 @@
 $localestrings['en']['404'] = "by";
 $localestrings['en']['405'] = "No information found!";
+$localestrings['en']['406'] = "Database not found, no access to database, or database is not a Trac database";
+$localestrings['en']['407'] = "Trac & SVN user aliases";
+$localestrings['en']['408'] = "Add alias";
+$localestrings['en']['409'] = "There are no aliases defined";
+$localestrings['en']['410'] = "Save settings";
+$localestrings['en']['411'] = "Trac MySQL database name:";
+$localestrings['en']['412'] = "Trac username";
+$localestrings['en']['413'] = "Member";
+$localestrings['en']['414'] = "Milestone";
+$localestrings['en']['415'] = "";
+$localestrings['en']['416'] = "Due in";
+$localestrings['en']['417'] = "Open tickets";
+$localestrings['en']['418'] = "Closed tickets";
+$localestrings['en']['419'] = "Completed";
+$localestrings['en']['420'] = "ago";
+$localestrings['en']['421'] = "Opened";
+$localestrings['en']['422'] = "Closed";
+$localestrings['en']['423'] = "Open";
+$localestrings['en']['424'] = "tickets for";
+$localestrings['en']['425'] = "Summary";
+$localestrings['en']['426'] = "Type";
+$localestrings['en']['427'] = "Priority";
+$localestrings['en']['428'] = "Status";
+$localestrings['en']['429'] = "View ticket details";
+$localestrings['en']['430'] = "View open tickets";
+$localestrings['en']['431'] = "View closed tickets";
+$localestrings['en']['432'] = "Ticket";
+$localestrings['en']['433'] = "Reported by";
+$localestrings['en']['434'] = "Assigned to";
+$localestrings['en']['435'] = "Component";
+$localestrings['en']['436'] = "Version";
+$localestrings['en']['437'] = "Severity";
+$localestrings['en']['438'] = "Keywords";
+$localestrings['en']['439'] = "Description";
+$localestrings['en']['440'] = "Change history";
+$localestrings['en']['441'] = "changed";
+$localestrings['en']['442'] = "from";
+$localestrings['en']['443'] = "to";
+$localestrings['en']['444'] = "Command specified is not the SVN executable";
+$localestrings['en']['445'] = "Path to the SVN program:";
+$localestrings['en']['446'] = "SVN authorisation string:";
+$localestrings['en']['447'] = "SVN repository URL:";
+$localestrings['en']['448'] = "Generate diffs for file extensions:";
+$localestrings['en']['449'] = "Could not connect to the SVN repository. Output of the command is:<br />";
+
+$localestrings['en']['500'] = "Changeset";
+$localestrings['en']['501'] = "Timestamp";
+$localestrings['en']['502'] = "Author";
+$localestrings['en']['503'] = "Message";
+$localestrings['en']['504'] = "Files";
+$localestrings['en']['505'] = "copied from";
+$localestrings['en']['506'] = "moved from";
+$localestrings['en']['507'] = "Unmodified";
+$localestrings['en']['508'] = "Added";
+$localestrings['en']['509'] = "Removed";
+$localestrings['en']['510'] = "Copied";
+$localestrings['en']['511'] = "Modified";
+$localestrings['en']['512'] = "Moved";
+$localestrings['en']['513'] = "diff";
+$localestrings['en']['514'] = "Show differences";
+$localestrings['en']['515'] = "Show new revision %s of this file";
+$localestrings['en']['516'] = "View this changeset";
+$localestrings['en']['517'] = "Show entry";
+$localestrings['en']['518'] = "Show original file (rev. %s)";
 
 $localestrings['nl'] = array();
-$localestrings['nl']['400'] = "Trac & SVN Rapportering";
+$localestrings['nl']['400'] = "Project Management";
 $localestrings['nl']['401'] = "SVN - nu actief...";
 $localestrings['nl']['402'] = "SVN Revisie";
@@ -76 +142 @@
 $localestrings['nl']['404'] = "door";
 $localestrings['nl']['405'] = "Geen informatie gevonden!";
+$localestrings['nl']['406'] = "Database niet gevonden, geen toegang tot de database, of de database is geen Trac database";
+$localestrings['nl']['407'] = "Trac & SVN gebruikersaliassen";
+$localestrings['nl']['408'] = "Alias toevoegen";
+$localestrings['nl']['409'] = "Er zijn geen aliassen gedefinieerd";
+$localestrings['nl']['410'] = "Bewaar instellingen";
+$localestrings['nl']['411'] = "Trac MySQL database naam:";
+$localestrings['nl']['412'] = "Trac gebruiker";
+$localestrings['nl']['413'] = "Lid";
+$localestrings['nl']['414'] = "Mijlpaal";
+$localestrings['nl']['415'] = "Opgeleverd op";
+$localestrings['nl']['416'] = "Gepland op";
+$localestrings['nl']['417'] = "Open tickets";
+$localestrings['nl']['418'] = "Gesloten tickets";
+$localestrings['nl']['419'] = "Gereed";
+$localestrings['nl']['420'] = "geleden";
+$localestrings['nl']['421'] = "Geopend";
+$localestrings['nl']['422'] = "Gesloten";
+$localestrings['nl']['423'] = "Open";
+$localestrings['nl']['424'] = "tickets van";
+$localestrings['nl']['425'] = "Omschrijving";
+$localestrings['nl']['426'] = "Type";
+$localestrings['nl']['427'] = "Prioriteit";
+$localestrings['nl']['428'] = "Status";
+$localestrings['nl']['429'] = "Ticket details bekijken";
+$localestrings['nl']['430'] = "Open tickets bekijken";
+$localestrings['nl']['431'] = "Gesloten tickets bekijken";
+$localestrings['nl']['432'] = "Ticket";
+$localestrings['nl']['433'] = "Gemeld door";
+$localestrings['nl']['434'] = "Toegewezen aan";
+$localestrings['nl']['435'] = "Component";
+$localestrings['nl']['436'] = "Versie";
+$localestrings['nl']['437'] = "Criticiteit";
+$localestrings['nl']['438'] = "Sleutelwoorden";
+$localestrings['nl']['439'] = "Omschrijving";
+$localestrings['nl']['440'] = "Aanpassingshistorie";
+$localestrings['nl']['441'] = "gewijzigd";
+$localestrings['nl']['442'] = "van";
+$localestrings['nl']['443'] = "naar";
+$localestrings['nl']['444'] = "Pad wijst niet naar het SVN programma!";
+$localestrings['nl']['445'] = "Pad naar het SVN programma:";
+$localestrings['nl']['446'] = "SVN authorisatie string:";
+$localestrings['nl']['447'] = "SVN repository URL:";
+$localestrings['nl']['448'] = "Genereer diffs voor deze file extensies:";
+$localestrings['nl']['449'] = "Kan geen verbinding maken met de SVN repository. Uitvoer van het commando is:<br />";
+
+$localestrings['nl']['500'] = "Changeset";
+$localestrings['nl']['501'] = "Datum";
+$localestrings['nl']['502'] = "Auteur";
+$localestrings['nl']['503'] = "Bericht";
+$localestrings['nl']['504'] = "Bestanden";
+$localestrings['nl']['505'] = "Gekopieerd van";
+$localestrings['nl']['506'] = "Verplaatst van";
+$localestrings['nl']['507'] = "Ongewijzigd";
+$localestrings['nl']['508'] = "Toegevoegd";
+$localestrings['nl']['509'] = "Verwijderd";
+$localestrings['nl']['510'] = "Gekopieerd";
+$localestrings['nl']['511'] = "Gewijzigd";
+$localestrings['nl']['512'] = "Verplaatst";
+$localestrings['nl']['513'] = "diff";
+$localestrings['nl']['514'] = "Toon de wijzigingen";
+$localestrings['nl']['515'] = "Toon nieuwe revisie %s van dit bestand";
+$localestrings['nl']['516'] = "Bekijk dit changeset";
+$localestrings['nl']['517'] = "Bekijk bestand";
+$localestrings['nl']['518'] = "Toon origineel bestand (rev. %s)";
 
 /*---------------------------------------------------+
@@ -85 +215 @@
 // add the configuration items for this module
 $mod_install_cmds[] = array('type' => 'db', 'value' => "INSERT INTO ".$db_prefix."configuration( cfg_name, cfg_value ) VALUES ('tracsvn_database', '')");
+$mod_install_cmds[] = array('type' => 'db', 'value' => "INSERT INTO ".$db_prefix."configuration( cfg_name, cfg_value ) VALUES ('tracsvn_url', '')");
+$mod_install_cmds[] = array('type' => 'db', 'value' => "INSERT INTO ".$db_prefix."configuration( cfg_name, cfg_value ) VALUES ('tracsvn_svncmd', '/usr/bin/svn')");
+$mod_install_cmds[] = array('type' => 'db', 'value' => "INSERT INTO ".$db_prefix."configuration( cfg_name, cfg_value ) VALUES ('tracsvn_svnauth', '--username name_here --password pass_here')");
+$mod_install_cmds[] = array('type' => 'db', 'value' => "INSERT INTO ".$db_prefix."configuration( cfg_name, cfg_value ) VALUES ('tracsvn_extensions', 'php,tpl,sh')");
 
 // create the table: tracsvn_alias