$course_code = $row_course_src['course_code'];
$course_title = $row_course_src['course_title'];
insert_course($dest_db_con, $course_code, $course_title);
$count++;
}
echo "Copy course success :: {$count} entries<br>";
$count = 0;
#Copy block data
$query_block_src = mysqli_query($src_db_con, "SELECT * FROM student_block_t") or die("Error in save_content.php : line 5 :: " . mysql_error($src_db_con));
while ($row_block_src = mysqli_fetch_array($query_block_src)) {
$block_id = $row_block_src['block_id'];
$block_name = $row_block_src['block_name'];
$course_code = $row_block_src['course_code'];
$year_level = $row_block_src['year_level'];
$sem_id = $row_block_src['sem_id'];
insert_block($dest_db_con, $course_code, $year_level, $block_name, $sem_id);
$count++;
}
echo "Copy block success :: {$count} entries<br>";
$count = 0;
#Copy Student data
$query_student_src = mysqli_query($src_db_con, "SELECT * FROM student_t") or die("Error in save_content.php : line 5 :: " . mysql_error($src_db_con));
while ($row_student_src = mysqli_fetch_array($query_student_src)) {
$student_id = $row_student_src['student_id'];
$f_name = $row_student_src['f_name'];
$m_name = $row_student_src['m_name'];
$l_name = $row_student_src['l_name'];
$gender = $row_student_src['gender'];
$birthdate = $row_student_src['birthdate'];
$address = $row_student_src['address'];
$status = $row_student_src['status'];
response(__('No block has been specified!', 'rmcommon'), array(), 1, 1);
}
$block = new RMInternalBlock($block_id);
if ($block->isNew()) {
response(__('Specified block does not exists!', 'rmcommon'), array(), 1, 1);
}
if (!$block->delete()) {
response(sprintf(__('The block "%s" could not be deleted!', 'rmcommon'), $block->getVar('name')), array('error' => $block->errors()), 1, 1);
} else {
response(sprintf(__('The block "%s" was deleted successfully!', 'rmcommon'), $block->getVar('name')), array(), 0, 1);
}
}
$action = rmc_server_var($_POST, 'action', '');
switch ($action) {
case 'insert':
insert_block();
break;
case 'settings':
configure_block();
break;
case 'saveconfig':
save_block_config();
break;
case 'savepos':
save_block_position();
break;
case 'save-orders':
save_block_order();
break;
case 'show-block':
change_block_visibility(1);
}
$isEntry = false;
$block = preg_replace("/\\([^)]+\\)/", "", $block);
//$subject_title = preg_replace("/\([^)]+\)/","",$subject_title);
preg_match('#\\((.*?)\\)#', $subject_title, $match);
if (count($match) > 0) {
$str = trim($match[1]);
if (is_numeric(stripos($str, "lec")) || is_numeric(stripos($str, "lab"))) {
$subject_title = preg_replace("/\\([^)]+\\)/", "", $subject_title);
}
}
//echo $subject_title."<br>";
$faculty_id = verify_faculty_id($temp_db_con, $faculty_id);
//$block_id = get_block_id($temp_db_con, $course, get_year_level($block),$course." ".$block, $sem_id);
$course_code = insert_course($temp_db_con, $course, '');
$block_id = insert_block($temp_db_con, $course_code, get_year_level($block), $course . " " . $block, $sem_id);
//$faculty_id = get_faculty_id($temp_db_con, $faculty);
//$year_level = get_year_level($block);
$block_name = $block;
$subject_id = insert_subject($temp_db_con, $subject_code, $subject_title, $credit_units, $lec_units, $lab_units);
//$room_code = insert_room($temp_db_con, $room, NULL, NULL);
//$subject_title = preg_replace("/\([^)]+\)/","",$subject_title);
//echo $subject_title."<br> ";
#check for existing entry with id no.
if (true || $faculty_id != "") {
//echo $sem_id."<br>";
$class_id = insert_class($temp_db_con, $subject_id, $faculty_id, $block_id, $sem_id);
//echo "class_id = $class_id ";
$schedule_id = insert_schedule_entries($temp_db_con, $class_id, $day, $time, $room);
}
}
