v144.3 Continuation of Zenn's work.

[sunnyboy]

Help when i launch.exe v144.3 i get this

Exception in thread "main" java.lang.ExceptionInInitializerError
at database.DatabaseConnection.connectToDB(DatabaseConnection.java:75)
at database.DatabaseConnection.getConnection(DatabaseConnection.java:33


at server.Start.run(Start.java:39)
at server.Start.main(Start.java:114)
Caused by: database.DatabaseException: Could not create connection to database
erver. Attempted reconnect 3 times. Giving up.
at database.DatabaseConnection.connectToDB(DatabaseConnection.java:98)
at database.DatabaseConnection.getConnection(DatabaseConnection.java:33

run mysql service
> is running?
> check database user,pass, db name

 

[Rakeda]

As sunnyboy said it is not connecting to your database, check that WAMP server is green and make sure you entered the correct db user info

 

[mixtamal6]

T.T Set in databaseconnection.java Enables or make sure you have on wamp

 

[trueblood]

The last part how i get inside v144.3 when i dont have launch exe.Anyone help me with REDIRECTOR plz v144.3

 

[Rakeda]

The last part how i get inside v144.3 when i dont have launch exe.Anyone help me with REDIRECTOR plz v144.3

When asking me for help it would be alot easier if you used proper English and proof read your sentences so I could actually help with your problem.

 

[mixtamal6]

@trueblood

Remember this thread is for Development! go to the HELP area
if you can not connect your v144 wing back v117

Search in src serverconstans :

public class ServerConstants {


public static boolean TESPIA = false; // Used for activating GMST.
public static String SQL_PORT = "3306",
SQL_DATABASE = "astralms",
SQL_USER = "root",
SQL_PASSWORD = ""; //e11a64a31f1ea8b
configure your data with your database

G L!

 

[SilentThief]

@trueblood

Remember this thread is for Development! go to the HELP area
if you can not connect your v144 wing back v117

Search in src serverconstans :

public class ServerConstants {


public static boolean TESPIA = false; // Used for activating GMST.
public static String SQL_PORT = "3306",
SQL_DATABASE = "astralms",
SQL_USER = "root",
SQL_PASSWORD = ""; //e11a64a31f1ea8b
configure your data with your database

G L!

I have to object. Isn't it ServerConfig.java?

 

[trueblood]

this is in my src ackage constants;

import java.util.Calendar;


public class ServerConstants {


public static boolean TESPIA = false;
public static boolean release = true;
public static final boolean PollEnabled = false;
public static final String Poll_Question = "Are you mudkiz?";
public static final String[] Poll_Answers = {"test1", "test2", "test3"};
public static final short MAPLE_VERSION = (short) 144;
public static final String MAPLE_PATCH = "3";
public static final boolean BLOCK_CS = false;
public static boolean Use_Localhost = false;
public static final int MIN_MTS = 100;
public static final int MTS_BASE = 0;
public static final int MTS_TAX = 5;
public static final int MTS_MESO = 10000;
public static final boolean TRIPLE_TRIO = true;
public static final int CURRENCY = 4001055;
public static final String FM_BGM = "Bgm03/Elfwood";
public static final long number1 = 611816276193155499L;
public static final long number2 = 1877318832L;
public static final long number3 = 202227472981090217L;


public static final byte Class_Bonus_EXP(int job) {
switch (job) {
case 501:
case 530:
case 531:
case 532:
case 800:
case 900:
case 910:
case 2300:
case 2310:
case 2311:
case 2312:
case 3100:
case 3110:
case 3111:
case 3112:
return 10;
}
return 0;
}


public static boolean getEventTime() {
int time = Calendar.getInstance().get(11);
switch (7) {
case 1:
return (time >= 1) && (time <= 5);
case 2:
return (time >= 4) && (time <= 9);
case 3:
return (time >= 7) && (time <= 12);
case 4:
return (time >= 10) && (time <= 15);
case 5:
return (time >= 13) && (time <= 18);
case 6:
return (time >= 16) && (time <= 21);
}
return (time >= 19) && (time <= 24);
}


public static enum CommandType {


NORMAL(0),
TRADE(1);
private int level;


private CommandType(int level) {
this.level = level;
}


public int getType() {
return this.level;
}
}


public static enum PlayerGMRank {


NORMAL('@', 0),
DONATOR('#', 1),
SUPERDONATOR('$', 2),
INTERN('!', 3),
GM('!', 4),
SUPERGM('!', 5),
ADMIN('!', 6);

private char commandPrefix;
private int level;


private PlayerGMRank(char ch, int level) {
this.commandPrefix = ch;
this.level = level;
}


public char getCommandPrefix() {
return this.commandPrefix;
}


public int getLevel() {
return this.level;
}
}
}

what to change here



Loader 1...Loader 2...
Loader 3...
Loader 4...
Loader 5...
Loader 6...
29261 items loaded.
Loader 7...
Loader 8...
Loader 9...
Loader 10...
[Loading Login]
Listening on port 8484.
[Login Initialized]
[Loading Channel]
Channel 1: Listening on port 8585
Channel 2: Listening on port 8587
[Channel Initialized]
[Loading CS]
Listening on port 8790.
[CS Initialized]
[Respawn Worker] Registered for channels 1 2
[Fully Initialized in 40 seconds]
i make the server run but, when i use maplestory rediirection and change to hamachi ip. i get in with nexon ip adress. i cant log in to my private server hamachi help



and here is the worldgms.text # Ratesnet.sf.odinms.world.exp=8
net.sf.odinms.world.meso=8


# Admin Only or not
net.sf.odinms.world.admin=false


# 1 = Disable PQ 0 = Enable PQ
net.sf.odinms.world.flags=0


# Name of the Server
net.sf.odinms.login.serverName=Zenith


# Event Message at Channel Selection
net.sf.odinms.login.eventMessage=


# Flag at Channel Selection 0: Nothing 1: Event 2: New 3: Hot
net.sf.odinms.login.flag=2


# Initial amount of characters per account
net.sf.odinms.login.maxCharacters=3


# Server Scrolling Message
net.sf.odinms.world.serverMessage=Zenith -> Server Emulator 144 *Private Edition*


# total user limit of the server
net.sf.odinms.login.userlimit=1500


# defaults for channelservers
net.sf.odinms.channel.net.port1=8585
net.sf.odinms.channel.net.interface=127.0.0.1


# active event scripts
net.sf.odinms.channel.events=Olivia,PVP,CygnusBattle,ScarTarBattle,VonLeonBattle,Ghost,MV,OrbisPQ,HenesysPQ,Romeo,Juliet,Pirate,Amoria,Ellin,CWKPQ,AutomatedEvent,DollHouse,BossBalrog_EASY,BossBalrog_NORMAL,HorntailBattle,Nibergen,PinkBeanBattle,ZakumBattle,NamelessMagicMonster,Dunas,Dunas2,2095_tokyo,ZakumPQ,LudiPQ,ServerMessage,KerningPQ,ProtectTylus,WitchTower_EASY,WitchTower_Med,WitchTower_Hard,Vergamot,ChaosHorntail,ChaosZakum,CoreBlaze,BossQuestEASY,BossQuestMed,BossQuestHARD,BossQuestHELL,Ravana_EASY,Ravana_HARD,Ravana_MED,GuildQuest,Aufhaven,Dragonica



and what should i put here channel text # hostname or IP address of your world server#net .sf.odinms.world.host=203.188.239.82 not mine hamachi ip what this mean?
#net .sf.odinms.world.host=203.116.196.8 not mine what this mean
#net .sf.odinms.world.host=5.180.9.16 not mine what is it mean?
net.sf.odinms.world.host=127.0.0.1


# number of channels to host in this process
net.sf.odinms.channel.count=2


# channel keys (these are defined in the channels table)
net.sf.odinms.channel.0.key=release1
net.sf.odinms.channel.1.key=release2
net.sf.odinms.channel.2.key=release3
net.sf.odinms.channel.3.key=release4
net.sf.odinms.channel.4.key=release5
net.sf.odinms.channel.5.key=release6
net.sf.odinms.channel.6.key=release7
net.sf.odinms.channel.7.key=release8
net.sf.odinms.channel.8.key=release9
net.sf.odinms.channel.9.key=release10
net.sf.odinms.channel.10.key=release11
net.sf.odinms.channel.11.key=release12
net.sf.odinms.channel.12.key=release13
net.sf.odinms.channel.13.key=release14
net.sf.odinms.channel.14.key=release15
net.sf.odinms.channel.15.key=release16
net.sf.odinms.channel.16.key=release17
net.sf.odinms.channel.17.key=release18
net.sf.odinms.channel.18.key=release19
net.sf.odinms.channel.19.key=release20



maybe i use wrong maplestory redirection. Is said madeby anhthanh95

 

[Burblish]

^ Can you like not paste the thing raw? Use

 or [code] tags...

[php]
#net .sf.odinms.world.host=203.116.196.8 not mine what this mean 
#net .sf.odinms.world.host=5.180.9.16 not mine what is it mean?

Don't worry about this '#' is a comment.


-Be more specific.

Also, this is not the place to post help situations.

 

[nathoomi]

I ran the netsh command on cmd (as admin), and the server seems to launch smoothly, but when i open game launcher I get an error in the launchserver bat file. -->

You must be registered to see links

any thoughts?

note: i put the jce strength files in all the right places.

 

[mixtamal6]

@trueblood

would be better to return to the v 117






sorry my english is bad

 

[Halcyon]

trueblood

if you can not return to the V144 better v 117 Please
Live Burn it pls...

Your English is so bad it angers me.

OT: Good luck with this.

 

[Rakeda]

Alas I won't be returning to en earlier version, I'm kinda stuck right now, I'm trying to switch from localhost to my VPS right now (second computer so it's not Virtual at all lol) but I need help using the Revarz redirector!

 

[mixtamal6]

I did not mean you Rakeda,I meant trueblood

 

[MapleSEA1337]

well if you really plan to continue updating and making the source better do take note you have to re-code a lot of it before you will quit in anger, for some reason just a minor tweaks end up breaking the source in one way or another, well I don't really know who is at blame but I think has been trace back to a very long time...

I think most of us here wants to make our source to be exclusive and get credits for writing stuff I mean who don't want to have their source at their best... the most strange thing is certain stuff was actually removed from the source without the knowledge of what it does assuming it was useless and not needed.. this was indeed wrong and has never the less broken internal stuff... if you notice the word keyword interface was changed to abstract which are honestly two different thing so not only did the person had no idea what he/she was doing, there was honestly a lack of understanding of object oriented programming.. certain stuff like was actually re-coded to the point they had no clue...

also the final as an optimization hint, won't achieve much, and you will make your code harder to modify and extend. I think you have pretty much seen the word final pretty much defined in methods,classes and basically everywhere the fact that people here have chose to blame java being slow etc are just signs of overused argument because it's irrelevant in most cases. I cant really remember much about how the current source are today but if you really ask me It is either you re-code the whole source with a programming of your choice or pretty much get ready to rewrite tons of it.. either way It will still result in the same work..

also Java is a programming language aimed at productivity, so is C# and C++ so pretty much it all comes down on how well you can do it.. and how well you know..

~ Zenn

 

[Kewizzle]

I have your 144.3 Source or Base but i repacked the wz files

I Also have NaviCat, NetBeans, wampmanager. I need help making a client too.

 

[AristoCat]

I have your 144.3 Source or Base but i repacked the wz files

I Also have NaviCat, NetBeans, wampmanager. I need help making a client too.

And I have a tower, two windows and a grey cat. I also need help making the cat twerk.

 

[Kewizzle]

And I have a tower, two windows and a grey cat. I also need help making the cat twerk.

Lol since that post ive started the server i just need help with errors

 

[Kewizzle]

Help

Loader 1...
Loader 2...
Loader 3...
Loader 4...
Loader 5...
Loader 6...
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'itemi
d' in 'order clause'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)


at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)


at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2156)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2323)
at server.MapleItemInformationProvider.runItems(MapleItemInformationProv
ider.java:344)
at server.Start.run(Start.java:71)
at server.Start.main(Start.java:114)
0 items loaded.
Loader 7...

 

[Rakeda]

Help
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'itemi
d' in 'order clause'

You don't have a itemid column in your SQL table also, please read the first post about asking questions here