Mangos Zero Compiling

[DoxramosPS]

Mangos Zero for build 5875 6005
(1.12 Client)

Okay, so it's been a while since I put a new guide up, so we're going to go with the lovable mangos zero!
Credit goes to
The MangosDev team for a great job on the core so far.
TheLuda for a great Database

-----------------------------------------------------------------------------------

Step One
The Software

Some kind of SQL administrator tool. I myself like to use Navicat
Navicat Download
Or you can just torrent it, but you didn't hear that from me.

Alright, so if we need a SQL admin tool, there's a good chance that we'll need a SQL server I'm assuming? I prefer to use MySQL 5.5
MySQL :: Download MySQL Community Server
Okay, so choose the one that looks best to you and go ahead and download then configure, I prefer to install as a windows service, but all in all it's up to you, set it up the way you want to it's all pretty self explanitory; I personally would wait till Stage 3 When I say to configure your SQL server to configure it since you won't need it running int he beginning steps.

Now we go onto Microsoft Visual Basic and Microsoft Visual C++, without Basic the server will not start after it's been configured and if you don't have C++, Well, just tell me how that works for you. Make sure that you use 2010, I've had errors with anything older and I see plenty of posts on errors.
Visual Basic Express

Visual C++ Express
I linked the free editions, if you decide that you would rather have the paid editions than that's on you.

TortoiseGit
TortoiseGit
If you need the 32 bit or the 64 bit version I couldn't really tell you, so if you're compiling I really hope that you already know the answer to that.

----------------------------------------------------------------------------------

Step Two
Retrieving the Core

Retrieving the files.

The first code we're going to retrieve is for the server core. Right click on your desktop and select "Git Clone" Inside of URL you will now type
Mangos Zero Core:

git://github.com/mangos/zero.git

Press okay and lets move onto the next code that we'll need, follow the same steps as above, just change the url repository of the Git Clone
Mangos DB:

git://github.com/TheLuda/mangos-zero-database.git

You know the drill. Same steps as the last one, but now it's for compiling the scripts. I'm still working on getting them to not lock up my computer and give me errors when I compile them, but if you think you can jump on over it then I sure won't tell you not to try. (I think the issue lies in 64 bit compiling)
Scriptdevzero:

git://github.com/scriptdev/scriptdevzero.git

----------------------------------------------------------------------------------

Step Three
Compiling the Core

Open your zero folder and then navigate into the win folder. Open Mangosdvc100 with Visual C++
Make sure that the top reads
Release "Your platform"
Go to Debug---->Build Solution and let it run it's course. This will take some time, so if at this point you have not set up your SQL server this would be a good time to do so.

At this point it will still be compiling after you've set up your SQL server, so go to
"zero/contrib/extractor" and copy ad.exe into your World of Warcraft folder and run it; it will begin to extract the DBC files as well as the maps files.

Now while it does that go to "zero\contrib\vmap_extract_assembler_bin"
Copy "makevmaps_SIMPLE.bat" into your World of Warcraft Directory and let it run alongside everything else. All of these together should take some time. (It takes me a little while with 16 gigs of RAM running, so if you're running a low amount of RAM you may want to just do them one at a time.)

Create a new folder; We're going to say it's on your desktop and is called "My Server".
**=32 or 64
Go to "zero\bin\Win**_Release" and copy the contents from there to "My Server" Feel free to only copy the .exe files and the .dll files that are in the release; now copy "maps" "dbc" and "vmaps" from your World of Warcraft folder and move them into "My Server"
**=mangosd or realmd
You also need to copy "mangosd.conf.dist" and "realmd.conf.dist" From "zero/src/**"

----------------------------------------------------------------------------------

Step Four
Setting up your database

Open Navicat and connect to your server with the settings you established earlier and create database

realmd
mangos
characters
scriptdevzero

Copy the contents from your database git folder into the proper query.
IE

zp_realm=Copy all contents into the realmd Query Section

zp_world=Copy all contents into the mangos Query Section

zp_characters=Copy all contents into the characters Query Section

zp_scripts=Copy all contents into the scriptdevzero Query Section

You will now go to schedule on the top right of the navicat menu and add all of the queries and tell it to start.

----------------------------------------------------------------------------------

Step Five
Configuring your Conf files and starting the server

You've just about finished, but have a few parts left that you need to finish up on.

Open mangosd.conf.dist and navigate to this section
Change the red color to your mysql root and the green to your mysql password

RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo     = "127.0.0.1;3306;mangos;mangos;realmd"
WorldDatabaseInfo     = "127.0.0.1;3306;mangos;mangos;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;mangos;mangos;characters"
LoginDatabaseConnections = 1
WorldDatabaseConnections = 1
CharacterDatabaseConnections = 1
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

Save as "mangosd.conf" and close

Now open realmd.conf.dist and navigate to the bottom and change the colored portions the same way as before.

LoginDatabaseInfo = "127.0.0.1;3306;mangos;mangos;realmd"
LogsDir = ""
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "0.0.0.0"
PidFile = ""
LogLevel = 0
LogTime = 0
LogFile = "Realmd.log"
LogTimestamp = 0
LogFileLevel = 0
LogColors = ""
UseProcessors = 0
ProcessPriority = 1
WaitAtStartupError = 0
RealmsStateUpdateDelay = 20
WrongPass.MaxCount = 0
WrongPass.BanTime = 600
WrongPass.BanType = 0

Save as "realmd.conf" and close.

Start your server either through the exe files or through command prompt.

Command prompt method:
Open a Command Prompt Terminal

cd desktop/My Server

Press enter

realmd

Press enter

Open another Command Prompt Terminal

cd desktop/My Server

Press enter

mangosd

Press enter

I recommend starting your server this way because you can see any errors that may have happened without having to open your server error log. If you have any issues please feel free to ask for help, but if you followed this guide then there should be no problems.

[dmcg]

thanks for the tut I believe i've follwed it exactly but im having a problem getting my mangosd.exe to work heres the log im getting

2011-06-04 12:51:23 Using configuration file mangosd.conf.
2011-06-04 12:51:23 World Database: 127.0.0.1;3306;root;xxx;mangos, total connections: 2
2011-06-04 12:51:23 MySQL client library: 5.1.49
2011-06-04 12:51:23 MySQL server ver: 5.5.13
2011-06-04 12:51:23 MySQL client library: 5.1.49
2011-06-04 12:51:23 MySQL server ver: 5.5.13
2011-06-04 12:51:23 ERROR:SQL: SELECT required_z1730_xxxxx_01_mangos_instance_template FROM db_version LIMIT 1
2011-06-04 12:51:23 ERROR:query ERROR: Unknown column 'required_z1730_xxxxx_01_mangos_instance_template' in 'field list'
2011-06-04 12:51:23 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!
2011-06-04 12:51:23 ERROR:
2011-06-04 12:51:23 ERROR: [A] You have: --> `z1614_s1120_02_mangos_mangos_string.sql`
2011-06-04 12:51:23 ERROR:
2011-06-04 12:51:23 ERROR: [B] You need: --> `z1730_xxxxx_01_mangos_instance_template.sql`
2011-06-04 12:51:23 ERROR:
2011-06-04 12:51:23 ERROR:You must apply all updates after [A] to [B] to use mangos with this database.
2011-06-04 12:51:23 ERROR:These updates are included in the sql/updates folder.
2011-06-04 12:51:23 ERROR:Please read the included [README] in sql/updates for instructions on updating.

[kallefleetwood123]

i also have he same problem how to fix it?

[freeman725]

Good guide. +2 rep from me. Blue text doesn't contrast very well though. Seeing that the only problems people are having are with sql update errors, add a quick tutorial on how to update the db to match the core and it will be golden. Cheers!

To the people getting errors:

2011-06-04 12:51:23 ERROR:SQL: SELECT required_z1730_xxxxx_01_mangos_instance_template FROM db_version LIMIT 1
2011-06-04 12:51:23 ERROR:query ERROR: Unknown column 'required_z1730_xxxxx_01_mangos_instance_template' in 'field list'
2011-06-04 12:51:23 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!
2011-06-04 12:51:23 ERROR:
2011-06-04 12:51:23 ERROR: [A] You have: --> `z1614_s1120_02_mangos_mangos_string.sql`
2011-06-04 12:51:23 ERROR:
2011-06-04 12:51:23 ERROR: [B] You need: --> `z1730_xxxxx_01_mangos_instance_template.sql`
2011-06-04 12:51:23 ERROR:
2011-06-04 12:51:23 ERROR:You must apply all updates after [A] to [B] to use mangos with this database.
2011-06-04 12:51:23 ERROR:These updates are included in the sql/updates folder.
2011-06-04 12:51:23 ERROR:Please read the included [README] in sql/updates for instructions on updating.

This is your error. There are many like it but this one is yours. The error is your friend although it may not appear to be. Read the error. The error will reveal the solution to your problem. Perhaps the README file will be of some service to you as well.

End of subliminal message.

[xXGRiMXx]

my compile skips all the projects.......

[kallefleetwood123]

Hey Guys! i have finally find the problem..

This is how to guys do. You open your navicat or what you using open mangos execuete batch file and go the my Server/zero/sql/updates and on the errors you got it says: You must apply all updates after [A] to [B] to use mangos with this database. so we got

A: z1614_s1120_02_mangos_mangos_string.sql Find that sql in zero/sql/updates and execute the one who is below that one, is z1661_s1188_01_mangos_item_template and then just execute all sql below that and finally execute z1730_xxxxx_01_mangos_instance_template.sql and you have update the DB
Sorry for my english hope you guys understand

[freeman725]

my compile skips all the projects.......

If you're using visual express to compile, make sure you're not trying to compile in 64 bit. Unfortunately, the express version doesn't allow 64 bit compiling. You have to buy/"obtain" visual studio to compile in 64 bit.

[eclipz13]

error with git host.. i used this one
git://github.com/PanteraPolnocy/MaNGOS-Zero.git

Here is my issue now
1:Fresh install / update to 1.12.1
2:Fallowed this tutorial
3:After i see "Network Thread Starting" i type in "account create lostboy 13"
4:Then i type in "account set gm lostboy 3"
5:checked to make sure ports 3724/3306/8080/8085/8129/8093/6112/6881-699/3036/8050
in both UDP and TCP were open
6:Opened up wow. tried to log in and it just says "handshaking"

P.S I just want to use this server inbound LAN without internet so im not using my-ip just 192.168.2.13 "this laptop that is hostin"

what do i set my realmlist as "127.0.0.1/localhost/192.168.2.13" ?

[freeman725]

error with git host.. i used this one
git://github.com/PanteraPolnocy/MaNGOS-Zero.git

Here is my issue now
1:Fresh install / update to 1.12.1
2:Fallowed this tutorial
3:After i see "Network Thread Starting" i type in "account create lostboy 13"
4:Then i type in "account set gm lostboy 3"
5:checked to make sure ports 3724/3306/8080/8085/8129/8093/6112/6881-699/3036/8050
in both UDP and TCP were open
6:Opened up wow. tried to log in and it just says "handshaking"

P.S I just want to use this server inbound LAN without internet so im not using my-ip just 192.168.2.13 "this laptop that is hostin"

what do i set my realmlist as "127.0.0.1/localhost/192.168.2.13" ?

When connecting on a lan, you still use 127.0.0.1 on the server machine. Any client on the lan would use the server's router assigned ip, 192.168.2.13. You don't have to forward ports for lan connections being as you have no outside connections going through the router. Make sure your configs are right. If you're uncertain, post the realmd config.

[eclipz13]

i set the name as root and the pw as 13 and have changed it back and forth from "192.168.2.13/127.0.0.1/localhost/NeVeRlAnD/192.168.2.1" and keep gettin "handshaking" .. anything i can check in nav to see what i may be doin wrong?
P.S I also tried a Bind IP to 192.168.2.13 and still handshaking

LoginDatabaseInfo = "127.0.0.1;3306;root;13;realmd"
LogsDir = "Logs"
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "0.0.0.0"
PidFile = ""
LogLevel = 0
LogTime = 0
LogFile = "Realmd.log"
LogTimestamp = 0
LogFileLevel = 0
LogColors = ""
UseProcessors = 0
ProcessPriority = 1
WaitAtStartupError = 0
RealmsStateUpdateDelay = 20
WrongPass.MaxCount = 0
WrongPass.BanTime = 600
WrongPass.BanType = 0

in my mangosd

RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;13;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;13;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;13;characters"
LoginDatabaseConnections = 1
WorldDatabaseConnections = 1
CharacterDatabaseConnections = 1
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

[eclipz13]

Its alright i guess the DB on yer link is screwed because i just got one from getmangos and it works fine. but i will still give +rep for posting the tut

[EspPlay]

You should update the whole post.
This is outdated.

Now while it does that go to "zero\contrib\vmap_extract_assembler_bin"
Copy "makevmaps_SIMPLE.bat" into your World of Warcraft Directory and let it run alongside everything else. All of these together should take some time. (It takes me a little while with 16 gigs of RAM running, so if you're running a low amount of RAM you may want to just do them one at a time.)

And what exactly did we need this; "Mangosdvc100"
Build it? for what reason? You state no use for it.


Picture not related.

[EspPlay]

And oh, by the record;


Anyway,
git://github.com/TheLuda/mangos-zero-database.git
is empty.

Use;
git://github.com/mangos-zero/database.git
instead.

And change everything in this post to;
mangos-zero 
===========

*mangos-zero* has been **moved** into its' own [organization][1] on [github][101],
and finally will be one with all the other tools you need to enjoy a classic
[World of Warcaft][50] experience for *World of Warcraft Client Patch 1.12* -
[_Drums of War_][51].


**YES, WE HAVE MOVED TO [FRESH GROUNDS][10], WITH [FRESH FEATURES][11], AND
EVEN [FRESHER CONTENT][12].**

[1]: https://github.com/mangos-zero "mangos-zero"

[10]: https://github.com/mangos-zero/server "mangos zero"
[11]: https://github.com/mangos-zero/scriptdev0 "script bindings"
[12]: https://github.com/mangos-zero/database "content database"

[EspPlay]

People basicly know nothing about this, nor use this forum?
-.-

[thesixth]

I'm stuck at success with both the master-branch and the dev-branch :\