[Guide] Beginner: Setting up Theo's WoTLK Blizzlike Repack!

[Mango Jerry]

Welcome to Hephaestus' Beginner Guide of how to Setup Theo's WoTLK Blizzlike Repack!
** Hephaestus' Presents a Beginner Guide for Theo's WoTLK BlizzLike Repack! **

Requirements:

.NET Framework 3.5: Download details: .NET Framework 3.5
MySQL 5.0: MySQL :: MySQL 5.0 Downloads
SQLyog (Database Editor): Download - SQLyog MySQL Frontend, MONyog MySQL Monitoring Tool


<------------------------------------->
-> Setting up MySQL 5.0:

1. Download MySQL: There is a link for it, on the top of the Thread.
2. Installing MySQL 5.0:

--> Animation Picture is made by: Hephaestus
* The Animation Picture may be fast, so look at it a couple of times, to understand the Setup. *

3. When installed, you are successfully done by Installing MySQL 5.0!

<------------------------------------->
-> Where to download the Repack:

Theo's Stable Repack: http://www.mmowned.com/forums/emulat...ev-1973-a.html

2. Save the Repack on the Desktop, and extract it to the Desktop with WinRaR/7zip or something else.
3. Remember you have to extract the Maps and VMaps for your Server.


<------------------------------------->

-> How to Extract the Maps and the VMaps:

~ Extracting the Maps:

1. Go to the Folder of your Repack and look for the Folder Called: "Extractors"
2. Then there is a Folder Called: "Map Extractor".
3. The file called "ad.exe" has to be put in your World of Warcraft Folder.
4. Before Extracting with "ad.exe" you have to make a Folder called: "Maps" in your World of Warcraft Folder.
5. When the Extraction of the Maps is done, put the "Maps" Folder to your Repack Folder.
6. Then your "Maps" is extracted/Made successfully.. Good Job!

~ Extracting the VMaps:

1. Go to the Folder of your Repack and look for the Folder Called: "Vmap Extractors"
2. Then there is a Folder called: "Vmap Extractor".
3. The file called "vmapextract_v3" has to be put in your World of Warcraft Folder.
4. Before Extracting with "vmapextract_v3" you have to make a Folder called: "vmaps" in your World of Warcraft Folder.
5. When the Extraction of the Vmaps is done, put the "Vmaps" Folder to your Repack Folder.
6. Then your "Vmaps" is extracted/Made successfully.. Good Job!

<------------------------------------->
-> Getting the Database Tool called Webyog SQLyog:

1. Go to the Website: Download - SQLyog MySQL Frontend, MONyog MySQL Monitoring Tool
2. Download a Trial of the SQLyog Database Tool for MySQL and Install it.
3. Then you have the Database Tool for MySQL as Trial!

<------------------------------------->
-> Setting up SQLyog (Database Tool):

1. Launch the Database Tool: SQLyog.
~ (There is a Shortcut of it, on your Desktop)
2. Then you will get a Pop-up of when the SQLyog Trial expires, just close the Window.
3. On the top you can see a button called: "New", then Write "Ascent" as the "Connection Name".
4. Leave the "MySQL Host Address", "Username" ALONE!
5. The Password of it is the Password as you Made in the MySQL Setup Progress.
6. Click on "OK" and then on the top Right Click on the "Computer Icon" and Click on: "Create a New Database" and Call the 1st Database:
World and then make a 2nd Database Called: Logon
7. Now you made your Server Databases.. Good Job!

<------------------------------------->
-> Executing the "World.sql" to the World Database:

1. Open up the Repack Folder, and look for the Databases (SQL Files) called World and Logon.
2. Once its extracted, go to "SQLyog" and go to the Database as you made called: "World".
3. Then Right Click on the "World" Name and Click on "Execute from SQL Dumb" and then Select the "World.sql" in the Repack Folder as you've extracted.
4. When the SQL File is executed Successfully, Close down "SQLyog".
5. Then your World Database is Executed!

<------------------------------------->
-> Executing the "logon.sql" to your Logon Database:

1. Go to "SQLyog" and type this at the "Database Name": Logon
2. Then Right Click on the "Logon" Name and Click on "Execute from SQL Dumb"
And then Select the "Logon.sql" in the Repack Folder, as you've extracted right before.
3. When the SQL File is executed Successfully, Close down "SQLyog".
4. Then your Account/Logon Database is Executed!

