boa tarde
estou atualizando um script para usar em php 7, atualizei quase todas as funçoes mysql_ para mysqli, menos a mysqli_result que nao tem mais no php 7, pelo menos nao com a mesma funçao
o codigo
$boxes = 1;
$tot24 = "0";
$out24 = "0";
$click24 = "0";
$intot = "0";
$outtot = "0";
$clicktot = "0";
$credittot = "0";
while($row = mysqli_fetch_object($result3)) {
$result4 = mysqli_query($db1, "SELECT u0,u1,u2,u3,u4,u5,u6,u7,u8,u9,u10,u11,u12,u13,u14,u15,u16,u17,u18,u19,u20,u21,u22,u23 FROM stats WHERE id = $row->id");
$in = mysqli_fetch_array($result4, MYSQLI_NUM);
$result5 = mysqli_query($db1, "SELECT o0,o1,o2,o3,o4,o5,o6,o7,o8,o9,o10,o11,o12,o13,o14,o15,o16,o17,o18,o19,o20,o21,o22,o23 FROM stats WHERE id = $row->id");
$out = mysqli_fetch_array($result5, MYSQLI_NUM);
$result6 = mysqli_query($db1, "SELECT c0,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23 FROM stats WHERE id = $row->id");
$click = mysqli_fetch_array($result6, MYSQLI_NUM);
$today = 0;
$todayout = 0;
$todayclick = 0;
for($i=0;$i<=$thishour;$i++) {
$today = $today + $in[$i];
}
for($i=0;$i<=$thishour;$i++) {
$todayout = $todayout + $out[$i];
}
for($i=0;$i<=$thishour;$i++) {
$todayclick = $todayclick + $click[$i];
}
$totalins = $row->ins + $today;
$totalout = $row->outs + $todayout;
$totalclick = $row->clicks + $todayclick;
if($row->ins24 == 0) $prod24 = "0%";
else $prod24 = round($row->click24 / $row->ins24 * 100) ."%";
if($totalins == 0) $prod = "0%";
else $prod = round($totalclick / $totalins * 100) ."%";
if($row->active == 0) {
$bgimg = "../images/system/line2.jpg";
$enable = "<span onclick=\"enable('partner',$row->id);\" id=\"enable$row->id\"><img src=\"../images/system/enable.jpg\" id=\"enimg$row->id\"></span>";
} else {
$bgimg = "../images/system/line.jpg";
$enable = "<span onclick=\"disable('partner',$row->id);\" id=\"enable$row->id\"><img src=\"../images/system/disable.jpg\" id=\"enimg$row->id\"></span>";
}
if($row->chosen == 0) $chosenone = "No";
else $chosenone = "Yes";
if($row->noframe == 0) $nofrm = "Yes";
else $nofrm = "No";
$credits = round($totalins - $totalout * ($ratio / 100));
if($showdaily == 1) {
$showin2 = $today;
$showout2 = $todayout;
if($today == 0) $showprod2 = "0%";
else $showprod2 = round($todayclick / $today * 100) ."%";
} else {
$showin2 = $row->ins24;
$showout2 = $row->out24;
$showprod2 = $prod24;
}
if(strlen($row->domain) > 15) $domain = substr($row->domain, 0, 15)."...";
else $domain = $row->domain;
$allplugs = mysqli_result(mysqli_query($db1, "SELECT COUNT(*) FROM content WHERE domain='$row->domain'"),0);
$activeplugs = mysqli_result(mysqli_query($db1, "SELECT COUNT(*) FROM content WHERE domain='$row->domain' AND active=1"),0);
o erro esta nas duas ultimas linhas, porque nao existe a funçao msqli_result, pesquisei todos os topicos aqui do forum e de outros forum sobre o meu problema, consegui resolver quase todos menos esse do mysqli_result
ja tentei de todas as formas indicadas, a mais proxima foi
$allplugs = mysqli_query($db1, "SELECT COUNT(*) FROM content WHERE domain='$row->domain'");
$rows = $allplugs->fetch_assoc();
if(count($rows) > 0){ }
$activeplugs = mysqli_query($db1, "SELECT COUNT(*) FROM content WHERE domain='$row->domain'");
$rows = $activeplugs->fetch_assoc();
if(count($rows) > 0){ }
mas da o erro
Recoverable fatal error: Object of class mysqli_result could not be converted to string in /home2
linha do erro:
<div style=\"width:900px;float:left;\"><div class=\"edittitle\">Plugs(active):</div><div id=\"edittext\">$allplugs($activeplugs)</div></div>");
echo " <li id=\"li$row->id\">
o problema ainda é a forma de usar a funçao mysqli_result, acho que fiz da forma errada
alguem saberia onde esta o erro? ou indicar algum artigo relacionado...