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)*
infobus.zip

Other download (Thanks to: JSansassio).
http://italfiles.com/f/wz05BSJvJe

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:
http://www.uploadplaatjes.nl/img1/20120425/545445.png


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:
ads_background.swf

Other thread from me: http://forum.ragezone.com/f353/rooft...om_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 :D

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

Attachment 104859
Attachment 104860
Attachment 104861

[MentaL]

[blink182sp44]

Good job! Its nice!

[Landana]

nice. Thanks for that.

[.::Arjan::.]

Thanks :D

[GertJanA]

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

Greetz,

[keven007]

Nice! An ads background expert haha

Sent from my GT-S5660 using Tapatalk

[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]

http://www.uploadplaatjes.nl/img1/20120425/545425.png
http://www.uploadplaatjes.nl/img1/20120425/545432.png
http://www.uploadplaatjes.nl/img1/20120425/545438.png

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 http://www.uploadplaatjes.nl/img1/20120425/545425.png

[.::Arjan::.]

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

[XMichaelX]

it worked but when I have everything completed how do I save something that

nederlands; het is gelukt maar als ik alles ingevuld heb hoe moet ik het dat opslaan ofzo

[.::Arjan::.]

Dutch: Klik op instant.buttum.save pak de room ads op en plaats hem opnieuw.
Eng: Click on instant.buttum.save pick the room ads up and place it again

[XMichaelX]

Ok Tnxx :$

[windows7025]

I agree, very good release. I will test it on my hotel later on...
Posted via Mobile Device

[.::Arjan::.]

Everybody says he/she likes it.
But i dont see likes on my post (A).