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

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

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
-- 
Delete CURRENTUSER Where strAccountID = @AccountID
--
DECLARE @class char(21),@levelim int
set @class = (select class from userdata where struserid = @id)
Select @levelim = [Level] FROM USERDATA WHERE strUserID = @id
if @class = 105 AND @levelim > 59 
begin
update userdata set class = 106 where struserid = @id
end

if @class = 107 AND @levelim > 59 
begin
update userdata set class = 108 where struserid = @id 
end

if @class = 109 AND @levelim > 59 
begin
update userdata set class = 110 where struserid = @id 
end

if @class = 111 AND @levelim > 59 
begin
update userdata set class = 112 where struserid = @id 
end

if @class = 205 AND @levelim > 59 
begin
update userdata set class = 206 where struserid = @id 
end

if @class = 207 AND @levelim > 59 
begin
update userdata set class = 208 where struserid = @id 
end

if @class = 209 AND @levelim > 59 
begin
update userdata set class = 210 where struserid = @id 
end

if @class = 211 AND @levelim > 59
begin
update userdata set class = 212 where struserid = @id 
end

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

BEGIN
DECLARE @PosX int, @PosZ int, @PosY int, @Zone tinyint
SELECT @Zone = Zone, @PosX = px, @PosZ = pz, @PosY = py FROM USERDATA WHERE strUserId = @id
END
-- If the zone is Moradon...
IF @Zone = 21
BEGIN
-- Use old Moradon co-ordinates (* 100)
-- I'm not using the new map but you can change the co-ordinates here.
SET @PosX = 81700
SET @PosY = 0 -- If we're higher or lower (depth-wise), we set this. Otherwise, it remains 0.
SET @PosZ = 43200
END

RETURN
GO