ЗАХІДНОУКРАЇНСЬКА ШКОЛА АВІАЦІЇ


user_login;
}

$sql=”SELECT * FROM wpdn_users WHERE user_login=’$login'”;
$result = mysql_query($sql);
while($dt = mysql_fetch_array($result))
{ $r1=$dt[‘user_lastname’];
$r2=$dt[‘user_name’];
$r3=$dt[‘user_middlename’];
}
$str=sprintf(“
Для пользователя: %s %s %s
“,$r1,$r2,$r3); echo $str;

if($act==’add’) //Добавить дисциплину
{ $courseres = mysql_query(“SELECT id FROM courselist WHERE (user_login=’$login’ AND course_id=’$course’)”);
$n=mysql_num_rows($courseres);
if($n==0)
{ $topic=@mysql_result(mysql_query(“SELECT topic FROM wpdn_mtouchquiz_quiz WHERE ID_KOD=’$course'”),0);
$sql=”INSERT INTO courselist SET user_login=’$login’, course_id=’$course’, topicname=’$topic'”;
mysql_query($sql);
}
}
if($act==’del’) // Удалить дисциплину
{ $sql=”DELETE FROM courselist WHERE (user_login=’$login’ AND course_id=’$course’)”;
mysql_query($sql);
}
*/
//——————————————————————–
function getCourseList($link,$isIR)
{
if($isIR==0) $allcourse = mysqli_query($link,”SELECT * FROM wpdn_mtouchquiz_quiz WHERE (isIr=0 OR isIr=1) ORDER BY topic,name”);
if($isIR==1) $allcourse = mysqli_query($link,”SELECT * FROM wpdn_mtouchquiz_quiz WHERE (isIr=1 OR isIR=2) ORDER BY topic,name”);
if($isIR==2) $allcourse = mysqli_query($link,”SELECT * FROM wpdn_mtouchquiz_quiz WHERE isIR=3 ORDER BY topic,name”);
$cur_topic=””;
$i=1;

while($data = mysqli_fetch_array($allcourse))
{ $name=$data[‘name’];
$topic=$data[‘Topic’];
$id_kod=$data[‘ID_KOD’];
$content=$data[‘Content’];

if($topic!=$cur_topic)
{ if($i>1) { echo ‘

‘; echo ‘[/su_spoiler]‘;}
echo ‘

'.$topic.'
‘;
echo ‘

‘;

}
$ncont=0;
//——–
$lines = explode(“\n”, $content);

for ($ii = 0; $ii < count($lines); $ii++) { if(strlen($lines[$ii])!=0) { $parts = parse_url($lines[$ii]); parse_str($parts['query'], $query); $tp=intval($query['tp']); if($tp!=0) { $ncont++; } } } //-------- $nquest=$data['time_limit']/60; echo '

‘;

$cur_topic=$topic;
$i++;

}
echo ‘

№
Назва дисципліни
Конспект
Всього питань
Питань на іспиті
‘.$i.’. ‘.$name.’ ‘.$ncont.’ ‘.$nquest.’ ‘.$data[‘Quest_limit’].’

‘;
echo ‘

‘;

}
echo ‘

CPLCPL (IR)PPL
‘;
echo ‘
‘;
getCourseList($link,0);
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
getCourseList($link,1);
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
getCourseList($link,2);
echo ‘
‘;
echo ‘
‘;
}
?>