• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

items & cash shop

G

GhostBoy

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

CrazyGuardian

Junior Spellweaver
Joined
Oct 27, 2015
Messages
164
Reaction score
33
Re: items & cash shop

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

not work.. db error. ??
 

Attachments

You must be registered for see attachments list
M

Myster Dev

Banned
Banned
500 Posts
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!
 
memvoicam

memvoicam

Experienced Elementalist
Joined
Nov 8, 2014
Messages
233
Reaction score
14
hemaprince - items & cash shop - RaGEZONE Forums



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

aungm

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

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

I did it but it did not work.
 

Attachments

You must be registered for see attachments list
H

hernancb17

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.
 
W

winner8kjy

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

About Us

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

Online statistics

Members online
125
Guests online
11,833
Total visitors
11,958
Totals may include hidden visitors.

Forum statistics

Threads
429,198
Messages
4,590,913
Members
281,305
Latest member
ismodev
Most visitors online was 12720 , on 2 May 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top