Neler yeni

Vsro Tüm Uniquelerin Eliteleri Kaldırmak(Query)

admin

Joymax Family
Forum Yöneticisi
Aileden Biri
Joymax Amiral
Katılım
5 Şub 2021
Mesajlar
90
Tepkime puanı
38
Puanları
118
Ülke
TÜRKİYE
Ad
JoymaxTR
Soyad
Family
Discord
JoymaxTR#7857
Kod:
- MOB_CH_TIGERWOMAN
- MOB_CH_TIGERWOMAN_L3
- MOB_EU_KERBEROS
- MOB_EU_KERBEROS_L3
- MOB_AM_IVY
- MOB_AM_IVY_L3
- MOB_OA_URUCHI
- MOB_OA_URUCHI_L3
- MOB_KK_ISYUTARU
- MOB_KK_ISYUTARU_L3
- MOB_TK_BONELORD
- MOB_TK_BONELORD_L3
- MOB_RM_TAHOMET
- MOB_RM_TAHOMET_L3

Query
Kod:
USE SRO_VT_SHARD

declare @uniq1 varchar (64) = 'MOB_CH_TIGERWOMAN_L3' -- skilleri alınacak
declare @UniQ2 varchar (64) = 'MOB_CH_TIGERWOMAN' -- skilleri değişecek
declare @id1 int = (select link from _RefObjCommon where CodeName128 = @uniq1)
declare @id2 int = (select link from _RefObjCommon where CodeName128 = @UniQ2)
declare @skill1 int = (select DefaultSkill_1 from _RefObjChar where ID = @id1)
declare @skill2 int = (select DefaultSkill_2 from _RefObjChar where ID = @id1)
declare @skill3 int = (select DefaultSkill_3 from _RefObjChar where ID = @id1)
declare @skill4 int = (select DefaultSkill_4 from _RefObjChar where ID = @id1)
declare @skill5 int = (select DefaultSkill_5 from _RefObjChar where ID = @id1)
declare @skill6 int = (select DefaultSkill_6 from _RefObjChar where ID = @id1)
declare @skill7 int = (select DefaultSkill_7 from _RefObjChar where ID = @id1)
declare @skill8 int = (select DefaultSkill_8 from _RefObjChar where ID = @id1)
declare @skill9 int = (select DefaultSkill_9 from _RefObjChar where ID = @id1)
declare @skill10 int = (select DefaultSkill_10 from _RefObjChar where ID = @id1)




update _RefObjChar set
DefaultSkill_1 = @skill1,
DefaultSkill_2 = @skill2,
DefaultSkill_3 = @skill3,
DefaultSkill_4 = @skill4,
DefaultSkill_5 = @skill5,
DefaultSkill_6 = @skill6,
DefaultSkill_7 = @skill7,
DefaultSkill_8 = @skill8,
DefaultSkill_9 = @skill9,
DefaultSkill_10 = @skill10 where ID=@id2
 
Üst