Bitcoin Forum

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program.  If not, see <http://www.gnu.org/licenses/>.

mysql> show tables;
+----------------+
| Tables_in_sc   |
+----------------+
| accountBalance |
| networkBlocks  |
| pool_worker    |
| settings       |
| shares         |
| shares_history |
| webUsers       |
+----------------+
7 rows in set (0.00 sec)

mysql> select * from sc.accountBalance;
+----+--------+---------+------------------------------------+------+-----------+
| id | userId | balance | sendAddress                        | paid | threshold |
+----+--------+---------+------------------------------------+------+-----------+
|  1 |      1 | 0       | 1CfUcB7yKKWpco3BPjzHjveyrR1rBmvmEp | 0    |         0 |
+----+--------+---------+------------------------------------+------+-----------+
1 row in set (0.00 sec)

mysql> select * from sc.shares;
Empty set (0.00 sec)

mysql> select * from sc.shares_history;
Empty set (0.00 sec)

mysql> select * from sc.pool_worker;
+----+------------------+-------------+----------+--------+----------+
| id | associatedUserId | username    | password | active | hashrate |
+----+------------------+-------------+----------+--------+----------+
|  1 |                1 | genewitch.1 | x        |      0 |        0 |
+----+------------------+-------------+----------+--------+----------+
1 row in set (0.00 sec)

mysql> select * from sc.shares;
Empty set (0.00 sec)

