All,
Sorry it's been a day and a half since I've been on the forums, but
Kitteh got angry at me and said that Mrs. Wife, Beautiful Daughter, and Family were more important that 'that silly coinz'. Kitteh said she'd claw at my 'most precious bits' if coinz took over Christmas... - also I got sick, I can't stop coughing - so it's taken me until now to jump back on here,
to address the matter most pressing to me at the moment - paying out the miners who threw their hashing power at kittehcoinpool.com.After some exploring of the pool's DB, and some calculatin', I now have payout amounts for all miners at kittehcoinpool.com, and the payout settings are now set up as they should be, as best as I can see when I test.
First, the pertinent numbers and queries I used to arrive at my totals:
Wallet Totalkittehcoind getbalance
111028330.70416938 MEOW
Pool Feesselect sum(amount) as amount_fees
from transactions where
type = 'Fee_PPS' or type = 'TXFee'
amount_fees
323.70102484
Fee Adjusted Total111028330.70416938 - 0 (
CUZ FUCK THE POOL FEES) = 111028330.70416938
Total Number of Credit TransactionsSELECT count(*) num_txns
FROM `transactions` txns, `accounts` us
where txns.account_id = us.id and (type = 'Credit' or type = 'Credit_PPS')
num_txns
31074
Value per each Credit Transaction111028330.70416938 / 31074 =
3573.02988685619425 MEOWMEOW Received and owed per MinerSELECT
us.username,
(select count(*) from transactions where account_id = us.id and (type = 'Credit' or type = 'Credit_PPS')) num_txns,
(select sum(amount) from transactions where account_id = us.id and (type like 'Debit%')) payout_made,
num_txns * 3573.0298868561942 actual_payout,
actual_payout - payout_made payout_due
FROM `transactions` txns, `accounts` us where txns.account_id = us.id and type = 'Credit' or type = 'Credit_PPS' group by us.id order by num_txns desc
(file kitteh_owes_u.csv) ->
http://l.bitcasa.com/lUNoPrwgIt's Late Now and Kitteh Will Award Payouts 2morrowI'm sure there's q's and rants about kittehcoinpool and some of the DNS issues over the last couple of days, but I don't have it in me to respond now - it's 4am PST. Kitteh and I will be back tomorrow with more updates... if u have any pressing q's please PM me.
Another huge apology to the miners at kittehcoinpool. Thank you for not hate-raging my inbox or this thread. You have class, kitteh-lovers.Happy Holidays everyone!
thank you for the long reply and hope you have a happy holiday.