phorensic
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 21, 2011, 01:07:31 AM |
|
You rock masterp! ![](https://ip.bitcointalk.org/?u=http%3A%2F%2Ffarm4.static.flickr.com%2F3252%2F5855181090_c90c35630a_b.jpg&t=665&c=LKJi0exoToBizw)
|
|
|
|
Xenland (OP)
Legendary
Offline
Activity: 980
Merit: 1003
I'm not just any shaman, I'm a Sha256man
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 21, 2011, 01:25:58 AM |
|
You rock masterp! ![](https://ip.bitcointalk.org/?u=http%3A%2F%2Ffarm4.static.flickr.com%2F3252%2F5855181090_c90c35630a_b.jpg&t=665&c=LKJi0exoToBizw) Thanks for your contributions masterp ive added yor code to be in the next update along with a couple of other fixes that will be included should be released tonight!
|
|
|
|
peedee
Newbie
Offline
Activity: 28
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 21, 2011, 10:27:24 PM |
|
Great work guys!
|
|
|
|
xmasterpx
Newbie
Offline
Activity: 25
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 07:23:37 AM |
|
Hi, Thanks phorensic ![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif) But Xenland is rocking more ![Wink](https://bitcointalk.org/Smileys/default/wink.gif) @xenland before i update my version. anything to do at the database? or just that? ALTER TABLE `stats_poolMHashHistory` ADD `totalMhash` INT( 50 ) NOT NULL secondary it is maybe useful to write it down at the first post if someone want to make an update. best regards
|
|
|
|
Xenland (OP)
Legendary
Offline
Activity: 980
Merit: 1003
I'm not just any shaman, I'm a Sha256man
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 07:27:09 AM |
|
Hi, Thanks phorensic ![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif) But Xenland is rocking more ![Wink](https://bitcointalk.org/Smileys/default/wink.gif) @xenland before i update my version. anything to do at the database? or just that? ALTER TABLE `stats_poolMHashHistory` ADD `totalMhash` INT( 50 ) NOT NULL secondary it is maybe useful to write it down at the first post if someone want to make an update. best regards That looks about right, I believe totalMhash was the only field I used for MySql you can find all current change log updates over at http://miningfarm.com/changeLog.phpThanks everybody for your support!
|
|
|
|
xmasterpx
Newbie
Offline
Activity: 25
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 07:30:21 AM |
|
Hi, yes i have seen this changelog. But i cant see any sqltable changing. Because of that is was asking. :>
I will update now.
|
|
|
|
xmasterpx
Newbie
Offline
Activity: 25
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 07:39:49 AM |
|
Hi, do you have tested your code?
TotalHashes arent working anymore. :>
|
|
|
|
Xenland (OP)
Legendary
Offline
Activity: 980
Merit: 1003
I'm not just any shaman, I'm a Sha256man
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 07:40:47 AM |
|
Hi, yes i have seen this changelog. But i cant see any sqltable changing. Because of that is was asking. :>
I will update now.
Oh you want specifics? Its really hard to output that kind of information, I'm constantly updating my software to be-inline with my future plans like Modules and Skin chooser. In fact I believe there will be a state that my software wont need any more mysql changes, it'll be database pefect! Thinking about a Lottery module? whatchu thinks? P.S. total hashes updates to mysql but I forgot to output it to the data on the index, I'll post an update soon after I find my self in the forest
|
|
|
|
xmasterpx
Newbie
Offline
Activity: 25
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 07:46:26 AM Last edit: June 22, 2011, 08:00:55 AM by xmasterpx |
|
Hi, do you have tested your code?
TotalHashes arent working anymore. :>
May you use "spline" instead of "line" on the charts. it looks realy better. use this code xen: http://nopaste.info/46f62a7fde_nl.htmlits showing the stats even you're logged out. P.S. A lottery modul? Hmm i would not use it but would be nice.
|
|
|
|
Xenland (OP)
Legendary
Offline
Activity: 980
Merit: 1003
I'm not just any shaman, I'm a Sha256man
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 08:16:12 AM |
|
Hi, do you have tested your code?
TotalHashes arent working anymore. :>
May you use "spline" instead of "line" on the charts. it looks realy better. use this code xen: http://nopaste.info/46f62a7fde_nl.htmlits showing the stats even you're logged out. P.S. A lottery modul? Hmm i would not use it but would be nice. Thanks for that, i was wondering about how you made your graph look so smooth i need to stop and ask more questions. Personally i wouldnt use a lottory module either considering that someone could change my code to rig it. May i could run a local mining farm and the lottory module just outsources the interface, that could be a potientially huge jackpot if users from every pool participated with just one jack pot Whatchu think?
|
|
|
|
xmasterpx
Newbie
Offline
Activity: 25
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 08:32:22 AM |
|
Hi, That would be nice. And i think each user can choose itself implement a form like for withdraw -> send to jackpot an amount X.X or an selfchoosed automatic percentage on each round in the lottery. if the jackpot pays out you send it back to the farm and the user get it in his balance.
But if you run it yourself my pool cant participate to this. cause we are farming namecoins :>
|
|
|
|
FreddyE
Newbie
Offline
Activity: 27
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 09:29:56 AM |
|
how do I set a pool fee?
|
|
|
|
Xenland (OP)
Legendary
Offline
Activity: 980
Merit: 1003
I'm not just any shaman, I'm a Sha256man
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 10:15:35 AM |
|
Hi, That would be nice. And i think each user can choose itself implement a form like for withdraw -> send to jackpot an amount X.X or an selfchoosed automatic percentage on each round in the lottery. if the jackpot pays out you send it back to the farm and the user get it in his balance.
But if you run it yourself my pool cant participate to this. cause we are farming namecoins :>
Looks like I'll just have to run two lottos, Namecoin and Bitcoind lottory modules!!!! I'm trying to think of a way that will make it so the user can send the payment to the pot with out allowing the pool operator to mess with the code....baffelling..... Oh yeah freedyE pool fee options is comming soon I left that out by accident on the graphic design shift change, Thanks for the reminder ![Cheesy](https://bitcointalk.org/Smileys/default/cheesy.gif)
|
|
|
|
phorensic
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 06:06:27 PM |
|
Ah dangit, you released a new version just as our private pool code is frozen while we find our first real block. Looks like I have a lot more hours of hacking once we find our first block!
|
|
|
|
peedee
Newbie
Offline
Activity: 28
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 09:02:03 PM |
|
How would I query for the number of active workers ?
|
|
|
|
Xenland (OP)
Legendary
Offline
Activity: 980
Merit: 1003
I'm not just any shaman, I'm a Sha256man
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 09:08:13 PM |
|
How would I query for the number of active workers ?
$fiveMinutesAgo = time(); $fiveMinutesAgo -= 60*5;
SELECT `id` FROM `stats_userMhashes` WHERE `timestamp` >= $fiveMinutesAgo AND `mhashes` > 0
try that?
|
|
|
|
xane
Newbie
Offline
Activity: 51
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 09:40:49 PM |
|
Ok I read a couple of pages, but I can't find any info to WTF THIS SOFTWARE ACTUALLY DOES. ![Tongue](https://bitcointalk.org/Smileys/default/tongue.gif) Is it just a mining pool solution?
|
|
|
|
peedee
Newbie
Offline
Activity: 28
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 22, 2011, 10:47:35 PM |
|
Its actually like this :
$fiveMinutesAgo = time(); $fiveMinutesAgo -= 60*5;
$workers = mysql_query("SELECT count(*) FROM `stats_userMHashHistory` WHERE `timestamp` >= $fiveMinutesAgo AND `mhashes` > 0");
// Verify it worked if (!$workers) echo mysql_error();
$nrworkers = mysql_fetch_array($workers);
Then where ever you want to display the amount of workers :
echo "$nrworkers[0]"
Btw the stats_userMHashHistory table is filling up pretty quickly, especially if the number of workers that have been created increases, I think this will be become a scalability bottleneck.
|
|
|
|
gigabytecoin
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 23, 2011, 04:18:29 AM |
|
Its actually like this :
$fiveMinutesAgo = time(); $fiveMinutesAgo -= 60*5;
$workers = mysql_query("SELECT count(*) FROM `stats_userMHashHistory` WHERE `timestamp` >= $fiveMinutesAgo AND `mhashes` > 0");
// Verify it worked if (!$workers) echo mysql_error();
$nrworkers = mysql_fetch_array($workers);
Then where ever you want to display the amount of workers :
echo "$nrworkers[0]"
Btw the stats_userMHashHistory table is filling up pretty quickly, especially if the number of workers that have been created increases, I think this will be become a scalability bottleneck.
Just don't use MySQL then. CouchDB or another database type optimized for large databases.
|
|
|
|
BombaUcigasa
Legendary
Offline
Activity: 1442
Merit: 1005
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 23, 2011, 08:39:21 AM |
|
$fiveMinutesAgo = time(); $fiveMinutesAgo -= 60*5;
$fiveMinutesAgo = time() - 60 * 5; // WTF @ convulted code...
|
|
|
|
|