rikito89

LINEAGE ][ LEGENDS

A Pvp Hard Core server of the famous game Lineage2 in its version high five!(H5). Everyone’s favorite version.

Un servidor Pvp Hard Core del famoso juego Lineage2 en su versión high five! (H5). La versión favorita de todos.

http://www.lineage2legends.com/

https://discord.gg/zW9D3UdBG2

www.l2origen.com

Grand Opening 1, January, 2016.

L2J Community Server version=4912M

Hello, ive got i little problem:

im trying to query the gameserver database from the community server :

private void loadFromDB(int type) {
      java.sql.Connection con = null;
      String top;
      if (type==0)
         top = "database_stat1";
      else
         top = "database_stat2";
      try
      {
         _posId = 0;
         con = L2DatabaseFactory.getInstance().getConnection();
         PreparedStatement statement = con.prepareStatement("SELECT c.char_name, c.base_class, c."+top+", c.level, c.online, cl.clan_name, cl.ally_name FROM characters c LEFT 
         JOIN clan_data cl ON cl.clan_id=c.clanid WHERE c.accesslevel=0 ORDER BY c."+top+" DESC, c.char_name ASC LIMIT 10");

      }

But this connects to my "l2jcs" databse ad obviusly there isnt any tables called characters, how can i modify this to connect to my "l2jgs"? ty any help would be great

-Ricky

thanks.. this is for see the photo xaxaxaxa