[HELP] Community server query GS database

[thaiscorpion]

L2J Community Server version=4912M

Hello, ive got i little problem:

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

Code: Select all

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

[tukune]

con = L2DatabaseFactory.getInstance().getConnection();
con = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/l2jgs", "root", "your password");