[HowTo] All Skills learned with lvl 1

USE [Character]
GO
/****** Object: StoredProcedure [dbo].[give_this_feg_skills] Script Date: 10/22/2016 00:17:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Batch submitted through debugger: SQLQuery33.sql|7|0|C:\Users\Pachamachai\AppData\Lo cal\Temp\~vsE202.sql
ALTER PROCEDURE [dbo].[give_this_feg_skills] @[Only registered and activated users can see links. Click Here To Register...]_id as int, @[Only registered and activated users can see links. Click Here To Register...]_id as tinyint
AS
BEGIN
declare @[Only registered and activated users can see links. Click Here To Register...] as bigint;
if @[Only registered and activated users can see links. Click Here To Register...]_id = 4 --glad
begin
insert into Character.dbo.tSkill values @[Only registered and activated users can see links. Click Here To Register...]_id, 452, 1, 0, DATEDIFF(SECOND, '1970-01-01 00:00:00', GETUTCDATE()), 0, 0, 0, 0, 0);
--kopieren und 2ten wert durch die skill id ueberschreiben
end
else if @[Only registered and activated users can see links. Click Here To Register...]_id = 5 --knight
begin
insert into Character.dbo.tSkill values @[Only registered and activated users can see links. Click Here To Register...]_id, 454, 1, 0, DATEDIFF(SECOND, '1970-01-01 00:00:00', GETUTCDATE()), 0, 0, 0, 0, 0);
--kopieren und 2ten wert durch die skill id ueberschreiben
end
else if @[Only registered and activated users can see links. Click Here To Register...]_id = 9 --holy
begin
insert into Character.dbo.tSkill values @[Only registered and activated users can see links. Click Here To Register...]_id, 1920, 1, 0, DATEDIFF(SECOND, '1970-01-01 00:00:00', GETUTCDATE()), 0, 0, 0, 0, 0);
--kopieren und 2ten wert durch die skill id ueberschreiben
end
else if @[Only registered and activated users can see links. Click Here To Register...]_id = 10 --guard
begin
insert into Character.dbo.tSkill values @[Only registered and activated users can see links. Click Here To Register...]_id, 1980, 1, 0, DATEDIFF(SECOND, '1970-01-01 00:00:00', GETUTCDATE()), 0, 0, 0, 0, 0);
--kopieren und 2ten wert durch die skill id ueberschreiben
end
else if @[Only registered and activated users can see links. Click Here To Register...]_id = 14 -- sharp
begin
insert into Character.dbo.tSkill values @[Only registered and activated users can see links. Click Here To Register...]_id, 4220, 1, 0, DATEDIFF(SECOND, '1970-01-01 00:00:00', GETUTCDATE()), 0, 0, 0, 0, 0);
--kopieren und 2ten wert durch die skill id ueberschreiben
end
else if @[Only registered and activated users can see links. Click Here To Register...]_id = 15 -- ranger
begin
insert into Character.dbo.tSkill values @[Only registered and activated users can see links. Click Here To Register...]_id, 4340, 1, 0, DATEDIFF(SECOND, '1970-01-01 00:00:00', GETUTCDATE()), 0, 0, 0, 0, 0);
--kopieren und 2ten wert durch die skill id ueberschreiben
end
else if @[Only registered and activated users can see links. Click Here To Register...]_id = 19 --warl
begin
insert into Character.dbo.tSkill values @[Only registered and activated users can see links. Click Here To Register...]_id, 6360, 1, 0, DATEDIFF(SECOND, '1970-01-01 00:00:00', GETUTCDATE()), 0, 0, 0, 0, 0);
--kopieren und 2ten wert durch die skill id ueberschreiben
end
else if @[Only registered and activated users can see links. Click Here To Register...]_id = 20 --wiz
begin
insert into Character.dbo.tSkill values @[Only registered and activated users can see links. Click Here To Register...]_id, 6440, 1, 0, DATEDIFF(SECOND, '1970-01-01 00:00:00', GETUTCDATE()), 0, 0, 0, 0, 0);
--kopieren und 2ten wert durch die skill id ueberschreiben
end
else if @[Only registered and activated users can see links. Click Here To Register...]_id = 24 --spec
begin
insert into Character.dbo.tSkill values @[Only registered and activated users can see links. Click Here To Register...]_id, 6720, 1, 0, DATEDIFF(SECOND, '1970-01-01 00:00:00', GETUTCDATE()), 0, 0, 0, 0, 0);
--kopieren und 2ten wert durch die skill id ueberschreiben
end
else if @[Only registered and activated users can see links. Click Here To Register...]_id = 25 --assa
begin
insert into Character.dbo.tSkill values @[Only registered and activated users can see links. Click Here To Register...]_id, 6750, 1, 0, DATEDIFF(SECOND, '1970-01-01 00:00:00', GETUTCDATE()), 0, 0, 0, 0, 0);
--kopieren und 2ten wert durch die skill id ueberschreiben
end
END;

USE [Character]
GO
/****** Object: Trigger [dbo].[check_feggets_class] Script Date: 10/22/2016 00:17:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Batch submitted through debugger: SQLQuery32.sql|0|0|C:\Users\Pachamachai\AppData\Lo cal\Temp\~vs79BD.sql
ALTER trigger [dbo].[check_feggets_class] on [dbo].[tCharacterShape]
after update
as
begin
declare @[Only registered and activated users can see links. Click Here To Register...]class_id as tinyint;
declare @[Only registered and activated users can see links. Click Here To Register...]id as int;
select @[Only registered and activated users can see links. Click Here To Register...]id = nCharNo from inserted i where nCharNo = i.nCharNo;
select @[Only registered and activated users can see links. Click Here To Register...]class_id = nClass from inserted i where nCharNo = i.nCharNo;
if UPDATE(nClass)
begin
exec Character.dbo.give_this_feg_skills @[Only registered and activated users can see links. Click Here To Register...]id, @[Only registered and activated users can see links. Click Here To Register...]class_id;
end
end;