{$value}" ;
$s .= $value . $y[1] ;
}
else $s .= $x ;
}
return $s ;
}
function wfDataView ( $dt ) # $dt = data type
{
if ( $dt == "" ) return ;
global $wgParser, $wgTitle;
global $wgOut , $wgUser ;
$nsdata = 20 ;
$s = "{$dt}
" ;
# Read from source
$dbr =& wfGetDB( DB_SLAVE );
$sql = "SELECT * FROM cur WHERE cur_namespace={$nsdata} AND cur_title=\"{$dt}\"";
$res1 = $dbr->query( $sql, "wfDataEdit" );
$data = $dbr->fetchObject( $res1 ) ;
$sql = "SELECT * FROM data_rev WHERE rev_cur_id={$data->cur_id} GROUP BY rev_masterkey ORDER BY rev_masterkey" ;
$r = $dbr->query( $sql, "wfDataEdit" );
$mk = array () ;
while ( ($d = $dbr->fetchObject( $r )) ) $mk[] = $d->rev_masterkey ;
foreach ( $mk AS $x )
{
$s .= "{$x}" ;
}
$wgOut->AddHTML ( $s ) ;
}
function wfDataEdit ( $dt ) # $dt = data type
{
if ( $dt == "" ) return ;
global $wgParser, $wgTitle;
global $wgOut , $wgUser ;
$nsdata = 20 ;
$s = "{$dt}
" ;
if ( isset ( $_POST['revision'] ) ) $revision = $_POST['revision'] ;
else if ( isset ( $_GET['revision'] ) ) $revision = $_GET['revision'] ;
else $revision = "" ;
if ( isset ( $_POST['masterkey'] ) ) $masterkey = $_POST['masterkey'] ;
else $masterkey = "" ;
if ( isset ( $_POST['comment'] ) ) $comment = $_POST['comment'] ;
else $comment = "" ;
# Read form source
$dbr =& wfGetDB( DB_SLAVE );
$sql = "SELECT * FROM cur WHERE cur_namespace={$nsdata} AND cur_title=\"{$dt}\"";
$res1 = $dbr->query( $sql, "wfDataEdit" );
$data = $dbr->fetchObject( $res1 ) ;
# Pre-render
$parserOutput = $wgParser->parse( $data->cur_text, $wgTitle, $wgOut->mParserOptions, true );
$t = $parserOutput->getText() ;
# Read from last form
if ( isset ( $_POST['dk'] ) ) $dk = $_POST['dk'] ;
# Store new version
if ( isset ( $_POST['doit'] ) && $dk[$masterkey] )
{
# Get next revision number
$dbw =& wfGetDB( DB_MASTER ); # Maybe DB_SLAVE didn't update yet
$sql = "SELECT MAX(rev_id) AS m FROM data_rev WHERE rev_cur_id={$data->cur_id} AND rev_masterkey=\"" . $dk[$masterkey] . "\"" ;
$r = $dbw->query( $sql, "wfDataEdit" );
$newrev = $dbr->fetchObject( $r ) ;
if ( isset ( $newrev ) AND isset ( $newrev->m ) ) $newrev = $newrev->m ;
else $newrev = "" ;
if ( $newrev == "" ) $newrev = 1 ;
# Generate SQL
$dbw->query( "BEGIN", "wfDataEdit" );
$sql = "INSERT INTO data_rev (rev_cur_id,rev_id,rev_masterkey,rev_user_id,rev_user_text,rev_comment,rev_time) VALUES (" .
"\"{$data->cur_id}\"," .
"\"{$newrev}\",".
"\"" . $dk[$masterkey] . "\"," .
"\"" . $wgUser->getID() . "\",".
"\"" . $wgUser->getName() . "\",".
"\"{$comment}\",".
"\"" . time() . "\");" ;
$dbw->query( $sql, "wfDataEdit" );
foreach ( $dk AS $k => $v )
{
$sql = "INSERT INTO data (data_cur_id,data_revision,data_key,data_value) VALUES (" .
"\"" . $data->cur_id . "\"," .
"\"" . $newrev . "\"," .
"\"" . $k . "\"," .
"\"" . $v . "\");" ;
$dbw->query( $sql, "wfDataEdit" );
}
$dbw->query( "COMMIT", "wfDataEdit" );
$s .= "Action complete.
\n" ;
$s .= wfDataPreview ( $t , $dk ) ;
$wgOut->AddHTML ( $s ) ;
return ;
}
# Preview
if ( isset ( $_POST['preview'] ) ) $s .= wfDataPreview ( $t , $dk ) . "\n
\n" ;
# Editing
$t = explode ( "((" , $t ) ;
$s .= "" ;
$wgOut->AddHTML ( $s ) ;
}
function wfSpecialData()
{
global $wgUseData ;
if ( !$wgUseData ) return "" ;
global $wgOut ;
if ( isset ( $_GET['data_action'] ) ) $data_action = $_GET['data_action'] ;
else $data_action = "" ;
if ( isset ( $_POST['add_data'] ) ) $data_action = "add_data" ;
if ( isset ( $_POST['view_data'] ) ) $data_action = "view_data" ;
$nsdata = 20 ;
$last = "
Back to data" ;
if ( $data_action == "" )
{
$s = "" ;
$s .= "" ;
$wgOut->AddHTML ( $s ) ;
$last = "" ;
}
else if ( $data_action == "add_data" )
{
wfDataEdit ( $_POST['data_type'] ) ;
}
else if ( $data_action == "view_data" )
{
wfDataView ( $_POST['data_type'] ) ;
}
if ( $last ) $wgOut->AddHTML ( $last ) ;
return "" ;
}
?>