}
// No To? Give them the default
if (isset($reviewer_comments_fields[0]) && strlen($reviewer_comments_fields[0]) <= strlen('to=')) {
$reviewer_comments_fields[0] = 'To=Author(s)';
}
if ($file_data_obj->isArchived()) {
$filename = $GLOBALS['CONFIG']['archiveDir'] . $_REQUEST['id'] . '.dat';
$file_size = display_filesize($filename);
} else {
$filename = $GLOBALS['CONFIG']['dataDir'] . $_REQUEST['id'] . '.dat';
if (!isset($file_size)) {
$file_size = display_filesize($filename);
}
}
// display red or green icon depending on file status
if ($status == 0 && $user_perms_obj->canView($_REQUEST['id'])) {
$file_unlocked = true;
} else {
$file_unlocked = false;
}
//chm sahar
if (!empty($revision_id)) {
$query = "\n SELECT\n u.last_name,\n u.first_name,\n l.modified_on,\n l.note,\n l.revision\n FROM\n {$GLOBALS['CONFIG']['db_prefix']}log l,\n {$GLOBALS['CONFIG']['db_prefix']}user u\n WHERE\n l.id = :log_id\n AND\n u.username = l.modified_by\n AND\n l.revision = :revision_id\n ORDER BY\n l.modified_on DESC";
$stmt = $pdo->prepare($query);
$stmt->execute(array(':log_id' => $_REQUEST['id'], ':revision_id' => $revision_id));
$revisionData = $stmt->fetchAll();
} else {
$query = "\n SELECT\n u.last_name,\n u.first_name,\n l.modified_on,\n l.note,\n l.revision\n FROM\n {$GLOBALS['CONFIG']['db_prefix']}log l,\n {$GLOBALS['CONFIG']['db_prefix']}user u\n WHERE\n l.id = :log_id\n AND\n u.username = l.modified_by\n ORDER BY\n l.modified_on DESC\n ";
$stmt = $pdo->prepare($query);
$stmt->execute(array(':log_id' => $_REQUEST['id']));
$revisionData = $stmt->fetchAll();
}
// No To? Give them the default
if (isset($reviewer_comments_fields[0]) && strlen($reviewer_comments_fields[0]) <= strlen('to=')) {
$reviewer_comments_fields[0] = 'To=Author(s)';
}
if ($file_data_obj->isArchived()) {
$filename = $GLOBALS['CONFIG']['archiveDir'] . $request_id . '.dat';
$file_size = display_filesize($filename);
} else {
$filename = $GLOBALS['CONFIG']['dataDir'] . $request_id . '.dat';
if (!isset($file_size)) {
$file_size = display_filesize($filename);
}
}
// display red or green icon depending on file status
if ($status == 0 && $user_perms_obj->canView($request_id)) {
$file_unlocked = true;
} else {
$file_unlocked = false;
}
//chm sahar
if (!empty($revision_id)) {
$query = "\n SELECT\n u.last_name,\n u.first_name,\n l.modified_on,\n l.note,\n l.revision\n FROM\n {$GLOBALS['CONFIG']['db_prefix']}log l,\n {$GLOBALS['CONFIG']['db_prefix']}user u\n WHERE\n l.id = :log_id\n AND\n u.username = l.modified_by\n AND\n l.revision = :revision_id\n ORDER BY\n l.modified_on DESC";
$stmt = $pdo->prepare($query);
$stmt->execute(array(':log_id' => $request_id, ':revision_id' => $revision_id));
$revisionData = $stmt->fetchAll();
} else {
$query = "\n SELECT\n u.last_name,\n u.first_name,\n l.modified_on,\n l.note,\n l.revision\n FROM\n {$GLOBALS['CONFIG']['db_prefix']}log l,\n {$GLOBALS['CONFIG']['db_prefix']}user u\n WHERE\n l.id = :log_id\n AND\n u.username = l.modified_by\n ORDER BY\n l.modified_on DESC\n ";
$stmt = $pdo->prepare($query);
$stmt->execute(array(':log_id' => $request_id));
$revisionData = $stmt->fetchAll();
}
// No To? Give them the default
if (isset($reviewer_comments_fields[0]) && strlen($reviewer_comments_fields[0]) <= strlen('to=')) {
$reviewer_comments_fields[0] = 'To=Author(s)';
}
if ($filedata->isArchived()) {
$filename = $GLOBALS['CONFIG']['archiveDir'] . $_REQUEST['id'] . '.dat';
$filesize = display_filesize($filename);
} else {
$filename = $GLOBALS['CONFIG']['dataDir'] . $_REQUEST['id'] . '.dat';
if (!isset($filesize)) {
$filesize = display_filesize($filename);
}
}
// display red or green icon depending on file status
if ($status == 0 && $user->canView($_REQUEST['id'])) {
$file_unlocked = true;
} else {
$file_unlocked = false;
}
//chm sahar
if (isset($lrevision_id)) {
$query = "SELECT {$GLOBALS['CONFIG']['db_prefix']}user.last_name, \r\r\n {$GLOBALS['CONFIG']['db_prefix']}user.first_name, \r\r\n {$GLOBALS['CONFIG']['db_prefix']}log.modified_on, \r\r\n {$GLOBALS['CONFIG']['db_prefix']}log.note, \r\r\n {$GLOBALS['CONFIG']['db_prefix']}log.revision \r\r\n FROM {$GLOBALS['CONFIG']['db_prefix']}log, {$GLOBALS['CONFIG']['db_prefix']}user \r\r\n WHERE {$GLOBALS['CONFIG']['db_prefix']}log.id = '{$_REQUEST['id']}' \r\r\n AND {$GLOBALS['CONFIG']['db_prefix']}user.username = {$GLOBALS['CONFIG']['db_prefix']}log.modified_by \r\r\n AND {$GLOBALS['CONFIG']['db_prefix']}log.revision = {$lrevision_id} \r\r\n ORDER BY {$GLOBALS['CONFIG']['db_prefix']}log.modified_on DESC";
} else {
$query = "SELECT {$GLOBALS['CONFIG']['db_prefix']}user.last_name, \r\r\n {$GLOBALS['CONFIG']['db_prefix']}user.first_name, \r\r\n {$GLOBALS['CONFIG']['db_prefix']}log.modified_on, \r\r\n {$GLOBALS['CONFIG']['db_prefix']}log.note, \r\r\n {$GLOBALS['CONFIG']['db_prefix']}log.revision \r\r\n FROM {$GLOBALS['CONFIG']['db_prefix']}log, {$GLOBALS['CONFIG']['db_prefix']}user \r\r\n WHERE {$GLOBALS['CONFIG']['db_prefix']}log.id = '{$_REQUEST['id']}' \r\r\n AND {$GLOBALS['CONFIG']['db_prefix']}user.username = {$GLOBALS['CONFIG']['db_prefix']}log.modified_by \r\r\n ORDER BY {$GLOBALS['CONFIG']['db_prefix']}log.modified_on DESC";
}
$result = mysql_query($query, $GLOBALS['connection']) or die("Error in query: {$query}. " . mysql_error());
$rows = mysql_num_rows($result);
$revisionData = mysql_fetch_assoc($result);
if ($rows == 1 && !isset($lrevision_id)) {
$revision = "1";
