Editing BugSquish

{{ExtensionCheck}}
[[Image:BugSquish.png|right]]
This extension checks your bug tracker installation and adds a strikethrough to interwiki links for closed bugs.  BugSquish currently supports the [http://www.bugzilla.org/ Bugzilla], [http://bestpractical.com/rt/ RT] and [http://trac.edgewall.org/ Trac] bug trackers, running on either MySQL or PostgreSQL databases.

<br style="clear: right;">

== Changes ==
{{On MediaWiki.org}}

* 2018-09-13: Updated the code to use the 'mysqli' PHP extension, rather than the older 'mysql' extension.  This improves compatibility with PHP 7 and above.  The 'mysql' extension is still used if 'mysqli' is unavailable (to ensure this doesn't break backwards-compatibility with old PHP/MediaWiki versions).
* 2016-02-07: Fixed an issue whereby the CSS was not being output on MediaWiki >= 1.19.
* 2012-01-08: Fixed a bug whereby the extension would cause CSS styles added by other extensions to be lost.
* 2011-10-18: Added the CSS styling to the extension, so it is available by default, therefore you no longer need to add it manually.  You can still over-ride it in MediaWiki:Common.css, though.
* 2011-10-02: BugSquish now supports Trac.  Thanks to [http://bradenehrat.com/ Braden Ehrat] for the patch.
* 2009-11-12: Updated extension so that it now works correctly on MW 1.14 and above.

__TOC__

== Credits ==

&copy; Copyright 2006-2016, Mark Clements.  Released under a creative-commons [http://creativecommons.org/licenses/by-sa/2.5/ CC BY-SA 2.5 (or later) license].

Many thanks to [http://blogs.gurulabs.com/dax/ Dax Kelson] for providing the RT and PostgreSQL code and to [http://bradenehrat.com/ Braden Ehrat] for integrating with Trac.

== Installation ==

Simply copy and paste the code ([[#Source Code|below]]) into a new file in your 'extensions' directory and include() it from your LocalSettings.php file in the usual way.

== Requirements ==

Firstly, links to your bug tracker need to be setup in your interwiki table.  For example you might setup an interwiki link called <code>bug</code> with the URL <code><nowiki>http://www.example.com/bugzilla/show_bug.cgi?id=$1</nowiki></code> <small>(though see [[#Known issues|known issues]], below, if you plan to use this prefix)</small>.  This means you can enter the wiki code <code><nowiki>[[bug:2314]]</nowiki></code> to create a link to bug 2314 in your Bugzilla install (resulting in a link such as: [http://www.example.com/bugzilla/show_bug.cgi?id=2314 bug:2314]).  For links to other bug-trackers, the URL format will change, but the principal is the same.  

Note that setting up links to your bug-tracker in this manner is something that MediaWiki supports natively - it is not functionality added by this extension.  BugSquish simply adds the ability to shown these links crossed out (or otherwise styled) based on their status.

For BugSquish to work are you need to have an interwiki prefix that accepts just a single number, and that the DB containing the bugs must be accessible locally (though the code is designed to allow for alternative access to the bug tracker data (e.g. via WebDAV)... once someone has written the necessary code!).

Multiple interwiki prefixes to different bug tracker installations can be defined on the same wiki.

== Configuration ==

For each interwiki link that you want to use, you need to add an entry into <code>$wgBugSquishSources</code>.  Each entry has the following required elements:

* '''interwiki''' => The interwiki prefix this definition applies to.
* '''type''' => The type of connection.  Currently only <code>BUGSQUISH_DBConnect</code> is valid for this field.
* '''tracker''' => The type of bug tracker you are linking to.  Currently the following values are recognised: <code>[http://www.bugzilla.org/ "bugzilla"]</code>, <code>[http://bestpractical.com/rt/ "rt"]</code> and <code>[http://trac.edgewall.org/ "trac"]</code>.

The following elements are only required if necessary:
* '''prefix''' => DB prefix (as setup in your tracker installation - can be omitted if this does not apply to your tracker, or no prefix is being used).


The following optional elements can be used to define the database connection.  If any of the elements are omitted, then the values used for your MediaWiki installation are used.  Therefore if Bugzilla shares a database with MediaWiki (and the MediaWiki user has appropriate access privileges) then you can omit all of the settings.  If not, then fill in anything that differs from your MediaWiki install.
* '''dbtype''' => The database type.  Currently only <code>"mysql"</code> and <code>"postgresql"</code> are supported.
* '''host''' => The database host.
* '''database''' => The database name.
* '''user''' => Username for DB connection.
* '''password''' => Password for DB connection.

== Examples ==

=== Example 1 - shared DB ===

If MediaWiki and Bugzilla are installed in a single DB, then you only need to specify a minimal set of components:

<php>
include("extensions/BugSquish.php");

$wgBugSquishSources[] = array(
	'interwiki'	=> "bug",
	'type'		=> BUGSQUISH_DBConnect,
    'tracker'   => "bugzilla",
	'prefix'	=> "bugzilla_",
);
</php>

=== Example 2 - separate DB ===

If Bugzilla is stored in a separate DB, then you need to supply details.  In most cases 'host' will be the same as for MediaWiki, in which case it can be omitted (as it has been here).  Also if no table prefix is used in your Bugzilla install, then that field can be omitted.

<php>
include("extensions/BugSquish.php");

$wgBugSquishSources[] = array(
	'interwiki' => "bug",
	'type'		=> BUGSQUISH_DBConnect,
    'tracker'   => "bugzilla",
	'database'	=> "dbname",
	'user'		=> "dbuser",
	'password'	=> "dbpass",
);
</php>

== Known issues ==

* Doesn't handle interwiki links created dynamically via templates, (e.g. <code><nowiki>[[bug:{{{1}}}]]</nowiki></code>.  It should handle links that don't contain variables though - let me know if you spot any other problems with transclusion, however!
* From MediaWiki v1.6 the 'Bugis' language was added, which has the ISO code 'bug'.  This means that in the default configuration you can't use 'bug' for the links (or rather, you can, but they appear in the left side-bar rather than in the text as expected).  There are two work-arounds to this:
*# Use a different interwiki prefix.
*# If you don't use inter-language links (and if you're unsure, you don't) then you can disable them by setting [[mw:Manual:$wgInterwikiMagic|$wgInterwikiMagic]] to false in your LocalSettings.php file.

== Source Code ==

<show_source file="BugSquish.php"></show_source>