# http://www.mediawiki.org/
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License along
# with this program; if not, write to the Free Software Foundation, Inc.,
# 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
# http://www.gnu.org/copyleft/gpl.html
class Validation {
function find_this_version( $article_title , &$article_time , &$id , &$tab ) {
$id = "";
$tab = "";
$sql = "SELECT cur_id,cur_timestamp FROM cur WHERE cur_namespace=0 AND cur_title='" . wfStrencode( $article_title ) . "'";
$res = wfQuery( $sql, DB_READ );
if( $s = wfFetchObject( $res ) ) {
if ( $article_time == "" ) {
# No timestamp = current version
$article_time = $s->cur_timestamp;
} elseif ( $article_time == $s->cur_timestamp ) {
# Means current version
$tab = "cur";
$id = $s->cur_id;
}
}
if ( $id == "" ) {
$sql = "SELECT old_id FROM old WHERE old_namespace=0 AND old_title='" . wfStrencode( $article_title ) .
"' AND old_timestamp='" . wfStrencode( $article_time ) . "'";
$res = wfQuery( $sql, DB_READ );
if( $s = wfFetchObject( $res ) ) {
$tab = "old";
$id = $s->old_id;
}
}
}
function get_prev_data( $user_id , $article_title , $article_timestamp = "" ) {
$ret = array ();
$sql = "SELECT * FROM validate WHERE val_user='" . wfStrencode( $user_id ) .
"' AND val_title='" . wfStrencode( $article_title ) . "'";
if ( $article_timestamp != "" ) {
$sql .= " AND val_timestamp='" . wfStrencode( $article_timestamp ) . "'";
}
$res = wfQuery( $sql, DB_READ );
while( $s = wfFetchObject( $res ) ) {
$ret[$s->val_timestamp][$s->val_type] = $s;
}
return $ret;
}
function validate_form( $article_title = "" ) {
global $wgOut, $wgLang, $wgUser, $wgArticle, $wgRequest;
if ( $wgUser->getID() == 0 ) {
# Anon
$wgOut->addHTML( htmlspecialchars( wfMsg( 'val_no_anon_validation' ) ) .
$this->getPageStatistics ( $article_title ) ) ;
return;
}
$validationtypes = $wgLang->getValidationTypes();
if ( $article_title == "" ) {
$article_title = $wgRequest->getVal( 'article_title' );
$heading = "
" . htmlspecialchars( $article_title ) . "
\n";
} else {
$heading = "";
}
$article_time = "";
$article_time = $wgRequest->getVal( 'timestamp' );
$article = Title::newFromText( $article_title );
if( is_null( $article ) ) {
$wgOut->errorpage( "badtitle", "badtitletext" );
return;
}
# Now we get all the "votes" for the different versions of this article for this user
$val = $this->get_prev_data( $wgUser->getID() , $article_title );
# No votes for this version, initial data
if( !isset( $val[$article_time] ) ) {
if( $article_time == "" ) {
$res = wfQuery( "select cur_timestamp FROM cur WHERE cur_title='" .
wfStrencode( $article_title ) . "' AND cur_namespace=0", DB_READ );
if( $s = wfFetchObject( $res ) ) {
$article_time = $s->cur_timestamp;
}
}
$val[$article_time] = array();
}
# Newest versions first
krsort( $val );
# User has clicked "Doit" before, so evaluate form
if( $wgRequest->wasPosted() ) {
$oldtime = StrVal( $wgRequest->getVal( 'oldtime' ) );
if( !isset ( $val[$oldtime] ) ) {
$val[$oldtime] = array();
}
# Reading postdata
$postrad = array();
$poscomment = array();
for( $idx = 0 ; $idx < count( $validationtypes) ; $idx++ ) {
$postrad[$idx] = $wgRequest->getVal( "rad{$idx}" );
$postcomment[$idx] = $wgRequest->getText( "comment{$idx}" );
}
# Merge others into this one
if( $wgRequest->getCheck( 'merge_other' ) ) {
foreach( $val as $time => $stuff ) {
if( $time != $article_time ) {
for( $idx = 0; $idx < count( $validationtypes ); $idx++ ) {
$rad = $postrad[$idx];
if( isset ( $stuff[$idx] ) && $stuff[$idx]->val_value != -1 && $rad == -1 ) {
$postrad[$idx] = $stuff[$idx]->val_value;
$postcomment[$idx] = $stuff[$idx]->val_comment;
}
}
}
}
}
# Clear all others
if( $wgRequest->getCheck( 'clear_other' ) ) {
$sql = "DELETE FROM validate WHERE val_title='" . wfStrencode( $article_title ) .
"' AND val_timestamp<>'" . wfStrencode( $oldtime ) . "' AND val_user='";
$sql .= wfStrencode( $wgUser->getID() ) . "'";
wfQuery( $sql, DB_WRITE );
$val2 = $val[$oldtime]; # Only version left
$val = array(); # So clear others
$val[$oldtime] = $val2;
}
# Delete old "votes" for this version
$sql = "DELETE FROM validate WHERE val_title='" . wfStrencode( $article_title ) .
"' AND val_timestamp='" . wfStrencode( $oldtime ) . "' AND val_user='";
$sql .= wfStrencode( $wgUser->getID() ) . "'";
wfQuery( $sql, DB_WRITE );
# Incorporate changes
for( $idx = 0; $idx < count( $validationtypes ); $idx++ ) {
$comment = $postcomment[$idx] ;
$rad = $postrad[$idx] ;
if ( !isset( $val[$oldtime][$idx] ) ) {
$val[$oldtime][$idx] = "";
}
$val[$oldtime][$idx]->val_value = $rad;
$val[$oldtime][$idx]->val_comment = $comment;
if( $rad != -1 ) {
# Store it in the database
$sql = "INSERT INTO validate (val_user,val_title,val_timestamp,val_type,val_value,val_comment) " .
"VALUES ( '" . wfStrencode( $wgUser->getID() ) . "','" .
wfStrencode( $article_title ) . "','" .
wfStrencode( $oldtime ) . "','" .
wfStrencode( $idx ) . "','" .
wfStrencode( $rad ) . "','" .
wfStrencode( $comment ) . "')";
wfQuery( $sql, DB_WRITE );
}
}
$wgArticle->showArticle( "Juhuu", wfMsg( 'val_validated' ) );
return; # Show article instead of validation page
}
# Generating HTML
$html = "";
$skin = $wgUser->getSkin();
$staturl = $skin->makeSpecialURL( "validate" , "mode=stat_page&article_title=" . urlencode( $article_title ) );
$listurl = $skin->makeSpecialURL( "validate" , "mode=list_page" );
$html .= "" . wfMsg('val_stat_link_text') . " \n";
$html .= "" . wfMsg('val_article_lists') . "
\n";
$html .= "" . wfMsg('val_form_note') . "
\n";
# Generating data tables
$tabsep = " | ";
$topstyle = "style='border-top:2px solid black'";
foreach( $val as $time => $stuff ) {
$tablestyle = "cellspacing='0' cellpadding='2'";
if ( $article_time == $time ) {
$tablestyle .=" style='border: 2px solid red'";
}
$html .= "" . wfMsg( 'val_version_of', gmdate( "F d, Y H:i:s", wfTimestamp2Unix( $time ) ) );
$this->find_this_version ( $article_title , $time , $table_id , $table_name );
if( $table_name == "cur" ) {
$html .= " (" . wfMsg( 'val_this_is_current_version' ) . ")";
}
$html .= "
\n" ;
$html .= "\n";
}
$html .= "" . wfMsg( 'preview' ) . "
";
$wgOut->addHTML( $html );
$wgOut->addWikiText( $wgArticle->getContent( true ) );
}
function getData( $user = -1 , $title = "" , $type = -1 ) {
$ret = array();
$sql = array();
if( $user != -1 ) {
$sql[] = "val_user='" . wfStrencode( $user ) . "'";
}
if( $type != -1 ) {
$sql[] = "val_type='" . wfStrencode( $type ) . "'";
}
if( $title != "" ) {
$sql[] = "val_title='" . wfStrencode( $title ) . "'";
}
$sql = implode( " AND " , $sql );
if( $sql != "" ) {
$sql = " WHERE " . $sql;
}
$sql = "SELECT * FROM validate" . $sql;
$res = wfQuery( $sql, DB_READ );
while( $s = wfFetchObject( $res ) ) {
$ret["{$s->val_title}"]["{$s->val_timestamp}"]["{$s->val_type}"][] = $s;
}
return $ret;
}
# Show statistics for the different versions of a single article
function getPageStatistics( $article_title = "" ) {
global $wgLang, $wgUser, $wgOut, $wgRequest;
$validationtypes = $wgLang->getValidationTypes();
if( $article_title == "" ) {
$article_title = $wgRequest->getVal( 'article_title' );
}
$d = $this->getData( -1 , $article_title , -1 );
if( count ( $d ) ) {
$d = array_shift ( $d ) ;
} else {
$d = array();
}
krsort( $d );
# Getting table data (cur_id, old_id etc.) for each version
$table_id = array();
$table_name = array();
foreach( $d as $version => $data ) {
$this->find_this_version( $article_title, $version, $table_id[$version], $table_name[$version] );
}
# Generating HTML
$title = Title::newFromDBkey( $article_title );
$wgOut->setPageTitle( wfMsg( 'val_page_validation_statistics' , $title->getPrefixedText() ) );
$html = "";
$skin = $wgUser->getSkin();
$listurl = $skin->makeSpecialURL( "validate" , "mode=list_page" );
$html .= "" . wfMsg( 'val_article_lists' ) . "
\n";
$html .= "\n";
$html .= "" . wfMsg('val_version') . " | ";
foreach( $validationtypes as $idx => $title ) {
$title = explode ( "|" , $title );
$html .= "{$title[0]} | ";
}
$html .= "" . wfMsg('val_total') . " | ";
$html .= "
\n";
foreach( $d as $version => $data ) {
# Preamble for this version
$title = Title::newFromDBkey( $article_title );
$version_date = $wgLang->timeanddate( $version );
$version_validate_link = $title->escapeLocalURL( "action=validate×tamp={$version}" );
$version_validate_link = "" . wfMsg('val_validate_version') . "";
if( $table_name[$version] == 'cur' ) {
$version_view_link = $title->escapeLocalURL( "" );
} else {
$version_view_link = $title->escapeLocalURL( "oldid={$table_id[$version]}" );
}
$version_view_link = "" . wfMsg('val_view_version') . "";
$html .= "";
$html .= "{$version_date} {$version_view_link} {$version_validate_link} | ";
# Individual data
$vmax = array();
$vcur = array();
$users = array();
foreach( $data as $type => $x2 ) {
if ( !isset ( $vcur[$type] ) ) $vcur[$type] = 0 ;
if ( !isset ( $vmax[$type] ) ) $vmax[$type] = 0 ;
if ( !isset ( $users[$type] ) ) $users[$type] = 0 ;
foreach( $x2 as $user => $x ) {
$vcur[$type] += $x->val_value;
$temp = explode( "|" , $validationtypes[$type] );
$vmax[$type] += $temp[3] - 1;
$users[$type] += 1;
}
}
$total_count = 0;
$total_percent = 0;
foreach( $validationtypes as $idx => $title ) {
if( isset ( $vcur[$idx] ) ) {
$average = 100 * $vcur[$idx] / $vmax[$idx] ;
$total_count += 1;
$total_percent += $average;
if( $users[$idx] > 1 ) {
$msgid = "val_percent";
} else {
$msgid = "val_percent_single";
}
$html .= "" .
wfMsg( $msgid, number_format( $average, 2 ) ,
$vcur[$idx] , $vmax[$idx] , $users[$idx] );
} else {
$html .= " | ";
$html .= "(" . wfMsg ( "val_noop" ) . ")";
}
$html .= " | ";
}
if( $total_count > 0 ) {
$total = $total_percent / $total_count;
$total = number_format( $total , 2 ) . " %";
} else {
$total = "";
}
$html .= "{$total} | ";
$html .= "
";
}
$html .= "
\n";
return $html ;
}
function countUserValidations( $userid ) {
$sql = "SELECT count(DISTINCT val_title) AS num FROM validate WHERE val_user=" . IntVal( $userid );
$res = wfQuery( $sql, DB_READ );
if ( $s = wfFetchObject( $res ) ) {
$num = $s->num;
} else {
$num = 0;
}
return $num;
}
function getArticleList() {
global $wgLang, $wgOut;
$validationtypes = $wgLang->getValidationTypes();
$wgOut->setPageTitle( wfMsg( 'val_article_lists' ) );
$html = "";
# Choices
$choice = array ();
$maxw = 0;
foreach( $validationtypes as $idx => $data ) {
$x = explode( "|" , $data , 4 );
if( $x[3] > $maxw ) {
$maxw = $x[3];
}
}
foreach( $validationtypes as $idx => $data ) {
$choice[$idx] = array();
for( $a = 0 ; $a < $maxw ; $a++ ) {
$var = "cb_{$idx}_{$a}";
if( isset ( $_POST[$var] ) ) $choice[$idx][$a] = $_POST[$var] ; # Selected
else if ( !isset ( $_POST["doit"] ) ) $choice[$idx][$a] = 1 ; # First time
else $choice[$idx][$a] = 0 ; # De-selected
}
}
# The form
$html .= "\n";
# The query
$articles = array();
$sql = "SELECT DISTINCT val_title,val_timestamp,val_type,avg(val_value) AS avg FROM validate GROUP BY val_title,val_timestamp,val_type";
$res = wfQuery( $sql, DB_READ );
while( $s = wfFetchObject( $res ) ) {
$articles[$s->val_title][$s->val_timestamp][$s->val_type] = $s;
}
# The list
$html .= "\n";
foreach( $articles as $dbkey => $timedata ) {
$title = Title::newFromDBkey( $dbkey );
$out = array();
krsort( $timedata );
foreach( $timedata as $timestamp => $typedata ) {
$showit = true;
foreach( $typedata as $type => $data ) {
$avg = intval ( $data->avg + 0.5 );
if ( $choice[$type][$avg] == 0 ) $showit = false;
}
if( $showit ) {
$out[] = "- " . $this->getVersionLink ( $title , $timestamp ) . "
\n";
}
}
if( count( $out ) > 0 ) {
$html .= "- \n";
$html .= htmlspecialchars( $title->getText() ) . "\n";
$html .= "
\n";
$html .= implode( "\n" , $out );
$html .= "
\n \n";
}
}
$html .= "
\n";
return $html;
}
function getVersionLink( &$title , $timestamp ) {
global $wgLang;
$dbkey = $title->getDBkey();
$this->find_this_version( $dbkey, $timestamp, $table_id, $table_name );
if( $table_name == 'cur' ) {
$link = $title->getLocalURL( "" );
} else {
$link = $title->getLocalURL( "action=validate×tamp={$table_id}" );
}
$linktitle = wfMsg( 'val_version_of', $wgLang->timeanddate( $timestamp ) );
$link = "" . $linktitle . "";
if( $table_name == 'cur' ) {
$link .= " (" . wfMsg ( 'val_this_is_current_version' ) . ")";
}
$vlink = wfMsg( 'val_tab' );
$vlink = "[escapeLocalURL( "action=validate×tamp={$timestamp}" ) . "\">{$vlink}] " . $link;
return $vlink ;
}
}
function wfSpecialValidate( $page = "" ) {
global $wgOut, $wgRequest, $wgUseValidation;
if( !$wgUseValidation ) {
$wgOut->errorpage( "nosuchspecialpage", "nospecialpagetext" );
return;
}
$mode = $wgRequest->getVal( 'mode', 'form' );
$v = new Validation;
$html = "" ;
/* if( $mode == "form" ) {
$html = $v->validate_form () ;
} else */
if( $mode == "stat_page" ) {
$html = $v->getPageStatistics();
} else if( $mode == "list_page" ) {
$html = $v->getArticleList();
}
$wgOut->addHTML( $html );
}
?>