TS abilities that use power/not enough power when cast

Post in this forum if you found any bugs with game content.

Moderator: Team Members

Forum rules
READ THE STICKY ON PROPER BUG SUBMISSION FORMAT BEFORE POSTING.
Post Reply
User avatar
Ememjr
Team Member
Posts: 975
Joined: Wed Mar 15, 2017 9:41 am
EQ2Emu Server: Perseverance

TS abilities that use power/not enough power when cast

Post by Ememjr » 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

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

User avatar
Ememjr
Team Member
Posts: 975
Joined: Wed Mar 15, 2017 9:41 am
EQ2Emu Server: Perseverance

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

Post by Ememjr » Fri Mar 08, 2019 2:58 pm

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.

User avatar
Cynnar
Project Leader
Posts: 738
Joined: Sat Sep 27, 2014 1:22 am
EQ2Emu Server: Eq2emulator
Characters: Vlash
Veinlash
Taragak
Cynnar

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

Post by Cynnar » Fri Mar 08, 2019 8:22 pm

Got this added in.
[ 01000011 01111001 01101110 01101110 01100001 01110010 ]

Follow on:
Twitter Facebook

Contact me:
PM Discord chat email

Hardware: the parts of a computer that can be kicked

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest