Buy item problem

Results 1 to 10 of 10
  1. #1
    Member Pain is offline
    MemberRank
    Nov 2017 Join Date
    beggarLocation
    44Posts

    sad Buy item problem


    RaGEZONE Recommends

    RaGEZONE Recommends

    Hey Ragezone,

    It's been a while since my test server has this error!
    Spoiler:


    Some items I can usually buy, but others appear this message!

    I saw some posts saying it's something in the database (dbo.Item), but what do I do to fix this error? Will I have to rewrite it item by item?

    thank you if anyone can help me
    - Pain


  2. #2
    Aikatsu! jorklenis2 is offline
    True MemberRank
    Oct 2011 Join Date
    PanamáLocation
    546Posts

    Re: Buy item problem

    It is not necessary to add them, I do not have any element added to the table dbo.Item and I can buy, look at this procedure to see how.

    PHP Code:
    USE [GunzDB]
    GO
    /****** Object:  StoredProcedure [dbo].[spBuyBountyItem?back2]    Script Date: 01/08/2018 00:51:10 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO


    ALTER PROC 
    [dbo].[spBuyBountyItem?back2]
    -- 
    ALTER PROC dbo.spBuyBountyItem
        
    [MENTION=369615]Cid[/MENTION]                INT,  
        @
    ItemID                INT,
        @
    ItemCount            INT,
        [
    MENTION=828510]price[/MENTION]                INT,
        @
    IsSpendableItem    INT,
        [
    MENTION=2000189957]Ren[/MENTION]tHourPeriod        INT NULL    
    AS BEGIN
        SET NOCOUNT ON
        
        
    DECLARE @Bounty INT;
        DECLARE [
    MENTION=518004]Order[/MENTION]CIID INT;
        DECLARE @
    Cnt INT;
        
        IF( [
    MENTION=2000189957]Ren[/MENTION]tHourPeriod IS NULL BEGIN
            SET 
    [MENTION=2000189957]Ren[/MENTION]tHourPeriod 0;
        
    END
        
        
    DECLARE @CurDate DATETIME;
        
    SET @CurDate GETDATE();


        
    BEGIN TRAN ----------------------------    
        
            -- 
    Àܾװ˻ç => Bounty °¨¼Ò      
            UPDATE    dbo
    .Character 
            SET        BP 
    BP - [MENTION=828510]price[/MENTION
            
    WHERE    CID = [MENTION=369615]Cid[/MENTION
            AND        (
    BP - [MENTION=828510]price[/MENTION] > 0);
            
            IF( 
    <> @@ERROR OR = @@ROWCOUNT BEGIN      
                ROLLBACK TRAN
                SELECT 
    -AS 'Ret'
                
    RETURN;
            
    END              
            
            
    IF( @IsSpendableItem BEGIN
                        
                
    -- À̹̠°®°í ÀÖ´ÂÁö È®ÀÎÇغ»´Ù.
                
    SELECT    [MENTION=518004]Order[/MENTION]CIID CIID 
                FROM    CharacterItem
    (NOLOCK
                
    WHERE    CID = [MENTION=369615]Cid[/MENTION
                AND        
    ItemID = @ItemID;
            
                -- 
    À̹̠°®°í ÀÖÁö ¾Ê´Ù¸é »õ·Î Ãß°¡ÇØÁØ´Ù.
                IF( [
    MENTION=518004]Order[/MENTION]CIID IS NOT NULL BEGIN
                
                    UPDATE    dbo
    .CharacterItem                -- Item Ãß°¡
                    SET        Cnt 
    Cnt + @ItemCount
                    WHERE    CIID 
    = [MENTION=518004]Order[/MENTION]CIID
                    
    AND        CID = [MENTION=369615]Cid[/MENTION];
                    
                    IF( 
    <> @@ERROR OR = @@ROWCOUNT BEGIN      
                        ROLLBACK TRAN
                        SELECT 
    -AS 'Ret'
                        
    RETURN;
                    
    END
                                            
                END 
    ELSE BEGIN
                
                    INSERT INTO CharacterItem 
    (CIDItemIDRegDateRentDateRentHourPeriodCnt)
                    
    Values  [MENTION=369615]Cid[/MENTION], @ItemID, @CurDate, @CurDate, [MENTION=2000189957]Ren[/MENTION]tHourPeriod, @ItemCount)
                    
                    IF( 
    <> @@ERROR OR = @@ROWCOUNT BEGIN      
                        ROLLBACK TRAN
                        SELECT 
    -AS 'Ret'
                        
    RETURN;
                    
    END
                    
                    SELECT 
    [MENTION=518004]Order[/MENTION]CIID = @@IDENTITY;    
                
    END
                            
            END
            
    ELSE BEGIN
                    
                INSERT dbo
    .CharacterItem (CIDItemIDRegDateRentDateRentHourPeriodCnt)
                
    Values  [MENTION=369615]Cid[/MENTION], @ItemID, @CurDate, @CurDate, [MENTION=2000189957]Ren[/MENTION]tHourPeriod, @ItemCount)
                
                
    SELECT [MENTION=518004]Order[/MENTION]CIID = @@IDENTITY;    
                
                IF( 
    <> @@ERROR OR = @@ROWCOUNT BEGIN      
                    ROLLBACK TRAN
                    SELECT 
    -AS 'Ret'
                    
    RETURN;
                
    END
                            
            END 
            
            
    -- Item ±¸¸Å·Î±× Ãß°¡      
            INSERT INTO ItemPurchaseLogByBounty 
    (ItemIDCIDDateBountyCharBountyType)
            
    VALUES (@ItemID, [MENTION=369615]Cid[/MENTION], @CurDate, [MENTION=828510]price[/MENTION], @Bounty'±¸ÀÔ')
            
            IF( 
    <> @@ERROR OR = @@ROWCOUNT BEGIN      
                ROLLBACK TRAN
                SELECT 
    -AS 'Ret'
                
    RETURN;
            
    END
            
        COMMIT TRAN 
    ----------------------------
            
        
    SELECT 0 AS 'Ret', [MENTION=518004]Order[/MENTION]CIID AS 'ORDERCIID'
    END 
    If you are trying to add the VIP stores in the game it would be another procedure code, if so, let me know to help you out.
    My idol activities are about to start !.


  3. #3
    Member Pain is offline
    MemberRank
    Nov 2017 Join Date
    beggarLocation
    44Posts

    Re: Buy item problem

    Quote Originally Posted by jorklenis2 View Post
    If you are trying to add the VIP stores in the game it would be another procedure code, if so, let me know to help you out.
    I can not buy certain items from the bounty store.
    - Pain

  4. #4
    Aikatsu! jorklenis2 is offline
    True MemberRank
    Oct 2011 Join Date
    PanamáLocation
    546Posts

    Re: Buy item problem

    Specify well which are the articles and model pose here the xml code of the article.
    My idol activities are about to start !.


  5. #5
    Member Pain is offline
    MemberRank
    Nov 2017 Join Date
    beggarLocation
    44Posts

    Re: Buy item problem

    Quote Originally Posted by jorklenis2 View Post
    Specify well which are the articles and model pose here the xml code of the article.
    Are all items that do not have the ItemID in dbo.Item
    - Pain

  6. #6
    ❀◕ ‿ ◕❀ Zujirawa is offline
    True MemberRank
    Aug 2004 Join Date
    凸(¬‿¬)凸Location
    468Posts

    Re: Buy item problem

    Quote Originally Posted by Pain View Post
    Are all items that do not have the ItemID in dbo.Item
    check your zitem
    just replace it.
    Shotgun01 = Shotgun02
    H̺̣̯̻̥̖i̜̯̹͉,͕ ͙͍͔͚̺͕̤͎̪I͕͇͔'͕̗̫̺̱͙m͍̩̘ͅ ͇͓͖̤̝̩͕Z̥̭̠̲̬͎̖̙i̖͚͔̞͉m͉̹̲̭̬y̤̭̱
    ̟͓̣͓̥.̘̱ͅ

  7. #7
    Member Pain is offline
    MemberRank
    Nov 2017 Join Date
    beggarLocation
    44Posts

    Re: Buy item problem

    Quote Originally Posted by Zujirawa View Post
    check your zitem
    just replace it.
    Shotgun01 = Shotgun02
    I do not understand!

    I've been trying to do everything. The only thing that worked was put ItemID.
    - Pain

  8. #8
    Member Pain is offline
    MemberRank
    Nov 2017 Join Date
    beggarLocation
    44Posts

    Re: Buy item problem

    I've added item by item, now everything is normal!
    - Pain

  9. #9
    Hardcore Member Orby is offline
    MemberRank
    Oct 2015 Join Date
    NeverlandLocation
    127Posts

    Re: Buy item problem

    Open your db go in dbo.item remove Set Primary Key.

  10. #10
    Member Pain is offline
    MemberRank
    Nov 2017 Join Date
    beggarLocation
    44Posts

    Re: Buy item problem

    Quote Originally Posted by Orby View Post
    Open your db go in dbo.item remove Set Primary Key.
    This works, thx ;)
    - Pain




Advertisement