SQL to Delete all items from User

[Blasteh]

Hello,
I'm looking for an SQL to delete all of a users items. So basically, if there ID is 5, it'll delete all furniture that was owned by User ID 5 and remove it from their rooms.

I was playing around on localhost, and I was trying to max out the room. I maxed it out, and it could not be entered anymore. I have deleted the room from the database, but the thing is on the top-stats it still shows the following:

You must be registered for see images attach

I want to get that user off the top-stats. But by deleting it from the database, it never returned the furniture.

 

[Sledmore]

DELETE FROM `items` WHERE `user_id` = '5';

This will not delete moodlight data, toner data, wired data. If you have such data ,et me know and I'll adjust the query.

 

[Core]

Of you want to delete a specific item you can use

DELETE FROM `items` WHERE `user_id` = '5' AND `base_item` = '1';

Change base item with something like throne id to remove them off the throne leaderboard, and so on.

 

[Zaka]

Of you want to delete a specific item you can use

DELETE FROM `items` WHERE `user_id` = '5' AND `base_item` = '1';

Change base item with something like throne id to remove them off the throne leaderboard, and so on.

He specifically said he wanted to remove all items connected to his user id

 

[Core]

He specifically said he wanted to remove all items connected to his user id

I can read, thanks for the writing it again tho :troll:
I was providing him a solution to just remove from top stats.