[Guide]Fixing In-Game Item Mall

Page 2 of 3 1 2 3
09/24/2013 23:16 nubness#16
Nope, not necessarily.
09/25/2013 00:58 dorrigro#17
This tutorial has not corrected the "error 0"
10/02/2013 16:19 ltohvuey51#18
ep4.5 oke but dont fix ep 5.3 or 60 ???
10/02/2013 19:15 st.jimmy998#19
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
11/14/2013 05:23 riuga12#20
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
11/17/2013 13:06 Kenwood25#21
THaaaaaaaaaaaaanks ! VERY MUCH! <3
I have this problem, and now i fix it! My hero :)
03/31/2014 17:33 momocruz#22
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
03/31/2014 19:35 QQers19#23
Use TeddyBear94 Files
[Only registered and activated users can see links. Click Here To Register...]

And this:
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
04/01/2014 13:33 momocruz#24
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
11/10/2015 18:38 arybb#25
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:
11/10/2015 20:13 SnickQ#26
Code:
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
01/20/2019 12:17 Pandablack#27
Quote:
Originally Posted by RebeccaBlack View Post
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:
[Only registered and activated users can see links. Click Here To Register...]

Step 2: Find "Distributed Transaction Coordinator" in the new window.
Step 2 Image:
[Only registered and activated users can see links. Click Here To Register...]

Step 3: Right-Click on "Distributed Transaction Coordinator" and select Properties
Step 3 Image:
[Only registered and activated users can see links. Click Here To Register...]

Step 4: Make sure the general tab looks like the image above, then go to Log On.
Step 4 Image:
[Only registered and activated users can see links. Click Here To Register...]

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:
[Only registered and activated users can see links. Click Here To Register...]

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 ...
01/20/2019 16:11 RebirthEpic#28
You Have To Pay Attention To The Steps Correctly.
09/22/2019 23:59 [ADM]Festa#29
Estou com problema de compra algo no item mall. Sempre da dc quando eu compro algo! Alguem ajuda ae pfv?
09/23/2019 06:38 [DEV]Wan#30
Quote:
Originally Posted by [ADM]Festa View Post
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
Page 2 of 3 1 2 3