xenland / miningfarm Goto Github PK

For some reason sessions are not created at the http://www.bitcoin-server.de/ server mainly due becuase of the cookie creation isn't working. This is probably due to headers being sent some where

Threshhold has been reported it isn't used for anything

My webserver is running Apache/2 and MySQL client version: 5.1.30

I've downloaded the latest version but when i try to import the sql-data i get following error...

Error

SQL query:

-- Dumping data for table shares

-- Table structure for table shares_history

CREATE TABLE IF NOT EXISTS shares_history (
id bigint( 30 ) NOT NULL AUTO_INCREMENT ,
shareCounted int( 1 ) NOT NULL ,
blockNumber int( 255 ) NOT NULL ,
time varchar( 255 ) NOT NULL ,
rem_host varchar( 255 ) NOT NULL ,
username varchar( 120 ) NOT NULL ,
our_result enum( 'Y', 'N' ) NOT NULL ,
upstream_result enum( 'Y', 'N' ) DEFAULT NULL ,
reason varchar( 50 ) DEFAULT NULL ,
solution varchar( 257 ) NOT NULL ,
PRIMARY KEY ( id )
) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =19979;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--------------------------------------------------------

-- Table structure ' at line 4

in the /req/bitcoinWallet/bitcoin.inc.php the line, with "getblocknumber" under public just needs to be changed to "getblockcount" and it fixes the block#

The new interface for the workers didn't update properly but delete works
(Javascript Solution on the way!!!!)

Yeah title says it all

Alot of optimization needs to be balanced in the blockFound.php

Integration of the Miningfarm into Drupal http://www.drupal.org

BTC Value in fiat dnt get actual. The Chart dnt refresh itself and hangs on entry 2:01 no further entries are shown since a few days.

Basicaly the BTC Value chart should be actual and sync with the topright value of the btc.

Home page: Unknown column 'efficiency' in 'field list'

Database:
CREATE TABLE IF NOT EXISTS stats_userMHashHistory (
id int(255) NOT NULL AUTO_INCREMENT,
username varchar(255) NOT NULL,
mhashes varchar(20) NOT NULL,
efficiency varchar(5) NOT NULL,
timestamp int(20) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4704 ;

import phpmyadmin OK but "efficiency" not present..

just noticed there are no index files in the underlying directories.

solution: create an empty "index.php" file with this content and place the file into every directory you want to keep hidden from our users.

This way users get redirected to the parent directory.
No need to go into the system sub-directories.

We need a stats display for the total Mhash of total workers.

Back-end works great, shares are being submitted and updated into the database no problems. However, front-end is getting slower and slower as 'shares' table grows. At 1.8Million rows in 'shares' currently. "statsUpdater.php" currently takes 2mins 40secs to get stats. Web pages currently take 10-15 seconds to load. This is an 8 core Xeon server with 4GB of RAM and a super optimized ext4 storage system. We are not storage or RAM bound right now. Load average is extremely low. There is something inefficient about 'shares'. I see we are doing large SELECT's on 'shares' that are taking a long time. I've looked at all possibly ways to increase performance of the front end and it's lead me to possibly Indexing some things. Using your database layout, nothing is really Indexed for these large SELECT's. I'm thinking about indexing epochTimestamp column, but I can't do that until the next round as it will lock the table. I might want to index other columns after that, not sure. Thoughts? Can't live with 15 second load times on the webpage, unfortunately.

Send email when workers stopped working.

No pages for blogs

Apparently I forgot about the blog editor menu item link, So I will be sure to include this in the next update.

for now you can access your blog editor by going to

http://domain.com/adminPanel.php?show=blogEditor

workerstatus.php is not present yet

administrator panel option to change the theme of the charts

Yes the account details palge is blank. It is due to small errors the code such as ";" and some comma i forgot.
Upon fixing these issues, Payouts don't work so I am working on that aswell thanks everyone :)

Just a reminder to myself no menu editor for editing menus.....

We also need donation perks where admins can setup less server fees when the user makes a donation.

ETA till next block found graph is 90% never accruate becuase its based on time and dosent take in to consideration the hashrate.

We also need a ranking system for top miners. and block finders

top right stats shows above the actual BTC Value
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in .../httpdocs/req/functions.php on line 391

Apparently the threshhold is always at .5 even after the user has updated there information.

Implementing a posibility to recover and change the user Password

Missing "shares_dead" table definition as added in new version with blockFound.php.

I have forgot to include the option for pools to set the "Show all users stats" on or off. Basically it will display front page pool stats of all users, usefull for private pools

pendingBalance is called from accountDetails, and it is defined in functions, but never populated with values. I have an old version of functions.php that had the block of code still in it. It was broken, so I fixed it. It now works on my site. Code below:

    //Get unconfirmed balance

        //Go through all the `shares_history` Blocks numbers that have been found

            $unconfirmedBalance = 0;

            $blockHistoryQ = mysql_query("SELECT DISTINCT `blockNumber` FROM `shares_history` WHERE `username` LIKE '$username.%'");

            while($block = mysql_fetch_array($blockHistoryQ)){

                //With the selected $block, check estimated balance from that round

                    $getRoundSharesQ = mysql_query("SELECT `id` FROM `shares_history` WHERE `blockNumber` = '".$block["blockNumber"]."' AND `username` LIKE '$username.%' AND `our_result` != 'N'");

                    $numRoundShares = mysql_num_rows($getRoundSharesQ);



                    $getTotalRoundSharesQ = mysql_query("SELECT `id` FROM `shares_history` WHERE `blockNumber` = '".$block["blockNumber"]."' AND `our_result` != 'N'");

                    $numTotalRoundShares = mysql_num_rows($getTotalRoundSharesQ);



                //Calculate balance

                    $unconfirmedBalance += round(50*($numRoundShares/$numTotalRoundShares), 8);



            }

---and then later on $this->pendingBalance = $unconfirmedBalance;

Have a install page where it configure the first blog post as well as the the heading before install is complete :)

Admin Panel settings not working
Unknown column 'currencyData' in 'field list'

replacement of the chart red curve "av. worker hashrate" with "total user hashrate" and addition of an other curve that displays the stale shares.

/customer/customername
to go a stats page of some sort

We need a

% Pool efficiency display area
Total Shares out of Total Valid shares Pool display

I've looked over the code in /json/workerstatus.php and I've run the SQL commands manually. I suck at math and I can't figure out where the issue is. My workerstatus.php and database are exactly like yours.