[Solved] Client crashes after deleting items from NPC

[fckdup01]

Hey Guys!
I tried to delete items from shops so I could fill them with my desired items using this query:
USE SRO_VT_SHARD
GO

DECLARE @oDelete varchar(129) = 'STORE_KT_ACCESSORY_TAB2';

-- Step 1: Get all package items from the tab we want to delete
DECLARE @Items TABLE (RefPackageItemCodeName varchar(129) COLLATE Korean_Wansung_CI_AS);

INSERT INTO @Items (RefPackageItemCodeName)
SELECT DISTINCT RefPackageItemCodeName
FROM _RefShopGoods
WHERE RefTabCodeName = @oDelete COLLATE Korean_Wansung_CI_AS;

-- Step 2: Delete from _RefShopGoods ANYWHERE these package items appear
DELETE sg
FROM _RefShopGoods sg
JOIN @Items pi
ON sg.RefPackageItemCodeName COLLATE Korean_Wansung_CI_AS = pi.RefPackageItemCodeName;

-- Step 3: Delete from _RefPricePolicyOfItem
DELETE p
FROM _RefPricePolicyOfItem p
JOIN @Items pi
ON p.RefPackageItemCodeName COLLATE Korean_Wansung_CI_AS = pi.RefPackageItemCodeName;

-- Step 4: Delete from _RefScrapOfPackageItem
DELETE s
FROM _RefScrapOfPackageItem s
JOIN @Items pi
ON s.RefPackageItemCodeName COLLATE Korean_Wansung_CI_AS = pi.RefPackageItemCodeName;

-- Step 5: Delete from _RefPackageItem
DELETE pkg
FROM _RefPackageItem pkg
JOIN @Items pi
ON pkg.CodeName128 COLLATE Korean_Wansung_CI_AS = pi.RefPackageItemCodeName;

Server started without errors after executing the query, but when I updated the media.pk2 the client crashes on start.
Does anyone have any idea why it could happen, or have a tested query to delete items from NPC?

[janicka]

Try dont delete them, just set service to 0, also youre queryes are too much complicated for such task. Btw i dont even read them.

[Kabloz™]

back to old shard and execute this query.

UPDATE dbo._RefShopGoods SET Service = 0 WHERE RefTabCodeName LIKE 'STORE_KT_ACCESSORY_TAB2'