[Collecting]Usefull SQL-Script`s

[Raskim2000]

Clean. I will not longer support german/english/arabic bitche's, wich aren`t able, to write one sentence right.

[HeavenOnlyWishes]

< Erased >

[lestat002]

merci pour ces superbe scripts...

Moi je recherche un script pour ajouter un nouveau NPC et comment ajouter des items dans sa boutique.....

Je vais vous mettre 2-3 scripts bientot : celui pour le nouveau pet de l'epic 7.3 (le cube)
un script pour l'Astaroth (avec les skill qui marche) et la ceinture 6 slots...

[Raskim2000]

Originally Posted by lestat002

merci pour ces superbe scripts...

Moi je recherche un script pour ajouter un nouveau NPC et comment ajouter des items dans sa boutique.....

Je vais vous mettre 2-3 scripts bientot : celui pour le nouveau pet de l'epic 7.3 (le cube)
un script pour l'Astaroth (avec les skill qui marche) et la ceinture 6 slots...

I allready released a script for the chance of a 6 slot Belt.

Also, setting skills to an Pet is very Easy, but you cant release a script for the "Cube" Pet, because the current Gameserver can't handle it.

And there will be no script for creating NPC`s. You have to do this on your own. Nobody Knows, what the NPC Should look like etc. And for the NPC`s you need the LUA-File, too.

[msrm]

can you pleas explain to me where to but these scripts and what to do with them

thank you in advance

[The Bird Man]

Originally Posted by Raskim2000

Hey everybody,

because of this big number of "Newbies", "Lazy Guys" etc. i decided to start an Thread to Collect usefull Scripts.

Hopefully this will be sticky, i will write and collect all good scripts, wich can be used for all.

Here we go.

Scripts Credit by Raskim2000

 Spoiler

Set Basic price for Items

 Spoiler

use arcadia
update dbo.ItemResource 
set price = 3000000
where id = Here_Item_ID

Search for items

 Spoiler

SELECT id, StringResource.value, rank
FROM Arcadia.dbo.ItemResource
LEFT JOIN Arcadia.dbo.StringResource
on name_id = StringResource.code
where value like '%world%' -- search here
order by id, value, rank

Set Taming-ID

 Spoiler

-- Red Pixi
use arcadia
update dbo.monsterresource
set taming_id = 1011
WHERE model LIKE '%fiery_pixi%'  

--Blue Pixi
update dbo.monsterresource
set taming_id = 1021
WHERE model LIKE '%water_pixi%'  

--Hawkmen
update dbo.monsterresource
set taming_id = 1201
WHERE model LIKE '%hawkman%'  

--Siren
update dbo.monsterresource
set taming_id = 1301
WHERE model LIKE '%seiren%' 

--Kenta
update dbo.monsterresource
set taming_id = 1701
WHERE model LIKE '%horseman%' 

--yeti
update dbo.monsterresource
set taming_id = 1801
WHERE model LIKE '%yeti%' 

--Salamander
update dbo.monsterresource
set taming_id = 1901
WHERE model LIKE '%salamander%' 

--Angel
update dbo.monsterresource
set taming_id = 2001
WHERE model LIKE '%angel%' 

--Chicken
update dbo.monsterresource
set taming_id = 2101
WHERE model LIKE '%chichen%' 

--Turtle
update dbo.monsterresource
set taming_id = 2201
WHERE model LIKE '%turtle%' 

--Panter
update dbo.monsterresource
set taming_id = 2301
WHERE model LIKE '%panthera%' 

--Skeleton
update dbo.monsterresource
set taming_id = 2401
WHERE model LIKE '%skelfighter%' 

--Orc
update dbo.monsterresource
set taming_id = 2501
WHERE model LIKE '%orc%' 

--White Dragon
update dbo.monsterresource
set taming_id = 2701
WHERE model LIKE '%dragon%' 

--Cerberus
update dbo.monsterresource
set taming_id = 2801
WHERE model LIKE '%keberos%' 

--Wolf
update dbo.monsterresource
set taming_id = 2901
WHERE model LIKE '%wolf%' 

--Harpy
update dbo.monsterresource
set taming_id = 3301
WHERE model LIKE '%windsong%' 

--Gnoll
update dbo.monsterresource
set taming_id = 3401
WHERE model LIKE '%eimus%' 

--Octo
update dbo.monsterresource
set taming_id = 3502
WHERE model LIKE '%octopus%' 

