Syke
08-14-2008, 06:09 PM
I've been leeching for a while and i thought it's time to give back, this is my first contribution, so please don't be too rough ;)
This repack is different from some of the other ones I've seen posted here, the other ones require you to Install MySQL, this repack lets you use the MySQL included in the AC Web repacks, which means all your databases are in one spot and only one connection is required to access all your database info, I'll include a tutorial for setting it up with AC Web repacks, and without.
Downloads
Navicat for MySQL (http://www.navicat.com/download/navicat8_mysql_en.exe) (30 Day free trial.)
Navicat lite (http://www.navicat.com/download.php?id=1) (Free version.)
MaNGoS WotLK Beta Repack (8643) (http://filebeam.com/abde6d551e3d12e669c36d6a27ca5e83)-Filebeam.
MySQL 5.0.67 (http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-essential-5.0.67-win32.msi/from/http://mysql.llarian.net/)
And of course a repack is useless unless you can play on your server right? So you'll be needing the beta client.
WotLK 3.0.1 Beta Blizz Downloader [enUS] (http://filebeam.com/1f040c0d66da873cb1a32d7f8466746c)
First thing's first, we need to either start MySQL, or install it if you don't have it, if you don't have it click the link posted above (MySQL 5.0.67) (http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-essential-5.0.67-win32.msi/from/http://mysql.llarian.net/) once that's done install it, and select typical, if you are going to run the server off your computer then it would probably be best to select 'Developer Machine' during installation. Once that is done, go to configuration (you will be taken there directly after installation) select port 3306 and continue onto the login details, choose any password you would like, however to make things go faster use mangos so there will be less editing of .conf files later on.
If you have a repack that comes with MySQL already, such as the AC Web repacks, then navigate to the repack folder, go to the server folder and double click MySQL, it's not necessary to start apache for this. NOTE- If you use the MySQL included in the repack that you are using, then you must use the login details for that repack!
After MySQL is running it's time to get to the actual setup of the server, download Navicat lite, or any MySQL tool, and connect to your database (if your using MySQL from a repack the details would be localhost, root, <password>. if you went with step 1 and chose mangos as the password then connect with, localhost, root, mangos.) If you don't know what the password is for your repack it can usually be found in the read me, you know what that is, right? Anyway once the WotLK repack is downloaded extract the folder inside the .rar to anywhere you would like, and go to your database (if your not already connected to then connect to it!) create 4 new databases, call them "scriptdev2" "mangos" "characters" and "realmd" (without " "), now it's time to fill those databases, if you are using navicat as described above, open the database and right click and select execute batch file, click the "..." button and find the repack folder you extracted from the .rar earlier, open it up and go into the Database folder, select the appropriate batch file for whatever database you are in and execute it, be patient though as mangos is a large file with over 800,000 queries and it may take something like 8 minutes to complete.
WARNING! You can use any MySQL tool you want, but I highly recommend Navicat, sometimes HeidiSQL has the tendency to freeze up and become non-responsive with the larger batch files like mangos.
After you created your databases and executed the batch files, we need to do a little bit of editing, go into the batabase "realmd" and select and open the "account" table none of the four accounts have TBC enabled so we are going to fix that, and YES TBC does have to be enabled to play WotLK not only for the creation of blood elves and draenei, but you can't access anywhere but the death knight starting location (if you create a DK which I'm sure you will) without TBC, so once in the table find the "tbc" column and erase the 0 and replace it with and 8, exit the table, now in the "realmd" database open up the realmlist table, if you want to make it public replace the IP adress "127.0.0.1" with your IP adress, if you don't know what it is go to What Is My IP Address? - IP Address Lookup, Bandwidth Speed Test, IP Info, plus more (http://whatismyip.com) and conpy and paste you IP, also rename your realm to whatever you so choose.
Ok, we're almost there, we've done everything we need to do in the database now it's time for a lengthier process. Go into the folder you extracted from .rar and go into DBC & Map Extractor, go to your WotLK beta directory and place ad.exe in there, no need to create a maps and dbc folder like other repacks, ad.exe will do that for you upon extracting the files, so if you haven't already, start ad.exe and let it run untill finished.
Ok, so once as.exe is done doing it's thing copy or move the dbc and maps folders to your repack folder, once that is done we have one to two more steps before we are ready to play, if you are using the MySQL included in a repackm you'll need to edit your .conf files in your repack folder, so if you didn't select mangos as your password when installing MySQL or are using the MySQL from a repack open up mangosd.conf with notepad, and change the following information that is in red
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"
The red text indicates the MySQL password that will be used to connect to the database when starting up the server, so chnage only the red to your password, leave everything else alone, once done save it and close it.
Time to do it two more times, this time open up "realmd.conf" with notepad and find the following;
LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd
Once again only change the red text to point to your MySQL password.
Open "scriptdev2.conf" with notepad and find to following;
ScriptDev2DatabaseInfo = "127.0.0.1;3306;root;mangos;scriptdev2"[\quote]
And yet again only change the red text to point to your MySQL password.
Ok, now you're done! and you're ready to start playing, go to your realmlist.wtf file in your WotLK directory and delete everything inside, and replace it with
[quote]set realmlist XXX.XXX.XXX.XXX
Where XXX.XXX.XXX.XXX is your IP address (either get this from the realmlist table in your realmd database or go back to What Is My IP Address? - IP Address Lookup, Bandwidth Speed Test, IP Info, plus more (http://whatismyip.com) and get your IP and put it there, save close and start up WotLK with WoW.exe NOT Launcher.exe. That's it! you've just setup your very own WotLK beta server! If you have any questions post here and I'll be sure to answer as soon as possible.
If you don't want people to know your IP, go to Making your Ascent server public. (http://www.ac-web.org/forum/tutorials/7572-making-your-ascent-server-public.html) and follow that guide.
I did not make this repack, I did not compile it, and I had nothing to do with the creation of it, I am simply here posting it, and telling you all how to use it.
This repack is different from some of the other ones I've seen posted here, the other ones require you to Install MySQL, this repack lets you use the MySQL included in the AC Web repacks, which means all your databases are in one spot and only one connection is required to access all your database info, I'll include a tutorial for setting it up with AC Web repacks, and without.
Downloads
Navicat for MySQL (http://www.navicat.com/download/navicat8_mysql_en.exe) (30 Day free trial.)
Navicat lite (http://www.navicat.com/download.php?id=1) (Free version.)
MaNGoS WotLK Beta Repack (8643) (http://filebeam.com/abde6d551e3d12e669c36d6a27ca5e83)-Filebeam.
MySQL 5.0.67 (http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-essential-5.0.67-win32.msi/from/http://mysql.llarian.net/)
And of course a repack is useless unless you can play on your server right? So you'll be needing the beta client.
WotLK 3.0.1 Beta Blizz Downloader [enUS] (http://filebeam.com/1f040c0d66da873cb1a32d7f8466746c)
First thing's first, we need to either start MySQL, or install it if you don't have it, if you don't have it click the link posted above (MySQL 5.0.67) (http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-essential-5.0.67-win32.msi/from/http://mysql.llarian.net/) once that's done install it, and select typical, if you are going to run the server off your computer then it would probably be best to select 'Developer Machine' during installation. Once that is done, go to configuration (you will be taken there directly after installation) select port 3306 and continue onto the login details, choose any password you would like, however to make things go faster use mangos so there will be less editing of .conf files later on.
If you have a repack that comes with MySQL already, such as the AC Web repacks, then navigate to the repack folder, go to the server folder and double click MySQL, it's not necessary to start apache for this. NOTE- If you use the MySQL included in the repack that you are using, then you must use the login details for that repack!
After MySQL is running it's time to get to the actual setup of the server, download Navicat lite, or any MySQL tool, and connect to your database (if your using MySQL from a repack the details would be localhost, root, <password>. if you went with step 1 and chose mangos as the password then connect with, localhost, root, mangos.) If you don't know what the password is for your repack it can usually be found in the read me, you know what that is, right? Anyway once the WotLK repack is downloaded extract the folder inside the .rar to anywhere you would like, and go to your database (if your not already connected to then connect to it!) create 4 new databases, call them "scriptdev2" "mangos" "characters" and "realmd" (without " "), now it's time to fill those databases, if you are using navicat as described above, open the database and right click and select execute batch file, click the "..." button and find the repack folder you extracted from the .rar earlier, open it up and go into the Database folder, select the appropriate batch file for whatever database you are in and execute it, be patient though as mangos is a large file with over 800,000 queries and it may take something like 8 minutes to complete.
WARNING! You can use any MySQL tool you want, but I highly recommend Navicat, sometimes HeidiSQL has the tendency to freeze up and become non-responsive with the larger batch files like mangos.
After you created your databases and executed the batch files, we need to do a little bit of editing, go into the batabase "realmd" and select and open the "account" table none of the four accounts have TBC enabled so we are going to fix that, and YES TBC does have to be enabled to play WotLK not only for the creation of blood elves and draenei, but you can't access anywhere but the death knight starting location (if you create a DK which I'm sure you will) without TBC, so once in the table find the "tbc" column and erase the 0 and replace it with and 8, exit the table, now in the "realmd" database open up the realmlist table, if you want to make it public replace the IP adress "127.0.0.1" with your IP adress, if you don't know what it is go to What Is My IP Address? - IP Address Lookup, Bandwidth Speed Test, IP Info, plus more (http://whatismyip.com) and conpy and paste you IP, also rename your realm to whatever you so choose.
Ok, we're almost there, we've done everything we need to do in the database now it's time for a lengthier process. Go into the folder you extracted from .rar and go into DBC & Map Extractor, go to your WotLK beta directory and place ad.exe in there, no need to create a maps and dbc folder like other repacks, ad.exe will do that for you upon extracting the files, so if you haven't already, start ad.exe and let it run untill finished.
Ok, so once as.exe is done doing it's thing copy or move the dbc and maps folders to your repack folder, once that is done we have one to two more steps before we are ready to play, if you are using the MySQL included in a repackm you'll need to edit your .conf files in your repack folder, so if you didn't select mangos as your password when installing MySQL or are using the MySQL from a repack open up mangosd.conf with notepad, and change the following information that is in red
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"
The red text indicates the MySQL password that will be used to connect to the database when starting up the server, so chnage only the red to your password, leave everything else alone, once done save it and close it.
Time to do it two more times, this time open up "realmd.conf" with notepad and find the following;
LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd
Once again only change the red text to point to your MySQL password.
Open "scriptdev2.conf" with notepad and find to following;
ScriptDev2DatabaseInfo = "127.0.0.1;3306;root;mangos;scriptdev2"[\quote]
And yet again only change the red text to point to your MySQL password.
Ok, now you're done! and you're ready to start playing, go to your realmlist.wtf file in your WotLK directory and delete everything inside, and replace it with
[quote]set realmlist XXX.XXX.XXX.XXX
Where XXX.XXX.XXX.XXX is your IP address (either get this from the realmlist table in your realmd database or go back to What Is My IP Address? - IP Address Lookup, Bandwidth Speed Test, IP Info, plus more (http://whatismyip.com) and get your IP and put it there, save close and start up WotLK with WoW.exe NOT Launcher.exe. That's it! you've just setup your very own WotLK beta server! If you have any questions post here and I'll be sure to answer as soon as possible.
If you don't want people to know your IP, go to Making your Ascent server public. (http://www.ac-web.org/forum/tutorials/7572-making-your-ascent-server-public.html) and follow that guide.
I did not make this repack, I did not compile it, and I had nothing to do with the creation of it, I am simply here posting it, and telling you all how to use it.