https://forum.andowson.com/posts/list/7.page JForum - http://www.jforum.net [code=sql]# ###########
# KarmaModel
# ###########
...
KarmaModel.deletePostKarma = DELETE FROM jforum_karma WHERE post_id = ?
...
[/code]

2.修改net/jforum/dao/KarmaDao.java，加上deletePostKarma(int postId) method宣告
[code]public interface KarmaDAO
{
...
/**
* Deletes the karma belonging to some post.
* This method will remove the post's karma from the
* karma table.
*
* @param postId The id of the post to delete
*/
public void deletePostKarma(int postId) ;
...
}[/code]

3.修改net/jforum/dao/generic/GenericKarmaDao.java，加上deletePostKarma(int postId) method實做
[code]public class GenericKarmaDAO implements net.jforum.dao.KarmaDAO
{
...
/**
* @see net.jforum.dao.KarmaDAO#deletePostKarma(int)
*/
public void deletePostKarma(int postId)
{
PreparedStatement p = null;
try {
p = JForumExecutionContext.getConnection()
.prepareStatement(SystemGlobals.getSql("KarmaModel.deletePostKarma"));
p.setInt(1, postId);
p.executeUpdate();
}
catch (SQLException e) {
throw new DatabaseException(e);
}
finally {
DbUtils.close(p);
}
}
...[/code]

4.修改net/jforum/view/forum/PostAction.java，修改delete() method，在Karma處理部分插入karmaDao.deletePostKarma(p.getId());在重算Karma之前
[code]public class PostAction extends Command
{
...
public void delete()
{
...
// Karma
KarmaDAO karmaDao = DataAccessDriver.getInstance().newKarmaDAO();
karmaDao.deletePostKarma(p.getId());
karmaDao.updateUserKarma(p.getUserId());
...
}
...
}[/code]

5.重新編譯，並重新載入JForum]]> https://forum.andowson.com/posts/preList/298/556.page https://forum.andowson.com/posts/preList/298/556.page GMT