prjHELLO - Habbo Hotel v1 [C#, MySQL, From Scratch]

[Lukadora]

Good Release!!!

is it normal, my rooms dont load xD

[Someuser]

fail @ that cms ^

[SrTetris]

later I'll work on a cms for me, maybe I release for download.

PHP Connection ^^

Spoiler:

        public void LOL()
        {
            NewSocket.SendData(clientStream, "lol");
        }

<?php
// By Sr.Tetris
    $ip= '127.0.0.1';
    $port = '90';
    $socket = socket_create(AF_INET, SOCK_STREAM, getprotobyname('tcp'));
    socket_connect($socket, $ip, $port);
    
    $data = "00  LOL";    
    socket_send($socket, $data, strlen($data), MSG_DONTROUTE);
    @$recv_data .= socket_read($socket, 512)."<br>";
    @$recv_data .= socket_read($socket, 512)."<br>";
    echo $recv_data;
    socket_close($socket);
?>

[Predict]

MEGAUPLOAD - The leading online storage and file delivery service

V1 DCRS, CCTS and other stuff.

[SrTetris]

Sample cms : http://dl.dropbox.com/u/24544019/v1/samplecms.rar
Database :

Spoiler:

CREATE TABLE IF NOT EXISTS `tetris_cms_config` (
  `ip` varchar(150) NOT NULL,
  `port` int(11) NOT NULL,
  `hotel` varchar(200) NOT NULL,
  `dcr` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `tetris_cms_config` (`ip`, `port`, `hotel`, `dcr`) VALUES
('5.110.210.190', 90, 'Sample CMS By Sr.Tetris', 'http://5.110.210.190/2001/loader.dcr');


CREATE TABLE IF NOT EXISTS `tetris_cms_lang` (
  `name` varchar(300) NOT NULL,
  `file` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `tetris_cms_lang` (`name`, `file`) VALUES
('Portugues Brasil', 'pt_br'),
('English', 'en');


CREATE TABLE IF NOT EXISTS `tetris_cms_lang_ip` (
  `ip` varchar(150) NOT NULL,
  `lang` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Print : http://dl.dropbox.com/u/24544019/v1/basecms.png

now I expect the improvements to the server for me to improve cms

Edit

CONSOLE FIND by Sr.Tetris :P
Print - http://dl.dropbox.com/u/24544019/v1/console.PNG

        public void UINFO_MATCH()
        {

            string userconsole = NewSocket.split[2].Replace("/", "");
            using (DatabaseClient dbClient = Program.GetDatabase().GetClient())
            {
                dbClient.AddParamWithValue("consoleusr", userconsole);

                try
                {
                    string checkdata = dbClient.ReadString("SELECT * FROM members WHERE username = @consoleusr ");

                    if (checkdata != null)
                    {
                        DataRow dbRow = dbClient.ReadDataRow("SELECT * FROM members WHERE username = @consoleusr;");
                        Username = (String)dbRow["username"];

                        fuseMessage = new serverMessage("MEMBERINFO MESSENGER");
                        fuseMessage.AppendString((String)dbRow["username"]);
                        fuseMessage.AppendString((String)dbRow["console_motto"]);
                        fuseMessage.AppendString(" "); // LAST TIME
                        fuseMessage.AppendString(" "); //ONLINE or OFFLINE
                        fuseMessage.AppendString((String)dbRow["figure"]);
                        fuseMessage.AppendString((String)dbRow["sex"]);
                        NewSocket.SendData(clientStream, fuseMessage);

                    }
                    else
                    {
                        fuseMessage = new serverMessage("NOSUCHUSER MESSENGER");
                        NewSocket.SendData(clientStream, fuseMessage);
                    }
                }
                catch
                {
                    fuseMessage = new serverMessage("NOSUCHUSER MESSENGER");
                    NewSocket.SendData(clientStream, fuseMessage);
                }
            }
        }

[ps3cfw]

why i can't go on any room?

[SrTetris]

can not go on any yet :(

[ps3cfw]

this MUST be fixed... if i can do something with the db call me.

[obrienray1]

It has to do with the emulator he didn't complete it because he has another project to do. Anyways good release Alex.

[ps3cfw]

when the r4 will come? i wait impatiently to try v 1, and i think this is the only emy that can do that.

[SrTetris]

FIXES by Sr.Tetris

SERVER

NAVIGATOR, FAVORITES AND SEARCH

        public void SEARCHFLAT()
        {
            string lowner_roomx = NewSocket.split[2].Replace("/", "");
            string lowner_room = lowner_roomx.Replace("%", "");
            string builder = null;

            using (DatabaseClient dbClient = Program.GetDatabase().GetClient())
            {
                try
                {
                    DataTable Table = dbClient.ReadDataTable("SELECT * FROM rooms_private WHERE owner LIKE '" + lowner_room + "' OR name LIKE '" + lowner_room + "'");

                    foreach (DataRow Row in Table.Rows)
                    {
                        builder = builder + (Char)13 + (Int32)Row["id"] + "/" + (String)Row["name"] + "/" + (String)Row["owner"] + "/" + (String)Row["status"] + "/" + (String)Row["password"] + "/floor1/127.0.0.1/127.0.0.1/90/1/null" + "/" + (String)Row["desc"];
                    }

                    if (builder != null)
                    {
                        fuseMessage = new serverMessage("BUSY_FLAT_RESULTS 1");
                        fuseMessage.Append(builder);
                        NewSocket.SendData(clientStream, fuseMessage);
                    }
                    else
                    {
                        fuseMessage = new serverMessage("BUSY_FLAT_RESULTS 0");
                        fuseMessage.Append(builder);
                        NewSocket.SendData(clientStream, fuseMessage);
                    }
                }
                catch
                {
                    fuseMessage = new serverMessage("BUSY_FLAT_RESULTS 0");
                    fuseMessage.Append(builder);
                    NewSocket.SendData(clientStream, fuseMessage);
                }
            }
        }
        public void SEARCHBUSYFLATS()
        {
            string builder = null;

            using (DatabaseClient dbClient = Program.GetDatabase().GetClient())
            {
                try
                {
                    DataTable Table = dbClient.ReadDataTable("SELECT * FROM rooms_private ORDER BY inroom DESC");

                    foreach (DataRow Row in Table.Rows)
                    {
                        builder = builder + (Char)13 + (Int32)Row["id"] + "/" + (String)Row["name"] + "/" + (String)Row["owner"] + "/" + (String)Row["status"] + "/" + (String)Row["password"] + "/floor1/127.0.0.1/127.0.0.1/90/1/null" + "/" + (String)Row["desc"];
                    }

                    if (builder != null)
                    {
                        fuseMessage = new serverMessage("BUSY_FLAT_RESULTS 1");
                        fuseMessage.Append(builder);
                        NewSocket.SendData(clientStream, fuseMessage);
                    }
                    else
                    {
                        fuseMessage = new serverMessage("BUSY_FLAT_RESULTS 9");
                        fuseMessage.Append(builder);
                        NewSocket.SendData(clientStream, fuseMessage);
                    }
                }
                catch
                {
                    fuseMessage = new serverMessage("BUSY_FLAT_RESULTS 9");
                    fuseMessage.Append(builder);
                    NewSocket.SendData(clientStream, fuseMessage);
                }
            }
        }
        public void SEARCHFLATFORUSER()
        {
            string lowner = NewSocket.split[2].Replace("/", "");
            string builder = null;

            using (DatabaseClient dbClient = Program.GetDatabase().GetClient())
            {
                try
                {
                    dbClient.AddParamWithValue("lowner", lowner);
                    DataTable Table = dbClient.ReadDataTable("SELECT * FROM rooms_private WHERE owner = @lowner");

                    foreach (DataRow Row in Table.Rows)
                    {
                        builder = builder + (Char)13 + (Int32)Row["id"] + "/" + (String)Row["name"] + "/" + (String)Row["owner"] + "/" + (String)Row["status"] + "/" + (String)Row["password"] + "/floor1/127.0.0.1/127.0.0.1/90/1/null" + "/" + (String)Row["desc"];
                    }

                    if (builder != null)
                    {
                        fuseMessage = new serverMessage("BUSY_FLAT_RESULTS 1");
                        fuseMessage.Append(builder);
                        NewSocket.SendData(clientStream, fuseMessage);
                    }
                    else
                    {
                        fuseMessage = new serverMessage("BUSY_FLAT_RESULTS 0");
                        NewSocket.SendData(clientStream, fuseMessage);
                    }
                }
                catch
                {
                    fuseMessage = new serverMessage("BUSY_FLAT_RESULTS 0");
                    NewSocket.SendData(clientStream, fuseMessage);
                }
            }
        }
        public void GET_FAVORITE_ROOMS()
        {
            string RoomData = null;
            string user = NewSocket.split[2];
            using (DatabaseClient dbClient = Program.GetDatabase().GetClient())
            {
                try
                {
                    dbClient.AddParamWithValue("luser", user);

                    string checkdata = dbClient.ReadString("SELECT * FROM rooms_fav WHERE user = @luser ");
                    if (checkdata != null)
                    {
                        DataTable datafavx = dbClient.ReadDataTable("SELECT * FROM rooms_fav WHERE user = @luser ");


                        foreach (DataRow dbfv in datafavx.Rows)
                        {
                            DataTable dataroom = dbClient.ReadDataTable("SELECT * FROM rooms_private WHERE id = " + (int)dbfv["id"] + "");

                            foreach (DataRow dbrm in dataroom.Rows)
                            {
                                RoomData = RoomData + (Char)13 + (Int32)dbrm["id"] + "/" + (String)dbrm["name"] + "/" + (String)dbrm["owner"] + "/" + (String)dbrm["status"] + "/" + (String)dbrm["password"] + "/floor1/127.0.0.1/127.0.0.1/90/1/null" + "/" + (String)dbrm["desc"] + " ";
                            }

                        }
                        if (RoomData != null)
                        {
                            fuseMessage = new serverMessage("BUSY_FLAT_RESULTS 1");
                            fuseMessage.AppendString(RoomData);
                            NewSocket.SendData(clientStream, fuseMessage);
                        }

                    }
                    else
                    {
                        fuseMessage = new serverMessage("BUSY_FLAT_RESULTS 0");
                        fuseMessage.AppendString(RoomData);
                        NewSocket.SendData(clientStream, fuseMessage);
                    }
                }
                catch
                {
                    fuseMessage = new serverMessage("BUSY_FLAT_RESULTS 0");
                    fuseMessage.AppendString(RoomData);
                    NewSocket.SendData(clientStream, fuseMessage);
                }

            }

        }
        public void ADD_FAVORITE_ROOM()
        {
            using (DatabaseClient dbClient = Program.GetDatabase().GetClient())
            {
                try
                {
                    dbClient.ExecuteQuery("INSERT INTO rooms_fav (id, user) VALUES ('" + NewSocket.split[2] + "', '" + Username + "')");
                }
                catch
                {
                    fuseMessage = new serverMessage("SYSTEMBROADCAST");
                    fuseMessage.AppendString("dont work");
                    NewSocket.SendData(clientStream, fuseMessage);
                }
            }
            
        }
        public void DEL_FAVORITE_ROOM()
        {
            using (DatabaseClient dbClient = Program.GetDatabase().GetClient())
            {
                dbClient.ExecuteQuery("DELETE FROM rooms_fav WHERE id = '" + NewSocket.split[2] + "' and user = '" + Username + "' LIMIT 1");
            }
        }

DATABASE

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tempo de Geração: Jun 29, 2011 as 05:59 
-- Versão do Servidor: 5.5.8
-- Versão do PHP: 5.3.5

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

--
-- Banco de Dados: `r1`
--

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

--
-- Estrutura da tabela `members`
--

DROP TABLE IF EXISTS `members`;
CREATE TABLE IF NOT EXISTS `members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(150) NOT NULL,
  `password` varchar(150) NOT NULL,
  `role` int(40) NOT NULL,
  `email` varchar(255) NOT NULL,
  `coins` int(255) NOT NULL,
  `motto` varchar(150) NOT NULL,
  `console_motto` varchar(150) NOT NULL,
  `figure` varchar(500) NOT NULL,
  `birthday` varchar(150) NOT NULL,
  `country` varchar(150) NOT NULL,
  `sex` varchar(10) NOT NULL,
  `badge` int(255) NOT NULL,
  `had_read_agreement` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Extraindo dados da tabela `members`
--

INSERT INTO `members` (`id`, `username`, `password`, `role`, `email`, `coins`, `motto`, `console_motto`, `figure`, `birthday`, `country`, `sex`, `badge`, `had_read_agreement`) VALUES
(1, 'Alex', 'lol', 7, 'hehe@woo.com', 1337, 'My name is cake.', 'HeyHey plz', 'sd=001/0&hr=001/255,255,255&hd=002/255,204,153&ey=001/0&fc=001/255,204,153&bd=001/255,204,153&lh=001/255,204,153&rh=001/255,204,153&ch=001/232,177,55&ls=001/232,177,55&rs=001/232,177,55&lg=001/119,159,187&sh=003/121,94,83', '06/07/1997', 'AU', 'Male', 0, 1),
(2, 'Lolol', 'lol', 1, 'emo@haha.com', 1234, 'lol', 'lol', 'sd=001/0&hr=001/255,255,255&hd=002/255,204,153&ey=001/0&fc=001/255,204,153&bd=001/255,204,153&lh=001/255,204,153&rh=001/255,204,153&ch=001/232,177,55&ls=001/232,177,55&rs=001/232,177,55&lg=001/119,159,187&sh=003/121,94,83', '05.09.1992', 'AU', 'Female', 0, 1),
(3, 'teste', 'lol123', 1, 'ddd@hotmail.com', 1337, 'xd', '', 'sd=001/0&hr=001/255,255,255&hd=002/255,204,153&ey=001/0&fc=001/255,204,153&bd=001/255,204,153&lh=001/255,204,153&rh=001/255,204,153&ch=001/232,177,55&ls=001/232,177,55&rs=001/232,177,55&lg=001/119,159,187&sh=001/175,220,223', '09.08.1994', '', 'Male', 0, 1),
(4, 'srtetris', 'lol123', 1, 'rodrigobmessias@hotmail.com', 1337, 'LOL', '', 'sd=001/0&hr=005/223,218,190&hd=002/255,204,153&ey=001/0&fc=001/255,204,153&bd=001/255,204,153&lh=001/255,204,153&rh=001/255,204,153&ch=003/232,177,55&ls=001/232,177,55&rs=001/232,177,55&lg=004/102,102,102&sh=003/47,45,38', '06.09.1995', '', 'Male', 0, 1),
(5, 'luan', 'lolz123', 1, 'lol@hotmail.com', 1337, 'Lolhehehe', '', 'sd=001/0&hr=014/200,210,230&hd=002/255,204,153&ey=001/0&fc=001/255,204,153&bd=001/255,204,153&lh=001/255,204,153&rh=001/255,204,153&ch=001/51,102,51&ls=002/51,102,51&rs=002/51,102,51&lg=002/255,255,255&sh=002/192,180,199', '03/02/1992', '', 'Male', 0, 1);

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

--
-- Estrutura da tabela `rooms_fav`
--

DROP TABLE IF EXISTS `rooms_fav`;
CREATE TABLE IF NOT EXISTS `rooms_fav` (
  `id` int(11) NOT NULL,
  `user` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `rooms_fav`
--

INSERT INTO `rooms_fav` (`id`, `user`) VALUES
(2, 'srtetris'),
(3, 'srtetris');

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

--
-- Estrutura da tabela `rooms_private`
--

DROP TABLE IF EXISTS `rooms_private`;
CREATE TABLE IF NOT EXISTS `rooms_private` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `owner` varchar(150) NOT NULL,
  `password` varchar(150) NOT NULL,
  `status` varchar(150) NOT NULL COMMENT 'open / closed',
  `model` varchar(150) NOT NULL,
  `desc` varchar(150) NOT NULL,
  `floor` varchar(300) NOT NULL,
  `inroom` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Extraindo dados da tabela `rooms_private`
--

INSERT INTO `rooms_private` (`id`, `name`, `owner`, `password`, `status`, `model`, `desc`, `floor`, `inroom`) VALUES
(1, 'My secret room biatches', 'Alex', '', 'open', 'model_b', 'loled!', '', 0),
(2, 'Join the lulz', 'Alex', '', 'open', 'model_a', 'Wanna fight meh?', '', 0),
(3, 'Teste', 'srtetris', 'lol', 'closed', 'model_a', 'quarto de teste', '', 0);

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

--
-- Estrutura da tabela `rooms_public`
--

DROP TABLE IF EXISTS `rooms_public`;
CREATE TABLE IF NOT EXISTS `rooms_public` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `model` varchar(250) NOT NULL,
  `max_in` int(255) NOT NULL,
  `curr_in` int(255) NOT NULL,
  `name_tolower` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Extraindo dados da tabela `rooms_public`
--

INSERT INTO `rooms_public` (`id`, `name`, `model`, `max_in`, `curr_in`, `name_tolower`) VALUES
(2, 'Habbo Lido', 'pool_a', 25, 0, 'lido'),
(3, 'Hotel Kitchen', 'cr_kitchen', 25, 0, 'kitchen'),
(4, 'The Dirty Duck Pub', 'pub_a', 25, 0, 'pub'),
(7, 'Main Lobby', 'gf_lobby', 25, 0, 'lobby'),
(8, 'The Chromide Club', 'habbo_disco', 25, 0, 'disco'),
(9, 'Cafe Ole', 'gf_cafe', 25, 0, 'cafe'),
(10, 'Hotel Kitchen', 'gf_kitchen', 25, 0, 'Kitchen'),
(11, 'Habburger''s', 'gf_habburger', 25, 0, 'habburger'),
(12, 'Club Massiva', 'gf_bar', 25, 0, 'bar');

[kbj]

Thanks! I love oldskool. (all things that are old (Nintendo NES, Gameboy classic, sega gamegear) XD
I really respect people that loves and remakes the old v1 (and mobiles disco)!

[Quackster]

I've stopped development on this but SrTetris is welcome to post a thread about this if he wants to :D

[SrTetris]

I've stopped development on this but SrTetris is welcome to post a thread about this if he wants to :D

This is my last fix, I'm trying to modify the ION v7,
Tanks to this server I learned more about the v1, I hope one day to create a server complete.

[Makarov]

This is my last fix, I'm trying to modify the ION v7,
Tanks to this server I learned more about the v1, I hope one day to create a server complete.

You should really try that, good luck if ya do.

[Roper]

A fantastic little base to work on, thanks for sharing it Alex. I think I may have a mess around with it, and see what I can break!

[Witschi262]

Hai Duh,

im searching for ANY MySql Files to use. There Arent ANYTHING