[HELP] Community server query GS database
Posted: Sat Sep 24, 2011 9:11 am
L2J Community Server version=4912M
Hello, ive got i little problem:
im trying to query the gameserver database from the community server :
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
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"); }
con = L2DatabaseFactory.getInstance().getConnection();
con = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/l2jgs", "root", "your password");