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

    Changing characters spawn zone?


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Hello, how I can change all starting characters spawn location for example Dalaran? I couldnt find anything in the worldcinfig?

    PS. How to make DK's to spawn with 71 talents points when starting at level 80 like other characters and with no gear?
    Last edited by Bokrael; 03-30-2020 at 07:19 PM.

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

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,568
    Quote Originally Posted by Bokrael View Post
    Hello, how I can change all starting characters spawn location for example Dalaran? I couldnt find anything in the worldcinfig?

    PS. How to make DK's to spawn with 71 talents points when starting at level 80 like other characters and with no gear?
    First Question :

    World > PlayerCreateInfo

    Second Question :

    When you spawn it somewhere else and as 80 he'll have all talents already.
    no gear ? well that's controlled by DB & DBC

    DB : playercreateinfo_item
    DBC : CharStartOutfit.dbc ( Not needed it's just for how the char will look like )
    Last edited by JadaDev; 03-30-2020 at 07:32 PM.

  3. #3
    Thanks! It worked. Now I got this problem - when my DK spawn in Ogrimmar he has no spells and need a trainer. There is no DK trainer and Orgrimmar. So I have to make them spawn with Death Gate spell learned to be able to return back to Ebon Hold (because there is no portal to there which I can spawn). How to do that?


    INSERT INTO world.playercreateinfo_item (`race`, `class`, `itemid`, `amount`)
    VALUES (0, 6, 6948, 1);

    This script adds a heartstone to DKs when starting. How to edit it to make them starting with Death Gate spell learned.
    Last edited by Bokrael; 03-30-2020 at 08:20 PM.

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

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,568
    that's another story

    easiest way is to simply spawn the trainer somewhere in orgrimmar or you can do one of this :

    1. Custom spell ( playercreateinfo )
    2. Custom Item that learns players the gate and add it to the playercreateinfo ( item )

  5. #5
    Thanks again!

    Last question:

    How to create 2 NPCs. Gems and Glyphs. I got the ID's but I will take a lot of time to manually add a neutral faction NPC that already exist in the database, delete his items and manually add the gems or glyphs. Is there any ohter faster way? How can I use a script to add the NPC add in the database with all the items than just spawn it with .npc add?

    (Im with last AzerothCore 3.3.5)

  6. #6
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,568
    Quote Originally Posted by Bokrael View Post
    Thanks again!

    Last question:

    How to create 2 NPCs. Gems and Glyphs. I got the ID's but I will take a lot of time to manually add a neutral faction NPC that already exist in the database, delete his items and manually add the gems or glyphs. Is there any ohter faster way? How can I use a script to add the NPC add in the database with all the items than just spawn it with .npc add?

    (Im with last AzerothCore 3.3.5)
    http://www.ac-web.org/forums/showthr...tyCore-Vendors

    This is a full list of items and vendors you can later spawn

  7. #7
    I execute the script with no errors. Than I .npc add 500002 and get this?

    Spawn a creature by the given template id of #creatureid

    Any idea what went wrong?
    Last edited by Bokrael; 03-31-2020 at 03:47 PM.

  8. #8
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,568
    Quote Originally Posted by Bokrael View Post
    I execute the script with no errors. Than I .npc add 500002 and get this?

    Spawn a creature by the given template id of #creatureid

    Any idea what went wrong?
    you need to insert both files inside the rar than restart the server

  9. #9
    I only find 1 link for SQL file in your thread - http://www.mediafire.com/file/8wf65e...Spawn.sql/file ?

    I cannot find rar with two files?

  10. #10
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,568
    Quote Originally Posted by Bokrael View Post
    I only find 1 link for SQL file in your thread - http://www.mediafire.com/file/8wf65e...Spawn.sql/file ?

    I cannot find rar with two files?
    disappointed but whatever

    http://www.mediafire.com/file/9ip810...rp/Vendors.rar

    You need to read the thread not just search for download and do it ...

  11. #11
    Thanks! It worked fine!



    How to fix that script to spawn all classes in Dalaran, not just DK's:



    -- DK Alliance starting location (Dalaran)
    SET
    @MAP := 571,
    @ZONE := 4395,
    @X := 5813.555664,
    @Y := 448.814423,
    @Z := 658.750854,
    @O := 1.211951;

    UPDATE world.playercreateinfo SET map=@MAP, zone=@ZONE, position_X=@X, position_Y=@Y, position_Z=@Z, orientation=@O
    WHERE race IN(
    1, -- Human
    3, -- Dwarf
    4, -- Night Elf
    7, -- Gnome
    11) -- Draenei
    AND class IN(6);

    -- ---------------------------------------------------------------------------------------------------------------------

    -- DK Horde starting location (Dalaran)
    SET
    @MAP := 571,
    @ZONE := 4395,
    @X := 5813.555664,
    @Y := 448.814423,
    @Z := 658.750854,
    @O := 1.211951;

    UPDATE world.playercreateinfo SET map=@MAP, zone=@ZONE, position_X=@X, position_Y=@Y, position_Z=@Z, orientation=@O
    WHERE race IN(
    2, -- Orc
    5, -- Undead
    6, -- Tauren
    8, -- Troll
    10) -- Blood Elf
    AND class IN(6);

  12. #12
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,568
    Simple remove AND class IN(6)

    instead :

    -- All Alliance starting location (Dalaran)
    Code:
    SET
    @MAP := 571,
    @ZONE := 4395,
    @X := 5813.555664,
    @Y := 448.814423,
    @Z := 658.750854,
    @O := 1.211951;
    
    UPDATE world.playercreateinfo SET map=@MAP, zone=@ZONE, position_X=@X, position_Y=@Y, position_Z=@Z, orientation=@O
    WHERE race IN(
    1, -- Human
    3, -- Dwarf
    4, -- Night Elf
    7, -- Gnome
    11); -- Draenei
    -- All Horde starting location (Dalaran)
    Code:
    SET
    @MAP := 571,
    @ZONE := 4395,
    @X := 5813.555664,
    @Y := 448.814423,
    @Z := 658.750854,
    @O := 1.211951;
    
    UPDATE world.playercreateinfo SET map=@MAP, zone=@ZONE, position_X=@X, position_Y=@Y, position_Z=@Z, orientation=@O
    WHERE race IN(
    2, -- Orc
    5, -- Undead
    6, -- Tauren
    8, -- Troll
    10); -- Blood Elf

  13. #13

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    You are the best!

 

 

Posting Permissions

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