Mys v1.3.4 Itemdrop Mod for Mys v1.3.4

[squiggler]

Okay, went to adopts_inventory and it only said my cherries were there. In adopts_items, it has all 3 items listed. These are the values:
Full texts id category itemname description imageurl function target value shop price chance cap tradable consumable
2 valuable Raw Sapphire A beautiful blue stone. URL Valuable all 0 Toris Trinkets 100 100 99 yes NULL
3 valuable Ring A ring. URL Valuable all 0 Toris Trinkets 10 100 99 yes NULL
4 click Cherry A delicious cherry. Gives 25 clicks to your adopta... URL Click1 all 25 Toris Trinkets 25 100 99 yes yes

[LucasA33]

Yeah, that is strange. Maybe HoF can help you out further

[Hall of Famer]

So you are saying that the items are in your inventory when you go to phpmyadmin database but just somehow aint showing up on the site? Or did I misunderstand? I think posting the entries in your adopts_inventory table will be more helpful than adopts_items.

[squiggler]

They never get added to the inventory, it seems.
iid category itemname owner quantity status
3 click Cherry ToriandLori 97 Available

In fact, I just tried to click 2 adoptables, and it said I shoulda gotten them, but I didn't.

[Missy Master]

Whatever happened with this? Is it working for most people? I am launching four Pet sites on the 4th, and would love to include this but I don't want to mess up what I have ...

it looks like a lot of fun to use!!

Is this working ok now ?

[Hall of Famer]

It seems that some people are having trouble with it, as the items aint added to their inventory. I dunno why it happens though, but I can give a try troubleshooting it for the next 2-4 days.

[squiggler]

Thank you for working on it. If you need access to my files to do it, just ask!

[Missy Master]

Great!! Thanks HOF :)

[Hall of Famer]

Originally Posted by squiggler

Thank you for working on it. If you need access to my files to do it, just ask!

Oh sure, Id love to test it with a live site like yours. You can PM me the FTP information if you dont mind. ^^

[Hall of Famer]

I've fixed Squiggler's problem, it seems that there is a minor error I made for manual installation. This line:

PHP Code:

$this->setField("reward", ($dropstatus)?$dropstatus:new Integer(0)); 


should be:

PHP Code:

$this->setField("dropstatus", ($dropstatus)?$dropstatus:new Integer(0)); 


A typo, but significant enough to stop the mod from working. Also Squiggler made an error in the manual installation as well, perhaps I did not explain very well myself. When you add this row to table prefix.acp_hooks, for string columns please do not enter the double quotes and instead only enter the alphanumeric values. MySQL is not PHP, strings are not enclosed by double or single quotes. Note "Itemdrop"(with double quotes) and Itemdrop(without quotes) are different values for a mysql column, it will stop the mod from working.

PHP Code:

"id" => NULL, 
"linktext" => "Item Drop Plugin v1.3.4 by Hall of Famer", 
"linkurl" => "http://www.mysidiaadoptables.com/forum/showthread.php?t=4362", 
"pluginname" => "itemdrop", 
"pluginstatus" => 1 


Hope this helps, and note you should not encounter this issue if you simply download the script files and use automatic installer, it only affects manual installations.