Not keeping variables that I know are there

[Jedi~]

Ok, I'm trying to update my mute users mod and write a new mod, and it's not keeping the $username variable that I know is there, nor the $ID_MEMBER. It's in the same function that uses the bloody variable and it says there's nothing in the variable. Here's the code I'm trying to use within ModifyMessage.php

Code Select Expand

$muteduser = mysql_query("SELECT muteduser FROM {db_prefix}members WHERE (memberName = '$username')");
$muteuser = mysql_fetch_row($muteduser);
Any ideas?
It gives me a mysql error saying that it's invalid, but the variable $username should be there!

First line of that function:

Code Select Expand

global $username,$ID_MEMBER,$currentboard,$yytitle,$txt,$color,$cgi,$imagesdir,$img,$threadid,$msg,$modSettings;

[Joseph Fung]

Just make sure accessing $muteuser[0] as opposed to $museuser

because you have $muteuser = mysql_fetch_row etc.... $musteuser is an array - so you need to access $muteuser[0]

I just thought I'd make sure you were doing it - based on your variable names it appeared you might be trying to just access $muteuser

[Joseph Fung]

wait - nvm.  make {db_prefix} {$db_prefix}

or else it would try to access a table name thats really odd

[Jedi~]

crap I didnt even see that, thanks Joseph!

EDIT: Didn't help any though :-/
The username shows now, the query doesnt work though

[Jedi~]

Ok, got that working, now it does it in another place (for a diff mod.)

I put this in the very bottom of Subs.php

Code Select Expand

if ($action == "change_mood") {
   $mood_chng = mysql_query("UPDATE {$db_prefix}members SET mood = '$mood', mood_filename = '$mood_fn' WHERE (memberName='$username')");
   }
It doesn't keep $username though, any ideas?