Page 1 of 1

TS abilities that use power/not enough power when cast

Posted: Thu Aug 24, 2017 6:21 am
by Ememjr
in TS abilities that use power when casting are set to a specific power value in the power_rew field of the spell_tiers table
so when you cast an ability while tradeskilling it tries to use 175 power each time, and most low level characters wanting to tradeskill so not even have 175 power
the way is works on live when you use a TS ability that uses power it is a % of power used, through trial and error % amount is 5 6 or 7
based on what was import for abilites the values in the power_req can be diveided by 25 to get the correct amount of the %

You can run the following sql to fix the DB for proper amounts

Code: Select all

UPDATE spell_tiers SET power_req_percent = power_req /25 WHERE spell_id >=9000 AND spell_id < 9100;
UPDATE spell_tiers SET power_req = 0 WHERE spell_id >=9000 AND spell_id < 9100;
This has been update on Perseverance,

i would update on EMU but it would be easier for JAb or someone to just runt he sql vs changing 30 abilities manually

Re: TS abilities that use power/not enough power when cast

Posted: Fri Mar 08, 2019 2:58 pm
by Ememjr
this is still an isuue on EMU DB on TS abilites that use power
the power requirements need to be changed to a percentage not a flat value
i do relize census show a flat value but from a post i saw awhile back some of the numbers are based on a character of a higher level when exported to census
for example on live my level 5 toon only has 120 power
agitate uses 8 power about 7%

i level to 6 and power is now 136
agitate uses 9 power now

found an article about it
Because your power pool is based on your Adventure level and your equipment, and because you can be any level Adventurer and any level Artisan at the same time, the Arts which use power use a percentage of your power pool rather than a fixed number. To demonstrate this, put on all your best gear and check how much power that Art uses. Now take it off and examine the Art again. At higher levels you can really see the difference. The power-using Arts at different Tiers will use varying percentages of your power pool.
Nonetheless, it's still a percentage.

Re: TS abilities that use power/not enough power when cast

Posted: Fri Mar 08, 2019 8:22 pm
by Cynnar
Got this added in.