الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**ahmed mohmed** · 07-09-2014, 03:52 PM

بعد اذنكم يا شباب لما بفتح ال جلوبال منجر بيجلى الكلام الاحمر اللى تحت دا ياريت حد يقولىى على الحل

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

**MeMo@Love** · 07-09-2014, 05:04 PM

اعمل كلين للداتا بتاعتك
SRO_VT_ACCOUNT

كود:

USE [SRO_VT_ACCOUNT] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SK_gamebang_ip]( [nID] [smallint] NOT NULL, [ip] [int] NOT NULL, [capacity] [smallint] NOT NULL ) ON [PRIMARY] GO

كود:

USE [SRO_VT_ACCOUNT] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO DROP TABLE [dbo].[_PrivilegedIP] GO CREATE TABLE [dbo].[_PrivilegedIP]( [IP1] [tinyint] NOT NULL, [IP2] [tinyint] NOT NULL, [IP3] [tinyint] NOT NULL, [IP4] [tinyint] NOT NULL, [IP5] [tinyint] NOT NULL, [IP6] [tinyint] NOT NULL, [IP7] [tinyint] NOT NULL, [IP8] [tinyint] NOT NULL ) ON [PRIMARY] GO

كود:

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_SHARD

كود:

USE [SRO_VT_SHARD] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure [dbo].[_ExistsServiceOffRentItem] as if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) ) begin return -1 end GO

كود:

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]

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]

**ahmed mohmed** · 07-09-2014, 05:16 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة MeMo@Love عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

اعمل كلين للداتا بتاعتك
SRO_VT_ACCOUNT

كود:

USE [SRO_VT_ACCOUNT] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SK_gamebang_ip]( [nID] [smallint] NOT NULL, [ip] [int] NOT NULL, [capacity] [smallint] NOT NULL ) ON [PRIMARY] GO

كود:

USE [SRO_VT_ACCOUNT] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO DROP TABLE [dbo].[_PrivilegedIP] GO CREATE TABLE [dbo].[_PrivilegedIP]( [IP1] [tinyint] NOT NULL, [IP2] [tinyint] NOT NULL, [IP3] [tinyint] NOT NULL, [IP4] [tinyint] NOT NULL, [IP5] [tinyint] NOT NULL, [IP6] [tinyint] NOT NULL, [IP7] [tinyint] NOT NULL, [IP8] [tinyint] NOT NULL ) ON [PRIMARY] GO

كود:

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_SHARD

كود:

USE [SRO_VT_SHARD] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure [dbo].[_ExistsServiceOffRentItem] as if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) ) begin return -1 end GO

كود:

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]

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]

معلش يا باشا انا مش فاهم ياريت تقولى خطوات الكلين

**MeMo@Love** · 07-09-2014, 05:30 PM

هتفتح برنامج SQL و هتلاقى على الشمال اسمها New Query
هتدوس عليها و هتكت الاكواد حسب اسميها يعني هتلاقى جنب كلمة NewQuery
مستطيل صغير بينزل بقائمه فيه
SRO_VT_ACCOUNT
SRO_VT_SHARD
SRO_VT_SHARDLOG
هتختار حسب الكويري الى انت بتحطه و تحط الاكواد الى انا مدهالك بعدين تضغط على F5

**Hero** · 07-09-2014, 05:33 PM

و بعد ما تعمل كلين اتاكد من ال IP فى ال Server.cfg

**ahmed mohmed** · 07-09-2014, 05:56 PM

عملت الخطوات يا باشا واتاكدت من ip وبردوا نفس الكلام بيظهر

**Hero** · 07-09-2014, 06:05 PM

غير ال server.cfg وا لو لسة غير ال SRO_VT_ACCOUNT

**ahmed mohmed** · 07-09-2014, 06:19 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة Hero عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

غير ال server.cfg وا لو لسة غير ال SRO_VT_ACCOUNT

معلش يا باشا تعبك معايا انا عارف بس مش فاهم اغيرهم ازاى ياريت توضيح اكتر

**Hero** · 07-09-2014, 06:25 PM

على اول ملف اللى هوا ال Server.cfg اتفضل اعمل دة

كود PHP:


			
Common {
    debug_option_debugger_present{
            DEBUG_OPTION_ASSERT_SHOW_MESSAGEBOX_OKCANCEL,
            DEBUG_OPTION_ASSERT_ADVANCE_BREAK,
            DEBUG_OPTION_ASSERT_CANCEL_EXIT
    }
    debug_option_stand_alone{            
            DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
            DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
    }
    netengine_debug_option_debugger_present{
            DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
            DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
    }
    netengine_debug_option_stand_alone{
            DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
            DEBUG_OPTION_ASSERT_WRITE_MINIDUMP 
    }

}

