Im Have Problem Error Natice Connection

09/19/2011 02:03 emohardkore#1
Help me Im have problem for Connection lLogin For server


PS_LOGIN
Quote:
2011-09-18 20:39:16 PS_LOGIN__system log start (Login01)

2011-09-18 20:41:38 <Console input> /vchkoff

2011-09-18 20:41:38 <Console output> cmd version chk off ok

2011-09-18 20:42:46 err=-1, [Microsoft][Administrador de controladores ODBC] Estado del cursor no válido, SQL STATE: 24000, NATIVE ERROR: 0 (0x0)

2011-09-18 20:42:46 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'admin','admin123', 3343160409577226241,'190.110.151.1', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-09-18 20:43:49 err=-1, [Microsoft][Administrador de controladores ODBC] Estado del cursor no válido, SQL STATE: 24000, NATIVE ERROR: 0 (0x0)

2011-09-18 20:43:49 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'admin','admin123', 3343160697340035073,'190.110.151.1', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-09-18 20:45:43 err=-1, [Microsoft][Administrador de controladores ODBC] Estado del cursor no válido, SQL STATE: 24000, NATIVE ERROR: 0 (0x0)

2011-09-18 20:45:43 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'admin','admin123', 3343161221326045185,'190.49.177.37', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
PS_GAME
Quote:
2011-09-18 20:39:14 PS_GAME__system log start (Game01) [KR]

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/sorp1

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/croco1

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/croco2

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/Troll1

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/Spink1

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/GoldenPig

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/Sorp3

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/SorpNamed1

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/SorpNamed2

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/Sorp2

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/CrocoNamed1

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/CrocoNamed2

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/CrocoNamed3

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/OrcNamed1

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/OrcNamed2

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/OrcNamed3

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/TrollNamed1

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/Deinos

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/Parridalis

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/Alcarian

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/ZinAlcaria

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/Belizabeth

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/Kirhiross

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/CrypticOne

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/Haruhion

2011-09-18 20:39:15 Loaded Behavior In Factory : data/ai/Freezing

2011-09-18 20:39:16 RandomOption Error : ItemID=32230, byServer=3, Wis=0

2011-09-18 20:39:16 RandomOption Error : ItemID=33230, byServer=3, Wis=0

2011-09-18 20:39:22 connect mgr 1008

2011-09-18 20:39:22 connect dbagent 1012

2011-09-18 20:39:22 connect dbagent2 1016

2011-09-18 20:39:22 connect gamelog 1036

2011-09-18 20:39:23 Market End -----------------------

2011-09-18 20:39:23 Load Shaiya.SData 0

2011-09-18 20:41:24 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=0, SC=3,SCS=0, SB=51,SBS=0

2011-09-18 20:42:59 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=0, SC=3,SCS=0, SB=51,SBS=0

2011-09-18 20:43:10 <Console input> /nprotectoff

2011-09-18 20:43:10 <Console output> cmd NProtect off ok

2011-09-18 20:43:57 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=0, SC=2,SCS=0, SB=31,SBS=0

2011-09-18 20:45:53 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=0, SC=2,SCS=0, SB=31,SBS=0
Pls Help :))))


im use Windows Server Web 2008 x64 Dedicated Server rent

わたしわ日本語です！
05/12/2012 17:14 Kyonhism#2
I made everything I think correct for ep5 server . Server seems working perfect but I saw same error after clicked server :S I not find a solution :S
05/12/2012 21:29 treica#3
Quote:
2011-09-18 20:42:46 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'admin','admin123', 3343160409577226241,'190.110.151.1', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
I see that it blocking your IP, because you use the dupe fix stored procedure, so you have to introduce on the procedure your IP and run it again on DB ( in chase you have an Static IP, or do remove it) and is happens only to ranked 16, 32, 48, 64, 80 accounts because is protecting to do not get hacked your staff.
So set your IP there or change the procedure usp_Try_GameLogin_Taiwan normally how it was.

PS: Also before you get online your server make your database for local only or change the login info's like admin, admin123 :P

Good luck!
05/13/2012 09:57 Kyonhism#4
I tried with another database and fixed :D