1 last problem : no msg

Newbie Spellweaver
Joined
Feb 14, 2007
Messages
8
Reaction score
0
I got my server running .
I managed to be able to let people enter my server.
They can login.
But here the problem comes ; when creating a character a < no msg > appears.
So simply said people can't create characters on my gunz.
I do have a char because imade a long while ago.
But currently neither me or members can make a character.
Please someone tell me what to do.
 
Expand GunzDB
Expand at tables,
Right Click at Fields
And select New Field

Put the name (QuestItemInfo), then the type of data: varchar (MAX) , and then you check the box that says Allow NULL data.

Now click execute.

Now open Stored Procedures,

Click new query,

and put this in:

Code:
CREATE PROCEDURE [dbo].[spSelectCharQuestItemInfoByCID]
@nCID INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
 
SELECT QuestItemInfo FROM Character Where CID = @nCID
 
END

Now click execute.

Now, open Stored Procedures, right click dbo.spInsertChar, then click
modify. At the end of the INSERT INTO Character

Code:
VALUES(@nAID,@szName,@cnt,50,@nSex,@nCostume,@nFace,@nHair,NULL,0,100000,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)

After the 0 at the end, type ,NULL don't remove the ).

Credits:

http://forum.ragezone.com/gunz-releases/questions-answers-206502.html
 
Upvote 0
Back