Skillbooks, more skill in 1 book.

[Patrik10]

Hi. How its possible, to make a skillbook, what gave eg.: shockwave, and splashy ice?

Like this: (But this wont work)
ELSE IF (@Type = 58 AND @Remain = 14)
begin
ELSE IF (@Class = 1) --mage
begin
SET @grade = (select [Level] from Skill WHERE [PID] = @PID AND [Index] = 2) +3
UPDATE Skill SET [Level] = @grade WHERE [PID] = @PID AND [Index] = 2
end
begin
SET @grade = (select [Level] from Skill WHERE [PID] = @PID AND [Index] = 3) +3
UPDATE Skill SET [Level] = @grade WHERE [PID] = @PID AND [Index] = 3
end

[MentaL]

[EvolutionKal]

ELSE IF (@Type = 58 AND @Remain = 16)
begin
IF (@Class = 1) -- Hermit Elementmagic Light Fire +10 Refine +5 (Index 3437)
begin
SET @grade = (select [Level] from Skill WHERE [PID] = @PID AND [Index] = 12) +10
UPDATE Skill SET [Level] = @grade WHERE [PID] = @PID AND [Index] = 12

SET @grade = (select [Level] from Skill WHERE [PID] = @PID AND [Index] = 13) +10
UPDATE Skill SET [Level] = @grade WHERE [PID] = @PID AND [Index] = 13

SET @grade = (select [Level] from Skill WHERE [PID] = @PID AND [Index] = 14) +10
UPDATE Skill SET [Level] = @grade WHERE [PID] = @PID AND [Index] = 14

SET @grade = (select [Level] from Skill WHERE [PID] = @PID AND [Index] = 38) +5
UPDATE Skill SET [Level] = @grade WHERE [PID] = @PID AND [Index] = 38
end


end