[Collecting]Usefull SQL-Script`s

[Raskim2000]

Originally Posted by evilxana

any one have script or any thing for my problem ???????????????


i use this file(Redemption Repack v1.04) + client 7.1 PH (Rappelz 7.1 Client Update
Powered by: NCarbon) ...

i lost ... : (


the problem is :

I can't speak with the teleport hidden Village (when i clic in him nothing happen: no speak ...no dialogue )....and thnx for help : Handsdown:

Sounds, that the contact_sript cannot talk to the LUA, or better said, There are 2 differents. 1 is the Contact Script, but the LUA works with an other function.

[ismokedrow]

I'll DO IT ^^ More item's makes me happy ^^ Now the question is do the little effects on this items actually transfer to the character wearing it + If these smaller versions of dura are available on cloaks could we not use a similar method to jerry rig dura equips?


-EDIT-

All three work:

-First = Noxious Helmet
-Second = Helmet with Poison
-Third = Rapid Bikini Deco

[Raskim2000]

Originally Posted by speedy-nl

rask, smoke any of you 2 wana test those id to see if they show

3630124...........3630125.............602110301

We allready have these ID`s in the 1.3 Repack Database and im working on it to write the Entry`s, but that needs much time. ._.

Originally Posted by ismokedrow

I'll DO IT ^^ More item's makes me happy ^^ Now the question is do the little effects on this items actually transfer to the character wearing it + If these smaller versions of dura are available on cloaks could we not use a similar method to jerry rig dura equips?

No, you know smoke, the current GS dont support Dura Handle, so the only way to delte them is the timed method.

But hey, give me some time and most of the Effect Deco will be functional. (The Deco with Buffs not, because i have no idea how to handle them, that they appear and disappear, same like the Set Buffs of the Rank 7 Stuff)


BTW, not important, but i found two really funny helmets (They have no icon)

302307 WTF Helm
302213 Soldiers Helm

[ismokedrow]

Well we could rig them to use an lua or we could do like the item should with the optional variables.. but probably easier to go with an lua set of functions for the items ^^

[ismokedrow]

Well get a package of all these nifty little deco's together (in a script if you don't mind) and pass it to me and Raskim via PM and we'll see what works and what doesn't ^^ Need something to work on beside COR shops anyway ^^

[Raskim2000]

Originally Posted by ismokedrow

Well we could rig them to use an lua or we could do like the item should with the optional variables.. but probably easier to go with an lua set of functions for the items ^^

I dont know any function`s with them you can write that an Buff appear for example for 30 second`s, dissappear and appear again.

[ismokedrow]

Well a dynamic trigger would be hard to accomplish, as far as these smaller deco items go we could simply hardcode their stats into the optional variables. ^^ We simply need to know all the different opt_var_type 's so we can code them in correctly, but SilentBill already proved it works for things like (M.atk/Crit/P.atk etc..) I will def have to get a hold to him for all the types ^^ These Dura Deco won't be hard to get working properly.

[Raskim2000]

Originally Posted by speedy-nl

yea wel the problem with those id is i have no idee if i did them before

remember i have more id's then ever now

Like i said, we allready have the ID´s, but i have no idea how to make the buffs appear and disappear.

 Spoiler

602110106	Savage Ninja Suit(28 days)
602110107	Resilient Ninja Suit(28 days)
602110108	Forceful Ninja Suit(28 days)
602110109	Fiendish Ninja Suit(28 days)
602110110	Polished Ninja Suit(28 days)
602110111	Ardent Ninja Suit(28 days)
603110101	Rapid Ninja Helmet(28 days)
603110102	Sturdy Ninja Helmet(28 days)
603110103	Eager Ninja Helmet(28 days)
603110104	Armored Ninja Helmet(28 days)
603110105	Devoted Ninja Helmet(28 days)
603110106	Savage Ninja Helmet(28 days)
603110107	Resilient Ninja Helmet(28 days)
603110108	Forceful Ninja Helmet(28 days)
603110109	Fiendish Ninja Helmet(28 days)
603110110	Polished Ninja Helmet(28 days)
603110111	Ardent Ninja Helmet(28 days)
604110101	Rapid Ninja Gloves(28 days)
604110102	Sturdy Ninja Gloves(28 days)
604110103	Eager Ninja Gloves(28 days)
604110104	Armored Ninja Gloves(28 days)
604110105	Devoted Ninja Gloves(28 days)
604110106	Savage Ninja Gloves(28 days)
604110107	Resilient Ninja Gloves(28 days)
604110108	Forceful Ninja Gloves(28 days)
604110109	Fiendish Ninja Gloves(28 days)
604110110	Polished Ninja Gloves(28 days)
604110111	Ardent Ninja Gloves(28 days)
605110101	Rapid Ninja Boots(28 days)
605110102	Sturdy Ninja Boots(28 days)
605110103	Eager Ninja Boots(28 days)
605110104	Armored Ninja Boots(28 days)
605110105	Devoted Ninja Boots(28 days)
605110106	Savage Ninja Boots(28 days)
605110107	Resilient Ninja Boots(28 days)
605110108	Forceful Ninja Boots(28 days)
605110109	Fiendish Ninja Boots(28 days)
605110110	Polished Ninja Boots(28 days)
605110111	Ardent Ninja Boots(28 days)
602110101	Rapid Ninja Suit(28 days)
602110102	Sturdy Ninja Suit(28 days)
602110103	Eager Ninja Suit(28 days)
602110104	Armored Ninja Suit(28 days)
602110105	Devoted Ninja Suit(28 days)

----------

602110301	Rapid Swim Suit(28 days)
602110302	Sturdy Swim Suit(28 days)
602110303	Eager Swim Suit(28 days)
602110304	Armored Swim Suit(28 days)
602110305	Devoted Swim Suit(28 days)
602110306	Savage Swim Suit(28 days)
602110307	Resilient Swim Suit(28 days)
602110308	Forceful Swim Suit(28 days)
602110309	Fiendish Swim Suit(28 days)
602110310	Polished Swim Suit(28 days)
602110311	Ardent Swim Suit(28 days)
605110301	Rapid Swimsuit Flip-Flops(28 days)
605110302	Sturdy Swimsuit Flip-Flops(28 days)
605110303	Eager Swimsuit Flip-Flops(28 days)
605110304	Armored Swimsuit Flip-Flops(28 days)
605110305	Devoted Swimsuit Flip-Flops(28 days)
605110306	Savage Swimsuit Flip-Flops(28 days)
605110307	Resilient Swimsuit Flip-Flops(28 days)
605110308	Forceful Swimsuit Flip-Flops(28 days)
605110309	Fiendish Swimsuit Flip-Flops(28 days)
605110310	Polished Swimsuit Flip-Flops(28 days)
605110311	Ardent Swimsuit Flip-Flops(28 days)

----------

602110201	Rapid Viking Suit(28 days)
602110202	Sturdy Viking Suit(28 days)
602110203	Eager Viking Suit(28 days)
602110204	Armored Viking Suit(28 days)
602110205	Devoted Viking Suit(28 days)
602110206	Savage Viking Suit(28 days)
602110207	Resilient Viking Suit(28 days)
602110208	Forceful Viking Suit(28 days)
602110209	Fiendish Viking Suit(28 days)
602110210	Polished Viking Suit(28 days)
602110211	Ardent Viking Suit(28 days)
603110201	Rapid Viking Helmet(28 days)
603110202	Sturdy Viking Helmet(28 days)
603110203	Eager Viking Helmet(28 days)
603110204	Armored Viking Helmet(28 days)
603110205	Devoted Viking Helmet(28 days)
603110206	Savage Viking Helmet(28 days)
603110207	Resilient Viking Helmet(28 days)
603110208	Forceful Viking Helmet(28 days)
603110209	Fiendish Viking Helmet(28 days)
603110210	Polished Viking Helmet(28 days)
603110211	Ardent Viking Helmet(28 days)
604110201	Rapid Viking Gloves(28 days)
604110202	Sturdy Viking Gloves(28 days)
604110203	Eager Viking Gloves(28 days)
604110204	Armored Viking Gloves(28 days)
604110205	Devoted Viking Gloves(28 days)
604110206	Savage Viking Gloves(28 days)
604110207	Resilient Viking Gloves(28 days)
604110208	Forceful Viking Gloves(28 days)
604110209	Fiendish Viking Gloves(28 days)
604110210	Polished Viking Gloves(28 days)
604110211	Ardent Viking Gloves(28 days)
605110201	Rapid Viking Boots(28 days)
605110202	Sturdy Viking Boots(28 days)
605110203	Eager Viking Boots(28 days)
605110204	Armored Viking Boots(28 days)
605110205	Devoted Viking Boots(28 days)
605110206	Savage Viking Boots(28 days)
605110207	Resilient Viking Boots(28 days)
605110208	Forceful Viking Boots(28 days)
605110209	Fiendish Viking Boots(28 days)
605110210	Polished Viking Boots(28 days)
605110211	Ardent Viking Boots(28 days)

----------

304110101	Rapid Mask of the Crow(28 days)
304110102	Sturdy Mask of the Crow(28 days)
304110103	Eager Mask of the Crow(28 days)
304110104	Armored Mask of the Crow(28 days)
304110105	Devoted Mask of the Crow(28 days)
304110106	Savage Mask of the Crow(28 days)
304110107	Resilient Mask of the Crow(28 days)
304110108	Forceful Mask of the Crow(28 days)
304110109	Fiendish Mask of the Crow(28 days)
304110110	Polished Mask of the Crow(28 days)
304110111	Ardent Mask of the Crow(28 days)
304110701	Rapid Glass Butterfly Mask(28 days)
304110702	Sturdy Glass Butterfly Mask(28 days)
304110703	Eager Glass Butterfly Mask(28 days)
304110704	Armored Glass Butterfly Mask(28 days)
304110705	Devoted Glass Butterfly Mask(28 days)
304110706	Savage Glass Butterfly Mask(28 days)
304110707	Resilient Glass Butterfly Mask(28 days)
304110708	Forceful Glass Butterfly Mask(28 days)
304110709	Fiendish Glass Butterfly Mask(28 days)
304110710	Polished Glass Butterfly Mask(28 days)
304110711	Ardent Glass Butterfly Mask(28 days)
304110801	Rapid Bandit Mask(28 days)
304110802	Sturdy Bandit Mask(28 days)
304110803	Eager Bandit Mask(28 days)
304110804	Armored Bandit Mask(28 days)
304110805	Devoted Bandit Mask(28 days)
304110806	Savage Bandit Mask(28 days)
304110807	Resilient Bandit Mask(28 days)
304110808	Forceful Bandit Mask(28 days)
304110809	Fiendish Bandit Mask(28 days)
304110810	Polished Bandit Mask(28 days)
304110811	Ardent Bandit Mask(28 days)
304115101	Rapid Mask of the Crow(28 days)
304115102	Sturdy Mask of the Crow(28 days)
304115103	Eager Mask of the Crow(28 days)
304115104	Armored Mask of the Crow(28 days)
304115105	Devoted Mask of the Crow(28 days)
304115106	Savage Mask of the Crow(28 days)
304115107	Resilient Mask of the Crow(28 days)
304115108	Forceful Mask of the Crow(28 days)
304115109	Fiendish Mask of the Crow(28 days)
304115110	Polished Mask of the Crow(28 days)
304115111	Ardent Mask of the Crow(28 days)
304115701	Rapid Glass Butterfly Mask(28 days)
304115702	Sturdy Glass Butterfly Mask(28 days)
304115703	Eager Glass Butterfly Mask(28 days)
304115704	Armored Glass Butterfly Mask(28 days)
304115705	Devoted Glass Butterfly Mask(28 days)
304115706	Savage Glass Butterfly Mask(28 days)
304115707	Resilient Glass Butterfly Mask(28 days)
304115708	Forceful Glass Butterfly Mask(28 days)
304115709	Fiendish Glass Butterfly Mask(28 days)
304115710	Polished Glass Butterfly Mask(28 days)
304115711	Ardent Glass Butterfly Mask(28 days)
304115801	Rapid Bandit Mask(28 days)
304115802	Sturdy Bandit Mask(28 days)
304115803	Eager Bandit Mask(28 days)
304115804	Armored Bandit Mask(28 days)
304115805	Devoted Bandit Mask(28 days)
304115806	Savage Bandit Mask(28 days)
304115807	Resilient Bandit Mask(28 days)
304115808	Forceful Bandit Mask(28 days)
304115809	Fiendish Bandit Mask(28 days)
304115810	Polished Bandit Mask(28 days)
304115811	Ardent Bandit Mask(28 days)
10950022	Mask of the Gloomy Rabbit
10950023	Mask of the Lovely Rabbit
10950024	Mask of the Crow <Permanent>
10950030	Glass Butterfly Mask
10950031	Bandit Mask
10950033	Black Rabbit Mask
10950034	Black Rabbit Mask<30days>
10950035	Black Rabbit Mask<15days>
10950036	Sad Clown Mask
10950037	Sad Clown Mask<30days>
10950038	Sad Clown Mask<15days>
12000182	Snowman Mask
12010208	Mask of the Gloomy Rabbit<event for 14days>
12010209	Mask of the Lovely Rabbit<event for 14days>
12010211	Mask of the Crow (14 days)
12010286	Black Rabbit Mask<14days>
12010287	Black Rabbit Mask<7days>
12010288	Sad Clown Mask(14 Day)
12010289	Sad Clown Mask<7days>
12012071	Mask random box<Event_2010>
12012109	Mask of the Gloomy Rabbit<Event_2010_Non-tradable_28days>
12012110	Mask of the Lovely Rabbit<Event_2010_Non-tradable_28days>
12012111	Mask of The Crow<Event_2010_Non-tradable_28days>
12012117	Glass Butterfly Mask<Event_2010_Non-tradable_28days>
12012118	Bandit Mask<Event_2010_Non-tradable_28days>
13630139	Antivirus Mask<Event Item>
19000016	Primal Mask <30days> <For Test server>
19000044	Mask of The Crow <Permanent> <For Test server>
19000050	Glass Butterfly Mask <Permanent> <For Test server>
19000051	Bandit Mask <Permanent> <For Test server>
224510401	Rapid Primal Mask(28 days)
224510402	Sturdy Primal Mask(28 days)
224510403	Eager Primal Mask(28 days)
224510404	Armored Primal Mask(28 days)
224510405	Devoted Primal Mask(28 days)
224510406	Savage Primal Mask(28 days)
224510407	Resilient Primal Mask(28 days)
224510408	Forceful Primal Mask(28 days)
224510409	Fiendish Primal Mask(28 days)
224510410	Polished Primal Mask(28 days)
224510411	Ardent Primal Mask(28 days)
224515401	Rapid Primal Mask(28 days)
224515402	Sturdy Primal Mask(28 days)
224515403	Eager Primal Mask(28 days)
224515404	Armored Primal Mask(28 days)
224515405	Devoted Primal Mask(28 days)
224515406	Savage Primal Mask(28 days)
224515407	Resilient Primal Mask(28 days)
224515408	Forceful Primal Mask(28 days)
224515409	Fiendish Primal Mask(28 days)
224515410	Polished Primal Mask(28 days)
224515411	Ardent Primal Mask(28 days)
246715637	Agility: Primal Mask<28days><When attacking>
246715638	Protector: Primal Mask<28days><When attacking>
246715639	Quickness: Primal Mask<28days><When attacking>
246715640	Iron Fortress: Primal Mask<28days><When attacking>
246715641	Gaze: Primal Mask<28days><When attacking>
246715642	Blow: Primal Mask<28days><When attacking>
246715643	Mana: Primal Mask<28days><When attacking>
246715644	Sharp: Primal Mask<28days><When attacking>
246715645	Magic: Primal Mask<28days><When attacking>
246715646	Lucid: Primal Mask<28days><When attacking>
246715647	Insight: Primal Mask<28days><When attacking>
246716055	Agility: Primal Mask<28days><being attacked>
246716056	Protector: Primal Mask<28days><being attacked>
246716057	Quickness: Primal Mask<28days><being attacked>
246716058	Iron Fortress: Primal Mask<28days><being attacked>
246716059	Gaze: Primal Mask<28days><being attacked>
246716060	Blow: Primal Mask<28days><being attacked>
246716061	Mana: Primal Mask<28days><being attacked>
246716062	Sharp: Primal Mask<28days><being attacked>
246716063	Magic: Primal Mask<28days><being attacked>
246716064	Lucid: Primal Mask<28days><being attacked>
246716065	Insight: Primal Mask<28days><being attacked>

Originally Posted by ismokedrow

Well a dynamic trigger would be hard to accomplish, as far as these smaller deco items go we could simply hardcode their stats into the optional variables. ^^ We simply need to know all the different opt_var_type 's so we can code them in correctly, but SilentBill already proved it works for things like (M.atk/Crit/P.atk etc..) I will def have to get a hold to him for all the types ^^ These Dura Deco won't be hard to get working properly.

Ehm, the Deco i released,give the right Stat`s.

