usp_Read_Chars_PointLog_R 11 help me all please

05/16/2011 00:28 Haskoman#1

hi all,

So i have this bug its the time not good work?

::LoadCharacter 11 Hasko qerr=-1, EXEC usp_Read_Chars_PointLog_R 11

2011-05-16 00:24:57 ErrorMsg=[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification, SQL STATE: 22018, NATIVE ERROR: 0 (0x0)

2011-05-16 00:25:16 1 1 SAgent::Disconnect: (4, 64)

05/16/2011 12:28 Shaiya Xtreme#2

Use this

Code:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO

/****** 개체: 저장 프로시저 dbo.usp_Read_Chars_R    스크립트 날짜: 2006-05-09 오후 12:17:36 ******/


ALTER  Proc [dbo].[usp_Read_Chars_R]

@ServerID tinyint,
@UserUID int,
@Del int= 0

AS

SET NOCOUNT ON

SELECT CharID, CharName, Slot, 
Family, Grow, Hair, Face, [Size], Job, Sex, [Level], [Str], Dex, Rec, [Int], Luc, Wis, 
HP, MP, SP, Map, RenameCnt, RemainTime, 
DATEPART(yyyy, RegDate) AS MakeTime_YYYY, 
DATEPART(mm, RegDate) AS MakeTime_MM, 
DATEPART(dd, RegDate) AS MakeTime_DD, 
DATEPART(hh, RegDate) AS MakeTime_HH, 
DATEPART(mi, RegDate) AS MakeTime_MI, 
DATEPART(ss, RegDate) AS MakeTime_SS

FROM Chars

WHERE ServerID=@ServerID AND UserUID=@UserUID AND Del=@Del

SET NOCOUNT OFF

05/16/2011 16:27 castor4878#3

The issue is indeed a returned date that is read & formatted using local domestic settings (those used by MSSQL) by ODBC and misunderstood by ps_game that try to recover it using Korean rules, but the PO dealt with Read_Chars_PointLog not Read_Chars.