<?php

include("geoipcity.inc");
include("geoipregionvars.php");

define("DIR_LOCALISE", getcwd() . "/");

class backoffice 
{
 
    function getIP($database, $serveurbase, $loginbase, $passwordbase) 
    {        
      $rest = array();
      
      // on se connecte        
      $link = mysql_connect($serveurbase, $loginbase, $passwordbase) or die ("Impossible de se connecter : " . mysql_error()); 
      mysql_select_db($database, $link);
      
      $sql = "SELECT DISTINCT AdresseIP, Email, Date FROM `login`";
      
      // on envoie la requęte  
      $req = mysql_query($sql) or die('Erreur SQL !'.$sql.''.mysql_error());
      
      // on fait une boucle qui va faire un tour pour chaque enregistrement
      while($data = mysql_fetch_assoc($req))  
      {            
        $Email = $data['Email']; 
        $Date = $data['Date'];
        $AdresseIP = $data['AdresseIP'];
       
        $gi = geoip_open(DIR_LOCALISE."GeoLiteCity.dat",GEOIP_STANDARD); 
        $record = geoip_record_by_addr($gi,$AdresseIP);
        
        $Latitude = $record->latitude;
        $Longitude = $record->longitude;
             
        array_push($rest, array("Email"=>$Email, "Date"=>$Date, "AdresseIP"=>$AdresseIP, "Latitude"=>$Latitude, "Longitude"=>$Longitude));      
      }                

      // on retourne le tableau 
      return $rest;	 
    }      
}
?>