[Repack] Mangos Server for WotLK Beta Build 9095

[zackorion15]

Do not try this package if you do not know the following :
- How to import .sql files
- How to run a MySQL server
- Where your WotLK folder is or how to get it.
- What revision of WotLK you have

* This is a blizzlike repack
* There still a lot of errors on loading Mangosd, but it still gets to the command line.

Download Here

This repack contains :
- Mangos Core ver 6744 + SQLs ver 6767 w/ Patch 19.5
- Frozen DataBase ver 6.2 + Scripts ver 3h
- ScriptDev2 ver 707 w/ ACID 0.0.4

Install Guide :
1.) Open Maps and DBC Extracter and move the file ad.exe to your Wotlk folder after it updated to 3.0.3.9095, then run ad.exe. After it is done move the folders it made (maps and dbc) to your Mangos Server folder.

2.) Open MySQL Files (Database) and import the sql files that are in there. I am sure you know which ones go to which databases. (StartFresh will delete the databases there (mangos, realmd, characters, scriptdev2) and re-create them.)

3.) Open Mangos Server and edit the config files (mangosd.conf, realmd.conf, and scriptdev2.conf) to your needs.

"IP Address/Host Name:Port;DBUsername;DBPassword;database"

mangosd.conf
Line 48 : LoginDatabaseInfo = "127.0.0.1;3306;root; password;realmd"
Line 49 : WorldDatabaseInfo = "127.0.0.1;3306;root; password;mangosd"
Line 50 : CharacterDatabaseInfo = "127.0.0.1;3306;root; password;characters"

realmd.conf
Line 99 : LoginDatabaseInfo = "127.0.0.1;3306;root;password;realmd"

4.) Run Realmd.exe and Mangosd.exe
5.) Enjoy

FAQs :
Q: How do I create more accounts?
A: In the Mangosd.exe window (after it is done loading of course) type :
create accountname accountpassword
setexpansion accountname 2 (To enable WotLK) *If you don't do this the account will not be able to play some of the classes / races*
setgm accountname (0, 1, 2, or 3) * 3 = Admin 2 = GM 1 = Moderator 0 = Normal

Q: How do I change the server's name?
A: Open "realmlist" table in the "realmd" database and change the "name" cell.

Q: Why can't I connect to my private server?
A: Make sure your reamlist.wtf file in the wotlk folder is pointing towards 127.0.0.1 or the IP Address/Hostname the server is on.

Q: I am getting an "unable to validate game version" error, what do I do?!
A: Check you game version before setting up the server by running wotlk and then looking in the lower left hand side and verifying the last four numbers match this repack version (9061).

Q: How do I make the server public
A: Open realmd database then the realmlist table and change the address cell to your external IP or Hostname, also you may need to set your router to forward ports 3724 and 8085 to your computers current local ip.

Q: What are the commands for this server?
A: When you have Mangosd running type "help" and you will see a list of commands. Also when you want to know more about that command type "commandname help".

Q: Where is realmlist.wtf now? (For Beta Builds over 903
A: It has moved in your WotLK folder to \Data\enUS\. That means open your wotlk folder, then Data folder, then enUS folder, then open realmlist.wtf.

[Etna]

Somemore Information ?

[zackorion15]

My aren't you impatient. Hardly a few hours in and you expect a lot. If you don't know what to do please wait.

[hux77]

good guide yet needs a little more detail +Rep from me tho

[zackorion15]

good guide yet needs a little more detail +Rep from me tho

Clarify and thank you.

Note: I just added details for the ad.exe part.

[hux77]

u need to add a code list if posible since i have experience with other repacks and the .commands are way different, ur welcome

[zackorion15]

I will put in a FAQ about command list.

-edit-
Done tank you for the idea. I would figure it common sense, but that is because I am used to computers.

[hux77]

k thanks, ur welcome

[hux77]

nvm i just found out how to use SQl files

[zackorion15]

- This is not meant for people who do not know how to import files in to a SQL and or do not know how to install a SQL Server.

Sorry I do not want to teach ppl how to install mysql or how to import the files.

[Etna]

Hmm now it's good but still wanna know abit more about the Repack is it a Funserver or Blizzlike or what ?

[orrebrink]

[Err] 1062 - Duplicate entry '49200' for key 1
[Err] INSERT INTO `spell_proc_event` VALUES ('49200', '126', '0', '0', '0', '0', '1081472', '0', '0');
[Err] 1062 - Duplicate entry '50151' for key 1
[Err] INSERT INTO `spell_proc_event` VALUES ('50151', '126', '0', '0', '0', '0', '1081472', '0', '0');
[Err] 1062 - Duplicate entry '50152' for key 1
[Err] INSERT INTO `spell_proc_event` VALUES ('50152', '126', '0', '0', '0', '0', '1081472', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
a message i get when installing mangos.sql

what do i do ?

ohh and btw shouldnt there be a scriptdev2.conf in this pack ?

[zackorion15]

Hmm now it's good but still wanna know abit more about the Repack is it a Funserver or Blizzlike or what ?

Sorry unless ppl mention it has funlike things in the server I would assume ppl take it as blizzlike. I added it to notes so you all know. Thanks,.

[Err] 1062 - Duplicate entry '49200' for key 1
[Err] INSERT INTO `spell_proc_event` VALUES ('49200', '126', '0', '0', '0', '0', '1081472', '0', '0');
[Err] 1062 - Duplicate entry '50151' for key 1
[Err] INSERT INTO `spell_proc_event` VALUES ('50151', '126', '0', '0', '0', '0', '1081472', '0', '0');
[Err] 1062 - Duplicate entry '50152' for key 1
[Err] INSERT INTO `spell_proc_event` VALUES ('50152', '126', '0', '0', '0', '0', '1081472', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
a message i get when installing mangos.sql

what do i do ?

ohh and btw shouldnt there be a scriptdev2.conf in this pack ?

DOOH I accidently put up my OLD link instead. Sorry I have a premium Rapid Share account and I have many older versions. I thought that rapid share showed my uploads in order of date uploaded but it is by name and that is how I made this mistake. Sorry!

NEW LINK

Updated first post too, thanks

[Etna]

Hehe Good job now i wanna know how mutch it's Spawned ?

[zackorion15]

You sure are lazy to learn yourself you know that? You are the only person who has asked me this question before. The rest figure it out themselves. No offense just a personal observation.

Answer: I and NO ONE else knows that answer. It is BETA, which means it is not complete and it won't be even 50% complete till it is released as a release by blizzard (it = WotLK itself).