NPC spawning problems using SQL to code menu

Shout-Out

User Tag List

Results 1 to 12 of 12
  1. #1
    ddftrick's Avatar Member
    Reputation
    1
    Join Date
    Mar 2008
    Posts
    35
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    NPC spawning problems using SQL to code

    I am really only having two problems with spawning NPCs that I create using SQL, as appose to WoW-V vendor creator.

    1: NPC's spawn with only 1% health and do not regen up to 100%. They just stay at 1% the entire time.

    2: I can't figure out what I have to do to get the mob to have the golden elite dragon display.

    I have tried searching the forums for these solutions already, but I am either to incompetent to find them, or they are not listed. Most likely the former, but any help would be appreciated.

    NPC spawning problems using SQL to code
  2. #2
    2dgreengiant's Avatar ★ Elder ★


    Reputation
    1192
    Join Date
    Feb 2007
    Posts
    7,129
    Thanks G/R
    1/3
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    use ade to create your mobs, its the easiest way than manually creating them
    If you need me you have my skype, if you don't have my skype then you don't need me.

  3. #3
    ddftrick's Avatar Member
    Reputation
    1
    Join Date
    Mar 2008
    Posts
    35
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the info. I just did a search and see what your talking about. I'll give it a shot and if I got problems I'll just post in this thread again.

    +Rep for the help

  4. #4
    ddftrick's Avatar Member
    Reputation
    1
    Join Date
    Mar 2008
    Posts
    35
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Using ADE I have been able to get my NPCs to spawn with full health, but I still can't get it to flag the mobs with the elite golden dragon even though I have selected elite while creating the npc.

    If I choose boss I get the golden elite dragon along with the skull to block out the level, but I can't get mobs selected any other option (elite, elite rare, elite rare?) to get that golden elite dragon graphic. Anyone else had this problem and figured out how to fix it?

  5. #5
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by ddftrick View Post
    Using ADE I have been able to get my NPCs to spawn with full health, but I still can't get it to flag the mobs with the elite golden dragon even though I have selected elite while creating the npc.

    If I choose boss I get the golden elite dragon along with the skull to block out the level, but I can't get mobs selected any other option (elite, elite rare, elite rare?) to get that golden elite dragon graphic. Anyone else had this problem and figured out how to fix it?
    hmm it should work with ADE but if it doesnt check the creature tables and do it manualy...

    how? find the "rank" column and put in one of these values:
    0-Normal
    1-Elite
    2-RareElite
    3-WorldBoss
    4-Rare
    Last edited by latruwski; 04-11-2008 at 10:46 AM.

  6. #6
    Lich King's Avatar Contributor
    Reputation
    100
    Join Date
    May 2007
    Posts
    911
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There's a scroll down menu on ADE for elite, boss, normal, rare, etc.

  7. #7
    ddftrick's Avatar Member
    Reputation
    1
    Join Date
    Mar 2008
    Posts
    35
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by latruwski View Post
    hmm it should work with ADE but if it doesnt check the creature tables and do it manualy...

    how? find the "rank" column and put in one of these values:
    0-Normal
    1-Elite
    2-RareElite
    3-WorldBoss
    4-Rare
    Tried doing it manually in SQL, but still nothing. The mob has 1 under its rank column but for some reason he is still non elite in game.

  8. #8
    Lich King's Avatar Contributor
    Reputation
    100
    Join Date
    May 2007
    Posts
    911
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh, that sometimes happens to me. Sometimes when I edit a creature, the edits don't show up in-game, try making a completely new creature with ADE and use the drop down menu to select it from the begining

  9. #9
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by TheBetrayer View Post
    Oh, that sometimes happens to me. Sometimes when I edit a creature, the edits don't show up in-game, try making a completely new creature with ADE and use the drop down menu to select it from the begining
    or just delete your cache and reload the table and see

  10. #10
    Lich King's Avatar Contributor
    Reputation
    100
    Join Date
    May 2007
    Posts
    911
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by latruwski View Post
    or just delete your cache and reload the table and see
    Oh yeah.. the cache.. thanks, I forgot about that

  11. #11
    join's Avatar Member
    Reputation
    26
    Join Date
    Dec 2007
    Posts
    153
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    sorry that i souns n00b, but how to fix that the NPC spawns? i had made a npc and everything is fine, but wen i going to add it just say invalid entry id, and what is the command to reload npcs? please help xD


  12. #12
    Shellie_p's Avatar Member
    Reputation
    1
    Join Date
    Mar 2008
    Posts
    1
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    in game .reloadtable creature_names
    .reloadtable creature_proto

    and if its a vendor that you've added items to in the DB
    .reloadtable vendors

Similar Threads

  1. [ArcEmu] Problem with .npc spawn
    By copyright6 in forum WoW EMU Questions & Requests
    Replies: 30
    Last Post: 04-15-2010, 10:23 AM
  2. got problems importing SQL or TXT??
    By Rouslan in forum World of Warcraft Emulator Servers
    Replies: 0
    Last Post: 11-30-2007, 12:11 PM
  3. [HELP] Creature Spawn Problems
    By Matis02 in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 11-23-2007, 07:32 AM
  4. npc spawn command not working
    By Ganoran in forum World of Warcraft Emulator Servers
    Replies: 6
    Last Post: 11-01-2007, 09:06 PM
  5. [Ascent] List of Class Trainers and Weapon Masters NPC spawn ID's
    By mkenzi in forum World of Warcraft Emulator Servers
    Replies: 5
    Last Post: 10-21-2007, 11:41 AM
All times are GMT -5. The time now is 01:06 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search