items & cash shop

Page 3 of 3 FirstFirst 123
Results 31 to 44 of 44
  1. #31
    only asm, only hardcore! lastfun is offline
    DeveloperRank
    Apr 2012 Join Date
    RussiaLocation
    422Posts

    Re: items & cash shop

    why why why why :( item buy work. inventory it doesn't .fail.
    may be the date? (time of use)

  2. #32
    Ultimate Member xlmansox is offline
    MemberRank
    Sep 2014 Join Date
    184Posts

    Re: items & cash shop

    work perfect 100%









    - - - Updated - - -

    an easy to add that i make.

    1.Remove primary key.


    from all of this table.



    2.here is a query to make it easy :)

    Code:
    USE [C9Service]
    GO
    /****** Object:  StoredProcedure [Admin].[UspAddShopProduct]    Script Date: 01/05/2016 23:00:25 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    /******************************************************************************
    **		Name: UspAddShopProduct
    **		Desc: 상품 정보를 등록한다
    **
    **		Auth: 김석천
    **		Date: 20110603
    *******************************************************************************
    **		Change History
    *******************************************************************************
    **		Date:		Author:				Description:
    **		--------	--------			---------------------------------------
    **		2011-07-26	김석천				cClassKey 추가
    **		2011-11-30	김석천				cLevel -> cLevelMin, cLevelMax
    *******************************************************************************/
    ALTER PROCEDURE [Admin].[UspAddShopProduct]
    	@pBranchId			NVARCHAR(20),
    	@pProductId			NVARCHAR(20),
    	@pProductName			NVARCHAR(40),
    	@pPrice			int,
    	@pProductDesc			NVARCHAR(500),
    	@pGiftYN			tinyint,
    	@pLevelMin			int,
    	@pLevelMax			int,
    	@pUnitName			NVARCHAR(50),
    	@pProductType			NVARCHAR(20),
    	@pClassName			NVARCHAR(40),
    	@pClassKey			TINYINT,
     @Precommend			int
    AS
    BEGIN
    	SET NOCOUNT ON
        SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
    	
    	SET LOCK_TIMEOUT 5000;
    	SET XACT_ABORT ON
    	
    	DECLARE @AerrNo INT,
    			@aRowCnt INT
    
    
    	SELECT @AerrNo = 0, @aRowCnt = 0
    
    
    	INSERT INTO [Server].[TblShopProductInfo] (
    		cBranchId,
    		cProductId,
    		cProductName,
    		cMoneyCode,
    		cPrice,
    		cDiscountRate,
    		cRegDate,
    		cStartDate,
    		cEndDate,
    		cProductDesc,
    		cGiftYN,
    		cSellTotalCount,
    		cLevelMin,
    		cLevelMax,
    		cDuplicateSell,
    		cUnitName,
    		cProductType,
    		cDispOrder,
    		cDiscountInfo,
    		cClassName,
    		cClassKey,
    		cRefundYN,
    		cPageNum,
    		cRecommend
    	)
    	VALUES (
    		@pBranchId,
    		@pProductId,
    		@pProductName,
    		'Cash',
    		@pPrice,
    		'0',
    		'2.01111e+013',
    		'2.01111e+013',
    		'2.01111e+013',
    		@pProductDesc,
    		@pGiftYN,
    		'0',
    		@pLevelMin,
    		@pLevelMax,
    		'1',
    		@pUnitName,
    		@pProductType,
    		'1',
    		NULL,
    		@pClassName,
    		@pClassKey,
    		'0',
    		'1',
    	 @Precommend
    	)
    	
    	INSERT INTO [Server].[TblShopProductDetailInfo](
    	cChildProductId,
    	cProductId,
    	cPrice,
    	cUnitName,
    	cValidTerm,
    	cPossibleLevel,
    	cUseCount,
    	cPeriod,
    	cCoinPrice,
    	cGameMoneyPrice,
    	cClassName ) 
    	
    	VALUES(
    	@pProductId,
    	@pProductId,
    	@pPrice,
    	@pUnitName,
    	'0',
    	'0',
    	'1',
    	'0',
    	'0',
    	'0',
    	@pClassName)
    	
    	SELECT @AerrNo = @@Error, @aRowCnt = @@RowCount
    	IF  @AerrNo <> 0) OR (@aRowCnt <> 1)
    	BEGIN
    		RETURN (1)
    	END
    	
    	RETURN (0)
    END

  3. #33
    (php + c#) Developer hemaprince is offline
    True MemberRank
    Jan 2015 Join Date
    Gaza, PalestineLocation
    230Posts

    Re: items & cash shop

    @xlmansox
    wow what is the names of these outfit
    could u plz share the codes of it
    Good FRIENDS are hard to find, harder to leave, and impossible to forget
    After clouds sun shine ... After a storm comes a calm

  4. #34
    Ultimate Member CrazyGuardian is offline
    MemberRank
    Oct 2015 Join Date
    C9 Waterford EULocation
    167Posts

    Re: items & cash shop

    I don't understand. no image...


  5. #35
    (php + c#) Developer hemaprince is offline
    True MemberRank
    Jan 2015 Join Date
    Gaza, PalestineLocation
    230Posts

    Re: items & cash shop

    @CrazyGuardian
    here is the missed image
    Good FRIENDS are hard to find, harder to leave, and impossible to forget
    After clouds sun shine ... After a storm comes a calm

  6. #36
    Ultimate Member CrazyGuardian is offline
    MemberRank
    Oct 2015 Join Date
    C9 Waterford EULocation
    167Posts

    Re: items & cash shop

    yes. not show image

  7. #37
    Ultimate Member xlmansox is offline
    MemberRank
    Sep 2014 Join Date
    184Posts

    Re: items & cash shop

    Quote Originally Posted by CrazyGuardian View Post
    @fallenfate @hemaprince
    why why why why :( item buy work. inventory it doesn't .fail.

    This because you item in this pack is not have :) or server cannot read item id in that packed box.

  8. #38
    (php + c#) Developer hemaprince is offline
    True MemberRank
    Jan 2015 Join Date
    Gaza, PalestineLocation
    230Posts

    Re: items & cash shop

    Quote Originally Posted by xlmansox View Post
    This because you item in this pack is not have :) or server cannot read item id in that packed box.
    same as i thought but , i did not thought this could be real hehe
    Good FRIENDS are hard to find, harder to leave, and impossible to forget
    After clouds sun shine ... After a storm comes a calm

  9. #39
    Newbie alphaz0 is offline
    MemberRank
    Jan 2016 Join Date
    1Posts

    Re: items & cash shop

    So, to add item that we want , we should also add it into that game file ? I tried adding other items (such as weapons etc) but it doesn' work. Did I missed any point ?

  10. #40
    C9Fan Stunn is offline
    True MemberRank
    Dec 2015 Join Date
    BrazilLocation
    217Posts

    Re: items & cash shop

    you wont be able to add nothing new , without new server files ;)
    :)

  11. #41
    Newbie GhostBoy is offline
    MemberRank
    Mar 2016 Join Date
    1Posts

    Re: items & cash shop

    wow dude how did u translate it to arabic ? can u teach me please ? do u have skype or anything ?
    Last edited by GhostBoy; 12-03-16 at 09:21 AM.

  12. #42
    Ultimate Member CrazyGuardian is offline
    MemberRank
    Oct 2015 Join Date
    C9 Waterford EULocation
    167Posts

    Re: items &amp; cash shop

    Quote Originally Posted by xlmansox View Post
    work perfect 100%









    - - - Updated - - -

    an easy to add that i make.

    1.Remove primary key.


    from all of this table.



    2.here is a query to make it easy :)

    Code:
    USE [C9Service]
    GO
    /****** Object:  StoredProcedure [Admin].[UspAddShopProduct]    Script Date: 01/05/2016 23:00:25 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    /******************************************************************************
    **        Name: UspAddShopProduct
    **        Desc: 상품 정보를 등록한다
    **
    **        Auth: 김석천
    **        Date: 20110603
    *******************************************************************************
    **        Change History
    *******************************************************************************
    **        Date:        Author:                Description:
    **        --------    --------            ---------------------------------------
    **        2011-07-26    김석천                cClassKey 추가
    **        2011-11-30    김석천                cLevel -> cLevelMin, cLevelMax
    *******************************************************************************/
    ALTER PROCEDURE [Admin].[UspAddShopProduct]
        @pBranchId            NVARCHAR(20),
        @pProductId            NVARCHAR(20),
        @pProductName            NVARCHAR(40),
        @pPrice            int,
        @pProductDesc            NVARCHAR(500),
        @pGiftYN            tinyint,
        @pLevelMin            int,
        @pLevelMax            int,
        @pUnitName            NVARCHAR(50),
        @pProductType            NVARCHAR(20),
        @pClassName            NVARCHAR(40),
        @pClassKey            TINYINT,
     @Precommend            int
    AS
    BEGIN
        SET NOCOUNT ON
        SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
        
        SET LOCK_TIMEOUT 5000;
        SET XACT_ABORT ON
        
        DECLARE @AerrNo INT,
                @aRowCnt INT
    
    
        SELECT @AerrNo = 0, @aRowCnt = 0
    
    
        INSERT INTO [Server].[TblShopProductInfo] (
            cBranchId,
            cProductId,
            cProductName,
            cMoneyCode,
            cPrice,
            cDiscountRate,
            cRegDate,
            cStartDate,
            cEndDate,
            cProductDesc,
            cGiftYN,
            cSellTotalCount,
            cLevelMin,
            cLevelMax,
            cDuplicateSell,
            cUnitName,
            cProductType,
            cDispOrder,
            cDiscountInfo,
            cClassName,
            cClassKey,
            cRefundYN,
            cPageNum,
            cRecommend
        )
        VALUES (
            @pBranchId,
            @pProductId,
            @pProductName,
            'Cash',
            @pPrice,
            '0',
            '2.01111e+013',
            '2.01111e+013',
            '2.01111e+013',
            @pProductDesc,
            @pGiftYN,
            '0',
            @pLevelMin,
            @pLevelMax,
            '1',
            @pUnitName,
            @pProductType,
            '1',
            NULL,
            @pClassName,
            @pClassKey,
            '0',
            '1',
         @Precommend
        )
        
        INSERT INTO [Server].[TblShopProductDetailInfo](
        cChildProductId,
        cProductId,
        cPrice,
        cUnitName,
        cValidTerm,
        cPossibleLevel,
        cUseCount,
        cPeriod,
        cCoinPrice,
        cGameMoneyPrice,
        cClassName ) 
        
        VALUES(
        @pProductId,
        @pProductId,
        @pPrice,
        @pUnitName,
        '0',
        '0',
        '1',
        '0',
        '0',
        '0',
        @pClassName)
        
        SELECT @AerrNo = @@Error, @aRowCnt = @@RowCount
        IF  @AerrNo <> 0) OR (@aRowCnt <> 1)
        BEGIN
            RETURN (1)
        END
        
        RETURN (0)
    END
    not work.. db error. ??

  13. #43
    Account Upgraded | Title Enabled! Myster Dev is offline
    True MemberRank
    Apr 2014 Join Date
    127.0.0.1Location
    330Posts

    Re: items & cash shop

    someone can re-upload images on this thread or anyone has a video guide or new guide about cash shop editing? ^_^ thank you so much!

  14. #44
    Registered memvoicam is offline
    MemberRank
    Nov 2014 Join Date
    19Posts

    Re: items & cash shop




    my client no have it, i can't buy item on cash shop :( plss fix it :(



Page 3 of 3 FirstFirst 123

Advertisement