[help]Activate Heroes - new items problem...

[crisbr002]

USE [lin2world]

GO

/****** Object:  StoredProcedure [dbo].[lin_ActivatedHeroes]    Script Date: 07/15/2010 00:28:00 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[lin_ActivatedHeroes]

AS

BEGIN

 

SET NOCOUNT ON;

 

DELETE FROM user_skill

WHERE skill_id = '395'

 

DELETE FROM user_skill

WHERE skill_id = '396'

 

DELETE FROM user_skill

WHERE skill_id = '1374'

 

DELETE FROM user_skill

WHERE skill_id = '1375'

 

DELETE FROM user_skill

WHERE skill_id = '1376'

 

 

INSERT INTO user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id)

SELECT char_id, '395', '1', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id)

SELECT char_id, '396', '1', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id)

SELECT char_id, '1374', '1', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id)

SELECT char_id, '1375', '1', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_skill (char_id, skill_id, skill_lev, to_end_time, subjob_id)

SELECT char_id, '1376', '1', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6622', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6622', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6622', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6622', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6622', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6577', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6577', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6577', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6577', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6577', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6578', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6578', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6578', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6578', '1', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '6578', '1', '0', '0', '0', '0', '0', '0'

from user_nobless

WHERE hero_type = 2;

 

 

INSERT INTO user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse)

SELECT char_id, '1538', '45', '0', '0', '0', '0', '0', '0'

FROM user_nobless

WHERE hero_type = 2;

 

END

 

 

because the items that I added were not delivered to the heroes in the same time as the skills?