Instant 80 - All spells and weapon skills on start.

[Portals]

Credits: Breezicaf, Parranoia, Me.

Script: http://pastebin.com/cpvRkyr4

 

[Hyperion]

Thanks for sharing

 

[Portals]

Thanks for sharing

No problem hope it comes in handy.

 

[Tommy]

Great share!

However, the DELETE FROM could be simplified like this:

DELETE FROM `playercreateinfo_spell` WHERE note IN ('Hunter Spell', 'Priest Spell', 'Warlock Spell', 'Deathknight Spell', 'Mage Spell', 'Druid Spell', 'Paladin Spell', 
'Warrior Spell', 'Rogue Spell', 'Shaman Spell, 'Mage portal - Horde', 'Mage portal - Alliance');

Basic future advice if you guys ever come across anything like that again. Other than that, good release.

 

[Portals]

Great share!

However, the DELETE FROM could be simplified like this:

DELETE FROM `playercreateinfo_spell` WHERE note IN ('Hunter Spell', 'Priest Spell', 'Warlock Spell', 'Deathknight Spell', 'Mage Spell', 'Druid Spell', 'Paladin Spell', 
'Warrior Spell', 'Rogue Spell', 'Shaman Spell, 'Mage portal - Horde', 'Mage portal - Alliance');

Basic future advice if you guys ever come across anything like that again. Other than that, good release.

Thanks for the advice, share*.

 

[AlexeWarr]

Nice share

 

[Parranoia]

TrinityCore recently changed how this table works and you are able to use bitmasks so it can be greatly simplified to this: http://pastebin.com/p9RT5UdF

 

[MilboW]

Thanks for sharing

 

[faiver]

good release thx