CSROR - Fix Unique Attack Damage (SQL Query)

[PX2000]

I think this csro-r db was used for GNGWC or idk cuz unique skill (some params) are higher than than SRO_VT_SHARD..

Anyways here is a example query on how to copy skill param from SRO_VT_SHARD to SROR_CH_SHARD..

UPDATE SKILL1 SET
SKILL1.Param1 = SKILL2.Param1,
SKILL1.Param2 = SKILL2.Param2,
SKILL1.Param3 = SKILL2.Param3,
SKILL1.Param4 = SKILL2.Param4,
SKILL1.Param5 = SKILL2.Param5,
SKILL1.Param6 = SKILL2.Param6,
SKILL1.Param7 = SKILL2.Param7,
SKILL1.Param8 = SKILL2.Param8,
SKILL1.Param9 = SKILL2.Param9,
SKILL1.Param10 = SKILL2.Param10
FROM SRO_R_GAME01.dbo._RefSkill SKILL1
INNER JOIN SRO_GAME01.dbo._RefSkill SKILL2 ON SKILL1.ID = SKILL2.ID
WHERE SKILL1.Basic_Code LIKE '[B]MSKILL_TK_BONELORD_ATTACK[/B]%'
GO

SRO_R_GAME01 = SROR_CH_SHARD
SRO_GAME01 = SRO_VT_SHARD


Hope it may help u to buy some time.

 

[CoderWaxy]

UPDATE SKILL1 SET
SKILL1.Param1 = SKILL2.Param1,
SKILL1.Param2 = SKILL2.Param2,
SKILL1.Param3 = SKILL2.Param3,
SKILL1.Param4 = SKILL2.Param4,
SKILL1.Param5 = SKILL2.Param5,
SKILL1.Param6 = SKILL2.Param6,
SKILL1.Param7 = SKILL2.Param7,
SKILL1.Param8 = SKILL2.Param8,
SKILL1.Param9 = SKILL2.Param9,
SKILL1.Param10 = SKILL2.Param10,
SKILL1.Param11 = SKILL2.Param11,
SKILL1.Param12 = SKILL2.Param12,
SKILL1.Param13 = SKILL2.Param13,
SKILL1.Param14 = SKILL2.Param14,
SKILL1.Param15 = SKILL2.Param15,
SKILL1.Param16 = SKILL2.Param16,
SKILL1.Param17 = SKILL2.Param17,
SKILL1.Param18 = SKILL2.Param18,
SKILL1.Param19 = SKILL2.Param19,
SKILL1.Param20 = SKILL2.Param20,
SKILL1.Param21 = SKILL2.Param21,
SKILL1.Param22 = SKILL2.Param22,
SKILL1.Param23 = SKILL2.Param23,
SKILL1.Param24 = SKILL2.Param24,
SKILL1.Param25 = SKILL2.Param25,
SKILL1.Param26 = SKILL2.Param26,
SKILL1.Param27 = SKILL2.Param27,
SKILL1.Param28 = SKILL2.Param28,
SKILL1.Param29 = SKILL2.Param29,
SKILL1.Param30 = SKILL2.Param30,
SKILL1.Param31 = SKILL2.Param31,
SKILL1.Param32 = SKILL2.Param32,
SKILL1.Param33 = SKILL2.Param33,
SKILL1.Param34 = SKILL2.Param34,
SKILL1.Param35 = SKILL2.Param35,
SKILL1.Param36 = SKILL2.Param36,
SKILL1.Param37 = SKILL2.Param37,
SKILL1.Param38 = SKILL2.Param38,
SKILL1.Param39 = SKILL2.Param39,
SKILL1.Param40 = SKILL2.Param40,
SKILL1.Param41 = SKILL2.Param41


FROM SR_R_Shard1.dbo._RefSkill SKILL1
INNER JOIN SRO_VT_SHARD.dbo._RefSkill SKILL2 ON SKILL1.ID = SKILL2.ID
WHERE SKILL1.Basic_Code LIKE 'MSKILL_SD_%_ATTACK%'

You want more params for edit on all uniques
i tested your query without my edit give me param value unknown

 

[hamzafigo]

Thanks gonna try that. But u mean copy the parms from any other dbs right ?



Ty fixed (Y)