vSRO Çözüldü VSRO Attack Pet / Fellow Pet Calıştırdığın zaman Disconnect from the Server

xtreme50

.
Aktiflik: 1%
Şovalye 1 Mesaj
Katılım
6 Kas 2021
Mesajlar
38
Tepkime puanı
28
Puan
18
Yaş
49
Konum
Angara
Thread owner
Evet Arkadaşlar

Bazen Internet´den araştırsan bile bir yöntem bulsan denesen bile Attack Pet veya Fellow Petler DC yediriyor. Bunun bir çözümünü buldum.

Ben Aşadaki yüklediğim Fotoraf gibi sildim Server´i yeniden başlatmısdım henüz yine DC veriyordu.

Uğraşdığım Yöntem:
12121212.jpg



Ondan sonra aklıma gelen Database´deki Moblar baya aşdi. Aklıma bir fikir geldi ve Mob sayısını indirdim. Ardından yeniden Clean DB yapip yeninden denedim ve artık Attack Pet Olsun veya Fellow Pet Olsun DC vermiyor.

Yapacanız işlem bu:


USE SRO_VT_SHARD
UPDATE Tab_RefNest SET dwmaxtotalcount=dwmaxtotalcount/2
WHERE dwTacticsID NOT BETWEEN 41000 AND 43860
AND dwTacticsID NOT BETWEEN 32100 AND 32800


Öncelikle Sizlere Tavsiye ederim: --> ( Eger Tabiki Database´i yeni kurduysaniz Tavsiye ederim )

~~~Clean DB~~~


SRO_VT_ACCOUNT:


USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[__SiegeFortressStatus__]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[_ShardCurrentUser]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[SK_DownLevelLog]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_partnerInfo]
TRUNCATE TABLE [dbo].[tb_paygate_trans]
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[Test_HN]
UPDATE [dbo].[_ShardService] SET ShardID = '64'


SRO_VT_LOG:

USE [SRO_VT_LOG]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]


SRO_VT_SHARD:

USE [SRO_VT_SHARD]
GO
TRUNCATE TABLE [dbo].[_Chest]
TRUNCATE TABLE [dbo].[_ChestInfo]
TRUNCATE TABLE [dbo].[_User]
TRUNCATE TABLE [dbo].[_OpenMarket]
DELETE FROM [dbo].[_AccountJID]
TRUNCATE TABLE [dbo].[_GuildWar]
TRUNCATE TABLE [dbo].[_GuildMember]
TRUNCATE TABLE [dbo].[_GuildChest]
TRUNCATE TABLE [dbo].[_SiegeFortressStruct]
TRUNCATE TABLE [dbo].[_SiegeFortressObject]
TRUNCATE TABLE [dbo].[_SiegeFortressItemForge]
DELETE FROM [dbo].[_SiegeFortress]
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (1)
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (3)
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (6)
UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0'
DELETE FROM [dbo].[_Guild] WHERE ID > 0
DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0
TRUNCATE TABLE [dbo].[_InventoryForAvatar]
TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint]
TRUNCATE TABLE [dbo].[_BlockedWhisperers]
TRUNCATE TABLE [dbo].[_TrainingCampMember]
TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade]
DELETE FROM [dbo].[_CharTrijob] WHERE CharID > 0
TRUNCATE TABLE [dbo].[_TimedJob]
TRUNCATE TABLE [dbo].[_StaticAvatar]
TRUNCATE TABLE [dbo].[_Inventory]
TRUNCATE TABLE [dbo].[_Memo]
TRUNCATE TABLE [dbo].[_FleaMarketNetwork]
TRUNCATE TABLE [dbo].[_Friend]
TRUNCATE TABLE [dbo].[_CharSkillMastery]
TRUNCATE TABLE [dbo].[_CharSkill]
TRUNCATE TABLE [dbo].[_InvCOS]
DELETE FROM [dbo].[_CharCOS] WHERE ID > 0
DELETE FROM [dbo].[_Char] WHERE CharID > 0
TRUNCATE TABLE [dbo].[_CharCollectionBook]
TRUNCATE TABLE [dbo].[_CharInstanceWorldData]
TRUNCATE TABLE [dbo].[_CharNameList]
TRUNCATE TABLE [dbo].[_CharNickNameList]
TRUNCATE TABLE [dbo].[_CharQuest]
TRUNCATE TABLE [dbo].[_ClientConfig]
TRUNCATE TABLE [dbo].[_DeletedChar]
TRUNCATE TABLE [dbo].[_GPHistory]
TRUNCATE TABLE [dbo].[_InventoryForLinkedStorage]
TRUNCATE TABLE [dbo].[_ItemPool]
DELETE FROM [dbo].[_Items] WHERE ID64 > 0
TRUNCATE TABLE [dbo].[_Skill_BaoHiem_TNET]
TRUNCATE TABLE [dbo].[_TimedJobForPet]
TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus]
TRUNCATE TABLE [dbo].[_TrainingCampHonorRank]
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50)
EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]
DELETE FROM [dbo].[_TrainingCamp]
TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution]
TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution]
TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderContribution]
 

Bu konuyu görüntüleyen kullanıcılar

Geri
Üst Alt