The welcome lounge room model and fixed furni.

[.::Arjan::.]

Hello RZ, i have found the Welcoms lounge model with clickable furni on my retro; Drabbo.nl

First make this room: (Thanks Ryan aka Niels for that tip)


Download this furni;
Fixed_Furni.rar (Thanks duckietm)!

And you have clickable furni with the welcome lounge model.
(and place blackhole 1x1 in the remaining tiles).

And the look from Frank;
hr-831-45.fa-1206-91.sh-290-1331.ha-3129-100.hd-180-2.cc-3039-73.ch-3215-92.lg-270-73


The bot sql:

-- phpMyAdmin SQL Dump
-- version 3.5.2
-- phpMyAdmin
--
-- Machine: localhost
-- Genereertijd: 25 jul 2012 om 15:53
-- 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 `bots`
--

CREATE TABLE IF NOT EXISTS `bots` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`room_id` int(10) unsigned NOT NULL DEFAULT '0',
`ai_type` enum('generic','guide','pet') NOT NULL DEFAULT 'generic',
`name` varchar(100) NOT NULL,
`motto` varchar(120) NOT NULL,
`look` text NOT NULL,
`x` int(11) NOT NULL DEFAULT '0',
`y` int(11) NOT NULL DEFAULT '0',
`z` int(11) NOT NULL DEFAULT '0',
`rotation` int(11) NOT NULL DEFAULT '0',
`walk_mode` enum('stand','freeroam','specified_range') NOT NULL DEFAULT 'stand',
`min_x` int(11) NOT NULL DEFAULT '0',
`min_y` int(11) NOT NULL DEFAULT '0',
`max_x` int(11) NOT NULL DEFAULT '0',
`max_y` int(11) NOT NULL DEFAULT '0',
`effect` int(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `room_id` (`room_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1549 ;

--
-- Gegevens worden uitgevoerd voor tabel `bots`
--

INSERT INTO `bots` (`id`, `room_id`, `ai_type`, `name`, `motto`, `look`, `x`, `y`, `z`, `rotation`, `walk_mode`, `min_x`, `min_y`, `max_x`, `max_y`, `effect`) VALUES
(3, 1, 'generic', 'Frank', 'Hallo, ik ben Frank!', 'hr-831-45.fa-1206-91.sh-290-1331.ha-3129-100.hd-180-2.cc-3039-73.ch-3215-92.lg-270-73', 15, 19, 0, 0, 'freeroam', 0, 0, 0, 0, 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 */;

And the furni sql:
http://forum.ragezone.com/f353/new-p...-found-837878/

Like if you like my Topic(s).
Greetz,
Arjan

[MentaL]

[Monsma]

thanks for this

[PRIZM]

Awesome Arjan! :-)

[.::Arjan::.]

Awesome Arjan! :-)

You're welcome ;)

[Timzzz]

i love it

[sasuke]

how to put the bot in the room at that point?

[Nilenz]

Wow Arjan, I like this so Thanks for release

[.::Arjan::.]

The bot sql:

-- phpMyAdmin SQL Dump
-- version 3.5.2
-- phpMyAdmin
--
-- Machine: localhost
-- Genereertijd: 25 jul 2012 om 15:53
-- 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 `bots`
--

CREATE TABLE IF NOT EXISTS `bots` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`room_id` int(10) unsigned NOT NULL DEFAULT '0',
`ai_type` enum('generic','guide','pet') NOT NULL DEFAULT 'generic',
`name` varchar(100) NOT NULL,
`motto` varchar(120) NOT NULL,
`look` text NOT NULL,
`x` int(11) NOT NULL DEFAULT '0',
`y` int(11) NOT NULL DEFAULT '0',
`z` int(11) NOT NULL DEFAULT '0',
`rotation` int(11) NOT NULL DEFAULT '0',
`walk_mode` enum('stand','freeroam','specified_range') NOT NULL DEFAULT 'stand',
`min_x` int(11) NOT NULL DEFAULT '0',
`min_y` int(11) NOT NULL DEFAULT '0',
`max_x` int(11) NOT NULL DEFAULT '0',
`max_y` int(11) NOT NULL DEFAULT '0',
`effect` int(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `room_id` (`room_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1549 ;

--
-- Gegevens worden uitgevoerd voor tabel `bots`
--

INSERT INTO `bots` (`id`, `room_id`, `ai_type`, `name`, `motto`, `look`, `x`, `y`, `z`, `rotation`, `walk_mode`, `min_x`, `min_y`, `max_x`, `max_y`, `effect`) VALUES
(3, 1, 'generic', 'Frank', 'Hallo, ik ben Frank!', 'hr-831-45.fa-1206-91.sh-290-1331.ha-3129-100.hd-180-2.cc-3039-73.ch-3215-92.lg-270-73', 15, 19, 0, 0, 'freeroam', 0, 0, 0, 0, 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 */;

[St89]

Where is the sqls for the furnis? Please addet!

[.::Arjan::.]

Where is the sqls for the furnis? Please addet!

Here you go ;)
http://forum.ragezone.com/f353/new-p...-found-837878/

[Bjork]

I fixed myself age ago but nice release for others :)

Thank you

[sasuke]

The bot sql:

thanks guy

[DaiMinzz1]

Thank you :)


Edit: Its not fixed ? ..

[.::Arjan::.]

Thank you :)


Edit: Its not fixed ? ..

You must clear your cache ;x

[blink182sp44]

Nice job! I Like it. You have MY like :D

[landline]

Mine was already fixed, but thanks anyway.. It will help others :D

[BurakAdama]

Thanks, working

[Matthew55]

Where is the furniture and catalog_items sql??????
:)

-Matt

[.::Arjan::.]

Where is the furniture and catalog_items sql??????
:)

-Matt

I have place it in my post.

[Chapo]

(!@#$%^%!) i found for you :@:@

[Incinigrate]

Thanks for the release <3 Will help a lot of people who want to make a welcome room like that :P

[.::Arjan::.]

(!@#$%^%!) i found for you :@:@

O sorry i forgot to say that :$