Topic: is it possible to calculate total confirmed transactions till a block ? (Read 1593 times)

Quote from: shorena on March 07, 2016, 09:59:52 AM

-snip-

Yeah, not on all systems though. Block 401263 is the oldest on my windows box.

Code:

2016-03-05 11:02:08 UpdateTip: new best=000000000000000002d84ebbcf33e8951cfdb3234768de5026e399c79f92f987 height=401263 log2_work=84.24007 tx=114496141 date=2016-03-05 11:01:37 progress=1.000000 cache=57.1MiB(21671tx)

The log file is trimmed from time to time, at 10 MB IIRC.

Well, Yes it's trimmed but When I posted this game online 17 days ago, this line was very below of the debug.log. It should be recently deleted.
(If your node relays tx'es then it should has more lines than mine).

Probably, its configured to allow as much TX as possible to be relayed. When I shut it down recently it had ~900MB worth of TX in memory. Just out of curiosity, can you link me to the riddle/puzzle?

ty for your help

Now ı have to find ; what is " personal homepage " hint. As ı promised ı will send you the prize if ı can solve it

cakir

legendary

Activity: 1274

Merit: 1000

★ BitClave ICO: 15/09/17 ★

Quote from: cakir on March 07, 2016, 09:46:56 AM

Quote from: cakir on March 07, 2016, 09:46:56 AM

-snip-

Yeah, not on all systems though. Block 401263 is the oldest on my windows box.

Code:

2016-03-05 11:02:08 UpdateTip: new best=000000000000000002d84ebbcf33e8951cfdb3234768de5026e399c79f92f987 height=401263 log2_work=84.24007 tx=114496141 date=2016-03-05 11:01:37 progress=1.000000 cache=57.1MiB(21671tx)

The log file is trimmed from time to time, at 10 MB IIRC.

Well, Yes it's trimmed but When I posted this game online 17 days ago, this line was very below of the debug.log. It should be recently deleted.
(If your node relays tx'es then it should has more lines than mine).

Probably, its configured to allow as much TX as possible to be relayed. When I shut it down recently it had ~900MB worth of TX in memory. Just out of curiosity, can you link me to the riddle/puzzle?

Puzzle is this: (in Turkish of course)
http://www.bitcoinavi.com/oyun-4-kac-islem-kac/

So far I've published 5 puzzles, 4 was solved.

Thanks, they look very interesting, esp. the doge one and the one with the QR code. Looks like all 5 are solved. Would I be allowed to join future games even if Im not turkish, e.g. by using a google translator or asking a friend?

Well, This game's purpose is not just give away money to people who has knowledge.
It's main purpose is to teach Turkish people how to deal with Bitcoin & Crypto Universe, best way to practice bitcoin is "apply & learn" so Game solvers are trying to solve riddles & learn more stuff about Bitcoin.

You already know lots of stuff about bitcoin. I prefer you not to join, But you're wellcomed anyway. But trust me, they're already hard. Not only knowing Turkish is enough but also you need to know Turkic language, Math etc

shorena

copper member

Activity: 1498

Merit: 1528

No I dont escrow anymore.

-snip-

Yeah, not on all systems though. Block 401263 is the oldest on my windows box.

Code:

2016-03-05 11:02:08 UpdateTip: new best=000000000000000002d84ebbcf33e8951cfdb3234768de5026e399c79f92f987 height=401263 log2_work=84.24007 tx=114496141 date=2016-03-05 11:01:37 progress=1.000000 cache=57.1MiB(21671tx)

The log file is trimmed from time to time, at 10 MB IIRC.

Well, Yes it's trimmed but When I posted this game online 17 days ago, this line was very below of the debug.log. It should be recently deleted.
(If your node relays tx'es then it should has more lines than mine).

Probably, its configured to allow as much TX as possible to be relayed. When I shut it down recently it had ~900MB worth of TX in memory. Just out of curiosity, can you link me to the riddle/puzzle?

Puzzle is this: (in Turkish of course)
http://www.bitcoinavi.com/oyun-4-kac-islem-kac/

So far I've published 5 puzzles, 4 was solved.

Thanks, they look very interesting, esp. the doge one and the one with the QR code. Looks like all 5 are solved. Would I be allowed to join future games even if Im not turkish, e.g. by using a google translator or asking a friend?

cakir

legendary

Activity: 1274

Merit: 1000

★ BitClave ICO: 15/09/17 ★

-snip-

Yeah, not on all systems though. Block 401263 is the oldest on my windows box.

Code:

2016-03-05 11:02:08 UpdateTip: new best=000000000000000002d84ebbcf33e8951cfdb3234768de5026e399c79f92f987 height=401263 log2_work=84.24007 tx=114496141 date=2016-03-05 11:01:37 progress=1.000000 cache=57.1MiB(21671tx)

The log file is trimmed from time to time, at 10 MB IIRC.

Well, Yes it's trimmed but When I posted this game online 17 days ago, this line was very below of the debug.log. It should be recently deleted.
(If your node relays tx'es then it should has more lines than mine).

Probably, its configured to allow as much TX as possible to be relayed. When I shut it down recently it had ~900MB worth of TX in memory. Just out of curiosity, can you link me to the riddle/puzzle?

Puzzle is this: (in Turkish of course)
http://www.bitcoinavi.com/oyun-4-kac-islem-kac/

So far I've published 5 puzzles, 4 was solved.

shorena

copper member

Activity: 1498

Merit: 1528

No I dont escrow anymore.

-snip-

Yeah, not on all systems though. Block 401263 is the oldest on my windows box.

Code:

2016-03-05 11:02:08 UpdateTip: new best=000000000000000002d84ebbcf33e8951cfdb3234768de5026e399c79f92f987 height=401263 log2_work=84.24007 tx=114496141 date=2016-03-05 11:01:37 progress=1.000000 cache=57.1MiB(21671tx)

The log file is trimmed from time to time, at 10 MB IIRC.

Well, Yes it's trimmed but When I posted this game online 17 days ago, this line was very below of the debug.log. It should be recently deleted.
(If your node relays tx'es then it should has more lines than mine).

Probably, its configured to allow as much TX as possible to be relayed. When I shut it down recently it had ~900MB worth of TX in memory. Just out of curiosity, can you link me to the riddle/puzzle?

cakir

legendary

Activity: 1274

Merit: 1000

★ BitClave ICO: 15/09/17 ★

Quote from: cakir on March 06, 2016, 06:56:30 PM

-snip-

Yeah, not on all systems though. Block 401263 is the oldest on my windows box.

Code:

2016-03-05 11:02:08 UpdateTip: new best=000000000000000002d84ebbcf33e8951cfdb3234768de5026e399c79f92f987 height=401263 log2_work=84.24007 tx=114496141 date=2016-03-05 11:01:37 progress=1.000000 cache=57.1MiB(21671tx)

The log file is trimmed from time to time, at 10 MB IIRC.

Well, Yes it's trimmed but When I posted this game online 17 days ago, this line was very below of the debug.log. It should be recently deleted.
(If your node relays tx'es then it should has more lines than mine).

shorena

copper member

Activity: 1498

Merit: 1528

No I dont escrow anymore.

Quote from: shorena on March 06, 2016, 06:45:42 PM

Quote from: cakir on March 06, 2016, 06:24:44 PM

Quote from: shorena on March 06, 2016, 06:45:42 PM

Well they told me via PM that it was for a riddle and there would be reward. Be that as it may, here is a quick and dirty (2 beer) solution in ruby:

Code:

total_count = 0
h = BitcoinRPC.new('http://rpcuser:rpcpass@rpc_ip:rpc_port')
for i in 0..399000
hash = h.getblockhash i
block = h.getblock hash
#puts block
txs = block["tx"].size
total_count = total_count + txs
puts "block #{i}: #{total_count}"
end #for
puts total_count

~~its still running (~block 260k) will update with the result.~~

Edit: 110863024 so its a different number than the one posted.

There's reward & yes this is correct number. But you can get the reward if only you know Turkish.
Also you didn't have to run this program to find it

(This value is stored on Core's debug.log).

Interesting, well its not in all of my debug.log files, only in one test VM. I guess it was already trimmed from the other files.

Well, if you open debug.log (I suggest notepad++) and look for (ctrl+h) 399000
you'll find this line;
2016-02-18 14:12:13 UpdateTip: new best=000000000000000003d2548d4c19a5e91a8762c764f3195a7cb4be189bb1da48 height=399000 log2_work=84.137116 tx=110863024 date=2016-02-18 11:41:04 progress=0.999923 cache=53.4MiB(14531tx)

"tx=110863024" this one is the total confirmed transaction count till block height 399000.

Yeah, not on all systems though. Block 401263 is the oldest on my windows box.

Code:

2016-03-05 11:02:08 UpdateTip: new best=000000000000000002d84ebbcf33e8951cfdb3234768de5026e399c79f92f987 height=401263 log2_work=84.24007 tx=114496141 date=2016-03-05 11:01:37 progress=1.000000 cache=57.1MiB(21671tx)

The log file is trimmed from time to time, at 10 MB IIRC.

cakir

legendary

Activity: 1274

Merit: 1000

★ BitClave ICO: 15/09/17 ★

Quote from: cakir on March 06, 2016, 06:24:44 PM

Quote from: cakir on March 06, 2016, 06:24:44 PM

Well they told me via PM that it was for a riddle and there would be reward. Be that as it may, here is a quick and dirty (2 beer) solution in ruby:

Code:

total_count = 0
h = BitcoinRPC.new('http://rpcuser:rpcpass@rpc_ip:rpc_port')
for i in 0..399000
hash = h.getblockhash i
block = h.getblock hash
#puts block
txs = block["tx"].size
total_count = total_count + txs
puts "block #{i}: #{total_count}"
end #for
puts total_count

~~its still running (~block 260k) will update with the result.~~

Edit: 110863024 so its a different number than the one posted.

There's reward & yes this is correct number. But you can get the reward if only you know Turkish.
Also you didn't have to run this program to find it

(This value is stored on Core's debug.log).

Interesting, well its not in all of my debug.log files, only in one test VM. I guess it was already trimmed from the other files.

Well, if you open debug.log (I suggest notepad++) and look for (ctrl+h) 399000
you'll find this line;
2016-02-18 14:12:13 UpdateTip: new best=000000000000000003d2548d4c19a5e91a8762c764f3195a7cb4be189bb1da48 height=399000 log2_work=84.137116 tx=110863024 date=2016-02-18 11:41:04 progress=0.999923 cache=53.4MiB(14531tx)

"tx=110863024" this one is the total confirmed transaction count till block height 399000.

shorena

copper member

Activity: 1498

Merit: 1528

No I dont escrow anymore.

Well they told me via PM that it was for a riddle and there would be reward. Be that as it may, here is a quick and dirty (2 beer) solution in ruby:

Code:

total_count = 0
h = BitcoinRPC.new('http://rpcuser:rpcpass@rpc_ip:rpc_port')
for i in 0..399000
hash = h.getblockhash i
block = h.getblock hash
#puts block
txs = block["tx"].size
total_count = total_count + txs
puts "block #{i}: #{total_count}"
end #for
puts total_count

~~its still running (~block 260k) will update with the result.~~

Edit: 110863024 so its a different number than the one posted.

There's reward & yes this is correct number. But you can get the reward if only you know Turkish.
Also you didn't have to run this program to find it

(This value is stored on Core's debug.log).

Interesting, well its not in all of my debug.log files, only in one test VM. I guess it was already trimmed from the other files.

cakir

legendary

Activity: 1274

Merit: 1000

★ BitClave ICO: 15/09/17 ★

Quote from: cakir on March 06, 2016, 05:08:45 PM

Well they told me via PM that it was for a riddle and there would be reward. Be that as it may, here is a quick and dirty (2 beer) solution in ruby:

Code:

total_count = 0
h = BitcoinRPC.new('http://rpcuser:rpcpass@rpc_ip:rpc_port')
for i in 0..399000
hash = h.getblockhash i
block = h.getblock hash
#puts block
txs = block["tx"].size
total_count = total_count + txs
puts "block #{i}: #{total_count}"
end #for
puts total_count

~~its still running (~block 260k) will update with the result.~~

Edit: 110863024 so its a different number than the one posted.

There's reward & yes this is correct number. But you can get the reward if only you know Turkish.
Also you didn't have to run this program to find it

(This value is stored on Core's debug.log).

shorena

copper member

Activity: 1498

Merit: 1528

No I dont escrow anymore.

Well they told me via PM that it was for a riddle and there would be reward. Be that as it may, here is a quick and dirty (2 beer) solution in ruby:

Code:

total_count = 0
  h = BitcoinRPC.new('http://rpcuser:rpcpass@rpc_ip:rpc_port')
  for i in 0..399000
   hash = h.getblockhash i
   block = h.getblock hash
   #puts block
   txs = block["tx"].size
   total_count = total_count + txs
   puts "block #{i}: #{total_count}"
  end #for
  puts total_count

~~its still running (~block 260k) will update with the result.~~

Edit: 110863024 so its a different number than the one posted.

achow101

staff

Activity: 3458

Merit: 6793

Just writing some code

Quote from: DannyHamilton on March 06, 2016, 04:11:40 PM

Quote from: DannyHamilton on March 06, 2016, 04:11:40 PM

it's part of a bitcoin prized game in Turkish

LOL

So the OP is trying to get someone else give him the answer to a contest that will win bitcoins for himself, but is unwilling to share the prize with the person that gives him the answer?

Well, not entirely.
This is just a step of it, this answer will be used on next step.
There're more steps to get the prize

Well if this is for a prize, then I think that he should figure it out himself instead of asking for others to do it for him.

cakir

legendary

Activity: 1274

Merit: 1000

★ BitClave ICO: 15/09/17 ★

Quote from: DannyHamilton on March 06, 2016, 04:11:40 PM

it's part of a bitcoin prized game in Turkish

LOL

So the OP is trying to get someone else give him the answer to a contest that will win bitcoins for himself, but is unwilling to share the prize with the person that gives him the answer?

Well, not entirely.
This is just a step of it, this answer will be used on next step.
There're more steps to get the prize

sonerbo

copper member

Activity: 1358

Merit: 523

it's part of a bitcoin prized game in Turkish

LOL

So the OP is trying to get someone else give him the answer to a contest that will will bitcoins for himself, but is unwilling to share the prize with the person that gives him the answer?

yeah u are rıght sherlock holmes Cool

am the ugly and dishonest guy. u got me are you happy ??

DannyHamilton

legendary

Activity: 3472

Merit: 4801

Quote from: DannyHamilton on March 06, 2016, 03:04:55 PM

it's part of a bitcoin prized game in Turkish

LOL

So the OP is trying to get someone else give him the answer to a contest that will win bitcoins for himself, but is unwilling to share the prize with the person that gives him the answer?

cakir

legendary

Activity: 1274

Merit: 1000

★ BitClave ICO: 15/09/17 ★

Guys it's logged somewhere (I can't tell it where yet, because it's part of a bitcoin prized game in Turkish) you don't need to calculate it

sonerbo

copper member

Activity: 1358

Merit: 523

I need the total count of the confirmed transactions from 1-399000th block.

There were a total of 96 transactions confirmed in block number 399000.

İs that clear ??

1 block 1 transaction

2 block 2 transacktion

3 block 5 transaction

1-3 block total 8 transaction. I need 1-399000

So ?

I think it will be somewhere between 110000000 and 111000000. Do you need an exact number, or just a close approximation?

Do you only want transactions with spendable outputs? Do you only want the count of transactions that pay to a standard bitcoin address, or should the total include transactions that pay to a non-standard script?

Its in the hash ( 000000000000000003d2548d4c19a5e91a8762c764f3195a7cb4be189bb1da48 ) I think..

That is the hash of the block header of block number 399000. It is not possible to decode that hash into anything useful. The block header that was used as input to the hashing function contained the following:

Version: 00000004
Previous Block Hash: 0000000000000000010cb91a899239148b28b0d6182286b8c8fd1b8e422183d9
Merkle Root: 89b80612102795be5a8e78502d5e49fbe47ae2a192d08fb28daad6a2e14327f7
Time: 56C5ADD0
Bits: 1807a114
Nonce: 3A73B160

Quote from: achow101 on March 06, 2016, 03:06:33 PM

and also there is a graph in blockchain.info for total transactions but I need the exact total value at 399000.

I can't imagine what you'd need the "exact" total for, but you are welcome to add them all up if you like.

Start here:
https://blockchain.info/block-height/1
(You'll see that block had 1 transaction)

Then here:
https://blockchain.info/block-height/2
(Again you'll see that block had 1 transaction)

Next here:
https://blockchain.info/block-height/3
(Yet again you'll see that block had 1 transaction)

Just keep adding 1 to the number on the end of the link until you get to 399000. Add up the number of transactions in all the blocks, and you'll have your total.

we have a exact total value 1-399718 and its 111998228 . I dont know how it has found. and the question is this "the total number of transactions confirmed in all blocks from block number 1 up to and including block number 399000" its true

sonerbo

copper member

Activity: 1358

Merit: 523

Quote from: sonerbo on March 06, 2016, 02:57:16 PM

Quote from: achow101 on March 06, 2016, 02:44:51 PM

Quote from: sonerbo on March 06, 2016, 02:57:16 PM

ı don't use the bitcoin wallet. it will take so long to wait for bitcoind . and also ı have no idea how to compile a programe from that code Cry

It can be modified to work with other APIs like blockchain.info's.

Also, it isn't code, it is pseudocode which is just logic, not actual code.

Edit: what OS do you use? I can write you a batch or shell script (os dependent) that does this. I can do it in a few hours after I get to my computer.

ı use win 7 . Am not sure u asked this

am not a computer genius. ı just see a few c++ lessons at universty its all.

I did ask for that. I can write you a command line script which does this.

"399718 uzunluklu blok itibariyle Bitcoin ağında toplam 111998228 işlem onaylanmış durumda."
if u can find 399000- 399718 ı can get what ı need. its easy ı think. just 718 blocks total transactios ?

achow101

staff

Activity: 3458

Merit: 6793

Just writing some code

Quote from: achow101 on March 06, 2016, 02:44:51 PM

ı don't use the bitcoin wallet. it will take so long to wait for bitcoind . and also ı have no idea how to compile a programe from that code Cry

It can be modified to work with other APIs like blockchain.info's.

Also, it isn't code, it is pseudocode which is just logic, not actual code.

Edit: what OS do you use? I can write you a batch or shell script (os dependent) that does this. I can do it in a few hours after I get to my computer.

ı use win 7 . Am not sure u asked this

am not a computer genius. ı just see a few c++ lessons at universty its all.

I did ask for that. I can write you a command line script which does this.

DannyHamilton

legendary

Activity: 3472

Merit: 4801

I need the total count of the confirmed transactions from 1-399000th block.

There were a total of 96 transactions confirmed in block number 399000.

İs that clear ??

1 block 1 transaction

2 block 2 transacktion

3 block 5 transaction

1-3 block total 8 transaction. I need 1-399000

So the total number of transactions confirmed in all blocks from block number 1 up to and including block number 399000?

I think it will be somewhere between 110000000 and 111000000. Do you need an exact number, or just a close approximation?

Do you only want transactions with spendable outputs? Do you only want the count of transactions that pay to a standard bitcoin address, or should the total include transactions that pay to a non-standard script?

Its in the hash ( 000000000000000003d2548d4c19a5e91a8762c764f3195a7cb4be189bb1da48 ) I think..

That is the hash of the block header of block number 399000. It is not possible to decode that hash into anything useful. The block header that was used as input to the hashing function contained the following:

Version: 00000004
Previous Block Hash: 0000000000000000010cb91a899239148b28b0d6182286b8c8fd1b8e422183d9
Merkle Root: 89b80612102795be5a8e78502d5e49fbe47ae2a192d08fb28daad6a2e14327f7
Time: 56C5ADD0
Bits: 1807a114
Nonce: 3A73B160

Quote from: achow101 on March 06, 2016, 02:44:51 PM

and also there is a graph in blockchain.info for total transactions but I need the exact total value at 399000.

I can't imagine what you'd need the "exact" total for, but you are welcome to add them all up if you like.

Start here:
https://blockchain.info/block-height/1
(You'll see that block had 1 transaction)

Then here:
https://blockchain.info/block-height/2
(Again you'll see that block had 1 transaction)

Next here:
https://blockchain.info/block-height/3
(Yet again you'll see that block had 1 transaction)

Just keep adding 1 to the number on the end of the link until you get to 399000. Add up the number of transactions in all the blocks, and you'll have your total.

sonerbo

copper member

Activity: 1358

Merit: 523

ı don't use the bitcoin wallet. it will take so long to wait for bitcoind . and also ı have no idea how to compile a programe from that code Cry

It can be modified to work with other APIs like blockchain.info's.

Also, it isn't code, it is pseudocode which is just logic, not actual code.

Edit: what OS do you use? I can write you a batch or shell script (os dependent) that does this. I can do it in a few hours after I get to my computer.

ı use win 7 . Am not sure u asked this

am not a computer genius. ı just see a few c++ lessons at universty its all.

achow101

staff

Activity: 3458

Merit: 6793

Just writing some code

Quote from: achow101 on March 06, 2016, 02:37:51 PM

ı don't use the bitcoin wallet. it will take so long to wait for bitcoind . and also ı have no idea how to compile a programe from that code Cry

It can be modified to work with other APIs like blockchain.info's.

Also, it isn't code, it is pseudocode which is just logic, not actual code.

Edit: what OS do you use? I can write you a batch or shell script (os dependent) that does this. I can do it in a few hours after I get to my computer.

sonerbo

copper member

Activity: 1358

Merit: 523

ı need the total count of the confırmed transactions from 1-399000 th block.

İs that clear ??

1 block 1 transaction

2 block 2 transacktion

3 block 5 transaction

1-3 block total 8 transaction. ı need 1-399000

its in the hash ( 000000000000000003d2548d4c19a5e91a8762c764f3195a7cb4be189bb1da48 ) ı think.. and also there is a graph in blockchain.info for total transactions but ı need the exact total valu at 399000 .

edit : https://blockchain.info/charts/n-transactions-total this is the chart.

Shorena has already given you the pseudo code for it. You already have the logic, you just need to implement that in whatever programming language you want as a program or script which connects to bitcoind to get the data you want.

ı don't use the bitcoin wallet. it will take so long to wait for bitcoind . and also ı have no idea how to compile a programe from that code Cry

achow101

staff

Activity: 3458

Merit: 6793

Just writing some code