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?
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?