All weapon problem! Help!

[fstenbergp]

Any1 know how to do, so all can use all weapons and all can have dual wield? Help please! :-D

[fstenbergp]

oh cmon help

[AfterMidnight]

First of all you obey the rules on MMOwned.
Then you proceed by going to http://www.wowhead.com/spells=6 and teach yourself every spell listed there.
Finally, teach yourself Titan's Grip - Spell - World of Warcraft so you can dualwield all 2H but pole-arms.

And that's pretty much it.

P.S.: If you MUST dualwield polearms, you can only do so by forcing your characters to wield them upon creation.

[Valmere]

so all can use all weapons and all can have dual wield

He wants all players on his realm to be able to do wield all weapons in addition do dual wielding.

For this, you'll have to execute an SQL query into your database that modifies the playercreateinfo_skills table and adds all weapon skills to all classes when someone creates a new toon.

[fstenbergp]

got any link to a download or a copypaste?

[Pedregon]

Or you could just add dual wielding to all the class trainers and remove the level and class restrictions, as well as removing the class/race restrictions to learning all weapons, etc. pretty easy, just find the dual wielding spell # and add it to all class trainers that you'll be using as well as weapon skill #'s. :] it all can be in the database

[fstenbergp]

I would really like a SQL :s.

[Dynashock]

WARNING: Backup your playercreateinfo before you run these queries!

REPLACE INTO playercreateinfo_spells
SELECT `Index`, 672 from playercreateinfo;

This query should make all newly created characters start out with the dual wield skill. (as 672 is the spell id, if I recall correctly)

-- WARRIOR (1) --
REPLACE INTO playercreateinfo_skills
SELECT `index`, 45, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 226, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 173, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 473, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 46, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 44, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 54, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 43, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 229, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 136, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 176, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 172, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 160, 400, 400 FROM playercreateinfo WHERE class = 1;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 55, 400, 400 FROM playercreateinfo WHERE class = 1;

-- PALADIN (2) --
REPLACE INTO playercreateinfo_skills
SELECT `index`, 44, 400, 400 FROM playercreateinfo WHERE class = 2;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 54, 400, 400 FROM playercreateinfo WHERE class = 2;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 43, 400, 400 FROM playercreateinfo WHERE class = 2;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 229, 400, 400 FROM playercreateinfo WHERE class = 2;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 172, 400, 400 FROM playercreateinfo WHERE class = 2;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 160, 400, 400 FROM playercreateinfo WHERE class = 2;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 55, 400, 400 FROM playercreateinfo WHERE class = 2;

-- HUNTER (3) --
REPLACE INTO playercreateinfo_skills
SELECT `index`, 45, 400, 400 FROM playercreateinfo WHERE class = 3;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 226, 400, 400 FROM playercreateinfo WHERE class = 3;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 173, 400, 400 FROM playercreateinfo WHERE class = 3;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 473, 400, 400 FROM playercreateinfo WHERE class = 3;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 46, 400, 400 FROM playercreateinfo WHERE class = 3;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 44, 400, 400 FROM playercreateinfo WHERE class = 3;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 43, 400, 400 FROM playercreateinfo WHERE class = 3;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 229, 400, 400 FROM playercreateinfo WHERE class = 3;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 136, 400, 400 FROM playercreateinfo WHERE class = 3;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 176, 400, 400 FROM playercreateinfo WHERE class = 3;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 172, 400, 400 FROM playercreateinfo WHERE class = 3;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 55, 400, 400 FROM playercreateinfo WHERE class = 3;

-- ROGUE (4) --
REPLACE INTO playercreateinfo_skills
SELECT `index`, 45, 400, 400 FROM playercreateinfo WHERE class = 4;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 226, 400, 400 FROM playercreateinfo WHERE class = 4;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 173, 400, 400 FROM playercreateinfo WHERE class = 4;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 473, 400, 400 FROM playercreateinfo WHERE class = 4;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 46, 400, 400 FROM playercreateinfo WHERE class = 4;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 44, 400, 400 FROM playercreateinfo WHERE class = 4;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 54, 400, 400 FROM playercreateinfo WHERE class = 4;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 43, 400, 400 FROM playercreateinfo WHERE class = 4;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 176, 400, 400 FROM playercreateinfo WHERE class = 4;

