All pastes #191023 Raw Edit

Someone

public text v1 · immutable
·published 2006-10-04 15:54 UTC
rendered paste body
$_SESSION['TicketGagnant']="oui";
$_SESSION['KodeGagnant']=$_POST['InputUtiliserKode'];



$sql = "CREATE TEMPORARY TABLE tmp  TYPE=HEAP SELECT id, nom, 1 / valeur * stock_en_cours UnSur FROM kados";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = "CREATE TEMPORARY TABLE tmp2 TYPE=HEAP SELECT sum(UnSur) AS total FROM tmp";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql = "SELECT a.id, a.nom, a.UnSur / b.total *100 AS chances FROM tmp a, tmp2 b ORDER BY RAND()";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());

$valeur_tiree_au_sort = mt_rand(1,100);
$valeur_intermediare = 0;

while($data = mysql_fetch_assoc($req)) 
    {
	
	if($valeur_tiree_au_sort<=$valeur_intermediare){
	$_SESSION['KadoID']=$data['id'];
	$_SESSION['KadoNom']=$data['nom'];
	
	
	print("vous avez gagné : "); print($_SESSION['KadoNom']);
	exit;
	
	}else{
	$val_intermediaire+=$data['chances'];
		}
	
	}