'; // Liste des enchères en cours $encheres_autresSQL = mysql_query('SELECT ID FROM tirages WHERE typelot like "enchere" AND DateFin > Now() AND Cible="panelistes" AND Etat="EnCours" ORDER BY ID'); $encheres_autres = array(); while($var = mysql_fetch_assoc($encheres_autresSQL)) { $encheres_autres[] = $var['ID']; } $month_uk = array('January' , 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'); $month_fr = array('Janu', 'Feb', 'March', 'April', 'May', 'June', 'July', 'Augu', 'Sept', 'Oct', 'Nov', 'Dec'); $jour_fr = array('Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'); ?>
Rewards

Survey Points – Gift Voucher Shop



Survey Points – Gift Lottery  
'; echo ' '; $sql_tirages = 'SELECT *, DATE_FORMAT(DateFin , "%e %M %Y") as DateFinTS FROM tirages WHERE (typelot="groslot" or typelot="produit" or typelot="cheque") AND DateFin > Now() AND Cible="panelistes" AND Etat="EnCours" ORDER BY DateFin'; $req_tirages = mysql_query($sql_tirages); echo ''; while($r = mysql_fetch_array($req_tirages)) { $nom_lot = ''.$r['LotNom'].''; $date_limite = str_replace($month_uk, $month_fr, $r['DateFinTS']); //on recupere le jour de la semaine du tirage $Requetejour="SELECT *,UNIX_TIMESTAMP(DateFin) as DateFinTS, DATE_FORMAT(DateFin , '%w') as DateFinJour FROM tirages WHERE ID='$r[ID]' ORDER BY `DateFin` ASC"; $Resultjour=mysql_query($Requetejour); $infosjour = mysql_fetch_assoc($Resultjour); $jourDebutSondage = $infosjour['DateFinJour']; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '
Draw Date Value Prize
'.$jour_fr[($jourDebutSondage)].'
'.$date_limite.'		£'.$r[LotValeur].''.$r[LotNom].'
'; if($r["LotNom"] == 'Voucher') echo ''; else{ if(http_file_exists3('http://www.marketest.co.uk/admin/marketest/uploads/gifts/gifts-'.$r[ID].'.gif')) echo ''; else if(http_file_exists3('http://www.marketest.co.uk/admin/marketest/uploads/gifts/gifts-'.$r[ID].'.GIF')) echo ''; else if(http_file_exists3('http://www.marketest.co.uk/admin/marketest/uploads/gifts/gifts-'.$r[ID].'.png') ) echo ''; else if(http_file_exists3('http://www.marketest.co.uk/admin/marketest/uploads/gifts/gifts-'.$r[ID].'.PNG') ) echo ''; else if(http_file_exists3('http://www.marketest.co.uk/admin/marketest/uploads/gifts/gifts-'.$r[ID].'.jpg') ) echo ''; else if(http_file_exists3('http://www.marketest.co.uk/admin/marketest/uploads/gifts/gifts-'.$r[ID].'.JPG') ) echo ''; else if(http_file_exists3('http://www.marketest.co.uk/admin/marketest/uploads/gifts/gifts-'.$r[ID].'.jpeg')) echo ''; else if(http_file_exists3('http://www.marketest.co.uk/admin/marketest/uploads/gifts/gifts-'.$r[ID].'.JPEG')) echo ''; else echo ''; } // echo'

Social Points - Voucher Auctions - Auctions Available
     Aucune enchère en cours à laquelle vous ne participez pas.