[repack] noob friendly tompack

[tomch]

Introduction
This is an old repack that I have been working on for a while. It is a mangos driven repack, and one of the first noob friendly ones. I made it so you do not need to install a bunch of things like previous repacks in the past have. If you notice, a lot of repacks are like this now.

Anyway, I try to make this repack easy to use, noob friendly, and stable. Give some feedback on it to make it better.

Current version
tompack 4.99 beta
In this release:
MaNGOS revision 5650
ScriptDev2 revision 344
UDB 0.10.0.346
DBC files from client 2.3.3

supports WoW TBC 2.3.3

Changes
This version now starts properly. There was a problem in the database, mostly in the characters table. I have now fixed it and it should run rather smoothly now.

Currently supports WoW TBC client 2.3.3

Download
tompack 4.97

tompack homepage
check for updates and stuff

Guide
Before installing, make sure that you uninstall all other versions of tompack just to ensure that it works fine.

other than that, the newer versions now dont require you run any registry changes or do anything else with any other program. Just make sure you follow the instructions

1. Download the tompack. Start up the installer (double click on tompack.exe). Choose the install directory and hit install. Wait patiently until it finishes.
   
2. As soon as the install is finished, the post-installer should pop up in a command prompt window. Just read the instructions to extract the maps and continue. In this release I was able to get you guys the DBC files for 2.3.3 enUS, so you dont need to worry about extracting that. When another installer comes up, tell it where you world of warcraft install directory is and hit install. Then ad.exe should start doing its job. When it is done, go to the world of warcraft install directory, and you should see a folder in there called maps. Move it to the install directory of the tompack.
3. Now then, you should be all set. I already pre-configured the configuration files for a basic server, but if you want to customize it, feel free to open up the .conf files and fix it to what you want, given you know what you are doing. Otherwise, go to the next step.
   
4. Now then, go to the tompack folder and double click on either "start background.bat" or "start mysql console.bat" It doesnt matter which one you choose. If you want to see the mysql output and/or need to debug, use the console batch, but otherwise, you can use the background one. If you use the console on, make sure you do NOT close the window after, you must keep it open for the server to run. With the background batch, you just need to give if about 5 seconds to initialize, then you can close it if you want.
5. After you start up the mysql server, you can now start up the rest of the server. Just double click on realmd.exe and wait for it to finish up (should take around 1-10 seconds) then start up mangosd.exe and wait until that finishes. It should beep when it is done, and/or give you a Mangos> prompt. Make sure you keep the windows open.
6. then to play on your server, change you realmlist.wtf file in you world of warcraft install directory. Change it so it says "set realmlist 127.0.0.1" you dont need to worry about the other line.
   
7. Now that you have you server up, you need to make some accounts. Just go to the mangosd.exe window and type in "create USERNAME PASSWORD" where USERNAME is the username you want, and PASSWORD is the password you want for your account. To set GM type in "setgm USERNAME #" where USERNAME is the username you want to give privileges to and # is the number 0,1, 2, or 3, where 0=normal player, 1=moderator, 2=game master, and 3=administrator. To enable all TBC features, type in "setbc USERNAME #" where USERNAME is the username u want to give tbc to and # is 1 or 0 where 1 enables TBC and 0 is normal wow. After you have an account, start wow, login and enjoy!

NOTE TO SHUT DOWN THE SERVER to shutdown your server, close mangosd.exe and realmd.exe and run "shutdwon mysql.bat" in the tompack folder. When it asks to enter the password, enter "root" and press enter.


[*] once everything is done change the realmlist.wtf in your wow directory to 127.0.0.1


I will be making patches periodically, so check back often for updates! Please post feedback!

Optional step! Making your server public the easy way with Hamachi!:

