Hello folks , well im getting into the point: im facing a problem with offline buffers.
I can set them as offline buffers and work ,but they aren't restoring after restart ,also give a error at system .
Hello everyone!
I have a problem with editing mobs. I took some Mobs from here without sound and added them,
they looked good !!! BUT BUT !
When I hit him it does generate the effect, but when he hits it it doesn't.
Is this effect controlled from Npcgrp.dat?
PD_ I add capture of the event / effect I mention.
I await your answers, thank you!
Question
Irrelevant
Hello folks , well im getting into the point: im facing a problem with offline buffers.
I can set them as offline buffers and work ,but they aren't restoring after restart ,also give a error at system .
pics: https://imgur.com/a/unUqNOA
+
private void saveSellerData(L2PcInstance seller){
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection(false);
PreparedStatement statement;
statement = con.prepareStatement("CALL sellbuff_saveSellerData(?,?,?,?)");
statement.setInt(1, seller.getObjectId());
statement.setString(2, seller.getTitle());
statement.setInt(3, seller.getAppearance().getTitleColor());
statement.setInt(4, seller.getAppearance().getNameColor());
statement.execute();
statement.close();
statement = null;
}
catch(Exception e)
{
if(Config.ENABLE_ALL_EXCEPTIONS)
e.printStackTrace();
}
finally
{
CloseUtil.close(con);
con = null;
}
}
public void restoreSellerData(L2PcInstance seller){
//int defaultNickColor = 16777215; // white
//int defaultTitleColor = 16777079; // light blue
Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection(false);
PreparedStatement statement;
statement = con.prepareStatement("CALL sellbuff_restoreSellerData(?)");
statement.setInt(1, seller.getObjectId());
ResultSet res = statement.executeQuery();
while(res.next())
{
seller.setTitle(res.getString("lastTitle"));
seller.getAppearance().setTitleColor(Integer.parseInt(res.getString("lastTitleColor")));
seller.getAppearance().setNameColor(Integer.parseInt(res.getString("lastNameColor")));
}
res.close();
res = null;
statement.close();
statement = null;
}
catch(Exception e)
{
if(Config.ENABLE_ALL_EXCEPTIONS)
e.printStackTrace();
}
finally
{
CloseUtil.close(con);
con = null;
}
}
i can't fine the mistake :/ ..
thanks.
Edited by Irrelevant
7 answers to this question
Recommended Posts