[HELP] Shaiya in-game Ap problem

11/11/2013 18:48 theghostnetwork#1

Hello guys, I'm having a problem with the in-game item mall, if anyone knows the fix for this problem, please help.

Before my problem, I apologize if I posted in the wrong section. Please do not come with "use the search button" because I'm almost four hours looking on the internet about this problem, I am also new to the forum, so go easy.

The following happens: I put the points in dbo.users_master then rebooted the server and logged back in the game, but still no item mall points and if I try to buy an item the message appears: "insufficient points."

I also tried to use the stored procedure to load the points, but still no points in the game.

My server is brand new, installed today, already ran the sqls item.sData and cash.sData on the server, so far everything is normal, the only problem: no points.

Again, if anyone knows a fix for this problem, please help and sorry for bad English, I used google translator.

11/11/2013 19:04 nubness#2

Are you using the "ep6" server files ?

11/11/2013 19:39 theghostnetwork#3

Quote:

Originally Posted by nubness

Are you using the "ep6" server files ?

No. I forgot to specify some things. Server ep 4, ep 4.5 client. Ep3 used to make the server and updated for ep4.

11/14/2013 03:31 theghostnetwork#4

All right, found the fix for the Ap problem. But new problem has appeared:
Item Mall DC Error 0

Now, in brazil is 00:21 am and i'm searching for the fix of this since 12:00pm, so if someone has some light, please show to me.
Already tried lots and lots of fixes that i found here in epvp and with my friends that also have private servers.

Here is the log

Quote:

2013-11-13 23:13:53 PS_DBAGENT__system log start (DBAgent)

2013-11-13 23:13:56 connect game, Name=

2013-11-13 23:13:56 connect game, Name=

2013-11-13 23:15:34 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erro ao converter tipo de dados varchar em datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2013-11-13 23:15:34 SaveBuyPointItem 10 Sideshow qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,10,0,'TY1_0026 ','2013-11-13 23:15:33')}

2013-11-13 23:19:51 1 1 SAgent::Disconnect: (4, 64)

2013-11-13 23:19:51 1 1 T=000:05:00:000, RC=13,RCS=0, RB=374,RBS=1, SC=30,SCS=0, SB=3464,SBS=9

2013-11-13 23:19:51 disconnect game, Name=Shaiya Daedra

2013-11-13 23:19:51 1 1 SAgent::Disconnect: (4, 64)

2013-11-13 23:19:51 1 1 T=000:05:00:000, RC=2,RCS=0, RB=41,RBS=0, SC=4,SCS=0, SB=2068,SBS=5

2013-11-13 23:19:51 disconnect game, Name=Shaiya Daedra

2013-11-13 23:19:51 save market... wait plz...

2013-11-13 23:19:52 3 1 SERVICE_CONTROL_STOP

2013-11-13 23:19:54 save all... wait plz... enter /uc

2013-11-13 23:19:56 PS_DBAGENT__system log end (DBAgent)

2013-11-13 23:19:56 3 1 SService::ServiceCtrlDispatcher(): service shutdown

that thing in red is in portuguese, it means: Error converting data type varchar to datetime

if someone please could help, i appreciate

thanks

06/07/2015 06:02 rockman1668#5

hi theghostnetwork, may you tell me how to fix for the AP problem, I still get 0 item mall point right now,
Hope you reply, thanks so much!
zidane

06/07/2015 15:39 mabe140#6

Hello :)

To fix this, you need these:

__________________________________________________

Save this file as: usp_Read_User_CashPoint_NCash.txt

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

_____________________________________________

Save this file as: usp_Save_User_BuyPointItems_NCash.txt

Code:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


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



ALTER Proc [dbo].[usp_Save_User_BuyPointItems_NCash]

@UserUID int,
@CharID int,
@UsePoint int,
@ProductCode varchar(20),
@UseDate datetime

AS

SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @UseType int
DECLARE @ReturnValue int

SET @UseType = 1 -- 掘衙

BEGIN DISTRIBUTED TRANSACTION


EXEC @ReturnValue = PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
IF ( @ReturnValue < 0 )
BEGIN
	GOTO ERROR
END
-- ?檣? 離馬(Old, 夥煎 UPDATE僥 陳塒唳辦 醴憮?纂陛 號檜 橾橫陴)
--UPDATE PS_UserData.dbo.Users_Master SET Point=Point-@UsePoint WHERE UserUID=@UserUID
--IF( @@ERROR<>0 OR @@ROWCOUNT=0)
--BEGIN
--	GOTO ERROR
--END

-- ?檣? 煎斜 晦煙
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate)
VALUES(@UseType,@UserUID,@CharID,@UsePoint,@ProductCode,@UseDate)
IF( @@ERROR<>0)
BEGIN
	GOTO ERROR
END

COMMIT TRAN
RETURN 1

ERROR:
ROLLBACK TRAN
RETURN -1


SET XACT_ABORT OFF
SET NOCOUNT OFF

__________________________________________________ __

And last, save this file as: Read_User_CashPoint_NCash.sql

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
==================================================*/
CREATE 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

Right click and copy text, then go into SQL Server Manager, and make new query, paste text in, and execute. Restart server.

If all goes well, with no error, then everything should be working.

06/07/2015 17:23 killer2p#7

Add Use PS_GameData