Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-14-2015, 08:26 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

Post your results for:
Code:
SHOW CREATE VIEW `vwmercnpctypes`
and
Code:
EXPLAIN `vwmercnpctypes`
..if you would, please
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #2  
Old 10-14-2015, 08:53 PM
Atzanik
Fire Beetle
 
Join Date: Oct 2015
Location: Ontario, Canada
Posts: 8
Default

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....
Reply With Quote
  #3  
Old 10-14-2015, 08:54 PM
Atzanik
Fire Beetle
 
Join Date: Oct 2015
Location: Ontario, Canada
Posts: 8
Default

Code:
EXPLAIN `vwmercnpctypes`
Code:
+-------------------+-----------------------+------+-----+---------+-------+
| Field             | Type                  | Null | Key | Default | Extra |
+-------------------+-----------------------+------+-----+---------+-------+
| merc_npc_type_id  | int(11) unsigned      | NO   |     | NULL    |       |
| name              | char(0)               | NO   |     |         |       |
| clientlevel       | tinyint(2) unsigned   | NO   |     | 1       |       |
| level             | tinyint(2) unsigned   | NO   |     | 1       |       |
| race_id           | int(10) unsigned      | NO   |     | NULL    |       |
| class_id          | int(10) unsigned      | NO   |     | NULL    |       |
| hp                | int(11)               | NO   |     | 1       |       |
| mana              | int(11)               | NO   |     | 0       |       |
| gender            | int(1)                | NO   |     | 0       |       |
| texture           | tinyint(2) unsigned   | NO   |     | 0       |       |
| helmtexture       | tinyint(2) unsigned   | NO   |     | 0       |       |
| attack_speed      | tinyint(3)            | NO   |     | 0       |       |
| STR               | mediumint(8) unsigned | NO   |     | 75      |       |
| STA               | mediumint(8) unsigned | NO   |     | 75      |       |
| DEX               | mediumint(8) unsigned | NO   |     | 75      |       |
| AGI               | mediumint(8) unsigned | NO   |     | 75      |       |
| _INT              | mediumint(8) unsigned | NO   |     | 80      |       |
| WIS               | mediumint(8) unsigned | NO   |     | 80      |       |
| CHA               | mediumint(8) unsigned | NO   |     | 75      |       |
| MR                | smallint(5)           | NO   |     | 15      |       |
| CR                | smallint(5)           | NO   |     | 15      |       |
| DR                | smallint(5)           | NO   |     | 15      |       |
| FR                | smallint(5)           | NO   |     | 15      |       |
| PR                | smallint(5)           | NO   |     | 15      |       |
| Corrup            | smallint(5)           | NO   |     | 15      |       |
| mindmg            | int(10) unsigned      | NO   |     | 1       |       |
| maxdmg            | int(10) unsigned      | NO   |     | 1       |       |
| attack_count      | smallint(6)           | NO   |     | 0       |       |
| special_abilities | text                  | YES  |     | NULL    |       |
| d_melee_texture1  | int(10) unsigned      | NO   |     | 0       |       |
| d_melee_texture2  | int(10) unsigned      | NO   |     | 0       |       |
| prim_melee_type   | tinyint(4) unsigned   | NO   |     | 28      |       |
| sec_melee_type    | tinyint(4) unsigned   | NO   |     | 28      |       |
| runspeed          | float                 | NO   |     | 0       |       |
| hp_regen_rate     | int(11) unsigned      | NO   |     | 1       |       |
| mana_regen_rate   | int(11) unsigned      | NO   |     | 1       |       |
| bodytype          | int(1)                | NO   |     | 0       |       |
| armortint_id      | int(10) unsigned      | NO   |     | 0       |       |
| armortint_red     | tinyint(3) unsigned   | NO   |     | 0       |       |
| armortint_green   | tinyint(3) unsigned   | NO   |     | 0       |       |
| armortint_blue    | tinyint(3) unsigned   | NO   |     | 0       |       |
| AC                | smallint(5)           | NO   |     | 1       |       |
| ATK               | mediumint(9)          | NO   |     | 1       |       |
| Accuracy          | mediumint(9)          | NO   |     | 0       |       |
| spellscale        | float                 | NO   |     | 100     |       |
| healscale         | float                 | NO   |     | 100     |       |
+-------------------+-----------------------+------+-----+---------+-------+
46 rows in set (0.01 sec)

Last edited by joligario; 10-14-2015 at 10:18 PM.. Reason: Code brackets
Reply With Quote
  #4  
Old 10-14-2015, 08:55 PM
Atzanik
Fire Beetle
 
Join Date: Oct 2015
Location: Ontario, Canada
Posts: 8
Default

Edit: I cleaned everything up in the previous two posts so that you can read it better. Instead of just cutting and paste from workbench output, I opened the view and cut and paste, then ran the explain on the command line as it puts in the nice table

Let me know if you need anything else.

And thank you for the response.

Last edited by joligario; 10-14-2015 at 10:19 PM.. Reason: code brackets
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 02:02 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3