// if(current_user_can('administrator') || current_user_can('editor'))
{ include "connect.php";
// $login=$_GET['login'];
// $act=$_GET['act'];
// $course=$_GET['course'];
/* if(!isset($login)){
$user = wp_get_current_user();
$login=$user->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 ‘
}
echo ‘
echo ‘
getCourseList($link,0);
echo ‘
echo ‘
echo ‘
getCourseList($link,1);
echo ‘
echo ‘
echo ‘
getCourseList($link,2);
echo ‘
echo ‘
}
?>
