-
-
Save Daejiv/90959981f08a6a60272f to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql> SELECT Id, SpellNameDE, SpellNameEN, AttributesEx3 FROM spell WHERE (AttributesEx3 & 0x02000000) != 0; | |
+-------+---------------------------------------+----------------------------------+---------------+ | |
| Id | SpellNameDE | SpellNameEN | AttributesEx3 | | |
+-------+---------------------------------------+----------------------------------+---------------+ | |
| 5857 | Höllenfeuereffekt | Hellfire Effect | 33554432 | | |
| 10580 | Totem des glühenden Magmas | Magma Totem | 33554496 | | |
| 10581 | Totem des glühenden Magmas | Magma Totem | 33554496 | | |
| 11681 | Höllenfeuereffekt | Hellfire Effect | 33554432 | | |
| 11682 | Höllenfeuereffekt | Hellfire Effect | 33554432 | | |
| 15290 | Vampirumarmung | Vampiric Embrace | 33619968 | | |
| 20168 | Siegel der Weisheit | Seal of Wisdom | 33554432 | | |
| 20267 | Richturteil des Lichts | Judgement of Light | 1107296256 | | |
| 20268 | Richturteil der Weisheit | Judgement of Wisdom | 1107296256 | | |
| 25550 | Totem des glühenden Magmas | Magma Totem | 33554496 | | |
| 27214 | Höllenfeuereffekt | Hellfire Effect | 33554432 | | |
| 29107 | Unterbrechender Schrei | Disrupting Shout | 33554432 | | |
| 29956 | Arkane Geschosse | Arcane Missiles | 33554944 | | |
| 30523 | Netherbrand | Nether Burn | 33554688 | | |
| 31786 | Einklang des Geistes | Spiritual Attunement | 33554432 | | |
| 32448 | Netheraura | Nether Aura | 33554432 | | |
| 34299 | Verbesserter Rudelführer | Improved Leader of the Pack | 33554432 | | |
| 34394 | Lykulraserei | Stinger Frenzy | 33554432 | | |
| 34919 | Vampirberührung | Vampiric Touch | 33554432 | | |
| 35925 | Energiefluss | Energy Flux | 33554432 | | |
| 36415 | Arkanstarren | Arcane Glare | 33554432 | | |
| 36416 | Schattenstarren | Shadow Glare | 33554432 | | |
| 36417 | Feuriges Starren | Fiery Glare | 33554432 | | |
| 36580 | Warpsturm | Warp Storm | 33554432 | | |
| 37621 | Gedankenschinden | Mind Flay | 33554432 | | |
| 38395 | Essenz entziehen | Siphon Essence | 33554432 | | |
| 38988 | Feuriges Starren | Fiery Glare | 33554432 | | |
| 38989 | Arkanstarren | Arcane Glare | 33554432 | | |
| 38990 | Schattenstarren | Shadow Glare | 33554432 | | |
| 39373 | Schattenheilung | Shadowmend | 33554432 | | |
| 39609 | Totem der Manaflut | Mana Tide Totem | 33554432 | | |
| 42227 | Feuerregen | Rain of Fire | 1107296256 | | |
| 42565 | Flammenfurche | Flame Trench | 33619968 | | |
| 45024 | Russells Testhöllenfeuereffekt!! | Russell's Test Hellfire Effect!! | 33554432 | | |
| 46008 | Negative Energie | Negative Energy | 33554688 | | |
| 46285 | Negative Energie | Negative Energy | 33554688 | | |
| 46289 | Negative Energie | Negative Energy | 33554688 | | |
| 47822 | Höllenfeuereffekt | Hellfire Effect | 33554432 | | |
| 48379 | Nightmare Effect | Nightmare Effect | 33554432 | | |
| 49766 | Dispersion | Dispersion | 33554432 | | |
| 50475 | Blutpräsenz | Blood Presence | 33554432 | | |
| 50578 | Eissplitter | Ice Shard | 33554432 | | |
| 50590 | Feuerbrand | Immolation | 33554432 | | |
| 50846 | Blutspiegel | Blood Mirror Damage | 33554432 | | |
| 50988 | Böser Blick des Tribunals | Glare of the Tribunal | 33554688 | | |
| 51125 | Sengender Blick | Searing Gaze | 33554432 | | |
| 51437 | Schwelende Knochen | Smoldering Bones | 33554432 | | |
| 51438 | Schwelende Knochen | Smoldering Bones | 33554432 | | |
| 51743 | Überladen | Overload | 33554432 | | |
| 52032 | Totem der Manaquelle | Mana Spring Totem | 33554432 | | |
| 52042 | Totem des heilenden Flusses | Healing Stream Totem | 33554432 | | |
| 52105 | Brennender Schlag | Burning Blow | 33554432 | | |
| 52212 | Tod und Verfall | Death and Decay | 1107296256 | | |
| 52700 | Blitzgeladen | Lightning Charged | 33554432 | | |
| 52763 | Bogenschweißung | Arc Weld | 570687488 | | |
| 52942 | Pulsierende Schockwelle | Pulsing Shockwave | 570425344 | | |
| 53168 | Blutaura | Blood Aura | 33554432 | | |
| 53468 | Egelschwarm | Leeching Swarm | 33554432 | | |
| 54171 | Göttlicher Sturm | Divine Storm | 33619968 | | |
| 54172 | Göttlicher Sturm | Divine Storm | 33619968 | | |
| 54180 | Richturteil des Weisen | Judgements of the Wise | 33619968 | | |
| 54344 | Schattenblitzsalve | Shadow Bolt Volley | 33554432 | | |
| 54368 | Krankheitswolke | Disease Cloud | 33554432 | | |
| 54755 | Glyphe 'Verjüngung' | Glyph of Rejuvenation | 33554432 | | |
| 54920 | Schock | Shock | 33554432 | | |
| 55543 | Unterbrechender Schrei | Disrupting Shout | 33554432 | | |
| 56654 | Rasche Erholung | Rapid Recuperation | 33554432 | | |
| 56657 | Lodernde Flammen | Seething Flames | 33554432 | | |
| 57669 | Erfrischung | Replenishment | 33554432 | | |
| 58732 | Totem des glühenden Magmas | Magma Totem | 33554496 | | |
| 58735 | Totem des glühenden Magmas | Magma Totem | 33554496 | | |
| 58882 | Rasche Erholung | Rapid Recuperation | 33554432 | | |
| 59431 | Egelschwarm | Leeching Swarm | 33554432 | | |
| 59747 | Zuramat Add 2 | Zuramat Add 2 | 301989888 | | |
| 59837 | Pulsierende Schockwelle | Pulsing Shockwave | 570425344 | | |
| 59866 | Sengender Blick | Searing Gaze | 33554432 | | |
| 59870 | Böser Blick des Tribunals | Glare of the Tribunal | 33554688 | | |
| 60889 | Verbesserter Rudelführer | Improved Leader of the Pack | 33554432 | | |
| 61782 | Unendliche Erfrischung + Weisheit | Infinite Replenishment + Wisdom | 33554432 | | |
| 61905 | Totem des glühenden Magmas Testeffekt| Magma Totem Test Effect | 33554496 | | |
| 62188 | Beißende Kälte | Biting Cold | 570425344 | | |
| 62775 | Betäubender Koller | Tympanic Tantrum | 33554432 | | |
| 63023 | Sengendes Licht | Searing Light | 33620480 | | |
| 63387 | Rapide Wucht | Rapid Burst | 33554432 | | |
| 63420 | Wahre Dunkelheit | Profound Darkness | 33685760 | | |
| 63525 | Hochspannung | High Voltage | 33554432 | | |
| 63526 | Hochspannung | High Voltage | 33554432 | | |
| 63720 | Steingebrüll | Stone Shout | 33554432 | | |
| 63847 | Flammendüsen | Flame Vents | 33554432 | | |
| 64004 | Steingebrüll | Stone Shout | 33554432 | | |
| 64019 | Rapide Wucht | Rapid Burst | 33554432 | | |
| 64348 | Handpuls | Hand Pulse | 33554432 | | |
| 64352 | Handpuls | Hand Pulse | 33554432 | | |
| 64378 | Sternenregen | Starfall | 33554688 | | |
| 64531 | Rapide Wucht | Rapid Burst | 33554432 | | |
| 64532 | Rapide Wucht | Rapid Burst | 33554432 | | |
| 64536 | Handpuls | Hand Pulse | 33554432 | | |
| 64537 | Handpuls | Hand Pulse | 33554432 | | |
| 64544 | Gefrorene Schläge | Frozen Blows | 33554688 | | |
| 64545 | Gefrorene Schläge | Frozen Blows | 33554688 | | |
| 64594 | Sternenregen | Starfall | 33554688 | | |
| 64801 | Verjüngung | Rejuvenation | 33554432 | | |
| 65120 | Sengendes Licht | Searing Light | 33620480 | | |
| 65722 | Schlackentopf | Slag Pot | 33554432 | | |
| 65723 | Schlackentopf | Slag Pot | 570425344 | | |
| 65778 | Flammenfurche | Flame Trench | 33619968 | | |
| 65817 | Höllenfeuereffekt | Hellfire Effect | 33554432 | | |
| 66240 | Egelschwarm | Leeching Swarm | 301989888 | | |
| 66485 | Feuerbrand | Immolation | 33554432 | | |
| 66496 | Teufelsinferno | Fel Inferno | 33554432 | | |
| 68142 | Höllenfeuereffekt | Hellfire Effect | 33554432 | | |
| 68143 | Höllenfeuereffekt | Hellfire Effect | 33554432 | | |
| 68144 | Höllenfeuereffekt | Hellfire Effect | 33554432 | | |
| 68716 | Teufelsinferno | Fel Inferno | 33554432 | | |
| 68717 | Teufelsinferno | Fel Inferno | 33554432 | | |
| 68718 | Teufelsinferno | Fel Inferno | 33554432 | | |
| 68781 | Gefrorenes Gesicht | Frozen Visage | 33685824 | | |
| 68786 | Permafrost | Permafrost | 33554432 | | |
| 69146 | Eisflamme | Coldflame | 33554432 | | |
| 69585 | Höllenfeuereffekt | Hellfire Effect | 33554432 | | |
| 70284 | Höllenfeuereffekt | Hellfire Effect | 33554432 | | |
| 70336 | Permafrost | Permafrost | 33554432 | | |
| 70677 | Vampirmacht | Vampiric Might | 33554432 | | |
| 70823 | Eisflamme | Coldflame | 33554432 | | |
| 70824 | Eisflamme | Coldflame | 33554432 | | |
| 70825 | Eisflamme | Coldflame | 33554432 | | |
| 70872 | Essenz der Blutkönigin | Essence of the Blood Queen | 33554432 | | |
| 71341 | Pakt der Sinistren | Pact of the Darkfallen | 570884864 | | |
| 71447 | Blutgeschosseinschlag | Bloodbolt Splash | 570687744 | | |
| 71481 | Blutgeschosseinschlag | Bloodbolt Splash | 570687744 | | |
| 71482 | Blutgeschosseinschlag | Bloodbolt Splash | 570687744 | | |
| 71483 | Blutgeschosseinschlag | Bloodbolt Splash | 570687744 | | |
| 71822 | Schattenresonanz | Shadow Resonance | 33554688 | | |
+-------+---------------------------------------+----------------------------------+---------------+ | |
133 rows in set |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment