Avalon ASIC Batch #2 Income Sharing; arrived and hashing

[ProfMac]

Is this still open?

Just to confirm, if I sent 0.85BTC to 17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH that would be accepted as a bid for 1%? If I wanted to bid on several shares, I would need to submit multiple payments of say 0.85BTC to 17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH ?

One final question, would you accept 1BTC Casascius coins for this auction?

Yes, 0.85 BTC to 17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH  would be a bid for 1%.
Yes, you need to submit a payment from a different address to make a different bid.

If you decide to raise your first bid to 1.00 BTC at a later time, you could submit 0.15 BTC from the same address to 17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH.

I don't know enough about the Casascius coin to know.  I think the current bidders should have the opportunity to tell me "no" and I would like to read discussion, with selected links, so that I know more.  For example, do they have some value beyond their face value for some collector, somewhere, who might contact me soon?  Is the value of the coin available digitally without destroying the coin?  Would you have to send it to me as a physical object via UPS or FedEx?

------

I hand tallied the shares, and I am ready to return some unsuccessful bids.  I am willing to delay the return of anyone's bid if that is what they prefer, just post here or send a PM.

[theGECK]

I think prioritizing BTC return is more important than hashing on an alt chain

Check the "Ratio vs. BTC" column:

http://dustcoin.com/mining

Ratio will change by the time machine starts hashing, but still it is possible mining altcoins would return BTC faster than mining BTC itself. Time will tell.

For me personally it's not about the return I can get right now, but about what I think has the longer-term chance. Bitcoin has the mind share of cryptocurrency and I think it's the one that will go for the long haul and eventually be worth more down the road. That's why my position is to prioritize BTC mining over alt-chains, but if we can do merged mining without sacrificing BTC returns it would provide an additional benefit in the short term.

Some questions that come to mind are these:

1.  How do I make the payout without controversy.
2.  How can 1 ASIC be mining on more than 1 coin?  Or, can I really double dip?

First, it's very possible to mine multiple crypto-currencies that use the same hash. Essentially, 30k foot overview, you test the same hash on both chains to see if it solves the problem for a particular chain.
#2 has two solutions:

1) Use a pool that uses merged mining. - simple, and should be done because many of the pools are merged mining at least one alt currency.
2) Setup merged mining on your own system. - I couldn't help you there, but if a pool operator can set it up then you can set it up for yourself on your own system.

[svenp]

Is this auction still open?  I don't see the 48 hr notice anywhere, but others have claimed it was closed.

[ProfMac]

Is this auction still open?  I don't see the 48 hr notice anywhere, but others have claimed it was closed.

This thread has two ventures.

1.  The 70% venture at a straight purchase.  It is closed.
2.  The 10% venture as a multi winner auction.  It is open.  The opening post has a link to the auction announcement and the offer.

[svenp]

That's what I thought, thanks.  Matthew N. Wright said your auction had closed in his Avalon thread so I was thinking I missed something!

[ProfMac]

That's what I thought, thanks.  Matthew N. Wright said your auction had closed in his Avalon thread so I was thinking I missed something!

I think I had said it in *this* thread, but I think I might have been mistaken. Perhaps I am confused because the Prof may be hosting two separate auctions. Could someone clarify?

The opening post says it at the top, and gives a link to the auction details.

[TheJuice]

48 hours yet?

[ProfMac]

That's what I thought, thanks.  Matthew N. Wright said your auction had closed in his Avalon thread so I was thinking I missed something!

I think I had said it in *this* thread, but I think I might have been mistaken. Perhaps I am confused because the Prof may be hosting two separate auctions. Could someone clarify?

The opening post says it at the top, and gives a link to the auction details.

Thank you! On another note, what do you think the likelihood of BFL shipping is at this point?

I ordered an Avalon; I did not order a BFL. 

[ProfMac]

48 hours yet?

The auction remains open.

[TheJuice]

Announcing TheJuice BlockChain Auction Manager!

Lucky for you ProfMac, I have testing this with your auction!

Real Time Bid Info: http://getpaidtoinfo.com/BCA/blockchainauctions.php?auction=17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH

Features:
1) Only counts BIDs from 1 address.
2) Sums Bids from each address
3) Remember no coins are actually stored on the my address


Looking for suggestions!
Tips to convince me to keep working on this project: 1B8g2eUo4E5TDGuMZWF3irESUg87HerCyp

Thanks all!

TheJuice

[ProfMac]

Announcing TheJuice BlockChain Auction Manager!

Lucky for you ProfMac, I have testing this with your auction!

Real Time Bid Info: http://getpaidtoinfo.com/BCA/blockchainauctions.php?auction=17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH

Features:
1) Only counts BIDs from 1 address.
2) Sums Bids from each address
3) Remember no coins are actually stored on the my address


