Başlangıç Skilleri Ayarlama

~~aliemre123~~ · Eylül 29, 2017

Tüm jobların skilleri 83 lwl gibi verilmiş olarak geliyor

başlangıç lwli 1 e çektim

create_new_chara baktım nereyi düzelteceğimi göremedim

KODevelopers · Eylül 29, 2017

@ aliemre123

create_new_chara

Kod at buraya bakam Göster bakayim..

Eylül 29, 2017

hocam skill ve statlar create new charda olmayabilir. Siz userdata tablosunun stunlarındaki defoult değerlerine de bakın.

~~aliemre123~~ · Eylül 29, 2017

/*    ==Scripting Parameters==


    Source Server Version : SQL Server 2016 (13.0.4001)

    Source Database Engine Edition : Microsoft SQL Server Enterprise Edition

    Source Database Engine Type : Standalone SQL Server


    Target Server Version : SQL Server 2017

    Target Database Engine Edition : Microsoft SQL Server Standard Edition

    Target Database Engine Type : Standalone SQL Server

*/


USE [kn_online]

GO

/****** Object:  StoredProcedure [dbo].[CREATE_NEW_CHAR]    Script Date: 29.9.2017 20:59:16 ******/

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)



update USERDATA SET zone=21 where zone = 21




update userdata set Class = 101 where struserid = @strCharID and @sClass = 101

update userdata set Class = 102 where struserid = @strCharID and @sClass = 102

update userdata set Class = 103 where struserid = @strCharID and @sClass = 103

update userdata set Class = 104 where struserid = @strCharID and @sClass = 104


update userdata set Class = 201 where struserid = @strCharID and @sClass = 201

update userdata set Class = 202 where struserid = @strCharID and @sClass = 202

update userdata set Class = 203 where struserid = @strCharID and @sClass = 203

update userdata set Class = 204 where struserid = @strCharID and @sClass = 204








	DECLARE @bFree tinyint

  SET @bFree = 0



	EXEC ITEM_VER @StrCharID








	IF (@@ERROR  0)







	BEGIN

		ROLLBACK TRAN

		RETURN 4

	END

COMMIT TRAN


RETURN 0

~~aliemre123~~ · Eylül 29, 2017

@ KiraAmora61

KODevelopers · Eylül 29, 2017

Başka olması lazım LOAD_USER_DATA Da bak bi var mı at bakam.

@ aliemre123

~~aliemre123~~ · Eylül 29, 2017

Alıntı
Başka olması lazım LOAD_USER_DATA Da bak bi var mı at bakam.

@ aliemre123

/*    ==Scripting Parameters==


    Source Server Version : SQL Server 2016 (13.0.4001)

    Source Database Engine Edition : Microsoft SQL Server Enterprise Edition

    Source Database Engine Type : Standalone SQL Server


    Target Server Version : SQL Server 2017

    Target Database Engine Edition : Microsoft SQL Server Standard Edition

    Target Database Engine Type : Standalone SQL Server

*/


USE [kn_online]

GO

