error

08/18/2013 08:26 amarybb#1
hello guys, i get dc after selecting char

2013-08-18 02:37:36 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)

2013-08-18 02:37:36 ::LoadCharacter 512 [ADM]TheEnd* qerr=-1, {? = call [usp_Read_User_CashPoint_PayLetterT](?,13)}
08/20/2013 21:14 vovan681#2
usp_Read_User_CashPoint_PayLetterT

/****** 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
08/21/2013 04:49 st.jimmy998#3
[Only registered and activated users can see links. Click Here To Register...]
:3 and double post