[Ceejays edit][RP][V26]Ceejays Edit of Rasta's RP Edit[V26][RP][Ceejay's Edit]

[CJRP]

RIGHT 3RD TIME LUCKY ( PAST 2 TIMES IVE ACCIDENTLY CLOSED THIS :@) RIGHT IM RELEASING MY RP SERVER

TIPS:
DONT CODE TO MUCH AT ONCE
DONT STRESS
HAVE FUN


FOUND AT
HTTP://abboh.ath.cx/rpemu.rar
http://abboh.ath.cx/cms.rar

Mirror them if you wish, Anyone that Claims them will die Whatever idgaf, THere only staying on till i go bed tonight then i will delete them...

PM me for the pw, If i think your worthy enough for it you can have it. :/ if not.. in simple terms

UOY KCUF :)

commands

:skin <name> <white/brown/black>
sexchange <name> <m/f>
jailtimer
deadtimer
jailbreak
workout
sellproperty/buyproperty
roomdetails
bankrob
poof
flagme
stats
emptyhand
rooms
commands
whosonline/phonebook
test
weed
canabis
run/avoid/flee/runaway
rape
corpdeposit <id> <amount> 
push <user>
pull <user>
balance 
911/112 <message>
deposit <amount>
taxi < roomid>
give <user> <amount>
hw/ha
offline
ra
addwanted<user>
remove wanted<user>
superhire <user> <corpid> <rank>
superspeed / superspeed off
flag
roomheal
bringtostand
banggabel
courtclosed
caseclosed
defend <user>
prosicute <user>
say <user> <message>
coins
summon <user
colour 
ganginvite
gangaccept
gangform
gangdelete
reccomend
removereccomendation
kill <user
resetroom
drink <id>
fight <yes/no>
allowtaxi <yes/no>
game <user> <game>
textmsg <user>
giveitem
marry <user>
divorce <user>
sex
oralsex
hair <type>-<colour>
purchase <type>-<colour>
change clothes
colour <colour>
useweed
smoke
sleed
nap
wakeup
sniffcocaine
usesteroids
surrender

db

-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 16, 2010 at 09:56 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.1

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

--
-- Database: `cleardb`
--

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

--
-- Table structure for table `applications`
--

CREATE TABLE IF NOT EXISTS `applications` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `appstatus` text NOT NULL,
  `age` text NOT NULL,
  `country` text NOT NULL,
  `timezone` text NOT NULL,
  `realname` text NOT NULL,
  `modname` text NOT NULL,
  `time` text NOT NULL,
  `experience` text NOT NULL,
  `message1` text NOT NULL,
  `message2` text NOT NULL,
  `message3` text NOT NULL,
  `users` text NOT NULL,
  `visitoripaddy` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `applications`
--


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

--
-- Table structure for table `catalogue_deals`
--

