include('header.php'); ?>
include('menuhaut.php'); ?>
include('animhaut.php'); ?>
HIT 30
$ip = $_SERVER['REMOTE_ADDR'];
$action = $_REQUEST['action'];
$idmusic = $_REQUEST['idmusic'];
$Jour = date("d/");
$Mois = date("n/");
switch ($Mois) {
case 1:
$Mois = "01";
break;
case 2:
$Mois = "02";
break;
case 3:
$Mois = "03";
break;
case 4:
$Mois = "04";
break;
case 5:
$Mois = "05";
break;
case 6:
$Mois = "06";
break;
case 7:
$Mois = "07";
break;
case 8:
$Mois = "08";
break;
case 9:
$Mois = "09";
break;
case 10:
$Mois = "10";
break;
case 11:
$Mois = "11";
break;
case 12:
$Mois = "12";
break;
}
$Annee= date("/Y");
$quand = $Jour.$Mois.$Annee; // on met bout à bout
if($action=="pour") {
$search_vote = mysql_query("SELECT * FROM votes WHERE ip = '$ip' AND date = '$quand' ");
$nb_vote = mysql_num_rows($search_vote);
if($nb_vote =="1") {
echo"Un seul vote par jour.
";
}
else {
$newvote=$nbvote+1;
$sql = "INSERT INTO votes (id, ip, idmusic, date) VALUES ('','$ip','$idmusic','$quand')";
$insert = mysql_query ($sql);
$query = "UPDATE hit30 SET nbvote='$newvote' WHERE id='$idmusic' ";
$result = mysql_query($query);
echo"Votre vote a bien été enregistré.
";
}
}
if($action=="contre") {
$search_vote = mysql_query("SELECT * FROM votes WHERE ip = '$ip' AND date = '$quand' ");
$nb_vote = mysql_num_rows($search_vote);
if($nb_vote =="1") {
echo"Un seul vote par jour.
";
}
else {
$result_sql = mysql_query("SELECT * FROM hit30 WHERE id='$idmusic' ");
$nbvote = mysql_result($result_sql,0,"nbvote");
if($nbvote =="0") {
$sql = "INSERT INTO votes (id, ip, idmusic, date) VALUES ('','$ip','$idmusic','$quand')";
$insert = mysql_query ($sql);
echo"Votre vote a bien été enregistré.
";
}
else {
$newvote=$nbvote-1;
$sql = "INSERT INTO votes (id, ip, idmusic, date) VALUES ('','$ip','$idmusic','$quand')";
$insert = mysql_query ($sql);
$query = "UPDATE hit30 SET nbvote='$newvote' WHERE id='$idmusic' ";
$result = mysql_query($query);
echo"Votre vote a bien été enregistré.
";
}
}
}
$hit1=mysql_query("select * from hit30 WHERE place='1' ");
$i=1;
while($row=mysql_fetch_array($hit1)) {
$res1=$row[place1]-$row[place];
if($res1 =="0") { $res=""; }
if($res1 > 0) { $res="+$res1"; }
if($res1 < 0) { $res="$res1"; }
?>
}
?>
$hit2=mysql_query("select * from hit30 WHERE place='2' ");
$i=1;
while($row=mysql_fetch_array($hit2)) {
$res1=$row[place1]-$row[place];
if($res1 =="0") { $res=""; }
if($res1 > 0) { $res="+$res1"; }
if($res1 < 0) { $res="$res1"; }
?>
}
?>
$hit3=mysql_query("select * from hit30 WHERE place='3' ");
$i=1;
while($row=mysql_fetch_array($hit3)) {
$res1=$row[place1]-$row[place];
if($res1 =="0") { $res=""; }
if($res1 > 0) { $res="+$res1"; }
if($res1 < 0) { $res="$res1"; }
?>
}
?>
$hit4=mysql_query("select * from hit30 order by place asc LIMIT 3,200 ");
$i=1;
while($row=mysql_fetch_array($hit4)) {
$res1=$row[place1]-$row[place];
if($res1 =="0") { $res=""; }
if($res1 > 0) { $res="+$res1"; }
if($res1 < 0) { $res="$res1"; }
?>
}
?>
include('menuconnexion.php'); ?>
include('footer.php'); ?>