All pastes #191041 Raw Edit

Untitled

public php v1 · immutable
·published 2006-10-04 16:07 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){	print("Nous avons un kado");	$_SESSION['KadoID']=$data['id'];	$_SESSION['KadoNom']=$data['nom'];			print("vous avez gagné : "); print($_SESSION['KadoNom']);	exit;		}else{	echo "$val_intermediaire<br>";	$val_intermediaire+=$data['chances'];		}		}