Can't update user status

[Dinocanid]

I have new columns in my users_status table for user achievements, but I can't seem to update them. I see lines like these in user.php that works for the others:

PHP Code:

$mysidia->db->update("users_status", array("canvm" => 'no'), "uid='{$mysidia->input->get("uid")}'"); 


One of my achievements unlocks when a user has owned a certain number of pets, which I used these lines of code in myadoptsview for:

PHP Code:

$shelfSpace = $mysidia->db->select("users", array("shelfspace"), "username = '{$mysidia->user->username}'")->fetchColumn(); 
$adoptAmount = $mysidia->db->select("owned_adoptables", array("aid"), "owner = '{$mysidia->user->username}'")->rowCount();
        if($adoptamount >= 10){
        $mysidia->db->update("users_status", array("fullpantry" => 'unlocked'), "username='{$mysidia->input->get("username")}'");
        } 


(located under public function index)

It's supposed to run when the user just visits the page since I wanted to avoid using buttons for this, but it doesn't work and I can't see why. Any ideas?

[Hwona]

Why don't you just use this?:

PHP Code:

 $mysidia->db->update("users_status", array("fullpantry" => 'unlocked'), "username='{$mysidia->user->username}'"); 


Isn't $mysidia->input->get("username") normally used to collect an input from a form?

[Dinocanid]

It is, I didn't realize I was using it though. Thanks for pointing that out! It still doesn't work though.

[Hwona]

Umm, I can't figure out what's wrong, but why don't you try printing out value for $adoptAmount to see if the value is correct.

[Dinocanid]

Found out what was wrong. I was using adoptamount in the database update instead of adoptAmount like it should be >_<