Revision: 307 http://opencsw.svn.sourceforge.net/opencsw/?rev=307&view=rev Author: wbonnet Date: 2011-02-21 10:58:07 +0000 (Mon, 21 Feb 2011)
Log Message: ----------- Fix the default no information message Modified Paths: -------------- web/wordpresscsw/wp-content/themes/opencsw/maintainer.php web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers-activity.php web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php Modified: web/wordpresscsw/wp-content/themes/opencsw/maintainer.php =================================================================== --- web/wordpresscsw/wp-content/themes/opencsw/maintainer.php 2011-02-21 10:40:40 UTC (rev 306) +++ web/wordpresscsw/wp-content/themes/opencsw/maintainer.php 2011-02-21 10:58:07 UTC (rev 307) @@ -58,9 +58,13 @@ print "</tr>\n" ; print "<tr>\n" ; if ($lastActivityInfo[0]["date"] != "") { - print "<th>Last packaging activity</th><td><a href=/package/" . $lastActivityInfo[0]["software"] . ">" . $lastActivityInfo[0]["software"] . "</a> has been added to unstable on " . $lastActivityInfo[0]["date"] . "</td>\n" ; + if ( $lastActivityInfo[0]["date"] == "2009-10-14") { + print "<th>Last packaging activity</th><td>No information available</td>"; + } else { + print "<th>Last packaging activity</th><td><a href=/package/" . $lastActivityInfo[0]["software"] . ">" . $lastActivityInfo[0]["software"] . "</a> has been added to unstable on " . $lastActivityInfo[0]["date"] . "</td>\n" ; + } } else { - print "<th>Last packaging activity</th><td>No information available</td>\n" ; + print "<th>Last packaging activity</th><td>The maintainer has no package</td>\n" ; } print "</tr>\n" ; print "<tr>\n" ; Modified: web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers-activity.php =================================================================== --- web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers-activity.php 2011-02-21 10:40:40 UTC (rev 306) +++ web/wordpresscsw/wp-content/themes/opencsw/qa-maintainers-activity.php 2011-02-21 10:58:07 UTC (rev 307) @@ -34,7 +34,7 @@ print "<table border=\"0\">"; print "<tbody class=\"package-list\">"; print "<tr>"; - print "<th>Name</th><th>Last packaging activity</th><th>Most recently updated package</th><th>Last bug tracker activity</th>\n" ; + print "<th>Name</th><th>Last packaging activity</th><th>Last bug tracker activity</th>\n" ; print "</tr>"; $totalPkg = 0; for( $i = 0 ; $i < count($arrayMaint) ; $i++) { @@ -42,11 +42,16 @@ $lastActivityInfo = $qaDAO->getMaintainerLastUnstableSubmitDate($maint["maintainer"]); print "<tr>"; if ( $lastActivityInfo[0]["date"] == "") { - print "<td><a title='" . $maint["fullname"] . "' href='/maintainers/" . $maint["maintainer"] . "'>" . $maint["fullname"] . "</a></td><td>-</td><td>The maintainer has no package</td>\n"; + print "<td><a title='" . $maint["fullname"] . "' href='/maintainers/" . $maint["maintainer"] . "'>" . $maint["fullname"] . "</a></td><td>The maintainer has no package</td>\n"; } else { - print "<td><a title='" . $maint["fullname"] . "' href='/maintainers/" . $maint["maintainer"] . "'>" . $maint["fullname"] . "</a></td><td>" . $lastActivityInfo[0]["date"] . "</td><td><a href=/package/" . $lastActivityInfo[0]["software"] . ">" . $lastActivityInfo[0]["software"] . "</a></td>\n"; + if ( $lastActivityInfo[0]["date"] == "2009-10-14") { + print "<td><a title='" . $maint["fullname"] . "' href='/maintainers/" . $maint["maintainer"] . "'>" . $maint["fullname"] . "</a></td><td>No activity information</td>\n"; + } else { + print "<td><a title='" . $maint["fullname"] . "' href='/maintainers/" . $maint["maintainer"] . "'>" . $maint["fullname"] . "</a></td><td>" . $lastActivityInfo[0]["date"] . " (<a href=/package/" . $lastActivityInfo[0]["software"] . ">" . $lastActivityInfo[0]["software"] . "</a>)</td>\n"; + } } - print "<td></td>"; + print "<td>No bug tracker activity information</td>"; + print "</tr>"; } // Close table Modified: web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php =================================================================== --- web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php 2011-02-21 10:40:40 UTC (rev 306) +++ web/wordpresscsw/wp-content/themes/opencsw/qaDAO.php 2011-02-21 10:58:07 UTC (rev 307) @@ -472,7 +472,7 @@ function getMaintainerLastUnstableSubmitDate($maintName) { // Define the query used to retrieve the packages from the database - $sqlQuery = "select p.software , h.HIST_VERSION_DATE from UWATCH_VERSION_HISTORY as h , UWATCH_PKG_VERSION as v , packages as p where p.maintlogin = '" . $maintName . "' and p.software = v.PKG_CATALOGNAME and v.ID_PKG = h.ID_PKG and h.HIST_VERSION_TYPE = 'unstable' order by h.HIST_VERSION_DATE desc limit 1 ; "; + $sqlQuery = "select p.software , date(h.HIST_VERSION_DATE) from UWATCH_VERSION_HISTORY as h , UWATCH_PKG_VERSION as v , packages as p where p.maintlogin = '" . $maintName . "' and p.software = v.PKG_CATALOGNAME and v.ID_PKG = h.ID_PKG and h.HIST_VERSION_TYPE = 'unstable' order by h.HIST_VERSION_DATE desc limit 1 ; "; // Execute the query to retrieve the row to update $this->execQuery($sqlQuery); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. _______________________________________________ devel mailing list devel@lists.opencsw.org https://lists.opencsw.org/mailman/listinfo/devel