Instant Level and Buffs

USE [RohanGame]
GO
/****** Object: StoredProcedure [dbo].[ROHAN_CreateCharacter] Script Date: 6/23/2018 10:40:35 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/*

@author :
@date : @[Only registered and activated users can see links. Click Here To Register...] : @[Only registered and activated users can see links. Click Here To Register...] : 2008-01-09 / 원미현 (한국, 일본적용) 01-16(대만적용)
생산시스템 적용으로 인한 내용추가
@brief :

*/
ALTER procedure [dbo].[ROHAN_CreateCharacter]
@char_id int output
,@name varchar(20)
,@ctype_id int
,@cface_id int
,@chair_id int
,@mode tinyint
@[Only registered and activated users can see links. Click Here To Register...] int
@[Only registered and activated users can see links. Click Here To Register...]_location int
@[Only registered and activated users can see links. Click Here To Register...]_id tinyint
as
set nocount on
declare @ret int
begin tran

exec @ret = LOCAL_InsTCharacter @char_id output, @name, @ctype_id, @cface_id, @chair_id, @[Only registered and activated users can see links. Click Here To Register...], @mode, @[Only registered and activated users can see links. Click Here To Register...]_id
if @ret <> 0 goto ERR
exec @ret = LOCAL_InsTCharacterAbility @char_id, @ctype_id
if @ret <> 0 goto ERR
exec @ret = LOCAL_InsTCharacterStatus @char_id, @[Only registered and activated users can see links. Click Here To Register...]_location
if @ret <> 0 goto ERR
exec @ret = LOCAL_InsTCharacterLogin @char_id
-- if @ret <> 0 goto ERR
-- exec @ret = LOCAL_InsTRank @char_id

declare @inven_money bigint
set @inven_money = 0
insert into TMoney(char_id, inven_money) values (@char_id, @inven_money)

insert into TCharacterPoint(char_id) values (@char_id)

--extend for character interface ext
insert into TCharacterCraft(char_id) values (@char_id)

update rohangame.dbo.TCharacterAbility set ability_point = 757, skill_point = 114, level = 115 where char_id = @char_id


INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28668, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28667, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28669, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28628, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28627, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28648, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28647, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28646, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28638, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28651, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28629, 0, 7200000, 0, NULL)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2884912, 0x4c0300, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (4063244, 0x4c0300, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (3998774, 0x4c0300, 1, @char_id , 0)

--acce
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2752528, 0x4c0300, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2752528, 0x4c0300, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2752528, 0x4c0300, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2752528, 0x4c0300, 1, @char_id , 0)
-- bag
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2883585, 0x4c0300, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2883585, 0x4c0300, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2883585, 0x4c0300, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2883585, 0x4c0300, 1, @char_id , 0)
--SES
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2884583, 0x4c0300, 10, @char_id , 0)
--ASES
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2884586, 0x4c0300, 10, @char_id , 0)
--monkey
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (4063236, 0x4c0300, 1, @char_id , 0)
--molly
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (4063538, 0x4c0300, 1, @char_id , 0)
--Growth seal
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (4722673, 0x4c0300, 10, @char_id , 0)
--Blessing seal
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (4722675, 0x4c0300, 10, @char_id , 0)
--Agreement seal
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (4722679, 0x4c0300, 10, @char_id , 0)
--Harmony seal
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (4722677, 0x4c0300, 10, @char_id , 0)
--Change job stone
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2884582, 0x4c0300, 1, @char_id , 0)
--Lucky Stone
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (4785137, 0x4c0300, 1, @char_id , 0)
--Lucky Stone
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (4785137, 0x4c0300, 1, @char_id , 0)
--Lucky Stone
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (4785137, 0x4c0300, 1, @char_id , 0)

--Scrolls
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id) values (4718649, 0x4c0300, 25, @char_id)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id) values (4718652, 0x4c0300, 25, @char_id)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id) values (4718658, 0x4c0300, 25, @char_id)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id) values (4718622, 0x4c0300, 25, @char_id)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id) values (4718625, 0x4c0300, 25, @char_id)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id) values (4718628, 0x4c0300, 25, @char_id)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id) values (4718631, 0x4c0300, 25, @char_id)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id) values (4718672, 0x4c0300, 25, @char_id)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id) values (4718669, 0x4c0300, 25, @char_id)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id) values (4722694, 0x4c0300, 25, @char_id)

