Peer review (16) add email and oline mode cesei_review_new

Add archive_method in table cesei_review_new (for email, member_id=0)
ALTER TABLE `cesei_new1`.`cesei_review_new` ADD `archive_method` mediumint(8) unsigned NOT NULL default '0'; 
ALTER TABLE `cesei_new1`.`cesei_review_new` ADD `member_id` mediumint(8) unsigned NOT NULL default '0';
modify C:\Users\jiansen\Desktop\CAS\jiansen_dir\www_cesei0_mobile\admin\edu\add_review.php
C:\Users\jiansen\Desktop\CAS\jiansen_dir\www_cesei0_mobile\_lib\peer_review_tools.inc.php
add hide column for cesei_module_user_reviews_p
ALTER TABLE `cesei_new1`.`cesei_module_user_reviews_p` ADD `hide` mediumint(8) unsigned NOT NULL default '0'; 
or
DROP TABLE IF EXISTS `cesei_new1`.`cesei_module_user_reviews_p`;
CREATE TABLE  `cesei_new1`.`cesei_module_user_reviews_p` (
  `review_id` mediumint(8) unsigned NOT NULL auto_increment,
  `member_id` mediumint(8) unsigned NOT NULL,
  `module_id` mediumint(8) unsigned NOT NULL,
  `revision_cycle` tinyint(3) unsigned NOT NULL default '0',
  `is_complete` tinyint(3) unsigned NOT NULL default '0',
  `date_assigned` date NOT NULL default '0000-00-00',
  `date_complete` date NOT NULL default '0000-00-00',
  `hide` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`review_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
CREATE TABLE  `cesei_new1`.`cesei_module_user_review_data_p` (
  `review_id` mediumint(8) unsigned NOT NULL,
  `outline` text NOT NULL,
  `content` text NOT NULL,
  `evaluation` text NOT NULL,
  `overall` text NOT NULL,
  `rating_outline` tinyint(3) unsigned NOT NULL default '0',
  `rating_content` tinyint(3) unsigned NOT NULL default '0',
  `rating_evaluation` tinyint(3) unsigned NOT NULL default '0',
  `rating_overall` tinyint(3) unsigned NOT NULL default '0',
  `has_simulators` tinyint(3) unsigned NOT NULL default '0',
  `simulators` text NOT NULL,
  PRIMARY KEY  (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 CREATE TABLE  `cesei_new1`.`cesei_module_user_rebuttal_data_p` (
  `review_id` mediumint(8) unsigned NOT NULL,
  `re_outline` text NOT NULL,
  `re_content` text NOT NULL,
  `re_evaluation` text NOT NULL,
  `re_overall` text NOT NULL,
  `re_simulators` text NOT NULL,
  PRIMARY KEY  (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Rename three table and create new new
DROP TABLE IF EXISTS `cesei_new1`.`cesei_module_user_reviews`;
CREATE TABLE  `cesei_new1`.`cesei_module_user_reviews` (
  `review_id` mediumint(8) unsigned NOT NULL auto_increment,
  `member_id` mediumint(8) unsigned NOT NULL,
  `module_id` mediumint(8) unsigned NOT NULL,
  `revision_cycle` tinyint(3) unsigned NOT NULL default '0',
  `is_complete` tinyint(3) unsigned NOT NULL default '0',
  `date_assigned` date NOT NULL default '0000-00-00',
  `date_complete` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`review_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
DROP TABLE IF EXISTS `cesei_new1`.`cesei_module_user_review_data`;
CREATE TABLE  `cesei_new1`.`cesei_module_user_review_data` (
  `review_id` mediumint(8) unsigned NOT NULL,
  `outline` text NOT NULL,
  `content` text NOT NULL,
  `evaluation` text NOT NULL,
  `overall` text NOT NULL,
  `rating_outline` tinyint(3) unsigned NOT NULL default '0',
  `rating_content` tinyint(3) unsigned NOT NULL default '0',
  `rating_evaluation` tinyint(3) unsigned NOT NULL default '0',
  `rating_overall` tinyint(3) unsigned NOT NULL default '0',
  `has_simulators` tinyint(3) unsigned NOT NULL default '0',
  `simulators` text NOT NULL,
  PRIMARY KEY  (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `cesei_new1`.`cesei_module_user_rebuttal_data`;
CREATE TABLE  `cesei_new1`.`cesei_module_user_rebuttal_data` (
  `review_id` mediumint(8) unsigned NOT NULL,
  `re_outline` text NOT NULL,
  `re_content` text NOT NULL,
  `re_evaluation` text NOT NULL,
  `re_overall` text NOT NULL,
  `re_simulators` text NOT NULL,
  PRIMARY KEY  (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

RENAME TABLE `cesei_new1`.`cesei_module_user_reviews`

 TO `cesei_new1`.`cesei_module_user_reviews0`;

 RENAME TABLE `cesei_new1`.`cesei_module_user_review_data` 

TO `cesei_new1`.`cesei_module_user_review_data0`;

 RENAME TABLE `cesei_new1`.`cesei_module_user_rebuttal_data` 

TO `cesei_new1`.`cesei_module_user_rebuttal_data0`;

/education/instructor_resources/module_reviews.php

line 97 change

   $rev_content .= '<div>&rsaquo; <a href="view_reviews.php?module='.

$module['course_id'].'&cycle='.($review_info['revision_cycle']).'">

Read and comment on reviews</a></div>';

to

   $rev_content .= '<div>&rsaquo; <a href="reply_reviews.php?module='.

$module['course_id'].'&cycle='.($review_info['revision_cycle']).'">

Read and comment on reviews</a></div>'; 

 copy reply_reviews.php from peer_review to /education/instructor_resources