same question
Printable View
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
SQL_USER cannot be resolved or is not a field
SQL_PASSWORD cannot be resolved or is not a field
at database.DatabaseConnection$ThreadLocalConnection.initialValue(Databa
seConnection.java:110)
at database.DatabaseConnection$ThreadLocalConnection.initialValue(Databa
seConnection.java:1)
at java.lang.ThreadLocal.setInitialValue(Unknown Source)
at java.lang.ThreadLocal.get(Unknown Source)
at database.DatabaseConnection.getConnection(DatabaseConnection.java:86)
at server.Start.run(Start.java:37)
at server.Start.main(Start.java:111)
Press any key to continue . . .
Someone wanna help me?
Cant log in help~
I got a new problem. I redid everything you did before and here is the new problem:
Loader 1...
Loader 2...
Loader 3...
Loader 4...
Loader 5...
Loader 6...
32052 items loaded.
Loader 7...
Loader 8...
Loader 9...
Loader 10...
[Loading Login]
Listening on port 8484.
[Login Initialized]
[Loading Channel]
Exception in thread "main" java.lang.RuntimeException: java.lang.NumberFormatExc
eption: For input string: "500 "
at handling.channel.ChannelServer.run_startup_configurations(ChannelServ
er.java:110)
at handling.channel.ChannelServer.startChannel_Main(ChannelServer.java:3
06)
at server.Start.run(Start.java:92)
at server.Start.main(Start.java:111)
Caused by: java.lang.NumberFormatException: For input string: "500
"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at handling.channel.ChannelServer.run_startup_configurations(ChannelServ
er.java:102)
... 3 more
EDIT: Found out how to locate them. All commands are in the GMCommand and SuperGMCommand java files (go figure).
Hi,
I've got my server running via hamachi and my friends are joining.. but I don't know all of the GM commands for version 142. Would anyone happen to know the full list for version 142? Or would it be possible to extract the GM command list from any of the Java files? Any help would be appreciated.
Thanks again for the great tutorial.
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.
i cant run the server when i run iRedirectoRX in the maplestory map it says failed to initialize iRedirectoRX
WHAT to do?!?! :(
Try downloading Net Framework 4.5 on your PC. Also run the program in administrator. I know some people have problems running iRedirecoRX on Windows XP and 8. If you're running Windows 8, try and change the compatibility mode to perform in Windows 7 or Vista. Disable any antivirus and firewall software. If its still not working, try the IP Redirect Tool or download a different Redirector program (I use M-Launcher).
can you open the server to other lan players or hamachi players?
So , let say I want to make another version(not v142) or another game , the same things that I need to make private server is :
Eclipse
Java SE Development Kit (JDK7)
MySQL WorkBench
JCE7 Unlimited Strength Files
Wamp Server
The original file of that game
And the same version of the private server
Is this right ?
First off I read through all the pages to make sure I didn't repeat this question.
I got this error message from launch.bat:
Additional details:Code:ERRORjava.sql.SQLException: No suitable driver found for "jdbc:mysql://localhost
:3306/librams?autoReconnect=true"
Exception in thread "main" java.lang.NullPointerException
at server.Start.run(Start.java:37)
at server.Start.main(Start.java:111)
Press any key to continue . . .
I used Netbeans instead of Eclipse,
Navicat instead of MySQL Workbench
XAMPP instead of Wampserver
So any ideas?
Have you imported the .jar files into the project?
- - - Updated - - -
Quick question :
Does the default client login includes encryption of password? If yes, what kind of password encryption does it use?
If not, which file do I edit to add in password encryption?
Lastly, which CMS can I use for this? Thanks!