That`s the only Reason why i needed so long for this "little" Script.

[Raskim2000]

I Know them.

They a sorted in 4 Groups :

<beeing attacked> passiv stat´s
<when attacking> passiv stat`s
<beeing attacked> with buff
<when attacking> with buff

[qaaah]

Thx man you are the best !

[gavsta]

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

Entrys for the Epic 7 Pieces (With Help of Speedy-nl)

 Spoiler

Just download the Rar-package anduse the Scripts. 1 is LUA, 1 for SQL.


And the ID`s of the Pieces

 Spoiler

910064 Healthy Altered Pieces
910065 Spiritual Altered Pieces
910066 Rapid Altered Pieces
910067 Sturdy Altered Pieces
910068 Eager Altered Pieces
910069 Armored Altered Pieces
910070 Devoted Altered Pieces
910071 Savage Altered Pieces
910072 Resilient Altered Pieces
910073 Forceful Altered Pieces
910074 Fiendish Altered Pieces
910075 Polished Altered Pieces
910076 Ardent Altered Pieces

Gilded Wings Fix (With Help of Speedy-nl)

 Spoiler

Download the File, Connect to your SQL-Server, run the script and hit F5. Gratz, you`ve done it!

(THE WINGS WILL BE ONLY SHOWN ON A 7.1 PH Modded CLIENT!)

