Furnidata JSON Generator

<?php

    /**
    *  ______  __      ______ ______       ________
    *  ___  / / /_____ ___  /____  /__________  __ )___  ____________
    *  __  /_/ /_  __ `/_  __ \_  __ \  __ \_  __  |  / / /__  /__  /
    *  _  __  / / /_/ /_  /_/ /  /_/ / /_/ /  /_/ // /_/ /__  /__  /_
    *  /_/ /_/  \__,_/ /_.___//_.___/\____//_____/ \__,_/ _____/____/
    *
    *  @link https://www.habbobuzz.com
    *  @copyright The HabboBuzz Group
    *  @author Mercury (volodia)
    */

header('Content-Type: application/json');

$mysqli = new mysqli("localhost","root","mysql","arcturus");

if ($mysqli->connect_errno) {
  echo "Failed to connect to MySQL: " . $mysqli->connect_error;
  exit();
}

$resultRoomItem = $mysqli->query("SELECT * FROM items_base WHERE type = 's'");
$resultWallItem = $mysqli->query("SELECT * FROM items_base WHERE type = 'i'");

/**
* Put url of the furnidata json Habbo. E.g: https://www.habbo.com/gamedata/furnidata_json/1
* Met l'url du furnidata en json d'Habbo. Ex: https://www.habbo.fr/gamedata/furnidata_json/1
\**/

$furnidataJson = file_get_contents('https://www.habbo.com/gamedata/furnidata_json/1');
//https://images.habbobuzz.com/nitro/json/Furnidata_fr.json

$json = json_decode($furnidataJson, true);
$roomItem = json_encode($json['roomitemtypes']);
$mobisSol = json_decode($roomItem, true);

$wallItem = json_encode($json['wallitemtypes']);
$mobisMur = json_decode($wallItem, true);

foreach($mobisSol as $person => $value)
{
    foreach($value as $key => $personal)
    {
        $row = mysqli_fetch_array($resultRoomItem);
        str_replace('"', '', $row['id']);

        if(isset($personal['partcolors'])):
        $roomitemtypes[] = array('id' => (int)$row['id'],
                                 'classname' => $row['item_name'],
                                 'revision' => 0,
                                 'category' => $personal['category'],
                                 'defaultdir' => 0,
                                 'xdim' => (int)$row['width'],
                                 'ydim' => (int)$row['length'],
                                 'partcolors' => $personal['partcolors'],
                                 'name' => $personal['name'],
                                 'description' => $personal['description'],
                                 'adurl' => $personal['adurl'],
                                 'offerid' => (int)$personal['id'],
                                 'buyout' => $personal['buyout'],
                                 'rentofferid' => $personal['rentofferid'],
                                 'bc' => $personal['bc'],
                                 'excludeddynamic' => $personal['excludeddynamic'],
                                 'customparams' => $personal['customparams'],
                                 'specialtype' => $personal['specialtype'],
                                 'canstandon' => $personal['canstandon'],
                                 'cansiton' => $personal['cansiton'],
                                 'canlayon' => $personal['canlayon'],
                                 'furniline' => $personal['furniline'],
                                 'environment' => $personal['environment'],
                                 'rare' => $personal['rare']
                             );
        else:
        $roomitemtypes[] = array('id' => (int)$row['id'],
                                 'classname' => $row['item_name'],
                                 'revision' => 0,
                                 'category' => $personal['category'],
                                 'defaultdir' => 0,
                                 'xdim' => (int)$row['width'],
                                 'ydim' => (int)$row['length'],
                                 'name' => $personal['name'],
                                 'description' => $personal['description'],
                                 'adurl' => $personal['adurl'],
                                 'offerid' => (int)$personal['id'],
                                 'buyout' => $personal['buyout'],
                                 'rentofferid' => $personal['rentofferid'],
                                 'bc' => $personal['bc'],
                                 'excludeddynamic' => $personal['excludeddynamic'],
                                 'customparams' => $personal['customparams'],
                                 'specialtype' => $personal['specialtype'],
                                 'canstandon' => $personal['canstandon'],
                                 'cansiton' => $personal['cansiton'],
                                 'canlayon' => $personal['canlayon'],
                                 'furniline' => $personal['furniline'],
                                 'environment' => $personal['environment'],
                                 'rare' => $personal['rare']
                             );
            endif;
    }
}

foreach($mobisMur as $person => $value)
{
    foreach($value as $key => $personal)
    {
        $row = mysqli_fetch_array($resultWallItem);

        $wallitemtypes[] = array('id' => (int)$row['id'],
                                 'classname' => $row['item_name'],
                                 'revision' => 0,
                                 'category' => $personal['category'],
                                 'name' => $personal['name'],
                                 'description' => $personal['description'],
                                 'adurl' => $personal['adurl'],
                                 'specialtype' => $personal['specialtype'],
                                 'furniline' => $personal['furniline'],
                                 'environment' => $personal['environment'],
                                 'rare' => $personal['rare'],
                                 'offerid' => (int)$personal['id'],
                                 'buyout' => $personal['buyout'],
                                 'rentofferid' => $personal['rentofferid'],
                                 'rentbuyout' => $personal['rentbuyout'],
                                 'bc' => $personal['bc'],
                                 'excludeddynamic' => $personal['excludeddynamic']
                             );
    }
}

$furnidata = array("roomitemtypes" => ['furnitype' => $roomitemtypes],
                   "wallitemtypes" => ['furnitype' => $wallitemtypes]);

echo json_encode($furnidata);