[MaNGOS] Warrior start with full DPS Gear

[CthulhuFtagn]

/* Warrior Gear */
insert into `playercreateinfo_item` (`race`, `class`, `itemid`, `amount`)
values
/* Bag */
('1','1','51809','3'), /* Human */
('2','1','51809','3'), /* Orc */
('3','1','51809','3'), /* Dwarf */
('4','1','51809','3'), /* Night Elf */
('5','1','51809','3'), /* Undead */
('6','1','51809','3'), /* Tauren */
('7','1','51809','3'), /* Gnome */
('8','1','51809','3'), /* Troll */
('11','1','51809','3'), /* Draenei */
/* Ammo Pouch */
('1','1','44447','1'), /* Human */
('2','1','44447','1'), /* Orc */
('3','1','44447','1'), /* Dwarf */
('4','1','44447','1'), /* Night Elf */
('5','1','44447','1'), /* Undead */
('6','1','44447','1'), /* Tauren */
('7','1','44447','1'), /* Gnome */
('8','1','44447','1'), /* Troll */
('11','1','44447','1'), /* Draenei */
/* Head */
('1','1','51227','1'), /* Human */
('2','1','51227','1'), /* Orc */
('3','1','51227','1'), /* Dwarf */
('4','1','51227','1'), /* Night Elf */
('5','1','51227','1'), /* Undead */
('6','1','51227','1'), /* Tauren */
('7','1','51227','1'), /* Gnome */
('8','1','51227','1'), /* Troll */
('11','1','51227','1'), /* Draenei */
/* Neck */
('1','1','50728','1'), /* Human */
('2','1','50728','1'), /* Orc */
('3','1','50728','1'), /* Dwarf */
('4','1','50728','1'), /* Night Elf */
('5','1','50728','1'), /* Undead */
('6','1','50728','1'), /* Tauren */
('7','1','50728','1'), /* Gnome */
('8','1','50728','1'), /* Troll */
('11','1','50728','1'), /* Draenei */
/* Shoulder */
('1','1','51229','1'), /* Human */
('2','1','51229','1'), /* Orc */
('3','1','51229','1'), /* Dwarf */
('4','1','51229','1'), /* Night Elf */
('5','1','51229','1'), /* Undead */
('6','1','51229','1'), /* Tauren */
('7','1','51229','1'), /* Gnome */
('8','1','51229','1'), /* Troll */
('11','1','51229','1'), /* Draenei */
/* Back */
('1','1','47545','1'), /* Human */
('2','1','47546','1'), /* Orc */
('3','1','47545','1'), /* Dwarf */
('4','1','47545','1'), /* Night Elf */
('5','1','47546','1'), /* Undead */
('6','1','47546','1'), /* Tauren */
('7','1','47545','1'), /* Gnome */
('8','1','47546','1'), /* Troll */
('11','1','47545','1'), /* Draenei */
/* Chest */
('1','1','50965','1'), /* Human */
('2','1','50965','1'), /* Orc */
('3','1','50965','1'), /* Dwarf */
('4','1','50965','1'), /* Night Elf */
('5','1','50965','1'), /* Undead */
('6','1','50965','1'), /* Tauren */
('7','1','50965','1'), /* Gnome */
('8','1','50965','1'), /* Troll */
('11','1','50965','1'), /* Draenei */
/* Wrist */
('1','1','46967','1'), /* Human */
('2','1','47414','1'), /* Orc */
('3','1','46967','1'), /* Dwarf */
('4','1','46967','1'), /* Night Elf */
('5','1','47414','1'), /* Undead */
('6','1','47414','1'), /* Tauren */
('7','1','46967','1'), /* Gnome */
('8','1','47414','1'), /* Troll */
('11','1','46967','1'), /* Draenei */
/* Hands */
('1','1','50977','1'), /* Human */
('2','1','50977','1'), /* Orc */
('3','1','50977','1'), /* Dwarf */
('4','1','50977','1'), /* Night Elf */
('5','1','50977','1'), /* Undead */
('6','1','50977','1'), /* Tauren */
('7','1','50977','1'), /* Gnome */
('8','1','50977','1'), /* Troll */
('11','1','50977','1'), /* Draenei */
/* Waist */
('1','1','47002','1'), /* Human */
('2','1','47429','1'), /* Orc */
('3','1','47002','1'), /* Dwarf */
('4','1','47002','1'), /* Night Elf */
('5','1','47429','1'), /* Undead */
('6','1','47429','1'), /* Tauren */
('7','1','47002','1'), /* Gnome */
('8','1','47429','1'), /* Troll */
('11','1','47002','1'), /* Draenei */
/* Legs */
('1','1','49903','1'), /* Human */
('2','1','49903','1'), /* Orc */
('3','1','49903','1'), /* Dwarf */
('4','1','49903','1'), /* Night Elf */
('5','1','49903','1'), /* Undead */
('6','1','49903','1'), /* Tauren */
('7','1','49903','1'), /* Gnome */
('8','1','49903','1'), /* Troll */
('11','1','49903','1'), /* Draenei */
/* Feet */
('1','1','50639','1'), /* Human */
('2','1','50639','1'), /* Orc */
('3','1','50639','1'), /* Dwarf */
('4','1','50639','1'), /* Night Elf */
('5','1','50639','1'), /* Undead */
('6','1','50639','1'), /* Tauren */
('7','1','50639','1'), /* Gnome */
('8','1','50639','1'), /* Troll */
('11','1','50639','1'), /* Draenei */
/* Ring */
('1','1','50657','1'), /* Human */
('2','1','50657','1'), /* Orc */
('3','1','50657','1'), /* Dwarf */
('4','1','50657','1'), /* Night Elf */
('5','1','50657','1'), /* Undead */
('6','1','50657','1'), /* Tauren */
('7','1','50657','1'), /* Gnome */
('8','1','50657','1'), /* Troll */
('11','1','50657','1'), /* Draenei */
/* Ring */
('1','1','50693','1'), /* Human */
('2','1','50693','1'), /* Orc */
('3','1','50693','1'), /* Dwarf */
('4','1','50693','1'), /* Night Elf */
('5','1','50693','1'), /* Undead */
('6','1','50693','1'), /* Tauren */
('7','1','50693','1'), /* Gnome */
('8','1','50693','1'), /* Troll */
('11','1','50693','1'), /* Draenei */
/* Trinket */
('1','1','47131','1'), /* Human */
('2','1','47464','1'), /* Orc */
('3','1','47131','1'), /* Dwarf */
('4','1','47131','1'), /* Night Elf */
('5','1','47464','1'), /* Undead */
('6','1','47464','1'), /* Tauren */
('7','1','47131','1'), /* Gnome */
('8','1','47464','1'), /* Troll */
('11','1','47131','1'), /* Draenei */
/* Trinket */
('1','1','50343','1'), /* Human */
('2','1','50343','1'), /* Orc */
('3','1','50343','1'), /* Dwarf */
('4','1','50343','1'), /* Night Elf */
('5','1','50343','1'), /* Undead */
('6','1','50343','1'), /* Tauren */
('7','1','50343','1'), /* Gnome */
('8','1','50343','1'), /* Troll */
('11','1','50343','1'), /* Draenei */
/* Ranged */
('1','1','47521','1'), /* Human */
('2','1','47523','1'), /* Orc */
('3','1','47521','1'), /* Dwarf */
('4','1','47521','1'), /* Night Elf */
('5','1','47523','1'), /* Undead */
('6','1','47523','1'), /* Tauren */
('7','1','47521','1'), /* Gnome */
('8','1','47523','1'), /* Troll */
('11','1','47521','1'), /* Draenei */
/* Main Hand */
('1','1','49623','1'), /* Human */
('2','1','49623','1'), /* Orc */
('3','1','49623','1'), /* Dwarf */
('4','1','49623','1'), /* Night Elf */
('5','1','49623','1'), /* Undead */
('6','1','49623','1'), /* Tauren */
('7','1','49623','1'), /* Gnome */
('8','1','49623','1'), /* Troll */
('11','1','49623','1'), /* Draenei */
/* Off Hand */
('1','1','50709','1'), /* Human */
('2','1','50709','1'), /* Orc */
('3','1','50709','1'), /* Dwarf */
('4','1','50709','1'), /* Night Elf */
('5','1','50709','1'), /* Undead */
('6','1','50709','1'), /* Tauren */
('7','1','50709','1'), /* Gnome */
('8','1','50709','1'), /* Troll */
('11','1','50709','1'), /* Draenei */
/* Tabard */
('1','1','45574','1'), /* Human */
('2','1','45581','1'), /* Orc */
('3','1','45577','1'), /* Dwarf */
('4','1','45579','1'), /* Night Elf */
('5','1','45583','1'), /* Undead */
('6','1','45584','1'), /* Tauren */
('7','1','45578','1'), /* Gnome */
('8','1','45582','1'), /* Troll */
('11','1','45580','1'); /* Draenei */


