™_Muslim_™
15-04-2013, 10:13 PM
http://www13.0zz0.com/2013/04/15/17/933893142.png
فى هذا الموضوع مشاكل كثيره و طريقه حلها بالتفصيل
نبدأ على بركه الله
http://www10.0zz0.com/2013/04/15/18/652423605.gif
1- ازاى تعدل ال Rates بتاعت سيرفرك
1* افتح Server.cfg
2* هات اللى فى الصوره
3* عدل الحاجات دى للى انتا عايزها
ملحوظه 1x = 1000 يعنى 100x = 100000
اوعى تكتب x اكتب مكانها 1000
4* اخرج و اعمل Save
5* تحمل SrPatch 1.0.6 من هنا (http://www.mediafire.com/?42xpiua48h7mbge)
6* افتح SrPatch 1.0.6
7* اختار SrGameServer
8* دوس Patch Selected
9* اختار Fix Rates
10* دوس Browse for SR_GameServer
11* هات مكان ال SrGameServer و اختاروا و مبروك
http://www10.0zz0.com/2013/04/15/18/652423605.gif
2- Agent Server no x trap مش شغال
1* افتح SrPatch 1.0.6 تحملو من هنا (http://www.mediafire.com/?42xpiua48h7mbge) او اللى حملته من فوق
2* اختار Agent Server
3* دوس Patch Selected
4* اكتب Your Ip
5* دوس Browse for Agent Server
6* هات مكان ال Agent Server no x trap و مبـــــــــروكـــ
http://www10.0zz0.com/2013/04/15/18/652423605.gif
3- عايز تقفل او تفتح اماكن
1* SRO_VT_SHARD >> Tables >> dbo.RefRegionBindAssocServer
2* كليك يمين و اختار Edit All Rows
3* هتلاقى قدامك اختصارات و قدام كل واحد رقم
ملحوظه رقم 1 يعنى شغال 0 مقفول
كل الحاجات و معانيها :
CHINA = Jangan
TQ = Qin-Shi Tomb (Jangan Cave)
West_China = Downhang
Oasis_Kingdom = Hotan
Thief Village = Thief town
Roc = Roc Mountain
Eu = Constantinople
Am = Asia Minor (Captain Ivy)
Ca = Central Asia (Samarkand)
SD = DESERT OF ALEX
KingsValley = ALEX DOWN
Pharaoh= HOLY TEMPLE
DELTA = ALEXANDRIA TOWN
TEMPLE = JOB CAVE ALEXANDRIA
FORT_JA_AREA = Jangan FW
FORT_DW_AREA = Donwhang FW
FORT_HT_AREA = Hotan FW
FORT_CT_AREA = Constantiple FW
FORT_SK_AREA = Samarkand FW
FORT_BJ_AREA = Bandit FW
FORT_HM_AREA = -
FORT_ER_AREA = -
ARENA_OCCUPY = -
ARENA_FLAG = Arena Flag
ARENA_SCORE = Arena Score
SIEGE_DUNGEON = Capture the Flag
ARENA_GNGWC = Arena GNGWC
GOD_TOGUI = Forgotten World
GOD_WRECK_IN = Forgotten World
GOD_FLAME = Forgotten World
GOD_WRECK_OUT = Forgotten World
EVENT_GHOST = Forgotten World
JUPITER = Jupiter Temple 120 mob
PRISON = Prison
GM_EVENT = GM Map
http://www10.0zz0.com/2013/04/15/18/652423605.gif
4- عندك ال Rows 200 و عايز تخليها All
1* فى SQL
2* Tools >> Optians >> SQL Server Object Explorer
3* خلى كل اللى قدامك قدامو 0
http://www10.0zz0.com/2013/04/15/18/652423605.gif
5- عايز تفكك من حوار ال PrivildeIP و تفتح ال GM من اى مكان
1* حمل ده هنا (http://www.mediafire.com/?2kcq3r1hehhbsn4)
2* حطو مكان اللى عندك فى Server Files
3* اقفل سيرفرك و افتحوا تانى و مبروكــــ
http://www10.0zz0.com/2013/04/15/18/652423605.gif
6- مشكله ال C4
1* حمل IPInput من هنا (http://www.mediafire.com/?n0brecf29p4p9za)
2* افتح IpInput هتلاقى خانه اسمها Version
3* غيرو ب Version ال فى الخطوات الاتيه
4* بعد ما تفتح Your Server هات ال SMC intepent
5* هتلاقى خانه اسمها MoudlePatch افتحها
6* دوس كليك يمين على SRO_Client و اختار SRO_Client 22
7* هتلاقى فى مستطيل فوق شويه فى النصف مربعين صغيرين واحد هتلاقيه ابيض و فاضى و التانى مينفعش
تكتب فيه و مكتوب جنب كل واحد منهم Version فى المربع التانى اللى مينفعش تكتب فيه احفظ الرقم و اكتبوا
فى Version اللى فى IpInput و مبروكـــــــ
http://www10.0zz0.com/2013/04/15/18/652423605.gif
7- عايز تظبط مسافات الاكواد
1* من هنا (http://www.silkroad4arab.com/vb/showthread.php?t=487448)
http://www10.0zz0.com/2013/04/15/18/652423605.gif
8- بيجيلك DC كل 8-9 دقائق
1* فى خطأ فى DB Connect الصيغه الصحيحه اتفضل
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=NamePC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=Pw-SQL;"
DBConnA.Open strConnectA
%>
http://www10.0zz0.com/2013/04/15/18/652423605.gif
9- Billing Server is Dead
1* برضو خطأ فى DB Connect
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=NamePC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=Pw-SQL;"
DBConnA.Open strConnectA
%>
http://www10.0zz0.com/2013/04/15/18/652423605.gif
10-الملفات بتختفى اول ما تفتحها
1* اعمل كده كليك يمين على My Computer
2* Advanced System Setting >> Setting >> Date Execution prevention
اعمل Turn on DEP و تعمل Add لجميع ملفات السيرفر و مبروكـــ
http://www10.0zz0.com/2013/04/15/18/652423605.gif
11- فى SrShardManager بيجيب DBConnectFailed
الخطأ غالبا يكون فى DB Connect or ini Files
و الصيغه الصحيحه اهى اتفضل
DBConnect
<%
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
[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
[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
[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://www10.0zz0.com/2013/04/15/18/652423605.gif
12- ازاى تغير ال Reward بتاع CTF + Arena
1* حمل ده هنا (http://files.fm/u/kcvwblm)
2* افتح المسار الاتى هتلاقيه فى اللى انتا حملته
3* Cfg >> Common
4* هتلاقى فيه Code فيه كلمه Arena غيرها للكود الReward الجديد و نفس النظام فى ال CTF
http://www10.0zz0.com/2013/04/15/18/652423605.gif
13 - ازاى تفتح skilldata_3500enc و بقيت الملفات المشفره
1* حمل ده هنا (http://www.silkroad4arab.com/vb/attachment.php?attachmentid=14407&d=1365332655)
2* انقل الملف ليه كانك بتاخدو Move للبرنامج
3* خد كل الFiles اللى لاقيتها فى الفولدر و حطها فى ملفات السيرفر و وافق على الاستبدال
http://www10.0zz0.com/2013/04/15/18/652423605.gif
DBConnect Failed
الـحل : راجع على wwwroot واتـاكد انك حاتت فيها الDBConnect
الـصيغه الـصحيحه لى DBConnect
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=CHALABI-PC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=I'llNotMissEgypt;"
DBConnA.Open strConnectA
%>
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
http://im36.gulfup.com/g32pd.jpg (http://www.gulfup.com/?QVkVS9)
الـحل : المـشكله دى بتيجى لما بنضيف حاجه فى RefObjItem و الـID بتعها موجود
الحل انـك تغير الID
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
http://im35.gulfup.com/iYGv0.png (http://www.gulfup.com/?trgR9W)
http://im35.gulfup.com/GNRN3.png (http://www.gulfup.com/?5c6Fi2)
الـحل:
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'
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
Billing Server is Dead
الحـل : الـمشـكله من IIS راجع عليها وراجع على ODBC
واتاكد ان الPort فى Server.cfg 8080
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
http://im36.gulfup.com/mCfqH.jpg (http://www.gulfup.com/?X4Ncsp)
الـحل : ققفل شويه خرايـط و حط ملـف الداتا مـع ملفات السيرفر
أسامى الـمـدن فى الداتابيز
CHINA = Jangan
TQ = Qin-Shi Tomb (Jangan Cave)
West_China = Downhang
Oasis_Kingdom = Hotan
Thief Village = Thief town
Roc = Roc Mountain
Eu = Constantinople
Am = Asia Minor (Captain Ivy)
Ca = Central Asia (Samarkand)
SD = DESERT OF ALEX
KingsValley = ALEX DOWN
Pharaoh= HOLY TEMPLE
DELTA = ALEXANDRIA TOWN
TEMPLE = JOB CAVE ALEXANDRIA
FORT_JA_AREA = Jangan FW
FORT_DW_AREA = Donwhang FW
FORT_HT_AREA = Hotan FW
FORT_CT_AREA = Constantiple FW
FORT_SK_AREA = Samarkand FW
FORT_BJ_AREA = Bandit FW
FORT_HM_AREA = -
FORT_ER_AREA = -
ARENA_OCCUPY = -
ARENA_FLAG = Arena Flag
ARENA_SCORE = Arena Score
SIEGE_DUNGEON = Capture the Flag
ARENA_GNGWC = Arena GNGWC
GOD_TOGUI = Forgotten World
GOD_WRECK_IN = Forgotten World
GOD_FLAME = Forgotten World
GOD_WRECK_OUT = Forgotten World
EVENT_GHOST = Forgotten World
JUPITER = Jupiter Temple 120 mob
PRISON = Prison
GM_EVENT = GM Map
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
http://im41.gulfup.com/ljtAK.jpg (http://www.gulfup.com/?HZzBnH)
الـحل : راجع على الIP بتاعـك فى ملفات الـ INI
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
بيجليى Dc كـل 5 دقائق :(
الحل : استخدم AgentServer_no_xtrap بدل AgnetServer
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
كل ماجى ادخل بى اكونت الجيم مش بيرد يفتح اى اكونت عادى بيفتح عادى :111 (13):
الـحل : حط الIP بتاعك فى _PrivilegedIP
او استخدم Getaway No IP مـن هنـا (http://files.fm/u/khdhglr)
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
http://im41.gulfup.com/3FT4x.jpg (http://www.gulfup.com/?8DzEOu)
الـحل : من Server.cfg حط الIP بتاعك فيه عشان الIP اللى موجود فىServer.cfg غير IP الجهاز اذا كان هامشى او static ip
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
Server Degree 11 And Chars Get Lv111+
الحل : SQL & SRO_VT_SHARD & TABLE & _RefLevel
هنروح عند Lv110 ونكتب فى Exp_C القيمه دى 999999999999999999
هنزل الملف ده ونعمل بيه Import فى الميديا و لو عندك ناس فى السيرفر اعمل update
Here (http://files.fm/u/avqvoeb)
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
How to fix 0 notice
الـحل :
Pk2Extractor> Media > server_dep > silkroad > textdata > textuisystem.txt
Press Ctrf+F
then search for " UIIT_MSG_VIETNAM_MRSYSTEM "
then set 1 to 0
وبعد ما تخلص تعمل للملف Import
للميديا تانى .
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
الـ Exp بيقف لما الكتاب الاخضر بيخلص
الحـل :- srPatcher_1.0.6
نعلم على Sr_GameServer وتدوس Patch Selected
علم على Disable Green Book
وبعدين ندوس Browse for Sr_GameServer ونختار الSr_GameServer
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
عندى لما بروح Downhang بيجلى Crush ولما افتح تانى بيجلى Failed to Connect to Server .(S1034)
الحـل : حضرتك مكنتش فاتح Downhang ولما فتحتها معملتش restart All Files Server
وعشان تفك Bug الشخصيه دى اعمل الQuery ده
USE[SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25000, posX= 982 , posY= -0.421872 ,posZ= 140 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0,
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0
الموضوع متجدد ان شاء الله و هيبقى شامل جميع المواضيع
فى هذا الموضوع مشاكل كثيره و طريقه حلها بالتفصيل
نبدأ على بركه الله
http://www10.0zz0.com/2013/04/15/18/652423605.gif
1- ازاى تعدل ال Rates بتاعت سيرفرك
1* افتح Server.cfg
2* هات اللى فى الصوره
3* عدل الحاجات دى للى انتا عايزها
ملحوظه 1x = 1000 يعنى 100x = 100000
اوعى تكتب x اكتب مكانها 1000
4* اخرج و اعمل Save
5* تحمل SrPatch 1.0.6 من هنا (http://www.mediafire.com/?42xpiua48h7mbge)
6* افتح SrPatch 1.0.6
7* اختار SrGameServer
8* دوس Patch Selected
9* اختار Fix Rates
10* دوس Browse for SR_GameServer
11* هات مكان ال SrGameServer و اختاروا و مبروك
http://www10.0zz0.com/2013/04/15/18/652423605.gif
2- Agent Server no x trap مش شغال
1* افتح SrPatch 1.0.6 تحملو من هنا (http://www.mediafire.com/?42xpiua48h7mbge) او اللى حملته من فوق
2* اختار Agent Server
3* دوس Patch Selected
4* اكتب Your Ip
5* دوس Browse for Agent Server
6* هات مكان ال Agent Server no x trap و مبـــــــــروكـــ
http://www10.0zz0.com/2013/04/15/18/652423605.gif
3- عايز تقفل او تفتح اماكن
1* SRO_VT_SHARD >> Tables >> dbo.RefRegionBindAssocServer
2* كليك يمين و اختار Edit All Rows
3* هتلاقى قدامك اختصارات و قدام كل واحد رقم
ملحوظه رقم 1 يعنى شغال 0 مقفول
كل الحاجات و معانيها :
CHINA = Jangan
TQ = Qin-Shi Tomb (Jangan Cave)
West_China = Downhang
Oasis_Kingdom = Hotan
Thief Village = Thief town
Roc = Roc Mountain
Eu = Constantinople
Am = Asia Minor (Captain Ivy)
Ca = Central Asia (Samarkand)
SD = DESERT OF ALEX
KingsValley = ALEX DOWN
Pharaoh= HOLY TEMPLE
DELTA = ALEXANDRIA TOWN
TEMPLE = JOB CAVE ALEXANDRIA
FORT_JA_AREA = Jangan FW
FORT_DW_AREA = Donwhang FW
FORT_HT_AREA = Hotan FW
FORT_CT_AREA = Constantiple FW
FORT_SK_AREA = Samarkand FW
FORT_BJ_AREA = Bandit FW
FORT_HM_AREA = -
FORT_ER_AREA = -
ARENA_OCCUPY = -
ARENA_FLAG = Arena Flag
ARENA_SCORE = Arena Score
SIEGE_DUNGEON = Capture the Flag
ARENA_GNGWC = Arena GNGWC
GOD_TOGUI = Forgotten World
GOD_WRECK_IN = Forgotten World
GOD_FLAME = Forgotten World
GOD_WRECK_OUT = Forgotten World
EVENT_GHOST = Forgotten World
JUPITER = Jupiter Temple 120 mob
PRISON = Prison
GM_EVENT = GM Map
http://www10.0zz0.com/2013/04/15/18/652423605.gif
4- عندك ال Rows 200 و عايز تخليها All
1* فى SQL
2* Tools >> Optians >> SQL Server Object Explorer
3* خلى كل اللى قدامك قدامو 0
http://www10.0zz0.com/2013/04/15/18/652423605.gif
5- عايز تفكك من حوار ال PrivildeIP و تفتح ال GM من اى مكان
1* حمل ده هنا (http://www.mediafire.com/?2kcq3r1hehhbsn4)
2* حطو مكان اللى عندك فى Server Files
3* اقفل سيرفرك و افتحوا تانى و مبروكــــ
http://www10.0zz0.com/2013/04/15/18/652423605.gif
6- مشكله ال C4
1* حمل IPInput من هنا (http://www.mediafire.com/?n0brecf29p4p9za)
2* افتح IpInput هتلاقى خانه اسمها Version
3* غيرو ب Version ال فى الخطوات الاتيه
4* بعد ما تفتح Your Server هات ال SMC intepent
5* هتلاقى خانه اسمها MoudlePatch افتحها
6* دوس كليك يمين على SRO_Client و اختار SRO_Client 22
7* هتلاقى فى مستطيل فوق شويه فى النصف مربعين صغيرين واحد هتلاقيه ابيض و فاضى و التانى مينفعش
تكتب فيه و مكتوب جنب كل واحد منهم Version فى المربع التانى اللى مينفعش تكتب فيه احفظ الرقم و اكتبوا
فى Version اللى فى IpInput و مبروكـــــــ
http://www10.0zz0.com/2013/04/15/18/652423605.gif
7- عايز تظبط مسافات الاكواد
1* من هنا (http://www.silkroad4arab.com/vb/showthread.php?t=487448)
http://www10.0zz0.com/2013/04/15/18/652423605.gif
8- بيجيلك DC كل 8-9 دقائق
1* فى خطأ فى DB Connect الصيغه الصحيحه اتفضل
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=NamePC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=Pw-SQL;"
DBConnA.Open strConnectA
%>
http://www10.0zz0.com/2013/04/15/18/652423605.gif
9- Billing Server is Dead
1* برضو خطأ فى DB Connect
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=NamePC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=Pw-SQL;"
DBConnA.Open strConnectA
%>
http://www10.0zz0.com/2013/04/15/18/652423605.gif
10-الملفات بتختفى اول ما تفتحها
1* اعمل كده كليك يمين على My Computer
2* Advanced System Setting >> Setting >> Date Execution prevention
اعمل Turn on DEP و تعمل Add لجميع ملفات السيرفر و مبروكـــ
http://www10.0zz0.com/2013/04/15/18/652423605.gif
11- فى SrShardManager بيجيب DBConnectFailed
الخطأ غالبا يكون فى DB Connect or ini Files
و الصيغه الصحيحه اهى اتفضل
DBConnect
<%
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
[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
[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
[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://www10.0zz0.com/2013/04/15/18/652423605.gif
12- ازاى تغير ال Reward بتاع CTF + Arena
1* حمل ده هنا (http://files.fm/u/kcvwblm)
2* افتح المسار الاتى هتلاقيه فى اللى انتا حملته
3* Cfg >> Common
4* هتلاقى فيه Code فيه كلمه Arena غيرها للكود الReward الجديد و نفس النظام فى ال CTF
http://www10.0zz0.com/2013/04/15/18/652423605.gif
13 - ازاى تفتح skilldata_3500enc و بقيت الملفات المشفره
1* حمل ده هنا (http://www.silkroad4arab.com/vb/attachment.php?attachmentid=14407&d=1365332655)
2* انقل الملف ليه كانك بتاخدو Move للبرنامج
3* خد كل الFiles اللى لاقيتها فى الفولدر و حطها فى ملفات السيرفر و وافق على الاستبدال
http://www10.0zz0.com/2013/04/15/18/652423605.gif
DBConnect Failed
الـحل : راجع على wwwroot واتـاكد انك حاتت فيها الDBConnect
الـصيغه الـصحيحه لى DBConnect
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=CHALABI-PC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=I'llNotMissEgypt;"
DBConnA.Open strConnectA
%>
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
http://im36.gulfup.com/g32pd.jpg (http://www.gulfup.com/?QVkVS9)
الـحل : المـشكله دى بتيجى لما بنضيف حاجه فى RefObjItem و الـID بتعها موجود
الحل انـك تغير الID
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
http://im35.gulfup.com/iYGv0.png (http://www.gulfup.com/?trgR9W)
http://im35.gulfup.com/GNRN3.png (http://www.gulfup.com/?5c6Fi2)
الـحل:
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'
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
Billing Server is Dead
الحـل : الـمشـكله من IIS راجع عليها وراجع على ODBC
واتاكد ان الPort فى Server.cfg 8080
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
http://im36.gulfup.com/mCfqH.jpg (http://www.gulfup.com/?X4Ncsp)
الـحل : ققفل شويه خرايـط و حط ملـف الداتا مـع ملفات السيرفر
أسامى الـمـدن فى الداتابيز
CHINA = Jangan
TQ = Qin-Shi Tomb (Jangan Cave)
West_China = Downhang
Oasis_Kingdom = Hotan
Thief Village = Thief town
Roc = Roc Mountain
Eu = Constantinople
Am = Asia Minor (Captain Ivy)
Ca = Central Asia (Samarkand)
SD = DESERT OF ALEX
KingsValley = ALEX DOWN
Pharaoh= HOLY TEMPLE
DELTA = ALEXANDRIA TOWN
TEMPLE = JOB CAVE ALEXANDRIA
FORT_JA_AREA = Jangan FW
FORT_DW_AREA = Donwhang FW
FORT_HT_AREA = Hotan FW
FORT_CT_AREA = Constantiple FW
FORT_SK_AREA = Samarkand FW
FORT_BJ_AREA = Bandit FW
FORT_HM_AREA = -
FORT_ER_AREA = -
ARENA_OCCUPY = -
ARENA_FLAG = Arena Flag
ARENA_SCORE = Arena Score
SIEGE_DUNGEON = Capture the Flag
ARENA_GNGWC = Arena GNGWC
GOD_TOGUI = Forgotten World
GOD_WRECK_IN = Forgotten World
GOD_FLAME = Forgotten World
GOD_WRECK_OUT = Forgotten World
EVENT_GHOST = Forgotten World
JUPITER = Jupiter Temple 120 mob
PRISON = Prison
GM_EVENT = GM Map
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
http://im41.gulfup.com/ljtAK.jpg (http://www.gulfup.com/?HZzBnH)
الـحل : راجع على الIP بتاعـك فى ملفات الـ INI
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
بيجليى Dc كـل 5 دقائق :(
الحل : استخدم AgentServer_no_xtrap بدل AgnetServer
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
كل ماجى ادخل بى اكونت الجيم مش بيرد يفتح اى اكونت عادى بيفتح عادى :111 (13):
الـحل : حط الIP بتاعك فى _PrivilegedIP
او استخدم Getaway No IP مـن هنـا (http://files.fm/u/khdhglr)
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
http://im41.gulfup.com/3FT4x.jpg (http://www.gulfup.com/?8DzEOu)
الـحل : من Server.cfg حط الIP بتاعك فيه عشان الIP اللى موجود فىServer.cfg غير IP الجهاز اذا كان هامشى او static ip
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
Server Degree 11 And Chars Get Lv111+
الحل : SQL & SRO_VT_SHARD & TABLE & _RefLevel
هنروح عند Lv110 ونكتب فى Exp_C القيمه دى 999999999999999999
هنزل الملف ده ونعمل بيه Import فى الميديا و لو عندك ناس فى السيرفر اعمل update
Here (http://files.fm/u/avqvoeb)
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
How to fix 0 notice
الـحل :
Pk2Extractor> Media > server_dep > silkroad > textdata > textuisystem.txt
Press Ctrf+F
then search for " UIIT_MSG_VIETNAM_MRSYSTEM "
then set 1 to 0
وبعد ما تخلص تعمل للملف Import
للميديا تانى .
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
الـ Exp بيقف لما الكتاب الاخضر بيخلص
الحـل :- srPatcher_1.0.6
نعلم على Sr_GameServer وتدوس Patch Selected
علم على Disable Green Book
وبعدين ندوس Browse for Sr_GameServer ونختار الSr_GameServer
http://www4.0zz0.com/2013/06/19/17/232147305.gif (http://www.0zz0.com)
عندى لما بروح Downhang بيجلى Crush ولما افتح تانى بيجلى Failed to Connect to Server .(S1034)
الحـل : حضرتك مكنتش فاتح Downhang ولما فتحتها معملتش restart All Files Server
وعشان تفك Bug الشخصيه دى اعمل الQuery ده
USE[SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25000, posX= 982 , posY= -0.421872 ,posZ= 140 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0,
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0
الموضوع متجدد ان شاء الله و هيبقى شامل جميع المواضيع