The new Infobus [Room ads]

[.::Arjan::.]

First the add the room model:

Spoiler

-- phpMyAdmin SQL Dump
-- version 3.5.0
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 25 apr 2012 om 17:00
-- Serverversie: 5.0.67-community
-- PHP-Versie: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Databank: `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_busje', 16, 28, 0, 0, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\r\nx00000000000000000000xxxxxxxxxxxxx\r\nx00000000000000000000xxxxxxxxxxxxx\r\nx000000000000000000000000000000xxx\r\nx000000000000000000000000000000xxx\r\nx00000000000000000000xxxxxxxx00xxx\r\nx00000000000000000000xxxxxxxx00xxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0xxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0xxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0xx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0xx\r\nx00000000000000000000000000000000x\r\nx00000000000000000000000000000000x\r\nx00000000000000000000000000000000x\r\nx00000000000000000000000000000000x\r\nxx0000000000000000000000000000000x\r\nxxx000000000000000000000000000000x\r\nxxxx00000000000000000000000000000x\r\nxxxxx0000000000000000000000000000x\r\nxxxxxx000000000000000000000000000x\r\nxxxxxxx00000000000000000000000000x\r\nxxxxxxxx0000000000000000000000000x\r\nxxxxxxxxx000000000000000000000000x\r\nxxxxxxxxxx0000000000000000000000xx\r\nxxxxxxxxxxx00000000000000000000xxx\r\nxxxxxxxxxxxx000000000000000000xxxx\r\nxxxxxxxxxxxxx0000000000000000xxxxx\r\nxxxxxxxxxxxxxx00000000000000xxxxxx\r\nxxxxxxxxxxxxxxx00xxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', '', '0');

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

Reboot your hotel.

download the following: and add it to your swf host (c_images)*

To view the content, you need to sign in or register

Other download (Thanks to: JSansassio).

To view the content, you need to sign in or register

Okay, now we go to the room,
instead here a roomads with the following codes:

Spoiler

Step 2:
Place a new room ads here: (Look screen).

Spoiler

Step 3:
Place the last room ads here: (Look screen again).

Spoiler

Done!
The end result:

To view the content, you need to sign in or register

No room ads on your retro?

Spoiler

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES ('8263', '26', '8263', 'Ads_Background Only for staff! - Retroplace.nl', '3', '0', '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`, `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:

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

Download:

To view the content, you need to sign in or register

Other thread from me: http://forum.ragezone.com/f353/rooftop-cafe-room_ads-835157/

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

Like you my topic(s) Click on like

Edit if your coords not working: (Thanks to Jerromyster).

View attachment 104859
View attachment 104860
View attachment 104861

 

[blink182sp44]

Good job! Its nice!

 

[Landana]

nice. Thanks for that.

 

[.::Arjan::.]

Thanks

 

[GertJanA]

Nice release.
I will add it soon Dutchie (Y).

Greetz,

 

[keven007]

Nice! An ads background expert haha

 

[steffchef]

Nice relase, thank you.

 

[PRIZM]

Cool release, but i when i execute the SQL it can't load the Room model's cache in Emulator (Phoenix 3.7.2)

 

[Bradshly]

cant get them to fit

 

[.::Arjan::.]

if you get an error when you start the emulator at room cache, you have a enter by the room model.

 

[Bradshly]

I mean i dont know where to put the ad_background furni i try copy yours

 

[The General]

To view the content, you need to sign in or register

To view the content, you need to sign in or register

To view the content, you need to sign in or register

And then fill in the image url and X/Y/Z offsets. You have to host them on your own host.

 

[Bradshly]

i kinda got there

 

[Liam]

No joke, this is a super sexy release <3 THANKS! 9/10

 

[.::Arjan::.]

Thanks

 

[.::Arjan::.]

Thanks for the extra download link

 

[CasperP]

Help! I delete the cache and restart the emu. And it just will not show. and you can not use the

 

[Bradshly]

i had this it was an sql problem.

Mine dont look like yours why?

the top roof bus dont work for me it doesnt fit PM me if u can help

 

[XMichaelX]

how do you do that rom ads as

To view the content, you need to sign in or register

 

[.::Arjan::.]

Place the roomads that same room and fill in what I have on that screen