Add Course Material
format('Y-m-d H:i:s');
//$conversationid= mt_rand();
$rs_chk = "select * from course_material where file_title = '$file_title'";
if(mysql_num_rows($rs_chk) == 0){
$query = "insert into course_material (course_id, file_title,file_name,file_type, note, status)
values ('".$_GET['course_id']."','$file_title','$file_name','$file_type','$note','$status')";
if(mysql_query($query)){
$docID = mysql_insert_id();
if($file_type=='Lectures')
{
if($status=='1'){
$checking = mysql_fetch_array(mysql_query("select *,max(lecture_no) as record from course_material where course_id='$course_id' and file_type='Lectures'"));
if($checking['record']==0)
{
$update = mysql_query("update course_material set lecture_no = '1' where course_id='$course_id' and id='$docID'");
}else{
$lecture_no = $checking['record'] +1;
$update = mysql_query("update course_material set lecture_no = '$lecture_no' where course_id='$course_id' and id='$docID'");
}
$up = mysql_query("update discussion_board set status='0' where course_id='$course_id'");
$queryi = "insert into discussion_board (course_id, lecture_id,user_id, create_date, status) Values ($course_id,'$docID','$user_id','$start_date','1')";
}else{
$checking = mysql_fetch_array(mysql_query("select *,max(lecture_no) as record from course_material where course_id='$course_id' and file_type='Lectures'"));
if($checking['record']==0)
{
$update = mysql_query("update course_material set lecture_no = '1' where course_id='$course_id' and id='$docID'");
}else{
$lecture_no = $checking['record'] +1;
$update = mysql_query("update course_material set lecture_no = '$lecture_no' where course_id='$course_id' and id='$docID'");
}
$up = mysql_query("update discussion_board set status='0' where course_id='$course_id'");
$queryi = "insert into discussion_board (course_id, lecture_id,user_id, create_date, status) values ($course_id,'$docID','$user_id','$start_date','0')";
}
}
if($status=='1') {
if(mysql_query($queryi)){
$disID = mysql_insert_id();
$update ="update discussion_board set status='0' where id !='".$disID."'";
mysql_query($update);
echo 'Discussion board created ... !
';
} }else if(mysql_query($queryi)) {
echo 'Discussion board created ... !
';
}
}
else{ echo 'File cannot be uploaded ... !
';
}
if(!is_dir('courses')){
mkdir('courses', 0777);
chmod('courses', 0777);
}
$row_c = mysql_fetch_assoc(mysql_query("select * from courses where id = '".$_GET['course_id']."'"));
$course_code = strtolower($row_c['course_code']);
if(!is_dir('courses/'.$course_code)){
mkdir('courses/'.$course_code, 0777);
chmod('courses/'.$course_code, 0777);
}
if(!is_dir('courses/'.$course_code.'/'.$file_type)){
mkdir('courses/'.$course_code.'/'.$file_type, 0777);
chmod('courses/'.$course_code.'/'.$file_type, 0777);
}
if(!is_dir('courses/'.$course_code.'/'.$file_type.'/'.$docID)){
mkdir('courses/'.$course_code.'/'.$file_type.'/'.$docID, 0777);
chmod('courses/'.$course_code.'/'.$file_type.'/'.$docID, 0777);
}
if(!empty($_FILES['file_name']['name'])){
mysql_query("update course_material set file_name = '".$_FILES['file_name']['name']."' where id = '$docID' ");
move_uploaded_file($_FILES['file_name']['tmp_name'], 'courses/'.$course_code.'/'.$file_type.'/'.$docID.'/'.$_FILES['file_name']['name']);
chmod('courses/'.$course_code.'/'.$file_type.'/'.$docID.'/'.$_FILES['file_name']['name'],0775);
}
?>