ConnectInputs + stubs for GetCoinAge, GetMinFee and GetProofOfStakeReward.
[NovacoinLibrary.git] / Novacoin / CBlockStore.cs
index cb07aec..97ce54e 100644 (file)
 
 using System;
 using System.IO;
-using System.Linq;
 using System.Collections.Concurrent;
 
 using SQLite.Net;
-using SQLite.Net.Attributes;
 using SQLite.Net.Interop;
 using SQLite.Net.Platform.Generic;
-using SQLiteNetExtensions.Attributes;
 using System.Collections.Generic;
-using System.Diagnostics.Contracts;
 using System.Text;
+using System.Diagnostics.Contracts;
+using System.Linq;
 
 namespace Novacoin
 {
-    [Table("ChainState")]
-    public class ChainState
-    {
-        [PrimaryKey, AutoIncrement]
-        public long itemId { get; set; }
-
-        /// <summary>
-        /// Hash of top block in the best chain
-        /// </summary>
-        public byte[]  HashBestChain { get; set; }
-
-        /// <summary>
-        /// Total trust score of best chain
-        /// </summary>
-        public byte[] BestChainTrust { get; set; }
-
-        public uint nBestHeight { get; set;}
-
-        [Ignore]
-        public uint256 nBestChainTrust
-        {
-            get { return BestChainTrust; }
-            set { BestChainTrust = value; }
-        }
-
-        [Ignore]
-        public uint256 nHashBestChain
-        {
-            get { return HashBestChain; }
-            set { HashBestChain = value; }
-        }
-    }
-
-    [Table("BlockStorage")]
-    public class CBlockStoreItem : IBlockStorageItem
-    {
-        #region IBlockStorageItem
-        /// <summary>
-        /// Item ID in the database
-        /// </summary>
-        [PrimaryKey, AutoIncrement]
-        public long ItemID { get; set; }
-
-        /// <summary>
-        /// PBKDF2+Salsa20 of block hash
-        /// </summary>
-        [Unique]
-        public byte[] Hash { get; set; }
-
-        /// <summary>
-        /// Version of block schema
-        /// </summary>
-        [Column("nVersion")]
-        public uint nVersion { get; set; }
-
-        /// <summary>
-        /// Previous block hash.
-        /// </summary>
-        [Column("prevHash")]
-        public byte[] prevHash { get; set; }
-
-        /// <summary>
-        /// Merkle root hash.
-        /// </summary>
-        [Column("merkleRoot")]
-        public byte[] merkleRoot { get; set; }
-
-        /// <summary>
-        /// Block timestamp.
-        /// </summary>
-        [Column("nTime")]
-        public uint nTime { get; set; }
-
-        /// <summary>
-        /// Compressed difficulty representation.
-        /// </summary>
-        [Column("nBits")]
-        public uint nBits { get; set; }
-
-        /// <summary>
-        /// Nonce counter.
-        /// </summary>
-        [Column("nNonce")]
-        public uint nNonce { get; set; }
-
-        /// <summary>
-        /// Next block hash.
-        /// </summary>
-        [Column("nextHash")]
-        public byte[] nextHash { get; set; }
-
-        /// <summary>
-        /// Block type flags
-        /// </summary>
-        [Column("BlockTypeFlag")]
-        public BlockType BlockTypeFlag { get; set; }
-
-        /// <summary>
-        /// Stake modifier
-        /// </summary>
-        [Column("nStakeModifier")]
-        public long nStakeModifier { get; set; }
-
-        /// <summary>
-        /// Proof-of-Stake hash
-        /// </summary>
-        [Column("hashProofOfStake")]
-        public byte[] hashProofOfStake { get; set; }
-
-        /// <summary>
-        /// Stake generation outpoint.
-        /// </summary>
-        [Column("prevoutStake")]
-        public byte[] prevoutStake { get; set; }
-
-        /// <summary>
-        /// Stake generation time.
-        /// </summary>
-        [Column("nStakeTime")]
-        public uint nStakeTime { get; set; }
-
-        /// <summary>
-        /// Block height, encoded in VarInt format
-        /// </summary>
-        [Column("nHeight")]
-        public uint nHeight { get; set; }
-
-        /// <summary>
-        /// Chain trust score, serialized and trimmed uint256 representation.
-        /// </summary>
-        [Column("ChainTrust")]
-        public byte[] ChainTrust { get; set; }
-
-        /// <summary>
-        /// Block position in file, encoded in VarInt format
-        /// </summary>
-        [Column("BlockPos")]
-        public byte[] BlockPos { get; set; }
-
-        /// <summary>
-        /// Block size in bytes, encoded in VarInt format
-        /// </summary>
-        [Column("BlockSize")]
-        public byte[] BlockSize { get; set; }
-        #endregion
-
-        /// <summary>
-        /// Accessor and mutator for BlockPos value.
-        /// </summary>
-        [Ignore]
-        public long nBlockPos
-        {
-            get { return (long)VarInt.DecodeVarInt(BlockPos); }
-            set { BlockPos = VarInt.EncodeVarInt(value); }
-        }
-
-        /// <summary>
-        /// Accessor and mutator for BlockSize value.
-        /// </summary>
-        [Ignore]
-        public int nBlockSize
-        {
-            get { return (int)VarInt.DecodeVarInt(BlockSize); }
-            set { BlockSize = VarInt.EncodeVarInt(value); }
-        }
-
-        /// <summary>
-        /// Fill database item with data from given block header.
-        /// </summary>
-        /// <param name="header">Block header</param>
-        /// <returns>Header hash</returns>
-        public uint256 FillHeader(CBlockHeader header)
-        {
-            uint256 _hash = header.Hash;
-
-            Hash = _hash;
-
-            nVersion = header.nVersion;
-            prevHash = header.prevHash;
-            merkleRoot = header.merkleRoot;
-            nTime = header.nTime;
-            nBits = header.nBits;
-            nNonce = header.nNonce;
-
-            return _hash;
-        }
-
-        /// <summary>
-        /// Reconstruct block header from item data.
-        /// </summary>
-        public CBlockHeader BlockHeader
-        {
-            get
-            {
-                CBlockHeader header = new CBlockHeader();
-
-                header.nVersion = nVersion;
-                header.prevHash = prevHash;
-                header.merkleRoot = merkleRoot;
-                header.nTime = nTime;
-                header.nBits = nBits;
-                header.nNonce = nNonce;
-
-                return header;
-            }
-        }
-
-        /// <summary>
-        /// Read block from file.
-        /// </summary>
-        /// <param name="reader">Stream with read access.</param>
-        /// <param name="reader">CBlock reference.</param>
-        /// <returns>Result</returns>
-        public bool ReadFromFile(ref Stream reader, out CBlock block)
-        {
-            var buffer = new byte[nBlockSize];
-            block = null;
-
-            try
-            {
-                reader.Seek(nBlockPos, SeekOrigin.Begin);
-
-                if (nBlockSize != reader.Read(buffer, 0, nBlockSize))
-                {
-                    return false;
-                }
-
-                block = new CBlock(buffer);
-
-                return true;
-            }
-            catch (IOException)
-            {
-                // I/O error
-                return false;
-            }
-            catch (BlockException)
-            {
-                // Constructor exception
-                return false;
-            }
-        }
-
-        /// <summary>
-        /// Writes given block to file and prepares cursor object for insertion into the database.
-        /// </summary>
-        /// <param name="writer">Stream with write access.</param>
-        /// <param name="block">CBlock reference.</param>
-        /// <returns>Result</returns>
-        public bool WriteToFile(ref Stream writer, ref CBlock block)
-        {
-            try
-            {
-                byte[] blockBytes = block;
-
-                var magicBytes = BitConverter.GetBytes(CBlockStore.nMagicNumber);
-                var blkLenBytes = BitConverter.GetBytes(blockBytes.Length);
-
-                // Seek to the end and then append magic bytes there.
-                writer.Seek(0, SeekOrigin.End);
-                writer.Write(magicBytes, 0, magicBytes.Length);
-                writer.Write(blkLenBytes, 0, blkLenBytes.Length);
-
-                // Save block size and current position in the block cursor fields.
-                nBlockPos = writer.Position;
-                nBlockSize = blockBytes.Length;                
-
-                // Write block and flush the stream.
-                writer.Write(blockBytes, 0, blockBytes.Length);
-                writer.Flush();
-
-                return true;
-            }
-            catch (IOException)
-            {
-                // I/O error
-                return false;
-            }
-            catch (Exception)
-            {
-                // Some serialization error
-                return false;
-            }
-        }
-
-        /// <summary>
-        /// Previous block cursor
-        /// </summary>
-        [Ignore]
-        public CBlockStoreItem prev
-        {
-            get { return CBlockStore.Instance.GetMapCursor(prevHash); }
-        }
-
-        /// <summary>
-        /// Next block cursor
-        /// </summary>
-        [Ignore]
-        public CBlockStoreItem next
-        {
-            get
-            {
-                if (nextHash == null)
-                {
-                    return null;
-                }
-
-                return CBlockStore.Instance.GetMapCursor(nextHash);
-            }
-            set
-            {
-                nextHash = value.Hash;
-
-                CBlockStore.Instance.UpdateMapCursor(this);
-            }
-        }
-
-        [Ignore]
-        bool IsInMainChain
-        {
-            get { return (next != null); }
-        }
-
-        /// <summary>
-        /// STake modifier generation flag
-        /// </summary>
-        [Ignore]
-        public bool GeneratedStakeModifier
-        {
-            get { return (BlockTypeFlag & BlockType.BLOCK_STAKE_MODIFIER) != 0; }
-        }
-
-        /// <summary>
-        /// Stake entropy bit
-        /// </summary>
-        [Ignore]
-        public uint StakeEntropyBit
-        {
-            get { return ((uint)(BlockTypeFlag & BlockType.BLOCK_STAKE_ENTROPY) >> 1); }
-        }
-
-        /// <summary>
-        /// Sets stake modifier and flag.
-        /// </summary>
-        /// <param name="nModifier">New stake modifier.</param>
-        /// <param name="fGeneratedStakeModifier">Set generation flag?</param>
-        public void SetStakeModifier(long nModifier, bool fGeneratedStakeModifier)
-        {
-            nStakeModifier = nModifier;
-            if (fGeneratedStakeModifier)
-                BlockTypeFlag |= BlockType.BLOCK_STAKE_MODIFIER;
-        }
-
-        /// <summary>
-        /// Set entropy bit.
-        /// </summary>
-        /// <param name="nEntropyBit">Entropy bit value (0 or 1).</param>
-        /// <returns>False if value is our of range.</returns>
-        public bool SetStakeEntropyBit(byte nEntropyBit)
-        {
-            if (nEntropyBit > 1)
-                return false;
-            BlockTypeFlag |= (nEntropyBit != 0 ? BlockType.BLOCK_STAKE_ENTROPY : 0);
-            return true;
-        }
-
-        /// <summary>
-        /// Set proof-of-stake flag.
-        /// </summary>
-        public void SetProofOfStake()
-        {
-            BlockTypeFlag |= BlockType.BLOCK_PROOF_OF_STAKE;
-        }
-
-        /// <summary>
-        /// Block has no proof-of-stake flag.
-        /// </summary>
-        [Ignore]
-        public bool IsProofOfWork
-        {
-            get { return (BlockTypeFlag & BlockType.BLOCK_PROOF_OF_STAKE) == 0; }
-        }
-
-        /// <summary>
-        /// Block has proof-of-stake flag set.
-        /// </summary>
-        [Ignore]
-        public bool IsProofOfStake 
-        {
-            get { return (BlockTypeFlag & BlockType.BLOCK_PROOF_OF_STAKE) != 0; }
-        }
-
-        /// <summary>
-        /// Block trust score.
-        /// </summary>
-        [Ignore]
-        public uint256 nBlockTrust
-        {
-            get
-            {
-                uint256 nTarget = 0;
-                nTarget.Compact = nBits;
-
-                /* Old protocol */
-                if (nTime < NetInfo.nChainChecksSwitchTime)
-                {
-                    return IsProofOfStake ? (new uint256(1) << 256) / (nTarget + 1) : 1;
-                }
-
-                /* New protocol */
-
-                // Calculate work amount for block
-                var nPoWTrust = NetInfo.nPoWBase / (nTarget + 1);
-
-                // Set nPowTrust to 1 if we are checking PoS block or PoW difficulty is too low
-                nPoWTrust = (IsProofOfStake || !nPoWTrust) ? 1 : nPoWTrust;
-
-                // Return nPoWTrust for the first 12 blocks
-                if (prev == null || prev.nHeight < 12)
-                    return nPoWTrust;
-
-                CBlockStoreItem currentIndex = prev;
-
-                if (IsProofOfStake)
-                {
-                    var nNewTrust = (new uint256(1) << 256) / (nTarget + 1);
-
-                    // Return 1/3 of score if parent block is not the PoW block
-                    if (!prev.IsProofOfWork)
-                    {
-                        return nNewTrust / 3;
-                    }
-
-                    int nPoWCount = 0;
-
-                    // Check last 12 blocks type
-                    while (prev.nHeight - currentIndex.nHeight < 12)
-                    {
-                        if (currentIndex.IsProofOfWork)
-                        {
-                            nPoWCount++;
-                        }
-                        currentIndex = currentIndex.prev;
-                    }
-
-                    // Return 1/3 of score if less than 3 PoW blocks found
-                    if (nPoWCount < 3)
-                    {
-                        return nNewTrust / 3;
-                    }
-
-                    return nNewTrust;
-                }
-                else
-                {
-                    var nLastBlockTrust = prev.nChainTrust - prev.prev.nChainTrust;
-
-                    // Return nPoWTrust + 2/3 of previous block score if two parent blocks are not PoS blocks
-                    if (!prev.IsProofOfStake || !prev.prev.IsProofOfStake)
-                    {
-                        return nPoWTrust + (2 * nLastBlockTrust / 3);
-                    }
-
-                    int nPoSCount = 0;
-
-                    // Check last 12 blocks type
-                    while (prev.nHeight - currentIndex.nHeight < 12)
-                    {
-                        if (currentIndex.IsProofOfStake)
-                        {
-                            nPoSCount++;
-                        }
-                        currentIndex = currentIndex.prev;
-                    }
-
-                    // Return nPoWTrust + 2/3 of previous block score if less than 7 PoS blocks found
-                    if (nPoSCount < 7)
-                    {
-                        return nPoWTrust + (2 * nLastBlockTrust / 3);
-                    }
-
-                    nTarget.Compact = prev.nBits;
-
-                    if (!nTarget)
-                    {
-                        return 0;
-                    }
-
-                    var nNewTrust = (new uint256(1) << 256) / (nTarget + 1);
-
-                    // Return nPoWTrust + full trust score for previous block nBits
-                    return nPoWTrust + nNewTrust;
-                }
-            }
-        }
-
-        /// <summary>
-        /// Stake modifier checksum.
-        /// </summary>
-        public uint nStakeModifierChecksum;
-
-        /// <summary>
-        /// Chain trust score
-        /// </summary>
-        [Ignore]
-        public uint256 nChainTrust {
-            get { return Interop.AppendWithZeros(ChainTrust); }
-            set { ChainTrust = Interop.TrimArray(value); }
-        }
-
-        public long nMint { get; internal set; }
-        public long nMoneySupply { get; internal set; }
-    }
-
-    /// <summary>
-    /// Block type.
-    /// </summary>
-    public enum BlockType
-    {
-        BLOCK_PROOF_OF_STAKE = (1 << 0), // is proof-of-stake block
-        BLOCK_STAKE_ENTROPY = (1 << 1), // entropy bit for stake modifier
-        BLOCK_STAKE_MODIFIER = (1 << 2), // regenerated stake modifier
-    };
-
-    /// <summary>
-    /// Transaction type.
-    /// </summary>
-    public enum TxFlags : byte
-    {
-        TX_COINBASE,
-        TX_COINSTAKE,
-        TX_USER
-    }
-
-    /// <summary>
-    /// Output flags.
-    /// </summary>
-    public enum OutputFlags : byte
-    {
-        AVAILABLE, // Unspent output
-        SPENT      // Spent output
-    }
-
-    [Table("MerkleNodes")]
-    public class CMerkleNode : IMerkleNode
-    {
-        #region IMerkleNode
-        /// <summary>
-        /// Node identifier
-        /// </summary>
-        [PrimaryKey, AutoIncrement]
-        public long nMerkleNodeID { get; set; }
-
-        /// <summary>
-        /// Reference to parent block database item.
-        /// </summary>
-        [ForeignKey(typeof(CBlockStoreItem), Name = "ItemId")]
-        public long nParentBlockID { get; set; }
-
-        /// <summary>
-        /// Transaction type flag
-        /// </summary>
-        [Column("TransactionFlags")]
-        public TxFlags TransactionFlags { get; set; }
-
-        /// <summary>
-        /// Transaction hash
-        /// </summary>
-        [Column("TransactionHash")]
-        public byte[] TransactionHash { get; set; }
-
-        /// <summary>
-        /// Transaction offset from the beginning of block header, encoded in VarInt format.
-        /// </summary>
-        [Column("TxOffset")]
-        public byte[] TxOffset { get; set; }
-
-        /// <summary>
-        /// Transaction size, encoded in VarInt format.
-        /// </summary>
-        [Column("TxSize")]
-        public byte[] TxSize { get; set; }
-        #endregion
-
-        /// <summary>
-        /// Read transaction from file.
-        /// </summary>
-        /// <param name="reader">Stream with read access.</param>
-        /// <param name="tx">CTransaction reference.</param>
-        /// <returns>Result</returns>
-        public bool ReadFromFile(ref Stream reader, long nBlockPos, out CTransaction tx)
-        {
-            var buffer = new byte[CTransaction.nMaxTxSize];
-
-            tx = null;
-
-            try
-            {
-                reader.Seek(nBlockPos + nTxOffset, SeekOrigin.Begin); // Seek to transaction offset
-
-                if (nTxSize != reader.Read(buffer, 0, nTxSize))
-                {
-                    return false;
-                }
-
-                tx = new CTransaction(buffer);
-
-                return true;
-            }
-            catch (IOException)
-            {
-                // I/O error
-                return false;
-            }
-            catch (TransactionConstructorException)
-            {
-                // Constructor error
-                return false;
-            }
-        }
-
-        /// <summary>
-        /// Transaction offset accessor
-        /// </summary>
-        [Ignore]
-        public long nTxOffset
-        {
-            get { return (long) VarInt.DecodeVarInt(TxOffset); }
-            private set { TxOffset = VarInt.EncodeVarInt(value); }
-        }
-
-        /// <summary>
-        /// Transaction size accessor
-        /// </summary>
-        [Ignore]
-        public int nTxSize
-        {
-            get { return (int)VarInt.DecodeVarInt(TxSize); }
-            private set { TxSize = VarInt.EncodeVarInt(value); }
-        }
-
-        public CMerkleNode(CTransaction tx)
-        {
-            nTxOffset = -1;
-            nParentBlockID = -1;
-
-            nTxSize = tx.Size;
-            TransactionHash = tx.Hash;
-
-            if (tx.IsCoinBase)
-            {
-                TransactionFlags |= TxFlags.TX_COINBASE;
-            }
-            else if (tx.IsCoinStake)
-            {
-                TransactionFlags |= TxFlags.TX_COINSTAKE;
-            }
-            else
-            {
-                TransactionFlags |= TxFlags.TX_USER;
-            }
-        }
-
-        public CMerkleNode(long nBlockId, long nOffset, CTransaction tx)
-        {
-            nParentBlockID = nBlockId;
-
-            nTxOffset = nOffset;
-            nTxSize = tx.Size;
-            TransactionHash = tx.Hash;
-
-            if (tx.IsCoinBase)
-            {
-                TransactionFlags |= TxFlags.TX_COINBASE;
-            }
-            else if (tx.IsCoinStake)
-            {
-                TransactionFlags |= TxFlags.TX_COINSTAKE;
-            }
-            else
-            {
-                TransactionFlags |= TxFlags.TX_USER;
-            }
-        }
-
-    }
-
-    [Table("Outputs")]
-    public class TxOutItem : ITxOutItem
-    {
-        /// <summary>
-        /// Reference to transaction item.
-        /// </summary>
-        [ForeignKey(typeof(CMerkleNode), Name = "nMerkleNodeID")]
-        public long nMerkleNodeID { get; set; }
-
-        /// <summary>
-        /// Output flags
-        /// </summary>
-        public OutputFlags outputFlags { get; set; }
-
-        /// <summary>
-        /// Output number in VarInt format.
-        /// </summary>
-        public byte[] OutputNumber { get; set; }
-
-        /// <summary>
-        /// Output value in VarInt format.
-        /// </summary>
-        public byte[] OutputValue { get; set; }
-
-        /// <summary>
-        /// Second half of script which contains spending instructions.
-        /// </summary>
-        public byte[] scriptPubKey { get; set; }
-
-        /// <summary>
-        /// Getter for output number.
-        /// </summary>
-        [Ignore]
-        public uint nOut
-        {
-            get { return (uint)VarInt.DecodeVarInt(OutputNumber); }
-            private set { OutputNumber = VarInt.EncodeVarInt(value); }
-        }
-
-        /// <summary>
-        /// Getter for output value.
-        /// </summary>
-        [Ignore]
-        public ulong nValue
-        {
-            get { return VarInt.DecodeVarInt(OutputValue); }
-            private set { OutputValue = VarInt.EncodeVarInt(value); }
-        }
-
-        /// <summary>
-        /// Getter ans setter for IsSpent flag.
-        /// </summary>
-        [Ignore]
-        public bool IsSpent
-        {
-            get { return (outputFlags & OutputFlags.SPENT) != 0; }
-            set { outputFlags |= value ? OutputFlags.SPENT : OutputFlags.AVAILABLE; }
-        }
-
-        public TxOutItem(CTxOut o, uint nOut)
-        {
-            nValue = o.nValue;
-            scriptPubKey = o.scriptPubKey;
-            this.nOut = nOut;
-        }
-    }
-
     public class CBlockStore : IDisposable
     {
         public const uint nMagicNumber = 0xe5e9e8e4;
@@ -982,12 +226,7 @@ namespace Novacoin
 
             return false;
         }
-
-        interface InputsJoin : ITxOutItem
-        {
-            byte[] TransactionHash { get; set; }
-        }
-
+        
         public bool FetchInputs(CTransaction tx, ref Dictionary<COutPoint, TxOutItem> queued, ref Dictionary<COutPoint, TxOutItem> inputs, bool IsBlock, out bool Invalid)
         {
             Invalid = false;
@@ -995,17 +234,17 @@ namespace Novacoin
             if (tx.IsCoinBase)
             {
                 // Coinbase transactions have no inputs to fetch.
-                return true; 
+                return true;
             }
 
             StringBuilder queryBuilder = new StringBuilder();
-            
+
             queryBuilder.Append("select o.*, m.[TransactionHash] from [Outputs] o left join [MerkleNodes] m on (m.[nMerkleNodeID] = o.[nMerkleNodeID]) where ");
 
             for (var i = 0; i < tx.vin.Length; i++)
             {
-                queryBuilder.AppendFormat(" {0} (m.[TransactionHash] = x'{1}' and o.[OutputNumber] = x'{2}')", 
-                    (i > 0 ? "or" : string.Empty), Interop.ToHex(tx.vin[i].prevout.hash), 
+                queryBuilder.AppendFormat(" {0} (m.[TransactionHash] = x'{1}' and o.[OutputNumber] = x'{2}')",
+                    (i > 0 ? "or" : string.Empty), Interop.ToHex(tx.vin[i].prevout.hash),
                     Interop.ToHex(VarInt.EncodeVarInt(tx.vin[i].prevout.n)
                 ));
             }
@@ -1019,12 +258,12 @@ namespace Novacoin
                     return false; // Already spent
                 }
 
-                var inputsKey =  new COutPoint(item.TransactionHash, item.nOut);
+                var inputsKey = new COutPoint(item.TransactionHash, item.nOut);
 
                 item.IsSpent = true;
 
                 // Add output data to dictionary
-                inputs.Add(inputsKey, (TxOutItem) item);
+                inputs.Add(inputsKey, (TxOutItem)item);
             }
 
             if (queryResults.Count < tx.vin.Length)
@@ -1046,7 +285,7 @@ namespace Novacoin
                         inputs.Add(outPoint, queued[outPoint]);
 
                         // Mark output as spent
-                        queued[outPoint].IsSpent = true;                        
+                        queued[outPoint].IsSpent = true;
                     }
                 }
                 else
