 |
|
 |
||||||||
 |
|
|
LinkBack | Thread Tools | Display Modes |
11-10-2008, 12:26 AM
|
||||
|
||||
|
How to make 3.0.3 private server with aspire(FULL PIC GUIDE) FOR NUBS
ANY QUESTION ADD ME ON YOUR MESSENGER MY NAME IS xxsuperanthonyxx@yahoo.com Im ALWAYS ON WINDOWS MESSENGER
This Tut is for how to make a 3.0.3 private server with 3.0.3 Aspire Core+DBC+Maps+SQL Rongs files THIS TELLS HOW TO MAKE THE SERVER, AND HOW TO MAKE IT PUBLIC, FOLLOW STEPS EXACTLY AS I SAY lol First, download the files ^^ EXTRACT THEM TO DESKTOP  download Mysql server 5.0 MySQL :: MySQL Downloads   EXTRACT TO DESKTOP THEN INSTALL  MYSQL INSTALL    Configure MySql server      MYSQL SERVER DONE! Last edited by heroicanthony; 11-10-2008 at 04:34 AM. 
|
|
11-10-2008, 12:50 AM
|
||||
|
||||
|
But it is still nice
 it is to help and if people want to set up everything on their own well let them do it!
|
|
11-10-2008, 12:58 AM
|
||||
|
||||
|
i know you made a tut, but i wanted to make the most complete pic tut ever, cause i think its good so far :0 idk, is it east to follow???
NAVICAT Download Navicat - the World's Best MySQL Front End for Windows, Linux & Mac OS X     JUST HIT NEXT TILL INSTALLATION IS COMPLETE, DONT NEED TO CHANGE ANYTHING... OPEN NAVICAT, AND CLICK NEW CONNECTION   NOW THAT YOU HAVE YOUR CONNECTION, DOUBLE CLICK ON IT TO OPEN THE CONNECTION, IF IT DOESNT WORK, MAKE SURE YOU HAVE MYSQL ON AND THAT THE USERNAME AND PASSWORD OF THE MYSQL ARE SAME ON NAVICAT INSERTING THE DATABASE FILES Right click on your connection and click new database  Name it logon  right click on your connection again and click new database Name it world  Now you should have this  Last edited by heroicanthony; 11-10-2008 at 04:09 AM. Reason: Automerged Doublepost
|
|
11-10-2008, 02:18 AM
|
||||
|
||||
|
importing Database files
Our Next step is to import the Database files DO THIS CAREFULLY!!!
First off double click on your logon and world databases... Now Right click on your logon database and hit execute batch file        OK I found this problem and fixed it quickly, if you try and import the logon database youll get an error, well double click on you logon database to see all the tables(File thingies) then youll see one named accounts_data... DELETE IT  Now import the Aspire_Logon_Structure BE SURE TO HIT LOGON NOT CHARACTER  Now that your logon database is complete, do the same thing with your world database, but instead of using Aspire_Character_Structure or Aspire_Logon_Structure, you want to import Aspire_World_Structure and thats it. WE ARE DONE IMPORTING DATABASES NOW!!@!@!@@#!@# Last edited by heroicanthony; 11-12-2008 at 02:55 AM.
|
|
11-10-2008, 03:34 AM
|
||||
|
||||
|
Server Files
Now we are going to work on server files, which can get confusing, you have to pay close attention
FIRST we are going to make your hostname go to DynDNS.com: DNS Hosting, E-mail Delivery, VPS Hosting and Other Services and create an account  Create your account, not hard lol Then click my services  Then click Dynamic DNS  then Get Started  Follow Picture, but put what you want into the fields, for IP Address click auto detect, make sure wildcard is ON...  Now your DynDNS is done, click your start button on button left of your computer screen  Now click run Then type in C:/Windows/system32/drivers/etc/hosts it will pop up saying what to open it with select choose from file type, Then NOTEPAD or WORDPAD  Now go to whatismyip.com and copy that address, and paste it in your hosts file you just opened (if your ip addess is there dont worry bout this)((This is your external IPAddress if your wondering)) then click your start button, click run then type cmd... Then type Inconfig and press enter..  youll see one called IP Address and the number will be like 192.168.x.x ((This is your internal IP Address)) copy and paste this number into your hosts file under the other one u put. Now you should have something along the lines of this... # Copyright (c) 1993-2006 Microsoft Corp. # # This is a sample HOSTS file used by Microsoft TCP/IP for Windows. # # This file contains the mappings of IP addresses to host names. Each # entry should be kept on an individual line. The IP address should # be placed in the first column followed by the corresponding host name. # The IP address and the host name should be separated by at least one # space. # # Additionally, comments (such as these) may be inserted on individual # lines or following the machine name denoted by a '#' symbol. # # For example: # # 102.54.94.97 rhino.acme.com # source server # 38.25.63.10 x.acme.com # x client host 127.0.0.1 xx.xxx.xx.x.x 192.168.x.x )) If you dont have that, put yours like that... Now after the 3 addresses add your DynDNS hostname Such like this # Copyright (c) 1993-2006 Microsoft Corp. # # This is a sample HOSTS file used by Microsoft TCP/IP for Windows. # # This file contains the mappings of IP addresses to host names. Each # entry should be kept on an individual line. The IP address should # be placed in the first column followed by the corresponding host name. # The IP address and the host name should be separated by at least one # space. # # Additionally, comments (such as these) may be inserted on individual # lines or following the machine name denoted by a '#' symbol. # # For example: # # 102.54.94.97 rhino.acme.com # source server # 38.25.63.10 x.acme.com # x client host 127.0.0.1 whatever.servegame.org xx.xxx.xx.x.x whatever.servegame.org 192.168.x.x whatever.servegame.org )) Now save the file and close it WE ARE DONE WITH THE HOST FILE NOW !@#!@#!#!@# Now Server files... First open your AspireC303R414 folder thats on your desktop and open logonserver.conf with NOTEPAD    MAKE SURE YOURS ARE EXACTLY THE SAME AS I TYPED IN THE RED... Save it and close it... Then Scroll down till you see setremotepassword and type pass in for that.... Now Open your world conf with notepad  Just open it with notepad like you did with logonserver conf  MAKE IT HOW I HAVE IT IN RED AND THEN SAVE IT AND CLOSE IT Now open realms.conf like you did with world.conf and logonserver.conf with notepad... Change it how like so...  Your DONE WITH SERVER FILES!@#!@#$@! Last edited by heroicanthony; 11-11-2008 at 11:51 PM.
|
|
11-10-2008, 04:04 AM
|
||||
|
||||
|
Last But not least...
This will be easy but pay attention...
Open your AspireC303R414 folder and open the tools folder  Then double click AD  Now copy Ad.exe  Now go paste in your World of Warcraft folder... After you've pasted it right click anywhere in the World of warcraft folder and create a new folder name it maps double click on the Ad.exe that you just put in the World of warcraft folder and let it run, IT MAY TAKE A WHILE... Once its done Copy the maps folder that you put in the world of warcraft folder and paste it in the AspireC303R414 folder... After its done pasting, Go to your desktop and drag the DBC folder into your AspireC303R414 folder, it may take a second... YAY WHERE DONE MAKING THE SERVER!!@#!@#!@#!@#!@#!@!@# Now to start it LISTEN UP, FOR SOME UNGODLY REASON PEOPLE DONT LISTEN HERE AND START PROGRAMS THEY SHOULDN'T !!! Open your AspireC303R414 folder... Start ascent-logonserver and let it run till it says Hooking Signals  Then Double click on ascent-world... Once it gets to where it says Logonserver latency - 0  Now you should be able to log in, BUT WAIT... Go to your World of Warcraft folder, then click data folder, then the EnUS folder then open Realmlist.WTF with notepad, then it will say Set realmlist us.logon.worldofwarcraft.com setpatchlist us.version.worldofwarcraft.com Change it to set realmlist whatever.servegame.org set patchlist us.version.worldofwarcraft.com Then open wow.exe and enjoy... To create accounts open navicat, double click on your connection to open it, then double click logon, then click on accounts, then on the bottom youll see a + sign, click it then fill in the account info as shown...  NOW YOUR DONE!!!!! CREDITS GO TO ME FOR MAKING TUT SERVER FILES GO TO RONG THIS IT MY FIRST TUT, DEFINATLY NOT THE LAST, NEXT ILL MAKE A WEBSITE TUT, AND A VIDEO TUT FOR THIS, HOPE IT HELPED Hopefully i can get some rep on me now, and start to get to be known ^^ Last edited by heroicanthony; 11-10-2008 at 04:13 AM.
|
|
11-10-2008, 04:27 AM
|
||||
|
||||
|
god this was a pain in the ass to make lol, but was worth it, now if i forget how to make one ( i do a lot ) ill remember now XD
at least i got a +rep, ive never had a rep on here, i finally have a green bubble!!!!!! OMFG Last edited by heroicanthony; 11-10-2008 at 04:35 AM. Reason: Automerged Doublepost
|
|
11-10-2008, 08:48 PM
|
||||
|
||||
|
Sweet
I had the same problem, if you go to your navicat make sure that your databases are named world and logon no caps, then if thats right, open your logonserver conf and make sure that the "Database Name" is logon. Then open your world.conf file and youll see the 2 lines that say
<WorldDatabase Hostname = "localhost" Username = "root" Password = "pass" Name = "world" Port = "3306" Type = "1"> <CharacterDatabase Hostname = "localhost" Username = "root" Password = "pass" Name = "logon" Port = "3306" Type = "1"> Where they say Name = "logon" and "world" make sure they are like that... If that doesnt work make sure your DB folder is in the aspireC303R414 folder and the maps too... Make sure also that your hosts file is correct, exactly as i have in the pictures exept with your numbers... If that doesnt work make sure that your ports are forwarded, now if you can find guides on here, but if you cannot get it working, ill be able to help you in 5 hours, when i get home, cause i have a thing at school till 9 pm, so after that i can help you do that, then it should work, so try the steps i just posted and if they dont work, i WILL get it working... dont worry we WILL be able to fix this, when i say i had same problem, i litterally mean it, thats kind of why i made this guide, is because i had problems with it and it took me a while to get it working, so i thought i'd save other peoples the trouble... ^^ Last edited by heroicanthony; 11-10-2008 at 08:51 PM. Reason: Automerged Doublepost
|
|
11-11-2008, 11:23 PM
|
|||
|
|||
|
@ anders93
The way I fixed this was that I went did a search (ctrl-f) in my ascent-world config file and changed the RemotePassword to my password. You need to 1. Open ascent-world 2. ctrl-f search for RemotePassword and change it to the root password, which would be "pass" if you were following the OP's guide.
|
|
11-11-2008, 11:48 PM
|
||||
|
||||
|
Omg i knew i forgot something, thank you phtye, ^^ im gonna go ahead and throw that in the guide
And if you guys have questions add me to your instant messenger... ill talk to ya ^^ Last edited by heroicanthony; 11-11-2008 at 11:52 PM. Reason: Automerged Doublepost
|
|
11-12-2008, 01:29 AM
|
|||
|
|||
|
thx for this you deserve +rep for your work!
I get to the character screen and create a new character (on Test Realm) and as soon as I okay I am disconnected from the server. Hints? -edit I found that there was a column count mismatch when the app tried to input the newly made chars into the db. I am wondering why the world db was created. There is no reference as to what goes in it. thx again Last edited by arrowroot; 11-12-2008 at 02:12 AM.
|
|
11-12-2008, 05:10 AM
|
||||
|
||||
|
woops
ok i fixed the guide for the world database, lol, my bad XD this is my first guide so im getting used to it...
|
|
11-12-2008, 08:29 AM
|
|||
|
|||
|
Hello, First off just want to thank you very much for putting this up. now my problem.
When I opened the hosts file in C:/Windows/system32/drivers/etc/hosts I typed in all the ip information however when i tried to save it to the original location, it said I couldn't. If I am supposed to save it some where else, where would that be. otherwise, what am I doing wrong.
|
|
11-12-2008, 05:59 PM
|
|||
|
|||
|
I still have the same problem
i already did the server 3 times already and isnt working. I have the same problem tat the guy post it the authentication isnt working.
can u help me please. I port forward and did everything exactly as u told us
|
