Karakter ekraninda dc problemi

[aho44 2]

Merhaba developers ailesi,
V1299 serverda karakter ekranında yeni karakter oluşturduğumda sürekli dc oluyor önceden kurulan karakterlerde böyle problem yok .
bu konuda yardımlarınızı bekliyorum .

[OzkanOzdemir 1.560]

@ aho44
Örnek vereyim;
Server dosyalarının level sınırını 59 yapmışsındır ama CREATE_NEW_CHAR prosedürü içerisinde yeni oluşturulan karakterin levelini 59 üstü bir level olarak ayarlıyordur.
Mesela 70, 80, 83 gibi bir leveldeyken Server yapabilir.

[aho44 2]

Alıntı

@ aho44
Örnek vereyim;
Server dosyalarının level sınırını 59 yapmışsındır ama CREATE_NEW_CHAR prosedürü içerisinde yeni oluşturulan karakterin levelini 59 üstü bir level olarak ayarlıyordur.
Mesela 70, 80, 83 gibi bir leveldeyken Server yapabilir.

USE [kn_online]

GO

/****** Object:  StoredProcedure [dbo].[CREATE_NEW_CHAR]    Script Date: 07/03/2019 22:16:10 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

/****** Object:  Stored Procedure dbo.CREATE_NEW_CHAR    Script Date: 6/6/2006 6:03:33 PM ******/



/****** 개체: 저장 프로시저 dbo.CREATE_NEW_CHAR    스크립트 날짜: 2002-11-14 오전 11:18:03 ******/



-- scripted by samma

-- 2002.01.17

-- 2003.02.06 sungyong 


ALTER PROCEDURE [dbo].[CREATE_NEW_CHAR]


@nRet		smallint OUTPUT, 

@AccountID 	char(21), 

@index 		tinyint,

@CharID	char(21),

@Race 		tinyint, 

@Class 	smallint, 

@Hair 		tinyint,

@Face 		tinyint, 

@Str 		tinyint, 

@Sta 		tinyint, 

@Dex 		tinyint,

@Intel 		tinyint, 

@Cha 		tinyint


AS


DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int

	SET @Row = 0	SET @Nation = 0  SET @Zone = 0  SET @PosX = 0 SET @PosZ = 0


	SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID


	IF @Row >= 5	SET @nRet =  1


	IF @Nation = 1 AND @Race > 10	SET @nRet = 2

	ELSE IF @Nation = 2 AND @Race 	ELSE IF @Nation 1 AND @Nation  2	SET @nRet = 2


	IF @nRet > 0

		RETURN


	SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID

	IF @Row > 0 

	BEGIN

		SET @nRet =  3

		RETURN

	END


	IF @CharID LIKE 'þ%' or @CharID LIKE '%þ%' or @CharID LIKE '%þ' or @CharID LIKE 'ç%' or @CharID LIKE '%ç' or @CharID LIKE '%ç%' or @CharID LIKE 'Ç%' or @CharID LIKE '%Ç' or @CharID LIKE '%Ç%' or @CharID LIKE 'ö%' or @CharID LIKE '%ö' or @CharID LIKE '%ö%' or @CharID LIKE '%Ö%' or @CharID LIKE '%Ö' or @CharID LIKE 'Ö%' or @CharID LIKE '%ü%' or @CharID LIKE '%ü' or @CharID LIKE 'ü%' or @CharID LIKE '%Ü%' or @CharID LIKE '%Ü' or @CharID LIKE 'Ü%' or @CharID LIKE '%Ý%' or @CharID LIKE '%Ý' or @CharID LIKE 'Ý%' or @CharID LIKE '%ð%' or @CharID LIKE '%ð' or @CharID LIKE 'ð%' or @CharID LIKE '%Ð%' or @CharID LIKE '%Ð' or @CharID LIKE 'Ð%'

	BEGIN

		SET @nRet =  3

		RETURN

	END



	--SET @Zone = @Nation

	SET @Zone=21

	SELECT @PosX = InitX, @PosZ = InitZ  FROM ZONE_INFO WHERE ZoneNo = @Zone



BEGIN TRAN

IF @index = 0

UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 1

UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 2

UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 3

UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 4

UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID



 INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ, sRace) 

        VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ, @Race)



exec baslangicitem @CharID

update userdata set Class = 106 , strong = '255' , sta = '180' ,strskill = '?????P??' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 101

update userdata set Class = 108 , strong = '71' , dex = '255' , sta = '169' ,strskill ='Pupdate userdata set Class = 110 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='Pupdate userdata set Class = 112 , strong = '110' , sta = '120' , intel = '230' ,strskill ='Pupdate userdata set Class = 206 , strong = '255' , sta = '180' ,strskill ='Pupdate userdata set Class = 208 , strong = '71' , dex = '255' , sta = '169' ,strskill ='Pupdate userdata set Class = 210 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='Pupdate userdata set Class = 212 , strong = '110' , sta = '120' , intel = '230' ,strskill ='P 


update userdata set Class = 106 where struserid = @CharID and @Class = 101

update userdata set Class = 108 where struserid = @CharID and @Class = 102

update userdata set Class = 110 where struserid = @CharID and @Class = 103

update userdata set Class = 112 where struserid = @CharID and @Class = 104

update userdata set Class = 206 where struserid = @CharID and @Class = 201

update userdata set Class = 208 where struserid = @CharID and @Class = 202

update userdata set Class = 210 where struserid = @CharID and @Class = 203

update userdata set Class = 212 where struserid = @CharID and @Class = 204


IF @@ERROR  0

BEGIN

ROLLBACK TRAN

SET @nRet = 4

RETURN

END


COMMIT TRAN

SET @nRet = 0

update userdata set px = 81700 , pz = 43200  

exec baslangicitem @CharID

update userdata set sRace=Race

update TB_USER set CashPoint='5000'

bendeki kod böyle nerede hata var gibi gözüküyor max level 83 başlangıçda 83 şuanda
-- mesaja ek olarak --
sorun çözülmüştür teşekkürler @Newtwo