الموقع العربي الاول للعبة Silkroad Online
صفحة 1 من 2 1 2
عرض 40 مشاركات من هذا الموضوع لكل صفحة

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   global manager Error (https://silkroad4arab.com/vb/showthread.php?t=565948)

ahmed mohmed 07-09-2014 03:52 PM
global manager Error
 
بعد اذنكم يا شباب لما بفتح ال جلوبال منجر بيجلى الكلام الاحمر اللى تحت دا ياريت حد يقولىى على الحل


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 (المشاركة 5103004)
اعمل كلين للداتا بتاعتك
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 (المشاركة 5103071)
غير ال 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 (المشاركة 5103085)
على اول ملف اللى هوا ال 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 (المشاركة 5103091)
اكبت على جوجل و حضرتك هتحملها
حضرتك قول مشكلتك مرة واحد عشان ال 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
ارجواا الاهتمام ......ز :mf_follow: :angry2:


الساعة الآن 04:40 AM.
صفحة 1 من 2 1 2
عرض 40 مشاركات من هذا الموضوع لكل صفحة

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.