Bitcoin Forum
May 05, 2024, 11:44:17 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
  Home Help Search Login Register More  
  Show Posts
Pages: « 1 ... 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 52 53 54 55 56 57 58 59 60 61 62 [63] 64 65 66 67 68 69 70 71 72 73 74 75 76 77 »
1241  Bitcoin / Hardware / Re: [WTS] Avalon Chips Available to Order; Purchase Consortium, 1 chip minimum. on: April 16, 2013, 06:15:23 AM
that is quite bizarre. they need some govt funding pronto.

from the forums i cannot tell if they are sold out or if it is a bug.

Ron Paul is from Texas.  His district has potholes in the streets, burned out street lights, low taxes, and satisfied voters.
I looked at a very nice house in Yoakum at a very good price, but I find that I like higher taxes and paved roads.  I find I am undecided about street lights.
1242  Bitcoin / Hardware / Re: [WTS] Avalon Chips Available to Order; Purchase Consortium, 1 chip minimum. on: April 16, 2013, 06:04:32 AM
sorry to interrupt your perfectly-reasonable-statement professor Mac, but I think it is hilarious you compared south Texas to Africa. things are /that/ bad here, but I am near Houston(third largest US city). I guess you mean the rural areas around Corpus.

I'm thinking of when Lyndon bought toothpaste for each of his students.
And that not all the public schools have running water.
(And I own a house in Austin, and dearly want to go home with the Armadillo, and saw Townes at Waterloo)
1243  Bitcoin / Hardware / Re: [WTS] Avalon Chips Available to Order; Purchase Consortium, 1 chip minimum. on: April 16, 2013, 05:51:46 AM
I encourage people who don't know what they are doing to buy as many of these chips as possible.  I will buy them from you at pennies on the dollar later.

Whats wrong with somebody wanting to act like a distributor?
It works for Coca-Cola and it works for Digikey/Avnet/Arrow?



Both of those organizations know exactly what to do to utilize their product, and they offer support.

This isn't some heathkit project you solder together in your garage.

I can't remember anymore whether I ever had a heathkit or not.  I wanted one and I had other kits.  I did read the entire Scientific American book of projects for boys.  My opinion is that many of those projects would be challenging today for graduate students.

I wonder how many people both know what bitcoin is, and also know what heathkit was.

While many of your comments are on point in general in any bitcoin forum, please do go back and re-read my original post.  I thought I was pretty droll, very under-promised, issued proper cautions about the difficulty, and gave the exit strategy as well as the buy in strategy.  I did not promise easy money, nor did I promise a marketing  view of engineering or science.  It may appear rushed:  I thought I was racing the clock, and the "out of stock" status seems to agree with this thinking.

I do value constructive criticism and I spend considerable time evaluating it for any instruction that I may gain from it.  However, I find that I assimilate the criticism better when I see some connection to my own actions.


Well, in this case you are the apparent adult inviting children to come play on the highway.

What exactly will you do with one chip?  Avalon modules have 80 chips in them.  How will you manage risk of yield loss?  Who will you contract to build them?

How long will it take to go from order to hashing hardware?  What will alternative cost at that future date?  How many ASIC programs will be shipping in that time frame?

They are not my children, so go ahead, let them play in the highway just as rush hour starts.

Ok.  This one has some meat on it.  I will think on this.  I am internalizing it as:  make stronger disclaimers and stronger customer qualification.

But be warned:  I think Americans hate elitism, and your comments could be confused with elitism.  While I am fiercely proud of my education, credentials, and expertise, and often think I am the smartest guy in the room, I think it is a mistake to adopt the posture that only I can evaluate the risks, and only I can produce a quality design.

There is a WWII story that the Germans, in their elitist thinking, trained gunners, and drivers, and other specialists.  The Americans, well, were all over the map.  An American sniper could shoot a German driver, and the vehicle was dead, and the passengers sitting ducks.  Shoot an American driver, and the passengers decided who would be medic, who would be driver, and with our glorious randomness, they bugged the hell out of there while treating the driver.  "We voted, Let's Roll" is a uniquely American viewpoint.

I don't think that 1 chip is a good engineering purchase.  Someone who manages to purchase one for $10 and who puts it into clearcast and wears it for a nerd-bracelet or uses it for an executive paperweight is cool.  I'm certainly willing to pay $10 just to hold it in my hand and posses it.

