• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Straypixels furniture! SQL - For uber... ONLY!

Status
Not open for further replies.
Joined
Feb 2, 2010
Messages
1,742
Reaction score
264
Hey again! I just made some sql's for the Straypixel furnitures.

Image:
Adde - Straypixels furniture! SQL - For uber... ONLY! - RaGEZONE Forums


Catalog_Page:
Code:
INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `coming_soon`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`) VALUES
(497, 3, 'Stray Pixels', 28, 1, '1', '1', 1, '0', '0', 7, 'default_3x3', 'Stray Pixel', '', '', 'Stray Pixel', '', '', '');

Catalog_Items:
Code:
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES
(10289, 497, '10289', 'easel_0', 25, 0, 1),
(10290, 497, '10290', 'easel_1', 25, 0, 1),
(10291, 496, '10291', 'easel_2', 25, 0, 1),
(10292, 497, '10292', 'easel_3', 25, 0, 1),
(10293, 497, '10293', 'easel_4', 25, 0, 1),
(10294, 497, '10294', 'easel_2', 25, 0, 1);

Furniture:
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`) VALUES
(10289, 'easel_0', 'easel_0', 's', 1, 1, 1, '0', '0', '0', 3582, '1', '1', '1', '1', '1', 'default', 2, '0'),
(10290, 'easel_1', 'easel_1', 's', 1, 1, 1, '0', '0', '0', 3594, '1', '1', '1', '1', '1', 'default', 3, '0'),
(10291, 'easel_2', 'easel_2', 's', 1, 1, 1, '0', '0', '0', 3603, '1', '1', '1', '1', '1', 'default', 3, '0'),
(10292, 'easel_3', 'easel_3', 's', 1, 1, 1, '1', '0', '0', 3596, '1', '1', '1', '1', '1', 'default', 6, '0'),
(10293, 'easel_4', 'easel_4', 's', 1, 1, 1, '0', '0', '0', 3600, '1', '1', '1', '1', '1', 'default', 5, '0'),
(10294, 'easel_2', 'easel_2', 's', 1, 1, 1, '0', '0', '0', 3603, '1', '1', '1', '1', '1', 'default', 6, '0');

Credits goes to me for making the SQL for them.. And for Sulake for making the furnitures.

Enjoy! And THANK me. ;)

Btw, No flaming or spamming in this thread please. Thanks!
 
Custom Title Activated
Loyal Member
Joined
Jan 25, 2009
Messages
1,539
Reaction score
4
1st post omfg!

great release man, these look awesome, if only rdc let me on ;0
 
凸(ಠ益ಠ)凸
Loyal Member
Joined
Jun 16, 2008
Messages
1,665
Reaction score
227
WORKS GREAT, small question...is it suppose to have 2 of the same kind or was it suppose to be something else? for easel_2
 
I'm back!
Joined
Nov 29, 2008
Messages
526
Reaction score
95
Thanks mate!

Will use these :D
10/10
 
Newbie Spellweaver
Joined
May 14, 2009
Messages
16
Reaction score
0
Can you make them for Non-beta pleas :thumbup:

Hey again! I just made some sql's for the Straypixel furnitures.

Image:
Adde - Straypixels furniture! SQL - For uber... ONLY! - RaGEZONE Forums


Catalog_Page:
Code:
INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `coming_soon`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`) VALUES
(497, 3, 'Stray Pixels', 28, 1, '1', '1', 1, '0', '0', 7, 'default_3x3', 'Stray Pixel', '', '', 'Stray Pixel', '', '', '');

Catalog_Items:
Code:
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES
(10289, 497, '10289', 'easel_0', 25, 0, 1),
(10290, 497, '10290', 'easel_1', 25, 0, 1),
(10291, 496, '10291', 'easel_2', 25, 0, 1),
(10292, 497, '10292', 'easel_3', 25, 0, 1),
(10293, 497, '10293', 'easel_4', 25, 0, 1),
(10294, 497, '10294', 'easel_2', 25, 0, 1);

Furniture:
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`) VALUES
(10289, 'easel_0', 'easel_0', 's', 1, 1, 1, '0', '0', '0', 3582, '1', '1', '1', '1', '1', 'default', 2, '0'),
(10290, 'easel_1', 'easel_1', 's', 1, 1, 1, '0', '0', '0', 3594, '1', '1', '1', '1', '1', 'default', 3, '0'),
(10291, 'easel_2', 'easel_2', 's', 1, 1, 1, '0', '0', '0', 3603, '1', '1', '1', '1', '1', 'default', 3, '0'),
(10292, 'easel_3', 'easel_3', 's', 1, 1, 1, '1', '0', '0', 3596, '1', '1', '1', '1', '1', 'default', 6, '0'),
(10293, 'easel_4', 'easel_4', 's', 1, 1, 1, '0', '0', '0', 3600, '1', '1', '1', '1', '1', 'default', 5, '0'),
(10294, 'easel_2', 'easel_2', 's', 1, 1, 1, '0', '0', '0', 3603, '1', '1', '1', '1', '1', 'default', 6, '0');

Credits goes to me for making the SQL for them.. And for Sulake for making the furnitures.

Enjoy! And THANK me. ;)

Btw, No flaming or spamming in this thread please. Thanks!
 
Status
Not open for further replies.
Back
Top