Genel Araştırma

SteamKO'nun Data klasörünün yani TBL dosyalarının üst version cryption olayı 1298 ve 1534 versionu arası cryptionuna ayarlanmıştır. Üst versionun kullandığı TBL dosyaları içersinde yoktur. Kısaca 2123 -> 1298 TBL dosyalarıdır. Not : Sütun ayarlamaları yapılmamıştır. 1298 için kullanacaksanız fazla olan sütunları silin. [Gizli İçerik]

[Gizli İçerik]

databaseyi uyumlu hale getirmeye çalışıyorum tüm hataları geçtim data yüklenirken kapat hatası veriyor loglar temiz fakat ebenezerde bu hata var

Kullandığım client usko clienti. Filesları 2125 den 2167 ve 2189a yükseltmeden öncede bu hata devam ediyordu version yükseltmeme rağmen hata aynı devam ediyor. Sorunun çözümünü bilen arkadaşlar bakabilrimi? Hata; http://prntscr.com/k3vgcu

Aldığım hata kodu Source: {? = CALL UPDATE_USER_DATA(?, 1, 1, 101,4, 0, 0, 0, 100, 100, 100, 60, 60, 80, 50, 50, 1, 469, ?,0, 0, 21, 0, 0, 0, 205, -1, -858993472, -858993472, 0, 0,?, ?, ?, 0, ?, 0, ?,1, 0,12, 202, 56545082, 0, 0, 0, 0, 1526522929, 0, 0)} Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function UPDATE_USER_DATA has too many arguments specified. Description: Failed to execute statement. update_user_data içeriği USE [kn_online] GO /****** Object: StoredProcedure [dbo].[UPDATE_USER_DATA] Script Date: 17.5.2018 05:13:24 ******/ 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, @bRebLevel 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(592), @strItemEx binary(584), @strSerial binary(592), @strQuest binary(600), @strQuestUse binary(100), @strRebStats binary(5), @nMannerPoint int, @nLoyaltyMonthly int, @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, bLevelRebirth = @bRebLevel, [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, strItemEx = @strItemEx, strSerial = @strSerial, sQuestCount = @sQuestCount, strQuest = @strQuest, strQuestUse = @strQuestUse, strRebStats = @strRebStats, MannerPoint = @nMannerPoint, LoyaltyMonthly = @nLoyaltyMonthly, strMemo = @strMemo, sGenieTime = @sGenieTime, strGenieOptions = @strGenieOptions, dtUpdateTime = GETDATE() WHERE strUserID = @strCharID aldığım 2. hata kodu Source: UPDATE USER_ACHIEVE_DATA SET sCoverID=0, sSkillID=0, sAchieveCount=0, strAchieve=? WHERE strUserID=? Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'USER_ACHIEVE_DATA'. Description: Failed to execute statement. anladığım kadarıyla 2. hata kodunda böyle bir tablo yok diyor. prosedürler içinde yaptığım aramada böyle bir tablo ile etkileşen her hangi bir kod görmedim. ayrıca src de yaptığım aramada da göremedim. sorun çözümleri için şimdiden teşekkür ederim

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