Help plz :P

[Nubbadon]

I'm gonna make donation gear and i need to know how i take away "<Class> Only"

[Ballwinkle]

-1 in allowableclass

[Nubbadon]

Any Command for that?

[Ballwinkle]

its in the database, in table items

[Nubbadon]

I cant seem to find the Item that im looking for in Items. Im looking for the Merciless Gladiator Gear for hunters.

[Ballwinkle]

its there...

[Nubbadon]

well i dont find it......

[Ballwinkle]

next page?

[Gastricpenguin]

Do you use navicat? If so you can just search for the name :d

[Nubbadon]

Lolz! xD Thx :P

[Nubbadon]

Where do i search?

[latruwski]

Where do i search?

in the items table ofc... anyway it is possible you dont have the gladiator gear in your DB...

[Nubbadon]

Well... It's it a write able search for it? Like somewhere i can type in the name and get it?

[latruwski]

just use search in the items table and search for "merciless gladiator's chain"
man here i made it ieven more simple... just run this query:

SELECT
items.entry,
items.name1
from items
WHERE
items.name1 LIKE  '%Merciless Gladiator\'s Chain%'

if that doesnt bring up result then you dont have the Hunters gladiator set in your DB!

if it is missing:

run this query to insert the merciles gladiator set for hunters into your DB:

INSERT INTO `items` (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, `ItemExtendedCost`, `ArenaRankRequirement`, `ReqDisenchantSkill`, `unk2`) VALUES
('31960',4,3,-1,'Merciless Gladiator\'s Chain Armor','','','','45963',4,32768,0,0,5,4,32767,136,70,0,0,0,0,0,0,0,0,1,0,7,57,3,31,32,21,35,21,5,17,-1,0,-1,0,-1,0,-1,0,-1,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,954,0,0,0,0,0,0,0,0,'0',15807,1,0,-1,0,-1,0,1,0,-1,0,-1,0,1,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,5,0,0,0,0,586,140,0,0,0,0,2,0,2,0,4,0,2874,0,1431,42,-1,0),
    ('31961',4,3,-1,'Merciless Gladiator\'s Chain Gauntlets','','','','45964',4,32768,0,0,10,4,32767,136,70,0,0,0,0,0,0,0,0,1,0,7,48,3,30,32,17,35,21,5,13,-1,0,-1,0,-1,0,-1,0,-1,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,596,0,0,0,0,0,0,0,0,'0',15806,1,0,-1,0,-1,28539,1,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,5,0,0,0,0,586,50,0,0,0,0,0,0,0,0,0,0,0,0,1432,47,-1,0),
    ('31962',4,3,-1,'Merciless Gladiator\'s Chain Helm','','','','45965',4,32768,0,0,1,4,32767,136,70,0,0,0,0,0,0,0,0,1,0,7,55,3,37,32,22,35,22,5,19,-1,0,-1,0,-1,0,-1,0,-1,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,775,0,0,0,0,0,0,0,0,'0',14056,1,0,-1,0,-1,0,1,0,-1,0,-1,0,1,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,5,0,0,0,0,586,85,0,0,0,0,1,0,2,0,0,0,2878,0,1431,52,-1,0),
    ('31963',4,3,-1,'Merciless Gladiator\'s Chain Leggings','','','','45966',4,32768,0,0,7,4,32767,136,70,0,0,0,0,0,0,0,0,1,0,7,58,3,38,32,21,35,33,5,15,-1,0,-1,0,-1,0,-1,0,-1,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,835,0,0,0,0,0,0,0,0,'0',15812,1,0,-1,0,-1,0,1,0,-1,0,-1,0,1,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,5,0,0,0,0,586,105,0,0,0,0,0,0,0,0,0,0,0,0,1431,49,-1,0),
    ('31964',4,3,-1,'Merciless Gladiator\'s Chain Spaulders','','','','45967',4,32768,0,0,3,4,32767,136,70,0,0,0,0,0,0,0,0,1,0,7,45,3,32,32,14,35,21,5,10,-1,0,-1,0,-1,0,-1,0,-1,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,715,0,0,0,0,0,0,0,0,'0',14027,1,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,5,0,0,0,0,586,85,0,0,0,0,2,0,4,0,0,0,2859,0,1435,44,-1,0);

[latruwski]

there that should be e solution no?

grtz