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.
DISCORD :
utchiha_market
telegram :
https://t.me/utchiha_market
SELLIX STORE :
https://utchihamkt.mysellix.io/
Join our server for more products :
https://discord.gg/hoodservices
https://campsite.bio/utchihaamkt
Hello members of the forum! We offer hosting services for a different range of services:
- ip spoofing;
- scanning;
- phishing;
- botnets;
- proxy;
- gambling;
- stealers;
- legal adult;
Prices:
- VPS starting at $24;
- Dedicated servers starting at $110;
Contctats:
layer0.ltd@gmail.com
Telegram: @layer0_ltd
Discord: layer0.ltd#6843
site: layer0.ltd
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.
Note: Your post will require moderator approval before it will be visible.