How do I remove furniture from the DB via SQL?

sim0n

Member
Feb 16, 2013
227
15
So I added some furnis that didnt work, and now I want to delete them again. I have already deleted the swf files, but I can't find where they are located in the DB.

Code:
INSERT INTO `catalog_items_copy` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`, `cost_crystal`, `cost_oude_belcredits`, `song_id`, `limited_stack`, `limited_sells`, `offer_active`, `extradata`, `badge`) VALUES
 
(55001, 13, '55001', 'Saffire Bar', 25000, 0, 1, 0, 0, 0, 0, 0, '0', '0', ''), (55002, 13, '55002', 'Diamond Bar', 100000, 0, 1, 0, 0, 0, 0, 0, '0', '0', '');

Code:
INSERT INTO  `items_base` (
 
`item_id` ,`sprite_id` ,`public_name` ,`item_name` ,`type` ,`width` ,`length` ,`height` ,`allow_stack` ,`allow_walk` ,`allow_sit` ,`allow_recycle` ,`allow_trade` ,`allow_marketplace_sell` ,`allow_gift` ,`allow_inventory_stack` ,`allow_group_item` ,`interaction_type` ,`cycle_count` ,`vending_ids`)VALUES ('55001',  '55001',  'Saffire Bar',  'CFC_25000_saffb',  's',  '1',  '1',  '0.4',  '1',  '0', '0',  '1',  '1',  '1',  '1',  '1',  '0',  'default',  '1',  '0'),('55002',  '55002',  'Diamond Bar',  'CFC_100000_diam',  's',  '1',  '1',  '0.4',  '1',  '0', '0',  '1',  '1',  '1',  '1',  '1',  '0',  'default',  '1',  '0' );
 

sim0n

Member
Feb 16, 2013
227
15
DELETE FROM `catalog_items_copy` WHERE id = '55001';
DELETE FROM `items_base` WHERE public_name = 'Diamond Bar';
Thank you very much good sir, although that was just for the diamond bar. I used my 2 braincells to change 55002 and Diamond Bar to Saffire bar and woops it worked. Many thanks!
 

Users who are viewing this thread

Top