[Mini Release] Warrior Stance Fix

[R33C3]

Ok, couldnt find one a couple of weeks ago and had to make my own so, he you go..

(Executing this script will give every newly created warrior all stances)

insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('1','71');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('2','71');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('3','71');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('4','71');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('5','71');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('6','71');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('7','71');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('8','71');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('1','2458');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('2','2458');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('3','2458');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('4','2458');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('5','2458');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('6','2458');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('7','2458');
insert into `playercreateinfo_spells` (`indexid`, `spellid`) values('8','2458');

Enjoy

PS. I'll be posting a lot more fixes/releases shortly..

[ardicsoul]

ty works:)

[R33C3]

No problem :)

[tony12]

Wow I love you.
Now can you fix rouges :/!

[lawzon]

Thanks using it in my server

[booble69]

Thanks, it helped me and my friend in his server.

[hawl]

what do i put this into?

someone please help?

[slade1000]

playercreateinfo_spells you put it in that table in your world database

[hawl]

sorry, this is my first day using this, my logon folder doesnt have a playercreateinfo_spells table... how do i make or get one?

[QQrofl]

It is not in "a" logon folder, it is in your "Database" do you have navicat installed?

[blacksheep25]

is their a mage fix yet? sometimes when you cast fireball etc it gets stuck.

[Gnome]

Lol this is a fix that makes you start with a Spell, blacksheep25 and not a Spell Fix.

[hawl]

i dont have navicat but i do have HeidiSQL, will that work too? again sorry ><

[Nexus16]

Yes, connect to your database, go into "world" then click "import>LoadSQLFile" and select this wherever you saved it, then click F9 to import, you know how to connect to your databse, etc? Yeah?

[hawl]

uhh i might but could you tell me just so im sure? thank you very much for helping

wait by connect to my database do u just mean like getting to the list of everything? cause i can do that but i cant seem to find "world" whats that under?

[Pigge]

The world database doesn't have to be called 'World' it could be called Blizzlike, ArcEmu, Ascent or funserver, anything really. It's also the folder where you insert new items and creatures. Just browse through the DBs for a while and you should find it. It should contain tables like 'Items', 'Creature_<x>' and gameobject_<x>. After you find it, make sure it's selected and then run the query. Restart your server and it should work. :)

Good luck

[Double]

i've seen this fix in the arcemu sql_updates