55c55
< 		$authPin	= (int) $_POST["authPin"];
---
> 		$authPin	= (string) $_POST["authPin"];
89c89
< 				if(!is_int($authPin)){
---
> 				if(!is_numeric($authPin)){

                $testUserQ = mysql_query("SELECT id FROM webUsers WHERE username = '".$username."' LIMIT 1");
                        //If not, create new user
                        //if (!$testUserQ) {
                        if (($testUserQ == false) || (mysql_num_rows($testUserQ) == 0)) {

}else if($inputAuthPin != $authPin && $act){

}else if($inputAuthPin != $authPin && $act != "addWorker"){

PHP Warning:  implode(): Invalid arguments passed in [PATH-TO]/cronjobs/shares.php on line 69

I was getting errors when testing the crobjobs via command line ssh:
[code]
 PHP Notice:  Undefined index: REMOTE_ADDR 

//Check that script is run locally
$ip = $_SERVER['REMOTE_ADDR'];
if ($ip != "127.0.0.1") {
	echo "cronjobs can only be run locally.";
	exit;
}

if (isset( $_SERVER['REMOTE_ADDR'])) 
 {
$ip = $_SERVER['REMOTE_ADDR'];
if ($ip != "127.0.0.1") 
      {
	echo "cronjobs can only be run locally.";
	exit;
      }
  }

    {
        "account" : "",
        "category" : "generate",
        "amount" : 50.00000000,
        "confirmations" : 120,
        "txid" : "47a833ba9e311a839988136a283d9e6a8d05f7c609cc5ec26de397f352472751",
        "time" : 1300079031
    },
    {
        "account" : "",
        "category" : "immature",
        "amount" : 50.00000000,
        "confirmations" : 119,
        "txid" : "c31c89383ec77234cc2c2cbeca87edbc2b6348edba9d0e6c343fc34f1ed730ff",
        "time" : 1300079115
    },

# bitcoind -datadir=testnet/1 gettransaction 47a833ba9e311a839988136a283d9e6a8d05f7c609cc5ec26de397f352472751

{
    "amount" : 50.00000000,
    "confirmations" : 120,
    "txid" : "47a833ba9e311a839988136a283d9e6a8d05f7c609cc5ec26de397f352472751",
    "time" : 1300079031,
    "details" : [
        {
            "account" : "",
            "category" : "generate",
            "amount" : 50.00000000
        }
    ]
}

# bitcoind -datadir=testnet/1 gettransaction c31c89383ec77234cc2c2cbeca87edbc2b6348edba9d0e6c343fc34f1ed730ff

{
    "amount" : 0.00000000,
    "confirmations" : 119,
    "txid" : "c31c89383ec77234cc2c2cbeca87edbc2b6348edba9d0e6c343fc34f1ed730ff",
    "time" : 1300079115,
    "details" : [
        {
            "account" : "",
            "category" : "immature",
            "amount" : 50.00000000
        }
    ]
}

//Get list of transactions
$transactions = $bitcoinController->query("listtransactions \"*\" 200");

//Go through all the transactions check if there is 50BTC inside
$numAccounts = count($transactions);

for($i = 0; $i < $numAccounts; $i++) {
	//Check for 50BTC inside only if they are in the generate category
	if($transactions[$i]["amount"] >= 50 && ($transactions[$i]["category"] == "generate" || $transactions[$i]["category"] == "immature")) {		
		//At this point we may or may not have found a block,
		//Check to see if this account addres is already added to `networkBlocks`
		$accountExistsQ = mysql_query("SELECT id FROM networkBlocks WHERE accountAddress = '".$transactions[$i]["txid"]."' ORDER BY blockNumber DESC LIMIT 0,1")or die(mysql_error());
		$accountExists = mysql_num_rows($accountExistsQ);

	    //Insert txid into latest network block
		if (!$accountExists) {									
			//Get last winning block			
			$lastSuccessfullBlockQ = mysql_query("SELECT n.id FROM networkBlocks n, winning_shares w where n.blockNumber = w.blockNumber ORDER BY w.id DESC LIMIT 1");
			$lastSuccessfullBlockR = mysql_fetch_object($lastSuccessfullBlockQ);
			$lastEmptyBlock = $lastSuccessfullBlockR->id;			

			$insertBlockSuccess = mysql_query("UPDATE networkBlocks SET accountAddress = '".$transactions[$i]["txid"]."' WHERE id = $lastEmptyBlock")or die(mysql_error());
					
			//Update site balance for tx fee
			$poolReward = $transactions[$i]["amount"] - $bonusCoins;
			mysql_query("UPDATE settings SET value = value + $poolReward WHERE setting='sitebalance'");
		}			
	}
}

//Go through networkblocks and update confirms as needed
$winningAccountQ = mysql_query("SELECT id, accountAddress FROM networkBlocks WHERE accountAddress <> '' AND confirms < 120");
while ($winningAccountR = mysql_fetch_object($winningAccountQ)) {
	$txInfo = $bitcoinController->gettransaction($winningAccountR->accountAddress);
	if (count($txInfo["confirmations"]) > 0) {
		mysql_query("UPDATE networkBlocks SET confirms = ".$txInfo["confirmations"]." WHERE id = $winningAccountR->id");
	}
}

//Query bitcoind for list of transactions
$transactions = $bitcoinController->query('listtransactions', '', '60');

//Go through all the transactions check if there is 50BTC inside
$numAccounts = count($transactions);

for($i = 0; $i < $numAccounts; $i++){
        //Check for 50BTC in each transaction (even when immature so we can start tracking confirms)
        if($transactions[$i]["amount"] >= 50 && ($transactions[$i]["category"] == "generate" || $transactions[$i]["category"] == "immature")) {

// Update MtGox last price via curl, 3 second timeout on connection
$mtgox_ticker = exec("/usr/bin/curl -q -s --connect-timeout 3 'https://mtgox.com/code/data/ticker.php'");
if (!is_null($mtgox_ticker)) {
        $ticker_obj = json_decode($mtgox_ticker);
        if (intval($ticker_obj->ticker->last) > 0) {
                $settings->setsetting('mtgoxlast', $ticker_obj->ticker->last);
        }
}

//Include site functions
include("includes/requiredFunctions.php");
include("includes/universalChecklogin.php");

$user = $userInfo->username;
$checkPassQ = mysql_query("SELECT id FROM webUsers WHERE username = '".$user."' LIMIT 0,1");
$checkPass = mysql_fetch_object($checkPassQ);
$userid = $checkPass->id;

setcookie($cookieName, false);
unset($cookieValid);
mysql_query("UPDATE `webUsers` SET `sessionTimeoutStamp` = '0' WHERE `id` = '" .$userid. "'");
header("Location: /index.php");

//Check if the cookie is set, if so check if the cookie is valid
if(isSet($_COOKIE[$cookieName])){
        $cookieValid = false;
        $ip = $_SERVER['REMOTE_ADDR']; //Get Ip address for cookie validation
        $validateCookie = new checkLogin();
        $cookieValid = $validateCookie->checkCookie(mysql_real_escape_string($_COOKIE[$cookieName]), $ip);
        $userId = $validateCookie->returnUserId($_COOKIE[$cookieName]);

        //ensure userId is integer to prevent sql injection attack
        if (!is_numeric($userId)) {
                $userId = 0;
                exit;
        }

if($act == "updateDetails"){
                        //Update user's details
                        $newSendAddress = mysql_real_escape_string($_POST["paymentAddress"]);
                        $newDonatePercent = mysql_real_escape_string($_POST["donatePercent"]);
                        $newPayoutThreshold = mysql_real_escape_string($_POST["payoutThreshold"]);
                        if ($newPayoutThreshold > 25)
                                $newPayoutThreshold = 25;
                        if ($newPayoutThreshold < 1)
                                $newPayoutThreshold = 0;
                        if ($newDonatePercent < 0)
                                $newDonatePercent = 0;

[Thu Jul 07 02:36:39 2011] [error] PHP Parse error:  syntax error, unexpected T_VARIABLE in /htdocs/adminPanel.php on line 43

        //Make sure an authPin is set and valid when $act is active^M
        if($_POST["act"] && $_$authPin == $inputAuthPin){

[Sat Jul 09 14:27:48 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_data_seek(): Offset 0 is invalid for MySQL result index 28 (or the query data is unbuffered) in /var/www/stats.php on line 353, referer: http://xx.xx.xx.xx/accountdetails.php
[Sat Jul 09 14:29:33 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_data_seek(): Offset 0 is invalid for MySQL result index 28 (or the query data is unbuffered) in /var/www/stats.php on line 353, referer: http://xx.xx.xx.xx/accountdetails.php
[Sat Jul 09 14:29:46 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_data_seek(): Offset 0 is invalid for MySQL result index 28 (or the query data is unbuffered) in /var/www/stats.php on line 353, referer: http://xx.xx.xx.xx/accountdetails.php
[Sat Jul 09 14:30:11 2011] [error] [client xx.xx.xx.xx] PHP Notice:  Undefined variable: cookieName in /var/www/includes/universalChecklogin.php on line 23, referer: http://xx.xx.xx.xx/includes/
[Sat Jul 09 14:35:51 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_data_seek(): Offset 0 is invalid for MySQL result index 28 (or the query data is unbuffered) in /var/www/stats.php on line 353, referer: http://xx.xx.xx.xx/accountdetails.php
[Sat Jul 09 14:35:59 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_data_seek(): Offset 0 is invalid for MySQL result index 28 (or the query data is unbuffered) in /var/www/stats.php on line 353, referer: http://xx.xx.xx.xx/my_stats.php
[Sat Jul 09 14:39:31 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_data_seek(): Offset 0 is invalid for MySQL result index 28 (or the query data is unbuffered) in /var/www/stats.php on line 353, referer: http://xx.xx.xx.xx/accountdetails.php
[Sat Jul 09 14:43:12 2011] [error] [client xx.xx.xx.xx] PHP Parse error:  syntax error, unexpected T_VARIABLE in /var/www/adminPanel.php on line 42, referer: http://xx.xx.xx.xx/index.php
[Sat Jul 09 14:43:39 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_data_seek(): Offset 0 is invalid for MySQL result index 28 (or the query data is unbuffered) in /var/www/stats.php on line 353, referer: http://xx.xx.xx.xx/index.php
[Sat Jul 09 14:43:42 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_data_seek(): Offset 0 is invalid for MySQL result index 28 (or the query data is unbuffered) in /var/www/stats.php on line 353, referer: http://xx.xx.xx.xx/index.php

Jul  9 15:50:01 bitcoinitalia CRON[11981]: (root) CMD (/var/www/cronjobs/cronjob.php)
Jul  9 15:50:01 bitcoinitalia CRON[11980]: (root) CMD (/var/www/cronjobs/archive.php)
Jul  9 15:50:01 bitcoinitalia CRON[11978]: (CRON) error (grandchild #11981 failed with exit status 126)
Jul  9 15:50:01 bitcoinitalia CRON[11979]: (CRON) error (grandchild #11980 failed with exit status 126)

Cannot load the ionCube PHP Loader - it was built with configuration 2.2.0, whereas running engine is API220090626,NTS

Deprecated: Directive 'register_long_arrays' is deprecated in PHP 5.3 and greater in Unknown on line 0

Deprecated: Directive 'safe_mode' is deprecated in PHP 5.3 and greater in Unknown on line 0

Deprecated: Directive 'magic_quotes_gpc' is deprecated in PHP 5.3 and greater in Unknown on line 0

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in .../httpdocs/stats.php on line 298

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in .../httpdocs/news.php on line 25

Warning: include() [function.include]: Filename cannot be empty in .../httpdocs/users.php on line 82

Warning: include() [function.include]: Failed opening '' for inclusion (include_path='.:') in .../httpdocs/users.php on line 82

Fatal error: Uncaught BitcoinClientException: [0]: Didn't receive 200 OK from remote server. (HTTP/1.1 404 Not Found) thrown in on line 0

[Fri Aug 12 16:11:18 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62

[Fri Aug 12 16:11:19 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/register.php

[Fri Aug 12 16:11:21 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/stats.php

PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/gettingstarted.php

[error] [client 58.218.199.22
7] script '/var/www/proxyheader.php' not found or unable
 to stat

[Fri Aug 12 16:10:52 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/register.php

[Fri Aug 12 16:11:13 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/register.php

[Fri Aug 12 16:11:16 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/register.

] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/about.php

[Fri Aug 12 16:10:49 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/about.php

[Fri Aug 12 16:10:51 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/stats.php

setCache("pool_hashrate", $currenthashrate, 300);
try {
$fileName = "/var/www/api/pool/speed";
$fileHandle = fopen($fileName, 'w') or die("can't open file");
fwrite($fileHandle, ($currenthashrate/1000));
fclose($fileHandle);
} catch (Exception $e) {
//echo $e->getMessage();
}

] PHP Warning:  Invalid argument supplied for foreach()
in /var/www/includes/stats.php on line 89

] PHP Warning:  Invalid argument supplied for foreach()
in /var/www/stats.php on line 75

[Sat Aug 13 11:47:01 2011] [error] [client 84.228.254.88
] PHP Fatal error:  Call to a member function fetch() on
 a non-object in /var/www/includes/stats.php on line 42,

PHP Fatal error:  Call to a member function fetch() on a non-object in /var/www/simplecoin/includes/stats.php on line 276

if ($currentSharesR = $currentSharesQ->fetch()) {

$sql = "SELECT count(id) as id FROM shares WHERE id > $lastwinningshare AND username in ('".implode("','",$workers)."')";

edit pool_worker mysql
disabled enum('yes','no') NOT NULL DEFAULT 'no'

//Check if username already exists
$usernameExistsQ = mysql_query("SELECT id,username FROM `pool_worker` WHERE `associatedUserId` = ".$userId." AND `username` = '".$inputUser."'");
$usernameExists = mysql_num_rows($usernameExistsQ);
$usernameExists1 = mysql_fetch_object($usernameExistsQ);
$workerId = $usernameExists1->username;


}else if($usernameExists == 1){
mysql_query("UPDATE `pool_worker` SET disabled = 'no' WHERE username = '".$workerId."' AND `associatedUserId` = '".$userId."'")or sqlerr(__FILE__,__LINE__);
returnError = "Reinstated Worker";
}

			//Delete worker OH NOES!
				mysql_query("UPDATE `pool_worker` SET `disabled` = 'yes' WHERE `id` = '".$workerId."' AND `associatedUserId` = '".$userId."'")or sqlerr(__FILE__,__LINE__);
		}

$getWorkers = mysql_query("SELECT `id`, `username`, `password`, active, hashrate, monitor, disabled FROM `pool_worker` WHERE `associatedUserId` = '".$userId."' AND disabled = 'no'");

[Thu Apr 18 13:13:05 2013] [error] [client 172.18.1.240] PHP Warning:  array_key_exists() expects parameter 2 to be array, boolean given in /var/www/includes/stats.php on line 268, referer: http://172.18.251.184/my_stats.php
[Thu Apr 18 13:13:05 2013] [error] [client 172.18.1.240] PHP Warning:  fopen(/var/www/api/pool/speed): failed to open stream: No such file or directory in /var/www/includes/stats.php on line 83, referer: http://172.18.251.184/my_stats.php
[Thu Apr 18 13:13:05 2013] [error] [client 172.18.1.240] PHP Warning:  fwrite() expects parameter 1 to be resource, boolean given in /var/www/includes/stats.php on line 84, referer: http://172.18.251.184/my_stats.php
[Thu Apr 18 13:13:05 2013] [error] [client 172.18.1.240] PHP Warning:  fclose() expects parameter 1 to be resource, boolean given in /var/www/includes/stats.php on line 85, referer: http://172.18.251.184/my_stats.php
[Thu Apr 18 13:13:05 2013] [error] [client 172.18.1.240] PHP Warning:  Invalid argument supplied for foreach() in /var/www/includes/stats.php on line 110, referer: http://172.18.251.184/my_stats.php
[Thu Apr 18 13:13:06 2013] [error] [client 172.18.1.240] PHP Warning:  array_key_exists() expects parameter 2 to be array, boolean given in /var/www/includes/stats.php on line 268, referer: http://172.18.251.184/my_stats.php
[Thu Apr 18 13:13:06 2013] [error] [client 172.18.1.240] PHP Warning:  Division by zero in /var/www/includes/header.php on line 98, referer: http://172.18.251.184/my_stats.php