[Guide]Fixing In-Game Item Mall

[nubness]

Nope, not necessarily.

[dorrigro]

This tutorial has not corrected the "error 0"

[ltohvuey51]

ep4.5 oke but dont fix ep 5.3 or 60 ???

[st.jimmy998]

This tutorial doesnt care episode..

and @dorrigro, its for Item Mall DC, ur problem can be caused by "stack", u should set in item.sdata and sql files into ur db

[riuga12]

hi i still have that problem my service msdtc is working but when i try buy something i have dc "error 0" I have been a week looking for solution but can not find one


these are my logs


2013-11-13 21:45:42 PS_DBAGENT__system log start (DBAgent01)

2013-11-13 21:46:08 connect game, Name=



2013-11-13 21:46:09 connect game, Name=



2013-11-13 21:48:58 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)

2013-11-13 21:48:58 SaveBuyPointItem 49 Valcor- qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(2,49,0,'b2_runa' ,'2013-11-13 21:48:58')}

im sorry if is wrong section for post i need help ty

[Kenwood25]

THaaaaaaaaaaaaanks ! VERY MUCH! <3
I have this problem, and now i fix it! My hero

[momocruz]

I have followed ALL post about item Mail DC ( step by step ) but i have again DC when i m buy item and on my item Mail only have 1 item to buy (rez rune 30 day)

i have ADD Npsquest ,monster,item,killstatue

I use W7 and SQL 2012 and DB smallserver

I Need Help and more information , Google it's my frienf and EPVPERS to i have used all keys word on search button but they send me always here and my probleme always here

Thx for readind this and i hope someone help me

(PS: Im french i speak portugues and english) i accept PM here to receiv link or Information

[QQers19]

Use TeddyBear94 Files


And this:

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

[momocruz]

Thx QQers19 i'm going to try that's today and back tell if my problem was resolved


Ok now i have find how to fix that "error 0 "

And Fixed Thx to all people have post in forum solution , i have mixed all information , and this is my first time i maked server , i have learn all here to make one and in 8 Days i can play normaly with my friend , and use whatever EP i want to play

Big Thanks all for helped me in all post in EPVP forum

To get solution we just have to READ and use search Button here

[arybb]

hola buenas tardes. pues disculpa no se escribir en ingles, em hace rato, que estoy haciendo un server. busco mas que todo un episodio 4-5, ya los e hecho a cada rato. en mi computador pero se da el caso deq ya teniendo todo listo , el unico error que me queda. segun creo yo es este. tanto en los files 4.5 como ep 5.

2015-11-10 11:53:29 PS_DBAGENT__system log start (DBAgent01)

2015-11-10 11:53:37 connect game, Name=



2015-11-10 11:53:37 connect game, Name=



2015-11-10 12:38:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC no está disponible en el servidor 'SERVIDOR-PC'., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)

2015-11-10 12:38:20 SaveBuyPointItem 1 ?? qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,1,5000,' Accesorios PvP-15','2015-11-10 12:38:18')}

....
ese es el error tengo varios meses en este plan y por ello no e logrado montar mi servidor.. espero pronta respuesta si alguno ya a solucionado.. gracias



translate:

[SnickQ]

2015-11-10 12:38:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC no está disponible en el servidor 'SERVIDOR-PC'., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)

2015-11-10 12:38:20 SaveBuyPointItem 1 ?? qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,1,5000,' Accesorios PvP-15','2015-11-10 12:38:18')}

Im pretty sure you can get solution in this topic for your problem : D

[Pandablack]

Originally Posted by RebeccaBlack

I see the other user removed his guide due to "leaving" Elitepvpers.

The usual problem with in game item mall DC is due to a windows service not running. The easy way to fix it is shown below.

Step 1: Open Services.msc
Step 1 Image:


Step 2: Find "Distributed Transaction Coordinator" in the new window.
Step 2 Image:


Step 3: Right-Click on "Distributed Transaction Coordinator" and select Properties
Step 3 Image:


Step 4: Make sure the general tab looks like the image above, then go to Log On.
Step 4 Image:


Step 5: Click the Radio Button next to This Account, and make sure it says Network Service. The NetworkService account does not have a password, so anything entered into that field will be ignored.

Step 6: Click Apply, then go back to the General Tab and click Start.
Step 6 Image:

That should cover the service error when DCing from the item mall. Make sure you do this on the computer RUNNING the SERVER, not a client computer, as that doesn't really matter. Other errors are probably from SQL errors, and if you have those, post the errors on THIS thread, and I'll solve them as you post.

Good luck.

Hi, I did it the way you taught it, but I still can not buy the store ...

[RebirthEpic]

You Have To Pay Attention To The Steps Correctly.

[[ADM]Festa]

Estou com problema de compra algo no item mall. Sempre da dc quando eu compro algo! Alguem ajuda ae pfv?

[[DEV]Wan]

Originally Posted by [ADM]Festa

Estou com problema de compra algo no item mall. Sempre da dc quando eu compro algo! Alguem ajuda ae pfv?

iae mano me enviar seu discord ou skype vou lhe ajudar