
Bu patchi indir daha sonra ui.us.tbl'nin yedeğini al patchdeki tbl ile değiştir
USE [kn_online]
GO
/****** Object: StoredProcedure [dbo].[LOAD_USER_DATA] Script Date: 05/05/2012 12:18:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[LOAD_USER_DATA]
@id char(21),
@nRet smallint OUTPUT
AS
SELECT Nation, Race, Class, HairColor, 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
FROM USERDATA WHERE strUserId = @id
SET @nRet = @@RowCount
RETURN
Öncelikle ;
Tamer'in soruceler ile paylaştığı ajuardı kullan,
Tüm dosyaları kapat ve şunu Query'e uygula ;
Kod:USE [kn_online] GO /****** Object: StoredProcedure [dbo].[LOAD_USER_DATA] Script Date: 05/05/2012 12:18:45 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[LOAD_USER_DATA] @id char(21), @nRet smallint OUTPUT AS SELECT Nation, Race, Class, HairColor, 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 FROM USERDATA WHERE strUserId = @id SET @nRet = @@RowCount RETURN