الموضوع: مشكلة بسيطة SQL
عرض مشاركة واحدة
قديم 02-10-2014, 08:58 AM   #7

Dynamic_
عضو فعال



الصورة الرمزية Dynamic_


• الانـتـسـاب » Sep 2014
• رقـم العـضـويـة » 119176
• المشـــاركـات » 283
• الـدولـة » Egypt
• الـهـوايـة »
• اسـم الـسـيـرفـر » Vela
• الـجـنـس » Female
• نقـاط التقييم » 10
Dynamic_ صـاعـد

Dynamic_ غير متواجد حالياً


إرسال رسالة عبر Yahoo إلى Dynamic_

افتراضي



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

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



و دي من ال srPatcher_1.0.6



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


توقيع Dynamic_ :


رد مع اقتباس