21xx için 1 lvl baslangic yapma

[Netfarmko 0]

Arkadaslar 83 lvl skilller ve master acik basliyor.
1 lvl olarak baslangic icin prosedur nedir simdiden tesekkurler.

[OzkanOzdemir 1.560]

CREATE_NEW_CHAR prosedürünü kontrol eder misin?

[vestside 90]

DB de USERDATA tablosuna sağ tıkla DESIGN de. gelen pencerede [LEVEL] colum ün default değerini 1 yap. aynı zamanda skill ve statlarda column isimlerine bakarak düzeltebilirsin. tabiki @ OzkanOzdemir in bahsettiği gibi prosedür ile DB ye yazılmamış ise bu dediklerim geçerli..

[Netfarmko 0]

USE [kn_online]
GO
/****** Object: StoredProcedure [dbo].[CREATE_NEW_CHAR] Script Date: 22.07.2018 22:08:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[CREATE_NEW_CHAR]
@strAccountID varchar(21),
@index tinyint,
@strCharID varchar(21),
@bRace tinyint,
@sClass smallint,
@nHair int,
@bFace tinyint,
@bStr tinyint,
@bSta tinyint,
@bDex tinyint,
@bIntel tinyint,
@bCha tinyint
AS
DECLARE @bNation tinyint
DECLARE @bCharCount tinyint
DECLARE @bCount tinyint

SELECT @bNation = bNation, @bCharCount = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @strAccountID

--IF (@bNation = 1 AND @bRace > 10)
--RETURN 2
--ELSE IF (@bNation = 2 AND @bRace --RETURN 2
--ELSE IF (@bNation 1 AND @bNation 2)
--RETURN 2

SELECT @bCount = COUNT(strUserID) FROM USERDATA WHERE strUserID = @strCharID

IF (@bCount > 0)
RETURN 3

BEGIN TRAN
IF (@index = 0)
UPDATE ACCOUNT_CHAR SET strCharID1 = @strCharID, bCharNum += 1 WHERE strAccountID = @strAccountID
ELSE IF (@index = 1)
UPDATE ACCOUNT_CHAR SET strCharID2 = @strCharID, bCharNum += 1 WHERE strAccountID = @strAccountID
ELSE IF (@index = 2)
UPDATE ACCOUNT_CHAR SET strCharID3 = @strCharID, bCharNum += 1 WHERE strAccountID = @strAccountID
ELSE IF (@index = 3)
UPDATE ACCOUNT_CHAR SET strCharID4 = @strCharID, bCharNum += 1 WHERE strAccountID = @strAccountID

IF (@@ERROR 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRAN
RETURN 4
END

INSERT INTO USERDATA (strUserID, Nation, Race, Class, HairRGB, Face, Strong, Sta, Dex, Intel, Cha)
VALUES (@strCharID, @bNation, @bRace, @sClass, @nHair, @bFace, @bStr, @bSta, @bDex, @bIntel, @bCha)
EXEC GIVE_BEGINNER_ITEM @StrCharID
EXEC MASTER_AC @StrCharID


IF (@@ERROR 0)
BEGIN
ROLLBACK TRAN
RETURN 4
END
COMMIT TRAN

RETURN 0



Bu Şekilde Hocam

[aakinci 142]

Alıntı

USE [kn_online]
GO
/****** Object: StoredProcedure [dbo].[CREATE_NEW_CHAR] Script Date: 22.07.2018 22:08:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[CREATE_NEW_CHAR]
@strAccountID varchar(21),
@index tinyint,
@strCharID varchar(21),
@bRace tinyint,
@sClass smallint,
@nHair int,
@bFace tinyint,
@bStr tinyint,
@bSta tinyint,
@bDex tinyint,
@bIntel tinyint,
@bCha tinyint
AS
DECLARE @bNation tinyint
DECLARE @bCharCount tinyint
DECLARE @bCount tinyint

SELECT @bNation = bNation, @bCharCount = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @strAccountID

--IF (@bNation = 1 AND @bRace > 10)
--RETURN 2
--ELSE IF (@bNation = 2 AND @bRace --RETURN 2
--ELSE IF (@bNation 1 AND @bNation 2)
--RETURN 2

SELECT @bCount = COUNT(strUserID) FROM USERDATA WHERE strUserID = @strCharID

IF (@bCount > 0)
RETURN 3

BEGIN TRAN
IF (@index = 0)
UPDATE ACCOUNT_CHAR SET strCharID1 = @strCharID, bCharNum += 1 WHERE strAccountID = @strAccountID
ELSE IF (@index = 1)
UPDATE ACCOUNT_CHAR SET strCharID2 = @strCharID, bCharNum += 1 WHERE strAccountID = @strAccountID
ELSE IF (@index = 2)
UPDATE ACCOUNT_CHAR SET strCharID3 = @strCharID, bCharNum += 1 WHERE strAccountID = @strAccountID
ELSE IF (@index = 3)
UPDATE ACCOUNT_CHAR SET strCharID4 = @strCharID, bCharNum += 1 WHERE strAccountID = @strAccountID

IF (@@ERROR 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRAN
RETURN 4
END

INSERT INTO USERDATA (strUserID, Nation, Race, Class, HairRGB, Face, Strong, Sta, Dex, Intel, Cha)
VALUES (@strCharID, @bNation, @bRace, @sClass, @nHair, @bFace, @bStr, @bSta, @bDex, @bIntel, @bCha)
EXEC GIVE_BEGINNER_ITEM @StrCharID
EXEC MASTER_AC @StrCharID


IF (@@ERROR 0)
BEGIN
ROLLBACK TRAN
RETURN 4
END
COMMIT TRAN

RETURN 0



Bu Şekilde Hocam

EXEC GIVE_BEGINNER_ITEM @StrCharID bunu kaldırırsan başlangıç eşyalarını vermez.
EXEC MASTER_AC @StrCharID bunu kaldırırsan master vs. açmaz.

[Netfarmko 0]

Teşekkurler..

[Netfarmko 0]

1 lvl baslangıc için prosdr nedir arkadaslar.

[Netfarmko 0]

1 lvl baslangıc proedr yazıcak olan varmı arkadaslar

[yolcups 26]

1 level için prosedür yok ama ben şu şekilde yaptım, başlangıç itemlerini silip warrior priest vs karakter açıp editörle 1 lvl yaptım ve sonra db de actığım charlar 1 lvl oldu yanlış isem düzeltin, uzun zaman olmuştu yapalı..