/****** Object:  StoredProcedure [dbo].[LOAD_USER_DATA]    Script Date: 29.9.2017 21:09:59 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO


ALTER PROCEDURE [dbo].[LOAD_USER_DATA]

@strAccountID varchar(21),

@strCharID varchar(21)

AS


DECLARE @strCharID1 varchar(21), @strCharID2 varchar(21), @strCharID3 varchar(21)


SELECT	@strCharID1 = ISNULL(strCharID1, ''), 

		@strCharID2 = ISNULL(strCharID2, ''), 

		@strCharID3 = ISNULL(strCharID3, '') 

FROM ACCOUNT_CHAR WHERE strAccountID = @strAccountID


IF (@strCharID NOT IN(@strCharID1, @strCharID2, @strCharID3))

	RETURN


SELECT Nation, Race, Class, HairRGB, [Rank], Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame, Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, Zone, Bind, PX, PZ, PY, dwTime, strSkill, strItem, strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly, strItemTime, strMemo, sGenieTime, strGenieOptions FROM USERDATA WHERE strUserID = @strCharID

KODevelopers · Eylül 29, 2017

@ aliemre123 burda birşey yok sanırım başka olması lazım.

~~EveryBodyFool~~ · Eylül 29, 2017

Alıntı
Başka olması lazım LOAD_USER_DATA Da bak bi var mı at bakam.

@ aliemre123

Başlangıç özellikleri için LOAD_USER_DATA ne alaka? Bu presedür karakter select kısmında çalışır her karakter select de skillerini mi değiştireceksin adamın.

@ aliemre123
CREATE_NEW_CHAR üzerinde düzenleme yapman gerekecek.

~~aliemre123~~ · Eylül 29, 2017

Alıntı
Başlangıç özellikleri için LOAD_USER_DATA ne alaka? Bu presedür karakter select kısmında çalışır her karakter select de skillerini mi değiştireceksin adamın.

@ aliemre123
CREATE_NEW_CHAR üzerinde düzenleme yapman gerekecek.

nasıl bir düzenleme

@ KiraAmora61

/*    ==Scripting Parameters==


    Source Server Version : SQL Server 2016 (13.0.4001)

    Source Database Engine Edition : Microsoft SQL Server Enterprise Edition

    Source Database Engine Type : Standalone SQL Server


    Target Server Version : SQL Server 2017

    Target Database Engine Edition : Microsoft SQL Server Standard Edition

    Target Database Engine Type : Standalone SQL Server

*/


USE [kn_online1]

GO

/****** Object:  StoredProcedure [dbo].[CREATE_NEW_CHAR]    Script Date: 29.9.2017 21:33:27 ******/

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)


Update WAREHOUSE set WarehouseData = 0xB813AF2F1E000100881BAF2F1E0001005823AF2F1E000100A017AF2F1E000100085AAF2F32000100D00FAF2F14000100B038B02F1E000100983CB02F1E000100C834B02F1E000100B03EAF2F1E0001004027AF2F140001009842AF2F1E00010030EEB12F14000100503CB22F14000100B0B5B02F14000100D003B12F140001009053491E0100010038B9670BA00F0100A08EB02F14000100C0DCB02F140001004015B22F140001006063B22F14000100C0C5351788130100B09E3517881301000085AF2F01000100F057B02F010001009067B02F01000100284AB92901000100158ECC1701000100FE91CC17010001008093B72F0100010090BAB72F010001004086B42F01000100D02EB92901000100201F4A3001000100201F4A300100010010A0B12F01000100708AB22F01000100A0FFB22F01000100203C491E0100010090D8B22F0100010090D8B22F0100010020C7B12F0100010080B1B22F01000100B026B32F010001000840491E0100010090D8B22F0100010090D8B22F010001001B068212010001000D0A821201000100FF0D821201000100F111821201000100313F4A1401000100313F4A14010001001B068212010001000D0A821201000100FF0D821201000100F11182120100010017404A1401000100674C4D14010001000BC4BF10302A01003BBCBF10302A010023C0BF10302A0100DBCBBF10302A0100F3C7BF10302A01004822981601000100F5988E0F1027010025918E0F102701000D958E0F10270100C5A08E0F10270100DD9C8E0F102701003026981601000100153F4F08204E0100F7239807204E0100156C800968420100AF66A707803E0100AF66A707803E010063DCC00AB0360100A784D30B204E0100B13FE10B384A01001F41E308384A0100E100B7085046010061974F09803E01007D80170A803E01001BB84D08803E01005332DE0B384A01001D821907C832010021F2A006B036010021F2A006B03601006F6E140AC8320100BD651708983A010003E97E09803E01001D821907C8320100398B1C07983A0100398B1C07983A0100FF499009C8320100AD42C40B983A0100F909AD0A50460100F3D3250AB036010010D0250AB0360100D137250AB0360100CF33250AB03601007961DF0A983A010013A4EE0A983A0100ADE6FD0A983A010063AE480BB036010041A1450BB0360100FF27470BB0360100F19B450BB0360100AF22470BB03601006DA9480BB03601003947BC0AE02E01001B47BC0AE02E01005747BC0AC83201005D00570B684201003F00570B803E01007B00570B50460100601E981601000100601E981601000100601E98160100010083AFD00C495C0100B3A7D00C6E4101009BABD00C495C010053B7D00C495C01006BB3D00C495C0100601E981601000100BF09330F6E410100EF01330F6E410100D705330F6E4101008F11330F6E410100A70D330F6E410100601E981601000100A1366410AA370100D12E6410AA370100B9326410AA370100713E6410AA370100893A6410AA370100601E981601000100A16395116E410100D15B95116E410100B95F95116E410100716B95116E410100896795116E410100601E981601000100C3F1DF0C495C0100F3E9DF0C495C0100DBEDDF0C495C010093F9DF0C495C0100ABF5DF0C495C010038FB971601000F27FF4B420FFA4901002F44420FFA4901001748420FFA490100CF53420FFA490100E74F420FFA49010020FF971601000F27E1787310C53D010011717310C53D0100F9747310C53D0100B1807310C53D0100C97C7310C53D01000803981601000F27E1A5A411FA490100119EA411FA490100F9A1A411FA490100B1ADA411FA490100C9A9A411FA490100F006981601000F274376FE0C25620100736EFE0C256201005B72FE0C256201002B7AFE0C25620100137EFE0C25620100D80A9816010001007FD0600FD54F0100AFC8600FD54F010097CC600FD54F010067D4600FD54F01004FD8600FD54F0100C00E98160100010061FD9110A043010091F59110A043010079F99110A043010049019210A043010031059210A0430100A812981601000100612AC311D54F01009122C311D54F01007926C311D54F0100492EC311D54F01003132C311D54F01009016981601000100 where WarehouseData = 0x00


