1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
|
if (isset($_POST['Submit']))
{
$url=$_POST['url_concours'];
$mois=date("m");
$id=($_POST['pid_concours']);
$idc=($_POST['id_concours']);
$type=$_POST['type_concours'];
$login=$_POST['login'];
$url=$_POST['url_concours'];
If($type=='Unique')
{
mysql_query("INSERT INTO perso_back(pid_concours,rpseudo,dateparticipation)(SELECT * from perso WHERE pid_concours='$id')");
mysql_query("Update perso_back SET dateparticipation=DATE_ADD(now(),interval 0 day) WHERE pid_concours='$id' Limit 1");
mysql_query("Update perso SET compteur=2 WHERE pid_concours='$id'");
}
if ($type=="Journalier")
{
mysql_query("UPDATE perso SET dateparticipation=DATE_ADD(dateparticipation,INTERVAL 1 day) WHERE pid_concours='$id'") or die(mysql_error());
//mysql_query("UPDATE perso SET compteur=0 WHERE pid_concours='$id'") or die(mysql_error());
}
if($type=="Hebdomadaire")
mysql_query("UPDATE perso SET dateparticipation=DATE_ADD(CURDATE(), INTERVAL 7 day) WHERE pid_concours='$id'") or die(mysql_error());
if($type=="Mensuel")
{
if($mois=='04' || $mois=='06' || $mois=='09' || $mois=='11')
{
mysql_query("UPDATE perso SET dateparticipation=DATE_ADD(CURDATE(), INTERVAL 30 day)WHERE pid_concours='$id'") or die(mysql_error());
}
if($mois=='01' || $mois=='03' || $mois=='05' || $mois=='07' || $mois=='08' || $mois=='09' || $mois=='10' || $mois=='12')
{
mysql_query("UPDATE perso SET dateparticipation=DATE_ADD(CURDATE(), INTERVAL 31 day)WHERE pid_concours='$id'") or die(mysql_error());
}
if($mois=='02')
{
mysql_query("UPDATE perso SET dateparticipation=DATE_ADD(CURDATE(), INTERVAL 28 day)WHERE pid_concours='$id'") or die(mysql_error());
}
}
//Redirection vers un lien externe
echo "<SCRIPT LANGUAGE=Javascript>
window.open('$url','_blank')// ouverture du lien dans une autre fenetre
</SCRIPT>";
} |
Partager