////////////////////////////////////////////////////////////////////////////////////////////
GlobalManager {
        Certification "10.31.140.100", 32000 
        LoginFailureTolerance        3
        IBUVFailureTolerance        3
        LoginFailureBlockTimeMin    0
        IBUVFailureBlockTimeMin        0
        AutomatedPunisher            "AutomatedPunisher"
        LoginPunishmentGuide        "Blocked for 10 minutes due to incorrect password entered 3 times"
        LoginPunishmentDescription    "Blocked for 10 minutes due to incorrect password entered 3 times"
        IBUVPunishmentGuide            "Blocked for 10 minutes due to incorrect code entered 3 times"
        IBUVPunishmentDescription    "Blocked for 10 minutes due to incorrect code entered 3 times"
}

GatewayServer {
        LastFullVersion_SR_Client     130
        Certification "10.31.140.100", 15880
        IBUVQueueReserveCount        20000
        IBUVQueuePrepareRatio        0.10
        IBUVFailureIPTolerance        0
        IBUVStringSize                0
        IBUVCharacterSet            "0"
}

DownloadServer {
        Certification "10.31.140.100", 15880
}
FarmManager {
        Certification "10.31.140.100", 15880
}

AgentServer {
        Certification "10.31.140.100", 15882 //no global manager running lol
            //traffic_filter_activity     "service_off"
            //MaxUser 5000
            //SockTCPCount 15000
        MaxConnectionsPerServer         "5000"
        MaxConnectionsPer1_OServer         "5000"
}

MachineManager {
        Certification "10.31.140.100", 15880
        CERTIFICATION_IP_BIND "10.31.140.100"
}

SR_GameServer {
        Certification "10.31.140.100", 15882
        SockTCPCount                                     "5000"
        ExpRatio                                         "30000"
        ExpRatioParty                                     "35000" 
        DropItemRatio                                     "50000"
        DropGoldAmountCoef                                 "1000"
        HwanGainFactor                                     "250"
        ShowFormulaDetail                                 "1"
    
            //WINTER_EVENT_2009                            EVENT_ON
            //EUBUSINESS_EVENT                            EVENT_ON
            //GOLDEN_PIG_FEBRUARY_EVENT                    EVENT_ON
            //THANKS_GIVING_EVENT                        EVENT_ON
            //LIBERATION_EVENT                            EVENT_ON
        LOCALE                                             LOCALE_VIETNAM
       
            //#ifdef OPEN_MARKET_SYSTEM
                SET_FEE_RATE                            "0,5,5,5"
                SELL_FEE_RATE                           "0,10,10,10"
            //#endif OPEN_MARKET_SYSTEM
            //RE FTW

        DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL     "OFF"
        ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED         "OFF"


}

SR_ShardManager {
        Certification "10.31.140.100", 15882
        BILLING_SERVER_URL                 "http://10.31.140.100:8080/"
        CREST_FTP_URL                     "ftp://sss:ssss.31.140.100:1148/"
        ChristmasEvent2007                 1
        SERVER_EVENT_SYSTEM             ON
        LOCALE                             LOCALE_VIETNAM
        FlagEvent                         1
            //HourForMeterRateLevelFirst    24
            //HourForMeterRateLevelSecond    0

        BattleArenaRandom                 1
        BattleArenaParty                 1
        BattleArenaGuild                 1
        BattleArenaJob                     1
        ArenaMatchOccupy                 1
        ArenaMatchFlag                     1
        ArenaMatchPoint                 1
}

تغير بقا ال SRO_VT_ACCOUNT
بمعنى تمسح اللى فى السكول و تحمل غيرها و تحطها
و انا موجود هنا عشان اساعد حضرتك يعنى دة شغلى لحضرتك

**ahmed mohmed** · 07-09-2014, 06:31 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة Hero عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

على اول ملف اللى هوا ال Server.cfg اتفضل اعمل دة

كود PHP:


			
Common {

    debug_option_debugger_present{

            DEBUG_OPTION_ASSERT_SHOW_MESSAGEBOX_OKCANCEL,

            DEBUG_OPTION_ASSERT_ADVANCE_BREAK,

            DEBUG_OPTION_ASSERT_CANCEL_EXIT

    }

    debug_option_stand_alone{            

            DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,

            DEBUG_OPTION_ASSERT_WRITE_MINIDUMP

    }

    netengine_debug_option_debugger_present{

            DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,

            DEBUG_OPTION_ASSERT_WRITE_MINIDUMP

    }

    netengine_debug_option_stand_alone{

            DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,

            DEBUG_OPTION_ASSERT_WRITE_MINIDUMP 

    }



}



////////////////////////////////////////////////////////////////////////////////////////////

GlobalManager {

        Certification "10.31.140.100", 32000 

        LoginFailureTolerance        3

        IBUVFailureTolerance        3

        LoginFailureBlockTimeMin    0

        IBUVFailureBlockTimeMin        0

        AutomatedPunisher            "AutomatedPunisher"

        LoginPunishmentGuide        "Blocked for 10 minutes due to incorrect password entered 3 times"

        LoginPunishmentDescription    "Blocked for 10 minutes due to incorrect password entered 3 times"

        IBUVPunishmentGuide            "Blocked for 10 minutes due to incorrect code entered 3 times"

        IBUVPunishmentDescription    "Blocked for 10 minutes due to incorrect code entered 3 times"

}