update USERDATA SET zone=21 where zone = 21


--HUMAN WARRİOR--

update userdata set Class = 206 ,strong = '255' , sta = '177' ,Dex='60',Cha='50',Intel='50', [level] = '83' where struserid = @strCharID and @sClass = 201

--HUMAN WARRİOR--



--HUMAN ROGUE--

update userdata set Class = 208 ,strong = '60' , dex = '255' , sta = '177',Intel='50',Cha='50' , [level] = '83' where struserid = @strCharID and @sClass = 202

--HUMAN ROGUE--



--HUMAN MAGİCİAN--

update userdata set Class = 210 ,strong = '51' , sta = '135' ,Dex='60', cha = '186' , intel = '160', [level] = '83' where struserid = @strCharID and @sClass = 203

--HUMAN MAGİCİAN--



--HUMAN PRİEST--

update userdata set Class = 212 ,strong = '194' , sta = '84' , intel = '194',Dex='70',Cha='50' ,[level] = '83' where struserid = @strCharID and @sClass = 204

--HUMAN PRİEST--






 -----------------------------------------------


--KARUS WARRİOR--

update userdata set Class = 106 ,strong = '255' , sta = '177' ,Dex='60',Cha='50',Intel='50', [level] = '83' where struserid = @strCharID and @sClass = 101

--KARUS WARRİOR--



--KARUS ROGUE--

update userdata set Class = 108 ,strong = '60' , dex = '255' , sta = '177',Intel='50',Cha='50' , [level] = '83' where struserid = @strCharID and @sClass = 102

--KARUS ROGUE--



--KARUS MAGİCİAN--

update userdata set Class = 110 ,strong = '51' , sta = '135' ,Dex='60', cha = '186' , intel = '160', [level] = '83' where struserid = @strCharID and @sClass = 103

--KARUS MAGİCİAN--



--KARUS PRİEST--

update userdata set Class = 112 ,strong = '194' , sta = '84' , intel = '194',Dex='70',Cha='50' ,[level] = '83' where struserid = @strCharID and @sClass = 104

--KARUS PRİEST--








update userdata set Class = 106 where struserid = @strCharID and @sClass = 101

update userdata set Class = 108 where struserid = @strCharID and @sClass = 102

update userdata set Class = 110 where struserid = @strCharID and @sClass = 103

update userdata set Class = 112 where struserid = @strCharID and @sClass = 104


update userdata set Class = 206 where struserid = @strCharID and @sClass = 201

update userdata set Class = 208 where struserid = @strCharID and @sClass = 202

