ALTER PROCEDURE [dbo].[LOAD_USER_DATA]
@AccountID CHAR(21),
@id CHAR(21),
@nRet SMALLINT OUTPUT
AS
DECLARE @PosX INT, @PosY INT, @PosZ INT, @Zone tinyint, @charid1 CHAR(21), @charid2 CHAR(21), @charid3 CHAR(21), @speedhack VARCHAR(250), @dupeyakala INT , @Nation tinyint

SET @nRet = 0

SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @id NOT IN(@charid1, @charid2, @charid3)
BEGIN
RETURN 0
END

SELECT @Zone = Zone, @PosX = px, @PosY = py, @PosZ = pz FROM USERDATA WHERE strUserId = @id
IF @Zone = 21
BEGIN
SET @PosX = 81700
SET @PosY = 0
SET @PosZ = 43200
END


##############This TO dont be run IN 14-16 AND 23 -01################################
SELECT @Zone = Zone , @Nation = Nation FROM USERDATA WHERE strUserId = @id
IF @Zone = 1 AND @Nation = 2
BEGIN
UPDATE USERDATA SET Zone = 2 WHERE strUserId = @id
END

IF @Zone = 2 AND @Nation = 1
BEGIN
UPDATE USERDATA SET Zone = 1 WHERE strUserId = @id
END
##############This TO dont be run IN 14-16 AND 23 -01################################



-- # Today Ladder Rank Start # --
UPDATE USERDATA SET LoyaltyTodayNow = LoyaltyMonthly FROM USERDATA WHERE strUserId = @id
UPDATE USERDATA SET LoyaltyToday = 0 FROM USERDATA WHERE strUserId = @id
-- # Today Ladder Rank End # --

-- # Automatic Today Loyalty Restarter Stat # --

DECLARE @HourForLT tinyint
DECLARE @MinuteForLT tinyint
SET @HourForLT = DATEPART(HOUR,GETDATE())
SET @MinuteForLT = DATEPART(MINUTE,GETDATE())

IF (@HourForLT = 0) AND (@MinuteForLT = 0)
BEGIN
UPDATE USERDATA SET Loyaltytoday = 0 WHERE Loyaltytoday != 0
END
ELSE IF (@HourForLT = 0) AND (@MinuteForLT = 5)
BEGIN
UPDATE USERDATA SET Loyaltytoday = 0 WHERE Loyaltytoday != 0
END
ELSE IF (@HourForLT = 0) AND (@MinuteForLT = 10)
BEGIN
UPDATE USERDATA SET Loyaltytoday = 0 WHERE Loyaltytoday != 0
END
ELSE IF (@HourForLT = 12) AND (@MinuteForLT = 0)
BEGIN
UPDATE USERDATA SET Loyaltytoday = 0 WHERE Loyaltytoday != 0
END
ELSE IF (@HourForLT = 12) AND (@MinuteForLT = 5)
BEGIN
UPDATE USERDATA SET Loyaltytoday = 0 WHERE Loyaltytoday != 0
END
ELSE IF (@HourForLT = 12) AND (@MinuteForLT = 10)
BEGIN
UPDATE USERDATA SET Loyaltytoday = 0 WHERE Loyaltytoday != 0
END
UPDATE USERDATA SET City = 100 WHERE City > 100
-- # Automatic Today Loyalty Restarter End # --

UPDATE USERDATA SET Class = Class + 1 WHERE strUserId = @id AND Level > 59 AND Class IN(105, 107, 109, 111, 205, 207, 209, 211)
UPDATE USERDATA SET Zone = 21 WHERE Zone IN(61, 62, 71, 72) AND strUserId = @id

--Si (forum display name update)
UPDATE forum.dbo.phpbb_users SET username = @charid1, username_clean = @charid1 WHERE loginname = @AccountID

UPDATE SERVERS SET players = (SELECT COUNT(*) FROM CURRENTUSER)

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, @PosX, @PosZ, @PosY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly
FROM USERDATA WHERE strUserId = @id

SET @nRet = @@ROWCOUNT

SELECT @speedhack = strHackToolName FROM HACKTOOL_USERLOG WHERE strCharID = @id
IF @speedhack LIKE '%Something that resembles Speedhack has been detected on this PC. (Code = 10303)%'
BEGIN
SET @nRet = 0
END
RETURN