[share] HopZone Java Vote Reward

[DarkCore]

I'm using Epilogue chronicle, but when i add this code, i get error in gs. Maybe someone knows, what should i do?

 

[extr3me]

is from mysql :| at line 1

[soragoi]

i get the same error!! anybody know how to fix this error?

[Xanderॐ]

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.

[soragoi]

same error :-[

[Xanderॐ]

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]

Here Is Corect Code http://www.maxcheaters.com/forum/index.php?topic=190452.45

[soragoi]

Thx for help.But i fix it self for freya. it works^^!!

[extr3me]

ok ;) well done

[sekker]

I would really appreciate if you adapt this code to work with l2jfree G3 >.< i've been trying to adapt it without any success.

[Vector]

Nice share..

[extr3me]

Nice share..

thx ;)