[Opserty]

PHP Code:

$result = $db->query_read("
            SELECT `fname`, `id`, `q_id`, `priority`, `q_desc`, `char_id` 
            FROM quests 
            LEFT JOIN roster ON `char_id` = `id`
            WHERE `priority` > 0 AND `complete` = 0 
            ORDER BY `priority`");
 
while($thisquest = $db->fetch_array($result))
{
    $q_id = $thisquest[q_id];
    // Find out percentage complete and store in $pct
    
    $goal = 0;
    $current = 0;
    $goal_result = $db->query("SELECT `q_compl`, `q_stepdesc` FROM `quests_ext` WHERE `q_id` = '$q_id'");
    
    if($goal_result)
    {
      
        $numrows = $db->num_rows($goal_result);
        
        
        while($goal_rowset = $db->fetch_array($goal_result))
        {
            
           
            // THIS PART NOT WORKING AS IT SHOULD
            if(strlen($goal_rowset['q_stepdesc']))
            {
                $goal++;
                if($goal_rowset['q_compl']) 
                {
                    $current++;
                } 
            }
            // END OF NOT WORKING CODE
           
            $gr++;  
        }   
        
        if($goal != 0)
        {
            $pct = round(($current / $goal) * 100);
        }
        else
        {
            $pct = 0;
        }
        if($pct > 100)
        {
            $pct = 100;
        }
    
    
    }
    
     
    eval('$questlist .= "' . fetch_template('quest_questlist') . '";');
}
$db->free_result($result); 


Does that work? (You should really layout your code better too )