[MaNGOS] Warrior start with full DPS Gear

**CthulhuFtagn** · 23-01-10, 12:38 AM

Code:

/* 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.

Code:

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

› See More: [MaNGOS] Warrior start with full DPS Gear

**LordMonky1** · 23-01-10, 08:30 AM

hmmm wher do post that code ? hmm ^^

**CthulhuFtagn** · 23-01-10, 09:49 AM

As a SQL query into your mangos or evox database.

**LordMonky1** · 23-01-10, 11:29 AM

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

**LordMonky1** · 23-01-10, 11:35 AM

if you have time ofc ^^

**CthulhuFtagn** · 23-01-10, 11:42 AM

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

**LordMonky1** · 23-01-10, 11:46 AM

Originally Posted by TheRealMethuselah

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

ok ^^

**CthulhuFtagn** · 23-01-10, 01:07 PM

Well, I changed my mind and added the DPS starter gear for all classes as an optional update in my revision [272] repack.

Update:

Code:

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** · 23-01-10, 03:51 PM

Originally Posted by TheRealMethuselah

Well, I changed my mind and added the DPS starter gear for all classes as an optional update in my revision [272] repack.

Update:

Code:

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 ^^