Bug Reports

[admin]

Came across this.

If you have not created your own articles (i.e. you are using the default Joomla one's supplied with the sample data installed in the Joomla installation, Users may show the default articles in their profiles. This should not affect articles submitted by users or administrators - it only occurs with the default sample data installed with Joomla.

In any case, to fix open the file phpfox/plugins/hirednetwork/phpfox_functions.php

Find the code:

PHP Code:

$sql="SELECT * from ".$prefix."user where user='".$hit1."' LIMIT 1";
    $result=mysql_query($sql);
    $numRows = mysql_num_rows($result);
    if($numRows<1)
        {
        $sql="SELECT * from `".$prefix."user` where user='".$hit2."' LIMIT 1";
        $result=mysql_query($sql);
        if(mysql_num_rows($result)<1)
            {
            $artContent="";
            }
        else
            {
            $reqUser=$hit2;
            }
        }//end if
    else
        {
        $reqUser=$hit1;
        } 


Replace with:

PHP Code:

$sql="SELECT * from `".$prefix."user` where user='".$hit2."' LIMIT 1";
    
    $result=mysql_query($sql);
    $numRows = mysql_num_rows($result);
    if($numRows<1)
        {
        $sql="SELECT * from ".$prefix."user where user='".$hit1."' LIMIT 1";
        $result=mysql_query($sql);
        if(mysql_num_rows($result)<1)
            {
            $artContent="";
            }
        else
            {
            $reqUser=$hit2;
            }
        }//end if
    else
        {
        $reqUser=$hit2;
        }