Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Character Select Black Screen

Newbie Spellweaver
Joined
Jan 7, 2007
Messages
24
Reaction score
0
Well heres the drift of things.

I made my own server (hurray!)
I have my own character and custom items (Hazah)
I have full quest (Hoot-rah)
I can't get past character select screen (gasp!)
^
|
Spamish so ill go to real point.

I get to character select, I select my character... and then the lobby is all black, nothing to touch, and no matter how much or where i click, nothing happens.

Anyone know the fix to this?
 
Newbie Spellweaver
Joined
Jan 7, 2007
Messages
24
Reaction score
0
Maxtrax... you rock. I literally am so happy right now. But uhh.. wheres it say 0,0, null cuz i cant find it. Heres what mine is, can you copy+paste yours to the fix?
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SET NOCOUNT ON;

DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROM Character
WHERE AID = @nAID

DECLARE @cid INT
SELECT @cid=COUNT(*)
FROM Character

INSERT INTO Character
VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,50000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
END
 
Upvote 0
Banned
Banned
Joined
Jan 13, 2007
Messages
1,898
Reaction score
65
well that not right, this is tho
Code:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SET NOCOUNT ON;

DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROM Character
WHERE AID = @nAID

DECLARE @cid INT
SELECT @cid=COUNT(*)
FROM Character

INSERT INTO Character
VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,50000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null)
END
 
Upvote 0
Back
Top