@@ -1069,7 +308,7 @@ namespace Novacoin
 
                             return false; // nOut is out of range
                         }
-                        
+
                         // TODO: return inputs from map 
                         throw new NotImplementedException();
 
@@ -1084,7 +323,6 @@ namespace Novacoin
 
         private bool AddItemToIndex(ref CBlockStoreItem itemTemplate, ref CBlock block)
         {
-            var writer = new BinaryWriter(fStreamReadWrite).BaseStream;
             uint256 blockHash = itemTemplate.Hash;
 
             if (blockMap.ContainsKey(blockHash))
@@ -1093,6 +331,9 @@ namespace Novacoin
                 return false;
             }
 
+            // Begin transaction
+            dbConn.BeginTransaction();
+
             // Compute chain trust score
             itemTemplate.nChainTrust = (itemTemplate.prev != null ? itemTemplate.prev.nChainTrust : 0) + itemTemplate.nBlockTrust;
 
@@ -1134,7 +375,7 @@ namespace Novacoin
                 itemTemplate.nStakeTime = block.vtx[1].nTime;
             }
 
-            if (!itemTemplate.WriteToFile(ref writer, ref block))
+            if (!itemTemplate.WriteToFile(ref fStreamReadWrite, ref block))
             {
                 return false;
             }
