|
Okay just making sure there are no elephants in this neck of the woods room
|
|
|
|
|
Ah so thats the definition of a patent troll I've been hearing lately....
So...
Basically Build a product that will be ideally good in the future
Apply for an ambiguous patent...
Get patent
Await for trillionaire to want to invest in the same idea but can't because the law says so
Instead trillionaire is forced to make a deal with ambiguous patent holder
Profit!
Gotcha..... It all makes sense now.
|
|
|
|
|
Seriously not trying to offend, just curious as to other bitcoiners thoughts about the project....
It seems like they are just very enthusiastic about Bitcoin that they are just oblivious as to what they are trying to accomplish is just completely a waste of time. Granted an ATM for Bitcoins would be useful in the rare occasion that I happen to find another Bitcoiner on the street and they just so happen to need some Bitcoins and I don't happen to have my cellphone on me with out the Bitcoin client app, but assuming that this rare occasion could happen(and it did). So heres my questions...
Why would any one deal with bitcoins on a Windows XP ran kiosk?
Does anyone else notice the gaping hole to running an ATM machine on an Apache2+PHP server and on top of that attackers can have physical access to the ATM machine?
Even if this was ran on an executable and not a web server... using windows xp to run the executable just leaves open for a rootkit virus to take over your kiosk machine while your doing a transfer....
Looking back at the page, I think It might be a all-in-one ad-caimpain for his blogs and other websites probably made by him. Okay I'ma just come out and say it looks like one big fat open source troll project. There I said it... Not tell me how much I'm wrong... go ahead... tell me.
(*edited grammer cuz imma english tard)
|
|
|
|
|
I'll be shipping my final product to MemoryDealers shortly, It'll be up to him when to release it. Very excited to see the finished design.
|
|
|
|
I can't seem to find a register link, have you implemented that yet?
Just a guess but since the thread is titled starting may 1st I'll have to say that it is 99.999999999% likely its disabled...  The site itself is functional - virtual hashing doesn't start until the 1st. Sounds a little contradictory, but I'll withdraw from this conversation. |
|
|
|
|
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.
|
|
|
|
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: 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 |
|
|
|
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. 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? |
|
|
|
I can't seem to find a register link, have you implemented that yet?
Just a guess but since the thread is titled starting may 1st I'll have to say that it is 99.999999999% likely its disabled... |
|
|
|
|
So its like a purely text game and you just click buttons in a strategic manner? I guess nobody caught my sarcasum earlier I still don't get what this game is.. I guess I'll see on may 1st
|
|
|
|
Ive found and read that link before but i still dont understabd the convience of it. Maybe if someone could give me a couple of one liners describing some uses for p2pool to someone who dosent mine or own/run a mining farm in my garage. It's a decentralized pool, which IMO makes sense for a decentralized currency. You get all the choices and security of solo mining but with the variance of pooled mining. Decentrelized mining pool.... Now ive heard it all. Thanks for clearing that up. Now when i read the p2pool wiki it might actually make sense to me for once  |
|
|
|
Ive found and read that link before but i still dont understabd the convience of it. Maybe if someone could give me a couple of one liners describing some uses for p2pool to someone who dosent mine or own/run a mining farm in my garage. |
|
|
|
I think that was rather related to my question about block timestamps... thanks by the way!
Still either way it helped me understand what those functions are used for and I'm still quite curious too. Apologies to any awkwardness felt from my responses. |
|
|
|
$ ./bitcoind getblockhash 100000
000000000003ba27aa200b1cecaad478d2b00432346c3f1f3986da1afd33e506
$ ./bitcoind getblock 000000000003ba27aa200b1cecaad478d2b00432346c3f1f3986da1afd33e506
{
"hash" : "000000000003ba27aa200b1cecaad478d2b00432346c3f1f3986da1afd33e506",
"size" : 957,
"height" : 100000,
"version" : 1,
"merkleroot" : "f3e94742aca4b5ef85488dc37c06c3282295ffec960994b2c0d5ac2a25a95766",
"time" : 1293623863,
"nonce" : 274148111,
"bits" : "1b04864c",
"difficulty" : 14484.16236123,
"tx" : [
"8c14f0db3df150123e6f3dbbf30f8b955a8249b62ac1d1ff16284aefa3d06d87",
"fff2525b8931402dd09222c50775608f75787bd2b87e56995a7bdd30f79702c4",
"6359f0868171b1d194cbee1af2f16ea598ae8fad666d9b012c8ed2b79a236ec4",
"e9a66845e05d5abc0ad04ec80f774a7e585c6e8db975962d069a522137b80c1d"
],
"previousblockhash" : "000000000002d01c1fccc21636b607dfd930d31d01c3a62104612a1719011250",
"nextblockhash" : "00000000000080b66c911bd5ba14a74260057311eaeb1982802f7010f1a9f090"
}
First call getblochash to find the hash of a block at a particular height, then use getblock to query information about the block with that given hash. The "time" field will tell you the block's timestamp (in seconds since epoch).
Ah that makes alot more sense. so im guessing with the array of tx data id have to query the tx info one by one to get the balances or transaction history? (maybe not transaction history but atleast an update for that parituclar block of the addresses involved) |
|
|
|
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. 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 |
|
|
|
|
Do people still need frontends like mmcfe, simplecoin, p2pool, etc?
Also what is p2pool and why do people use it?
|
|
|
|
|
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.
|
|
|
|
|
I tried the bitcoind getblockhash thing... I had no idea what information it was presenting me or how'd I utilize that information.
I ended up using Abe since it was best for my situation. Which was for me to be able to query things with PHP and MySql databases. At least myself and others have a thread to checkout later when they need some good bitcoin libraries.
|
|
|
|
Many years ago when I wanted to learn HTML I used this site: http://www.lissaexplains.com/It's designed to each children how to code, so it's explained in the absolute simplest terms and it gave me a great stepping stone to learn more advanced things later on. Dude! I thought i was the only one that used that site when I was young. Too bad it's off-line meow. It was so helpful at teaching teeny boppers. Nostalgic... |
|
|
|
|
Show Posts
