N paar Errors :<

~Kevin~ · 19. August 2011, 23:51

Hab da ma n paar Errors.. Leider! :<

Ich brauche keine Tipps, sondern Lösungen! :)

Quellcode

2011/ 8/19 21:43:48
\Users\Kevin\Desktop\SRC\SRC\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1313783018, @pserverindex='01', @pidPlayer='0000130', @pItemIndex='22131', @pItemSerialNum=-660221761, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1792618819584
2011/ 8/19 23:23:57
\Users\Kevin\Desktop\SRC\SRC\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1313789024, @pserverindex='01', @pidPlayer='0000130', @pItemIndex='22300', @pItemSerialNum=-430640309, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=2566111106048

Quellcode

2011/08/19 21:43:48
query:uspLoggingTrade @pFlag=2, @pTradeID=1313783018, @pserverindex='01', @pidPlayer='0000130', @pItemIndex='22131', @pItemSerialNum=-660221761, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1792618819584
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2011/08/19 21:43:48
query:uspLoggingTrade @pFlag=2, @pTradeID=1313783018, @pserverindex='01', @pidPlayer='0000130', @pItemIndex='22131', @pItemSerialNum=-660221761, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1792618819584
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2011/08/19 21:43:48
query:LOG_ITEM_STR @im_szName='Baron43',@iserverindex='01',@im_GetszName='Imperator',@idwWorldID=2,@im_dwGold=333931647,@im_nRemainGold=333931647,@iItem_UniqueNo=-1672042622,@iItem_Name='26456',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=612197387,@iItem_count=8,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemResist=0,@im_nResistAbilityOption=0,@im_bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId=0,@inPiercedSize=0,@iadwItemId0=0,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4=0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Ungültiger Cursorstatus
2011/08/19 23:23:57
query:uspLoggingTrade @pFlag=2, @pTradeID=1313789024, @pserverindex='01', @pidPlayer='0000130', @pItemIndex='22300', @pItemSerialNum=-430640309, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=2566111106048
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2011/08/19 23:23:57
query:uspLoggingTrade @pFlag=2, @pTradeID=1313789024, @pserverindex='01', @pidPlayer='0000130', @pItemIndex='22300', @pItemSerialNum=-430640309, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=2566111106048
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2011/08/19 23:23:57
query:LOG_ITEM_STR @im_szName='Yaku',@iserverindex='01',@im_GetszName='UPGRADEITEM_SMELTSAFETY',@idwWorldID=1,@im_dwGold=141761813,@im_nRemainGold=141761813,@iItem_UniqueNo=-1410200246,@iItem_Name='2035',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count=180,@iState='N',@im_nSlot0=100,@im_nSlot1=100,@im_bItemResist=0,@im_nResistAbilityOption=0,@im_bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId=0,@inPiercedSize=0,@iadwItemId0=0,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4=0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Ungültiger Cursorstatus

Alles anzeigen

Danke im Vorraus!
~Kevin

Dancex3 · 19. August 2011, 23:57

Am besten mal deine Prozedur uspLogging_trade und LOG_ITEM_STR posten. die du in deinen Datenbanken hast.

~Kevin~ · 20. August 2011, 00:32

uspLoggingTrade

Quellcode