1. Download and install Hamachi from http://www.hamachi.cc (go to the bottom of the download page to download without registering.
2. If you want follow or skip the tutorial. Press the green power button in the left-hand corner of the hamachi window. Wait until hamachi is done starting up the network.
3. press the button with a triangle in it in the right hand corner of the hamachi window. Select create new network. Think of a name for your network (this will not be the name of your realm/server, so it can be a crappy name as long as you can remember it.) and make a password. Write both these down so you do not forget. Note the number that hamachi give you at the top of the window (eg: 5.123.456.7, and write that down as well.
4. Start the mysql sever with "start mysql.bat" or "start background.bat" but do not start up the server, and open up your database with a mysql gui such as navicat or sqlyog. To do this, create a new connection in navicat or sqlyog and use these settings:
   

   connection name: this can be anything you want
   host: 127.0.0.1
   username: root
   password: root
   and keep everything else default

5. Now assuming you have done that successfully, start the connection and click on the realmd database in the connection and open up the realmlist table. You should see an entry in the table. Scroll all the way over to the ip address column and change it from 127.0.0.1 to your hamachi ip address you wrote down earlier. Now close the mysql gui and fire up hamachi then your server (in that order) and you should be good to go. Now just get some people to join your hamachi network and make some accounts for them, and you should have a small server up in no time.

* Troubleshooting step: If for some reason, you and other people are unable to connect to your server, please make sure it is properly up and running. If it is up and running (properly and you are 100% sure of it) refer to step2 in the repack installation section of this guide, and edit the "realmlist" table in the "realmd" database and replace 127.0.0.1 with your hamachi IP address.

if a tompack patch has a database patch (it will tell you) to backup your characters:

1. First off, download the patch
2. Before installing the patch, start mysql server (if it isnt already up) and go to the characters folder in the tompack directory and run "backup characters.bat" It should make a file called "characters.sql"
3. Wait until it is done and then shutdown the server.
4. After the server is down, run the patch installer
5. When the it is done patching, go back and start the server up and go back to the character folder. Run "restore characters.bat" and wait until it finishes.
6. When its done (correctly) you should be done and your tompack repack should be up-to-date!
7. If you experience problems, post them here

OPTIONAL!! MAKING YOUR SERVER PUBLIC WITHOUT HAMACHI (DYNAMIC IP)

INDEX:

• I. CREATING A DYNAMIC DOMAIN NAME.
• II. MANGOS PREPERATION.
• III. ROUTER CONFIGURATIONS
• IV. SETTING UP YOUR CLIENT TO CONNECT TO YOUR SERVER.
• V. COMMON Q&A

DLink Router users : I do not know how to configure your routers becuase they have too many conflicting port configuration applications on it.

If you have a Static IP from your ISP simply choose Static DNS instead and you do not need to download the updater. Then proceed with the rest of the guide.

I. Creating a Dynamic Domain Name:

1. Goto DynDNS.com and register an account. 2. Once your able to log in, goto the Tab 'Services' ontop. 3. A short way down the middle of the page you'll see Dynamic DNS, click that. 4. To your right you'll see 'Create Host', click that.
   • Host Name: Can be whatever you want b. IP Address: Usually auto populated but if not, goto Myipaddress.com and copy that here. c. Check enable wildcard. d. Mail Exchanger: I doubt you have this considering your looking at this guide for help. Leave blank. e. Click on 'Add Host'
2. Now click this link and download DynDNS Updater I would set it up as as a service, but it doesn't matter.
   
3. If you have issues setting up DynDNS Update post what you dont' get in detail and I will help you.

II. MANGOS Preperation:

1. Goto \system32\drivers\etc\ and open the file called 'host' with notepad. (replace with the location of your windows folder.. i.e. c:\windows\system32\drivers \etc\)
2. • At the end of the file (after all the text you see) insert this into it's own line:
   
   

   127.0.0.1 (Not sure if this is necassary, but mines working smile.gif )
   127.0.0.1
   example: 127.0.0.1wowjunkies.servegame.org b. Save and close

3. Download Navicat HERE, install. (just get the lite version, not the trial)
   
   • Click on Connection
   
   

   Connection Name: (Whatever you want)
   Host name/IP address: locahost (unless you have it hosted on a server elsewhere us it's address)
   Port: Leave it as is unless you know you need something different which i doubt.
   User name: User name of your Mysql mangos DB
   Password: Password of your Mysql mangos DB
   Test your connection, if it doesn't work your username and password are wrong or you don't have your mangos DB running. b. Click OK and your done with setting up Navicat!

4. In Navicat look in the Connections window and click the name of the connectoin you just made so it expands.
   
   a. Click on realmd b. In the right window double click realmlist c. Now change the field 'address' from 127.0.0.1 to d. At the bottom of the window click on the check mark to save or hit enter. e. Close that window and close Navicat
   
5. This will also help solve Realm Looping if your having that, but realm looping is also caused by port forwarding if you don't know what your doing.

III. Router configurations;

If you have some generic router that for some reason only allows you to forward one port i can't help you. Throw it away and get a good router. And don't try to do this stuff wirelessly, because that's a whole nother set of issues and why you'd want to do that is beyond me.

1. Disable Port Trigerring if you have the option. If not, just don't use it becuase it's an advanced feature that you need to know what it's for in order for it to work properly. Not necessary for your wow server to go public without hamanchi. 2. The following ports need to be opened and pointing to your servers router assinged IP address.
   
   - 3724 TCP (Enables you to connect to the Realmd DB) This port will give you the "Unable to connect" Message if not forwarded to your server. - 8085 TCP (Enables you to connect to the WorldServer?) This port is what causes realm looping if not pointing to your server IP and has the wrong protocol. Simply because you can't log into the mangos server so it kicks you back to the realmd server (realm list). - 80 TCP (This is only needed if your hosting a website frontend on the same server) - 3306 TCP (This allows connection to your DB in MySQL! Only open this if you need remote connection into your DB) BE SURE TO CHANGE THE PASSWORD OF ALL THE ACCOUNTS THAT HAVE ACCESS TO YOUR DB. WITH REPAKS THERE ARE ABOUT 4 ROOT/POWER USERS SETUP WITH THE PASSWORD MANGOS! CHANGE IT IMMEDIATELY!
   
2. Make sure your servers router assigned IP address is the Default DMZ server. (Only put your server in the DMZ zone if your still having issues, if you have correctly configured the ports as stated above you should be good to go without having to do this step.)

IMPORTANT!!!!! Antivirus applications and your firewall will also cause connection issues. Disable both to make sure you can connect, then enable if you can connect and see if it still connects. If not you will need to forward the same ports in your firewall. Sorry not gonna go through that or antivirus blocking issues.

IV. Setting up your client to connect to your server:

1. Go into your World of Warcraft game directory. Example c:\World of warcraft\ 2. Open the file realmlist.wtf with notepad. 3. Replace us.logon.worldofwarcraft.com with so it should look like this:
   
   

   set realmlist wowjunkies.servegame.org (or course entering your own domain name there)

2. Save and close

V. Q&A

Q. What is my DB username and password?
A. Depends on what repak your using and how you set up mysql. If your using repaks that come with mysql then it's usually mangos, mangos by default. If you setup mysql yourself, well then I couldn't tell ya.

Q. I have a static IP address from my ISP, how do i get it to work with that?
A. Use the Static host name instead of Dynamic and you do not need dynamic updater.

Q. Does this work with a DLINK router?
A. Not from my experience.

Q. Its possible my antivirus blocking my ports?
A. Yes some antivirus programs can do that.

Q. Do i need to configure my firewall as well by forwarding the same ports?
A. Most firewalls will automatically set this up for you the first time you use the app and try to access the net or access it from another computer. But if it hasn't then yes you do.

Q. Which IP should you use with forwarding ports your static, lan, or wan ip? or dns server ip ?
A. LAN

Q. What if i can't get access to my router to forward the ports?
A. Then you'll need to use Hamachi.

THATS IT! You should have no issues connecting! Again if you have issues, please be detailed.. things like: Doesn't work.. This sucks.. Wont connect.. Still isn't working Or crying it's not detailed enough ...

Tell me what steps you've takin and where your stuck and what exactly is happening.

credits for dynamic ip goto jinxer (hs)

[Nemerick]

Thanks alot for this guide, i liked it quite a bit, easy to follow etc.

Though I am experiencing some problems, I have made some accounts and all,
but when I log in to one of them and make me a character, it wont appear.
If I go and check the realm list, it says that i have 1 character on the realm,
but when I look at my characterlist, it aint there. Got the same problem with all the accounts, including the pre-made ones.

Do you know whats wrong?

Oh, almost forgot, i follow all the steps untill the "making it public"-part, since I wanted to see if it worked before i invited friends etc.

[daser]

nice guide man i`l try it when i`l be home :P and if it work`s +Rep

[Nemerick]

Thanks alot for this guide, i liked it quite a bit, easy to follow etc.

Though I am experiencing some problems, I have made some accounts and all,
but when I log in to one of them and make me a character, it wont appear.
If I go and check the realm list, it says that i have 1 character on the realm,
but when I look at my characterlist, it aint there. Got the same problem with all the accounts, including the pre-made ones.

Do you know whats wrong?

Oh, almost forgot, i follow all the steps untill the "making it public"-part, since I wanted to see if it worked before i invited friends etc.

Okay, now i think i know where the problem lies, but not how to solve it.
When i tried to make a character, the mangosd.exe comes up with an error saying that the "character.character" Table doesn't exist.
Also all the other character databases are missing, and they all have names like "characters.name/whatever".

So basically, there is some problems with the characters_NAME tables.
Maybe some kind of remake of those could fix the problem?

[lawlface]

i get same problems with the chars dude

[FoZ]

I get the massege when i try to start realmd:
SQL: SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel
, population FROM realmlist WHERE color <> 3 ORDER BY name
query ERROR: Unknown column 'allowedSecurityLevel' in 'field list'
No valid realms specified.

and when i try to start mangosd:
SQL: SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel
, population FROM realmlist WHERE color <> 3 ORDER BY name
query ERROR: Unknown column 'allowedSecurityLevel' in 'field list'
No valid realms specified.

any1 help plx

[vadoman]

same problem with the dudes wont appear

[bragdy]

Download site is down..

[encore394]

for me when i try open mapextract(tbc233) it brings up a doss window and seas eror
and i cant install it

[encore394]

when the ad.exe then a eror pops up and it wont finish what should i do

[Killer500226]

I've been playing on acsent servers forever this is something new and exiting i like it!

[Wetop]

Got around that, but when i start mangosd.exe it gives me
SQL: UPDATE characters SET online = 0
SQL ERROR: Table 'characters.characters' doesn't exist
SQL: SELECT MAX(guid) FROM characters
query ERROR: Table 'characters.characters' doesn't exist
SQL: SELECT MAX(guid) FROM item_instance
query ERROR: Table 'characters.item_instance' doesn't exist
SQL: SELECT MAX(id) FROM auctionhouse
query ERROR: Table 'characters.auctionhouse' doesn't exist
SQL: SELECT MAX(id) FROM mail
query ERROR: Table 'characters.mail' doesn't exist
SQL: SELECT MAX(id) FROM item_text
query ERROR: Table 'characters.item_text' doesn't exist
SQL: SELECT MAX(guid) FROM corpse
query ERROR: Table 'characters.corpse' doesn't exist
Check existing of map file './maps/0004331.map': not exist!
Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmap
s'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correc
t the DataDir value in the mangosd.conf file.

[Wetop]

SQL: SELECT characters.data, characters.name, characters.position_x, characters.
position_y, characters.position_z, characters.map, characters.totaltime, charact
ers.leveltime, characters.at_login, character_pet.entry, character_pet.modelid,
character_pet.level FROM characters LEFT JOIN character_pet ON characters.guid=c
haracter_pet.owner AND character_pet.slot='0' WHERE characters.account = '5' ORD
ER BY characters.guid
query ERROR: Table 'characters.characters' doesn't exist

sorry for double post :s

[shotterke]

I cant see my character after i created a new one

[tomch]

k sry guys i havnt replied to help out.
i was away doin stuff
anway
if you are having problems with the characters, i fixed that problem in the version 4.95. make sure that you install that one and not 4.90, and that 4.95 is a fresh install. if you still have problems ill see what i can do.

edit well i just tested this, and i see that this is a problem again. i thought i fixed it, but ill work on this again.

I get the massege when i try to start realmd:
SQL: SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel
, population FROM realmlist WHERE color <> 3 ORDER BY name
query ERROR: Unknown column 'allowedSecurityLevel' in 'field list'
No valid realms specified.

and when i try to start mangosd:
SQL: SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel
, population FROM realmlist WHERE color <> 3 ORDER BY name
query ERROR: Unknown column 'allowedSecurityLevel' in 'field list'
No valid realms specified.

any1 help plx

you need to run mysql.bat or background.bat. read the instructons carefully

when the ad.exe then a eror pops up and it wont finish what should i do

do you have WoW TBC client 2.3.3? and did you specify to extract to its install location?

Got around that, but when i start mangosd.exe it gives me
SQL: UPDATE characters SET online = 0
SQL ERROR: Table 'characters.characters' doesn't exist
SQL: SELECT MAX(guid) FROM characters
query ERROR: Table 'characters.characters' doesn't exist
SQL: SELECT MAX(guid) FROM item_instance
query ERROR: Table 'characters.item_instance' doesn't exist
SQL: SELECT MAX(id) FROM auctionhouse
query ERROR: Table 'characters.auctionhouse' doesn't exist
SQL: SELECT MAX(id) FROM mail
query ERROR: Table 'characters.mail' doesn't exist
SQL: SELECT MAX(id) FROM item_text
query ERROR: Table 'characters.item_text' doesn't exist
SQL: SELECT MAX(guid) FROM corpse
query ERROR: Table 'characters.corpse' doesn't exist
Check existing of map file './maps/0004331.map': not exist!
Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmap
s'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correc
t the DataDir value in the mangosd.conf file.

for the sql errors, make sure that you have the 4.95 version. i fixed the database, and for the maps problem, make sure that you run the mapextract program to extract the maps. read the instructions carefully for details.