[DiscordArchive] they're the bit IDs that make up the bitmask value I guess ?
[DiscordArchive] they're the bit IDs that make up the bitmask value I guess ?
Original source
The spell editor determines which spells will be effected by a given spell effect by running the following query:
```sql
SELECT id, SpellName0 FROM spell WHERE
SpellFamilyName = {0} AND
(
(SpellFamilyFlags & {1}) > 0 OR
(SpellFamilyFlags1 & {2}) > 0 OR
(SpellFamilyFlags2 & {3}) > 0
);
```
Where {0}..{3} = familyName, classmask1, classmask2, classmask3
rektbyfaith
06-30-2023, 08:00 PM #21Archived author: stoneharry • Posted: 2023-06-30T20:00:12.804000+00:00
Original source
The spell editor determines which spells will be effected by a given spell effect by running the following query:
```sql
SELECT id, SpellName0 FROM spell WHERE
SpellFamilyName = {0} AND
(
(SpellFamilyFlags & {1}) > 0 OR
(SpellFamilyFlags1 & {2}) > 0 OR
(SpellFamilyFlags2 & {3}) > 0
);
```
Where {0}..{3} = familyName, classmask1, classmask2, classmask3
Original source
alright, and because its a bitmask if you add spellfamilyflag A + spellfanilyflag B and input the result you get both groupa affected
rektbyfaith
06-30-2023, 08:00 PM #22Archived author: flyingfrog • Posted: 2023-06-30T20:00:14.782000+00:00
Original source
alright, and because its a bitmask if you add spellfamilyflag A + spellfanilyflag B and input the result you get both groupa affected
Original source
you don't add family A and B they're handled separately
rektbyfaith
06-30-2023, 08:01 PM #23Archived author: Titi • Posted: 2023-06-30T20:01:00.248000+00:00
Original source
you don't add family A and B they're handled separately
Original source
and vanilla only has A client side
rektbyfaith
06-30-2023, 08:01 PM #24Archived author: Titi • Posted: 2023-06-30T20:01:06.586000+00:00
Original source
and vanilla only has A client side
Original source
this confuses me then, might be non applicable or out of date
rektbyfaith
06-30-2023, 08:03 PM #25Archived author: flyingfrog • Posted: 2023-06-30T20:03:42.446000+00:00
Original source
this confuses me then, might be non applicable or out of date
Original source
Say for example we would want to change spell 11242 to not affect Arcane Explosion but affect Fireball instead we would change the value 4096 to 1073741825.
To change this value in the database you need a decimal to hexadecimal converter.
In our update query we would write the hexadecimal value of 1073741825, which is 0x0000000040000001.
If we want spell 11242 to affect both Arcane Explosion and Fireball we need only to add 4096 to 1073741825: 1073745921 and put the hexadecimal value of this in the database.
rektbyfaith
06-30-2023, 08:03 PM #26Archived author: flyingfrog • Posted: 2023-06-30T20:03:46.416000+00:00
Original source
Say for example we would want to change spell 11242 to not affect Arcane Explosion but affect Fireball instead we would change the value 4096 to 1073741825.
To change this value in the database you need a decimal to hexadecimal converter.
In our update query we would write the hexadecimal value of 1073741825, which is 0x0000000040000001.
If we want spell 11242 to affect both Arcane Explosion and Fireball we need only to add 4096 to 1073741825: 1073745921 and put the hexadecimal value of this in the database.
Original source
https://www.getmangos.eu/wiki/referencei...ect-r1111/
[Embed: spell_affect]
MaNGOS Zero,mangos0,spell_affect
https://www.getmangos.eu/wiki/referencei...ect-r1111/
rektbyfaith
06-30-2023, 08:03 PM #27Archived author: flyingfrog • Posted: 2023-06-30T20:03:55.567000+00:00
Original source
https://www.getmangos.eu/wiki/referencei...ect-r1111/
[Embed: spell_affect]
MaNGOS Zero,mangos0,spell_affect
https://www.getmangos.eu/wiki/referencei...ect-r1111/
Original source
the only reference to the question I has i found in the web
rektbyfaith
06-30-2023, 08:04 PM #28Archived author: flyingfrog • Posted: 2023-06-30T20:04:07.830000+00:00
Original source
the only reference to the question I has i found in the web
Original source
that's why I was talking about addition
rektbyfaith
06-30-2023, 08:04 PM #29Archived author: flyingfrog • Posted: 2023-06-30T20:04:25.306000+00:00
Original source
that's why I was talking about addition
Original source
fireball is 1 not 1073741825
rektbyfaith
06-30-2023, 08:06 PM #30Archived author: Titi • Posted: 2023-06-30T20:06:14.794000+00:00
Original source
fireball is 1 not 1073741825
1 Guest(s)
1 Guest(s)