#CACHE{0} Admin oxfam [(#INCLURE{fond=inc_infometa}{id_rubrique}{id_article}{lang=#LANG})] #SPIP_CRON #INSERT_HEAD

Statistique du quizz

".$str_queryError."
".$sql."
".mysql_error()."

");@mysql_free_result($result);exit();endif; $data = mysql_fetch_array($result) ; $nb_joueurs = mysql_num_rows($result) ; echo "- Nombre de participant : ".$nb_joueurs; $sql = "SELECT * FROM oxfam_stat ;" ; $result2=mysql_query($sql); if(!$result2):echo("

".$str_queryError."
".$sql."
".mysql_error()."

");@mysql_free_result($result2);exit();endif; $data2 = mysql_fetch_array($result2) ; $nb_reponses = mysql_num_rows($result2) ; echo "
- Taux de complétion : ".($nb_reponses/5); echo "
- Nb de questions / joueur : ".($nb_reponses/$nb_joueurs); $sql = "SELECT * FROM oxfam_stat WHERE reponse_internaute = bonne_reponse ;" ; $result=mysql_query($sql); if(!$result):echo("

".$str_queryError."
".$sql."
".mysql_error()."

");@mysql_free_result($result);exit();endif; $data = mysql_fetch_array($result) ; $nb_bonnereponses = mysql_num_rows($result); echo "
- Taux de bonnes reponses : ".($nb_bonnereponses/$nb_reponses) ; echo "
- Taux de bonnes reponses par question :" ; echo "" ; $sql = "SELECT * FROM oxfam_stat WHERE num_question = '#ID_ARTICLE';" ; $result2=mysql_query($sql); if(!$result2):echo("

".$str_queryError."
".$sql."
".mysql_error()."

");@mysql_free_result($result2);exit();endif; $data2 = mysql_fetch_array($result2) ; $nb_reponses = mysql_num_rows($result2) ; $sql = "SELECT * FROM oxfam_stat WHERE reponse_internaute = bonne_reponse AND num_question = '#ID_ARTICLE';" ; $result=mysql_query($sql); if(!$result):echo("

".$str_queryError."
".$sql."
".mysql_error()."

");@mysql_free_result($result);exit();endif; $data = mysql_fetch_array($result) ; $nb_bonnereponses = mysql_num_rows($result); echo "" ; echo "
[(#TITRE|sansguillemet)]".$nb_bonnereponses." / ".$nb_reponses."".($nb_bonnereponses/$nb_reponses)."
" ; ?>

Données brutes du quizz

Date Adreese IP Question Réponse Internaute Bonne Réponse
[(#DATE_CHOIX)] #ADR_IP #TITRE #REPONSE_INTERNAUTE #BONNE_REPONSE
#LOGIN_PUBLIC