My auction price is constructed so that I have 9 replacement chips for each one purchased at the minimum commit level.  This allows me to give courtesy replacement chips, although of course this is not promised in the offer language.

My first thoughts to build them are Olimex in Bulgaria.  They do really high quality work, they do some design, they do PCB production and assembly, they make some consumer products, and I am an established customer.  From Avalon's first notice to sold out was too fast to discuss anything with them, however.

I am not promising working hashing hardware.  I did leave that door open in the offer just in case I am overcome with optimism and bad judgement, but my target audience is one of the groups that think they want to buy a partial wafer and do something innovative.  It is up to them to use sound business judgement, and to only make promises that they can reasonably fulfill.  

I have been influenced by reading Kickstarter projects all summer.  I would probably detail out a device that is solar powered, that has onboard WiFi in a mesh architecture, that is totally self contained, and you open it up, set it in the sun, and earn some income and pay for internet access and a door to the world.  I lean toward those Loser Liberal ideals of letting a village in Africa, or South Texas, buy one and raise their level of education and prosperity.  The ROI is so fast, that the funders here could buy them, receive the mining income until 200% return, then the village could receive the remaining benefits.  What better way to insure peace than to help others?  It would take weeks to put this together as a KickStarter project statement, it is too much to do in the hour or two after a for sale announcement.

I think everyone is aware that BFL is in the room.  The quiet guys who want to sell chips to 2 or 3 OEMs are also in the room.  With as much guns, gold, and conspiracy thinking as I see in the forums, surely everyone finds it plausible that "they" are out there designing their own ASICS to dilute all of us "true heroes."  However, set against all of this, Avalon has set attainable goals, met those goals, and invested in additional capability.  Predicting future hash rates, bitcoin prices, or anything else is just to stare at the base of the waterfall and try to predict where the next drop will travel.

Again, I have not used any marketing hype.  I do not think I am enticing anyone to get involved at this level.  In fact, my actual language says "The chips are probably useless in a home/hobbyist environment." and An Avalon chip project will be significantly more advanced and difficult in many different dimensions than the project that I did back then and even Others attempting ASIC based projects have missed deadlines.

Perhaps you would read an invitation to a board of directors, if I had the free time to write one.  Won't happen this week, for sure.

1244  Bitcoin / Hardware / Re: [WTS] Avalon Chips Available to Order; Purchase Consortium, 1 chip minimum. on: April 16, 2013, 04:45:59 AM
Let me get this straight, you're the one who is out all orders and now want to re-sell?

If that's addressed to me, I don't know what you mean.


If you taken all pre-orders of chips for resale?

I still don't get what you want to say. 
At this time I haven't accepted any money and I haven't made any purchase.
I am willing to collect enough money from small purchasers and put together a minimum order that they cannot get on their own.
I put together a clean and transparent way to do so.
If you have a question on the mechanics of the deal, I will try to answer them.


.
1245  Other / Off-topic / Re: Bitcoin vs boinc on: April 16, 2013, 03:54:58 AM
Crunching via BOINC is like donating to a charity, just, you donate your computing power and not directly money.

Bitcoin is different, this is not a charity, if you are losing money by mining then don't mine  Wink

Oh and i do BOINC, there are tons of awesome projects  Cheesy www.worldcommunitygrid.org

How odd.  I was thinking of BOINC and botnet and bitcoin all mixed up together this morning, and wondered why not put bitcoin out on a voluntary net.  Like botnet, only with permission.
1246  Other / Off-topic / Re: Boston Marathon Explosions on: April 16, 2013, 03:51:44 AM
Well, christ. I was being sarcastic again and no one picked up on it. I seriously doubt it was N. Korea...

I know you were bub Tongue  But it's funny how people will honestly blame NK or the middle-east for all the bad that happens in their country.

Oh, JESUS! I didn't notice your full user name until after I posted. And THAT is the truth! Fuck, now I am getting confused... I was just saying christ for effect.

Who's on first?

I still laugh whenever I watch that on YouTube.
1247  Other / Off-topic / Re: I accidently burned myself! Twice! on: April 16, 2013, 03:49:57 AM
Accidentally put my fingers in boiling water while trying to find my tea in complete darkness. Then rushed to cool the damn hand under cold water but instead opened steamy hot water on full load. What a brainfart!

