Welcome to AC Web.
Results 1 to 8 of 8
  1. #1

    How can I Change a NPC/Mob's Respawn time???


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Hey Guys!

    Does anyone know how to change a NPC/Mob's Respawn time for TrinityCore 3.3.5?
    Because I have a leveling road and the mobs are taking a while to respawn (I think 5 min is the default time), And I want them to respawn every 10 seconds.

    So it would be great if someone could write me a guide or if they can give me a SQL Code that will change a NPC/Mob's Repsawn Time Permanently.

    Thank You!

    +REP if you helped.

  2. #2
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,568
    Hey Deathorous, you can run this
    Code:
    SET
    @ENTRY =  160000, /*NPC ENTRY*/
    @SPAWNTIME = 10; /*SPAWNTIME*/
    UPDATE creature SET spawntimesecs = @SPAWNTIME WHERE id IN (SELECT DISTINCT id FROM creature_template WHERE entry = @ENTRY);
    Or you can check Creature table than find 'ID' of your creature and change the spawntimesecs. goodluck

  3. #3
    Quote Originally Posted by JadaDev View Post
    Hey Deathorous, you can run this
    Code:
    SET
    @ENTRY =  160000, /*NPC ENTRY*/
    @SPAWNTIME = 10; /*SPAWNTIME*/
    UPDATE creature SET spawntimesecs = @SPAWNTIME WHERE id IN (SELECT DISTINCT id FROM creature_template WHERE entry = @ENTRY);
    Or you can check Creature table than find 'ID' of your creature and change the spawntimesecs. goodluck
    Thank You!
    It worked!
    I really appreciate it!
    +REP!

  4. #4
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,568
    No problem mate , and thank you :* /Happy

  5. #5
    dude in mangos database there is no coumn with name : spawntimedisc , do you know what name is it ? @jadadev

  6. #6
    Quote Originally Posted by meti.reflex1997 View Post
    dude in mangos database there is no coumn with name : spawntimedisc , do you know what name is it ? @jadadev
    This topic has 6 years old mate.

    Mangos `creature` structure has `spawntimesecsmin` & `spawntimesecsmax`, so this will take a random number between min-max spawntimesecs.
    If you want your creature to spawn in 3 sec set spawntimesecsmin = 3 & spawntimesecsmax = 3
    If you want your creature to spawn in 3-5 sec set spawntimesecsmin = 3 & spawntimesecsmax = 5
    https://github.com/cmangos/issues/wiki/creature

  7. #7
    @molinita omg it works thank you so much.i was stack in it about 2weeks and i posted this hoplessly but you help too much,thank you bro <3 +reeeeeeeeeep
    1 quesiton more do you know any thing about it : no one(players) can enter instance hyjal smite.
    error :Unable to zone in while an encounter is in progress.(i went in instance with command .gm on and no one is fighting in instance) i reset mode:normal to heroic , in heroic mode 2player just can go into instance no more and no once can go in normal mode)
    Last edited by meti.reflex1997; 04-08-2020 at 12:23 AM.

  8. #8

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Quote Originally Posted by meti.reflex1997 View Post
    @molinita omg it works thank you so much.i was stack in it about 2weeks and i posted this hoplessly but you help too much,thank you bro <3 +reeeeeeeeeep
    1 quesiton more do you know any thing about it : no one(players) can enter instance hyjal smite.
    error :Unable to zone in while an encounter is in progress.(i went in instance with command .gm on and no one is fighting in instance) i reset mode:normal to heroic , in heroic mode 2player just can go into instance no more and no once can go in normal mode)
    Uhm, no idea. Make a thread about it in support section.
    Maybe you could try changing values in .dbc from Hyjal area:

    https://trinitycore.atlassian.net/wi...9959/AreaTable
    https://trinitycore.atlassian.net/wi...es/2130252/Map

    Check AreaTable.dbc and Map.dbc, you could try changing values from there.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •