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"); }
public void commit(CBlockPayload block) throws Exception { // Superclass super.commit(block); // Insert asset UTILS.DB.executeUpdate( "INSERT INTO assets " + "SET adr='" + this.target_adr + "', " + "assetID='" + this.assetID + "', " + "symbol='" + this.symbol + "', " + "title='" + UTILS.BASIC.base64_encode(this.title) + "', " + "description='" + UTILS.BASIC.base64_encode(this.description) + "', " + "how_buy='" + UTILS.BASIC.base64_encode(this.how_buy) + "', " + "how_sell='" + UTILS.BASIC.base64_encode(this.how_sell) + "', " + "web_page='" + UTILS.BASIC.base64_encode(this.web_page) + "', " + "pic='" + UTILS.BASIC.base64_encode(this.pic) + "', " + "expire='" + (this.block + (1440 * this.days)) + "', " + "qty='" + this.qty + "', " + "trans_fee_adr='" + this.trans_fee_adr + "', " + "trans_fee='" + UTILS.FORMAT_2.format(this.trans_fee) + "', " + "block='" + this.block + "'"); // Update UTILS.DB.executeUpdate( "INSERT INTO assets_owners " + "SET owner='" + this.target_adr + "', " + "symbol='" + this.symbol + "', " + "qty='" + this.qty + "', " + "block='" + this.block + "'"); }
public void check(CBlockPayload block) throws Exception { // Super class super.check(block); // Valid asset ID if (!UTILS.BASIC.validID(this.assetID)) throw new Exception("Invalid asset ID - CIssueAssetPayload.java"); // Symbol length if (!UTILS.BASIC.isSymbol(this.symbol)) throw new Exception("Invalid symbol - CIssueAssetPayload.java"); // Same symbol ResultSet rs = UTILS.DB.executeQuery("SELECT * " + "FROM assets " + "WHERE symbol='" + this.symbol + "'"); if (UTILS.DB.hasData(rs)) throw new Exception("Asset symbol already exist - CIssueAssetPayload.java"); // Qty if (this.qty < 1000 || this.qty > 10000000000L) throw new Exception("Invalid qty - CIssueAssetPayload.java"); // Title if (!UTILS.BASIC.isTitle(this.title)) throw new Exception("Invalid title - CIssueAssetPayload.java"); // Description if (!UTILS.BASIC.isDesc(this.description)) throw new Exception("Invalid description - CIssueAssetPayload.java"); // Web page if (!this.web_page.equals("")) if (!UTILS.BASIC.isLink(this.web_page)) throw new Exception("Invalid web page - CIssueAssetPayload.java"); // How buy if (!this.how_buy.equals("")) if (!UTILS.BASIC.isDesc(this.how_buy)) throw new Exception("Invalid how to buy - CIssueAssetPayload.java"); // How sell if (!this.how_sell.equals("")) if (!UTILS.BASIC.isDesc(this.how_sell)) throw new Exception("Invalid to sell - CIssueAssetPayload.java"); // Pic if (!this.pic.equals("")) if (!UTILS.BASIC.isPic(this.pic)) throw new Exception("Invalid pic - CIssueAssetPayload.java"); // Days if (this.days < 1000) throw new Exception("Invalid days - CIssueAssetPayload.java"); // Transaction fee address if (!UTILS.BASIC.isAdr(this.trans_fee_adr)) throw new Exception("Invalid transaction fee address - CIssueAssetPayload.java"); // Transaction fee if (this.trans_fee < 0.01 || this.trans_fee > 10) throw new Exception("Invalid transaction fee - CIssueAssetPayload.java"); // Sealed ? if (UTILS.BASIC.isSealed(this.target_adr)) throw new Exception("Sealed address - CIssueAssetPayload.java"); // Mkt address ? if (UTILS.BASIC.isMktAdr(this.target_adr) || UTILS.BASIC.isContractAdr(this.target_adr)) throw new Exception("Market address - CIssueAssetPayload.java"); // Calculates hash String h = UTILS.BASIC.hash( this.getHash() + this.assetID + this.symbol + this.title + this.description + this.how_buy + this.how_sell + this.web_page + this.pic + days + this.qty + this.trans_fee_adr + UTILS.FORMAT_2.format(this.trans_fee)); // Check hash if (!this.hash.equals(h)) throw new Exception("Invalid hash - CIssueAssetPayload.java"); }