Gamble item Error

Results 1 to 2 of 2
  1. #1
    Account Upgraded | Title Enabled! Arenbunny is offline
    True MemberRank
    Mar 2013 Join Date
    Peru - AyacuchoLocation
    262Posts

    ! Gamble item Error


    RaGEZONE Recommends

    RaGEZONE Recommends

    please help me!
    error log..


    [09/13/17 06:08:37] MMatchDBMgr::ExceptionHandlerErrSQL( {CALL spChangeGambleItemToRewardSpendableItem (1944, 36836, 1003103, 203, 405005, 0)} ), ErrCode( -1 )ErrMsg - El nombre de columna 'RentHourPeriod' no es válido.El nombre de columna 'ItemCnt' no es válido.State:S0022,Native:207,Origin:[Microsoft][SQL Server Native Client 11.0][SQL Server]
    dbo.sp

    USE [GUNZARMYDBAren]GO/****** Object: StoredProcedure [dbo].[spChangeGambleItemToRewardItem] Script Date: 13/09/2017 17:35:12 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROC [dbo].[spChangeGambleItemToRewardItem] -- CREATE PROC dbo.spChangeGambleItemToRewardItem @CID INT , @CIID INT , @GIID INT , @GRIID INT , @RewardItemID INTAS BEGIN SET NOCOUNT ON; DECLARE @RentHourPeriod INT DECLARE @GambleItemCount INT; ----------------------------------------------------------------------------- SELECT @RentHourPeriod = ISNULL(RentHourPeriod, 0) FROM GambleRewardItem gri(NOLOCK) WHERE GRIID = @GRIID AND GIID = @GIID AND (ItemIDMale = @RewardItemID OR ItemIDFemale = @RewardItemID) IF (0 = @@ROWCOUNT) BEGIN SELECT -1 AS 'Ret' RETURN END SELECT @GambleItemCount = ISNULL(Cnt, 1) FROM CharacterItem(NOLOCK) WHERE CIID = @CIID; ----------------------------------------------------------------------------- DECLARE @NowDate DATETIME; SET @NowDate = GETDATE(); ----------------------------------------------------------------------------- BEGIN TRAN ----------- ---------------------------------------------------------------------------------------- IF( @GambleItemCount > 1 ) BEGIN UPDATE CharacterItem SET Cnt = Cnt - 1 WHERE CID = @CID AND CIID = @CIID IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN ROLLBACK TRAN SELECT -2 AS 'Ret' RETURN END END ELSE BEGIN UPDATE CharacterItem SET CID = NULL WHERE CID = @CID AND CIID = @CIID IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN ROLLBACK TRAN SELECT -3 AS 'Ret' RETURN END END --------------------------------------------------------------------------------------- INSERT CharacterItem(CID, ItemID, RegDate, RentDate, RentHourPeriod, Cnt) VALUES (@CID, @RewardItemID, @NowDate, @NowDate, @RentHourPeriod, 1) DECLARE @OrderCIID INT; SET @OrderCIID = @@IDENTITY; IF (0 <> @@ERROR) BEGIN ROLLBACK TRAN SELECT -4 AS 'Ret' RETURN END INSERT dbo.ItemChangeLog_CharacterItem(ChangeType, ChangeDate, CID, CIID, ItemID, [Count]) VALUES (202, @NowDate, @CID, @CIID, @GIID, 1); IF (0 <> @@ERROR) BEGIN ROLLBACK TRAN SELECT -5 AS 'Ret' RETURN END INSERT dbo.ItemChangeLog_CharacterItem(ChangeType, ChangeDate, CID, CIID, ItemID, [Count]) VALUES (102, @NowDate, @CID, @OrderCIID, @RewardItemID, 1); IF (0 <> @@ERROR) BEGIN ROLLBACK TRAN SELECT -6 AS 'Ret' RETURN END INSERT INTO LogDB..GambleLog(CID, GIID, RewardItemID, RegDate) VALUES (@CID, @GIID, @RewardItemID, @NowDate); IF (0 <> @@ERROR) BEGIN ROLLBACK TRAN SELECT -7 AS 'Ret' RETURN END ---------------------------------------------------------------------------------------- COMMIT TRAN ----------- SELECT 0 AS 'Ret', @OrderCIID AS 'ORDERCIID'END
    other error:
    first open normal open



    2º normal items open


    3º no update item no view item


    4º relogin server view item


    Help Fix Please
    Last edited by Arenbunny; 14-09-17 at 01:36 AM.


  2. #2
    Developer PlayGunZ.net jorklenis2 is online now
    True MemberRank
    Oct 2011 Join Date
    PanamáLocation
    526Posts

    Re: Gamble item Error

    I also had that same problem close 3 years ago and I had to leave it like this.

    You can check these lines to see if you can find a solution to this.

    PHP Code:
    USE [GunzDB]
    GO

    /****** Object:  Table [dbo].[GambleItem]    Script Date: 04/05/2015 14:32:49 By Jorklenis2 ******/
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    SET ANSI_PADDING ON
    GO

    CREATE TABLE 
    [dbo].[GambleItem](
        [
    GIID] [intNOT NULL,
        [
    Name] [varchar](128NOT NULL,
        [
    Description] [varchar](256NOT NULL,
        [
    Price] [intNOT NULL,
        [
    RegDate] [datetimeNOT NULL,
        [
    StartDate] [datetimeNOT NULL,
        [
    LifeTimeHour] [smallintNOT NULL,
        [
    IsCash] [tinyintNOT NULL,
        [
    Opened] [tinyintNOT NULL,
     
    CONSTRAINT [PK_GambleItemPRIMARY KEY CLUSTERED 
    (
        [
    GIIDASC
    )WITH (PAD_INDEX  OFFSTATISTICS_NORECOMPUTE  OFFIGNORE_DUP_KEY OFFALLOW_ROW_LOCKS  ONALLOW_PAGE_LOCKS  ONON [PRIMARY]
    ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF
    GO

    ALTER TABLE 
    [dbo].[GambleItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleItemADD  DEFAULT (getdate()) FOR [RegDate]
    GO

    ALTER TABLE 
    [dbo].[GambleItemADD  DEFAULT ((0)) FOR [StartDate]
    GO

    ALTER TABLE 
    [dbo].[GambleItemADD  DEFAULT ((0)) FOR [LifeTimeHour]
    GO

    ALTER TABLE 
    [dbo].[GambleItemADD  DEFAULT ((0)) FOR [IsCash]
    GO

    ALTER TABLE 
    [dbo].[GambleItemADD  DEFAULT ((0)) FOR [Opened]
    GO


    USE [GunzDB]
    GO

    /****** By Jorklenis2 Object:  Table [dbo].[GambleRewardItem]    Script Date: 04/05/2015 14:33:47 ******/
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    CREATE TABLE 
    [dbo].[GambleRewardItem](
        [
    GRIID] [intIDENTITY(1,1NOT NULL,
        [
    GIID] [intNOT NULL,
        [
    ItemIDMale] [intNOT NULL,
        [
    ItemIDFemale] [intNOT NULL,
        [
    RentHourPeriod] [intNOT NULL,
        [
    RatePerThousand] [smallintNOT NULL,
     
    CONSTRAINT [PK_GambleRewardItemPRIMARY KEY CLUSTERED 
    (
        [
    GRIIDASC
    )WITH (PAD_INDEX  OFFSTATISTICS_NORECOMPUTE  OFFIGNORE_DUP_KEY OFFALLOW_ROW_LOCKS  ONALLOW_PAGE_LOCKS  ONON [PRIMARY]
    ON [PRIMARY]

    GO

    ALTER TABLE 
    [dbo].[GambleRewardItem]  WITH CHECK ADD FOREIGN KEY([GIID])
    REFERENCES [dbo].[GambleItem] ([GIID])
    GO

    ALTER TABLE 
    [dbo].[GambleRewardItem]  WITH CHECK ADD FOREIGN KEY([GIID])
    REFERENCES [dbo].[GambleItem] ([GIID])
    GO

    ALTER TABLE 
    [dbo].[GambleRewardItem]  WITH CHECK ADD FOREIGN KEY([GIID])
    REFERENCES [dbo].[GambleItem] ([GIID])
    GO

    ALTER TABLE 
    [dbo].[GambleRewardItem]  WITH CHECK ADD FOREIGN KEY([GIID])
    REFERENCES [dbo].[GambleItem] ([GIID])
    GO

    ALTER TABLE 
    [dbo].[GambleRewardItem]  WITH CHECK ADD FOREIGN KEY([GIID])
    REFERENCES [dbo].[GambleItem] ([GIID])
    GO

    ALTER TABLE 
    [dbo].[GambleRewardItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleRewardItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleRewardItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleRewardItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleRewardItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleRewardItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleRewardItem]  WITH CHECK ADD CHECK  (([GIID]>(1000000)))
    GO

    ALTER TABLE 
    [dbo].[GambleRewardItemADD  DEFAULT ((0)) FOR [RentHourPeriod]
    GO


    USE [GunzDB]
    GO
    /****** By Jorklenios2 Object:  StoredProcedure [dbo].[spChangeGambleItemToRewardNormalItem]    Script Date: 04/05/2015 14:35:00 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO

    -- Å¬·£ »ý¼ºÇϱâ
    ALTER PROC 
    [dbo].[spChangeGambleItemToRewardNormalItem]
     [
    MENTION=369615]Cid[/MENTION]                INT
        
    , @CIID                INT
        
    , [MENTION=503186]Gii[/MENTION]D                INT
        
    , @GRIID            INT
        
    , @RewardItemID        INT
        
    , @RewardRentPeriod INT
    AS BEGIN

        SET NOCOUNT ON
    ;

        -----------------------------------------------------------------------------

        DECLARE @
    NowDate DATETIME;
        
    SET @NowDate GETDATE();    

        DECLARE [
    MENTION=474740]Gamble[/MENTION]ItemCount    INT;
                
        
    SELECT [MENTION=474740]Gamble[/MENTION]ItemCount ISNULL(Cnt1)
        
    FROM    CharacterItem(NOLOCK)
        
    WHERE    CIID = @CIID
        
    AND        CID IS NOT NULL;
            
        -----------------------------------------------------------------------------
        
        
    SET XACT_ABORT ON;

        
    BEGIN TRAN -----------  
        
            ----------------------------------------------------------------------------------------
            
            IF( [
    MENTION=474740]Gamble[/MENTION]ItemCount BEGIN
            
                UPDATE    CharacterItem 
                SET        Cnt 
    Cnt 1
                WHERE    CID 
    = [MENTION=369615]Cid[/MENTION
                AND        
    CIID = @CIID 
                
            END
            
    ELSE BEGIN
            
                DELETE  CharacterItem 
                WHERE    CID 
    = [MENTION=369615]Cid[/MENTION
                AND        
    CIID = @CIID
                
            END
            
            
    ---------------------------------------------------------------------------------------    
            
            
    INSERT CharacterItem(CIDItemIDRegDateRentDateRentHourPeriodCnt)
            
    VALUES  [MENTION=369615]Cid[/MENTION], @RewardItemID, @NowDate, @NowDate, @RewardRentPeriod1)
            
            DECLARE [
    MENTION=518004]Order[/MENTION]CIID INT;            
            
    SET [MENTION=518004]Order[/MENTION]CIID = @@IDENTITY;            

        
    COMMIT TRAN  -----------

        
    SET XACT_ABORT OFF;
            

        
    INSERT dbo.ItemChangeLog_CharacterItem(ChangeTypeChangeDateCIDCIIDItemID, [Count])
        
    VALUES (202, @NowDate, [MENTION=369615]Cid[/MENTION], @CIID, [MENTION=503186]Gii[/MENTION]D1);    

        
    INSERT dbo.ItemChangeLog_CharacterItem(ChangeTypeChangeDateCIDCIIDItemID, [Count])
        
    VALUES (102, @NowDate, [MENTION=369615]Cid[/MENTION], [MENTION=518004]Order[/MENTION]CIID, @RewardItemID1);

        
    INSERT INTO LogDB..GambleLog(CIDGIIDRewardItemIDRegDateRentHourPeriodItemCnt)
        
    VALUES  [MENTION=369615]Cid[/MENTION], [MENTION=503186]Gii[/MENTION]D, @RewardItemID, @NowDate, @RewardRentPeriod1);

        ----------------------------------------------------------------------------------------
            
        
    SELECT [MENTION=518004]Order[/MENTION]CIID AS 'ORDERCIID'
    END  

    USE [GunzDB]
    GO
    /****** By Jorklenios2 Object:  StoredProcedure [dbo].[spChangeGambleItemToRewardNormalItem]    Script Date: 04/05/2015 14:35:00 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO

    -- Å¬·£ »ý¼ºÇϱâ
    ALTER PROC 
    [dbo].[spChangeGambleItemToRewardNormalItem]
     [
    MENTION=369615]Cid[/MENTION]                INT
        
    , @CIID                INT
        
    , [MENTION=503186]Gii[/MENTION]D                INT
        
    , @GRIID            INT
        
    , @RewardItemID        INT
        
    , @RewardRentPeriod INT
    AS BEGIN

        SET NOCOUNT ON
    ;

        -----------------------------------------------------------------------------

        DECLARE @
    NowDate DATETIME;
        
    SET @NowDate GETDATE();    

        DECLARE [
    MENTION=474740]Gamble[/MENTION]ItemCount    INT;
                
        
    SELECT [MENTION=474740]Gamble[/MENTION]ItemCount ISNULL(Cnt1)
        
    FROM    CharacterItem(NOLOCK)
        
    WHERE    CIID = @CIID
        
    AND        CID IS NOT NULL;
            
        -----------------------------------------------------------------------------
        
        
    SET XACT_ABORT ON;

        
    BEGIN TRAN -----------  
        
            ----------------------------------------------------------------------------------------
            
            IF( [
    MENTION=474740]Gamble[/MENTION]ItemCount BEGIN
            
                UPDATE    CharacterItem 
                SET        Cnt 
    Cnt 1
                WHERE    CID 
    = [MENTION=369615]Cid[/MENTION
                AND        
    CIID = @CIID 
                
            END
            
    ELSE BEGIN
            
                DELETE  CharacterItem 
                WHERE    CID 
    = [MENTION=369615]Cid[/MENTION
                AND        
    CIID = @CIID
                
            END
            
            
    ---------------------------------------------------------------------------------------    
            
            
    INSERT CharacterItem(CIDItemIDRegDateRentDateRentHourPeriodCnt)
            
    VALUES  [MENTION=369615]Cid[/MENTION], @RewardItemID, @NowDate, @NowDate, @RewardRentPeriod1)
            
            DECLARE [
    MENTION=518004]Order[/MENTION]CIID INT;            
            
    SET [MENTION=518004]Order[/MENTION]CIID = @@IDENTITY;            

        
    COMMIT TRAN  -----------

        
    SET XACT_ABORT OFF;
            

        
    INSERT dbo.ItemChangeLog_CharacterItem(ChangeTypeChangeDateCIDCIIDItemID, [Count])
        
    VALUES (202, @NowDate, [MENTION=369615]Cid[/MENTION], @CIID, [MENTION=503186]Gii[/MENTION]D1);    

        
    INSERT dbo.ItemChangeLog_CharacterItem(ChangeTypeChangeDateCIDCIIDItemID, [Count])
        
    VALUES (102, @NowDate, [MENTION=369615]Cid[/MENTION], [MENTION=518004]Order[/MENTION]CIID, @RewardItemID1);

        
    INSERT INTO LogDB..GambleLog(CIDGIIDRewardItemIDRegDateRentHourPeriodItemCnt)
        
    VALUES  [MENTION=369615]Cid[/MENTION], [MENTION=503186]Gii[/MENTION]D, @RewardItemID, @NowDate, @RewardRentPeriod1);

        ----------------------------------------------------------------------------------------
            
        
    SELECT [MENTION=518004]Order[/MENTION]CIID AS 'ORDERCIID'
    END  

    USE [GunzDB]
    GO
    /****** Object:  StoredProcedure [dbo].[spChangeGambleItemToRewardItem]    Script Date: 04/05/2015 14:36:40 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER PROC 
    [dbo].[spChangeGambleItemToRewardItem]  
    -- 
    CREATE PROC dbo.spChangeGambleItemToRewardItem  
     
    [MENTION=369615]Cid[/MENTION]                INT
        
    , @CIID                INT
        
    , [MENTION=503186]Gii[/MENTION]D                INT
        
    , @GRIID            INT
        
    , @RewardItemID        INT
    AS BEGIN

        SET NOCOUNT ON
    ;

        DECLARE [
    MENTION=2000189957]Ren[/MENTION]tHourPeriod        INT  
        
    DECLARE [MENTION=474740]Gamble[/MENTION]ItemCount    INT;
        
        -----------------------------
    By Jorklenis2---------------------------------
                
        
    SELECT [MENTION=2000189957]Ren[/MENTION]tHourPeriod ISNULL(RentHourPeriod0)
        
    FROM    GambleRewardItem gri(NOLOCK)  
        
    WHERE    GRIID = @GRIID
        
    AND        GIID = [MENTION=503186]Gii[/MENTION]
        
    AND        (ItemIDMale = @RewardItemID OR ItemIDFemale = @RewardItemID)  
        
        IF (
    = @@ROWCOUNTBEGIN
            SELECT 
    -AS 'Ret'  
            
    RETURN
        
    END
                
        SELECT 
    [MENTION=474740]Gamble[/MENTION]ItemCount ISNULL(Cnt1)
        
    FROM    CharacterItem(NOLOCK)
        
    WHERE    CIID = @CIID;
            
        -----------------------------------------------------------------------------
        
        DECLARE @
    NowDate    DATETIME;
        
    SET @NowDate GETDATE();    
        
        -----------------------------------------------------------------------------
                
        
    BEGIN TRAN -----------  
        
            ----------------------------------------------------------------------------------------
            
            IF( [
    MENTION=474740]Gamble[/MENTION]ItemCount BEGIN
            
                UPDATE    CharacterItem 
                SET        Cnt 
    Cnt 1
                WHERE    CID 
    = [MENTION=369615]Cid[/MENTION
                AND        
    CIID = @CIID 
                
                
    IF (<> @@ERROR) OR (= @@ROWCOUNTBEGIN  
                    ROLLBACK TRAN  
                    SELECT 
    -AS 'Ret'  
                    
    RETURN
                
    END
                
            END
            
    ELSE BEGIN
            
                UPDATE    CharacterItem 
                SET        CID 
    NULL
                WHERE    CID 
    = [MENTION=369615]Cid[/MENTION
                AND        
    CIID = @CIID
                
                
    IF (<> @@ERROR) OR (= @@ROWCOUNTBEGIN  
                    ROLLBACK TRAN  
                    SELECT 
    -AS 'Ret'  
                    
    RETURN
                
    END
                
            END
            
            
    ---------------------------------------------------------------------------------------    
            
            
    INSERT CharacterItem(CIDItemIDRegDateRentDateRentHourPeriodCnt)
            
    VALUES  [MENTION=369615]Cid[/MENTION], @RewardItemID, @NowDate, @NowDate, [MENTION=2000189957]Ren[/MENTION]tHourPeriod1)
            
            DECLARE [
    MENTION=518004]Order[/MENTION]CIID INT;            
            
    SET [MENTION=518004]Order[/MENTION]CIID = @@IDENTITY;
                
            IF (
    <> @@ERRORBEGIN  
                ROLLBACK TRAN  
                SELECT 
    -AS 'Ret'  
                
    RETURN
            
    END
                
                
            INSERT dbo
    .ItemChangeLog_CharacterItem(ChangeTypeChangeDateCIDCIIDItemID, [Count])
            
    VALUES (202, @NowDate, [MENTION=369615]Cid[/MENTION], @CIID, [MENTION=503186]Gii[/MENTION]D1);    
            
            IF (
    <> @@ERRORBEGIN  
                ROLLBACK TRAN  
                SELECT 
    -AS 'Ret'  
                
    RETURN
            
    END

            INSERT dbo
    .ItemChangeLog_CharacterItem(ChangeTypeChangeDateCIDCIIDItemID, [Count])
            
    VALUES (102, @NowDate, [MENTION=369615]Cid[/MENTION], [MENTION=518004]Order[/MENTION]CIID, @RewardItemID1);
            
            IF (
    <> @@ERRORBEGIN  
                ROLLBACK TRAN  
                SELECT 
    -AS 'Ret'  
                
    RETURN
            
    END

            INSERT INTO LogDB
    ..GambleLog(CIDGIIDRewardItemIDRegDate)  
            
    VALUES  [MENTION=369615]Cid[/MENTION], [MENTION=503186]Gii[/MENTION]D, @RewardItemID, @NowDate);
            
            IF (
    <> @@ERRORBEGIN  
                ROLLBACK TRAN  
                SELECT 
    -AS 'Ret'  
                
    RETURN
            
    END
            
            
    ----------------------------------------------------------------------------------------

        
    COMMIT TRAN  -----------
            
        
    SELECT 0 AS 'Ret', [MENTION=518004]Order[/MENTION]CIID AS 'ORDERCIID'
    END 
    Last edited by jorklenis2; 17-09-17 at 07:25 PM.
    My idol activities are about to start !.





Advertisement