You last visited: Today at 23:17
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.
03/10/2011, 07:47
#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
12/08/2015, 13:37
#2
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'
All times are GMT +2. The time now is 23:18 .