The instant respawn issue sounds so easy to me, say your db name is eq. and you want all npcs to spawn with a timer of 500. now go to mysql, do a
update eq.spawn2 set respawntime=500 where respawntime=0;
Unless you want to set different respawn time for different NPC, then it will take quite a bit of work.
For faction, you cant do a one query for all. You have to set the column faction right in table npc_type. That involves quite some work to set every npc to the right faction. You can do it relatively easy by run a set of queries for each NPC type (classified by race and texture) that have a faction ID, then you are done. Let's say, for example, the bear in everforst has a npc_faction_id of 3965, and you know bear's race is 43, and texture for polar bear is 2. Then you could do a
update eq.npc_type set npc_faction_id=3965 where race=43 and texture=2;
then woola, all polar bears have their faction now (unless in the database the texture was set wrong, for example, the current db the polar bear in everforst has texture of 0 instead of the correct number 2, and helmtexture of 0 instead of 2).
Another way to do this by feel is use their name, that's even more staightforward. for example, do this:
update eq.npc_type set npc_faction_id=3965 where name LIKE 'a_polar_bear%';
Quote:
|
Originally Posted by cybermax
Hmm.. any quick way to change the "instaspawn" mobs? As it is now, they all insta spawn upon death, and none of them xept the bazaar npcs have any faction message from killing them.
Since there is no faction, there is no aggro, but i still would like the mobs not to instaspawn tho..
|