It hurts! Any advices to reduce pain? I have no drugs or booze to relax me. It is not serious enough to seek medical attention and everything will be OK soon.

I have read some papers that recommend honey on recent burns.  I believe the honey quenches the free radicals that are produced after the burn and minimized further damage.  You may want to Google and read more.


Think that is after it have stopped hurting, to help the healing and keep it antiseptic.

A paper I read by Indian authors about 8-10 years ago suggested that immediate application would stop the biochemical havoc.  It appears to be well known in Aruveydic medicine.  I know precious little biology, but I think there is a cascade of biochemical reactions, and it is these reactions, not the burn proper that cause the cell death.  Stop these reactions, and stop the progress of damage.

I think it is also useful in longer time frames, at all time frames actually, to keep out infections and such.



1248  Bitcoin / Hardware / Re: [WTS] Avalon Chips Available to Order; Purchase Consortium, 1 chip minimum. on: April 16, 2013, 03:40:09 AM
I encourage people who don't know what they are doing to buy as many of these chips as possible.  I will buy them from you at pennies on the dollar later.

Whats wrong with somebody wanting to act like a distributor?
It works for Coca-Cola and it works for Digikey/Avnet/Arrow?



Both of those organizations know exactly what to do to utilize their product, and they offer support.

This isn't some heathkit project you solder together in your garage.

I can't remember anymore whether I ever had a heathkit or not.  I wanted one and I had other kits.  I did read the entire Scientific American book of projects for boys.  My opinion is that many of those projects would be challenging today for graduate students.

I wonder how many people both know what bitcoin is, and also know what heathkit was.

While many of your comments are on point in general in any bitcoin forum, please do go back and re-read my original post.  I thought I was pretty droll, very under-promised, issued proper cautions about the difficulty, and gave the exit strategy as well as the buy in strategy.  I did not promise easy money, nor did I promise a marketing  view of engineering or science.  It may appear rushed:  I thought I was racing the clock, and the "out of stock" status seems to agree with this thinking.

I do value constructive criticism and I spend considerable time evaluating it for any instruction that I may gain from it.  However, I find that I assimilate the criticism better when I see some connection to my own actions.
1249  Bitcoin / Hardware / Re: [WTS] Avalon Chips Available to Order; Purchase Consortium, 1 chip minimum. on: April 16, 2013, 03:16:24 AM
Let me get this straight, you're the one who is out all orders and now want to re-sell?

If that's addressed to me, I don't know what you mean.
1250  Other / Off-topic / Re: I accidently burned myself! Twice! on: April 16, 2013, 02:32:48 AM
Accidentally put my fingers in boiling water while trying to find my tea in complete darkness. Then rushed to cool the damn hand under cold water but instead opened steamy hot water on full load. What a brainfart!

It hurts! Any advices to reduce pain? I have no drugs or booze to relax me. It is not serious enough to seek medical attention and everything will be OK soon.

I have read some papers that recommend honey on recent burns.  I believe the honey quenches the free radicals that are produced after the burn and minimized further damage.  You may want to Google and read more.

1251  Bitcoin / Hardware / Re: [WTS] Avalon Chips Available to Order; Purchase Consortium, 1 chip minimum. on: April 16, 2013, 01:47:31 AM
What are your qualifications to handle the board design, manufacturing, assembly and testing?

For purposes of this auction: none.

1252  Bitcoin / Hardware / [WTS] Avalon Chips Available to Order; Purchase Consortium, 1 chip minimum. on: April 16, 2013, 01:36:32 AM
I and many others received email that announces the sale of the Avalon chips.  Additional detail is on the Avalon store page.  A minimum purchase, 10,000 assembled and tested chips, is BTC 780.

I propose to form a purchasing consortium and place an order.  I assume that an earlier order is better, as we are racing known and unknown competitors.  It is not defined what this consortium will do next.  The actions may increase or decrease the value of the chips.  Transactions involving the chips are all valuated in BTC.

In very vague, broad brush terms:

