%PDF- %PDF-<?
include("./config.inc.php");
$mysqlconnect = @mysql_connect($mysqladdress,$mysqlusername,$mysqluserpass) or die("Connexion impossible. Veuillez nous en excuser, nous faisons actuellement tout notre possible pour un rapide retour à la normale...");
                @mysql_select_db($mysqlbasename, $mysqlconnect) or die("Base introuvable");

function nb_commentaires($nom) {
 global $mysqlconnect;
	
$mysqlquery   = "SELECT COUNT(*) FROM commentaires WHERE nom='".$nom."'";
$mysqlresult  =  mysql_query($mysqlquery,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult);
	
	$nb_commentaires = $row[0];
	
	return $nb_commentaires;
}

if ($id_sondage!=""){
if ($rep_sondage) {
$mysqlquery1 = "SELECT id_sondage FROM sondages_sondages WHERE id_sondage='".$id_sondage."' AND actif='oui'";    
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);

if(mysql_num_rows($mysqlresult1) > 0) { 
	if (!$HTTP_COOKIE_VARS["sondage_".$id_sondage]){
	//echo "le cookie n'existe pas !";
$mysqlquery   = "UPDATE sondages_reponses SET nb_votes = nb_votes+1 WHERE id_sondage='".$id_sondage."' AND id_reponse='".$rep_sondage."'";    
$mysqlresult  =  mysql_query($mysqlquery,$mysqlconnect) or die ("Erreur !");

				$vote_save = $id_sondage;
				setcookie("sondage_".$id_sondage,1,time()+2592000,"/",".mixs.fr",0);

	}	
}}}

$mysqlquery1 = "SELECT * FROM sondages_sondages WHERE id_sondage='".$id_sondage."' AND actif='oui'";    
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);

if(mysql_num_rows($mysqlresult1) > 0) { 
 $row=mysql_fetch_row($mysqlresult1);
  $id_sondage=$row[0];
  $date_ajout=$row[1];
  $question=$row[2];

$nb_total_reponses_sondage = "SELECT SUM(nb_votes) AS total FROM sondages_reponses WHERE id_sondage='".$id_sondage."'";
$nb_total_reponses_sondage =  mysql_query($nb_total_reponses_sondage,$mysqlconnect);
$data = mysql_fetch_array($nb_total_reponses_sondage);
$nb_total_reponses_sondage = $data['total'];
?>
<table width="100%" cellpadding="0" cellspacing="3" bgcolor="#F9EBF9" style="border-top-width:2pt; border-top-color:white; border-top-style:solid;">
	<tr>
		<td width="235" bgcolor="#F9EBF9">
<h3><img src="http://www.mixs.fr/i/sondage.gif" border="0" vspace="5" hspace="5" alt="sondages"></h3>
		</td>
	</tr>
	<tr>
		<td width="100%" bgcolor="#F6FAFC">

<table width="100%" cellpadding="3" cellspacing="0" bgcolor="#F9EBF9">
	<tr>
		<td width="100%" bgcolor="#FF99FF" colspan="2"><font color="white"><b><?= utf8_encode($question); ?></b></font></td>
	</tr>
 <?
$i=1;
$mysqlquery1 = "SELECT * FROM sondages_reponses WHERE id_sondage='".$id_sondage."' ORDER BY id_reponse ASC";    
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);

if(mysql_num_rows($mysqlresult1) > 0) { 
 while ($row=mysql_fetch_row($mysqlresult1)) {
  $id_reponse=$row[0];
  $id_sondage=$row[1];
  $reponse=$row[2];
  $nb_votes=$row[3];

$pourcent_rep = round($nb_votes * 100 / $nb_total_reponses_sondage, 1);
?>
	<tr>
		<td<? if ($i==2) { ?> bgcolor="#F7F1F7"<? } ?>><font color="#FF33CC"><?= utf8_encode($reponse); ?></font></td>
		<td<? if ($i==2) { ?> bgcolor="#F7F1F7"<? $i=0; } ?>><img src="http://www.mixs.fr/i/sondagebarre.gif" border="0" height="7" width="<?= $pourcent_rep; ?>" align="absmiddle" alt="<?= $nb_votes; ?> vote<? if ($nb_votes>1) { ?>s<? } ?>"> <font color="#FF33CC"><?= $pourcent_rep; ?> %</font></td>
	</tr>
<? $i++; }} ?>
</table>

		</td>
	</tr>
	<tr>
		<td width="100%" bgcolor="#FF99FF">
<p align="center"><font color="white"><?  echo $nb_total_reponses_sondage." vote"; if ($nb_total_reponses_sondage>1) { echo "s"; } ?> | <a href="javascript:na_open_window('archives_sondage', 'http://www.mixs.fr/sondages/popup_archives.php', 0, 0, 400, 390, 0, 0, 0, 1, 1)" style="color:#FFFFFF;">archives</a> | <a href="javascript:na_open_window('archives_sondage', 'http://www.mixs.fr/sondages/popup_commentaires.php?id_sondage=<?= $id_sondage; ?>', 0, 0, 400, 390, 0, 0, 0, 1, 1)" style="color:#FFFFFF;">commentaires (<?= nb_commentaires("sondage-".$id_sondage); ?>)</a></font></p>
		</td>
	</tr>
</table><? } ?>