How do i make the client, so my friends can join? we are 5.
Hi KristianDH,
I use Hamachi but WanIP is accessible as well. First check that you are able to connect to phpmyadmin via your WampServer (type in your WanIP or Hamachi IP into your web browser). Also make sure you have your ports forwarded for all of the software:
If running Hamachi connectivity:
UDP 17771 relay connection port
If running WanIP (both TCP/UDP):
port 3306 (this will be assigned to your WanIP in MySQL Workbench -- still forward this port anyways)
-------
MapleStory channels (both TCP/UDP):
external: 8585 || internal: 8605
MapleStory Login (both TCP/UDP):
external: 8484 || internal: 8484
MapleStory Server (both TCP/UDP):
external: 8790 || internal: 8790
Wamp_1 port:
external: 443 || internal: 443
Wamp_2 port:
external: 80 || internal: 80
------
Once port forwarding is done, go into MySQL workbench and instead of creating a connection with Hostname: 127.0.0.1, change this to either your Hamachi IP or WanIP address. Port is 3306 and username is root. This allows all connection via MySQL to edit the database on either your Hamachi or WanIP address(es) instead of localhost.
As stated in the tutorial, when setting SQL_URL: in the ServerContants.java file, set the URL to "jdbc:mysql://<YourHamachiOrWanIPAddress>/<TheNameOfYourDatabase>?autoReconnect=true",
You need to save the SQL_URL directory to your db properties file in line 1 that reals 'url=' (the tutorial shows you how to do this). Enter your IP address after the 'net.sf.odinms.world.host=' in line 2 of the channel properties file AND in the worldGMS properties file on line 32 that reals 'net.sf.odinms.channel.net.interface='. Save these files and make sure you have set the CLIENT_START to recognize your IP address to log in with the admin credentials. You'll have to create new accounts for each friend you have joining in the accounts table in MySQL and create a new access line with their specific IP address in CLIENT_START for them to auto log in.
EDIT: I forgot to state as well -- go into phpmyadmin via your Hamachi or WanIP address and click on Users tab. Click on 'Add user ' and under Login Information set User name to root and Host with either your Hamachi ip or WanIP address. Leave the password blank and set the privileges to global privilege settings (all editing privileges should be checked). Click Go. This allows access via MySQL connection to grant it super admin privileges to edit your database.