xenland / miningfarm Goto Github PK
View Code? Open in Web Editor NEWA usefull tool for mining pool services
Home Page: miningfarm.com
License: Other
A usefull tool for mining pool services
Home Page: miningfarm.com
License: Other
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..
administrator panel option to change the theme of the charts
Have a install page where it configure the first blog post as well as the the heading before install is complete :)
Send email when workers stopped working.
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.
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 :)
workerstatus.php is not present yet
We also need a ranking system for top miners. and block finders
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:
shares
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
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.
We need a stats display for the total Mhash of total workers.
Yeah title says it all
Alot of optimization needs to be balanced in the blockFound.php
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.
Threshhold has been reported it isn't used for anything
Missing "shares_dead" table definition as added in new version with blockFound.php.
The new interface for the workers didn't update properly but delete works
(Javascript Solution on the way!!!!)
/customer/customername
to go a stats page of some sort
Apparently the threshhold is always at .5 even after the user has updated there information.
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
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.
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;
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
Implementing a posibility to recover and change the user Password
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
Just a reminder to myself no menu editor for editing menus.....
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#
replacement of the chart red curve "av. worker hashrate" with "total user hashrate" and addition of an other curve that displays the stale shares.
No pages for blogs
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
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.
We need a
% Pool efficiency display area
Total Shares out of Total Valid shares Pool display
Admin Panel settings not working
Unknown column 'currencyData' in 'field list'
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.