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