appdb/. viewbugs.php

[WineHQ]

ChangeSet ID:	30979
CVSROOT:	/opt/cvs-commit
Module name:	appdb
Changes by:	[e-mail]	2007/03/17 14:19:19

Modified files:
    .              : viewbugs.php

Log message:
    Alexander Nicolaysen Sørnes 
    Show downloads on 'Apps affected by this bug' page

Patch: http://cvs.winehq.org/patch.py?id=30979

Old revision  New revision  Changes     Path
 1.11          1.12          +12 -2      appdb/viewbugs.php

Index: appdb/viewbugs.php
diff -u -p appdb/viewbugs.php:1.11 appdb/viewbugs.php:1.12
--- appdb/viewbugs.php:1.11	17 Mar 2007 19:19:19 -0000
+++ appdb/viewbugs.php	17 Mar 2007 19:19:19 -0000
@@ -26,6 +26,7 @@ if(!is_numeric($aClean['iBugId']))
     echo '    <td width=80>Application Name</td>',"\n";
     echo '    <td>Description</td>',"\n";
     echo '    <td width=80>version</td>',"\n";
+    echo '    <td>Downloads</td>',"\n";
     echo '</tr>',"\n";

@@ -43,6 +44,14 @@ if(!is_numeric($aClean['iBugId']))
     {
         while($oRow = mysql_fetch_object($hResult))
         {
+            $sDownloadUrls = "";
+            if($hDownloadUrls = appData::getData($oRow->versionId, "downloadurl"))
+            {
+                while($oDownloadUrl = mysql_fetch_object($hDownloadUrls))
+                    $sDownloadUrls .= "<a href="$oDownloadUrl->url">".
+                            "$oDownloadUrl->description</a><br />";
+            }
+
             // set row color
             $bgcolor = ($c % 2 == 0) ? "color0" : "color1";
             echo '<tr class='.$bgcolor.'>',"\n";
@@ -53,6 +62,7 @@ if(!is_numeric($aClean['iBugId']))
             echo '    <td>',"\n";
             echo '    <a href="appview.php?iVersionId='.$oRow->versionId.'">'.$oRow->versionName.'</a>',"\n";
             echo '    </td>',"\n";
+            echo "    <td>$sDownloadUrls</td>\n";
             echo '</tr>',"\n";
         }
     }
@@ -63,13 +73,13 @@ if(!is_numeric($aClean['iBugId']))
     echo '</tr>',"\n";

echo '<tr class=color4>',"\n";
-    echo '    <td colspan=3 >&nbsp Bug #</td>',"\n";
+    echo '    <td colspan=4 >&nbsp Bug #</td>',"\n";
     echo '</tr>',"\n";

echo '<tr class=color3>',"\n";
     echo '    <td align=center>',"\n";
     echo '    <input type="text" name="iBugId" value="'.$aClean['iBugId'].'" size="8"></td>',"\n";
-    echo '    <td colspan=2><input type="submit" name="sSub" value="Search"></td>',"\n";
+    echo '    <td colspan=3><input type="submit" name="sSub" value="Search"></td>',"\n";
     echo '</tr>',"\n";

echo '</table>',"\n";