initial commit

1 files changed, 902 insertions, 0 deletions

diff --git a/editcodeadmin.inc b/editcodeadmin.inc
new file mode 100755
index 0000000..41f0e83
--- /dev/null
+++ b/editcodeadmin.inc
@@ -0,0 +1,902 @@
+<?php
+// $Id$
+
+/******************************************************************************/
+/***************************** EDIT EXAMPLE ***********************************/
+/******************************************************************************/
+
+function upload_examples_admin_edit_form($form_state)
+{
+  global $user;
+  $example_id = arg(2);
+
+  /* get example details */
+  $example_q = db_query("SELECT * FROM {textbook_companion_example} WHERE id = %d LIMIT 1", $example_id);
+  $example_data = db_fetch_object($example_q);
+  if (!$example_q)
+  {
+    drupal_set_message(t("Invalid example selected."), 'error');
+    drupal_goto('');
+    return;
+  }
+
+  /* get examples files */
+  $source_file = ""; $source_id = 0;
+  $result1_file = ""; $result1_id = 0;
+  $result2_file = ""; $result2_id = 0;
+  $xcos1_file = ""; $xcos1_id = 0;
+  $xcos2_file = ""; $xcos2_id = 0;
+
+  $example_files_q = db_query("SELECT * FROM {textbook_companion_example_files} WHERE example_id = %d", $example_id);
+  while ($example_files_data = db_fetch_object($example_files_q))
+  {
+    if ($example_files_data->filetype == "S")
+    {
+      $source_file = l($example_files_data->filename, 'download/file/' . $example_files_data->id);
+      $source_file_id = $example_files_data->id;
+    }
+    if ($example_files_data->filetype == "R")
+    {
+      if (strlen($result1_file) == 0)
+      {
+        $result1_file = l($example_files_data->filename, 'download/file/' . $example_files_data->id);
+        $result1_file_id = $example_files_data->id;
+      } else {
+        $result2_file = l($example_files_data->filename, 'download/file/' . $example_files_data->id);
+        $result2_file_id = $example_files_data->id;
+      }
+    }
+    if ($example_files_data->filetype == "X")
+    {
+      if (strlen($xcos1_file) <= 0)
+      {
+        $xcos1_file = l($example_files_data->filename, 'download/file/' . $example_files_data->id);
+        $xcos1_file_id = $example_files_data->id;
+      } else {
+        $xcos2_file = l($example_files_data->filename, 'download/file/' . $example_files_data->id);
+        $xcos2_file_id = $example_files_data->id;
+      }
+    }
+   }
+
+  /* get chapter details */
+  $chapter_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE id = %d", $example_data->chapter_id);
+  $chapter_data = db_fetch_object($chapter_q);
+  if (!$chapter_data)
+  {
+    drupal_set_message(t("Invalid chapter selected."), 'error');
+    drupal_goto('');
+    return;
+  }
+
+  /* get preference details */
+  $preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $chapter_data->preference_id);
+  $preference_data = db_fetch_object($preference_q);
+  if (!$preference_data)
+  {
+    drupal_set_message(t("Invalid book selected."), 'error');
+    drupal_goto('');
+    return;
+  }
+
+  /* get proposal details */
+  $proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = %d", $preference_data->proposal_id);
+  $proposal_data = db_fetch_object($proposal_q);
+  if (!$proposal_data)
+  {
+    drupal_set_message(t("Invalid proposal selected."), 'error');
+    drupal_goto('');
+    return;
+  }
+
+  $user_data = user_load($proposal_data->uid);
+
+  /* add javascript for automatic book title, check if example uploaded, dependency selection effects */
+  $chapter_name_js = " $(document).ready(function() {
+    $('#edit-existing-depfile-dep-book-title').change(function() {
+      var dep_selected = ''; 
+      /* showing and hiding relevant files */
+      $('.form-checkboxes .option').hide();
+      $('.form-checkboxes .option').each(function(index) {
+        var activeClass = $('#edit-existing-depfile-dep-book-title').val();
+        if ($(this).children().hasClass(activeClass)) {
+          $(this).show();
+        }
+        if ($(this).children().attr('checked') == true) {
+          dep_selected += $(this).children().next().text() + '<br />';
+        }
+      });
+      /* showing list of already existing dependencies */
+      $('#existing_depfile_selected').html(dep_selected);
+    });
+
+    $('.form-checkboxes .option').change(function() {
+      $('#edit-existing-depfile-dep-book-title').trigger('change');
+    });
+    $('#edit-existing-depfile-dep-book-title').trigger('change');
+  });";
+  drupal_add_js($chapter_name_js, 'inline', 'header');
+
+  $form['#redirect'] = 'code_approval/bulk';
+  $form['#attributes'] = array('enctype' => "multipart/form-data");
+
+  $form['book_details']['book'] = array(
+    '#type' => 'item',
+    '#value' => $preference_data->book,
+    '#title' => t('Title of the Book'),
+  );
+  $form['contributor_name'] = array(
+    '#type' => 'item',
+    '#value' => $proposal_data->full_name,
+    '#title' => t('Contributor Name'),
+  );
+  $form['number'] = array(
+    '#type' => 'item',
+    '#title' => t('Chapter No'),
+    '#value' => $chapter_data->number,
+  );
+  $form['name'] = array(
+    '#type' => 'item',
+    '#title' => t('Title of the Chapter'),
+    '#value' => $chapter_data->name,
+  );
+  $form['example_number'] = array(
+    '#type' => 'item',
+    '#title' => t('Example No'),
+    '#value' => $example_data->number,
+  );
+  $form['example_caption'] = array(
+    '#type' => 'textfield',
+    '#title' => t('Caption'),
+    '#size' => 40,
+    '#maxlength' => 255,
+    '#required' => TRUE,
+    '#default_value' => $example_data->caption,
+  );
+  $form['example_warning'] = array(
+    '#type' => 'item',
+    '#title' => t('You should upload all the files (main or source files, result files, executable file if any)'),
+    '#prefix' => '<div style="color:red">',
+    '#suffix' => '</div>',
+  );
+
+  $form['sourcefile'] = array(
+    '#type' => 'fieldset',
+    '#title' => t('Main or Source Files'),
+    '#collapsible' => FALSE,
+    '#collapsed' => FALSE,
+  );
+  if ($source_file)
+  {
+    $form['sourcefile']['cur_source'] = array(
+      '#type' => 'item',
+      '#title' => t('Existing Main or Source File'),
+      '#value' => $source_file,
+    );
+    $form['sourcefile']['cur_source_checkbox'] = array(
+      '#type' => 'checkbox',
+      '#title' => t('Delete Existing Main or Source File'),
+      '#description' => 'Check to delete the existing Main or Source file.',
+    );
+    $form['sourcefile']['sourcefile1'] = array(
+      '#type' => 'file',
+      '#title' => t('Upload New Main or Source File'),
+      '#size' => 48,
+      '#description' => t("Upload new Main or Source file above if you want to replace the existing file. Leave blank if you want to keep using the existing file. <br />") .
+      t('Allowed file extensions : ') . variable_get('textbook_companion_source_extensions', ''),
+    );
+    $form['sourcefile']['cur_source_file_id'] = array(
+      '#type' => 'hidden',
+      '#value' => $source_file_id,
+    );
+  } else {
+    $form['sourcefile']['sourcefile1'] = array(
+      '#type' => 'file',
+      '#title' => t('Upload New Main or Source File'),
+      '#size' => 48,
+      '#description' => t('Allowed file extensions : ') . variable_get('textbook_companion_source_extensions', ''),
+    );
+  }
+
+  $form['dep_files'] = array(
+    '#type' => 'item',
+    '#title' => t('Dependency Files'),
+  );
+  
+  /************ START OF EXISTING DEPENDENCIES **************/
+  
+  $dependency_files = array();
+  $dependency_q = db_query("SELECT * FROM {textbook_companion_example_dependency} WHERE example_id = %d", $example_data->id);
+  while ($dependency_data = db_fetch_object($dependency_q))
+  {
+    $dependency_files[] = $dependency_data->dependency_id;
+  }
+  
+  /* existing dependencies */
+  $form['existing_depfile'] = array(
+    '#type' => 'fieldset',
+    '#title' => t('Use Already Existing Dependency Files'),
+    '#collapsible' => FALSE,
+    '#collapsed' => FALSE,
+    '#prefix' => '<div id="existing-depfile-wrapper">',
+    '#suffix' => '</div>',
+    '#tree' => TRUE,
+  );
+  
+  /* existing dependencies */
+  $form['existing_depfile']['selected'] = array(
+    '#type' => 'item',
+    '#title' => t('Existing Dependency Files Selected'),
+    '#value' => '<div id="existing_depfile_selected"></div>',
+  );
+  
+  $form['existing_depfile']['dep_book_title'] = array(
+    '#type' => 'select',
+    '#title' => t('Title of the Book'),
+    '#options' => _list_of_book_titles(),
+  );
+
+  list($files_options, $files_options_class) = _list_of_book_dependency_files();
+  $form['existing_depfile']['dep_chapter_example_files'] = array(
+    '#type' => 'checkboxes',
+    '#title' => t('Dependency Files'),
+    '#options' => $files_options,
+    '#options_class' => $files_options_class,
+    '#multiple' => TRUE,
+    '#default_value' => $dependency_files,
+  );
+
+  $form['existing_depfile']['dep_upload'] = array(
+    '#type' => 'item',
+    '#value' => l('Upload New Depedency Files', 'textbook_companion/code/upload_dep'),
+  );
+  /************ END OF EXISTING DEPENDENCIES **************/
+  
+  $form['result'] = array(
+    '#type' => 'fieldset',
+    '#title' => t('Result Files'),
+    '#collapsible' => FALSE,
+    '#collapsed' => FALSE,
+  );
+  if ($result1_file)
+  {
+    $form['result']['cur_result1'] = array(
+      '#type' => 'item',
+      '#title' => t('Existing Result File 1'),
+      '#value' => $result1_file,
+    );
+    $form['result']['cur_result1_checkbox'] = array(
+      '#type' => 'checkbox',
+      '#title' => t('Delete Existing Result File 1'),
+      '#description' => 'Check to delete the existing Result file.',
+    );
+    $form['result']['result1'] = array(
+      '#type' => 'file',
+      '#title' => t('Upload New Result File 1'),
+      '#size' => 48,
+      '#description' => t("Upload new Result file above if you want to replace the existing file, leave blank if you want to keep using the existing file. <br />") .
+        t('Allowed file extensions : ') . variable_get('textbook_companion_result_extensions', ''),
+    );
+    $form['result']['cur_result1_file_id'] = array(
+      '#type' => 'hidden',
+      '#value' => $result1_file_id,
+    );
+  } else {
+    $form['result']['result1'] = array(
+      '#type' => 'file',
+      '#title' => t('Upload New Result File 1'),
+      '#size' => 48,
+      '#description' => t('Allowed file extensions : ') . variable_get('textbook_companion_result_extensions', ''),
+    );
+  }
+  
+  $form['result']['br'] = array(
+  '#type' => 'item',
+  '#value' => "<br />",
+  );
+  
+  if ($result2_file)
+  {
+    $form['result']['cur_result2'] = array(
+      '#type' => 'item',
+      '#title' => t('Existing Result File 2'),
+      '#value' => $result2_file,
+    );
+    $form['result']['cur_result2_checkbox'] = array(
+      '#type' => 'checkbox',
+      '#title' => t('Delete Existing Result File 2'),
+      '#description' => 'Check to delete the existing Result file.',
+    );
+    $form['result']['result2'] = array(
+      '#type' => 'file',
+      '#title' => t('Upload New Result file 2'),
+      '#size' => 48,
+      '#description' => t("Upload new Result file above if you want to replace the existing file. Leave blank if you want to keep using the existing file. <br />") . 
+        t('Allowed file extensions : ') . variable_get('textbook_companion_result_extensions', ''),
+    );
+    $form['result']['cur_result2_file_id'] = array(
+      '#type' => 'hidden',
+      '#value' => $result2_file_id,
+    );
+  } else {
+    $form['result']['result2'] = array(
+      '#type' => 'file',
+      '#title' => t('Upload New Result file 2'),
+      '#size' => 48,
+      '#description' => t('Allowed file extensions : ') . variable_get('textbook_companion_result_extensions', ''),
+    );
+  }
+  $form['xcos'] = array(
+    '#type' => 'fieldset',
+    '#title' => t('XCOS Files'),
+    '#collapsible' => FALSE,
+    '#collapsed' => FALSE,
+  );
+  if ($xcos1_file)
+  {
+    $form['xcos']['cur_xcos1'] = array(
+      '#type' => 'item',
+      '#title' => t('Existing xcos File 1'),
+      '#value' => $xcos1_file,
+    );
+    $form['xcos']['cur_xcos1_checkbox'] = array(
+      '#type' => 'checkbox',
+      '#title' => t('Delete Existing xcos File 1'),
+      '#description' => 'Check to delete the existing xcos file.',
+    );
+    $form['xcos']['xcos1'] = array(
+      '#type' => 'file',
+      '#title' => t('Upload New xcos file 1'),
+      '#size' => 48,
+      '#description' => t("Upload new xcos file above if you want to replace the existing file. Leave blank if you want to keep using the existing file. <br />") .
+        t('Allowed file extensions : ') . variable_get('textbook_companion_xcos_extensions', ''),
+    );
+    $form['sourcefile']['cur_xcos1_file_id'] = array(
+      '#type' => 'hidden',
+      '#value' => $xcos1_file_id,
+    );
+  } else {
+    $form['xcos']['xcos1'] = array(
+      '#type' => 'file',
+      '#title' => t('Upload New xcos file 1'),
+      '#size' => 48,
+      '#description' => t('Allowed file extensions : ') . variable_get('textbook_companion_xcos_extensions', ''),
+    );
+  }
+
+  $form['xcos']['br'] = array(
+    '#type' => 'item',
+    '#value' => "<br />",
+  );
+
+  if ($xcos2_file)
+  {
+    $form['xcos']['cur_xcos2'] = array(
+      '#type' => 'item',
+      '#title' => t('Existing xcos File 2'),
+      '#value' => $xcos2_file,
+    );
+    $form['xcos']['cur_xcos2_checkbox'] = array(
+      '#type' => 'checkbox',
+      '#title' => t('Delete Existing xcos File 2'),
+      '#description' => 'Check to delete the existing xcos file.',
+    );
+    $form['xcos']['xcos2'] = array(
+      '#type' => 'file',
+      '#title' => t('Upload New xcos file 2'),
+      '#size' => 48,
+      '#description' =>  t("Upload new xcos file above if you want to replace the existing file. Leave blank if you want to keep using the existing file. <br />") . 
+        t('Allowed file extensions : ') . variable_get('textbook_companion_xcos_extensions', ''),
+    );
+    $form['xcos']['cur_xcos2_file_id'] = array(
+      '#type' => 'hidden',
+      '#value' => $xcos2_file_id,
+    );
+  } else {
+    $form['xcos']['xcos2'] = array(
+      '#type' => 'file',
+      '#title' => t('Upload New xcos file 2'),
+      '#size' => 48,
+      '#description' => t('Allowed file extensions : ') . variable_get('textbook_companion_xcos_extensions', ''),
+    );
+  }
+
+  $form['submit'] = array(
+    '#type' => 'submit',
+    '#value' => t('Submit')
+  );
+
+  $form['cancel'] = array(
+    '#type' => 'markup',
+    '#value' => l(t('Cancel'), 'textbook_companion/code'),
+  );
+  return $form;
+}
+
+function upload_examples_admin_edit_form_validate($form, &$form_state)
+{
+  if (!check_name($form_state['values']['example_caption']))
+    form_set_error('example_caption', t('Example Caption can contain only alphabets, numbers and spaces.'));
+
+  if (isset($_FILES['files']))
+  {
+    /* check for valid filename extensions */  
+    foreach ($_FILES['files']['name'] as $file_form_name => $file_name)
+    {
+      if ($file_name)
+      {
+        /* checking file type */
+        if (strstr($file_form_name, 'source'))
+          $file_type = 'S';
+        else if (strstr($file_form_name, 'result'))
+          $file_type = 'R';
+        else if (strstr($file_form_name, 'xcos'))
+          $file_type = 'X';
+        else
+          $file_type = 'U';
+
+        $allowed_extensions_str = '';
+        switch ($file_type)
+        {
+        case 'S':
+          $allowed_extensions_str = variable_get('textbook_companion_source_extensions', '');
+          break;
+        case 'R':
+          $allowed_extensions_str = variable_get('textbook_companion_result_extensions', '');
+          break;
+        case 'X':
+          $allowed_extensions_str = variable_get('textbook_companion_xcos_extensions', '');
+          break;
+        }
+
+        $allowed_extensions = explode(',' , $allowed_extensions_str);
+        $temp_extension = end(explode('.', strtolower($_FILES['files']['name'][$file_form_name])));
+        if (!in_array($temp_extension, $allowed_extensions))
+          form_set_error($file_form_name, t('Only file with ' . $allowed_extensions_str . ' extensions can be uploaded.'));
+        if ($_FILES['files']['size'][$file_form_name] <= 0)
+          form_set_error($file_form_name, t('File size cannot be zero.'));
+
+        /* check if valid file name */
+        if (!textbook_companion_check_valid_filename($_FILES['files']['name'][$file_form_name]))
+         form_set_error($file_form_name, t('Invalid file name specified. Only alphabets, numbers and underscore is allowed as a valid filename.'));
+      }
+    }
+  }
+
+  /* add javascript again for automatic book title, check if example uploaded, dependency selection effects */
+  $chapter_name_js = " $(document).ready(function() {
+    $('#edit-number').change(function() {
+      $.get('" . base_path() . "textbook_companion/ajax/chapter_title/' + $('#edit-number').val() + '/' + " . $row->pre_id . ", function(data) {
+        $('#edit-name').val(data);
+      });
+    });
+    $('#edit-example-number').change(function() {
+      $.get('" . base_path() . "textbook_companion/ajax/example_exists/' + $('#edit-number').val() + '/' + $('#edit-example-number').val(), function(data) {
+        if (data) {
+          alert(data);
+        }
+      });
+    });
+    $('#edit-existing-depfile-dep-book-title').change(function() {
+      var dep_selected = ''; 
+      /* showing and hiding relevant files */
+      $('.form-checkboxes .option').hide();
+      $('.form-checkboxes .option').each(function(index) {
+        var activeClass = $('#edit-existing-depfile-dep-book-title').val();
+        if ($(this).children().hasClass(activeClass)) {
+          $(this).show();
+        }
+        if ($(this).children().attr('checked') == true) {
+          dep_selected += $(this).children().next().text() + '<br />';
+        }
+      });
+      /* showing list of already existing dependencies */
+      $('#existing_depfile_selected').html(dep_selected);
+    });
+
+    $('.form-checkboxes .option').change(function() {
+      $('#edit-existing-depfile-dep-book-title').trigger('change');
+    });
+    $('#edit-existing-depfile-dep-book-title').trigger('change');
+  });";
+  drupal_add_js($chapter_name_js, 'inline', 'header');
+}
+
+function upload_examples_admin_edit_form_submit($form, &$form_state)
+{
+  global $user;
+  $example_id = arg(2);
+
+  /* get example details */
+  $example_q = db_query("SELECT * FROM {textbook_companion_example} WHERE id = %d LIMIT 1", $example_id);
+  $example_data = db_fetch_object($example_q);
+  if (!$example_q)
+  {
+    drupal_set_message(t("Invalid example selected."), 'error');
+    drupal_goto('');
+    return;
+  }
+
+  /* get chapter details */
+  $chapter_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE id = %d", $example_data->chapter_id);
+  $chapter_data = db_fetch_object($chapter_q);
+  if (!$chapter_data)
+  {
+    drupal_set_message(t("Invalid chapter selected."), 'error');
+    drupal_goto('');
+    return;
+  }
+
+  /* get preference details */
+  $preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $chapter_data->preference_id);
+  $preference_data = db_fetch_object($preference_q);
+  if (!$preference_data)
+  {
+    drupal_set_message(t("Invalid book selected."), 'error');
+    drupal_goto('');
+    return;
+  }
+
+  /* get proposal details */
+  $proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = %d", $preference_data->proposal_id);
+  $proposal_data = db_fetch_object($proposal_q);
+  if (!$proposal_data)
+  {
+    drupal_set_message(t("Invalid proposal selected."), 'error');
+    drupal_goto('');
+    return;
+  }
+  $user_data = user_load($proposal_data->uid);
+
+  /* creating directories */
+  $root_path = textbook_companion_path();
+
+  $dest_path = $preference_data->id . '/';
+  if (!is_dir($root_path . $dest_path))
+    mkdir($root_path . $dest_path);
+
+  $dest_path .= 'CH' . $chapter_data->number . '/';
+  if (!is_dir($root_path . $dest_path))
+    mkdir($root_path . $dest_path);
+
+  $dest_path .= 'EX' . $example_data->number . '/';
+  if (!is_dir($root_path . $dest_path))
+    mkdir($root_path . $dest_path);
+
+  /* updating example caption */
+  db_query("UPDATE {textbook_companion_example} SET caption = '%s' WHERE id = %d", $form_state['values']['example_caption'], $example_id);
+
+  /* handling dependencies */
+  db_query("DELETE FROM {textbook_companion_example_dependency} WHERE example_id = %d", $example_data->id);
+  foreach ($form_state['values']['existing_depfile']['dep_chapter_example_files'] as $row)
+  {
+    if ($row > 0)
+    {
+      /* insterting into database */
+      db_query("INSERT INTO {textbook_companion_example_dependency} (example_id, dependency_id, approval_status, timestamp)
+        VALUES (%d, %d, %d, %d)",
+        $example_data->id,
+        $row,
+        0,
+        time()
+      );
+    }
+  }
+
+  /* handle source file */
+  $cur_file_id = $form_state['values']['cur_source_file_id'];
+  if ($cur_file_id > 0)
+  {
+    $file_q = db_query("SELECT * FROM  {textbook_companion_example_files} WHERE id = %d AND example_id = %d", $cur_file_id, $example_data->id);
+    $file_data = db_fetch_object($file_q);
+    if (!$file_data)
+    {
+        drupal_set_message("Error deleting example source file. File not present in database.", 'error');
+        return;
+    }
+    if (($form_state['values']['cur_source_checkbox'] == 1) && (!$_FILES['files']['name']['sourcefile1']))
+    {
+      if (!delete_file($cur_file_id))
+      {
+        drupal_set_message("Error deleting example source file.", 'error');
+        return;
+      }
+    }
+  }
+  if ($_FILES['files']['name']['sourcefile1'])
+  {
+    if ($cur_file_id > 0)
+    {
+      if (!delete_file($cur_file_id))
+      {
+        drupal_set_message("Error removing previous example source file.", 'error');
+        return;
+      }
+    }
+    if (file_exists($root_path . $dest_path . $_FILES['files']['name']['sourcefile1']))
+    {
+      drupal_set_message(t("Error uploading source file. File !filename already exists.", array('!filename' => $_FILES['files']['name']['sourcefile1'])), 'error');
+      return;
+    }
+    /* uploading file */
+    if (move_uploaded_file($_FILES['files']['tmp_name']['sourcefile1'], $root_path . $dest_path . $_FILES['files']['name']['sourcefile1']))
+    {
+      /* for uploaded files making an entry in the database */
+      db_query("INSERT INTO {textbook_companion_example_files} (example_id, filename, filepath, filemime, filesize, filetype, timestamp)
+        VALUES (%d, '%s', '%s', '%s', %d, '%s', %d)",
+        $example_data->id,
+        $_FILES['files']['name']['sourcefile1'],
+        $dest_path . $_FILES['files']['name']['sourcefile1'],
+        $_FILES['files']['type']['sourcefile1'],
+        $_FILES['files']['size']['sourcefile1'],
+        'S',
+        time()
+        );
+      drupal_set_message($_FILES['files']['name']['sourcefile1'] . ' uploaded successfully.', 'status');
+    } else {
+      drupal_set_message('Error uploading file : ' . $dest_path . '/' . $_FILES['files']['name']['sourcefile1'], 'error');
+    }
+  }
+
+  /* handle result1 file */
+  $cur_file_id = $form_state['values']['cur_result1_file_id'];
+  if ($cur_file_id > 0)
+  {
+    $file_q = db_query("SELECT * FROM  {textbook_companion_example_files} WHERE id = %d AND example_id = %d", $cur_file_id, $example_data->id);
+    $file_data = db_fetch_object($file_q);
+    if (!$file_data)
+    {
+        drupal_set_message("Error deleting example result 1 file. File not present in database.", 'error');
+        return;
+    }
+    if (($form_state['values']['cur_result1_checkbox'] == 1) && (!$_FILES['files']['name']['result1']))
+    {
+      if (!delete_file($cur_file_id))
+      {
+        drupal_set_message("Error deleting example result 1 file.", 'error');
+        return;
+      }
+    }
+  }
+  if ($_FILES['files']['name']['result1'])
+  {
+    if ($cur_file_id > 0)
+    {
+      if (!delete_file($cur_file_id))
+      {
+        drupal_set_message("Error removing previous example result 1 file.", 'error');
+        return;
+      }
+    }
+    if (file_exists($root_path . $dest_path . $_FILES['files']['name']['result1']))
+    {
+      drupal_set_message(t("Error uploading result 1 file. File !filename already exists.", array('!filename' => $_FILES['files']['name']['result1'])), 'error');
+      return;
+    }
+    /* uploading file */
+    if (move_uploaded_file($_FILES['files']['tmp_name']['result1'], $root_path . $dest_path . $_FILES['files']['name']['result1']))
+    {
+      /* for uploaded files making an entry in the database */
+      db_query("INSERT INTO {textbook_companion_example_files} (example_id, filename, filepath, filemime, filesize, filetype, timestamp)
+        VALUES (%d, '%s', '%s', '%s', %d, '%s', %d)",
+        $example_data->id,
+        $_FILES['files']['name']['result1'],
+        $dest_path . $_FILES['files']['name']['result1'],
+        $_FILES['files']['type']['result1'],
+        $_FILES['files']['size']['result1'],
+        'R',
+        time()
+        );
+      drupal_set_message($_FILES['files']['name']['result1'] . ' uploaded successfully.', 'status');
+    } else {
+      drupal_set_message('Error uploading file : ' . $dest_path . '/' . $_FILES['files']['name']['result1'], 'error');
+    }
+  }
+
+  /* handle result2 file */
+  $cur_file_id = $form_state['values']['cur_result2_file_id'];
+  if ($cur_file_id > 0)
+  {
+    $file_q = db_query("SELECT * FROM  {textbook_companion_example_files} WHERE id = %d AND example_id = %d", $cur_file_id, $example_data->id);
+    $file_data = db_fetch_object($file_q);
+    if (!$file_data)
+    {
+        drupal_set_message("Error deleting example result 2 file. File not present in database.", 'error');
+        return;
+    }
+    if (($form_state['values']['cur_result2_checkbox'] == 1) && (!$_FILES['files']['name']['result2']))
+    {
+      if (!delete_file($cur_file_id))
+      {
+        drupal_set_message("Error deleting example result 2 file.", 'error');
+        return;
+      }
+    }
+  }
+  if ($_FILES['files']['name']['result2'])
+  {
+    if ($cur_file_id > 0)
+    {
+      if (!delete_file($cur_file_id))
+      {
+        drupal_set_message("Error removing previous example result 2 file.", 'error');
+        return;
+      }
+    }
+    if (file_exists($root_path . $dest_path . $_FILES['files']['name']['result2']))
+    {
+      drupal_set_message(t("Error uploading result 2 file. File !filename already exists.", array('!filename' => $_FILES['files']['name']['result2'])), 'error');
+      return;
+    }
+    /* uploading file */
+    if (move_uploaded_file($_FILES['files']['tmp_name']['result2'], $root_path . $dest_path . $_FILES['files']['name']['result2']))
+    {
+      /* for uploaded files making an entry in the database */
+      db_query("INSERT INTO {textbook_companion_example_files} (example_id, filename, filepath, filemime, filesize, filetype, timestamp)
+        VALUES (%d, '%s', '%s', '%s', %d, '%s', %d)",
+        $example_data->id,
+        $_FILES['files']['name']['result2'],
+        $dest_path . $_FILES['files']['name']['result2'],
+        $_FILES['files']['type']['result2'],
+        $_FILES['files']['size']['result2'],
+        'R',
+        time()
+        );
+      drupal_set_message($_FILES['files']['name']['result2'] . ' uploaded successfully.', 'status');
+    } else {
+      drupal_set_message('Error uploading file : ' . $dest_path . '/' . $_FILES['files']['name']['result2'], 'error');
+    }
+  }
+
+  /* handle xcos1 file */
+  $cur_file_id = $form_state['values']['cur_xcos1_file_id'];
+  if ($cur_file_id > 0)
+  {
+    $file_q = db_query("SELECT * FROM  {textbook_companion_example_files} WHERE id = %d AND example_id = %d", $cur_file_id, $example_data->id);
+    $file_data = db_fetch_object($file_q);
+    if (!$file_data)
+    {
+        drupal_set_message("Error deleting example xcos 1 file. File not present in database.", 'error');
+        return;
+    }
+    if (($form_state['values']['cur_xcos1_checkbox'] == 1) && (!$_FILES['files']['name']['xcos1']))
+    {
+      if (!delete_file($cur_file_id))
+      {
+        drupal_set_message("Error deleting example xcos 1 file.", 'error');
+        return;
+      }
+    }
+  }
+  if ($_FILES['files']['name']['xcos1'])
+  {
+    if ($cur_file_id > 0)
+    {
+      if (!delete_file($cur_file_id))
+      {
+        drupal_set_message("Error removing previous example xcos 1 file.", 'error');
+        return;
+      }
+    }
+    if (file_exists($root_path . $dest_path . $_FILES['files']['name']['xcos1']))
+    {
+      drupal_set_message(t("Error uploading xcos 1 file. File !filename already exists.", array('!filename' => $_FILES['files']['name']['xcos1'])), 'error');
+      return;
+    }
+    /* uploading file */
+    if (move_uploaded_file($_FILES['files']['tmp_name']['xcos1'], $root_path . $dest_path . $_FILES['files']['name']['xcos1']))
+    {
+      /* for uploaded files making an entry in the database */
+      db_query("INSERT INTO {textbook_companion_example_files} (example_id, filename, filepath, filemime, filesize, filetype, timestamp)
+        VALUES (%d, '%s', '%s', '%s', %d, '%s', %d)",
+        $example_data->id,
+        $_FILES['files']['name']['xcos1'],
+        $dest_path . $_FILES['files']['name']['xcos1'],
+        $_FILES['files']['type']['xcos1'],
+        $_FILES['files']['size']['xcos1'],
+        'X',
+        time()
+        );
+      drupal_set_message($_FILES['files']['name']['xcos1'] . ' uploaded successfully.', 'status');
+    } else {
+      drupal_set_message('Error uploading file : ' . $dest_path . '/' . $_FILES['files']['name']['xcos1'], 'error');
+    }
+  }
+
+  /* handle xcos2 file */
+  $cur_file_id = $form_state['values']['cur_xcos2_file_id'];
+  if ($cur_file_id > 0)
+  {
+    $file_q = db_query("SELECT * FROM  {textbook_companion_example_files} WHERE id = %d AND example_id = %d", $cur_file_id, $example_data->id);
+    $file_data = db_fetch_object($file_q);
+    if (!$file_data)
+    {
+        drupal_set_message("Error deleting example xcos 2 file. File not present in database.", 'error');
+        return;
+    }
+    if (($form_state['values']['cur_xcos2_checkbox'] == 1) && (!$_FILES['files']['name']['xcos2']))
+    {
+      if (!delete_file($cur_file_id))
+      {
+        drupal_set_message("Error deleting example xcos 2 file.", 'error');
+        return;
+      }
+    }
+  }
+  if ($_FILES['files']['name']['xcos2'])
+  {
+    if ($cur_file_id > 0)
+    {
+      if (!delete_file($cur_file_id))
+      {
+        drupal_set_message("Error removing previous example xcos 2 file.", 'error');
+        return;
+      }
+    }
+    if (file_exists($root_path . $dest_path . $_FILES['files']['name']['xcos2']))
+    {
+      drupal_set_message(t("Error uploading xcos 2 file. File !filename already exists.", array('!filename' => $_FILES['files']['name']['xcos2'])), 'error');
+      return;
+    }
+    /* uploading file */
+    if (move_uploaded_file($_FILES['files']['tmp_name']['xcos2'], $root_path . $dest_path . $_FILES['files']['name']['xcos2']))
+    {
+      /* for uploaded files making an entry in the database */
+      db_query("INSERT INTO {textbook_companion_example_files} (example_id, filename, filepath, filemime, filesize, filetype, timestamp)
+        VALUES (%d, '%s', '%s', '%s', %d, '%s', %d)",
+        $example_data->id,
+        $_FILES['files']['name']['xcos2'],
+        $dest_path . $_FILES['files']['name']['xcos2'],
+        $_FILES['files']['type']['xcos2'],
+        $_FILES['files']['size']['xcos2'],
+        'X',
+        time()
+        );
+      drupal_set_message($_FILES['files']['name']['xcos2'] . ' uploaded successfully.', 'status');
+    } else {
+      drupal_set_message('Error uploading file : ' . $dest_path . '/' . $_FILES['files']['name']['xcos2'], 'error');
+    }
+  }
+
+  /* sending email */
+  $email_to = $user_data->mail;
+  $param['example_updated_admin']['example_id'] = $example_id;
+  $param['example_updated_admin']['user_id'] = $proposal_data->uid;
+  if (!drupal_mail('textbook_companion', 'example_updated_admin', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
+    drupal_set_message('Error sending email message.', 'error');
+
+  drupal_set_message(t("Example successfully udpated."), 'status');
+}
+
+/******************************************************************************/
+/************************** GENERAL FUNCTIONS *********************************/
+/******************************************************************************/
+
+function _list_of_book_titles()
+{
+  $book_titles = array('0' => 'Please select...');
+  $book_titles_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status = 1 OR approval_status = 3 ORDER BY book ASC");
+  while ($book_titles_data = db_fetch_object($book_titles_q))
+  {
+    $book_titles[$book_titles_data->id] = $book_titles_data->book . ' (Written by ' . $book_titles_data->author . ')';
+  }
+  return $book_titles;
+}
+
+function _list_of_book_dependency_files()
+{
+  $book_dependency_files = array();
+  $book_dependency_files_class = array();
+  $book_dependency_files_q = db_query("SELECT * FROM {textbook_companion_dependency_files} ORDER BY filename ASC");
+
+  while ($book_dependency_files_data = db_fetch_object($book_dependency_files_q))
+  {
+    $temp_caption = '';
+    if ($book_dependency_files_data->caption)
+      $temp_caption .= ' (' . $book_dependency_files_data->caption . ')';
+    $book_dependency_files[$book_dependency_files_data->id] = l($book_dependency_files_data->filename . $temp_caption, 'download/dependency/' . $book_dependency_files_data->id);
+    $book_dependency_files_class[$book_dependency_files_data->id] = $book_dependency_files_data->preference_id;
+  }
+  return array($book_dependency_files, $book_dependency_files_class);
+}
+