R63B Database (Make all furni stackable & Stack Height) any one have a SQL for this?

[JTAG]

Title says it all, is there a SQL for r63b database to make all furni stackable and height of stack. ​

 

[IntactDev]

..... show me the furniture table.

 

[JTAG]

this any good?

Link -

 

[IntactDev]

Here you go

You must be registered for see links

! Let me know if it worked

ALTER TABLE `items_base` SET allow_stack = '1';

 

[JTAG]

Just trying it now, i'm a but un sure of navicat so yeah i'll prob be doing it wrong-.-​

Here you go

You must be registered for see links

! Let me know if it worked

ALTER TABLE `items_base` SET allow_stack = '1';

​

​

Don't want to sound a pain or anything but could you show me how to run this through on navicat over Team viewer?​

mean alot if you could <3​

​

I keep getting this so i'm deffo doing it wrong-.-
​

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET allow_stack = '1'' at line 1
[Err] ALTER TABLE `items_base` SET allow_stack = '1';
[Msg] Finished - Unsuccessfully
--------------------------------------------------

​

 

[sim0n]

I'm pretty sure you open your database, click query, new query, enter the code which is provided right above this reply, click run. Done.

 

[xUnknownGamer]

UPDATE `items_base` SET allow_stack = '1';
Try that^^​

 

[JTAG]

UPDATE `items_base` SET allow_stack = '1';​

Try that^^​

The SQL didn't run also i'm using a r63b database....

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET allow_stack = '1'' at line 1
[Err] ALTER TABLE `items_base` SET allow_stack = '1';
[Msg] Finished - Unsuccessfully

 

[sim0n]

The SQL didn't run also i'm using a r63b database....

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET allow_stack = '1'' at line 1
[Err] ALTER TABLE `items_base` SET allow_stack = '1';
[Msg] Finished - Unsuccessfully

It did work for me

 

[JTAG]

I go on to Navicat go to my tables new query paste the code and run and get nothing but error...

 

[sim0n]

I go on to Navicat go to my tables new query paste the code and run and get nothing but error...

Weird

 

[IntactDev]

I go on to Navicat go to my tables new query paste the code and run and get nothing but error...

Click Run SQL, then do the following:

UPDATE `items_base` SET allow_stack = '1';

 

[JTAG]

Click Run SQL, then do the following:

UPDATE `items_base` SET allow_stack = '1';

Worked thanks man.

 

[IntactDev]

Worked thanks man.

No problem, glad to help. Can someone close thread, as problem is solved?

You must be registered for see links

You must be registered for see links