EQExtractor2

[Akkadius]

Originally Posted by Andrew80k

Anyone doing TBS?

I have been doing TBS, but most of the zones are instanced, I have most of the statics though.

I've got almost PoR (is done I think), TBS and DoN statics completely done. I don't post them all until they are done otherwise if I upload them gradually I have no idea where I am with the way you have to upload to CD's repo.

[Derision]

1.5 is up with these changes:

Fixed bug which caused the first spawn to always be skipped.
Update generated for fog_density column in zone table.
Populated Drakkin specific fields in npc_types.
If zone config and/or zone points are selected, the generated SQL will no longer be commented out.

I implemented the update for npc_types, but I have disabled it for now in the UI as I found some issues with it ...

First I was updating the size, then I found multiple NPCs with the same name but different sizes, so I took the size out of the update. Then I found multiple NPCs with the same name,
but some were wielding weapons and some not, e.g.

mysql> select id, name, d_meele_texture1, d_meele_texture2 from npc_types where name like 'a_Nokk_elder';
+--------+--------------+------------------+------------------+
| id     | name         | d_meele_texture1 | d_meele_texture2 |
+--------+--------------+------------------+------------------+
| 394319 | a_Nokk_elder |                0 |                0 |
| 394320 | a_Nokk_elder |            10608 |                0 |
| 394363 | a_Nokk_elder |                0 |                0 |
+--------+--------------+------------------+------------------+
3 rows in set (0.25 sec)

(this is with current live data, not existing PEQ tables).

Now my guess is there are multiple mobs with the same name but different facial features, but I didn't check that, so I'm really not sure what to do and await Cavedude's words
of wisdom on the matter

[cavedude]

The melee textures, could that possibly be an item the NPC has on their loottable? If so, I don't think it would be a big deal to 0 out those columns after they have been sourced into the db. I'm mainly looking for textures on guards and player races as everything else is usually handled by loot. It's no big deal if I have to go back and manually fiddle with the melee columns.

About the size and face data... That's tricky. How about a way to check which columns you want to dump in the UPDATE? Maybe have the default the "safe" options, but also have choices for things like level or size which may not be as safe. Not sure how much work that would be, but I think that would make everybody happy.