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

[FrostBiteRetros]

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

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]

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]

Oh man, sweet.
Nice little tutorial

 

[FrostBiteRetros]

Oh man, sweet.
Nice little tutorial

thanks

 

[Jerry]

Thanks dude.

 

[FrostBiteRetros]

Thanks dude.

No problem

 

[Ruin]

Thanks bro, I needed this.

 

[FrostBiteRetros]

Thanks bro, I needed this.

Haha no problem man!

 

[Brackston]

bump

 

[Brad]

Nice Tutorial for those that need it!

 

[Jamescool12]

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]

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

 

[Swiftay98]

How to do this with a navicat database?

 

[Kak]

How to do this with a navicat database?

run the code as a query...

 

[Swiftay98]

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]

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

 

[Zachariah]

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

 

[5050]

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]

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

UPDATE `catalog_furnis` SET can_stack = '1';