history.php

<?php
/*
history.php - display revision history
Copyright (C) 2002, 2003, 2004 Stephen Lawrence Jr., Khoa Nguyen
Copyright (C) 2005-2011 Stephen Lawrence Jr.

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.
*/


// check session and $id
session_start();

if (!isset($_SESSION['uid']))
{
    header('Location:index.php?redirection=' . urlencode($_SERVER['PHP_SELF'] . '?' . $_SERVER['QUERY_STRING']));
    exit;
}

include('odm-load.php');

$last_message = (isset($_REQUEST['last_message']) ? $_REQUEST['last_message'] : '');

if (!isset($_REQUEST['id']) || $_REQUEST['id'] == '')
{
    header('Location:error.php?ec=2');
    exit;
}

draw_header(msg('area_view_history'), $last_message);
//revision parsing
if(strchr($_REQUEST['id'], '_') )
{
    list($_REQUEST['id'], $lrevision_id) = explode('_' , $_REQUEST['id']);
}
$datafile = new FileData($_REQUEST['id'], $GLOBALS['connection'], DB_NAME);
// verify
if ($datafile->getError() != NULL)
{
    header('Location:error.php?ec=2');
    exit;
}
else
{
// obtain data from resultset

$owner_fullname = $datafile->getOwnerFullName();
$owner = $owner_fullname[1].', '.$owner_fullname[0];
$realname = $datafile->getRealName();
$category = $datafile->getCategoryName();
$created = $datafile->getCreatedDate();
$description = $datafile->getDescription();
$comments = $datafile->getComment();
$status = $datafile->getStatus();

// corrections
if ($description == '')
{ 
    $description = 'No description available';
}
if ($comments == '')
{ 
    $comment = 'No author comments available';
}
if($datafile->isArchived())
{	
    $filename = $GLOBALS['CONFIG']['archiveDir'] . $_REQUEST['id'] . '.dat';
}
else
{	
    $filename = $GLOBALS['CONFIG']['dataDir'] . $_REQUEST['id'] . '.dat';
}
?>
<table border="0" width=80% cellspacing="4" cellpadding="1">

<tr>
<td align="right">
<?php
// check file status, display appropriate icon
if ($status == 0)
{ 
    echo '<img src="images/file_unlocked.png" alt="" border=0 align="absmiddle">';
} 
else
{ 
    echo '<img src="images/file_locked.png"  alt="" border=0 align="absmiddle">';
}
echo '</td>';
echo '<td align="left"><font size="+1">'.$realname.'</font></td>';
?>
</tr>

<tr>
<th valign=top align=right><?php echo msg('historypage_category');?></th><td><?php echo $category; ?></td>
</tr>

<tr>
<th valign=top align=right><?php echo msg('historypage_file_size');?></th><td> <?php echo display_filesize($filename); ?></td>
</tr>

<tr>
<th valign=top align=right><?php echo msg('historypage_creation_date');?></th><td> <?php echo fix_date($created); ?></td>
</tr>

<tr>
<th valign=top align=right><?php echo msg('historypage_owner');?></th><td> <?php echo $owner; ?></td>
</tr>

<tr>
<th valign=top align=right><?php echo msg('historypage_description');?></th><td> <?php echo $description; ?></td>
</tr>

<tr>
<th valign=top align=right><?php echo msg('historypage_comment');?></th><td> <?php echo $comments; ?></td>
</tr>
<tr>
<th valign=top align=right><?php echo msg('historypage_revision');?></th><td>
<?php 
if(isset($lrevision_id))
{
    if( $lrevision_id == 0)
    {
        echo msg('historypage_original_revision');
    }
    else
    {
        echo $lrevision_id;
    }
}
else
{
    echo msg('historypage_latest');
}
        ?>
</td>
</tr>

<!-- history table -->
<tr>
<td align="right">
<img src="images/revision.png" width=40 height=40 alt="" border="0" align="absmiddle">
</td>
<td><?php echo msg('historypage_history');?></td>
</td>
</tr>

<tr>
<td colspan="2" align="center">
	<table border="0" cellspacing="5" cellpadding="5">
	<tr bgcolor="#83a9f7">
	<th><font size=-1><?php echo msg('historypage_version');?></font></th>
	<th><font size=-1><?php echo msg('historypage_modification');?></font></th>
	<th><font size=-1><?php echo msg('historypage_by');?></font></th>
	<th><font size=-1><?php echo msg('historypage_note');?></font></th>
	</tr>
<?php
	// query to obtain a list of modifications
	
	if( isset($lrevision_id) )
	{
		$query = "SELECT {$GLOBALS['CONFIG']['db_prefix']}user.last_name, 
						{$GLOBALS['CONFIG']['db_prefix']}user.first_name, 
						{$GLOBALS['CONFIG']['db_prefix']}log.modified_on, 
						{$GLOBALS['CONFIG']['db_prefix']}log.note, 
						{$GLOBALS['CONFIG']['db_prefix']}log.revision 
						FROM {$GLOBALS['CONFIG']['db_prefix']}log, {$GLOBALS['CONFIG']['db_prefix']}user 
						WHERE {$GLOBALS['CONFIG']['db_prefix']}log.id = '{$_REQUEST['id']}' 
						AND {$GLOBALS['CONFIG']['db_prefix']}user.username = {$GLOBALS['CONFIG']['db_prefix']}log.modified_by 
						AND {$GLOBALS['CONFIG']['db_prefix']}log.revision <= $lrevision_id 
						ORDER BY {$GLOBALS['CONFIG']['db_prefix']}log.modified_on DESC";
	}
	else
	{
		$query = "SELECT {$GLOBALS['CONFIG']['db_prefix']}user.last_name, 
					{$GLOBALS['CONFIG']['db_prefix']}user.first_name, 
					{$GLOBALS['CONFIG']['db_prefix']}log.modified_on, 
					{$GLOBALS['CONFIG']['db_prefix']}log.note, 
					{$GLOBALS['CONFIG']['db_prefix']}log.revision 
					FROM {$GLOBALS['CONFIG']['db_prefix']}log, {$GLOBALS['CONFIG']['db_prefix']}user 
					WHERE {$GLOBALS['CONFIG']['db_prefix']}log.id = '{$_REQUEST['id']}' 
					AND {$GLOBALS['CONFIG']['db_prefix']}user.username = {$GLOBALS['CONFIG']['db_prefix']}log.modified_by 
					ORDER BY {$GLOBALS['CONFIG']['db_prefix']}log.modified_on DESC";
	}
	$result = mysql_query($query, $GLOBALS['connection']) or die ("Error in query: $query. " . mysql_error());
	$current_revision = mysql_num_rows($result);
	// iterate through resultset
	while(list($last_name, $first_name, $modified_on, $note, $revision_id) = mysql_fetch_row($result))
	{

	if ( isset($bgcolor) && $bgcolor == "#FCFCFC" )
        {
          $bgcolor="#E3E7F9";
        }
        else
        {
          $bgcolor="#FCFCFC";
        }

	echo '<tr bgcolor=' . $bgcolor . '>';

	$extra_message = '';
	if( is_file($GLOBALS['CONFIG']['revisionDir'] . $_REQUEST['id'] . '/' . $_REQUEST['id'] . "_$revision_id.dat") )
	{	
            echo '<td align=center><font size="-1"> <a href="details.php?id=' . $_REQUEST['id'] . "_$revision_id" . '&state=' . ($_REQUEST['state']-1) . '">' . ($revision_id +1). '</a>' . $extra_message;
        }
	else
	{
            echo '<td><font size="-1">' . $revision_id . $extra_message;
        }
?>
	</font></td>
	<td><font size="-1"><?php echo fix_date($modified_on); ?></font></td>
	<td><font size="-1"><?php echo $last_name.', '.$first_name; ?></font></td>
	<td><font size="-1"><?php echo $note; ?></font></td>
	</tr>
<?php
	}
	// clean up
	mysql_free_result($result);
?>
	</table>
</td>
</tr>

</table>
<?php
draw_footer();
}