@@ -1146,7 +387,7 @@ namespace Novacoin
 
             // Get last RowID.
             itemTemplate.ItemID = dbPlatform.SQLiteApi.LastInsertRowid(dbConn.Handle);
-            
+
             if (!blockMap.TryAdd(blockHash, itemTemplate))
             {
                 return false; // blockMap add failed
@@ -1162,6 +403,9 @@ namespace Novacoin
                 }
             }
 
+            // Commit transaction
+            dbConn.Commit();
+
             return true;
         }
 
@@ -1328,9 +572,6 @@ namespace Novacoin
                 return false; // UpdateTopChain failed
             }
 
-            // Make sure it's successfully written to disk 
-            dbConn.Commit();
-
             // Resurrect memory transactions that were in the disconnected branch
             foreach (var tx in txResurrect)
             {
@@ -1371,8 +612,6 @@ namespace Novacoin
             // Add to current best branch
             cursor.prev.next = cursor;
 
-            dbConn.Commit();
-
             // Delete redundant memory transactions
             foreach (var tx in block.vtx)
             {
@@ -1383,7 +622,7 @@ namespace Novacoin
             return true;
         }
 
-        private bool ConnectBlock(CBlockStoreItem cursor, ref CBlock block, bool fJustCheck=false)
+        private bool ConnectBlock(CBlockStoreItem cursor, ref CBlock block, bool fJustCheck = false)
         {
             // Check it again in case a previous version let a bad block in, but skip BlockSig checking
             if (!block.CheckBlock(!fJustCheck, !fJustCheck, false))
@@ -1439,13 +678,13 @@ namespace Novacoin
                     // Add in sigops done by pay-to-script-hash inputs;
                     // this is to prevent a "rogue miner" from creating
                     // an incredibly-expensive-to-validate block.
-                    nSigOps += tx.GetP2SHSigOpCount(inputs);
+                    nSigOps += tx.GetP2SHSigOpCount(ref inputs);
                     if (nSigOps > CBlock.nMaxSigOps)
                     {
                         return false; // too many sigops
                     }
 
-                    ulong nTxValueIn = tx.GetValueIn(inputs);
+                    ulong nTxValueIn = tx.GetValueIn(ref inputs);
                     ulong nTxValueOut = tx.nValueOut;
 
                     nValueIn += nTxValueIn;
@@ -1456,7 +695,7 @@ namespace Novacoin
                         nFees += nTxValueIn - nTxValueOut;
                     }
 
-                    if (!ConnectInputs(tx, inputs, queued, cursor, fScriptChecks, scriptFlags))
+                    if (!ConnectInputs(tx, ref inputs, ref queued, ref cursor, true, fScriptChecks, scriptFlags))
                     {
                         return false;
                     }
@@ -1468,7 +707,12 @@ namespace Novacoin
                     queuedMerkleNodes.Add(hashTx, mNode);
 
                     var outKey = new COutPoint(hashTx, i);
-                    var outData = new TxOutItem(tx.vout[i], i);
+                    var outData = new TxOutItem();
+
+                    outData.nValue = tx.vout[i].nValue;
+                    outData.scriptPubKey = tx.vout[i].scriptPubKey;
+                    outData.nOut = i;
+
 
                     outData.IsSpent = false;
 
@@ -1487,7 +731,7 @@ namespace Novacoin
                 }
             }
 
