function giveinfobalance(){ $dblocation = "localhost"; $dbuser = "******"; $dbpasswd = "libertos"; $dbname="bitcoin_db"; $db = new SafeMysql(array('user' => $dbuser, 'pass' => $dbpasswd,'db' => $dbname, 'charset' => 'utf8')); $kon="1"; $timestamplast=strtotime("2013-06-04"); $today=date("Y-m-d",$timestamplast); $todaynow=date("Y-m-d"); for (;$kon != "0" ;){ $timestamplast=strtotime("$today"); $today=date("Y-m-d",$timestamplast+(24*60*60)); echo " ,['".$today."', "; $result = $db->query("select * from btce_balance where date like \"%$today%\""); $maximum=0; while ($row = $db->fetch($result)){ if ($row['balance'] > $maximum){ $maximum=$row['balance']; } } echo "$maximum"; echo ","; $result = $db->query("select * from mtgox_balance where data like \"%$today%\""); $maximum2=0; while ($row = $db->fetch($result)){ if ($row['balance'] > $maximum2){ $maximum2=$row['balance']; } } echo "$maximum2"; echo ", "; $allmax=$maximum2+$maximum; echo "$allmax"; echo "] "; if ($today == $todaynow){ $kon="0"; } } }
<? ini_set("session.gc_maxlifetime", 3600); include_once('../safemysql.class.php'); $dblocation = "localhost"; $dbuser = "******"; $dbpasswd = "libertos"; $dbname="bitcoin_db"; $db = new SafeMysql(array('user' => $dbuser, 'pass' => $dbpasswd,'db' => $dbname, 'charset' => 'utf8')); $stack=array(); $b=0; $ba=720; for ($i=0; $i < 60; $i++){ $min=10000; $max=0; $result = $db->query("select * from mtgox_ticker order by id desc limit $b,720;"); while ($row = $db->fetch($result)){ $where=$row['date']; if ($row['current'] < $min){ $min=$row['current']; } if ($row['current'] > $max){ $max=$row['current']; } } $close=$db->getRow("select * from mtgox_ticker order by id desc limit $b,1;"); $close=$close['current']; $open=$db->getRow("select * from mtgox_ticker order by id desc limit $ba,1;"); $open=$open['current']; $inarray="['".$where."', $min, $open, $close, $max],"; #echo $inarray;
<? ini_set("session.gc_maxlifetime", 3600); include_once('../safemysql.class.php'); $dblocation = "localhost"; $dbuser = "******"; $dbpasswd = "libertos"; $dbname="bitcoin_db"; $db = new SafeMysql(array('user' => $dbuser, 'pass' => $dbpasswd,'db' => $dbname, 'charset' => 'utf8')); $stack=array(); $b=0; $ba=30; for ($i=0; $i < 60; $i++){ $min=10000; $max=0; $result = $db->query("select * from btce_ticker order by id desc limit $b,30;"); while ($row = $db->fetch($result)){ $where=$row['date']; if ($row['current'] < $min){ $min=$row['current']; } if ($row['current'] > $max){ $max=$row['current']; } } $close=$db->getRow("select * from btce_ticker order by id desc limit $b,1;"); $close=$close['current']; $open=$db->getRow("select * from btce_ticker order by id desc limit $ba,1;"); $open=$open['current']; $inarray="['".$where."', $min, $open, $close, $max],"; #echo $inarray;