What's wrong with this code?

Status
Not open for further replies.

Clit

Posting Freak
Feb 25, 2012
1,065
103
Code:
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
(39300161, 'Monster Drink Machine', 'lm_mananadrink', 's', 1, 1, 1, '0', '0', '0', 500051, '1', '1', '1', '1', '1', 'vendingmachine', 2, '61', '0'),
(39300162, 'Monster Throne', 'mhrone', 's', 1, 1, 1, '0', '1', '0', 500052, '1', '1', '1', '1', '1', 'default', 1, '0', '0'),
(39300163, 'Monster Pillow', 'millow', 's', 1, 1, 1, '0', '1', '0', 500053, '1', '1', '1', '1', '1', 'default', 1, '0', '0'),
(39300164, 'Monster Dragon', 'rare_dragonmamp*4', 's', 1, 1, 1, '0', '0', '0', 500060, '1', '1', '1', '1', '1', 'default', 2, '0', '0'),
(39300165, 'Monster Parasol', 'ads_calip_monster', 's', 1, 1, 1, '0', '0', '0', 500061, '1', '1', '1', '1', '1', 'default', 2, '0', '0'),

Code:
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`, `vip`) VALUES
(39300161, 9998, '39300161', 'Monster Drink Machine', 100, 20, 0, 1, '0'),
(39300162, 9998, '39300162', 'Monster Throne', 100, 20, 0, 1, '0'),
(39300163, 9998, '39300163', 'Monster Pillow', 100, 20, 0, 1, '0'),
(39300164, 9998, '39300164', 'Monster Dragon', 100, 20, 0, 1, '0'),
(39300165, 9998, '39300165', 'Monster Parasol', 100, 20, 0, 1, '0'),

Error I got was:
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6

Am I retarded? What is wrong?
 

Kryptos

prjRev.com
Jul 21, 2010
2,205
1,252
This should work..

Code:
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
(39300161, 'Monster Drink Machine', 'lm_mananadrink', 's', 1, 1, 1, '0', '0', '0', 500051, '1', '1', '1', '1', '1', 'vendingmachine', 2, '61', '0'),
(39300162, 'Monster Throne', 'mhrone', 's', 1, 1, 1, '0', '1', '0', 500052, '1', '1', '1', '1', '1', 'default', 1, '0', '0'),
(39300163, 'Monster Pillow', 'millow', 's', 1, 1, 1, '0', '1', '0', 500053, '1', '1', '1', '1', '1', 'default', 1, '0', '0'),
(39300164, 'Monster Dragon', 'rare_dragonmamp*4', 's', 1, 1, 1, '0', '0', '0', 500060, '1', '1', '1', '1', '1', 'default', 2, '0', '0'),
(39300165, 'Monster Parasol', 'ads_calip_monster', 's', 1, 1, 1, '0', '0', '0', 500061, '1', '1', '1', '1', '1', 'default', 2, '0', '0');

Code:
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`, `vip`) VALUES
(39300161, 9998, '39300161', 'Monster Drink Machine', 100, 20, 0, 1, '0'),
(39300162, 9998, '39300162', 'Monster Throne', 100, 20, 0, 1, '0'),
(39300163, 9998, '39300163', 'Monster Pillow', 100, 20, 0, 1, '0'),
(39300164, 9998, '39300164', 'Monster Dragon', 100, 20, 0, 1, '0'),
(39300165, 9998, '39300165', 'Monster Parasol', 100, 20, 0, 1, '0');
 
Status
Not open for further replies.

Users who are viewing this thread

Top