JeuWeb Créez votre jeu par navigateur !

joshua · 13-11-2006, 10:59 PM

voila des elements de reponse....

Code PHP :
<?php 

code testé

debut test

test coord ok

avant eval coord

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 45) * ( `coordonnee_x` - 45 ) + ( `coordonnee_y` - 50 ) * ( `coordonnee_y` - 50 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

apres eval coord

1test coord 48 50

avant eval coord

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 48) * ( `coordonnee_x` - 48 ) + ( `coordonnee_y` - 50 ) * ( `coordonnee_y` - 50 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

apres eval coord

test coord 49 50

avant eval coord

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 49) * ( `coordonnee_x` - 49 ) + ( `coordonnee_y` - 50 ) * ( `coordonnee_y` - 50 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

apres eval coord

test coord 50 50

avant eval coord

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 50) * ( `coordonnee_x` - 50 ) + ( `coordonnee_y` - 50 ) * ( `coordonnee_y` - 50 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

apres eval coord

test coord 51 50

avant eval coord

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 51) * ( `coordonnee_x` - 51 ) + ( `coordonnee_y` - 50 ) * ( `coordonnee_y` - 50 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

apres eval coord

test coord 52 50

avant eval coord

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 52) * ( `coordonnee_x` - 52 ) + ( `coordonnee_y` - 50 ) * ( `coordonnee_y` - 50 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

apres eval coord

test coord 53 50

avant eval coord

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 53) * ( `coordonnee_x` - 53 ) + ( `coordonnee_y` - 50 ) * ( `coordonnee_y` - 50 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

apres eval coord

1

nombre de soleils = 3

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 8) * ( `coordonnee_x` - 8 ) + ( `coordonnee_y` - 19 ) * ( `coordonnee_y` - 19 ) <= ( `taille` + 6 ) * ( `taille` + 6 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 24) * ( `coordonnee_x` - 24 ) + ( `coordonnee_y` - 39 ) * ( `coordonnee_y` - 39 ) <= ( `taille` + 7 ) * ( `taille` + 7 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 71) * ( `coordonnee_x` - 71 ) + ( `coordonnee_y` - 31 ) * ( `coordonnee_y` - 31 ) <= ( `taille` + 6 ) * ( `taille` + 6 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 53) * ( `coordonnee_x` - 53 ) + ( `coordonnee_y` - 51 ) * ( `coordonnee_y` - 51 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 96) * ( `coordonnee_x` - 96 ) + ( `coordonnee_y` - 11 ) * ( `coordonnee_y` - 11 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 16) * ( `coordonnee_x` - 16 ) + ( `coordonnee_y` - 99 ) * ( `coordonnee_y` - 99 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 6) * ( `coordonnee_x` - 6 ) + ( `coordonnee_y` - 92 ) * ( `coordonnee_y` - 92 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 70) * ( `coordonnee_x` - 70 ) + ( `coordonnee_y` - 89 ) * ( `coordonnee_y` - 89 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 94) * ( `coordonnee_x` - 94 ) + ( `coordonnee_y` - 83 ) * ( `coordonnee_y` - 83 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 24) * ( `coordonnee_x` - 24 ) + ( `coordonnee_y` - 42 ) * ( `coordonnee_y` - 42 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 42) * ( `coordonnee_x` - 42 ) + ( `coordonnee_y` - 80 ) * ( `coordonnee_y` - 80 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 38) * ( `coordonnee_x` - 38 ) + ( `coordonnee_y` - 31 ) * ( `coordonnee_y` - 31 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 87) * ( `coordonnee_x` - 87 ) + ( `coordonnee_y` - 30 ) * ( `coordonnee_y` - 30 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 22) * ( `coordonnee_x` - 22 ) + ( `coordonnee_y` - 78 ) * ( `coordonnee_y` - 78 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 12) * ( `coordonnee_x` - 12 ) + ( `coordonnee_y` - 29 ) * ( `coordonnee_y` - 29 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 34) * ( `coordonnee_x` - 34 ) + ( `coordonnee_y` - 55 ) * ( `coordonnee_y` - 55 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 52) * ( `coordonnee_x` - 52 ) + ( `coordonnee_y` - 25 ) * ( `coordonnee_y` - 25 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 85) * ( `coordonnee_x` - 85 ) + ( `coordonnee_y` - 83 ) * ( `coordonnee_y` - 83 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 90) * ( `coordonnee_x` - 90 ) + ( `coordonnee_y` - 15 ) * ( `coordonnee_y` - 15 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 33) * ( `coordonnee_x` - 33 ) + ( `coordonnee_y` - 34 ) * ( `coordonnee_y` - 34 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 62) * ( `coordonnee_x` - 62 ) + ( `coordonnee_y` - 46 ) * ( `coordonnee_y` - 46 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 87) * ( `coordonnee_x` - 87 ) + ( `coordonnee_y` - 30 ) * ( `coordonnee_y` - 30 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 52) * ( `coordonnee_x` - 52 ) + ( `coordonnee_y` - 13 ) * ( `coordonnee_y` - 13 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 8) * ( `coordonnee_x` - 8 ) + ( `coordonnee_y` - 43 ) * ( `coordonnee_y` - 43 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 94) * ( `coordonnee_x` - 94 ) + ( `coordonnee_y` - 65 ) * ( `coordonnee_y` - 65 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 5) * ( `coordonnee_x` - 5 ) + ( `coordonnee_y` - 95 ) * ( `coordonnee_y` - 95 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 72) * ( `coordonnee_x` - 72 ) + ( `coordonnee_y` - 98 ) * ( `coordonnee_y` - 98 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 36) * ( `coordonnee_x` - 36 ) + ( `coordonnee_y` - 58 ) * ( `coordonnee_y` - 58 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 22) * ( `coordonnee_x` - 22 ) + ( `coordonnee_y` - 58 ) * ( `coordonnee_y` - 58 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 12) * ( `coordonnee_x` - 12 ) + ( `coordonnee_y` - 53 ) * ( `coordonnee_y` - 53 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 26) * ( `coordonnee_x` - 26 ) + ( `coordonnee_y` - 44 ) * ( `coordonnee_y` - 44 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 92) * ( `coordonnee_x` - 92 ) + ( `coordonnee_y` - 53 ) * ( `coordonnee_y` - 53 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 21) * ( `coordonnee_x` - 21 ) + ( `coordonnee_y` - 1 ) * ( `coordonnee_y` - 1 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 84) * ( `coordonnee_x` - 84 ) + ( `coordonnee_y` - 79 ) * ( `coordonnee_y` - 79 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 89) * ( `coordonnee_x` - 89 ) + ( `coordonnee_y` - 27 ) * ( `coordonnee_y` - 27 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 49) * ( `coordonnee_x` - 49 ) + ( `coordonnee_y` - 4 ) * ( `coordonnee_y` - 4 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 66) * ( `coordonnee_x` - 66 ) + ( `coordonnee_y` - 68 ) * ( `coordonnee_y` - 68 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 96) * ( `coordonnee_x` - 96 ) + ( `coordonnee_y` - 49 ) * ( `coordonnee_y` - 49 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 35) * ( `coordonnee_x` - 35 ) + ( `coordonnee_y` - 22 ) * ( `coordonnee_y` - 22 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 84) * ( `coordonnee_x` - 84 ) + ( `coordonnee_y` - 85 ) * ( `coordonnee_y` - 85 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 32) * ( `coordonnee_x` - 32 ) + ( `coordonnee_y` - 34 ) * ( `coordonnee_y` - 34 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 23) * ( `coordonnee_x` - 23 ) + ( `coordonnee_y` - 36 ) * ( `coordonnee_y` - 36 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 40) * ( `coordonnee_x` - 40 ) + ( `coordonnee_y` - 3 ) * ( `coordonnee_y` - 3 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 72) * ( `coordonnee_x` - 72 ) + ( `coordonnee_y` - 72 ) * ( `coordonnee_y` - 72 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 94) * ( `coordonnee_x` - 94 ) + ( `coordonnee_y` - 75 ) * ( `coordonnee_y` - 75 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 40) * ( `coordonnee_x` - 40 ) + ( `coordonnee_y` - 16 ) * ( `coordonnee_y` - 16 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 78) * ( `coordonnee_x` - 78 ) + ( `coordonnee_y` - 46 ) * ( `coordonnee_y` - 46 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 87) * ( `coordonnee_x` - 87 ) + ( `coordonnee_y` - 39 ) * ( `coordonnee_y` - 39 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 27) * ( `coordonnee_x` - 27 ) + ( `coordonnee_y` - 64 ) * ( `coordonnee_y` - 64 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 21) * ( `coordonnee_x` - 21 ) + ( `coordonnee_y` - 64 ) * ( `coordonnee_y` - 64 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 25) * ( `coordonnee_x` - 25 ) + ( `coordonnee_y` - 26 ) * ( `coordonnee_y` - 26 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 4) * ( `coordonnee_x` - 4 ) + ( `coordonnee_y` - 62 ) * ( `coordonnee_y` - 62 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 6) * ( `coordonnee_x` - 6 ) + ( `coordonnee_y` - 78 ) * ( `coordonnee_y` - 78 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 43) * ( `coordonnee_x` - 43 ) + ( `coordonnee_y` - 55 ) * ( `coordonnee_y` - 55 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 56) * ( `coordonnee_x` - 56 ) + ( `coordonnee_y` - 18 ) * ( `coordonnee_y` - 18 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 98) * ( `coordonnee_x` - 98 ) + ( `coordonnee_y` - 15 ) * ( `coordonnee_y` - 15 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 7) * ( `coordonnee_x` - 7 ) + ( `coordonnee_y` - 91 ) * ( `coordonnee_y` - 91 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 79) * ( `coordonnee_x` - 79 ) + ( `coordonnee_y` - 64 ) * ( `coordonnee_y` - 64 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 45) * ( `coordonnee_x` - 45 ) + ( `coordonnee_y` - 96 ) * ( `coordonnee_y` - 96 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 45) * ( `coordonnee_x` - 45 ) + ( `coordonnee_y` - 73 ) * ( `coordonnee_y` - 73 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 3) * ( `coordonnee_x` - 3 ) + ( `coordonnee_y` - 79 ) * ( `coordonnee_y` - 79 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 5) * ( `coordonnee_x` - 5 ) + ( `coordonnee_y` - 66 ) * ( `coordonnee_y` - 66 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 67) * ( `coordonnee_x` - 67 ) + ( `coordonnee_y` - 36 ) * ( `coordonnee_y` - 36 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 19) * ( `coordonnee_x` - 19 ) + ( `coordonnee_y` - 12 ) * ( `coordonnee_y` - 12 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 71) * ( `coordonnee_x` - 71 ) + ( `coordonnee_y` - 15 ) * ( `coordonnee_y` - 15 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 96) * ( `coordonnee_x` - 96 ) + ( `coordonnee_y` - 36 ) * ( `coordonnee_y` - 36 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 99) * ( `coordonnee_x` - 99 ) + ( `coordonnee_y` - 13 ) * ( `coordonnee_y` - 13 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 95) * ( `coordonnee_x` - 95 ) + ( `coordonnee_y` - 7 ) * ( `coordonnee_y` - 7 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 85) * ( `coordonnee_x` - 85 ) + ( `coordonnee_y` - 76 ) * ( `coordonnee_y` - 76 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 27) * ( `coordonnee_x` - 27 ) + ( `coordonnee_y` - 48 ) * ( `coordonnee_y` - 48 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 14) * ( `coordonnee_x` - 14 ) + ( `coordonnee_y` - 1 ) * ( `coordonnee_y` - 1 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 49) * ( `coordonnee_x` - 49 ) + ( `coordonnee_y` - 32 ) * ( `coordonnee_y` - 32 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 20) * ( `coordonnee_x` - 20 ) + ( `coordonnee_y` - 36 ) * ( `coordonnee_y` - 36 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 72) * ( `coordonnee_x` - 72 ) + ( `coordonnee_y` - 79 ) * ( `coordonnee_y` - 79 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 87) * ( `coordonnee_x` - 87 ) + ( `coordonnee_y` - 76 ) * ( `coordonnee_y` - 76 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 55) * ( `coordonnee_x` - 55 ) + ( `coordonnee_y` - 62 ) * ( `coordonnee_y` - 62 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 51) * ( `coordonnee_x` - 51 ) + ( `coordonnee_y` - 70 ) * ( `coordonnee_y` - 70 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 8) * ( `coordonnee_x` - 8 ) + ( `coordonnee_y` - 3 ) * ( `coordonnee_y` - 3 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 94) * ( `coordonnee_x` - 94 ) + ( `coordonnee_y` - 13 ) * ( `coordonnee_y` - 13 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 89) * ( `coordonnee_x` - 89 ) + ( `coordonnee_y` - 73 ) * ( `coordonnee_y` - 73 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 53) * ( `coordonnee_x` - 53 ) + ( `coordonnee_y` - 53 ) * ( `coordonnee_y` - 53 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 8) * ( `coordonnee_x` - 8 ) + ( `coordonnee_y` - 95 ) * ( `coordonnee_y` - 95 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 10) * ( `coordonnee_x` - 10 ) + ( `coordonnee_y` - 87 ) * ( `coordonnee_y` - 87 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 24) * ( `coordonnee_x` - 24 ) + ( `coordonnee_y` - 40 ) * ( `coordonnee_y` - 40 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 1) * ( `coordonnee_x` - 1 ) + ( `coordonnee_y` - 61 ) * ( `coordonnee_y` - 61 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 48) * ( `coordonnee_x` - 48 ) + ( `coordonnee_y` - 30 ) * ( `coordonnee_y` - 30 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 9) * ( `coordonnee_x` - 9 ) + ( `coordonnee_y` - 72 ) * ( `coordonnee_y` - 72 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 38) * ( `coordonnee_x` - 38 ) + ( `coordonnee_y` - 36 ) * ( `coordonnee_y` - 36 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 70) * ( `coordonnee_x` - 70 ) + ( `coordonnee_y` - 68 ) * ( `coordonnee_y` - 68 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 3) * ( `coordonnee_x` - 3 ) + ( `coordonnee_y` - 82 ) * ( `coordonnee_y` - 82 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 67) * ( `coordonnee_x` - 67 ) + ( `coordonnee_y` - 44 ) * ( `coordonnee_y` - 44 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 3) * ( `coordonnee_x` - 3 ) + ( `coordonnee_y` - 39 ) * ( `coordonnee_y` - 39 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 35) * ( `coordonnee_x` - 35 ) + ( `coordonnee_y` - 49 ) * ( `coordonnee_y` - 49 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 48) * ( `coordonnee_x` - 48 ) + ( `coordonnee_y` - 28 ) * ( `coordonnee_y` - 28 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 59) * ( `coordonnee_x` - 59 ) + ( `coordonnee_y` - 78 ) * ( `coordonnee_y` - 78 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 96) * ( `coordonnee_x` - 96 ) + ( `coordonnee_y` - 22 ) * ( `coordonnee_y` - 22 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 72) * ( `coordonnee_x` - 72 ) + ( `coordonnee_y` - 79 ) * ( `coordonnee_y` - 79 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 57) * ( `coordonnee_x` - 57 ) + ( `coordonnee_y` - 42 ) * ( `coordonnee_y` - 42 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 59) * ( `coordonnee_x` - 59 ) + ( `coordonnee_y` - 48 ) * ( `coordonnee_y` - 48 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 91) * ( `coordonnee_x` - 91 ) + ( `coordonnee_y` - 60 ) * ( `coordonnee_y` - 60 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 54) * ( `coordonnee_x` - 54 ) + ( `coordonnee_y` - 33 ) * ( `coordonnee_y` - 33 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 7) * ( `coordonnee_x` - 7 ) + ( `coordonnee_y` - 98 ) * ( `coordonnee_y` - 98 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 42) * ( `coordonnee_x` - 42 ) + ( `coordonnee_y` - 31 ) * ( `coordonnee_y` - 31 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 64) * ( `coordonnee_x` - 64 ) + ( `coordonnee_y` - 29 ) * ( `coordonnee_y` - 29 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 58) * ( `coordonnee_x` - 58 ) + ( `coordonnee_y` - 87 ) * ( `coordonnee_y` - 87 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 71) * ( `coordonnee_x` - 71 ) + ( `coordonnee_y` - 73 ) * ( `coordonnee_y` - 73 ) <= ( `taille` + 0 ) * ( `taille` + 0 ) 

