Ok! I didnt make the repack or the links to the downloads : these can be found here : http://www.mmowned.com/forums/emulat...ng-repack.html
character.sql - MEGAUPLOAD - The leading online storage and file delivery service
logon.sql - MEGAUPLOAD - The leading online storage and file delivery service
------ Anyway onto the guide ---------
1. Download the 2 files listed on the link above!
- One is called Etzzhys_repack[1].rar
- The other is ncdb.rar
2. etzzhys_repack[1].rar - Extract it... Put it somewhere, I put it in C:\
And leave the .conf files for a while, this can take up to 30 seconds... =)
3. Download MySQL and Navicat from MySQL :: The world's most popular open source database and Navicat MySQL Admin Tool - the World's Best MySQL GUI for Windows, Linux & Mac OS X - Download Now! Support Access to MySQL, Excel to MySQL, MySQL editor, MySQL administrator, MySQL frontend, MySQL manager, phpmyadmin, MySQL mangement, MySQL administ
4. extract the ncdb.rar To the near same location to the repack. I will use C:\ again and called the extraction folder "Server" so all the files are in "C:\Server"
5. Set up MySQL with the MySQL Instance Configuration Tool
Select - Default Config - Put a root password, confirm it, and Apply Settings
6. Set up Navicat, on up a new connection using localhost as the Host, and the password you set up. Make a new database : i called it "ncdb"
7. Ok! Here it gets harder. Go to the extracted ncdb, and find "AscentTool.exe", right click and edit it. Scroll a wee bit down and find
set user=root
set pass=ascent <--- Change this to ur Password
REM wdb - is the World Database
REM cdb - is the Character Database
REM If you do not have them seperated then set them to the same values
set wdb= ascent <------ Change this to the database name you set in Navicat
set cdb=ascent <------ Change this to the database name you set in Navicat
Both the SAME!!!
REM
############
I will set the wdb and cdb to ncdb
Save that
and Run the AscentTool.exe
8. When it opens press "w" on your keyboard and press ENTER!
NOTE: If there is anything on the DB you set... it will be destroyed
... IT WILL DO A LOT OF IMPORTING... Take around 2mins! So Go get a cup of coffee and some biscuits
9. After it is complete - Press any key and then type "X" and enter
10. Go to Navicat, and hey! The Database has been populated
But hey, its not all done yet, if you notice, the "Accounts" , "character" and other tables are missing. So the server is unplayable for the moment =(
11. Minimize Navicat, Go to the Server folder, then releases, Then milestones, then MileStone-0.3.x! Itll be a .rar
12. In the rar will be another .rar, "Database.rar". Extract that to Desktop. Itll have database.sql in it
13. Go to Navicat, right click on your Server Database, in my case its ncdb. And Right Click and hit Execute-batch-file. Then navigate to the database.sql done in Step 11-12. Thisll take around 5 mins... Notice it wont Execute all instructions, it is making the loot tables and fixxing some bugs! Exactly Which i have no clue
14.I have made 2 files called character.sql and logon.sql, Execute-batch them both! Links are at the bottom
15. NOW WE HAVE ALL THE TABLES!
16. Go to the table "Accounts"
And make a new account, I did :
Login : Admin
Pass : *******
gm : az
flags : 8
ForceLanguage : enGB ( thats for EU Clients )
-------
17. Now Go to the repack folder we extracted earlier and open up ascent-logonserver.conf
Scroll down to :
<LogonDatabase Hostname = "localhost"
Username = "root"
Password = ""XXXXX"---< Change to MySQL Password
Name = "XXXXX"---< Change to database name
Port = "3306"
Type = "1">
Then Scroll down a bit.....
To get to :
<Client MinBuild = "6739"
MaxBuild = "6739"> Change to 9999
Ctrl+S to Save
and Close.
Now go to ascent-realms and find :
ITS AT THE BOTTOM
<Realm1 Name = "Test Realm" <---- Change this to whatever you want
Address = "127.0.0.1:8129"
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">
Save and close
Open up ascent-world and find :
<WorldDatabase Hostname = "localhost" Username = "root" Password = "XXXXX" Name = "XXXX" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = root" Password = "XXXX" Name = "XXXXX" Port = "3306" Type = "1">
EVERYTHING IN RED NEEDS TO BE CHANGED BY YOU!
Scroll down to about 45% of the document and find the rates!
Set em to whateva you want!
--- VISTA USERS ONLY ----
Download and install : Download details: .NET Framework 3.5#
After that... You are good to go!!!!!
RUN the ascent-logonserver, then the world , then realm!