How to empty someones Inventory?

[Jwake]

Hello,
So I want to reset everyones rares via database, but I'm not too sure how... Could someone help? Is there an sql or what?
Please help

 

[Pinkman]

Hello,
So I want to reset everyones rares via database, but I'm not too sure how... Could someone help? Is there an sql or what?
Please help

Should be inside your database in "items" Just look for the unique id for that rare and remove it.

 

[Jwake]

Should be inside your database in "items" Just look for the unique id for that rare and remove it.

Can I truncate the whole table to delete all items? or will it like delete the furni in the room

 

[Pinkman]

Can I truncate the whole table to delete all items? or will it like delete the furni in the room

That will delete everyones furni in room and inventory.

 

[Jwake]

That will delete everyones furni in room and inventory.

How do I remove furni from the inventory? It's confusing...

 

[yoyok]

This query will delete all furnitures in the inventory.

DELETE * FROM items where room_id = '0';

 

[Jwake]

This query will delete all furnitures in the inventory.

DELETE * FROM items where room_id = '0';

"[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 '* FROM items where room_id = '0'' at line 1"

 

[yoyok]

"[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 '* FROM items where room_id = '0'' at line 1"

Try this, should work now.

DELETE FROM items where room_id = '0';

 

[Jwake]

Try this, should work now.

DELETE FROM items where room_id = '0';

Thanks man! It worked

 

[yoyok]

Thanks man! It worked

If you have any questions just ask it.