Sustentabilidade agora é

'".time()."'"); $ausers = mysql_result($ret,0); $ret = mysql_query("SELECT COUNT(clienteid) FROM `arvores`"); $arvoresplant = mysql_result($ret,0); $co2neutr = $arvoresplant*60;*/ $pageviews = 0; $pageviewsmes = 0; $pageviewsdia = 0; $arvores = 0; $co2neutralizado = 0; $strano = strtotime(date('Y',time()).'-01-01'); $ano = date('Y-m-d',$strano); $strmes = strtotime(date('Y-m',time()).'-01'); $mes = date('Y-m-d',$strano); $ret = mysql_query("SELECT * FROM `pageviews`"); while($row = mysql_fetch_array($ret)){ if(strtotime($row['data']) >= $strano){ $pageviews = $pageviews + $row['pageviews']; } if(strtotime($row['data']) >= $mes){ $pageviewsmes = $pageviewsmes + $row['pageviews']; } if($row['data'] >= date('Y-m-d',time())){ $pageviewsdia = $pageviewsdia + $row['pageviews']; } } $ret = mysql_query("SELECT COUNT(licencaid) FROM `licenca` WHERE `estado` = 'A' AND datafim > '".time()."'"); $ausers = mysql_result($ret,0); $ret3 = mysql_query("SELECT * FROM `clientes`"); while($row3 = mysql_fetch_array($ret3)){ $ret = mysql_query("SELECT * FROM `licenca` WHERE `estado` = 'A' AND `clienteid` = '".$row3['clienteid']."' ORDER BY `datainicio` DESC LIMIT 1"); $row = mysql_fetch_array($ret); $ret2 = mysql_query("SELECT * FROM `versoes` WHERE `versaoid` = '".$row['versaoid']."'"); $row2 = mysql_fetch_array($ret2); $arvores = $arvores + $row2['arvores']; } $co2neutralizado = $arvores * 0.6; ?>