2012062 Gilded Wings

Ice-Maiden Potion Fix

 Spoiler

just download the SQL File , double Click on it and hit F5...

Epic 7.1 KTS Special Effect Deco Partial Release (im not finished, there are many more Deco items, wich has to be configured)

 Spoiler

Download the Script, open your SQL, double Click on the Script and Hit F5

Some of the Decoration will only be shown on a Modded Epic 7.1 (PH) Client!



And the Codes for this Special Deco

Bear Deco

 Spoiler

602110401	Rapid Fluffy Bear Costume<bear Costume>(28 days)
602110402	Sturdy Fluffy Bear Costume<bear Costume>(28 days)
602110403	Eager Fluffy Bear Costume<bear Costume>(28 days)
602110404	Armored Fluffy Bear Costume<bear Costume>(28 days)
602110405	Devoted Fluffy Bear Costume<bear Costume>(28 days)
602110406	Savage Fluffy Bear Costume<bear Costume>(28 days)
602110407	Resilient Fluffy Bear Costume<bear Costume>(28 days)
602110408	Forceful Fluffy Bear Costume<bear Costume>(28 days)
602110409	Fiendish Fluffy Bear Costume<bear Costume>(28 days)
602110410	Polished Fluffy Bear Costume<bear Costume>(28 days)
602110411	Ardent Fluffy Bear Costume<bear Costume>(28 days)
602110501	Rapid Ferocious Bear Costume<bear Costume>(28 days)
602110502	Sturdy Ferocious Bear Costume<bear Costume>(28 days)
602110503	Eager Ferocious Bear Costume<bear Costume>(28 days)
602110504	Armored Ferocious Bear Costume<bear Costume>(28 days)
602110505	Devoted Ferocious Bear Costume<bear Costume>(28 days)
602110506	Savage Ferocious Bear Costume<bear Costume>(28 days)
602110507	Resilient Ferocious Bear Costume<bear Costume>(28 days)
602110508	Forceful Ferocious Bear Costume<bear Costume>(28 days)
602110509	Fiendish Ferocious Bear Costume<bear Costume>(28 days)
602110510	Polished Ferocious Bear Costume<bear Costume>(28 days)
602110511	Ardent Ferocious Bear Costume<bear Costume>(28 days)
602110601	Rapid Vicious Bear Costume<bear Costume>(28 days)
602110602	Sturdy Vicious Bear Costume<bear Costume>(28 days)
602110603	Eager Vicious Bear Costume<bear Costume>(28 days)
602110604	Armored Vicious Bear Costume<bear Costume>(28 days)
602110605	Devoted Vicious Bear Costume<bear Costume>(28 days)
602110606	Savage Vicious Bear Costume<bear Costume>(28 days)
602110607	Resilient Vicious Bear Costume<bear Costume>(28 days)
602110608	Forceful Vicious Bear Costume<bear Costume>(28 days)
602110609	Fiendish Vicious Bear Costume<bear Costume>(28 days)
602110610	Polished Vicious Bear Costume<bear Costume>(28 days)
602110611	Ardent Vicious Bear Costume<bear Costume>(28 days)