USE [LOGGING_01_DBF]
GO
/****** Objekt: StoredProcedure [dbo].[uspLoggingTrade] Skriptdatum: 08/20/2011 00:32:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER Procedure [dbo].[uspLoggingTrade]
@pFlag int,
@pTradeID int,
@pserverindex char(2),
@pWorldID int=0,
@pidPlayer char(7)='0000000',
@pTradeGold int=0,
@pPlayerIP varchar(15)='',
@pLevel int=0,
@pJob int=0,
@pItemIndex int=0,
@pItemSerialNum int=0,
@pItemCnt int=0,
@pAbilityOpt int=0,
@pItemResist int=0,
@pResistAbilityOpt int=0,
@pRandomOpt bigint=0
AS
SET NOCOUNT ON
IF @pFlag=0 BEGIN
INSERT INTO tblTradeLog(TradeID, serverindex, WorldID, TradeDt)
VALUES (@pTradeID, @pserverindex, @pWorldID, getdate())
IF @@ROWCOUNT=0 BEGIN
SELECT 9001
RETURN
END
END
ELSE IF @pFlag=1 BEGIN
INSERT INTO tblTradeDetailLog(TradeID, serverindex, idPlayer, Job, Level, TradeGold, PlayerIP)
VALUES (@pTradeID, @pserverindex, @pidPlayer, @pJob, @pLevel, @pTradeGold, @pPlayerIP)
IF @@ROWCOUNT=0 BEGIN
SELECT 9002
RETURN
END
END
ELSE IF @pFlag=2 BEGIN
INSERT INTO tblTradeItemLog(TradeID, serverindex, idPlayer, ItemIndex, ItemSerialNum, ItemCnt, AbilityOpt, ItemResist, ResistAbilityOpt, RandomOpt)
VALUES (@pTradeID, @pserverindex, @pidPlayer, @pItemIndex, @pItemSerialNum, @pItemCnt, @pAbilityOpt, @pItemResist, @pResistAbilityOpt, @pRandomOpt)
IF @@ROWCOUNT=0 BEGIN
SELECT 9003
RETURN
END
END
ELSE BEGIN
SELECT 9004
RETURN
END
SELECT 1
RETURN
SET NOCOUNT OFF

Alles anzeigen

LOG_ITEM_STR

Brainfuck-Quellcode

USE [LOGGING_01_DBF]
GO
/****** Objekt: StoredProcedure [dbo].[LOG_ITEM_STR] Skriptdatum: 08/20/2011 00:32:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER proc [dbo].[LOG_ITEM_STR]
@im_szName VARCHAR(32),
@iserverindex CHAR(2),
@im_GetszName VARCHAR(32) = '',
@idwWorldID INT = 0,
@im_dwGold INT = 0,
@im_nRemainGold INT = 0,
@iItem_UniqueNo INT = 0,
@iItem_Name VARCHAR(32) = '',
@iItem_durability INT = 0,
@im_nAbilityOption INT = 0,
@Im_GetdwGold INT = 0,
@iItem_count INT = 0,
@iState CHAR(1) = '',
@im_nSlot0 INT = 0,--: ?? ??? ???? ?????
@im_nSlot1 INT = 0,-- : ?? ??? ??? ?????
@im_bItemResist INT = 0,-- : ?? (?> ?, ?, ??, ? )
@im_nResistAbilityOption INT = 0,--: m_bItemResist ???
@im_bCharged INT = 0,
@im_dwKeepTime INT = 0,
@im_nRandomOptItemId BIGINT = 0,
@inPiercedSize INT = 0,
@iadwItemId0 INT = 0,
@iadwItemId1 INT = 0,
@iadwItemId2 INT = 0,
@iadwItemId3 INT = 0,
@iadwItemId4 INT = 0,
@iMaxDurability INT = 0
,@inPetKind int = 0, @inPetLevel int = 0, @idwPetExp int = 0, @iwPetEnergy int = 0, @iwPetLife int = 0
,@inPetAL_D int = 0, @inPetAL_C int = 0, @inPetAL_B int = 0, @inPetAL_A int = 0, @inPetAL_S int = 0
------------ ver.12
, @iadwItemId5 int = 0, @iadwItemId6 int = 0,@iadwItemId7 int = 0, @iadwItemId8 int = 0, @iadwItemId9 int = 0
, @inUMPiercedSize int = 0, @iadwUMItemId0 int = 0, @iadwUMItemId1 int = 0, @iadwUMItemId2 int = 0, @iadwUMItemId3 int = 0, @iadwUMItemId4 int = 0
AS
set nocount on
/***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************
LOG ?? ????
??? : ???
??? : 2003.10.17
--20040908 ????
-- ALTER TABLE LOG_ITEM_EVENT_TBL ADD m_nSlot0 INT NULL, m_nSlot1 INT NULL, m_bItemResist INT NULL, m_nResistAbilityOption INT NULL
-- ALTER TABLE LOG_BILLING_ITEM_TBL ADD m_nSlot0 INT NULL, m_nSlot1 INT NULL, m_bItemResist INT NULL, m_nResistAbilityOption INT NULL
-- ALTER TABLE LOG_ITEM_TBL ADD m_nSlot0 INT NULL, m_nSlot1 INT NULL, m_bItemResist INT NULL, m_nResistAbilityOption INT NULL
***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************/
DECLARE @os_date CHAR(14)
SELECT @os_date = CONVERT(CHAR(8),GETDATE(),112)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,GETDATE())),2)
BEGIN
/*************************************************************
?? ???
@iGu = 'L3'
*************************************************************/
IF @iState = 'E'
BEGIN
INSERT LOG_ITEM_EVENT_TBL
(
m_szName,
serverindex,
m_GetszName,
dwWorldID,
m_dwGold,
m_nRemainGold,
Item_UniqueNo,
Item_Name,
Item_durability,
m_nAbilityOption,
m_GetdwGold,
Item_count,
State,
s_date,
m_nSlot0,
m_nSlot1,
m_bItemResist ,
m_nResistAbilityOption,
m_bCharged,
m_dwKeepTime,
m_nRandomOptItemId,
nPiercedSize,
adwItemId0,
adwItemId1,
adwItemId2,
adwItemId3,
MaxDurability,
adwItemId4,
nPetKind, nPetLevel, dwPetExp, wPetEnergy, wPetLife, nPetAL_D, nPetAL_C, nPetAL_B, nPetAL_A, nPetAL_S
, adwItemId5, adwItemId6, adwItemId7, adwItemId8, adwItemId9
, nUMPiercedSize, adwUMItemId0, adwUMItemId1, adwUMItemId2, adwUMItemId3, adwUMItemId4
)
VALUES
(
@im_szName,
@iserverindex,
@im_GetszName,
@idwWorldID,
@im_dwGold,
@im_nRemainGold,
@iItem_UniqueNo,
@iItem_Name,
@iItem_durability,
@im_nAbilityOption ,
@Im_GetdwGold,
@iItem_count,
@iState,
@os_date,
@im_nSlot0,
@im_nSlot1,
@im_bItemResist ,
@im_nResistAbilityOption,
@im_bCharged,
@im_dwKeepTime,
@im_nRandomOptItemId,
@inPiercedSize,
@iadwItemId0,
@iadwItemId1,
@iadwItemId2,
@iadwItemId3,
@iMaxDurability,
@iadwItemId4
,@inPetKind, @inPetLevel, @idwPetExp, @iwPetEnergy, @iwPetLife
,@inPetAL_D, @inPetAL_C, @inPetAL_B, @inPetAL_A, @inPetAL_S
, @iadwItemId5, @iadwItemId6, @iadwItemId7, @iadwItemId8, @iadwItemId9
, @inUMPiercedSize, @iadwUMItemId0, @iadwUMItemId1, @iadwUMItemId2, @iadwUMItemId3, @iadwUMItemId4
)
END
ELSE
IF @iState in ('1','2','3','4','5','6','7','8','9','0')
BEGIN
INSERT LOG_BILLING_ITEM_TBL
(
m_szName,
serverindex,
m_GetszName,
dwWorldID,
m_dwGold,
m_nRemainGold,
Item_UniqueNo,
Item_Name,
Item_durability,
m_nAbilityOption,
m_GetdwGold,
Item_count,
State,
s_date,
m_nSlot0,
m_nSlot1,
m_bItemResist ,
m_nResistAbilityOption,
m_bCharged,
m_dwKeepTime,
m_nRandomOptItemId,
nPiercedSize,
adwItemId0,
adwItemId1,
adwItemId2,
adwItemId3,
MaxDurability,
adwItemId4,
nPetKind, nPetLevel, dwPetExp, wPetEnergy, wPetLife, nPetAL_D, nPetAL_C, nPetAL_B, nPetAL_A, nPetAL_S
, adwItemId5, adwItemId6, adwItemId7, adwItemId8, adwItemId9
, nUMPiercedSize, adwUMItemId0, adwUMItemId1, adwUMItemId2, adwUMItemId3, adwUMItemId4
)
VALUES
(
@im_szName,
@iserverindex,
@im_GetszName,
@idwWorldID,
@im_dwGold,
@im_nRemainGold,
@iItem_UniqueNo,
@iItem_Name,
@iItem_durability,
@im_nAbilityOption ,
@Im_GetdwGold,
@iItem_count,
@iState,
@os_date,
@im_nSlot0,
@im_nSlot1,
@im_bItemResist ,
@im_nResistAbilityOption,
@im_bCharged,
@im_dwKeepTime,
@im_nRandomOptItemId,
@inPiercedSize,
@iadwItemId0,
@iadwItemId1,
@iadwItemId2,
@iadwItemId3,
@iMaxDurability,
@iadwItemId4
,@inPetKind, @inPetLevel, @idwPetExp, @iwPetEnergy, @iwPetLife
,@inPetAL_D, @inPetAL_C, @inPetAL_B, @inPetAL_A, @inPetAL_S
, @iadwItemId5, @iadwItemId6, @iadwItemId7, @iadwItemId8, @iadwItemId9
, @inUMPiercedSize, @iadwUMItemId0, @iadwUMItemId1, @iadwUMItemId2, @iadwUMItemId3, @iadwUMItemId4
)
END
ELSE
BEGIN
INSERT LOG_ITEM_TBL
(
m_szName,
serverindex,
m_GetszName,
dwWorldID,
m_dwGold,
m_nRemainGold,
Item_UniqueNo,
Item_Name,
Item_durability,
m_nAbilityOption,
m_GetdwGold,
Item_count,
State,
s_date,
m_nSlot0,
m_nSlot1,
m_bItemResist ,
m_nResistAbilityOption,
m_bCharged,
m_dwKeepTime,
m_nRandomOptItemId,
nPiercedSize,
adwItemId0,
adwItemId1,
adwItemId2,
adwItemId3,
MaxDurability,
adwItemId4,
nPetKind, nPetLevel, dwPetExp, wPetEnergy, wPetLife, nPetAL_D, nPetAL_C, nPetAL_B, nPetAL_A, nPetAL_S
, adwItemId5, adwItemId6, adwItemId7, adwItemId8, adwItemId9
, nUMPiercedSize, adwUMItemId0, adwUMItemId1, adwUMItemId2, adwUMItemId3, adwUMItemId4
)
VALUES
(
@im_szName,
@iserverindex,
@im_GetszName,
@idwWorldID,
@im_dwGold,
@im_nRemainGold,
@iItem_UniqueNo,
@iItem_Name,
@iItem_durability,
@im_nAbilityOption ,
@Im_GetdwGold,
@iItem_count,
@iState,
@os_date,
@im_nSlot0,
@im_nSlot1,
@im_bItemResist ,
@im_nResistAbilityOption,
@im_bCharged,
@im_dwKeepTime,
@im_nRandomOptItemId,
@inPiercedSize,
@iadwItemId0,
@iadwItemId1,
@iadwItemId2,
@iadwItemId3,
@iMaxDurability,
@iadwItemId4
,@inPetKind, @inPetLevel, @idwPetExp, @iwPetEnergy, @iwPetLife
,@inPetAL_D, @inPetAL_C, @inPetAL_B, @inPetAL_A, @inPetAL_S
, @iadwItemId5, @iadwItemId6, @iadwItemId7, @iadwItemId8, @iadwItemId9
, @inUMPiercedSize, @iadwUMItemId0, @iadwUMItemId1, @iadwUMItemId2, @iadwUMItemId3, @iadwUMItemId4
)
END
RETURN
END
/*
?? ???
ex )
LOG_ITEM_STR @im_szName,
@iserverindex ,
@im_GetszName ,
@idwWorldID,
@im_dwGold,
@im_nRemainGold,
@iItem_UniqueNo,
@iItem_Name ,
@iItem_durability ,
@im_nAbilityOption ,
@Im_GetdwGold ,
@iItem_count,
@iState ,
@im_nSlot0,
@im_nSlot1,
@im_bItemResist,
@im_nResistAbilityOption
@im_bCharged,
@im_dwKeepTime,
@im_nRandomOptItemId,
@inPiercedSize,
@iadwItemId0,
@iadwItemId1,
@iadwItemId2,
@iadwItemId3
LOG_ITEM_STR '???',
'01',
'??',
1,
0,
1000,
-12341,
'????',
1,
3,
123,
1,
'G',
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
*/
set nocount off

Alles anzeigen

~Kevin~ · 22. August 2011, 01:34

Push... Habs noch nicht gelöst bekommen.

Quellcode

Quellcode

Quellcode

Brainfuck-Quellcode

Teilen