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

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم المواضيع المكررة و المخالفة (https://silkroad4arab.com/vb/forumdisplay.php?f=58)
-   -   مشكلة بسيطة SQL (https://silkroad4arab.com/vb/showthread.php?t=568413)

Dynamic_ 02-10-2014 07:28 AM

انا موجود في الموضوع طول اليوم .. بس فاضل لي اخر ملفين و هشتغل دلوقتي ..

Hero 02-10-2014 07:35 AM

خلاص اخر ما تخلص اعمل UP

Dynamic_ 02-10-2014 08:17 AM

انا تعبت و الله يا Hero
اللي في ايدك اعمله انا مش فاهم شوف لي و النبي كل الحلول للمشكلة دي عشان لازم اشتغل النهاردة

http://im81.gulfup.com/v8Dft4.jpg

ال Machine بيفضل ابيض كدة حتى لو سبته يحمل نص ساعة
مع اني عامل كل حاجة و عامل كل الحلول كمان
ممكن خليك بس معايا 5 دقايق !
:111:

Hero 02-10-2014 08:34 AM

ايوة معاك بص يا كبير هتعملة با ال srPatcher_1.0.6
و هتروح على ملفات ال ini اتاكد على اسم السكول و الباسورد

Dynamic_ 02-10-2014 08:40 AM

تمت المراجعة بنجاح .. و ما زالت المشكلة قائمة
و بالنسبة ل srPatcher_1.0.6
و الله العظيم انا بعمل كل الحلول قبل ما احط موضوع عشان متعبكوش معايا ..
يا ريت لو تخليك معايا شوية عشان بجد انا فيه حاجات كتير متوقفة على تشغيه النهاردة ..
و انا سايب ال TV ده اخر حاجة اكلمك فيها لاني عارف انك مشغول

Hero 02-10-2014 08:47 AM

هيا من ملفات ال ini :D

Dynamic_ 02-10-2014 08:58 AM

طيب ما انا معدل عليها كلها
ثواني اجيب لك التعديل

srGlobalOperation
كود PHP:

[global]
count=1
[entry0]
id=20
operation_type
=22
name
=SRO_Vietnam_TestLocal [F0
query


srGlobalService
كود PHP:

[global]
count=1
[entry0]
operation_type=22
name
=SRO Vietnam TestLocal
query
=DRIVER={SQL Server};SERVER=KING-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=12121995;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id
=697 

srNodeData
كود PHP:

[global]
count=9
[entry0]
node_id=697
operation_type
=22
global_operation_id
=0
associated_shard_id
=0
node_type
=335
service_type
=2
certification_node_id
=1
port
=15880
node_icon
=4
u1
=144
u2
=22
u3
=24
u4
=1
u5
=248
u6
=146
u7
=19
u8
=1
u9
=64
u10
=160
u11
=17
u12
=1
u13
=0
u14
=0
u15
=0
u16
=0
u17
=0
u18
=0
u19
=0
u20
=0
[entry1]
node_id=1
operation_type
=0
global_operation_id
=0
associated_shard_id
=0
node_type
=335
service_type
=1
certification_node_id
=0
port
=32000
node_icon
=5
u1
=40
u2
=22
u3
=24
u4
=1
u5
=216
u6
=99
u7
=19
u8
=1
u9
=0
u10
=0
u11
=0
u12
=0
u13
=0
u14
=0
u15
=0
u16
=0
u17
=0
u18
=0
u19
=0
u20
=0
[entry2]
node_id=698
operation_type
=22
global_operation_id
=0
associated_shard_id
=0
node_type
=335
service_type
=4
certification_node_id
=697
port
=15779
node_icon
=0
u1
=96
u2
=23
u3
=24
u4
=1
u5
=48
u6
=148
u7
=19
u8
=1
u9
=64
u10
=160
u11
=17
u12
=1
u13
=0
u14
=0
u15
=0
u16
=0
u17
=0
u18
=0
u19
=0
u20
=0
[entry3]
node_id=699
operation_type
=22
global_operation_id
=0
associated_shard_id
=0
node_type
=335
service_type
=11
certification_node_id
=697
port
=25880
node_icon
=0
u1
=56
u2
=26
u3
=24
u4
=1
u5
=48
u6
=148
u7
=19
u8
=1
u9
=64
u10
=160
u11
=17
u12
=1
u13
=0
u14
=0
u15
=0
u16
=0
u17
=0
u18
=0
u19
=0
u20
=0
[entry4]
node_id=700
operation_type
=22
global_operation_id
=0
associated_shard_id
=0
node_type
=335
service_type
=3
certification_node_id
=697
port
=15881
node_icon
=0
u1
=248
u2
=22
u3
=24
u4
=1
u5
=96
u6
=147
u7
=19
u8
=1
u9
=64
u10
=160
u11
=17
u12
=1
u13
=0
u14
=0
u15
=0
u16
=0
u17
=0
u18
=0
u19
=0
u20
=0
[entry5]
node_id=704
operation_type
=22
global_operation_id
=20
associated_shard_id
=0
node_type
=335
service_type
=5
certification_node_id
=697
port
=15882
node_icon
=0
u1
=200
u2
=23
u3
=24
u4
=1
u5
=152
u6
=148
u7
=19
u8
=1
u9
=64
u10
=160
u11
=17
u12
=1
u13
=0
u14
=0
u15
=17
u16
=1
u17
=0
u18
=0
u19
=0
u20
=0
[entry6]
node_id=705
operation_type
=22
global_operation_id
=20
associated_shard_id
=64
node_type
=335
service_type
=7
certification_node_id
=704
port
=15883
node_icon
=0
u1
=152
u2
=24
u3
=24
u4
=1
u5
=0
u6
=149
u7
=19
u8
=1
u9
=64
u10
=160
u11
=17
u12
=1
u13
=0
u14
=0
u15
=17
u16
=1
u17
=168
u18
=102
u19
=18
u20
=1
[entry7]
node_id=707
operation_type
=22
global_operation_id
=20
associated_shard_id
=64
node_type
=335
service_type
=6
certification_node_id
=704
port
=15884
node_icon
=0
u1
=48
u2
=24
u3
=24
u4
=1
u5
=104
u6
=149
u7
=19
u8
=1
u9
=64
u10
=160
u11
=17
u12
=1
u13
=0
u14
=0
u15
=17
u16
=1
u17
=168
u18
=102
u19
=18
u20
=1
[entry8]
node_id=713
operation_type
=22
global_operation_id
=20
associated_shard_id
=64
node_type
=335
service_type
=8
certification_node_id
=704
port
=15885
node_icon
=0
u1
=0
u2
=25
u3
=24
u4
=1
u5
=160
u6
=150
u7
=19
u8
=1
u9
=64
u10
=160
u11
=17
u12
=1
u13
=0
u14
=0
u15
=17
u16
=1
u17
=168
u18
=102
u19
=18
u20
=

srNodeLink
كود PHP:

[global]
count=11
[entry0]
id=1227
child_node_id
=697
parent_node_id
=1
p_label
=0
u1
=0
u2
=0
u3
=0
u4
=0
u5
=0
[entry1]
id=1228
child_node_id
=698
parent_node_id
=697
p_label
=0
u1
=0
u2
=0
u3
=0
u4
=0
u5
=0
[entry2]
id=1229
child_node_id
=699
parent_node_id
=697
p_label
=0
u1
=0
u2
=0
u3
=0
u4
=0
u5
=0
[entry3]
id=1230
child_node_id
=700
parent_node_id
=697
p_label
=0
u1
=0
u2
=0
u3
=0
u4
=0
u5
=0
[entry4]
id=1234
child_node_id
=704
parent_node_id
=697
p_label
=1
u1
=0
u2
=0
u3
=0
u4
=0
u5
=0
[entry5]
id=1235
child_node_id
=705
parent_node_id
=704
p_label
=0
u1
=0
u2
=0
u3
=0
u4
=0
u5
=0
[entry6]
id=1237
child_node_id
=707
parent_node_id
=704
p_label
=1
u1
=0
u2
=0
u3
=0
u4
=0
u5
=0
[entry7]
id=1239
child_node_id
=713
parent_node_id
=704
p_label
=0
u1
=0
u2
=0
u3
=0
u4
=0
u5
=0
[entry8]
id=1241
child_node_id
=707
parent_node_id
=713
p_label
=1
u1
=0
u2
=0
u3
=0
u4
=0
u5
=0
[entry9]
id=1245
child_node_id
=707
parent_node_id
=705
p_label
=1
u1
=0
u2
=0
u3
=0
u4
=0
u5
=0
[entry10]
id=1256
child_node_id
=713
parent_node_id
=705
p_label
=0
u1
=0
u2
=0
u3
=0
u4
=0
u5
=

srNodeType
كود PHP:

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

srOperationType
كود PHP:

[global]
count=35
[entry0]
id=1
name
=Silkroad_Dev
[entry1]
id=2
name
=Silkroad_Korea_Yahoo_Official
[entry2]
id=3
name
=Silkroad_Korea_Yahoo_Test_IN
[entry3]
id=4
name
=SRO_China_Official
[entry4]
id=5
name
=SRO_China_TestLocal
[entry5]
id=6
name
=Silkroad_Joymax
[entry6]
id=7
name
=JoymaxMessenger
[entry7]
id=8
name
=ServiceManager
[entry8]
id=9
name
=SRO_China_TestIn
[entry9]
id=10
name
=SRO_Taiwan_TestIn
[entry10]
id=11
name
=SRO_Taiwan_TestLocal
[entry11]
id=12
name
=SRO_Taiwan_Official
[entry12]
id=13
name
=SRO_DEEPDARK
[entry13]
id=14
name
=SRO_Taiwan_BillingTest
[entry14]
id=15
name
=SRO_Japan_Official
[entry15]
id=16
name
=SRO_Japan_TestLocal
[entry16]
id=17
name
=SRO_Japan_TestIn
[entry17]
id=18
name
=SRO_Global_TestBed
[entry18]
id=19
name
=SRO_Global_TestBed_In
[entry19]
id=20
name
=SRO_EuropeTest
[entry20]
id=21
name
=SRO_Vietnam_TestIn
[entry21]
id=22
name
=SRO_Vietnam_TestLocal
[entry22]
id=23
name
=SRO_Net2E_Official
[entry23]
id=24
name
=Yahoo_Official_Test
[entry24]
id=25
name
=SRO_GNGWC_TestIn
[entry25]
id=26
name
=SRO_GNGWC_Official
[entry26]
id=27
name
=SRO_China_OpenTest
[entry27]
id=29
name
=SRO_GNGWC_Official_Final
[entry28]
id=30
name
=CPRJ_Dev
[entry29]
id=31
name
=SRO_INTERNAL_EU
[entry30]
id=32
name
=SRO_INTERNAL_EU_QUEST
[entry31]
id=33
name
=Vietnam_Dev
[entry32]
id=34
name
=SRO_China_EuroTest
[entry33]
id=35
name
=SRO_Taiwan_FOS CB
[entry34]
id=36
name
=SRO_GameOn_Official_Test 

srServiceType
كود PHP:

[global]
count=17
[entry0]
id=1
name
=Certification
[entry1]
id=2
name
=GlobalManager
[entry2]
id=3
name
=DownloadServer
[entry3]
id=4
name
=GatewayServer
[entry4]
id=5
name
=FarmManager
[entry5]
id=6
name
=AgentServer
[entry6]
id=7
name
=SR_ShardManager
[entry7]
id=8
name
=SR_GameServer
[entry8]
id=9
name
=SR_Client
[entry9]
id=10
name
=ServiceManager
[entry10]
id=11
name
=MachineManager
[entry11]
id=12
name
=JmxMsgSvr
[entry12]
id=13
name
=JmxMessenger
[entry13]
id=14
name
=SMC
[entry14]
id=15
name
=CPRJ_Client
[entry15]
id=16
name
=CPRJ_GameServer
[entry16]
id=17
name
=CPRJ_ShardManager 

srShard
كود PHP:

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

srUnknown
كود PHP:

[global]
count=1
[entry0]
global_operation_id=20
operation_type
=22
u3
=240
u4
=208
u5
=17
u6
=

و ده كمان ال DBConnect
كود PHP:

<%
Dim DBConnAstrConnectA
Set DBConnA 
Server.CreateObject("ADODB.Connection")
strConnectA "Provider=SQLOLEDB;Data Source=KING-PC\SQLExpress;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=12121995;"
DBConnA.Open strConnectA

%> 

و دي صورة من ال srPatcher_1.0.5

http://im55.gulfup.com/337K1L.jpg

و دي من ال srPatcher_1.0.6

http://im55.gulfup.com/S6OaaO.jpg

شفت بقى اني فعلا مخلص كل حاجة و مش عارف الغلط فين .. بالله عليك ما تسيبني عشان مكسرش الجهاز عشان انت الامل الوحيد

Dynamic_ 02-10-2014 09:33 AM

و دي بتظهر لي و انا بعمل ايميل ال GM
انا كنت سايبها للاخر بس يمكن ليها علاقة ..
http://im63.gulfup.com/PlMZCC.jpg

Dynamic_ 02-10-2014 09:33 AM

:111:.. UP

Hero 03-10-2014 01:21 AM

اول حاجة غير ملفات ال ini كلها حمل اى واحدة غير اللى عندك و ظبط البيانات
تانى حاجة المفروض تكتب اسم ال ID عادى
GM مثلا مش هماشى لاكن الباس هوا اللى يكون هماشى


الساعة الآن 04:24 AM.

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