I know this was originally posted by -DefaulT. All credit goes to him and the people who helped him out. I'm just here to make it more clearer for some of you.
Also credit to xkl for his client,server and database.
IMPORTANT
Make sure to have these Port forwarded.
Name PortDatabase
Pokenet 7001
Pokenet2 7002
Pokenet3 7005
Mysql 3306
Client
MySql
Java
Navicat
1. Installing MySql
It says reconfigure for me because I already have this installed. It should say like "Configure now" or something like that for you
Ignore the top of this. Just put in you password and make sure "Create and Anonymous account" is unchecked
Then just click finish and execute and wait for it to finish.
2.Setting up the Database and Navicat
MAKE SURE TO EXTRACT THE DATABASE TO THE SERVER FOLDER
I couldn't make pictures cuz my Navicat expired lol. So I'll explain it
Install Navicat.
Open it
Click on Connection and go to MySQL.
Than you have to type it in like this:
And click "Test Connection".Connection Name: localhost Hostname/IP address: localhost Port: 3306 Username: root Password: (here your password you used when you created your MySQL Server)
If it's Successful click ok.
If it's Failure check everything if everything is filled out right and try again.
Now double click on MySql.
There should be some databases under it. Don't touch those. Rgh click it and click "Create New Database"
Name the database "pokeconnect" without the ""
Then double click it.
Then right click it.
And click "Execute SQL File"
Open the database you extracted to the server folder.
Click "Start" and wait for it to finish.
When it finishes click "Close" and you can close out of Navicat.
You're done with the hardest part :D
3.Setting up the Client
Go to Client/Res
Find the servers.txt file.
Change 127.0.0.1 to your IP or just leave it :P.
Make sure the IP and the server name are the same on the Server.bat and the servers.txt
Common issue(s)
Q-Doesn't work. Nothing starts!!Client features: Already has the Sprite change NPC put in.
A-Reinstall Java. Install the on I gave you.
Q-Can't connect to my server!
A- Make sure you typed in the correct mysql password and IP typed in. If it still doesn't work,try updating to a newwer version of mysql
Already has timezone fix.
Already has shiny Pokemon