[Kiint]

I'm currently modifying a piece of code, but I can't get it to work within vbulletin, it keeps giving me the wrong results.

What the code below is basically doing is getting a list of quests from the database, and putting them into templates and then displaying the results in a table, that part works great, but the part that isn't is the Percentage of what is complete.

For each row that it builds it should be checking another database table, adding up how many rows there are for each q_id and from working out how many of those rows are marked as complete it will make a percentage which is then passed into my template. However it doesn't process the highlighted part in the code below and gives me a value of zero for both of the variables, If i take out the IF statements it will give me results for everything (which is bad), so I know it's the conditions that are wrong...but why?

Any help is appreciated.

PHP Code:

  $result = $db->query("
 
    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)
    {
     $goal_rowset = $db->fetch_array($goal_result);
     $numrows = $db->num_rows($goal_result);
 
     $gr = 0;
     while($gr <= $numrows) {
      $row = $goal_rowset[$gr];
 
   // THIS PART NOT WORKING AS IT SHOULD
      if(strlen($row[q_stepdesc]))
      {
       $goal++;
       if($goal_rowset[$gr][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);