Need help adding horses

Status
Not open for further replies.

K4TRIN4

Posting Freak
Jul 24, 2012
777
39
Hi can someone help me add horses to my hotel its currently r63 and i use phoenix and navicat i have the horse swf but i need the sql to add to the database after we added them could you help me make them rideable.
Thanks so much
 

Drugs

Member
Jun 2, 2013
34
5
That isnt need and besides im not sure as its not a proper phoenix i just need the sql
Think that's to add into catalogue :p

INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`) VALUES(30001, 'Horse', 'a0 pet13', 's', 1, 1, 1, '0', '0', '0', 14, '0', '0', '0', '0', '1', 'pet', 1, '0');



INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES(30001, '1433', '30001', 'a0 pet14', 0, 2000, 1);



INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `vip_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`) VALUES(1433, 14, 'Horse', 0, 134, '1', '1', 1, '0', '0', 302, 'pets', 'catalog_pets', '', '', '', '', 'Name:Breed:', '');
 

K4TRIN4

Posting Freak
Jul 24, 2012
777
39
Think that's to add into catalogue :p

INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`) VALUES(30001, 'Horse', 'a0 pet13', 's', 1, 1, 1, '0', '0', '0', 14, '0', '0', '0', '0', '1', 'pet', 1, '0');



INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES(30001, '1433', '30001', 'a0 pet14', 0, 2000, 1);



INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `vip_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`) VALUES(1433, 14, 'Horse', 0, 134, '1', '1', 1, '0', '0', 302, 'pets', 'catalog_pets', '', '', '', '', 'Name:Breed:', '');
Thanks just did it now the catalogue pages sql and the catalogue item sql worked but not the very first one the furniture sql it gives me a error when i try to run that please can u send me again the working one Thanks
 
Status
Not open for further replies.

Users who are viewing this thread

Top