update userdata set Class = 210 where struserid = @strCharID and @sClass = 203

update userdata set Class = 212 where struserid = @strCharID and @sClass = 204








	DECLARE @bFree tinyint

  SET @bFree = 0



	EXEC ITEM_VER @StrCharID








	IF (@@ERROR  0)







	BEGIN

		ROLLBACK TRAN

		RETURN 4

	END

COMMIT TRAN


RETURN 0

~~EveryBodyFool~~ · Eylül 29, 2017

@ aliemre123

İlk önce oyunda karakteri açıcaksın sonra skill pointlerini verip USERDATA kısmında skill stunundan verinin binary karşılığını alacaksın. Senin database inde stun tipi ney bilmiyorum ondan binary dedim. Örnek 0x0ABAC154 şeklinde olacak. Sonra bunu


Update WAREHOUSE set WarehouseData = 0xB813AF2F1E000100881BAF2F1E0001005823AF2F1E000100A017AF2F1E000100085AAF2F32000100D00FAF2F14000100B038B02F1E000100983CB02F1E000100C834B02F1E000100B03EAF2F1E0001004027AF2F140001009842AF2F1E00010030EEB12F14000100503CB22F14000100B0B5B02F14000100D003B12F140001009053491E0100010038B9670BA00F0100A08EB02F14000100C0DCB02F140001004015B22F140001006063B22F14000100C0C5351788130100B09E3517881301000085AF2F01000100F057B02F010001009067B02F01000100284AB92901000100158ECC1701000100FE91CC17010001008093B72F0100010090BAB72F010001004086B42F01000100D02EB92901000100201F4A3001000100201F4A300100010010A0B12F01000100708AB22F01000100A0FFB22F01000100203C491E0100010090D8B22F0100010090D8B22F0100010020C7B12F0100010080B1B22F01000100B026B32F010001000840491E0100010090D8B22F0100010090D8B22F010001001B068212010001000D0A821201000100FF0D821201000100F111821201000100313F4A1401000100313F4A14010001001B068212010001000D0A821201000100FF0D821201000100F11182120100010017404A1401000100674C4D14010001000BC4BF10302A01003BBCBF10302A010023C0BF10302A0100DBCBBF10302A0100F3C7BF10302A01004822981601000100F5988E0F1027010025918E0F102701000D958E0F10270100C5A08E0F10270100DD9C8E0F102701003026981601000100153F4F08204E0100F7239807204E0100156C800968420100AF66A707803E0100AF66A707803E010063DCC00AB0360100A784D30B204E0100B13FE10B384A01001F41E308384A0100E100B7085046010061974F09803E01007D80170A803E01001BB84D08803E01005332DE0B384A01001D821907C832010021F2A006B036010021F2A006B03601006F6E140AC8320100BD651708983A010003E97E09803E01001D821907C8320100398B1C07983A0100398B1C07983A0100FF499009C8320100AD42C40B983A0100F909AD0A50460100F3D3250AB036010010D0250AB0360100D137250AB0360100CF33250AB03601007961DF0A983A010013A4EE0A983A0100ADE6FD0A983A010063AE480BB036010041A1450BB0360100FF27470BB0360100F19B450BB0360100AF22470BB03601006DA9480BB03601003947BC0AE02E01001B47BC0AE02E01005747BC0AC83201005D00570B684201003F00570B803E01007B00570B50460100601E981601000100601E981601000100601E98160100010083AFD00C495C0100B3A7D00C6E4101009BABD00C495C010053B7D00C495C01006BB3D00C495C0100601E981601000100BF09330F6E410100EF01330F6E410100D705330F6E4101008F11330F6E410100A70D330F6E410100601E981601000100A1366410AA370100D12E6410AA370100B9326410AA370100713E6410AA370100893A6410AA370100601E981601000100A16395116E410100D15B95116E410100B95F95116E410100716B95116E410100896795116E410100601E981601000100C3F1DF0C495C0100F3E9DF0C495C0100DBEDDF0C495C010093F9DF0C495C0100ABF5DF0C495C010038FB971601000F27FF4B420FFA4901002F44420FFA4901001748420FFA490100CF53420FFA490100E74F420FFA49010020FF971601000F27E1787310C53D010011717310C53D0100F9747310C53D0100B1807310C53D0100C97C7310C53D01000803981601000F27E1A5A411FA490100119EA411FA490100F9A1A411FA490100B1ADA411FA490100C9A9A411FA490100F006981601000F274376FE0C25620100736EFE0C256201005B72FE0C256201002B7AFE0C25620100137EFE0C25620100D80A9816010001007FD0600FD54F0100AFC8600FD54F010097CC600FD54F010067D4600FD54F01004FD8600FD54F0100C00E98160100010061FD9110A043010091F59110A043010079F99110A043010049019210A043010031059210A0430100A812981601000100612AC311D54F01009122C311D54F01007926C311D54F0100492EC311D54F01003132C311D54F01009016981601000100 where WarehouseData = 0x00