CREATE TABLE IF NOT EXISTS `catalogue_deals` (
  `id` int(10) NOT NULL COMMENT 'The ID of this deal [the part after "deal"]',
  `tid` int(10) NOT NULL COMMENT 'The template ID of the item that should be in this deal',
  `amount` int(10) NOT NULL COMMENT 'The amount, of how many items of the type _TID should be in this deal'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `catalogue_deals`
--


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

--
-- Table structure for table `catalogue_items`
--

CREATE TABLE IF NOT EXISTS `catalogue_items` (
  `tid` int(10) NOT NULL AUTO_INCREMENT,
  `catalogue_name` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `catalogue_description` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `catalogue_cost` int(5) NOT NULL,
  `typeid` int(1) NOT NULL DEFAULT '0',
  `length` int(2) NOT NULL DEFAULT '0',
  `width` int(2) NOT NULL DEFAULT '0',
  `top` double(4,2) NOT NULL,
  `name_cct` varchar(110) COLLATE latin1_general_ci NOT NULL,
  `colour` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `catalogue_id_page` tinyint(3) NOT NULL,
  `door` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `tradeable` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `recycleable` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `catalogue_id_index` int(5) NOT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `catalogue_items`
--


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

--
-- Table structure for table `catalogue_pages`
--

CREATE TABLE IF NOT EXISTS `catalogue_pages` (
  `indexid` tinyint(3) NOT NULL,
  `minrank` tinyint(1) NOT NULL,
  `indexname` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `displayname` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `style_layout` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `img_header` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `img_side` text COLLATE latin1_general_ci,
  `label_description` text COLLATE latin1_general_ci,
  `label_misc` text COLLATE latin1_general_ci,
  `label_moredetails` varchar(150) COLLATE latin1_general_ci DEFAULT NULL,
  `opt_bodyreplace` text COLLATE latin1_general_ci,
  PRIMARY KEY (`indexid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `catalogue_pages`
--


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

--
-- Table structure for table `cms_alerts`
--

CREATE TABLE IF NOT EXISTS `cms_alerts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `alert` text NOT NULL,
  `type` enum('1','0','-1','2') NOT NULL DEFAULT '1',
  `time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_alerts`
--


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

--
-- Table structure for table `cms_applications`
--

CREATE TABLE IF NOT EXISTS `cms_applications` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `rankname` varchar(255) NOT NULL,
  `username` varchar(50) NOT NULL,
  `realname` varchar(50) NOT NULL,
  `birth` varchar(15) NOT NULL,
  `sex` varchar(10) NOT NULL,
  `country` varchar(50) NOT NULL,
  `general_information` text NOT NULL,
  `experience` text NOT NULL,
  `education` varchar(50) NOT NULL,
  `additional_information` text NOT NULL,
  `accepted_disclaimer` int(1) NOT NULL DEFAULT '0',
  `admin_reacted` int(1) NOT NULL DEFAULT '0',
  `admin_read` int(1) NOT NULL DEFAULT '0',
  `admin_deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_applications`
--


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

--
-- Table structure for table `cms_application_forms`
--

CREATE TABLE IF NOT EXISTS `cms_application_forms` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '0' COMMENT 'For what rank can people applicate?',
  `introduction` text NOT NULL COMMENT 'What''s the description of the rank it self?',
  `requirements` text NOT NULL COMMENT 'What are the requirments if you want to do this job?',
  `hconly` int(1) NOT NULL DEFAULT '0' COMMENT 'Can only people who are HC applicate or everyone?',
  `username` int(1) NOT NULL DEFAULT '0' COMMENT 'Show username in application form?',
  `realname` int(1) NOT NULL DEFAULT '0' COMMENT 'Need people to fill in their real name?',
  `birth` int(1) NOT NULL DEFAULT '0' COMMENT 'Show birth in application form?',
  `sex` int(1) NOT NULL DEFAULT '0' COMMENT 'Need people to fill in what there sex is (male/female/shemale)?',
  `country` int(1) NOT NULL DEFAULT '0' COMMENT 'Need people to fill in, in what country they live?',
  `general_information` int(1) NOT NULL DEFAULT '0' COMMENT 'Need people to fill in general information (reasons why you''re interested/why the staff should choose you)?',
  `experience` int(1) NOT NULL DEFAULT '0' COMMENT 'Need people to fill in if they have work experience?',
  `education` int(1) NOT NULL DEFAULT '0' COMMENT 'Need people to fill in what level they (did) study?',
  `additional_information` int(1) NOT NULL DEFAULT '0' COMMENT 'Need people to fill in hobbies or interests?',
  `show_disclaimer` int(1) NOT NULL DEFAULT '0' COMMENT 'Must there be a disclaimer that the people who applicates need to accept?',
  `disclaimer_text` text NOT NULL COMMENT 'The disclaimer it self (shown if configurated).',
  `enabled` int(11) NOT NULL DEFAULT '0' COMMENT 'Can you right now apply for this rank?',
  `deleted` int(1) NOT NULL DEFAULT '0' COMMENT 'If you ''delete'' a application form it will be invisible. We don''t delete it in the sql table so no errors come up if someone applied for this rank.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='You DO NOT find any applications in this table, only the for' AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_application_forms`
--


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

--
-- Table structure for table `cms_banners`
--

CREATE TABLE IF NOT EXISTS `cms_banners` (
  `id` int(35) NOT NULL AUTO_INCREMENT,
  `text` varchar(50) NOT NULL,
  `banner` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `status` smallint(1) NOT NULL DEFAULT '0',
  `advanced` int(1) DEFAULT NULL,
  `html` text,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_banners`
--


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

--
-- Table structure for table `cms_campaigns`
--

CREATE TABLE IF NOT EXISTS `cms_campaigns` (
  `id` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `desc` text,
  `visible` enum('1','0') DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_campaigns`
--


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

--
-- Table structure for table `cms_client_errors`
--

CREATE TABLE IF NOT EXISTS `cms_client_errors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` text,
  `userid` int(11) DEFAULT NULL,
  `error_type` text,
  `os` text,
  `error_id` text,
  `hookerror` text,
  `error_message` text,
  `hookmsgb` text,
  `lastexecute` text,
  `lastmessage` text,
  `server_errors` text,
  `lastroom` text,
  `mus_errorcode` text,
  `client_process_list` text,
  `client_errors` text,
  `neterr_cast` text,
  `neterr_res` text,
  `client_uptime` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_client_errors`
--


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

--
-- Table structure for table `cms_collectables`
--

CREATE TABLE IF NOT EXISTS `cms_collectables` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `image_small` varchar(255) DEFAULT NULL,
  `image_large` varchar(255) DEFAULT NULL,
  `furni_id` int(20) NOT NULL DEFAULT '0',
  `date` int(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_collectables`
--


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

--
-- Table structure for table `cms_config`
--

CREATE TABLE IF NOT EXISTS `cms_config` (
  `name_short` varchar(20) NOT NULL,
  `name_long` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms_config`
--


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

--
-- Table structure for table `cms_content`
--

CREATE TABLE IF NOT EXISTS `cms_content` (
  `contentkey` text NOT NULL,
  `contentvalue` text NOT NULL,
  `setting_title` text NOT NULL,
  `setting_desc` text NOT NULL,
  `fieldtype` enum('1','2','3') NOT NULL DEFAULT '1',
  `category` int(11) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms_content`
--


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

--
-- Table structure for table `cms_faq`
--

CREATE TABLE IF NOT EXISTS `cms_faq` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `type` enum('item','cat') NOT NULL DEFAULT 'item',
  `catid` int(11) DEFAULT NULL,
  `title` varchar(1000) NOT NULL,
  `content` text,
  `show_in_footer` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_faq`
--


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

--
-- Table structure for table `cms_forum_posts`
--

CREATE TABLE IF NOT EXISTS `cms_forum_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `threadid` int(11) NOT NULL DEFAULT '0',
  `message` text NOT NULL,
  `posterid` int(25) NOT NULL,
  `time` int(10) NOT NULL,
  `edit_time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_forum_posts`
--


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

--
-- Table structure for table `cms_forum_threads`
--

CREATE TABLE IF NOT EXISTS `cms_forum_threads` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `starterid` int(25) NOT NULL,
  `title` varchar(30) NOT NULL,
  `open` enum('1','0') NOT NULL DEFAULT '1',
  `sticky` enum('1','0') NOT NULL DEFAULT '0',
  `views` int(11) NOT NULL,
  `groupid` int(10) NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_forum_threads`
--


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

--
-- Table structure for table `cms_guestbook`
--

CREATE TABLE IF NOT EXISTS `cms_guestbook` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `message` text,
  `time` int(10) DEFAULT NULL,
  `userid` int(10) DEFAULT NULL,
  `ownerid` int(10) DEFAULT NULL,
  `owner` enum('user','group') DEFAULT 'user',
  PRIMARY KEY (`id`),
  KEY `id` (`id`,`ownerid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_guestbook`
--


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

--
-- Table structure for table `cms_help`
--

CREATE TABLE IF NOT EXISTS `cms_help` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) NOT NULL,
  `ip` varchar(50) NOT NULL,
  `message` mediumtext NOT NULL,
  `date` varchar(50) NOT NULL,
  `picked_up` enum('0','1') NOT NULL,
  `subject` varchar(50) NOT NULL,
  `roomid` int(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`,`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_help`
--


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

--
-- Table structure for table `cms_homes`
--

CREATE TABLE IF NOT EXISTS `cms_homes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemid` int(11) DEFAULT NULL,
  `ownerid` int(11) NOT NULL,
  `x` varchar(6) DEFAULT '1' COMMENT 'left',
  `y` varchar(6) DEFAULT '1' COMMENT 'top',
  `z` varchar(6) DEFAULT '1' COMMENT 'z-index',
  `skin` varchar(255) DEFAULT 'defaultskin',
  `location` int(11) DEFAULT '-1' COMMENT '-1 = inventory, 0 = user''s home page >1 = group id page',
  `variable` text,
  PRIMARY KEY (`id`),
  KEY `id` (`id`,`ownerid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_homes`
--


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

--
-- Table structure for table `cms_homes_catalogue`
--

CREATE TABLE IF NOT EXISTS `cms_homes_catalogue` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '-1 = groups only, 0 = anywhere, 1 = homes only',
  `name` varchar(255) NOT NULL,
  `desc` varchar(255) DEFAULT NULL COMMENT 'ONLY for widgets',
  `type` enum('1','2','3','4') NOT NULL COMMENT 'stickers = 1, widgets = 2, notes = 3, backgrounds = 4',
  `data` varchar(255) NOT NULL,
  `price` int(11) NOT NULL,
  `amount` int(11) NOT NULL DEFAULT '1',
  `category` varchar(255) NOT NULL DEFAULT 'Default',
  `categoryid` int(11) NOT NULL,
  `minrank` int(11) DEFAULT '1',
  `where` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id` (`id`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_homes_catalogue`
--


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

--
-- Table structure for table `cms_homes_catalouge`
--

CREATE TABLE IF NOT EXISTS `cms_homes_catalouge` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `type` varchar(1) NOT NULL,
  `subtype` varchar(1) NOT NULL,
  `data` text NOT NULL,
  `price` int(11) NOT NULL,
  `amount` int(11) NOT NULL DEFAULT '1',
  `category` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_homes_catalouge`
--


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

--
-- Table structure for table `cms_homes_edit`
--

CREATE TABLE IF NOT EXISTS `cms_homes_edit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageid` int(11) NOT NULL,
  `editorid` int(11) NOT NULL,
  `type` enum('group','user') NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_homes_edit`
--


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

--
-- Table structure for table `cms_homes_group_linker`
--

CREATE TABLE IF NOT EXISTS `cms_homes_group_linker` (
  `userid` int(11) NOT NULL,
  `groupid` int(11) NOT NULL,
  `active` varchar(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms_homes_group_linker`
--


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

--
-- Table structure for table `cms_homes_inventory`
--

CREATE TABLE IF NOT EXISTS `cms_homes_inventory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `type` varchar(1) NOT NULL,
  `subtype` varchar(1) NOT NULL,
  `data` text NOT NULL,
  `amount` varchar(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_homes_inventory`
--


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

--
-- Table structure for table `cms_homes_stickers`
--

CREATE TABLE IF NOT EXISTS `cms_homes_stickers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `x` varchar(6) NOT NULL DEFAULT '1' COMMENT 'left',
  `y` varchar(6) NOT NULL DEFAULT '1' COMMENT 'top',
  `z` varchar(6) NOT NULL DEFAULT '1' COMMENT 'z-index',
  `data` text NOT NULL,
  `type` varchar(1) NOT NULL DEFAULT '1',
  `subtype` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Widget Type (if widget)',
  `skin` text NOT NULL,
  `groupid` int(11) NOT NULL DEFAULT '-1',
  `var` int(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_homes_stickers`
--


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

--
-- Table structure for table `cms_minimail`
--

CREATE TABLE IF NOT EXISTS `cms_minimail` (
  `senderid` int(11) NOT NULL,
  `to_id` int(11) DEFAULT NULL,
  `subject` varchar(30) NOT NULL,
  `time` int(10) NOT NULL,
  `message` text NOT NULL,
  `read_mail` enum('0','1') NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` int(10) DEFAULT '0',
  `conversationid` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`,`to_id`,`senderid`,`read_mail`,`deleted`,`conversationid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_minimail`
--


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

--
-- Table structure for table `cms_news`
--

CREATE TABLE IF NOT EXISTS `cms_news` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `categories` text NOT NULL,
  `header_image` varchar(100) NOT NULL,
  `summary` text NOT NULL,
  `story` longtext NOT NULL,
  `time` int(10) NOT NULL,
  `author` text NOT NULL,
  `images` text,
  PRIMARY KEY (`id`),
  KEY `num` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_news`
--


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

--
-- Table structure for table `cms_news_comments`
--

CREATE TABLE IF NOT EXISTS `cms_news_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `article` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `posted_on` varchar(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_news_comments`
--


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

--
-- Table structure for table `cms_noobgifts`
--

CREATE TABLE IF NOT EXISTS `cms_noobgifts` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `userid` int(30) NOT NULL,
  `gift` int(2) NOT NULL,
  `read` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_noobgifts`
--


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

--
-- Table structure for table `cms_ratings`
--

CREATE TABLE IF NOT EXISTS `cms_ratings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  `raterid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_ratings`
--


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

--
-- Table structure for table `cms_recommended`
--

CREATE TABLE IF NOT EXISTS `cms_recommended` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `rec_id` int(10) DEFAULT NULL,
  `type` varchar(10) DEFAULT 'group',
  `sponsered` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_recommended`
--


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

--
-- Table structure for table `cms_security_log`
--

CREATE TABLE IF NOT EXISTS `cms_security_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `ipaddress` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `event` text NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_security_log`
--


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

--
-- Table structure for table `cms_settings`
--

CREATE TABLE IF NOT EXISTS `cms_settings` (
  `id` varchar(255) NOT NULL DEFAULT '',
  `value` text,
  `label` varchar(255) DEFAULT NULL,
  `description` text,
  `type` enum('textbox','radiobuttons','selectbox','textarea','hidden') DEFAULT 'textbox',
  `values` text,
  `page` varchar(255) DEFAULT NULL,
  `order` int(11) DEFAULT '0',
  `category` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_settings`
--


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

--
-- Table structure for table `cms_settings_pages`
--

CREATE TABLE IF NOT EXISTS `cms_settings_pages` (
  `order` int(11) NOT NULL AUTO_INCREMENT,
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `icon` varchar(255) NOT NULL,
  PRIMARY KEY (`id`,`order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_settings_pages`
--


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

--
-- Table structure for table `cms_system`
--

CREATE TABLE IF NOT EXISTS `cms_system` (
  `sitename` varchar(30) COLLATE latin1_general_ci NOT NULL,
  `shortname` varchar(30) COLLATE latin1_general_ci NOT NULL,
  `site_closed` enum('0','1') COLLATE latin1_general_ci NOT NULL COMMENT 'Maintenance Mode',
  `enable_sso` enum('0','1') COLLATE latin1_general_ci NOT NULL,
  `language` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `ip` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `port` varchar(5) COLLATE latin1_general_ci NOT NULL,
  `texts` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `variables` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `dcr` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `reload_url` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `localhost` enum('0','1') COLLATE latin1_general_ci NOT NULL COMMENT 'Local server?',
  `start_credits` int(11) NOT NULL DEFAULT '0',
  `admin_notes` text COLLATE latin1_general_ci NOT NULL,
  `loader` int(1) NOT NULL DEFAULT '1',
  `analytics` text COLLATE latin1_general_ci
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';

--
-- Dumping data for table `cms_system`
--


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

--
-- Table structure for table `cms_tags`
--

CREATE TABLE IF NOT EXISTS `cms_tags` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `ownerid` int(11) NOT NULL DEFAULT '0',
  `tag` varchar(25) NOT NULL,
  `type` enum('user','group') DEFAULT 'user',
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_tags`
--


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

--
-- Table structure for table `cms_transactions`
--

CREATE TABLE IF NOT EXISTS `cms_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` int(10) NOT NULL,
  `amount` varchar(10) NOT NULL,
  `descr` text NOT NULL,
  `userid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cms_transactions`
--


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

--
-- Table structure for table `cms_users`
--

CREATE TABLE IF NOT EXISTS `cms_users` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `ipaddress_last` varchar(255) DEFAULT NULL,
  `lastvisit` int(10) DEFAULT NULL,
  `online` int(10) DEFAULT '1',
  `newsletter` int(1) DEFAULT '1',
  `email_verified` tinyint(1) DEFAULT '0',
  `show_home` int(11) DEFAULT '1',
  `email_friendrequest` enum('0','1') DEFAULT '1',
  `email_minimail` enum('0','1') DEFAULT '1',
  `show_online` int(11) DEFAULT '1',
  `remember_token` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_users`
--


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

--
-- Table structure for table `cms_verify`
--

CREATE TABLE IF NOT EXISTS `cms_verify` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `key_hash` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_verify`
--


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

--
-- Table structure for table `cms_wardrobe`
--

CREATE TABLE IF NOT EXISTS `cms_wardrobe` (
  `userid` int(11) NOT NULL,
  `slotid` varchar(1) NOT NULL,
  `figure` text NOT NULL,
  `gender` varchar(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_wardrobe`
--


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

--
-- Table structure for table `furniture`
--

CREATE TABLE IF NOT EXISTS `furniture` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'The ID of this item',
  `tid` int(10) NOT NULL COMMENT 'The template ID of this item',
  `ownerid` int(10) NOT NULL COMMENT 'The ID of the user that owns this item',
  `roomid` int(10) NOT NULL COMMENT 'The room ID the item is in. If it''s 0, then it''s in the hand of OWNERID, if it''s -1, then it''s in a present and not opened yet, if it''s -2, then it''s in the Recycler',
  `x` smallint(6) NOT NULL COMMENT 'The X of the item in a room',
  `y` smallint(6) NOT NULL COMMENT 'The Y of the item in a room',
  `z` smallint(6) NOT NULL COMMENT 'The Z [rotation] of the item in a room',
  `h` double(4,2) NOT NULL DEFAULT '0.00' COMMENT 'The H [height, double] of the item in a room',
  `var` text COLLATE latin1_general_ci COMMENT 'The variable of the item, specifying it''s turned on/off etc, :S',
  `wallpos` varchar(200) COLLATE latin1_general_ci DEFAULT NULL COMMENT 'Wallitems only. The location on the wall where the item is',
  `teleportid` int(10) DEFAULT NULL COMMENT 'Teleporters only. The ID of the teleporter that links to this one',
  `soundmachine_soundset` int(2) DEFAULT NULL,
  `soundmachine_machineid` int(10) DEFAULT NULL,
  `soundmachine_slot` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `furniture`
--


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

--
-- Table structure for table `furniture_moodlight`
--

CREATE TABLE IF NOT EXISTS `furniture_moodlight` (
  `id` int(11) NOT NULL,
  `roomid` int(11) NOT NULL,
  `preset_cur` int(1) NOT NULL DEFAULT '0',
  `preset_1` varchar(75) COLLATE latin1_general_ci DEFAULT NULL,
  `preset_2` varchar(75) COLLATE latin1_general_ci DEFAULT NULL,
  `preset_3` varchar(75) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`,`roomid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `furniture_moodlight`
--


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

--
-- Table structure for table `furniture_presents`
--

CREATE TABLE IF NOT EXISTS `furniture_presents` (
  `id` int(10) NOT NULL,
  `itemid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `furniture_presents`
--


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

--
-- Table structure for table `furniture_stickies`
--

CREATE TABLE IF NOT EXISTS `furniture_stickies` (
  `id` int(10) NOT NULL,
  `text` text COLLATE latin1_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `furniture_stickies`
--


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

--
-- Table structure for table `games_lobbies`
--

CREATE TABLE IF NOT EXISTS `games_lobbies` (
  `id` int(10) NOT NULL,
  `type` enum('bb') COLLATE latin1_general_ci NOT NULL DEFAULT 'bb',
  `rank` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `bb_allowedpowerups` text COLLATE latin1_general_ci
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `games_lobbies`
--


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

--
-- Table structure for table `games_maps`
--

CREATE TABLE IF NOT EXISTS `games_maps` (
  `type` enum('ss','bb') COLLATE latin1_general_ci NOT NULL,
  `id` enum('6','5','4','3','2','1') COLLATE latin1_general_ci NOT NULL DEFAULT '1',
  `heightmap` text COLLATE latin1_general_ci NOT NULL,
  `bb_tilemap` text COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `games_maps`
--


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

--
-- Table structure for table `games_maps_playerspawns`
--

CREATE TABLE IF NOT EXISTS `games_maps_playerspawns` (
  `type` enum('ss','bb') COLLATE latin1_general_ci NOT NULL DEFAULT 'bb',
  `mapid` enum('6','5','4','3','2','1') COLLATE latin1_general_ci NOT NULL,
  `teamid` enum('3','2','1','0') COLLATE latin1_general_ci NOT NULL,
  `x` int(11) NOT NULL,
  `y` int(11) NOT NULL,
  `z` enum('9','8','7','6','5','4','3','2','1','0') COLLATE latin1_general_ci NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `games_maps_playerspawns`
--


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

--
-- Table structure for table `games_ranks`
--

CREATE TABLE IF NOT EXISTS `games_ranks` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `type` enum('ss','bb') COLLATE latin1_general_ci NOT NULL DEFAULT 'bb',
  `title` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `minpoints` int(10) NOT NULL,
  `maxpoints` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `games_ranks`
--


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

--
-- Table structure for table `groups_details`
--

CREATE TABLE IF NOT EXISTS `groups_details` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE latin1_general_ci NOT NULL,
  `description` text CHARACTER SET utf8 NOT NULL,
  `ownerid` int(10) NOT NULL,
  `roomid` int(10) NOT NULL,
  `created` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `badge` text COLLATE latin1_general_ci NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `recommended` int(1) NOT NULL DEFAULT '0',
  `views` int(15) NOT NULL,
  `pane` smallint(1) NOT NULL DEFAULT '0',
  `topics` smallint(1) NOT NULL DEFAULT '0',
  `forumtype` tinyint(1) NOT NULL,
  `forumpremission` tinyint(1) NOT NULL,
  `alias` varchar(30) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`,`alias`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `groups_details`
--


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

--
-- Table structure for table `groups_memberships`
--

CREATE TABLE IF NOT EXISTS `groups_memberships` (
  `userid` int(10) NOT NULL,
  `groupid` int(10) NOT NULL,
  `member_rank` enum('3','2','1') COLLATE latin1_general_ci NOT NULL DEFAULT '3',
  `is_current` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `is_pending` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `groups_memberships`
--


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

--
-- Table structure for table `jobs_corps`
--

CREATE TABLE IF NOT EXISTS `jobs_corps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `corp_name` varchar(100) NOT NULL,
  `corp_balance` int(11) NOT NULL,
  `owner` int(11) NOT NULL,
  `badge` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jobs_corps`
--


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

--
-- Table structure for table `jobs_ranks`
--

CREATE TABLE IF NOT EXISTS `jobs_ranks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `figure_data_F` varchar(1000) NOT NULL DEFAULT 'hr-838-56.hd-628-7.ch-821-106.lg-700-91.sh-725-92',
  `corp_id` int(11) NOT NULL,
  `job_rank` int(2) NOT NULL,
  `motto` varchar(50) NOT NULL,
  `figure_data_M` varchar(150) NOT NULL DEFAULT 'ha-1015-.hd-180-1.ch-210-66.lg-270-81.sh-290-80.hr-100-',
  `manager_rank` int(1) NOT NULL,
  `pay` int(5) NOT NULL,
  `open_spots` int(6) NOT NULL,
  `state_owned` int(1) NOT NULL,
  `global` int(1) NOT NULL,
  `arrest` int(1) NOT NULL,
  `stun` int(1) NOT NULL,
  `cuff` int(1) NOT NULL,
  `uncuff` int(1) NOT NULL,
  `heal` int(1) NOT NULL,
  `withdraw` int(1) NOT NULL,
  `release` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jobs_ranks`
--


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

--
-- Table structure for table `jobs_rooms`
--

CREATE TABLE IF NOT EXISTS `jobs_rooms` (
  `corp_id` int(5) NOT NULL,
  `rank_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jobs_rooms`
--


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

--
-- Table structure for table `messenger_friendrequests`
--

CREATE TABLE IF NOT EXISTS `messenger_friendrequests` (
  `userid_from` int(10) NOT NULL DEFAULT '0',
  `userid_to` int(10) NOT NULL DEFAULT '0',
  `requestid` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userid_from`,`userid_to`,`requestid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `messenger_friendrequests`
--


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

--
-- Table structure for table `messenger_friendships`
--

CREATE TABLE IF NOT EXISTS `messenger_friendships` (
  `userid` bigint(20) NOT NULL,
  `friendid` bigint(20) NOT NULL,
  KEY `index extreme` (`userid`),
  KEY `extreme the 2nd` (`friendid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `messenger_friendships`
--


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

--
-- Table structure for table `messenger_messages`
--

CREATE TABLE IF NOT EXISTS `messenger_messages` (
  `userid` int(15) NOT NULL,
  `friendid` int(15) NOT NULL,
  `messageid` int(11) NOT NULL,
  `sent_on` text COLLATE latin1_general_ci NOT NULL,
  `message` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`userid`,`messageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `messenger_messages`
--


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

--
-- Table structure for table `poll`
--

CREATE TABLE IF NOT EXISTS `poll` (
  `pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rid` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `thanks` varchar(255) NOT NULL,
  PRIMARY KEY (`pid`),
  UNIQUE KEY `pid` (`pid`,`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `poll`
--


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

--
-- Table structure for table `poll_answers`
--

CREATE TABLE IF NOT EXISTS `poll_answers` (
  `aid` int(11) NOT NULL,
  `qid` int(11) NOT NULL,
  `answer` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `poll_answers`
--


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

--
-- Table structure for table `poll_questions`
--

CREATE TABLE IF NOT EXISTS `poll_questions` (
  `qid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL,
  `question` varchar(255) NOT NULL,
  `type` enum('1','2','3') NOT NULL,
  `min` int(11) NOT NULL,
  `max` int(11) NOT NULL,
  UNIQUE KEY `qid` (`qid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `poll_questions`
--


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

--
-- Table structure for table `poll_results`
--

CREATE TABLE IF NOT EXISTS `poll_results` (
  `pid` int(11) NOT NULL,
  `qid` int(11) NOT NULL,
  `aid` int(11) NOT NULL,
  `answers` varchar(255) NOT NULL,
  `uid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `poll_results`
--


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

--
-- Table structure for table `ranks`
--

CREATE TABLE IF NOT EXISTS `ranks` (
  `rankid` int(1) NOT NULL,
  `rankname` varchar(15) COLLATE latin1_general_ci DEFAULT NULL,
  `ignoreFilter` int(1) NOT NULL,
  `receiveCFH` int(1) NOT NULL,
  `enterAllRooms` int(1) NOT NULL,
  `seeAllOwners` int(1) NOT NULL,
  `adminCatalogue` int(1) NOT NULL,
  `staffFloor` int(1) NOT NULL,
  `rightsEverywhere` int(4) NOT NULL,
  PRIMARY KEY (`rankid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `ranks`
--


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

--
-- Table structure for table `rank_fuserights`
--

CREATE TABLE IF NOT EXISTS `rank_fuserights` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `minrank` int(1) NOT NULL,
  `fuseright` varchar(100) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`,`fuseright`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `rank_fuserights`
--


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

--
-- Table structure for table `rarevalue`
--

CREATE TABLE IF NOT EXISTS `rarevalue` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT 'Empty slot',
  `img` varchar(64) NOT NULL DEFAULT 'noimg',
  `value` decimal(15,2) NOT NULL DEFAULT '1.00',
  `valuestate` varchar(1) NOT NULL DEFAULT '0' COMMENT '0 = no change, 1 = value increase, 2 = value decrease',
  `releasestate` varchar(1) NOT NULL DEFAULT '0' COMMENT '0 = new, 1 = released',
  `category` varchar(1) NOT NULL,
  `last_update` varchar(64) NOT NULL DEFAULT '2008-06-28',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `rarevalue`
--


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

--
-- Table structure for table `roombots`
--

CREATE TABLE IF NOT EXISTS `roombots` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `roomid` int(10) NOT NULL,
  `name` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `mission` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `figure` text COLLATE latin1_general_ci NOT NULL,
  `x` int(5) NOT NULL,
  `y` int(5) NOT NULL,
  `z` int(1) NOT NULL,
  `freeroam` enum('1','0') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `message_noshouting` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT 'Shouting is not neccessary.',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `roombots`
--


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

--
-- Table structure for table `roombots_coords`
--

CREATE TABLE IF NOT EXISTS `roombots_coords` (
  `id` int(10) NOT NULL,
  `x` int(5) NOT NULL,
  `y` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `roombots_coords`
--


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

--
-- Table structure for table `roombots_texts`
--

CREATE TABLE IF NOT EXISTS `roombots_texts` (
  `id` int(10) NOT NULL,
  `type` enum('shout','say') COLLATE latin1_general_ci NOT NULL,
  `text` varchar(255) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `roombots_texts`
--


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

--
-- Table structure for table `roombots_texts_triggers`
--

CREATE TABLE IF NOT EXISTS `roombots_texts_triggers` (
  `id` int(10) NOT NULL,
  `words` text COLLATE latin1_general_ci NOT NULL,
  `replies` text COLLATE latin1_general_ci NOT NULL,
  `serve_replies` text COLLATE latin1_general_ci NOT NULL,
  `serve_item` varchar(20) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `roombots_texts_triggers`
--


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

--
-- Table structure for table `rooms`
--

CREATE TABLE IF NOT EXISTS `rooms` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `description` varchar(125) COLLATE latin1_general_ci DEFAULT NULL,
  `owner` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `category` int(3) NOT NULL DEFAULT '0',
  `model` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `ccts` text COLLATE latin1_general_ci,
  `floor` int(3) NOT NULL DEFAULT '0',
  `wallpaper` int(3) NOT NULL DEFAULT '0',
  `state` int(11) NOT NULL DEFAULT '0' COMMENT '0 = open, 1 = closed, 2 = password, 3 = hc only, 4 = staff',
  `password` varchar(15) COLLATE latin1_general_ci DEFAULT NULL,
  `showname` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '1',
  `superusers` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `visitors_now` int(3) NOT NULL DEFAULT '0',
  `visitors_max` int(3) NOT NULL DEFAULT '25',
  `landscape` decimal(2,1) NOT NULL,
  `price` int(11) NOT NULL,
  `sale` int(1) NOT NULL,
  `taxi` int(1) NOT NULL,
  `violence` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `rooms`
--


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

--
-- Table structure for table `room_ads`
--

CREATE TABLE IF NOT EXISTS `room_ads` (
  `roomid` int(10) NOT NULL,
  `img` text COLLATE latin1_general_ci NOT NULL,
  `uri` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`roomid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `room_ads`
--


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

--
-- Table structure for table `room_bans`
--

CREATE TABLE IF NOT EXISTS `room_bans` (
  `roomid` int(10) NOT NULL,
  `userid` int(10) NOT NULL,
  `ban_expire` varchar(50) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `room_bans`
--


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

--
-- Table structure for table `room_categories`
--

CREATE TABLE IF NOT EXISTS `room_categories` (
  `id` int(3) NOT NULL DEFAULT '0',
  `parent` int(3) NOT NULL DEFAULT '0',
  `type` int(1) NOT NULL DEFAULT '1',
  `name` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT 'Non-named category',
  `access_rank_min` int(2) NOT NULL,
  `access_rank_hideforlower` enum('0','1') COLLATE latin1_general_ci NOT NULL,
  `trading` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `room_categories`
--


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

--
-- Table structure for table `room_modeldata`
--

CREATE TABLE IF NOT EXISTS `room_modeldata` (
  `model` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `roomomatic_subscr_only` int(1) NOT NULL DEFAULT '0',
  `door_x` int(3) NOT NULL,
  `door_y` int(3) NOT NULL,
  `door_h` int(3) NOT NULL,
  `door_z` int(1) NOT NULL,
  `heightmap` text COLLATE latin1_general_ci NOT NULL,
  `publicroom_items` text COLLATE latin1_general_ci NOT NULL,
  `swimmingpool` enum('1','0') COLLATE latin1_general_ci NOT NULL,
  `specialcast_emitter` varchar(15) COLLATE latin1_general_ci DEFAULT NULL,
  `specialcast_interval` int(10) DEFAULT NULL,
  `specialcast_rnd_min` int(10) DEFAULT NULL,
  `specialcast_rnd_max` int(10) DEFAULT NULL,
  PRIMARY KEY (`model`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `room_modeldata`
--


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

--
-- Table structure for table `room_modeldata_triggers`
--

CREATE TABLE IF NOT EXISTS `room_modeldata_triggers` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `model` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `object` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `x` int(5) NOT NULL DEFAULT '0',
  `y` int(5) NOT NULL DEFAULT '0',
  `stepx` int(5) NOT NULL,
  `stepy` int(5) NOT NULL,
  `goalx` int(5) NOT NULL,
  `goaly` int(5) NOT NULL,
  `roomid` int(10) NOT NULL DEFAULT '0',
  `state` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `room_modeldata_triggers`
--


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

--
-- Table structure for table `room_rights`
--

CREATE TABLE IF NOT EXISTS `room_rights` (
  `roomid` int(11) NOT NULL,
  `userid` int(10) NOT NULL,
  KEY `index` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `room_rights`
--


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

--
-- Table structure for table `room_votes`
--

CREATE TABLE IF NOT EXISTS `room_votes` (
  `roomid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `vote` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `room_votes`
--


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

--
-- Table structure for table `security_log`
--

CREATE TABLE IF NOT EXISTS `security_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `ipaddress` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `event` text NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `security_log`
--


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

--
-- Table structure for table `soundmachine_playlists`
--

CREATE TABLE IF NOT EXISTS `soundmachine_playlists` (
  `machineid` int(10) NOT NULL,
  `songid` int(10) NOT NULL,
  `pos` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `soundmachine_playlists`
--


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

--
-- Table structure for table `soundmachine_songs`
--

CREATE TABLE IF NOT EXISTS `soundmachine_songs` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `userid` int(10) NOT NULL,
  `title` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `machineid` int(10) NOT NULL,
  `length` int(3) NOT NULL,
  `data` text COLLATE latin1_general_ci NOT NULL,
  `burnt` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `soundmachine_songs`
--


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

--
-- Table structure for table `system`
--

CREATE TABLE IF NOT EXISTS `system` (
  `onlinecount` int(3) NOT NULL DEFAULT '0',
  `onlinecount_peak` int(10) NOT NULL,
  `connections_accepted` int(10) NOT NULL,
  `activerooms` int(10) NOT NULL,
  `activerooms_peak` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `system`
--


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

--
-- Table structure for table `system_config`
--

CREATE TABLE IF NOT EXISTS `system_config` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `skey` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `sval` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `system_config`
--


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

--
-- Table structure for table `system_fuserights`
--

CREATE TABLE IF NOT EXISTS `system_fuserights` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `minrank` int(1) NOT NULL,
  `fuseright` varchar(100) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`,`fuseright`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `system_fuserights`
--


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

--
-- Table structure for table `system_recycler`
--

CREATE TABLE IF NOT EXISTS `system_recycler` (
  `rclr_cost` int(5) NOT NULL,
  `rclr_reward` int(10) NOT NULL,
  PRIMARY KEY (`rclr_cost`,`rclr_reward`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `system_recycler`
--


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

--
-- Table structure for table `system_stafflog`
--

CREATE TABLE IF NOT EXISTS `system_stafflog` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `action` varchar(12) COLLATE latin1_general_ci NOT NULL,
  `message` text COLLATE latin1_general_ci,
  `note` text COLLATE latin1_general_ci,
  `userid` int(11) NOT NULL,
  `targetid` int(11) DEFAULT NULL,
  `timestamp` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `system_stafflog`
--


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

--
-- Table structure for table `system_strings`
--

CREATE TABLE IF NOT EXISTS `system_strings` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `stringid` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT 'null',
  `var_en` text COLLATE latin1_general_ci,
  `var_de` text COLLATE latin1_general_ci,
  `var_nl` text COLLATE latin1_general_ci,
  PRIMARY KEY (`id`,`stringid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `system_strings`
--


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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `password` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `rank` int(1) NOT NULL DEFAULT '2',
  `email` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `birth` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `hbirth` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `figure` varchar(150) COLLATE latin1_general_ci NOT NULL,
  `sex` varchar(5) COLLATE latin1_general_ci NOT NULL,
  `mission` varchar(50) COLLATE latin1_general_ci DEFAULT 'Civilian',
  `consolemission` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `credits` int(7) NOT NULL DEFAULT '0',
  `tickets` int(5) NOT NULL DEFAULT '0',
  `badge_status` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '1',
  `lastvisit` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `figure_swim` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `user` text COLLATE latin1_general_ci,
  `postcount` bigint(20) NOT NULL DEFAULT '0',
  `ticket_sso` varchar(39) COLLATE latin1_general_ci DEFAULT NULL,
  `ipaddress_last` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `noob` int(1) NOT NULL DEFAULT '0',
  `online` int(50) NOT NULL DEFAULT '1',
  `bb_totalpoints` int(30) DEFAULT '0',
  `bb_playedgames` int(30) DEFAULT '0',
  `screen` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `rea` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `gift` smallint(2) DEFAULT NULL,
  `sort` smallint(1) DEFAULT NULL,
  `roomid` int(15) DEFAULT NULL,
  `lastgift` smallint(2) DEFAULT NULL,
  `visibility` int(1) DEFAULT '1',
  `hc_before` int(1) DEFAULT NULL,
  `newsletter` int(1) DEFAULT '1',
  `guideavailable` int(1) NOT NULL,
  `shockwaveid` text COLLATE latin1_general_ci NOT NULL,
  `guide` int(1) NOT NULL,
  `guideallowed` int(1) NOT NULL,
  `window` int(3) NOT NULL,
  `lastlogin` bigint(20) NOT NULL DEFAULT '0',
  `creditcheck` tinyint(2) NOT NULL DEFAULT '0',
  `creditgiventime` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `str` int(2) NOT NULL,
  `health` int(2) NOT NULL DEFAULT '100',
  `corp_id` int(11) NOT NULL,
  `job_rank` int(2) NOT NULL,
  `secure_id` int(11) NOT NULL,
  `onloadroom` int(6) NOT NULL DEFAULT '1',
  `arrested` int(1) NOT NULL,
  `working` int(1) NOT NULL,
  `dead` int(11) NOT NULL,
  `working_out` int(1) NOT NULL,
  `hits` int(11) NOT NULL,
  `kills` int(11) NOT NULL,
  `deaths` int(11) NOT NULL,
  `arrests` int(11) NOT NULL,
  `time_work` int(3) NOT NULL,
  `time_jail` int(3) NOT NULL,
  `time_dead` int(3) NOT NULL,
  `bank_account` int(11) NOT NULL,
  `flagged` int(1) NOT NULL,
  `time_workout` int(3) NOT NULL,
  `afk` int(1) NOT NULL,
  `private` int(1) NOT NULL,
  `game_dm` int(11) NOT NULL,
  `game_brawl` int(11) NOT NULL,
  `wanted` int(50) NOT NULL,
  `intel` int(2) NOT NULL,
  `learning` int(11) NOT NULL,
  `time_learn` int(11) NOT NULL,
  `becomenypd` int(1) NOT NULL DEFAULT '0',
  `reccomendnypd` int(1) NOT NULL DEFAULT '0',
  `cowardness` int(10) NOT NULL DEFAULT '0',
  `had_sex` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `users`
--


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

--
-- Table structure for table `users_badges`
--

CREATE TABLE IF NOT EXISTS `users_badges` (
  `userid` int(15) NOT NULL,
  `badgeid` varchar(5) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `iscurrent` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `slotid` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `badge` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`userid`,`badgeid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `users_badges`
--


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

--
-- Table structure for table `users_badgescur`
--

CREATE TABLE IF NOT EXISTS `users_badgescur` (
  `userid` int(15) NOT NULL,
  `badge1` varchar(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `badge2` varchar(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `badge3` varchar(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `badge4` varchar(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `badge5` varchar(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_badgescur`
--


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

--
-- Table structure for table `users_bans`
--

CREATE TABLE IF NOT EXISTS `users_bans` (
  `userid` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `ipaddress` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `date_expire` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `descr` text COLLATE latin1_general_ci
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `users_bans`
--


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

--
-- Table structure for table `users_club`
--

CREATE TABLE IF NOT EXISTS `users_club` (
  `userid` bigint(6) NOT NULL,
  `months_expired` int(4) DEFAULT NULL,
  `months_left` int(4) DEFAULT NULL,
  `date_monthstarted` varchar(25) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `users_club`
--


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

--
-- Table structure for table `users_favouriterooms`
--

CREATE TABLE IF NOT EXISTS `users_favouriterooms` (
  `userid` int(10) NOT NULL,
  `roomid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `users_favouriterooms`
--


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

--
-- Table structure for table `users_favourites`
--

CREATE TABLE IF NOT EXISTS `users_favourites` (
  `userid` int(10) NOT NULL,
  `roomid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `users_favourites`
--


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

--
-- Table structure for table `users_fuserights`
--

CREATE TABLE IF NOT EXISTS `users_fuserights` (
  `userid` int(15) NOT NULL,
  `fuseright` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_fuserights`
--


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

--
-- Table structure for table `users_recycler`
--

CREATE TABLE IF NOT EXISTS `users_recycler` (
  `userid` int(10) NOT NULL,
  `session_started` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `session_reward` int(10) NOT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `users_recycler`
--


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

--
-- Table structure for table `users_vip`
--

CREATE TABLE IF NOT EXISTS `users_vip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `url` varchar(150) NOT NULL,
  `amount` varchar(150) NOT NULL,
  `date` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `users_vip`
--


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

--
-- Table structure for table `user_ignores`
--

CREATE TABLE IF NOT EXISTS `user_ignores` (
  `userid` int(10) NOT NULL,
  `targetid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_ignores`
--


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

--
-- Table structure for table `vip_manage`
--

CREATE TABLE IF NOT EXISTS `vip_manage` (
  `name` varchar(80) NOT NULL,
  `payment` enum('Free','Daopay','Paypal') NOT NULL,
  `months` enum('1','2','3','4','5') NOT NULL,
  `admin` varchar(80) NOT NULL,
  `admin_lastedited` varchar(80) NOT NULL,
  `date_added` varchar(150) NOT NULL,
  `date_edited` varchar(150) NOT NULL,
  `date_expires` varchar(150) NOT NULL,
  `year_added` int(4) NOT NULL,
  `month_added` int(2) NOT NULL,
  `day_added` int(2) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vip_manage`
--


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

--
-- Table structure for table `vouchers`
--

CREATE TABLE IF NOT EXISTS `vouchers` (
  `voucher` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `type` enum('item','credits') COLLATE latin1_general_ci NOT NULL DEFAULT 'credits',
  `credits` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`voucher`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `vouchers`
--


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

--
-- Table structure for table `wanted`
--

CREATE TABLE IF NOT EXISTS `wanted` (
  `wanted` enum('') DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wanted`
--


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

--
-- Table structure for table `wordfilter`
--

CREATE TABLE IF NOT EXISTS `wordfilter` (
  `word` varchar(100) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `wordfilter`
--


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

[MentaL]

[Rejection]

Nice x] 1st Post Pwn!! (: Thanks.

---------- Post added at 09:05 PM ---------- Previous post was at 09:04 PM ----------

Oh and May i have the password?

[CJRP]

PM me.

[winterpartys]

I hate caps. Makes me wanna hack you.

[CJRP]

I hate caps. Makes me wanna hack you.

See,

I was very pissed off. So yer.

[Makarov]

er you took commands from different releases
and put them in Rasta's
this is basically Mango's Release..
I wouldn't use it either.. 3/10

[CJRP]

er you took commands from different releases
and put them in Rasta's
this is basically Mango's Release..
I wouldn't use it either.. 3/10

Err np therres some commands that i have coded -.-'


Ungratefull Sh**

[Subway]

dude you didnt even add a screenie wdf add some please.

[CJRP]

dude you didnt even add a screenie wdf add some please.

Dont trust me

LUMP It.


-.-'

[Crawl]

Err np therres some commands that i have coded -.-'


Ungratefull Sh**

You seriously need to calm down.. I don't see anything that has changed apart from a few commands which are basic.. and Yes, You should add some screenshots so people know what has changed especially the smoking bit. I would like to see what that is like without having to download it and set it up just to see what it looks like.

[CJRP]

You seriously need to calm down.. I don't see anything that has changed apart from a few commands which are basic.. and Yes, You should add some screenshots so people know what has changed especially the smoking bit. I would like to see what that is like without having to download it and set it up just to see what it looks like.

Well ive removed it now :)


Please close thread.

[Crawl]

You can close the thread yourself, Edit the main post - go advanced & close or delete thread.

[Makarov]

Err np therres some commands that i have coded -.-'


Ungratefull Sh**

You should calm down..
I doubt this emulator is any good.
You cannot stop my opinion..

[Glee]

Link dead

[Rejection]

Aww, i was wanting to test and than use for my hotel... I wish i could find a good cms and emu uber doesnt work for me ! ):

[mango2735]

Next time give creds cause certaintly u didnt code this all.

[1960s]

What exactly did you "Code" that everyone hasn't seen before? It seems sloppy, but anyway. WHAT DID YOU DO ?

Next time give creds cause certaintly u didnt code this all.

You didn't code anything in your emulator either. Please give credits to the people you got the source from. This is why major coders and coding anymore, because you leechers steal it and call it your own.

[ReDoc]

Nice release.

[mango2735]

What exactly did you "Code" that everyone hasn't seen before? It seems sloppy, but anyway. WHAT DID YOU DO ?



You didn't code anything in your emulator either. Please give credits to the people you got the source from. This is why major coders and coding anymore, because you leechers steal it and call it your own.

hey ive' looked in the emu some of the stuff i coded i r in there like 1 or 3 codes of mine. ok im nt the best coder but i advise u stfu cuz to me notin but a lousy cunt.

---------- Post added at 02:13 AM ---------- Previous post was at 02:11 AM ----------

Talkin form someone tht cant code him slef dumbass fss...

[Sojobo]

sex
oralsex
sniffcocaine
usesteroids

You're not actually serious are you? What do those commands do? Make you say something? Do they actually do anything or is it for lazy fucks who can't actually RP and should therefore not even be on an RP server?

[Ryno]

You're not actually serious are you? What do those commands do? Make you say something? Do they actually do anything or is it for lazy fucks who can't actually RP and should therefore not even be on an RP server?

Not being funny Aaron but this guy is probably 10 and thinks it makes him hardcore and everyone will be like "omg dis servar is da shiiittt!!!! imma go make lurve to piczzz off uuu!!!"

Sadly nothing like that will ever happen.

[Makarov]

You're not actually serious are you? What do those commands do? Make you say something? Do they actually do anything or is it for lazy fucks who can't actually RP and should therefore not even be on an RP server?

Sex/OralSex was made by 1960's in a un-released emulator..
while Mango made the last two

[Sojobo]

Sex/OralSex was made by 1960's in a un-released emulator..
while Mango made the last two

Do they actually do anything though or does it just make you say something?

[Crawl]

Do they actually do anything though or does it just make you say something?

I tested it, They just make you say something.

[vLife]

Maybe when we rid this section of the Half Assed people who claim they can code but simply copy, paste & edit commands. Then someone maybe will do a RP that can meet up with HabboRP Edit.

It gets boring seeing all these people who want e-peen so badly instead of actually learning a Programming language.
Be serious about a language you want to code instead of stealing others.
-.-

Sorry for the offtopic but its the truth.