Bitcoin Forum
December 08, 2016, 04:28:51 PM *
News: Latest stable version of Bitcoin Core: 0.13.1  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 [15] 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 »
  Print  
Author Topic: [ANNOUNCE] Abe 0.7: Open Source Block Explorer Knockoff  (Read 175760 times)
mcorlett
Donator
Sr. Member
*
Offline Offline

Activity: 308



View Profile
March 28, 2012, 03:53:36 PM
 #281

I'm very interested in seeing Firstbits support.

1481214531
Hero Member
*
Offline Offline

Posts: 1481214531

View Profile Personal Message (Offline)

Ignore
1481214531
Reply with quote  #2

1481214531
Report to moderator
1481214531
Hero Member
*
Offline Offline

Posts: 1481214531

View Profile Personal Message (Offline)

Ignore
1481214531
Reply with quote  #2

1481214531
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1481214531
Hero Member
*
Offline Offline

Posts: 1481214531

View Profile Personal Message (Offline)

Ignore
1481214531
Reply with quote  #2

1481214531
Report to moderator
molecular
Donator
Legendary
*
Offline Offline

Activity: 2142



View Profile
March 28, 2012, 10:07:00 PM
 #282

I'm very interested in seeing Firstbits support.

what exactly do you have in mind?

an api call "/q/firstbits/15ArtC" that returns "15ArtCgi3wmpQAAfYx4riaFmo4prJA4VsK"?

PGP key molecular F9B70769 fingerprint 9CDD C0D3 20F8 279F 6BE0  3F39 FC49 2362 F9B7 0769
mcorlett
Donator
Sr. Member
*
Offline Offline

Activity: 308



View Profile
March 29, 2012, 02:25:16 PM
 #283

I'm very interested in seeing Firstbits support.

what exactly do you have in mind?

an api call "/q/firstbits/15ArtC" that returns "15ArtCgi3wmpQAAfYx4riaFmo4prJA4VsK"?

Yes. I'd prefer some SQL code, but I know that Abe doesn't store addresses in base58 form for now, so that'd be difficult to implement. What you describe is adequate.

Xenland
Legendary
*
Offline Offline

Activity: 980


I'm not just any shaman, I'm a Sha256man


View Profile
April 25, 2012, 06:25:21 AM
 #284

Is there documentation on the table setup?

How do I query information on a particular address? (total received balance, transaction history,etc)
John Tobey
Hero Member
*****
Offline Offline

Activity: 481



View Profile WWW
April 25, 2012, 05:46:45 PM
 #285

Is there documentation on the table setup?

How do I query information on a particular address? (total received balance, transaction history,etc)
No, sorry, no docs on the tables.  Have you searched this thread for the answer?

Can a change to the best-chain criteria protect against 51% to 90+% attacks without a hard fork?
Xenland
Legendary
*
Offline Offline

Activity: 980


I'm not just any shaman, I'm a Sha256man


View Profile
April 26, 2012, 04:17:54 AM
 #286

Yeah I don't see how to query mysql for the balance of a Bitcoin address in this thread, I checked every single message. I noticed their is a nice API system but I'm already running a webserver with apache/php so I think it might be cleaner to just query the mysql data straight from php instead of having php call back to the server through python and then to mysql.
John Tobey
Hero Member
*****
Offline Offline

Activity: 481



View Profile WWW
April 26, 2012, 05:09:46 AM
 #287

