CREATE PROCEDURE [dbo].[NATION_TRANSFER] @strAccountID as varchar(40), @Nation as tinyintAS/*Author : Ceribrio*/DECLARE @strNation tinyint,@Class 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 = @strAccountIDSET @Class = nullSET @Race = nullIF @Nation = 1 and @strNation = 2 BEGIN SELECT @Class = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID1 IF @Class = 201 OR @Class = 205 OR @Class = 206 BEGIN SET @Race = 1 END IF @Class = 202 OR @Class = 207 OR @Class = 208 BEGIN SET @Race = 2 END IF @Class = 203 OR @Class = 209 OR @Class = 210 BEGIN SET @Race = 3 END IF @Class = 204 OR @Class = 211 OR @Class = 212 BEGIN IF @Race = 12 BEGIN SET @Race = 4 END ELSE BEGIN SET @Race = 2 END END UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = @Class - 100 WHERE strUserID = @strCharID1 DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID1 SELECT @Class = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID2 IF @Class = 201 OR @Class = 205 OR @Class = 206 BEGIN SET @Race = 1 END IF @Class = 202 OR @Class = 207 OR @Class = 208 BEGIN SET @Race = 2 END IF @Class = 203 OR @Class = 209 OR @Class = 210 BEGIN SET @Race = 3 END IF @Class = 204 OR @Class = 211 OR @Class = 212 BEGIN IF @Race = 12 BEGIN SET @Race = 4 END ELSE BEGIN SET @Race = 2 END END UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = @Class - 100 WHERE strUserID = @strCharID2 DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID2 SELECT @Class = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID3 IF @Class = 201 OR @Class = 205 OR @Class = 206 BEGIN SET @Race = 1 END IF @Class = 202 OR @Class = 207 OR @Class = 208 BEGIN SET @Race = 2 END IF @Class = 203 OR @Class = 209 OR @Class = 210 BEGIN SET @Race = 3 END IF @Class = 204 OR @Class = 211 OR @Class = 212 BEGIN IF @Race = 12 BEGIN SET @Race = 4 END ELSE BEGIN SET @Race = 2 END END UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = @Class - 100 WHERE strUserID = @strCharID3 DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID3 UPDATE ACCOUNT_CHAR SET bNation = @Nation WHERE strAccountID = @strAccountID ENDIF @Nation = 2 and @strNation = 1 BEGIN SELECT @Class = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID1 IF @Class = 101 OR @Class = 105 OR @Class = 106 BEGIN SET @Race = 12 END IF @Class = 102 OR @Class = 107 OR @Class = 108 BEGIN SET @Race = 12 END IF @Class = 103 OR @Class = 109 OR @Class = 110 BEGIN SET @Race = 12 END IF @Class = 104 OR @Class = 111 OR @Class = 112 BEGIN IF @Race = 4 BEGIN SET @Race = 12 END ELSE BEGIN SET @Race = 13 END END UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = @Class + 100 WHERE strUserID = @strCharID1 DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID1 SELECT @Class = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID2 IF @Class = 101 OR @Class = 105 OR @Class = 106 BEGIN SET @Race = 12 END IF @Class = 102 OR @Class = 107 OR @Class = 108 BEGIN SET @Race = 12 END IF @Class = 103 OR @Class = 109 OR @Class = 110 BEGIN SET @Race = 12 END IF @Class = 104 OR @Class = 111 OR @Class = 112 BEGIN IF @Race = 4 BEGIN SET @Race = 12 END ELSE BEGIN SET @Race = 13 END END UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = @Class + 100 WHERE strUserID = @strCharID2 DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID2 SELECT @Class = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID3 IF @Class = 101 OR @Class = 105 OR @Class = 106 BEGIN SET @Race = 12 END IF @Class = 102 OR @Class = 107 OR @Class = 108 BEGIN SET @Race = 12 END IF @Class = 103 OR @Class = 109 OR @Class = 110 BEGIN SET @Race = 12 END IF @Class = 104 OR @Class = 111 OR @Class = 112 BEGIN IF @Race = 4 BEGIN SET @Race = 12 END ELSE BEGIN SET @Race = 13 END END UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = @Class + 100 WHERE strUserID = @strCharID3 DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID3 UPDATE ACCOUNT_CHAR SET bNation = @Nation WHERE strAccountID = @strAccountID END