Irk Değiştirmeyi Aktf Etmek

CREATE PROCEDURE [dbo].[ACCOUNT_NATION_CHANGE]

@strAccountID as varchar(40),

@Nation as tinyint

AS



DECLARE @strNation tinyint [MENTION=2874]class[/MENTION] int,@Race int,@strCharID1 char(21), @strCharID2 char(21), @strCharID3 char(21)



SELECT @strNation = bNation,@strCharID1 = strCharID1,@strCharID2 = strCharID2,@strCharID3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @strAccountID



SET [MENTION=2874]class[/MENTION] = null

SET @Race = null



IF @Nation = 1 and @strNation = 2

BEGIN

SELECT [MENTION=2874]class[/MENTION] = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID1

IF [MENTION=2874]class[/MENTION] = 201 OR [MENTION=2874]class[/MENTION] = 205 OR [MENTION=2874]class[/MENTION] = 206

BEGIN

SET @Race = 1

END



IF [MENTION=2874]class[/MENTION] = 202 OR [MENTION=2874]class[/MENTION] = 207 OR [MENTION=2874]class[/MENTION] = 208

BEGIN

SET @Race = 2

END



IF [MENTION=2874]class[/MENTION] = 203 OR [MENTION=2874]class[/MENTION] = 209 OR [MENTION=2874]class[/MENTION] = 210

BEGIN

SET @Race = 3

END



IF [MENTION=2874]class[/MENTION] = 204 OR [MENTION=2874]class[/MENTION] = 211 OR [MENTION=2874]class[/MENTION] = 211

BEGIN

IF @Race = 12

BEGIN

SET @Race = 4

END

ELSE

BEGIN

SET @Race = 2

END

END

UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = [MENTION=2874]class[/MENTION] - 100 WHERE strUserID = @strCharID1

DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID1





SELECT [MENTION=2874]class[/MENTION] = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID2

IF [MENTION=2874]class[/MENTION] = 201 OR [MENTION=2874]class[/MENTION] = 205 OR [MENTION=2874]class[/MENTION] = 206

BEGIN

SET @Race = 1

END



IF [MENTION=2874]class[/MENTION] = 202 OR [MENTION=2874]class[/MENTION] = 207 OR [MENTION=2874]class[/MENTION] = 208

BEGIN

SET @Race = 2

END



IF [MENTION=2874]class[/MENTION] = 203 OR [MENTION=2874]class[/MENTION] = 209 OR [MENTION=2874]class[/MENTION] = 210

BEGIN

SET @Race = 3

END



IF [MENTION=2874]class[/MENTION] = 204 OR [MENTION=2874]class[/MENTION] = 211 OR [MENTION=2874]class[/MENTION] = 211

BEGIN

IF @Race = 12

BEGIN

SET @Race = 4

END

ELSE

BEGIN

SET @Race = 2

END

END

UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = [MENTION=2874]class[/MENTION] - 100 WHERE strUserID = @strCharID2

DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID2



SELECT [MENTION=2874]class[/MENTION] = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID3

IF [MENTION=2874]class[/MENTION] = 201 OR [MENTION=2874]class[/MENTION] = 205 OR [MENTION=2874]class[/MENTION] = 206

BEGIN

SET @Race = 1

END



IF [MENTION=2874]class[/MENTION] = 202 OR [MENTION=2874]class[/MENTION] = 207 OR [MENTION=2874]class[/MENTION] = 208

BEGIN

SET @Race = 2

END



IF [MENTION=2874]class[/MENTION] = 203 OR [MENTION=2874]class[/MENTION] = 209 OR [MENTION=2874]class[/MENTION] = 210

BEGIN

SET @Race = 3

END



IF [MENTION=2874]class[/MENTION] = 204 OR [MENTION=2874]class[/MENTION] = 211 OR [MENTION=2874]class[/MENTION] = 211

BEGIN

IF @Race = 12

BEGIN

SET @Race = 4

