Register for your free account! | Forgot your password?

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

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

Advertisement



Does anyone know how to fix this?

Discussion on Does anyone know how to fix this? within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2011
Posts: 214
Received Thanks: 205
Does anyone know how to fix this?

hey guys i got problem >.<

Code:
2011-03-09 11:01:11 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'PS_USERDB01' is not configured for RPC., SQL STATE: 42000, NATIVE ERROR: 7411 (0x1CF3)

2011-03-09 11:01:11 ::SaveCharacter 236 test ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(236,1, 0,5, 14,12,9,8,7,15, 250,85,195, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0, 0,0,0,0, 0,0)}
Code:
2011-03-09 11:16:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'game' is not configured for RPC., SQL STATE: 42000, NATIVE ERROR: 7411 (0x1CF3)

2011-03-09 11:16:02 SaveBuyPointItem 239 Sadie qerr=-1, {?=call usp_Save_User_BuyPointItems_PayLetterT(115,239,1500,'PK_shaiy0001','2011-03-09 11:16:02',1)}

2011-03-09 12:04:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'game' is not configured for RPC., SQL STATE: 42000, NATIVE ERROR: 7411
and I cant find Usp Save User BuyPointItems_Payletter.. does anyone have it? if yes pls can you give me? thx alot =)

i got these error after i used Bane's Linked server query >.<

and this is my save char info:
Code:
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_Char_Info_E]    Script Date: 03/09/2011 23:50:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO








/****** Object:  Stored Procedure dbo.usp_Save_Char_Info_E    Script Date: 2008-6-7 18:31:57 ******/

/****** Object:  Stored Procedure dbo.usp_Save_Char_Info_E    Script Date: 2008/3/15 下午 05:25:52 ******/




ALTER Proc [dbo].[usp_Save_Char_Info_E]

@CharID int,
@Level int,
@StatPoint smallint,
@SkillPoint smallint,
@Str smallint,
@Dex smallint,
@Rec smallint,
@Int smallint,
@Wis smallint,
@Luc smallint,
@Hp smallint,
@Mp smallint,
@Sp smallint,
@Map smallint,
@Dir smallint,
@Exp int,
@Money int,
@Posx real,
@Posy real,
@Posz real,
@Hg int,
@Vg int,
@Cg int,
@Og int,
@Ig int,
@K1 int = null,
@K2 int = null,
@K3 int = null,
@K4 int = null,
@KillLevel tinyint,
@DeadLevel tinyint

AS

SET NOCOUNT ON

DECLARE @ServerID int
DECLARE @UID varchar (18)
SET @ServerID = 1

UPDATE Chars
SET [Level] = @Level, StatPoint = @StatPoint, SkillPoint = @SkillPoint,
[Str] = @Str, dex = @Dex, Rec = @Rec, [int] = @Int, Wis = @Wis, Luc = @Luc,
HP = @Hp, Mp = @Mp, Sp = @Sp,
Map = @Map, dir = @Dir, [exp] = @Exp, [money] = @Money,
PosX = @Posx, PosY = @PosY, PosZ = @PosZ, hg = @Hg, vg = @Vg, cg = @Cg, og = @Og, ig = @Ig, 
KillLevel=@KillLevel, DeadLevel=@DeadLevel,LeaveDate=GETDATE()
WHERE CharID = @CharID
--UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE CharID=@CharID

--SELECT @Sta=LoginStatus FROM CHARS WHERE CharID = @CharID

IF( (@K1 IS NOT NULL) AND (@K2 IS NOT NULL) AND (@K3 IS NOT NULL) AND (@K4 IS NOT NULL))
BEGIN
	UPDATE Chars SET K1=@K1, K2=@K2, K3=@K3, K4=@K4 WHERE CharID=@CharID
END

--IF(@Sta=0)
--BEGIN

--END
--EXEC game.PS_UserData_IDC_T3.dbo.usp_Update_CharsPVPData_E @ServerID = @ServerID, @CharID = @CharID, @K1 = @K1, @K2 = @K2, @K3 = @K3, @K4 = @K4

IF(@@ERROR = 0 AND @@ROWCOUNT = 1)
BEGIN
--SELECT @UID=UserID FROM CHARS WHERE CharID=@CharID
--UPDATE CHARS SET LoginStatus = 0  WHERE (CharID<>@CharID) AND (UserID=@UID)
RETURN 1
END
ELSE
BEGIN
--SELECT @UID=UserID FROM CHARS WHERE CharID=@CharID
--UPDATE CHARS SET LoginStatus = 0  WHERE (CharID<>@CharID) AND (UserID=@UID)

--UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE CharID=@CharID
RETURN -1
END

SET NOCOUNT OFF
Xx.LaMin.xX is offline  
Old 12/08/2015, 13:37   #2
 
ShiroMarcelo's Avatar
 
elite*gold: 0
Join Date: May 2013
Posts: 13
Received Thanks: 5
you just need to configure the linked server game for RPC
exec sp_serveroption @server='game', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true'
ShiroMarcelo is offline  
Thanks
4 Users
Reply




All times are GMT +1. The time now is 11:57.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.