Mercenary Failed to Spawn!

Atzanik · #3 10-14-2015, 08:53 PM

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