//--------------------------------------------
//zeit
$link = mysql_connect($dbhost, $dbusername, $dbpassword)
or die("Impossible de se connecter : " . mysql_error());
mysql_select_db($dbdatabase,$link) or die('Erreur de selection '.mysql_error());
$bitcoin2 = new Bitcoin($coin_username,$coin_password,$coin_url,$coin_port);
$tab = $bitcoin2->getinfo();
$hash = $bitcoin2->getmininginfo();
$hash = $hash['networkhashps'];
if ($hash > 1000000000) { // Ghash
$hashrate = $hash / 1000000000;
$hashrate = round($hashrate,3);
$hashrate .= ' Ghash';
} elseif ($hash > 1000000) { // Mhash
$hashrate = $hash / 1000000;
$hashrate = round($hashrate,3);
$hashrate .= ' Mhash';
}
else { // Khash
$hashrate = $hash;
$hashrate = round($hashrate,3);
$hashrate .= ' Khash';
}
$transa = $bitcoin2->listtransactions('*',$maxconnec,0);
$btcv = $tab['balance'] * $zeitBTC;
$btcusd = $usd * $btcv;
$btceur = $eur * $btcv;
echo "";
echo "
";
echo ''.$coin_name.' Stats';
echo 'VersionBlocksDiffNet HashConnectionsBalance'.$coin_name.' Value฿$€';
echo ''.$tab['version'].''.$tab['blocks'].''.$tab['difficulty'].''.$hashrate.''.$tab['connections'].''.$tab['balance'].''.$zeitBTC.''.number_format($btcv, 8,",","").''.number_format($btcusd, 4,",","").''.number_format($btceur, 4,",","").'
';
echo ''.$a1.'
';
echo '';
echo "
";
echo "";
echo 'Last 25 Transactions
';
echo 'Amount฿$DateTypeConfirmationsExplorer';
$i = $maxconnec;
$j = 190;
while($i > 0) {
$j--;
$i--;
if ($transa[$i]['category'] == 'generate') {
$aazz = $bitcoin2->gettransaction($transa[$i]['txid']);
$btcv = $aazz['fee'] * $zeitBTC;
$btcusd = $usd * $btcv;
}
elseif ($transa[$i]['category'] == 'orphan') {
$aazz = $bitcoin2->gettransaction($transa[$i]['txid']);
$btcv = $aazz['fee'] * $zeitBTC;
$btcusd = $usd * $btcv;
$myid = $transa[$i]['txid'];
$sqlx = "delete FROM pos WHERE txid='$myid'";
mysql_query($sqlx) or die('Erreur SQL !'.$sqlx.'
'.mysql_error());
}
elseif ($transa[$i]['fee'] < 0) {
$myid = $transa[$i]['txid'];
$sqlx = "delete FROM pos WHERE txid='$myid'";
mysql_query($sqlx) or die('Erreur SQL !'.$sqlx.'
'.mysql_error());
}
elseif ($transa[$i]['category'] == 'send') {
if ($transa[$i]['txid'] != $myid) {
$sql = "INSERT IGNORE INTO pos(txid, amount, date) VALUES('" .$transa[$i]['txid']. "','" .$transa[$i]['fee']. "','" .date('Y/m/d', $transa[$i]['timereceived']). "')";
mysql_query($sql) or die('Erreur SQL !'.$sql.'
'.mysql_error());
$btcv = $transa[$i]['fee'] * $zeitBTC;
echo ''.$transa[$i]['fee'].''.number_format($btcv, 8,",","").''.number_format($btcusd, 4,",","").''.date('d/m/Y', $transa[$i]['timereceived']).' à '.date('H:i', $transa[$i]['timereceived']).'POS'.$transa[$i]['confirmations'].'.$transa[$i]['txid'].'" TARGET="_blank">
';
}
}
else {
$btcv = $transa[$i]['amount'] * $zeitBTC;
$btcusd = $usd * $btcv;
echo ''.$transa[$i]['amount'].''.number_format($btcv, 8,",","").''.number_format($btcusd, 4,",","").''.date('d/m/Y', $transa[$i]['timereceived']).' à '.date('H:i', $transa[$i]['timereceived']).''.$transa[$i]['category'].''.$transa[$i]['confirmations'].'.$transa[$i]['txid'].'" TARGET="_blank">
';
}
}
echo "";
echo 'TotalTodayYesterdayAverage
';
$res = mysql_query('SELECT COUNT(*) AS total FROM pos') OR die(mysql_error());
$row = mysql_fetch_assoc($res);
$sql="SELECT Sum(amount) FROM pos";
$req = mysql_query($sql) or die('Erreur SQL !
'.mysql_error());
$data = mysql_fetch_array($req);
echo ''.number_format($data[0], 8,",","").' ('.$row['total'].')';
$avg = $data[0] / $dureeSejour2;
$res = mysql_query("SELECT COUNT(*) AS total FROM pos WHERE date='".$auj."'") OR die(mysql_error());
$row = mysql_fetch_assoc($res);
$sql="SELECT Sum(amount) FROM pos WHERE date='".$auj."'";
$req = mysql_query($sql) or die('Erreur SQL !
'.mysql_error());
$data = mysql_fetch_array($req);
echo ''.number_format($data[0], 8,",","").' ('.$row['total'].')';
$res = mysql_query("SELECT COUNT(*) AS total FROM pos WHERE date='".$hier."'") OR die(mysql_error());
$row = mysql_fetch_assoc($res);
$sql="SELECT Sum(amount) FROM pos WHERE date='".$hier."'";
$req = mysql_query($sql) or die('Erreur SQL !
'.mysql_error());
$data = mysql_fetch_array($req);
echo ''.number_format($data[0], 8,",","").' ('.$row['total'].')';
echo ''.number_format($avg, 8,",","").'
';
mysql_close($link);
echo "";
?>
) 
