v5.6.0 ][ Open-Source Pooling Web Software ( MiningFarm )

[phorensic]

You rock masterp!

[Xenland]

You rock masterp!

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]

Great work guys!

[xmasterpx]

Hi,
Thanks phorensic   

But Xenland is rocking more

@xenland
before i update my version. anything to do at the database?
or just that?

Code:

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]

Hi,
Thanks phorensic   

But Xenland is rocking more

@xenland
before i update my version. anything to do at the database?
or just that?

Code:

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.php

Thanks everybody for your support!

[xmasterpx]

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]

Hi,
do you have tested your code?

TotalHashes arent working anymore. :>

[Xenland]

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]

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.html

its showing the stats even you're logged out.

P.S.
A lottery modul?
Hmm i would not use it but would be nice.

[Xenland]

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.html

its 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]

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]

how do I set a pool fee?

[Xenland]

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

[phorensic]

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]

How would I query for the number of active workers ?

[Xenland]

How would I query for the number of active workers ?

Code:

$fiveMinutesAgo = time();
$fiveMinutesAgo -= 60*5;

Code:

SELECT `id` FROM `stats_userMhashes` WHERE `timestamp` >= $fiveMinutesAgo AND `mhashes` > 0

try that?

[xane]

Ok I read a couple of pages, but I can't find any info to WTF THIS SOFTWARE ACTUALLY DOES. 

Is it just a mining pool solution?

[peedee]

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]

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]

$fiveMinutesAgo = time();
$fiveMinutesAgo -= 60*5;

$fiveMinutesAgo = time() - 60 * 5; // WTF @ convulted code...