CREATE PROCEDURE eMU_CreateCharacter(OUT aResult SMALLINT, OUT aCharactersCount SMALLINT, IN sAccountID VARCHAR(10), IN sName VARCHAR(10), IN aClass SMALLINT)
           BEGIN
               DECLARE aCount        SMALLINT;
               DECLARE aStrength    SMALLINT;
               DECLARE aDexterity    SMALLINT;
               DECLARE aVitality    SMALLINT;
               DECLARE aEnergy        SMALLINT;
               DECLARE aLeadership    SMALLINT;
               DECLARE aMapNumber    SMALLINT;
               DECLARE aMapPosX    SMALLINT;
               DECLARE aMapPosY    SMALLINT;
          
               SELECT COUNT(*) INTO @aCount FROM `character` WHERE Name = @sName;
          
               IF(@aCount = 0)
               THEN
                   SELECT COUNT(*) INTO @aCharactersCount FROM `character` WHERE AccountID = @sAccountID;
          
                   SET @aLeadership    = 0;
                   SET @aMapNumber        = 0;
                   SET @aMapPosX        = 182;
                   SET @aMapPosY        = 128;
          
                   IF(@aClass = 0)
                   THEN
                       SET @aStrength         = 18;
                       SET @aDexterity     = 18;
                       SET @aVitality         = 15;
                       SET @aEnergy         = 30;
                   END IF;
          
                   IF(@aClass = 16)
                   THEN
                       SET @aStrength         = 28;
                       SET @aDexterity     = 20;
                       SET @aVitality         = 25;
                       SET @aEnergy         = 10;
                   END IF;
          
                   IF(@aClass = 32)
                   THEN
                       SET @aStrength         = 22;
                       SET @aDexterity     = 25;
                       SET @aVitality        = 20;
                       SET @aEnergy         = 15;
                       SET @aMapNumber     = 3;
                       SET @aMapPosX        = 182;
                       SET @aMapPosY        = 128;
                   END IF;
          
                   IF(@aClass = 48)
                   THEN
                       SET @aStrength        = 26;
                       SET @aDexterity     = 26;
                       SET @aVitality         = 26;
                       SET @aEnergy         = 26;
                   END IF;
          
                   IF(@aClass = 64)
                   THEN
                       SET @aStrength         = 26;
                       SET @aDexterity     = 20;
                       SET @aVitality        = 20;
                       SET @aEnergy         = 15;
                       SET @aLeadership    = 15;
                   END IF;
          
                   IF(@aClass = 80)
                   THEN
                       SET @aStrength        = 18;
                       SET @aDexterity     = 18;
                       SET @aVitality         = 15;
                       SET @aEnergy         = 30;
                   END IF;
          
                   INSERT INTO `character` (`AccountID`, `Name`, `Class`, `Strength`, `Dexterity`, `Vitality`, `Energy`, `Leadership`, `MapNumber`, `MapPosX`, `MapPosY`) VALUES(@sAccountID, @sName, @aClass, @aStrength, @aDexterity, @aVitality, @aEnergy, @aLeadership, @aMapNumber, @aMapPosX, @aMapPosY);
          
                   SET @aResult = 1;
               END IF;
          
               IF(@aCount = 0)
               THEN
                   SET @aResult        = 0;
                   SET @aCharactersCount    = 0;
               END IF;
           END;

         CALL eMU_CreateCharacter(@aResult, @aCharactersCount, 'thrall', 'thrall12', '0');

SELECT @aResult;
SELECT @aCharactersCount;