This seems to work.  Note that the database has no function to translate an address into a public key hash.  I assume you can do this in PHP.  The example uses address 12cbQLTFMXRnSzktFkuoG3eHoMeFtpTu3S, whose hash is 11b366edfc0a8b66feebae5c2e25a7b6a5d1cf31.  The hash appears in two places in the query.
Code:
SELECT SUM(value) / 100000000 AS balance FROM (
    SELECT -txout.txout_value AS value
      FROM pubkey
      JOIN txout ON txout.pubkey_id=pubkey.pubkey_id
      JOIN txin ON txin.txout_id=txout.txout_id
      JOIN block_tx ON block_tx.tx_id=txout.tx_id
      JOIN block b ON b.block_id=block_tx.block_id
      JOIN chain_candidate cc ON cc.block_id=b.block_id
      WHERE
          pubkey.pubkey_hash = LOWER('11B366EDFC0A8B66FEEBAE5C2E25A7B6A5D1CF31') AND
          cc.chain_id = 1 AND
          cc.in_longest = 1
    UNION ALL
    SELECT txout.txout_value AS value
      FROM pubkey
      JOIN txout ON txout.pubkey_id=pubkey.pubkey_id
      JOIN block_tx ON block_tx.tx_id=txout.tx_id
      JOIN block b ON b.block_id=block_tx.block_id
      JOIN chain_candidate cc ON cc.block_id=b.block_id
      WHERE
          pubkey.pubkey_hash = LOWER('11B366EDFC0A8B66FEEBAE5C2E25A7B6A5D1CF31') AND
          cc.chain_id = 1 AND
          cc.in_longest = 1
) a;

Can a change to the best-chain criteria protect against 51% to 90+% attacks without a hard fork?
Xenland
Legendary
*
Offline Offline

Activity: 980


I'm not just any shaman, I'm a Sha256man


View Profile
April 26, 2012, 05:38:14 AM
 #288

This seems to work.  Note that the database has no function to translate an address into a public key hash.  I assume you can do this in PHP.  The example uses address 12cbQLTFMXRnSzktFkuoG3eHoMeFtpTu3S, whose hash is 11b366edfc0a8b66feebae5c2e25a7b6a5d1cf31.  The hash appears in two places in the query.
Code:
SELECT SUM(value) / 100000000 AS balance FROM (
    SELECT -txout.txout_value AS value
      FROM pubkey
      JOIN txout ON txout.pubkey_id=pubkey.pubkey_id
      JOIN txin ON txin.txout_id=txout.txout_id
      JOIN block_tx ON block_tx.tx_id=txout.tx_id
      JOIN block b ON b.block_id=block_tx.block_id
      JOIN chain_candidate cc ON cc.block_id=b.block_id
      WHERE
          pubkey.pubkey_hash = LOWER('11B366EDFC0A8B66FEEBAE5C2E25A7B6A5D1CF31') AND
          cc.chain_id = 1 AND
          cc.in_longest = 1
    UNION ALL
    SELECT txout.txout_value AS value
      FROM pubkey
      JOIN txout ON txout.pubkey_id=pubkey.pubkey_id
      JOIN block_tx ON block_tx.tx_id=txout.tx_id
      JOIN block b ON b.block_id=block_tx.block_id
      JOIN chain_candidate cc ON cc.block_id=b.block_id
      WHERE
          pubkey.pubkey_hash = LOWER('11B366EDFC0A8B66FEEBAE5C2E25A7B6A5D1CF31') AND
          cc.chain_id = 1 AND
          cc.in_longest = 1
) a;

Dude your awsome!, I would have never figured that query out on my own -- works great too
John Tobey
Hero Member
*****
Offline Offline

Activity: 481



View Profile WWW
April 26, 2012, 07:54:49 AM
 #289

Dude your awsome!, I would have never figured that query out on my own -- works great too
Thanks for confirming.

Can a change to the best-chain criteria protect against 51% to 90+% attacks without a hard fork?
Xenland
Legendary
*
Offline Offline

Activity: 980


I'm not just any shaman, I'm a Sha256man


View Profile
April 28, 2012, 05:16:36 AM
 #290