Looking for suggestions!
Tips to convince me to keep working on this project: 1B8g2eUo4E5TDGuMZWF3irESUg87HerCyp

Thanks all!

TheJuice

Ah, the free market.
I'll look at it as soon as I can reach the web page :-(

[ProfMac]

Announcing TheJuice BlockChain Auction Manager!

Lucky for you ProfMac, I have testing this with your auction!

Real Time Bid Info: http://getpaidtoinfo.com/BCA/blockchainauctions.php?auction=17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH

Features:
1) Only counts BIDs from 1 address.
2) Sums Bids from each address
3) Remember no coins are actually stored on the my address


Looking for suggestions!
Tips to convince me to keep working on this project: 1B8g2eUo4E5TDGuMZWF3irESUg87HerCyp

Thanks all!

TheJuice

Thanks.

I want to treat transaction 35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58 as legal.

In retrospect, I also want to treat transaction 1df1ccf5d0f1f59d813d4283648a68ae3fb3db7f04697b9b2b0141cc954ab38f as legal.

I would subtract the "change" paid to the same address as one of the inputs.
I total all the remaining  "inputs."  Figure out what to call them so that ganderson doesn't flip out.
I divide the payment to the auction address by this total.  That is a scaling number.
I multiply the amount of each input by this scaling number.
I make a database entry in this payment amount for each input address.

This can be done deliberately by a user who wants to own more than one share.

When I return a payment, I create a negative payment amount.


Here is a mySQL statement that I use to update the bid information.

Code:

SELECT COUNT(*) AS payments, `address`, SUM(`amount`) AS bid 
FROM `auction` 
GROUP BY `address`
ORDER BY `bid` DESC, `address`;

And here is a mySQL table, and data used to drive that query.

Code:

-- phpMyAdmin SQL Dump
-- version 3.4.10.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 11, 2013 at 11:35 PM
-- Server version: 5.5.29
-- PHP Version: 5.3.10-1ubuntu3.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `Currency`
--

-- --------------------------------------------------------

--
-- Table structure for table `auction`
--

