elitepvpers - [Release] How to find missing avatars

Hello again

I got sick of adding avatars manually to Item Mall so I made a query that will select all missing avatars from _RefObjCommon

Please remember to take backup before doing this big change

Query

Code:

-- RefShopGoods

SELECT 1, 15, 'MALL_AVATAR_DRESS', 'PACKAGE_'+CodeName128, 0, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx' FROM _RefObjCommon WHERE CodeName128 NOT in (SELECT RefItemCodeName FROM _RefScrapOfPackageItem) AND CodeName128 like 'ITEM_MALL_AVATAR_%' And Service = 1 AND CodeName128 not like '%_HAT%' AND CodeName128 not like '%_ATTACH%' order by id asc



-- RefPackageItem

SELECT 1, 15, 1300, 'PACKAGE_'+CodeName128, 0, 'EXPAND_TERM_ALL', NameStrID128, DescStrID128, AssocFileIcon128, -1, 'XXX', -1, 'xxx', -1, 'xxx', -1, 'xxx' FROM _RefObjCommon WHERE CodeName128 NOT in (SELECT RefItemCodeName FROM _RefScrapOfPackageItem) AND CodeName128 like 'ITEM_MALL_AVATAR_%' And Service = 1 AND CodeName128 not like '%_HAT%' AND CodeName128 not like '%_ATTACH%' order by id asc



-- RefPricePolicyOfITem

SELECT 1, 15, 'PACKAGE_'+CodeName128, 2, 0, 398, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx' FROM _RefObjCommon WHERE CodeName128 NOT in (SELECT RefItemCodeName FROM _RefScrapOfPackageItem) AND CodeName128 like 'ITEM_MALL_AVATAR_%' And Service = 1 AND CodeName128 not like '%_HAT%' AND CodeName128 not like '%_ATTACH%' order by id asc



-- RefScrapOfPackageItem

SELECT 1, 15, 'PACKAGE_'+CodeName128, CodeName128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', 100 FROM _RefObjCommon WHERE CodeName128 NOT in (SELECT RefItemCodeName FROM _RefScrapOfPackageItem) AND CodeName128 like 'ITEM_MALL_AVATAR_%' And Service = 1 AND CodeName128 not like '%_HAT%' AND CodeName128 not like '%_ATTACH%' order by id asc

Edit this SQL codes however you wish, I only show dresses but you can edit this out, the only thing you need to do manually is SlotIndex in _RefShopGoods

Enjoy!