------------------------------------------------------------------

603110401	Rapid Fluffy Bear Head<bear Head>(28 days)
603110402	Sturdy Fluffy Bear Head<bear Head>(28 days)
603110403	Eager Fluffy Bear Head<bear Head>(28 days)
603110404	Armored Fluffy Bear Head<bear Head>(28 days)
603110405	Devoted Fluffy Bear Head<bear Head>(28 days)
603110406	Savage Fluffy Bear Head<bear Head>(28 days)
603110407	Resilient Fluffy Bear Head<bear Head>(28 days)
603110408	Forceful Fluffy Bear Head<bear Head>(28 days)
603110409	Fiendish Fluffy Bear Head<bear Head>(28 days)
603110410	Polished Fluffy Bear Head<bear Head>(28 days)
603110411	Ardent Fluffy Bear Head<bear Head>(28 days)
603110501	Rapid Ferocious Bear Head<bear Head>(28 days)
603110502	Sturdy Ferocious Bear Head<bear Head>(28 days)
603110503	Eager Ferocious Bear Head<bear Head>(28 days)
603110504	Armored Ferocious Bear Head<bear Head>(28 days)
603110505	Devoted Ferocious Bear Head<bear Head>(28 days)
603110506	Savage Ferocious Bear Head<bear Head>(28 days)
603110507	Resilient Ferocious Bear Head<bear Head>(28 days)
603110508	Forceful Ferocious Bear Head<bear Head>(28 days)
603110509	Fiendish Ferocious Bear Head<bear Head>(28 days)
603110510	Polished Ferocious Bear Head<bear Head>(28 days)
603110511	Ardent Ferocious Bear Head<bear Head>(28 days)
603110601	Rapid Vicious Bear Head<bear Head>(28 days)
603110602	Sturdy Vicious Bear Head<bear Head>(28 days)
603110603	Eager Vicious Bear Head<bear Head>(28 days)
603110604	Armored Vicious Bear Head<bear Head>(28 days)
603110605	Devoted Vicious Bear Head<bear Head>(28 days)
603110606	Savage Vicious Bear Head<bear Head>(28 days)
603110607	Resilient Vicious Bear Head<bear Head>(28 days)
603110608	Forceful Vicious Bear Head<bear Head>(28 days)
603110609	Fiendish Vicious Bear Head<bear Head>(28 days)
603110610	Polished Vicious Bear Head<bear Head>(28 days)
603110611	Ardent Vicious Bear Head<bear Head>(28 days)

------------------------------------------------------------

604110401	Rapid Fluffy Bear Gloves<bear Hand>(28 days)
604110402	Sturdy Fluffy Bear Gloves<bear Hand>(28 days)
604110403	Eager Fluffy Bear Gloves<bear Hand>(28 days)
604110404	Armored Fluffy Bear Gloves<bear Hand>(28 days)
604110405	Devoted Fluffy Bear Gloves<bear Hand>(28 days)
604110406	Savage Fluffy Bear Gloves<bear Hand>(28 days)
604110407	Resilient Fluffy Bear Gloves<bear Hand>(28 days)
604110408	Forceful Fluffy Bear Gloves<bear Hand>(28 days)
604110409	Fiendish Fluffy Bear Gloves<bear Hand>(28 days)
604110410	Polished Fluffy Bear Gloves<bear Hand>(28 days)
604110411	Ardent Fluffy Bear Gloves<bear Hand>(28 days)
604110501	Rapid Ferocious Bear Gloves<bear Hand>(28 days)
604110502	Sturdy Ferocious Bear Gloves<bear Hand>(28 days)
604110503	Eager Ferocious Bear Gloves<bear Hand>(28 days)
604110504	Armored Ferocious Bear Gloves<bear Hand>(28 days)
604110505	Devoted Ferocious Bear Gloves<bear Hand>(28 days)
604110506	Savage Ferocious Bear Gloves<bear Hand>(28 days)
604110507	Resilient Ferocious Bear Gloves<bear Hand>(28 days)
604110508	Forceful Ferocious Bear Gloves<bear Hand>(28 days)
604110509	Fiendish Ferocious Bear Gloves<bear Hand>(28 days)
604110510	Polished Ferocious Bear Gloves<bear Hand>(28 days)
604110511	Ardent Ferocious Bear Gloves<bear Hand>(28 days)
604110601	Rapid Vicious Bear Gloves<bear Hand>(28 days)
604110602	Sturdy Vicious Bear Gloves<bear Hand>(28 days)
604110603	Eager Vicious Bear Gloves<bear Hand>(28 days)
604110604	Armored Vicious Bear Gloves<bear Hand>(28 days)
604110605	Devoted Vicious Bear Gloves<bear Hand>(28 days)
604110606	Savage Vicious Bear Gloves<bear Hand>(28 days)
604110607	Resilient Vicious Bear Gloves<bear Hand>(28 days)
604110608	Forceful Vicious Bear Gloves<bear Hand>(28 days)
604110609	Fiendish Vicious Bear Gloves<bear Hand>(28 days)
604110610	Polished Vicious Bear Gloves<bear Hand>(28 days)
604110611	Ardent Vicious Bear Gloves<bear Hand>(28 days)

--------------------------------------------------------------

