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.
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.
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)
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.
![[HELP] Shaiya in-game Ap problem](https://www.elitepvpers.com/forum/iconimages/shaiya-pserver-development/help-shaiya-game-ap-problem_ltr.gif){kind=small}
