<?php
 
//Question container
$qpid = $_GET['qpid'];
//question startname
$qpids = $_GET['qpids'];
$userid = $GLOBALS['TSFE']->fe_user->user['uid'];
//var_dump($GLOBALS['TSFE']->fe_user->user);
$result_title = $GLOBALS['TYPO3_DB']->sql_query("SELECT title FROM pages WHERE uid=".$qpid);
$result_title = $GLOBALS['TYPO3_DB']->sql_fetch_row($result_title);
echo '<h3>'.$result_title[0].'</h3>';
 
$sql10 = "SELECT it.answers, it.question_subtext, it.question, ans.answer
FROM tx_pbsurvey_answers AS ans
RIGHT JOIN tx_pbsurvey_item AS it ON ans.question=it.uid
RIGHT JOIN tx_pbsurvey_results AS rus ON ans.result = rus.uid
WHERE it.pid = '".$qpids."'
AND it.deleted =0
AND it.hidden =0
AND ans.deleted = 0
AND rus.user = '".$userid."'
ORDER BY sorting";
 
$result = $GLOBALS['TYPO3_DB']->sql_query($sql10);
 
echo '<div id="center"><div id="content"><div class="tx-pbsurvey-pi1"><div id="survey_form">';
 
$q_count = 0;
$q_count_f = 0;
while ($datensatz = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($result))
{
$q_count++;
echo '<table width="100%" cellpadding="0" cellspacing="0" border="0">';
echo '<tr>';
echo '<td width="25" rowspan="2" valign="top"><b>'.str_replace("Frage ","",$datensatz['question']).'.</b></td>';
echo '<td width="635" align="justify"><p class="bodytext">'.$datensatz['question_subtext'].'</p></td>';
echo '</tr>';
echo '<tr>';
echo '<td><br>';
$question_array = explode(chr(13).chr(10),$datensatz['answers']);
echo '<table width="100%" border="0" cellpadding="0" cellspacing="0">';
foreach ($question_array as $key=>$value)
{
$value = explode("|",$value);
if ($datensatz['answer']==($key+1) AND $value[1]==0)
{
$aus_falsch = '<tr><td width="10%" valign="top"><font color="#ff0000"><b>FALSCH:</b></td><td>'.$value[0].'</font><br></td></tr>';
$q_count_f++;
}
elseif ($value[1]==1)
{
$aus_richtig = '<tr><td width="10%" valign="top"><b>RICHTIG:</b></td><td>'.$value[0].'</td></tr>';
}
 
}
 
echo $aus_falsch.$aus_richtig;
echo '</table>';
echo '</td>';
echo '</tr>';
echo '</table>';
echo '<p>&nbsp</p>';
 
$aus_falsch = null;
$aus_richtig = null;
}
echo '<hr>';
$ans_corr = $q_count-$q_count_f;
if ($GLOBALS['TSFE']->fe_user->user['gender']==0)
{
$anrede = "Sehr geehrter Herr";
}
elseif ($GLOBALS['TSFE']->fe_user->user['gender']==1)
{
$anrede = "Sehr geehrte Frau";
};
if ($ans_corr>=7 && $ans_corr<10)
{
$cme = 2;
}
elseif ($ans_corr==10)
{
$cme = 3;
}
else
{
$cme = 0;
}
$en = $ans_corr==1?'':'en';
echo '<p>'.$anrede.' '.$GLOBALS['TSFE']->fe_user->user['last_name'].',</p>';
 
echo '<p>Sie haben bei der Leistungsfeststellung '.$result_title[0].' '.$ans_corr.' richtige Antwort'.$en.' gegeben. Dafür erhalten Sie '.$cme.' CME Punkte.</p>';
echo '</div></div></div></div>';
 
 
$GLOBALS['TYPO3_DB']->sql_query("UPDATE tx_pbsurvey_results SET correct_ans = ".$ans_corr.", cme=".$cme." WHERE pid=".$qpids." AND user=".$userid."&quot<img src="typo3conf/ext/mm_forum//res/smilies/icon_wink.gif" alt="icon_wink.gif" />;
?>