API code

<?php
$host = "91.121.68.87"; // Rellenar el host de la db, ejemplo: $host = "localhost";
$user_db = "mices_es"; // Rellenar el usuario de la db, ejemplo: $user = "root";
$pass = "FryYgZKhdSp6QFGe"; // Rellenar la contrase単a de la db, ejemplo: $pass = "";
$usr = file_get_contents("http://atelier801.com/profile?pr=".$_GET["user"]);
if (isset($_GET["user"]))
{
    header("Content-type: application/json");
    $user = array("name" => $_GET["user"]);
    $link = mysql_connect($host, $user_db, $pass);
    mysql_select_db("statistiques", $link);
    $result = mysql_query("SELECT * FROM player WHERE name='".$user["name"]."'", $link);
    $result2 = mysql_query("SELECT * FROM member WHERE name='".$user["name"]."'", $link);
    while ($row = mysql_fetch_array($result))
    {
        $user["id"] = $row["id"];
        $user["badges"] = $row["badges"];
        $user["look"] = $row["look"];
        $user["title_id"] = $row["title"];
        $user["experience"] = $row["experience"];
        $user["first"] = $row["first"];
        $user["bootcamp"] = $row["bootcamp"];
        $user["round_played"] = $row["round_played"];
        $user["shaman_cheese"] = $row["shaman_cheese"];
        $user["saved_mice"] = $row["saved_mice"];
        $user["saved_mice_hard"] = $row["saved_mice_hard"];
        $user["saved_mice_divine"] = $row["saved_mice_divine"];
        $user["cheese_gathered"] = $row["cheese_gathered"];
        $user["dress_list"] = $row["dress_list"];
        $user["color1"] = $row["color1"];
        $user["color2"] = $row["color2"];
        $user["skills"] = $row["skills"];
        $user["survivor_round_played"] = $row["survivor_round_played"];
        $user["survivor_mouse_killed"] = $row["survivor_mouse_killed"];
        $user["survivor_shaman_count"] = $row["survivor_shaman_count"];
        $user["survivor_survivor_count"] = $row["survivor_survivor_count"];
        $user["racing_round_played"] = $row["racing_round_played"];
        $user["racing_finished_map"] = $row["racing_finished_map"];
        $user["racing_first"] = $row["racing_first"];
        $user["racing_podium"] = $row["racing_podium"];
    }
    while ($row2 = mysql_fetch_array($result2))
    {
        $idtribe = $row2["id_tribe"];
        $idspouse = $row2["id_spouse"];
        $user["marriage_date"] = $row2["marriage_date"];
        $user["gender"] = $row2["id_gender"] == 0 ? "Ninguno" : ($row2["id_gender"] == 1 ? "Femenino" : "Masculino");
    }
    $result3 = mysql_query("SELECT * FROM tribe WHERE id=".$idtribe);
    while ($row3 = mysql_fetch_array($result3)){ $user["tribe"] = $row3["name"]; }
    $result4 = mysql_query("SELECT * FROM player WHERE id=".$idspouse, $link);
    while ($row4 = mysql_fetch_array($result4)) { $user["spouse"] = $row4["name"]; }
    if (preg_match("|Date d'inscription : (.*?)</span>|is", $usr, $abc)) $user["registration_date"] = $abc[1];
    else $user["registration_date"] = "";
    $user["avatar"] = "http://avatars.atelier801.com/".$user["id"] % 10000 . "/".$user["id"].".jpg";
    $a = array();
    $b = 0;
    while (true)
    {
        if ($b == 0) { $a[$b+1] = 32; $c = 32; }
        elseif ($b > 0 && $b < 29) { $a[$b+1] = ($c+2*($b+1))+$a[$b]; $c = $c+2*($b+1); }
        elseif ($b > 28 && $b < 59) { $a[$b+1] = ($c+10*($b+1))+$a[$b]; $c = $c+10*($b+1); }
        else { $a[$b+1] = ($c+15*($b+1))+$a[$b]; $c = $c+15*($b+1); }
        if ($a[$b+1] > $user["experience"]) { $user["level"] = $b+1; break; }
        if ($b == 887) { $user["level"] = 888; break; }
        $b++;
    }
    $json = json_encode($user);
    echo $json;
}
elseif (isset($_GET["id"]))
{
    header("Content-type: application/json");
    $user = array("id" => $_GET["id"]);
    $link = mysql_connect($host, $user_db, $pass);
    mysql_select_db("statistiques", $link);
    $result = mysql_query("SELECT * FROM player WHERE id=".$user["id"], $link);
    while ($row = mysql_fetch_array($result))
    {
        $user["name"] = $row["name"];
        $user["title_id"] = $row["title"];
        $user["experience"] = $row["experience"];
        $user["first"] = $row["first"];
        $user["bootcamp"] = $row["bootcamp"];
        $user["round_played"] = $row["round_played"];
        $user["shaman_cheese"] = $row["shaman_cheese"];
        $user["saved_mice"] = $row["saved_mice"];
        $user["saved_mice_hard"] = $row["saved_mice_hard"];
        $user["saved_mice_divine"] = $row["saved_mice_divine"];
        $user["cheese_gathered"] = $row["cheese_gathered"];
    }
    $result2 = mysql_query("SELECT * FROM member WHERE name='".$user["name"]."'", $link);
    while ($row2 = mysql_fetch_array($result2))
    {
        $idtribe = $row2["id_tribe"];
        $idspouse = $row2["id_spouse"];
        $user["marriage_date"] = $row2["marriage_date"];
        $user["gender"] = $row2["id_gender"] == 0 ? "Ninguno" : ($row2["id_gender"] == 1 ? "Femenino" : "Masculino");
    }
    $result3 = mysql_query("SELECT * FROM tribe WHERE id=".$idtribe);
    while ($row3 = mysql_fetch_array($result3)){ $user["tribe"] = $row3["name"]; }
    $result4 = mysql_query("SELECT * FROM player WHERE id=".$idspouse, $link);
    while ($row4 = mysql_fetch_array($result4)) { $user["spouse"] = $row4["name"]; }
    if (preg_match("|Date d'inscription : (.*?)</span>|is", $usr, $abc)) $user["registration_date"] = $abc[1];
    else $user["registration_date"] = "";
    $user["avatar"] = "http://avatars.atelier801.com/".$user["id"] % 10000 . "/".$user["id"].".jpg";
    $a = array();
    $b = 0;
    while (true)
    {
        if ($b == 0) { $a[$b+1] = 32; $c = 32; }
        elseif ($b > 0 && $b < 29) { $a[$b+1] = ($c+2*($b+1))+$a[$b]; $c = $c+2*($b+1); }
        elseif ($b > 28 && $b < 59) { $a[$b+1] = ($c+10*($b+1))+$a[$b]; $c = $c+10*($b+1); }
        else { $a[$b+1] = ($c+15*($b+1))+$a[$b]; $c = $c+15*($b+1); }
        if ($a[$b+1] > $user["experience"]) { $user["level"] = $b+1; break; }
        if ($b == 887) { $user["level"] = 888; break; }
        $b++;
    }
    $json = json_encode($user);
    echo $json;
}
else
{
    echo "No fueron definidos los par&aacute;metros.";
}
?>