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

10-14-2015, 08:26 PM
|
 |
Developer
|
|
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
|
|
Post your results for:
Code:
SHOW CREATE VIEW `vwmercnpctypes`
and
Code:
EXPLAIN `vwmercnpctypes`
..if you would, please 
__________________
Uleat of Bertoxxulous
Compilin' Dirty
|
 |
|
 |

10-14-2015, 08:53 PM
|
Fire Beetle
|
|
Join Date: Oct 2015
Location: Ontario, Canada
Posts: 8
|
|
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....
|
 |
|
 |
 |
|
 |

10-14-2015, 08:54 PM
|
Fire Beetle
|
|
Join Date: Oct 2015
Location: Ontario, Canada
Posts: 8
|
|
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
|
 |
|
 |

10-14-2015, 08:55 PM
|
Fire Beetle
|
|
Join Date: Oct 2015
Location: Ontario, Canada
Posts: 8
|
|
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
|
Thread Tools |
|
Display Modes |
Hybrid Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 02:02 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |