Potime spawns

[eqwarrior1188]

I recently downloaded an update to my db and now there arent any of the god spawns on potimeb :-/ Oh yeah, btw i downloaded the update from this post http://www.eqemulator.net/forums/viewtopic.php?t=12723

[jotajota]

Dont know why, but if you turn bodytypes=0 you will see potimeb (and many others) spawns

[eqwarrior1188]

I'm a newb lol, what do you mean body types lol

[jotajota]

Theres a column in your npc_types table in database, use eqadmin or mysqlfont to change value to 0. dont do that in all spawns or a lot of dupiclates will spawn too. so do it only in zones whitout spawns.


Note: before do it, u can track this mobs whit Druid/Ranger characters, they are there, but u cant see them. when u add 0 to bodytypes they apperar.

but dont know why....

[eqwarrior1188]

So your saying if i got to eqadmin i have to change every single spawn in potimeb to 0..that could take a while lol

[jotajota]

That is

[eqwarrior1188]

that is...?

[tcsmyworld]

There will be another update soon, with repaired body_types for those zones and alot more dupes removed.
The DB that will be released is currently running on my Test Server, you can log into it and check it out (TCsMyWorld_Test).

[1010101]

You could also use this command in mysql to change it:

UPDATE npc_types SET bodytype=0;

[eqwarrior1188]

Eh, im not all that good with mysql, i like sticking with 3rd party programs if anything.

[Monrezz]

Start --> Run --> cmd
mysql -u root eq
UPDATE npc_types SET bodytype=0;


Done.

[tcsmyworld]

Not ALL of the body_types should be set to 0.
Setting ALL body_types to 0 may have unwanted effects on your DB.

[Monrezz]

True, but was a quick fix :P

UPDATE npc_types SET bodytype=0 WHERE bodytype="";

[jotajota]

what about bodytype=-1 ?

[Monrezz]

UPDATE npc_types SET bodytype=0 WHERE ((bodytype=-1) OR (bodytype ="") OR (bodytype is null));

[codemonkey]

you may wish to try this :


update npc_types set bodytype=0 where bodytype is null OR bodytype=-1;