Genel Araştırma

Selamun aleyküm, XGAME database üzerinde uğraşmaya devam ediyorum. Fakat başlangıç levelini ne yaptıysam düzeltemedim. Forumdaki çoğu çözümü denedim ama fayda etmiyor hala 83 Lv'de başlıyor. CREATE_NEW_CHAR prosedürüde şöyle USE [kn_online] GO /****** Object: StoredProcedure [dbo].[CREATE_NEW_CHAR] Script Date: 11.1.2019 20:57:36 ******/ 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, @strAchieve binary(3300) 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 < 10) 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 USER_ACHIEVE (strUserID, strAchieve) VALUES (@strCharID, @strAchieve) 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) --Banka Başlangıç-- Update WAREHOUSE set WarehouseData = 0xB813AF2F1E000100881BAF2F1E0001005823AF2F1E000100A017AF2F1E000100085AAF2F32000100D00FAF2F140001001029B02F0A000100B038B02F1E00010000D748301E000100B03EAF2F1E0001004027AF2F140001009842AF2F1E00010030EEB12F14000100503CB22F14000100B0B5B02F14000100D003B12F14000100808E0235010001005019023501000100A08EB02F14000100C0DCB02F140001004015B22F140001006063B22F14000100C0C5351788130100B09E3517881301000085AF2F01000100F057B02F010001009067B02F010001004086B42F01000100FE91CC1701000100158ECC1701000100F85A4F3001000100C0BEB52F01000100C0BEB52F01000100D0E5B52F01000100A063493001000100B85F493001000100775D5130201C0100708AB22F01000100A0FFB22F01000100203C491E0100010010A0B12F0100010090D8B22F01000100201F4A300100010080B1B22F01000100B026B32F010001000840491E0100010020C7B12F0100010090D8B22F01000100696EFE0C555A01005172FE0C555A01003976FE0C555A0100217AFE0C555A0100097EFE0C555A0100D80A981601000100A5C8600F054801008DCC600F0548010075D0600F054801005DD4600F0548010045D8600F05480100C00E98160100010087F59110D03B01006FF99110D03B010057FD9110D03B01003F019210D03B010027059210D03B0100A8129816010001008722C311054801006F26C31105480100572AC311054801003F2EC311054801002732C3110548010090169816010001003BBCBF10302A010023C0BF10302A01000BC4BF10302A0100F3C7BF10302A0100DBCBBF10302A010038FB971601000F27D700B708803E01003314B207C83201002F8B1C07B03601002F8B1C07B0360100302C971601000F2720FF971601000F2711B84D08983A0100F9E87E09983A01003314B207C8320100F3E47E09983A01001541E30850460100F006981601000F272D80170AC832010013821907E02E010013821907E02E0100D17D1907E02E0100D17D1907E02E01000803981601000F2739664F08384A010039938009803E010077999807384A010049729807384A010001B5A707983A010059DCC00AB03601000B3F4F08384A010095E18009803E0100CBABD30B384A01009D84D30B384A0100D38DA707983A01008703C10AB0360100678D4F08384A010067BA8009803E0100A342C40B983A0100116BC40B983A0100A566A707983A0100B52AC10AB036010095B44F08384A0100EF09AD0A50460100E9D3250AB0360100C737250AB0360100A305AD0A50460100E351C10AB0360100D10DFE0AB0360100A3E6FD0AB0360100FF34FE0AB036010025FD560B803E01002FFD560B6842010039FD560B5046010025E5EB0AB036010037CBEE0AB036010009A4EE0AB0360100A73FE10B504601004932DE0B504601004FD72E07803E0100CBAFDF0AB03601006F61DF0AB03601009D88DF0AB036010010D0250AB0360100CF33250AB036010013EBAF0AC832010037A1450BC832010059AE480BC8320100F527470BC8320100C543BC0AF82A0100D943BC0AC8320100CF43BC0AE02E01 --Banka Başlangıç-- EXEC GIVE_BEGINNER_ITEM @strCharID EXEC MASTER_AC @StrCharID IF (@@ERROR <> 0) BEGIN ROLLBACK TRAN RETURN 4 END COMMIT TRAN RETURN 0

Öncelikle herkese merhaba, versiyonu 2150 olan bir ardream pvp server kurmaya çalışıyorum ve 2 tane sorunum var birincisi, Oyuna giriş yaptığımda gate de ronark land, base ve ardream seçenekleri var. Ben ardream server kurmak istediğim için ronark land ve base yi gateden kaldırmak istiyorum. Bunu nasıl yapabilirim? İkinci sorunum ise başlangıç leveli 83 olarak ayarlanmış durumda. Bunu nasıl 59 olarak ayarlayabilirim? -- mesaja ek olarak -- Arkadaşlar 2. sorunumu çözdüm. Birinci sorunum yani ronark land ve baseyi gateden kaldırma devam etmekte 2. sorunun cevabını merak eden arkadaşlar dm den yazarsa yardımcı olurum..