[HELP] ERROR 10053 ITEM MALL EP 6.3

AgustinWoW · 01/22/2016, 21:25

Any1 can help me ???
i got error 10053 when i buy something in item mall..
i use this:

to try fix but it doesnt work ...
so if anyone know how to fix it pls tell me

bruno9280 · 01/23/2016, 01:35

Execute:

PHP Code:



IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game') 
BEGIN 
    EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'; 
    EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123'; 
END 
 
exec sp_serveroption @server='game', @optname='rpc', @optvalue='true'; 
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true'; 
 
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_DEFINEDB') 
BEGIN 
    EXEC sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1'; 
    EXEC sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123'; 
END 
 
exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc', @optvalue='true'; 
exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc out', @optvalue='true'; 
 
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_NCASH') 
BEGIN 
    EXEC sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'; 
    EXEC sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123'; 
END 
 
exec sp_serveroption @server='PS_NCASH', @optname='rpc', @optvalue='true'; 
exec sp_serveroption @server='PS_NCASH', @optname='rpc out', @optvalue='true'; 
 
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB') 
BEGIN 
    EXEC sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'; 
    EXEC sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123'; 
END 
 
exec sp_serveroption @server='PS_USERDB', @optname='rpc', @optvalue='true'; 
exec sp_serveroption @server='PS_USERDB', @optname='rpc out', @optvalue='true'; 
 
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_GAMEDB01') 
BEGIN 
    EXEC sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'; 
    EXEC sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123'; 
END 
 
exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc', @optvalue='true'; 
exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc out', @optvalue='true'; 
 
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB01') 
BEGIN 
    EXEC sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'; 
    EXEC sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123'; 
END 
 
exec sp_serveroption @server='PS_USERDB01', @optname='rpc', @optvalue='true'; 
exec sp_serveroption @server='PS_USERDB01', @optname='rpc out', @optvalue='true';

AgustinWoW · 01/23/2016, 02:06

doesnt work ... pls help me

bruno9280 · 01/23/2016, 02:32

Please delete the Linked Server(Server Objects/Linked Servers/(game,PS_DEFINEDB,PS_GAMEDB01,PS_NCASH,PS_USERDB,P S_USERDB01)) and run the script sql.

AgustinWoW · 01/23/2016, 16:59

i did it and doesnt work... what could be???
here are my logs
DbAgent 2016-01-23 13:54:44 PS_DBAGENT__system log start (DBAgent01)

Module list:

C:\ShaiyaServer\SERVER\PSM_Client\bin\ps_dbAgent.e xe, loaded at 0x00400000 - 11/09/14 16:20:57

2016-01-23 13:54:54 ### Connect[4928] : Game[?][0x010EFE70], Addr=127.0.0.1, DBJobEnd=1

2016-01-23 13:54:54 ### DB_SYSTEM_CONNECT[4076] :Game[1][0x010EFE70], Name=Game01, Addr=127.0.0.1

2016-01-23 13:57:55 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error al convertir el tipo de datos varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2016-01-23 13:57:55 SaveBuyPointItem 10 Agustin qerr=-1, {?=call usp_Save_User_BuyPointItems2(1,10,0,'AC_100108_1', '2016-01-23 13:57:55')}

Game:
2016-01-23 13:54:46 PS_GAME__system log start (Game01) [GERMANY]

2016-01-23 13:54:47 Cannot Load String DB File

2016-01-23 13:54:48 RandomOption Error : ItemID=120123, byServer=2, Wis=0

2016-01-23 13:54:48 RandomOption Error : ItemID=120124, byServer=2, Wis=0

2016-01-23 13:54:48 RandomOption Error : ItemID=120125, byServer=2, Wis=0

2016-01-23 13:54:48 InitMobCreateSet fopen error

2016-01-23 13:54:54 connect mgr 1164

2016-01-23 13:54:54 Server Version : 0

2016-01-23 13:54:54 connect dbagent 1168

2016-01-23 13:54:54 connect gamelog 1180

2016-01-23 13:54:54 Market End -----------------------

2016-01-23 13:54:57 Start CWorldSendThread=904

Module list:

C:\ShaiyaServer\SERVER\PSM_Client\bin\ps_game.exe, loaded at 0x00400000 - 11/09/14 17:10:08

2016-01-23 13:55:02 <Console input> /nprotectoff