1.  You could redeem your shares and take possession of your chips.  Postage and handling are prepaid with your shares.  Share ownership reverts to me.  The chips are probably useless in a home/hobbyist environment.
2.  The chips could be resold in smaller amounts to groups that are making something interesting with them.  I will hold a buy-back auction to redeem a corresponding number of shares with any coin received.  This may or may not produce profit.
3.  The chips could be the manufacturing inventory for something interesting that I make with them.  I will hold a buy-back auction with the net coin received after expenses.  This may or may not produce profit.

It has been 10 years since my first serious PCB project.  You may see elements of that project as presented in a Kickstarter project that is approved, but not launched.  An Avalon chip project will be significantly more advanced and difficult in many different dimensions than the project that I did back then.  Others attempting ASIC based projects have missed deadlines.  I also have an old resume on line at the moment.

I am offering shares for sale as interest in a batch order of 10,000 chips.  There are a total of 10,000 shares, 1 share represents 1 chip.

THE OFFER, Auction #1
Losing bids are fully returned.
This is a multiple-winner auction, the largest bids win, the remaining bids lose.
You may bid for 1 share by making a payment to the bitcoin address 13oUpURSCtDTYpkZP6kd7YAtL9iJ9gYRgy
Each address that pays forms a bid.  If a transaction submits payments from more than 1 address, each address is an independent bid.
The payment from each paying address in one transaction is adjusted so that the total of the adjusted payments equals the total received by 13oUpURSCtDTYpkZP6kd7YAtL9iJ9gYRgy.
Multiple payments from 1 address count as 1 bid, the adjusted amounts are added together.
The bid amount is this total of adjusted amounts.
The block-chain holds all the auction information.  The auction is as transparent, as public, and as anonymous as the block-chain itself.
I may close the auction at any time, for any reason.
I may return your coins and cancel your bid at any time, for any reason.
The no bullshit no fine print terms of sale on the Avalon store page apply here as much as possible.
Correspondence signed by the paying address will be accepted as authentic.
END OF OFFER

I have a similar auction running for shares in a Batch #2 Avalon.  A link to that auction is in my signature, you may wish to bookmark that link, read through that discussion, and examine that payment address in the block-chain.  This auction is modified slightly based on that experience.  There is a preliminary third party web page announced toward the end of that discussion, and it gives the totals from highest to lowest.

I need to raise a total of BTC 780 before Avalon sells out, I do need enough money to handle the chips after I receive them, and this auction must outbid other situations that are also bidding for my time.  In recent Avalon sales, there has been significant after sale increase in price, in some instances more than 12X. 

The following table may offer you some guidance in order to remain competitive at auction.  If the cutoff at the number of bids in the second column gives a minimum of the total in the third column, I will offer that many shares in this auction.  Please note, this table does not set a minimum bid.  I will simply set some cut-off in the future and all larger bids are in.

Code:
@ BTC 0.2028 average	10,000 shares	BTC 2,028 total
@ BTC 0.2167 average 9,000 shares BTC 1,950 total
@ BTC 0.2340 average 8,000 shares BTC 1,872 total
@ BTC 0.2563 average 7,000 shares BTC 1,794 total
@ BTC 0.2860 average 6,000 shares BTC 1,716 total
@ BTC 0.3276 average 5,000 shares BTC 1,638 total
@ BTC 0.3900 average 4,000 shares BTC 1,560 total
@ BTC 0.4680 average 3,000 shares BTC 1,404 total
@ BTC 0.5850 average 2,000 shares BTC 1,170 total

I will keep the auction open at least until Thursday, 4/18, at 13:00 GMT (8:00 AM CDT), a little more than 48 hours, or until I have BTC 1,170 in payments, whichever occurs first. 

Sometime after there are BTC 1,170 or more of bids on the block-chain and BTC 780 are 6-confirmed by that time, I will attempt to make the chip purchase and upon success of that purchase, I will declare the auction a success.  I may keep the bidding open even after I have made the purchase.

If the Avalon store is "out of stock" I will wait at least two weeks to see if I have another possibility to purchase.  I purchased a Batch #2 Avalon on Feb. 18, during the 2nd round of purchasing, so this seems to be a prudent precaution.

It is not defined what I will do if there are between BTC 780 and BTC 1,170 in bids.

Code:
@ BTC 0.7800 average	1,000 shares	BTC 780 total

