This is a modification of an existing MediaWiki plugin, found here
The modifications include:
This is a brief description of the changes necessary to make this work. However some code needed to be moved around, so please verify with the entire code at the bottom before making any changes. This "changes" section is only intended to give you a vague idea of the changes involved.
in function get_wordpress_comments:
$wp_post_title = (isset($param["wp_post_title"]))? $param["wp_post_title"] : $wgParser->mTitle->mTextform;
$wp_url = (isset($param["wp_url"]))? $param["wp_url"] : $wgWpBaseURL;
a little farther down:
if ($number < 1) {
# Insert a new Wordpress Post with the specified title
$sql = 'INSERT INTO wp_posts
(post_author, post_date, post_date_gmt, post_content, post_title, post_status, comment_status,
post_modified, post_modified_gmt, post_type)
VALUES
("1", "'.date('Y-m-d H:i:s').'", "'.gmdate('Y-m-d H:i:s').'", "", "'.mysql_escape_string($wp_post_title).'", "publish", "open",
"'.date('Y-m-d H:i:s').'", "'.gmdate('Y-m-d H:i:s').'", "post")';
mysql_query($sql);
# get the id of the post and update the wp_posts table
$last_id = mysql_insert_id();
$sql = 'UPDATE wp_posts SET guid="'.$wp_url.'/?p='.$last_id.'" WHERE id='.$last_id;
mysql_query($sql);
}
in get_wordpress_reply_form()
$ret .= "<input type=\"hidden\" name=\"redirect_to\" value=\"http://" . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'] . "\" />";
<?php
/**
* WordPress Comments extension
* For documentation, please see http://www.mediawiki.org/wiki/Extension:WordPress_Comments
*
* @ingroup Extensions
* @author Greg Perry
* @version 0.9.0
*/
define('WORDPRESSCOMMENTS_VERSION','0.9.0, 2007-12-1');
//Extension credits that show up on Special:Version
$wgExtensionCredits['parserhook'][] = array(
'name' => 'WordPress Comments',
'url' => 'http://www.mediawiki.org/wiki/Extension:WordPress_Comments',
'version' => WORDPRESSCOMMENTS_VERSION,
'author' => 'Greg Perry',
'description' => '<tt><wp:comments></tt> parser hook to show WordPress comments on a MediaWiki.'
);
//Avoid unstubbing $wgParser on setHook() too early on modern (1.12+) MW versions, as per r35980
if ( defined( 'MW_SUPPORTS_PARSERFIRSTCALLINIT' ) ) {
$wgHooks['ParserFirstCallInit'][] = 'wordpresscomments';
} else {
$wgExtensionFunctions[] = 'wordpresscomments';
}
function wordpresscomments(){
global $wgParser;
$wgParser->setHook ( 'wp:comments', 'get_wordpress_comments' );
return true;
}
function get_wordpress_comments($data)
{
$param = array();
$info = explode("\n", $data);
if(is_array($info)){
foreach($info as $lin){
$line = explode("=",$lin, 2);
if(count($line)==2){
$param[trim($line[0])] = trim($line[1]);
}
}
}
global $wgParser, $wgDBserver, $wgDBname;
global $wgDBuser, $wgDBpassword, $wgPageName, $wgWpBaseURL;
$wp_post_title = (isset($param["wp_post_title"]))? $param["wp_post_title"] : $wgParser->mTitle->mTextform;
$wp_url = (isset($param["wp_url"]))? $param["wp_url"] : $wgWpBaseURL;
$wgParser->disableCache();
mysql_connect($wgDBserver,$wgDBuser,$wgDBpassword) or die("Unable toconnect to database" . mysql_error());
@mysql_select_db("$wgDBname") or die("Unable to select database $wgDBname");
mysql_query("SET NAMES utf8");
mysql_query("SET CHARACTER_SET utf8");
$sql = " SELECT * FROM wp_posts WHERE post_title LIKE \"".mysql_escape_string($wp_post_title)."\" AND post_status = 'publish' ";
$result = mysql_query($sql);
$number = mysql_num_rows($result);
$wp_post_ID = 0;
$ret = "";
if ($number < 1) {
# Insert a new Wordpress Post with the specified title
$sql = 'INSERT INTO wp_posts
(post_author, post_date, post_date_gmt, post_content, post_title, post_status, comment_status,
post_modified, post_modified_gmt, post_type)
VALUES
("1", "'.date('Y-m-d H:i:s').'", "'.gmdate('Y-m-d H:i:s').'", "", "'.mysql_escape_string($wp_post_title).'", "publish", "open",
"'.date('Y-m-d H:i:s').'", "'.gmdate('Y-m-d H:i:s').'", "post")';
mysql_query($sql);
# get the id of the post and update the wp_posts table
$last_id = mysql_insert_id();
$sql = 'UPDATE wp_posts SET guid="'.$wp_url.'/?p='.$last_id.'" WHERE id='.$last_id;
mysql_query($sql);
}
$sql = " SELECT * FROM wp_posts WHERE post_title LIKE \"".mysql_escape_string($wp_post_title)."\" AND post_status = 'publish' ";
$result = mysql_query($sql);
$number = mysql_num_rows($result);
$wp_post_ID = 0;
$ret = "";
if ($number == 1){
$wp_post_ID = mysql_result($result, 0,"ID");
$sql = " SELECT * FROM wp_comments INNER JOIN wp_posts ON comment_post_ID = ID WHERE ID = $wp_post_ID AND comment_approved = '1' ORDER BY comment_date ";
$result = mysql_query($sql);
$number = mysql_num_rows($result);
$i = 0;
$ret = "";
#$ret .= "[".$sql ."]";
#$ret .= "[".$wp_post_ID ."]";
if ($number < 1) {
#$ret .= "no records found"; -- TODO Configurable
} else {
$ret .= "<ul class=\"commentlist\">";
while ($number > $i) {
$ret .= "<li id=\"comment-". mysql_result($result,$i,"comment_ID") ."\" ";
$ret .= (($i % 2) ? " " : " class=\"alt\" ");
$ret .= ">";
if( mysql_result($result,$i,"comment_author_url") )
$ret .= " <cite><a href='". mysql_result($result,$i,"comment_author_url") ."' rel='external nofollow'>". mysql_result($result,$i,"comment_author") ."</a></cite> Says:";
else
$ret .= " <cite>". mysql_result($result,$i,"comment_author") ."</cite> Says:";
$ret .= " <br />";
$ret .= " <small class=\"commentmetadata\"><a href=\"#comment-". mysql_result($result,$i,"comment_ID") ."\" title=\"\">". date("M d Y g:i a", strtotime(mysql_result($result,$i,"comment_date"))) ."</a> </small><br>";
$ret .= " <p>" . mysql_result($result,$i,"comment_content") . "</p>";
$ret .= "</li>";
$i++;
}
$ret .= "</ul>";
}
$reply_form = true;
if ($reply_form) {
$ret .= get_wordpress_reply_form($wp_post_ID, $wp_url);
}
} else {
$ret .= "more than one wordpress post match";
$ret .= "sql [".$sql."]";
}
return $ret;
}
function get_wordpress_reply_form ($wp_post_ID, $wp_url) {
if ($wp_post_ID > 0) {
$ret = "<div class=\"wpCommentForm\">";
$ret .= "<h3 id=\"respond\">Leave a Comment</h3>";
$ret .= "<form action=\"$wp_url/wp-comments-post.php\" method=\"post\" id=\"commentform\">";
$ret .= "<p><input type=\"text\" name=\"author\" id=\"author\" value=\"\" size=\"22\" tabindex=\"1\" />";
$ret .= "<label for=\"author\"><small>Name (required)</small></label></p>";
$ret .= "<p><input type=\"text\" name=\"email\" id=\"email\" value=\"\" size=\"22\" tabindex=\"2\" />";
$ret .= "<label for=\"email\"><small>Mail (will not be published) (required)</small></label></p>";
$ret .= "<p><input type=\"text\" name=\"url\" id=\"url\" value=\"\" size=\"22\" tabindex=\"3\" />";
$ret .= "<label for=\"url\"><small>Website</small></label></p>";
$ret .= "<p><textarea name=\"comment\" id=\"comment\" cols=\"100%\" rows=\"5\" tabindex=\"4\"></textarea></p>";
$ret .= "<p><input name=\"submit\" type=\"submit\" id=\"submit\" tabindex=\"5\" value=\"Submit Comment\" />";
$ret .= "<input type=\"hidden\" name=\"comment_post_ID\" value=\"$wp_post_ID\" />";
$ret .= "<input type=\"hidden\" name=\"redirect_to\" value=\"http://" . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'] . "\" />";
$ret .= "</p>";
$ret .= "</form>";
$ret .= "</div>\n";
}
return $ret;
}
?>
In a semi-private wiki I maintain, we are using whitelisting to make some pages visible to the public but not others. Authentication is done off of an IMAP server, and only registered users have full access tothe wiki. We still run in to the occasional page where most info should be public, but only certain bits should not appear to the public. Things like server passwords, or phone numbers should be hidden except to registered users. I created this plugin so that we can hide bits and pieces of pages from non-registered users, while making the rest of the page public. Just add a <private> tag around the text you want hidden, and you're good to go.
Copy this code to a "extensions/PrivateBlocks.php", and add the following line to LocalSettings.php:
require_once( 'extensions/PrivateBlocks.php' );
PrivateBlocks.php
<?php
$wgExtensionFunctions[] = "wfPrivateBlocks";
$wgExtensionCredits['parserhook'][] = array(
'name' => 'PrivateBlocks',
'author' => 'Aaron Parecki',
'description' => 'Adds <nowiki><private></nowiki> tag for hiding text to non-registered users',
'url' => 'http://blog.neverusethisfont.com/2008/09/hiding-text-from-non-registered-users-in-mediawiki/'
);
function wfPrivateBlocks() {
global $wgParser;
$wgParser->setHook( "private", "privateBlock" );
}
# The callback function for converting the input text to HTML output
function privateBlock($input, $args)
{
if( $_SESSION['wsUserID'] == 0 )
{
return "";
}
else
{
return $input;
}
}
?>