Помогите редактировать запрос

$rows = $db->super_query( "SELECT `category` FROM " . PREFIX . "_post WHERE `autor` = '$user'");
$row = $db->get_row( $rows );

if( $row ) {
  do {
         ++$games_num[ $row['category'] ];
} while( $row = $db->get_row( $rows ) );
}

foreach( $games_num as $key => $val ) {
   $tpl->set( '{games-num-'.$key.'}', $val );
}

$rows = $db->super_query( "SELECT COUNT(*) as count FROM " . PREFIX . "_post WHERE category IN ('" . implode ( "','", $cat_info[$category_id] ) . "') AND autor = '$user'");

Да и вообще не указаны типы переменных. Нет проверок

    $rows = $db->query( "SELECT `category` FROM " . PREFIX . "_post WHERE `autor` = '$user'");
$row = $db->get_row( $rows );
 
if( $row ) {
  do {
         ++$games_num[ $row['category'] ];
} while( $row = $db->get_row( $rows ) );
}
 
foreach( $games_num as $key => $val ) {
   $tpl->set( '{games-num-'.$key.'}', $val );
}

        $rows = $db->query( "SELECT `category` FROM " . PREFIX . "_post WHERE `autor` = '$user'");
        $rowz = $db->get_row( $rows );
 
if( $rowz ) {
  do {
         ++$m_num[ $rowz['category'] ];
}   while( $rowz = $db->get_row( $rows ) ); 
}
 
foreach( $m_num as $key => $val ) {
   $tpl->set( '{m-num-'.$key.'}', $val );
}

 /**
  * Подсчет количества постов по каждой категории у определенного юзера
  */

      // Получим category для данного автора

      $pUserArray = $db->super_query ( "SELECT category FROM " . PREFIX . "_post WHERE autor = '" . $user . "'", TRUE );

      // Т.к. возможна мультикатегорийность, то пройдемся по каждой полученной категории

      if ( ! empty ( $pUserArray ) )
      {

              $countFromCategory = array();

              foreach ( $pUserArray as $_pua )
              {

                  $categoryArr = explode ( ',', $_pua['category'] );

                  if ( ! empty ( $categoryArr ) )
                  {

                      if ( is_array ( $categoryArr ) )
                      {

                          foreach ( $categoryArr as $_ca )
                          {

                              ! isset ( $countFromCategory[$_ca] ) ? $countFromCategory[$_ca] = 1 : $countFromCategory[$_ca]++;

                          }

                      } else {

                          ! isset ( $countFromCategory[$categoryArr] ) ? $countFromCategory[$categoryArr] = 1 : $countFromCategory[$categoryArr]++;

                      }

                  } else {

                      continue;

                  }

              }


              if ( ! empty ( $countFromCategory ) )
              {

                  foreach ( $countFromCategory as $_cID => $_cfc )
                  {

                      $tpl->set( '{m-num-' . $_cID . '}' , $_cfc );

                  }

              }

      }

$tpl->set_block( "'\\[unews-num\\](.*?)\\[/unews-num\\]'si", "" );
                        $tpl->set( '[not-unews-num]', "" );
                        $tpl->set( '[/not-unews-num]', "" );