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 already explain it to You - I can finish the job, send You the files, or if You don't like that, I can refund 50%, because I did start the work. The flood made it impossible for me to deliver on time, but I did start the work.
You asking me to send You 150% of Your payment. That's not possible. Flood wasn't by my doing, I'm not guilty here. I'm trying to be reasonable with You - deliverying the files (You are not willing to send me missing details for updater) or refunding 50%. Telling me to shup to, calling me an idiot and sending threats won't speed anything up.
GOT BACK TO WORK! Deliverying past commissions, taking new ones!
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
Link to comment
Share on other sites
7 answers to this question
Recommended Posts