Ep.5 Shaiya item mall Error= 0

[Iulian01]

Hello I met this problem earlier today when i tryed to modify my item mall. I extracted Cash.SData out of data.sah of my own client and modified in there with some items. When I try to buy them i get dced.(error 0). I checked the log
PS_DBAGENT_system and i got this error

2012-09-05 06:58:39 PS_DBAGENT__system log start (DBAgent01)

2012-09-05 06:58:42 connect game, Name=



2012-09-05 06:58:42 connect game, Name=



2012-09-05 07:01:14 SaveBuyPointItem 1024 tyu qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(2,1024,30000,'B1_DispersionLoop','2012-09-05 07:01:14')}

More informations:
-I use db from Svinseladden
-MSTDC on automatic
-After i login into the character the item is missing and points are reeting to 0.roll back a long one
-I changed the points from an item to 0 and it worked no dc. I guess only the items with points i get dc +rollback. My points are 100% buged bcuz i just stored some points on me ..checked them in item mall closed the item mall they dissapeared after.woot

[TeddyBear94]

did u made sure the item u wanted to buy if u noted that it gives 255 that this item is even stackable to 255? a dc mostly comes from something like that.

[Iulian01]

#Edited.

[JohnHeatz]

Well, haven't heard of an issue when it comes to working with the AP packages, would need to check what could that be because honestly, your logs are just letting us know that there might be some issue with usp_Save_User_BuyPointItems_NCash; and there is where you must start checking carefully

[Iulian01]

Well my server has unique bugs omfg o.o

USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_User_BuyPointItems_NCash]    Script Date: 9/6/2012 4:08:40 PM ******/
SET ANSI_NULLS ON
GO
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

That's how my usp_Save_User_BuyPointItems_NCash looks.

[mabejenta]

You got the same one as I do, and mine is working fine. However, it seems to me like your DB and Client aint matching with the item. Have you tried to truncate table and insert all items over again, and restart server? And what program are you using when editing item mall? For me ShStudio creates alot of bugs, so I edit my item mall with a program called "shCashShop.exe". I have never gotten any bugs with that one.

This is what I did when I got that error:

1: Truncate the productlist
2: Use shCashShop.exe to edit items in item mall, add those items you want in, and make a productcode.
3: save the file, in the folder where you have your ShStudio linked in, and open Cash.SData with ShStudio, and edit a description and save. (You just need to add a space somewhere)
4: You recieve a script called Cash.sql - run that one in SQL, and add to each line in front of the product name, the next number in line. Example without number:

INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Party Member Summon Runes','PMSR100045',99,100045,10,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0)

Example of how it's suposed to look:

INSERT INTO [PS_GameDefs].[dbo].[ProductList] values (1,'Party Member Summon Runes','PMSR100045',99,100045,10,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0)

5: Exequte the query after adding all numbers.
6: restart server.

That usually fixes all my issues with the Cash/Item mall DC's.

Hope it helps.

[accuface35]

hi, habe folgendes Problem.... ein Freund von mir wollte die Item Mall ändern er hat auch alles encryptet shaiya tool, sh studio, da dann die items geändert (stats), die item mal ebenfalls mit sh astudio aufgemacht und geändert, dann in der DB, Ps Game Defs, Product list, auch geändert, update wurde auch gemacht, aber..... im Game wird ind er Item Mall die gänderten Preise und Items nicht angezeigt, was is da falsch. hoffe auf antwort. er hat die Sachen die dort vorher drinnen waren überschrieben mit den neuen IDs, muss ier in der DB andere Product ids eingeben, weil die alten product ids ja schon vorhanden waren, wenn ja wo und wie macht er das?

[TeddyBear94]

hat er den clienten bearbeited? wenn er nur im server die sachen geändert hat aba nich im clienten dann is das das prob

[mabejenta]

Hallo. Ich bin nicht Deutsch, aber ich habe google translate, um zu versuchen, um zu sehen, was dein Problem dabei war. Und wie ich es sehe, hat google translate mir nicht helfen zu viel. aber wussten Sie sagen, dass das Problem war, dass die Elemente wie Preise und Symbole nicht in der Position mal zeigen? Wenn ja, ist die Symbole a einfache Lösung, ist alles was Sie brauchen, um in Client-Seite das Symbol Pack hinzufügen, und bekommen, dass man in. Das sollte die Symbole zu beheben. Wenn es um die die Bestellung kommt, habe I allways shCashShop.exe, diese Dinge zu beheben verwendet. Denken Sie daran, die cash.SData vor dem Import in Client zu verschlüsseln. In der Regel tut es für mich, und ich hoffe, es hilft Ihnen. Es tut mir leid um die Armen Deutsch, aber google translate nicht immer seinen "besten

[accuface35]

kann wer bitte server files hochladen, die hier im Forum sind, da sind die links tot. bitte um hilfe. server is auf epi 6 ausgelegt.

[TeddyBear94]

da sind genung upgeloadedte server files drin wenn mal ein link nich geht sag dem mod bescheid aba ansonsten findest dort alles was du brauchst!

[Iulian01]

Yeh i figure it out that ShStudio is so buggy it dosent even create good querrys

[mabejenta]

Originally Posted by Iulian01

Yeh i figure it out that ShStudio is so buggy it dosent even create good querrys

ShStudio is consithered a helping tool to help out with the developing of your server. Yes, there is bugs to it and all that, but consither it as a helping hand trying to get you to find the clues on your own. If you are constantly unhappy about something that someone spent time on making, it's not going to help you figure out how to fix the bugs. shStudio is a awesome tool! All credits to the producers of it.

[TeddyBear94]

Originally Posted by mabejenta

ShStudio is consithered a helping tool to help out with the developing of your server. Yes, there is bugs to it and all that, but consither it as a helping hand trying to get you to find the clues on your own. If you are constantly unhappy about something that someone spent time on making, it's not going to help you figure out how to fix the bugs. shStudio is a awesome tool! All credits to the producers of it.

well i just can say i love Sh studio sure it is sometimes a bit limited and u need sometimes to figure out some stuff but since i figure how do set sh studio up for my self i dont have any other problems with it besides the Skill.sdata but that seems to be an commen prob because that file is buggy like hell^^

[Iulian01]

Ok i just fiexd it 10 mins ago,Just needed a proper server instalation