<?php

mysql_connect('localhost','root','') ;

mysql_select_db('elvetika') ;



for ($i=0; $i<25; $i++) {

$sql = 'insert into systeme (px, py, skin)

                select A,B,C

                from (

                select 

                truncate(rand()*200+1,0) A,

                truncate(rand()*200+1,0) B,

                truncate(rand()*6+1,0) C

                ) as rand

                where  not exists (select skin from systeme where px=rand.A and py=rand.B)';

mysql_unbuffered_query ($sql);

}



$req = mysql_query("SELECT count(*) FROM systeme");

$total = array_pop(mysql_fetch_row($req));



mysql_close();



if ($total<4000) header ("Refresh: 1;URL=creer_systemes.php");

  echo $total;

?>

<?php

header ("Content-type: image/png");



$image_carte = imagecreate(800,700)   or die ('Librairie GD non fonctionnelle');

$fond_carte=Imagecolorallocate($image_carte, 0, 0, 0);



$decx=22; //decalage pour faire jolie ;p

$decy=22;



$bleu = Imagecolorallocate($image_carte, 255, 0, 0);

$vert = Imagecolorallocate($image_carte, 255, 0, 255);

$jaune = Imagecolorallocate($image_carte, 0, 255, 255);

$rose = Imagecolorallocate($image_carte, 255, 255, 0);

$blanc = Imagecolorallocate($image_carte, 255, 255, 255);

$noir = Imagecolorallocate($image_carte, 120, 30, 255);



$x1=0+$decx;

$x2=0+$decx;



for ($i=1;$i<=5;$i++) {

    ImageLine ($image_carte, $x1, $decy, $x2, 600+$decy, $blanc);

    $x1= $x1+150;

    $x2 =$x2+150;

}



$y1=0+$decy;

$y2=0+$decy;



for ($i=1;$i<=5;$i++) {

    ImageLine ($image_carte, $decx, $y1, 600+$decx, $y2, $blanc);

    $y1= $y1+150;

    $y2 =$y2+150;

}



include('config.php'); // constantes HOST USER PWD BDD

include ('inc/class.mydb.php');// class mysql (si qqun veu je peu la poster mais je l'ai pas finie)



$sql = new myDB(HOST, USER, PWD , BDD);



$query = 'SELECT px,py,skin FROM systeme';





$nbbleu = 0;

$nbvert = 0;

$nbjaune = 0;

$nbrose = 0;

$nbblanc = 0;

$nbnoir = 0;





if (!$sql->select($query)) {}

else {

foreach ($sql->select($query) as $value) {



   //je cree un tableau pour les trier par clan

$px     = $value['px'];

$py    = $value['py'];





  switch ($value['skin']) {

    case 1 :

       $color = $bleu;

       $nbbleu++;

    break;

    case 2 :

       $color = $vert;

       $nbvert++;

    break;

     case 3 :

       $color = $jaune;

       $nbjaune++;

    break;

     case 4 :

       $color = $rose;

       $nbrose++;

    break;

     case 5 :

       $color = $blanc;

       $nbblanc++;

    break;

    case 6 :

       $color = $noir;

       $nbnoir++;

    break;

     }



    $px = $px*3;

    $py = $py*3;

   imagefilledrectangle ($image_carte, $px+$decx-1, $py+$decy-1, $px+$decx+1, $py+$decy+1, $color);

}

}



imagestring($image_carte, 4, 722, 250, $nbbleu, $bleu);

imagestring($image_carte, 4, 722, 300, $nbvert, $vert);

imagestring($image_carte, 4, 722, 350, $nbblanc, $blanc);

imagestring($image_carte, 4, 722, 400, $nbrose, $rose);

imagestring($image_carte, 4, 722, 450, $nbjaune, $jaune);

imagestring($image_carte, 4, 722, 500, $nbnoir, $noir);

$somme = $nbbleu+$nbvert+$nbblanc+$nbrose+$nbjaune+$nbnoir;

imagestring($image_carte, 3, 666, 550, 'TOTAL : '.$somme, $blanc);



$sql->close();

// on affiche l'image

imagepng($image_carte);

ImageDestroy ($image_carte);

?>

<?php 

for ($i=0; $i<25; $i++) {

$rand1 = mt_rand(1,200);

$rand2 = mt_rand(1,200);

$rand3 = mt_rand(1,6);



$sql = 'insert into systeme (px, py, skin)

                select A,B,C

                from (

                select 

                '.$rand1.' A,

                '.$rand2.' B,

                '.$rand3.' C

                ) as rand

                where  not exists (select skin from systeme where px=rand.A and py=rand.B)';

mysql_unbuffered_query ($sql);

}