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 .
I apologize for my incompetence. The ability to trade is limited only for builder 1. Ordinary characters can trade with each other, and this has nothing to do with auto loot.)
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