I have been trying for a couple of weeks to get these functions to work. The functions are part of a mod for YaBB SE that displays user selectable moods on the board. The admin is supposed to be able to update/reorder these moods using the following code, however, it won't update the values. It appears that the $HTTP_POST_VARS aren't being updated, almost as if it loses all the info that the user has just entered as soon as you submit the changes. I've tried several different ways of doing this (do...while, even a for loop using mysql_count_rows), and it won't work. Here's a little extra info as to what the variables are - $moodtxt is the variable for the array of text strings that go along with this mod. The $color stuff is set in the template. $cgi is 'index.php?board='. All of the action variables are set in an array in the main index.php file (I've got it set to go to the ModifyMoods2() function when it sees "action=modifymoods"). Also, $db_prefix is set in the settings file - this is the database table prefix. $imagesdir is the url for the images directory for the board.

Here's the code:

function ModifyMoods() { 
   global $db_prefix, $moodtxt, $imagesdir, $cgi, $yytitle, $id, $HTTP_POST_VARS; 
    
        is_admin(); 
   $yytitle = $moodtxt[8]; 
   template_header(); 
    
   $get_moods = mysql_query("SELECT * FROM {$db_prefix}moods ORDER BY oid ASC"); 
   echo ' 
   <form action="' . $cgi . ';action=modifymoods" method="POST"> 
   <table border="1" width="100%" cellspacing="0" cellpadding="0" bgcolor="' . $color['bordercolor'] . '" class="bordercolor" align="center"> 
   <tr> 
                <td valign="middle" align="left" class="titlebg" bgcolor="' . $color['titlebg'] . '" colspan="5" height=22> <img src="' . $imagesdir . '/grin.gif" /> </td> 
      <td valign="middle" align="center" class="titlebg" bgcolor="' . $color['titlebg'] . '" width="100%" height=22><b><font size="2" class="text1" color="' . $color['titletext'] . '">' . $moodtxt['1'] . '</font></b></td> 
   </tr></table> 
        <table border="0" width="100%" cellspacing="1" cellpadding="1" bgcolor="' . $color['bordercolor'] . '" class="bordercolor" align="center"> 
   <tr> 
      <td class="catbg" bgcolor="' . $color['catbg'] . '" width="30%" align="center">' . $moodtxt['6']. '</td> 
      <td class="catbg" bgcolor="' . $color['catbg'] . '" width="30%" align="center">' . $moodtxt['7'] . '</td> 
      <td class="catbg" bgcolor="' . $color['catbg'] . '" width="30%" align="center">' . $moodtxt['13'] . '</td> 
      <td class="catbg" bgcolor="' . $color['catbg'] . '" width="30%" align="center">Mood Image</td> 
      <td class="catbg" bgcolor="' . $color['catbg'] . '" width="10%" align="center"></td> 
   </tr>'; 

        $i = 1; 
   while ($mood = mysql_fetch_row($get_moods)) { 
      echo ' 
      <tr> 
         <td class="windowbg" bgcolor="' . $color['windowbg'] . '" width="30%" align="center"><input type="text" name="name$i" value="' . $mood[1] . '"></td> 
         <td class="windowbg" bgcolor="' . $color['windowbg'] . '" width="30%" align="center"><input type="text" name="fn$i" value="' . $mood[2] . '"></td> 
         <td class="windowbg" bgcolor="' . $color['windowbg'] . '" width="30%" align="center"><input type="text" name="oid$i" value="' . $mood[3] . '"></td> 
         <td class="windowbg" bgcolor="' . $color['windowbg'] . '" width="30%" align="center"><img src="' . $imagesdir . '/' . $mood[2] . '" alt="' . $mood[1] . '"></td>'; 
          
         if ($MenuType == 1) { echo' <td class="windowbg" bgcolor="' . $color['windowbg'] . '" width="10%" align="center"><a href="index.php?action=deletemood;id=' . $mood[0] . '">' . $moodtxt['14'] . '</a></td>';} 
              else { echo' <td class="windowbg" bgcolor="' . $color['windowbg'] . '" width="10%" align="center"><a href="index.php?action=deletemood;id=' . $mood[0] . '"><img src="' . $imagesdir . '/delete.gif" border=0 /></a></td>'; } 
      echo'</tr>'; 
      $i++; 
      } 
   echo ' 
   <tr> 
   <td class="catbg" bgcolor="' . $color['catbg'] . '" align="center" colspan="5"> 
   <input type="submit" value="Modify Moods"> 
   <br /></td></tr></table> 
   </form>'; 
   footer(); 
        obExit(); 
} 

function ModifyMoods2() { 
   global $db_prefix, $imagesdir, $HTTP_POST_VARS, $id, $oid, $name, $fn; 

   $i = 1; 
   $get_moods = mysql_query("SELECT * FROM {$db_prefix}moods WHERE (id='$id')"); 

   while ($mood = mysql_fetch_row($get_moods)) { 
                            if(isset($HTTP_POST_VARS["name$i"])){ 
                                if(isset($HTTP_POST_VARS["fn$i"])){ 
                                  if(isset($HTTP_POST_VARS["oid$i"])){ 
               $name[$i] = $HTTP_POST_VARS["name$i"]; 
               $fn[$i] = $HTTP_POST_VARS["fn$i"]; 
               $oid[$i] = $HTTP_POST_VARS["oid$i"]; 
                
               $result = mysql_query("   UPDATE {$db_prefix}moods 
                        SET name='$name[$i]',filename='$fn[$i]',oid='$oid[$i]' 
                        WHERE (id='$id')");                
               } 
            } 
         } 
      $i++; 
      } 
   ModifyMoods(); 
   }