Good Release!!!
is it normal, my rooms dont load xD
Printable View
Good Release!!!
is it normal, my rooms dont load xD
fail @ that cms ^
later I'll work on a cms for me, maybe I release for download.
PHP Connection ^^
Spoiler:
MEGAUPLOAD - The leading online storage and file delivery service
V1 DCRS, CCTS and other stuff.
Sample cms : http://dl.dropbox.com/u/24544019/v1/samplecms.rar
Database :
Spoiler:
Print : http://dl.dropbox.com/u/24544019/v1/basecms.png
now I expect the improvements to the server for me to improve cms :lol:
Edit
CONSOLE FIND by Sr.Tetris :P
Print - http://dl.dropbox.com/u/24544019/v1/console.PNG
Code: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);
}
}
}
why i can't go on any room?
can not go on any yet :(
this MUST be fixed... if i can do something with the db call me.
It has to do with the emulator he didn't complete it because he has another project to do. Anyways good release Alex.
when the r4 will come? i wait impatiently to try v 1, and i think this is the only emy that can do that.
FIXES by Sr.TetrisSERVERNAVIGATOR, FAVORITES AND SEARCHCode: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
Code:-- 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');
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)!
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,Quote:
Originally Posted by Quackster
Tanks to this server I learned more about the v1, I hope one day to create a server complete. :laugh:
You should really try that, good luck if ya do.Quote:
Originally Posted by SrTetris
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!
Hai Duh,
im searching for ANY MySql Files to use. There Arent ANYTHING