bu kısmın altında UPDATE şeklinde koyabilirsin.
örnek :


UPDATE USERDATA set Skill = 0x0ABAC154 WHERE strUserID = @strCharID

KODevelopers · Eylül 29, 2017

@ EveryBodyFool

Bazıları select ellemeden en altı ekliyor..

~~aliemre123~~ · Eylül 29, 2017

Alıntı

@ aliemre123

İlk önce oyunda karakteri açıcaksın sonra skill pointlerini verip USERDATA kısmında skill stunundan verinin binary karşılığını alacaksın. Senin database inde stun tipi ney bilmiyorum ondan binary dedim. Örnek 0x0ABAC154 şeklinde olacak. Sonra bunu


Update WAREHOUSE set WarehouseData = 0xB813AF2F1E000100881BAF2F1E0001005823AF2F1E000100A017AF2F1E000100085AAF2F32000100D00FAF2F14000100B038B02F1E000100983CB02F1E000100C834B02F1E000100B03EAF2F1E0001004027AF2F140001009842AF2F1E00010030EEB12F14000100503CB22F14000100B0B5B02F14000100D003B12F140001009053491E0100010038B9670BA00F0100A08EB02F14000100C0DCB02F140001004015B22F140001006063B22F14000100C0C5351788130100B09E3517881301000085AF2F01000100F057B02F010001009067B02F01000100284AB92901000100158ECC1701000100FE91CC17010001008093B72F0100010090BAB72F010001004086B42F01000100D02EB92901000100201F4A3001000100201F4A300100010010A0B12F01000100708AB22F01000100A0FFB22F01000100203C491E0100010090D8B22F0100010090D8B22F0100010020C7B12F0100010080B1B22F01000100B026B32F010001000840491E0100010090D8B22F0100010090D8B22F010001001B068212010001000D0A821201000100FF0D821201000100F111821201000100313F4A1401000100313F4A14010001001B068212010001000D0A821201000100FF0D821201000100F11182120100010017404A1401000100674C4D14010001000BC4BF10302A01003BBCBF10302A010023C0BF10302A0100DBCBBF10302A0100F3C7BF10302A01004822981601000100F5988E0F1027010025918E0F102701000D958E0F10270100C5A08E0F10270100DD9C8E0F102701003026981601000100153F4F08204E0100F7239807204E0100156C800968420100AF66A707803E0100AF66A707803E010063DCC00AB0360100A784D30B204E0100B13FE10B384A01001F41E308384A0100E100B7085046010061974F09803E01007D80170A803E01001BB84D08803E01005332DE0B384A01001D821907C832010021F2A006B036010021F2A006B03601006F6E140AC8320100BD651708983A010003E97E09803E01001D821907C8320100398B1C07983A0100398B1C07983A0100FF499009C8320100AD42C40B983A0100F909AD0A50460100F3D3250AB036010010D0250AB0360100D137250AB0360100CF33250AB03601007961DF0A983A010013A4EE0A983A0100ADE6FD0A983A010063AE480BB036010041A1450BB0360100FF27470BB0360100F19B450BB0360100AF22470BB03601006DA9480BB03601003947BC0AE02E01001B47BC0AE02E01005747BC0AC83201005D00570B684201003F00570B803E01007B00570B50460100601E981601000100601E981601000100601E98160100010083AFD00C495C0100B3A7D00C6E4101009BABD00C495C010053B7D00C495C01006BB3D00C495C0100601E981601000100BF09330F6E410100EF01330F6E410100D705330F6E4101008F11330F6E410100A70D330F6E410100601E981601000100A1366410AA370100D12E6410AA370100B9326410AA370100713E6410AA370100893A6410AA370100601E981601000100A16395116E410100D15B95116E410100B95F95116E410100716B95116E410100896795116E410100601E981601000100C3F1DF0C495C0100F3E9DF0C495C0100DBEDDF0C495C010093F9DF0C495C0100ABF5DF0C495C010038FB971601000F27FF4B420FFA4901002F44420FFA4901001748420FFA490100CF53420FFA490100E74F420FFA49010020FF971601000F27E1787310C53D010011717310C53D0100F9747310C53D0100B1807310C53D0100C97C7310C53D01000803981601000F27E1A5A411FA490100119EA411FA490100F9A1A411FA490100B1ADA411FA490100C9A9A411FA490100F006981601000F274376FE0C25620100736EFE0C256201005B72FE0C256201002B7AFE0C25620100137EFE0C25620100D80A9816010001007FD0600FD54F0100AFC8600FD54F010097CC600FD54F010067D4600FD54F01004FD8600FD54F0100C00E98160100010061FD9110A043010091F59110A043010079F99110A043010049019210A043010031059210A0430100A812981601000100612AC311D54F01009122C311D54F01007926C311D54F0100492EC311D54F01003132C311D54F01009016981601000100 where WarehouseData = 0x00