605110401	Rapid Fluffy Bear Boots<bear Foot>(28 days)
605110402	Sturdy Fluffy Bear Boots<bear Foot>(28 days)
605110403	Eager Fluffy Bear Boots<bear Foot>(28 days)
605110404	Armored Fluffy Bear Boots<bear Foot>(28 days)
605110405	Devoted Fluffy Bear Boots<bear Foot>(28 days)
605110406	Savage Fluffy Bear Boots<bear Foot>(28 days)
605110407	Resilient Fluffy Bear Boots<bear Foot>(28 days)
605110408	Forceful Fluffy Bear Boots<bear Foot>(28 days)
605110409	Fiendish Fluffy Bear Boots<bear Foot>(28 days)
605110410	Polished Fluffy Bear Boots<bear Foot>(28 days)
605110411	Ardent Fluffy Bear Boots<bear Foot>(28 days)
605110501	Rapid Ferocious Bear Boots<bear Foot>(28 days)
605110502	Sturdy Ferocious Bear Boots<bear Foot>(28 days)
605110503	Eager Ferocious Bear Boots<bear Foot>(28 days)
605110504	Armored Ferocious Bear Boots<bear Foot>(28 days)
605110505	Devoted Ferocious Bear Boots<bear Foot>(28 days)
605110506	Savage Ferocious Bear Boots<bear Foot>(28 days)
605110507	Resilient Ferocious Bear Boots<bear Foot>(28 days)
605110508	Forceful Ferocious Bear Boots<bear Foot>(28 days)
605110509	Fiendish Ferocious Bear Boots<bear Foot>(28 days)
605110510	Polished Ferocious Bear Boots<bear Foot>(28 days)
605110511	Ardent Ferocious Bear Boots<bear Foot>(28 days)
605110601	Rapid Vicious Bear Boots<bear Foot>(28 days)
605110602	Sturdy Vicious Bear Boots<bear Foot>(28 days)
605110603	Eager Vicious Bear Boots<bear Foot>(28 days)
605110604	Armored Vicious Bear Boots<bear Foot>(28 days)
605110605	Devoted Vicious Bear Boots<bear Foot>(28 days)
605110606	Savage Vicious Bear Boots<bear Foot>(28 days)
605110607	Resilient Vicious Bear Boots<bear Foot>(28 days)
605110608	Forceful Vicious Bear Boots<bear Foot>(28 days)
605110609	Fiendish Vicious Bear Boots<bear Foot>(28 days)
605110610	Polished Vicious Bear Boots<bear Foot>(28 days)
605110611	Ardent Vicious Bear Boots<bear Foot>(28 days)

------------------------------------------------------------

606110401	Rapid Fluffy Bear Cloak<bear Cloak>(28 days)
606110402	Sturdy Fluffy Bear Cloak<bear Cloak>(28 days)
606110403	Eager Fluffy Bear Cloak<cloak for bear>(28 days)
606110404	Armored Fluffy Bear Cloak<cloak for bear>(28 days)
606110405	Devoted Fluffy Bear Cloak<cloak for bear>(28 days)
606110406	Savage Fluffy Bear Cloak<cloak for bear>(28 days)
606110407	Resilient Fluffy Bear Cloak<cloak for bear>(28 days)
606110408	Forceful Fluffy Bear Cloak<cloak for bear>(28 days)
606110409	Fiendish Fluffy Bear Cloak<cloak for bear>(28 days)
606110410	Polished Fluffy Bear Cloak<cloak for bear>(28 days)
606110411	Ardent Fluffy Bear Cloak<cloak for bear>(28 days)
606110501	Rapid Ferocious Bear Cloak<cloak for bear>(28 days)
606110502	Sturdy Ferocious Bear Cloak<cloak for bear>(28 days)
606110503	Eager Ferocious Bear Cloak<cloak for bear>(28 days)
606110504	Armored Ferocious Bear Cloak<cloak for bear>(28 days)
606110505	Devoted Ferocious Bear Cloak<cloak for bear>(28 days)
606110506	Savage Ferocious Bear Cloak<cloak for bear>(28 days)
606110507	Resilient Ferocious Bear Cloak<cloak for bear>(28 days)
606110508	Forceful Ferocious Bear Cloak<cloak for bear>(28 days)
606110509	Fiendish Ferocious Bear Cloak<cloak for bear>(28 days)
606110510	Polished Ferocious Bear Cloak<cloak for bear>(28 days)
606110511	Ardent Ferocious Bear Cloak<cloak for bear>(28 days)
606110601	Rapid Vicious Bear Cloak<cloak for bear>(28 days)
606110602	Sturdy Vicious Bear Cloak<cloak for bear>(28 days)
606110603	Eager Vicious Bear Cloak<cloak for bear>(28 days)
606110604	Armored Vicious Bear Cloak<cloak for bear>(28 days)
606110605	Devoted Vicious Bear Cloak<cloak for bear>(28 days)
606110606	Savage Vicious Bear Cloak<cloak for bear>(28 days)
606110607	Resilient Vicious Bear Cloak<cloak for bear>(28 days)
606110608	Forceful Vicious Bear Cloak<cloak for bear>(28 days)
606110609	Fiendish Vicious Bear Cloak<cloak for bear>(28 days)
606110610	Polished Vicious Bear Cloak<cloak for bear>(28 days)
606110611	Ardent Fluffy Bear Cloak<cloak for bear>(28 days)

And the Special Rank 7 Cloaks

 Spoiler

246715417	Rapid Cloak of Holy Serenity<New Rank 7><28 days><Attack>
246715418	Sturdy Cloak of Holy Serenity<New Rank 7><28 days><Attack>
246715419	Eager Cloak of Holy Serenity<New Rank 7><28 days><Attack>
246715420	Armored Cloak of Holy Serenity<New Rank 7><28 days><Attack>
246715421	Devoted Cloak of Holy Serenity<New Rank 7><28 days><Attack>
246715422	Savage Cloak of Holy Serenity<New Rank 7><28 days><Attack>
246715423	Resilient Cloak of Holy Serenity<New Rank 7><28 days><Attack>
246715424	Forceful Cloak of Holy Serenity<New Rank 7><28 days><Attack>
246715425	Fiendish Cloak of Holy Serenity<New Rank 7><28 days><Attack>
246715426	Polished Cloak of Holy Serenity<New Rank 7><28 days><Attack>
246715427	Ardent Cloak of Holy Serenity<New Rank 7><28 days><Attack>

----------------------------------------------------------------------------

246715428	Rapid Obsidikar Spine Cloak<New Rank 7><28 days><Attack>
246715429	Sturdy Obsidikar Spine Cloak<New Rank 7><28 days><Attack>
246715430	Eager Obsidikar Spine Cloak<New Rank 7><28 days><Attack>
246715431	Armored Obsidikar Spine Cloak<New Rank 7><28 days><Attack>
246715432	Devoted Obsidikar Spine Cloak<New Rank 7><28 days><Attack>
246715433	Savage Obsidikar Spine Cloak<New Rank 7><28 days><Attack>
246715434	Resilient Obsidikar Spine Cloak<New Rank 7><28 days><Attack>
246715435	Forceful Obsidikar Spine Cloak<New Rank 7><28 days><Attack>
246715436	Fiendish Obsidikar Spine Cloak<New Rank 7><28 days><Attack>
246715437	Polished Obsidikar Spine Cloak<New Rank 7><28 days><Attack>
246715438	Ardent Obsidikar Spine Cloak<New Rank 7><28 days><Attack>

Scripts Credit to HeavenOnlyWishes:

 Spoiler