CREATE TABLE IF NOT EXISTS `auction` (
  `address` varchar(128) NOT NULL,
  `date` datetime NOT NULL,
  `amount` decimal(15,8) NOT NULL,
  `transaction` varchar(256) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auction`
--

INSERT INTO `auction` (`address`, `date`, `amount`, `transaction`) VALUES
('1HWdsr5FjadLMFiaZZvS4YqXpR4aQwDTHX', '2013-03-30 21:36:55', 0.04965694, '87da9aba665bc953a822090c43a51569f4501692ccd13a60bc1fbbcdbba2c175'),
('1MaMD7C4zAYxZybmB87CgJKhojt97G7TAr', '2013-04-01 14:25:22', 0.05000000, '25d14e5cda75a7f4008ad2387215aa74b40941a99345f5deec673c1871e5bcf2'),
('13shEJVGamWDu1qkAjbjD8g62hacPFmjQc', '2013-04-01 14:25:55', 0.05000000, '52c506ec67fcfbe016d63cb9c41598b64134086595c300538baacbf87414c7b2'),
('18qDhkReMuFfciHshdpQhr3QhXZp82aWon', '2013-04-01 15:50:54', 0.01000000, '611339552830b61d6a4d1de4c6552bf7c162d1c06047bfe4d0cab6525e242e99'),
('1QKKFsCXYv1Ya2qyCiQGC2MVfioKon9w3L', '2013-04-02 02:32:00', 0.02326481, 'e5ca352c1ccad367d361a325798cf0e4d951d3b1d258272b19f42a65680dac00'),
('1FrpnnbV98mMVDk7xfvRYNkMdiVkHeo4CL', '2013-04-02 16:21:43', 0.11000000, '496edce4c28cdb35e3be1537019d0a849bdd79e2bf029fe158e68d0b880764a2'),
('1AFA4ppBvYpdiDFidFUGsWo6nn2NTdAvzZ', '2013-04-03 02:56:42', 0.04000000, '70900d0cec1d4042b821f4b0220c7c10d9bb459dc26ab6acb23acb36c0dee68e'),
('1LaMr73WuPknQqcnYx5B49hUV3njXtGkzv', '2013-04-03 20:52:08', 0.75000000, 'f30285a40d89d80c3de0231936ec00b8f87af6465b6031c753a47d39c576b903'),
('1BatJJEzBD49AiqtPBGpErLigQGv6oDioK', '2013-04-03 20:53:08', 0.75000000, '1da36ca95582a042e637ad7c934f92506d3aef06703efbc258a9871a35e145ed'),
('1GZzn1wN2SN1XF6zo6CkLh77tQGqTYJS46', '2013-04-03 20:53:32', 0.75000000, '2753782e18eac7e5e3f0ea34aa1d69cdb637fede0c6f662c78a5b0527560a79a'),
('1AFuCJXLNZEF2ktFw1WWgvo7guUghtino8', '2013-04-04 05:24:19', 0.92000000, '76d55fc06c45330352cefadf4e66a9d1434341621581135f92953933a93468f0'),
('1HZrAsW7i1P5TVrVxWmwxZyiKqyMsw1rC5', '2013-04-04 11:28:14', 0.75000000, '049e35ff97c2f79635a74f54a5a7789b309ed61606e5b7b1026a46cf850b8b94'),
('1F2472ponJGqDyKNLgFKPnFdXfXT46Hx3Y', '2013-04-04 11:28:42', 0.75000000, 'a7c614c2bdbe3799e206368f17e4eebefc1d1d9cb8d63967659675c0c753e87e'),
('1CpXQhWptbYu4AAsmiEcos9f7rPgDHdALs', '2013-04-04 14:38:11', 0.80000000, '36ee9fe3de151fb50946aed1869faac31766a497a3fc4c810b878e9836883113'),
('1nAmPPmyDkvd5FJscJhDZ4te9tFvaD4BS', '2013-04-04 14:38:27', 0.80000000, '4e5621fe9bbd6537a6c6c2cd7bc6e699933c61dc22c14f1a03670e25c92fa1e0'),
('16NUNbUCieHLZGVoGdCP7Uzp5pxDNp35UT', '2013-04-04 14:38:42', 0.80000000, '74387b5a84fa3884c6b1d5df6ad78f9bd7158ab114f04353b6fa4016bb264075'),
('1F79KrkTVrGSoHX8j52axHUZi66utRnmzZ', '2013-04-04 14:38:56', 0.80000000, '7486d443677e6509bce91bf1426a097c216d519bfa1a277bb6a079b3c50c56f5'),
('14pDJaE7qWXgLAS4RbpVyq4ebsUPXEBXNa', '2013-04-04 14:39:12', 0.80000000, '0d271bef60d5cfc5f80c39448f17bb766614979262974ddd1d82de5a326a432a'),
('18qDhkReMuFfciHshdpQhr3QhXZp82aWon', '2013-04-02 17:42:38', 0.10000000, '66a32cfde8d2dbf757be39bcf753b6cc7fd1e038832cdb7c16ef8d7146f621ff'),
('1JzMp55NW22xjEE4QKUhN5iAmKyFnJSUDg', '2013-04-05 02:17:21', 1.05950000, 'b874c4fb2b3d8168e369f0b00f69bdea18926650712430d3f372c79872eb23c9'),
('18qDhkReMuFfciHshdpQhr3QhXZp82aWon', '2013-04-05 05:34:07', 0.82000000, '1a3f53416eefc3679d1ca6098204665e291e8a8b7a70dfb1cd61074dbc9193b3'),
('1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL', '2013-04-05 21:41:40', 0.83000000, 'd7c5ebf532a8c5fb17dbd334e1882c40d1cc0a3166302e230a2e8e60349f6324'),
('1cCXNG5mNFkErBWtCLaVLA9fZrGAzFCB1', '2013-04-08 09:32:47', 0.81000000, '593b76274db7197b63f119fe90befd0113fb6917d032621f2b6aa95d51f0633a'),
('1EkWkthDoxCXTyxRYVjtnmq13e8SbQNbs2', '2013-04-09 16:05:17', 0.85000000, '5be18b06459c1cd5e949f59780f3ddf7d6854d8a78ecb083974cb188ecb0fb94'),
('1PnAWB2opLVyGFUmaCeyjdFZ3w88PgPbmb', '2013-04-09 16:05:55', 0.85000000, '6df360bb237b7b11aff7eeb963650fe94b42d351c469499bd81b48cbef778307'),
('18jpEzLGFYeT4nACAUs5zrY2cDSwBXWVAt', '2013-04-09 18:30:48', 0.02000000, '7119478c78db64f91d784d2de3ddd13ed7947f7e442968c77e3dc31f475b2e4c'),
('1LktD4cXPmcJ75Sd2WgRs69rBZqNQd5L4P', '2013-04-09 19:10:47', 0.82000000, 'd8d700f36d3fe0e878ffdcc92337a8f439b800a47f40ea7fd04c2bfde54060e0'),
('18jpEzLGFYeT4nACAUs5zrY2cDSwBXWVAt', '2013-04-09 14:21:03', 0.84000000, '3f827b10a41b3363f566326f62b378120b9daee3338bdca89f1c2d19f2205be5'),
('1cCXNG5mNFkErBWtCLaVLA9fZrGAzFCB1', '2013-04-09 19:37:40', 0.01120000, '846d661ca343dace8f06cfd38f694b91cd23e478a88d256bf8a469d1502b11c6'),
('1PnAWB2opLVyGFUmaCeyjdFZ3w88PgPbmb', '2013-04-10 05:53:41', 0.10000000, '717292755607ec260f9db04f4fbb01f850e57af27a1eb85dcd449ed4eb8c819f'),
('1EkWkthDoxCXTyxRYVjtnmq13e8SbQNbs2', '2013-04-10 05:52:44', 0.15000000, '506405194aace2d759d1e85923e7d72233e0176d659bd007c4679736afa1cd1e'),
('14pDJaE7qWXgLAS4RbpVyq4ebsUPXEBXNa', '2013-04-09 15:30:25', -0.80000000, 'ed23878117fa6327e27c4837a2ac49734acbe9ca3894f38b74af608c9f3a1f71'),
('1F2472ponJGqDyKNLgFKPnFdXfXT46Hx3Y', '2013-04-08 15:29:29', -0.75000000, 'a0e316deda94e5449d3b4200640a852dc02b545b6c56266095c6f1210f08f90a'),
('1BatJJEzBD49AiqtPBGpErLigQGv6oDioK ', '2013-04-08 15:29:29', -0.75000000, 'a0e316deda94e5449d3b4200640a852dc02b545b6c56266095c6f1210f08f90a'),
('1Q8nr8o5s9ZQfVy94EspjdpjteqqQmD1K', '2013-04-05 09:39:16', -0.01507825, '41a932e51e195b26979b1bf68c6167442095828d76b9bbb7f8d8312d183d74a7'),
('1QKKFsCXYv1Ya2qyCiQGC2MVfioKon9w3L', '2013-04-05 09:39:16', -0.02326481, '41a932e51e195b26979b1bf68c6167442095828d76b9bbb7f8d8312d183d74a7'),
('1AFA4ppBvYpdiDFidFUGsWo6nn2NTdAvzZ', '2013-04-05 09:39:16', -0.04000000, '41a932e51e195b26979b1bf68c6167442095828d76b9bbb7f8d8312d183d74a7'),
('1HWdsr5FjadLMFiaZZvS4YqXpR4aQwDTHX ', '2013-04-05 09:39:16', -0.04965694, '41a932e51e195b26979b1bf68c6167442095828d76b9bbb7f8d8312d183d74a7'),
('1MaMD7C4zAYxZybmB87CgJKhojt97G7TAr ', '2013-04-05 09:39:16', -0.05000000, '41a932e51e195b26979b1bf68c6167442095828d76b9bbb7f8d8312d183d74a7'),
('13shEJVGamWDu1qkAjbjD8g62hacPFmjQc', '2013-04-05 09:39:16', -0.05000000, '41a932e51e195b26979b1bf68c6167442095828d76b9bbb7f8d8312d183d74a7'),
('1FrpnnbV98mMVDk7xfvRYNkMdiVkHeo4CL ', '2013-04-05 09:39:16', -0.11000000, '41a932e51e195b26979b1bf68c6167442095828d76b9bbb7f8d8312d183d74a7'),
('1LaMr73WuPknQqcnYx5B49hUV3njXtGkzv ', '2013-04-05 09:39:16', -0.75000000, '41a932e51e195b26979b1bf68c6167442095828d76b9bbb7f8d8312d183d74a7'),
('1GZzn1wN2SN1XF6zo6CkLh77tQGqTYJS46', '2013-04-05 09:39:16', -0.75000000, '41a932e51e195b26979b1bf68c6167442095828d76b9bbb7f8d8312d183d74a7'),
('1BatJJEzBD49AiqtPBGpErLigQGv6oDioK ', '2013-04-05 09:39:16', -0.75000000, '41a932e51e195b26979b1bf68c6167442095828d76b9bbb7f8d8312d183d74a7'),
('1BtJWrqHB5jKBE1Szb99mRQsqkwXGEF57s', '2013-04-03 20:22:42', -0.10000000, '9714762c7f65d286f97687992d342ea5e4a0de9aff5755e36d47c0292f78f397'),
('1BtJWrqHB5jKBE1Szb99mRQsqkwXGEF57s', '2013-04-03 11:35:16', -0.40000000, '2e6b037cf216c3509c04f27ab45e12563eb9d53969e8efc8177c2528f7c7ebea'),
('1HZrAsW7i1P5TVrVxWmwxZyiKqyMsw1rC5', '2013-04-10 09:43:39', -0.75000000, 'fbb7442348288bff62172d36181830d4f46cdb4f93a0d0120e1d6a3f3766eb6a'),
('1F79KrkTVrGSoHX8j52axHUZi66utRnmzZ', '2013-04-10 09:43:39', -0.80000000, 'fbb7442348288bff62172d36181830d4f46cdb4f93a0d0120e1d6a3f3766eb6a'),
('1nAmPPmyDkvd5FJscJhDZ4te9tFvaD4BS ', '2013-04-10 09:43:39', -0.80000000, 'fbb7442348288bff62172d36181830d4f46cdb4f93a0d0120e1d6a3f3766eb6a'),
('16NUNbUCieHLZGVoGdCP7Uzp5pxDNp35UT', '2013-04-10 09:43:39', -0.80000000, 'fbb7442348288bff62172d36181830d4f46cdb4f93a0d0120e1d6a3f3766eb6a'),
('1LktD4cXPmcJ75Sd2WgRs69rBZqNQd5L4P', '2013-04-10 10:33:00', 0.04100000, 'ca1ceebd34ec23208a7aa398a0b2401becabcfadfe9cf4e30f237201794baeca'),
('1CwLwBgR16urEkcL5Su3LkzA7RYYqyjHy4', '2013-04-10 10:24:57', 0.89110000, '17f91f624c1f377ca23d48aa4f679e47ee94bbcdcd9f8ea8740b3f476ce3f2d0'),
('18jpEzLGFYeT4nACAUs5zrY2cDSwBXWVAt ', '2013-04-10 15:03:51', 0.07100000, '73049d77693de95413e758c396bbded4e507e7bb0418061abd9724b1577ffd46'),
('1cCXNG5mNFkErBWtCLaVLA9fZrGAzFCB1', '2013-04-10 15:29:26', 0.07000000, '04352365922fd24118281847d1fda2881c6897602399fbffcaa91b8624e91b15'),
('1Aby6bNLfydieYGkLaMVd6BJjHrAaBsLMR', '2013-04-10 15:45:08', 0.00072085, '35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58'),
('1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL', '2013-04-10 15:45:08', 0.00864448, '35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58'),
('1BnYjPuUek6kSZYprV7KwZCEh5Fdt5EtSX', '2013-04-11 19:04:06', -0.00072073, '08f680132fd6f2a47e0421e78ab24005a7a935305937336497a3cd93f58b36ae'),
('1Gor6F9rMXUhbKGT9iYRKpa4U4tW94Ycq8', '2013-04-11 02:36:03', 1.00000000, '9ac095cc1059307f5fe8ac2dacd84119cf8ec3d25d9e948e5668a7512a1d04e3'),
('1NFtyTwefVtHXbxCPVZBG9H6SrujTxk4G6', '2013-04-11 02:36:27', 1.00000000, '29745e76ccb9adabb8e37770ae48eb5b027ee961578985f8359e81980b743de6'),
('18jpEzLGFYeT4nACAUs5zrY2cDSwBXWVAt', '2013-04-11 02:38:49', 0.06588120, '24ff1755fad50c12fde17ee65fdaa339c411ab0e9722c601b0bdf539ed758cb1'),
('1LktD4cXPmcJ75Sd2WgRs69rBZqNQd5L4P', '2013-04-11 16:44:06', 0.10900000, '472f4a16d90e6e3e04b3f41ca1453adafea0bb3a60b5c8fa08ca6a05eecc3a96'),
('1CwLwBgR16urEkcL5Su3LkzA7RYYqyjHy4', '2013-04-11 16:48:17', 0.10890001, '85db2bb735a4ac39071fc50d98271f78bd00f811d1402152a90376d13637b046'),
('1cCXNG5mNFkErBWtCLaVLA9fZrGAzFCB1', '2013-04-11 16:53:41', 0.20880000, '5436eb44254f3cb24ae68a8e2de7bdf1f393436b723c703ad69f75910ef6c184'),
('1Aby6bNLfydieYGkLaMVd6BJjHrAaBsLMR', '2013-04-11 19:04:06', -0.00072085, '08f680132fd6f2a47e0421e78ab24005a7a935305937336497a3cd93f58b36ae'),
('1CpXQhWptbYu4AAsmiEcos9f7rPgDHdALs', '2013-04-11 19:04:06', -0.80000000, '08f680132fd6f2a47e0421e78ab24005a7a935305937336497a3cd93f58b36ae'),
('1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL', '2013-04-11 19:04:06', -0.83864448, '08f680132fd6f2a47e0421e78ab24005a7a935305937336497a3cd93f58b36ae'),
('1AFuCJXLNZEF2ktFw1WWgvo7guUghtino8', '2013-04-11 19:04:06', -0.92000000, '08f680132fd6f2a47e0421e78ab24005a7a935305937336497a3cd93f58b36ae'),
('1BnYjPuUek6kSZYprV7KwZCEh5Fdt5EtSX', '2013-04-10 15:45:08', 0.00072073, '35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58'),
('1NFtyTwefVtHXbxCPVZBG9H6SrujTxk4G6', '2013-04-11 20:45:29', 0.15000000, '0f19a0e0512b44cef7fde0ce8b149a780e6c05df8676b1d3c389fd2c81948b9f'),
('18jpEzLGFYeT4nACAUs5zrY2cDSwBXWVAt', '2013-04-11 20:43:05', 0.15010000, '44df370423e859c5218b1db58a5c5967d92b298b35821674f6c7fdd21b85e316'),
('1JzMp55NW22xjEE4QKUhN5iAmKyFnJSUDg', '2013-04-11 20:41:40', 0.11000000, '325e333d497f8bb21f82c14a63890aaf5f9d02422ec88b79e128710193c76e8b'),
('1Gor6F9rMXUhbKGT9iYRKpa4U4tW94Ycq8', '2013-04-11 20:44:27', 0.16000000, '5611bf1b988d1082354e1cb2218aeb1f15dd95cca0f97829f65f650f14512d87');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[sealkid]

Announcing TheJuice BlockChain Auction Manager!

Thanks TheJuice, until now I have been watching the blockchain and creating my own list by hand, this is great!

I want to treat transaction 35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58 as legal.

This transaction was sent from my Bitcoin-QT client. I wrongly assumed that since the first bid I made (transaction d7c5ebf532a8c5fb17dbd334e1882c40d1cc0a3166302e230a2e8e60349f6324) came from one address, that future 'top-ups' to my bid would also come from one address. I am sending bids from now on solely by using separate blockchain.info addresses.

At time of writing, I have only been partially refunded for these two separate transactions for the unsuccessful bid. My total bid comes to 0.83 + 0.13 = 0.96 BTC. I have received back  0.83864448 to 1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL + 0.00072085 to 1Aby6bNLfydieYGkLaMVd6BJjHrAaBsLMR + 0.00072073 to 1BnYjPuUek6kSZYprV7KwZCEh5Fdt5EtSX = 0.84008606. So I figure there is 0.11991394 missing?

Sorry for the confusion, I will be keeping clear of Bitcoin-QT for all current and future auctions.

[ProfMac]

Announcing TheJuice BlockChain Auction Manager!

Lucky for you ProfMac, I have testing this with your auction!

Real Time Bid Info: http://getpaidtoinfo.com/BCA/blockchainauctions.php?auction=17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH

Features:
1) Only counts BIDs from 1 address.
2) Sums Bids from each address
3) Remember no coins are actually stored on the my address


Looking for suggestions!
Tips to convince me to keep working on this project: 1B8g2eUo4E5TDGuMZWF3irESUg87HerCyp

Thanks all!

TheJuice

I am lucky, and I thought I'd ask you for another favor ...


Here is some more tedious mySQL that looks at sealKid's transactions.  It explicitly adds the address 'miner' so that the sum of all the amounts with that transaction number are '0'
It also shows both the origins and the output amounts.

I would like a checkbox on your webpage that will allow me to download the mySQL for all the transactions that use the specified auction address.

Code:

-- phpMyAdmin SQL Dump
-- version 3.4.10.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 12, 2013 at 08:57 AM
-- Server version: 5.5.29
-- PHP Version: 5.3.10-1ubuntu3.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `Currency`
--

-- --------------------------------------------------------

--
-- Table structure for table `auction-reconcile`
--

CREATE TABLE IF NOT EXISTS `auction-reconcile` (
  `address` varchar(128) NOT NULL,
  `date` datetime NOT NULL,
  `amount` decimal(15,8) NOT NULL,
  `transaction` varchar(256) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auction-reconcile`
--

INSERT INTO `auction-reconcile` (`address`, `date`, `amount`, `transaction`) VALUES
('1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL', '2013-04-05 21:41:40', 0.35911449, 'd7c5ebf532a8c5fb17dbd334e1882c40d1cc0a3166302e230a2e8e60349f6324'),
('1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL', '2013-04-05 21:41:40', 0.23240448, 'd7c5ebf532a8c5fb17dbd334e1882c40d1cc0a3166302e230a2e8e60349f6324'),
('1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL', '2013-04-05 21:41:40', 0.24852019, 'd7c5ebf532a8c5fb17dbd334e1882c40d1cc0a3166302e230a2e8e60349f6324'),
('1AQMC4sXZuk9qKSA7yW3CFoM2YQEZvycU7', '2013-04-05 21:41:40', -0.01003916, 'd7c5ebf532a8c5fb17dbd334e1882c40d1cc0a3166302e230a2e8e60349f6324'),
('17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH', '2013-04-05 21:41:40', -0.83000000, 'd7c5ebf532a8c5fb17dbd334e1882c40d1cc0a3166302e230a2e8e60349f6324'),
('miner', '2013-04-05 21:41:40', 0.00000000, 'd7c5ebf532a8c5fb17dbd334e1882c40d1cc0a3166302e230a2e8e60349f6324'),
('1Aby6bNLfydieYGkLaMVd6BJjHrAaBsLMR', '2013-04-10 15:45:08', 0.01001200, '35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58'),
('1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL', '2013-04-10 15:45:08', 0.12006376, '35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58'),
('1BnYjPuUek6kSZYprV7KwZCEh5Fdt5EtSX', '2013-04-10 15:45:08', 0.01001031, '35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58'),
('15fDquQeCgBTBCf7AD8hYhh2jT9D2ZsBZL', '2013-04-10 15:45:08', -0.01008607, '35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58'),
('miner', '2013-04-10 15:45:08', 0.00000000, '35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58'),
('17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH', '2013-04-10 15:45:08', -0.13000000, '35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58'),
('1BnYjPuUek6kSZYprV7KwZCEh5Fdt5EtSX', '2013-04-11 19:04:06', -0.00072073, '08f680132fd6f2a47e0421e78ab24005a7a935305937336497a3cd93f58b36ae'),
('1Aby6bNLfydieYGkLaMVd6BJjHrAaBsLMR', '2013-04-11 19:04:06', -0.00072085, '08f680132fd6f2a47e0421e78ab24005a7a935305937336497a3cd93f58b36ae'),
('1CpXQhWptbYu4AAsmiEcos9f7rPgDHdALs', '2013-04-11 19:04:06', -0.80000000, '08f680132fd6f2a47e0421e78ab24005a7a935305937336497a3cd93f58b36ae'),
('1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL', '2013-04-11 19:04:06', -0.83864448, '08f680132fd6f2a47e0421e78ab24005a7a935305937336497a3cd93f58b36ae'),
('1AFuCJXLNZEF2ktFw1WWgvo7guUghtino8', '2013-04-11 19:04:06', -0.92000000, '08f680132fd6f2a47e0421e78ab24005a7a935305937336497a3cd93f58b36ae'),
('17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH', '2013-04-11 19:04:06', -0.64891409, '08f680132fd6f2a47e0421e78ab24005a7a935305937336497a3cd93f58b36ae'),
('miner', '2013-04-11 19:04:06', -0.00050000, '08f680132fd6f2a47e0421e78ab24005a7a935305937336497a3cd93f58b36ae');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[ProfMac]

Announcing TheJuice BlockChain Auction Manager!

Thanks TheJuice, until now I have been watching the blockchain and creating my own list by hand, this is great!

Sorry for the confusion, I will be keeping clear of Bitcoin-QT for all current and future auctions.

I'm looking at these two transactions in my database, and I'm having a "what was I smoking" moment.
I'm having coffee and digging through details at the moment.

[ProfMac]

Announcing TheJuice BlockChain Auction Manager!

Thanks TheJuice, until now I have been watching the blockchain and creating my own list by hand, this is great!

Sorry for the confusion, I will be keeping clear of Bitcoin-QT for all current and future auctions.

I'm looking at these two transactions in my database, and I'm having a "what was I smoking" moment.
I'm having coffee and digging through details at the moment.

I have to go run some errands, and I thought I would post what I have at the moment.  I think that there are two transactions where you made a bid.
I applied the "inputs" proportionally to the amount paid to the auction address / the total paid.

Here is a summary of the addresses and the total payments as I applied them.
I then took each separate address as a separate bid.  The smaller ones will drop off the bottom of the auction and be refunded.  They should be refunded the proportional amount.
I will reconcile these totals and the actual refund later today.


Please look this over carefully, and let me know if there is a typo or if it is confusing.  We should be in agreement at this step.

Code:

1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL	2013-04-05 21:41:40	0.35911449	d7c5ebf532a8c5fb17dbd334e1882c40d1cc0a3166302e230a...	0.84003916	0.83000000	0.35482277600010932824
1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL	2013-04-05 21:41:40	0.23240448	d7c5ebf532a8c5fb17dbd334e1882c40d1cc0a3166302e230a...	0.84003916	0.83000000	0.22962705500538808215
1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL	2013-04-05 21:41:40	0.24852019	d7c5ebf532a8c5fb17dbd334e1882c40d1cc0a3166302e230a...	0.84003916	0.83000000	0.24555016899450258962

1Aby6bNLfydieYGkLaMVd6BJjHrAaBsLMR	2013-04-10 15:45:08	0.01001200	35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2...	0.14008607	0.13000000	0.00929114507959285317
1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL	2013-04-10 15:45:08	0.12006376	35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2...	0.14008607	0.13000000	0.11141927816234690573
1BnYjPuUek6kSZYprV7KwZCEh5Fdt5EtSX	2013-04-10 15:45:08	0.01001031	35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2...	0.14008607	0.13000000	0.00928957675806024111

Here is some preliminary SQL that pulls these sums for a single transaction.  I hope to have SQL that will create a new, augmented table Real Soon Now.

Code:

SELECT * , `amount` * `b`.`total-placed` / `t`.`total-trans` AS `allocate-bid`
FROM
`auction-reconcile`,
(SELECT SUM(`amount`) AS 'total-trans'
FROM `auction-reconcile`
WHERE `transaction` = '35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58'
AND 0 < `amount`
AND `address` <> '17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH') AS t,

(SELECT -SUM(`amount`) AS 'total-placed'
FROM `auction-reconcile`
WHERE `transaction` = '35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58'
AND `amount` < 0
AND `address` = '17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH') AS b

WHERE 0 < `amount`
AND `transaction` IN (
'35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58' )

[TheJuice]

Right now my script is very basic. I pull everything from blockchain.info - and i dont even store it in mysql yet, but plan to do that soon. ill work on the refund data today. i like the download all option.

thx guys

[TheJuice]

Thanks for the donation! Motivated me to update the code. I'll release a new version soon

[ProfMac]

Announcing TheJuice BlockChain Auction Manager!

Thanks TheJuice, until now I have been watching the blockchain and creating my own list by hand, this is great!

I want to treat transaction 35fbf696ed7c71d5d97a27f3450be2962f8a1edbab837858e2d5ddb25af6bb58 as legal.

This transaction was sent from my Bitcoin-QT client. I wrongly assumed that since the first bid I made (transaction d7c5ebf532a8c5fb17dbd334e1882c40d1cc0a3166302e230a2e8e60349f6324) came from one address, that future 'top-ups' to my bid would also come from one address. I am sending bids from now on solely by using separate blockchain.info addresses.

At time of writing, I have only been partially refunded for these two separate transactions for the unsuccessful bid. My total bid comes to 0.83 + 0.13 = 0.96 BTC. I have received back  0.83864448 to 1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL + 0.00072085 to 1Aby6bNLfydieYGkLaMVd6BJjHrAaBsLMR + 0.00072073 to 1BnYjPuUek6kSZYprV7KwZCEh5Fdt5EtSX = 0.84008606. So I figure there is 0.11991394 missing?

Sorry for the confusion, I will be keeping clear of Bitcoin-QT for all current and future auctions.

I have these figures:

Code:

1BnYjPuUek6kSZYprV7KwZCEh5Fdt5EtSX	0.00928958	-0.00072073	0.00856885
1Aby6bNLfydieYGkLaMVd6BJjHrAaBsLMR	0.00929115	-0.00072085	0.00857030
1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL	0.94141928	-0.83864448	0.10277480
sum	0.96000001	-0.84008606	0.11991395

And for TheJuice, I have this mySQL snippet.

Code:

#---------------------------------------------------------------------------
CREATE TABLE payout3
AS
SELECT
	paid.`address`, `bid`, `amount`, `bid` + `amount` AS 'net'
FROM
`auction-reconcile`,
(
	SELECT `address`, SUM(`allocate-bid`) AS 'bid'
	FROM
	(
		SELECT `auction-reconcile`.* , `b`.`total-placed`, `t`.`total-trans`,
			`amount` * `b`.`total-placed` / `t`.`total-trans` AS `allocate-bid`
		FROM
		`auction-reconcile`,
		(
			SELECT SUM(`amount`) AS 'total-trans', `transaction` AS t1
			FROM `auction-reconcile`
			WHERE 0 < `amount`
			AND `address` <> '17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH'
			GROUP BY `transaction`
		) AS t,

		(
			SELECT -SUM(`amount`) AS 'total-placed', `transaction` AS t2
			FROM `auction-reconcile`
			WHERE  `amount` < 0
			AND `address` = '17DCms43Vu2yusDjmpjHJuZihSSWkNzgSH'
			GROUP BY `transaction`
		) AS b

		WHERE 0 < `amount`
		AND t1 = t2
		AND `transaction` = t1
	) AS t3
	GROUP BY `address`
	ORDER BY `bid` DESC
) AS paid

WHERE
 `auction-reconcile`.`address` = `paid`.`address`
 AND `amount` < 0
#---------------------------------------------------------------------------

[sealkid]

I have these figures:

Code:

1BnYjPuUek6kSZYprV7KwZCEh5Fdt5EtSX	0.00928958	-0.00072073	0.00856885
1Aby6bNLfydieYGkLaMVd6BJjHrAaBsLMR	0.00929115	-0.00072085	0.00857030
1LsZV1sNMnrvgGqgg1WYeaJ4Bbjm3ZkMoL	0.94141928	-0.83864448	0.10277480
sum	0.96000001	-0.84008606	0.11991395

Yes, that all adds up at my end, and received. Thank you!