[PEDIDO]SQL HABBO

Olá!
cheque essa área:

https://www.power-pixel.net/f31-

até.

Código:


-- phpMyAdmin SQL Dump
-- version 3.5.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 19, 2016 at 01:59 AM
-- Server version: 5.5.25a
-- PHP Version: 5.4.4

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

--
-- Database: `220`
--

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

--
-- tab[b][/b]le structure for tab[b][/b]le `rooms_data`
--

CREATE tab[b][/b]le IF NOT EXISTS `rooms_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `roomtype` enum('public','private') NOT NULL DEFAULT 'private',
  `caption` varchar(100) NOT NULL DEFAULT 'Room',
  `owner` varchar(75) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `category` int(11) NOT NULL DEFAULT '0',
  `state` enum('open','locked','password') NOT NULL DEFAULT 'open',
  `trade_state` enum('0','1','2') NOT NULL DEFAULT '2',
  `users_now` int(11) NOT NULL DEFAULT '0',
  `users_max` int(11) NOT NULL DEFAULT '25',
  `model_name` varchar(50) NOT NULL,
  `public_ccts` varchar(50) NOT NULL DEFAULT '',
  `score` int(11) NOT NULL DEFAULT '0',
  `tags` varchar(100) NOT NULL DEFAULT '',
  `icon_bg` int(11) NOT NULL DEFAULT '1',
  `icon_fg` int(11) NOT NULL DEFAULT '0',
  `icon_items` varchar(50) NOT NULL DEFAULT '',
  `password` varchar(30) NOT NULL DEFAULT '',
  `wallpaper` varchar(10) NOT NULL DEFAULT '0.0',
  `floor` varchar(10) NOT NULL DEFAULT '0.0',
  `landscape` varchar(10) NOT NULL DEFAULT '0.0',
  `allow_pets` enum('0','1') NOT NULL DEFAULT '1',
  `allow_pets_eat` enum('0','1') NOT NULL DEFAULT '0',
  `allow_walkthrough` enum('0','1') NOT NULL DEFAULT '0',
  `hidewall` enum('0','1') NOT NULL DEFAULT '0',
  `wallthick` int(1) NOT NULL DEFAULT '0',
  `floorthick` int(1) NOT NULL DEFAULT '0',
  `achievement` int(11) NOT NULL DEFAULT '0',
  `group_id` int(11) unsigned NOT NULL DEFAULT '0',
  `game_id` int(11) NOT NULL DEFAULT '0',
  `mute_settings` int(3) NOT NULL DEFAULT '0',
  `ban_settings` int(3) NOT NULL DEFAULT '0',
  `kick_settings` int(3) NOT NULL DEFAULT '0',
  `chat_type` int(3) NOT NULL DEFAULT '0',
  `chat_balloon` int(3) NOT NULL DEFAULT '0',
  `chat_speed` int(3) NOT NULL DEFAULT '0',
  `chat_max_distance` int(3) NOT NULL DEFAULT '14',
  `chat_flood_protection` int(3) NOT NULL DEFAULT '0',
  `walls_height` int(3) NOT NULL DEFAULT '-1',
  `image_thumb` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`) USING BTREE,
  KEY `owner` (`owner`) USING BTREE,
  KEY `roomtype` (`roomtype`) USING BTREE,
  KEY `caption` (`caption`) USING BTREE,
  KEY `users_now` (`users_now`) USING BTREE,
  KEY `tags` (`tags`) USING BTREE,
  KEY `category` (`category`) USING BTREE,
  KEY `password` (`password`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

DELIMITER $$
--
-- Events
--
CREATE DEFINER=`root`@`localhost` EVENT `daily_pet_respect_points` ON SCHEDULE EVERY 24 HOUR STARTS '2015-02-10 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO update users_stats set daily_pet_respect_points = 5 where daily_pet_respect_points = 0$$

CREATE DEFINER=`root`@`localhost` EVENT `daily_respect_points` ON SCHEDULE EVERY 24 HOUR STARTS '2015-01-12 21:39:07' ON COMPLETION NOT PRESERVE ENABLE DO update users_stats set daily_respect_points = 5 where daily_respect_points = 0$$

DELIMITER ;

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



[aviso=Alerta] 24 horas para informar se está satisfeito [/aviso]

[sucesso=OBRIGADO ] PODE FECHAR O TÓPICO ! [/sucesso]

[sucesso=Questão marcada como Resolvida ou o Autor solicitou que ela fosse arquivada.] Tópico marcado como Resolvido e movido para "Questões resolvidas". [/sucesso]