-            cursor.nMint = (long) (nValueOut - nValueIn + nFees);
+            cursor.nMint = (long)(nValueOut - nValueIn + nFees);
             cursor.nMoneySupply = (cursor.prev != null ? cursor.prev.nMoneySupply : 0) + (long)nValueOut - (long)nValueIn;
 
             if (!UpdateDBCursor(ref cursor))
@@ -1503,7 +747,7 @@ namespace Novacoin
             // Write queued transaction changes
             var actualMerkleNodes = new Dictionary<uint256, CMerkleNode>();
             var queuedOutpointItems = new List<TxOutItem>();
-            foreach(KeyValuePair<COutPoint, TxOutItem> outPair in queued)
+            foreach (KeyValuePair<COutPoint, TxOutItem> outPair in queued)
             {
                 uint256 txID = outPair.Key.hash;
                 CMerkleNode merkleNode;
@@ -1564,11 +808,140 @@ namespace Novacoin
             return true;
         }
 
-        private bool ConnectInputs(CTransaction tx, Dictionary<COutPoint, TxOutItem> inputs, Dictionary<COutPoint, TxOutItem> queued, CBlockStoreItem cursor, bool fScriptChecks, scriptflag scriptFlags)
+        private bool ConnectInputs(CTransaction tx, ref Dictionary<COutPoint, TxOutItem> inputs, ref Dictionary<COutPoint, TxOutItem> queued, ref CBlockStoreItem cursorBlock, bool fBlock, bool fScriptChecks, scriptflag scriptFlags)
         {
-            throw new NotImplementedException();
+            // Take over previous transactions' spent pointers
+            // fBlock is true when this is called from AcceptBlock when a new best-block is added to the blockchain
+            // fMiner is true when called from the internal bitcoin miner
+            // ... both are false when called from CTransaction::AcceptToMemoryPool
+
+            if (!tx.IsCoinBase)
+            {
+                ulong nValueIn = 0;
+                ulong nFees = 0;
+                for (uint i = 0; i < tx.vin.Length; i++)
+                {
+                    var prevout = tx.vin[i].prevout;
+                    Contract.Assert(inputs.ContainsKey(prevout));
+                    var input = inputs[prevout];
+
+                    CBlockStoreItem parentBlockCursor;
+                    var merkleItem = GetMerkleCursor(input, out parentBlockCursor);
+
+                    if (merkleItem == null)
+                    {
+                        return false; // Unable to find merkle node
+                    }
+
+                    // If prev is coinbase or coinstake, check that it's matured
+                    if (merkleItem.IsCoinBase || merkleItem.IsCoinStake)
+                    {
+                        if (cursorBlock.nHeight - parentBlockCursor.nHeight < NetInfo.nGeneratedMaturity)
+                        {
+                            return false; // tried to spend non-matured generation input.
+                        }
+                    }
+
+                    // check transaction timestamp
+                    if (merkleItem.nTime > tx.nTime)
+                    {
+                        return false; // transaction timestamp earlier than input transaction
+                    }
+
+                    // Check for negative or overflow input values
+                    nValueIn += input.nValue;
+                    if (!CTransaction.MoneyRange(input.nValue) || !CTransaction.MoneyRange(nValueIn))
+                    {
+                        return false; // txin values out of range
+                    }
+
+                }
+
+                // The first loop above does all the inexpensive checks.
+                // Only if ALL inputs pass do we perform expensive ECDSA signature checks.
+                // Helps prevent CPU exhaustion attacks.
+                for (int i = 0; i < tx.vin.Length; i++)
+                {
+                    var prevout = tx.vin[i].prevout;
+                    Contract.Assert(inputs.ContainsKey(prevout));
+                    var input = inputs[prevout];
+
+                    // Check for conflicts (double-spend)
+                    if (input.IsSpent)
+                    {
+                        return false;
+                    }
+
+                    // Skip ECDSA signature verification when connecting blocks (fBlock=true)
+                    // before the last blockchain checkpoint. This is safe because block merkle hashes are
+                    // still computed and checked, and any change will be caught at the next checkpoint.
+                    if (fScriptChecks)
+                    {
+                        // Verify signature
+                        if (!ScriptCode.VerifyScript(tx.vin[i].scriptSig, input.scriptPubKey, tx, i, (int)scriptflag.SCRIPT_VERIFY_P2SH, 0))
+                        {
+                            return false; // VerifyScript failed.
+                        }
+                    }
+
+                    // Mark outpoint as spent
+                    input.IsSpent = true;
+                    inputs[prevout] = input;
+
+                    // Write back
+                    if (fBlock)
+                    {
+                        queued.Add(prevout, input);
+                    }
+                }
+
+                if (tx.IsCoinStake)
+                {
+                    // ppcoin: coin stake tx earns reward instead of paying fee
+                    ulong nCoinAge;
+                    if (!tx.GetCoinAge(ref inputs, out nCoinAge))
+                    {
+                        return false; // unable to get coin age for coinstake
+                    }
+
+                    int nTxSize = (tx.nTime > NetInfo.nStakeValidationSwitchTime) ? tx.Size : 0;
+                    ulong nReward = tx.nValueOut - nValueIn;
+
+                    ulong nCalculatedReward = CBlock.GetProofOfStakeReward(nCoinAge, cursorBlock.nBits, tx.nTime) - CTransaction.GetMinFee(1, false, CTransaction.MinFeeMode.GMF_BLOCK, nTxSize) + CTransaction.nCent;
+
+                    if (nReward > nCalculatedReward)
+                    {
+                        return false; // coinstake pays too much
+                    }
+                }
+                else
+                {
+                    if (nValueIn < tx.nValueOut)
+                    {
+                        return false; // value in < value out
+                    }
+
+                    // Tally transaction fees
+                    ulong nTxFee = nValueIn - tx.nValueOut;
+                    if (nTxFee < 0)
+                    {
+                        return false; // nTxFee < 0
+                    }
+
+                    nFees += nTxFee;
+
+                    if (!CTransaction.MoneyRange(nFees))
+                    {
+                        return false; // nFees out of range
+                    }
+                }
+                
+            }
+
+            return true;
         }
 
