Instant Level and Buffs

[asmodeus812]

Came here to ask if some1 knows how to:

1. Make a higher starter level (for example 110 lv on a fresh made character)
2.How to buff urself rightaway with guild buffs etc
3.How to make freshmade characters to start with some certain items in their event/mall inventories !

I believe this is made with procedures on into the DB , maybe on each new record. But since i've been away i didnt quite follow the forums around would be nice if some1 gives a hand ! Well Thx and have a nice day!

[imarin]

this code is from other forum:

PHP Code:

this i set for auto job change lv 50 (relogin for change job)
"RohanGame>Programmability>System Stored Procedures>ROHAN_EndGame"

this i have set for make new Character (give item to beginner)
"RohanGame>Programmability>System Stored Procedures>ROHAN_CreateCharacter" 


[mashiteri]

Originally Posted by imarin

this code is from other forum:

PHP Code:

this i set for auto job change lv 50 (relogin for change job)
"RohanGame>Programmability>System Stored Procedures>ROHAN_EndGame"

this i have set for make new Character (give item to beginner)
"RohanGame>Programmability>System Stored Procedures>ROHAN_CreateCharacter" 


which forum?

[Dr.Dr.SheldonLeeCooper]

Rage.Zone

[Luôô]

Open the ROHAN_CreateCharacter function for modify

and add this for items at the end

INSERT INTO dbo.TEventItem (type, attr, stack, rank, equip_level, equip_dexterity, equip_intelligence, equip_strength, char_id) VALUES (ITEMIDHERE, 0, 1, 0, 0, 0, 0, 0, @char_id)

you only need to change the itemid and the stack

for skills

INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, KIND, LEVEL, TIME, 0, NULL)

Only change the kind, level and time and then save again.

For the start level open the function LOCAL_InsTCharacterAbility
and change

set @level = 1

to this

set @level = 110

and save again.

[moviper]

Originally Posted by Dr.Dr.SheldonLeeCooper

Rage.Zone

elitepvper.com

[flyghter]

Guys do you know from where i can change abilty points for 1>50>70>99>110

[oziel235]

Originally Posted by flyghter

Guys do you know from where i can change abilty points for 1>50>70>99>110

See the code below:

PHP Code:

INSERT INTO [RohanGame].[dbo].[TCharacterAbility]
           ([char_id]
           ,[ability_point]
           ,[skill_point]
           ,[strength]
           ,[dexterity]
           ,[intelligence]
           ,[mentality]
           ,[health]
           ,[quickness]
           ,[level])
     VALUES
           (<char_id, int,>
           ,<ability_point, smallint,>
           ,<skill_point, smallint,>
           ,<strength, smallint,>
           ,<dexterity, smallint,>
           ,<intelligence, smallint,>
           ,<mentality, smallint,>
           ,<health, smallint,>
           ,<quickness, smallint,>
           ,<level, smallint,>)
GO 


[yurierodriguez]

Originally Posted by Luôô

Open the ROHAN_CreateCharacter function for modify

and add this for items at the end

you only need to change the itemid and the stack

for skills

Only change the kind, level and time and then save again.

For the start level open the function LOCAL_InsTCharacterAbility
and change

and save again.

thanks big help ^_^ i have a qustion? how to add starting items for new chracter?

[im batman]

Hopefully this will finally shut you the hell up:

 Spoiler

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 : @ : @ : 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
@ int
@_location int
@_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, @, @mode, @_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, @_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
----------------------------------------------------

sets new char to lvl 115
adds a bunch of crap to the event inventory
pops a bunch of guild skills


It is messy, brute force method but it works for some. You can thank Ammadpurba for this shitty indo-style trash which is why I don't mind giving it to you FOR FREE. If you have any issues with it, talk to him - maybe he won't charge you a lot of money for the answers.

Personally i would NEVER inline code it like this and I would never Ever start a character at max level. It is some of the messiest TSQL code ever.