aliemre123

teşekkürler sorun çözüldü :)

Uyumlu Olduğu Src Linki https://www.kodevelopers.com/18001900-paylasim/233-1975-server-files-amp-source.html Resimler Alıntıdır [Gizli İçerik]

teşekkürler

monster olarak eklediğimde de aynı atak yapılmıyor

k_monster ekleyip aynı yere konumlandıracağım değil mi

update_user_datada sorun yok gibi duruyor /* ==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].[UPDATE_USER_DATA] Script Date: 1.10.2017 23:36:41 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[UPDATE_USER_DATA] @strCharID char(21), @bNation tinyint, @bRace tinyint, @sClass smallint, @nHair int, @bRank tinyint, @bTitle tinyint, @bLevel tinyint, @iExp bigint, @nLoyalty int, @bFace tinyint, @bCity tinyint, @sClanID smallint, @bFame tinyint, @sHp smallint, @sMp smallint, @sSp smallint, @bStr tinyint, @bSta tinyint, @bDex tinyint, @bIntel tinyint, @bCha tinyint, @bAuthority tinyint, @sPoints smallint, @nCoins int, @bZone tinyint, @sBind smallint, @iPosX int, @iPosZ int, @iPosY int, @dwTime int, @sQuestCount smallint, @strSkill varchar(10), @strItem binary(584), @strSerial binary(584), @strQuest binary(600), @nMannerPoint int, @nLoyaltyMonthly int, @strItemTime binary(584), @strMemo char(21), @sGenieTime smallint, @strGenieOptions char(100) AS UPDATE USERDATA SET Nation = @bNation, Race = @bRace, Class = @sClass, HairRGB = @nHair, [Rank] = @bRank, Title = @bTitle, [Level] = @bLevel, [Exp] = @iExp, Loyalty = @nLoyalty, Face = @bFace, City = @bCity, Knights = @sClanID, Fame = @bFame, Hp = @sHp, Mp = @sMp, Sp = @sSp, Strong = @bStr, Sta = @bSta, Dex = @bDex, Intel = @bIntel, Cha = @bCha, Authority = @bAuthority, Points = @sPoints, Gold = @nCoins, [Zone] = @bZone, Bind = @sBind, PX = @iPosX, PZ = @iPosZ, PY = @iPosY, dwTime = @dwTime, strSkill = @strSkill, strItem = @strItem, strSerial = @strSerial, sQuestCount = @sQuestCount, strQuest = @strQuest, MannerPoint = @nMannerPoint, LoyaltyMonthly = @nLoyaltyMonthly, strItemTime = @strItemTime, strMemo = @strMemo, sGenieTime = @sGenieTime, strGenieOptions = @strGenieOptions, dtUpdateTime = GETDATE() WHERE strUserID = @strCharID questhandlerda ne yapacağımı bilmiyorum

k_npc de ekli

şuan ortak npcler var ya kahverengi gözüküyor o tarzda tamamen monumente çeviremedim bir türlü

sonuç olumsuz ortak npcler gibi davranıyor monu

olmayacağını biliyorum ama kırmayım seni deneyim

güncel

2. görevi almaya çalıştığımda görevleri bitirip alın uyarısı geliyor ve görevi alıp relog attıgımda aldıgım görev kayboluyor ve yapılmıyor. çözümü nedir şimdiden teşekkürler

teşekkürler

teşekkürler bu sorun çözüldü ronark land sorunu devam ediyor

Evet var para olmasa uyarı verir zaten

skill açarken confirm bassak bile skill açmıyor ronark monument z ye geliyor fakat ne skill atılıyor nede r atılıyor. çözümleri bekliyorum şimdiden teşekkürler

anti virüs açıksa kapatın

teşekkür ederim sorunum çözüldü

Güncel

Ek olarak sadece warrior açıyor warrior harici hiç bir jobu açmıyor

Yeni karakter açmaya çalışırken gelen hata [ ODBC Error - 30.9.2017 3:24:46 ] ] Source: {? = CALL CREATE_NEW_CHAR(?, 0, ?, 13, 202, 64020410, 4, 60, 70, 70, 50, 50)} Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. Description: Failed to execute statement. Create_New_char prosedürü /* ==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: 30.9.2017 03:26: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 USERDATA SET zone=21 where zone = 21 DECLARE @bFree tinyint SET @bFree = 0 EXEC ITEM_VER @StrCharID IF (@@ERROR 0) BEGIN ROLLBACK TRAN RETURN 4 END COMMIT TRAN RETURN 0 item_ver prosedürü /* ==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].[ITEM_VER] Script Date: 30.9.2017 03:27:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[ITEM_VER] @strUserId varchar(21) AS BEGIN DECLARE @Class smallint DECLARE @MASTER smallint SELECT @Class = Cast(SubString(Cast(Class as varchar(3)), 2, 2) as smallint) FROM USERDATA WHERE strUserId = @strUserId IF @Class = 1 OR @Class = 5 OR @Class = 6 SET @Class = 1 IF @Class = 2 OR @Class = 7 OR @Class = 8 SET @Class = 2 IF @Class = 3 OR @Class = 9 OR @Class = 10 SET @Class = 3 IF @Class =4 OR @Class = 11 OR @Class = 12 SET @Class = 4 UPDATE USERDATA SET strItem = (SELECT strItem FROM BEGINNER_ITEM WHERE iClass = @Class), Gold = (SELECT Gold FROM BEGINNER_ITEM WHERE iClass = @Class) WHERE strUserId = @strUserId END son olarak beginner_item tablosu hata nerden kaynaklı acaba

@ OzkanOzdemir şu post kasanlara bi el atın :)

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ı

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

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