Çevrimdışı
MOD
Bölüm Görevlisi
Merhaba arkadaşlar herkese iyi forumlar dilerim.Paylaşacağım query ile 110 cap fgw içerisindeki mob damagelerini ayarlayabilirsiniz.
Query içerisinde
ÖNEMLİ NOT : İşlem yapmadan önce muhakkak SHARD yedeği alın.
Query içerisinde
set Param5/=1.5,Param6/=1.5 yazan kısımda /=1.5 değerini kendinize göre değiştirerek okutunuz.ÖNEMLİ NOT : İşlem yapmadan önce muhakkak SHARD yedeği alın.
SQL:
[B]FGW Grade 1[/B]
UPDATE SRO_VT_SHARD.._RefSkill set Param5/=1.5,Param6/=1.5 where ID IN(32591,32599,32607,32615,32623,32631,32639,32647,32655,32663,32671,32679,32687,32695,32703,32711,32719,32727
,32735,32743,32751,32759,32767,32775,32783,32791,32799,32831,32839,32847,32855,32863) and Param2=6386804
[B]FGW Grade 2[/B]
UPDATE SRO_VT_SHARD.._RefSkill set Param5/=1.3,Param6/=1.3 where ID IN (32592,32616,32640,32664,32688,32712,32736,32760,32784,32872,32832,32600,32624,32648,32672,32696,32720,32744,32768,32792,32608,32632,32656,32680,32704,32728,32752,32776,32800,32840,32848,32856,32864)
and ID NOT IN(32591,32599,32607,32615,32623,32631,32639,32647,32655,32663,32671,32679,32687,32695,32703,32711,32719,32727
,32735,32743,32751,32759,32767,32775,32783,32791,32799,32831,32839,32847,32855,32863) and Param2=6386804
[B]FGW Grade 3[/B]
UPDATE SRO_VT_SHARD.._RefSkill set Param5/=1.3,Param6/=1.3 where ID IN (32593,32617,32641,32665,32689,32713,32737,32761,32785,32873,32601,32625,32649,32673,32697,32721,32745,32769,32793,32609,32633,32657,32681,32705,32729,32753,32777,32801,32833,32841,32849,32857,32865)
and ID NOT IN(32591,32599,32607,32615,32623,32631,32639,32647,32655,32663,32671,32679,32687,32695,32703,32711,32719,32727
,32735,32743,32751,32759,32767,32775,32783,32791,32799,32831,32839,32847,32855,32863,32592,32616,32640,32664,32688,32712,32736,32760,32784,32872,32832,32600,32624
,32648,32672,32696,32720,32744,32768,32792,32608,32632,32656,32680,32704,32728,32752,32776,32800,32840,32848,32856,32864) and Param2=6386804
[B]FGW Grade 4[/B]
UPDATE SRO_VT_SHARD.._RefSkill set Param5/=1.4,Param6/=1.3 where ID IN (32594,32618,32642,32666,32690,32714,32738,32762,32786,32602,32626,32650,32674,32698,32722,32746,32770,32794,32610,32634,32658,32682,32706,32730,32754,32778,32802,32834,32842,32850,32858,32866)
and ID NOT IN(32591,32599,32607,32615,32623,32631,32639,32647,32655,32663,32671,32679,32687,32695,32703,32711,32719,32727
,32735,32743,32751,32759,32767,32775,32783,32791,32799,32831,32839,32847,32855,32863,32592,32616,32640,32664,32688,32712,32736,32760,32784,32872,32832,32600,32624
,32648,32672,32696,32720,32744,32768,32792,32608,32632,32656,32680,32704,32728,32752,32776,32800,32840,32848,32856,32864,
32593,32617,32641,32665,32689,32713,32737,32761,32785,32873,32601,32625,32649,32673,32697,32721,32745,32769,32793,32609,32633,32657,32681,32705,32729,32753,32777,32801,32833,32841,32849,32857,32865) and Param2=6386804