Newly adopted pets not inserting into database

[Hall of Famer]

I see where the problem is now, find this line from your doadopt.php file:

PHP Code:

mysql_query("INSERT INTO ".$prefix."owned_adoptables VALUES ('',  '$type', '$name','$loggedinname','0','0', '$code',  '','$alts','fortrade','no','$gender')"); 


Replace with:

PHP Code:

mysql_query("INSERT INTO ".$prefix."owned_adoptables VALUES ('',  '$type', '$name','$loggedinname','0','0','0','0','0','0','0', '$code',  '','$alts','fortrade','no','$gender')"); 


Note the seven zero's here. I am assuming that all the five new columns you add in your sql table has default value 0, you can change them to whatever you like though. Whenever you make changes in owned_adoptables table, make sure you edit this mysql query line in doadopt.php to make sure the total number of columns from your script file matches the total number of columns in your database table.