I placed this here because you can use it as a template to start your class with full gear.

The only one missing from the Warrior class, of course, is the Blood elf which is Race 10.


Class
1 = Warrior
2 = Paladin
3 = Hunter
4 = Rogue
5 = Priest
6 = Death Knight
7 = Shaman
8 = Mage
9 = Warlock
11 = Druid

Race
1 = Human
2 = Orc
3 = Dwarf
4 = Night Elf
5 = Undead
6 = Tauren
7 = Gnome
8 = Troll
10 = Blood Elf
11 = Draenei

[LordMonky1]

hmmm wher do post that code ? hmm ^^

[CthulhuFtagn]

As a SQL query into your mangos or evox database.

[LordMonky1]

is only for warrior right...can you make that is for all class?+rep

[LordMonky1]

if you have time ofc ^^

[CthulhuFtagn]

That's why I posted this, so that you could make your own using the template.

[LordMonky1]

That's why I posted this, so that you could make your own using the template.



ok ^^

[CthulhuFtagn]

Well, I changed my mind and added the DPS starter gear for all classes as an optional update in my revision [272] repack (http://mmopro.net/forums/releases/2732-release-trm-repack-mangos-compatible-core-db-evo-x-3-3-0-11159-a-post11699.html#post11699).

Update:

evo-X:
[272] Fixed inconstence in one from recently added AI events name
[271] Implement AI/EventAI calls at summoned creature die/despawn
[270] Implement spell 24834.
[269] Apply second part of spell 50397.
[268] New Scripts for Halls of Stone
[267] Update spell 15286 work to current funtionality.
[266] Ulduar Change
[265] More Ulduar Stuff

Optional:
DPS Starter Gear Scripts

[LordMonky1]

Well, I changed my mind and added the DPS starter gear for all classes as an optional update in my revision [272] repack (http://mmopro.net/forums/releases/2732-release-trm-repack-mangos-compatible-core-db-evo-x-3-3-0-11159-a-post11699.html#post11699).

Update:

evo-X:
[272] Fixed inconstence in one from recently added AI events name
[271] Implement AI/EventAI calls at summoned creature die/despawn
[270] Implement spell 24834.
[269] Apply second part of spell 50397.
[268] New Scripts for Halls of Stone
[267] Update spell 15286 work to current funtionality.
[266] Ulduar Change
[265] More Ulduar Stuff

Optional:
DPS Starter Gear Scripts



^^ nice done ^^

[CthulhuFtagn]

Thought you'd like that one ;)

[agamoose]

Thanks

http://i24.photobucket.com/albums/c12/Agamoose/agamoosesignature.png

[deltawow]

The link don't work for me?