[TrinityCore] Custom Season 9 - Malicious Gladiator

[TrinityCore] Custom Season 9 - Malicious Gladiator 2022-12-27

Malicious Gladiator gear is a custom season 9 (stats from season 8 + 15%).

Frathir

Divine
Divine
Frathir Rep
0
0
0
Rep
0
Frathir Vouches
0
0
0
Vouches
0
Posts
18
Likes
28
Bits
2 YEARS
2 YEARS OF SERVICE
LEVEL 1 25 XP
Liked By 1 member :

Urwifemykids

Banned
banned
Urwifemykids Rep
0
0
2
Rep
-1000
Urwifemykids Vouches
0
0
0
Vouches
0
Posts
26
Likes
71
Bits
2 YEARS
2 YEARS OF SERVICE
LEVEL 2 115 XP
I used your query and the items work perfectly but the vendors are empty ;/
 

Kearu

Divine
Divine
Rep
1
0
0
Rep
1
Vouches
0
0
0
Vouches
0
Posts
139
Likes
81
2 YEARS
2 YEARS OF SERVICE
LEVEL 3 120 XP
I used your query and the items work perfectly but the vendors are empty ;/
SQL:
SET @Weapons_Vendor_Entry := '-1'; -- Replace With the entry of Weapon Vendor
SET @Armo_Vendor_Entry := '-1'; -- Replace with the entry of Armor Vendor

INSERT INTO npc_vendor (`Entry`, `Item`)
SELECT DISTINCT @Weapons_Vendor_Entry, `Entry` FROM `item_template`
WHERE NAME LIKE 'Malicious Gladiator\'s %' AND (class = '2' OR (`class` = '4' AND `subclass` = '6')) ORDER BY `Entry` ASC;

INSERT INTO npc_vendor (`Entry`, `Item`)
SELECT DISTINCT @Armo_Vendor_Entry, `Entry` FROM `item_template`
WHERE NAME LIKE 'Malicious Gladiator\'s %' AND `class` = '4' AND `subclass` != '6' ORDER BY `Entry` ASC;

This should work, just replace the ID's with the vendor ID... This will not add an extended cost to the item, it will try to organize the items as long as entries are in order. Have not tested, so if there is any issues just let me know and I will try to help out.
 
Liked By 1 member :

3,387

1,270

9,554

428

Top