الموقع العربي الاول للعبة Silkroad Online

- قسم المواضيع المكررة و المخالفة (https://silkroad4arab.com/vb/forumdisplay.php?f=58)

- - مشكله بسيطه (https://silkroad4arab.com/vb/showthread.php?t=514037)

مشكله بسيطه

انا عندي ملفات السيرفر كلها بتفتح بس الملفين دول
9. SR_ShardManager
10. SR_GameServer

مش بينورو خالص

http://www7.0zz0.com/2013/07/12/12/203053260.png

http://www7.0zz0.com/2013/07/12/12/649594262.png

خطأك اكيد من حاجه من دول
DB CONNECT
INI Files
هات الكلام اللى مكتوب جواه

اتاكد من ملفاتiniوحاطت اسم sqlrxpressصح

واه صح اتاكد فى ملفsr_SHARD فى ملفاتiniافتحو لو لقيت الفيل كدة غير للهقولك عليةSRO_VT_LOGغيرو لىSRO_VT_SHARDLOG

كود PHP:

USE [SRO_VT_SHARD] GO truncate table _OpenMarket print 'Cleaned _OpenMarket' truncate table _CharSkill print 'Cleaned _CharSkill' truncate table _CharSkillMastery print 'Cleaned _CharSkillMastery' truncate table _GuildMember print 'Cleaned _GuildMember' truncate table _BlockedWhisperers print 'Cleaned _BlockedWhisperers' truncate table _Inventory print 'Cleaned _Inventory' truncate table _InventoryForAvatar print 'Cleaned _InventoryForAvatar' truncate table _InventoryForLinkedStorage print 'Cleaned _InventoryForLinkedStorage' truncate table _TrainingCampMember print 'Cleaned _TrainingCampMember' truncate table _TrainingCampSubMentorHonorPoint print 'Cleaned _TrainingCampSubMentorHonorPoint' update _TrainingCampHonorRank set CampID = NULL, Rank = NULL print 'Cleaned _TrainingCampHonorRank' truncate table _TrainingCampBuffStatus print 'Cleaned _TrainingCampBuffStatus' delete from _TrainingCamp print 'Cleaned _TrainingCamp' truncate table _StaticAvatar print 'Cleaned _StaticAvatar' truncate table _User print 'Cleaned _User' truncate table _Friend print 'Cleaned _Friend' truncate table _Memo print 'Cleaned _Memo' truncate table _TimedJob print 'Cleaned _TimedJob' truncate table _CharTrijobSafeTrade print 'Cleaned _CharTrijobSafeTrade' delete from _CharTrijob print 'Cleaned _CharTrijob' truncate table _InvCOS print 'Cleaned _InvCOS' delete from _CharCOS where ID > 0 print 'Cleaned _CharCOS' delete from _Char where charid > 0 print 'Cleaned _Char' truncate table _Chest print 'Cleaned _Chest' truncate table _ChestInfo print 'Cleaned _ChestInfo' truncate table _ItemPool print 'Cleaned _ItemPool' delete from _Items where ID64 > 0 print 'Cleaned _Items' delete from _AccountJID print 'Cleaned _AccountJID' update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0 print 'Cleaned _AlliedClans' truncate table _GuildWar print 'Cleaned _GuildWar' truncate table _CharNameList print 'Cleaned _CharNameList' truncate table _CharQuest print 'Cleaned _CharQuest' truncate table _ClientConfig print 'Cleaned _ClientConfig' truncate table _DeletedChar print 'Cleaned _DeletedChar' truncate table _SiegeFortressStoneState print 'Cleaned _SiegeFortressStoneState' truncate table _SiegeFortressRequest print 'Cleaned _SiegeFortressRequest' truncate table _SiegeFortressObject print 'Cleaned _SiegeFortressObject' truncate table _SiegeFortressItemForge print 'Cleaned _SiegeFortressItemForge' truncate table _SiegeFortressBattleRecord print 'Cleaned _SiegeFortressBattleRecord' update _SiegeFortressStruct SET OwnerGuildID = '0' print 'Cleaned _SiegeFortressStruct' UPDATE _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL print 'Cleaned _SiegeFortress' truncate table _CharNickNameList print 'Cleaned _CharNickNameList' truncate table _GPHistory print 'Cleaned _GPHistory' truncate table _GuildChest print 'Cleaned _GuildChest' delete from _Guild where ID > 0 print 'Cleaned _Guild' delete from _AlliedClans where ID > 0 print 'Cleaned _AlliedClans'

اتـاكد ان اسـامى الداتابيز كدة

SRO_VT_ACCOUNT
SRO_VT_SHARD
SRO_VT_SHARDLOG

ودى الـصيغة الصحيحة لـ DBConnect

كود PHP:


		
			
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=You-PC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=SQLPw;"
DBConnA.Open strConnectA

%>

مشكله بسيطه

ده المكتوب في ملف DB Connect

http://www11.0zz0.com/2013/07/13/16/912870436.png

ودي صوره من العبه

http://www11.0zz0.com/2013/07/13/16/888107527.png

ياريت الحل بليز

فى الـ SMC Server Control
دوس Start All Service

عملت كده والله

ياريت حد يخش تيم فيور يحل المشكله دي

ده الياهو بتاعي [email protected]:punk::punk::busted_blue::busted_blue:

وشكرا

يا باشا اول مشكلة عاندك فى Sr.Shardmanger اتاكد من الملفات دية كويس المشكلة منهومـ
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=sa;password=PW-SQL;"
DBConnA.Open strConnectA

%>

SrGlobalService

كود PHP:


		
			
[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=Name-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=PW-SQL;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697

SrNodeType

كود PHP:


		
			
[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=Your IP Here
nip=Your IP Here
machine_manager_node_id=699

SrShard

كود PHP:


		
			
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=scorpion sro
query=DRIVER={SQL Server};SERVER=Name-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=Pw-SQL;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=Name-PC\SQLEXPRESS;DSN=SRO_VT_SHARDLOG;UID=sa;PWD=PW-SQL;DATABASE=SRO_VT_SHARDLOG
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

حمل دة و حطو مكان اللى عاندك بس عدل علية http://files.fm/down.php?i=ftffasu&n...ternalTest.rar

ممكن حطرتك تخوش تيم فيور تحلهالي

حملت الملف وعدلت عليه ونفس المشكله بردو