function delete_semester($id)
{
/*$user = $this->session->userdata("isLoggedIn");
$sem = $this->common_model->query("SELECT semester FROM semesters WHERE semesters.id = ".$id."")->row();
$sem = slug($sem->semester);
$user->user_type;
$dir = "./uploads/".strtolower($user->type_name).'/'.$user->user_name.'/'.$sem;
array_walk(glob($dir . '/*'), function ($fn) {
if (is_file($fn))
chown($fn,0777);
unlink($fn);
});
chown($dir,0777);
unlink($dir);
exit;
$documents = $this->common_model->query("SELECT documents.subject_id FROM documents WHERE documents.semester_id = ".$id." GROUP BY documents.subject_id");
if($document->num_rows()>0){
foreach($document->result() as $doc){
$documents = $this->common_model->query("SELECT documents.subject_id FROM documents WHERE documents.subject_id = ".$doc->subject_id."");
}
}
$document = $this->common_model->query("SELECT * FROM documents WHERE documents.semester_id = ".$id."");
if($document->num_rows()>0){
foreach($document->result() as $row){
$path = './uploads/'.$row->doc_paths.'/'.$row->uploaded_filename;
if(file_exists($path)){
unlink($path);
}
$this->common_model->delete("id",$id,"documents");
}
}
$document = $document->row();
$dir = './uploads/'.$document->doc_paths.'/';
if(is_dir($dir)){
rmdir($dir);
}
exit;
$this->common_model->delete("id",$id,"subjects");
$this->session->set_flashdata("error","Record Deleted...");
redirect(site_url("semesters_subjects"));
*/
if (check_delete("subjects", "semester_id", $id) == TRUE) {
$this->session->set_flashdata("error", "This semester have multiple subjects so you cannot delete this semester.");
redirect(site_url("semesters_subjects"));
} else {
$this->common_model->delete("id", $id, "semesters");
$this->session->set_flashdata("error", "Record Deleted...");
redirect(site_url("semesters_subjects"));
}
}
$category_child = $category_relation_array["category_child"];
mysql_query("DELETE FROM tbl_tag_relation WHERE category_parent = '{$category_child}'", $conn);
mysql_query("DELETE FROM tbl_tag WHERE category_id = '{$category_child}'", $conn);
}
}
mysql_query("DELETE FROM tbl_tag_relation WHERE category_child = '{$category_id}' OR category_parent = '{$category_id}'", $conn);
}
//END CHECK
$_SESSION['alert'] = "success";
$_SESSION['msg'] = "Item(s) has been successfully deleted.";
} else {
if ($_POST['btn-index-category'] == "GO") {
if ($_POST['category-action'] == "delete" || $_POST['category-option'] == "yes") {
foreach ($_POST['category_id'] as $category_id) {
// CALL FUNCTION
$check_delete = check_delete($category_id);
$category_check_name = check_delete_get_category_name($category_id);
$validate_delete = getTotal($category_id);
if ($validate_delete['total_product'] > 0) {
$_SESSION['alert'] = "error";
$_SESSION['msg'] = "Can't delete because it contains one or more items.";
} else {
mysql_query("DELETE FROM tbl_tag WHERE category_id = '{$category_id}'", $conn);
$_SESSION['alert'] = "success";
$_SESSION['msg'] = "Item(s) has been successfully deleted.";
}
}
}
}
}
}
$prof[$rep] = $val;
}
if ($_POST['profile_id'] == '') {
$_POST['profile_id'] = get_post('name');
}
update_printer_profile($_POST['profile_id'], $prof);
if ($selected_id == '') {
display_notification_centered(_('New printing profile has been created'));
clear_form();
} else {
display_notification_centered(_('Printing profile has been updated'));
}
}
}
if (get_post('delete')) {
if (!check_delete(get_post('name'))) {
delete_printer_profile($selected_id);
display_notification(_('Selected printing profile has been deleted'));
clear_form();
}
}
if (get_post('_profile_id_update')) {
$Ajax->activate('_page_body');
}
start_form();
start_table();
print_profiles_list_row(_('Select printing profile') . ':', 'profile_id', null, _('New printing profile'), true);
end_table();
echo '<hr>';
start_table();
if (get_post('profile_id') == '') {
function update_history_function()
{
global $adminflag, $submit, $conn, $db, $rr_table, $rrh_table, $viewselect;
global $cname, $class, $order, $lastlooted, $firstpass, $secondpass, $added;
global $todelete, $editmode;
global $secondpass, $lootname, $loottype, $dkppaid, $dateawarded;
/* DEBUG
for($r=0;$r<count($cname);$r++)
{
echo" Line $r is : ";
$delete=check_delete($r,$todelete);
if(!$delete){
echo $cname[$r]." ";
echo $order[$r]." ";
echo $lastlooted[$r]." ";
echo $secondpass[$r]." ";
echo $added[$r]."<br> ";
}
else echo $cname[$r]." deleted.<br>\n";
} */
/* Update to delete all entries for the viewselect (class) and then re-add the information. */
/* all info required therefore, cnames classes added also.. delete flag */
$query = "DELETE FROM {$rrh_table} WHERE class='{$viewselect}'";
// echo"$query<br>\n";
$result = mysql_query($query, $conn);
for ($r = 0; $r < count($cname); $r++) {
$delete = check_delete($r, $todelete);
if (!$delete) {
$query = "INSERT INTO {$rrh_table} VALUES ('{$cname[$r]}','{$viewselect}','{$lootname[$r]}','{$loottype[$r]}','" . nztousdate($dateawarded[$r]) . "','{$dkppaid[$r]}')";
// echo"$query<br>\n";
$result = mysql_query($query, $conn);
}
}
echo "<center><br /><br /><br /><br / ><br /><p>History records updated... Returning to {$viewselect} history...</p></center>";
echo "<meta HTTP-EQUIV='Refresh' CONTENT='1;URL=index.php?submit=history&viewselect={$viewselect}'>";
exit;
}
