Code:
SHOW CREATE VIEW `vwmercnpctypes`
Code:
CREATE
ALGORITHM = UNDEFINED
DEFINER = `root`@`localhost`
SQL SECURITY DEFINER
VIEW `vwmercnpctypes` AS
SELECT
`ms`.`merc_npc_type_id` AS `merc_npc_type_id`,
'' AS `name`,
`ms`.`clientlevel` AS `clientlevel`,
`ms`.`level` AS `level`,
`mtyp`.`race_id` AS `race_id`,
`mstyp`.`class_id` AS `class_id`,
`ms`.`hp` AS `hp`,
`ms`.`mana` AS `mana`,
0 AS `gender`,
`mai`.`texture` AS `texture`,
`mai`.`helmtexture` AS `helmtexture`,
`ms`.`attack_speed` AS `attack_speed`,
`ms`.`STR` AS `STR`,
`ms`.`STA` AS `STA`,
`ms`.`DEX` AS `DEX`,
`ms`.`AGI` AS `AGI`,
`ms`.`_INT` AS `_INT`,
`ms`.`WIS` AS `WIS`,
`ms`.`CHA` AS `CHA`,
`ms`.`MR` AS `MR`,
`ms`.`CR` AS `CR`,
`ms`.`DR` AS `DR`,
`ms`.`FR` AS `FR`,
`ms`.`PR` AS `PR`,
`ms`.`Corrup` AS `Corrup`,
`ms`.`mindmg` AS `mindmg`,
`ms`.`maxdmg` AS `maxdmg`,
`ms`.`attack_count` AS `attack_count`,
`ms`.`special_abilities` AS `special_abilities`,
`mwi`.`d_melee_texture1` AS `d_melee_texture1`,
`mwi`.`d_melee_texture2` AS `d_melee_texture2`,
`mwi`.`prim_melee_type` AS `prim_melee_type`,
`mwi`.`sec_melee_type` AS `sec_melee_type`,
`ms`.`runspeed` AS `runspeed`,
`ms`.`hp_regen_rate` AS `hp_regen_rate`,
`ms`.`mana_regen_rate` AS `mana_regen_rate`,
1 AS `bodytype`,
`mai`.`armortint_id` AS `armortint_id`,
`mai`.`armortint_red` AS `armortint_red`,
`mai`.`armortint_green` AS `armortint_green`,
`mai`.`armortint_blue` AS `armortint_blue`,
`ms`.`AC` AS `AC`,
`ms`.`ATK` AS `ATK`,
`ms`.`Accuracy` AS `Accuracy`,
`ms`.`spellscale` AS `spellscale`,
`ms`.`healscale` AS `healscale`
FROM
(((((`merc_stats` `ms`
JOIN `merc_armorinfo` `mai` ON (((`ms`.`merc_npc_type_id` = `mai`.`merc_npc_type_id`)
AND (`mai`.`minlevel` <= `ms`.`level`)
AND (`mai`.`maxlevel` >= `ms`.`level`))))
JOIN `merc_weaponinfo` `mwi` ON (((`ms`.`merc_npc_type_id` = `mwi`.`merc_npc_type_id`)
AND (`mwi`.`minlevel` <= `ms`.`level`)
AND (`mwi`.`maxlevel` >= `ms`.`level`))))
JOIN `merc_templates` `mtem` ON ((`mtem`.`merc_npc_type_id` = `ms`.`merc_npc_type_id`)))
JOIN `merc_types` `mtyp` ON ((`mtem`.`merc_type_id` = `mtyp`.`merc_type_id`)))
JOIN `merc_subtypes` `mstyp` ON ((`mtem`.`merc_subtype_id` = `mstyp`.`merc_subtype_id`)))
I have to split up my response due to too many images....