-- 
-- Table structure for table `advertisers`
-- 

CREATE TABLE `advertisers` (
  `advertiserid` int(10) unsigned NOT NULL auto_increment,
  `advertiseremail` text NOT NULL,
  `advertisercontact` text NOT NULL,
  `advertisername` text NOT NULL,
  `advertiserurl` text NOT NULL,
  PRIMARY KEY  (`advertiserid`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `adzones`
-- 

CREATE TABLE `adzones` (
  `zoneid` int(10) unsigned NOT NULL auto_increment,
  `zonedescription` text NOT NULL,
  PRIMARY KEY  (`zoneid`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `banned`
-- 

CREATE TABLE `banned` (
  `ipaddress` text NOT NULL,
  `banneddate` text NOT NULL
) TYPE=MyISAM;

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

-- 
-- Table structure for table `banners`
-- 

CREATE TABLE `banners` (
  `bannerid` int(10) unsigned NOT NULL auto_increment,
  `bannerwidth` int(11) NOT NULL default '0',
  `bannerheight` int(11) NOT NULL default '0',
  `bannerstatus` int(11) NOT NULL default '0',
  `bannerhits` int(11) NOT NULL default '0',
  `bannerviews` int(11) NOT NULL default '0',
  `bannercustom` text NOT NULL,
  `adzone1` int(11) NOT NULL default '0',
  `adzone2` int(11) NOT NULL default '0',
  `adzone3` int(11) NOT NULL default '0',
  `trackhits` int(11) NOT NULL default '0',
  `advertiserid` int(11) NOT NULL default '0',
  `banneralt` text NOT NULL,
  `bannerlocation` text NOT NULL,
  `bannerlinkto` text NOT NULL,
  `bannertype` int(11) NOT NULL default '1',
  `bannerdescription` text NOT NULL,
  PRIMARY KEY  (`bannerid`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `categories`
-- 

CREATE TABLE `categories` (
  `catid` int(10) unsigned NOT NULL auto_increment,
  `catname` text NOT NULL,
  `catdesc` text NOT NULL,
  `catkeywords` text NOT NULL,
  PRIMARY KEY  (`catid`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `comments`
-- 

CREATE TABLE `comments` (
  `commentid` int(10) unsigned NOT NULL auto_increment,
  `gameid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `comment` text NOT NULL,
  `date` date NOT NULL default '0000-00-00',
  `ipaddress` varchar(16) NOT NULL default '',
  PRIMARY KEY  (`commentid`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `custompages`
-- 

CREATE TABLE `custompages` (
  `pageid` int(10) unsigned NOT NULL auto_increment,
  `pagetitle` text NOT NULL,
  `pagekeywords` text NOT NULL,
  `pagedescription` text NOT NULL,
  `pagecontent` text NOT NULL,
  PRIMARY KEY  (`pageid`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `games`
-- 

CREATE TABLE `games` (
  `gameid` int(10) unsigned NOT NULL auto_increment,
  `gametitle` text NOT NULL,
  `gamedesc` text NOT NULL,
  `gamekeywords` text NOT NULL,
  `gamefile` text NOT NULL,
  `gameheight` int(11) NOT NULL default '0',
  `gamewidth` int(11) NOT NULL default '0',
  `category` int(11) NOT NULL default '0',
  `timesplayed` int(11) NOT NULL default '0',
  `totalvotes` int(11) NOT NULL default '0',
  `totalvotepoints` int(11) NOT NULL default '0',
  `rating` int(11) NOT NULL default '0',
  `gameicon` text NOT NULL,
  `gamestatus` int(11) NOT NULL default '0',
  `playedtoday` int(11) NOT NULL default '0',
  `gamelocation` int(11) NOT NULL default '0',
  `iconlocation` int(11) NOT NULL default '0',
  `instructions` text NOT NULL,
  `filetype` int(11) NOT NULL default '1',
  `customcode` text NOT NULL,
  PRIMARY KEY  (`gameid`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `links`
-- 

CREATE TABLE `links` (
  `websiteid` int(10) unsigned NOT NULL auto_increment,
  `websitename` text NOT NULL,
  `websiteurl` text NOT NULL,
  `emailaddress` text NOT NULL,
  `dayin` int(10) unsigned NOT NULL default '0',
  `totalin` int(10) unsigned NOT NULL default '0',
  `description` mediumtext NOT NULL,
  `alwayslisted` int(11) NOT NULL default '0',
  `linkstatus` int(11) NOT NULL default '0',
  PRIMARY KEY  (`websiteid`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `messages`
-- 

CREATE TABLE `messages` (
  `messageid` int(11) unsigned NOT NULL auto_increment,
  `fromuserid` int(11) NOT NULL default '0',
  `touserid` int(11) NOT NULL default '0',
  `messagetext` text NOT NULL,
  `sentdate` text NOT NULL,
  `messagestatus` int(11) NOT NULL default '0',
  `fromuserip` text NOT NULL,
  `messagesubject` text NOT NULL,
  PRIMARY KEY  (`messageid`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `newsletters`
-- 

CREATE TABLE `newsletters` (
  `nlid` int(10) unsigned NOT NULL auto_increment,
  `nlsubject` text NOT NULL,
  `nlcontent` text NOT NULL,
  `nltype` int(11) NOT NULL default '0',
  `nlstatus` int(11) NOT NULL default '0',
  `nlsentdate` text,
  PRIMARY KEY  (`nlid`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `online_users`
-- 

CREATE TABLE `online_users` (
  `userid` int(10) unsigned default NULL,
  `userip` varchar(16) default NULL,
  `usertime` int(10) unsigned default NULL,
  `userverification` text
) TYPE=MyISAM;

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

-- 
-- Table structure for table `siteconfig`
-- 

CREATE TABLE `siteconfig` (
  `baseurl` text NOT NULL,
  `sitedescription` text NOT NULL,
  `sitekeywords` text NOT NULL,
  `contactemail` text NOT NULL,
  `maxresults` int(11) NOT NULL default '0',
  `maxfrontpage` int(11) NOT NULL default '0',
  `celltitlebackground` text NOT NULL,
  `newestgameslist` int(11) NOT NULL default '0',
  `maxnewestgames` int(11) NOT NULL default '0',
  `mostplayedgameslist` int(11) NOT NULL default '0',
  `maxmostplayedgames` int(11) NOT NULL default '0',
  `linktrading` int(11) NOT NULL default '0',
  `linktradinglist` int(11) NOT NULL default '0',
  `maxlinks` int(11) NOT NULL default '0',
  `tradenotification` int(11) NOT NULL default '0',
  `tradeconfirmation` int(11) NOT NULL default '0',
  `tellafriend` int(11) NOT NULL default '0',
  `emailconfirmation` int(11) NOT NULL default '0',
  `sitetitle` text NOT NULL,
  `pointsforgames` int(11) NOT NULL default '0',
  `pointsforcomments` int(11) NOT NULL default '0',
  `memberlogin` int(11) NOT NULL default '0',
  `comments` int(11) NOT NULL default '0',
  `maxcomments` int(11) NOT NULL default '0',
  `whocancomment` int(11) NOT NULL default '0',
  `adminusername` text NOT NULL,
  `adminpassword` text NOT NULL,
  `topplayers` int(11) NOT NULL default '0',
  `maxtopplayers` int(11) NOT NULL default '0',
  `sorttopplayers` int(11) NOT NULL default '1',
  `bantext` text NOT NULL,
  `rewrite` int(10) unsigned NOT NULL default '0',
  `maxmessages` int(10) unsigned NOT NULL default '25',
  `adminuserid` int(10) unsigned NOT NULL default '0',
  `imageverification` int(11) NOT NULL default '1',
  `maxfilewidth` int(10) unsigned NOT NULL default '0',
  `maxfileheight` int(10) unsigned NOT NULL default '0',
  `guestcredits` int(10) unsigned NOT NULL default '0',
  `limitplays` int(10) unsigned NOT NULL default '0',
  `notes` text NOT NULL,
  `privatemessaging` int(11) NOT NULL default '1'
) TYPE=MyISAM;

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

-- 
-- Table structure for table `userlog`
-- 

CREATE TABLE `userlog` (
  `ipaddress` text NOT NULL,
  `userid` int(11) NOT NULL default '0',
  `gamesplayed` int(11) NOT NULL default '0',
  `usertime` text NOT NULL
) TYPE=MyISAM;

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

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

CREATE TABLE `users` (
  `userid` int(10) unsigned NOT NULL auto_increment,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `avatar` text NOT NULL,
  `location` text NOT NULL,
  `website` text NOT NULL,
  `gamesplayed` int(11) NOT NULL default '0',
  `points` int(11) NOT NULL default '0',
  `gameone` int(11) NOT NULL default '0',
  `gametwo` int(11) NOT NULL default '0',
  `gamethree` int(11) NOT NULL default '0',
  `gamefour` int(11) NOT NULL default '0',
  `gamefive` int(11) NOT NULL default '0',
  `joindate` date NOT NULL default '0000-00-00',
  `emailaddress` text NOT NULL,
  `laston` date default NULL,
  `message` text NOT NULL,
  `userstatus` int(11) NOT NULL default '0',
  `favoritegame` int(11) NOT NULL default '0',
  `playedtoday` int(11) NOT NULL default '0',
  `confirmation` text NOT NULL,
  `newsletter` int(11) NOT NULL default '0',
  `newslettercode` text NOT NULL,
  PRIMARY KEY  (`userid`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `siteconfig`
-- 

INSERT INTO `siteconfig` VALUES ('http://www.phparcadescript.com/', 'Online flash arcade full of your favorite games. Yea Hoo!', 'flash arcade,arcade games', 'support@yourdomain.com', 12, 4, '#FF0000', 1, 5, 1, 5, 1, 1, 5, 0, 0, 1, 0, 'phpArcadeScript', 1, 6, 1, 1, 10, 0, 'admin', '21232f297a57a5a743894a0e4a801fc3', 1, 5, 1, 'Site is down for construction. Please come back later.', 1, 0, 1, 1, 550, 0, 99, 1, 'Welcome to phpArcadeScript v2.0!', 1);
INSERT INTO `advertisers` VALUES (1, 'adsense-support@google.com', 'Google', 'Google Adsense', 'http://www.google.com/adsense/');
INSERT INTO `advertisers` VALUES (2, '', 'Yahoo!', 'Yahoo! Publisher', 'http://publisher.yahoo.com/');
INSERT INTO `advertisers` VALUES (3, '', 'AdBrite', 'AdBrite', 'http://www.adbrite.com/');
INSERT INTO `advertisers` VALUES (4, '', 'AdEngage', 'AdEngage', 'http://www.adengage.com/');