UBB.Developers Forums UBB.threads 6 V6 Modifications Archived Mods [6.1.x] Last Post By

code:

Step 6.
   In your viewunapproved.php script find this:


       // ----------------------------------------
       // Grab the unapproved posts for this board 
          $Keyword_q = addslashes($Keyword);
          $query = "
           SELECT B_Number,B_Subject,B_Username,B_Posted 
           FROM  {$config['tbprefix']}Posts 
           WHERE B_Approved = 'no'
           AND   B_Board  = '$Keyword_q'
           ORDER BY B_Posted DESC
         ";

  
  and change it to this:

  
       // ----------------------------------------
       // Grab the unapproved posts for this board 
          $Keyword_q = addslashes($Keyword);
          $query = "
           SELECT B_Number,B_Subject,B_Username,B_Posted 
           FROM  {$config['tbprefix']}Posts 
           WHERE B_Approved = 'no'
           AND   B_Board  = '$Keyword_q'
           ORDER BY B_Number DESC
         ";