sim0n
Member
- Feb 16, 2013
- 227
- 15
So I tried entering these codes manually one by one into the database, it's for a few custom furnis. But when I enter them, I get something similar to this; it was some time ago so yeah its something like this: You have an error in your SQL syntax;(yes i changed furniture to items_base etc)
furniture;
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`, `is_arrow`) VALUES
(71000160, 'Glass Dice', 'glassdi', 's', 1, 1, 1, '1', '0', '0', 71000160, '1', '1', '1', '1', '1', 'dice', 1, '0', '0'),
(71005000, 'Green Dice', '3d1ceh5', 's', 1, 1, 1, '1', '0', '0', 71005000, '1', '1', '1', '1', '1', 'dice', 1, '0', '0'),
(71006000, 'Colourful Dice', '34807', 's', 1, 1, 1, '1', '0', '0', 71006000, '1', '1', '1', '1', '1', 'dice', 1, '0', '0');
(71000532, 'Ice Dice', 'icedice', 's', 1, 1, 1, '1', '0', '0', 71000532, '1', '1', '1', '1', '1', 'dice', 1, '0', '0'),
(71000608, 'Candy Cane Dice', 'candice', 's', 1, 1, 1, '1', '0', '0', 71000608, '1', '1', '1', '1', '1', 'dice', 1, '0', '0'),
(71006000, 420, '71006000', '3d1ceh4', 500, 0, 0, 1);
Items;
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES
(71000160, 420, '71000160', 'glassdi', 500, 0, 0, 1),
(71000532, 420, '71000532', 'icedice', 500, 0, 0, 1),
(71000608, 420, '71000608', 'candice', 500, 0, 0, 1),
(71006000, 420, '71006000', '3d1ceh4', 500, 0, 0, 1),
(71005000, 420, '71005000', '3d1ceh5', 500, 0, 0, 1);
Furnidata;
["s","71000532","icedice","71000532","","","","","Ice Dice","Ice Dice, Baby","","-1","-1","1"],["s","71000608","candice","71000608","","","","","Candy Cane Dice","Minty Fresh!","","-1","-1","1"],["s","71000160","glassdi","71000160","0","1","1","0,0,0","Glass Dice","Careful When Rolling!","","-1","-1"],["s","71005000","3d1ceh5","71005000","0","1","1","0,0,0","Green Dice","Colourful!","","-1","-1"],["s","71006000","3d1ceh4","34807","0","1","1","0,0,0","Colourful Dice","Colourful!","","-1","-1"],
furniture;
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`, `is_arrow`) VALUES
(71000160, 'Glass Dice', 'glassdi', 's', 1, 1, 1, '1', '0', '0', 71000160, '1', '1', '1', '1', '1', 'dice', 1, '0', '0'),
(71005000, 'Green Dice', '3d1ceh5', 's', 1, 1, 1, '1', '0', '0', 71005000, '1', '1', '1', '1', '1', 'dice', 1, '0', '0'),
(71006000, 'Colourful Dice', '34807', 's', 1, 1, 1, '1', '0', '0', 71006000, '1', '1', '1', '1', '1', 'dice', 1, '0', '0');
(71000532, 'Ice Dice', 'icedice', 's', 1, 1, 1, '1', '0', '0', 71000532, '1', '1', '1', '1', '1', 'dice', 1, '0', '0'),
(71000608, 'Candy Cane Dice', 'candice', 's', 1, 1, 1, '1', '0', '0', 71000608, '1', '1', '1', '1', '1', 'dice', 1, '0', '0'),
(71006000, 420, '71006000', '3d1ceh4', 500, 0, 0, 1);
Items;
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES
(71000160, 420, '71000160', 'glassdi', 500, 0, 0, 1),
(71000532, 420, '71000532', 'icedice', 500, 0, 0, 1),
(71000608, 420, '71000608', 'candice', 500, 0, 0, 1),
(71006000, 420, '71006000', '3d1ceh4', 500, 0, 0, 1),
(71005000, 420, '71005000', '3d1ceh5', 500, 0, 0, 1);
Furnidata;
["s","71000532","icedice","71000532","","","","","Ice Dice","Ice Dice, Baby","","-1","-1","1"],["s","71000608","candice","71000608","","","","","Candy Cane Dice","Minty Fresh!","","-1","-1","1"],["s","71000160","glassdi","71000160","0","1","1","0,0,0","Glass Dice","Careful When Rolling!","","-1","-1"],["s","71005000","3d1ceh5","71005000","0","1","1","0,0,0","Green Dice","Colourful!","","-1","-1"],["s","71006000","3d1ceh4","34807","0","1","1","0,0,0","Colourful Dice","Colourful!","","-1","-1"],