report user in mlog

[riderz]

hey guys ive being strugling with this small damn code i have added code to report users porfile but now i want it to display in the main page in mlog like if there are new reports

(1|0|0)

the 1 will be users profiles reported

  if(ismod($uid))
  {
echo "<hr />";
    $tnor = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE reported='1'"));
    $tot = $tnor[0];
    
     $tnor = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE reported='1'"));
    $tot = $tnor[0];
    
       $tnor = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts WHERE reported='1'"));
    $tot += $tnor[0];
    
    $tnor = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_topics WHERE reported='1'"));
    $tot += $tnor[0];
    
    $tnol = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_mlog"));
    $tol = $tnol[0];
    
    if($tol+$tot>0)
    {

    echo "<a href=\"mcppl.php?action=main&amp;sid=$sid\">&#187;$lang36</a>($tot|$tol)";
echo "<hr />";
}

[kevk3v]

try this

 if(ismod($uid))
  {
echo "<hr />";
    $tnor = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE reported='1'"));
    $tot = $tnor[0];
    
     $tnor = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE reported='1'"));
    $tot = $tnor[0];
    
       $tnor = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts WHERE reported='1'"));
    $tot += $tnor[0];
    
    $tnor = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_topics WHERE reported='1'"));
    $tot += $tnor[0];
    
    $tnol = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_mlog"));
    $tol = $tnol[0];
    echo "$tot";
    if($tol+$tot>0)
    {

    echo "<a href=\"mcppl.php?action=main&amp;sid=$sid\">»$lang36</a>($tot|$tol)";
echo "<hr />";
} 

or this

 if(ismod($uid))
  {
echo "<hr />";
    $tnor = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE reported='1'"));
    $tot = $tnor[0];
    
     $tnor = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE reported='1'"));
    $tot = $tnor[0];
    
       $tnor = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts WHERE reported='1'"));
    $tot += $tnor[0];
    
    $tnor = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_topics WHERE reported='1'"));
    $tot += $tnor[0];
    
    $tnol = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_mlog"));
    $tol = $tnol[0];
    echo "$tol";
    if($tol+$tot>0)
    {

    echo "<a href=\"mcppl.php?action=main&amp;sid=$sid\">»$lang36</a>($tot|$tol)";
echo "<hr />";
} 

[riderz]

what did u change on there i meant in the link part there must be like the following

 echo "<a href=\"mcppl.php?action=main&amp;sid=$sid\">»$lang36</a>($tot|$tol|$ruser)";

or what ever there must be extra space to show all the reported users in there or even if it show in the normal code that there are a reported object

[kevk3v]

well im afraid i cant help not so familar with lavalair sorry

[CreativityKills]

I did it in my script, cheque it

[riderz]

what script is that mobilegigs