الموقع العربي الاول للعبة Silkroad Online - وين المشرفين نريد حل للGolbalManager

اول حاجه فيه مشكلتين اولها ال DBConnect
و ده ليها مشاكل عديده منها انك ممكن تكون عامل الصيغة غلط و ديه الصيغة الصح

كود:

<%

Dim DBConnA, strConnectA

Set DBConnA = Server.CreateObject("ADODB.Connection")

strConnectA = "Provider=SQLOLEDB;Data Source=MEMO-PC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=123456789;"

DBConnA.Open strConnectA



%>

ثانيا ممكن متكونش عامل ال odbc صح
و المشكلة التانيه ان الداتا بيس فيها حاجه غلط و لازم تعملها Clean
و ده الكلين
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_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



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]

و الى ميتعملش معاك فى SQL مش مشكلة