Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

MySQL Error when querying


  • Please log in to reply

#1
MR0624

MR0624

    Member

  • Member
  • PipPipPip
  • 365 posts
I dunno a thing about mysql and when i punched this code in to query it it found errors at the end of every table relating to ") ENGINE=MyISAM DEFAULT CHARSET=latin1;" i have NO CLUE what's wrong with this. The mysql server is set to the defaults of any mysql server since i haven't edited it since i bought it. Any ideas of what might be wrong?

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.', '');
  • 0

Advertisements







Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP