[Repack] HoB's BlizzLike MangosZero (1.12.1)

[St4rf1sh]

Releasing a fresh repack of a compiled MangosZero core+ScriptDev+Acid+Database and fixes if needed each time any mayor updates comes or if i fix a bug, since im using it on my own server aswell.

Information:

MangosZero rev 0119 (1.12.1)
Updated ZeroDB (rev 11)
BlizzLike no custom things added.
No Client Crash
Spells/Quests Working (Not all but most of it, if you encounter a spell bug please report it to me).
Waypoints Working
BattleGrounds Working.
Scripted Areas/Dungeons and Raids.
Pets almost working as they should (Report to me if you encounter a problem and i'll support).



Credits:

ZeroProject Team.
St4rf1sh for compiling and making minor fixes.

Download Links:

Version 1.0: FileBeam - Beam up that file Scottie!



Changelog:

v1.0: Release.

Updates:

2010-02-02: Pet feed working correctly.
2010-02-02: Big fix pack (Credits to TommyAnders)



Setup Guide:

1) Unrar the files downloaded from filebeam with your favorite unrar program, if you dont have one i'd suggest you to download WinRaR: http://www.rarlab.com/rar/wrar392b1.exe


2) I presume you already have MySQL else:
Windows 32-bit:
mysql-essential-5.1.43-win32.msi
Windows 64-bit: mysql-essential-5.1.43-winx64.msi
MAC OS X 32-bit: mysql-5.1.43-osx10.6-x86.dmg
MAC OS X 64-bit: mysql-5.1.43-osx10.6-x86_64.dmg
RedHat 32-bit RPM: MySQL-client-community-5.1.43-1.rhel5.i386.rpm
RedHat 64-bit RPM: MySQL-client-community-5.1.43-1.rhel5.x86_64.rpm

And a MySQL Manager i recommend SQLYog or Navicat.

3) After installing Configure it by choosing the following:
Standard Configuration.
Enable Remote Access while creating an user on your MySQL Server.
Remember your password as you will need it later on.

4) Now start up your MySQL manager and log in using your information.

5) Create your world database, you can name it whatever you like. After you created it right click on it and choose something like "Execute from sql batch" or "Restore from sql batch" and choose the world.sql located in your repack folder.

6) Create your realmd database, you can name it whatever you like. After created repeat step nr. 5 but choose realmd.sql instead.

7) Create your character database, this aswell you can name anything you like. After created repeat step nr. 5 but choose characters.sql instead.

Create your scriptdev database, you can name this one anything you want aswell. After created repeat step nr. 5 but choose scriptdev.sql instead.

9) Setup your configs which are located in the repack folder.
The most important lines to change are:

Mangosd.conf:

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

RealmID should be set to the same id defined in your Realmd database.

Set the LoginDatabaseInfo to:
127.0.0.1 : this should be the ip address of your MySQL Server.
3306 : this should be the port to your MySQL Server.
root : this should be the username to the MySQL Server.
mangos : this should be the password to the MySQL Server.
realmd : this is the database name of your realmd database.
Set the WorldDatabaseInfo to:
Same steps as above only change the database name to your world database.
Set the CharacterDatabase to:
Same steps as above only change the database name to your character database.

realmd.conf:

LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd"
LogsDir = ""
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "0.0.0.0"

LoginDatabaseInfo should be the same as the one in your mangosd.conf

scriptdevzero.conf:
Do the same as the others just use your scriptdev database instead.

10) Copy from the tools folder in your repack folder the ad.exe and the files in the vmap_extract_assembler_bin map to your world of warcraft 1.12.1 server and run them untill they are finished, then move the following folders to your Server folder(The one where your repack files is): dbc,maps,vmaps,buildings.

11) Ports you should have opened to run your server is: 3724 and 8085.

12) Start up mangosd.exe and realmd.exe and you got your server running! You can now create an account for yourself at the mangosd.exe console with the following command:
.account create username password
To set admin access:
.account set gmlevel username 3

[gaminino3]

Lol, Nice one man! Keep the real thing up as you can . I think many people from the old school will appreciate this

[Mitron]

NICE !
tho u might wanna fix this in World.SQL

Error occured at:2010-02-11 00:30:10
Line no.:1
Error Code: 1054 - Unknown column 'RequiredRaputationRank' in 'item_template'

Query:
insert into `game_event_gameobject` (`guid`, `event`) values('50965','1')

EDIT !
i uploaded whole error file if it could be to any help: http://filebeam.com/b7f7aae39c317f1756e7b62b6932cc04

[St4rf1sh]

hmm i will download the SQL's on my computer and fix it since my server computer is down atm and theres where my files are... i will come back with this shortly

[Ziddy1337]

Pretty nice although I'm using the one KrisBG released. +Rep

If anybody needs the 1.12.1 client you can get it here: World of Warcraft 1.12.1 Full Client + Patches (download torrent) - TPB (Credits to KrisBG)

[maroko]

Honor works? Honor Items? Enchart window, spell Curse of doom....
Ets
Its previous problems mangos Zero.
& In MZ the last rev is 164.
KrisBG is better rev. but it's a pitty that he dont update his revisions =/

[St4rf1sh]

have been rewriting a test version of the core for a couple of days now and trying to get honor working, i might be making some progress actually

edit: the reason i havent been updating later revs is becuase the things added are completly useless torwards gameplay last time i checked, im just waiting for a usefull update in the revision then im updating this

[Mitron]

when are this for 100% working so u actually can login ? (honor and such are not really important for me atm)

[St4rf1sh]

this should work to the point of logging in and play pretty bugfree running a server with it atm

[Mitron]

but the world DB is bugged ? ;o or you updated it ?

[sethfear]

had to whipe my system cause errors, so, now installing again at this moment from disk images and updating to 1.12.1 again. Gonna test out this pack and see where it takes me. If you are wanting any feedback, I will be more than happy to provide it. I was a feedback-guy for 3 different makes of TBC 2.4.3 servers about 2 years ago. Anyway, anyone who doesn't do feedback is just wasting time to be honest, because if something is wrong, you should always make a note of it, and try to get it fixed for later use. Concidering this is mangos, errors should be easy to update alone, but if not, I will definately be seeking support. Anything I find that I can make fix on, and do, I will also post with fix data-stings so everyone can use.
+rep and thanks a million

[kedaze]

hey man,great job with this post,how is going with the fixes?thanks =) + rep


oh,and why took so long to execute the sql's files??thanks

[Mitron]

so... when are the fix on the world DB SQL File coming ?

[Mrthomsen]

Yeah, could really use a fixed world.sql, i even went so far to reinstall my pc for this server.. xD

[anwes1]

Yeah, can some one fix the world.sql file? It would be really awsome!