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!

|HELP!| with my private server!!!

Newbie Spellweaver
Joined
Jul 12, 2006
Messages
17
Reaction score
0
ok so i made a private server...but when iam geting in the character(not the account) its not working! (the game freezing and nothing happening)
i tryed to reset the server (i started all over again) and its not helped..
i tryed to reset my computer and nothing helped me!!!

i realy need yours help!!!!
(and sry for my bad english)
 
Last edited:
Banned
Banned
Joined
Jan 13, 2007
Messages
1,898
Reaction score
65
lol, i had the same problem,
put this into dbo.spInsertChar

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,50,@nSex,@nCostume,@nFace,@nHair,NULL,0,100,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,null,null)
END

then it will work
 
Upvote 0
ThuGie.NL - Webmaster
Joined
Apr 16, 2006
Messages
607
Reaction score
55
This insertchar is a failure..
like this..
What if you make 4 characters
they get the id 0 1 2 3
i delete char with id 0 make a new character then i have 2 characters with id 3 ;).
and that would mess up when you login.

When i have time i have to fix it though for lg's server
But atm kinda to lazy :p.

and wtf
DECLARE @cid INT
SELECT @cid=COUNT(*)
FROM Character
totaly not needed so far i can see
it just counts how many characters are in the database for nothing...
and for

DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROM Character
WHERE AID = @nAID
well SELECT TOP 4 @cnt=C etc
would make it use less cpu/memory ;).
since it stops searching the db after 4 result else it checks the whole table while it already has 4 ;).
 
Upvote 0
Back
Top