• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

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

Status
Not open for further replies.
CJRP

CJRP

Junior Spellweaver
Joined
Jan 8, 2010
Messages
119
Reaction score
3
RIGHT 3RD TIME LUCKY ( PAST 2 TIMES IVE ACCIDENTLY CLOSED THIS :mad:) RIGHT IM RELEASING MY RP SERVER

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


FOUND AT
You must be registered to see links

You must be registered to see links


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
Code: 
: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
Code: 
-- 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 */;
 
The Best DDoS Protected Servers
R

Rejection

Newbie Spellweaver
Joined
Dec 22, 2009
Messages
32
Reaction score
0
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

CJRP

Junior Spellweaver
Joined
Jan 8, 2010
Messages
119
Reaction score
3
Cobe said:
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
Click to expand...

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


Ungratefull Sh**
 
S

Subway

Custom Title Activated
Loyal Member
Joined
Jan 25, 2009
Messages
1,539
Reaction score
4
dude you didnt even add a screenie wdf add some please.
 
Crawl

Crawl

Crawl Me Maybe
Loyal Member
1000 Posts 10 Happy Years
Joined
Aug 18, 2009
Messages
1,420
Reaction score
386
CJRP said:
Err np therres some commands that i have coded -.-'


Ungratefull Sh**
Click to expand...


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.
 
Last edited:
CJRP

CJRP

Junior Spellweaver
Joined
Jan 8, 2010
Messages
119
Reaction score
3
Crawl said:
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.
Click to expand...

Well ive removed it now :)


Please close thread.
 
R

Rejection

Newbie Spellweaver
Joined
Dec 22, 2009
Messages
32
Reaction score
0
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 ! ):
 
1960s

1960s

Newbie Spellweaver
Joined
Sep 20, 2009
Messages
37
Reaction score
1
What exactly did you "Code" that everyone hasn't seen before? It seems sloppy, but anyway. WHAT DID YOU DO ?


mango2735 said:
Next time give creds cause certaintly u didnt code this all.
Click to expand...
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.
 
Last edited:
mango2735

mango2735

Junior Spellweaver
10 Happy Years
Joined
Jun 5, 2010
Messages
149
Reaction score
7
1960s said:
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.
Click to expand...
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 punt.

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

Talkin form someone tht cant code him slef dumbass fss...
 
Last edited:
Status
Not open for further replies.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
150
Guests online
11,879
Total visitors
12,029
Totals may include hidden visitors.

Forum statistics

Threads
429,198
Messages
4,590,913
Members
281,305
Latest member
ismodev
Most visitors online was 12720 , on 2 May 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top