2016-01-23 13:55:02 <Console output> cmd NProtect off ok

2016-01-23 13:57:56 discon client: (104, 1236) T=000:02:00:000, RC=231,RCS=1, RB=2401,RBS=19, SC=601,SCS=4, SB=18655,SBS=154

the others log are normal

SnickQ · 01/23/2016, 17:16

Try this

Code:

USE PS_GameData
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

create   Proc [dbo].[usp_Save_User_BuyPointItems2]

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

AS

SET NOCOUNT ON
--SET XACT_ABORT ON

DECLARE @UseType 	int
DECLARE @Ret 		int
DECLARE @RemainPoint  	int
DECLARE @OrderNumber 	int
DECLARE @ReturnValue int

SET @Ret = 0

SET @UseType = 1 -- ??

BEGIN DISTRIBUTED TRANSACTION

/*========================================
??? ??
??? ?? ?? ?? UID ? ?? ?? UID? ??? ???? ???.
procRequestOrderProductByGame

???? UID       @buyClientUserNumber               BIGINT
???? UID       @receiveClientUserNumber           BIGINT
?????         @itemCode                          VARCHAR(50)
?? ??          @resultCode                        SMALLINT           	OUTPUT
?? ? ??       @cashBalanceAfterOrder             INT                      	OUTPUT
????	   @orderNumber			      INT			OUTPUT

resultCode
0            ??
1            ????
2            ?? ??? ???? ??
3            ?? ???? ???? ??
5            DB??
6            ????
=========================================*/
EXEC @ReturnValue = game.PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
IF ( @ReturnValue < 0 )
BEGIN
	GOTO ERROR
END

/*IF ( @Ret <> 0 )
BEGIN  
	INSERT INTO PointErrorLog( UserUID, CharID, ProductCode, Ret) 	VALUES( @UserUID, @CharID, @ProductCode, @Ret )
	GOTO ERROR
END
---------------------------------------------
*/

-- ??? ?? ??
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate,RemainPoint,OrderNumber)
VALUES(@UseType,@UserUID,@CharID,@UsePoint,@ProductCode,@UseDate,@RemainPoint,@OrderNumber)
IF( @@ERROR<>0)
BEGIN
	GOTO ERROR
END

COMMIT TRAN
RETURN 1

ERROR:
ROLLBACK TRAN
RETURN -1


SET XACT_ABORT OFF
SET NOCOUNT OFF

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

AgustinWoW · 01/23/2016, 19:22

does not work and i used it before

SnickQ · 01/23/2016, 19:48

cn_string.DB

D:\ShaiyaServer\PSM_Client\Bin\Data

PS_gameLog.exe

D:\ShaiyaServer\PSM_Client\Bin\

Code:

USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_User_BuyPointItems_NCash]    Script Date: 2014-01-21 19:10:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


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



ALTER Proc [dbo].[usp_Save_User_BuyPointItems_NCash]

@UserUID int,
@CharID int,
@UsePoint int,
@ProductCode varchar(20),
@textDate varchar(30)

AS

DECLARE @UseTime datetime
set @UseTime=CONVERT(datetime, @textDate, 120) 

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,@textDate)
IF( @@ERROR<>0)
BEGIN
GOTO ERROR
END

COMMIT TRAN
RETURN 1

ERROR:
ROLLBACK TRAN
RETURN -1


SET XACT_ABORT OFF
SET NOCOUNT OFF

AgustinWoW · 01/23/2016, 20:04

doesnt work :VV the error is like error 0 of ep 5.4 i see the items in my inventory for a second and boom error 10053 diconnected

SnickQ · 01/23/2016, 20:08

Download file from my last post or from stinka server files

AgustinWoW · 01/23/2016, 20:20

stinka server file the link is down and i cant find your last post could you leave me a link???

SnickQ · 01/23/2016, 20:36

Is not down

AgustinWoW · 01/24/2016, 02:25

my fail i saw the wrong thread of stinka xddd

with stynka files the ps_game crash :V
wich database you use to ep 6.3?

Yoquiz · 01/24/2016, 19:20

I have the same problem, not solve it with these files?

AgustinWoW · 01/24/2016, 19:43

with the omega files it works but have error 10053 item mall ...
im downloading english version of sql and see what happens because reading logs i see error to convert varchar to date time so in other thread they said me that i have to use english version of sql .
i will go to try and if it works i tell you
srry for bad english i speak spanish