Skateboard Furni [SQL]

Hello Regezone, new furnis ^^

Catalog_pages:

Code:

---

INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `vip_only`, `coming_soon`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`) VALUES
(556, 3, 'Skate', 1, 1, '1', '1', 1, '0', '0', '0', 1, 'default_3x3', '', '', '', '', '', '', '');

---

Catalog_items:

Code:

---

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES
(55901, '556', '55901', 'prizetrophy_skate*1', '3', '0', '1'),
(55902, '556', '55902', 'prizetrophy_skate*2', '3', '0', '1'),
(55903, '556', '55903', 'prizetrophy_skate*3', '3', '0', '1'),
(55904, '556', '55904', 'sb_rail', '3', '0', '1'),
(55905, '556', '55905', 'sb_ramp', '3', '0', '1'),
(55906, '556', '55906', 'sb_block', '3', '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`, `foot_figure`) VALUES
(55901, 'prizetrophy_skate*1', 'prizetrophy_skate*1', 's', 1, 1, 1, '0', '0', '0', 4027, '1', '1', '1', '1', '1', 'trophy', 1, '0', ''),
(55902, 'prizetrophy_skate*2', 'prizetrophy_skate*2', 's', 1, 1, 1, '0', '0', '0', 4028, '1', '1', '1', '1', '1', 'trophy', 1, '0', ''),
(55903, 'prizetrophy_skate*3', 'prizetrophy_skate*3', 's', 1, 1, 1, '0', '0', '0', 4029, '1', '1', '1', '1', '1', 'trophy', 1, '0', ''),
(55904, 'sb_rail', 'sb_rail', 's', 1, 1, 1, '0', '0', '0', 4030, '1', '1', '1', '1', '1', 'default', 1, '0', ''),
(55905, 'sb_ramp', 'sb_ramp', 's', 2, 2, 1, '0', '0', '0', 4031, '1', '1', '1', '1', '1', 'default', 1, '0', ''),
(55906, 'sb_block', 'sb_block', 's', 2, 2, 0.7, '1', '0', '1', 4032, '1', '1', '1', '1', '1', 'default', 1, '0', '');

---

Furnidata:

Code:

---

["s","4027","prizetrophy_skate*1","34499","0","1","1","#ffffff,#ffffff,#FFDD3F","prizetrophy_skate_gold name","prizetrophy_skate_gold desc","","-1","-1"],
["s","4028","prizetrophy_skate*2","34499","0","1","1","#ffffff,#ffffff,#ffffff","prizetrophy_skate_silver name","prizetrophy_skate_silver desc","","-1","-1"],
["s","4029","prizetrophy_skate*3","34499","0","1","1","#ffffff,#ffffff,#996600","prizetrophy_skate_bronze name","prizetrophy_skate_bronze desc","","-1","-1"],
["s","4030","sb_rail","34499","0","1","1","","Skate Rail","Grind and jump!","","139137","10199"],
["s","4031","sb_ramp","34499","0","2","1","","Skate Ramp","A skatepark necessity","","139137","10201"],
["s","4032","sb_block","34499","0","2","2","","Skate Platform","How high can you ollie??","","139137","10202"]

---

Screen: http://img269.imageshack.us/img269/9190/imagemlh.png
http://img269.imageshack.us/img269/9190/imagemlh.png

Download: http://forum.ragezone.com/f353/skatefurni-sql-758319/


EDIT: Skate Effect
Catalog_items:

Code:

---

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `amount`) VALUES
('55907', '556', '55907', 'avatar_effect72', '1', '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`, `foot_figure`) VALUES
(55907, 'avatar_effect72', 'avatar_effect72', 'e', 1, 1, 1, '0', '0', '0', 72, '1', '1', '1', '1', '1', 'default', 1, '0', '');

---

Screen: http://img818.imageshack.us/img818/8292/imagemsnt.png
http://img818.imageshack.us/img818/8292/imagemsnt.png

Download: Skate Effect.rar

Credits:
Jeanzinh0, joopie and Sulake

Zomg your back
we have missed you
=d
thanks for the release

Already in my hotel. ^^

thx!

Yay, your back!

Nice release as usual!

what about the effect, add that if possible? >;]

