-_-" Instant Disconnect error 0

[aragonik]

Hey guys. I finnaly found out how to get my stupid ep 3 game.exe working with thanks to xXDASHXx.

But now when i create a char, and press '' start game'' i get an instant Connection with server has been disconnect error 0 thingie.Maybe this is caused because im using a ep 4 DB idk :/


I have used the search button and found this out:
But i couldnt find a fix in this tread.

#EDIT

Could this be it?

2012-01-17 13:51:27 PS_DBAGENT__system log start (DBAgent01)

2012-01-17 13:51:28 UpdateGuildPointRankDB Result=-1

2012-01-17 13:51:52 connect game



2012-01-17 13:53:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'usp_Read_User_CashPoint_PayLetterT'., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)

2012-01-17 13:53:35 ::LoadCharacter 13 BosKx qerr=-1, {? = call [usp_Read_User_CashPoint_PayLetterT](?,6)}

If so , ive been searching for this usp_read_user_cashpoint_payletterT but i couldnt find it.

#EDIT 2

i found this

Originally Posted by [DEV]xXDASHXx

/****** Object:  Stored Procedure dbo.usp_Read_User_CashPoint_PayLetterT    Script Date: 2008-6-7 18:31:57 ******/

/****** Object:  Stored Procedure dbo.usp_Read_User_CashPoint_UsersMaster    Script Date: 2008/3/15 下午 05:25:51 ******/



/*==================================================
@author	lenasoft
@date	2006-09-28
@return	
@brief	USERDB曖 Users_Master纔檜綰縑憮 檣蒂 陛螳螞棻.
==================================================*/
CREATE PROCEDURE [dbo].[usp_Read_User_CashPoint_PayLetterT]  
@CashPoint 	int OUTPUT,
@UserUID 	int


AS

SET NOCOUNT ON

SET @CashPoint = 0

SELECT @CashPoint=ISNULL(Point,0) FROM game.PS_UserData.dbo.Users_Master WHERE UserUID=@UserUID 
IF @CashPoint < 0
BEGIN
	UPDATE game.PS_UserData.dbo.Users_Master SET Point=0 WHERE UserUID=@UserUID
	SET @CashPoint = 0
END

SET NOCOUNT OFF

there is my stored proc you are looking for from my ep3 test server hope it helps

But it did not fix my problems :/

and i did execute it the right way because(this is the 2nd tiem i tried to exec it)

Msg 2714, Level 16, State 3, Procedure usp_Read_User_CashPoint_PayLetterT, Line 31
There is already an object named 'usp_Read_User_CashPoint_PayLetterT' in the database.

Dont forget im n ot using ep 3 SQL DB while (trying) to run a EP3 server. Im using ep 4 DB and ep 5 PS_UserData.

Comon guys D: i really need a fix :/

EDIT
Im also getting this o.o""...

2012-01-17 14:12:53 PS_DBAGENT__system log start (DBAgent01)

2012-01-17 14:12:54 UpdateGuildPointRankDB Result=-1

2012-01-17 14:12:57 connect game



2012-01-17 14:14:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'usp_Read_User_CashPoint_PayLetterT'., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)

2012-01-17 14:14:45 ::LoadCharacter 15 test qerr=-1, {? = call [usp_Read_User_CashPoint_PayLetterT](?,6)}

2012-01-17 15:42:49 1 1 SAgent::Disconnect: (4, 64)

2012-01-17 15:42:49 1 1 T=001:29:00:000, RC=31,RCS=0, RB=469,RBS=0, SC=22,SCS=0, SB=2687,SBS=0

2012-01-17 15:42:49 disconnect game



2012-01-17 15:42:49 save all... wait plz... enter /uc



2012-01-17 15:42:49 3 1 SERVICE_CONTROL_STOP

2012-01-17 15:42:49 PS_DBAGENT__system log end (DBAgent01)


2012-01-17 15:42:49 3 1 SService::ServiceCtrlDispatcher(): service shutdown

bump o.o

[aragonik]

#Request close error been fixed with many thanks and credits to xXDASHXx