--Naga
update dbo.monsterresource
set taming_id = 3601
WHERE model LIKE '%tafari%' 

--Genie
update dbo.monsterresource
set taming_id = 3701
WHERE model LIKE '%spirit_jini%'  

--Ifrit
update dbo.monsterresource
set taming_id = 3801
WHERE model LIKE '%spirit_mystic_jini%'  

--Unicorn
update dbo.monsterresource
set taming_id = 3901
WHERE id = 53006 or id = 54005 or id = 55006 or id = 171001 or id = 172001 or id = 173001 or id = 174001 or id = 724

--Nightmare
update dbo.monsterresource
set taming_id = 4001
WHERE id = 90003 or id = 91002 or id = 92001 or id = 7092001 or id = 171002 or id = 172002 or id = 173002 or id = 725 or id = 174002

--Deathtyrant
update dbo.monsterresource
set taming_id = 4101
WHERE id = 734 or id = 179001 or id = 180003 or id = 1000079

Set Tame Rate Percentage

 Spoiler

--T6
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.1000 
WHERE taming_id = 4101 or taming_id = 2701
GO
--T5
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.1500
WHERE taming_id = 2801 or taming_id = 3701 or taming_id = 3801
GO
--T4
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.2000
WHERE taming_id = 3601 or taming_id = 3401 or taming_id = 2001 or taming_id = 1701
GO
--T3
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.3000 
WHERE taming_id = 1201 or taming_id = 1901 or taming_id = 3301 or taming_id = 3901 or taming_id = 4001
GO
--Tier 2
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.5000 
WHERE taming_id = 1011 or taming_id = 1021 or taming_id = 1301 or taming_id = 1801 or taming_id = 2401 taming_id = 2501 or taming_id = 2901 or taming_id = 3502 
GO
--Tier 1
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.8000 
WHERE taming_id = 2301 or taming_id = 2201 or taming_id = 2101
GO

Set 6 Slots to an Belt

 Spoiler

Use Arcadia
update dbo.ItemResource
set opt_var1_0 = 6
where id = here_Belt_ID

Set a Passiv R7 Set Boni, Ordered for every Rank
(With this Script, every Item for R7 T1-T3 will give you an Passiv Bonus for your Stats and the Full Set will give you the Correct Full Bonus, without the Set-Buff)

 Spoiler

use arcadia 
update dbo.ItemResource 
set opt_type_0 = 96
where set_id = 1111 or set_id = 1112 or set_id = 1113 

update dbo.ItemResource 
set opt_var1_0 = 127
where set_id = 1111 or set_id = 1112 or set_id = 1113

update dbo.ItemResource 
set opt_var2_0 = 2
where set_id = 1111

update dbo.ItemResource 
set opt_var2_0 = 4
where set_id = 1112

update dbo.ItemResource 
set opt_var2_0 = 6
where set_id = 1113

update dbo.ItemResource 
set opt_type_1 = 98
where set_id = 1111 or set_id = 1112 or set_id = 1113

update dbo.ItemResource 
set opt_var1_1 = 2097152
where set_id = 1111 or set_id = 1112 or set_id = 1113

update dbo.ItemResource 
set opt_var2_1 = 0.10
where set_id = 1111

update dbo.ItemResource 
set opt_var2_1 = 0.20
where set_id = 1112

update dbo.ItemResource 
set opt_var2_1 = 0.30
where set_id = 1113

Scripts Credit to HeavenOnlyWishes:

 Spoiler

Epic 7.1 Client Quest Fix

 Spoiler

Lv1-10 Quests

 Spoiler

