N paar Errors :<

~Kevin~

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

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

Code

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

Code

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

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

~Kevin~

uspLoggingTrade

Code

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

Code

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~

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

N paar Errors :<

Jetzt mitmachen!

SCHNELLZUGRIFF

HILFE & COMMUNITY

RECHTLICHES

Benutzer online in diesem Thema