Missing "World" in SQL menu

User Tag List

Results 1 to 12 of 12
  1. #1
    nobodylovesme's Avatar Member
    Reputation
    2
    Join Date
    Oct 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Missing "World" in SQL

    Hello guys!

    This is my first post ever here and I'm new into server making, scripting etc.

    So I'd be happy if you could help me out. I wanted to make am NPC for my server but when I read that I have to "execute the SQL files to the World Database." I don't know how to do that. I open up Navicat lite and all I have is (after connecting to the server):

    -arcemu
    -characters
    -information_schema
    -mysql

    But I saw in a vid that the guy making it has a "-World" aswell there. So why is it missing for me ?

    I hope you can help and excuse me for being a noob but I'm very very new to this .

    Thanks!

    Missing "World" in SQL
  2. #2
    Pedregon's Avatar Contributor
    Reputation
    221
    Join Date
    Aug 2007
    Posts
    705
    Thanks G/R
    0/2
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i't looks like "arcemu" for you is "world". Once you have the ".sql" file you can execute it into your "arcemu" database.
    Leecher - 08-30-2007 - Contributor - 07-23-2008
    Donator - 06-19-2009
    My website



  3. #3
    nobodylovesme's Avatar Member
    Reputation
    2
    Join Date
    Oct 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh I'd be happy if it would be like that but I cannot test it since whenever I'm going to execute it I always get an error that says: "[Msg] Finished - Unsuccessfully" at about 30%. Any help on this ?

  4. #4
    Pedregon's Avatar Contributor
    Reputation
    221
    Join Date
    Aug 2007
    Posts
    705
    Thanks G/R
    0/2
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can you post your sql?
    in the code tags?
    Leecher - 08-30-2007 - Contributor - 07-23-2008
    Donator - 06-19-2009
    My website



  5. #5
    nobodylovesme's Avatar Member
    Reputation
    2
    Join Date
    Oct 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    [Err] 1062 - Duplicate entry '551155' for key 1
    [Err] 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 ('551155', "TEST", "", '', '0', '10', '0', '0', '0', '0', '4527', '0', '0', '0', '1', '1', '0', '0');
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------

    This is what happens. I know it has to do something with the ID but I don't have a clue what exactly can be the problem.

  6. #6
    Pedregon's Avatar Contributor
    Reputation
    221
    Join Date
    Aug 2007
    Posts
    705
    Thanks G/R
    0/2
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try this one.

    Code:
    INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`, `questitem2`) VALUES ('551155', 'TEST', '', '', '0', '10', '0', '0', '0', '0', '4527', '0', '0', '0', '1', '1', '0', '0')
    Don't forget to delete your old one before executing it.
    Leecher - 08-30-2007 - Contributor - 07-23-2008
    Donator - 06-19-2009
    My website



  7. #7
    nobodylovesme's Avatar Member
    Reputation
    2
    Join Date
    Oct 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Pedregon View Post
    Try this one.

    Code:
    INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`, `questitem2`) VALUES ('551155', 'TEST', '', '', '0', '10', '0', '0', '0', '0', '4527', '0', '0', '0', '1', '1', '0', '0')
    Don't forget to delete your old one before executing it.
    [Err] 1054 - Unknown column 'killcredit1' in 'field list'
    [Err] INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`, `questitem2`) VALUES ('551155', 'TEST', '', '', '0', '10', '0', '0', '0', '0', '4527', '0', '0', '0', '1', '1', '0', '0')
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------

  8. #8
    Pedregon's Avatar Contributor
    Reputation
    221
    Join Date
    Aug 2007
    Posts
    705
    Thanks G/R
    0/2
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wow, alrighty. How updated is your arcemu/world database?
    Leecher - 08-30-2007 - Contributor - 07-23-2008
    Donator - 06-19-2009
    My website



  9. #9
    nobodylovesme's Avatar Member
    Reputation
    2
    Join Date
    Oct 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Pedregon View Post
    Wow, alrighty. How updated is your arcemu/world database?
    Dunno what you mean exactly but I used this guide to make the server : http://www.mmowned.com/forums/world-...te-server.html

    At the SVN Checkout thing I did the "Update Revision" thing to get back to 2.4.3. That's all I can tell you now lol.

  10. #10
    Pedregon's Avatar Contributor
    Reputation
    221
    Join Date
    Aug 2007
    Posts
    705
    Thanks G/R
    0/2
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wait so you want to make a 2.4.3 server?
    Leecher - 08-30-2007 - Contributor - 07-23-2008
    Donator - 06-19-2009
    My website



  11. #11
    nobodylovesme's Avatar Member
    Reputation
    2
    Join Date
    Oct 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Pedregon View Post
    Wait so you want to make a 2.4.3 server?
    Yes, exactly

  12. #12
    Pedregon's Avatar Contributor
    Reputation
    221
    Join Date
    Aug 2007
    Posts
    705
    Thanks G/R
    0/2
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try using Summit instead of ArcEmu for 2.4.3

    http://www.mmowned.com/forums/world-...summitemu.html
    Leecher - 08-30-2007 - Contributor - 07-23-2008
    Donator - 06-19-2009
    My website



Similar Threads

  1. Quotes from Steven Write
    By Amedis in forum Community Chat
    Replies: 2
    Last Post: 11-14-2022, 10:26 AM
  2. "Quotes"
    By Krazyglue in forum Community Chat
    Replies: 2
    Last Post: 11-16-2007, 09:36 PM
  3. WTB Powerleveling - Need Quotes!!
    By Drovos in forum Members Only Gold And Powerleveling Buy Sell
    Replies: 7
    Last Post: 10-14-2007, 10:26 AM
  4. Quote: For a Steam Account!
    By Obama in forum Members Only Accounts And CD Keys Buy Sell
    Replies: 0
    Last Post: 09-16-2007, 07:57 PM
  5. Funny GM quotes
    By shadowfox47 in forum World of Warcraft General
    Replies: 9
    Last Post: 08-13-2007, 07:24 PM
All times are GMT -5. The time now is 08:36 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