[Help] dataserver problem

Status
Not open for further replies.
Newbie Spellweaver
Joined
Sep 1, 2006
Messages
70
Reaction score
0
Location
Asuncion
i have a problem with the dataserver.... before... yesterday i was running perfectly the dataserver and now i cannot run it.. its not running...
 
Hi, Im trying to build up a 1.02N server, but when I try to open both of the DATA SERVER files, the next message appears on screen

Error: WZ_CreateCharacter Stored Procedure Version: 1

So If anyone can help me with this problem, I will be very grateful
 
Upvote 0
Hi, Im trying to build up a 1.02N server, but when I try to open both of the DATA SERVER files, the next message appears on screen

Error: WZ_CreateCharacter Stored Procedure Version: 1

So If anyone can help me with this problem, I will be very grateful
that was shown me in 1.00M but i changed databasebuckups and worked great
 
Upvote 0
make sure you are using a full clean datbase. the "Error: WZ_CreateCharacter Stored Procedure Version: 1" happens because your Wz_CreateCharacter procedure is not in the database. check if its there, if not, do this:

Open Quesry Analysis, and enter the code provided below, select muonline database and execute the query, this will fix the error

CREATE Procedure WZ_CreateCharacter
@AccountID varchar(10), --// 拌沥 沥焊
@Name varchar(10), --// 某腐磐
@Class tinyint --// Class Type
AS
Begin

SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @Result tinyint

--// 搬苞蔼 檬扁拳
SET @Result = 0x00

--====================================================================================
-- 某腐磐 粮犁咯何 犬牢
--====================================================================================
If EXISTS ( SELECT Name FROM Character WHERE Name = @Name )
begin
SET @Result = 0x01 --// 悼老 某腐磐疙 粮犁
GOTO ProcEnd
end

BEGIN TRAN
--====================================================================================
-- 拌沥 粮犁 咯何 犬牢 棺 后 浇吩 沥焊 犬牢窍咯 历厘
--====================================================================================
If NOT EXISTS ( SELECT Id FROM AccountCharacter WHERE Id = @AccountID )
begin
INSERT INTO dbo.AccountCharacter(Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC)
VALUES(@AccountID, @Name, NULL, NULL, NULL, NULL, NULL)

SET @Result = @@Error
end
else
begin
--// 某腐磐 后 浇吩 汲沥
Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10)
SELECT @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5 FROM dbo.AccountCharacter Where Id = @AccountID
if( ( @g1 Is NULL) OR (Len(@g1) = 0))

begin
UPDATE AccountCharacter SET GameID1 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
end
else if( @g2 Is NULL OR Len(@g2) = 0)
begin
UPDATE AccountCharacter SET GameID2 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
end
else if( @g3 Is NULL OR Len(@g3) = 0)
begin
UPDATE AccountCharacter SET GameID3 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
end
else if( @g4 Is NULL OR Len(@g4) = 0)
begin
UPDATE AccountCharacter SET GameID4 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
end
else if( @g5 Is NULL OR Len(@g5) = 0)
begin
UPDATE AccountCharacter SET GameID5 = @Name
WHERE Id = @AccountID

SET @Result = @@Error
end
else
--// 秦寸 后 浇吩 沥焊啊 粮犁 窍瘤 臼促.
begin
SET @Result = 0x03
GOTO TranProcEnd
end
end




--====================================================================================
-- 某腐磐 沥焊 历厘
--====================================================================================
if( @Result <> 0 )
begin
GOTO TranProcEnd
end
else
begin
INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership,money )
SELECT @AccountID As AccountID, @Name As Name, Level, 300, @Class As Class,
Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,200000
FROM DefaultClassType WHERE Class = @Class

SET @Result = @@Error
end

TranProcEnd: -- GOTO
IF ( @Result <> 0 )
ROLLBACK TRAN
ELSE
COMMIT TRAN

ProcEnd:
SET NOCOUNT OFF
SET XACT_ABORT OFF


--====================================================================================

-- 搬苞蔼 馆券 贸府

-- 0x00 : 某腐磐 粮犁, 0x01 : 己傍肯丰, 0x02 : 某腐磐 积己 角菩 , 0x03 : 后浇吩 粮犁窍瘤 臼绰促
--====================================================================================
SELECT
CASE @Result
WHEN 0x00 THEN 0x01 --// 己傍 馆券
WHEN 0x01 THEN 0x00 --// 某腐磐 粮犁
WHEN 0x03 THEN 0x03 --// 后浇吩捞 粮犁窍瘤 臼绰促.
ELSE 0x02 --// 扁鸥 俊矾内靛绰 积己 圾菩 馆券
END AS Result
End
GO


@Loks

can you provide some screen shots of the error(s)?

thanks
 
Upvote 0
Status
Not open for further replies.
Back