Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Development
You last visited: Today at 15:39

  • Please register to post and access all features, it's quick, easy and FREE!


help my server 5.4 connection error buy in itemmall

Discussion on help my server 5.4 connection error buy in itemmall within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Sep 2013
Posts: 8
Received Thanks: 1
help my server 5.4 connection error buy in itemmall

pls help is server
Attached Images
File Type: jpg Untitled.jpg (353.5 KB, 51 views)
File Type: jpg Untitled1.jpg (141.4 KB, 46 views)



rendel12 is offline  
Old 06/21/2018, 13:03   #2
 
elite*gold: 0
Join Date: Oct 2016
Posts: 40
Received Thanks: 21
What SQL do you use?
Try to take a look at these posts: Trayne01 and shen1l


elitonfarol9 is offline  
Thanks
1 User
Old 06/23/2018, 06:15   #3
 
elite*gold: 0
Join Date: May 2018
Posts: 29
Received Thanks: 3
Accept me In Skype Rendel << Anon Anon >>
anon112 is offline  
Old 06/25/2018, 12:01   #4
 
elite*gold: 0
Join Date: Aug 2015
Posts: 120
Received Thanks: 87
PS_GameData

Quote:
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,ProductCo de,UseDate,RemainPoint,OrderNumber)
VALUES(@UseType,@UserUID,@CharID,@UsePoint,@Produc tCode,@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

C:\ShaiyaServer\SERVER\PSM_Client\Bin

ItemMallFix.dll
msado15.dll
msado15.tlh
ps_dbAgent.exe
ps_game.exe

Download;


[GM]-RazoR-* is offline  
Old 06/25/2018, 17:46   #5
 
elite*gold: 0
Join Date: Mar 2018
Posts: 168
Received Thanks: 81
Thumbs up Hey man

Quote:
Originally Posted by rendel12 View Post
pls help is server
you need PsDBAgent for ep 4.5 to fix dc +11


[DEV]Wan is offline  
Reply



« PVP Reward | How To Share The Database To one Another »

Similar Threads
Itemmall Error for SQL Server 2012
12/25/2017 - Shaiya PServer Development - 1 Replies
Hi Epvp , i use SQL Server 2012 and EP 5.4 Serverfiles i try shen1l and cups itemmal fix files and don't work when select character and start game button dc & ps_game drop this is my logs
I curse ITEMMALL, I hate ITEMMALL, I'll burn ITEMMALL [calm down szokersonik]
02/19/2016 - SRO PServer Ask the Experts - 7 Replies
Hey Fellas! As You can see my patient is over, ITEMALL ruined it. I dont fcking get it, no matter wich one(item), no matter how, if i add any new ITEM to itemmall im getting DC all time when im trying to buy it(with any other items old, existed in itemmall i dont have any problems, i can buy'em easily). IF i add exacly the same item using the same rule to NPC shop i dont have any problems, so wth is wrong with that ITEMMALL? Okay:
[HELP] Itemmall crash game Error 0
11/11/2015 - Shaiya PServer Development - 12 Replies
Hi all, i need help please .. I have edit my cash.Sdata et item.Sdata i have make a event, no problem, players can play, and now when i buy on the itemmall i have that error : connection with server has been disconnected ERROR 0, help me please i have delete and restart download in my database and i have the problem, i use SQL 2005 and i can't use 2008 R2 or 2012 ... I can't play and my players wait me :( I have test service.msc and i have error too .. Please help me ! :(
I cant buy in ItemMall. [Please Help]
06/05/2014 - SRO PServer Ask the Experts - 0 Replies
Hello guys. Add a premium and I can not buy it. I have repeated all steps again and nothing, has services on 1. I could have done wrong to not be able to buy? http://i.epvpimg.com/Ibljb.jpg
Help Itemmall error
02/01/2014 - Shaiya PServer Development - 3 Replies
When i buy an item from the item mall i get this error "Please try to reconnect to the server ERROR 1" and i executed the Item.sql and Cash.sql idk why i'm getting this error please help.



All times are GMT +1. The time now is 15:39.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2019 elitepvpers All Rights Reserved.