Register for your free account! | Forgot your password?

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

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


help my server 5.4 connection error buy in itemmall

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, 44 views)
File Type: jpg Untitled1.jpg (141.4 KB, 39 views)



rendel12 is offline  
Old 06/21/2018, 13:03   #2
 
elite*gold: 0
Join Date: Oct 2016
Posts: 36
Received Thanks: 18
What SQL do you use?
Try to take a look at these posts: https://www.elitepvpers.com/forum/sh...rv-2012-a.html Trayne01 and https://www.elitepvpers.com/forum/sh...all-fixed.html shen1l


elitonfarol9 is online now  
Thanks
1 User
Old 06/23/2018, 06:15   #3
 
elite*gold: 0
Join Date: May 2018
Posts: 16
Received Thanks: 1
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: 101
Received Thanks: 67
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; https://www.elitepvpers.com/forum/sh...all-fixed.html


[GM]-RazoR-* is offline  
Old 06/25/2018, 17:46   #5
 
elite*gold: 0
Join Date: Mar 2018
Posts: 107
Received Thanks: 22
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,...
[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...
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 +2. The time now is 14:11.


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

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