[펌]성세금 20억 제한(에바)

CastleTable.java

public void updateCastle(L1Castle castle) { <=검색

Connection con = null;

PreparedStatement pstm = null;

try {

 

 

int money; //요기부터

if (castle.getPublicMoney() > 2000000000){

money = 2000000000;

}else{

money = castle.getPublicMoney();

} //요기까지

 

 

con = L1DatabaseFactory.getInstance().getConnection();

pstm = con.prepareStatement("UPDATE castle SET name=?, war_time=?, tax_rate=?, public_money=?, public_ready_money=?, show_money=?, war_basetime=?, security=? WHERE castle_id=?");

pstm.setString(1, castle.getName());

SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");

String fm = sdf.format(castle.getWarTime().getTime());

// String fm = DateFormat.getDateTimeInstance().format( //## A1 원본

// castle.getWarTime().getTime()); //#

pstm.setString(2, fm);

pstm.setInt(3, castle.getTaxRate());

 

 

//pstm.setInt(4, castle.getPublicMoney());
pstm.setInt(4, money); //이렇게변경

 

 

pstm.setInt(5, castle.getPublicReadyMoney());

pstm.setInt(6, castle.getShowMoney());

pstm.setInt(7, castle.getWarBaseTime());

// String ft = sdf.format(castle.getTimeBase().getTime());

// pstm.setString(8, ft);

pstm.setInt(8, castle.getCastleSecurity());

pstm.setInt(9, castle.getId());

pstm.execute();

 

_castles.put(castle.getId(), castle);

} catch (SQLException e) {

_log.log(Level.SEVERE, e.getLocalizedMessage(), e);

} finally {

SQLUtil.close(pstm);

SQLUtil.close(con);

 

 

 

TownTable.java

public synchronized void addSalesMoney(int town_id, int salesMoney) { <= 검색

Connection con = null;

PreparedStatement pstm = null;

 

L1Town town = TownTable.getInstance().getTownTable(town_id);

int townTaxRate = town.get_tax_rate();

 

int townTax = salesMoney / 100 * townTaxRate;

int townFixTax = salesMoney / 100 * 2;

if (townTax <= 0 && townTaxRate > 0) {

townTax = 1;

}

if (townFixTax <= 0 && townTaxRate > 0) {

townFixTax = 1;

}

 

try {

con = L1DatabaseFactory.getInstance().getConnection();

pstm = con.prepareStatement("UPDATE town SET sales_money = sales_money + ?, town_tax = town_tax + ?, town_fix_tax = town_fix_tax + ? WHERE town_id = ?");

pstm.setInt(1, salesMoney);

pstm.setInt(2, townTax);

pstm.setInt(3, townFixTax);

pstm.setInt(4, town_id);

pstm.execute();

int money; //요기부터

 

 

if (town.get_sales_money() + salesMoney > 2000000000){

money = 2000000000;

}else{

money = town.get_sales_money() + salesMoney;

}

town.set_sales_money(money); //요기까지

//town.set_sales_money(town.get_sales_money() + salesMoney);

 

 

town.set_town_tax(town.get_town_tax() + townTax);

town.set_town_fix_tax(town.get_town_fix_tax() + townFixTax);

 

} catch (SQLException e) {

_log.log(Level.SEVERE, e.getLocalizedMessage(), e);

} finally {

SQLUtil.close(pstm);

SQLUtil.close(con);

}

}

 

 

 

 

옆동네 야메루님거 퍼왔습니다.