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
✯✯✯✯✯✯✯✯✯✯✯✯ UPDATE ✯✯✯✯✯✯✯✯✯✯✯✯✯✯
Protocol Version 450
[ Date 26.09.2023 ][ LANG:KOREAN-ORIGINAL ]
Clean System Patch Lineage 2
L2exe + Core.dll + Engine.dll unpacked 100% works
[unpacked REVERSECODE-TEAM ]
[ Kill game guard ][ Kill FROST ]
[ Kill AwesomiumProcess ]
DEVMODE - we will make to order
Sell Clean System [ WTS PM ME ]
✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯
[REVERSECODE-TEAM] PATCH DEVELOPER LABORATORY
Portfolio Discord Group https://discord.gg/56EuZyFJj2
Hello guys. Is there any interface that works on L2-Damage ? I mean auto assist and auto skills casting without pressing F button ? If anyone know i can buy it.
Question
rikito89
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
-Ricky
Link to comment
Share on other sites
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.