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

G

GhostBoy

Inactive Account
Inactive Account
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:
The Best DDoS Protected Servers
CrazyGuardian

CrazyGuardian

Inactive Account
Inactive Account
Joined
Oct 27, 2015
Messages
168
Reaction score
33
Re: items & cash shop

xlmansox said:
work perfect 100%


GKNNHVu.png



qLKjvxA.png


1v1KesH.png


- - - Updated - - -

an easy to add that i make.

1.Remove primary key.
img


from all of this table.
g7mbO1M.png



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
Click to expand...

not work.. db error. ??
 
Myster Dev

Myster Dev

Banned
Banned
Joined
Apr 13, 2014
Messages
738
Reaction score
78
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!
 
M

memvoicam

Experienced Elementalist
Joined
Nov 8, 2014
Messages
200
Reaction score
9
1v1KesH.png



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

aungm

Inactive Account
Inactive Account
Joined
Apr 17, 2018
Messages
52
Reaction score
0
Re: items &amp; cash shop

xlmansox said:
work perfect 100%


GKNNHVu.png



qLKjvxA.png


1v1KesH.png


- - - Updated - - -

an easy to add that i make.

1.Remove primary key.
img


from all of this table.
g7mbO1M.png



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
Click to expand...

I did it but it did not work.
 
H

hernancb17

Inactive Account
Inactive Account
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

https://imgur.com/HronQAa

Basically when I try to buy any item, nothing happens.
 
W

winner8kjy

Initiate Mage
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:
You must log in or register to reply here.

Similar threads

octrpus
Custom Emote Groups / Emote Items
Replies
0
Views
379
octrpus
octrpus
MrSensei
[Server] Understanding Assistant.scp - Mercenaries
Replies
5
Views
652
Anndralgon
Anndralgon
MrSensei
[Server] Understanding World_drop.scp
Replies
4
Views
849
triplexC
T
L
Malevolent (Client & Source Dump)
Replies
5
Views
3K
Aisaka
A
Anndralgon
[Database] Item Type ( PRIM | IDT_PRIM (79) )
Replies
0
Views
823
Anndralgon
Anndralgon

About Us

RaGEZONE is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
123
Guests online
470
Total visitors
593
Robots
2,419
Totals may include hidden visitors.

Forum statistics

Threads
421,955
Messages
4,550,793
Members
244,785
Latest member
DMGG
Most visitors online was 2783 , on 8 Sep 2023

RaGEZONE Sponsor

    HyperFilter
Back
Top