AppDB Add bug.php to better integrate AppDB with Bugzilla

[Tony Lambregts]

Change log: Add bug.php to better integrate AppDB with Bugzilla

Files changed: appview.php
Files added:   bugs.php

--- /dev/null	2003-01-30 03:24:37.000000000 -0700
+++ bugs.php	2004-04-14 11:33:14.000000000 -0600
@@ -0,0 +1,82 @@
+<?
+
+/*
+ * Application Database Bug Search Page
+ *
+ */
+
+include("path.php");
+require(BASE."include/"."incl.php");
+
+
+
+?>
+
+/* code to VIEW an application's Bugs */
+
+$appId = $_REQUEST['appId'];
+$versionId = $_REQUEST['versionId'];
+
+if(!is_numeric($appId))
+    {
+    errorpage("Something went wrong with the IDs");
+    exit;
+    }
+
+if($appId && !$versionId)
+   {
+    $app = new Application($appId);
+    $data = $app->data;
+    if(!$data) {
+	// Oops! application not found or other error. do something
+	errorpage('Internal Database Access Error');
+	exit;
+	}
+    //start display Bug Options
+    echo html_frame_start("","98%","",0);
+    category
+    echo '<tr><td class=color4 valign=top>',"\n";	
+    echo '<table width="250" border=0 cellpadding=3 cellspacing=1">',"\n";
+    echo "<tr class=color0 valign=top><td width='100' align=right> <b>Name</b></td><td width='100%'> ".stripslashes($data->appName)." </td>\n";
+    echo "<tr class=color1 valign=top><td width='100' align=right> <b>App Id</b></td><td width='100%'> ".$data->appId." </td>\n";
+    echo "<tr class=color0 valign=top><td align=right> <b>Vendor</b></td><td> ".
+        "   <a href='vendorview.php?vendorId=$vendor->vendorId'> ".stripslashes($vendor->vendorName)." </a> &nbsp;\n";
+    echo "<tr class=color0 valign=top><td align=right> <b>All Bugs</b></td><td> ".
+        "   <a href='http://bugs.winehq.org/buglist.cgi?product=Wine&bug_file_loc_type=allwords&bug_file_loc=appdb ".$data->appId."'>
+         Look for All bugs in bugzilla </a> &nbsp;\n";
+    echo "<tr class=color0 valign=top><td align=right> <b>Open Bugs</b></td><td> ".
+        "   <a href='http://bugs.winehq.org/buglist.cgi?product=Wine
+         &bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&bug_file_loc_type=allwords&bug_file_loc=appdb ".$data->appId."'>
+         Look for Open bugs in bugzilla </a> &nbsp;\n";        
+    echo "<tr class=color0 valign=top><td align=right> <b>Submit New Bug</b></td><td> ".
+        "   <a href='http://bugs.winehq.org/enter_bug.cgi?product=Wine
+         &bug_file_loc=http://appdb.winehq.org/appview.php?appid=.$data->appId."'>
+         Submit new bugs in bugzilla </a> &nbsp;\n";        
+
+    echo "</td></tr>\n";
+	
+	
+    echo "<tr class=color1><td valign=top align=right> <b>Notes</b></td><td>\n";
+<?    
+        <p><big><b>Welcome</b></big></p>
+	
+        <p>This is the link between the Wine Application Database and Wine's Buzilla. From here you 
+        get search for bugs entered against this application. You can also enter new bugs if you log
+        into Wine's Bugzilla.</p>
+	
+        <p>The link between the Application Database and Bugzilla is based on the bug having the URL
+        For this aplication in the "URL" Field. If it is not entered, this serch page can not find it.
+        The URL for this Application is:<p>
+	
+?>
+        echo "<a href='http://appdb.winehq.org/appview.php?appId=".$data->appId."'>
+        http://appdb.winehq.org/appview.php?appId=".$data->appId."'</a> &nbsp;\n";        
+ 
+    echo "</td></tr>\n";
+
+    echo "<p>&nbsp;</p>\n";
+
+apidb_footer();
+
+
+?>
Index: appview.php
===================================================================
RCS file: /home/wine/appdb/appview.php,v
retrieving revision 1.4
diff -u -r1.4 appview.php
--- appview.php	6 Apr 2004 21:21:20 -0000	1.4
+++ appview.php	14 Apr 2004 17:44:10 -0000
@@ -284,8 +284,7 @@
 	echo "<tr class=color0 valign=top><td align=right> <b>Vendor</b></td><td> ".
 	     "   <a href='vendorview.php?vendorId=$vendor->vendorId'> ".stripslashes($vendor->vendorName)." </a> &nbsp;\n";
         echo "<tr class=color0 valign=top><td align=right> <b>BUGS</b></td><td> ".
-	     "   <a href='http://bugs.winehq.org/buglist.cgi?product=Wine&bug_file_loc_type=allwords&bug_file_loc=appdb ".$data->appId."'>
-             Check for bugs in bugzilla </a> &nbsp;\n";        
+	     "   <a href='bugs.php?appId=$data->appId.'> Check for bugs in bugzilla </a> &nbsp;\n";        
 	echo "</td></tr>\n";
 	
 	//display notes