This seems to work.  Note that the database has no function to translate an address into a public key hash.  I assume you can do this in PHP.  The example uses address 12cbQLTFMXRnSzktFkuoG3eHoMeFtpTu3S, whose hash is 11b366edfc0a8b66feebae5c2e25a7b6a5d1cf31.  The hash appears in two places in the query.
Code:
SELECT SUM(value) / 100000000 AS balance FROM (
    SELECT -txout.txout_value AS value
      FROM pubkey
      JOIN txout ON txout.pubkey_id=pubkey.pubkey_id
      JOIN txin ON txin.txout_id=txout.txout_id
      JOIN block_tx ON block_tx.tx_id=txout.tx_id
      JOIN block b ON b.block_id=block_tx.block_id
      JOIN chain_candidate cc ON cc.block_id=b.block_id
      WHERE
          pubkey.pubkey_hash = LOWER('11B366EDFC0A8B66FEEBAE5C2E25A7B6A5D1CF31') AND
          cc.chain_id = 1 AND
          cc.in_longest = 1
    UNION ALL
    SELECT txout.txout_value AS value
      FROM pubkey
      JOIN txout ON txout.pubkey_id=pubkey.pubkey_id
      JOIN block_tx ON block_tx.tx_id=txout.tx_id
      JOIN block b ON b.block_id=block_tx.block_id
      JOIN chain_candidate cc ON cc.block_id=b.block_id
      WHERE
          pubkey.pubkey_hash = LOWER('11B366EDFC0A8B66FEEBAE5C2E25A7B6A5D1CF31') AND
          cc.chain_id = 1 AND
          cc.in_longest = 1
) a;
Oh yeah I forgot to ask, what needs to be changed to this query to get the "total over all received" balance?
John Tobey
Hero Member
*****
Offline Offline

Activity: 481



View Profile WWW
April 28, 2012, 05:21:07 AM
 #291

Oh yeah I forgot to ask, what needs to be changed to this query to get the "total over all received" balance?
Take out the first sub-select and simplify, leaving this:
Code:
    SELECT SUM(txout.txout_value) / 100000000
      FROM pubkey
      JOIN txout ON txout.pubkey_id=pubkey.pubkey_id
      JOIN block_tx ON block_tx.tx_id=txout.tx_id
      JOIN block b ON b.block_id=block_tx.block_id
      JOIN chain_candidate cc ON cc.block_id=b.block_id
      WHERE
          pubkey.pubkey_hash = LOWER('11B366EDFC0A8B66FEEBAE5C2E25A7B6A5D1CF31') AND
          cc.chain_id = 1 AND
          cc.in_longest = 1

Can a change to the best-chain criteria protect against 51% to 90+% attacks without a hard fork?
Xenland
Legendary
*
Offline Offline

Activity: 980


I'm not just any shaman, I'm a Sha256man


View Profile
April 28, 2012, 05:46:25 AM
 #292

Oh yeah I forgot to ask, what needs to be changed to this query to get the "total over all received" balance?
Take out the first sub-select and simplify, leaving this:
Code:
    SELECT SUM(txout.txout_value) / 100000000
      FROM pubkey
      JOIN txout ON txout.pubkey_id=pubkey.pubkey_id
      JOIN block_tx ON block_tx.tx_id=txout.tx_id
      JOIN block b ON b.block_id=block_tx.block_id
      JOIN chain_candidate cc ON cc.block_id=b.block_id
      WHERE
          pubkey.pubkey_hash = LOWER('11B366EDFC0A8B66FEEBAE5C2E25A7B6A5D1CF31') AND
          cc.chain_id = 1 AND
          cc.in_longest = 1


Excellent worked again!

Is this donation address still valid?: 1PWC7PNHL1SgvZaN7xEtygenKjWobWsCuf
John Tobey
Hero Member
*****
Offline Offline

Activity: 481



View Profile WWW
April 28, 2012, 06:14:32 AM
 #293

Is this donation address still valid?: 1PWC7PNHL1SgvZaN7xEtygenKjWobWsCuf
Yes, it is.  Thanks.

Can a change to the best-chain criteria protect against 51% to 90+% attacks without a hard fork?
Xenland
Legendary
*
Offline Offline

Activity: 980


I'm not just any shaman, I'm a Sha256man


View Profile
April 28, 2012, 06:38:29 AM
 #294

For anyone who was curious. I ended up using bitcoin-php library to convert address to hash160 using the (almost obvious name) addressToHash160() function. It worked like a charm.
Xenland
Legendary
*
Offline Offline