+
         /// <summary>
         /// Set new top node or current best chain.
         /// </summary>
@@ -1644,6 +1017,8 @@ namespace Novacoin
 
             if (!AddItemToIndex(ref itemTemplate, ref block))
             {
+                dbConn.Rollback();
+
                 return false;
             }
 
@@ -1671,40 +1046,22 @@ namespace Novacoin
             return cursor.ReadFromFile(ref fStreamReadWrite, out block);
         }
 
-
-        /// <summary>
-        /// Interface for join
-        /// </summary>
-        interface IBlockJoinMerkle : IBlockStorageItem, IMerkleNode
-        {
-        }
-
         /// <summary>
         /// Get block and transaction by transaction hash.
         /// </summary>
         /// <param name="TxID">Transaction hash</param>
         /// <param name="block">Block reference</param>
-        /// <param name="tx">Transaction reference</param>
         /// <param name="nBlockPos">Block position reference</param>
-        /// <param name="nTxPos">Transaction position reference</param>
         /// <returns>Result of operation</returns>
-        public bool GetBlockByTransactionID(uint256 TxID, ref CBlock block, ref CTransaction tx, ref long nBlockPos, ref long nTxPos)
+        public bool GetBlockByTransactionID(uint256 TxID, ref CBlock block, ref long nBlockPos)
         {
-            var queryResult = dbConn.Query<IBlockJoinMerkle>("select *  from [BlockStorage] b left join [MerkleNodes] m on (b.[ItemID] = m.[nParentBlockID]) where m.[TransactionHash] = ?", (byte[])TxID);
+            var queryResult = dbConn.Query<CBlockStoreItem>("select b.* from [BlockStorage] b left join [MerkleNodes] m on (b.[ItemID] = m.[nParentBlockID]) where m.[TransactionHash] = ?", (byte[])TxID);
 
             if (queryResult.Count == 1)
             {
-                CBlockStoreItem blockCursor = (CBlockStoreItem) queryResult[0];
-                CMerkleNode txCursor = (CMerkleNode)queryResult[0];
-
-                var reader = new BinaryReader(fStreamReadWrite).BaseStream;
-
-                if (!txCursor.ReadFromFile(ref reader, blockCursor.nBlockPos, out tx))
-                {
-                    return false; // Unable to read transaction
-                }
+                CBlockStoreItem blockCursor = queryResult[0];
 
-                return blockCursor.ReadFromFile(ref reader, out block);
+                return blockCursor.ReadFromFile(ref fStreamReadWrite, out block);
             }
 
             // Tx not found
@@ -1739,13 +1096,6 @@ namespace Novacoin
             return false;
         }
 
