Missing "World" in SQL

[nobodylovesme]

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!

[Pedregon]

i't looks like "arcemu" for you is "world". Once you have the ".sql" file you can execute it into your "arcemu" database.

[nobodylovesme]

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 ?

[Pedregon]

Can you post your sql?
in the code tags?

[nobodylovesme]

[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.

[Pedregon]

Try this one.

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.

[nobodylovesme]

Try this one.

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
--------------------------------------------------

[Pedregon]

Wow, alrighty. How updated is your arcemu/world database?

[nobodylovesme]

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.

[Pedregon]

Wait so you want to make a 2.4.3 server?

[nobodylovesme]

Wait so you want to make a 2.4.3 server?

Yes, exactly

[Pedregon]

Try using Summit instead of ArcEmu for 2.4.3

http://www.mmowned.com/forums/world-...summitemu.html