<?php

        // -----------------------------------------------------------------------------------------------------------
        // Loteria creado por SainT
        // loteria.php
        // http://www.ogame.ciberpaxi.es
        // -----------------------------------------------------------------------------------------------------------

        define('INSIDE'  , true);
        define('INSTALL' , false);

$ugamela_root_path = './';
    include($ugamela_root_path . 'extension.inc');
    include($ugamela_root_path . 'common.' . $phpEx);

        $Tiempo = time();
        $loteria = gettemplate('loterie_off');
        if($Tiempo < $game_config['Loterie']) {
        $Falta =  $game_config['Loterie']-$Tiempo;
        $parse['usuarios'] = "Il reste ".$Falta." secondes avant la prochaine loterie... Patience !!!";
           
           $lote = parsetemplate( $loteria, $parse);
           display ($lote, "Loterie", false, '', true);
           
        } else {

                    $resto = $Tiempo - $game_config['Actualisation'];
                   
                 
           $loteria = gettemplate('loterie_body');
        $tiempolote = 63600;
        $maxtickets = 10000;
        $canxticketm = 2500000;
        $canxticketc = 2500000;
        $canxticketd = 2500000;



        $totaltickets  = doquery ("SELECT sum(tickets) as total_tickets FROM {{table}} ",'loterie');
          $CantidadTickets = mysql_fetch_array($totaltickets);
        $parse['Cantidad'] = $CantidadTickets['total_tickets'];
        $parse['Cantidadf'] = $maxtickets-$CantidadTickets['total_tickets'];
        $parse['Cantidadt'] = $maxtickets;
        $parse['Cantidadm'] = $canxticketm;
        $parse['Cantidadc'] = $canxticketc;
        $parse['Cantidadd'] = $canxticketd;

        $TusTickets2  = doquery ("SELECT * FROM {{table}} WHERE `user` = '".$user['username']."' ",'loterie');
        $TusTicket3 = mysql_fetch_array($TusTickets2);
        $TusTickets=$TusTicket3['tickets'];
        if($TusTickets != NULL) {
        $parse['tustickets'] = $TusTickets;
        }
          else {
        $parse['tustickets'] = 0;
        }
        if($_GET['cp'] == "compra") {
        $metal = $_POST['Tickets']*$canxticketm;
        $cristal = $_POST['Tickets']*$canxticketc;
        $Deuterio = $_POST['Tickets']*$canxticketd;
        $complant = doquery("SELECT * FROM {{table}} WHERE `id` = '".$planetrow['id']."' ",'planets');
        $DatosPlaneta = mysql_fetch_array($complant);
        if ($DatosPlaneta['metal'] >= $metal && $DatosPlaneta['crystal'] >= $cristal && $DatosPlaneta['deuterium'] >= $Deuterio)
        {


        if ($parse['Cantidadf'] < $_POST['Tickets']) { $parse['MensajeCompra'] = "<font color='#FF0000'>Il n'y a plus assez de Tickets pour en acheter autant !</font>"; } else {
        $smetal = $DatosPlaneta['metal']-$metal;
        $scristal = $DatosPlaneta['crystal']-$cristal;
        $sdeuterio = $DatosPlaneta['deuterium']-$Deuterio;
        doquery("UPDATE {{table}} SET `metal`='".$smetal."', `crystal`='".$scristal."', `deuterium`='".$sdeuterio."' WHERE `id`='".$planetrow['id']."' limit 1", "planets");

        if($TusTickets > 0) {
        $Suma = $TusTickets+$_POST['Tickets'];
        doquery("UPDATE {{table}} SET `tickets`='".$Suma."' WHERE `user`='{$user['username']}' limit 1", "loterie");
        } else { doquery("INSERT INTO {{table}} SET `ID`='".$user['id']."', `user`='".$user['username']."', `tickets`='".$_POST['Tickets']."' ", "loterie"); }

        $parse['MensajeCompra'] = "<font color='#00FF00'>Juste acheter".$_POST['Tickets']." Tickets</font>";
        ?> <META HTTP-EQUIV='Refresh' CONTENT="0; URL='loterie.php'> <?
        }
                     

        if(($_POST['Tickets']+$CantidadTickets['total_tickets']) == $maxtickets) {


                     $ganador = doquery("SELECT * FROM {{table}} order by rand()", "loterie");
                    $elganador = mysql_fetch_array($ganador);
                    $ganad = $elganador['ID'];
                   
                    $userio = doquery("SELECT * FROM {{table}} WHERE `id` = '".$ganad."' limit 1",'users');
           $Datoswiner = mysql_fetch_array($userio);
              $ganadp = $Datoswiner['id_planet'];
                      $complant = doquery("SELECT * FROM {{table}} WHERE `id_owner` = '".$ganad."' limit 1",'planets');
           $DatosPlaneta = mysql_fetch_array($complant);
           
           $emetal = $DatosPlaneta['metal']+($canxticketm*$maxtickets);
           $ecristal = $DatosPlaneta['crystal']+($canxticketc*$maxtickets);
           $edeuterio = $DatosPlaneta['deuterium']+($canxticketd*$maxtickets);
           doquery("UPDATE {{table}} SET `metal`='".$emetal."', `crystal`='".$ecristal."', `deuterium`='".$edeuterio."' WHERE `id`='".$ganadp."' limit 1", "planets");
                 
                $dando = doquery("SELECT * FROM {{table}}", "loterie");
                     $Time    = time();             
                     $From    = "<font color=\"". $kolor ."\">Loteries</font>";             
                     $Subject = "<font color=\"". $kolor ."\">R&eacute;sultats de la loterie</font>";   
                     $summery=0;   
                     
                   while ($uzer = mysql_fetch_array($dando)) {         
                 if($ganad == $uzer['ID']) { $Message = "<font color='#00ff00'>F&eacute;licitations !!!<br>Tu as le Ticket gagnant de la loterie !<br>Nous &eacute;sp&eacute;rons te revoir bientot !</font>"; } //Message en cas de gain
                 else { $Message = "<font color='#FF0000'><br>Tu n'as pas achet&eacute; le Ticket gagnant, <br>Nous &eacute;sp&eacute;rons te revoir bientot !</font>"; } //Message en cas de perte
                      SendSimpleMessage ( $uzer['ID'], $uzer['ID'], $Time, 1, $From, $Subject, $Message);
                   
                     }   
                  doquery ("DELETE FROM {{table}} ",'loterie');
                  $sigueintelore = $tiempolote + time();
                  doquery("UPDATE {{table}} SET `config_value`='".$sigueintelore."' WHERE `config_name`='Loterie' limit 1", "config");
                  }
        } else { $parse['MensajeCompra'] = "<font color='#FF0000'>Tu n'as pas assez de ressources !</font>"; }
        }
        $pase['usuarios'] = "Autres joueurs";
        if($CantidadTickets == $maxtickets) { $parse['color'] = "red"; } else { $parse['color'] = "green"; }
               $usuarios   = doquery("SELECT * FROM {{table}} order by tickets", "loterie");
                   while ($listad = mysql_fetch_array($usuarios)) {   
                 $parse['usuarios'] .= "".$listad['user']." poss&egrave;de ".$listad['tickets']." Ticket(s)<br/>";
               
                 }


           $lote = parsetemplate( $loteria, $parse);
           display ($lote, "Loterie", false, '', true);
        }
        // -----------------------------------------------------------------------------------------------------------
        // Loteria creado por SainT
        // http://www.ogame.ciberpaxi.es
        // -----------------------------------------------------------------------------------------------------------

?>