END

ELSE

BEGIN

SET @Race = 2

END

END

UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = [MENTION=2874]class[/MENTION] - 100 WHERE strUserID = @strCharID3

DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID3



UPDATE ACCOUNT_CHAR SET bNation = @Nation WHERE strAccountID = @strAccountID

END



IF @Nation = 2 and @strNation = 1

BEGIN



SELECT [MENTION=2874]class[/MENTION] = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID1

IF [MENTION=2874]class[/MENTION] = 101 OR [MENTION=2874]class[/MENTION] = 105 OR [MENTION=2874]class[/MENTION] = 106

BEGIN

SET @Race = 12

END



IF [MENTION=2874]class[/MENTION] = 102 OR [MENTION=2874]class[/MENTION] = 107 OR [MENTION=2874]class[/MENTION] = 108

BEGIN

SET @Race = 12

END



IF [MENTION=2874]class[/MENTION] = 103 OR [MENTION=2874]class[/MENTION] = 109 OR [MENTION=2874]class[/MENTION] = 110

BEGIN

SET @Race = 12

END



IF [MENTION=2874]class[/MENTION] = 104 OR [MENTION=2874]class[/MENTION] = 111 OR [MENTION=2874]class[/MENTION] = 111

BEGIN

IF @Race = 4

BEGIN

SET @Race = 12

END

ELSE

BEGIN

SET @Race = 13

END

END

UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = [MENTION=2874]class[/MENTION] + 100 WHERE strUserID = @strCharID1

DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID1



SELECT [MENTION=2874]class[/MENTION] = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID2

IF [MENTION=2874]class[/MENTION] = 101 OR [MENTION=2874]class[/MENTION] = 105 OR [MENTION=2874]class[/MENTION] = 106

BEGIN

SET @Race = 12

END



IF [MENTION=2874]class[/MENTION] = 102 OR [MENTION=2874]class[/MENTION] = 107 OR [MENTION=2874]class[/MENTION] = 108

BEGIN

SET @Race = 12

END



IF [MENTION=2874]class[/MENTION] = 103 OR [MENTION=2874]class[/MENTION] = 109 OR [MENTION=2874]class[/MENTION] = 110

BEGIN

SET @Race = 12

END



IF [MENTION=2874]class[/MENTION] = 104 OR [MENTION=2874]class[/MENTION] = 111 OR [MENTION=2874]class[/MENTION] = 111

BEGIN

IF @Race = 4

BEGIN

SET @Race = 12

END

ELSE

BEGIN

SET @Race = 13

END

END

UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = [MENTION=2874]class[/MENTION] + 100 WHERE strUserID = @strCharID2

DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID2



SELECT [MENTION=2874]class[/MENTION] = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID3

IF [MENTION=2874]class[/MENTION] = 101 OR [MENTION=2874]class[/MENTION] = 105 OR [MENTION=2874]class[/MENTION] = 106

BEGIN

SET @Race = 12

END



IF [MENTION=2874]class[/MENTION] = 102 OR [MENTION=2874]class[/MENTION] = 107 OR [MENTION=2874]class[/MENTION] = 108

BEGIN

SET @Race = 12

END



IF [MENTION=2874]class[/MENTION] = 103 OR [MENTION=2874]class[/MENTION] = 109 OR [MENTION=2874]class[/MENTION] = 110

BEGIN

SET @Race = 12

END



IF [MENTION=2874]class[/MENTION] = 104 OR [MENTION=2874]class[/MENTION] = 111 OR [MENTION=2874]class[/MENTION] = 111

BEGIN

IF @Race = 4

BEGIN

SET @Race = 12

END

ELSE

BEGIN

SET @Race = 13

END

END

UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = [MENTION=2874]class[/MENTION] + 100 WHERE strUserID = @strCharID3

DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID3



UPDATE ACCOUNT_CHAR SET bNation = @Nation WHERE strAccountID = @strAccountID

END

GO