DarkCore Posted December 13, 2010 Posted December 13, 2010 I'm using Epilogue chronicle, but when i add this code, i get error in gs. Maybe someone knows, what should i do?
soragoi Posted January 6, 2011 Posted January 6, 2011 i get the same error!! anybody know how to fix this error?
Xanderॐ Posted January 6, 2011 Posted January 6, 2011 Show me the sql and ill solve it, i dont have VIP status. PS one possibility is that it needs space between c LEFT and as a ON Here is the correct: PreparedStatement statement = con.prepareStatement("" + + "SELECT" + + " c.charId," + + " c.char_name" + + " FROM" + + " characters AS c" + + " LEFT JOIN" + + " accounts AS a" + + " ON" + + " c.account_name = a.login" + + " WHERE" + + " c.online > 0" + + " GROUP BY" + + " a.lastIP" + + " ORDER BY" + + " c.level" + + " DESC"); PS: Whoever did this share bravos for using JOIN on tables. But he is a tard for making a useless vote shit. Servers should focus on becoming BETTER rather than trying to trick vote sites with silly reward scripts.
Xanderॐ Posted January 7, 2011 Posted January 7, 2011 Show me the sql and ill solve it, i dont have VIP status. PS one possibility is that it needs space between c LEFT and as a ON Here is the correct: PreparedStatement statement = con.prepareStatement("" + + "SELECT" + + " c.charId," + + " c.char_name" + + " FROM" + + " characters AS c" + + " LEFT JOIN" + + " accounts AS a" + + " ON" + + " c.account_name = a.login" + + " WHERE" + + " c.online > 0" + + " GROUP BY" + + " a.lastIP" + + " ORDER BY" + + " c.level" + + " DESC"); PS: Whoever did this share bravos for using JOIN on tables. But he is a tard for making a useless vote shit. Servers should focus on becoming BETTER rather than trying to trick vote sites with silly reward scripts. Try now i edited it a bit, copy the quoted code.
extr3me Posted January 7, 2011 Author Posted January 7, 2011 Here Is Corect Code http://www.maxcheaters.com/forum/index.php?topic=190452.45
soragoi Posted January 7, 2011 Posted January 7, 2011 Thx for help.But i fix it self for freya. it works^^!!
sekker Posted January 9, 2011 Posted January 9, 2011 I would really appreciate if you adapt this code to work with l2jfree G3 >.< i've been trying to adapt it without any success.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now