GatewayServer {

        LastFullVersion_SR_Client     130

        Certification "10.31.140.100", 15880

        IBUVQueueReserveCount        20000

        IBUVQueuePrepareRatio        0.10

        IBUVFailureIPTolerance        0

        IBUVStringSize                0

        IBUVCharacterSet            "0"

}



DownloadServer {

        Certification "10.31.140.100", 15880

}

FarmManager {

        Certification "10.31.140.100", 15880

}



AgentServer {

        Certification "10.31.140.100", 15882 //no global manager running lol

            //traffic_filter_activity     "service_off"

            //MaxUser 5000

            //SockTCPCount 15000

        MaxConnectionsPerServer         "5000"

        MaxConnectionsPer1_OServer         "5000"

}



MachineManager {

        Certification "10.31.140.100", 15880

        CERTIFICATION_IP_BIND "10.31.140.100"

}



SR_GameServer {

        Certification "10.31.140.100", 15882

        SockTCPCount                                     "5000"

        ExpRatio                                         "30000"

        ExpRatioParty                                     "35000" 

        DropItemRatio                                     "50000"

        DropGoldAmountCoef                                 "1000"

        HwanGainFactor                                     "250"

        ShowFormulaDetail                                 "1"

    

            //WINTER_EVENT_2009                            EVENT_ON

            //EUBUSINESS_EVENT                            EVENT_ON

            //GOLDEN_PIG_FEBRUARY_EVENT                    EVENT_ON

            //THANKS_GIVING_EVENT                        EVENT_ON

            //LIBERATION_EVENT                            EVENT_ON

        LOCALE                                             LOCALE_VIETNAM

       

            //#ifdef OPEN_MARKET_SYSTEM

                SET_FEE_RATE                            "0,5,5,5"

                SELL_FEE_RATE                           "0,10,10,10"

            //#endif OPEN_MARKET_SYSTEM

            //RE FTW



        DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL     "OFF"

        ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED         "OFF"





}



SR_ShardManager {

        Certification "10.31.140.100", 15882

        BILLING_SERVER_URL                 "http://10.31.140.100:8080/"

        CREST_FTP_URL                     "ftp://sss:ssss.31.140.100:1148/"

        ChristmasEvent2007                 1

        SERVER_EVENT_SYSTEM             ON

        LOCALE                             LOCALE_VIETNAM

        FlagEvent                         1

            //HourForMeterRateLevelFirst    24

            //HourForMeterRateLevelSecond    0



        BattleArenaRandom                 1

        BattleArenaParty                 1

        BattleArenaGuild                 1

        BattleArenaJob                     1

        ArenaMatchOccupy                 1

        ArenaMatchFlag                     1

        ArenaMatchPoint                 1

}

تغير بقا ال SRO_VT_ACCOUNT
بمعنى تمسح اللى فى السكول و تحمل غيرها و تحطها
و انا موجود هنا عشان اساعد حضرتك يعنى دة شغلى لحضرتك

الكود اللى حضرتك كاتبه دا احطه فى ال Server.cfg notepad بدل اللى عندى مع تعديل ال ip & FTW ID& PW ? والملف التانى دا احمله منين ؟

**Hero** · 07-09-2014, 06:39 PM

اكبت على جوجل و حضرتك هتحملها
حضرتك قول مشكلتك مرة واحد عشان ال spam

**ahmed mohmed** · 07-09-2014, 06:54 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة Hero عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

اكبت على جوجل و حضرتك هتحملها
حضرتك قول مشكلتك مرة واحد عشان ال spam

اسف بس انا برد على حضرتك عشان لو بس الحل بتاع المشكلة منفعش

**Hero** · 07-09-2014, 06:58 PM

طيب تمام اللى عليك دلوقتى تعمل كل حاجة و اول ما يجيلك مشكلة تكتبها او ترفعلها صورة و اخر ما المشكلة تتحل تقول

**komnda** · 07-09-2014, 09:40 PM

بوص حضرتك حط server.cfg فى ملفات السيرفر لو مش حطو واعمل ال قال عليه استاذ hero
واتأكد من ini وافتح بالترتيب .........ز

**komnda** · 08-09-2014, 08:55 PM

ارجواا الاهتمام ......ز

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
Global Manager Error	Reflex	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	7	08-10-2019 09:56 PM
Global Manager Error	ahmed mohmed	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	5	07-10-2015 01:07 PM
Global Manager Error	MohamedD3vil	قسم المواضيع المكررة و المخالفة	3	27-02-2014 02:55 AM
hELP IN global manager	.a7la-smile.	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	4	30-01-2013 05:14 PM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	حفظ بياناتي ؟