[Release] How to find missing avatars

[theminkman]

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

-- RefShopGoods
SELECT 1, 15, 'MALL_AVATAR_DRESS', 'PACKAGE_'+CodeName128, 0, -1, '***', -1, '***', -1, '***', -1, '***' 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, '***', -1, '***', -1, '***', -1, '***' 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, '***', -1, '***', -1, '***', -1, '***' 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, '***', -1, '***', -1, '***', -1, '***', 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!

[Bocc1337]

Be car full adding to many items to the item mall. you will get a item mall crash.

[hoangphan7]

Originally Posted by Bocc1337

Be car full adding to many items to the item mall. you will get a item mall crash.

Press F10 and you get nothing :v nothing appear :v both sro_client )

[Mr.Awesome1337]

I've been searching them manually, that's very useful, thank you.

[theminkman]

Originally Posted by Mr.Awesome1337

I've been searching them manually, that's very useful, thank you.

No problem, I was doing the same way.