Sql script

[Hanashi]

how to select remove all inventory items from the database and change group id of a certain account using sql script?

 

Edited November 17, 2016 by AshiHanna

[Jey]

# Removes all inventory items from all characters
DELETE FROM `inventory`;

# Removes inventory items from character 150000
DELETE FROM `inventory` WHERE `char_id` = 150000;

# Sets group_id to 1 of account 2000000
UPDATE `login` SET `group_id` = 1 WHERE `account_id` = 2000000;

Edit:

Don't forget to backup your database.

Edited November 17, 2016 by Jey