DarkCore Posted December 13, 2010 Share 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? Quote Link to comment Share on other sites More sharing options...
extr3me Posted December 14, 2010 Author Share Posted December 14, 2010 is from mysql :| at line 1 Quote Link to comment Share on other sites More sharing options...
soragoi Posted January 6, 2011 Share Posted January 6, 2011 i get the same error!! anybody know how to fix this error? Quote Link to comment Share on other sites More sharing options...
Xanderॐ Posted January 6, 2011 Share 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. Quote Link to comment Share on other sites More sharing options...
soragoi Posted January 7, 2011 Share Posted January 7, 2011 same error :-[ Quote Link to comment Share on other sites More sharing options...
Xanderॐ Posted January 7, 2011 Share 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. Quote Link to comment Share on other sites More sharing options...
extr3me Posted January 7, 2011 Author Share Posted January 7, 2011 Here Is Corect Code http://www.maxcheaters.com/forum/index.php?topic=190452.45 Quote Link to comment Share on other sites More sharing options...
soragoi Posted January 7, 2011 Share Posted January 7, 2011 Thx for help.But i fix it self for freya. it works^^!! Quote Link to comment Share on other sites More sharing options...
extr3me Posted January 7, 2011 Author Share Posted January 7, 2011 ok ;) well done Quote Link to comment Share on other sites More sharing options...
sekker Posted January 9, 2011 Share 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. Quote Link to comment Share on other sites More sharing options...
Vector Posted February 3, 2011 Share Posted February 3, 2011 Nice share.. Quote Link to comment Share on other sites More sharing options...
extr3me Posted February 16, 2011 Author Share Posted February 16, 2011 Nice share.. thx ;) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.