bu kısmın altında UPDATE şeklinde koyabilirsin.
örnek :


UPDATE USERDATA set Skill = 0x0ABAC154 WHERE strUserID = @strCharID

anladım fakat karakteri açtığımda skiller verili şekilde geliyor. ben 1 lwl başlangıç skill 0 olarak ayarlamak istiyorum

~~aliemre123~~ · Eylül 29, 2017

sorun çözüldü
BEGINNER_ITEM içinde strskill diye bi sütun oluşturulmuş

UPDATE USERDATA SET strItem = (SELECT strItem1 FROM BEGINNER_ITEM WHERE iClass = @Class),strSkill = (SELECT strskill FROM BEGINNER_ITEM WHERE iClass = @Class), Gold = (SELECT Gold FROM BEGINNER_ITEM WHERE iClass = @Class)   WHERE strUserId = @strUserId

kodundaki

strSkill = (SELECT strskill FROM BEGINNER_ITEM WHERE iClass = @Class)

bölümünü çı*****ca sorun ortadan kalktı

Giriş Yap

Başlangıç Skilleri Ayarlama

Önerilen Mesajlar

aliemre123 25

İletiyi paylaş

Link to post

Sitelerde Paylaş

KODevelopers 443

İletiyi paylaş

Link to post

Sitelerde Paylaş

aakinci 142

İletiyi paylaş

Link to post

Sitelerde Paylaş

aliemre123 25

İletiyi paylaş

Link to post

Sitelerde Paylaş

aliemre123 25

İletiyi paylaş

Link to post

Sitelerde Paylaş

KODevelopers 443

İletiyi paylaş

Link to post

Sitelerde Paylaş

aliemre123 25

İletiyi paylaş

Link to post

Sitelerde Paylaş

KODevelopers 443

İletiyi paylaş

Link to post

Sitelerde Paylaş

EveryBodyFool 199

İletiyi paylaş

Link to post

Sitelerde Paylaş

aliemre123 25

İletiyi paylaş

Link to post

Sitelerde Paylaş

EveryBodyFool 199

İletiyi paylaş

Link to post

Sitelerde Paylaş

KODevelopers 443

İletiyi paylaş

Link to post

Sitelerde Paylaş

aliemre123 25

İletiyi paylaş

Link to post

Sitelerde Paylaş

aliemre123 25

İletiyi paylaş

Link to post

Sitelerde Paylaş

Ana Sayfa

Aktivite

Üye Mağazası

142