Affected 0 rows when importing SQL NPC? menu

User Tag List

Results 1 to 4 of 4
  1. #1
    TypicalPlayer's Avatar Member
    Reputation
    1
    Join Date
    Sep 2017
    Posts
    3
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Affected 0 rows when importing SQL NPC?

    I am trying to import a test NPC that I created using Mindsear's Legion DB Editor, but I keep getting the "Affected 0 Rows" outcome from heidisql. I can't find anything in the code that could cause this, what is happening?

    Code:
    UPDATE world.creature_template SET `difficulty_entry_1`=0, `difficulty_entry_2`=0, `difficulty_entry_3`=0, `KillCredit1`=31210, `KillCredit2`=0, `modelid1`=24949, `modelid2`=0, `modelid3`=0, `modelid4`=0, `name`="Arthas", `femaleName`="", `subname`="Prince of Lordaeron", `IconName`="", `gossip_menu_id`=9653, `minlevel`=80, `maxlevel`=80, `HealthScalingExpansion`=2, `RequiredExpansion`=0, `VignetteID`=0, `faction`=2076, `npcflag`=1, `speed_walk`=1, `speed_run`=1.14286, `scale`=1, `rank`=1, `dmgschool`=0, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `BaseVariance`=1, `RangeVariance`=1, `unit_class`=4, `unit_flags`=33536, `unit_flags2`=2099200, `unit_flags3`=0, `dynamicflags`=0, `family`=0, `trainer_class`=0, `type`=7, `type_flags`=4096, `type_flags2`=0, `lootid`=0, `pickpocketloot`=0, `skinloot`=0, `resistance1`=0, `resistance2`=0, `resistance3`=0, `resistance4`=0, `resistance5`=0, `resistance6`=0, `spell1`=0, `spell2`=0, `spell3`=0, `spell4`=0, `spell5`=0, `spell6`=0, `spell7`=0, `spell8`=0, `VehicleId`=0, `mingold`=0, `maxgold`=0, `AIName`="", `MovementType`=0, `InhabitType`=0, `HoverHeight`=1, `HealthModifier`=3.5, `HealthModifierExtra`=1, `ManaModifier`=2, `ManaModifierExtra`=1, `ArmorModifier`=1, `DamageModifier`=7.5, `ExperienceModifier`=1, `RacialLeader`=0, `movementId`=0, `RegenHealth`=1, `mechanic_immune_mask`=0, `flags_extra`=0, `ScriptName`="npc_arthas", `VerifiedBuild`=23911 WHERE entry=20;

    Affected 0 rows when importing SQL NPC?
  2. #2
    brotalnia's Avatar Elite User
    Reputation
    497
    Join Date
    Apr 2009
    Posts
    473
    Thanks G/R
    26/300
    Trade Feedback
    0 (0%)
    Mentioned
    14 Post(s)
    Tagged
    2 Thread(s)
    The "UPDATE" statement updates an existing entry. You should watch a tutorial on SQL syntax. You need to use an "INSERT" in this case.

  3. Thanks TypicalPlayer (1 members gave Thanks to brotalnia for this useful post)
  4. #3
    TypicalPlayer's Avatar Member
    Reputation
    1
    Join Date
    Sep 2017
    Posts
    3
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you, I got the code from an NPC creator, which put it in this format. But now I know

  5. #4
    Harambeqt's Avatar Elite User CoreCoins Purchaser
    Reputation
    333
    Join Date
    Mar 2010
    Posts
    1,206
    Thanks G/R
    9/29
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by TypicalPlayer View Post
    Thank you, I got the code from an NPC creator, which put it in this format. But now I know
    'REPLACE INTO' will update(replace) and if the entry does not exist it will insert.
    Support the #1 WoW Emulator:
    http://arcemu.org/
    https://github.com/arcemu/arcemu
    - - -

Similar Threads

  1. [SQL] Heidi SQL NPC respawn + NPC's to attack each other, Not working.
    By Zaty in forum WoW EMU Questions & Requests
    Replies: 5
    Last Post: 07-20-2013, 05:36 PM
  2. Npc sql import
    By 888solomon in forum WoW EMU Questions & Requests
    Replies: 1
    Last Post: 09-17-2009, 05:09 AM
  3. Error importing sql
    By theory18 in forum WoW EMU Questions & Requests
    Replies: 6
    Last Post: 05-30-2009, 09:36 AM
  4. 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
  5. custom/spawned npc wont save when i spawned them
    By bjorn11 in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 11-19-2007, 10:04 AM
All times are GMT -5. The time now is 12:13 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search