-- PRIEST (5) --
REPLACE INTO playercreateinfo_skills
SELECT `index`, 173, 400, 400 FROM playercreateinfo WHERE class = 5;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 54, 400, 400 FROM playercreateinfo WHERE class = 5;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 136, 400, 400 FROM playercreateinfo WHERE class = 5;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 228, 400, 400 FROM playercreateinfo WHERE class = 5;

-- DEATH KNIGHT (6) -- UNUSED
REPLACE INTO playercreateinfo_skills
SELECT `index`, 44, 400, 400 FROM playercreateinfo WHERE class = 6;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 54, 400, 400 FROM playercreateinfo WHERE class = 6;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 43, 400, 400 FROM playercreateinfo WHERE class = 6;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 229, 400, 400 FROM playercreateinfo WHERE class = 6;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 172, 400, 400 FROM playercreateinfo WHERE class = 6;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 160, 400, 400 FROM playercreateinfo WHERE class = 6;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 55, 400, 400 FROM playercreateinfo WHERE class = 6;

-- SHAMAN (7) --
REPLACE INTO playercreateinfo_skills
SELECT `index`, 173, 400, 400 FROM playercreateinfo WHERE class = 7;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 473, 400, 400 FROM playercreateinfo WHERE class = 7;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 44, 400, 400 FROM playercreateinfo WHERE class = 7;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 54, 400, 400 FROM playercreateinfo WHERE class = 7;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 136, 400, 400 FROM playercreateinfo WHERE class = 7;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 172, 400, 400 FROM playercreateinfo WHERE class = 7;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 160, 400, 400 FROM playercreateinfo WHERE class = 7;

-- MAGE (8) --
REPLACE INTO playercreateinfo_skills
SELECT `index`, 173, 400, 400 FROM playercreateinfo WHERE class = 8;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 43, 400, 400 FROM playercreateinfo WHERE class = 8;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 136, 400, 400 FROM playercreateinfo WHERE class = 8;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 228, 400, 400 FROM playercreateinfo WHERE class = 8;

-- WARLOCK (9) --
REPLACE INTO playercreateinfo_skills
SELECT `index`, 173, 400, 400 FROM playercreateinfo WHERE class = 9;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 43, 400, 400 FROM playercreateinfo WHERE class = 9;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 136, 400, 400 FROM playercreateinfo WHERE class = 9;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 228, 400, 400 FROM playercreateinfo WHERE class = 9;

-- DRUID (11) --
REPLACE INTO playercreateinfo_skills
SELECT `index`, 173, 400, 400 FROM playercreateinfo WHERE class = 11;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 473, 400, 400 FROM playercreateinfo WHERE class = 11;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 54, 400, 400 FROM playercreateinfo WHERE class = 11;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 229, 400, 400 FROM playercreateinfo WHERE class = 11;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 136, 400, 400 FROM playercreateinfo WHERE class = 11;
REPLACE INTO playercreateinfo_skills
SELECT `index`, 160, 400, 400 FROM playercreateinfo WHERE class = 11;

Should take care of all of the weapon skills for newly created characters.

[fstenbergp]

I only see that it works with all skills to warriors, they dosent start with dual wield. And all other classes still cant use all weapons. :s

[Dynashock]

Oh right, I thought you meant all of the weapon skills a class normally can have, which this query does. I didn't make it apply every weapon skill to every class. :\ But using the warrior template it should be really easy to adjust it for every other class...

About the dual wield thing, it was a guess as I'm not sure what the spell id was. I think it might work with 674 instead, but again, I'm not too sure on that.

[fstenbergp]

no idea how to adjust it :b

[fstenbergp]

The SQL dosent work at all :S.... Can any1 please give me one who works? but thanks anyways.