Kullanıcı:
Filtreler
Neler yeni
Neler yeni
Neler yeni

Foruma hoş geldin 👋, Ziyaretçi

Forum içeriğine ve tüm hizmetlerimize erişim sağlamak için foruma kayıt olmalı ya da giriş yapmalısınız. Foruma üye olmak tamamen ücretsizdir.

Giriş yap Şimdi kayıt ol
Hipopotamya Güzel Ajans
Banner 1 Banner 2 Banner 3 Banner 4 Banner 5 Banner 6

Bilgi vSRO Kale Savaşı Fix Prosedür

Bilgi
ForumKolik

ForumKolik

Roc
Arena Üyesi
Katılım
9 May 2023
Mesajlar
174
Tepkime puanı
515
Puanları
0
[YETKİLİ] Moderatör 100. Mesaj 50. Mesaj
Merhabalar, bildiğiniz üzere kale savaşı fix adı altında onlarca paylaşım var, paylaşımların hemen hemen hepsi doğru ve geçerli fakat kimse tam olarak ne yaptığını bilmeden prosedürü okutup geçiyor.

vSRO Kale savaşı fixleme prosedürümüz, oyundaki tüm kaleleri ve kale objelerini(kapılar,kalp vs) siliyor ve yeniden orjinal hali ile ekliyor.

Kod: 
SQL:
use SRO_VT_SHARD
go
truncate table _SiegeFortressStruct
delete from _SiegeFortress

insert into _SiegeFortress values (1,0,0,0,0,0,NULL,NULL,0,1)
insert into _SiegeFortress values (3,0,0,0,0,0,NULL,NULL,0,1)
insert into _SiegeFortress values (6,0,0,0,0,0,NULL,NULL,0,1)

insert into _SiegeFortressStruct values (1,0,84,19538,936000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,85,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,86,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,87,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,88,19504,936000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,89,19504,936000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,90,19504,936000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,91,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,92,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,93,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,94,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,95,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,96,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,97,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,98,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,99,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,100,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,101,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,102,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,103,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,104,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,105,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,106,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,108,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,127,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,128,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,129,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,130,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,131,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,132,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,133,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,134,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,135,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,136,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,180,19610,936000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,181,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,182,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,183,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,184,19575,936000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,185,19575,936000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,186,19575,936000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,187,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,188,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,189,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,190,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,191,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,192,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,193,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,194,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,195,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,196,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,197,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,198,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,199,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,200,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,201,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,202,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,224,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,225,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,226,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,227,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,228,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,229,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,230,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (3,0,231,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,137,19625,464000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,138,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,139,19521,464000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,140,19590,464000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,141,19590,464000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,142,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,143,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,144,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,145,19509,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,146,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,147,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,148,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,149,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,150,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,151,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,152,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,153,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,154,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,155,19515,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,172,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,173,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,174,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,175,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,176,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,177,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,178,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (6,0,179,19543,0,getdate(),0)
insert into _SiegeFortressStruct values (1,0,118,19641,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,221,23934,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,117,19641,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,116,19642,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,124,19642,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,126,19550,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,114,19641,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,113,19641,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,222,23934,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,122,19643,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,220,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,121,19643,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,215,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,120,19643,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,213,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,119,19643,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,112,19641,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,211,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,111,19641,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,210,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,115,19642,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,123,19642,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,219,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,217,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,110,19643,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,218,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,216,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (1,0,109,19643,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,214,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,212,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,223,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,209,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,208,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,207,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,167,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,206,23933,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,171,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,205,23933,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,204,23933,80000,getdate(),0)
insert into _SiegeFortressStruct values (3,0,203,23933,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,169,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,168,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,166,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,156,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,162,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,163,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,164,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,165,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,170,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,161,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,157,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,160,19640,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,158,23932,80000,getdate(),0)
insert into _SiegeFortressStruct values (6,0,159,23932,80000,getdate(),0)
 
Cevap yazmak için giriş yap yada kayıt ol.

Foruma hoş geldin 👋, Ziyaretçi

Forum içeriğine ve tüm hizmetlerimize erişim sağlamak için foruma kayıt olmalı ya da giriş yapmalısınız. Foruma üye olmak tamamen ücretsizdir.

Giriş yap Şimdi kayıt ol