Some Scripts to let Empty DT´s drop, give Abomination Stat`s and more

 Spoiler

As you may already know the Unicorn and Nightmare E.Cards do not drop from any monsters, although they are in the database. So for starters I setup drop groups for both Unicorn and Nightmare monsters to drop both cards:

 Spoiler

UPDATE Arcadia.dbo.DropGroupResource
SET drop_item_id_02 = '540067',
drop_min_count_02 = '1',
drop_max_count_02 = '1',
drop_percentage_02 = '0.3500000',
drop_item_id_03 = '540065',
drop_min_count_03 = '1',
drop_max_count_03 = '1',
drop_percentage_03 = '0.1250000'
WHERE id = '-851080'

UPDATE Arcadia.dbo.DropGroupResource
SET drop_item_id_02 = '540067',
drop_min_count_02 = '1',
drop_max_count_02 = '1',
drop_percentage_02 = '0.1250000',
drop_item_id_03 = '540065',
drop_min_count_03 = '1',
drop_max_count_03 = '1',
drop_percentage_03 = '0.3500000'
WHERE id = '-851040'

UPDATE Arcadia.dbo.MonsterResource
SET drop_item_id_00 = '-851040',
drop_percentage_00 = '0.01000000',
drop_min_count_00 = '1',
drop_max_count_00 = '1',
drop_min_level_00 = '1',
drop_max_level_00 = '1'
WHERE taming_id = '3901'

UPDATE Arcadia.dbo.MonsterResource
SET drop_item_id_00 = '-851080',
drop_percentage_00 = '0.01000000',
drop_min_count_00 = '1',
drop_max_count_00 = '1',
drop_min_level_00 = '1',
drop_max_level_00 = '1'
WHERE taming_id = '4001'

Give your Abomination Stat`s:

 Spoiler

UPDATE Arcadia.dbo.StatResource
SET str = 10, int = 13, vit = 11, men = 15, agi = 19, dex = 24, luk = 15
WHERE id = 4401

UPDATE Arcadia.dbo.StatResource
SET str = 46, int = 57, vit = 43, men = 57, agi = 37, dex = 105, luk = 30
WHERE id = 4402

UPDATE Arcadia.dbo.StatResource
SET str = 55, int = 69, vit = 56, men = 74, agi = 92, dex = 135, luk = 45
WHERE id = 4403

Change Creature Taming Skill Cooltime and Casttime:

 Spoiler

UPDATE Arcadia.dbo.SkillResource
SET delay_cast = 10.00, delay_cooltime = 30.00
WHERE id = 4003

Epic 7.1 Client Quest Fix

 Spoiler

Download the Script , open SQL Server, double click on the Script and Hit F5

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

And for NPCs: NPC ID and NPC Title in Ascending order by NPC's title.

 Spoiler

SELECT NPC.id, npc.text_id, STRING.value
FROM Arcadia.dbo.NPCResource NPC, Arcadia.dbo.StringResource STRING
WHERE npc.text_id = string.code
ORDER BY value ASC

Script Credit to eGurgle

 Spoiler

Set Enchancement-Rate

 Spoiler

declare @c1 decimal(10,5), @c2 decimal(10,5), @c3 decimal(10,5), @c4 decimal(10,5), @c5 decimal(10,5), @c6 decimal(10,5), @c7 decimal(10,5), @c8 decimal(10,5), @c9 decimal(10,5), @c10 decimal(10,5)
declare @c11 decimal(10,5), @c12 decimal(10,5), @c13 decimal(10,5), @c14 decimal(10,5), @c15 decimal(10,5), @c16 decimal(10,5), @c17 decimal(10,5), @c18 decimal(10,5), @c19 decimal(10,5), @c20 decimal(10,5)
declare @ac1 decimal(10,5), @ac2 decimal(10,5), @ac3 decimal(10,5), @ac4 decimal(10,5), @ac5 decimal(10,5), @ac6 decimal(10,5), @ac7 decimal(10,5), @ac8 decimal(10,5), @ac9 decimal(10,5), @ac10 decimal(10,5)
declare @ac11 decimal(10,5), @ac12 decimal(10,5), @ac13 decimal(10,5), @ac14 decimal(10,5), @ac15 decimal(10,5), @ac16 decimal(10,5), @ac17 decimal(10,5), @ac18 decimal(10,5), @ac19 decimal(10,5), @ac20 decimal(10,5)
declare @s1 decimal(10,5), @s2 decimal(10,5), @s3 decimal(10,5), @s4 decimal(10,5), @s5 decimal(10,5), @s6 decimal(10,5), @s7 decimal(10,5), @s8 decimal(10,5), @s9 decimal(10,5), @s10 decimal(10,5)
declare @as1 decimal(10,5), @as2 decimal(10,5), @as3 decimal(10,5), @as4 decimal(10,5), @as5 decimal(10,5), @as6 decimal(10,5), @as7 decimal(10,5), @as8 decimal(10,5), @as9 decimal(10,5), @as10 decimal(10,5)
set @c1 = 1 -- <<== @c1 to @c20 = desired rates do Normal Cubes Strike/Defense R2 to R7
set @c2 = 1
set @c3 = 1
set @c4 = 1
set @c5 = 0.6
set @c6 = 0.5
set @c7 = 0.4
set @c8 = 0.3
set @c9 = 0.2
set @c10 = 0.1
set @c11 = 0.09
set @c12 = 0.08
set @c13 = 0.07
set @c14 = 0.06
set @c15 = 0.05
set @c16 = 0.04
set @c17 = 0.03
set @c18 = 0.02
set @c19 = 0.01
set @c20 = 0.01
set @ac1 = 1 -- <<== @ac1 to @ac20 = desired rates do Ancient Cubes Strike/Defense R2 to R7
set @ac2 = 1
set @ac3 = 1
set @ac4 = 1
set @ac5 = 1
set @ac6 = 0.90
set @ac7 = 0.80
set @ac8 = 0.70
set @ac9 = 0.60
set @ac10 = 0.50
set @ac11 = 0.40
set @ac12 = 0.30
set @ac13 = 0.25
set @ac14 = 0.20
set @ac15 = 0.15
set @ac16 = 0.14
set @ac17 = 0.13
set @ac18 = 0.12
set @ac19 = 0.11
set @ac20 = 0.10
set @s1 = 1 -- <<== @s1 to @s10 = desired rates do Cube Skill
set @s2 = 0.5
set @s3 = 0.3
set @s4 = 0.1
set @s5 = 0.05
set @s6 = 0
set @s7 = 0
set @s8 = 0
set @s9 = 0
set @s10 = 0
set @as1 = 1 -- <<== @as1 to @as10 = desired rates do Ancient Cube Skill
set @as2 = 0.90
set @as3 = 0.80
set @as4 = 0.70
set @as5 = 0.60
set @as6 = 0.50
set @as7 = 0.40
set @as8 = 0.30
set @as9 = 0.20
set @as10 = 0.10

/***** Cubes Def and Strikes *****/
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_1] = @c1
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_2] = @c2
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_3] = @c3
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_4] = @c4
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_5] = @c5
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_6] = @c6
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_7] = @c7
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_8] = @c8
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_9] = @c9
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_10] = @c10
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_11] = @c11
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_12] = @c12
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_13] = @c13
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_14] = @c14
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_15] = @c15
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_16] = @c16
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_17] = @c17
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_18] = @c18
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_19] = @c19
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_20] = @c20
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212