Quote:

---

Originally Posted by Danny95

what about the effect, add that if possible? >;]

---

I'm working on it right now, soon will edit the topic

Ok cool
thanks mate :)

effect is already released

Effect":

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 ('55907', 'avatar_effect72', 'avatar_effect72', 'e', '1', '1', '1', '0', '0', '0', '72', '1', '1', '1', '1', '1', 'default', '1', '0', '0');

Hmm, I added the furni but its not loading.

Quote:

---

Originally Posted by HabbliteHotel

Hmm, I added the furni but its not loading.

---

*sig*

Code:

---

<?php
    define("URL","http://192.168.10.111/r63");

        $type = $_GET['type'];
        $build = 0;
       
        $lang = 'us';
       
        switch ($type)
        {
                case 'override/external_override_variables':
                        echo "image.library.url=".URL."/r63/c_images/\n";
                        echo "private.image.library.url=".URL."/r63/c_images/\n";
                        echo "image.library.catalogue.url=".URL."/r63/c_images/catalogue/\n";
                        echo "flash.dynamic.download.url=".URL."/r63/dcr/hof_furni/\n";
                        echo "dynamic.download.url=".URL."/r63/dcr/hof_furni/\n";
                        echo "client.hotel_view.image=hotel_view_images_hq/beta_hotelview.png\n";
                        echo "external.figurepartlist.txt=".URL."/external.php?type=figuredata\n";         
            echo "flash.dynamic.download.name.template=%typeid%.swf\n";
            echo "furnidata.load.url=".URL."/external.php?type=furnidata\n";
                        break;
       
        case 'override/external_override_flash_texts':     
            break;
               
                case 'figuredata':
                        echo file_get_contents('http://hotel-'.$lang.'.habbo.com/gamedata/'.$type);
                        break;
               
                default:
                        echo file_get_contents('http://hotel-'.$lang.'.habbo.com/gamedata/'.$type.'/'.$build);
                        break;
        }
?>

---

Use this, And you have always the last externals from habbo..

Btw:

avatar_effect72 = Default skate
avatar_effect71 = HC skate

Code:

---

fx_72_desc=skateboard2_desc
fx_72=Skate Effect
fx_71=HC Skate Effect

---

All is workin ( i have Phoenix Emulator )but catalog_pages says ' Unknown column 'coming_soon' in 'field list'

Whats my problem? :S

Add coming_soon to your field list.

which command?

CREATE FIELD 'coming_soon' ?

;/, They invanted phpmyadmin for that.

Thanks a lot for this!

thanks. works well

all works well just the effect isnt showing D: any help with that?

Here. This is for people who dont know how to Create The Field "Comming Soon" :

PHP Code:

---

INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `vip_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`) VALUES
(556, 3, 'Skate', 1, 1, '1', '1', 1, '0', '0', 1, 'default_3x3', '', '', '', '', '', '', ''); 


---

Furniture -

PHP 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
(55901, 'prizetrophy_skate*1', 'prizetrophy_skate*1', 's', 1, 1, 1, '0', '0', '0', 4027, '1', '1', '1', '1', '1', 'trophy', 1, '0'),
(55902, 'prizetrophy_skate*2', 'prizetrophy_skate*2', 's', 1, 1, 1, '0', '0', '0', 4028, '1', '1', '1', '1', '1', 'trophy', 1, '0'),
(55903, 'prizetrophy_skate*3', 'prizetrophy_skate*3', 's', 1, 1, 1, '0', '0', '0', 4029, '1', '1', '1', '1', '1', 'trophy', 1, '0'),
(55904, 'sb_rail', 'sb_rail', 's', 1, 1, 1, '0', '0', '0', 4030, '1', '1', '1', '1', '1', 'default', 1, '0'),
(55905, 'sb_ramp', 'sb_ramp', 's', 2, 2, 1, '0', '0', '0', 4031, '1', '1', '1', '1', '1', 'default', 1, '0'),
(55906, 'sb_block', 'sb_block', 's', 2, 2, 0.7, '1', '0', '1', 4032, '1', '1', '1', '1', '1', 'default', 1, '0'); 