<------------------------------------->
-> Making Accounts for your Server:

1. Launch "SQLyog" and type this at the Database Name: Logon.
2. Then at the "Logon" name, you can right click and "Refresh" the Account Database.
3. Then Find the "Table" called "Accounts" and then Click on "Table Data"
4. Then you can see the Accounts thats allready been Created.
5. You can Edit the Account Names and Passwords.
6. When you want to make a New Account just click on "(NULL)" and Enter the Decided Account Name, Password, GM, Flags

Account Name: The Name of the Account.
Password: The Password of the Account.
GM: The Rank of the Account: 3 as GM, AZ as Admin and 0 as Normal.
Flags: Burning Crusade Enabled: 8
Wrath of the Lich King Enabled: 24

7. Then click on "Save" and the Created Accounts is ready for use!


<------------------------------------->
-> Starting up the Server:

1. Go to the Repack Folder, and Click on: "World.exe" and "Logonserver.exe"
2. Sometimes the Realms are going to "Realm Loop" but then you just can Restart the "World.exe" and "Logonserver.exe".

<------------------------------------->
-> Editing the Configs and making the server Public with Hamachi:

http://www.mmowned.com/forums/emulat...c-hamachi.html

<------------------------------------->

Some of the Setup's are from my Previous Guide, but it dosn't really matter!
I do still hope that Ground Zero is happy that i've made a Guide for the Repack.

Guide by: Hephaestus

[Ground Zero]

Lol....

MySQL server is pre-installed...

[Mango Jerry]

Uhm.. Huh?
What do you mean with that?

Oh on the Animation MySQL 5.0 Guide.
Yes, because i had to pre-install it to show how to do.
I forgot to Delete the Mysql.ini before doing the Guide, thats why.

People dosn't have to repeat their Password 2 times.

But still, i hope you all will Enjoy the Guide.
Its allmost the same as the previous one i made, because they allmost have to do the same.
Same setup, another Repack/release.

[Ground Zero]

No...You dont need mySQL Server 5 for my repacks...
This will just confuse people...
MySQL is preinstalled in Server File in my Repack.

[Mango Jerry]

Allright, thank you for telling me that now, Ground Z.
I recommend you to make a repack, with manual install of MySQL.

[BlackEagle]

Okay I can't seem to find the database files to execute to world and logon.
If anyone can tell me where to put them I would be thankful for that.

[tromboneguy007]

I can't find them either...

I am new to this so it could be just me.

[Mango Jerry]

Just lookup for a Large SQL File in the Repack Folder.

[BlackEagle]

Well you made the guide so I am guessing that you know where the files are and what they are named.
Cause I can't find any large .sql file there all 1kb 2kb ish.

[Mango Jerry]

Allright, ima go check it out now, Wespinator.

There's a Folder called: "Server", go into that folder and Click on the "MySQL.bat"
The MySQL.bat will execute the Files to your Database, but make sure the System Progress called "mysql-nt" is closedown first.

[koos]

hey im using the pre installed mysql and cant log into wow i tried admin as username and password and it doesnt work help pls

[Ghoulishtie]

The vmapextract_v3 wont work. It stops working and closes out. Any help?

(edit) nvmd got that working. Now when I either attempt to run the 'ArcScript Full' sql OR attempt your MYSQL.bat method, neither of them work. the Full sql doesnt batch sucessfully, and the .bat cannot find paths specified. Problems I cant seem to find paths around. Any help? (basically, stuck on ur 'executing sqls' step)

[Mango Jerry]

You dont have to execute anything with this repack.
The MySQL.bat is doing it its self.

[Ghoulishtie]

I dont get that though. I'm done extracting/moving the maps/vmaps, and I dont know what to do next. I'm reading all sorts of different ways on both this topic and the repack topic itself. Do I run MYSQL.bat? (If so, it wont work. Been trying to.) Or do I just continue with getting an account set up? (Which I cant figure out without using sql) I know the world/logon.exe wont work without this stuff.

Any help please?

(EDIT) here is a pic of what I get when I try MYSQL.bat (and yes, the file is where it says it's not)

[Mango Jerry]

You have to put the Server into the "C:" Drive.