Mysidia Adoptables Support Forum - Error When Using Item

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)

- Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)

- - Error When Using Item (http://www.mysidiaadoptables.com/forum/showthread.php?t=4628)

I have an account on your site now, I've purchased some items and I will adopt a few pets too. With this, I will try to reproduce the same white screen as you've encountered. I am sure theres a way to find out, I will let you know once I figure out. ^^

Great!!

It took me ten times on one account and 20 on another to get it to happen, but once it did, there was no going back. Most of the members cant use items it seems now ...

@Annatar
Wait... do you think it's a problem with the database?

Well, I really cant tell, because I've looked at everything after this happens, and right before, too, noted what all the user, item, inventory, banning, all those tables for all that, and I can't find one thing different in anything.

But it's likely some obscure value that gets inserted, or possibly there is a 'cut off' ?? Of how many items can be used?

It might possibly be something in where the amount of clicks and leveling gets cut off, there's something that seems to reach a cut off and then you error out and white out. Syntax is bad for it or something, but once you reach this critical point, you get no more chances then lol.

And bingo make a new account and log in, and you're right as rain.

Can't be ip based.

@Annatar
I tried over 30 times on my test site...
Nothing. Everything works.
What browser are you all using and how many items, pets, and users do you have?

I know it isn't just me since others are having it happen on their sites, and once it happens, it doesn't matter what browser or anything, I have used Chrome, FF and IE.

Happens on all of them :(

I have about 20 users, 15 items, 10 pet species.

Try making an account on Simmland and see if it happens? I had to do it 15 times but it did happen again, and then 20 times later on a second account.

Quote:

Originally Posted by Annatar (Post 30982)

I'll try on your site... What kinds of items have you been using? O.o

I've used Mature ( kicks a baby to level 3 ), and toys.

Let me paste the codes here for the toys for you :)

This is from functions_items.php, and is the basic outlay for all my add on toys. They work fine over and over, and then --- they don't. The only diff for any of these is they insert toys into different 'slots' to allow for more to be seen at a time.

Possibly it's reaching a cut off from the leveling of clicks or something? But then, why am I not the only one having it happen on their site ...

Code:





function items_click4($item, $adopt){

  $mysidia = Registry::get("mysidia");

  $newclicks = $item->value;

  $mysidia->db->update("owned_adoptables", array("totalclicks" => $newclicks), "aid='{$adopt->aid}'and owner='{$item->owner}'");



  $mysidia->db->update("owned_adoptables", array("toy_1" => $newclicks), "aid='{$adopt->aid}'and owner='{$item->owner}'");

  $note = "You added a {$item->itemname}, and the Pet has just received a {$item->value}<br>";

  //Now lets check if the adoptable has reached a new level.

  

  $ownedAdopt = new OwnedAdoptable($adopt->aid);

  if($ownedAdopt->hasNextLevel()){

      //new level exists, time to check if the total clicks have reached required minimum clicks for next level.

         $nextLevel = $ownedAdopt->getNextLevel();

         $requiredClicks = $nextLevel->getRequiredClicks();

     if($newclicks >= $requiredClicks and $requiredClicks != 0 and $requiredClicks != ""){

            // We need to level this adoptable up...

        $mysidia->db->update("owned_adoptables", array("currentlevel" => $nextlevel), "aid ='{$adopt->aid}' and owner='{$item->owner}'");          

        $note .= "And it has gained a new level!";

     }

  }



  //Update item quantity...

  $delitem = $item->remove(); 

  return $note;

}

@Annatar
Okay... well, I tried this on canis, but I don't seem to be having any problems... O.o
Are you only having this on SIMLAND?
Edit: Can you test it out on my site?