Skateboard Furni [SQL]

[Jeanzinh0]

Hello Regezone, new furnis ^^

Catalog_pages:

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:

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:

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:

["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:

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


EDIT: Skate Effect
Catalog_items:

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:

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:

Download:

You must be registered to see links

Credits:
Jeanzinh0, joopie and Sulake

 

[</Meap>]

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

 

[ScottBekmezci]

Already in my hotel. ^^

thx!

 

[NeonCrayonz]

Yay, your back!

Nice release as usual!

 

[</Meap>]

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

 

[Jeanzinh0]

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

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

 

[</Meap>]

Ok cool
thanks mate

 

[pLEDGE]

effect is already released

 

[xJaimx]

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');

 

[HabbliteHotel]

Hmm, I added the furni but its not loading.

 

[Joopie]

Hmm, I added the furni but its not loading.

*sig*

<?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..

 

[Joopie]

Btw:

avatar_effect72 = Default skate
avatar_effect71 = HC skate

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

 

[Habbi]

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

Whats my problem? :S

 

[Miggs]

Add coming_soon to your field list.

 

[Habbi]

which command?

CREATE FIELD 'coming_soon' ?

 

[Joopie]

;/, They invanted phpmyadmin for that.

 

[c0mma]

Thanks a lot for this!

 

[JayNZ]

thanks. works well

 

[iRosko]

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

 

[The-Trey]

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

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 -

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');