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.Quote:
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:
[Collecting]Usefull SQL-Script`s
11/07/2011 12:45
Raskim2000#31
11/07/2011 12:53
ismokedrow#32
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 :D + 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
-EDIT-
All three work:
-First = Noxious Helmet
-Second = Helmet with Poison
-Third = Rapid Bikini Deco
11/07/2011 12:56
Raskim2000#33
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. ._.Quote:
rask, smoke any of you 2 wana test those id to see if they show
3630124...........3630125.............602110301
[Only registered and activated users can see links. Click Here To Register...]
No, you know smoke, the current GS dont support Dura Handle, so the only way to delte them is the timed method. :(Quote:
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
11/07/2011 13:01
ismokedrow#34
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 ^^
11/07/2011 13:08
ismokedrow#35
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 ^^
11/07/2011 13:09
Raskim2000#36
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.Quote:
11/07/2011 13:13
ismokedrow#37
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.
11/07/2011 13:15
Raskim2000#38
Like i said, we allready have the IDīs, but i have no idea how to make the buffs appear and disappear.Quote:
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 :eek:
Code:
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>
Ehm, the Deco i released,give the right Stat`s. :DQuote:
That`s the only Reason why i needed so long for this "little" Script. :D
11/07/2011 13:31
Raskim2000#39
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
They a sorted in 4 Groups :
<beeing attacked> passiv statīs
<when attacking> passiv stat`s
<beeing attacked> with buff
<when attacking> with buff
11/07/2011 15:05
qaaah#40
Thx man you are the best !
11/07/2011 15:37
gavsta#41
Quote:
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
Set Basic price for Items
Code:use arcadia update dbo.ItemResource set price = 3000000 where id = Here_Item_ID
Search for items
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
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
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
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)
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
Entrys for the Epic 7 Pieces (With Help of Speedy-nl)
Just download the Rar-package anduse the Scripts. 1 is LUA, 1 for SQL.
[Only registered and activated users can see links. Click Here To Register...]
And the ID`s of the Pieces
Code: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)
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!)
[Only registered and activated users can see links. Click Here To Register...]
Code:2012062 Gilded Wings
Ice-Maiden Potion Fix
just download the SQL File , double Click on it and hit F5... [Only registered and activated users can see links. Click Here To Register...]
Epic 7.1 KTS Special Effect Deco Partial Release (im not finished, there are many more Deco items, wich has to be configured)
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!
[Only registered and activated users can see links. Click Here To Register...]
And the Codes for this Special Deco
Bear Deco
Code: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
Code: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:
Some Scripts to let Empty DTīs drop, give Abomination Stat`s and more
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:
Code: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:
Code: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:
Code:UPDATE Arcadia.dbo.SkillResource SET delay_cast = 10.00, delay_cooltime = 30.00 WHERE id = 4003
Epic 7.1 Client Quest Fix
Download the Script [Only registered and activated users can see links. Click Here To Register...] , open SQL Server, double click on the Script and Hit F5
Items: Item ID and Item Name
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
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
And for NPCs: NPC ID and NPC Title in Ascending order by NPC's title.
Code: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
Set Enchancement-Rate
Code: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
Set R7 Chips to R8 Chips (Chips will effect all Monster up to Lv 190)
Code: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
Summoning Scrolls for Epic 7.1 Client (Ne0, JW988, Speedy-nl )
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:
Code: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
Code: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 [Only registered and activated users can see links. Click Here To Register...]
Obisdikar Spine Cloak and Cloak of Holy Serenity (Speedy-Nl, ismokedrow) (The Cloaks will only be shown on a modded 7.1 PH Client!)
Just copy the Script, add it to SQL Server and Hit F5
Code: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
Code:2012064 Obsidikar Spine Cloak 2012063 Cloak of Holy Serenity
Get a Epic 7.1 (PH) Client
[Only registered and activated users can see links. Click Here To Register...]
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
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
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
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
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
11/07/2011 16:54
egurgle#42
nice pot,, but you missed my best scripts ;)
like DropRules + EventManager, Necklaces Upgrades, taming fixes
like DropRules + EventManager, Necklaces Upgrades, taming fixes
11/07/2011 19:38
Raskim2000#43
The Problem is, to the Time where i started this Thread, the Arcadia DEV Form were Allready down for me.Quote:
like DropRules + EventManager, Necklaces Upgrades, taming fixes
If you want, you can message me the Scripts (Taming fix not need, done this on my own :D)
If you want so, i will add them, ;)
11/07/2011 21:07
King of dubai#44
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
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
11/08/2011 00:19
Raskim2000#45
Almost finished Ninja, Viking and Swimsuit Deco.
Now working on Mask`s and maybe the Rank 2- Rank 6 Cloak`s.
Now working on Mask`s and maybe the Rank 2- Rank 6 Cloak`s.