Cyberfreak

What exactly do i do with this?

What you are asking for.

Is this an SQL query?

Yes.

If so will it put all races at their preset starting points, and play the correct race intro?

It does not touch the intro itself, but maybe the intro depends to the starting location. Just give it a try.

As a personal opinion, you should not use a repack just because of problems while getting started. If you are yet not able to compile, install & configure a server by yourself, you are also not able to give support, so you better should work on your sql problem, its not a miracle to run a selfmade mangos server.

There is no ultimate way, its depending to the patch, so you maybe should ask the author, but the often used way is a patch file, which you can insert with "git apply filename.patch" in your mangos source directory.

If there is no self-made content, which by the way should always be prepared in sql statements, you simply can drop the whole mangos (and SD2) database and replace it with an actual version. This should not affect the account or character database. For this two, there are much less updates, which can easily be inserted one by one.

By the way the mangos project (and also other WoW Server) does not compare to emulation.

First of all, mangos is a software development and learning project, not a "wow server for dummies". You need advanced skills in handling your operation system and network administration, its much bulky than game server for counterstrike and other.

The wiki guides starting with download any needed programms and ending with running the compiled application, including everything like database structure. For installing any content DB like UDB there are own guides from specific developer, so where is your problem? And by the way, if you are asking for additional guide, it would be nice to know for which operating system.

8 realms is a huge load and you should really not run them as root, but there ist enough free ram. The processor is at full load, which does not suprise me with 8 realms. You simply should login at different compression level and looking for lags. If there are lags, you can try to reduce the compression rate, otherwise, you can set it higher if you want to save bandwith.

I need to get the scriptdev2 that corresponds to the version.

Good luck about that in the ScriptDev2 forum, and dont forget, its a pre-alpha development branch, not a well running productive system.

Project site: http://udb.no-ip.org/

But the link is still correct, there is only no new release since 09/2010.

It is just a blind shot, but maybe you tried this with a security level > 0 account? I did not check, but when it would not suprise me that a GM/Admin could learn more than the config given numbers of professions.

Does the server recognize any connection attempt in the console? Maybe the communication is blocked by a kind of firewall, you also can check if the ports are open.

Have you inserted the host name in the realmd.realmlist table?

UDB and other only provide the content in development language, which is english, but there are many localized cleaving like "name_loc3" which can be filled by independent projects and then will be automatically used for the client specified language.

And what is so "lol" about using a wrong update file?

If there is no installation guide from the patch author, it could be "git apply patchfile.patch" in your mangos source directory.

This are called NPCs. You properly inserted only the sql files from mangos, which only contains a structure, without any content. They like a blueprint for content database developer. Get a content database like UDB or YTDB, then you will get NPCs.

There is no DLL because you get an error through compiling. Are you sure you follow their installation guide correctly?

It is "set realmlist HOSTNAME" and you also need to edit the realmd.realmlist table if your server is not running on the same address than the client.

Turns out I had to go all the way back to the 0.5 folder and apply ALL characters patches through ALL folders.

This is only neccessary if you have existing characters in your character database. For beginning a new database its much easier to use "/mangos/sql/characters.sql", which contains everything from the beginning up to the last update, at the moment "11436_01".

Map & DBC Extractor

===================

Detected locale: zhCN

Opening /mnt/hgfs/World of Warcraft//Data/zhCN/locale-zhCN.MPQ

Opening /mnt/hgfs/World of Warcraft//Data/zhCN/patch-zhCN.MPQ

Opening /mnt/hgfs/World of Warcraft//Data/zhCN/patch-zhCN-2.MPQ

Opening /mnt/hgfs/World of Warcraft//Data/zhCN/patch-zhCN-3.MPQ

Fatal error: Invalid component.wow-zhCN.txt file format!

In the last line he should say "Detected client build: 12340", so you properly use a wrong client version or wrong extractor. But there could also appear error if...

- You trying to run the extractor without adequate access to the files and/or registry (Administrator rights in Windows)

- You trying to extract data from a game directory, which is not referenced as the "installed directory" in the registry. This can be easy fixed by starting the "launcher.exe" once.

- There are problems with any other subdirectories in the game folder. Before extracting, I suggest to remove any subfolder in the game directory except "Data". You do need them for extracting and they will be recreated when launching the game.

- The files in the data directory are corrupt. Unfortunately the "repair.exe" from any pre-Cataclysm client does not work anymore since the release of cataclysm, so you need to reinstall for checking this.

another question, why can't we use the dbc/maps/vmaps files directly generated by trinitycore tools?

Properly you can, but this is the MaNGOS project, developing their own stuff, and the main objective is learning how to handle something, not to copy some functional stuff from other.

As lynx already notices, in default the path to "DataDir" is ".", which means the DBCs... are in the same folder than the executable, in your case "/root/mangos-server/". What he wanted to say is that a tidy system is clearly arranged. It would be useful, but not neccessary to create a subfolder as the "DataDir", which is properly most time called "data".

mysql

^-- the command

-u root

^-- using the account root

<

^-- insert into database

create_mysql.sql

^-- the sql file which being inserted. In this special case, thile file create the databases characters, mangos, realmd, adding the user mangos and grant the new user full access to this 3 databases.

yes. By the way, try to read welcome sites, FAQs and announcements befor asking useless question.

Whatever you have created through the installation process. I suggest the whole mangos directory you downloaded from git and the target directory, if you stated one while compiling.

With basic linux knowledge like deleting a directory. I can not understand about the big problem there. By the way, you should not run a WoW server beside other game servers as Counterstrike, there are much more ressource hungry.

Have you applied the ScriptDev2 patch file? If yes, try to download SD2 again, maybe the download was corrupt or there was a syntax error in the files, which could be solved with the next update.