/****** Object:  Stored Procedure dbo.LOAD_USER_DATA    Script Date: 6/6/2006 6:03:33 PM ******/

/****** ??: ?? ???? dbo.LOAD_USER_DATA    ???? ??: 2002-11-14 ?? 11:18:04 ******/
-- modifed by Sungyong 2003.04.09
-- 2004.04.22 ?????(LoyaltyMonthly) ?? arycoat

CREATE PROCEDURE LOAD_USER_DATA
@AccountID	char(21),
@id		char(21),
@nRet		smallint OUTPUT

AS

 -- inserted by samma 2003.07.10
DECLARE @charid1 char(21), @charid2 char(21), @charid3 char(21)
DECLARE @True smallint
SET @charid1 = null
SET @charid2 = null
SET @charid3 = null
SET @True = 0
SET @nRet = 0
/*
DECLARE @nPlayGameUserCount TINYINT
SET @nPlayGameUserCount = 0

SELECT @nPlayGameUserCount = COUNT(*) FROM [192.168.178.30].[knight_Account].[dbo].[CURRENTUSER] WHERE strAccountID = @AccountID
IF @nPlayGameUserCount > 0
BEGIN
	SET @nRet = 0
	RETURN
END
*/
	SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
	IF @id = @charid1 or @id = @charid2 or @id = @charid3 
		SET @True = 1
	IF @True = 0
	BEGIN
		SET @nRet = 0
		RETURN
	END

UPDATE USERDATA Set Exp = 30000000 WHERE strUserID = @id

 
-- Ganks Tarafindan *******.COM için Kodlanmistir!
-- *******.Com Disinda PayLasilmasi YASAKTIR.
-- Bu yaziyi degistiren toptur...
-- Kod Ganks Aganindir ben sadece relogda ban olmasini istiyenler için kod üzerinde biraz oynadim, paylasmak istedim hersey ******* için...
-- Top olmayiz ins xD Ganks a saygilar...
DECLARE @dupe_check int

select @dupe_check = count(Userid) FROM gokhan WHERE Userid = @id
if @dupe_check > 0
begin
update userdata set Authority = '255' where StrUserID = @id
end 

DECLARE @itemaldimi int

select @itemaldimi = [level] FROM USERDATA WHERE StrUserID = @id
if @itemaldimi = '1'
begin
exec baslangicitem @id
update userdata set [level] = '1' ,[strSkill] = '', [Points] = '' where strUserID = @id
end

DECLARE @levelkontrol int

SELECT @levelkontrol = Level  FROM USERDATA WHERE StrUserID = @id
if @levelkontrol = 58 or @levelkontrol = 59




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
exec rundupecheck2@id

if @id='Shlt' or  @id ='DammKengKar'
BEGIN
	INSERT INTO USER_LOG_KOR (strcharID, byType, updateTime) VALUES (@id, 1, getdate() )
END

RETURN

GO