| ".(($dir =="0")?"تسجيل الخروج " :"L o g o u t")." | ||||
| ";
$qtopic=@mysql_query("SELECT `td_topics`.`topics_id`,`td_topics`.`topics_name`,
`td_topics`.`step_id`,`td_step`.`step_name`,`td_topics`.`class_id`,
`td_class`.`class_name`
FROM `td_topics`
Inner Join `td_class` ON `td_topics`.`class_id` = `td_class`.`class_id`
Inner Join `td_step` ON `td_topics`.`step_id` = `td_step`.`step_id`
where `td_topics`.`class_id` ='$class' AND `part`='$part' AND `active` ='1' ORDER BY `arrange`,`topics_id` ");
$num=@mysql_num_rows($qtopic);
if($num > 0){
$i=1;
while($rtopic=@mysql_fetch_array($qtopic))
{
$info=" {$rtopic[step_name]} \t >> \t{$rtopic[class_name]} \t \t \t \t \t \t \t \t".(($dir =="0")?"الإمـتـحان \t ":"Exam \t")." \t: \t {$r[test_name]}\t \t ";
$qu=@mysql_query("SELECT `history`.`h_id`,`history`.`user_id`,
`history`.`test_id`,`history`.`exam_degree`,`td_test`.`test_success`
FROM `history`
Inner Join `td_test` ON `history`.`test_id` = `td_test`.`test_id` where `user_id`='".$_SESSION[user_id]."' AND ( `history`.`test_id`='".$r[test_id]."')");
$ru=@mysql_fetch_array($qu);
if(($ru[test_id]==$r[test_id])&&($ru[exam_degree] < $ru[test_success]))
{
$topics .=" ";
}
$i++;
}
$output .=$info.$topics;
}else
{
$output .=" ";
}elseif(($ru[test_id]==$r[test_id])&&($ru[exam_degree] >= $ru[test_success]))
{
$topics .=" ";
}
$topics .="".(($dir =="0")?"نأسف لا يمكنك الالتحاق بالاختبارات فى هذا الصف الان لعدم اضافتة وحداته بعد":"Sorry you can not enter the test related to this class now")." ";
} }
//topics
function topics()
{
global $dir , $output ,$step , $class , $part ;
$output .=" | ||||
| "; $qu1=@mysql_query("SELECT `td_topics`.`topics_id`,`td_topics`.`atype`,`td_topics`.`topics_name`,`td_topics`.`topics_title`, `td_topics`.`step_id`,`td_step`.`step_name`,`td_topics`.`class_id`,`td_class`.`class_name` FROM `td_step` Inner Join `td_topics` ON `td_topics`.`step_id` = `td_step`.`step_id` Inner Join `td_class` ON `td_topics`.`class_id` = `td_class`.`class_id` WHERE `td_topics`.`topics_id`='".$_REQUEST['id']."' ")or die(mysql_error()); $rqu=mysql_fetch_array($qu1); $output .= " | ||||
{$rqu[step_name]} \t >> \t{$rqu[class_name]} \t >> \t{$rqu[topics_name]} | ||||
".(($dir=="0")?"عـفــوا لا يـوجد ملف مضاف الى هذه الوحدة":"Sorry this topics no contain Any File")." | ||||
| {$rqu[topics_title]} | ||||
".(($dir=="0")?" يمكنك خـوض إمتحانات هذه الوحدة من":"you can Enter Exam following this topics")." ".(($dir=="")?"هـنــا":"HER")." | ||||
"; $qu=@mysql_query("select * from `history` where `user_id`='".$_SESSION[user_id]."' "); if(@mysql_num_rows($qu) > 0) { while($ru=mysql_fetch_array($qu)) { $do_test.= $ru['test_id'].","; } } $part[1]="".(($dir=="0")?"الفصل الدراسى الاول":"First Term").""; $part[2]="".(($dir=="0")?"الفصل الدراسى الثانى":"Second Term").""; $topics=intval($_REQUEST['id']); $qtopic=@mysql_query("SELECT `td_topics`.`topics_id`, `td_topics`.`topics_name`, `td_topics`.`topics_title`, `td_topics`.`step_id`, `td_topics`.`class_id`, `td_topics`.`part`, `td_class`.`class_name`, `td_step`.`step_name` FROM `td_topics` Inner Join `td_step` ON `td_topics`.`step_id` = `td_step`.`step_id` Inner Join `td_class` ON `td_topics`.`class_id` = `td_class`.`class_id` where `topics_id`='$topics' "); $rtopic=@mysql_fetch_array($qtopic); $nq="SELECT `td_test`.`test_id`,`td_test`.`topics_id`, `td_test`.`test_name`, `td_test`.`active` FROM `td_test` WHERE `topics_id`='$topics' AND `active`='1' "; $do_test =explode(",",$do_test); foreach($do_test as $value){ if($value !="") { $nw.="AND ( `td_test`.`test_id` <> '$value' ) "; } } $nq=$nq.$nw; $qtest=@mysql_query($nq)or die(mysql_error()); if(@mysql_num_rows($qtest) > 0) { $output .=" ".(($dir=="0")?"إختبار":"test")."\t ".$rtopic['topics_name']."\t\t >>\t ".$part[$rtopic['part']]."\t\t>>\t".$rtopic['class_name']."\t\t>>\t".$rtopic['step_name']." "; $i=1; while($rtest=mysql_fetch_array($qtest)){ $output .="\t $i \t -\t ".(($dir =="0")?"عـنـوان الإختبار":"Address Test")."\t :\t {$rtest[test_name]} "; $i++; } }else { $output .=" | ||||
".(($dir =="0")?"عــفــواً لا توجد أمتحانات جديدة":"Sorry No New Exam ")." | ||||
"; $test=intval($_REQUEST['test']); $qht=@mysql_query("SELECT `history`.`h_id`,`history`.`user_id`,`history`.`test_id` FROM `history` WHERE `test_id`='$test' AND `user_id`='".$_SESSION[user_id]."' "); $nt=@mysql_num_rows($qht); if($nt > 0) { $output .=" | ||||
| {$rr[question]} "; $qans=mysql_query("SELECT `td_answer`.`answer_id`,`td_answer`.`answer_title`,`td_answer`.`question_id` FROM `td_answer` where `question_id`='$rr[question_id]' "); $output .= " "; while($rans=mysql_fetch_array($qans)) { $output .= "{$rans[answer_title]} "; } $suresult=$rr['test_success']; $fresult =$rr['test_degree']; $result+=0; $qright=mysql_query("select * from `td_question` where `rightanswer`='$answer' and `question_id`='$question' "); if($nm=mysql_num_rows($qright) > 0) { $rq=mysql_fetch_array($qright); $result +=$rq['question_degree']; $topic=$rr['topics_id']; $output .= " ".(($dir=="0")?"الاجابة صحيحة":"The Right Answer")." \t( )\t \t \t \t | ||||
| ".(($dir=="0")?"مجموع الــدرجات التى حصلت عليها عن هذا الامتحان هى ":"Your Degree Get in the Exam")." \t : \t".$result." / ".$fresult." | ||||
| ".(($dir=="0")?"تــهـانينا لقد حصل على درجة النجاح فى هذه الوحدة":"congratulations You Get on sucessed degree this unit ")."\t \t".(($dir=="0")?"العودة إلى صفحة الأختبارات":"Back to Exams page")." \t | \t"; if (($testid !="")&&($testid !="0")) { $output .="".(($dir=="0")?"الأخـتـبار الـتـالـى":" Next Exam ")." | ||||
| ".(($dir=="0")?"عــفـوا لـم تتمكن من الحصول على درجة النجاح ":"Sorry you can't get on sucessed degree to this unit")."".(($dir=="0")?"الامتحان الملحق":" Exam Failed ")." | ||||
| ".$rts['test_name']." | ".$rts['topics_name']." | ".$part[$rts['part']]." | ".$rts['class_name']." | ".$rts['step_name']." |