-        public bool WriteNodes(ref CMerkleNode[] merkleNodes)
-        {
-            
-
-            return true;
-        }
-
         /// <summary>
         /// Get block cursor from map.
         /// </summary>
@@ -1766,6 +1116,32 @@ namespace Novacoin
         }
 
         /// <summary>
+        /// Get merkle node cursor by output metadata.
+        /// </summary>
+        /// <param name="item">Output metadata object</param>
+        /// <returns>Merkle node cursor or null</returns>
+        public CMerkleNode GetMerkleCursor(TxOutItem item, out CBlockStoreItem blockCursor)
+        {
+            blockCursor = null;
+
+            // Trying to get cursor from the database.
+            var QueryMerkleCursor = dbConn.Query<CMerkleNode>("select * from [MerkleNodes] where [nMerkleNodeID] = ?", item.nMerkleNodeID);
+
+            if (QueryMerkleCursor.Count == 1)
+            {
+                var merkleNode = QueryMerkleCursor[0];
+
+                // Search for block
+                var results = blockMap.Where(x => x.Value.ItemID == merkleNode.nParentBlockID).Select(x => x.Value).ToArray();
+
+                blockCursor = results[0];
+            }
+
+            // Nothing found.
+            return null;
+        }
+
+        /// <summary>
         /// Load cursor from database.
         /// </summary>
         /// <param name="blockHash">Block hash</param>
