TS abilities that use power/not enough power when cast
Posted: Thu Aug 24, 2017 6:21 am
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
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
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;i would update on EMU but it would be easier for JAb or someone to just runt he sql vs changing 30 abilities manually