$mysqluser = "webco2ze_dash"; $mysqlpass = "uadrc]H;z,7;"; $clientebd = "webco2ze_dashboard"; $db = mysql_connect($mysqlserver,$mysqluser,$mysqlpass); mysql_select_db($clientebd); mysql_set_charset('utf8'); $dominio = $_GET["dominio"]; $ret = mysql_query("SELECT * FROM `clientes` WHERE `website` LIKE '%".$dominio."'"); $row = mysql_fetch_array($ret); $ret3 = mysql_query("SELECT * FROM `licenca` WHERE `clienteid` = '".$row['clienteid']."'"); while($row3 = mysql_fetch_array($ret3)){ $ret2 = mysql_query("SELECT * FROM `versoes` WHERE `versaoid` = '".$row3["versaoid"]."'"); while($row2 = mysql_fetch_array($ret2)){ $arvorescli = $arvorescli + $row2['arvores']; } } $ret2 = mysql_query("SELECT * FROM `licenca` WHERE `clienteid` = '".$row['clienteid']."' ORDER BY `datainicio` ASC LIMIT 1"); $plicenca = mysql_fetch_array($ret2); ?>