Activity: 980


I'm not just any shaman, I'm a Sha256man


View Profile
May 19, 2012, 07:09:24 AM
 #295

Donation sent!


Hope everyone will appreciate Bitcoinchipin when its released this weekend Smiley

Hey wheres the "Powered by Bitcoin-Abe" logo at?  Wink
hamdi
Hero Member
*****
Offline Offline

Activity: 644



View Profile
May 21, 2012, 06:50:28 PM
 #296

who is running ABE and at which url´s??

wanna see how it looks now, but can´t find a working node.

thanks

Tittiez
Hero Member
*****
Offline Offline

Activity: 686



View Profile
May 22, 2012, 02:03:42 AM
 #297

who is running ABE and at which url´s??

wanna see how it looks now, but can´t find a working node.

thanks

I have an Abe running, its in my sig. I edited the main page, but you still get the idea on what it looks like.
Xenland
Legendary
*
Offline Offline

Activity: 980


I'm not just any shaman, I'm a Sha256man


View Profile
May 28, 2012, 01:45:33 AM
 #298

what is wrong here? When i run the following SQL command on Bitcoin-abe database:

Quote
SELECT SUM(txout.txout_value) FROM pubkey
      JOIN txout ON txout.pubkey_id=pubkey.pubkey_id
      JOIN block_tx ON block_tx.tx_id=txout.tx_id
      JOIN block b ON b.block_id=block_tx.block_id
      JOIN chain_candidate cc ON cc.block_id=b.block_id
      WHERE
          pubkey.pubkey_hash = LOWER('04E116F6F1236ED1D0E40F03A20DE85E81D6C6DF') AND
          cc.chain_id = 1 AND
          cc.in_longest = 1

I get the value of: 1953408036 ­

So to convert that with the following formula 1953408036 ­/ 100000000 = 19.53408036 BTC

But when I look at the Blockchain it says there is a slightly higher total received balance: https://blockchain.info/address/1SoMGuYknDgyYypJPVVKE2teHBN4HDAh3
John Tobey
Hero Member
*****
Offline Offline

Activity: 481



View Profile WWW
May 28, 2012, 02:08:50 AM
 #299

So to convert that with the following formula 1953408036 ­/ 100000000 = 19.53408036 BTC

But when I look at the Blockchain it says there is a slightly higher total received balance: https://blockchain.info/address/1SoMGuYknDgyYypJPVVKE2teHBN4HDAh3
Apparently 19.53408036 was the total received as of Block 180750 and until Block 180779 (8 days ago).  You would see that number if your database were not up to date.  You can check it through the browser interface or with SQL:
Code:
SELECT MAX(block_height) FROM chain_candidate
 WHERE chain_id = 1 AND in_longest = 1;

The output should be the current block number, 181904 as of right now.  Check bitcoind and Abe's log if you get a lower number.

Can a change to the best-chain criteria protect against 51% to 90+% attacks without a hard fork?
Xenland
Legendary
*
Offline Offline

Activity: 980


I'm not just any shaman, I'm a Sha256man


View Profile
May 28, 2012, 02:32:04 AM
 #300

So to convert that with the following formula 1953408036 ­/ 100000000 = 19.53408036 BTC

But when I look at the Blockchain it says there is a slightly higher total received balance: https://blockchain.info/address/1SoMGuYknDgyYypJPVVKE2teHBN4HDAh3
Apparently 19.53408036 was the total received as of Block 180750 and until Block 180779 (8 days ago).  You would see that number if your database were not up to date.  You can check it through the browser interface or with SQL:
Code:
SELECT MAX(block_height) FROM chain_candidate
 WHERE chain_id = 1 AND in_longest = 1;

The output should be the current block number, 181904 as of right now.  Check bitcoind and Abe's log if you get a lower number.


Oh.... yep that was i the issue my database is only at block: 180769

Thanks mate!
Pages: « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 [15] 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 »
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!