[RELEASE] White Stats Decoder (SQL ONLY)

SET NOCOUNT ON;

DECLARE @Variance BIGINT      = 34359738367
      , @Type     VARCHAR(16) = 'WEAPON'
      , @Counter  INT         = 0;

DECLARE @tmpTable TABLE (ID INT IDENTITY(1, 1), Value INT);
DECLARE @resultTable TABLE (ID INT IDENTITY(1, 1), Description VARCHAR(128), Value INT);

WHILE @Variance > 0
BEGIN
    INSERT @tmpTable (Value)
    VALUES ((@Variance & 0x1F) * 100 / 31);
    SET @Counter = 5;

    WHILE @Counter <> 0
    BEGIN
        SET @Variance = (@Variance - (@Variance & 1)) / 2;
        SET @Counter -= 1;
    END;
END;

IF @Type = 'WEAPON'
BEGIN
    IF (SELECT COUNT(*)FROM @tmpTable) <> 7
    BEGIN
        PRINT ('INVALID TYPE!');
        RETURN;
    END;

    INSERT @resultTable (Description, Value)
    VALUES ('Physitcal Damage', (SELECT Value FROM @tmpTable WHERE ID = 5))
         , ('Magical Damage', (SELECT Value FROM @tmpTable WHERE ID = 6))
         , ('Durability', (SELECT Value FROM @tmpTable WHERE ID = 1))
         , ('Hit Ratio', (SELECT Value FROM @tmpTable WHERE ID = 4))
         , ('Critical', (SELECT Value FROM @tmpTable WHERE ID = 7))
         , ('Physitcal Reinforce', (SELECT Value FROM @tmpTable WHERE ID = 2))
         , ('Magical Reinforce', (SELECT Value FROM @tmpTable WHERE ID = 3));
END;
ELSE IF @Type = 'SHIELD'
BEGIN
    IF (SELECT COUNT(*)FROM @tmpTable) <> 6
    BEGIN
        PRINT ('INVALID TYPE!');
        RETURN;
    END;

    INSERT @resultTable (Description, Value)
    VALUES ('Physitcal Defensive', (SELECT Value FROM @tmpTable WHERE ID = 5))
         , ('Magical Defensive', (SELECT Value FROM @tmpTable WHERE ID = 6))
         , ('Durability', (SELECT Value FROM @tmpTable WHERE ID = 1))
         , ('Block Ratio', (SELECT Value FROM @tmpTable WHERE ID = 4))
         , ('Physitcal Reinforce', (SELECT Value FROM @tmpTable WHERE ID = 2))
         , ('Magical Reinforce', (SELECT Value FROM @tmpTable WHERE ID = 3));
END;
ELSE IF @Type = 'EQUIPMENT'
BEGIN
    IF (SELECT COUNT(*)FROM @tmpTable) <> 6
    BEGIN
        PRINT ('INVALID TYPE!');
        RETURN;
    END;

    INSERT @resultTable (Description, Value)
    VALUES ('Physitcal Defensive', (SELECT Value FROM @tmpTable WHERE ID = 4))
         , ('Magical Defensive', (SELECT Value FROM @tmpTable WHERE ID = 5))
         , ('Durability', (SELECT Value FROM @tmpTable WHERE ID = 1))
         , ('Parry Ratio', (SELECT Value FROM @tmpTable WHERE ID = 6))
         , ('Physitcal Reinforce', (SELECT Value FROM @tmpTable WHERE ID = 2))
         , ('Magical Reinforce', (SELECT Value FROM @tmpTable WHERE ID = 3));
END;
ELSE IF @Type = 'ACCESSORY'
BEGIN
    IF (SELECT COUNT(*)FROM @tmpTable) <> 2
    BEGIN
        PRINT ('INVALID TYPE!');
        RETURN;
    END;

    INSERT @resultTable (Description, Value)
    VALUES ('Physitcal Absorption', (SELECT Value FROM @tmpTable WHERE ID = 1))
         , ('Magical Absorption', (SELECT Value FROM @tmpTable WHERE ID = 2));
END;

SELECT Description
     , Value
FROM @resultTable
ORDER BY ID;