@@ -1917,11 +1293,10 @@ namespace Novacoin
             var intBuffer = new byte[4];
 
             var fStream2 = File.OpenRead(BlockFile);
-            var readerForBlocks = new BinaryReader(fStream2).BaseStream;
 
-            readerForBlocks.Seek(nOffset, SeekOrigin.Begin); // Seek to previous offset + previous block length
+            fStream2.Seek(nOffset, SeekOrigin.Begin); // Seek to previous offset + previous block length
 
-            while (readerForBlocks.Read(buffer, 0, 4) == 4) // Read magic number
+            while (fStream2.Read(buffer, 0, 4) == 4) // Read magic number
             {
                 var nMagic = BitConverter.ToUInt32(buffer, 0);
                 if (nMagic != 0xe5e9e8e4)
@@ -1929,7 +1304,7 @@ namespace Novacoin
                     throw new Exception("Incorrect magic number.");
                 }
 
-                var nBytesRead = readerForBlocks.Read(buffer, 0, 4);
+                var nBytesRead = fStream2.Read(buffer, 0, 4);
                 if (nBytesRead != 4)
                 {
                     throw new Exception("BLKSZ EOF");
@@ -1937,9 +1312,9 @@ namespace Novacoin
 
                 var nBlockSize = BitConverter.ToInt32(buffer, 0);
 
-                nOffset = readerForBlocks.Position;
+                nOffset = fStream2.Position;
 
-                nBytesRead = readerForBlocks.Read(buffer, 0, nBlockSize);
+                nBytesRead = fStream2.Read(buffer, 0, nBlockSize);
 
                 if (nBytesRead == 0 || nBytesRead != nBlockSize)
                 {
@@ -1971,8 +1346,6 @@ namespace Novacoin
                 }*/
             }
 
-            dbConn.Commit();
-
             return true;
         }