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

@ 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_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

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

teşekkürler

teşekkürler

paylaşımda uyumlu olan db yok bildiğim kadarıyla uyarlaman gerekiyor

Teşekkürler

güncel

o dosya ise notepad ile açılmıyor kodlama değiştirdiğimdede garip yazılar var

client logu hangisi oluyor log.klg dosyası var o mu

efect data yükledikten sonra kapat veriyor

güncel !

güncel

teşekkürler

güncel

Güncel

biraz daha detaylandırabilir misiniz

@ OzkanOzdemir @ KiraAmora61

paket sorunu olduğunu düşünmüyorum. farklı databasede sorunsuz bir şekilde giriş yapabiliyorum çünkü. database uyumlu hale getirmeye çalıştım orda bi yanlışım var bence ama bulamadım neresi

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

yardımlarınız için çok teşekkür ederim halloldu açabiliyorum şuan char

aynen aktarmak için silmiştim fakat oluşturamamışım benim hatam :) düzelttim şuan farklı hatalar var düzeltemezsem yazacağım

[ ODBC Error - 25.9.2017 2:38:42 ] ] Source: {? = CALL CREATE_NEW_CHAR(?, 0, ?, 13, 202, 56361829, 4, 60, 70, 70, 50, 50)} Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'CREATE_NEW_CHAR'. Description: Failed to execute statement. [ ODBC Error - 25.9.2017 2:38:44 ] ] Source: {? = CALL CREATE_NEW_CHAR(?, 0, ?, 13, 202, 56361829, 4, 60, 70, 70, 50, 50)} Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'CREATE_NEW_CHAR'. Description: Failed to execute statement. [ ODBC Error - 25.9.2017 2:39:24 ] ] Source: {? = CALL CREATE_NEW_CHAR(?, 0, ?, 13, 202, 56361829, 4, 60, 70, 70, 50, 50)} Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'CREATE_NEW_CHAR'. Description: Failed to execute statement. [ ODBC Error - 25.9.2017 2:40:31 ] ] Source: {? = CALL CREATE_NEW_CHAR(?, 0, ?, 13, 202, 56361829, 4, 60, 70, 70, 50, 50)} Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'CREATE_NEW_CHAR'. Description: Failed to execute statement.