Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

items & cash shop

Initiate Mage
Joined
Mar 12, 2016
Messages
1
Reaction score
0
wow dude how did u translate it to arabic ? can u teach me please ? do u have skype or anything ?
 
Last edited:
Junior Spellweaver
Joined
Oct 27, 2015
Messages
164
Reaction score
33
Re: items & cash shop

work perfect 100%


GKNNHVu - items & cash shop - RaGEZONE Forums



qLKjvxA - items & cash shop - RaGEZONE Forums


1v1KesH - items & cash shop - RaGEZONE Forums




an easy to add that i make.

1.Remove primary key.
hemaprince - items & cash shop - RaGEZONE Forums


from all of this table.
g7mbO1M - items & cash shop - RaGEZONE Forums



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,
 @[I][B][URL="http://forum.ragezone.com/members/2000133456.html"]Pre[/URL][/B][/I]commend            int
AS
BEGIN
    SET NOCOUNT ON
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
    
    SET LOCK_TIMEOUT 5000;
    SET XACT_ABORT ON
    
    DECLARE @[I][B][URL="http://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo INT,
            @aRowCnt INT


    SELECT @[I][B][URL="http://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo = 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',
     @[I][B][URL="http://forum.ragezone.com/members/2000133456.html"]Pre[/URL][/B][/I]commend
    )
    
    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 @[I][B][URL="http://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo = @@Error, @aRowCnt = @@RowCount
    IF  @[I][B][URL="http://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo <> 0) OR (@aRowCnt <> 1)
    BEGIN
        RETURN (1)
    END
    
    RETURN (0)
END

not work.. db error. ??
 

Attachments

You must be registered for see attachments list
Banned
Banned
Joined
Apr 13, 2014
Messages
734
Reaction score
76
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!
 
Experienced Elementalist
Joined
Nov 8, 2014
Messages
222
Reaction score
12
hemaprince - items & cash shop - RaGEZONE Forums



my client no have it, i can't buy item on cash shop :( plss fix it :(
 
Newbie Spellweaver
Joined
Apr 17, 2018
Messages
52
Reaction score
0
Re: items &amp; cash shop

work perfect 100%


GKNNHVu - items & cash shop - RaGEZONE Forums



qLKjvxA - items & cash shop - RaGEZONE Forums


1v1KesH - items & cash shop - RaGEZONE Forums




an easy to add that i make.

1.Remove primary key.
hemaprince - items & cash shop - RaGEZONE Forums


from all of this table.
g7mbO1M - items & cash shop - RaGEZONE Forums



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,
 @[I][B][URL="http://forum.ragezone.com/members/2000133456.html"]Pre[/URL][/B][/I]commend            int
AS
BEGIN
    SET NOCOUNT ON
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
    
    SET LOCK_TIMEOUT 5000;
    SET XACT_ABORT ON
    
    DECLARE @[I][B][URL="http://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo INT,
            @aRowCnt INT


    SELECT @[I][B][URL="http://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo = 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',
     @[I][B][URL="http://forum.ragezone.com/members/2000133456.html"]Pre[/URL][/B][/I]commend
    )
    
    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 @[I][B][URL="http://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo = @@Error, @aRowCnt = @@RowCount
    IF  @[I][B][URL="http://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo <> 0) OR (@aRowCnt <> 1)
    BEGIN
        RETURN (1)
    END
    
    RETURN (0)
END

I did it but it did not work.
 

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
Mar 10, 2016
Messages
8
Reaction score
1
Hey so, I have the "Wcoin" amount right at the bottom of the cash shop, but how do you add the "Points" label there, I see that it consumes that currency.

I don't know if it's something related to cMoneyCode from [TblShopProductInfo] table

Basically when I try to buy any item, nothing happens.
 
Newbie Spellweaver
Joined
Dec 14, 2019
Messages
21
Reaction score
1
this one does not work for me. my client does not even show tab menus.
 
Last edited:
Back
Top