[Room ads] Nintendo 3ds room (Old but gold)..

[.::Arjan::.]

Hello RaGEZONE :)
I'm back with a new roomads, the Nintendo 3ds room.

First download the roomads:
http://drabbo.nl/swf/c_images/kamers/nintendo/1.png

Add the following room model to your db:

-- phpMyAdmin SQL Dump
-- version 3.5.2
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 04 aug 2012 om 10:11
-- Serverversie: 5.1.41
-- PHP-versie: 5.3.1

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_3ds', 11, 10, 0, 0, 'xxxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxxxx00000000000000x\r\nxxxxxxxxxxx00000000000000x\r\nxxxxxxxxxxx00000000000000x\r\nx0000xxxxxx00000000000000x\r\nx0000xxxxxx00000000000000x\r\nx0000xxxxxx00000000000000x\r\nx0000xxxxxx000000000000xxx\r\nx0000xxxxxx000000000000xxx\r\nx0000xxxxxx0000000000xxxxx\r\nxxxxxxxxxxx0000000000xxxxx\r\nxxxxxxxxxxx00000000xxxxxxx\r\nxxxxxxxxxxx00000000xxxxxxx\r\nxxxxxxxxxxx000000xxxxxxxxx\r\nxxxxxxxxxxx000000xxxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxxx', '', '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 */;

Search for your in the table: rooms. Change the room model to model_3ds

Go to your room and place a room ads with the following coords; (Look screen)..


(Like if you like)!

Succes!
Greetzzzzz,
Arjan

[MentaL]

[The General]

Roomads already released.

I had this already for quite a while.

[Ddos Attack]

Roomads already released.

I had this already for quite a while.

... well I didn't :P
Thanks for this!

[Nilenz]

Well Done Arjan this room is nice

[.::Arjan::.]

Thanks :)

[Twan]

I cant see the coördinates good...

[pLEDGE]

Thanks. Havent seen this before.

Cheers

[Twan]

Doesnt works good here:

[.::Arjan::.]

Doesnt works good here:

Nice Twan ;)

[Twan]

Nice Twan ;)

Whats wrong with it here?

[HabMoon]

Thanks for the roomadd, only one I didn't have yet lol.
Don't advertise your gay forum =3 nah joke.

[ParadiseRel]

Never had this, thanks for the room-ad. :)

[Tha Matrix]

Like Zuc Said - We didn't get this ;P Thanks anyway

[Naphier]

Never seen this before, nice release.

[J4y2]

Awesome! I Love The 3DS! Thanks

[Bui]

Thanks for the release :) I reckon that 3DS would look good as a furni (but smaller, of course).

[J4y2]

anyone has roomads sql?

[Livar]

above, guessing you'll have to search for them man, anyway awesome release arjan!

[.::Arjan::.]

above, guessing you'll have to search for them man, anyway awesome release arjan!

You're welcome :$

[andricozach]

I cant see the co-ordinates, the screenshot doesnt work.

[P3scal]

Can anyone reupload the coords pls ??

[FullmetalPride]

Good release, but I wish people would up and design the old public rooms. Chromide, Mammoth, etc..

I would do it, but public_ccts is too hard. Rest is easy.