---

Quote:

---

Originally Posted by The-Trey

Here. This is for people who dont know how to Create The Field "Comming Soon" :

PHP Code:

---

INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `vip_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`) VALUES
(556, 3, 'Skate', 1, 1, '1', '1', 1, '0', '0', 1, 'default_3x3', '', '', '', '', '', '', ''); 


---

Furniture -

PHP 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
(55901, 'prizetrophy_skate*1', 'prizetrophy_skate*1', 's', 1, 1, 1, '0', '0', '0', 4027, '1', '1', '1', '1', '1', 'trophy', 1, '0'),
(55902, 'prizetrophy_skate*2', 'prizetrophy_skate*2', 's', 1, 1, 1, '0', '0', '0', 4028, '1', '1', '1', '1', '1', 'trophy', 1, '0'),
(55903, 'prizetrophy_skate*3', 'prizetrophy_skate*3', 's', 1, 1, 1, '0', '0', '0', 4029, '1', '1', '1', '1', '1', 'trophy', 1, '0'),
(55904, 'sb_rail', 'sb_rail', 's', 1, 1, 1, '0', '0', '0', 4030, '1', '1', '1', '1', '1', 'default', 1, '0'),
(55905, 'sb_ramp', 'sb_ramp', 's', 2, 2, 1, '0', '0', '0', 4031, '1', '1', '1', '1', '1', 'default', 1, '0'),
(55906, 'sb_block', 'sb_block', 's', 2, 2, 0.7, '1', '0', '1', 4032, '1', '1', '1', '1', '1', 'default', 1, '0'); 


---

---

Beat me too it. But doesnt phoenix have a comming soon section in the catalog db? Couldnt we edit the existing code to use that?

Not working!

The tables does not work: D

Quote:

---

Originally Posted by Nilenz

Not working!

The tables does not work: D

---

Maby learn something about SQl, Then you know how to fix,
SQl isn't so hard:mellow:

nice i like it

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_snow`, `cost_pixels`, `amount`) VALUES
(55908, '556', '55908', 'sb_tag1', '3', '0', '0', '1'),
(55909, '556', '55909', 'sb_tag2', '3', '0', '0', '1'),
(55910, '556', '55910', 'sb_tag3', '3', '0', '0', '1'),
(55911, '556', '55911', 'sb_wall', '3', '0', '0', '1'),
(55912, '556', '55912', 'sb_cans', '3', '0', '0', '1'),
(55913, '556', '55913', 'sb_tile', '3', '0', '0', '1');

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
(55908, 'sb_tag1', 'sb_tag1', 'i', 0, 0, 1, '0', '0', '0', 4399, '1', '1', '1', '1', '1', 'default', 1, '0', ''),
(55909, 'sb_tag2', 'sb_tag2', 'i', 0, 0, 1, '0', '0', '0', 4400, '1', '1', '1', '1', '1', 'default', 1, '0', ''),
(55910, 'sb_tag3', 'sb_tag3', 'i', 0, 0, 1, '0', '0', '0', 4398, '1', '1', '1', '1', '1', 'default', 1, '0', ''),
(55911, 'sb_wall', 'sb_wall', 'i', 0, 0, 1, '0', '0', '0', 4401, '1', '1', '1', '1', '1', 'default', 1, '0', ''),
(55912, 'sb_cans', 'sb_cans', 's', 1, 1, 1, '0', '0', '0', 3743, '1', '1', '1', '1', '1', 'default', 1, '0', ''),
(55913, 'sb_tile', 'sb_tile', 's', 2, 2, 0.2, '1', '0', '1', 3744, '1', '1', '1', '1', '1', 'default', 1, '0', '');

for the rest... (Maybe you need to edit some values like page_id and sprite_id ;))