dans position planete

dans la boucle while

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 5) * ( `coordonnee_x` - 5 ) + ( `coordonnee_y` - 5 ) * ( `coordonnee_y` - 5 ) <= ( `taille` + 5 ) * ( `taille` + 5 ) 

les coord de x sont inferieur à 99

dans la boucle while

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 6) * ( `coordonnee_x` - 6 ) + ( `coordonnee_y` - 5 ) * ( `coordonnee_y` - 5 ) <= ( `taille` + 5 ) * ( `taille` + 5 ) 

les coord de x sont inferieur à 99

dans la boucle while

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 7) * ( `coordonnee_x` - 7 ) + ( `coordonnee_y` - 5 ) * ( `coordonnee_y` - 5 ) <= ( `taille` + 5 ) * ( `taille` + 5 ) 

les coord de x sont inferieur à 99

dans la boucle while

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 8) * ( `coordonnee_x` - 8 ) + ( `coordonnee_y` - 5 ) * ( `coordonnee_y` - 5 ) <= ( `taille` + 5 ) * ( `taille` + 5 ) 

les coord de x sont inferieur à 99

dans la boucle while

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 9) * ( `coordonnee_x` - 9 ) + ( `coordonnee_y` - 5 ) * ( `coordonnee_y` - 5 ) <= ( `taille` + 5 ) * ( `taille` + 5 ) 

les coord de x sont inferieur à 99

dans la boucle while

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 10) * ( `coordonnee_x` - 10 ) + ( `coordonnee_y` - 5 ) * ( `coordonnee_y` - 5 ) <= ( `taille` + 5 ) * ( `taille` + 5 ) 

les coord de x sont inferieur à 99

dans la boucle while

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 11) * ( `coordonnee_x` - 11 ) + ( `coordonnee_y` - 5 ) * ( `coordonnee_y` - 5 ) <= ( `taille` + 5 ) * ( `taille` + 5 ) 

les coord de x sont inferieur à 99

dans la boucle while

SELECT * FROM `tbl_planete` WHERE `galaxie`=1 AND (`coordonnee_x` - 12) * ( `coordonnee_x` - 12 ) + ( `coordonnee_y` - 5 ) * ( `coordonnee_y` - 5 ) <= ( `taille` + 5 ) * ( `taille` + 5 ) 

les coord de x sont inferieur à 99

Sujets apparemment similaires…
Sujet		Auteur	Réponses	Affichages	Dernier message
	Performances des Triggers (MySQL 5.7)	Xenos	0	999	14-08-2019, 05:52 PM Dernier message: Xenos