Rooftop cafe (ROOM_ADS)

Attachment 104949Hello Ragezone!
I have a nice realease the old rooftop cafe,
first the room SQL:

Spoiler:

Code:

---

-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 07 Apr 2012 om 17:07
-- Serverversie: 5.1.33
-- PHP-Versie: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `drabbo`
--

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `room_models`
--

CREATE TABLE IF NOT EXISTS `room_models` (
  `id` varchar(100) NOT NULL,
  `door_x` int(11) NOT NULL,
  `door_y` int(11) NOT NULL,
  `door_z` double NOT NULL,
  `door_dir` int(4) NOT NULL DEFAULT '2',
  `heightmap` text NOT NULL,
  `public_items` text NOT NULL,
  `club_only` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `room_models`
--

INSERT INTO `room_models` (`id`, `door_x`, `door_y`, `door_z`, `door_dir`, `heightmap`, `public_items`, `club_only`) VALUES
('model_cafe', 5, 12, 0, 0, 'xxxxxxxxxxx\r\nxx00000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nxxxx000xxxx\r\nxxxx000xxxx\r\nxxxxxxxxxxx', '', '0');

---

step 2
Make a roomads with the following coords;
http://i.imgur.com/lFGcC.png

And you done!
100& to me! :thumbup:

Download here room ads + sql: (Thanks to S3t0x)

Spoiler:

Quote:

---

Originally Posted by S3t0x

PHP Code:

---

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('8263', '26', '8263', 'ads_background', '3', '0', '0', '1'); 


---

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`, `is_arrow`) VALUES ('8263', 'ads_background', 'ads_background', 's', '1', '1', '1.6', '1', '0', '0', '8263', '1', '1', '1', '1', '1', 'default', '1', '0', '0'); 


---

Furnidata:

PHP Code:

---

["s","8263","ads_background","8263","4","1","1","","Background","-","","-1","-1","","1"]] 


---

Download:
ads_background.swf

---

Like my topic? Click on the button like :)

Sorry for my bad english I'm from the Netherlands

Edit: The picture of the room ads must be hosted on your server where you host your SWFs otherwise it does not work..

Other thread from me: http://forum.ragezone.com/f353/new-i...om-ads-840500/

Great release! I like it.

Already had it for a while. But its ok..

Thanks for sharing :)

Quote:

---

Originally Posted by HabMoon

Already had it for a while. But its ok..

Thanks for sharing :)

---

I know first I wanted to keep it for myself but I did not anyway.

Thanks! Please give me ads_background sql and furnidata thanks :-)
All gives me errors!
First can't execute
second gaves me errors catalogue cache in emulator (needs to delete it from database)
third can't load.
Please an working one :D

Quote:

---

Originally Posted by SuckLake

Thanks! Please give me ads_background sql and furnidata thanks :-)
All gives me errors!
First can't execute
second gaves me errors catalogue cache in emulator (needs to delete it from database)
third can't load.
Please an working one :D

---

PHP Code:

---

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('8263', '26', '8263', 'ads_background', '3', '0', '0', '1'); 


---

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`, `is_arrow`) VALUES ('8263', 'ads_background', 'ads_background', 's', '1', '1', '1.6', '1', '0', '0', '8263', '1', '1', '1', '1', '1', 'default', '1', '0', '0'); 


---

Furnidata:

PHP Code:

---

["s","8263","ads_background","8263","4","1","1","","Background","-","","-1","-1","","1"]] 


---

Download:
ads_background.swf

EDIT: and the Rooftop Cafe with no "Drabbo, Hallo etc..."

http://habboliday.hs.llnwd.fr/c_imag...aktuincafe.png

Quote:

---

Originally Posted by S3t0x

PHP Code:

---

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('8263', '26', '8263', 'ads_background', '3', '0', '0', '1'); 


---

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`, `is_arrow`) VALUES ('8263', 'ads_background', 'ads_background', 's', '1', '1', '1.6', '1', '0', '0', '8263', '1', '1', '1', '1', '1', 'default', '1', '0', '0'); 


---

Furnidata:

PHP Code:

---

["s","8263","ads_background","8263","4","1","1","","Background","-","","-1","-1","","1"]] 


---

Download:
ads_background.swf

EDIT: and the Rooftop Cafe with no "Drabbo, Hallo etc..."

http://habboliday.hs.llnwd.fr/c_imag...aktuincafe.png

---

Drabbo.nl are the credits :P in the image..

nice!!

Quote:

---

Originally Posted by blink182sp44

nice!!

---

Thnx, add you it to your hotel?

can someone please update the Download link for the swf .

Quote:

---

Originally Posted by ARMYDUDE

can someone please update the Download link for the swf .

---

Search on google or Ragezone ;)

thanks for this, fits perfectly.

Its nice:)

Thnx :)

anyone know what the threatedrome room is though?

Quote:

---

Originally Posted by JohnHearfield

anyone know what the threatedrome room is though?

---

I am currently working with him that if I did I put him on the forum :)
(With video)!

I dont have the save button option what do i do?

I have no idea... Use better swfs?

I now have save option but dont do anything

Save it, pick up the room_ads and place it again in your room :)

Hello,

Can anyone give me an DEV_test of this room without credits?

Best Regards

Delete it with paint.net ;)

This is a sexy as release. I mean, sexy! I don't know why, but I just think the custom rooms are really sexy! 10/10, I will add this to my hotel when it's opened :)! :thumbup1:

Nice :)
I make soon more room ads topics :)
Give me ideas :)

Look this:
http://www.uploadplaatjes.nl/img1/20120430/554289.png

Thats not ok?

NEDERLANDS:
Volgens mij heb ik de coordordinaten (ofzo) niet goed, maar ik heb het zelfde als jou?