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.
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?
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. ._.
Quote:
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)
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 ^^
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 ^^
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.
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.
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.
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
-- 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
--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
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)
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)
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:
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:
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
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.
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
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
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)
Flyff Collecting bot (need help) 08/30/2011 - AutoIt - 1 Replies hi!
im making a collecting bot using autoit.
all it needs to do is click some stuff then wait and repeat itself.
but im having a problem....
when i use "mousemove" or "mouseclick" it doesnt work while flyff is up.
Collecting Crafting Bot 09/14/2010 - Archlord - 5 Replies Hi
Please Someone experienced make a working bot for collecting and crafting
Maybe drop pick and wepon change will be good too but not very important to me
Im very sad about Avati is stoped working on a new one or he will just keep it for himself
IDK what email or warning he recived... I can not imagine how can it be so serious he need stop what hes doing.
But we need to see forward and make a new bot for us.
![[Collecting]Usefull SQL-Script`s](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/collecting-usefull-sql-script-s_ltr.gif){kind=small}
+ If these smaller versions of dura are available on cloaks could we not use a similar method to jerry rig dura equips?