--Weapons
--dagger
--melee
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2621481, 0x4c03001a28002214000e14000f1400, 1, @char_id , 0)
--crit dex
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2621481, 0x4c03000228000528000D08000e14000f1400, 1, @char_id , 0)
--crit agi
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2621481, 0x4c03000628000528000D08000e14000f1400, 1, @char_id , 0)

--Mace
--melee
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2621781, 0x4c03001a28002214000e14000f1400, 1, @char_id , 0)
--HP
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2621781, 0x4c03001728002214000e14000f1400, 1, @char_id , 0)

--Sword
--melee
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2621582, 0x4c03001a28002214000e14000f1400, 1, @char_id , 0)

--Staff
--magic
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2622181, 0x4c03001928002214000e14000f1400, 1, @char_id , 0)
--psy
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2622181, 0x4c03000428002214000e14000f1400, 1, @char_id , 0)
--HP
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2622181, 0x4c03001728002214000e14000f1400, 1, @char_id , 0)

--Katar
--melee
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2622481, 0x4c03001a28002214000e14000f1400, 1, @char_id , 0)
--crit agi
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2622481, 0x4c03000628000528000D08000e14000f1400, 1, @char_id , 0)

--Bow
--Range attack
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2622282, 0x4c03001b28002214000e14000f1400, 1, @char_id , 0)
--Crit
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2622282, 0x4c03000228000528000D08000e14000f1400, 1, @char_id , 0)

--crossbow
--Range attack
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2621480, 0x4c03001b28002214000e14000f1400, 1, @char_id , 0)
--Crit
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2621480, 0x4c03000228000528000D08000e14000f1400, 1, @char_id , 0)

--Zhen
--melee
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2622703, 0x4c03001a28002214000e14000f1400, 1, @char_id , 0)
--magic
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2622703, 0x4c03001928002214000e14000f1400, 1, @char_id , 0)
--HP
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2622703, 0x4c03001728002214000e14000f1400, 1, @char_id , 0)

--Dual sword
--melee
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2621689, 0x4c03001a28002214000e14000f1400, 1, @char_id , 0)

--Polearm
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2621987, 0x4c03001a28002214000e14000f1400, 1, @char_id , 0)

/**staff vit
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level)
values (2622189, 0x4c03000428000528000f0a000e0a, 1, 491900 , 0)--staff magic
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level)
values (2622189, 0x4c03001928002214000f0a000e0a, 1, 491900 , 0)

**/

--ARMOR SET
--Pluion hahahaha
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2687286, 0x4c03001c32001d3200306400, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2687287, 0x4c03001c32001d3200306400, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2687288, 0x4c03001c32001d3200306400, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2687289, 0x4c03001c32001d3200306400, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (2687290, 0x4c03001c32001d3200306400, 1, @char_id , 0)
insert into RohanGame.dbo.TEventItem (type , attr, stack , char_id, equip_level) values (3671320, 0x4c03001c32001d3200306400, 1, @char_id , 0)




INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,633,1,0,60,60,45,0,0,0,0,0,0,0,1,1,1,1,1 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,634,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,635,1,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,636,1,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,637,1,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,638,0,722,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,639,1,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1305,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1305,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1306,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1307,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1308,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1309,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1310,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1311,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1312,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1313,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1335,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1336,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1337,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1338,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1339,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1340,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1341,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1342,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1343,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1344,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1345,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

INSERT INTO dbo.TQuest (nCharID, nQuestID, bCompletion, nMainTimer, nCount1, nCount2, nCount3, nCount4, nCount5, nCount6, nCount7, nCount8, nCount9, nCount10, bReward1, bReward2,
bReward3, bReward4, bReward5, bReward6, bReward7, bReward8, bReward9, bReward10, nTimer1, nTimer2, nTimer3, nTimer4, nTimer5, nTimer6, nTimer7, nTimer8,
nTimer9, nTimer10, bFailed, nSeqNumber, nCompletion)
VALUES (@char_id,1346,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

DELETE FROM TEventItem where type = '2937613'
DELETE FROM TEventItem where type = '2903589'
DELETE FROM TEventItem where type = '3998759'
DELETE FROM TEventItem where type = '2937618'
DELETE FROM TEventItem where type = '4130076'
DELETE FROM TEventItem where type = '4130075'
DELETE FROM TEventItem where type = '2762559'
DELETE FROM TEventItem where type = '2762560'
DELETE FROM TEventItem where type = '2762561'
DELETE FROM TEventItem where type = '2762558'
DELETE FROM TEventItem where type = '2884750'


commit

--------------------------------------
return @ret
----------------------------------------------------
-- Error Process
----------------------------------------------------
ERR:
rollback
return @ret
----------------------------------------------------