[RELEASE]Mage/Assassin's Cape Fix

[XareL]

English
Hi Epvpers,
I saw a problem while surfing in Shstudio and wanted to share this problem and workaround with you.

I am using the older version of shstudio because of the incompatibility of the .sdata font I'm using.

When you click on a cloak that has not been edited in sh studio, the country section changes. this only applies Mage/Assasin's cape


and i find workaround fix
I Created sql version!




Query

/* Shaiya Mage & Assasin Cape Fix */

/* Created by XareL, 2018-04-01 */

/* For AoL - Mage Cape (if u add more just copy and paste and u know itemid) */

/**************************************************************/
SET NOCOUNT ON

USE PS_GameDefs;
GO

BEGIN

UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24066'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24069'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24180'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24181'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24182'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24183'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24184'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24185'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24186'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24187'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24188'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24241'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24242'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24243'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24244'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24253'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24254'
/**************************************************************/

/* For UoF - Assasin Cape (if u add more just copy and paste and u know itemid) */

/**************************************************************/
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39068'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39086'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39087'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39088'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39089'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39090'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39091'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39092'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39093'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39094'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39095'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39096'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39097'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39098'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39099'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39065'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39101'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39103'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39118'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39155'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39156'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39157'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39158'
UPDATE PS_GameDefs.dbo.Items SET Country='5' WHERE ItemID='39169'
/**************************************************************/


PRINT 'Problem has been fixed!'
PRINT 'must be executed each time when item.sql it is updated!'
PRINT 'Created by Xarel / ShaiyaDestek!'
END


GO

Regards,

[beetols]

Is enough all the times you open a cape set the country back to light or dark without run this quey all times u update item.sdata.

[SnickQ]

UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24066'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24069'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24180'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24181'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24182'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24183'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24184'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24185'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24186'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24187'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24188'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24241'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24242'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24243'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24244'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24253'
UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID='24254'
/************************************************** ************/

Is much easier and faster to do this when you use 'in' in query : D

UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID in (24066,24069, 24180, 24181, 24182, 24183, 24184, 24185, 24186, 24187, 24188, 24241, 24242, 24243, 24244, 24253, 24254)

[XareL]

Originally Posted by SnickQ

Is much easier and faster to do this when you use 'in' in query : D

UPDATE PS_GameDefs.dbo.Items SET Country='2' WHERE ItemID in (24066,24069, 24180, 24181, 24182, 24183, 24184, 24185, 24186, 24187, 24188, 24241, 24242, 24243, 24244, 24253, 24254)

Thanks for feedback.
but I'm new to these issues
and this problem has been common in recent times.