الموقع العربي الاول للعبة Silkroad Online - يا ريت حل او اى واحد يجى فيفر

- - يا ريت حل او اى واحد يجى فيفر (https://silkroad4arab.com/vb/showthread.php?t=563924)

يا ريت حل او اى واحد يجى فيفر

افتح ملفات ini ملف اسمو Srshard اتاكد ان بيانت sql موجود فيه صح

ورح C >input>wwwort >DbConnect اتاكد ان ملف dbconnect بيانات sql مكتوب فيه صح و اتاكد من odbc

اعمل كلين
و اتاكد من ال DbConnect
الصيغة الصحيحة

كود PHP:


		
			
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=Name-PC\SQLExpress;Initial Catalog=SRO_VT_ACCOUNT;user ID=CGI;password=CGI4Test;"
DBConnA.Open strConnectA

%>

والله كولو صح والله

هيرو تعالا فيفر او فيس مستنيك:sad2:

بص يا باشا مشكلتك ديه سهلة بس انت صحصح

فى مشكلة فى account db يعنى account db مش متعرف و مش محطوط صح تمام

افتح Ini و اتاكد من كل حاجة ممكن يكون فى space عملة مشكلة و هات صورة لى SQL لى db account

وصورة من db connect

وصورة من ini

srGlobalService
SrShard

هنا المشكلة 95 % من ini

ما تيجى فيفر :S

حضرتك الــ DBConnect غلط !!

خد لي hero قالك عليها و حطها و عدل و جرب !! :cool2:

صورة بعد التعديل و بردو نفس الكلام
http://up.3dlat.com/uploads/3dlat.com_14083298881.png

طيب اعمل كلين و اتاكد من ال odbc

انا هتجنن كولو با الصور اهو
http://up.3dlat.com/uploads/3dlat.com_14083305961.png
:twisted:

اولا شوف ال 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



%>

و اعمل كلينت للـ DB
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_SHARDLOG

كود:

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 افتح ياهوووو انا موتاكد

الهما يا رجاله ونبى :groupwave:

باردو يا ميمو محدش عارف الحل ؟؟؟؟؟ :sad2::sad2::sad2::sad2:

بلاش spam
وهات صوره من server.cfg
واـأكد احر مره من ini and db .conn

اعمل UP كل 24 ساعة :]

حضرتك استخدم الـ 3 كيوري دول ::.

كود PHP:


		
			
USE [SRO_VT_ACCOUNT]---By=M$ KoKTeL

GO

TRUNCATE TABLE [dbo].[TB_User]

TRUNCATE TABLE [dbo].[TB_User_Bak]

TRUNCATE TABLE [dbo].[SK_CharRenameLog]

TRUNCATE TABLE [dbo].[_Punishment]

TRUNCATE TABLE [dbo].[_ServiceManagerLog]

TRUNCATE TABLE [dbo].[Test_HN]

TRUNCATE TABLE [dbo].[_BlockedUser]

TRUNCATE TABLE [dbo].[_CasGMChatLog]

TRUNCATE TABLE [dbo].[_Notice]

TRUNCATE TABLE [dbo].[_SMCLog]

TRUNCATE TABLE [dbo].[QuaySoEpoint]

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_SilkGoods]

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_paygate_trans]

TRUNCATE TABLE [dbo].[_ShardCurrentUser]

TRUNCATE TABLE [dbo].[_PrivilegedIP]

و دي

كود PHP:


		
			
USE [SRO_VT_SHARD]---By=M$ KoKTeL

GO

truncate table _CharCollectionBook

truncate table _OpenMarket

truncate table _CharSkill

truncate table _CharSkillMastery

truncate table _GuildMember

truncate table _BlockedWhisperers

truncate table _Inventory

truncate table _InventoryForAvatar

truncate table _InventoryForLinkedStorage

truncate table _TrainingCampMember

truncate table _TrainingCampSubMentorHonorPoint

truncate table _TrainingCampHonorRank

truncate table _TrainingCampBuffStatus

delete from _TrainingCamp

truncate table _StaticAvatar

truncate table _User

truncate table _Friend

truncate table _GPHistory

truncate table _Memo

truncate table _TimedJob

truncate table _CharTrijobSafeTrade

delete from _CharTrijob

truncate table _InvCOS

delete from _CharCOS where ID > 0

delete from _Char where charid > 0

truncate table _Chest

truncate table _ChestInfo

truncate table _ItemPool

delete from _Items where ID64 > 0

delete from _AccountJID

truncate table _GuildChest

update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0

truncate table _GuildWar

delete from _Guild where ID > 0

delete from _AlliedClans where ID > 0

truncate table _CharNameList

truncate table _CharQuest

truncate table _ClientConfig

truncate table _DeletedChar

truncate table _SiegeFortressStruct

truncate table _SiegeFortressStoneState

truncate table _SiegeFortressRequest

truncate table _SiegeFortressObject

truncate table _SiegeFortressItemForge

truncate table _SiegeFortressBattleRecord

delete from _SiegeFortress

truncate table Guncel_Unique

truncate table UniqueRanking

truncate table Uniques

ودي بس هتغير Log_DB لـ SRO_VT_SHARDLOG

كود PHP:


		
			
USE [Log_DB]

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]

بعد كده هتروح الـ Table < _PrivilegedIP > Edit All Arrows > and add ur ip

حضرتك عملت كده و دى صورة من ال server,cfg و ال DB.Connect
http://up.3dlat.com/uploads/3dlat.com_14084150481.png
http://up.3dlat.com/uploads/3dlat.com_14084150482.png

بص يا باشا ياريت تتأكد من ال Server.cfg و الصيغة بتاعته دى أول حاجة تانى حاجة اتأكد من ال DB Connect تالت حاجة هات صورة من ال wwwroot

حط server.cfg غير اللى انت شغال بيها

هو عموما مشكلتك دى بسبب حاجة من دول

1- ملفات ال INI المعلومات اللى فيها غلط

2- ان حضرتك مسحت الملفات اللى بتكون موجودة فى ال wwwroot قبل ما تحط ملفات السيرفر بيبقى فى ملفات تانية ممكن تكون انت مسحتها

3- ال Server.cfg فيه حاجة غلط

4- ألمعلومات اللى فى ال DB Connect غلط

خد يا معلم ال Ini اللى عندى شغالة 100% غير بس المعلومات

http://www.gulfup.com/G.png

و باس ورد ايه

باشا حط server.cfg ديه بدل العندك وعدل على الايبى
http://files.fm/u/juytlhd

تم الحل بواسط MeMo@Love <3333333333333333333 والله بطل و تستحق المدير ##