Whydb trainers not working?

[brock106]

Hello,
My trainers arnt working, you click them but nothing happens. Here is name and proto table structure, may be flag related?

-- ----------------------------
-- Table structure for creature_names
-- ----------------------------
DROP TABLE IF EXISTS `creature_names`;
CREATE TABLE `creature_names` (
`entry` int(10) unsigned NOT NULL default '0',
`name` varchar(100) NOT NULL,
`subname` varchar(100) NOT NULL,
`info_str` varchar(500) NOT NULL,
`Flags1` int(10) unsigned default '0',
`type` int(10) unsigned default '0',
`family` int(10) unsigned default '0',
`rank` int(10) unsigned default '0',
`unk4` int(10) unsigned default '0',
`spelldataid` int(10) unsigned default NULL,
`male_displayid` int(30) NOT NULL,
`female_displayid` int(30) NOT NULL,
`male_displayid2` int(30) NOT NULL default '0',
`female_displayid2` int(30) NOT NULL default '0',
`unknown_float1` float NOT NULL default '1',
`unknown_float2` float NOT NULL default '1',
`civilian` int(4) unsigned default NULL,
`leader` tinyint(3) unsigned default NULL,
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Creature System';


-- ----------------------------
-- Table structure for creature_proto
-- ----------------------------
DROP TABLE IF EXISTS `creature_proto`;
CREATE TABLE `creature_proto` (
`entry` int(30) unsigned NOT NULL default '0',
`minlevel` int(30) unsigned NOT NULL,
`maxlevel` int(30) unsigned NOT NULL,
`faction` int(30) unsigned NOT NULL default '0',
`minhealth` int(30) unsigned NOT NULL,
`maxhealth` int(30) unsigned NOT NULL,
`mana` int(30) unsigned NOT NULL default '0',
`scale` float NOT NULL default '0',
`npcflags` int(30) unsigned NOT NULL default '0',
`attacktime` int(30) unsigned NOT NULL default '0',
`attacktype` int(4) NOT NULL default '0',
`mindamage` float NOT NULL default '0',
`maxdamage` float NOT NULL default '0',
`can_ranged` int(11) unsigned NOT NULL default '0',
`rangedattacktime` int(30) unsigned NOT NULL default '0',
`rangedmindamage` float unsigned NOT NULL default '0',
`rangedmaxdamage` float unsigned NOT NULL default '0',
`respawntime` int(30) unsigned NOT NULL default '0',
`armor` int(30) unsigned NOT NULL default '0',
`resistance1` int(30) unsigned NOT NULL default '0',
`resistance2` int(30) unsigned NOT NULL default '0',
`resistance3` int(30) unsigned NOT NULL default '0',
`resistance4` int(30) unsigned NOT NULL default '0',
`resistance5` int(30) unsigned NOT NULL default '0',
`resistance6` int(30) unsigned NOT NULL default '0',
`combat_reach` float NOT NULL default '0',
`bounding_radius` float NOT NULL default '0',
`auras` longtext NOT NULL,
`boss` int(11) unsigned NOT NULL default '0',
`money` int(30) NOT NULL default '0',
`invisibility_type` int(30) unsigned NOT NULL,
`death_state` int(30) unsigned NOT NULL,
`walk_speed` float NOT NULL default '2.5',
`run_speed` float NOT NULL default '8',
`fly_speed` float NOT NULL default '14',
`extra_a9_flags` int(30) NOT NULL default '0',
`spell1` int(30) NOT NULL default '0',
`spell2` int(30) NOT NULL default '0',
`spell3` int(30) NOT NULL default '0',
`spell4` int(30) NOT NULL default '0',
`spell_flags` int(30) NOT NULL default '0',
`modImmunities` int(30) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`),
UNIQUE KEY `ID` (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Creature System';


What is wrong?
Also is there an sql update to remove the cubes on equip slot for why DB?

[TheSpidey]

It might be flag related, but unless you post the npcflags of your trainers, we can't say for sure