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

Junior Spellweaver
Joined
Oct 27, 2015
Messages
164
Reaction score
33
meybi?follw each. i dont test .now not long time home...:(
INSERT [Server].[TblShopProductInfo] ([cBranchId], [cProductId], [cProductName], [cMoneyCode], [cPrice], [cDiscountRate], [cRegDate], [cStartDate], [cEndDate], [cProductDesc], [cGiftYN], [cSellTotalCount], [cDuplicateSell], [cUnitName], [cProductType], [cDispOrder], [cDiscountInfo], [cClassName], [cClassKey], [cRefundYN], [cPageNum], [cRecommend], [cLevelMin], [cLevelMax]) VALUES (N'shop03_tap03', N'K_C9_00014221', N'金色狂怒魔力头饰', N'点券', 10, 0, N'2.01111e+013', N'2.01111e+013', N'2.01111e+013', N'萨满专属', 1, 0, 1, N'7天', N'NEW,R', 5, NULL, N'萨满', 1, 0, 1, 0, 0, 0)
REMOVED

....
[cPossibleLevel], [cUseCount], [cPeriod], [cCoinPrice], [cGameMoneyPrice], [cClassName]) VALUES 0 1 0 450, 0, N')猎人'

(N'K_C9_00014255', N'K_C9_00014213', 10, N'30天', 0, 0, 1, 0, 450, 0, N')猎人'

Bla bla blaaa :)
 
Last edited:
Junior Spellweaver
Joined
Oct 27, 2015
Messages
164
Reaction score
33
hemaprince - items & cash shop - RaGEZONE Forums
 
Last edited:
Junior Spellweaver
Joined
Oct 27, 2015
Messages
164
Reaction score
33
some code is not working. i add db not error. but game shop not show ^^. Only reason: game files think.
 
Put Community First
Loyal Member
Joined
Oct 2, 2014
Messages
1,112
Reaction score
832
some code is not working. i add db not error. but game shop not show ^^. Only reason: game files think.

I've had similar issue, I've grabbed item ID strings but when added to the player via mail system, they haven't appeared. Not sure why, maybe it was something wrong I did as I was still learning the mail system back then.
 
Put Community First
Loyal Member
Joined
Oct 2, 2014
Messages
1,112
Reaction score
832
Re: items & cash shop

I will try to do some research on it today for everyone.



UPDATE: Have been poking the DB tables, nothing's happened yet. This week is quite busy for me too, but I'll keep investigating when I can.
 
Experienced Elementalist
Joined
Jan 21, 2015
Messages
235
Reaction score
201
hmmm , strange is it for this item only or all items !
for now i dnt have any idea about this issue
if i know something i'll tell u :)
 
Experienced Elementalist
Joined
Sep 13, 2014
Messages
232
Reaction score
85
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,
 [USER=2000133456]Pre[/USER]commend			int
AS
BEGIN
	SET NOCOUNT ON
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
	
	SET LOCK_TIMEOUT 5000;
	SET XACT_ABORT ON
	
	DECLARE [USER=2000075974]Aer[/USER]rNo INT,
			@aRowCnt INT


	SELECT [USER=2000075974]Aer[/USER]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',
	 [USER=2000133456]Pre[/USER]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 [USER=2000075974]Aer[/USER]rNo = @@Error, @aRowCnt = @@RowCount
	IF  [USER=2000075974]Aer[/USER]rNo <> 0) OR (@aRowCnt <> 1)
	BEGIN
		RETURN (1)
	END
	
	RETURN (0)
END
 

Attachments

You must be registered for see attachments list
Initiate Mage
Joined
Jan 24, 2016
Messages
1
Reaction score
0
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 ?
 
Experienced Elementalist
Joined
Dec 19, 2015
Messages
247
Reaction score
69
you wont be able to add nothing new , without new server files ;)
 
Back
Top