From: oldiesmann at hotpop dot com
Operating system: Red Hat Linux
PHP version: 4.3.2
PHP Bug Type: Variables related
Bug description: $HTTP_POST_VARS not being set/updated
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();
}
--
Edit bug report at http://bugs.php.net/?id=23957&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=23957&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=23957&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=23957&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=23957&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=23957&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=23957&r=support
Expected behavior: http://bugs.php.net/fix.php?id=23957&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=23957&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=23957&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=23957&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=23957&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=23957&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=23957&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=23957&r=gnused
