Client crashes after deleting items from NPC

06/17/2025 20:32 fckdup01#1
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 @[Only registered and activated users can see links. Click Here To Register...]oDelete varchar(129) = 'STORE_KT_ACCESSORY_TAB2';

-- Step 1: Get all package items from the tab we want to delete
DECLARE @[Only registered and activated users can see links. Click Here To Register...]Items TABLE (RefPackageItemCodeName varchar(129) COLLATE Korean_Wansung_CI_AS);

INSERT INTO @[Only registered and activated users can see links. Click Here To Register...]Items (RefPackageItemCodeName)
SELECT DISTINCT RefPackageItemCodeName
FROM _RefShopGoods
WHERE RefTabCodeName = @[Only registered and activated users can see links. Click Here To Register...]oDelete COLLATE Korean_Wansung_CI_AS;

-- Step 2: Delete from _RefShopGoods ANYWHERE these package items appear
DELETE sg
FROM _RefShopGoods sg
JOIN @[Only registered and activated users can see links. Click Here To Register...]Items pi
ON sg.RefPackageItemCodeName COLLATE Korean_Wansung_CI_AS = pi.RefPackageItemCodeName;

-- Step 3: Delete from _RefPricePolicyOfItem
DELETE p
FROM _RefPricePolicyOfItem p
JOIN @[Only registered and activated users can see links. Click Here To Register...]Items pi
ON p.RefPackageItemCodeName COLLATE Korean_Wansung_CI_AS = pi.RefPackageItemCodeName;

-- Step 4: Delete from _RefScrapOfPackageItem
DELETE s
FROM _RefScrapOfPackageItem s
JOIN @[Only registered and activated users can see links. Click Here To Register...]Items pi
ON s.RefPackageItemCodeName COLLATE Korean_Wansung_CI_AS = pi.RefPackageItemCodeName;

-- Step 5: Delete from _RefPackageItem
DELETE pkg
FROM _RefPackageItem pkg
JOIN @[Only registered and activated users can see links. Click Here To Register...]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?
06/20/2025 21:19 janicka#2
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.
06/23/2025 04:05 Kabloz™#3
back to old shard and execute this query.

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