Blah

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    Blah

    lol, I got the majority of the scotspaul2 script as people seem ta call it pmpl

    might stick it up bit later for those who want it......

    Tags: None
    #2
    Just the sql file would be great Rob thanks lol
    :p:p:p

    Comment

      #3
      Ok For Those Who Wanted It,

      Scotspaul2 Database Complete N Fixed.........

      Code:
      -- Table structure for table `banned`
-- 

DROP TABLE IF EXISTS `banned`;
CREATE TABLE IF NOT EXISTS `banned` (
  `username` varchar(17) NOT NULL default '',
  `reason` varchar(100) NOT NULL default '',
  `banner` varchar(17) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `banned`
-- 


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

-- 
-- Table structure for table `bkmsgs`
-- 

DROP TABLE IF EXISTS `bkmsgs`;
CREATE TABLE IF NOT EXISTS `bkmsgs` (
  `id` smallint(6) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `msg` varchar(200) NOT NULL default '',
  `username` varchar(20) NOT NULL default '',
  `date` varchar(50) NOT NULL default '',
  `time` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=235;

-- 
-- Dumping data for table `bkmsgs`
-- 


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

-- 
-- Table structure for table `blogs`
-- 

DROP TABLE IF EXISTS `blogs`;
CREATE TABLE IF NOT EXISTS `blogs` (
  `id` smallint(6) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `title` varchar(200) NOT NULL default '',
  `text` varchar(200) NOT NULL default '',
  `date` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

-- 
-- Dumping data for table `blogs`
-- 


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

-- 
-- Table structure for table `buddylist`
-- 

DROP TABLE IF EXISTS `buddylist`;
CREATE TABLE IF NOT EXISTS `buddylist` (
  `id` bigint(6) NOT NULL auto_increment,
  `username1` varchar(17) default NULL,
  `username2` varchar(17) default NULL,
  `approved` char(2) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4;

-- 
-- Dumping data for table `buddylist`
-- 

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

-- 
-- Table structure for table `chat`
-- 

DROP TABLE IF EXISTS `chat`;
CREATE TABLE IF NOT EXISTS `chat` (
  `id` bigint(12) NOT NULL auto_increment,
  `username` varchar(17) NOT NULL default '',
  `type` tinyint(7) NOT NULL default '0',
  `towhere` varchar(15) NOT NULL default '',
  `message` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2946;

-- 
-- Dumping data for table `chat`
-- 

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

-- 
-- Table structure for table `chatusers`
-- 

DROP TABLE IF EXISTS `chatusers`;
CREATE TABLE IF NOT EXISTS `chatusers` (
  `id` mediumint(5) NOT NULL auto_increment,
  `username` varchar(17) NOT NULL default '',
  `where_they` varchar(15) NOT NULL default '',
  `time` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=743;

-- 
-- Dumping data for table `chatusers`
-- 


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

-- 
-- Table structure for table `clock`
-- 

DROP TABLE IF EXISTS `clock`;
CREATE TABLE IF NOT EXISTS `clock` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`time`),
  UNIQUE KEY `name` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `clock`
-- 


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

-- 
-- Table structure for table `dating`
-- 

DROP TABLE IF EXISTS `dating`;
CREATE TABLE IF NOT EXISTS `dating` (
  `id` mediumint(4) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `cat` char(3) NOT NULL default '',
  `aboutme` varchar(200) NOT NULL default '',
  `lookingfor` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

-- 
-- Dumping data for table `dating`
-- 


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

-- 
-- Table structure for table `devices`
-- 

DROP TABLE IF EXISTS `devices`;
CREATE TABLE IF NOT EXISTS `devices` (
  `id` mediumint(7) NOT NULL auto_increment,
  `deviceid` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

-- 
-- Dumping data for table `devices`
-- 


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

-- 
-- Table structure for table `forum`
-- 

DROP TABLE IF EXISTS `forum`;
CREATE TABLE IF NOT EXISTS `forum` (
  `id` mediumint(4) NOT NULL auto_increment,
  `username` varchar(17) default NULL,
  `date` datetime default NULL,
  `lastreply` datetime default NULL,
  `reply_amount` smallint(5) unsigned default NULL,
  `subject` varchar(20) default NULL,
  `message` varchar(255) default NULL,
  `forum` varchar(40) default NULL,
  `haspoll` varchar(5) NOT NULL default 'no',
  `pass` varchar(22) NOT NULL default '',
  `choices` varchar(8) NOT NULL default '',
  `views` varchar(5) NOT NULL default '0',
  `locked` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13;

-- 
-- Dumping data for table `forum`
-- 

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

-- 
-- Table structure for table `forumindex`
-- 

DROP TABLE IF EXISTS `forumindex`;
CREATE TABLE IF NOT EXISTS `forumindex` (
  `id` mediumint(5) NOT NULL auto_increment,
  `forum` varchar(10) NOT NULL default '',
  `position` smallint(3) NOT NULL default '0',
  `access` char(2) NOT NULL default '',
  `display` varchar(20) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5;

-- 
-- Dumping data for table `forumindex`
-- 

INSERT INTO `forumindex` VALUES (1, '7355406643', 1, '1', '*Admin*');
INSERT INTO `forumindex` VALUES (3, 'General', 2, '0', '*General*');
INSERT INTO `forumindex` VALUES (4, 'Newbies', 3, '0', '*Newbies*');

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

-- 
-- Table structure for table `forumpoll`
-- 

DROP TABLE IF EXISTS `forumpoll`;
CREATE TABLE IF NOT EXISTS `forumpoll` (
  `id` mediumint(10) NOT NULL auto_increment,
  `question` varchar(200) NOT NULL default '',
  `choice1` varchar(50) NOT NULL default '',
  `choice2` varchar(50) NOT NULL default '',
  `choice3` varchar(50) NOT NULL default '',
  `choice4` varchar(50) NOT NULL default '',
  `choice5` varchar(50) NOT NULL default '',
  `result1` varchar(6) NOT NULL default '',
  `result2` varchar(6) NOT NULL default '',
  `result3` varchar(6) NOT NULL default '',
  `result4` varchar(6) NOT NULL default '',
  `result5` varchar(6) NOT NULL default '',
  `pass` varchar(22) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

-- 
-- Dumping data for table `forumpoll`
-- 


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

-- 
-- Table structure for table `highest`
-- 

DROP TABLE IF EXISTS `highest`;
CREATE TABLE IF NOT EXISTS `highest` (
  `id` char(3) NOT NULL default '',
  `highest` mediumint(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `highest`
-- 

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

-- 
-- Table structure for table `hits`
-- 

DROP TABLE IF EXISTS `hits`;
CREATE TABLE IF NOT EXISTS `hits` (
  `page` varchar(15) NOT NULL default '',
  `hits` mediumint(23) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `hits`
-- 

INSERT INTO `hits` VALUES ('verify', 22);
INSERT INTO `hits` VALUES ('welcome', 295);
INSERT INTO `hits` VALUES ('welcome', 295);

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

-- 
-- Table structure for table `ignorelist`
-- 

DROP TABLE IF EXISTS `ignorelist`;
CREATE TABLE IF NOT EXISTS `ignorelist` (
  `id` mediumint(6) NOT NULL auto_increment,
  `username1` varchar(17) default NULL,
  `username2` varchar(17) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

-- 
-- Dumping data for table `ignorelist`
-- 


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

-- 
-- Table structure for table `inbox`
-- 

DROP TABLE IF EXISTS `inbox`;
CREATE TABLE IF NOT EXISTS `inbox` (
  `id` mediumint(200) NOT NULL auto_increment,
  `from_who` varchar(17) NOT NULL default '',
  `to_who` varchar(17) NOT NULL default '',
  `title` varchar(15) NOT NULL default '',
  `message` blob NOT NULL,
  `been_read` varchar(5) NOT NULL default 'no',
  `archive` varchar(5) NOT NULL default 'no',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `password2` varchar(12) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=261;

-- 
-- Dumping data for table `inbox`
-- 

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

-- 
-- Table structure for table `latest`
-- 

DROP TABLE IF EXISTS `latest`;
CREATE TABLE IF NOT EXISTS `latest` (
  `ip` varchar(15) NOT NULL default '',
  `time` int(15) NOT NULL default '0',
  `cameonline` int(15) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `latest`
-- 
-- --------------------------------------------------------

-- 
-- Table structure for table `megastats`
-- 

DROP TABLE IF EXISTS `megastats`;
CREATE TABLE IF NOT EXISTS `megastats` (
  `username` varchar(20) NOT NULL default '',
  `pmsent` int(20) NOT NULL default '0',
  `forumreply` int(20) NOT NULL default '0',
  `forumtopic` int(20) NOT NULL default '0',
  `points` int(20) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `megastats`
-- 
-- --------------------------------------------------------

-- 
-- Table structure for table `members`
-- 

DROP TABLE IF EXISTS `members`;
CREATE TABLE IF NOT EXISTS `members` (
  `id` mediumint(7) NOT NULL auto_increment,
  `username` varchar(17) NOT NULL default '',
  `password` varchar(10) NOT NULL default '',
  `owner` tinyint(2) NOT NULL default '0',
  `admin` tinyint(2) NOT NULL default '0',
  `stars` tinyint(2) NOT NULL default '0',
  `forumadmin` tinyint(2) NOT NULL default '0',
  `banned` tinyint(2) NOT NULL default '0',
  `phone` varchar(120) NOT NULL default '',
  `subno` varchar(90) NOT NULL default '',
  `registerdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastloggedin` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastpost` varchar(15) NOT NULL default '',
  `email` varchar(30) NOT NULL default '',
  `validation` tinyint(2) NOT NULL default '0',
  `fp` tinyint(2) NOT NULL default '0',
  `ban` tinyint(2) NOT NULL default '0',
  `unban` tinyint(2) NOT NULL default '0',
  `deletem` tinyint(2) NOT NULL default '0',
  `deletepms` tinyint(2) NOT NULL default '0',
  `pass` tinyint(2) NOT NULL default '0',
  `pmname` varchar(17) NOT NULL default 'P.M',
  `buddyname` varchar(10) NOT NULL default 'Buddy',
  `validated` varchar(4) NOT NULL default 'no',
  `visit` mediumint(22) NOT NULL default '0',
  `device` varchar(10) NOT NULL default '',
  `gamepoints` smallint(100) NOT NULL default '0',
  `shy` varchar(4) NOT NULL default 'no',
  `turnpm` char(2) NOT NULL default '0',
  `colour` varchar(25) default NULL,
  `tosee` char(3) NOT NULL default '',
  `forumtools` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4;

-- 
-- Dumping data for table `members`
-- 
-- --------------------------------------------------------

-- 
-- Table structure for table `mood`
-- 

DROP TABLE IF EXISTS `mood`;
CREATE TABLE IF NOT EXISTS `mood` (
  `id` mediumint(6) NOT NULL auto_increment,
  `username` varchar(17) default NULL,
  `mood` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3;

-- 
-- Dumping data for table `mood`
-- 
-- --------------------------------------------------------

-- 
-- Table structure for table `notify`
-- 

DROP TABLE IF EXISTS `notify`;
CREATE TABLE IF NOT EXISTS `notify` (
  `id` mediumint(10) NOT NULL auto_increment,
  `username1` varchar(17) NOT NULL default '',
  `username2` varchar(17) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12;

-- 
-- Dumping data for table `notify`
-- 


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

-- 
-- Table structure for table `outbox`
-- 

DROP TABLE IF EXISTS `outbox`;
CREATE TABLE IF NOT EXISTS `outbox` (
  `id` mediumint(200) NOT NULL auto_increment,
  `from_who` varchar(17) NOT NULL default '',
  `to_who` varchar(17) NOT NULL default '',
  `title` varchar(15) NOT NULL default '',
  `message` blob NOT NULL,
  `been_read` varchar(5) NOT NULL default 'no',
  `archive` varchar(5) NOT NULL default 'no',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `password2` varchar(12) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=108;

-- 
-- Dumping data for table `outbox`
-- 
-- --------------------------------------------------------

-- 
-- Table structure for table `privatemessage`
-- 

DROP TABLE IF EXISTS `privatemessage`;
CREATE TABLE IF NOT EXISTS `privatemessage` (
  `id` bigint(6) NOT NULL auto_increment,
  `to_username` varchar(17) default NULL,
  `from_username` varchar(17) default NULL,
  `date_sent` datetime default NULL,
  `has_it_been_read` varchar(16) default NULL,
  `pm_message` varchar(255) default NULL,
  `spamfree` char(2) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17;

-- 
-- Dumping data for table `privatemessage`
-- 
-- --------------------------------------------------------

-- 
-- Table structure for table `profile`
-- 

DROP TABLE IF EXISTS `profile`;
CREATE TABLE IF NOT EXISTS `profile` (
  `id` mediumint(7) NOT NULL auto_increment,
  `username` varchar(17) NOT NULL default '',
  `name` varchar(17) NOT NULL default '',
  `age` smallint(3) NOT NULL default '0',
  `sex` varchar(7) NOT NULL default '',
  `location` varchar(12) NOT NULL default '',
  `about` varchar(255) NOT NULL default '',
  `picture` varchar(100) NOT NULL default '',
  `onlinetime` bigint(255) NOT NULL default '0',
  `here` varchar(80) NOT NULL default '',
  `page` varchar(50) NOT NULL default '',
  `showon` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4;

-- 
-- Dumping data for table `profile`
-- 

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

-- 
-- Table structure for table `rateme`
-- 

DROP TABLE IF EXISTS `rateme`;
CREATE TABLE IF NOT EXISTS `rateme` (
  `id` int(255) NOT NULL auto_increment,
  `username` varchar(100) NOT NULL default '',
  `total` int(100) NOT NULL default '0',
  `amount` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4;

-- 
-- Dumping data for table `rateme`
-- 

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

-- 
-- Table structure for table `ratemelog`
-- 

DROP TABLE IF EXISTS `ratemelog`;
CREATE TABLE IF NOT EXISTS `ratemelog` (
  `id` int(30) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `who` varchar(30) NOT NULL default '',
  `total` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2;

-- 
-- Dumping data for table `ratemelog`
-- 

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

-- 
-- Table structure for table `replies`
-- 

DROP TABLE IF EXISTS `replies`;
CREATE TABLE IF NOT EXISTS `replies` (
  `id` bigint(4) NOT NULL auto_increment,
  `subject_id` varchar(10) default NULL,
  `username` varchar(17) default NULL,
  `date` datetime default NULL,
  `reply_number` smallint(5) unsigned default NULL,
  `message` varchar(255) default NULL,
  `forum` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3;

-- 
-- Dumping data for table `replies`
-- 

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

-- 
-- Table structure for table `shoutbox`
-- 

DROP TABLE IF EXISTS `shoutbox`;
CREATE TABLE IF NOT EXISTS `shoutbox` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` varchar(17) default NULL,
  `message` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2;

-- 
-- Dumping data for table `shoutbox`
-- 


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

-- 
-- Table structure for table `spamfilter`
-- 

DROP TABLE IF EXISTS `spamfilter`;
CREATE TABLE IF NOT EXISTS `spamfilter` (
  `id` int(100) NOT NULL auto_increment,
  `word1` varchar(80) NOT NULL default '',
  `word2` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

-- 
-- Dumping data for table `spamfilter`
-- 


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

-- 
-- Table structure for table `toplist`
-- 

DROP TABLE IF EXISTS `toplist`;
CREATE TABLE IF NOT EXISTS `toplist` (
  `id` int(4) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `pass` varchar(30) NOT NULL default '',
  `mail` varchar(100) NOT NULL default '',
  `link` varchar(150) NOT NULL default '',
  `logo` varchar(150) default NULL,
  `cat` varchar(20) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastout` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastin` datetime NOT NULL default '0000-00-00 00:00:00',
  `incoming` int(10) NOT NULL default '0',
  `out` int(10) NOT NULL default '0',
  `total` int(10) NOT NULL default '0',
  `description` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=98;

-- 
-- Dumping data for table `toplist`
-- 

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

INSERT INTO `hits` (`page`, `hits`) VALUES ('welcome', '0');

      Comment

        #4
        Ok thats the database for the colour script lol now can we have the colour script please? Pretty please?

        Comment

        Previous template Next
        Working...
        X