{R63} Making all furniture Stackable without rollers {R63}

FrostBiteRetros · Apr 4, 2014

Okay this is very simple to do. Go into localhost/phpmyadmin, and open your database. click SQL and run this into the box :

Code:

UPDATE `furniture` SET can_stack = '1';

then click go.
Reload your client, then do these commands in-game :
:update_catalogue
:update_settings
:update_items

Now try it yourself

all furni is stackable !

Zymf · Apr 11, 2014

This will help a lot of people, nice tutorial.
:update_catalogue and :update_settings aren't needed though - Once you've updated your items table then used furni that isn't already placed it should work

Nerfed · Apr 11, 2014

Oh man, sweet.
Nice little tutorial

FrostBiteRetros · Apr 15, 2014

Nerfed said:
Oh man, sweet.
Nice little tutorial

thanks

Jerry · Apr 16, 2014

Thanks dude.

FrostBiteRetros · Apr 16, 2014

JerryCool said:
Thanks dude.

No problem

Ruin · Aug 6, 2014

Thanks bro, I needed this.

FrostBiteRetros · Aug 6, 2014

Sn1p3r said:
Thanks bro, I needed this.

Haha no problem man!

Brackston · Aug 6, 2014

Brad · Sep 2, 2014

Nice Tutorial for those that need it!

Jamescool12 · Dec 7, 2015

i put on my navicat i put as a qurey
UPDATE `furniture` SET can_stack = '1';

and it didnt work LOOL i tired puting all the commands you listed

Adapt · Jan 1, 2016

Nice SQL. This will help out many people who are owning hotels and have these problems. Great release.

Swiftay98 · Feb 21, 2018

How to do this with a navicat database?

Kak · Feb 21, 2018

Swiftay98 said:
How to do this with a navicat database?

run the code as a query...

Swiftay98 · Feb 21, 2018

You must be registered for see links

Just tried running as a Query but rp.furniture doesn't exist, but catalog_furnis and catalog_items does, would it be the same command but using one of these?

cammy · Feb 21, 2018

Wouldn't do this myself as it'll mess up some aspects of furni but great tutorial!

Zachariah · Feb 22, 2018

Or you can just go into furniture table and do the furni that you want stackable change it to stackable / can_stack = 1

5050 · Feb 24, 2018

Swiftay98 said:
You must be registered for see links

Just tried running as a Query but rp.furniture doesn't exist, but catalog_furnis and catalog_items does, would it be the same command but using one of these?

Try catalog_furnis.

Kak · Feb 25, 2018

Swiftay98 said:
You must be registered for see links

Just tried running as a Query but rp.furniture doesn't exist, but catalog_furnis and catalog_items does, would it be the same command but using one of these?

im not sure wat your furniture table is called. im guessing its catalog_furnis? so alter the furniture part to this

Code:

UPDATE `catalog_furnis` SET can_stack = '1';

{R63} Making all furniture Stackable without rollers {R63}

Member

Godzilla

Member

not rly active lol

Member

Member

Member

Member

Well-Known Member

Member

Learning Habbo Retro Developer

New Member

Posting Freak

New Member

Member

Active Member

Member

Posting Freak

Users who are viewing this thread