[HELP] Community server query GS database

[rikito89]

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