function profil (){

  global $userrow, $numqueries; 
  $sql = doquery("SELECT * FROM {{table}} WHERE latitude='$latitude' AND longitude='$longitude'", "users"); 
  $sql2 = doquery("SELECT * FROM {{table}} ", "control"); 
  $sqlrow = mysql_fetch_array($sql);
  $sqlrow2 = mysql_fetch_array($sql2);
  $realnewpass = md5($_POST['newpass1']);

  $_POST['class1name'] = 1 ;
  $_POST['class2name'] = 2 ;
  $_POST['class3name'] = 3 ;
  $_POST['diff1name'] = 1 ;
  $_POST['diff2name'] = 2 ;
  $_POST['diff3name'] = 3 ;

  // listes des options du select charclass.
  $mesOptions = array(1=>'class1name', 2=>'class2name', 3=>'class3name');

  // construire la liste des options
  $lesOptions = ''; 
  foreach ($mesOptions as $value=>$text) {
    $select=''; 
    if ( $value == $sqlrow["charclass"]) { 
       $select=' selected="selected"'; 
    }
    $lesOptions .= '<option value="'.$value.'"'.$select.'>'.$sqlrow2[$text].'</option>';
  }

 
  if (isset($_POST['home'])) {
    if ( empty($_POST['email']) || empty($_POST['charname'])){ 
      display("<table height=\"1\"><tr><td><img src=\"images/jeu/actions/notaire.jpg\"/></td></tr></table><br><table width=\"580\"><tr><td align=\"left\">Vous n'avez pas rempli correctement le formulaire. Veuillez réessayer.<br><br>Maintenant vous pouvez:<br><br><a href=\"index.php\">» retourner au sommaire de la ville</a><br><a href=\"index.php?do=profil\">» retourner dans votre profil</a></td></tr></table>", "Chez le notaire"); die(); 
    } 
    else {
      $query = doquery("UPDATE {{table}} SET  difficulty='" . $_POST['difficulty'] . "', charclass='" . $_POST['charclass'] . "', email='" . $_POST['email'] . "', charname='" . $_POST['charname'] . "', avatar='" . $_POST['avatar'] . "' WHERE id='".$userrow["id"]."' LIMIT 1", "users"); 

      $title = "Auberge"; 
      $page = "<table height=\"1\"><tr><td><img src=\"images/jeu/actions/votreprofil.jpg\"/></td></tr></table><br><table width=\"580\"><tr><td align=\"left\">Les modifications de votre compte ont été correctement enregistrée.<br><br>Maintenant vous pouvez:<br><br><a href=\"index.php\">» retourner au menu</a></td></tr></table>"; 
    }
 
  } else { 
    $title = "Votre profil"; 
    $page = "<form enctype=\"multipart/form-data\" action=\"index.php?do=profil\" method=\"post\">\n"; 
    $page .= "<table height=\"1\"><tr><td><img src=\"images/jeu/actions/votreprofil.jpg\"/></td></tr></table><br><table width=\"580\"><tr><td align=\"left\">Pour modifier votre profil, il vous suffit de modifier la donnée déja existante, puis de cliquer sur le bouton valider. <br>En cas de problèmes, postez votre message sur le <a href=\"forum.php\">forum du jeu</a></td></tr></table>.<br><br>\n"; 
$page .= "<table width=\"580\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" valign=\"top\">\n"; 
$page .= "<tr valign=\"top\"><td width=\"110\"><div align=\"left\">ID:</div></td><td><div align=\"left\"><input type=\"text\" name=\"username\" size=\"30\" maxlength=\"100\" disabled=\"disabled\" value=\"" . $sqlrow["username"] . "\"/></div><br></td></tr>\n"; 
$page .= "<tr valign=\"top\"><td width=\"110\"><div align=\"left\">PW:</div></td><td><div align=\"left\"><input type=\"password\" name=\"newpass1\" size=\"30\" maxlength=\"100\"  disabled=\"disabled\" value=\"".$sqlrow["password"]."\"/></div><br></td></tr>\n"; 
$page .= "<tr valign=\"top\"><td width=\"110\"><div align=\"left\">Adresse Email:</div></td><td><div align=\"left\"><input type=\"text\" name=\"email\" size=\"30\" maxlength=\"100\" value=\"" . $sqlrow["email"] . "\"/></div><br></td></tr>\n"; 
$page .= "<tr valign=\"top\"><td width=\"110\"><div align=\"left\">Nom du perso:</div></td><td><div align=\"left\"><input type=\"text\" name=\"charname\" size=\"30\" maxlength=\"100\" value=\"" . $sqlrow["charname"] . "\"/></div><br></td></tr>\n"; 
$page .= "<tr valign=\"top\"><td width=\"110\"><div align=\"left\">Avatar du perso:</div></td><td><div align=\"left\"><select name=\"avatar\" \><option value=\"1\">numéro 1</option><o<select name=\"charclass\"><option value=\"1\">" . $sqlrow2["class1name"] . "</option><option value=\"2\">" . $sqlrow2["class2name"] . "</option>ption value=\"2\" ".$selected." >numéro 2</option><option value=\"3\">numéro 3</option><option value=\"4\">numéro 4</option><option value=\"5\">numéro 5</option><option value=\"6\">numéro 6</option><option value=\"7\">numéro 7</option><option value=\"8\">numéro 8</option><option value=\"9\">numéro 9</option><option value=\"10\">numéro 10</option></select></div><div align=\"left\">Pour voir tous les avatars <A HREF=\"#\" onClick=\"window.open('avatars.php','_blank','toolbar=0, location=0, directories=0, status=0, scrollbars=0, resizable=0, copyhistory=0, menuBar=0, width=400, height=265');return(false)\">cliquez ici.</a></div><br></td><td></td></tr>\n";
$page .= "<tr valign=\"top\"><td width=\"110\"><div align=\"left\">Classe du perso:</td><td><div align=\"left\"><select name=\"charclass\" \>\n"; 
$page .= $lesOptions;
$page .= "</select></div><br><br></td></tr>\n"; 
$page .= "<tr valign=\"top\"><td width=\"110\"><div align=\"left\">Difficulté:</td><td><div align=\"left\"><select name=\"difficulty\" ><option value=\"1\">" . $sqlrow2["diff1name"] . "</option><option value=\"2\">" . $sqlrow2["diff2name"] . "</option><option value=\"3\">" . $sqlrow2["diff3name"] . "</option></select></div><br><br></td></tr>\n"; 
$page .= "</td></tr>\n";
$page .= "<tr valign=\"top\"><td width=\"1\"></td><td>\n"; 
$page .= "<div align=\"center\"><input type=\"submit\" name=\"home\" value=\"Valider\" /> <input type=\"reset\" name=\"reset\" value=\"Annuler\" /></div></td></tr>\n"; 
$page .= "</table>\n"; 
$page .= "</form>\n"; 

  } 
  display($page, $title); 
}