/***** Anc Cubes Def and Strikes *****/
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_1] = @ac1
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_2] = @ac2
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_3] = @ac3
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_4] = @ac4
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_5] = @ac5
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_6] = @ac6
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_7] = @ac7
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_8] = @ac8
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_9] = @ac9
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_10] = @ac10
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_11] = @ac11
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_12] = @ac12
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_13] = @ac13
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_14] = @ac14
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_15] = @ac15
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_16] = @ac16
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_17] = @ac17
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_18] = @ac18
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_19] = @ac19
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_20] = @ac20
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211


/***** Cube Skill *****/
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_1] = @s1
where need_item = 700401

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_2] = @s2
where need_item = 700401

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_3] = @s3
where need_item = 700401

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_4] = @s4
where need_item = 700401

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_5] = @s5
where need_item = 700401

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_6] = @s6
where need_item = 700401

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_7] = @s7
where need_item = 700401

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_8] = @s8
where need_item = 700401

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_9] = @s9
where need_item = 700401

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_10] = @s10
where need_item = 700401


/***** Anc Cube Skill *****/
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_1] = @as1
where need_item = 700402

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_2] = @as2
where need_item = 700402

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_3] = @as3
where need_item = 700402

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_4] = @as4
where need_item = 700402

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_5] = @as5
where need_item = 700402

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_6] = @as6
where need_item = 700402

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_7] = @as7
where need_item = 700402

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_8] = @as8
where need_item = 700402

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_9] = @as9
where need_item = 700402

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_10] = @as10
where need_item = 700402

Unknown about Credit Scripts

 Spoiler

Set R7 Chips to R8 Chips (Chips will effect all Monster up to Lv 190)

 Spoiler

USE Arcadia
UPDATE [Arcadia].[dbo].[ItemResource]
SET opt_var2_0=8.00
WHERE id=690007 OR id=690107 OR id=690207
GO

Scripts Credit to all Member of Ncarbon Team

 Spoiler

Summoning Scrolls for Epic 7.1 Client (Ne0, JW988, Speedy-nl )

 Spoiler

1) run the sql script
2) copy the lua to server resource folder
3 copy the client mods to resource folder ONLY IF YOU USE A 7.1US CLIENT (if you use 7.1 PH this mod is not needed, not tested with any other 7.1)

ID´s for the scrolls:

 Spoiler

3630270	Pantera Summoning Scroll
3630271	Tortus Summoning Scroll
3630272	Poultry Summoning Scroll
3630273	Orc Summoning Scroll
3630274	Yeti Summoning Scroll
3630275	Skeleton Summoning Scroll
3630276	Red Pixie Summoning Scroll
3630277	Blue Pixie Summoning Scroll
3630278	Siren Summoning Scroll
3630279	Wolf Summoning Scroll
3630280	Octopus Summoning Scroll
3630281	Hawkman Summoning Scroll
3630282	Salamander Summoning Scroll
3630283	Harpy Summoning Scroll
3630284	Unicorn Summoning Scroll
3630285	Nightmare Summoning Scroll
3630286	Angel Summoning Scroll
3630287	Kentauros Summoning Scroll
3630288	Gnoll Summoning Scroll
3630289	Naga Summoning Scroll
3630290	Cerberus Summoning Scroll
3630291	Genie Summoning Scroll
3630292	Ifrit Summoning Scroll
3630293	White Dragon Summoning Scroll
3630294	Death Tyrant Summoning Scroll

ID´s of the summoned Mobs

 Spoiler

710	Summoned Pantera
711	Summoned Tortus
712	Summoned Poultry
713	Summoned Orc
714	Summoned Yeti
715	Summoned Skeleton
716	Summoned Red Pixie
717	Summoned Blue Pixie
718	Summoned Siren
719	Summoned Wolf
720	Summoned Octopus
721	Summoned Hawkman
722	Summoned Salamander
723	Summoned Harpy
724	Summoned Unicorn
725	Summoned Nightmare
726	Summoned Angel
727	Summoned Kentauros
728	Summoned Gnoll
729	Summoned Naga
730	Summoned Cerberus
731	Summoned Genie
732	Summoned Ifrit
733	Summoned White Dragon
734	Summoned Death Tyrant

Download the Files

Obisdikar Spine Cloak and Cloak of Holy Serenity (Speedy-Nl, ismokedrow) (The Cloaks will only be shown on a modded 7.1 PH Client!)

 Spoiler

Just copy the Script, add it to SQL Server and Hit F5

 Spoiler

