Integration with vBulletin - MediaWiki Latest Additions & Changes

Last Updated Wiki pages block
Version 1.4

Purpose
This extension will list the last updated or new wiki entries.

It can be included as a vbAdvanced block or included wherever you desire. It was designed to be included in a vbAdvanced block for vBulletin. It also goes nicely with Nuhit's MediaWiki integration tool but is not required.


Requirements
This is only supported on MediaWiki 1.8.2 - 1.10. It might run on a lower version, but it hasn't been tested. It has been reported 1.12 not to function. If you are interested in updating this to support additional versions as they are released let me know and you can be a co-developer on this.

Warning
This is only designed for boards with less than 50 wiki page edits per minute. If you have more, it almost becomes a useless mod (and puts a senseless burden on the server).

No warranty other than this file will take up a few kb on your hard drive.


Instructions

1. Edit the setting where you want the created file (wikichanges.htm) placed
2. If you have a table prefix on your WIKI, then edit the sql to reflect your prefix
3. Place this file in the extensions directory in your wiki
4. add this line at the bottom of LocalSettings.php (before the "?>")
   
   PHP Code:

   //  Add last updates
require_once "$IP/extensions/makevbmodule.php"; 

5. Edit a wiki article
6. Browse to the file in your setting below to see if it worked
7. Add vbAdvanced block to include the file
8. Test links inside included page to ensure it works (you may have to edit depending upon your configuration)

Upgrade Instuctions

1. Backup your old version
2. Edit the current version's settings locally
3. Replace the old version with the updated version with your settings
4. Edit a wiki article (to generate a new wikichanges.htm file)
5. Confirm new file generation

Demos
Here are some demos of the plugin. If you would like yours to be included, just post your url in the thread.
www.golegend.com
www.euro-chimaera.co.uk
PinataIsland.info


Support
Support is limited to this forum and to those who click install (yes I can see who did). If you have any questions or find a bug, post it here. I spend time with my family on the weekends, so expect long waits then.


Versions
1.4 - Important bug fix. This fixes two issues:

• Links to namespaces were not being included in links
  
• Special or other undesirable pages being listed when updated

This version correctly generates links and will only show updated articles, user pages, images, and categories.

1.3 -Added namespace for User pages (thanks jimmcq)
1.2 - Removed some personal code references
1.1 - Update with table prefix setting (thanks jimmcq)
1.0 - Initial Release

Keywords: MediaWiki, Wiki, vbAdvanced, vbWiki, Nuhit

[optrex]

works great on 3.8 vb and 1.13.3 wiki with 3.1.0 vba

[majorxp]

Thanks for the confirmation Optrex

[ReCom]

Thanks for this mod.

I've modified your SQL query into this:

$query = "SELECT o.rc_title, o.rc_user_text, o.rc_new, o.rc_namespace, o.rc_timestamp FROM " . $prefix . "recentchanges o, (SELECT max(rc_timestamp) as xtimestamp, rc_title, rc_namespace FROM " . $prefix . "recentchanges WHERE ABS(rc_old_len - rc_new_len) > 20 AND rc_namespace IN (0,2,6,14) GROUP BY rc_title, rc_namespace) n WHERE o.rc_title = n.rc_title AND o.rc_namespace = n.rc_namespace AND o.rc_timestamp = n.xtimestamp ORDER BY rc_timestamp DESC LIMIT " . $results;

Improvements:

• Namespace filtering is done in the nested SELECT
• Articles with same titles but in different namespaces are not lumped together ("Category:Vehicles" and "Vehicles" are two different articles, are they not?)
• filter out minute changes (detected by difference in articles length -- ABS(rc_old_len - rc_new_len) > 20 -- change 20 to minimum length difference)

.. and here is how I made the output list into more than one column:

// set $count = 0 outside this WHILE loop
// also set $columns to the number of columns you want
// owh and you need to set $wikiUrl to be your wiki url

if ($count % $columns == 0) $wik = $wik . '<tr>';
$wik = $wik .'<td class="alt'. (($count%$columns+intval($count/$columns))%2+1) .'" style="width:'. intval(100 / $columns) .'%">';
$wik = $wik . '<a href="' . $wikiUrl . $wTitle . '" title="' . $wTitleName . '"><strong>' . $wTitleName . '</strong></a><span class="smallfont">' . $new . 'by <a href="'. $wikiUrl .'User:'. $row['rc_user_text'] .'">' . $row['rc_user_text'] . '</a>';
$wik = $wik . "</span></td>";
if ($count % $columns == $columns - 1) $wik = $wik . '</tr>';
$count++;

Make sure you set the $results variable to be a multiple of the $columns (e.g. if $columns = 3 then $results = 3 or 6 or 9 or 12 or 15 etc

Sample @ http://www.recom.org/

[Bernd]

Recom, could you share that file? I have no idea at what line your code has to be implemented and what has to be removed. I did change the sql, which did not result in any errors.

[AfterWorldForum]

Never mind me, I am daft.

Just as a note, works fine on 3.8.4, using MediaWiki 1.15.1.

Thank you for the mod

[majorxp]

Glad that worked out for ya...and yes I'm still watching.

[rwoscott]

Works on VB4 and 1.10.1

Just needed to make a couple of small chgs to makevbmodule.php
find this

  while($row = @mysql_fetch_array($result, MYSQL_ASSOC))

And add the bit in red

  $wik = $wik .'<div class="blockrow"><table>';
  while($row = @mysql_fetch_array($result, MYSQL_ASSOC))

And find this

      $wik = $wik . '</span>';

Replace with

      $wik = $wik . '</table></div>';