Hello, my name is Jeroen. Im a MSc. student information sciences at Tilburg University, the Netherlands. 
Im working on my graduation thesis which is about wiki usage in higher education.

Please leave a message after the beep (which you'll hear eventually if you listen long enough).


----

====Draft. Recently edited social awareness functionality====

**Patch description**
If you open a WikiPage in edit mode (invoke the edit page handler), 
a display of social awareness information might come in handy (eg. for collaboration purposes). 
This patch displays an overview of users who recently opened the WikiPage in edit mode, on a per-page basis.

If you want this functionality you need to do the following:

1. //Create new table to log necessary information.//

%%(sql)
CREATE TABLE yourprefix_log (
  id int(11) unsigned NOT NULL auto_increment,
  handler varchar(30) NOT NULL default '',
  tag varchar(75) NOT NULL default '0',
  username varchar(255) NOT NULL default '',
  accessed_at datetime NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
%%

2. //Patch edit page handler, handler/page/edit.php//

After the following existing code snippet in edit.php (wikka v1.1.6.0):

%%(php)
// append a comment?
if ($_REQUEST['appendcomment'])
{
	$body = trim($body)."\n\n----\n\n--".$this->GetUserName().' ('.strftime("%c").')';
}
%%

Add the following code, after line 124

%%(php)
//PATCH BEGIN
// indicates the number of minutes logs will be shown, eg. 5 = display users who accessed page in last 5 minutes and purge the rest
$minutes_interval = 30;
						
// first purge old showlogs
$deletebool = $this->Query("DELETE FROM ".$this->config["table_prefix"]."log WHERE handler=\"edit\" AND tag=\"" . $this->GetPageTag() . "\" AND accessed_at < (NOW() - INTERVAL " . $minutes_interval . " MINUTE)");

// if latest page version insert record in viewlog
$insertbool = $this->Query("INSERT INTO ".$this->config["table_prefix"]."log VALUES(\"\", \"edit\", \"" . $this->GetPageTag(). "\", \"" . $this->GetUserName() . "\", NOW()" . ")");
			
if($insertbool && $deletebool) $ispurged = true;
			
$lastusers = $this->LoadAll("SELECT * FROM ".$this->config["table_prefix"]."log WHERE handler=\"edit\" AND tag=\"" . $this->GetPageTag() . "\" AND accessed_at >= (NOW() - INTERVAL " . $minutes_interval . " MINUTE) GROUP BY username ORDER by username DESC");
			
foreach ($lastusers as $lastuser){				
   if($lastuser["username"] != $this->GetUserName()) { 
	   if($x > 0) $userstoprint .= "::";
	   $userstoprint .= $this->Format($lastuser["username"]); 
	   $x++;
   }
}

if($userstoprint) $lastusersmessage = "In the last " . $minutes_interval . " minutes, the following users opened this page in edit mode:<p>" .$userstoprint . "</p>\n";
			
$output .= $lastusersmessage;
//PATCH END
%%

After this you should be ready to play ball. Try playing around with a couple of different users who open the same page in edit mode and you'll see what this patch does. Please provide feedback if you think whether this is (not) usefull. 

----
CategoryUsers