INSERT INTO [Arcadia].[dbo].[ItemResource] ([id], [name_id], [tooltip_id], [type], [group], [class], [wear_type], [set_id], [set_part_flag], [rank], [level], [enhance], [socket], [status_flag], [limit_deva], [limit_asura], [limit_gaia], [limit_fighter], [limit_hunter], [limit_magician], [limit_summoner], [use_min_level], [use_max_level], [target_min_level], [target_max_level], [range], [weight], [price], [huntaholic_point], [endurance], [material], [summon_id], [flag_cashitem], [flag_wear], [flag_use], [flag_target_use], [flag_duplicate], [flag_drop], [flag_trade], [flag_sell], [flag_storage], [flag_overweight], [flag_riding], [flag_move], [flag_sit], [flag_enhance], [flag_quest], [flag_raid], [flag_secroute], [flag_eventmap], [flag_huntaholic], [flag_huntaholic_usable_only], [available_period], [decrease_type], [throw_range], [distribute_type], [base_type_0], [base_var1_0], [base_var2_0], [base_type_1], [base_var1_1], [base_var2_1], [base_type_2], [base_var1_2], [base_var2_2], [base_type_3], [base_var1_3], [base_var2_3], [opt_type_0], [opt_var1_0], [opt_var2_0], [opt_type_1], [opt_var1_1], [opt_var2_1], [opt_type_2], [opt_var1_2], [opt_var2_2], [opt_type_3], [opt_var1_3], [opt_var2_3], [effect_id], [enhance_0_id], [enhance_0_01], [enhance_0_02], [enhance_0_03], [enhance_0_04], [enhance_1_id], [enhance_1_01], [enhance_1_02], [enhance_1_03], [enhance_1_04], [skill_id], [state_id], [state_level], [state_time], [state_type], [cool_time], [cool_time_group], [model_type_dem], [model_type_def], [model_type_asm], [model_type_asf], [model_type_gam], [model_type_gaf], [deco_model_change], [model_00], [model_01], [model_02], [model_03], [model_04], [model_05], [model_06], [model_07], [model_08], [model_09], [model_10], [model_11], [model_12], [model_13], [model_14], [model_15], [model_16], [model_17], [texture_filename], [drop_type], [icon_id], [icon_file_name], [script_text]) VALUES (2012064, 12012064, 22012064, 1, 8, 260, 7, 0, 0, 7, 1, 0, 0, 0, N'1', N'1', N'1', N'1', N'1', N'1', N'1', 150, 0, 0, 0, CAST(0.00 AS Decimal(10, 2)), CAST(30.00 AS Decimal(10, 2)), 125000000, 0, CAST(0.000 AS Numeric(18, 3)), 12, 0, N'1', N'1', N'0', N'0', N'0', N'1', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', 0, 0, CAST(0.00 AS Decimal(10, 2)), N'0', 15, CAST(46.00 AS Decimal(12, 2)), CAST(0.80 AS Decimal(12, 2)), 16, CAST(69.00 AS Decimal(12, 2)), CAST(1.20 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, 15, CAST(1.30 AS Decimal(10, 2)), CAST(1.50 AS Decimal(10, 2)), CAST(1.90 AS Decimal(10, 2)), CAST(2.40 AS Decimal(10, 2)), 16, CAST(2.00 AS Decimal(10, 2)), CAST(2.30 AS Decimal(10, 2)), CAST(2.80 AS Decimal(10, 2)), CAST(3.50 AS Decimal(10, 2)), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, N'dem_mantle_astinwhisper', N'dem_mantle_astinwhisper', N'dem_mantle_astinwhisper', N'dem_mantle_astinwhisper', N'def_mantle_astinwhisper', N'def_mantle_astinwhisper', N'def_mantle_astinwhisper', N'asm_mantle_astinwhisper', N'asm_mantle_astinwhisper', N'asf_mantle_astinwhisper', N'asf_mantle_astinwhisper', N'asf_mantle_astinwhisper', N'gam_mantle_astinwhisper', N'gam_mantle_astinwhisper', N'gam_mantle_astinwhisper', N'gaf_mantle_astinwhisper', N'gaf_mantle_astinwhisper', N'gaf_mantle_astinwhisper', N'0', N'drop_wear_armor', 0, N'icon_mantle_astinwhisper', N'')
INSERT INTO [Arcadia].[dbo].[ItemResource] ([id], [name_id], [tooltip_id], [type], [group], [class], [wear_type], [set_id], [set_part_flag], [rank], [level], [enhance], [socket], [status_flag], [limit_deva], [limit_asura], [limit_gaia], [limit_fighter], [limit_hunter], [limit_magician], [limit_summoner], [use_min_level], [use_max_level], [target_min_level], [target_max_level], [range], [weight], [price], [huntaholic_point], [endurance], [material], [summon_id], [flag_cashitem], [flag_wear], [flag_use], [flag_target_use], [flag_duplicate], [flag_drop], [flag_trade], [flag_sell], [flag_storage], [flag_overweight], [flag_riding], [flag_move], [flag_sit], [flag_enhance], [flag_quest], [flag_raid], [flag_secroute], [flag_eventmap], [flag_huntaholic], [flag_huntaholic_usable_only], [available_period], [decrease_type], [throw_range], [distribute_type], [base_type_0], [base_var1_0], [base_var2_0], [base_type_1], [base_var1_1], [base_var2_1], [base_type_2], [base_var1_2], [base_var2_2], [base_type_3], [base_var1_3], [base_var2_3], [opt_type_0], [opt_var1_0], [opt_var2_0], [opt_type_1], [opt_var1_1], [opt_var2_1], [opt_type_2], [opt_var1_2], [opt_var2_2], [opt_type_3], [opt_var1_3], [opt_var2_3], [effect_id], [enhance_0_id], [enhance_0_01], [enhance_0_02], [enhance_0_03], [enhance_0_04], [enhance_1_id], [enhance_1_01], [enhance_1_02], [enhance_1_03], [enhance_1_04], [skill_id], [state_id], [state_level], [state_time], [state_type], [cool_time], [cool_time_group], [model_type_dem], [model_type_def], [model_type_asm], [model_type_asf], [model_type_gam], [model_type_gaf], [deco_model_change], [model_00], [model_01], [model_02], [model_03], [model_04], [model_05], [model_06], [model_07], [model_08], [model_09], [model_10], [model_11], [model_12], [model_13], [model_14], [model_15], [model_16], [model_17], [texture_filename], [drop_type], [icon_id], [icon_file_name], [script_text]) VALUES (2012063, 12012063, 22012063, 1, 8, 260, 7, 0, 0, 7, 1, 0, 0, 0, N'1', N'1', N'1', N'1', N'1', N'1', N'1', 150, 0, 0, 0, CAST(0.00 AS Decimal(10, 2)), CAST(30.00 AS Decimal(10, 2)), 125000000, 0, CAST(0.000 AS Numeric(18, 3)), 12, 0, N'1', N'1', N'0', N'0', N'0', N'1', N'0', N'1', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', 0, 0, CAST(0.00 AS Decimal(10, 2)), N'0', 15, CAST(46.00 AS Decimal(12, 2)), CAST(0.80 AS Decimal(12, 2)), 16, CAST(69.00 AS Decimal(12, 2)), CAST(1.20 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, 15, CAST(1.30 AS Decimal(10, 2)), CAST(1.50 AS Decimal(10, 2)), CAST(1.90 AS Decimal(10, 2)), CAST(2.40 AS Decimal(10, 2)), 16, CAST(2.00 AS Decimal(10, 2)), CAST(2.30 AS Decimal(10, 2)), CAST(2.80 AS Decimal(10, 2)), CAST(3.50 AS Decimal(10, 2)), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, N'dem_mantle_jericotears', N'dem_mantle_jericotears', N'dem_mantle_jericotears', N'def_mantle_jericotears', N'def_mantle_jericotears', N'def_mantle_jericotears', N'asm_mantle_jericotears', N'asm_mantle_jericotears', N'asm_mantle_jericotears', N'asf_mantle_jericotears', N'asf_mantle_jericotears', N'asf_mantle_jericotears', N'gam_mantle_jericotears', N'gam_mantle_jericotears', N'gam_mantle_jericotears', N'gaf_mantle_jericotears', N'gaf_mantle_jericotears', N'gaf_mantle_jericotears', N'0', N'drop_wear_armor', 0, N'icon_mantle_jericotears', N'')

And the ID´s

 Spoiler

2012064 Obsidikar Spine Cloak
2012063 Cloak of Holy Serenity

Get a Epic 7.1 (PH) Client

 Spoiler

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

Gold/Lak Rate

* = times

Gold

 Spoiler

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_min] = [gold_min] * 2
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_max] = [gold_max] * 2
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_min_2] = [gold_min_2] * 2
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_max_2] = [gold_max_2] * 2
GO

Lak

 Spoiler

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [chaos_min] = [chaos_min] * 2
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [chaos_max] = [chaos_max] * 2
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [chaos_min_2] = [chaos_min_2] * 2
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [chaos_max_2] = [chaos_max_2] * 2
GO

[egurgle]

nice pot,, but you missed my best scripts
like DropRules + EventManager, Necklaces Upgrades, taming fixes

[Raskim2000]

Originally Posted by egurgle

nice pot,, but you missed my best scripts
like DropRules + EventManager, Necklaces Upgrades, taming fixes

The Problem is, to the Time where i started this Thread, the Arcadia DEV Form were Allready down for me.

If you want, you can message me the Scripts (Taming fix not need, done this on my own )

If you want so, i will add them,

[King of dubai]

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



how i know the belt ID + can u show me how to update it PLZ

[Raskim2000]

Almost finished Ninja, Viking and Swimsuit Deco.


Now working on Mask`s and maybe the Rank 2- Rank 6 Cloak`s.