user_login;
$id=$user->ID;
$r1=$user->user_lastname;
$r2=$user->user_name;
$r3=$user->user_middlename;
$start_date=$user->start_date;
$end_date=$user->end_date;
}
else
{
// $login=$_GET[‘login’];
$sql=”SELECT * FROM wpdn_users WHERE user_login=’$login'”;
$result = mysqli_query($link,$sql);
while($dt = mysqli_fetch_array($result))
{ $id=$dt[‘ID’];
$r1=$dt[‘user_lastname’];
$r2=$dt[‘user_name’];
$r3=$dt[‘user_middlename’];
$start_date=$dt[‘start_date’];
$end_date=$dt[‘end_date’];
}
}
//———————————————————————————————
function checkContent($link,$ul,$id,$content,$res_content,&$perc)
{
$lines = explode(“\n”, $content);
$res_content=’
‘;
//$res_content=’
‘;
$tclick=0;
$nclick=0;
for ($i = 0; $i < count($lines); $i++)
{ if(strlen($lines[$i])!=0)
{ $parts = parse_url($lines[$i]);
parse_str($parts['query'], $query);
//$r=$query['r'];
$tp=intval($query['tp']);
if($tp!=0)
{ $sql="SELECT * FROM contentcheck WHERE (user_login='".$ul."' AND course_num=$id AND topic_num=$tp)";
$res = mysqli_query($link,$sql);
$nn=mysqli_num_rows($res);
if($nn==0)
{ $res_content.='
‘.$lines[$i].’
‘; }
else
{ $res_content.=’
‘.$lines[$i].’
‘;
$nclick++;
}
$tclick++;
}
else { $res_content.=’
‘.$lines[$i].’
‘; }
}
}
$res_content.=’
‘;
if($tclick!=0) $perc=($nclick*100.)/$tclick;
else $perc=100;
$t_perc=sprintf(“%3.1f”,$perc);
$res_content.=’Переглянуто матеріалу: ‘.$t_perc.’ % ‘;
return $res_content;
}
$str=sprintf(“Користувач: %s %s %s “,$r1,$r2,$r3); echo $str;
$usercourse = mysqli_query($link,”SELECT * FROM courselist WHERE user_login=’$login’ ORDER BY topicname”);
$i=1;
$admtxt=” “;
if(current_user_can(‘administrator’) || current_user_can(‘editor’))
{ $user = wp_get_current_user();
$admtxt=sprintf(“%s %s.%s.”,$user->user_lastname,mb_substr($user->user_name, 0, 1),mb_substr($user->user_middlename,0,1) );
}
//
Попытка
echo ‘
Іспит Навчання Навчальний матеріал
‘;
echo ‘
№ пп Назва дисципліни 1 2 3 ‘;
while($data = mysqli_fetch_array($usercourse))
{
$id_kod=$data[‘course_id’];
$sql=”SELECT * FROM testresults WHERE user_login=’$login’ AND testmode=’1′ AND testname=’$id_kod’ AND (DATE(dateres) >= ‘$start_date’ AND DATE(dateres) <= '$end_date') ORDER BY dateres ASC";
$results = mysqli_query($link,$sql);
$p1=""; $p2=""; $p3="";
$cr1=""; $cr2=""; $cr3="";
while($datares = mysqli_fetch_array($results))
{
$res=$datares['percent'];
if($res)
$datetxt=" ";//date("d-m-Y",strtotime($datares['dateres']));
if($p1==""){ $p1=' '.$datetxt.' '.$res.'%
if($res>=75) $cr1=”style=\”color: red;\””; }
else
{ if($p2==””)
{ $p2=’ ‘.$datetxt.’ ‘.$res.’%
if($res>=75) $cr2=”style=\”color: red;\””; }
else
{ $p3=’ ‘.$datetxt.’ ‘.$res.’%
if($res>=75) $cr3=”style=\”color: red;\””;}
}
}
echo ‘
‘.$i.’.
‘.$coursename.’ ‘.$p1.’
‘.$p2.’
‘.$p3.’
‘;
$i++;
}
echo ‘
‘;
echo ‘
‘;
$usercourse = mysqli_query($link,”SELECT * FROM courselist WHERE user_login=’$login’ ORDER BY topicname”);
$i=1;
echo ‘
№ пп Назва дисципліни 1 2 3 ‘;
while($data = mysqli_fetch_array($usercourse))
{
$id_kod=$data[‘course_id’];
$sql=”SELECT * FROM testresults WHERE user_login=’$login’ AND testmode=’0′ AND testname=’$id_kod’ AND (DATE(dateres) >= ‘$start_date’ AND DATE(dateres) <= '$end_date') ORDER BY dateres ASC";
$results = mysqli_query($link,$sql);
$p1=""; $p2=""; $p3="";
$cr1=""; $cr2=""; $cr3="";
while($datares = mysqli_fetch_array($results))
{
$res=$datares['percent'];
if($res)
$datetxt=" ";//date("d-m-Y",strtotime($datares['dateres']));
if($p1==""){ $p1=' '.$datetxt.' '.$res.'% ';
if($res>=50) $cr1=”style=\”color: blue;\””; }
else
{ if($p2==””)
{ $p2=’ ‘.$datetxt.’ ‘.$res.’%’;
if($res>=50) $cr2=”style=\”color: blue;\””; }
else
{ $p3=’ ‘.$datetxt.’ ‘.$res.’%’;
if($res>=50) $cr3=”style=\”color: blue;\””;}
}
}
$resc=mysqli_query($link,”SELECT name FROM wpdn_mtouchquiz_quiz WHERE ID_KOD='”.$id_kod.”‘ “);
echo ‘
‘.$i.’.
‘.$coursename.’ ‘.$p1.’
‘.$p2.’
‘.$p3.’
‘;
$i++;
}
echo ‘
‘;
echo ‘
‘;
$usercourse = mysqli_query($link,”SELECT * FROM courselist WHERE user_login=’$login’ ORDER BY topicname”);
$i=1;
echo ‘
№ пп Назва дисципліни % ‘;
while($data = mysqli_fetch_array($usercourse))
{
$id_kod=$data[‘course_id’];
/*
$sql=”SELECT * FROM testresults WHERE user_login=’$login’ AND testmode=’0′ AND testname=’$id_kod’ AND (dateres BETWEEN ‘$start_date’ AND ‘$end_date’ ) ORDER BY dateres ASC”;
$results = mysqli_query($link,$sql);
$p1=””; $p2=””; $p3=””;
$cr1=””; $cr2=””; $cr3=””;
while($datares = mysqli_fetch_array($results))
{
$res=$datares[‘percent’];
if($res)
$datetxt=” “;//date(“d-m-Y”,strtotime($datares[‘dateres’]));
if($p1==””){ $p1=’ ‘.$datetxt.’ ‘.$res.’% ‘;
if($res>=50) $cr1=”style=\”color: blue;\””; }
else
{ if($p2==””)
{ $p2=’ ‘.$datetxt.’ ‘.$res.’%’;
if($res>=50) $cr2=”style=\”color: blue;\””; }
else
{ $p3=’ ‘.$datetxt.’ ‘.$res.’%’;
if($res>=50) $cr3=”style=\”color: blue;\””;}
}
}
*/
$course=mysqli_query($link,”SELECT * FROM wpdn_mtouchquiz_quiz WHERE ID_KOD='”.$id_kod.”‘ “);
$data1 = mysqli_fetch_array($course);
$id=$data1[‘ID’];
$content=$data1[‘Content’];
$coursename=$data1[‘name’];
$res_content=””;
$perc=0;
$res_content=checkContent($link,$login,$id,$content,$res_content,$perc);
$t_perc=sprintf(“%3.1f”,$perc);
echo ‘
‘.$i.’.
‘.$res_content.’
‘.$t_perc.’%
‘;
$i++;
}
echo ‘
‘;
echo ‘
?>
Роздрукувати всі
Роздрукувати всі