First THANK YOU VERY MUCH ZeroSignal :handsdown:, I learned a lot with your tutorial, I got my server ep3 working on windows xp with sql server 2008 r2 ( I configured it with this tutorial
[Only registered and activated users can see links. Click Here To Register...]).
BUtttttt, I had one little problem when I select a mob or somes NPCs I got the Error 0 and I was disconnected, I take a look on my logs files and I found this:
Code:
---PS_DBAGENT__charsave.log__20110120_040724
//PS_DBAGENT__charsave log start (DBAgent01)
---PS_DBAGENT__system.log__20110120_040724
2011-01-20 04:07:24 PS_DBAGENT__system log start (DBAgent01)
2011-01-20 04:07:24 UpdateGuildPointRankDB Result=-1
2011-01-20 04:07:26 connect game
---PS_GAME__system.log__20110120_040724
2011-01-20 04:07:24 PS_GAME__system log start (Game01)
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/sorp1
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/croco1
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/croco2
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/Troll1
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/Spink1
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/GoldenPig
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/Sorp3
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/SorpNamed1
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/SorpNamed2
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/Sorp2
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/CrocoNamed1
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/CrocoNamed2
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/CrocoNamed3
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/OrcNamed1
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/OrcNamed2
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/OrcNamed3
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/TrollNamed1
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/Deinos
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/Parridalis
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/Alcarian
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/ZinAlcaria
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/Belizabeth
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/Kirhiross
2011-01-20 04:07:24 Loaded Behavior In Factory : data/ai/CrypticOne
2011-01-20 04:07:25 CItemDrop::InitSequenceItemCreate SequenceItemCreate open 0
2011-01-20 04:07:26 connect mgr 724
2011-01-20 04:07:26 connect dbagent 732
2011-01-20 04:07:26 connect gamelog 760
2011-01-20 04:07:26 map 0, zone 2 mob count = 905
2011-01-20 04:07:26 map 1, zone 3 mob count = 1747
2011-01-20 04:07:26 map 2, zone 4 mob count = 1811
2011-01-20 04:07:26 map 3, zone 5 mob count = 294
2011-01-20 04:07:26 map 4, zone 6 mob count = 47
2011-01-20 04:07:26 map 5, zone 7 mob count = 173
2011-01-20 04:07:26 map 6, zone 8 mob count = 45
2011-01-20 04:07:26 map 7, zone 9 mob count = 162
2011-01-20 04:07:26 map 8, zone 10 mob count = 37
2011-01-20 04:07:26 map 9, zone 11 mob count = 334
2011-01-20 04:07:26 map 10, zone 12 mob count = 234
2011-01-20 04:07:26 map 11, zone 13 mob count = 176
2011-01-20 04:07:26 map 12, zone 14 mob count = 233
2011-01-20 04:07:26 map 13, zone 15 mob count = 245
2011-01-20 04:07:26 map 14, zone 16 mob count = 202
2011-01-20 04:07:26 map 15, zone 17 mob count = 205
2011-01-20 04:07:26 map 16, zone 18 mob count = 205
2011-01-20 04:07:26 map 17, zone 19 mob count = 155
2011-01-20 04:07:26 map 18, zone 20 mob count = 172
2011-01-20 04:07:26 map 19, zone 21 mob count = 1105
2011-01-20 04:07:26 map 20, zone 22 mob count = 1142
2011-01-20 04:07:26 map 21, zone 23 mob count = 160
2011-01-20 04:07:26 map 22, zone 24 mob count = 93
2011-01-20 04:07:26 map 23, zone 25 mob count = 143
2011-01-20 04:07:26 map 24, zone 26 mob count = 158
2011-01-20 04:07:26 map 25, zone 27 mob count = 478
2011-01-20 04:07:26 map 26, zone 28 mob count = 234
2011-01-20 04:07:26 map 27, zone 29 mob count = 61
2011-01-20 04:07:26 map 28, zone 30 mob count = 1077
2011-01-20 04:07:26 map 29, zone 31 mob count = 1107
2011-01-20 04:07:26 map 30, zone 32 mob count = 246
2011-01-20 04:07:26 map 31, zone 33 mob count = 93
2011-01-20 04:07:26 map 32, zone 34 mob count = 94
2011-01-20 04:07:26 map 33, zone 35 mob count = 136
2011-01-20 04:07:26 map 34, zone 36 mob count = 121
2011-01-20 04:07:26 map 35, zone 37 mob count = 0
2011-01-20 04:07:26 map 36, zone 38 mob count = 0
2011-01-20 04:07:26 map 37, zone 39 mob count = 190
2011-01-20 04:07:26 map 38, zone 40 mob count = 228
2011-01-20 04:07:26 map 39, zone 41 mob count = 0
2011-01-20 04:07:26 map 40, zone 42 mob count = 0
2011-01-20 04:07:26 map 41, zone 43 mob count = 0
2011-01-20 04:07:26 map 42, zone 44 mob count = 0
2011-01-20 04:07:26 map 43, zone 45 mob count = 922
2011-01-20 04:07:26 map 44, zone 46 mob count = 852
2011-01-20 04:08:04 <Console input> /nprotectoff
2011-01-20 04:08:04 <Console output> cmd NProtect off ok
2011-01-20 04:09:35 discon client: ( 9, 64) T=000:01:00:000, RC=43,RCS=0, RB=715,RBS=10, SC=157,SCS=2, SB=10131,SBS=144
---PS_GAMELOG__system.log__20110120_040723
2011-01-20 04:07:23 PS_GAMELOG__system log start (GameLog01)
2011-01-20 04:07:26 connect game
----PS_LOGIN__system.log__20110120_040724
2011-01-20 04:07:24 PS_LOGIN__system log start (Login01)
2011-01-20 04:07:46 <Console input> /vchkoff
2011-01-20 04:07:46 <Console output> cmd version chk off ok
---PS_SESSION__system.log__20110120_040723
2011-01-20 04:07:23 PS_SESSION__system log start (Session)
2011-01-20 04:07:25 connect login
2011-01-20 04:07:26 connect game
---PS_USERLOG__system.log__20110120_040723
2011-01-20 04:07:23 PS_USERLOG__system log start (UserLog)
2011-01-20 04:07:25 connect
2011-01-20 04:07:25 connect
2011-01-20 04:07:26 connect
I was searching in the forum and another places and I found the potencial problems:
1-
"Disconnect when targetting mobs, or doing other specific activities
Most likely you have incorrect or missing data in your database. There could be many causes of this. I'd suggest using the SQL profiler to narrow down the problem." this information is in the link on top.
2- The client is not the correct, I was using the lat version:
[Only registered and activated users can see links. Click Here To Register...]
I get the ip of login with wireshark and modified it and I used the patcher developed by lilprohacker (thank you).
I think the problem is in the client side, if you see the log file PS_GAME__system.log__20110120_040724 in the end you can see
2011-01-20 04:09:35 discon client: ( 9, 64) T=000:01:00:000, RC=43,RCS=0, RB=715,RBS=10, SC=157,SCS=2, SB=10131,SBS=144
I am new in this by comparing it with other logs I dont see the common problems, this is just a hypothesis, someone can help me please??
if the problem is in the client side, where can i get the correct version??
I will go to sleep, here is 4:35 am....
Sorry by my English.