Ok, I'm trying to fix the black lobby problem, and I paste this in over what I have in spInsertChar
But then I hit Execute and get this message
Any clue what the hell is going on? I believe this is the only thing making my server unplayable.
Also, I didn't post this in the Q&A section because the newest page won't load for me, so I wouldn't be able to get an answer.
Edit: If no one's gonna take some time to help a guy out, just lock this thing.
Code:
CREATE 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,10000,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,NULL,NULL)
END
GO
But then I hit Execute and get this message
Code:
Msg 2714, Level 16, State 3, Procedure spInsertChar, Line 19
There is already an object named 'spInsertChar' in the database.
Any clue what the hell is going on? I believe this is the only thing making my server unplayable.
Also, I didn't post this in the Q&A section because the newest page won't load for me, so I wouldn't be able to get an answer.
Edit: If no one's gonna take some time to help a guy out, just lock this thing.