Hello
I have a problem with my catalog. When i want to buy a animal, i have this problem
https://i.gyazo.com/b7ad65860e508f5b...271c7f8b7a.png
however the spride id matches with those in the furnidata
Printable View
Hello
I have a problem with my catalog. When i want to buy a animal, i have this problem
https://i.gyazo.com/b7ad65860e508f5b...271c7f8b7a.png
however the spride id matches with those in the furnidata
You checked the pet colors?
Comet? Are you sure that you checks the colors of pets (in database)?
To my knowledge, it is incomplete...
Try this, it may help you ...Code:-- ------------------------------ Table structure for pet_races
-- ----------------------------
DROP TABLE IF EXISTS `pet_races`;
CREATE TABLE `pet_races` (
`race_id` int(255) DEFAULT NULL,
`colour1` int(255) DEFAULT NULL,
`colour2` int(255) DEFAULT NULL,
`has1colour` enum('1','0') DEFAULT NULL,
`has2colour` enum('1','0') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of pet_races
-- ----------------------------
INSERT INTO `pet_races` VALUES ('12', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('12', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('12', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('12', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('12', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('12', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('17', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('18', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('19', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('20', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('21', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('22', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '7', '7', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '8', '8', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '9', '9', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '10', '10', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '11', '11', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '12', '12', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '13', '13', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '14', '14', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '15', '15', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '16', '16', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '17', '17', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '18', '18', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '19', '19', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '20', '20', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '21', '21', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '22', '22', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '23', '23', '1', '0');
INSERT INTO `pet_races` VALUES ('0', '24', '24', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '7', '7', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '8', '8', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '9', '9', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '10', '10', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '11', '11', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '12', '12', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '13', '13', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '14', '14', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '15', '15', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '16', '16', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '17', '17', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '18', '18', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '19', '19', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '20', '20', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '21', '21', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '22', '22', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '23', '23', '1', '0');
INSERT INTO `pet_races` VALUES ('1', '24', '24', '1', '0');
INSERT INTO `pet_races` VALUES ('10', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('9', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('9', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('9', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('9', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('9', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('9', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('9', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('9', '7', '7', '1', '0');
INSERT INTO `pet_races` VALUES ('9', '8', '8', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '8', '8', '0', '0');
INSERT INTO `pet_races` VALUES ('11', '9', '9', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '10', '10', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '11', '11', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '12', '12', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '13', '13', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '15', '15', '1', '0');
INSERT INTO `pet_races` VALUES ('11', '18', '18', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '7', '7', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '8', '8', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '9', '9', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '10', '10', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '11', '11', '1', '0');
INSERT INTO `pet_races` VALUES ('8', '14', '14', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '3', '3', '0', '1');
INSERT INTO `pet_races` VALUES ('7', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '7', '7', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '3', '3', '0', '1');
INSERT INTO `pet_races` VALUES ('7', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('7', '7', '7', '1', '0');
INSERT INTO `pet_races` VALUES ('5', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('5', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('5', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('5', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('5', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('5', '7', '7', '1', '0');
INSERT INTO `pet_races` VALUES ('5', '8', '8', '1', '0');
INSERT INTO `pet_races` VALUES ('3', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('3', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('3', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('3', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('3', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('3', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('3', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('4', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('4', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('4', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('4', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('2', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('2', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('2', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('2', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('2', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('2', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('2', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('2', '7', '7', '1', '0');
INSERT INTO `pet_races` VALUES ('2', '8', '8', '1', '0');
INSERT INTO `pet_races` VALUES ('2', '9', '9', '1', '0');
INSERT INTO `pet_races` VALUES ('2', '10', '10', '1', '0');
INSERT INTO `pet_races` VALUES ('2', '11', '11', '1', '0');
INSERT INTO `pet_races` VALUES ('6', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('6', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('6', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('6', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('6', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('6', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('6', '6', '6', '0', '1');
INSERT INTO `pet_races` VALUES ('6', '7', '7', '0', '1');
INSERT INTO `pet_races` VALUES ('6', '8', '8', '0', '1');
INSERT INTO `pet_races` VALUES ('6', '9', '9', '0', '1');
INSERT INTO `pet_races` VALUES ('6', '10', '10', '0', '1');
INSERT INTO `pet_races` VALUES ('6', '11', '11', '1', '0');
INSERT INTO `pet_races` VALUES ('6', '12', '12', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '1', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('15', '2', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('15', '3', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('15', '4', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('15', '1', '6', '1', '1');
INSERT INTO `pet_races` VALUES ('15', '2', '7', '1', '1');
INSERT INTO `pet_races` VALUES ('15', '3', '8', '1', '1');
INSERT INTO `pet_races` VALUES ('15', '4', '9', '1', '1');
INSERT INTO `pet_races` VALUES ('15', '1', '10', '1', '1');
INSERT INTO `pet_races` VALUES ('15', '2', '11', '1', '1');
INSERT INTO `pet_races` VALUES ('15', '3', '12', '1', '1');
INSERT INTO `pet_races` VALUES ('15', '4', '13', '1', '1');
INSERT INTO `pet_races` VALUES ('15', '1', '14', '1', '1');
INSERT INTO `pet_races` VALUES ('15', '2', '15', '1', '1');
INSERT INTO `pet_races` VALUES ('15', '3', '16', '1', '1');
INSERT INTO `pet_races` VALUES ('15', '4', '17', '1', '1');
INSERT INTO `pet_races` VALUES ('15', '1', '18', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '2', '19', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '3', '20', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '4', '21', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '1', '22', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '2', '23', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '3', '24', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '4', '25', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '1', '26', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '2', '27', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '3', '28', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '4', '29', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '1', '30', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '2', '31', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '3', '32', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '4', '33', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '1', '34', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '2', '35', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '3', '36', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '4', '37', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '1', '38', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '2', '39', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '3', '40', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '4', '41', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '1', '46', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '2', '43', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '3', '44', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '4', '45', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '1', '42', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '2', '78', '1', '0');
INSERT INTO `pet_races` VALUES ('15', '3', '48', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '4', '49', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '1', '77', '1', '0');
INSERT INTO `pet_races` VALUES ('15', '2', '47', '0', '1');
INSERT INTO `pet_races` VALUES ('15', '3', '79', '1', '0');
INSERT INTO `pet_races` VALUES ('15', '4', '80', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '0', '0', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '1', '1', '1', '1');
INSERT INTO `pet_races` VALUES ('14', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '7', '7', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '8', '8', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '9', '9', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '9', '9', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '10', '10', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '11', '11', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '12', '12', '1', '0');
INSERT INTO `pet_races` VALUES ('14', '13', '13', '1', '0');
INSERT INTO `pet_races` VALUES ('29', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('29', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('29', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('29', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('29', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('29', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('29', '7', '7', '1', '0');
INSERT INTO `pet_races` VALUES ('29', '8', '8', '1', '0');
INSERT INTO `pet_races` VALUES ('29', '9', '9', '1', '0');
INSERT INTO `pet_races` VALUES ('29', '10', '10', '1', '0');
INSERT INTO `pet_races` VALUES ('28', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('28', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('28', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('28', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('28', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('28', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('28', '7', '7', '1', '0');
INSERT INTO `pet_races` VALUES ('28', '8', '8', '1', '0');
INSERT INTO `pet_races` VALUES ('28', '9', '9', '1', '0');
INSERT INTO `pet_races` VALUES ('28', '10', '10', '1', '0');
INSERT INTO `pet_races` VALUES ('30', '1', '1', '1', '0');
INSERT INTO `pet_races` VALUES ('30', '2', '2', '1', '0');
INSERT INTO `pet_races` VALUES ('30', '3', '3', '1', '0');
INSERT INTO `pet_races` VALUES ('30', '4', '4', '1', '0');
INSERT INTO `pet_races` VALUES ('30', '5', '5', '1', '0');
INSERT INTO `pet_races` VALUES ('30', '6', '6', '1', '0');
INSERT INTO `pet_races` VALUES ('30', '7', '7', '1', '0');
INSERT INTO `pet_races` VALUES ('30', '8', '8', '1', '0');
INSERT INTO `pet_races` VALUES ('30', '9', '9', '1', '0');
INSERT INTO `pet_races` VALUES ('30', '10', '10', '1', '0');
SET FOREIGN_KEY_CHECKS=1;
- trylix