[Help] Item mall points reads 0

01/13/2014 09:24 mrwarp#1

Hello All!

I'm having some trouble with my in game item mall. No matter what the point value is set to in dbo.Users_Master, it always reads 0 in game. The only thing I have found pertaining to this issue was this:

Code:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

/****** Shoping Mall	Fixed by sandolkakos	Website: www.universalgamesonline.com.br ******/

/*==================================================
@author	lenasoft
@date	2006-09-28
@return	
@brief	N-Cash DB에서 포인트를 가져온다.

잔액 확인
procGetCashBalance

유저 ID         	@userId              		AS         VARCHAR(12)
유저 UID		@clientUserNumber    	AS         BIGINT
캐쉬 잔액            	@cashBalance         	AS         INT                      OUTPUT
==================================================*/
ALTER PROCEDURE [dbo].[usp_Read_User_CashPoint_NCash]  
@CashPoint	int OUTPUT,
@UserUID 	int,
@UserID 	varchar(12)

AS

SET NOCOUNT ON

SET @CashPoint = 0

SELECT @CashPoint=ISNULL(Point,0) FROM PS_UserData.dbo.Users_Master WHERE UserUID=@UserUID 
IF @CashPoint < 0
BEGIN
	UPDATE PS_UserData.dbo.Users_Master SET Point=0 WHERE UserUID=@UserUID
	SET @CashPoint = 0
END



SET NOCOUNT OFF

I ran this query on my DB but did not solve the problem. I can execute the procedure from SQL Management and it returns the correct values...just not in game. I'm using EP5 DB and AGE version 192 client. Is there something that I'm overlooking? I've been banging my head on the desk for hours over this. Any suggestions would be greatly appreciated.

01/13/2014 13:18 sominus#2

Are you using that 'rare' server files with skills up to level 9? (the one with ps_game.exe packed with Themida).
Because in that case I think the 'zero mall Points' bug comes from the server itself.

01/13/2014 15:04 Zoas#3

Try to set
BEGIN
UPDATE PS_UserData.dbo.Users_Master SET Point=Point WHERE UserUID=@UserUID

01/14/2014 04:18 mrwarp#4

@sominus - The version I have was advertised as CN EP9 (us5 compatible) and the ps_game was packed with molebox, but I also have the unpacked version. Although the ps_game shows as a german version. This one only has skills to lvl 6 but has the placeholders to set up to lvl 9 but must be done manually and the HP/MP/SP bar glitches are fixed. I have 160k HP with perfect running bars. No dmg cap fix and no lvl cap raise (lvl 70 cap atm) put in as of yet.(heh I jumped all my stats to 28000 just to test it)

@Zoas - I made the change and rebooted everything, and it did not fix nor break anything. I also get the same results when executing the proc in SQL management.

Also I didn't mention it in my original post, but yes MSDTC is running and configured proper. :)

01/15/2014 22:13 sominus#5

I had that one and yes you can make skills up to lvl 9, I droped it because it was moleboxed so I couldn't raise the level cap. Anyway, I've heard everyone was having that item-mall not working bug with that release. (you could still use a webshop system)

01/16/2014 16:56 mrwarp#6

Yea I was hoping to figure it out because so far this has been the best running setup I've tested. If it comes down to it and I finally give up I may just do the webmall option to work around it...I think I can live with the trade-off. If it does come to that, is there anything I can do to disable the in-game item mall?