<?php

if (isset($object))
{
    $connection = mysql_connect("sql.free.fr","login","mdp");
    mysql_select_db("bdd") or die ("pas de connection");
 
      $req = "SELECT idpointage FROM pointages WHERE utilisateur='$object' AND dh_pointage_fin = '0000-00-00 00:00:00' ORDER BY idpointage DESC limit 1";
      $res = mysql_query($req) or die(mysql_error());
   
      if (mysql_num_rows($res) > 0)
      {
        $donnees = mysql_fetch_assoc($res);

        // UPDATE
        $req = "UPDATE pointages SET dh_pointage_fin = NOW() WHERE idpointage = ".$donnees['idpointage'];
        $res = mysql_query($req) or die(mysql_error());
        $txtpointage = "fin+du+travail.";
      }
      else
      {
        $req = "INSERT INTO pointages VALUES(0,'$object',NOW(),0)";
        $res = mysql_query($req) or die(mysql_error());
        $txtpointage = "debut+du+travail.";
      }
   
  //on referme la base de données
  mysql_close();



// message nabaztag
// parametres
$mac_adresse = "????????????"; //l'adresse mac de son nabaztag
$token = "??????????"; //le token de son nabaztag
$voice = "FR-Archibald";
$txt = $object.",+".$txtpointage.".";

//message pour nabaztag
$api_url = "http://api.nabaztag.com/vl/FR/api.jsp?sn=".$mac_adresse."&token=".$token."&voice=".$voice."&tts=".$txt."&ttlive=0";
global $api_url; //on récupère l'url de l'api
$content = @file_get_contents("$api_url"); //On charge l'adresse web


  }
  else
    echo 'pas de numero de serie';

?>