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!

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