Thanks!!
Michael
-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 09, 2006 at 01:52 AM
-- Server version: 4.1.13
-- PHP Version: 5.0.4
--
-- Database: `boards`
--
-- --------------------------------------------------------
--
-- Table structure for table `boards`
--
CREATE TABLE `boards` (
`board_id` mediumint(9) NOT NULL default '0',
`board_name` varchar(250) NOT NULL default '',
`board_desc` varchar(255) NOT NULL default '',
`board_cat` tinyint(4) NOT NULL default '0',
`board_viewlevel` smallint(6) NOT NULL default '0',
`board_postlevel` mediumint(9) NOT NULL default '0',
`board_createlevel` mediumint(9) NOT NULL default '0',
`board_default` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`board_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE `comments` (
`comment_id` mediumint(9) NOT NULL auto_increment,
`comment_for` mediumint(9) NOT NULL default '0',
`comment_from` mediumint(9) NOT NULL default '0',
`comment_text` text NOT NULL,
`comment_time` int(11) NOT NULL default '0',
`comment_anon` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`comment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=148 ;
-- --------------------------------------------------------
--
-- Table structure for table `drafts`
--
CREATE TABLE `drafts` (
`draft_id` int(11) NOT NULL auto_increment,
`draft_user` mediumint(9) NOT NULL default '0',
`draft_boardid` int(11) NOT NULL default '0',
`draft_topicid` mediumint(9) NOT NULL default '0',
`draft_topic` varchar(255) NOT NULL default '',
`draft_msg` text NOT NULL,
`draft_time` int(11) NOT NULL default '0',
PRIMARY KEY (`draft_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
-- --------------------------------------------------------
--
-- Table structure for table `ip_lookup`
--
CREATE TABLE `ip_lookup` (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(20) NOT NULL default '',
`hostname` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1868 ;
-- --------------------------------------------------------
--
-- Table structure for table `item_trade`
--
CREATE TABLE `item_trade` (
`trade_id` mediumint(9) NOT NULL auto_increment,
`trade_from` mediumint(9) NOT NULL default '0',
`trade_to` int(11) NOT NULL default '0',
`trade_item` varchar(70) NOT NULL default '',
`trade_time` int(11) NOT NULL default '0',
PRIMARY KEY (`trade_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;
-- --------------------------------------------------------
--
-- Table structure for table `logins`
--
CREATE TABLE `logins` (
`login_id` int(11) NOT NULL auto_increment,
`login_user` mediumint(9) NOT NULL default '0',
`login_ip` varchar(20) NOT NULL default '',
`login_time` int(11) NOT NULL default '0',
`login_attempt` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`login_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4422 ;
-- --------------------------------------------------------
--
-- Table structure for table `marked_msgs`
--
CREATE TABLE `marked_msgs` (
`mark_id` mediumint(9) NOT NULL auto_increment,
`mark_message` int(11) NOT NULL default '0',
`mark_time` int(11) NOT NULL default '0',
`mark_reason` smallint(6) NOT NULL default '0',
`mark_marker` mediumint(9) NOT NULL default '0',
`mark_comment` varchar(220) NOT NULL default '',
`mark_type` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`mark_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=100 ;
-- --------------------------------------------------------
--
-- Table structure for table `messages`
--
CREATE TABLE `messages` (
`message_id` int(11) NOT NULL auto_increment,
`message_topicid` int(11) NOT NULL default '0',
`message_boardid` int(11) NOT NULL default '0',
`message_time` int(11) NOT NULL default '0',
`message_poster` int(11) NOT NULL default '0',
`message_text` text NOT NULL,
`message_edit` text NOT NULL,
`message_status` tinyint(4) NOT NULL default '0',
`message_suggested` tinyint(4) NOT NULL default '0',
`message_ip` varchar(20) NOT NULL default '',
PRIMARY KEY (`message_id`),
KEY `message_topicid` (`message_topicid`),
KEY `message_time` (`message_time`),
KEY `message_poster` (`message_poster`),
KEY `message_status` (`message_status`),
KEY `message_boardid` (`message_boardid`),
FULLTEXT KEY `message_text` (`message_text`,`message_edit`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
-- --------------------------------------------------------
--
-- Table structure for table `mod_hist`
--
CREATE TABLE `mod_hist` (
`mod_id` int(11) NOT NULL auto_increment,
`mod_poster` int(11) NOT NULL default '0',
`mod_mod` int(11) NOT NULL default '0',
`mod_msgid` int(11) NOT NULL default '0',
`mod_msgtxt` text NOT NULL,
`mod_reason` tinyint(4) NOT NULL default '0',
`mod_topic` varchar(250) NOT NULL default '',
`mod_board` varchar(250) NOT NULL default '',
`mod_karma` smallint(6) NOT NULL default '0',
`mod_money` mediumint(9) NOT NULL default '0',
`mod_time` int(11) NOT NULL default '0',
`mod_action` varchar(50) NOT NULL default '',
`mod_contest` text NOT NULL,
`mod_reply` text NOT NULL,
`mod_status` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`mod_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=415 ;
-- --------------------------------------------------------
--
-- Table structure for table `money_hist`
--
CREATE TABLE `money_hist` (
`trans_id` mediumint(9) NOT NULL auto_increment,
`trans_transferer` mediumint(9) NOT NULL default '0',
`trans_transferee` smallint(6) NOT NULL default '0',
`trans_money` int(11) NOT NULL default '0',
`trans_time` int(11) NOT NULL default '0',
PRIMARY KEY (`trans_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=247 ;
-- --------------------------------------------------------
--
-- Table structure for table `notes`
--
CREATE TABLE `notes` (
`note_id` int(11) NOT NULL auto_increment,
`note_user` mediumint(9) NOT NULL default '0',
`note_time` int(11) NOT NULL default '0',
`note_text` text NOT NULL,
`note_status` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`note_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=549 ;
-- --------------------------------------------------------
--
-- Table structure for table `online_guests`
--
CREATE TABLE `online_guests` (
`online_id` int(11) NOT NULL auto_increment,
`online_ip` varchar(25) NOT NULL default '',
`online_time` int(11) NOT NULL default '0',
`online_lastpage` varchar(255) NOT NULL default '',
PRIMARY KEY (`online_id`),
UNIQUE KEY `online_ip` (`online_ip`)
) ENGINE=HEAP DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- Table structure for table `points_log`
--
CREATE TABLE `points_log` (
`points_id` int(11) NOT NULL auto_increment,
`points_to` int(11) NOT NULL default '0',
`points_from` int(11) NOT NULL default '0',
`points_time` int(11) NOT NULL default '0',
PRIMARY KEY (`points_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `poll_options`
--
CREATE TABLE `poll_options` (
`option_id` int(11) NOT NULL auto_increment,
`option_name` varchar(220) NOT NULL default '',
`option_poll` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=298 ;
-- --------------------------------------------------------
--
-- Table structure for table `poll_queue`
--
CREATE TABLE `poll_queue` (
`queue_id` smallint(6) NOT NULL auto_increment,
`queue_question` varchar(220) NOT NULL default '',
`queue_options` text NOT NULL,
`queue_maker` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`queue_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;
-- --------------------------------------------------------
--
-- Table structure for table `poll_votes`
--
CREATE TABLE `poll_votes` (
`vote_id` int(11) NOT NULL auto_increment,
`vote_poll` mediumint(9) NOT NULL default '0',
`vote_option` mediumint(9) NOT NULL default '0',
`vote_user` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`vote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2885 ;
-- --------------------------------------------------------
--
-- Table structure for table `polls`
--
CREATE TABLE `polls` (
`poll_id` smallint(6) NOT NULL auto_increment,
`poll_name` varchar(220) NOT NULL default '',
`poll_closed` tinyint(4) NOT NULL default '0',
`poll_stored` tinyint(4) NOT NULL default '0',
`poll_date` int(11) NOT NULL default '0',
PRIMARY KEY (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
-- --------------------------------------------------------
--
-- Table structure for table `priv_msgs`
--
CREATE TABLE `priv_msgs` (
`priv_id` int(11) NOT NULL auto_increment,
`priv_to` mediumint(9) NOT NULL default '0',
`priv_from` mediumint(9) NOT NULL default '0',
`priv_box` mediumint(9) NOT NULL default '0',
`priv_subject` varchar(255) NOT NULL default '',
`priv_text` text NOT NULL,
`priv_time` int(11) NOT NULL default '0',
`priv_status` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`priv_id`),
KEY `priv_to` (`priv_to`,`priv_box`,`priv_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=48800 ;
-- --------------------------------------------------------
--
-- Table structure for table `referrals`
--
CREATE TABLE `referrals` (
`refer_id` int(11) NOT NULL auto_increment,
`refer_user` int(11) NOT NULL default '0',
`refer_referrer` int(11) NOT NULL default '0',
`refer_time` int(11) NOT NULL default '0',
`refer_status` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`refer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `sug_hist`
--
CREATE TABLE `sug_hist` (
`sug_id` int(11) NOT NULL auto_increment,
`sug_poster` mediumint(9) NOT NULL default '0',
`sug_time` int(11) NOT NULL default '0',
`sug_mod` mediumint(9) NOT NULL default '0',
`sug_money` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`sug_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
-- --------------------------------------------------------
--
-- Table structure for table `suspensions`
--
CREATE TABLE `suspensions` (
`suspend_id` mediumint(9) NOT NULL auto_increment,
`suspend_user` mediumint(9) NOT NULL default '0',
`suspend_restore` int(11) NOT NULL default '0',
`suspend_level` smallint(6) NOT NULL default '0',
PRIMARY KEY (`suspend_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
-- --------------------------------------------------------
--
-- Table structure for table `topic_polloptions`
--
CREATE TABLE `topic_polloptions` (
`option_id` int(11) NOT NULL auto_increment,
`option_name` varchar(220) NOT NULL default '',
`option_poll` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=801 ;
-- --------------------------------------------------------
--
-- Table structure for table `topic_polls`
--
CREATE TABLE `topic_polls` (
`poll_id` smallint(6) NOT NULL auto_increment,
`poll_name` varchar(220) NOT NULL default '',
`poll_topicid` int(11) NOT NULL default '0',
PRIMARY KEY (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=215 ;
-- --------------------------------------------------------
--
-- Table structure for table `topic_pollvotes`
--
CREATE TABLE `topic_pollvotes` (
`vote_id` int(11) NOT NULL auto_increment,
`vote_poll` mediumint(9) NOT NULL default '0',
`vote_option` mediumint(9) NOT NULL default '0',
`vote_user` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`vote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2797 ;
-- --------------------------------------------------------
--
-- Table structure for table `topics`
--
CREATE TABLE `topics` (
`topic_id` int(11) NOT NULL auto_increment,
`topic_ispoll` tinyint(4) NOT NULL default '0',
`topic_name` varchar(120) NOT NULL default '',
`topic_boardid` int(11) NOT NULL default '0',
`topic_creator` int(11) NOT NULL default '0',
`topic_time` int(11) NOT NULL default '0',
`topic_status` tinyint(4) NOT NULL default '0',
`topic_sticky` tinyint(4) NOT NULL default '0',
`topic_views` int(11) NOT NULL default '0'
PRIMARY KEY (`topic_id`),
KEY `topic_boardid` (`topic_boardid`),
FULLTEXT KEY `topic_name` (`topic_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
-- --------------------------------------------------------
--
-- Table structure for table `usermaps`
--
CREATE TABLE `usermaps` (
`map_id` mediumint(9) NOT NULL auto_increment,
`map_user` mediumint(9) NOT NULL default '0',
`map_user2` mediumint(9) NOT NULL default '0',
`map_time` int(11) NOT NULL default '0',
`map_ip` varchar(20) NOT NULL default '',
PRIMARY KEY (`map_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`user_name` varchar(50) NOT NULL default '',
`user_password` varchar(50) NOT NULL default '',
`user_temp` varchar(50) NOT NULL default '',
`user_level` smallint(6) NOT NULL default '0',
`user_karma` mediumint(9) NOT NULL default '0',
`user_avaliable_respect` int(11) NOT NULL default '0',
`user_money` int(11) NOT NULL default '0',
`user_banked` mediumint(9) NOT NULL default '0',
`user_style` varchar(250) NOT NULL default 'styles/default.css',
`user_ipp` smallint(6) NOT NULL default '25',
`user_timezone` smallint(6) NOT NULL default '0',
`user_date` varchar(15) NOT NULL default 'D/M/Y g:i:sA',
`user_reg_time` int(11) NOT NULL default '0',
`user_reg_ip` varchar(20) NOT NULL default '',
`user_days_active` int(11) NOT NULL default '0',
`user_last_active` int(11) NOT NULL default '0',
`user_last_ip` varchar(20) NOT NULL default '',
`user_last_isp` varchar(50) NOT NULL default '',
`user_last_page` varchar(250) NOT NULL default '',
`user_last_agent` varchar(250) NOT NULL default '',
`user_privemail` varchar(120) NOT NULL default '',
`user_pubemail` varchar(120) NOT NULL default '',
`user_im` varchar(100) NOT NULL default '',
`user_sig` text NOT NULL,
`user_quote` text NOT NULL,
`user_about` text NOT NULL,
`user_hobbies` text NOT NULL,
`user_favmusic` text NOT NULL,
`user_favtv` text NOT NULL,
`user_favgames` text NOT NULL,
`user_img` int(11) NOT NULL default '0',
`user_tpcview` varchar(40) NOT NULL default 'default',
`user_msgview` varchar(25) NOT NULL default 'default',
`user_invisible` tinyint(4) NOT NULL default '0',
`user_contacts` text NOT NULL,
`user_tags` text NOT NULL,
`user_favorites` text NOT NULL,
`user_quicklinks` text NOT NULL,
`user_security` tinyint(4) NOT NULL default '0',
`user_avatar` varchar(170) NOT NULL default '',
`user_pubcom` tinyint(4) NOT NULL default '0',
`user_beta` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Table structure for table `items`
--
CREATE TABLE `items` (
`item_id` smallint(6) NOT NULL auto_increment,
`item_name` varchar(70) NOT NULL default '',
`item_cat` smallint(6) NOT NULL default '0',
`item_cost` int(11) NOT NULL default '0',
`item_stock` mediumint(9) NOT NULL default '0',
`item_shortdesc` varchar(255) NOT NULL default '',
`item_code` varchar(35) NOT NULL default '',
`item_store` tinyint(4) NOT NULL default '0',
`item_buyers` text NOT NULL,
`user_avaliable_respect` int(11) NOT NULL default '0',
PRIMARY KEY (`item_id`),
KEY `item_code` (`item_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
--
-- Dumping data for table `items`
--
INSERT INTO `items` VALUES (2, 'HTML: Acronym', 1, 400, 75, 'HTML: Acronym allows you to make use of the acronym tag. <acr>Acronym(Meaning)</acr>', 'HTML_ACRONYM', 1, '', 0);
INSERT INTO `items` VALUES (3, 'Post Faster', 2, 650, 30, 'Post Faster allows you to post 3 more messages per minute.', 'POST_FAST', 1, '', 0);
INSERT INTO `items` VALUES (4, 'Credit Card', 3, 220, 30, 'The credit card allows you to borrow cash for use in the store.', 'CREDIT_CARD', 1, '', 0);
INSERT INTO `items` VALUES (5, 'HTML: Lists', 1, 400, 75, 'Allows usage of the following tags: ul, ol, li, dd, dt, dl', 'HTML_LIST', 1, '', 0);
INSERT INTO `items` VALUES (6, 'HTML: Format', 1, 300, 50, 'Allows you to use the following tags: blockquote, p, q, pre, hr', 'HTML_FORMAT', 1, '', 0);
INSERT INTO `items` VALUES (7, 'HTML: Code', 1, 300, 50, 'Allows you to use the code tag in your posts.', 'HTML_CODE', 1, '', 0);
INSERT INTO `items` VALUES (8, 'HTML: Images', 1, 3000, 30, 'Allows you to post images using the pic tag.', 'HTML_IMAGE', 1, '', 0);
INSERT INTO `items` VALUES (9, 'Invisible Login', 3, 1300, 25, 'Adds option to your display options enabling you to remove yourself from the online users list.', 'INVISIBLE', 1, '', 0);
INSERT INTO `items` VALUES (10, 'Stalker', 2, 700, 30, 'Allows you to view a users last viewed page.', 'STALKER', 1, '', 0);
INSERT INTO `items` VALUES (11, 'OGFiles: 5MB', 3, 400, 60, 'Gives you 5MB extra for use with OGFiles', 'FILES_5MB', 1, '', 0);
INSERT INTO `items` VALUES (12, 'Smilies', 2, 500, 100, 'Allows you to use smilies in your posts', 'SMILIES', 1, '', 0);
INSERT INTO `items` VALUES (13, 'Nametag', 3, 600, 20, 'Nametag adds an option to your user info page which allows you to change your username ONCE.', 'NAMETAG', 1, '', 0);
INSERT INTO `items` VALUES (14, 'HTML: Embed', 1, 5000, 15, 'HTML Embed allows you to embed stuff using the embed tag.', 'HTML_EMBED', 1, '', 0);
INSERT INTO `items` VALUES (15, 'Omega Key', 3, 0, 50, 'This legendrary allows the bearer access to The Gateway, board 777.', 'OMEGA_KEY', 0, '', 0);
INSERT INTO `items` VALUES (17, 'HTML: Small', 1, 400, 75, 'HTML Small allows you to make use of the <small> tag.', 'HTML_SMALL', 1, '', 0);
INSERT INTO `items` VALUES (18, 'HTML: Links', 1, 350, 100, 'Allows use to create hyperlinks. Usage: <link>URL(Title)</link>', 'HTML_LINKS', 1, '', 0);
INSERT INTO `items` VALUES (28, 'HTML: Big', 1, 250, 100, 'Allows you to use the big tag to post bigger text.', 'HTML_BIG', 1, '', 0);
INSERT INTO `items` VALUES (29, 'HTML: Tables', 1, 700, 30, 'Allows the user to format their message using table tags (table, tr, td, th)', 'HTML_TABLES', 1, '', 0);
INSERT INTO `items` VALUES (30, 'HTML: Strikethrough', 1, 200, 100, 'Allows use of the <s> tag to make striked text.', 'HTML_STRIKE', 1, '', 0);
--
-- Table structure for table `levels`
--
CREATE TABLE `levels` (
`level_num` mediumint(9) NOT NULL default '0',
`level_name` varchar(255) NOT NULL default '',
`level_desc` text NOT NULL,
`level_req` varchar(30) NOT NULL default '',
PRIMARY KEY (`level_num`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`user_name` varchar(50) NOT NULL default '',
`user_password` varchar(50) NOT NULL default '',
`user_temp` varchar(50) NOT NULL default '',
`user_level` smallint(6) NOT NULL default '0',
`user_karma` mediumint(9) NOT NULL default '0',
`user_avaliable_respect` int(11) NOT NULL default '0',
`user_money` int(11) NOT NULL default '0',
`user_banked` mediumint(9) NOT NULL default '0',
`user_style` varchar(250) NOT NULL default 'styles/default.css',
`user_ipp` smallint(6) NOT NULL default '25',
`user_timezone` smallint(6) NOT NULL default '0',
`user_date` varchar(15) NOT NULL default 'd/m/y g:i:sA',
`user_reg_time` int(11) NOT NULL default '0',
`user_reg_ip` varchar(20) NOT NULL default '',
`user_days_active` int(11) NOT NULL default '0',
`user_last_active` int(11) NOT NULL default '0',
`user_last_ip` varchar(20) NOT NULL default '',
`user_last_isp` varchar(50) NOT NULL default '',
`user_last_page` varchar(250) NOT NULL default '',
`user_last_agent` varchar(250) NOT NULL default '',
`user_privemail` varchar(120) NOT NULL default '',
`user_pubemail` varchar(120) NOT NULL default '',
`user_im` varchar(100) NOT NULL default '',
`user_sig` text NOT NULL,
`user_quote` text NOT NULL,
`user_about` text NOT NULL,
`user_hobbies` text NOT NULL,
`user_favmusic` text NOT NULL,
`user_favtv` text NOT NULL,
`user_favgames` text NOT NULL,
`user_img` int(11) NOT NULL default '0',
`user_tpcview` varchar(40) NOT NULL default 'default',
`user_msgview` varchar(25) NOT NULL default 'default',
`user_profileview` tinyint(4) NOT NULL default '0',
`user_invisible` tinyint(4) NOT NULL default '0',
`user_contacts` text NOT NULL,
`user_tags` text NOT NULL,
`user_favorites` text NOT NULL,
`user_quicklinks` text NOT NULL,
`user_security` tinyint(4) NOT NULL default '0',
`user_avatar` varchar(170) NOT NULL default '',
`user_pubcom` tinyint(4) NOT NULL default '0',
`user_beta` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `levels` VALUES (70, 'Developers', 'Developers are responsible for the cutting edge in DP development', '');
INSERT INTO `levels` VALUES (60, 'Administrator', 'Administrators are responsible for banning, suspending and overall control the boards', '');
INSERT INTO `levels` VALUES (53, 'Lead Moderator', 'Lead Moderators are responsible for some board administration duties', '');
INSERT INTO `levels` VALUES (52, 'Moderator', 'Moderators can delete/reward posts and suspend users', '');
INSERT INTO `levels` VALUES (47, 'Coder', 'Codes new features abilites for the site.', '');
INSERT INTO `levels` VALUES (46, 'Graphics Designer', 'Designs logos and images for the site.', '');
INSERT INTO `levels` VALUES (45, 'VIP', 'User is a confirmed highly important part of DP and its operation.', 'null');
INSERT INTO `levels` VALUES (34, 'Icon', 'Users with at least 150 Karma.', '600');
INSERT INTO `levels` VALUES (33, 'Elite', 'Users with at least 350 Karma.', '350');
INSERT INTO `levels` VALUES (32, 'Legend', 'Awarded to users with at least 230 Karma.', '230');
INSERT INTO `levels` VALUES (25, 'Veteran', 'Users with at least 150 Karma.', '150');
INSERT INTO `levels` VALUES (22, 'Experienced User', 'Awarded to users with at least 100 Karma. Can now use DPFiles to upload files.', 'null');
INSERT INTO `levels` VALUES (21, 'Long Time User', 'Awarded to users with at least 70 Points. Can now use the edit post feature.', '70');
INSERT INTO `levels` VALUES (20, 'Frequent User', 'Awarded to users with at least 50 Karma. Can now "tag" topics with the "tag" button.', '50');
INSERT INTO `levels` VALUES (18, 'Regular User', 'Awarded to users with at least 30 Karma. Can now use the Kudos Bank and Kudos Shop.', 'null');
INSERT INTO `levels` VALUES (15, 'Average User', 'Awarded to users with at least 15 Karma. Can now mark messages for moderation ands use the private-messaging system.', '15');
INSERT INTO `levels` VALUES (12, 'New User', 'Awarded to users with at least 1 Respect Point. Can delete own messages and close topics.', '1');
INSERT INTO `levels` VALUES (10, 'Provisional', 'Account recently made. Upgraded to New User with 24 hours of positive Karma.', 'null');
INSERT INTO `levels` VALUES (5, 'Warned', 'User is on probation for one or more major ToS violations. Restored after 24 hours.', '');
INSERT INTO `levels` VALUES (4, 'Purgatory', 'Comptabaility level', '');
INSERT INTO `levels` VALUES (-2, 'Banned', 'This user has been banned for one more more major violations of the ToS. They will <strong>very</strong> rarely be restored.', '');
INSERT INTO `levels` VALUES (-4, 'Closed', 'Old level', '');
INSERT INTO `levels` VALUES (-5, 'Owned', 'User got served by the administration.', '');
INSERT INTO `levels` VALUES (-9, 'Permabanned', 'User has been banned from posting messages for one or more serious Terms of Service violations. User account will not be restored under any circumstances.', '');