MySQL importing anything menu

User Tag List

Results 1 to 5 of 5
  1. #1
    Vaknar's Avatar Member
    Reputation
    1
    Join Date
    Apr 2009
    Posts
    3
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL importing anything

    When I try to import anything to my database, whether it be with Navicat or HeidiSQL. It only displays "Duplicate enter '90007' (that's the entry ID) for key 1.
    Here's the thing I'm importing
    Code:
    insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
    values ('90007', "Overlord David", "Walsh", '', '0', '7', '0', '3', '0', '0', '3167', '0', '0', '0', '1', '1', '0', '0');
    
    insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
    values ('90007', '255', '255', '14', '435345', '35435', '35435', '3', '0', '500', '0', '5435', '34534', '0', '0', '0', '0', '60000', '390859', '0', '0', '0', '0', '0', '0', '0', '0', "0", '1', '44454350000', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

    MySQL importing anything
  2. #2
    Dynashock's Avatar Contributor

    Reputation
    176
    Join Date
    Nov 2007
    Posts
    203
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That's because there's already an entry 90007. Try changing the 90007 to another number, say 58000.

  3. #3
    Vaknar's Avatar Member
    Reputation
    1
    Join Date
    Apr 2009
    Posts
    3
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I changed it, and I get the same error for the number I put in to replace it. Yet there is no duplicate.

  4. #4
    Reflection's Avatar Legendary
    Reputation
    783
    Join Date
    Mar 2008
    Posts
    3,377
    Thanks G/R
    1/2
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Code:
    REPLACE INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
    values ('90007', "Overlord David", "Walsh", '', '0', '7', '0', '3', '0', '0', '3167', '0', '0', '0', '1', '1', '0', '0');
    
    REPLACE INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
    Use that and you will get no errors.

    Freelance Digital Artist
    https://reflectionartwork.deviantart.com
    You did not desert me
    My brothers in arms


  5. #5
    Vaknar's Avatar Member
    Reputation
    1
    Join Date
    Apr 2009
    Posts
    3
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That fixed what the query thing was saying, but when I attempt to add it to the database, it still says "Finished - Unsuccessful". Which was the reason I brought it into the query thing.

    EDIT: Never mind, the money value was too high. Thanks reflection.
    Last edited by Vaknar; 06-06-2009 at 05:07 AM.

Similar Threads

  1. Mod that queues u for a BG without u clicking anything?
    By JoKeR` in forum World of Warcraft General
    Replies: 4
    Last Post: 09-05-2006, 11:43 AM
  2. [Macro] Track anything?
    By RichyG in forum World of Warcraft Exploits
    Replies: 7
    Last Post: 08-08-2006, 06:27 PM
  3. Edit any model to anything
    By Dregonx in forum World of Warcraft Exploits
    Replies: 23
    Last Post: 06-25-2006, 02:07 AM
  4. Exploit almost anything without being banned!
    By Tbone in forum World of Warcraft Exploits
    Replies: 21
    Last Post: 06-20-2006, 06:57 AM
  5. Need to level with out doing anything bad ??
    By ineedthis in forum World of Warcraft General
    Replies: 6
    Last Post: 04-29-2006, 10:58 AM
All times are GMT -5. The time now is 04:01 AM. 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