So hear me out here. My understanding is, I look @ npc_types, find the NPC im looking for. Let's say Cazic thule:
mysql> select * from npc_types where name LIKE "%Cazic%"
-> ;
+--------+------------------+----------+-------+------+-------+----------+--------+--------+---------+-------------+------+---------------+-----------------+--------------+-------------+---------------+----------------+--------+--------+-----------------+-------------+------+------------------+------------------+-----------------+------------------+-------------------+--------------+------------------+------------------+----------+-----+-----+-----+-----+-----+-----------+------------------+---------+------+-----------+-------------+--------------+----------+-----+-----+-----+-----+------+-----+-----+----------+-------------------+-----------+-------+---------+-----+----------+
| id | name | lastname | level | race | class | bodytype | hp | gender | texture | helmtexture | size | hp_regen_rate | mana_regen_rate | loottable_id | merchant_id | npc_spells_id | npc_faction_id | mindmg | maxdmg | npcspecialattks | aggroradius | face | luclin_hairstyle | luclin_haircolor | luclin_eyecolor | luclin_eyecolor2 | luclin_beardcolor | luclin_beard | d_meele_texture1 | d_meele_texture2 | runspeed | MR | CR | DR | FR | PR | see_invis | see_invis_undead | qglobal | AC | npc_aggro | spawn_limit | attack_speed | findable | STR | STA | DEX | AGI | _INT | WIS | CHA | see_hide | see_improved_hide | trackable | isbot | exclude | ATK | Accuracy |
+--------+------------------+----------+-------+------+-------+----------+--------+--------+---------+-------------+------+---------------+-----------------+--------------+-------------+---------------+----------------+--------+--------+-----------------+-------------+------+------------------+------------------+-----------------+------------------+-------------------+--------------+------------------+------------------+----------+-----+-----+-----+-----+-----+-----------+------------------+---------+------+-----------+-------------+--------------+----------+-----+-----+-----+-----+------+-----+-----+----------+-------------------+-----------+-------+---------+-----+----------+
| 72003 | Cazic_Thule | | 70 | 95 | 1 | 7 | 277000 | 2 | 0 | 0 | 40 | 1000 | 0 | 291 | 0 | 116 | 18 | 375 | 850 | SERQUMCNIDW | 115 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2.25 | 200 | 200 | 200 | 200 | 200 | 1 | 0 | 0 | 3400 | 0 | 0 | -30 | 0 | 474 | 474 | 474 | 474 | 474 | 474 | 474 | 1 | 1 | 1 | 0 | 2 | 0 | 0 |
So Cazic is ID 72003. Now i look @ spawn 2:
| spawn2 | CREATE TABLE `spawn2` (
`id` int(11) NOT NULL auto_increment,
`spawngroupID` int(11) NOT NULL default '0',
`zone` varchar(16) NOT NULL default '',
`x` float(14,6) NOT NULL default '0.000000',
`y` float(14,6) NOT NULL default '0.000000',
`z` float(14,6) NOT NULL default '0.000000',
`heading` float(14,6) NOT NULL default '0.000000',
`respawntime` int(11) NOT NULL default '0',
`variance` smallint(4) NOT NULL default '0',
`pathgrid` int(10) NOT NULL default '0',
`timeleft` bigint(16) NOT NULL default '0',
`_condition` mediumint(
unsigned NOT NULL default '0',
`cond_value` mediumint(9) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `ZoneGroup` (`zone`,`spawngroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
There is no id 72003! What am I missing?
Threaded Mode