-- Devas First Hunt (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 603001,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 106101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 103101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 101102,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1005

-- Devas Feather Collection (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 603002,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 107101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 104101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 102101,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1006
-- Go to an Elementary Tutor --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602506,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1007

-- Asuras First Hunt (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 603001,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 106101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 103101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 101102,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1WHERE id = 1008

-- Asuras Claw Collection (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 603002,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 107101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 104101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 102101,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1009

-- Gaias First Hunt (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 603001,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 106101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 103101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 101102,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1010

-- Gaias Feather Collection (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 603002,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 107101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 104101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 102101,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1011

-- Achieve Job Level 3 --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602501,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 602503,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1
WHERE id = 1012

-- A Skilled Deva --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 540099,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 220101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 220102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1
WHERE id = 1013

-- A Skilled Asura --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 540099,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 230101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 230102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1
WHERE id = 1014

-- A Skilled Gaia --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 540099,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 240101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 240102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1
WHERE id = 1015

-- Talk to Gildas --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602501,
default_reward_level = 1,
default_reward_quantity = 10,
optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 10
WHERE id = 1016

-- Item Upgrade (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602504,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 602505,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 602503,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 602506,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1017

-- Herb Collecting (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602501,
default_reward_level = 1,
default_reward_quantity = 12,
optional_reward_id1 = 602505,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 602503,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 602506,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1019

-- First Class Transfer --UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602501,
default_reward_level = 1,
default_reward_quantity = 10,
optional_reward_id1 = 609077,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 609086,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1
WHERE id = 1023

-- Catch Anatema --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 609077,
optional_reward_level1 = 1,
optional_reward_quantity1 = 5,
optional_reward_id2 = 609086,
optional_reward_level2 = 1,
optional_reward_quantity2 = 5
WHERE id = 1026

-- Gain 1 Lak --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 690201,
default_reward_level = 1,
default_reward_quantity = 30,
optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30
WHERE id = 1032

-- Demonstrate Your Skill --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30
WHERE id = 1034

-- Go to Lak Trader --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 403101,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1037

-- Screening --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 305201,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 2900500,
optional_reward_level1 = 1,
optional_reward_quantity1 = 2
WHERE id = 1040

-- Attack of the Worm Piranhas! --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602001,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30
WHERE id = 1041

-- Wanted --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 303202,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 304202,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 432102,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1042

-- Learn creature summoning --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 1900001,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 540014,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 540015,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 540016,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1043

-- Brighton's Calling: Dawn --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 690201,
default_reward_level = 1,
default_reward_quantity = 30
WHERE id = 1236

-- Brighton's Calling: Dusk (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 690441,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 106202,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 103202,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 101202,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1237

-- Integra's Words: Glory --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602301,
default_reward_level = 1,
default_reward_quantity = 2,
optional_reward_id1 = 602304,
optional_reward_level1 = 1,
optional_reward_quantity1 = 2,
optional_reward_id2 = 602201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 5
WHERE id = 1239

-- Integra's Words: Revelation --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602304,
default_reward_level = 1,
default_reward_quantity = 3
WHERE id = 1238

-- Voice of Truth --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 910049,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 910047,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 910043,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1
WHERE id = 1240

-- Earrings of the Witch --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 1000075,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1246

-- Entering Navislamia --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 1000076,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1243

-- Glorious First Steps --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 602001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 5,
optional_reward_id2 = 602201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 5
WHERE id = 1049

-- Navislamia's Final Voyage (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2900500,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 107202,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 104202,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 102202,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1241

-- Reporting first job transfer to Gildas --
UPDATE Arcadia.dbo.QuestResourceSET 
default_reward_id = 900012,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 900011,
optional_reward_level1 = 1,
optional_reward_quantity1 = 3
WHERE id = 1197

-- The Zombie Crew --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 608301,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 608001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 5,
optional_reward_id2 = 608201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 5
WHERE id = 1242

-- Witch's Pendant --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 1000068,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1248

Lv11-20 Quests

 Spoiler

-- Calm Start --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 602002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 5,
optional_reward_id2 = 602201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 5
WHERE id = 1045

-- Start From Scratch --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 602002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 7,
optional_reward_id2 = 602201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 7
WHERE id = 1053

-- Sagittarius --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 602002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 5,
optional_reward_id2 = 602201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 5
WHERE id = 1046

-- Training Days --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 602002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 7,
optional_reward_id2 = 602201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 7
WHERE id = 1054

-- Yard Cleaning --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 602002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 5,
optional_reward_id2 = 602201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 5
WHERE id = 1050

-- Letter for Her (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609077,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1149

-- Lost Iron Ore (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 50,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 50,
optional_reward_id3 = 609077,
optional_reward_level3 = 1,
optional_reward_quantity3 = 8
WHERE id = 1103

-- Deodorizer 1 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609077,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1139

-- Deodorizer 2 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602101,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609077,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1140

-- Final Test (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602102,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1156

-- Ken's Test #1 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602401,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609077,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1150

-- Ken's Test #2 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609077,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1151

-- Ken's Test #3 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602304,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609077,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1152

-- Ken's Test #4 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1153

-- Ken's Test #5 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1154

-- Personal War #1 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609077,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1131

-- Personal War #2 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2900500,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1132

-- Road Construction (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602001,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609077,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1129

-- Roof Mushroom Collection --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602102,
default_reward_level = 1,
default_reward_quantity = 8
WHERE id = 1186

-- Soft Chest (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602301,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609077,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1158

-- Test Passed (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1155

-- The Name is Godzilla (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 432101,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1157

-- Collecting a Stack of Straws (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609077,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1193

-- Death Walker (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2900500,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1051

-- Official Request (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2900500,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1047

-- Way to experience Death (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2900500,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 8
WHERE id = 1055

-- Stump Logging Area Backup (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602201,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609077,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1130

-- Collecting a Lumber (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1194

-- Coreanus Treasure Box --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 602002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 5,
optional_reward_id2 = 602201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 5
WHERE id = 1185

Lv21-30 Quests

 Spoiler

-- Prisoner #1 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1142

-- Prisoner #2 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602401,
default_reward_level = 1,
default_reward_quantity = 2,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1143

-- Investigating Rock Salt --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 609078,
default_reward_level = 1,
default_reward_quantity = 30,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20
WHERE id = 10171

-- Crest of Coreanus (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1159

-- Funny Mask (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 60,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 60,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1048

-- Iron Scar (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 50,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 50,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 8
WHERE id = 1056

-- Paradise Lost (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 60,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 60,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1052

-- Searching for Bones (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1141

-- Skin (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602002,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 10
WHERE id = 1061

-- Lost Stump Logging Area (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1100

-- Bitter Coast --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 602301,
optional_reward_level1 = 1,
optional_reward_quantity1 = 3,
optional_reward_id2 = 602304,
optional_reward_level2 = 1,
optional_reward_quantity2 = 3
WHERE id = 1094

-- Collecting Burned Bone (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1195

-- Delivering Burned Bone (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1196

-- Lost Luggage (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1146

-- Magic Crystal Hunting (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1191

-- Retake Stump Logging Area --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602101,
default_reward_level = 1,
default_reward_quantity = 10
WHERE id = 1101

-- Trouble #1 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1147

-- Trouble #2 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2900500,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1148

-- Would you like a part time job --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 609078,
default_reward_level = 1,
default_reward_quantity = 45,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30
WHERE id = 10173

-- Summon Magician --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602301,
default_reward_level = 1,
default_reward_quantity = 3
WHERE id = 1109

-- Mysterious Lake Messi 1 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1144

-- Mysterious Lake Messi 2 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2900500,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1145

-- Questionable Test 1 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1136

-- Questionable Test 2 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2900500,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1137

-- Red Drill (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1138

-- Shell --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 602002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 12,
optional_reward_id2 = 602201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 8
WHERE id = 1095

-- Orc Hunting (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602002,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 10
WHERE id = 1057

-- Angel's Song (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1133

-- Rusty Orc Shield Retrieval (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1192

Lv31-40 Quests

 Spoiler

-- Chain of Pain (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602002,
default_reward_level = 1,
default_reward_quantity = 10,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 10
WHERE id = 1059

-- New Journey --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1058

-- Vestiges of Curse (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602002,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1064

-- Secret Medicine of Legend --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602401,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 602002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 8,
optional_reward_id2 = 602201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 8
WHERE id = 1065

-- Ask for Backup --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1117

-- Bringing Tool Box (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1188

-- Kadoon of Enmity --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1081

-- Revenge Preparation --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602003,
default_reward_level = 1,
default_reward_quantity = 7
WHERE id = 1072

-- Unwelcomed Visitor --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602003,
default_reward_level = 1,
default_reward_quantity = 12
WHERE id = 1116

-- Valmore Crystal Mine (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1190

-- Bird Chasing --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602102,
default_reward_level = 1,
default_reward_quantity = 10
WHERE id = 1096

-- City of Arrogance --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 602203,
optional_reward_level1 = 1,
optional_reward_quantity1 = 9,
optional_reward_id2 = 602003,
optional_reward_level2 = 1,
optional_reward_quantity2 = 9
WHERE id = 1060

-- Swamp Mushroom Collecting (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1187

-- Fallen Falcon Feathers (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1180

-- Gratitude of Presbytery (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1179

-- Magical Stone (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1182

-- Relics of Arid Moonlight Attack 1 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 20,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 20,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 3
WHERE id = 1172

-- Relics of Arid Moonlight Attack 2 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 25,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 25,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 4
WHERE id = 1173

-- Relics of Arid Moonlight Purgation 1 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1176

-- Relics of Arid Moonlight Purgation 2 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2900500,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1177

-- Ruin of Abhuva --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 423101,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1178

-- Ruin of Oforia --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 432104,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 432106,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1
WHERE id = 1174

-- The Black Orbs of Albinruke (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1181

-- Angel's Scream (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602101,
default_reward_level = 1,
default_reward_quantity = 10,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1135

-- Angel's Wing (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1134

-- Dodo's Feather (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1111

-- Request for Annihilation (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2900500,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609078,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1069

-- Song of the Dead --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1062

-- Annoying Obstacle (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602401,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1114

-- Aris Elimination (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602103,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1092

-- Cleansing the Relics of Arid Moonlight --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 3
WHERE id = 1183

-- Habitat War 1 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1105

-- Secret of Abandoned Mine --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 608102,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 602301,
optional_reward_level1 = 1,
optional_reward_quantity1 = 3,
optional_reward_id2 = 602304,
optional_reward_level2 = 1,
optional_reward_quantity2 = 3
WHERE id = 1074

-- Sirag Relics --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1184

Lv41-50 Quests

 Spoiler

-- Habitat War #2 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1106

-- Request for Extermination (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1070

-- More Annoying Obstacle (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 60,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 60,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 9
WHERE id = 1115

-- Habitat War #3 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 50,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 50,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 8
WHERE id = 1107

-- Identity of Pollution (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 60,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 60,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 9
WHERE id = 1083

-- Lost Document (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 60,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 60,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 9
WHERE id = 1098

-- Polluted Ground (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 60,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 60,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 9
WHERE id = 1082

-- Revenge for Revenge --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602003,
default_reward_level = 1,
default_reward_quantity = 8
WHERE id = 1097

-- Cursed Jar 4 (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690003,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690103,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 5
WHERE id = 1121

-- Cursed Jar 6 --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 432102,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1123

-- Fantasy Zone (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1093

-- Forager (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 50,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 50,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 8
WHERE id = 1108

-- Late Regret --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1124

-- Memory of Cherry Blossoms Road --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 609078,
default_reward_level = 1,
default_reward_quantity = 75,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 50,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 50
WHERE id = 10172

-- Evil Woods (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2900500,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1066

-- Evils of Woods (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690002,
optional_reward_level1 = 1,
optional_reward_quantity1 = 50,
optional_reward_id2 = 690102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 50,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 8
WHERE id = 1067

-- Grisis Subjugation (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 690003,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690103,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609079,
optional_reward_level3 = 1,
optional_reward_quantity3 = 6
WHERE id = 1084

-- Holy Water Purification --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2901000,
default_reward_level = 1,
default_reward_quantity = 2
WHERE id = 1080

-- A Treat for Reinke --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 1000092,
default_reward_level = 1,
default_reward_quantity = 3
WHERE id = 2028

-- Elohim's Trial: Lucid Spirit (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 423201,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 423202,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 423203,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 2003

-- Elohim's Trial: Stout Heart --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 540053,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 2004

-- Fanatic Assassin: Red Farm (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 433201,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 433202,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 433203,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 2008

Lv 70+ Quests

 Spoiler

-- Fanatic Assassin: Horizon --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 304401,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 304402,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 304403,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 2010

-- Fanatic Assassin: Katan --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 303402,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 303401,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 303403,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 2009

-- Fanatic Assassin: Laksy (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 424201,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 424202,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 424203,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 2011

-- Fanatic Assassin: Rondo (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 434201,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 434202,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 434203,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 2012

-- Witch Hunt (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 261523,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 262523,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 263523,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 2027

-- Traces of the Witch: Magic Test Ground --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 304501,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1
WHERE id = 2017

-- Traces of the Witch: Sirag Ruins --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 303501,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1
WHERE id = 2015

-- Subjugating the Ivory Tower Fanatics (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 425201,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 425202,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 425203,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 2021

-- Subjugating the Assassin Guild Fanatics (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 435001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 435002,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 435003,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 2023

-- Wet Harold (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690003,
optional_reward_level1 = 1,
optional_reward_quantity1 = 40,
optional_reward_id2 = 690103,
optional_reward_level2 = 1,
optional_reward_quantity2 = 40,
optional_reward_id3 = 609080,
optional_reward_level3 = 1,
optional_reward_quantity3 = 12
WHERE id = 1126

Items: Item ID and Item Name

 Spoiler

SELECT ITEM.id, item.name_id, STRING.value
FROM Arcadia.dbo.ItemResource ITEM, Arcadia.dbo.StringResource STRING
WHERE item.name_id = string.code
ORDER BY id ASC

And Conversely for Quests: Quest ID and Quest Name

 Spoiler

SELECT QUEST.id, quest.text_id_quest, STRING.value
FROM Arcadia.dbo.QuestResource QUEST, Arcadia.dbo.StringResource STRING
WHERE quest.text_id_quest = string.code
ORDER BY id ASC

I Will Update this Page when someone Message me a usefull Script or i get an Idea wich Scripts are missing (Usefull)

Thank you nice work!

[Frost@mp3]

i have codes for new pieces, and r7 cloaks, how to make them working? 1 guy says that i have to put them in database, but how? anyone knows, any script or something?

[Raskim2000]

Originally Posted by Frost@mp3

i have codes for new pieces, and r7 cloaks, how to make them working? 1 guy says that i have to put them in database, but how? anyone knows, any script or something?

Im working on this, i have all needed Entrys, but for some reason i can use them without any effect. ._.

And the Rank 7 Cloaks will not shown on all Client`s.

[HeavenOnlyWishes]

If it's content that is post 7.1 then it won't work with the client properly. There are databases stored inside the data packets for the client and if they don't match up with the data from the server then the items will be glitchy. Certain aspects won't work, etc.

[Raskim2000]

Originally Posted by HeavenOnlyWishes

If it's content that is post 7.1 then it won't work with the client properly. There are databases stored inside the data packets for the client and if they don't match up with the data from the server then the items will be glitchy. Certain aspects won't work, etc.

50/50

I got an screen from a "Fenix" player, where he got the new Pieces on the Character, but got no answer if the stats were written right, or he get the right stats.

And like Speedy-nl said, on a 7.1 modded PH Client, he got the R7 cloaks shown, on US they dont.

So i think in the PH Client are maybe more infos for the current DB,GS.

But i dont find any 7.1 Client of PH, just some manuell patches, wich patches the Client to 7.3.

[Frost@mp3]

so what should we download to have them working?

[Raskim2000]

Originally Posted by speedy-nl

get a 111 client, update that 1 true launcher, it will stop when it hit 7.1 , replace the sframe with the 6.2 and done

and yes the ph 7.1 holds more info then the crappy us version, the summon scrols that ne0 made works fine on a ph client, but the us need a client mod to show dt right

the obsi mantle don't show on us version, but it do on ph, just 2 samples

As i thougt. But what mades me confuse is that the modified pieces Health, rapid etc. seems to be buggy.

Some guys make them working (if the stats will added i dont know) and some not (like me)

Its very Crappy with all these Clients. Why are the Rappelz DEV`s so stupid and made xx versions of them?

Originally Posted by speedy-nl

those pieces don't work for me eighther, and i have a 7.3 itemresource + 7.1 ph client, but i can't use them, you would say the data shoud be correct it prolly is, but my quess is the client and db don't understand each other

This was my first thing i thought, but than i got a message with a request for create an NPC like some on "Fenix" and this Char has the Pieces on the Char buff showing (dont know the right in english, sry)

So, there must be a way. I will not rest until i got them working

Originally Posted by speedy-nl

maybe they got them working true lua

Hmm, thats so easy that i didnt thougt about this

Thanks speedy, this will be definitly easier than figure out whats the failure.


I love LUA. There so much things possible with them

[hfmazbs]

hi can u tell me how i add thes script (belt 6 slot ) how i do ???
my belt is lvl 150 please help me
ــــــــــــــــــــــــــــــــــــــــــــــــــ ــــــــــــــــــــــــــ
sory for my bad english

[Raskim2000]

Originally Posted by hfmazbs

hi can u tell me how i add thes script (belt 6 slot ) how i do ???
my belt is lvl 150 please help me
ــــــــــــــــــــــــــــــــــــــــــــــــــ ــــــــــــــــــــــــــ
sory for my bad english

Just open your SQL, select "New Query" insert the script and hit F5. (In your example you have to put your belt id into the script)

[hfmazbs]

i dont now my belt id please help me please