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
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Hello,iv got fafurion running localy just for fun and seems that files dont have geodata couse i can hit through walls so are mobs.Anyone can tell me how to activate geodata or where to insert geodata files?
Question
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
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.