usp_Read_User_CashPoint_PayLetterT error 0. Any solution?

10/15/2011 22:30 aboldijar2#1

Hello,
im having an error with my server.When I press the start button after the character screen it disconnects me with this error 0 here is the log.

Quote:

2011-10-15 16:20:23 PS_DBAGENT__system log start (DBAgent01)

2011-10-15 16:20:23 UpdateGuildPointRankDB Result=1

2011-10-15 16:20:28 connect game

2011-10-15 16:22:10 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)

2011-10-15 16:22:10 ::LoadCharacter 118 hahaha qerr=-1, {? = call [usp_Read_User_CashPoint_PayLetterT](?,2)}

Anyone can help me out ?

Thanks in advantance.

10/16/2011 12:45 Xx.LaMin.xX#2

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'usp_Read_User_CashPoint_PayLetterT'., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)

The red color text , that stored procedure is missing. I have diffrent one so i cant give it that to you becouse you will get problems. Try to search it on other PS_GameData database. Like ep3,ep4,ep5 idk xD.. But yea when you see that SP copy and paste it in to your DB and Excute it. The problem will be solved :)

10/16/2011 20:41 aboldijar2#3

Ohh ok thanks buddy will try to find on another DB :)

10/16/2011 23:18 [DEV]xXDASHXx#4

Code:

/****** 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