mirror of
https://github.com/araxiaonline/mod-azerothshard.git
synced 2026-06-16 02:52:25 -04:00
17 lines
377 B
SQL
17 lines
377 B
SQL
-- character inventory
|
|
|
|
DELETE FROM `character_inventory` WHERE `item` NOT IN (SELECT `guid` FROM `item_instance`);
|
|
|
|
|
|
-- [AZTH] character saved position
|
|
|
|
DELETE FROM character_saved_position WHERE charGuid NOT IN (
|
|
SELECT guid FROM characters
|
|
)
|
|
|
|
-- [AZTH] smartstone commands
|
|
|
|
DELETE FROM character_smartstone_commands WHERE playerGuid NOT IN (
|
|
SELECT guid FROM characters
|
|
)
|