public void commit(CBlockPayload block) throws Exception {
// Superclass
super.commit(block);
// Commit
UTILS.DB.executeUpdate(
"INSERT INTO comments "
+ "SET adr='"
+ this.target_adr
+ "',"
+ "parent_type='"
+ this.parent_type
+ "', "
+ "parentID='"
+ this.parentID
+ "', "
+ "comID='"
+ this.comID
+ "', "
+ "mes='"
+ UTILS.BASIC.base64_encode(this.mes)
+ "', "
+ "expire='"
+ (this.block + 43200)
+ "', "
+ "block='"
+ this.block
+ "'");
// Post ?
if (this.parent_type.equals("ID_POST"))
UTILS.DB.executeUpdate(
"UPDATE tweets " + "SET comments=comments+1 " + "WHERE tweetID='" + this.parentID + "'");
}
public void check(CBlockPayload block) throws Exception {
// Super class
super.check(block);
// Check Message
if (!UTILS.BASIC.isDesc(mes, 1000))
throw new Exception("Invalid message - CTweetMesPayload.java");
// CommentID valid
if (!UTILS.BASIC.validID(this.comID))
throw new Exception("Invalid message ID - CTweetMesPayload.java");
// Parent type
if (!this.parent_type.equals("ID_POST") && !this.parent_type.equals("ID_COM"))
throw new Exception("Invalid parent type - CTweetMesPayload.java");
// Already commented ?
ResultSet rs =
UTILS.DB.executeQuery(
"SELECT * "
+ "FROM comments "
+ "WHERE parent_type='"
+ this.parent_type
+ "' "
+ "AND parentID='"
+ this.parentID
+ "' "
+ "AND adr='"
+ this.target_adr
+ "'");
if (UTILS.DB.hasData(rs)) throw new Exception("Already commented - CTweetMesPayload.java");
// Target valid
if (!UTILS.BASIC.targetValid(this.parent_type, this.parentID))
throw new Exception("Invalid target type - CTweetMesPayload.java");
// Check Hash
String h =
UTILS.BASIC.hash(this.getHash() + this.parent_type + this.parentID + this.comID + this.mes);
if (!h.equals(this.hash)) throw new Exception("Invalid hash - CTweetMesPayload.java");
}