[Guide] How to Install Moffeman's Repack for 9183!

[Moffeman]

Moffeman's Repack 9138
Due to people who having problems how to install the repack I'm making a guide for it too to make it easier for you guys Hope you like it.

You need:
MySQL Server 5.0: MySQL :: The world's most popular open source database
Navicat: www.navicat.com
My Repack: http://www.mmowned.com/forums/emulat...ck-9138-a.html (Check Download links. All info about the repack is there too)

Download all of it.
Extract my repack to your desktop for example.
Install MySQL Server 5.0
When it wants to configure:

1. Standard Configuration
2. Press Next and then choose "Install as Windows Service" and "Launch the MySQL Server automatically"
3. Press Next and choose a password and I recommend enable root access from remote machines if you are gonna have devs for the DB or something.
4. Press Next and press "Execute" (When it's done just install navicat

When installed navicat. Open it, make a new connection, choose a good connection name like "Private Server"
Use the same host as already written "Localhost" and port "3306"
Also, use "root" as username and your MySQL Password as password.
Then press test connection. If it says it is working, then you got it working, if it says it cant connect, you did something wrong.

Press OK If it works and your connection is created.

Open the connection by double clicking it.
Then rightclick the connection and press "New Database"
Choose a good name like "WotLK" and then press OK.
Now right click your database called "WotLK" and press "Execute Batch File"
Browse until you find my repack folder and choose Database-WotLK.sql and then execute it.

Wait until its done (It might take a while)
When it's done. Make sure you have WotLK patch 3.0.3 9138.
Then in my repack folder, open the folder called "Tools".
Copy and paste the "ad.exe" inside your WoW Folder and run it.
It will extract maps and dbc. When it's done:
Move the maps folder to my repack main folder.
Then it's done.
NOTE: DO NOT MOVE THE DBC FOLDER! USE THE DBC FOLDER THAT CAME WITH THE REPACK!
Now open your config files and start with mangosd.conf
Look for:

RealmID = 1

DataDir = "."

LogsDir = ""

LoginDatabaseInfo = "127.0.0.1;3306;root;password;database"

WorldDatabaseInfo = "127.0.0.1;3306;root;password;database"
CharacterDatabaseInfo = "127.0.0.1;3306;root;password;database"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

Now change the "password" to your mysql password.

when that is done, change "database" to your database name you created in navicat. If you followed mine it should be changed to "WotLK"

There we go, now we're done with the mangosd.conf

Save & Close.
Open realmd.conf
and look for:

LoginDatabaseInfo = "127.0.0.1;3306;root;password;database"

LogsDir = ""

MaxPingTime = 30

RealmServerPort = 3724

BindIP = "127.0.0.1"
PidFile = ""
LogLevel = 0
LogTime = 0
LogFile = "Realmd.log"
LogTimestamp = 0
LogFileLevel = 0
LogColors = ""
UseProcessors = 0
ProcessPriority = 1
RealmsStateUpdateDelay = 20
WrongPass.MaxCount = 0
WrongPass.BanTime = 600
WrongPass.BanType = 0

Change "password" to your mysql password

and database to your db as you did in mangosd.conf

"WotLK"

Save & Close when done.
Ok, everything is done now.

Open MaNGOS.exe (The restarter) and then everything should start.

When you hear a beep sound, the server is started. Then open the mangosd.exe console.

Write:

create Moffeman 123456

(It will create an account with username Moffeman and password 123456)
(change if you want)
then write:
setexpansion Moffeman 2
(It will set account name Moffeman to WotLK)
then write:
setgm Moffeman 4
(It will set the account name Moffeman to admin account)

There we go, an account.

Now you got a server working.

Change your realmlist to 127.0.0.1 and login

NOTE: In your mangosd.conf file, look for "MOTD" make sure you change it or else the server will crash upon start.

NOTE2: Make sure you open your database inside navicat and right click the table called "Groups" and press "Empty Table" to make the server work too

If you need further help, check the main repack thread replies, it might help you!

Hope it helps you further!

---I don't know whats wrong, i couldn't upload any pics, im sorry. but i guess it will work anyway ---

[Daiigon]

Nice guide, I read your first post under the release section when you released this, and I had some trouble. But this is a nice guide. Never really played with MaNGOS before, always used ascent so this guide helped me out lol.

Setting everything up now

+Rep

[xorec]

I love it!! , Problem is that I dont know what I empty cusse its a lot of errors when I start! :O spell_proc_events (dosen't exist) and creature_add_on lot errors and Npc trainer errors and game_objext_script is sick much error.. but I can still run it but whit many errors

[xorec]

and how do you reload accounts :O ?

[Daiigon]

How long does the sql file take to execute, cause its been awhile and its not even half-way done lol

[Megosh]

Love the server... everything working great.... except under AQ. You have so much random stuff down there that my server stops connecting with my client. (however it doesnt kick me) no matter how many times you restart the pc/server it still doesnt fix the kick untill you do a .tele command (commands still work on the client but nothing displays on the player) when you .tele you dont move but when you relog you're wherever you tele'd. its rather odd lol. Its really odd but i dont have to worry about it till someone decides to hack their way behind aq. But... when they get there their char will lock up and they wont be able to use them again.

Yea... the SQL files is monstrous, just give it time.

---
Update.

if you want to host this server publicly you need to change your realmd.conf:

From:

...
LoginDatabaseInfo = "127.0.0.1;3306;root;XXXX;XXXX"
LogsDir = ""
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "127.0.0.1"
PidFile = ""
...

To:

...
LoginDatabaseInfo = "127.0.0.1;3306;root;XXXX;XXXX"
LogsDir = ""
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "0.0.0.0"
PidFile = ""
...

The way its set currently only allows connections locally (127.0.0.1). Changing it to 0.0.0.0 allows anyone to connect.

You'll also need to change your realmlist table... the rest is straight forward.

-----

Hey Moff... what happened to your server? I used to mess around on it and i haven't been able to connect for a while. I would love to help you get all the spawns/items/quests/etc together for your server/next repack if your interested. Send me a PM.

-Megosh

[foxtrot08]

Does it have to be Wow 3.0.3 (913? Because i have Wow 3.0.3 (9183). Will it function properly?

The sql takes ages, 400+ Mb. xD

[Daiigon]

Oh ok, Thanks Megosh, I was curious about it lol, I didnt know if the SQL file was just HUGE or messed up lol. Its still loading atm, hopefully it will finish soon.

Yeah I was wondering about hosting it publically because I was gonna use my hamachi IP but I didnt know 0.0.0.0 would allow me to host it so that should help knowing that lol. First time using MaNGOS

So used to seting up ascent servers and how to configure them I thought it would be the same lol =)

[Boiko7530bg]

Pls help i made the server but when i make acc and pass from mangosd.exe and when i log in wow it says wrong acc and pass

[deathlock]

dose it need vmaps

[Deathisfear]

I don't think so (Vmaps?). Anyway it just needs Maps and DBC.

[Tompilot]

Can we use SQLyog to? or MUST we use Navicat?

[Fragged Rabbit]

Does it have to be Wow 3.0.3 (913? Because i have Wow 3.0.3 (9183). Will it function properly?

The sql takes ages, 400+ Mb. xD

Isn't Wow 3.0.3 (913 the same as Wow 3.0.3 (913?
:wave:

[alritewhadeva]

Hmm..server working and everything great =D but how do i add custom items? i made a query and executed it in Navicat but it says "[Err] 1364 - Field 'unk_flag1' doesn't have a default value" any idea how to fix this? and one more thing wats the map code for the violet hold custom raid? =P thx AWESOME REPACK!!!!

[Megosh]

Can we use SQLyog to? or MUST we use Navicat?

You can use any SQL database editing program you wish. (I use SQLyog and it works fine)