Catalogfix for BCStorm

[=dj.matias=]

Hi,
Many years ago someone released catalogfix for uberemulator. I changed it to working on BCstorm based emulators. This script changes 99.9% sprite ids on db and you can use other habbo furnidata habbo.nl etc..

Create catalogfix.php and add this text:

<?php
set_time_limit(0); 

/*=======================================================================
| Vemund Eldegard aka iLost. 
| #######################################################################
| Found on Otaku-Studio
| Free for use!
\======================================================================*/

$db_host = "localhost";    //Host database
$db_user = "root";        //mysql_user
$db_pass = "";        //mysql_password
$db_database = "";    //database

$connect = mysql_connect($db_host, $db_user, $db_pass) or die("Could not connect to server, error: ".mysql_error());
$db = mysql_select_db($db_database, $connect) or die("Could not connect to database, error: ".mysql_error());

$data = file_get_contents("http://www.habbo.fi/gamedata/furnidata?hash=x");
$data = str_replace("\n", "", $data);
$data = str_replace("[[", "[", $data);
$data = str_replace("]]", "]", $data);
$data = str_replace("][", "],[", $data);


foreach (explode('],[', $data) as $val)
{
    $val = str_replace('[', '', $val);
    $val = str_replace(']', '', $val);
    
    $bits = explode(',', $val);
    $name = str_replace('"', '', $bits[2]);
    
    $stufftoupdate[] = '[' . $val . ']';
}

foreach ($stufftoupdate as $stuff)
    {
        #Start select item_name
        $stuff = str_replace('"s",', '', $stuff);
        $stuff = str_replace('"i",', '', $stuff);
        $furni = explode('[', $stuff);
        $furni = explode(']', $furni[1]);
        $nome = explode('","', $furni[0]);
        $nome = explode('","', $nome[1]);
        $nome = $nome[0];
        #End select item_name
        
        #Start select sprite_id
        $stuff = str_replace('"s",', '', $stuff);
        $stuff = str_replace('"i",', '', $stuff);
        $furni = explode('[', $stuff);
        $furni = explode(']', $furni[1]);
        $id = explode('"', $furni[0]);
        $id = explode('","', $id[1]);
        $id = $id[0];
        #End select sprite_id
        
        
        $idfurni = mysql_query("SELECT * FROM items_base WHERE item_name = '$nome'");
        $furni = mysql_fetch_array($idfurni);
        $furniid = $furni['item_id'];
        $update = mysql_query("UPDATE items_base SET sprite_id = ".$id." WHERE iteM_id =".$furniid);
        if ($update==FALSE) echo("MySQL error in item ".$nome."<br/><br/>");
        else echo("Item ".$nome." updated<br/><br/>");
    }
?>

Change mysql details and furnidata hotel location.

[MentaL]

[Spheral]

What does this do, basically update sprite_Ids?

[The General]

What does this do, basically update sprite_Ids?

Correct

[Spheral]

Is useful in it's own way.
Another great release from soneone who cares about the community and is trustworthy.

[Kaan2106]

It is the same as this or not?

[Carlosso]

This is very nice, but if I do this.. is my hotel getting buggy?

[Divide]

This was made `back in the day` when a gold bar would look like a club sofa or a furniture didnt load.

[Joopie]

You dont use json_decode (i know you didnt made it, but you edited it)?

And why do you want to update the sprite ids in the database when you can update the ids from the furnidata with the ids out the database?

[The General]

You dont use json_decode (i know you didnt made it, but you edited it)?

And why do you want to update the sprite ids in the database when you can update the ids from the furnidata with the ids out the database?

I do prefer this though :/

[Ddos Attack]

This was made `back in the day` when a gold bar would look like a club sofa or a furniture didnt load.

Good ol' days ;)

[Chapo]

Uh i'm a little bit confused because it updates the sprite ids same as habbo ids right? but what about the furniture in the hotel? People will get other furni etc?

[Joopie]

I do prefer this though :/

All the complicated str_replace shit can ge reduced to this:

$parsed = preg_replace('/\]\](\r|\n|\r\n|\n\r)\[\[/', '],[', $content);
$json = json_decode($parsed, true);

foreach ($json as $item)
{
  $furni = array();
  list($furni['type'], $furni['sprite_id'], $furni['item_name'], $furni['revision'], $furni['start_rotation'], $furni['width'], $furni['length'], $furni['colors'], $furni['public_name'], $furni['description']) = $item;
  
  //Do the mysql queries and shit
} 

I just lol'd

Uh i'm a little bit confused because it updates the sprite ids same as habbo ids right? but what about the furniture in the hotel? People will get other furni etc?

Theoretical it should be the same if this script is coded right.

[EvilCoder]

This is very nice, but if I do this.. is my hotel getting buggy?

Possible.

You should be carefull with this kind of stuff. Don't trust the furnidata of Habbo... They block "user_agents" using javascript. But anyway.. Good luck =)