This auction may cause a significant number of transactions.  It is feasible for the transactions to fill more than 20 blocks.  Please consider bidding early, and paying respectful miner's fees.

If you are a bitcoin software guru, you may consider producing a web page that will make a specified number of new addresses, transfer coin to them, and submit the transaction.  This would be useful to someone who wants to purchase a few hundred chips in this style auction.

I will be traveling on business this week, and communication will be catch-as-catch-can.






1253  Economy / Computer hardware / Qualified Interest in Avalon expansion modules on: April 15, 2013, 04:32:42 PM
I wonder how much qualified interest there is in purchasing Avalon expansion modules.  I believe that this information would be valuable to me, Avalon, their competitors, and the entire Bitcoin community.

This is how I propose to find out.

PROCEDURE
1.  Create a dedicated address and fund it with BTC 25.285 per module desired.  If you desire to use a mixer to fund it, that is your business.
2.  Pay 1 mBTC (0.001 BTC, 100000 Satoshis, $0.10), nonrefundable, per module desired to 16AtzLbhjFtcBryks36ayycVRSMa9NEzUi from your dedicated address.
3.  I can keep the dime.  It's your tip to me for publishing this approach.  The grand total of a few bucks will buy me a couppla cups of coffee.
4.  At will, inspect the details on blockchain.info

I do not represent Avalon.  This price is approximately 1/4 the publicly known price of a 4 module Batch #3 unit.  I do not have any information to guess future prices.  I do not have any information regarding Avalon's future business plans.  I assume that documentation of coin available for purchase will be noticed and discussed within Avalon.  I do have a paid purchase order for a Batch #2 unit.
1254  Other / Beginners & Help / Re: Hi - Please help my friend in getting back his 30,000 bitcoins! on: April 13, 2013, 07:28:48 PM
yea i agree with the guy above me. But first go to the cops and offer them a few hundred bucks for it and tell them your friend has family photos and stuff that are invaluable.  Thats alot of cash and it would be worth paying whatever its worth to get it.  Worse case they should be able to tell you what lot it is being sold in do you can buy it

Don't lie to the police.  They have very long memories.
Go to the auction and buy all the computers that are for sale.
Keep your mouth closed.  Keep a neutral poker face.  Act like you are totally indifferent.
If your friend has not told his lawyer this, he should now.



1255  Economy / Computer hardware / Re: [WTS] Avalon ASIC Batch #2 Income Sharing (2nd venture--auction) on: April 13, 2013, 05:07:31 PM
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

I have tried the bitcoind interface to blockchain.info.  In a linux environment:

bitcoind -rpcconnect=blockchain.info -rpcport=443 -rpcssl getblockcount

and I receive

error:  couldn't parse reply from server

1256  Economy / Computer hardware / Re: [WTS] Avalon ASIC Batch #2 Income Sharing (2nd venture--auction) on: April 13, 2013, 07:34:05 AM
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!


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
#---------------------------------------------------------------------------

1257  Economy / Computer hardware / Re: Selling my two Avalon ASIC Units from Batch #2 on: April 12, 2013, 03:29:00 PM
Hi, all

The Avalon says they will start shipping from April 15. And we need some time to switch my orders to buyer shipping address. So I will close my offer at 2:00 PM GMT April 12. If I will not sell till that time I will myself mine bitcoins on my Avalons  Grin

Avalon says they will not change shipping addresses.

There was a bit of drama with batch 1, where two parties wanted to change the address, then fell into disagreement.  I would make plans for Avalon to continue their "ship to original" policy.
1258  Economy / Computer hardware / Re: [WTS] Avalon ASIC Batch #2 Income Sharing (2nd venture--auction) on: April 12, 2013, 03:22:53 PM
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' )

1259  Economy / Computer hardware / Re: [WTS] Avalon ASIC Batch #2 Income Sharing (2nd venture--auction) on: April 12, 2013, 01:32:28 PM
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.
1260  Economy / Computer hardware / Re: [WTS] Avalon ASIC Batch #2 Income Sharing (2nd venture--auction) on: April 12, 2013, 12:46:37 PM
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 */;


Pages: « 1 ... 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 52 53 54 55 56 57 58 59 60 61 62 [63] 64 65 66 67 68 69 70 71 72 73 74 75 76 77 »
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!