[Collecting]Usefull SQL-Script`s

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

< Erased >

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...

Quote:

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.

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

thank you in advance

Quote:

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 Code: use arcadia update dbo.ItemResource set price = 3000000 where id = Here_Item_ID Search for items  Spoiler Code: 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 Code: -- 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 Code: --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 Code: 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 Code: 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 Code: -- 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 Code: -- 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 Code: -- 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 Code: -- 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 Code: -- 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 Code: -- 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 Code: 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 Code: 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!

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?

Quote:

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.

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.

Quote:

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. :D

so what should we download to have them working?

Quote:

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 [Only registered and activated users can see links. Click Here To Register...]

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) :D

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

Quote:

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 :D

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 :D

Quote:

Originally Posted by speedy-nl maybe they got them working true lua ;)

Hmm, thats so easy that i didnt thougt about this :D

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


I love LUA. There so much things possible with them :D

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

Quote:

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)

i dont now my belt id please help me please