} // 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";