Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

New Pixel Furnis [PHOENIX] [BCSTORM]

Status
Not open for further replies.
Junior Spellweaver
Joined
Feb 13, 2011
Messages
151
Reaction score
52
I fixed the phoenix SQL for you

Code:
INSERT INTO `furniture` VALUES(500100, '', 'pixel_table_red', 's', 2, 2, 1.3, '1', '0', '0', 4893, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500101, '', 'pixel_chair_blue', 's', 1, 1, 1.5, '0', '1', '0', 4894, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500102, '', 'pixel_floor_pink', 's', 2, 2, 0.01, '1', '0', '1', 4895, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500103, '', 'pixel_floor_brown', 's', 2, 2, 0.01, '1', '0', '1', 4896, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500104, '', 'pixel_floor_yellow', 's', 2, 2, 0.01, '1', '0', '1', 4897, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500105, '', 'pixel_bed_red', 's', 2, 3, 1.7, '0', '0', '0', 4898, '1', '1', '0', '1', '1', 'bed', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500106, '', 'pixel_chair_green', 's', 1, 1, 1.5, '0', '1', '0', 4899, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500107, '', 'pixel_table_black', 's', 2, 2, 1.3, '1', '0', '0', 4900, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500108, '', 'pixel_bed_black', 's', 2, 3, 1.7, '0', '0', '0', 4901, '1', '1', '0', '1', '1', 'bed', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500109, '', 'pixel_table_blue', 's', 2, 2, 1.3, '1', '0', '0', 4902, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500110, '', 'pixel_floor_green', 's', 2, 2, 0.01, '1', '0', '1', 4903, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500111, '', 'pixel_floor_silver', 's', 2, 2, 0.01, '1', '0', '1', 4904, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500112, '', 'pixel_table_pink', 's', 2, 2, 1.3, '1', '0', '0', 4905, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500113, '', 'pixel_chair_pink', 's', 1, 1, 1.5, '0', '1', '0', 4906, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500114, '', 'pixel_table_green', 's', 2, 2, 1.3, '1', '0', '0', 4907, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500115, '', 'pixel_bed_pink', 's', 2, 3, 1.7, '0', '0', '0', 4908, '1', '1', '0', '1', '1', 'bed', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500116, '', 'pixel_bed_green', 's', 2, 3, 1.7, '0', '0', '0', 4909, '1', '1', '0', '1', '1', 'bed', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500117, '', 'pixel_chair_red', 's', 1, 1, 1.5, '0', '1', '0', 4910, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500118, '', 'pixel_chair_black', 's', 1, 1, 1.5, '0', '1', '0', 4911, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500119, '', 'pixel_floor_blue', 's', 2, 2, 0.01, '1', '0', '1', 4912, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500120, '', 'valentines_lovelock8', 's', 2, 2, 1, '1', '0', '0', 4913, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500121, '', 'valentines_lovelock7', 's', 2, 2, 1, '1', '0', '0', 4914, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500122, '', 'valentines_lovelock3', 's', 2, 2, 1, '1', '0', '0', 4915, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500123, '', 'valentines_lovelock4', 's', 2, 2, 1, '1', '0', '0', 4916, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500124, '', 'valentines_lovelock6', 's', 2, 2, 1, '1', '0', '0', 4917, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500125, '', 'valentines_lovelock5', 's', 2, 2, 1, '1', '0', '0', 4918, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500126, '', 'valentines_lovelock2', 's', 2, 2, 1, '1', '0', '0', 4919, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500127, '', 'pixel_bed_blue', 's', 2, 3, 1.7, '0', '0', '0', 4886, '1', '1', '0', '1', '1', 'bed', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500128, '', 'pixel_smalltable_blue', 's', 1, 1, 1.3, '1', '0', '0', 4887, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500129, '', 'pixel_smalltable_red', 's', 1, 1, 1.3, '1', '0', '0', 4888, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500130, '', 'pixel_smalltable_pink', 's', 1, 1, 1.3, '1', '0', '0', 4889, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500131, '', 'pixel_smalltable_black', 's', 1, 1, 1.3, '1', '0', '0', 4890, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500132, '', 'pixel_smalltable_green', 's', 1, 1, 1.3, '1', '0', '0', 4891, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500133, '', 'valentines_lovelock9', 's', 2, 2, 1, '1', '0', '0', 4892, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500134, '', 'pixel_clock_red', 'i', 1, 1, 1, '0', '0', '0', 4481, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500135, '', 'pixel_walldeco', 'i', 1, 1, 1, '0', '0', '0', 4482, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500136, '', 'pixel_clock_pink', 'i', 1, 1, 1, '0', '0', '0', 4483, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500137, '', 'pixel_mirror', 'i', 1, 1, 1, '0', '0', '0', 4484, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500138, '', 'pixel_clock_black', 'i', 1, 1, 1, '0', '0', '0', 4485, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500139, '', 'pixel_clock_green', 'i', 1, 1, 1, '0', '0', '0', 4486, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES(500140, '', 'pixel_clock_blue', 'i', 1, 1, 1, '0', '0', '0', 4487, '1', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', '0');
 
Newbie Spellweaver
Joined
Jul 3, 2011
Messages
62
Reaction score
16
When u get Column count doesn't match value count at row 1"

Try this
INSERT INTO catalog_items VALUES ('500101', '500', '500101', 'pixel_chair_blue', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500102', '500', '500102', 'pixel_floor_pink', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500103', '500', '500103', 'pixel_floor_brown', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500104', '500', '500104', 'pixel_floor_yellow', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500105', '500', '500105', 'pixel_bed_red', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500106', '500', '500106', 'pixel_chair_green', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500107', '500', '500107', 'pixel_table_black', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500108', '500', '500108', 'pixel_bed_black', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500109', '500', '500109', 'pixel_table_blue', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500110', '500', '500110', 'pixel_floor_green', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500111', '500', '500111', 'pixel_floor_silver', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500112', '500', '500112', 'pixel_table_pink', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500113', '500', '500113', 'pixel_chair_pink', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500114', '500', '500114', 'pixel_table_green', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500115', '500', '500115', 'pixel_bed_pink', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500116', '500', '500116', 'pixel_bed_green', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500117', '500', '500117', 'pixel_chair_red', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500118', '500', '500118', 'pixel_chair_black', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500119', '500', '500119', 'pixel_floor_blue', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500120', '500', '500120', 'valentines_lovelock8', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500121', '500', '500121', 'valentines_lovelock7', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500122', '500', '500122', 'valentines_lovelock3', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500123', '500', '500123', 'valentines_lovelock4', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500124', '500', '500124', 'valentines_lovelock6', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500125', '500', '500125', 'valentines_lovelock5', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500126', '500', '500126', 'valentines_lovelock2', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500127', '500', '500127', 'pixel_bed_blue', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500128', '500', '500128', 'pixel_smalltable_blue', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500129', '500', '500129', 'pixel_smalltable_red', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500130', '500', '500130', 'pixel_smalltable_pink', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500131', '500', '500131', 'pixel_smalltable_black', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500132', '500', '500132', 'pixel_smalltable_green', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500133', '500', '500133', 'valentines_lovelock9', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500134', '500', '500134', 'pixel_clock_red', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500135', '500', '500135', 'pixel_walldeco', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500136', '500', '500136', 'pixel_clock_pink', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500137', '500', '500137', 'pixel_mirror', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500138', '500', '500138', 'pixel_clock_black', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500139', '500', '500139', 'pixel_clock_green', '3', '0', '0', '1', '0', '0', '0');
INSERT INTO catalog_items VALUES ('500140', '500', '500140', 'pixel_clock_blue', '3', '0', '0', '1', '0', '0', '0');
 
Status
Not open for further replies.
Back
Top